Formatting Remittance Layouts

Receivables provides a predefined program to format remittances. However, you may customize the formats, both for paper and tape, to suit your specific needs. Use the AR_REMITTED_RECEIPTS_FORMAT_V view to customize the formats. This view contains information relating to the receipt, customer, customer bank, remittance bank, and the remittance batch.

The layout on magnetic media is described below. The layout provided includes Header records, Detail Records, and Tail Records. All records are of a fixed size of 160 bytes.

Header Records

There is one header record for each remittance mode, payment type, remittance bank, due date, and currency. The layout of a header record is described in this table:

Column Numbers Contents
1 - 2 Record code: 03 for Header
3 - 4 Operation Code
5 -12 Always filled by zeros
13 - 18 Sales tax registration number
19 - 24 Blank
25 - 30 Remittance Date
31 - 54 Company name
55 - 78 Remittance bank address and name
79 - 79 Blank
80 - 81 Blank
82 - 86 Remittance bank account number
87 - 91 Remittance bank account number
92 - 102 Remittance bank account number
103 - 149 Blank
150 - 160 Remittance Batch name

Detail Records

There is one detail record per automatic receipt. The layout of a detail record is described in this table:

Column Numbers Contents
1 - 2 Record code: 06 for Detail
3 - 4 Operation Code
5 - 12 Always filled by zeros
13 - 20 Blank
21 - 30 Receipt Number
31 - 54 Customer name
55 - 78 Customer bank name
79 - 81 Blank
82 - 86 Customer bank account number
87 - 91 Customer bank account number
92 - 102 Customer bank account number
103 - 114 Payment amount
115 - 118 Blank
119 - 124 Due Date
125 - 130 Creation Date
131 - 150 Blank
151 - 160 Receipt Number

Tail Records

There is one tail record for each remittance mode, payment type, remittance bank, due date, and currency. The layout of a tail record is described in this table:

Column Numbers Contents
1 - 2 Record code: 08 for Tail
3 - 4 Operation Code
5 -12 Always filled by zeros
13 - 102 Blank
103 - 115 Total Amount
116 - 160 Blank

Related Topics