|
|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Navigation | Glossary | Library |
See: Data File Definition Format Legend for a description of the columns making up the data file definition table.
Field Description Category Rec Format Pos Width Start Rec Qual. Application Table Application Column RECORD 0010 (PYO) Common Key (Positions 1-91) 0010 Varchar2 91 1 Record Number 0010 Varchar2 4 92 Constant '0010' Record Layout 0010 Varchar2 2 96 Constant 'CT' Record Layout Qualifier 0010 Varchar2 3 98 Constant 'CTL' Communication Method 0010 Varchar2 10 2 101 CT CTL Bank Branch Test Indicator 0010 Varchar2 20 1 103 CT CTL ECE_TP_DETAILS TEST_FLAG Document ID 0010 Varchar2 30 6 104 CT CTL Document Type 0010 Varchar2 40 5 110 CT CTL Document Purpose Code 0010 Varchar2 50 2 115 CT CTL Document Code 0010 Varchar2 60 35 117 CT CTL AP_SELECTED_INVOICE_CHECKSCHECK_NUMBER Bank Branch Trading Partner Translator Code 0010 Varchar2 70 30 152 CT CTL ECE_TP_DETAILS TRANSLATOR_CODE Bank Branch Trading Partner Location Code 0010 Varchar2 80 35 182 CT CTL ECE_TP_HEADERS TP_LOCATION_CODE_EXT Bank Branch Trading Partner Description 0010 Varchar2 90 74 217 CT CTL ECE_TP_HEADERS TP_DESCRIPTION Bank Branch Trading Partner Reference 1 0010 Varchar2 100 80 291 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT1 Bank Branch Trading Partner Reference 2 0010 Varchar2 110 80 371 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT2 Transaction Date/Time 0010 Date 120 15 451 CT CTL Transaction Run ID 0010 Number 130 15 466 CT CTL Control 1 0010 Number 140 10 481 CT CTL Control 2 0010 Number 150 10 491 CT CTL Control 3 0010 Number 160 10 501 CT CTL RECORD 0020 (PYO) Common Key (Positions 1-91) 0020 Varchar2 91 1 Record Number 0020 Varchar2 4 92 Constant '0020' Record Layout 0020 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 0020 Varchar2 3 98 Constant 'TH1' Trading Partner Flexfield Context 0020 Varchar2 10 30 101 A1 TH1 ECE_TP_HEADERS ATTRIBUTE_CATEGORY Trading Partner Flexfield 1 0020 Varchar2 20 80 131 A1 TH1 ECE_TP_HEADERS ATTRIBUTE1 Trading Partner Flexfield 2 0020 Varchar2 30 80 211 A1 TH1 ECE_TP_HEADERS ATTRIBUTE2 Trading Partner Flexfield 3 0020 Varchar2 40 80 291 A1 TH1 ECE_TP_HEADERS ATTRIBUTE3 Trading Partner Flexfield 4 0020 Varchar2 50 80 371 A1 TH1 ECE_TP_HEADERS ATTRIBUTE4 RECORD 0030 (PYO) Common Key (Positions 1-91) 0030 Varchar2 91 1 Record Number 0030 Varchar2 4 92 Constant '0030' Record Layout 0030 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 0030 Varchar2 3 98 Constant 'TH2' Trading Partner Flexfield 5 0030 Varchar2 10 80 101 A2 TH2 ECE_TP_HEADERS ATTRIBUTE5 Trading Partner Flexfield 6 0030 Varchar2 20 80 181 A2 TH2 ECE_TP_HEADERS ATTRIBUTE6 Trading Partner Flexfield 7 0030 Varchar2 30 80 261 A2 TH2 ECE_TP_HEADERS ATTRIBUTE7 Trading Partner Flexfield 8 0030 Varchar2 40 80 341 A2 TH2 ECE_TP_HEADERS ATTRIBUTE8 Trading Partner Flexfield 9 0030 Varchar2 50 80 421 A2 TH2 ECE_TP_HEADERS ATTRIBUTE9 RECORD 0040 (PYO) Common Key (Positions 1-91) 0040 Varchar2 91 1 Record Number 0040 Varchar2 4 92 Constant '0040' Record Layout 0040 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 0040 Varchar2 3 98 Constant 'TH3' Trading Partner Flexfield 10 0040 Varchar2 10 80 101 A2 TH3 ECE_TP_HEADERS ATTRIBUTE10 Trading Partner Flexfield 11 0040 Varchar2 20 80 181 A2 TH3 ECE_TP_HEADERS ATTRIBUTE11 Trading Partner Flexfield 12 0040 Varchar2 30 80 261 A2 TH3 ECE_TP_HEADERS ATTRIBUTE12 Trading Partner Flexfield 13 0040 Varchar2 40 80 341 A2 TH3 ECE_TP_HEADERS ATTRIBUTE13 Trading Partner Flexfield 14 0040 Varchar2 50 80 421 A2 TH3 ECE_TP_HEADERS ATTRIBUTE14 RECORD 0050 (PYO) Common Key (Positions 1-91) 0050 Varchar2 91 1 Record Number 0050 Varchar2 4 92 Constant '0050' Record Layout 0050 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 0050 Varchar2 3 98 Constant 'TH4' Trading Partner Flexfield 15 0050 Varchar2 10 80 101 A2 TH4 ECE_TP_HEADERS ATTRIBUTE15 RECORD 1000 (PYO) Common Key (Positions 1-91) 1000 Varchar2 91 1 Record Number 1000 Varchar2 4 92 Constant '1000' Record Layout 1000 Varchar2 2 96 Constant 'BK' Record Layout Qualifier 1000 Varchar2 3 98 Constant 'BK1' EDI Transaction Handling Code TRX_HANDL 1000 Varchar2 10 25 101 BK BK1 PO_VENDOR_SITES EDI_TRANSACTION_HANDLING EDI Transaction Handling Code (Ext) 1000 Varchar2 20 3 126 BK BK1 ECE_XREF_DATA XREF_EXT_VALUE1 Amount in this Payment Batch 1000 Number 30 22 129 BK BK1 AP_SELECTED_INVOICE_CHECKSCHECK_AMOUNT Currency Code (internal) CURRENCY 1000 Varchar2 40 15 151 BK BK1 AP_SELECTED_INVOICE_CHECKSCURRENCY_CODE Currency Code (Ext 1) 1000 Varchar2 50 3 166 BK BK1 ECE_XREF_DATA XREF_EXT_VALUE1 EDI Payment Method (Internal) PAY_METH 1000 Varchar2 60 25 169 BK BK1 PO_VENDOR_SITES EDI_PAYMENT_METHOD EDI Payment Method (Ext 1) 1000 Varchar2 70 3 194 BK BK1 ECE_XREF_DATA XREF_EXT_VALUE1 EDI Payment Format for ACH PAY_FMT 1000 Varchar2 80 25 197 BK BK1 PO_VENDOR_SITES EDI_PAYMENT_FORMAT EDI Payment Format for ACH (Ext) 1000 Varchar2 90 10 222 BK BK1 ECE_XREF_DATA XREF_EXT_VALUE1 Bank Branch Type (Internal) BANK_BRCH_TYPE 1000 Varchar2 100 25 232 BK BK1 AP_BANK_BRANCHES BANK_BRANCH_TYPE Bank Branch Type (Ext 1) 1000 Varchar2 110 10 257 BK BK1 ECE_XREF_DATA XREF_EXT_VALUE1 Bank Account Type (Internal) BANK_ACCT_TYPE 1000 Varchar2 120 25 267 BK BK1 AP_BANK_ACCOUNTS ACCOUNT_TYPE Bank Account Type (Ext 1) 1000 Varchar2 130 10 292 BK BK1 ECE_XREF_DATA XREF_EXT_VALUE1 Bank Account Number 1000 Varchar2 140 30 302 BK BK1 AP_BANK_ACCOUNTS BANK_ACCOUNT_NUM BankĘs Trading Partner ID 1000 Varchar2 150 30 332 BK BK1 AP_BANK_BRANCHES EDI_ID_NUMBER Vendor Bank Branch Type (Internal) VENDOR_BANK_BRCH_TYPE 1000 Varchar2 160 25 362 BK BK1 PO_VENDOR_SITES BANK_BRANCH_TYPE Vendor Bank Branch Type(Ext1) 1000 Varchar2 170 10 387 BK BK1 ECE_XREF_DATA XREF_EXT_VALUE1 Vendor Bank Account Type (Internal) VENDOR_BANK_ACCT_TYPE 1000 Varchar2 180 25 397 BK BK1 AP_SELECTED_INVOICE_CHECKSBANK_ACCOUNT_TYPE Vendor Bank Account Type(Ext1) 1000 Varchar2 190 10 422 BK BK1 ECE_XREF_DATA XREF_EXT_VALUE1 Vendor Bank Account Num 1000 Varchar2 200 30 432 BK BK1 AP_SELECTED_INVOICE_CHECKSBANK_ACCOUNT_NUM Date Funds Available for Transfer 1000 Date 210 15 462 BK BK1 AP_SELECTED_INVOICE_CHECKSPAYMENT_DATE RECORD 1010 (PYO) Common Key (Positions 1-91) 1010 Varchar2 91 1 Record Number 1010 Varchar2 4 92 Constant '1010' Record Layout 1010 Varchar2 2 96 Constant 'PY' Record Layout Qualifier 1010 Varchar2 3 98 Constant 'PAY' Bank Transit Routing Number 1010 Varchar2 10 25 101 PY PAY AP_BANK_BRANCHES BANK_NUM Vendor Bank Transit Routing Number 1010 Varchar2 20 25 126 PY PAY AP_SELECTED_INVOICE_CHECKSBANK_NUM EDI Remittance Method 1010 Varchar2 30 25 151 PY PAY PO_VENDOR_SITES EDI_REMITTANCE_METHOD EDI Remittance Instruction 1010 Varchar2 40 80 176 PY PAY PO_VENDOR_SITES EDI_REMITTANCE_INSTRUCTION Payment Batch Name 1010 Varchar2 50 30 256 PY PAY AP_SELECTED_INVOICE_CHECKSCHECKRUN_NAME Voucher Number of Payment 1010 Number 60 22 286 PY PAY AP_SELECTED_INVOICE_CHECKSCHECK_VOUCHER_NUM Selected Check ID 1010 Varchar2 70 15 308 PY PAY AP_SELECTED_INVOICE_CHECKSSELECTED_CHECK_ID Payment Number 1010 Number 80 22 323 PY PAY AP_SELECTED_INVOICE_CHECKSCHECK_NUMBER Customer Number (Supplier Defined) 1010 Varchar2 90 25 345 PY PAY AP_SELECTED_INVOICE_CHECKSCUSTOMER_NUM (Custom) 1010 Varchar2 100 1 370 PY PAY (Custom) 1010 Date 110 15 371 PY PAY RECORD 1020 (PYO) Common Key (Positions 1-91) 1020 Varchar2 91 1 Record Number 1020 Varchar2 4 92 Constant '1020' Record Layout 1020 Varchar2 2 96 Constant 'VN' Record Layout Qualifier 1020 Varchar2 3 98 Constant 'VN1' Vendor Number (Internal) VENDOR_NUMBER 1020 Varchar2 10 30 101 VN VN1 PO_VENDORS SEGMENT1 Vendor Number (Ext 1) 1020 Varchar2 20 30 131 VN VN1 ECE_XREF_DATA XREF_EXT_VALUE1 Vendor's Trading Partner ID 1020 Varchar2 30 30 161 VN VN1 PO_VENDOR_SITES EDI_ID_NUMBER Vendor Key Flexfield Segment 1020 Varchar2 40 30 191 VN VN1 PO_VENDORS SEGMENT2 Vendor Key Flexfield Segment 1020 Varchar2 50 30 221 VN VN1 PO_VENDORS SEGMENT3 Vendor Key Flexfield Segment 1020 Varchar2 60 30 251 VN VN1 PO_VENDORS SEGMENT4 Vendor Key Flexfield Segment 1020 Varchar2 70 30 281 VN VN1 PO_VENDORS SEGMENT5 RECORD 1030 (PYO) Common Key (Positions 1-91) 1030 Varchar2 91 1 Record Number 1030 Varchar2 4 92 Constant '1030' Record Layout 1030 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1030 Varchar2 3 98 Constant 'BKĘ Bank Branch Entity Site Code (Internal) LOC_BANK_BRCH_SITE 1030 Varchar2 10 20 101 AD BK1 AP_BANK_BRANCHES BANK_BRANCH_ID Bank Branch Entity Site Code (Ext 1) 1030 Varchar2 20 20 121 AD BK1 Bank Branch Name 1030 Varchar2 30 60 141 AD BK1 Bank Branch Address Line 1 1030 Varchar2 40 35 201 AD BK1 AP_BANK_BRANCHES ADDRESS_LINE1 Bank Branch Address Line 2 1030 Varchar2 50 35 236 AD BK1 AP_BANK_BRANCHES ADDRESS_LINE2 Bank Branch Address Line 3 1030 Varchar2 60 35 271 AD BK1 AP_BANK_BRANCHES ADDRESS_LINE3 Bank Branch Address Line 4 1030 Varchar2 70 35 306 AD BK1 Bank Branch City 1030 Varchar2 80 30 341 AD BK1 AP_BANK_BRANCHES CITY Bank Branch Zip 1030 Varchar2 90 15 371 AD BK1 AP_BANK_BRANCHES ZIP Bank Branch Country (Internal) COUNTRY 1030 Varchar2 100 20 386 AD BK1 AP_BANK_BRANCHES COUNTRY Bank Branch Country (Ext 1) 1030 Varchar2 110 3 406 AD BK1 Bank Branch State (Internal) STATE 1030 Varchar2 120 20 409 AD BK1 AP_BANK_BRANCHES STATE Bank Branch State (Ext 1) 1030 Varchar2 130 10 429 AD BK1 Bank Branch Province (Internal) PROVINCE 1030 Varchar2 140 20 439 AD BK1 AP_BANK_BRANCHES PROVINCE Bank Branch Province (Ext 1) 1030 Varchar2 150 10 459 AD BK1 RECORD 1040 (PYO) Common Key (Positions 1-91) 1040 Varchar2 91 1 Record Number 1040 Varchar2 4 92 Constant '1040' Record Layout 1040 Varchar2 2 96 Constant 'CN' Record Layout Qualifier 1040 Varchar2 3 98 Constant 'BK1' Bank Contact First Name 1040 Varchar2 10 15 101 CN BK1 AP_BANK_BRANCHES CONTACT_FIRST_NAME Bank Contact Middle Name 1040 Varchar2 20 15 116 CN BK1 AP_BANK_BRANCHES CONTACT_MIDDLE_NAME Bank Contact Last Name 1040 Varchar2 30 20 131 CN BK1 AP_BANK_BRANCHES CONTACT_LAST_NAME Bank Contact Title 1040 Varchar2 40 30 151 CN BK1 AP_BANK_BRANCHES CONTACT_TITLE Bank Contact Prefix 1040 Varchar2 50 5 181 CN BK1 AP_BANK_BRANCHES CONTACT_PREFIX Bank Contact Area Code 1040 Varchar2 60 10 186 CN BK1 AP_BANK_BRANCHES AREA_CODE Bank Contact Phone Number 1040 Varchar2 70 15 196 CN BK1 AP_BANK_BRANCHES PHONE RECORD 1050 (PYO) Common Key (Positions 1-91) 1050 Varchar2 91 1 Record Number 1050 Varchar2 4 92 Constant '1050' Record Layout 1050 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1050 Varchar2 3 98 Constant 'VS1' Vendor Site Code (Internal) LOC_VENDOR_SITE 1050 Varchar2 10 20 101 AD VS1 AP_SELECTED_INVOICE_CHECKSVENDOR_SITE_CODE Vendor Site Code (Ext 1) 1050 Varchar2 20 20 121 AD VS1 ECE_XREF_DATA XREF_EXT_VALUE1 Vendor Name 1050 Varchar2 30 60 141 AD VS1 AP_SELECTED_INVOICE_CHECKSVENDOR_NAME Vendor Site Address Line 1 1050 Varchar2 40 35 201 AD VS1 AP_SELECTED_INVOICE_CHECKSADDRESS_LINE1 Vendor Site Address Line 2 1050 Varchar2 50 35 236 AD VS1 AP_SELECTED_INVOICE_CHECKSADDRESS_LINE2 Vendor Site Address Line 3 1050 Varchar2 60 35 271 AD VS1 AP_SELECTED_INVOICE_CHECKSADDRESS_LINE3 Vendor Site Address Line 4 1050 Varchar2 70 35 306 AD VS1 Vendor Site City 1050 Varchar2 80 30 341 AD VS1 AP_SELECTED_INVOICE_CHECKSCITY Vendor Site Zip Code 1050 Varchar2 90 15 371 AD VS1 AP_SELECTED_INVOICE_CHECKSZIP Vendor Site Country (Internal) COUNTRY 1050 Varchar2 100 20 386 AD VS1 AP_SELECTED_INVOICE_CHECKSCOUNTRY Vendor Site Country (Ext 1) 1050 Varchar2 110 3 406 AD VS1 Vendor Site State (Internal) STATE 1050 Varchar2 120 20 409 AD VS1 AP_SELECTED_INVOICE_CHECKSSTATE Vendor Site State (Ext 1) 1050 Varchar2 130 10 429 AD VS1 Vendor Site Province (Internal) PROVINCE 1050 Varchar2 140 20 439 AD VS1 AP_SELECTED_INVOICE_CHECKSPROVINCE Vendor Site Province (Ext 1) 1050 Varchar2 150 10 459 AD VS1 RECORD 2000 (PYO) Common Key (Positions 1-91) 2000 Varchar2 91 1 Record Number 2000 Varchar2 4 92 Constant '2000' Record Layout 2000 Varchar2 2 96 Constant 'IV' Record Layout Qualifier 2000 Varchar2 3 98 Constant 'INV' Payment Batch Name 2000 Varchar2 10 30 101 IV INV AP_SELECTED_INVOICES CHECKRUN_NAME Supplier Number (Internal) SUPPLIER_NUMBER 2000 Varchar2 30 30 131 IV INV AP_SELECTED_INVOICES VENDOR_NUM Supplier Number (Ext 1) 2000 Varchar2 40 20 161 IV INV ECE_XREF_DATA XREF_EXT_VALUE1 Customer Number (Supplier Defined) 2000 Varchar2 50 25 181 IV INV AP_SELECTED_INVOICES CUSTOMER_NUM Invoice Number 2000 Varchar2 60 50 206 IV INV AP_SELECTED_INVOICES INVOICE_NUM Invoice Date 2000 Date 70 15 256 IV INV AP_SELECTED_INVOICES INVOICE_DATE Invoice Description 2000 Varchar2 80 50 271 IV INV AP_SELECTED_INVOICES INVOICE_DESCRIPTION Payment Amount 2000 Number 90 22 321 IV INV AP_SELECTED_INVOICES PROPOSED_PAYMENT_AMOUNT Invoice Amount 2000 Number 100 22 343 IV INV AP_SELECTED_INVOICES INVOICE_AMOUNT Discount Amount 2000 Number 110 22 365 IV INV AP_SELECTED_INVOICES DISCOUNT_AMOUNT RECORD 2010 (PYO) Common Key (Positions 1-91) 2010 Varchar2 91 1 Record Number 2010 Varchar2 4 92 Constant '2010' Record Layout 2010 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 2010 Varchar2 3 98 Constant 'RE1' Remittance Advice Flexfield Context 2010 Varchar2 10 30 101 A1 RE1 AP_SELECTED_INVOICES ATTRIBUTE_CATEGORY Remittance Advice Flexfield 1 2010 Varchar2 20 80 131 A1 RE1 AP_SELECTED_INVOICES ATTRIBUTE1 Remittance Advice Flexfield 2 2010 Varchar2 30 80 211 A1 RE1 AP_SELECTED_INVOICES ATTRIBUTE2 Remittance Advice Flexfield 3 2010 Varchar2 40 80 291 A1 RE1 AP_SELECTED_INVOICES ATTRIBUTE3 Remittance Advice Flexfield 4 2010 Varchar2 50 80 371 A1 RE1 AP_SELECTED_INVOICES ATTRIBUTE4 RECORD 2020 (PYO) Common Key (Positions 1-91) 2020 Varchar2 91 1 Record Number 2020 Varchar2 4 92 Constant '2020' Record Layout 2020 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2020 Varchar2 3 98 Constant 'RE2' Remittance Advice Flexfield 5 2020 Varchar2 10 80 101 A1 RE2 AP_SELECTED_INVOICES ATTRIBUTE5 Remittance Advice Flexfield 6 2020 Varchar2 20 80 181 A1 RE2 AP_SELECTED_INVOICES ATTRIBUTE6 Remittance Advice Flexfield 7 2020 Varchar2 30 80 261 A1 RE2 AP_SELECTED_INVOICES ATTRIBUTE7 Remittance Advice Flexfield 8 2020 Varchar2 40 80 341 A1 RE2 AP_SELECTED_INVOICES ATTRIBUTE8 Remittance Advice Flexfield 9 2020 Varchar2 50 80 421 A1 RE2 AP_SELECTED_INVOICES ATTRIBUTE9 RECORD 2030 (PYO) Common Key (Positions 1-91) 2030 Varchar2 91 1 Record Number 2030 Varchar2 4 92 Constant '2030' Record Layout 2030 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2030 Varchar2 3 98 Constant 'RE3' Remittance Advice Flexfield 10 2030 Varchar2 10 80 101 A1 RE3 AP_SELECTED_INVOICES ATTRIBUTE10 Remittance Advice Flexfield 11 2030 Varchar2 20 80 181 A1 RE3 AP_SELECTED_INVOICES ATTRIBUTE11 Remittance Advice Flexfield 12 2030 Varchar2 30 80 261 A1 RE3 AP_SELECTED_INVOICES ATTRIBUTE12 Remittance Advice Flexfield 13 2030 Varchar2 40 80 341 A1 RE3 AP_SELECTED_INVOICES ATTRIBUTE13 Remittance Advice Flexfield 14 2030 Varchar2 50 80 421 A1 RE3 AP_SELECTED_INVOICES ATTRIBUTE14 RECORD 2040 (PYO) Common Key (Positions 1-91) 2040 Varchar2 91 1 Record Number 2040 Varchar2 4 92 Constant '2040' Record Layout 2040 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2040 Varchar2 3 98 Constant 'RE4' Remittance Advice Flexfield 15 2040 Varchar2 10 80 101 A1 RE4 AP_SELECTED_INVOICES ATTRIBUTE15
| Previous | Next | Contents | Index | Navigation | Glossary | Library |