CSV file

The CSV file contains a header, detail, and remittance file.

Header file

Field Data type and size
Total Record Count Numeric (5)
Total Amount Numeric (19.3)
File creation date and time Date (16)
Requisition Type Alphanumeric (2)

Detail file

Field Data type and size
Cash Code Alphanumeric (20)
Routing Number Alphanumeric (35)
Cash Management Account Numeric (35)
Bank Account Currency Alphanumeric (5)
Bank Client Identifier Alphanumeric (50)
Transaction Identifier Alphanumeric (10)
Transaction Number Alphanumeric (22)
General Ledger Source Code Alphanumeric (15)
Bank Transaction Code Alphanumeric (10)
Effective Date Date (8)
Payment Date Date (8)
Payment Amount Numeric (19.3)
Pay Bank Currency Alphanumeric (5)
Pay Bank Amount Numeric (19.3)
Approval Cost Center Alphanumeric (25)
Paid Name Alphanumeric (120)
Mailing Name Alphanumeric (120)
Payee Postal Address-Line 1 Alphanumeric (40)
Payee Postal Address-Line 2 Alphanumeric (40)
Payee Postal Address-Line 3 Alphanumeric (40)
Payee Postal Address-Line 4 Alphanumeric (40)
Payee Postal Address-City Alphanumeric (58)
Payee Postal Address-State/Province Alphanumeric (3)
Payee Postal Address-Postal Code Alphanumeric (12)
Payee Postal Address-Country Alphanumeric (3)
Pay Bank Account Number Alphanumeric (35)
Electronic Payment Code Alphanumeric (3)
First Party Reference Alphanumeric (12)
Second Party Reference Alphanumeric (12)
Pay Bank Name Alphanumeric (70)
Pay Bank Postal Address-Line 1 Alphanumeric (40)
Pay Bank Postal Address-Line 2 Alphanumeric (40)
Pay Bank Postal Address-Line 3 Alphanumeric (40)
Pay Bank Postal Address-Line 4 Alphanumeric (40)
Pay Bank Postal Address-City Alphanumeric (58)
Pay Bank Postal Address-State/Province Alphanumeric (3)
Pay Bank Postal Address-Postal Code Alphanumeric (12)
Pay Bank Postal Address-Country Alphanumeric (3)
Cross Border Identifier Alphanumeric (1)
Pay Bank Entity Alphanumeric (35)
Swift-ID Alphanumeric (12)
IBAN Alphanumeric (34)
Charge Code Alphanumeric (1)
Bank to Bank Information Alphanumeric (140)
Intermediary Bank-Name Alphanumeric (70)
Intermediary Bank Address-Line 1 Alphanumeric (40)
Intermediary Bank Address-Line 2 Alphanumeric (40)
Intermediary Bank Address-Line 3 Alphanumeric (40)
Intermediary Bank Address-Line 4 Alphanumeric (40)
Intermediary Bank Address-City Alphanumeric (58)
Intermediary Bank Address- State/Province Alphanumeric (3)
Intermediary Bank Address- Postal Code Alphanumeric (12)
Intermediary Bank Address-Country Alphanumeric (3)
Intermediary Cross Border Identifier Alphanumeric (1)
Intermediary Bank Entity Alphanumeric (35)
Intermediary Swift-ID Alphanumeric (12)
Language Code Alphanumeric (10)
Normal Or Express Code Alphanumeric (1)
Paid Vendor Numeric (9)
Invoice Alphanumeric (22)
Unformatted Comment Alphanumeric Text
TransactionData1 Alphanumeric (30)
TransactionData2 Alphanumeric (30)
TransactionData3 Alphanumeric (30)
TransactionData4 Alphanumeric (30)
Invoice Vendor Alphanumeric (9)
Invoice Vendor Name Alphanumeric (120)
Invoice Vendor Email Address Alphanumeric
Payor Name Alphanumeric (80)
Payor Postal Address-Line 1 Alphanumeric (40)
Payor Postal Address-Line 2 Alphanumeric (40)
Payor Postal Address-Line 3 Alphanumeric (40)
Payor Postal Address-Line 4 Alphanumeric (40)
Payor Postal Address-City Alphanumeric (58)
Payor Postal Address-State/Province Alphanumeric (3)
Payor Postal Address-Postal Code Alphanumeric (12)
Payor Postal Address-Country Alphanumeric (3)
Pay Bank Account Type Alphanumeric (2)
Pay Bank Type Description Alphanumeric (60)
Vendor Group Alphanumeric (5)
VAT Split Amount Numeric (19.3)
Vendor Bank Code 1 Alphanumeric (50)
Vendor Bank Code 2 Alphanumeric (50)
Vendor Bank Code 3 Alphanumeric (50)
Vendor Bank Code 4 Alphanumeric (50)
Vendor Bank Code 5 Alphanumeric (50)
Vendor Bank Code 6 Alphanumeric (50)
Vendor Bank Code 7 Alphanumeric (50)
Vendor Bank Code 8 Alphanumeric (50)
Vendor Bank Code 9 Alphanumeric (50)
Vendor Bank Code 10 Alphanumeric (50)
Vendor Bank Code 11 Alphanumeric (50)
Vendor Bank Code 12 Alphanumeric (50)
Vendor Bank Code 13 Alphanumeric (50)
Vendor Bank Code 14 Alphanumeric (50)
Vendor Bank Code 15 Alphanumeric (50)
Vendor Bank Code 16 Alphanumeric (50)
Vendor Bank Code 17 Alphanumeric (50)
Vendor Bank Code 18 Alphanumeric (50)
Vendor Bank Code 19 Alphanumeric (50)
Vendor Bank Code 20 Alphanumeric (50)
Email Address
Mobile Number
PayGlobalBankAccountType Alphanumeric (20)

Remittance file

Field Data type and size
Bank Client Identifier Alphanumeric (50)
Transaction Identifier Numeric (10)
Transaction Number Alphanumeric (10)
Paid Vendor Numeric (9)
Invoice Alphanumeric (22)
Invoice Suffix Numeric (3)
Invoice Date Date (8)
Payables Company Numeric (4)
Payables Company Name Alphanumeric (80)
Net Payment Amount Numeric (19.3)
Payment Amount Numeric (19.3)
Discount Amount Numeric (19.3)
Invoice Currency Alphanumeric (5)
Purchase Order Numeric (9)
Voucher Number Alphanumeric (15)
Process Level Alphanumeric (5)
Reason Code Alphanumeric (4)
Reason Code Description Alphanumeric (60)
Invoice Description Alphanumeric (60)
Invoice Comments Alphanumeric
TransactionData1 Alphanumeric (30)
TransactionData2 Alphanumeric (30)
TransactionData3 Alphanumeric (30)
TransactionData4 Alphanumeric (30)
Invoice Vendor Numeric (9)
Invoice Vendor Name Alphanumeric (120)
Invoice Vendor Email Address Alphanumeric
VAT Split Amount Numeric (19.3)