![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
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 Rec Qual Application Table Application Column RECORD 0010 (INO) Common Key (Positions 1-91) 0010 Varchar2 91 1 Record Number 0010 Varchar2 4 92 Constant '0010' Record Layout Code 0010 Varchar2 2 96 Constant 'CT' Record Layout Qualifier 0010 Varchar2 3 98 Constant 'CTL' Communication Method 0010 Varchar2 10 2 101 CT CTL ECE_TP_HEADERS COMMUNICATION_METHOD Test Indicator 0010 Varchar2 20 1 103 CT CTL ECE_TP_DETAILS TEST_FLAG Transaction Type 0010 Varchar2 30 6 104 CT CTL ECE_TP_DETAILS DOCUMENT_ID Document Type 0010 Varchar2 40 5 110 CT CTL RA_CUST_TRX_TYPES TYPE Document Purpose Code 0010 Varchar2 50 2 115 CT CTL Document Code 0010 Varchar2 60 35 117 CT CTL RA_CUSTOMER_TRX TRX_NUMBER Trading Partner Translator Code 0010 Varchar2 70 35 152 CT CTL ECE_TP_DETAILS TRANSLATOR_CODE Trading Partner Location Code 0010 Varchar2 80 35 187 CT CTL ECE_TP_HEADERS TP_LOCATION_CODE_EXT Trading Partner Description 0010 Varchar2 90 71 222 CT CTL ECE_TP_HEADERS TP_DESCRIPTION Trading Partner Reference 1 0010 Varchar2 100 80 293 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT1 Trading Partner Reference 2 0010 Varchar2 110 80 373 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT2 Transaction Date/Time 0010 Varchar2 120 15 453 CT CTL Transaction Run ID 0010 Number 130 15 468 CT CTL Control 1 0010 Varchar2 140 10 483 CT CTL Control 2 0010 Varchar2 150 10 493 CT CTL Control 3 0010 Varchar2 160 10 503 CT CTL RECORD 0020 (INO) Common Key (Positions 1-91) 0020 Varchar2 91 1 Record Number 0020 Varchar2 4 92 Constant '0020' Record Layout Code 0020 Varchar2 2 96 Constant 'A3' Record Layout Qualifier 0020 Varchar2 3 98 Constant 'TH1' Trading Partner Header Flexfield Context 0020 Varchar2 10 30 101 A3 TH1 ECE_TP_HEADERS ATTRIBUTE_CATEGORY Trading Partner Header Flexfield 1 0010 Varchar2 20 80 131 A3 TH1 ECE_TP_HEADERS ATTRIBUTE1 Trading Partner Header Flexfield 2 0020 Varchar2 30 80 211 A3 TH1 ECE_TP_HEADERS ATTRIBUTE2 Trading Partner Header Flexfield 3 0020 Varchar2 40 80 291 A3 TH1 ECE_TP_HEADERS ATTRIBUTE3 Trading Partner Header Flexfield 4 0020 Varchar2 50 80 371 A3 TH1 ECE_TP_HEADERS ATTRIBUTE4 RECORD 0030 (INO) Common Key (Positions 1-91) 0030 Varchar2 91 1 Record Number 0030 Varchar2 4 92 Constant '0030' Record Layout Code 0030 Varchar2 2 96 Constant 'A4' Record Layout Qualifier 0030 Varchar2 3 98 Constant 'TH2' Trading Partner Header Flexfield 5 0030 Varchar2 10 80 101 A4 TH2 ECE_TP_HEADERS ATTRIBUTE5 Trading Partner Header Flexfield 6 0030 Varchar2 20 80 181 A4 TH2 ECE_TP_HEADERS ATTRIBUTE6 Trading Partner Header Flexfield 7 0030 Varchar2 30 80 261 A4 TH2 ECE_TP_HEADERS ATTRIBUTE7 Trading Partner Header Flexfield 8 0030 Varchar2 40 80 341 A4 TH2 ECE_TP_HEADERS ATTRIBUTE8 Trading Partner Header Flexfield 9 0030 Varchar2 50 80 421 A4 TH2 ECE_TP_HEADERS ATTRIBUTE9 RECORD 0040 (INO) Common Key (Positions 1-91) 0040 Varchar2 91 1 Record Number 0040 Varchar2 4 92 Constant '0040' Record Layout Code 0040 Varchar2 2 96 Constant 'A4' Record Layout Qualifier 0040 Varchar2 3 98 Constant 'TH3' Trading Partner Header Flexfield 10 0040 Varchar2 10 80 101 A4 TH3 ECE_TP_HEADERS ATTRIBUTE10 Trading Partner Header Flexfield 11 0040 Varchar2 20 80 181 A4 TH3 ECE_TP_HEADERS ATTRIBUTE11 Trading Partner Header Flexfield 12 0040 Varchar2 30 80 261 A4 TH3 ECE_TP_HEADERS ATTRIBUTE12 Trading Partner Header Flexfield 13 0040 Varchar2 40 80 341 A4 TH3 ECE_TP_HEADERS ATTRIBUTE13 Trading Partner Header Flexfield 14 0040 Varchar2 50 80 421 A4 TH3 ECE_TP_HEADERS ATTRIBUTE14 RECORD 0050 (INO) Common Key (Positions 1-91) 0050 Varchar2 91 1 Record Number 0050 Varchar2 4 92 Constant '0050' Record Layout Code 0050 Varchar2 2 96 Constant 'A4' Record Layout Qualifier 0050 Varchar2 3 98 Constant 'TH4' Trading Partner Header Flexfield 15 0050 Varchar2 30 80 101 A4 TH4 ECE_TP_HEADERS ATTRIBUTE15 RECORD 1000 (INO) Common Key (Positions 1-91) 1000 Varchar2 91 1 Record Number 1000 Varchar2 4 92 Constant '1000' Record Layout Code 1000 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1000 Varchar2 3 98 Constant 'BT1' Bill To Code (Internal) 1000 Varchar2 10 20 101 AD BT1 RA_ADDRESSES ORIG_SYSTEM_REFERENCE Bill To Code (Ext) 1000 Varchar2 20 20 121 AD BT1 ECE_TP_HEADERS TP_LOCATION_CODE_EXT Bill To Customer Name 1000 Varchar2 30 60 141 AD BT1 RA_CUSTOMERS CUSTOMER_NAME Bill To Address 1 1000 Varchar2 40 35 201 AD BT1 RA_ADDRESSES ADDRESS1 Bill To Address 2 1000 Varchar2 50 35 236 AD BT1 RA_ADDRESSES ADDRESS2 Bill To Address 3 1000 Varchar2 60 35 271 AD BT1 RA_ADDRESSES ADDRESS3 Bill To Address 4 1000 Varchar2 70 35 306 AD BT1 RA_ADDRESSES ADDRESS4 Bill To City 1000 Varchar2 80 30 341 AD BT1 RA_ADDRESSES CITY Bill To Postal Code 1000 Varchar2 90 15 371 AD BT1 RA_ADDRESSES POSTAL_CODE Bill To Country (Internal) COUNTRY 1000 Varchar2 100 20 386 AD BT1 RA_ADDRESSES COUNTRY Bill To Country (Ext1) 1000 Varchar2 110 3 406 AD BT1 ECE_XREF_DATA XREF_EXT_VALUE1 Bill To State (Internal) STATE 1000 Varchar2 120 20 409 AD BT1 RA_ADDRESSES STATE Bill To State (Ext1) 1000 Varchar2 130 10 429 AD BT1 ECE_XREF_DATA XREF_EXT_VALUE1 Bill To Province (Internal) PROVINCE 1000 Varchar2 140 20 439 AD BT1 RA_ADDRESSES PROVINCE Bill To Province (Ext1) 1000 Varchar2 150 10 459 AD BT1 ECE_XREF_DATA XREF_EXT_VALUE1 Bill To County 1000 Varchar2 160 25 469 AD BT1 RA_ADDRESSES COUNTY RECORD 1010 (INO) Common Key (Positions 1-91) 1010 Varchar2 91 1 Record Number 1010 Varchar2 4 92 Constant '1010' Record Layout Code 1010 Varchar2 2 96 Constant 'CM' Record Layout Qualifier 1010 Varchar2 3 98 Constant 'BT1' Bill To Customer Location 1010 Varchar2 10 40 101 CM BT1 RA_SITE_USES LOCATION Bill To Customer Number 1010 Varchar2 20 30 141 CM BT1 RA_CUSTOMERS CUSTOMER_NUMBER Bill To Customer SIC Code 1010 Varchar2 30 30 171 CM BT1 RA_CUSTOMERS SIC_CODE Bill To Customer Sales Channel 1010 Varchar2 40 30 201 CM BT1 RA_CUSTOMERS SALES_CHANNEL_CODE Bill To Contact Last Name 1010 Varchar2 50 50 231 CM BT1 RA_CONTACTS LAST_NAME Bill To Contact First Name 1010 Varchar2 60 40 281 CM BT1 RA_CONTACTS FIRST_NAME Bill To Contact Job Title 1010 Varchar2 70 50 321 CM BT1 RA_CONTACTS JOB_TITLE RECORD 1015 (INO) Common Key (Positions 1-91) 1015 Varchar2 91 1 Record Number 1015 Varchar2 4 92 Constant '1015' Record Layout Code 1015 Varchar2 2 96 Constant 'RF' Record Layout Qualifier 1015 Varchar2 3 98 Constant 'BT1' Bill To Trading Partner Reference 1 1015 Varchar2 10 80 101 RF BT1 ECE_TP_HEADERS TP_REFERENCE_EXT1 Bill To Trading Partner Reference 2 1015 Varchar2 20 80 181 RF BT1 ECE_TP_HEADERS TP_REFERENCE_EXT1 RECORD 1020 (INO) Common Key (Positions 1-91) 1020 Varchar2 91 1 Record Number 1020 Varchar2 4 92 Constant '1020' Record Layout Code 1020 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1020 Varchar2 3 98 Constant 'BT1' Bill To Customer Flexfield Context 1020 Varchar2 10 30 101 A1 BT1 RA_CUSTOMERS ATTRIBUTE_CATEGORY Bill To Customer Flexfield 1 1020 Varchar2 20 80 131 A1 BT1 RA_CUSTOMERS ATTRIBUTE1 Bill To Customer Flexfield 2 1020 Varchar2 30 80 211 A1 BT1 RA_CUSTOMERS ATTRIBUTE2 Bill To Customer Flexfield 3 1020 Varchar2 40 80 291 A1 BT1 RA_CUSTOMERS ATTRIBUTE3 Bill To Customer Flexfield 4 1020 Varchar2 50 80 371 A1 BT1 RA_CUSTOMERS ATTRIBUTE4 RECORD 1030 (INO) Common Key (Positions 1-91) 1030 Varchar2 91 1 Record Number 1030 Varchar2 4 92 Constant '1030' Record Layout Code 1030 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1030 Varchar2 3 98 Constant 'BT2' Bill To Customer Flexfield 5 1030 Varchar2 10 80 101 A2 BT2 RA_CUSTOMERS ATTRIBUTE5 Bill To Customer Flexfield 6 1030 Varchar2 20 80 181 A2 BT2 RA_CUSTOMERS ATTRIBUTE6 Bill To Customer Flexfield 7 1030 Varchar2 30 80 261 A2 BT2 RA_CUSTOMERS ATTRIBUTE7 Bill To Customer Flexfield 8 1030 Varchar2 40 80 341 A2 BT2 RA_CUSTOMERS ATTRIBUTE8 Bill To Customer Flexfield 9 1030 Varchar2 50 80 421 A2 BT2 RA_CUSTOMERS ATTRIBUTE9 RECORD 1040 (INO) Common Key (Positions 1-91) 1040 Varchar2 91 1 Record Number 1040 Varchar2 4 92 Constant '1040' Record Layout Code 1040 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1040 Varchar2 3 98 Constant 'BT3' Bill To Customer Flexfield 10 1040 Varchar2 10 80 101 A2 BT3 RA_CUSTOMERS ATTRIBUTE10 Bill To Customer Flexfield 11 1040 Varchar2 20 80 181 A2 BT3 RA_CUSTOMERS ATTRIBUTE11 Bill To Customer Flexfield 12 1040 Varchar2 30 80 261 A2 BT3 RA_CUSTOMERS ATTRIBUTE12 Bill To Customer Flexfield 13 1040 Varchar2 40 80 341 A2 BT3 RA_CUSTOMERS ATTRIBUTE13 Bill To Customer Flexfield 14 1040 Varchar2 50 80 421 A2 BT3 RA_CUSTOMERS ATTRIBUTE14 RECORD 1050 (INO) Common Key (Positions 1-91) 1050 Varchar2 91 1 Record Number 1050 Varchar2 4 92 Constant '1050' Record Layout Code 1050 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1050 Varchar2 3 98 Constant 'BT4' Bill To Customer Flexfield 15 1050 Varchar2 10 80 101 A2 BT4 RA_CUSTOMERS ATTRIBUTE15 RECORD 1060 (INO) Common Key (Positions 1-91) 1060 Varchar2 91 1 Record Number 1060 Varchar2 4 92 Constant '1060' Record Layout Code 1060 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1060 Varchar2 3 98 Constant 'BS1' Bill To Site Flexfield Context 1060 Varchar2 10 30 101 A1 BS1 RA_SITE_USES ATTRIBUTE_CATEGORY Bill To Site Flexfield 1 1060 Varchar2 20 80 131 A1 BS1 RA_SITE_USES ATTRIBUTE1 Bill To Site Flexfield 2 1060 Varchar2 30 80 211 A1 BS1 RA_SITE_USES ATTRIBUTE2 Bill To Site Flexfield 3 1060 Varchar2 40 80 291 A1 BS1 RA_SITE_USES ATTRIBUTE3 Bill To Site Flexfield 4 1060 Varchar2 50 80 371 A1 BS1 RA_SITE_USES ATTRIBUTE4 RECORD 1070 (INO) Common Key (Positions 1-91) 1070 Varchar2 91 1 Record Number 1070 Varchar2 4 92 Constant '1070' Record Layout Code 1070 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1070 Varchar2 3 98 Constant 'BS2' Bill To Site Flexfield 5 1070 Varchar2 10 80 101 A2 BS2 RA_SITE_USES ATTRIBUTE5 Bill To Site Flexfield 6 1070 Varchar2 20 80 181 A2 BS2 RA_SITE_USES ATTRIBUTE6 Bill To Site Flexfield 7 1070 Varchar2 30 80 261 A2 BS2 RA_SITE_USES ATTRIBUTE7 Bill To Site Flexfield 8 1070 Varchar2 40 80 341 A2 BS2 RA_SITE_USES ATTRIBUTE8 Bill To Site Flexfield 9 1070 Varchar2 50 80 421 A2 BS2 RA_SITE_USES ATTRIBUTE9 RECORD 1080 (INO) Common Key (Positions 1-91) 1080 Varchar2 91 1 Record Number 1080 Varchar2 4 92 Constant '1080' Record Layout Code 1080 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1080 Varchar2 3 98 Constant 'BS3' Bill To Site Flexfield 10 1080 Varchar2 10 80 101 A2 BS3 RA_SITE_USES ATTRIBUTE10 Bill To Site Flexfield 11 1080 Varchar2 20 80 181 A2 BS3 RA_SITE_USES ATTRIBUTE11 Bill To Site Flexfield 12 1080 Varchar2 30 80 261 A2 BS3 RA_SITE_USES ATTRIBUTE12 Bill To Site Flexfield 13 1080 Varchar2 40 80 341 A2 BS3 RA_SITE_USES ATTRIBUTE13 Bill To Site Flexfield 14 1080 Varchar2 50 80 421 A2 BS3 RA_SITE_USES ATTRIBUTE14 RECORD 1090 (INO) Common Key (Positions 1-91) 1090 Varchar2 91 1 Record Number 1090 Varchar2 4 92 Constant '1090' Record Layout Code 1090 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1090 Varchar2 3 98 Constant 'BS4' Bill To Site Flexfield 15 1090 Varchar2 10 80 101 A2 BS4 RA_SITE_USES ATTRIBUTE15 RECORD 1100 (INO) Common Key (Positions 1-91) 1100 Varchar2 91 1 Record Number 1100 Varchar2 4 92 Constant '1100' Record Layout Code 1100 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1100 Varchar2 3 98 Constant 'ST1' Ship To Code (Internal) 1100 Varchar2 10 20 101 AD ST1 RA_ADDRESSES ORIG_SYSTEM_REFERENCES Ship To Code (Ext) 1100 Varchar2 20 20 121 AD ST1 ECE_TP_HEADERS TP_LOCATION_CODE_EXT Ship To Customer Name 1100 Varchar2 30 60 141 AD ST1 RA_CUSTOMERS CUSTOMER_NAME Ship To Address 1 1100 Varchar2 40 35 201 AD ST1 RA_ADDRESSES ADDRESS1 Ship To Address 2 1100 Varchar2 50 35 236 AD ST1 RA_ADDRESSES ADDRESS2 Ship To Address 3 1100 Varchar2 60 35 271 AD ST1 RA_ADDRESSES ADDRESS3 Ship To Address 4 1100 Varchar2 70 35 306 AD ST1 RA_ADDRESSES ADDRESS4 Ship To City 1100 Varchar2 80 30 341 AD ST1 RA_ADDRESSES CITY Ship To Postal Code 1100 Varchar2 90 15 371 AD ST1 RA_ADDRESSES POSTAL_CODE Ship To Country (Internal) COUNTRY 1100 Varchar2 100 20 386 AD ST1 RA_ADDRESSES COUNTRY Ship To Country (Ext1) 1100 Varchar2 110 3 406 AD ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To State (Internal) STATE 1100 Varchar2 120 20 409 AD ST1 RA_ADDRESSES STATE Ship To State (Ext1) 1100 Varchar2 130 10 429 AD ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Province (Internal) PROVINCE 1100 Varchar2 140 20 439 AD ST1 RA_ADDRESSES PROVINCE Ship To Province (Ext1) 1100 Varchar2 150 10 459 AD ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To County 1100 Varchar2 160 25 469 AD ST1 RA_ADDRESSES COUNTY RECORD 1110 (INO) Common Key (Positions 1-91) 1110 Varchar2 91 1 Record Number 1110 Varchar2 4 92 Constant '1110' Record Layout Code 1110 Varchar2 2 96 Constant 'CM' Record Layout Qualifier 1110 Varchar2 3 98 Constant 'ST1' Ship To Location 1110 Varchar2 10 40 101 CM ST1 RA_SITE_USES LOCATION Ship To Customer Number 1110 Varchar2 20 30 141 CM ST1 RA_CUSTOMERS CUSTOMER_NUMBER Ship To Customer SIC Code 1110 Varchar2 30 30 171 CM ST1 RA_CUSTOMERS SIC_CODE Ship To Customer Sales Channel 1110 Varchar2 40 30 201 CM ST1 RA_CUSTOMERS SALES_CHANNEL_CODE Ship To Contact Last Name 1110 Varchar2 50 50 231 CM ST1 RA_CONTACTS LAST_NAME Ship To Contact First Name 1110 Varchar2 60 40 281 CM ST1 RA_CONTACTS FIRST_NAME Ship To Contact Job Title 1110 Varchar2 70 50 321 CM ST1 RA_CONTACTS JOB_TITLE RECORD 1115 (INO) Common Key (Positions 1-91) 1115 Varchar2 91 1 Record Number 1115 Varchar2 4 92 Constant '1115' Record Layout Code 1115 Varchar2 2 96 Constant 'RF' Record Layout Qualifier 1115 Varchar2 3 98 Constant 'ST1' Ship To Trading Partner Reference 1 1115 Varchar2 10 80 101 RF ST1 ECE_TP_HEADERS TP_REFERENCE_EXT1 Ship To Trading Partner Reference 2 1115 Varchar2 20 80 181 RF ST1 ECE_TP_HEADERS TP_REFERENCE_EXT1 RECORD 1200 (INO) Common Key (Positions 1-91) 1200 Varchar2 91 1 Record Number 1200 Varchar2 4 92 Constant '1200' Record Layout Code 1200 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1200 Varchar2 3 98 Constant 'SO1' Sold To Code (Internal) 1200 Varchar2 10 20 101 AD SO1 RA_ADDRESSES ORIG_SYSTEM_REFERENCE Sold To Code (Ext) 1200 Varchar2 20 20 121 AD SO1 ECE_TP_HEADERS TP_LOCATION_CODE_EXT Sold To Customer Name 1200 Varchar2 30 60 141 AD SO1 RA_CUSTOMERS CUSTOMER_NAME Sold To Address 1 1200 Varchar2 40 35 201 AD SO1 RA_ADDRESSES ADDRESS1 Sold To Address 2 1200 Varchar2 50 35 236 AD SO1 RA_ADDRESSES ADDRESS2 Sold To Address 3 1200 Varchar2 60 35 271 AD SO1 RA_ADDRESSES ADDRESS3 Sold To Address 4 1200 Varchar2 70 35 306 AD SO1 RA_ADDRESSES ADDRESS4 Sold To City 1200 Varchar2 80 30 341 AD SO1 RA_ADDRESSES CITY Sold To Postal Code 1200 Varchar2 90 15 371 AD SO1 RA_ADDRESSES POSTAL_CODE Sold To Country (Internal) COUNTRY 1200 Varchar2 100 20 386 AD SO1 RA_ADDRESSES COUNTRY Sold To Country (Ext1) 1200 Varchar2 110 3 406 AD SO1 ECE_XREF_DATA XREF_EXT_VALUE1 Sold To State (Internal) STATE 1200 Varchar2 120 20 409 AD SO1 RA_ADDRESSES STATE Sold To State (Ext1) 1200 Varchar2 130 10 429 AD SO1 ECE_XREF_DATA XREF_EXT_VALUE1 Sold To Province (Internal) PROVINCE 1200 Varchar2 140 20 439 AD SO1 RA_ADDRESSES PROVINCE Sold To Province (Ext1) 1200 Varchar2 150 10 459 AD SO1 ECE_XREF_DATA XREF_EXT_VALUE1 Sold To County 1200 Varchar2 160 25 469 AD SO1 RA_ADDRESSES COUNTY RECORD 1210 (INO) Common Key (Positions 1-91) 1210 Varchar2 91 1 Record Number 1210 Varchar2 4 92 Constant '1210' Record Layout Code 1210 Varchar2 2 96 Constant 'CM' Record Layout Qualifier 1210 Varchar2 3 98 Constant 'SO1' Sold To Location 1210 Varchar2 10 40 101 CM SO1 RA_SITE_USES LOCATION Sold To Customer Number 1210 Varchar2 20 30 141 CM SO1 RA_CUSTOMERS CUSTOMER_NUMBER Sold To Customer SIC Code 1210 Varchar2 30 30 171 CM SO1 RA_CUSTOMERS SIC_CODE Sold To Customer Sales Channel 1210 Varchar2 40 30 201 CM SO1 RA_CUSTOMERS SALES_CHANNEL_CODE Sold To Contact Last Name 1210 Varchar2 50 50 231 CM SO1 RA_CONTACTS LAST_NAME Sold To Contact First Name 1210 Varchar2 60 40 281 CM SO1 RA_CONTACTS FIRST_NAME Sold To Contact Job Title 1210 Varchar2 70 50 321 CM SO1 RA_CONTACTS JOB_TITLE RECORD 1215 (INO) Common Key (Positions 1-91) 1215 Varchar2 91 1 Record Number 1215 Varchar2 4 92 Constant '1215' Record Layout Code 1215 Varchar2 2 96 Constant 'RF' Record Layout Qualifier 1215 Varchar2 3 98 Constant 'SO1' Sold To Trading Partner Reference 1 1215 Varchar2 10 80 101 RF SO1 ECE_TP_HEADERS TP_REFERENCE_EXT1 Sold To Trading Partner Reference 2 1215 Varchar2 20 80 181 RF SO1 ECE_TP_HEADERS TP_REFERENCE_EXT1 RECORD 1300 (INO) Common Key (Positions 1-91) 1300 Varchar2 91 1 Record Number 1300 Varchar2 4 92 Constant '1300' Record Layout Code 1300 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1300 Varchar2 3 98 Constant 'RE1' Remit To Code (Internal) 1300 Varchar2 10 20 101 AD RE1 RA_ADDRESSES ORIG_SYSTEM_REFERENCE Remit To Code (Ext) 1300 Varchar2 20 20 121 AD RE1 ECE_TP_HEADERS TP_LOCATION_CODE_EXT Remit to Customer Name 1300 Varchar2 30 60 141 AD RE1 RA_CUSTOMERS CUSTOMER_NAME Remit To Address 1 1300 Varchar2 40 35 201 AD RE1 RA_ADDRESSES ADDRESS1 Remit To Address 2 1300 Varchar2 50 35 236 AD RE1 RA_ADDRESSES ADDRESS2 Remit To Address 3 1300 Varchar2 60 35 271 AD RE1 RA_ADDRESSES ADDRESS3 Remit To Address 4 1300 Varchar2 70 35 306 AD RE1 RA_ADDRESSES ADDRESS4 Remit To City 1300 Varchar2 80 30 341 AD RE1 RA_ADDRESSES CITY Remit To Postal Code 1300 Varchar2 90 15 371 AD RE1 RA_ADDRESSES POSTAL_CODE Remit To Country (Internal) COUNTRY 1300 Varchar2 100 20 386 AD RE1 RA_ADDRESSES COUNTRY Remit To Country (Ext1) 1300 Varchar2 110 3 406 AD RE1 ECE_XREF_DATA XREF_EXT_VALUE1 Remit To State (Internal) STATE 1300 Varchar2 120 20 409 AD RE1 RA_ADDRESSES STATE Remit To State(Ext1) 1300 Varchar2 130 10 429 AD RE1 ECE_XREF_DATA XREF_EXT_VALUE1 Remit To Province (Internal) PROVINCE 1300 Varchar2 140 20 439 AD RE1 RA_ADDRESSES PROVINCE Remit To Province(Ext1) 1300 Varchar2 150 10 459 AD RE1 ECE_XREF_DATA XREF_EXT_VALUE1 Remit To County 1300 Varchar2 160 25 469 AD RE1 RA_ADDRESSES COUNTY RECORD 1315 (INO) Common Key (Positions 1-91) 1315 Varchar2 91 1 Record Number 1315 Varchar2 4 92 Constant '1315' Record Layout Code 1315 Varchar2 2 96 Constant 'RF' Record Layout Qualifier 1315 Varchar2 3 98 Constant 'RE1' Remit To Trading Partner Reference 1 1315 Varchar2 10 80 101 RF RE1 ECE_TP_HEADERS TP_REFERENCE_EXT1 Remit To Trading Partner Reference 2 1315 Varchar2 20 80 181 RF RE1 ECE_TP_HEADERS TP_REFERENCE_EXT1 RECORD 1400 (INO) Common Key (Positions 1-91) 1400 Varchar2 91 1 Record Number 1400 Varchar2 4 92 Constant '1400' Record Layout Code 1400 Varchar2 2 96 Constant 'SF' Record Layout Qualifier 1400 Varchar2 3 98 Constant 'SF1' Ship From Code (Internal) 1400 Varchar2 10 3 101 SF SF1 ORG_ORGANIZATION_DEFINITIONSORGANIZATION_CODE Ship From Code (Ext 1) 1400 Varchar2 20 80 104 SF SF1 ECE_XREF_DATA XREF_EXT_VALUE1 RECORD 2000 (INO) Common Key (Positions 1-91) 2000 Varchar2 91 1 Record Number 2000 Varchar2 4 92 Constant '2000' Record Layout Code 2000 Varchar2 2 96 Constant 'IV' Record Layout Qualifier 2000 Varchar2 3 98 Constant 'IV1' Invoice Number 2000 Varchar2 10 20 101 IV IV1 RA_CUSTOMER_TRX TRX_NUMBER Credited Invoice Number 2000 Varchar2 20 20 121 IV IV1 RA_CUSTOMER_TRX TRX_NUMBER Reference Invoice Number 2000 Varchar2 30 20 141 IV IV1 RA_CUSTOMER_TRX TRX_NUMBER Parent Invoice Number 2000 Varchar2 40 20 161 IV IV1 RA_CUSTOMER_TRX TRX_NUMBER Shipment Date 2000 Date 50 15 181 IV IV1 RA_CUSTOMER_TRX SHIP_DATE_ACTUAL Purchase Order Number 2000 Varchar2 60 50 196 IV IV1 RA_CUSTOMER_TRX PURCHASE_ORDER Creation Date 2000 Date 70 15 246 IV IV1 RA_CUSTOMER_TRX CREATION_DATE Purchase Order Revision Number 2000 Varchar2 80 50 261 IV IV1 RA_CUSTOMER_TRX PURCHASE_ORDER_REVISION Commitment Start Date 2000 Date 90 15 311 IV IV1 RA_CUSTOMER_TRX START_DATE_COMMITMENT Purchase Order Date 2000 Date 100 15 326 IV IV1 RA_CUSTOMER_TRX PURCHASE_ORDER_DATE Commitment End Date 2000 Date 110 15 341 IV IV1 RA_CUSTOMER_TRX END_DATE_COMMITMENT Transaction Date 2000 Date 120 15 356 IV IV1 RA_CUSTOMER_TRX TRX_DATE Last Update Date 2000 Date 130 15 371 IV IV1 RA_CUSTOMER_TRX LAST_UPDATE_DATE Due Date 2000 Date 140 15 386 IV IV1 AR_PAYMENT_SCHEDULES DUE_DATE Total Amount Due 2000 Number 150 22 401 IV IV1 AR_PAYMENT_SCHEDULES AMOUNT_DUE_ORIGINAL Amount Tax Due 2000 Number 160 22 423 IV IV1 AR_PAYMENT_SCHEDULES TAX_ORIGINAL Amount Freight Due 2000 Number 170 22 445 IV IV1 AR_PAYMENT_SCHEDULES FREIGHT_ORIGINAL Amount Line Items Due 2000 Number 180 22 467 IV IV1 AR_PAYMENT_SCHEDULES AMOUNT_LINE_ITEMS_ORIGINAL Invoice Name (internal) 2000 Number 190 20 489 IV IV1 AR_PAYMENT_SCHEDULES AMOUNT_LINE_ITEMS_ORIGINAL Invoice Name (ext 1) 2000 Number 200 10 509 IV IV1 AR_PAYMENT_SCHEDULES AMOUNT_LINE_ITEMS_ORIGINAL RECORD 2010 (INO) Common Key (Positions 1-91) 2010 Varchar2 91 1 Record Number 2010 Varchar2 4 92 Constant '2010' Record Layout Code 2010 Varchar2 2 96 Constant 'IV' Record Layout Qualifier 2010 Varchar2 3 98 Constant 'IV2' Amount Charges Due 2010 Number 10 22 101 IV IV2 RA_CUSTOMER_TRX_LINES RECORD 2020 (INO) Common Key (Positions 1-91) 2020 Varchar2 91 1 Record Number 2020 Varchar2 4 92 Constant '2020' Record Layout Code 2020 Varchar2 2 96 Constant 'IV' Record Layout Qualifier 2020 Varchar2 3 98 Constant 'IV3' Credit Memo Reason 2020 Varchar2 10 30 101 IV IV3 RA_CUSTOMER_TRX REASON_CODE Transmission Lead Days 2020 Number 20 22 131 IV IV3 RA_TERMS PRINTING_LEAD_DAYS Transaction Source 2020 Varchar2 30 50 153 IV IV3 AR_BATCH_SOURCES NAME Installment Number 2020 Number 40 22 203 IV IV3 RA_TERMS_LINES SEQUENCE_NUM Maximum Installment Number 2020 Number 50 22 225 IV IV3 RA_TERMS_LINES SEQUENCE_NUMBER RECORD 2030 (INO) Common Key (Positions 1-91) 2030 Varchar2 91 1 Record Number 2030 Varchar2 4 92 Constant '2030' Record Layout Code 2030 Varchar2 2 96 Constant 'IV' Record Layout Qualifier 2030 Varchar2 3 98 Constant 'IV4' Shipment Waybill Number 2030 Varchar2 10 30 101 IV IV4 RA_CUSTOMER_TRX WAYBILL_NUMBER Ship Via (Internal) SHIP_VIA 2030 Varchar2 20 30 131 IV IV4 RA_CUSTOMER_TRX SHIP_VIA Ship Via (Ext1) 2030 Varchar2 30 30 161 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE1 Ship Via (Ext2) 2030 Varchar2 40 30 191 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE2 Ship Via (Ext3) 2030 Varchar2 50 30 221 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE3 Ship Via (Ext4) 2030 Varchar2 60 30 251 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE4 Ship Via (Ext5) 2030 Varchar2 70 30 281 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE5 Shipment FOB (Internal) FOB 2030 Varchar2 80 30 311 IV IV4 RA_CUSTOMER_TRX FOB_POINT Shipment FOB Point (Ext1) 2030 Varchar2 90 30 341 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE1 Shipment FOB Point (Ext2) 2030 Varchar2 100 30 371 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE2 Shipment FOB Point (Ext3) 2030 Varchar2 110 30 401 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE3 Shipment FOB Point (Ext4) 2030 Varchar2 120 30 431 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE4 Shipment FOB Point (Ext5) 2030 Varchar2 130 30 461 IV IV4 ECE_XREF_DATA XREF_EXT_VALUE5 RECORD 2040 (INO) Common Key (Positions 1-91) 2040 Varchar2 91 1 Record Number 2040 Varchar2 4 92 Constant '2040' Record Layout Code 2040 Varchar2 2 96 Constant 'IV' Record Layout Qualifier 2040 Varchar2 3 98 Constant 'IV5' Currency Code CURRENCY 2040 Varchar2 10 15 101 IV IV5 RA_CUSTOMER_TRX INVOICE_CURRENCY_CODE Currency Code (Ext1) 2040 Varchar2 20 15 116 IV IV5 ECE_XREF_DATA XREF_EXT_VALUE1 Currency Exchange Rate 2040 Number 30 22 131 IV IV5 RA_CUSTOMER_TRX EXCHANGE_RATE Base Currency Code CURRENCY 2040 Varchar2 40 15 153 IV IV5 GL_SET_OF_BOOKS CURRENCY_CODE Base Currency Code (Ext1) 2040 Varchar2 50 15 168 IV IV5 ECE_XREF_DATA XREF_EXT_VALUE1 RECORD 2050 (INO) Common Key (Positions 1-91) 2050 Varchar2 91 1 Record Number 2050 Varchar2 4 92 Constant '2050' Record Layout Code 2050 Varchar2 2 96 Constant 'IV' Record Layout Qualifier 2050 Varchar2 3 98 Constant 'IV6' Payment Term Name (Internal) 2050 Varchar2 10 40 101 IV IV6 RA_TERMS NAME Term Due Percent 2050 Number 20 10 141 IV IV6 RA_TERMS_LINES Term Due Date 2050 Number 30 10 151 IV IV6 RA_TERMS_LINES DUE_DATE Term Due Days 2050 Number 40 10 161 IV IV6 RA_TERMS_LINES DUE_DAYS Term Due Day of Month 2050 Number 50 10 171 IV IV6 RA_TERMS_LINES DUE_DAY_OF_MONTH Term Due Cutoff Day 2050 Number 60 10 181 IV IV6 RA_REMIT_TOS DUE_CUTOFF_DAY Term Due Months Forward 2050 Number 70 10 191 IV IV6 RA_TERMS_LINES DUE_MONTHS_FORWARD Discount 1 Percent 2050 Number 80 10 201 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_PERCENT Discount 1 Days 2050 Number 90 10 211 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DAYS Discount 1 Date 2050 Date 100 10 221 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DATE Discount 1 Day of Month 2050 Number 110 10 231 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DAY_OF_MONTH Discount 1 Months Forward 2050 Number 120 10 241 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_MONTHS_FORWARD Discount 2 Percent 2050 Number 130 10 251 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_PERCENT Discount 2 Days 2050 Number 140 10 261 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DAYS Discount 2 Date 2050 Date 150 10 271 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DATE Discount 2 Day of Month 2050 Number 160 10 281 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DAY_OF_MONTH Discount 2 Months Forward 2050 Number 170 10 291 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_MONTHS_FORWARD Discount 3 Percent 2050 Number 180 10 301 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_PERCENT Discount 3 Days 2050 Number 190 10 311 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DAYS Discount 3 Date 2050 Date 200 10 321 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DATE Discount 3 Day of Month 2050 Number 210 10 331 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_DAY_OF_MONTH Discount 3 Months Forward 2050 Number 220 10 341 IV IV6 RA_TERMS_LINES_DISCOUNTS DISCOUNT_MONTHS_FORWARD Payment Term Name (Ext 1) 2050 Number 230 30 331 IV IV6 ECE_XREF_DATA XREF_EXT_VALUE1 Payment Term Name (Ext 2) 2050 Number 240 30 351 IV IV6 ECE_XREF_DATA XREF_EXT_VALUE2 Payment Term Name (Ext 3) 2050 Number 250 30 361 IV IV6 ECE_XREF_DATA XREF_EXT_VALUE3 Payment Term Name (Ext 4) 2050 Number 260 30 351 IV IV6 ECE_XREF_DATA XREF_EXT_VALUE4 Payment Term Name (Ext 5) 2050 Number 270 30 381 IV IV6 ECE_XREF_DATA XREF_EXT_VALUE5 RECORD 2060 (INO) Common Key (Positions 1-91) 2060 Varchar2 91 1 Record Number 2060 Varchar2 4 92 Constant '2060' Record Layout Code 2060 Varchar2 2 96 Constant 'IV' Record Layout Qualifier 2060 Varchar2 3 98 Constant 'IV7' Primary Sales Rep Name 2060 Varchar2 10 30 101 IV IV7 RA_SALESREPS NAME Comments 2060 Varchar2 20 240 131 IV IV7 RA_CUSTOMER_TRX INTERNAL_NOTES RECORD 3000 (INO) Common Key (Positions 1-91) 3000 Varchar2 91 1 Record Number 3000 Varchar2 4 92 Constant '3000' Record Layout Code 3000 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 3000 Varchar2 3 98 Constant 'IH1' Invoice Header Flexfield Context 3000 Varchar2 10 30 101 A1 IH1 RA_CUSTOMER_TRX ATTRIBUTE_CATEGORY Invoice Header Flexfield 1 3000 Varchar2 20 80 131 A1 IH1 RA_CUSTOMER_TRX ATTRIBUTE1 Invoice Header Flexfield 2 3000 Varchar2 30 80 211 A1 IH1 RA_CUSTOMER_TRX ATTRIBUTE2 Invoice Header Flexfield 3 3000 Varchar2 40 80 291 A1 IH1 RA_CUSTOMER_TRX ATTRIBUTE3 Invoice Header Flexfield 4 3000 Varchar2 50 80 371 A1 IH1 RA_CUSTOMER_TRX ATTRIBUTE4 RECORD 3010 (INO) Common Key (Positions 1-91) 3010 Varchar2 91 1 Record Number 3010 Varchar2 4 92 Constant '3010' Record Layout Code 3010 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3010 Varchar2 3 98 Constant 'IH2' Invoice Header Flexfield 5 3010 Varchar2 10 80 101 A2 IH2 RA_CUSTOMER_TRX ATTRIBUTE5 Invoice Header Flexfield 6 3010 Varchar2 20 80 181 A2 IH2 RA_CUSTOMER_TRX ATTRIBUTE6 Invoice Header Flexfield 7 3010 Varchar2 30 80 261 A2 IH2 RA_CUSTOMER_TRX ATTRIBUTE7 Invoice Header Flexfield 8 3010 Varchar2 40 80 341 A2 IH2 RA_CUSTOMER_TRX ATTRIBUTE8 Invoice Header Flexfield 9 3010 Varchar2 50 80 421 A2 IH2 RA_CUSTOMER_TRX ATTRIBUTE9 RECORD 3020 (INO) Common Key (Positions 1-91) 3020 Varchar2 91 1 Record Number 3020 Varchar2 4 92 Constant '3020' Record Layout Code 3020 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3020 Varchar2 3 98 Constant 'IH3' Invoice Header Flexfield 10 3020 Varchar2 10 80 101 A2 IH3 RA_CUSTOMER_TRX ATTRIBUTE10 Invoice Header Flexfield 11 3020 Varchar2 20 80 181 A2 IH3 RA_CUSTOMER_TRX ATTRIBUTE11 Invoice Header Flexfield 12 3020 Varchar2 30 80 261 A2 IH3 RA_CUSTOMER_TRX ATTRIBUTE12 Invoice Header Flexfield 13 3020 Varchar2 40 80 341 A2 IH3 RA_CUSTOMER_TRX ATTRIBUTE13 Invoice Header Flexfield 14 3020 Varchar2 50 80 421 A2 IH3 RA_CUSTOMER_TRX ATTRIBUTE14 RECORD 3030 (INO) Common Key (Positions 1-91) 3030 Varchar2 91 1 Record Number 3030 Varchar2 4 92 Constant '3030' Record Layout Code 3030 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3030 Varchar2 3 98 Constant 'IH4' Invoice Header Flexfield 15 3030 Varchar2 10 80 101 A2 IH4 RA_CUSTOMER_TRX ATTRIBUTE15 RECORD 3040 (INO) Common Key (Positions 1-91) 3040 Varchar2 91 1 Record Number 3040 Varchar2 4 92 Constant '3040' Record Layout Code 3040 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 3040 Varchar2 3 98 Constant 'IH5' Invoice Header Interface Flexfield Context 3040 Varchar2 10 30 101 A1 IH5 RA_CUSTOMER_TRX INTERFACE_HEADER_CONTEXT Invoice Header Interface Flexfield 1 3040 Varchar2 20 80 131 A1 IH5 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE1 Invoice Header Interface Flexfield 2 3040 Varchar2 30 80 211 A1 IH5 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE2 Invoice Header Interface Flexfield 3 3040 Varchar2 40 80 291 A1 IH5 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE3 Invoice Header Interface Flexfield 4 3040 Varchar2 50 80 371 A1 IH5 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE4 RECORD 3050 (INO) Common Key (Positions 1-91) 3050 Varchar2 91 1 Record Number 3050 Varchar2 4 92 Constant '3050' Record Layout Code 3050 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3050 Varchar2 3 98 Constant 'IH6' Invoice Header Interface Flexfield 5 3050 Varchar2 10 80 101 A2 IH6 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE5 Invoice Header Interface Flexfield 6 3050 Varchar2 20 80 181 A2 IH6 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE6 Invoice Header Interface Flexfield 7 3050 Varchar2 30 80 261 A2 IH6 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE7 Invoice Header Interface Flexfield 8 3050 Varchar2 40 80 341 A2 IH6 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE8 Invoice Header Interface Flexfield 9 3050 Varchar2 50 80 421 A2 IH6 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE9 RECORD 3060 (INO) Common Key (Positions 1-91) 3060 Varchar2 91 1 Record Number 3060 Varchar2 4 92 Constant '3060' Record Layout Code 3060 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3060 Varchar2 3 98 Constant 'IH7' Invoice Header Interface Flexfield 10 3060 Varchar2 10 80 101 A2 IH7 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE10 Invoice Header Interface Flexfield 11 3060 Varchar2 20 80 181 A2 IH7 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE11 Invoice Header Interface Flexfield 12 3060 Varchar2 30 80 261 A2 IH7 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE12 Invoice Header Interface Flexfield 13 3060 Varchar2 40 80 341 A2 IH7 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE13 Invoice Header Interface Flexfield 14 3060 Varchar2 50 80 421 A2 IH7 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE14 RECORD 3070 (INO) Common Key (Positions 1-91) 3070 Varchar2 91 1 Record Number 3070 Varchar2 4 92 Constant '3070' Record Layout Code 3070 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3070 Varchar2 3 98 Constant 'IH8' Invoice Header Interface Flexfield 15 3070 Varchar2 10 80 101 A2 IH8 RA_CUSTOMER_TRX INTERFACE_HEADER_ATTRIBUTE15 RECORD 3075 (INO) Common Key (Positions 1-91) 3075 Varchar2 91 1 Record Number 3075 Varchar2 4 92 Constant '3075' Record Layout Code 3075 Varchar2 2 96 Constant 'IVÆ Record Layout Qualifier 3075 Varchar2 3 98 Constant 'IV8Æ Equipment Prefix 3075 Varchar2 10 10 101 IV IV8 WSH_DEPARTURES VEHICLE_NUMBER Equipment Number 3075 Varchar2 20 30 111 IV IV8 WSH_DEPARTURES VEHICLE_NUMBER Packing Slip Number 3075 Varchar2 30 30 141 IV IV8 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE3 Routing Instructions 3075 Varchar2 40 150 171 IV IV8 WSH_DEPARTURES ROUTING_INSTRUCTIONS RECORD 3080 (INO) Common Key (Positions 1-91) 3080 Varchar2 91 1 Record Number 3080 Varchar2 4 92 Constant '3080' Record Layout Code 3080 Varchar2 2 96 Constant 'AHÆ Record Layout Qualifier 3080 Varchar2 3 98 Constant 'AH1Æ Header Allowance/Charge Indicator 3080 Varchar2 10 1 101 AH AH1 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_INDICATOR Header Allowance/Charge Amount 3080 Number 20 22 102 AH AH1 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_AMOUNT Header Special Services Code (Internal) 3080 Varchar2 30 10 124 AH AH1 VEH_ALLOWANCE_CHARGES SPECIAL_SERVICES_CODE Header Special Services Code(Ext1) 3080 Varchar2 40 10 134 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE1 Header Special Services Code(Ext2) 3080 Varchar2 50 10 144 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE2 Header Special Services Code(Ext3) 3080 Varchar2 60 10 154 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE3 Header Special Services Code(Ext4) 3080 Varchar2 70 10 164 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE4 Header Special Services Code(Ext5) 3080 Varchar2 80 10 174 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE5 Header Handling Code (Internal) 3080 Varchar2 90 3 184 AH AH1 VEH_ALLOWANCE_CHARGES METHOD_HANDLING_CODE Header Handling Code(External 1) 3080 Varchar2 100 10 187 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE1 Header Handling Code(External 2) 3080 Varchar2 110 10 197 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE2 Header Handling Code(External 3) 3080 Varchar2 120 10 207 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE3 Header Handling Code(External 4) 3080 Varchar2 130 10 217 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE4 Header Handling Code(External 5) 3080 Varchar2 140 10 227 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE5 Header Special Charges Code (Internal) 3080 Varchar2 150 3 237 AH AH1 VEH_ALLOWANCE_CHARGES METHOD_HANDLING_CODE Header Special Charges Code(Ext1) 3080 Varchar2 160 10 240 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE5 Header Special Charges Code(Ext1) 3080 Varchar2 170 10 250 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE5 Header Special Charges Code(Ext1) 3080 Varchar2 180 10 260 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE5 Header Special Charges Code(Ext1) 3080 Varchar2 190 10 270 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE5 Header Special Charges Code(Ext1) 3080 Varchar2 200 10 280 AH AH1 ECE_XREF_DATA XREF_EXT_VALUE5 RECORD 3090 (INO) Common Key (Positions 1-91) 3090 Varchar2 91 1 Record Number 3090 Varchar2 4 92 Constant '3090' Record Layout Code 3090 Varchar2 2 96 Constant 'AHÆ Record Layout Qualifier 3090 Varchar2 3 98 Constant 'IH2Æ Header Allowance Charge Description 3090 Varchar2 10 80 101 AH AH2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_DESC Header Agency Qualifier Code 3090 Varchar2 20 3 181 AH AH2 VEH_ALLOWANCE_CHARGES AGENCY_QUALIFIER_CODE Header Allowance Charge Rate 3090 Varchar2 30 22 184 AH AH2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_RATE Header Allowance Charge Pct Qualifier 3090 Varchar2 40 3 206 AH AH2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_PCT_QUALIFIER Header Allowance Charge Pct 3090 Varchar2 50 22 209 AH AH2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_PCT RECORD 3091 (INO) Common Key (Positions 1-91) 3091 Varchar2 91 1 Record Number 3091 Varchar2 4 92 Constant '3091' Record Layout Code 3091 Varchar2 2 96 Constant 'AHÆ Record Layout Qualifier 3091 Varchar2 3 98 Constant 'IH1Æ Header Allowance Charge Flexfield Context 3091 Varchar2 10 80 101 AH IH1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE_CATEGORY Header Allowance Charge Flexfield 1 3091 Varchar2 20 80 181 AH IH1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE1 Header Allowance Charge Flexfield 2 3091 Varchar2 30 80 261 AH IH1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE2 Header Allowance Charge Flexfield 3 3091 Varchar2 40 80 341 AH IH1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE3 Header Allowance Charge Flexfield 4 3091 Varchar2 50 80 421 AH IH1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE4 RECORD 3092 (INO) Common Key (Positions 1-91) 3092 Varchar2 91 1 Record Number 3092 Varchar2 4 92 Constant '3092' Record Layout Code 3092 Varchar2 2 96 Constant 'AHÆ Record Layout Qualifier 3092 Varchar2 3 98 Constant 'IH2Æ Header Allowance Charge Flexfield 5 3092 Varchar2 10 80 101 AH IH2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE5 Header Allowance Charge Flexfield 6 3092 Varchar2 20 80 181 AH IH2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE6 Header Allowance Charge Flexfield 7 3092 Varchar2 30 80 261 AH IH2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE7 Header Allowance Charge Flexfield 8 3092 Varchar2 40 80 341 AH IH2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE8 Header Allowance Charge Flexfield 9 3092 Varchar2 50 80 421 AH IH2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE9 RECORD 3093 (INO) Common Key (Positions 1-91) 3093 Varchar2 91 1 Record Number 3093 Varchar2 4 92 Constant '3093Æ Record Layout Code 3093 Varchar2 2 96 Constant 'AHÆ Record Layout Qualifier 3093 Varchar2 3 98 Constant 'IH3Æ Header Allowance Charge Flexfield10 3093 Varchar2 10 80 101 AH IH3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE10 Header Allowance Charge Flexfield11 3093 Varchar2 20 80 181 AH IH3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE11 Header Allowance Charge Flexfield12 3093 Varchar2 30 80 261 AH IH3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE12 Header Allowance Charge Flexfield13 3093 Varchar2 40 80 341 AH IH3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE13 Header Allowance Charge Flexfield14 3093 Varchar2 50 80 421 AH IH3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE14 RECORD 3094 (INO) Common Key (Positions 1-91) 3094 Varchar2 91 1 Record Number 3094 Varchar2 4 92 Constant '3094Æ Record Layout Code 3094 Varchar2 2 96 Constant 'AHÆ Record Layout Qualifier 3094 Varchar2 3 98 Constant 'IH4Æ Header Allowance Charge Flexfield15 3094 Varchar2 10 80 101 AH IH4 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE15 RECORD 4000 (INO) Common Key (Positions 1-91) 4000 Varchar2 91 1 Record Number 4000 Varchar2 4 92 Constant '4000' Record Layout Code 4000 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 4000 Varchar2 3 98 Constant 'IT1' Line Number 4000 Number 10 22 101 IT IT1 RA_CUSTOMER_TRX_LINES LINE_NUMBER Credited Line Number 4000 Number 20 22 123 IT IT1 RA_CUSTOMER_TRX_LINES LINE_NUMBER (Supplier) Line Part Number 4000 Varchar2 30 50 145 IT IT1 MTL_ITEM_FLEXFIELDS ITEM_NUMBER Customer Item Number 4000 Varchar2 40 50 195 IT IT1 MTL_CUSTOMER_ITEMS CUSTOMER_ITEM_NUMBER Ordered Quantity 4000 Number 50 22 245 IT IT1 RA_CUSTOMER_TRX_LINES QUANTITY_ORDERED Invoiced Quantity 4000 Number 60 22 267 IT IT1 RA_CUSTOMER_TRX_LINES QUANTITY_INVOICED UOM Code UOM 4000 Varchar2 70 3 289 IT IT1 RA_CUSTOMER_TRX_LINES UOM_CODE UOM Code (Ext1) 4000 Varchar2 80 5 292 IT IT1 ECE_XREF_DATA XREF_EXT_VALUE1 Unit Standard Price 4000 Number 90 22 297 IT IT1 RA_CUSTOMER_TRX_LINES UNIT_STANDARD_PRICE Unit Selling Price 4000 Number 100 22 319 IT IT1 RA_CUSTOMER_TRX_LINES UNIT_SELLING_PRICE Line Amount 4000 Number 110 22 341 IT IT1 RA_CUSTOMER_TRX_LINES EXTENDED_AMOUNT Credit Memo Reason 4000 Varchar2 120 30 363 IT IT1 RA_CUSTOMER_TRX_LINES REASON_CODE RECORD 4010 (INO) Common Key (Positions 1-91) 4010 Varchar2 91 1 Record Number 4010 Varchar2 4 92 Constant '4010' Record Layout Code 4010 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 4010 Varchar2 3 98 Constant 'IT2' Sales Order Number 4010 Varchar2 10 50 101 IT IT2 RA_CUSTOMER_TRX_LINES SALES_ORDER Sales Order Revision Number 4010 Number 20 22 151 IT IT2 RA_CUSTOMER_TRX_LINES SALES_ORDER_REVISION Sales Order Line Number 4010 Varchar2 30 30 173 IT IT2 RA_CUSTOMER_TRX_LINES SALES_ORDER_LINE Sales Order Date 4010 Date 40 15 203 IT IT2 RA_CUSTOMER_TRX_LINES SALES_ORDER_DATE Part Description 4010 Varchar2 50 125 218 IT IT2 RA_CUSTOMER_TRX_LINES DESCRIPTION Customer Item Description 4010 Varchar2 60 125 343 IT IT2 MTL_CUSTOMER_ITEMS CUSTOMER_ITEM_DESC RECORD 4020 (INO) Common Key (Positions 1-91) 4020 Varchar2 91 1 Record Number 4020 Varchar2 4 92 Constant '4020' Record Layout Code 4020 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 4020 Varchar2 3 98 Constant 'IT3' Sales Channel 4020 Varchar2 10 50 101 IT IT3 RA_CUSTOMER_TRX_LINES SALES_CHANNEL RECORD 4030 (INO) Common Key (Positions 1-91) 4030 Varchar2 91 1 Record Number 4030 Varchar2 4 92 Constant '4030' Record Layout Code 4030 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 4030 Varchar2 3 98 Constant 'IT4' Ship Order Status (Internal) 4030 Varchar2 10 22 101 IT IT4 SO_LINES S4 Ship Order Status (Ext 1) 4030 Varchar2 20 80 123 IT IT4 ECE_XREF_DATA XREF_EXT_VALUE1 Transaction Reference Key 4030 Varchar2 30 30 203 IT IT4 RLA_DEMAN_LINES_ALL REQUIREMENT_EXT RECORD 5000 (INO) Common Key (Positions 1-91) 5000 Varchar2 91 1 Record Number 5000 Varchar2 4 92 Constant '5000' Record Layout Code 5000 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 5000 Varchar2 3 98 Constant 'IL1' Interface Line Context 5000 Varchar2 10 30 101 A1 IL1 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_CONTEXT Interface Line Flexfield 1 5000 Varchar2 20 30 131 A1 IL1 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE1 Interface Line Flexfield 2 5000 Varchar2 30 30 161 A1 IL1 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE2 Interface Line Flexfield 3 5000 Varchar2 40 30 191 A1 IL1 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE3 Interface Line Flexfield 4 5000 Varchar2 50 30 221 A1 IL1 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE4 RECORD 5010 (INO) Common Key (Positions 1-91) 5010 Varchar2 91 1 Record Number 5010 Varchar2 4 92 Constant '5010' Record Layout Code 5010 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5010 Varchar2 3 98 Constant 'IL2' Interface Line Flexfield 5 5010 Varchar2 10 30 101 A2 IL2 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE5 Interface Line Flexfield 6 5010 Varchar2 20 30 131 A2 IL2 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE6 Interface Line Flexfield 7 5010 Varchar2 30 30 161 A2 IL2 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE7 Interface Line Flexfield 8 5010 Varchar2 40 30 191 A2 IL2 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE8 Interface Line Flexfield 9 5010 Varchar2 50 30 221 A2 IL2 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE9 RECORD 5020 (INO) Common Key (Positions 1-91) 5020 Varchar2 91 1 Record Number 5020 Varchar2 4 92 Constant '5020' Record Layout Code 5020 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5020 Varchar2 3 98 Constant 'IL3' Interface Line Flexfield 10 5020 Varchar2 10 30 101 A2 IL3 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE10 Interface Line Flexfield 11 5020 Varchar2 20 30 131 A2 IL3 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE11 Interface Line Flexfield 12 5020 Varchar2 30 30 161 A2 IL3 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE12 Interface Line Flexfield 13 5020 Varchar2 40 30 191 A2 IL3 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE13 Interface Line Flexfield 14 5020 Varchar2 50 30 221 A2 IL3 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE14 RECORD 5030 (INO) Common Key (Positions 1-91) 5030 Varchar2 91 1 Record Number 5030 Varchar2 4 92 Constant '5030' Record Layout Code 5030 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5030 Varchar2 3 98 Constant 'IL4' Interface Line Flexfield 15 5030 Varchar2 10 30 101 A2 IL4 RA_CUSTOMER_TRX_LINES INTERFACE_LINE_ATTRIBUTE15 RECORD 5040 (INO) Common Key (Positions 1-91) 5040 Varchar2 91 1 Record Number 5040 Varchar2 4 92 Constant '5040' Record Layout Code 5040 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 5040 Varchar2 3 98 Constant 'LN1' Line Flexfield Context 5040 Varchar2 10 30 101 A1 LN1 RA_CUSTOMER_TRX_LINES LINE_ATTRIBUTE_CATEGORY Line Flexfield 1 5040 Varchar2 20 80 131 A1 LN1 RA_CUSTOMER_TRX_LINES ATTRIBUTE1 Line Flexfield 2 5040 Varchar2 30 80 211 A1 LN1 RA_CUSTOMER_TRX_LINES ATTRIBUTE2 Line Flexfield 3 5040 Varchar2 40 80 291 A1 LN1 RA_CUSTOMER_TRX_LINES ATTRIBUTE3 Line Flexfield 4 5040 Varchar2 50 80 371 A1 LN1 RA_CUSTOMER_TRX_LINES ATTRIBUTE4 RECORD 5050 (INO) Common Key (Positions 1-91) 5050 Varchar2 91 1 Record Number 5050 Varchar2 4 92 Constant '5050' Record Layout Code 5050 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5050 Varchar2 3 98 Constant 'LN2' Line Flexfield 5 5050 Varchar2 10 80 101 A1 LN2 RA_CUSTOMER_TRX_LINES ATTRIBUTE5 Line Flexfield 6 5050 Varchar2 20 80 181 A1 LN2 RA_CUSTOMER_TRX_LINES ATTRIBUTE6 Line Flexfield 7 5050 Varchar2 30 80 261 A1 LN2 RA_CUSTOMER_TRX_LINES ATTRIBUTE7 Line Flexfield 8 5050 Varchar2 40 80 341 A1 LN2 RA_CUSTOMER_TRX_LINES ATTRIBUTE8 Line Flexfield 9 5050 Varchar2 50 80 421 A1 LN2 RA_CUSTOMER_TRX_LINES ATTRIBUTE9 Line Flexfield 10 5050 Varchar2 60 80 501 A1 LN2 RA_CUSTOMER_TRX_LINES ATTRIBUTE10 RECORD 5060 (INO) Common Key (Positions 1-91) 5060 Varchar2 91 1 Record Number 5060 Varchar2 4 92 Constant '5060' Record Layout Code 5060 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5060 Varchar2 3 98 Constant 'LN3' Line Flexfield 11 5060 Varchar2 10 80 101 A1 LN3 RA_CUSTOMER_TRX_LINES ATTRIBUTE11 Line Flexfield 12 5060 Varchar2 20 80 181 A1 LN3 RA_CUSTOMER_TRX_LINES ATTRIBUTE12 Line Flexfield 13 5060 Varchar2 30 80 261 A1 LN3 RA_CUSTOMER_TRX_LINES ATTRIBUTE13 Line Flexfield 14 5060 Varchar2 40 80 341 A1 LN3 RA_CUSTOMER_TRX_LINES ATTRIBUTE14 RECORD 5070 (INO) Common Key (Positions 1-91) 5070 Varchar2 91 1 Record Number 5070 Varchar2 4 92 Constant '5070' Record Layout Code 5070 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5070 Varchar2 3 98 Constant 'LN4' Line Flexfield 15 5070 Varchar2 10 80 101 A1 LN4 RA_CUSTOMER_TRX_LINES ATTRIBUTE15 RECORD 5100 (INO) Common Key (Positions 1-91) 5100 Varchar2 91 1 Record Number 5100 Varchar2 4 92 Constant '5100' Record Layout Code 5100 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 5100 Varchar2 3 98 Constant 'LP1' Line Part Flexfield Context 5100 Varchar2 10 30 101 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE_CATEGORY Line Part Flexfield 1 5100 Varchar2 20 80 131 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE1 Line Part Flexfield 2 5100 Varchar2 30 80 211 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE2 Line Part Flexfield 3 5100 Varchar2 40 80 291 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE3 Line Part Flexfield 4 5100 Varchar2 50 80 371 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE4 RECORD 5110 (INO) Common Key (Positions 1-91) 5110 Varchar2 91 1 Record Number 5110 Varchar2 4 92 Constant '5110' Record Layout Code 5110 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5110 Varchar2 3 98 Constant 'LP2' Line Part Flexfield 5 5110 Varchar2 10 80 101 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE5 Line Part Flexfield 6 5110 Varchar2 20 80 181 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE6 Line Part Flexfield 7 5110 Varchar2 30 80 261 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE7 Line Part Flexfield 8 5110 Varchar2 40 80 341 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE8 Line Part Flexfield 9 5110 Varchar2 50 80 421 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE9 RECORD 5120 (INO) Common Key (Positions 1-91) 5120 Varchar2 91 1 Record Number 5120 Varchar2 4 92 Constant '5120' Record Layout Code 5120 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5120 Varchar2 3 98 Constant 'LP3' Line Part Flexfield 10 5120 Varchar2 10 80 101 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE10 Line Part Flexfield 11 5120 Varchar2 20 80 181 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE11 Line Part Flexfield 12 5120 Varchar2 30 80 261 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE12 Line Part Flexfield 13 5120 Varchar2 40 80 341 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE13 Line Part Flexfield 14 5120 Varchar2 50 80 421 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE14 RECORD 5130 (INO) Common Key (Positions 1-91) 5130 Varchar2 91 1 Record Number 5130 Varchar2 4 92 Constant '5130' Record Layout Code 5130 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 5130 Varchar2 3 98 Constant 'LP4' Line Part Flexfield 15 5130 Varchar2 10 80 101 A2 LP4 MTL_ITEM_FLEXFIELDS ATTRIBUTE15 RECORD 6000 (INO) Common Key (Positions 1-91) 6000 Varchar2 91 1 Record Number 6000 Varchar2 4 92 Constant '6000' Record Layout Code 6000 Varchar2 2 96 Constant 'TX' Record Layout Qualifier 6000 Varchar2 3 98 Constant 'TX1' Line Type 6000 Varchar2 10 20 101 TX TX1 RA_CUSTOMER_TRX_LINES LINE_TYPE Tax Line Number 6000 Number 20 22 121 TX TX1 RA_CUSTOMER_TRX_LINES LINE_NUMBER Tax Amount 6000 Number 30 22 143 TX TX1 RA_CUSTOMER_TRX_LINES EXTENDED_AMOUNT Tax Rate 6000 Number 40 22 165 TX TX1 RA_CUSTOMER_TRX_LINES TAX_RATE Tax Precedence 6000 Number 50 22 143 TX TX1 RA_CUSTOMER_TRX_LINES TAX_PRECEDENCE Line Number 6000 Number 60 22 165 TX TX1 RA_CUSTOMER_TRX_LINES LINE_NUMBER Vat Tax Description 6000 Number 70 60 187 TX TX1 AR_VAT_TAX DESCRIPTION Vat Tax Location 6000 Number 80 60 247 TX TX1 AR_VAT_TAX LOCATION RECORD 6005 (INO) Common Key (Positions 1-91) 6005 Varchar2 91 1 Record Number 6005 Varchar2 4 92 Constant '6005' Record Layout Code 6005 Varchar2 2 96 Constant 'TX' Record Layout Qualifier 6005 Varchar2 3 98 Constant 'TX2' Tax Code (Internal) 6005 Varchar2 10 30 101 TX TX2 AR_VAT_TAX TAX_TYPE Tax Code (Ext1) 6005 Varchar2 20 50 131 TX TX2 ECE_XREF_DATA XREF_EXT_VALUE1 Tax Code (Ext2) 6005 Varchar2 30 50 181 TX TX2 ECE_XREF_DATA XREF_EXT_VALUE2 Tax Code (Ext3) 6005 Varchar2 40 50 231 TX TX2 ECE_XREF_DATA XREF_EXT_VALUE3 Tax Code (Ext4) 6005 Varchar2 50 50 281 TX TX2 ECE_XREF_DATA XREF_EXT_VALUE4 Tax Code (Ext5) 6005 Varchar2 60 50 331 TX TX2 ECE_XREF_DATA XREF_EXT_VALUE5 RECORD 6010 (INO) Common Key (Positions 1-91) 6010 Varchar2 91 1 Record Number 6010 Varchar2 4 92 Constant '6010' Record Layout Code 6010 Varchar2 2 96 Constant 'TX' Record Layout Qualifier 6010 Varchar2 3 98 Constant 'TX3' Tax Exempt Flag 6010 Varchar2 10 1 101 TX TX3 RA_CUSTOMER_TRX_LINES TAX_EXEMPT_FLAG Tax Exempt Number 6010 Varchar2 20 80 102 TX TX3 RA_CUSTOMER_TRX_LINES TAX_EXEMPT_NUMBER Tax Exempt Reason Code 6010 Varchar2 30 30 182 TX TX3 RA_CUSTOMER_TRX_LINES TAX_EXEMPT_REASON_CODE Tax Classification (Internal) 6010 Varchar2 40 30 212 TX TX3 RA_CUSTOMER_TRX_LINES TAX_CLASSIFICATION Tax Classification (Ext1) 6010 Varchar2 50 50 242 TX TX3 ECE_XREF_DATA XREF_EXT_VALUE1 Tax Classification (Ext2) 6010 Varchar2 60 50 292 TX TX3 ECE_XREF_DATA XREF_EXT_VALUE2 Tax Classification (Ext3) 6010 Varchar2 70 50 342 TX TX3 ECE_XREF_DATA XREF_EXT_VALUE3 Tax Classification (Ext4) 6010 Varchar2 80 50 392 TX TX3 ECE_XREF_DATA XREF_EXT_VALUE4 Tax Classification (Ext5) 6010 Varchar2 90 50 442 TX TX3 ECE_XREF_DATA XREF_EXT_VALUE5 RECORD 6020 (INO) Common Key (Positions 1-91) 6020 Varchar2 91 1 Record Number 6020 Varchar2 4 92 Constant '6020' Record Layout Code 6020 Varchar2 2 96 Constant 'TX' Record Layout Qualifier 6020 Varchar2 3 98 Constant 'TX4' Tax Code (Internal) 6020 Varchar2 10 80 101 TX TX4 RA_CUSTOMER_TRX_LINES TAX_CODE Tax Code (Ext1) 6020 Varchar2 20 80 181 TX TX4 ECE_XREF_DATA XREF_EXT_VALUE1 Tax Code (Ext2) 6020 Varchar2 30 50 261 TX TX4 ECE_XREF_DATA XREF_EXT_VALUE2 Tax Code (Ext3) 6020 Varchar2 40 50 311 TX TX4 ECE_XREF_DATA XREF_EXT_VALUE3 Tax Code (Ext4) 6020 Varchar2 50 50 361 TX TX4 ECE_XREF_DATA XREF_EXT_VALUE4 Tax Code (Ext5) 6020 Varchar2 60 50 411 TX TX4 ECE_XREF_DATA XREF_EXT_VALUE5 RECORD 6025 (INO) Common Key (Positions 1-91) 6025 Varchar2 91 1 Record Number 6025 Varchar2 4 92 Constant '6025' Record Layout Code 6025 Varchar2 2 96 Constant 'TX' Record Layout Qualifier 6025 Varchar2 3 98 Constant 'TX5' VAT Transaction Type (Internal) 6025 Varchar2 10 50 101 TX TX5 RA_CUSTOMER_TRX_LINES TAX_CODE VAT Transaction Type (Ext1) 6025 Varchar2 20 50 151 TX TX5 ECE_XREF_DATA XREF_EXT_VALUE1 VAT Transaction Type (Ext2) 6025 Varchar2 30 50 201 TX TX5 ECE_XREF_DATA XREF_EXT_VALUE2 VAT Transaction Type (Ext3) 6025 Varchar2 40 50 251 TX TX5 ECE_XREF_DATA XREF_EXT_VALUE3 VAT Transaction Type (Ext4) 6025 Varchar2 50 50 301 TX TX5 ECE_XREF_DATA XREF_EXT_VALUE4 VAT Transaction Type (Ext5) 6025 Varchar2 60 50 351 TX TX5 ECE_XREF_DATA XREF_EXT_VALUE5 RECORD 6030 (INO) Common Key (Positions 1-91) 6030 Varchar2 91 1 Record Number 6030 Varchar2 4 92 Constant '6030' Record Layout Code 6030 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 6030 Varchar2 3 98 Constant 'TX1' Tax Flexfield Context 6030 Varchar2 10 30 101 A1 TX1 RA_CUSTOMER_TRX_LINES ATTRIBUTE_CATEGORY Tax Flexfield 1 6030 Varchar2 20 80 131 A1 TX1 RA_CUSTOMER_TRX_LINES ATTRIBUTE1 Tax Flexfield 2 6030 Varchar2 30 80 211 A1 TX1 RA_CUSTOMER_TRX_LINES ATTRIBUTE2 Tax Flexfield 3 6030 Varchar2 40 80 291 A1 TX1 RA_CUSTOMER_TRX_LINES ATTRIBUTE3 Tax Flexfield 4 6030 Varchar2 50 80 371 A1 TX1 RA_CUSTOMER_TRX_LINES ATTRIBUTE4 RECORD 6040 (INO) Common Key (Positions 1-91) 6040 Varchar2 91 1 Record Number 6040 Varchar2 4 92 Constant '6040' Record Layout Code 6040 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 6040 Varchar2 3 98 Constant 'TX2' Tax Flexfield 5 6040 Varchar2 10 80 101 A2 TX2 RA_CUSTOMER_TRX_LINES ATTRIBUTE5 Tax Flexfield 6 6040 Varchar2 20 80 181 A2 TX2 RA_CUSTOMER_TRX_LINES ATTRIBUTE6 Tax Flexfield 7 6040 Varchar2 30 80 261 A2 TX2 RA_CUSTOMER_TRX_LINES ATTRIBUTE7 Tax Flexfield 8 6040 Varchar2 40 80 341 A2 TX2 RA_CUSTOMER_TRX_LINES ATTRIBUTE8 Tax Flexfield 9 6040 Varchar2 50 80 421 A2 TX2 RA_CUSTOMER_TRX_LINES ATTRIBUTE9 RECORD 6050 (INO) Common Key (Positions 1-91) 6050 Varchar2 91 1 Record Number 6050 Varchar2 4 92 Constant '6050' Record Layout Code 6050 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 6050 Varchar2 3 98 Constant 'TX3' Tax Flexfield 10 6050 Varchar2 10 80 101 A2 TX3 RA_CUSTOMER_TRX_LINES ATTRIBUTE10 Tax Flexfield 11 6050 Varchar2 20 80 181 A2 TX3 RA_CUSTOMER_TRX_LINES ATTRIBUTE11 Tax Flexfield 12 6050 Varchar2 30 80 261 A2 TX3 RA_CUSTOMER_TRX_LINES ATTRIBUTE12 Tax Flexfield 13 6050 Varchar2 40 80 341 A2 TX3 RA_CUSTOMER_TRX_LINES ATTRIBUTE13 Tax Flexfield 14 6050 Varchar2 50 80 421 A2 TX3 RA_CUSTOMER_TRX_LINES ATTRIBUTE14 RECORD 6060 (INO) Common Key (Positions 1-91) 6060 Varchar2 91 1 Record Number 6060 Varchar2 4 92 Constant '6060' Record Layout Code 6060 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 6060 Varchar2 3 98 Constant 'TX4' Tax Flexfield 15 6060 Varchar2 10 80 101 A2 TX4 RA_CUSTOMER_TRX_LINES ATTRIBUTE15 RECORD 6070 (INO) Common Key (Positions 1-91) 6070 Varchar2 91 1 Record Number 6070 Varchar2 4 92 Constant '6070' Record Layout Code 6070 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 6070 Varchar2 3 98 Constant 'VT1' Tax Flexfield Context 6070 Varchar2 10 30 101 A1 VT1 RA_CUSTOMER_TRX_LINES ATTRIBUTE_CATEGORY Tax Flexfield 1 6070 Varchar2 20 80 131 A1 VT1 RA_CUSTOMER_TRX_LINES ATTRIBUTE1 Tax Flexfield 2 6070 Varchar2 30 80 211 A1 VT1 RA_CUSTOMER_TRX_LINES ATTRIBUTE2 Tax Flexfield 3 6070 Varchar2 40 80 291 A1 VT1 RA_CUSTOMER_TRX_LINES ATTRIBUTE3 Tax Flexfield 4 6070 Varchar2 50 80 371 A1 VT1 RA_CUSTOMER_TRX_LINES ATTRIBUTE4 RECORD 6080 (INO) Common Key (Positions 1-91) 6080 Varchar2 91 1 Record Number 6080 Varchar2 4 92 Constant '6080' Record Layout Code 6080 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 6080 Varchar2 3 98 Constant 'VT2' Tax Flexfield 5 6080 Varchar2 10 80 101 A2 VT2 RA_CUSTOMER_TRX_LINES ATTRIBUTE5 Tax Flexfield 6 6080 Varchar2 20 80 181 A2 VT2 RA_CUSTOMER_TRX_LINES ATTRIBUTE6 Tax Flexfield 7 6080 Varchar2 30 80 261 A2 VT2 RA_CUSTOMER_TRX_LINES ATTRIBUTE7 Tax Flexfield 8 6080 Varchar2 40 80 341 A2 VT2 RA_CUSTOMER_TRX_LINES ATTRIBUTE8 Tax Flexfield 9 6080 Varchar2 50 80 421 A2 VT2 RA_CUSTOMER_TRX_LINES ATTRIBUTE9 RECORD 6090 (INO) Common Key (Positions 1-91) 6090 Varchar2 91 1 Record Number 6090 Varchar2 4 92 Constant '6090' Record Layout Code 6090 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 6090 Varchar2 3 98 Constant 'VT3' Tax Flexfield 10 6090 Varchar2 10 80 101 A2 VT3 RA_CUSTOMER_TRX_LINES ATTRIBUTE10 Tax Flexfield 11 6090 Varchar2 20 80 181 A2 VT3 RA_CUSTOMER_TRX_LINES ATTRIBUTE11 Tax Flexfield 12 6090 Varchar2 30 80 261 A2 VT3 RA_CUSTOMER_TRX_LINES ATTRIBUTE12 Tax Flexfield 13 6090 Varchar2 40 80 341 A2 VT3 RA_CUSTOMER_TRX_LINES ATTRIBUTE13 Tax Flexfield 14 6090 Varchar2 50 80 421 A2 VT3 RA_CUSTOMER_TRX_LINES ATTRIBUTE14 RECORD 6095 (INO) Common Key (Positions 1-91) 6095 Varchar2 91 1 Record Number 6095 Varchar2 4 92 Constant '6095' Record Layout Code 6095 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 6095 Varchar2 3 98 Constant 'VT4' Tax Flexfield 15 6095 Varchar2 10 80 101 A2 VT4 RA_CUSTOMER_TRX_LINES ATTRIBUTE15 RECORD 7000 (INO) Common Key (Positions 1-91) 7000 Varchar2 91 1 Record Number 7000 Varchar2 4 92 Constant '7000' Record Layout Code 7000 Varchar2 2 96 Constant 'AL' Record Layout Qualifier 7000 Varchar2 3 98 Constant 'AD1' Line Number 7000 Varchar2 10 22 98 AL AD1 RA_CUSTOMER_TRX_LINES LINE_NUMBER Allowance/Charge Indicator 7000 Varchar2 20 1 101 AL AD1 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_INDICATOR Allowance/Charge Amount 7000 Number 30 22 120 AL AD1 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_AMOUNT Special Services Code (Internal) 7000 Varchar2 40 10 102 AL AD1 VEH_ALLOWANCE_CHARGES SPECIAL_SERVICES_CODE Special Services Code (Ext1) 7000 Varchar2 50 10 142 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE1 Special Services Code (Ext2) 7000 Varchar2 60 10 112 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE2 Special Services Code (Ext3) 7000 Varchar2 70 10 152 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE3 Special Services Code (Ext4) 7000 Varchar2 80 10 122 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE4 Special Services Code (Ext5) 7000 Varchar2 90 10 162 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE5 Detail Handling Code (Internal) 7000 Varchar2 100 3 132 AL AD1 VEH_ALLOWANCE_CHARGES METHOD_HANDLING_CODE Detail Handling Code (Ext1) 7000 Varchar2 110 10 172 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE1 Detail Handling Code (Ext2) 7000 Varchar2 120 10 135 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE2 Detail Handling Code (Ext3) 7000 Varchar2 130 10 182 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE3 Detail Handling Code (Ext4) 7000 Varchar2 140 10 145 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE4 Detail Handling Code (Ext5) 7000 Varchar2 150 10 192 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE5 Special Charges Code (Internal) 7000 Varchar2 160 3 155 AL AD1 VEH_ALLOWANCE_CHARGES SPECIAL_CHARGES_CODE Special Charges Code (Ext1) 7000 Varchar2 170 10 202 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE1 Special Charges Code (Ext2) 7000 Varchar2 180 10 158 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE2 Special Charges Code (Ext3) 7000 Varchar2 190 10 212 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE3 Special Charges Code (Ext4) 7000 Varchar2 200 10 168 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE4 Special Charges Code (Ext5) 7000 Varchar2 210 10 222 AL AD1 ECE_XREF_DATA XREF_EXT_VALUE5 RECORD 7010 (INO) Common Key (Positions 1-91) 7010 Varchar2 91 1 Record Number 7010 Varchar2 4 92 Constant '7010' Record Layout Code 7010 Varchar2 2 96 Constant 'ALÆ Record Layout Qualifier 7010 Varchar2 3 98 Constant 'AD2Æ Detail Allowance Charge Description 7010 Varchar2 10 80 101 AL AD2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_DESC Detail Agency Qualifier Code 7010 Varchar2 20 3 181 AL AD2 VEH_ALLOWANCE_CHARGES AGENCY_QUALIFIER_CODE Detail Allowance Charge Rate 7010 Varchar2 30 22 184 AL AD2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_RATE Detail Allowance Charge Pct Qualifier 7010 Varchar2 40 3 206 AL AD2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_PCT_QUALIFIER Detail Allowance Charge Pct 7010 Varchar2 50 22 209 AL AD2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_PCT Detail Allowance Charge Unit of Measure 7010 Varchar2 60 3 231 AL AD2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_UOMT_CODE Detail Allowance Charge Quantity 7010 Varchar2 70 22 234 AL AD2 VEH_ALLOWANCE_CHARGES ALLOWANCE_CHARGE_QUANTITY RECORD 7100 (INO) Common Key (Positions 1-91) 7100 Varchar2 91 1 Record Number 7100 Varchar2 4 92 Constant 'Æ7100' Record Layout Code 7100 Varchar2 2 96 Constant 'ALÆ Record Layout Qualifier 7100 Varchar2 3 98 Constant 'IL1Æ Detail Allowance Charge Flexfield Context 7100 Varchar2 10 80 101 AL IL1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE_CATEGORY Detail Allowance Charge Flexfield 1 7100 Varchar2 20 80 181 AL IL1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE1 Detail Allowance Charge Flexfield 2 7100 Varchar2 30 80 261 AL IL1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE2 Detail Allowance Charge Flexfield 3 7100 Varchar2 40 80 341 AL IL1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE3 Detail Allowance Charge Flexfield 4 7100 Varchar2 50 80 421 AL IL1 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE4 RECORD 7110 (INO) Common Key (Positions 1-91) 7110 Varchar2 91 1 Record Number 7110 Varchar2 4 92 Constant '7110' Record Layout Code 7110 Varchar2 2 96 Constant 'ALÆ Record Layout Qualifier 7110 Varchar2 3 98 Constant 'IL2Æ Detail Allowance Charge Flexfield 5 7110 Varchar2 10 80 101 AL IL2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE5 Detail Allowance Charge Flexfield 6 7110 Varchar2 20 80 181 AL IL2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE6 Detail Allowance Charge Flexfield 7 7110 Varchar2 30 80 261 AL IL2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE7 Detail Allowance Charge Flexfield 8 7110 Varchar2 40 80 341 AL IL2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE8 Detail Allowance Charge Flexfield 9 7110 Varchar2 50 80 421 AL IL2 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE9 RECORD 7120 (INO) Common Key (Positions 1-91) 7120 Varchar2 91 1 Record Number 7120 Varchar2 4 92 Constant '7120Æ Record Layout Code 7120 Varchar2 2 96 Constant 'ALÆ Record Layout Qualifier 7120 Varchar2 3 98 Constant 'IL3Æ Detail Allowance Charge Flexfield10 7120 Varchar2 10 80 101 AL IL3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE10 Detail Allowance Charge Flexfield11 7120 Varchar2 20 80 181 AL IL3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE11 Detail Allowance Charge Flexfield12 7120 Varchar2 30 80 261 AL IL3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE12 Detail Allowance Charge Flexfield13 7120 Varchar2 40 80 341 AL IL3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE13 Detail Allowance Charge Flexfield14 7120 Varchar2 50 80 421 AL IL3 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE14 RECORD 7130 (INO) Common Key (Positions 1-91) 7130 Varchar2 91 1 Record Number 7130 Varchar2 4 92 Constant '7130Æ Record Layout Code 7130 Varchar2 2 96 Constant 'ALÆ Record Layout Qualifier 7130 Varchar2 3 98 Constant 'IL4Æ Detail Allowance Charge Flexfield15 7130 Varchar2 10 80 101 AL IL4 VEH_ALLOWANCE_CHARGES AC_ATTRIBUTE15
Previous | Next | Contents | Index | Navigation | Glossary | Library |