Vendors can find a link to a CTX 820 (Corporate Trade Exchange) file at the bottom of Remittance Advice emails. The CTX 820 is an industry-standard flat file layout that contains all of the remittance data from an invoice. The CTX 820 file allows vendors to import the data back to their financial system, eliminating the need for manual entry. A maximum of 9,999 records is allowed.
General Notes
- All character fields are left-justified.
- All numeric fields are zero-filled anytime they are used; numeric fields are decimal implied.
- A carriage return/line feed is used at the end of each record.
- Any values longer than the maximum row length will be truncated to fit.
Layout Summary
| Record Types | Comment |
|---|---|
| DHDR | Header Record |
| A | Payment Record |
| RM | Remittance Record |
| DEOR | Trailer Record |
File Naming Convention
The name used for each CTX 820 file: Remit.Records.CTX820.TXT
Delivery Method
This file will be delivered as an attachment to the Remittance Advice email.
Header
The header record (DHDR) summarizes the payee (vendor) information.
Header – CTX 820 Remittance Record File
| Field No | Length | Type | Field Position | Description | Notes |
|---|---|---|---|---|---|
| 1 | 4 | A/N* | 1-4 | Record ID | ‘DHDR” |
| 2 | 36 | A/N | 5-40 | Blank | |
| 3 | 20 | A/N | 41-60 | Vendor Name | |
| 4 | 12 | A/N | 61-72 | Vendor Telephone Number | |
| 5 | 17 | A/N | 73-89 | Blank | |
| 6 | 8 | A/N | 90-97 | Remittance Create Date | YYYYMMDD |
| 7 | 63 | A/N | 98-160 | Blank |
*A/N = ALPHANUMERIC
Payment
The Payment record (A) summarizes the remittance record, provides payee (vendor) name, card number, and total amount.
Payment – CTX 820 Remittance Record File
| Field No | Length | Type | Field Position | Description | Notes |
|---|---|---|---|---|---|
| 1 | 1 | A/N* | 1-1 | Record ID | ‘A’ |
| 2 | 9 | A/N | 2-10 | Blank | |
| 3 | 10 | N* | 11-20 | Must match NET_AMT from all Remittance Records | ‘V’ |
| 4 | 1 | A/N | 21-21 | Line Code | |
| 5 | 8 | A/N | 22-29 | Location Code (Optional) | |
| 6 | 23 | A/N | 30-52 | Payee Name | Blank |
| 7 | 1 | A/N | 53-53 | Account Type | |
| 8 | 8 | A/N | 54-61 | Blank | |
| 9 | 17 | A/N | 62-78 | Card Number or Account Number | |
| 10 | 82 | A/N | 79-160 | Invoice Comments |
*A/N = ALPHANUMERIC *N = NUMERIC
Remittance
The Remittance record (RM) summarizes the invoice detail.
Remittance – CTX 820 Remittance Record File
| Field No | Length | Type | Field Position | Description | Notes |
|---|---|---|---|---|---|
| 1 | 3 | A/N* | 1-3 | Record ID | ‘RM’ |
| 2 | 2 | A/N | 4-5 | Document Reference Type | ‘IV’ |
| 3 | 30 | N* | 6-35 | INVOICE_NBR | ‘V’ |
| 4 | 10 | N | 36-45 | NET_AMT | No Decimal |
| 5 | 10 | N | 46-55 | GROSS_AMT (optional) | No Decimal |
| 6 | 10 | N | 56-65 | DISC_AMT (optional) | No Decimal |
| 7 | 95 | A/N | 66-160 | Blank |
*A/N = ALPHANUMERIC *N = NUMERIC
Trailer
The Trailer record (DEOR) summarizes the total records in the Remittance Record file.
Trailer – CTX 820 Remittance Record File
| Field No | Length | Type | Field Position | Description | Notes |
|---|---|---|---|---|---|
| 1 | 4 | A/N* | 1-4 | Record ID | ‘DEOR’ |
| 2 | 6 | A/N | 5-10 | Blank | |
| 3 | 10 | N* | 11-20 | Total number of ‘A’ Payment Records | No Decimal |
| 4 | 10 | A/N | 21-30 | Blank | |
| 5 | 12 | N | 31-42 | Total Dollar Amount in field 3 of ‘A’ Payment Records | No Decimal |
| 6 | 118 | A/N | 43-160 | Blank |
*A/N = ALPHANUMERIC *N = NUMERIC