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.
Description Category Rec Format Pos Width Rec. Qual. Application Table Application Column RECORD 0010 (ADVO) Common Key (Positions 1-91) 0010 Varchar2 91 1 CT CTL Record Number 0010 Varchar2 4 92 CT CTL Constant '0010' Record Layout 0010 Varchar2 2 96 CT CTL Constant 'CT' Record Layout Qualifier 0010 Varchar2 3 98 CT CTL Constant 'CTL' Communication Method 0010 Varchar2 10 2 101 CT CTL ECE_TP_DETAILS COMMUNICATION_METHOD Test Indicator 0010 Varchar2 20 1 103 CT CTL ECE_TP_DETAILS TP_TEST_FLAG Document ID 0010 Varchar2 30 6 104 CT CTL TP_DOCUMENT_ID Document Type 0010 Varchar2 40 5 110 CT CTL DOCUMENT_TYPE Document Purpose Code 0010 Varchar2 50 2 115 CT CTL DOCUMENT_PURPOSE Document Code 0010 Varchar2 60 35 117 CT CTL DOCUMENT_CODE Trading Partner Translator Code 0010 Varchar2 70 30 152 CT CTL ECE_TP_DETAILS TRANSLATOR_CODE Trading Partner Location Code 0010 Varchar2 80 35 182 CT CTL ECE_TP_DETAILS TP_LOCATION_CODE_EXT Trading Partner Description 0010 Varchar2 90 74 217 CT CTL ECE_TP_HEADERS TP_DESCRIPTION Trading Partner Reference 1 0010 Varchar2 100 80 291 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT1 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 DOCUMENT_DATE_TIME Transaction Run ID 0010 Number 130 15 466 CT CTL RUN_ID Transaction Control 1 (Inbound) 0010 Number 140 10 481 CT CTL TRANSACTION_CONTROL1 Transaction Control 2 (Inbound) 0010 Number 150 10 491 CT CTL TRANSACTION_CONTROL2 Transaction Control 3 (Inbound) 0010 Number 160 10 501 CT CTL TRANSACTION_CONTROL3 RECORD 0020 (ADVO) Common Key (Positions 1-91) 0020 Varchar2 91 1 A1 TH1 Record Number 0020 Varchar2 4 92 A1 TH1 Constant '0020' Record Layout 0020 Varchar2 2 96 A1 TH1 Constant 'A1' Record Layout Qualifier 0020 Varchar2 3 98 A1 TH1 Constant 'TH1' Trading Partner Header Flexfield Context 0020 Varchar2 10 30 101 A1 TH1 ECE_ADVO_HEADER_V TPH_ATTRIBUTE_CATEGORY Trading Partner Header Flexfield 1 0020 Varchar2 20 80 131 A1 TH1 ECE_ADVO_HEADER_V TPH_ATTRIBUTE1 Trading Partner Header Flexfield 2 0020 Varchar2 30 80 211 A1 TH1 ECE_ADVO_HEADER_V TPH_ATTRIBUTE2 Trading Partner Header Flexfield 3 0020 Varchar2 40 80 291 A1 TH1 ECE_ADVO_HEADER_V TPH_ATTRIBUTE3 Trading Partner Header Flexfield 4 0020 Varchar2 50 80 371 A1 TH1 ECE_ADVO_HEADER_V TPH_ATTRIBUTE4 RECORD 0030 (ADVO) Common Key (Positions 1-91) 0030 Varchar2 91 1 A2 TH2 Record Number 0030 Varchar2 4 92 A2 TH2 Constant '0030' Record Layout 0030 Varchar2 2 96 A2 TH2 Constant 'A2' Record Layout Qualifier 0030 Varchar2 3 98 A2 TH2 Constant 'TH2' Trading Partner Header Flexfield 5 0030 Varchar2 10 80 101 A2 TH2 ECE_ADVO_HEADER_V TPH_ATTRIBUTE5 Trading Partner Header Flexfield 6 0030 Varchar2 20 80 181 A2 TH2 ECE_ADVO_HEADER_V TPH_ATTRIBUTE6 Trading Partner Header Flexfield 7 0030 Varchar2 30 80 261 A2 TH2 ECE_ADVO_HEADER_V TPH_ATTRIBUTE7 Trading Partner Header Flexfield 8 0030 Varchar2 40 80 341 A2 TH2 ECE_ADVO_HEADER_V TPH_ATTRIBUTE8 Trading Partner Header Flexfield 9 0030 Varchar2 50 80 421 A2 TH2 ECE_ADVO_HEADER_V TPH_ATTRIBUTE9 RECORD 0040 (ADVO) Common Key (Positions 1-91) 0040 Varchar2 91 1 A2 TH3 Record Number 0040 Varchar2 4 92 A2 TH3 Constant '0040' Record Layout 0040 Varchar2 2 96 A2 TH3 Constant 'A2' Record Layout Qualifier 0040 Varchar2 3 98 A2 TH3 Constant 'TH3' Trading Partner Header Flexfield 10 0040 Varchar2 10 80 101 A2 TH3 ECE_ADVO_HEADER_V TPH_ATTRIBUTE10 Trading Partner Header Flexfield 11 0040 Varchar2 20 80 181 A2 TH3 ECE_ADVO_HEADER_V TPH_ATTRIBUTE11 Trading Partner Header Flexfield 12 0040 Varchar2 30 80 261 A2 TH3 ECE_ADVO_HEADER_V TPH_ATTRIBUTE12 Trading Partner Header Flexfield 13 0040 Varchar2 40 80 341 A2 TH3 ECE_ADVO_HEADER_V TPH_ATTRIBUTE13 Trading Partner Header Flexfield 14 0050 Varchar2 50 80 421 A2 TH3 ECE_ADVO_HEADER_V TPH_ATTRIBUTE14 RECORD 0050 (ADVO) Common Key (Positions 1-91) 0050 Varchar2 91 1 A2 TH4 Record Number 0050 Varchar2 4 92 A2 TH4 Constant '0050' Record Layout 0050 Varchar2 2 96 A2 TH4 Constant 'A2' Record Layout Qualifier 0050 Varchar2 3 98 A2 TH4 Constant 'TH4' Trading Partner Header Flexfield 15 0050 Varchar2 10 80 101 A2 TH4 ECE_ADVO_HEADER_V TPH_ATTRIBUTE15 RECORD 1000 (ADVO) Common Key (Positions 1-91) 1000 Varchar2 91 1 HD EX1 Record Number 1000 Varchar2 4 92 HD EX1 Constant '1000' Record Layout 1000 Varchar2 2 96 HD EX1 Constant 'HD' Record Layout Qualifier 1000 Varchar2 3 98 HD EX1 Constant 'EX1' Related Document ID 1000 Varchar2 10 6 101 HD EX1 ECE_ADVO_HEADER_V RELATED_DOCUMENT_ID Advice Header External Reference 1 1000 Varchar2 20 80 107 HD EX1 ECE_ADVO_HEADER_V HDR_EXTERNAL_REFERENCE1 Advice Header External Reference 2 1000 Varchar2 30 80 187 HD EX1 ECE_ADVO_HEADER_V HDR_EXTERNAL_REFERENCE2 Advice Header External Reference 3 1000 Varchar2 40 80 267 HD EX1 ECE_ADVO_HEADER_V HDR_EXTERNAL_REFERENCE3 Advice Header External Reference 4 1000 Varchar2 50 80 347 HD EX1 ECE_ADVO_HEADER_V HDR_EXTERNAL_REFERENCE4 RECORD 1010 (ADVO) Common Key (Positions 1-91) 1010 Varchar2 91 1 HD EX2 Record Number 1010 Varchar2 4 92 HD EX2 Constant '1010' Record Layout 1010 Varchar2 2 96 HD EX2 Constant 'HD' Record Layout Qualifier 1010 Varchar2 3 98 HD EX2 Constant 'EX2' Advice Header External Reference 5 1010 Varchar2 10 80 101 HD EX2 ECE_ADVO_HEADER_V HDR_EXTERNAL_REFERENCE5 Advice Header External Reference 6 1010 Varchar2 20 80 181 HD EX2 ECE_ADVO_HEADER_V HDR_EXTERNAL_REFERENCE6 RECORD 1020 (ADVO) Common Key (Positions 1-91) 1020 Varchar2 91 1 HD IN1 Record Number 1020 Varchar2 4 92 HD IN1 Constant '1020' Record Layout 1020 Varchar2 2 96 HD IN1 Constant 'HD' Record Layout Qualifier 1020 Varchar2 3 98 HD IN1 Constant 'IN1' Advice Header Internal Reference 1 1020 Varchar2 10 80 101 HD IN1 ECE_ADVO_HEADER_V HDR_INTERNAL_REFERENCE1 Advice Header Internal Reference 2 1020 Varchar2 20 80 181 HD IN1 ECE_ADVO_HEADER_V HDR_INTERNAL_REFERENCE2 Advice Header Internal Reference 3 1020 Varchar2 30 80 261 HD IN1 ECE_ADVO_HEADER_V HDR_INTERNAL_REFERENCE3 Advice Header Internal Reference 4 1020 Varchar2 40 80 341 HD IN1 ECE_ADVO_HEADER_V HDR_INTERNAL_REFERENCE4 Advice Header Internal Reference 5 1020 Varchar2 50 80 421 HD IN1 ECE_ADVO_HEADER_V HDR_INTERNAL_REFERENCE5 RECORD 1030 (ADVO) Common Key (Positions 1-91) 1030 Varchar2 91 1 HD IN2 Record Number 1030 Varchar2 4 92 HD IN2 Constant '1030' Record Layout 1030 Varchar2 2 96 HD IN2 Constant 'HD' Record Layout Qualifier 1030 Varchar2 3 98 HD IN2 Constant 'IN2' Advice Header Internal Reference 6 1030 Varchar2 10 80 101 HD IN2 ECE_ADVO_HEADER_V HDR_INTERNAL_REFERENCE6 RECORD 1040 (ADVO) Common Key (Positions 1-91) 1040 Varchar2 91 1 AD TP1 Record Number 1040 Varchar2 4 92 AD TP1 Constant '1040' Record Layout 1040 Varchar2 2 96 AD TP1 Constant 'AD' Record Layout Qualifier 1040 Varchar2 3 98 AD TP1 Constant 'TP1' Trading Partner Code (Internal) SITE_TP 1040 Varchar2 10 20 101 AD TP1 ECE_ADVO_HEADER_V TP_CODE_INTERNAL Trading Partner Code (Ext1) 1040 Varchar2 20 20 121 AD TP1 ECE_ADVO_HEADER_V TP_CODE_EXTERNAL Trading Partner Name 1040 Varchar2 30 60 141 AD TP1 ECE_ADVO_HEADER_V TP_NAME Trading Partner Address 1 1040 Varchar2 40 35 201 AD TP1 ECE_ADVO_HEADER_V TP_ADDRESS1 Trading Partner Address 2 1040 Varchar2 50 35 236 AD TP1 ECE_ADVO_HEADER_V TP_ADDRESS2 Trading Partner Address 3 1040 Varchar2 60 35 271 AD TP1 ECE_ADVO_HEADER_V TP_ADDRESS3 Trading Partner Address 4 1040 Varchar2 70 35 306 AD TP1 ECE_ADVO_HEADER_V TP_ADDRESS4 Trading Partner City 1040 Varchar2 80 30 341 AD TP1 ECE_ADVO_HEADER_V TP_CITY Trading Partner Postal Code 1040 Varchar2 90 15 371 AD TP1 ECE_ADVO_HEADER_V TP_POSTAL_CODE Trading Partner Country (Internal) COUNTRY 1040 Varchar2 100 20 386 AD TP1 ECE_ADVO_HEADER_V TP_COUNTRY_INT Trading Partner Country (Ext1) 1040 Varchar2 110 3 406 AD TP1 ECE_ADVO_HEADER_V TP_COUNTRY_EXT Trading Partner State (Internal) STATE 1040 Varchar2 120 20 409 AD TP1 ECE_ADVO_HEADER_V TP_STATE_INT Trading Partner State (Ext1) 1040 Varchar2 130 10 429 AD TP1 ECE_ADVO_HEADER_V TP_STATE_EXT Trading Partner Province (Internal) PROVINCE 1040 Varchar2 140 20 439 AD TP1 ECE_ADVO_HEADER_V TP_PROVINCE_INT Trading Partner Province (Ext1) 1040 Varchar2 150 10 459 AD TP1 ECE_ADVO_HEADER_V TP_PROVINCE_EXT Trading Partner County 1040 Varchar2 160 60 469 AD TP1 ECE_ADVO_HEADER_V TP_COUNTY_INT RECORD 2000 (ADVO) Common Key (Positions 1-91) 2000 Varchar2 91 1 DT EX1 Record Number 2000 Varchar2 4 92 DT EX1 Constant '2000' Record Layout 2000 Varchar2 2 96 DT EX1 Constant 'DT' Record Layout Qualifier 2000 Varchar2 3 98 DT EX1 Constant 'EX1' Advice Date/Time 2000 Date 10 15 101 DT EX1 ECE_ADVO_DETAIL_V DTL_HDR_DATE_TIME Advice Status 2000 Varchar2 20 30 116 DT EX1 ECE_ADVO_DETAIL_V DTL_HDR_STATUS Advice Detail External Reference 1 2000 Varchar2 30 80 146 DT EX1 ECE_ADVO_DETAIL_V DTL_EXTERNAL_REFERENCE1 Advice Detail External Reference 2 2000 Varchar2 40 80 226 DT EX1 ECE_ADVO_DETAIL_V DTL_EXTERNAL_REFERENCE2 Advice Detail External Reference 3 2000 Varchar2 50 80 306 DT EX1 ECE_ADVO_DETAIL_V DTL_EXTERNAL_REFERENCE3 Advice Detail External Reference 4 2000 Varchar2 60 80 386 DT EX1 ECE_ADVO_DETAIL_V DTL_EXTERNAL_REFERENCE4 RECORD 2010 (ADVO) Common Key (Positions 1-91) 2010 Varchar2 91 1 DT EX2 Record Number 2010 Varchar2 4 92 DT EX2 Constant '2010' Record Layout 2010 Varchar2 2 96 DT EX2 Constant 'DT' Record Layout Qualifier 2010 Varchar2 3 98 DT EX2 Constant 'EX2' Advice Detail External Reference 5 2010 Varchar2 10 80 101 DT EX2 ECE_ADVO_DETAIL_V DTL_EXTERNAL_REFERENCE5 Advice Detail External Reference 6 2010 Varchar2 20 80 181 DT EX2 ECE_ADVO_DETAIL_V DTL_EXTERNAL_REFERENCE6 RECORD 2020 (ADVO) Common Key (Positions 1-91) 2020 Varchar2 91 1 DT IN1 Record Number 2020 Varchar2 4 92 DT IN1 Constant '2020' Record Layout 2020 Varchar2 2 96 DT IN1 Constant 'DT' Record Layout Qualifier 2020 Varchar2 3 98 DT IN1 Constant 'IN1' Advice Detail Internal Reference 1 2020 Varchar2 10 80 101 DT IN1 ECE_ADVO_DETAIL_V DTL_INTERNAL_REFERENCE1 Advice Detail Internal Reference 2 2020 Varchar2 20 80 181 DT IN1 ECE_ADVO_DETAIL_V DTL_INTERNAL_REFERENCE2 Advice Detail Internal Reference 3 2020 Varchar2 30 80 261 DT IN1 ECE_ADVO_DETAIL_V DTL_INTERNAL_REFERENCE3 Advice Detail Internal Reference 4 2020 Varchar2 40 80 341 DT IN1 ECE_ADVO_DETAIL_V DTL_INTERNAL_REFERENCE4 Advice Detail Internal Reference 5 2020 Varchar2 50 80 421 DT IN1 ECE_ADVO_DETAIL_V DTL_INTERNAL_REFERENCE5 RECORD 2030 (ADVO) Common Key (Positions 1-91) 2030 Varchar2 91 1 DT IN2 Record Number 2030 Varchar2 4 92 DT IN2 Constant '2030' Record Layout 2030 Varchar2 2 96 DT IN2 Constant 'DT' Record Layout Qualifier 2030 Varchar2 3 98 DT IN2 Constant 'IN2' Advice Detail Internal Reference 6 2030 Varchar2 10 80 101 DT IN2 ECE_ADVO_DETAIL_V DTL_INTERNAL_REFERENCE6 RECORD 2040 (ADVO) Common Key (Positions 1-91) 2040 Varchar2 91 1 ER ER1 Record Number 2040 Varchar2 4 92 ER ER1 Constant '2040' Record Layout 2040 Varchar2 2 96 ER ER1 Constant 'ER' Record Layout Qualifier 2040 Varchar2 3 98 ER ER1 Constant 'ER1' Advice Message Code 2040 Varchar2 10 60 101 ER ER1 ECE_ADVO_DETAIL_V ADVO_MESSAGE_CODE Advice Message Description 2040 Varchar2 20 80 161 ER ER1 ECE_ADVO_DETAIL_V ADVO_MESSAGE_DESC Advice Data (Errored) 2040 Varchar2 30 240 241 ER ER1 ECE_ADVO_DETAIL_V ADVO_DATA_BAD RECORD 2050 (ADVO) Common Key (Positions 1-91) 2050 Varchar2 91 1 AC AC1 Record Number 2050 Varchar2 4 92 AC AC1 Constant '2050' Record Layout 2050 Varchar2 2 96 AC AC1 Constant 'AC' Record Layout Qualifier 2050 Varchar2 3 98 AC AC1 Constant 'AC1' Advice Data (Accepted) 2050 Varchar2 10 240 101 AC AC1 ECE_ADVO_DETAIL_V ADVO_DATA_GOOD
Previous | Next | Contents | Index | Navigation | Glossary | Library |