Previous  Next          Contents  Index  Navigation  Glossary  Library

Outbound Payment Order / Remittance Advice Data File Organization

The data file produced by this transaction consists of two levels of data: payment and invoices.

Each payment will contain one or many invoices associated with that payment.

The output file is structured as follows:

Summary Tables

The following tables provide a summary description of the data file:

Record Occurrences within the Transaction

Records Content Occurrences
0010-0070 EDI Gateway Control Records Only one record
1000-1050 Payment Header Records Only one record occurrence per transaction
2000-2040 Remittance/Invoice Records One set of records per invoice within the Payment Header
Table 1 - 56. (Page 1 of 1)

Record Summary

Sequence Type of Data Data Level Record Number Misc. Info.
1 Control Record CONTROL 0010  
2 Trading Partner Header Attributes TRADING PARTNER 0020 Flexfields
3 Trading Partner Header Attributes TRADING PARTNER 0030-0050 Flexfields
6 Account Data PAYMENT 1000  
7 Payment Data PAYMENT 1010  
8 Supplier Flex Field Segments PAYMENT 1020  
9 Bank Address / Code PAYMENT 1030  
10 Bank Contacts PAYMENT 1040  
11 Supplier Site Address / Code PAYMENT 1050  
12 Extension Tables: Payment Data PAYMENT 1900  
13 Remittance / Invoice Details INVOICE / REMITTANCE 2000  
14 Remittance Advice Flexfields 1-4 INVOICE / REMITTANCE 2010 Flexfields
15 Remittance Advice Flexfields 5-9 INVOICE / REMITTANCE 2020 Flexfields
16 Remittance Advice Flexfields 10-14 INVOICE / REMITTANCE 2030 Flexfields
17 Remittance Advice Flexfields 15 INVOICE / REMITTANCE 2040 Flexfields
Table 1 - 57. (Page 2 of 2)

Transaction-specific Data in the Common Key Positions 1-100

Position Code Content
1-25 TP_CD Trading partner code as defined in the EDI translator
26-47 BATCH Payment batch number
48-69 INVOICE Invoice number
70-91 (blank) Not used
92-95 (varies) Record number
96-97 (varies) Record layout
98-100 (varies) Record layout qualifier
Table 1 - 58. (Page 2 of 2)

Transaction-specific Data in the Common Key Positions 1-100 Per Record

Seq. Record TP_CD Reference 1 Reference 2 Reference 3 Record Number Record Layout Record Quallifier
  Length 25 22 22 22 4 2 3
  Position 1-25 26-47 48-69 70-91 92-95 96-97 98-100
1 Control record TP_CD       0010 CT CTL
2 Trading partner header attributes TP_CD       0020 A1 TH1
3 Trading partner header attributes TP_CD       0030-0050 A2 TH2-TH4
6 Account data TP_CD BATCH     1000 BK BK1
7 Payment data TP_CD BATCH     1010 PY PAY
8 Supplier flexfield segments TP_CD BATCH     1020 VN VN1
9 Bank address / code TP_CD BATCH     1030 AD BK1
10 Bank contacts TP_CD BATCH     1040 CN BK1
11 Supplier site address / code TP_CD BATCH     1050 AD VS1
12 Extension tables: payment data TP_CD BATCH     1900 EX (custom)
13 Remittance / invoice details TP_CD BATCH INVOICE   2000 IV INV
14 Remittance advice flexfields 1-4 TP_CD BATCH INVOICE   2010 A1 RE1
15 Remittance advice flexfields 5-9 TP_CD BATCH INVOICE   2020 A2 RE2
16 Remittance advice flexfields 10-14 TP_CD BATCH INVOICE   2030 A2 RE3
17 Remittance advice flexfields 15 TP_CD BATCH INVOICE   2040 A2 RE4
Table 1 - 59. (Page 2 of 2)

See Also

Outbound Payment Order / Remittance Advice Data File Definition

         Previous  Next          Contents  Index  Navigation  Glossary  Library