FND payment files
Header Record - record Type 0 - Initial Record - Batch
The record header contains the records that are created once per cash code, pay group, payment code.
Record Type 9| Number | Position | Data type/size | Field | Description | Instructions | Additional Notes |
|---|---|---|---|---|---|---|
| 1 | 1-4 | Alpha/numeric (4) | Material Code | LM02 | Initial Record | |
| 2 | 5-5 | Alpha/numeric (1) | Record Type | 0 | ||
| 3 | 6-6 | Alpha/numeric (1) | Transaction Type | 0 | ||
| 4 | 7-20 | Alpha/numeric (14) | Payer Account number | ElectronicTransferID in PayablesElectronicTransferID | Specifies the payer’s account number in an electronic format with 14 characters | |
| 5 | 21-29 | Numeric (9) | Payer Code | OrganizationIdentifier in PayablesElectronicTransferID | With leading zeros | Contains Company number or other code that has been agreed with the bank. The code can be used as service code, and then leave field 16 blank. The service code identifies the payer and the code’s content is agreed at the end of the contract. A code is required in either field 5 or 16 |
| 6 | 30-35 | Numeric (6) | Date the file was created | System Date | YYMMDD | |
| 7 | 36-39 | Numeric (4) | Time the file was created | HHMM | ||
| 8 | 40-41 | Alpha/numeric (2) | Receipt monetary institution | 1 or 2 and blank characters | If the first position inElectronicTransferID = 1 then move 1 to the field. If the first position = 2 move to the field, otherwise blank. | |
| 9 | 42-47 | Numeric (6) | Due Date | Electronic Payment Creation Payment Date | YYMMDD | Specifies the due date when the payer intended the payments to be paid. If the date is missing or it is more than 5 business days old, the material is treated in the next payment run after receipt date is more than 5 business days old or more than 60 calendar days in the future. Rejected material date is not a business day, payments are paid the next business day. |
| 10 | 48-82 | Alpha/numeric (35) | Payer’s Name identifier | Name in PayablesCompany | The due date for a ilbetainingsmaterial can not be later than the business day after shipment date. Payer’s name identifier in field 10 is documented on the payer’s account statement. It is also documented on the recipient’s account statements, except with invoices that are addressee dot the finance company. Recipient identifier-2 for the payment transaction is transmitted to the finance company. | |
| 11 | 83-117 | Alpha/numeric (35) | Additive Identifier | Spaces | ||
| 12 | 118-134 | Alpha/numeric (17) | EDI Code | Spaces | Not in use | |
| 13 | 135-135 | Alpha/numeric (1) | Credits Unit Code | 1 = EUR | ||
| 14 | 136-223 | Alpha/numeric (88) | Reserved | Spaces | ||
| 15 | 224-224 | Alpha/numeric (1) | Type of Material | 0 | 0=invoice | |
| 16 | 225-234 | Alpha/numeric (10) | Service Code | Spaces | ||
| 17 | 235-298 | Alpha/numeric (64) | Reserved | Spaces | ||
| 18 | 299-299 | Alpha/numeric (1) | Carriage Return | 0D | ||
| 19 | 300-300 | Alpha/numeric (1) | New Line | 0A |
Payee/Payment record - Record Type 1
The payment/Payee records are created for each payment record.
| Number | Position | Data type/size | Field | Description | Instructions | Additional Notes |
|---|---|---|---|---|---|---|
| 1 | 1-4 | Alpha/numeric (4) | Material code | LM02 | ||
| 2 | 5-5 | Numeric (1) | Record Type | 1 | Record Type | |
| 3 | 6-6 | Numeric (1) | Transaction Type | 0 = invoice 2= credit note |
2 = Credit Memo 0= Debit Credit notes may not be included in ilbetainingsmaterial. The transactions in a ilbetainingsmaterial always treated as invoices, regardless of the value of the transaction type. |
In connection with credit notes, the material must also include one or more invoices to the same recipient. The net amount paid to a recipient must be greater than 0 (zero). If the amount is zero, reject both invoices and credit notes. If the amount is less than zero, reject credit notes and only invoices are transmitted to the receiver. |
| 4 | 7-20 | Alpha/numeric (14) | Reserve | Blank | ||
| 5 | 21-50 | Alpha/numeric (30) | Recipient Identifier – 1 | VendorName in Vendor or VendorLocation | Recipients Name | |
| 6 | 51-70 | Alpha/numeric (20) | Recipient Identifier – 2 | Spaces | Name on the vendor invoices and credit notes addressed to the finance company | |
| 7 | 71-90 | Alpha/numeric (20) | Recipient Identifier – 3 | Spaces | The recipient Company ID or social security number. | The description is left justified. The remainder
is left blank. Not communicated to either the recipient or payer |
| 8 | 91-104 | Alpha/numeric (14) | Recipient’s account number | BankAccountNumber from Vendor/VendorLocation Performs check digit validation. If invalid then value = 0 |
The recipient’s account number in an electronic format with 14 characters | |
| 9 | 105-107 | Alpha/numeric (3) | Reserve | Blank | ||
| 10 | 108-108 | Numeric (1) | Type of Message | 1 = reference number 5 = free message, 70 characters |
If the CustomerID in APINVOICE was entered, specify 1 in this field, otherwise 5 | |
| 11 | 109-178 | Alpha/numeric (70) | Message | Move CustomerID in PayablesInvoice if completed,
otherwise InvoiceNbr move APINVOICE comment to the field first.
There can be multiple comments – program only gets the first one. Performs check digit validation. If invalid then value = 0 |
Contents formed according to the type of
message. Tax message can be used only for payments to tax accounts
(taxes on their own initiatives). 1= N20, 50 blanks. Reference number with leading zeros 5 = AN35, AN35, messages |
|
| 12 | 179-180 | Numeric (2) | Reserve | Blank | ||
| 13 | 181-186 | Numeric (6) | Late interest rate due date | Zero | DDMMYYYY | The dues date is specified only when the interest on late payments must be calculated separately. The code in field 15 should then be 2 |
| 14 | 187-198 | Numeric (12) | Amounts | NetPaymentAmount from PayablesInvoicePayment | Amounts in cents | |
| 15 | 199-199 | Numeric (1) | Discount/Late Interest Rate | Zero | 0= no discount or late interest calculated at
the bank on the invoice 1 = discount on the invoice will be deducted according to percentage or amount 2= late payment interest is calculated on the invoice according to percentage or amount |
|
| 16 | 200-203 | Numeric (4) | Discount/Late Interest percent | Zero | The discount or interest on late payments is specified as a percentage | If both percentage and amount are specified, the bank decides the amount of money. |
| 17 | 204-215 | Numeric (12) | Discount /Late interest amount | Zero | The discount or interest on late payments is specified as an amount | If both percentage and amount are specified, the bank decides the amount of money. |
| 18 | 216-235 | Alpha/numeric (20) | Internal Data | Spaces | Reserved for the payer’s own data. The data must be returned to the payer on the account statement by transaction value specifications. The payer decides the content | |
| 19 | 236-255 | Alpha/numeric (20) | Kostandsstalle | Spaces | Reserved for the payer’s own data. The data must be returned to the payer on the account statement by transaction value specifications. The payer decides the content | |
| 20 | 256-298 | Alpha/numeric (43) | Reserve | Blank | ||
| 21 | 299-299 | Alpha/numeric (1) | Carriage Return | 0D | ||
| 22 | 300-300 | Alpha/numeric (1) | New Line | 0A |
Total Record – Record Type 9
The trailer record is created once per Cash Code, Pay Group, Payment Code.
| Number | Position | Data type/size | Field | Description | Instructions | Additional Notes |
|---|---|---|---|---|---|---|
| 1 | 1-4 | Alpha/numeric (4) | Material Code | LM02 | ||
| 2 | 5-5 | Alpha/numeric (1) | Record Type | 0 | Record type | |
| 3 | 6-6 | Alpha/numeric (1) | Transaction Type | 0 | ||
| 4 | 7-20 | Alpha/numeric (14) | Payer Account number | ElectronicTransferID in PayablesElectronicTransferID | Same as in the batch record | |
| 5 | 21-29 | Numeric (9) | Payer Code | OrganizationIdentifier in PayablesElectronicTransferID | ||
| 6 | 30-35 | Numeric (6) | Date the file was created | System Date | YYMMDD | |
| 7 | 36-41 | Numeric (6) | Invoice Number | Total # of db records | The DR/CR number counts (fields 7 and 9) are both the same. They both are the total of debit records and credit records | |
| 8 | 42-54 | Numeric (13) | Invoice Amount | Total NetPaymentAmount (DB) | ||
| 9 | 55-60 | Numeric (6) | Credit Notes, numbers | Total # of CR records | The DR/CR number counts (fields 7 and 9) are both the same. They both are the total of debit records and credit records | |
| 10 | 61-73 | Numeric (13) | Credit Note Amount | Amount in cents Total NetPaymentAmount (CR) |
The amounts are a total of all debit and credit amounts, however both amounts are totaled as whole amounts. So if you have a payment of $100 and a credit memo of -$70 the total will not be $30. It will be $170. | |
| 11 | 74-79 | Numeric (6) | Reserve | Blank | ||
| 12 | 80-114 | Alpha/numeric (35) | Additive Identifier | Spaces | ||
| 13 | 115-131 | Alpha/numeric (17) | EDI Code | Spaces | ||
| 14 | 132-298 | Alpha/numeric (167) | Reserve | Blank | ||
| 15 | 299-299 | Alpha/numeric (1) | Carriage Return | 0D | ||
| 16 | 300-300 | Alpha/numeric (1) | New Line | 0A |