|
|
|
|
|
|
|
|
|
| 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 RecQualApplication Table Application Column RECORD 0010 (POO) 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 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 PO_HEADERS TYPE_LOOKUP_CODE Document Purpose Code 0010 Varchar2 50 2 115 CT CTL Document Code 0010 Varchar2 60 35 117 CT CTL PO_HEADERS SEGMENT1 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_HEADERS 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 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 (POO) 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 '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 (POO) 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 'A2' Record Layout Qualifier 0030 Varchar2 3 98 Constant 'TH2' Trading Partner Flexfield 5 0030 Varchar2 10 80 101 A1 TH2 ECE_TP_HEADERS ATTRIBUTE5 Trading Partner Flexfield 6 0030 Varchar2 20 80 181 A1 TH2 ECE_TP_HEADERS ATTRIBUTE6 Trading Partner Flexfield 7 0030 Varchar2 30 80 261 A1 TH2 ECE_TP_HEADERS ATTRIBUTE7 Trading Partner Flexfield 8 0030 Varchar2 40 80 341 A1 TH2 ECE_TP_HEADERS ATTRIBUTE8 Trading Partner Flexfield 9 0030 Varchar2 50 80 421 A1 TH2 ECE_TP_HEADERS ATTRIBUTE9 RECORD 0040 (POO) 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 '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 (POO) 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 '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 (POO) 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 'PO' Record Layout Qualifier 1000 Varchar2 3 98 Constant 'PO1' Purchase Order Number 1000 Varchar2 10 40 101 PO PO1 PO_HEADERS SEGMENT1 Release Number 1000 Number 20 22 141 PO PO1 PO_RELEASES RELEASE_NUM Release Date 1000 Date 30 15 163 PO PO1 PO_RELEASES RELEASE_DATE Creation Date 1000 Date 40 15 178 PO PO1 PO_HEADERS CREATION_DATE Purchase Order Revision Number 1000 Number 50 22 193 PO PO1 PO_HEADERS REVISION_NUM Purchase Order Revision Date 1000 Date 60 15 215 PO PO1 PO_HEADERS REVISED_DATE Purchase Order Description 1000 Varchar2 70 80 230 PO PO1 PO_HEADERS COMMENTS Purchase Order Type 1000 Varchar2 80 10 310 PO PO1 PO_HEADERS TYPE_LOOKUP_CODE RECORD 1010 (POO) 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 'PO' Record Layout Qualifier 1010 Varchar2 3 98 Constant 'PO2' Payment Terms (Internal) PAY_TERMS 1010 Varchar2 10 50 101 PO PO2 AP_TERMS NAME Payment Terms (Ext1) 1010 Varchar2 20 22 151 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE1 Payment Terms (Ext2) 1010 Varchar2 30 15 173 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE2 Payment Terms (Ext3) 1010 Varchar2 40 3 188 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE3 Payment Terms (Ext4) 1010 Varchar2 50 3 191 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE4 Payment Terms (Ext5) 1010 Varchar2 60 3 194 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE5 Purchase Order Currency Code (Inte CURRENCY 1010 Varchar2 70 15 197 PO PO2 PO_HEADERS CURRENCY_CODE Purchase Order Currency Code (Ext1 1010 Varchar2 80 3 212 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE1 Currency Exchange Rate 1010 Number 90 22 215 PO PO2 PO_HEADERS RATE Purchase Order Ship Via (Internal) SHIP_VIA 1010 Varchar2 100 25 237 PO PO2 PO_HEADERS SHIP_VIA_LOOKUP_CODE Purchase Order Ship Via (Ext1) 1010 Varchar2 110 20 262 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE1 Purchase Order Ship Via (Ext2) 1010 Varchar2 120 20 282 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE2 Purchase Order Ship Via (Ext3) 1010 Varchar2 130 80 302 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE3 Purchase Order FOB Code (Internal) FOB 1010 Varchar2 140 25 382 PO PO2 PO_HEADERS FOB_LOOKUP_CODE Purchase Order FOB Code (Ext1) 1010 Varchar2 150 10 407 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE1 Purchase Order Freight Terms (Inte FREIGHT_TERMS 1010 Varchar2 160 25 417 PO PO2 PO_HEADERS FREIGHT_TERMS_LOOKUP_CODE Purchase Order Freight Terms (Ext1 1010 Varchar2 170 10 442 PO PO2 ECE_XREF_DATA XREF_EXT_VALUE1 Purchase Order Canceled Flag 1010 Varchar2 180 1 452 PO PO2 PO_HEADERS CANCEL_FLAG Purchase Order Acceptance Required Flag 1010 Varchar2 190 1 453 PO PO2 PO_HEADERS ACCEPTANCE_REQUIRED_FLAG Purchase Order Acceptance Due By Date 1010 Date 200 15 454 PO PO2 PO_HEADERS ACCEPTANCE_DUE_DATE Purchase Order Confirming Order flag 1010 Varchar2 210 1 469 PO PO2 PO_HEADERS CONFIRMING_ORDER_FLAG RECORD 1020 (POO) 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 'PO' Record Layout Qualifier 1020 Varchar2 3 98 Constant 'PO3' Blanket Start Date 1020 Date 10 15 101 PO PO3 PO_HEADERS START_DATE Blanket End Date 1020 Date 20 15 116 PO PO3 PO_HEADERS END_DATE Blanket Total Amount 1020 Date 30 22 131 PO PO3 PO_HEADERS BLANKET_TOTAL_AMOUNT Supplier Number 1020 Varchar2 40 30 153 PO PO3 PO_VENDORS SEGMENT1 Supplier Name 1020 Varchar2 50 80 183 PO PO3 PO_VENDORS VENDOR_NAME RECORD 1030 (POO) 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 'PO' Record Layout Qualifier 1030 Varchar2 3 98 Constant 'PO4' Purchase Order Notes to Supplier 1030 Varchar2 10 80 101 PO PO4 PO_HEADERS NOTE_TO_VENDOR RECORD 1040 (POO) 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 'A1' Record Layout Qualifier 1040 Varchar2 3 98 Constant 'PO1' Purchase Order Flexfield Context 1040 Varchar2 10 30 101 A1 PO1 PO_HEADERS ATTRIBUTE_CATEGORY Purchase Order Flexfield 1 1040 Varchar2 20 80 131 A1 PO1 PO_HEADERS ATTRIBUTE1 Purchase Order Flexfield 2 1040 Varchar2 30 80 211 A1 PO1 PO_HEADERS ATTRIBUTE2 Purchase Order Flexfield 3 1040 Varchar2 40 80 291 A1 PO1 PO_HEADERS ATTRIBUTE3 Purchase Order Flexfield 4 1040 Varchar2 50 80 371 A1 PO1 PO_HEADERS ATTRIBUTE4 RECORD 1050 (POO) 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 'PO2' Purchase Order Flexfield 5 1050 Varchar2 10 80 101 A2 PO2 PO_HEADERS ATTRIBUTE5 Purchase Order Flexfield 6 1050 Varchar2 20 80 181 A2 PO2 PO_HEADERS ATTRIBUTE6 Purchase Order Flexfield 7 1050 Varchar2 30 80 261 A2 PO2 PO_HEADERS ATTRIBUTE7 Purchase Order Flexfield 8 1050 Varchar2 40 80 341 A2 PO2 PO_HEADERS ATTRIBUTE8 Purchase Order Flexfield 9 1050 Varchar2 50 80 421 A2 PO2 PO_HEADERS ATTRIBUTE9 RECORD 1060 (POO) 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 'A2' Record Layout Qualifier 1060 Varchar2 3 98 Constant 'PO3' Purchase Order Flexfield 10 1060 Varchar2 10 80 101 A2 PO3 PO_HEADERS ATTRIBUTE10 Purchase Order Flexfield 11 1060 Varchar2 20 80 181 A2 PO3 PO_HEADERS ATTRIBUTE11 Purchase Order Flexfield 12 1060 Varchar2 30 80 261 A2 PO3 PO_HEADERS ATTRIBUTE12 Purchase Order Flexfield 13 1060 Varchar2 40 80 341 A2 PO3 PO_HEADERS ATTRIBUTE13 Purchase Order Flexfield 14 1060 Varchar2 50 80 421 A2 PO3 PO_HEADERS ATTRIBUTE14 RECORD 1070 (POO) 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 'PO4' Purchase Order Flexfield 15 1070 Varchar2 10 80 101 A2 PO4 PO_HEADERS ATTRIBUTE15 RECORD 1080 (POO) 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 'A1' Record Layout Qualifier 1080 Varchar2 3 98 Constant 'SU1' Supplier Flexfield Context 1080 Varchar2 10 30 101 A1 SU1 PO_VENDORS ATTRIBUTE_CATEGORY Supplier Flexfield 1 1080 Varchar2 20 80 131 A1 SU1 PO_VENDORS ATTRIBUTE1 Supplier Flexfield 2 1080 Varchar2 30 80 211 A1 SU1 PO_VENDORS ATTRIBUTE2 Supplier Flexfield 3 1080 Varchar2 40 80 291 A1 SU1 PO_VENDORS ATTRIBUTE3 Supplier Flexfield 4 1080 Varchar2 50 80 371 A1 SU1 PO_VENDORS ATTRIBUTE4 RECORD 1090 (POO) 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 'SU2' Supplier Flexfield 5 1090 Varchar2 10 80 101 A2 SU2 PO_VENDORS ATTRIBUTE5 Supplier Flexfield 6 1090 Varchar2 20 80 181 A2 SU2 PO_VENDORS ATTRIBUTE6 Supplier Flexfield 7 1090 Varchar2 30 80 261 A2 SU2 PO_VENDORS ATTRIBUTE7 Supplier Flexfield 8 1090 Varchar2 40 80 341 A2 SU2 PO_VENDORS ATTRIBUTE8 Supplier Flexfield 9 1090 Varchar2 50 80 421 A2 SU2 PO_VENDORS ATTRIBUTE9 RECORD 1100 (POO) 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 'A2' Record Layout Qualifier 1100 Varchar2 3 98 Constant 'SU3' Supplier Flexfield 10 1100 Varchar2 10 80 101 A2 SU3 PO_VENDORS ATTRIBUTE10 Supplier Flexfield 11 1100 Varchar2 20 80 181 A2 SU3 PO_VENDORS ATTRIBUTE11 Supplier Flexfield 12 1100 Varchar2 30 80 261 A2 SU3 PO_VENDORS ATTRIBUTE12 Supplier Flexfield 13 1100 Varchar2 40 80 341 A2 SU3 PO_VENDORS ATTRIBUTE13 Supplier Flexfield 14 1100 Varchar2 50 80 421 A2 SU3 PO_VENDORS ATTRIBUTE14 RECORD 1110 (POO) Common Key (Positions 1-91) 1110 Varchar2 91 1 Record Number 1110 Varchar2 4 92 Constant '1110' Record Layout Code 1110 Varchar2 2 96 A2 SU4 Constant 'A2' Record Layout Qualifier 1110 Varchar2 3 98 A2 SU4 Constant 'SU4' Supplier Flexfield 15 1110 Varchar2 10 80 101 A2 SU4 PO_VENDORS ATTRIBUTE15 RECORD 1120 (POO) Common Key (Positions 1-91) 1120 Varchar2 91 1 Record Number 1120 Varchar2 4 92 Constant '1120' Record Layout Code 1120 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1120 Varchar2 3 98 Constant 'SS1' Supplier Site Flexfield Context 1120 Varchar2 10 30 101 A1 SS1 PO_VENDOR_SITES ATTRIBUTE_CATEGORY Supplier Site Flexfield 1 1120 Varchar2 20 80 131 A1 SS1 PO_VENDOR_SITES ATTRIBUTE1 Supplier Site Flexfield 2 1120 Varchar2 30 80 211 A1 SS1 PO_VENDOR_SITES ATTRIBUTE2 Supplier Site Flexfield 3 1120 Varchar2 40 80 291 A1 SS1 PO_VENDOR_SITES ATTRIBUTE3 Supplier Site Flexfield 4 1120 Varchar2 50 80 371 A1 SS1 PO_VENDOR_SITES ATTRIBUTE4 RECORD 1130 (POO) Common Key (Positions 1-91) 1130 Varchar2 91 1 Record Number 1130 Varchar2 4 92 Constant '1130' Record Layout Code 1130 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1130 Varchar2 3 98 Constant 'SS2' Supplier Site Flexfield 5 1130 Varchar2 10 80 101 A2 SS2 PO_VENDOR_SITES ATTRIBUTE5 Supplier Site Flexfield 6 1130 Varchar2 20 80 181 A2 SS2 PO_VENDOR_SITES ATTRIBUTE6 Supplier Site Flexfield 7 1130 Varchar2 30 80 261 A2 SS2 PO_VENDOR_SITES ATTRIBUTE7 Supplier Site Flexfield 8 1130 Varchar2 40 80 341 A2 SS2 PO_VENDOR_SITES ATTRIBUTE8 Supplier Site Flexfield 9 1130 Varchar2 50 80 421 A2 SS2 PO_VENDOR_SITES ATTRIBUTE9 RECORD 1140 (POO) Common Key (Positions 1-91) 1140 Varchar2 91 1 Record Number 1140 Varchar2 4 92 Constant '1140' Record Layout Code 1140 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1140 Varchar2 3 98 Constant 'SS3' Supplier Site Flexfield 10 1140 Varchar2 10 80 101 A2 SS3 PO_VENDOR_SITES ATTRIBUTE10 Supplier Site Flexfield 11 1140 Varchar2 20 80 181 A2 SS3 PO_VENDOR_SITES ATTRIBUTE11 Supplier Site Flexfield 12 1140 Varchar2 30 80 261 A2 SS3 PO_VENDOR_SITES ATTRIBUTE12 Supplier Site Flexfield 13 1140 Varchar2 40 80 341 A2 SS3 PO_VENDOR_SITES ATTRIBUTE13 Supplier Site Flexfield 14 1140 Varchar2 50 80 421 A2 SS3 PO_VENDOR_SITES ATTRIBUTE14 RECORD 1150 (POO) Common Key (Positions 1-91) 1150 Varchar2 91 1 Record Number 1150 Varchar2 4 92 Constant '1150' Record Layout Code 1150 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1150 Varchar2 3 98 Constant 'SS4' Supplier Site Flexfield 15 1150 Varchar2 10 80 101 A2 SS4 PO_VENDOR_SITES ATTRIBUTE15 RECORD 1160 (POO) Common Key (Positions 1-91) 1160 Varchar2 91 1 Record Number 1160 Varchar2 4 92 Constant '1160' Record Layout Code 1160 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1160 Varchar2 3 98 Constant 'SU1' Supplier Customer Number 1160 Varchar2 10 20 101 AD SU1 PO_VENDORS CUSTOMER_NUM Supplier Code (Internal) 1160 Number 20 22 121 AD SU1 PO_HEADERS VENDOR_SITE_ID Supplier Code (Ext) 1160 Varchar2 25 20 143 AD SU1 Supplier Name 1160 Varchar2 30 60 163 AD SU1 PO_HEADERS Supplier Site Address Line 1 1160 Varchar2 40 35 223 AD SU1 PO_VENDOR_SITES ADDRESS_LINE1 Supplier Site Address Line 2 1160 Varchar2 50 35 258 AD SU1 PO_VENDOR_SITES ADDRESS_LINE2 Supplier Site Address Line 3 1160 Varchar2 60 35 293 AD SU1 PO_VENDOR_SITES ADDRESS_LINE3 Supplier Site Address Line 4 1160 Varchar2 70 35 328 AD SU1 PO_VENDOR_SITES ADDRESS_LINE4 Supplier Site City 1160 Varchar2 80 30 363 AD SU1 PO_VENDOR_SITES CITY Supplier Site Zip 1160 Varchar2 90 15 393 AD SU1 PO_VENDOR_SITES ZIP Supplier Site Country (Internal) COUNTRY 1160 Varchar2 100 20 408 AD SU1 PO_VENDOR_SITES COUNTRY Supplier Site Country (Ext1) 1160 Varchar2 110 3 428 AD SU1 ECE_XREF_DATA XREF_EXT_VALUE1 Supplier Site State (Internal) STATE 1160 Varchar2 120 20 431 AD SU1 PO_VENDOR_SITES STATE Supplier Site State (Ext1) 1160 Varchar2 130 10 451 AD SU1 ECE_XREF_DATA XREF_EXT_VALUE1 Supplier Site Province (Internal) PROVINCE 1160 Varchar2 140 20 461 AD SU1 PO_VENDOR_SITES PROVINCE Supplier Site Province (Ext1) 1160 Varchar2 150 10 481 AD SU1 ECE_XREF_DATA XREF_EXT_VALUE1 RECORD 1170 (POO) Common Key (Positions 1-91) 1170 Varchar2 91 1 Record Number 1170 Varchar2 4 92 Constant '1170' Record Layout Code 1170 Varchar2 2 96 Constant 'CN' Record Layout Qualifier 1170 Varchar2 3 98 Constant 'SS1' Supplier Site Contact Last Name 1170 Varchar2 10 50 101 CN SS1 Supplier Site Contact First Name 1170 Varchar2 20 50 151 CN SS1 Supplier Site Area Code 1170 Varchar2 30 10 201 CN SS1 PO_VENDOR_SITES AREA_CODE Supplier Site Phone 1170 Varchar2 40 60 211 CN SS1 PO_VENDOR_SITES PHONE Supplier Site Fax Area Code 1170 Varchar2 50 10 271 CN SS1 PO_VENDOR_SITES FAX_AREA_CODE Supplier Site Fax 1170 Varchar2 60 60 281 CN SS1 PO_VENDOR_SITES FAX Supplier Site Telex Area Code 1170 Varchar2 70 10 341 CN SS1 Supplier Site Telex 1170 Varchar2 80 60 351 CN SS1 PO_VENDOR_SITES TELEX RECORD 1180 (POO) Common Key (Positions 1-91) 1180 Varchar2 91 1 Record Number 1180 Varchar2 4 92 Constant '1180' Record Layout Code 1180 Varchar2 2 96 Constant 'CN' Record Layout Qualifier 1180 Varchar2 3 98 Constant 'SS2' Supplier Contact Last Name 1180 Varchar2 10 50 101 CN SS2 PO_VENDOR_CONTACTS LAST_NAME Supplier Contact First Name 1180 Varchar2 20 50 151 CN SS2 PO_VENDOR_CONTACTS FIRST_NAME Supplier Contact Job Title 1180 Varchar2 30 40 201 CN SS2 PO_VENDOR_CONTACTS TITLE Supplier Contact Area Code 1180 Varchar2 40 10 241 CN SS2 PO_VENDOR_CONTACTS AREA_CODE Supplier Contact Phone 1180 Varchar2 50 60 251 CN SS2 PO_VENDOR_CONTACTS PHONE Supplier Contact Fax Area Code 1180 Varchar2 60 10 311 CN SS2 Supplier Contact Fax 1180 Varchar2 70 60 321 CN SS2 Supplier Contact Telex Area Code 1180 Varchar2 80 10 381 CN SS2 Supplier Contact Telex 1180 Varchar2 90 60 391 CN SS2 RECORD 1190 (POO) Common Key (Positions 1-91) 1190 Varchar2 91 1 Record Number 1190 Varchar2 4 92 Constant '1190' Record Layout Code 1190 Varchar2 2 96 Constant 'AX' Record Layout Qualifier 1190 Varchar2 3 98 Constant 'ST1' Ship To Site Code (Internal) 1190 Number 10 22 101 AX ST1 PO_HEADERS SHIP_TO_LOCATION_ID Ship To Site Code (External+A324) 1190 Varchar2 20 20 123 AX ST1 Ship To Name 1190 Varchar2 30 60 143 AX ST1 Ship To Address Line 1 1190 Varchar2 40 35 203 AX ST1 HR_LOCATIONS ADDRESS_LINE_1 Ship To Address Line 2 1190 Varchar2 50 35 238 AX ST1 HR_LOCATIONS ADDRESS_LINE_2 Ship To Address Line 3 1190 Varchar2 60 35 273 AX ST1 HR_LOCATIONS ADDRESS_LINE_3 Ship To Address Line 4 1190 Varchar2 70 35 308 AX ST1 Ship To City 1190 Varchar2 80 30 343 AX ST1 HR_LOCATIONS TOWN_OR_CITY Ship To Postal Code 1190 Varchar2 90 15 373 AX ST1 HR_LOCATIONS POSTAL_CODE Ship To Country (Internal) COUNTRY 1190 Varchar2 100 20 388 AX ST1 HR_LOCATIONS COUNTRY Ship To Country (Ext1) 1190 Varchar2 110 3 408 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 1 (Internal) REGION1 1190 Varchar2 120 25 411 AX ST1 HR_LOCATIONS REGION_1 Ship To Region 1 (Ext1) 1190 Varchar2 130 10 436 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 2 (Internal) REGION2 or STATE 1190 Varchar2 140 25 446 AX ST1 HR_LOCATIONS REGION_2 Ship To Region 2 (Ext1) 1190 Varchar2 150 10 471 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 3 (Internal) REGION3 1190 Varchar2 160 25 481 AX ST1 HR_LOCATIONS REGION_3 Ship To Region 3 (Ext1) 1190 Varchar2 170 10 506 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 RECORD 1200 (POO) 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 'CN' Record Layout Qualifier 1200 Varchar2 3 98 Constant 'ST1' Ship To Contact Last Name 1200 Varchar2 10 50 101 CN ST1 Ship To Contact First Name 1200 Varchar2 20 50 151 CN ST1 Ship To Contact Job Title 1200 Varchar2 30 40 201 CN ST1 Ship To Contact Area Code 1 1200 Varchar2 40 10 241 CN ST1 Ship to Phone 1 1200 Varchar2 50 60 251 CN ST1 HR_LOCATIONS TELEPHONE_NUMBER_1 Ship To Contact Area Code 2 1200 Varchar2 60 10 311 CN ST1 Ship to Phone 2 1200 Varchar2 70 60 321 CN ST1 HR_LOCATIONS TELEPHONE_NUMBER_2 Ship To Contact Area Code 3 1200 Varchar2 80 10 381 CN ST1 Ship to Phone 3 1200 Varchar2 90 60 391 CN ST1 HR_LOCATIONS TELEPHONE_NUMBER_3 RECORD 1210 (POO) 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 'AX' Record Layout Qualifier 1210 Varchar2 3 98 Constant 'BT1' Bill to Site Code (Internal) 1210 Varchar2 10 20 101 AX BT1 PO_HEADERS BILL_TO_LOCATION_ID Bill To Site Code (External) 1210 Varchar2 20 20 121 AX BT1 Bill To Name 1210 Varchar2 30 60 141 AX BT1 Bill to Address Line 1 1210 Varchar2 40 35 201 AX BT1 HR_LOCATIONS ADDRESS_LINE_1 Bill to Address Line 2 1210 Varchar2 50 35 236 AX BT1 HR_LOCATIONS ADDRESS_LINE_2 Bill to Address Line 3 1210 Varchar2 60 35 271 AX BT1 HR_LOCATIONS ADDRESS_LINE_3 Bill To Address Line 4 1210 Varchar2 70 35 306 AX BT1 Bill to City 1210 Varchar2 80 30 341 AX BT1 HR_LOCATIONS TOWN_OR_CITY Bill to Postal Code 1210 Varchar2 90 15 371 AX BT1 HR_LOCATIONS POSTAL_CODE Bill to Country (Internal) COUNTRY 1210 Varchar2 100 3 386 AX BT1 HR_LOCATIONS COUNTRY Bill To Country (Ext1) 1210 Varchar2 110 3 389 AX BT1 ECE_XREF_DATA XREF_EXT_VALUE1 Bill to Region 1 (Internal) REGION1 1210 Varchar2 120 30 392 AX BT1 HR_LOCATIONS REGION_1 Bill To Region 1 (Ext1) 1210 Varchar2 130 10 422 AX BT1 ECE_XREF_DATA XREF_EXT_VALUE1 Bill to Region 2 (Internal) REGION2 or STATE 1210 Varchar2 140 30 432 AX BT1 HR_LOCATIONS REGION_2 Bill To Region 2 (Ext1) 1210 Varchar2 150 10 462 AX BT1 ECE_XREF_DATA XREF_EXT_VALUE1 Bill to Region 3 (Internal) REGION3 1210 Varchar2 160 30 472 AX BT1 HR_LOCATIONS REGION_3 Bill To Region 3 (Ext1) 1210 Varchar2 170 10 502 AX BT1 ECE_XREF_DATA XREF_EXT_VALUE1 RECORD 1220 (POO) Common Key (Positions 1-91) 1220 Varchar2 91 1 Record Number 1220 Varchar2 4 92 Constant '1220' Record Layout Code 1220 Varchar2 2 96 Constant 'CN' Record Layout Qualifier 1220 Varchar2 3 98 Constant 'BT1' Bill To Contact Last Name 1220 Varchar2 10 50 101 CN BT1 Bill To Contact First Name 1220 Varchar2 20 50 151 CN BT1 Bill To Contact Job Title 1220 Varchar2 30 40 201 CN BT1 Bill To Contact Area Code 1 1220 Varchar2 40 10 241 CN BT1 Bill to Phone 1 1220 Varchar2 50 60 251 CN BT1 HR_LOCATIONS TELEPHONE_NUMBER_1 Bill To Contact Area Code 2 1220 Varchar2 60 10 311 CN BT1 Bill to Phone 2 1220 Varchar2 70 60 321 CN BT1 HR_LOCATIONS TELEPHONE_NUMBER_2 Bill To Contact Area Code 3 1220 Varchar2 80 10 381 CN BT1 Bill to Phone 3 1220 Varchar2 90 60 391 CN BT1 HR_LOCATIONS TELEPHONE_NUMBER_3 RECORD 1230 (POO) Common Key (Positions 1-91) 1230 Varchar2 91 1 Record Number 1230 Varchar2 4 92 Constant '1230' Record Layout Code 1230 Varchar2 2 96 Constant 'PO' Record Layout Qualifier 1230 Varchar2 3 98 Constant 'PO5' Purchase Order Buyer Last Name 1230 Varchar2 10 50 101 PO PO5 HR_EMPLOYEES LAST_NAME Purchase Order Buyer First Name 1230 Varchar2 20 50 151 PO PO5 HR_EMPLOYEES FIRST_NAME Purchase Order Buyer Email 1230 Varchar2 30 240 201 PO PO5 PER_PEOPLE_F EMAIL_ADDRESS Purchase Order Buyer Work Phone 1230 Varchar2 40 60 441 PO PO5 PER_PEOPLE_F WORK_TELEPHONE RECORD 1240 (POO) Common Key (Positions 1-91) 1240 Varchar2 91 1 Record Number 1240 Varchar2 4 92 Constant '1240' Record Layout Code 1240 Varchar2 2 96 Constant 'PO' Record Layout Qualifier 1240 Varchar2 3 98 Constant 'PO6' Purchase Order Buyer Phone 1 1240 Varchar2 10 60 101 PO PO6 PER_ADDRESSES TELEPHONE_1 Purchase Order Buyer Phone 2 1240 Varchar2 20 60 161 PO PO6 PER_ADDRESSES TELEPHONE_2 Purchase Order Buyer Phone 3 1240 Varchar2 30 60 221 PO PO6 PER_ADDRESSES TELEPHONE_3 RECORD 2000 (POO) 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 'IT' Record Layout Qualifier 2000 Varchar2 3 98 Constant 'IT1' Line Number 2000 Number 10 22 101 IT IT1 PO_LINES LINE_NUM Line Order Quantity 2000 Number 20 22 123 IT IT1 PO_LINES QUANTITY Line UOM (Internal) UOM 2000 Varchar2 30 25 145 IT IT1 PO_LINES UOM_LOOKUP_CODE Line UOM (Ext1) 2000 Varchar2 40 2 170 IT IT1 ECE_XREF_DATA XREF_EXT_VALUE1 Line Part Number 2000 Number 50 22 172 IT IT1 PO_LINES ITEM_ID Line Item Revision Number 2000 Varchar2 60 3 194 IT IT1 PO_LINES ITEM_REVISION Supplier Product Number 2000 Varchar2 70 25 197 IT IT1 PO_LINES VENDOR_PRODUCT_NUMBER Line Unit Price 2000 Number 80 22 222 IT IT1 PO_LINES UNIT_PRICE Line Item Description 2000 Varchar2 90 80 244 IT IT1 MTL_ITEM_FLEXFIELD ITEM_DESCRIPTION Contract PO Number 2000 Varchar2 100 20 324 IT IT1 PO_HEADERS SEGMENT1 Contract PO Line Number 2000 Number 110 22 344 IT IT1 PO_HEADERS CONTRACT_PO_LINE_NUMBER Supplier Quote Number 2000 Varchar2 120 25 366 IT IT1 PO_HEADERS QUOTE_VENDOR_QUOTE_NUMBER RECORD 2010 (POO) 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 'IT' Record Layout Qualifier 2010 Varchar2 3 98 Constant 'IT2' Line Canceled Flag 2010 Varchar2 10 1 101 IT IT2 PO_LINES CANCEL_FLAG Line Canceled Date 2010 Date 20 15 102 IT IT2 PO_LINES CANCEL_DATE Blanket Qty Committed 2010 Number 30 22 117 IT IT2 PO_LINES QUANTITY_COMMITTED Blanket Amount Committed 2010 Number 40 22 139 IT IT2 PO_LINES COMMITTED_AMOUNT Line List Price 2010 Number 50 22 161 IT IT2 PO_LINES LIST_PRICE_PER_UNIT Line Market Price 2010 Number 60 22 183 IT IT2 PO_LINES MARKET_PRICE Line Unit Price Not to Exceed 2010 Number 70 22 205 IT IT2 PO_LINES NOT_TO_EXCEED_PRICE Negotiated Price Flag 2010 Varchar2 80 1 227 IT IT2 PO_LINES NEGOTIATED_BY_PREPARER_FLAG Line Taxable Flag (Internal) TAXABLE 2010 Varchar2 90 1 228 IT IT2 PO_LINES TAXABLE_FLAG Line Taxable Flag (Ext1) 2010 Varchar2 100 1 229 IT IT2 ECE_XREF_DATA XREF_EXT_VALUE1 Transaction Reason Code 2010 Varchar2 110 25 230 IT IT2 PO_LINES TRANSACTION_REASON_CODE Type 1099 2010 Varchar2 120 10 255 IT IT2 PO_LINES TYPE_1099 Line Order Type 2010 Varchar2 130 25 265 IT IT2 PO_LINE_TYPES ORDER_TYPE_LOOKUP_CODE RECORD 2020 (POO) 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 'IT' Record Layout Qualifier 2020 Varchar2 3 98 Constant 'IT3' Line Item Hazard Class 2020 Varchar2 10 40 101 IT IT3 PO_HAZARD_CLASSES HAZARD_CLASS UN Hazard Class Number 2020 Varchar2 20 25 141 IT IT3 PO_UN_NUMBERS UN_NUMBER UN Hazard Class Description 2020 Varchar2 30 80 166 IT IT3 PO_UN_NUMBERS DESCRIPTION RECORD 2030 (POO) 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 'IT' Record Layout Qualifier 2030 Varchar2 3 98 Constant 'IT4' Line Note to Supplier 2030 Varchar2 10 80 101 IT IT4 PO_LINES NOTE_TO_VENDOR RECORD 2040 (POO) 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 'A1' Record Layout Qualifier 2040 Varchar2 3 98 Constant 'LN1' Line Flexfield Context 2040 Varchar2 10 30 101 A1 LN1 PO_LINES ATTRIBUTE_CATEGORY Line Flexfield 1 2040 Varchar2 20 80 131 A1 LN1 PO_LINES ATTRIBUTE1 Line Flexfield 2 2040 Varchar2 30 80 211 A1 LN1 PO_LINES ATTRIBUTE2 Line Flexfield 3 2040 Varchar2 40 80 291 A1 LN1 PO_LINES ATTRIBUTE3 Line Flexfield 4 2040 Varchar2 50 80 371 A1 LN1 PO_LINES ATTRIBUTE4 RECORD 2050 (POO) 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 'A2' Record Layout Qualifier 2050 Varchar2 3 98 Constant 'LN2' Line Flexfield 5 2050 Varchar2 10 80 101 A2 LN2 PO_LINES ATTRIBUTE5 Line Flexfield 6 2050 Varchar2 20 80 181 A2 LN2 PO_LINES ATTRIBUTE6 Line Flexfield 7 2050 Varchar2 30 80 261 A2 LN2 PO_LINES ATTRIBUTE7 Line Flexfield 8 2050 Varchar2 40 80 341 A2 LN2 PO_LINES ATTRIBUTE8 Line Flexfield 9 2050 Varchar2 50 80 421 A2 LN2 PO_LINES ATTRIBUTE9 RECORD 2060 (POO) 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 'A2' Record Layout Qualifier 2060 Varchar2 3 98 Constant 'LN3' Line Flexfield 10 2060 Varchar2 10 80 101 A2 LN3 PO_LINES ATTRIBUTE10 Line Flexfield 11 2060 Varchar2 20 80 181 A2 LN3 PO_LINES ATTRIBUTE11 Line Flexfield 12 2060 Varchar2 30 80 261 A2 LN3 PO_LINES ATTRIBUTE12 Line Flexfield 13 2060 Varchar2 40 80 341 A2 LN3 PO_LINES ATTRIBUTE13 Line Flexfield 14 2060 Varchar2 50 80 421 A2 LN3 PO_LINES ATTRIBUTE14 RECORD 2070 (POO) Common Key (Positions 1-91) 2070 Varchar2 91 1 Record Number 2070 Varchar2 4 92 Constant '2070' Record Layout Code 2070 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2070 Varchar2 3 98 Constant 'LN4' Line Flexfield 15 2070 Varchar2 10 80 101 A2 LN4 PO_LINES ATTRIBUTE15 RECORD 2080 (POO) Common Key (Positions 1-91) 2080 Varchar2 91 1 Record Number 2080 Varchar2 4 92 Constant '2080' Record Layout Code 2080 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 2080 Varchar2 3 98 Constant 'LP1' Line Part Flexfield Context 2080 Varchar2 10 30 101 A1 LP1 MTL_ITEM_FLEXFIELD ATTRIBUTE_CATEGORY Line Part Flexfield 1 2080 Varchar2 20 80 131 A1 LP1 MTL_ITEM_FLEXFIELD ATTRIBUTE1 Line Part Flexfield 2 2080 Varchar2 30 80 211 A1 LP1 MTL_ITEM_FLEXFIELD ATTRIBUTE2 Line Part Flexfield 3 2080 Varchar2 40 80 291 A1 LP1 MTL_ITEM_FLEXFIELD ATTRIBUTE3 Line Part Flexfield 4 2080 Varchar2 50 80 371 A1 LP1 MTL_ITEM_FLEXFIELD ATTRIBUTE4 RECORD 2090 (POO) Common Key (Positions 1-91) 2090 Varchar2 91 1 Record Number 2090 Varchar2 4 92 Constant '2090' Record Layout Code 2090 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2090 Varchar2 3 98 Constant 'LP2' Line Part Flexfield 5 2090 Varchar2 10 80 101 A2 LP2 MTL_ITEM_FLEXFIELD ATTRIBUTE5 Line Part Flexfield 6 2090 Varchar2 20 80 181 A2 LP2 MTL_ITEM_FLEXFIELD ATTRIBUTE6 Line Part Flexfield 7 2090 Varchar2 30 80 261 A2 LP2 MTL_ITEM_FLEXFIELD ATTRIBUTE7 Line Part Flexfield 8 2090 Varchar2 40 80 341 A2 LP2 MTL_ITEM_FLEXFIELD ATTRIBUTE8 Line Part Flexfield 9 2090 Varchar2 50 80 421 A2 LP2 MTL_ITEM_FLEXFIELD ATTRIBUTE9 RECORD 2100 (POO) Common Key (Positions 1-91) 2100 Varchar2 91 1 Record Number 2100 Varchar2 4 92 Constant '2100' Record Layout Code 2100 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2100 Varchar2 3 98 Constant 'LP3' Line Part Flexfield 10 2100 Varchar2 10 80 101 A2 LP3 MTL_ITEM_FLEXFIELD ATTRIBUTE10 Line Part Flexfield 11 2100 Varchar2 20 80 181 A2 LP3 MTL_ITEM_FLEXFIELD ATTRIBUTE11 Line Part Flexfield 12 2100 Varchar2 30 80 261 A2 LP3 MTL_ITEM_FLEXFIELD ATTRIBUTE12 Line Part Flexfield 13 2100 Varchar2 40 80 341 A2 LP3 MTL_ITEM_FLEXFIELD ATTRIBUTE13 Line Part Flexfield 14 2100 Varchar2 50 80 421 A2 LP3 MTL_ITEM_FLEXFIELD ATTRIBUTE14 RECORD 2110 (POO) Common Key (Positions 1-91) 2110 Varchar2 91 1 Record Number 2110 Varchar2 4 92 Constant '2110' Record Layout Code 2110 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2110 Varchar2 3 98 Constant 'LP4' Line Part Flexfield 15 2110 Varchar2 10 80 101 A2 LP4 MTL_ITEM_FLEXFIELD ATTRIBUTE15 RECORD 2120 (POO) Common Key (Positions 1-91) 2120 Varchar2 91 1 Record Number 2120 Varchar2 4 92 Constant '2120' Record Layout Code 2120 Varchar2 2 96 Constant 'PS' Record Layout Qualifier 2120 Varchar2 3 98 Constant 'PS1' Line Part Segment 1 2120 Varchar2 10 40 101 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT1 Line Part Segment 2 2120 Varchar2 20 40 141 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT2 Line Part Segment 3 2120 Varchar2 30 40 181 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT3 Line Part Segment 4 2120 Varchar2 40 40 221 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT4 Line Part Segment 5 2120 Varchar2 50 40 261 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT5 Line Part Segment 6 2120 Varchar2 60 40 301 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT6 Line Part Segment 7 2120 Varchar2 70 40 341 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT7 Line Part Segment 8 2120 Varchar2 80 40 381 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT8 Line Part Segment 9 2120 Varchar2 90 40 421 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT9 Line Part Segment 10 2120 Varchar2 100 40 461 PS PS1 MTL_ITEM_FLEXFIELD SEGMENT10 RECORD 2130 (POO) Common Key (Positions 1-91) 2130 Varchar2 91 1 Record Number 2130 Varchar2 4 92 Constant '2130' Record Layout Code 2130 Varchar2 2 96 Constant 'PS' Record Layout Qualifier 2130 Varchar2 3 98 Constant 'PS2' Line Part Segment 11 2130 Varchar2 10 40 101 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT11 Line Part Segment 12 2130 Varchar2 20 40 141 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT12 Line Part Segment 13 2130 Varchar2 30 40 181 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT13 Line Part Segment 14 2130 Varchar2 40 40 221 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT14 Line Part Segment 15 2130 Varchar2 50 40 261 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT15 Line Part Segment 16 2130 Varchar2 60 40 301 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT16 Line Part Segment 17 2130 Varchar2 70 40 341 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT17 Line Part Segment 18 2130 Varchar2 80 40 381 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT18 Line Part Segment 19 2130 Varchar2 90 40 421 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT19 Line Part Segment 20 2130 Varchar2 100 40 461 PS PS2 MTL_ITEM_FLEXFIELD SEGMENT20 RECORD 3000 (POO) 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 'SH' Record Layout Qualifier 3000 Varchar2 3 98 Constant 'SH1' Shipment Number 3000 Number 10 22 101 SH SH1 PO_LINE_LOCATIONS SHIPMENT_NUM Quantity Original 3000 Number 30 22 123 SH SH1 PO_LINE_LOCATIONS QUANTITY UOM code UOM 3000 Varchar2 40 25 145 SH SH1 PO_LINE_LOCATIONS UNIT_MEAS_LOOKUP_CODE UOM code (Ext1) 3000 Varchar2 50 2 170 SH SH1 ECE_XREF_DATA XREF_EXT_VALUE1 Shipment Need By Date 3000 Date 60 15 172 SH SH1 PO_LINE_LOCATIONS NEED_BY_DATE Shipment Promised Date 3000 Date 70 15 187 SH SH1 PO_LINE_LOCATIONS PROMISED_DATE Shipment Last Acceptable Date 3000 Date 80 15 202 SH SH1 PO_LINE_LOCATIONS LAST_ACCEPT_DATE Quantity 3000 Number 90 22 217 SH SH1 PO_LINE_LOCATIONS QUANTITY - QUANTITY_CANCELLED Quantity Canceled 3000 Number 100 22 239 SH SH1 PO_LINE_LOCATIONS QUANTITY_CANCELLED Quantity Delivered 3000 Number 110 22 261 SH SH1 PO_LINE_LOCATIONS QUANTITY_RECEIVED Price Override 3000 Number 120 22 283 SH SH1 PO_LINE_LOCATIONS PRICE_OVERRIDE Canceled Flag 3000 Varchar2 130 1 305 SH SH1 PO_LINE_LOCATIONS CANCEL_FLAG Canceled Date 3000 Date 140 15 306 SH SH1 PO_LINE_LOCATIONS CANCEL_DATE Ship Via (Internal) SHIP_VIA 3000 Varchar2 150 25 321 SH SH1 PO_LINE_LOCATIONS SHIP_VIA_LOOKUP_CODE Ship Via (Ext1) 3000 Varchar2 160 20 346 SH SH1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship Via (Ext2) 3000 Varchar2 170 20 366 SH SH1 ECE_XREF_DATA XREF_EXT_VALUE2 Ship Via (Ext3) 3000 Varchar2 180 80 386 SH SH1 ECE_XREF_DATA XREF_EXT_VALUE3 FOB Code (Internal) FOB 3000 Varchar2 190 25 466 SH SH1 PO_LINE_LOCATIONS FOB_LOOKUP_CODE FOB Code (Ext1) 3000 Varchar2 200 2 491 SH SH1 ECE_XREF_DATA XREF_EXT_VALUE1 Freight Terms (Internal) FREIGHT_TERMS 3000 Varchar2 210 25 493 SH SH1 PO_LINE_LOCATIONS FREIGHT_TERMS_LOOKUP_CODE Freight Terms (Ext1) 3000 Varchar2 220 3 518 SH SH1 ECE_XREF_DATA XREF_EXT_VALUE1 Taxable Flag 3000 Varchar2 230 1 521 SH SH1 PO_LINE_LOCATIONS TAXABLE_FLAG RECORD 3010 (POO) 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 'A1' Record Layout Qualifier 3010 Varchar2 3 98 Constant 'SH1' Shipment Flexfield Context 3010 Varchar2 10 30 101 A1 SH1 PO_LINE_LOCATIONS ATTRIBUTE_CATEGORY Shipment Flexfield 1 3010 Varchar2 20 80 131 A1 SH1 PO_LINE_LOCATIONS ATTTRIBUTE1 Shipment Flexfield 2 3010 Varchar2 30 80 211 A1 SH1 PO_LINE_LOCATIONS ATTTRIBUTE2 Shipment Flexfield 3 3010 Varchar2 40 80 291 A1 SH1 PO_LINE_LOCATIONS ATTTRIBUTE3 Shipment Flexfield 4 3010 Varchar2 50 80 371 A1 SH1 PO_LINE_LOCATIONS ATTTRIBUTE4 RECORD 3020 (POO) 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 'SH2' Shipment Flexfield 5 3020 Varchar2 10 80 101 A2 SH2 PO_LINE_LOCATIONS ATTTRIBUTE5 Shipment Flexfield 6 3020 Varchar2 20 80 181 A2 SH2 PO_LINE_LOCATIONS ATTTRIBUTE6 Shipment Flexfield 7 3020 Varchar2 30 80 261 A2 SH2 PO_LINE_LOCATIONS ATTTRIBUTE7 Shipment Flexfield 8 3020 Varchar2 40 80 341 A2 SH2 PO_LINE_LOCATIONS ATTTRIBUTE8 Shipment Flexfield 9 3020 Varchar2 50 80 421 A2 SH2 PO_LINE_LOCATIONS ATTTRIBUTE9 RECORD 3030 (POO) 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 'SH3' Shipment Flexfield 10 3030 Varchar2 10 80 101 A2 SH3 PO_LINE_LOCATIONS ATTTRIBUTE10 Shipment Flexfield 11 3030 Varchar2 20 80 181 A2 SH3 PO_LINE_LOCATIONS ATTTRIBUTE11 Shipment Flexfield 12 3030 Varchar2 30 80 261 A2 SH3 PO_LINE_LOCATIONS ATTTRIBUTE12 Shipment Flexfield 13 3030 Varchar2 40 80 341 A2 SH3 PO_LINE_LOCATIONS ATTTRIBUTE13 Shipment Flexfield 14 3030 Varchar2 50 80 421 A2 SH3 PO_LINE_LOCATIONS ATTTRIBUTE14 RECORD 3040 (POO) 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 'A2' Record Layout Qualifier 3040 Varchar2 3 98 Constant 'SH4' Shipment Flexfield 15 3040 Varchar2 10 80 101 A2 SH4 PO_LINE_LOCATIONS ATTTRIBUTE15 RECORD 3050 (POO) 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 'AX' Record Layout Qualifier 3050 Varchar2 3 98 Constant 'SL1' Ship to Code (Internal) 3050 Varchar2 10 20 101 AX SL1 HR_LOCATIONS LOCATION_CODE Ship To Code (A323Ext 3050 Varchar2 20 20 121 AX SL1 Ship To Name 3050 Varchar2 30 60 141 AX SL1 Ship to Address Line 1 3050 Varchar2 40 35 201 AX SL1 HR_LOCATIONS ADDRESS_LINE_1 Ship to Address Line 2 3050 Varchar2 50 35 236 AX SL1 HR_LOCATIONS ADDRESS_LINE_2 Ship to Address Line 3 3050 Varchar2 60 35 271 AX SL1 HR_LOCATIONS ADDRESS_LINE_3 Ship To Address Line 4 3050 Varchar2 70 35 306 AX SL1 Ship to City 3050 Varchar2 80 30 341 AX SL1 HR_LOCATIONS TOWN_OR_CITY Ship to Postal Code 3050 Varchar2 90 15 371 AX SL1 HR_LOCATIONS POSTAL_CODE Ship to Country COUNTRY 3050 Varchar2 100 3 386 AX SL1 HR_LOCATIONS COUNTRY Ship To Country (Ext1) 3050 Varchar2 110 3 389 AX SL1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship to Region 1 (Internal) REGION1 3050 Varchar2 120 30 392 AX SL1 HR_LOCATIONS REGION_1 Ship To Region 1 (Ext1) 3050 Varchar2 130 10 422 AX SL1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 2 (Internal) REGION2 or STATE 3050 Varchar2 140 30 432 AX SL1 HR_LOCATIONS REGION_2 Ship To Region 2 (Ext1) 3050 Varchar2 150 10 462 AX SL1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 3 (Internal) REGION3 3050 Varchar2 160 30 472 AX SL1 HR_LOCATIONS REGION_3 Ship To Region 3 (Ext1) 3050 Varchar2 170 10 502 AX SL1 ECE_XREF_DATA XREF_EXT_VALUE1 RECORD 3060 (POO) 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 'CN' Record Layout Qualifier 3060 Varchar2 3 98 Constant 'SL1' Ship To Contact Last Name 3060 Varchar2 10 50 101 CN SL1 Ship To Contact First Name 3060 Varchar2 20 50 151 CN SL1 Ship To Contact Job Title 3060 Varchar2 30 40 201 CN SL1 Ship To Contact Area Code 1 3060 Varchar2 40 10 241 CN SL1 Ship to Phone 1 3060 Varchar2 50 60 251 CN SL1 HR_LOCATIONS TELEPHONE_NUMBER_1 Ship To Contact Area Code 2 3060 Varchar2 60 10 311 CN SL1 Ship to Phone 2 3060 Varchar2 70 60 321 CN SL1 HR_LOCATIONS TELEPHONE_NUMBER_2 Ship To Contact Area Code 3 3060 Varchar2 80 10 381 CN SL1 Ship to Phone 3 3060 Varchar2 90 60 391 CN SL1 HR_LOCATIONS TELEPHONE_NUMBER_3
| Previous | Next | Contents | Index | Navigation | Glossary | Library |