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 PosWidthStartRec.Qual.Interface Table Interface Column RECORD 0010 Common Key (Positions 1-91) 0010 Varchar2 91 1 Record Number 0010 Varchar2 4 92 Constant '0010' Record Layout 0010 Varchar2 2 96 Constant 'CT' Record Layout Qualifier 0010 Varchar2 3 98 Constant 'CTL' Communication Method 0010 Varchar2 10 2 101 CT CTL Test Indicator 0010 Varchar2 20 1 103 CT CTL Document ID 0010 Varchar2 30 6 104 CT CTL Document Type 0010 Varchar2 40 5 110 CT CTL Document Purpose Code 0010 Varchar2 50 2 115 CT CTL Document Code 0010 Varchar2 60 35 117 CT CTL Trading Partner Translator Code 0010 Varchar2 70 30 152 CT CTL Trading Partner Location Code 0010 Varchar2 80 35 182 CT CTL Trading Partner Description 0010 Varchar2 90 74 217 CT CTL Trading Partner Reference 1 0010 Varchar2100 80 291 CT CTL Trading Partner Reference 2 0010 Varchar2110 80 371 CT CTL 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 1000 Common Key (Positions 1-91) 1000 Varchar2 91 1 Record Number 1000 Varchar2 4 92 Constant '1000' Record Layout 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 SO_HEADERS_INTERFACE PURCHASE_ORDER_NUM Release Number 1000 Number 20 22 141 PO PO1 SO_HEADERS_INTERFACE Release Date 1000 Date 30 15 163 PO PO1 SO_HEADERS_INTERFACE Purchase Order Header Date 1000 Date 40 15 178 PO PO1 SO_HEADERS_INTERFACE DATE_ORDERED Purchase Order Header Revision Number 1000 Number 50 22 193 PO PO1 SO_HEADERS_INTERFACE Purchase Order Header Revision Date 1000 Date 60 15 215 PO PO1 SO_HEADERS_INTERFACE Release Revision Number 1000 Number 70 22 230 PO PO1 SO_HEADERS_INTERFACE Release Revision Date 1000 Number 80 15 252 PO PO1 SO_HEADERS_INTERFACE Purchase Order Description 1000 Varchar2 90 80 267 PO PO1 SO_HEADERS_INTERFACE Purchase Order Type (not used) 1000 Varchar2100 10 267 PO PO1 SO_HEADERS_INTERFACE (not used) Purchase Order Type (Internal) PO_TYPE 1000 Varchar2110 30 347 PO PO1 SO_HEADERS_INTERFACE Purchase Order Type (Ext1) 1000 Varchar2120 10 377 PO PO1 SO_HEADERS_INTERFACE PO_TYPE RECORD 1010 Common Key (Positions 1-91) 1010 Varchar2 91 1 Record Number 1010 Varchar2 4 92 Constant '1010' Record Layout 1010 Varchar2 2 96 Constant 'PO' Record Layout Qualifier 1010 Varchar2 3 98 Constant 'PO2' Payment Terms (Internal) PAYMENT_TERMS 1010 Varchar2 10 15 101 PO PO2 SO_HEADERS_INTERFACE TERMS_NAME Payment Terms (Ext1) 1010 Varchar2 20 22 116 PO PO2 SO_HEADERS_INTERFACE Payment Terms (Ext2) 1010 Varchar2 30 15 138 PO PO2 SO_HEADERS_INTERFACE Payment Terms (Ext3) 1010 Varchar2 40 3 153 PO PO2 SO_HEADERS_INTERFACE Payment Terms (Ext4) 1010 Varchar2 50 3 156 PO PO2 SO_HEADERS_INTERFACE Payment Terms (Ext5) 1010 Varchar2 60 3 159 PO PO2 SO_HEADERS_INTERFACE Currency Code (Internal) CURRRENCY 1010 Varchar2 70 15 162 PO PO2 SO_HEADERS_INTERFACE CURRENCY_CODE Currency Code (Ext1) 1010 Varchar2 80 3 177 PO PO2 SO_HEADERS_INTERFACE Currency Conversion Rate 1010 Number 90 22 180 PO PO2 SO_HEADERS_INTERFACE CONVERSION_RATE Currency Conversion Date 1010 Date 100 15 202 PO PO2 SO_HEADERS_INTERFACE CONVERSION_DATE Currency Conversion Type (Internal)CURR_CONV_TYPE1010 Varchar2110 30 217 PO PO2 SO_HEADERS_INTERFACE CONVERSION_TYPE_CODE Currency Conversion Type (Ext1) 1010 Varchar2120 10 247 PO PO2 SO_HEADERS_INTERFACE Shipment Priority Code (Internal) SHIP_PRIOR 1010 Varchar2130 25 257 PO PO2 SO_HEADERS_INTERFACE SHIPMENT_PRIORITY_CODE Shipment Priority Code (Ext1) 1010 Varchar2140 20 282 PO PO2 SO_HEADERS_INTERFACE Shipment Priority Code (Ext2) 1010 Varchar2150 20 302 PO PO2 SO_HEADERS_INTERFACE Shipment Priority Code (Ext3) 1010 Varchar2160 80 322 PO PO2 SO_HEADERS_INTERFACE FOB Code (Internal) FOB 1010 Varchar2170 25 402 PO PO2 SO_HEADERS_INTERFACE FOB_CODE FOB Code (Ext1) 1010 Varchar2180 10 427 PO PO2 SO_HEADERS_INTERFACE Freight Terms Code (Internal) FREIGHT_TERMS 1010 Varchar2190 25 437 PO PO2 SO_HEADERS_INTERFACE FREIGHT_TERMS_CODE Freight Terms Code (Ext1) 1010 Varchar2200 10 462 PO PO2 SO_HEADERS_INTERFACE RECORD 1020 Common Key (Positions 1-91) 1020 Varchar2 91 1 Record Number 1020 Varchar2 4 92 Constant '1020' Record Layout 1020 Varchar2 2 96 Constant 'PO' Record Layout Qualifier 1020 Varchar2 3 98 Constant 'PO3' PO Header Canceled Flag 1020 Varchar2 10 1 101 PO PO3 SO_HEADERS_INTERFACE PO Header Acceptance Required Flag 1020 Varchar2 20 1 102 PO PO3 SO_HEADERS_INTERFACE PO Header Acceptance Due By Date 1020 Date 30 15 103 PO PO3 SO_HEADERS_INTERFACE PO Header Confirming Order flag 1020 Varchar2 40 1 118 PO PO3 SO_HEADERS_INTERFACE Blanket Start Date 1020 Date 50 15 119 PO PO3 SO_HEADERS_INTERFACE Blanket End Date 1020 Date 60 15 134 PO PO3 SO_HEADERS_INTERFACE Blanket Total Amount 1020 Number 70 22 149 PO PO3 SO_HEADERS_INTERFACE Customer Name 1020 Varchar2 80 30 171 PO PO3 SO_HEADERS_INTERFACE CUSTOMER_NAME Customer Number 1020 Varchar2 90 80 201 PO PO3 SO_HEADERS_INTERFACE CUSTOMER_NUMBER RECORD 1030 Common Key (Positions 1-91) 1030 Varchar2 91 1 Record Number 1030 Varchar2 4 92 Constant '1030' Record Layout 1030 Varchar2 2 96 Constant 'PO' Record Layout Qualifier 1030 Varchar2 3 98 Constant 'PO4' Original System Reference 1030 Varchar2 10 50 101 PO PO4 SO_HEADERS_INTERFACE ORIGINAL_SYSTEM_REFERENCE Order Source ID 1030 Number 20 22 151 PO PO4 SO_HEADERS_INTERFACE ORDER_SOURCE_ID Date Requested Current 1030 Date 30 15 173 PO PO4 SO_HEADERS_INTERFACE DATE_REQUESTED_CURRENT Agreement Name 1030 Varchar2 40 30 188 PO PO4 SO_HEADERS_INTERFACE AGREEMENT_NAME Entered State 1030 Varchar2 30 30 218 PO PO4 SO_HEADERS_INTERFACE ENTERED_STATE_NAME RECORD 1040 Common Key (Positions 1-91) 1040 Varchar2 91 1 Record Number 1040 Varchar2 4 92 Constant '1040' Record Layout 1040 Varchar2 2 96 Constant 'PO' Record Layout Qualifier 1040 Varchar2 3 98 Constant 'PO5' Shipping Instructions 1040 Varchar2 10 240 101 PO PO5 SO_HEADERS_INTERFACE SHIPPING_INSTRUCTIONS RECORD 1050 Common Key (Positions 1-91) 1050 Varchar2 91 1 Record Number 1050 Varchar2 4 92 Constant '1050' Record Layout 1050 Varchar2 2 96 Constant 'PO' Record Layout Qualifier 1050 Varchar2 3 98 Constant 'PO6' Packing Instructions 1050 Varchar2 10 240 101 PO PO6 SO_HEADERS_INTERFACE PACKING_INSTRUCTIONS RECORD 1060 Common Key (Positions 1-91) 1040 Varchar2 91 1 Record Number 1040 Varchar2 4 92 Constant '1060' Record Layout 1040 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1040 Varchar2 3 98 Constant 'Purchase Order1' Context 1040 Varchar2 10 30 101 A1 PO1 SO_HEADERS_INTERFACE CONTEXT Purchase Order Header Flexfield 1 1040 Varchar2 20 80 131 A1 PO1 SO_HEADERS_INTERFACE ATTRIBUTE1 Purchase Order Header Flexfield 2 1040 Varchar2 30 80 211 A1 PO1 SO_HEADERS_INTERFACE ATTRIBUTE2 Purchase Order Header Flexfield 3 1040 Varchar2 40 80 291 A1 PO1 SO_HEADERS_INTERFACE ATTRIBUTE3 Purchase Order Header Flexfield 4 1040 Varchar2 50 80 371 A1 PO1 SO_HEADERS_INTERFACE ATTRIBUTE4 RECORD 1070 Common Key (Positions 1-91) 1050 Varchar2 91 1 Record Number 1050 Varchar2 4 92 Constant '1070' Record Layout 1050 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1050 Varchar2 3 98 Constant 'PO2' Purchase Order Header Flexfield 5 1050 Varchar2 10 80 101 A2 PO2 SO_HEADERS_INTERFACE ATTRIBUTE5 Purchase Order Header Flexfield 6 1050 Varchar2 20 80 181 A2 PO2 SO_HEADERS_INTERFACE ATTRIBUTE6 Purchase Order Header Flexfield 7 1050 Varchar2 30 80 261 A2 PO2 SO_HEADERS_INTERFACE ATTRIBUTE7 Purchase Order Header Flexfield 8 1050 Varchar2 40 80 341 A2 PO2 SO_HEADERS_INTERFACE ATTRIBUTE8 Purchase Order Header Flexfield 9 1050 Varchar2 50 80 421 A2 PO2 SO_HEADERS_INTERFACE ATTRIBUTE9 RECORD 1080 Common Key (Positions 1-91) 1060 Varchar2 91 1 Record Number 1060 Varchar2 4 92 Constant '1080' Record Layout 1060 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1060 Varchar2 3 98 Constant 'PO3' Purchase Order Header Flexfield 10 1060 Varchar2 10 80 101 A2 PO3 SO_HEADERS_INTERFACE ATTRIBUTE10 Purchase Order Header Flexfield 11 1060 Varchar2 20 80 181 A2 PO3 SO_HEADERS_INTERFACE ATTRIBUTE11 Purchase Order Header Flexfield 12 1060 Varchar2 30 80 261 A2 PO3 SO_HEADERS_INTERFACE ATTRIBUTE12 Purchase Order Header Flexfield 13 1060 Varchar2 40 80 341 A2 PO3 SO_HEADERS_INTERFACE ATTRIBUTE13 Purchase Order Header Flexfield 14 1060 Varchar2 50 80 421 A2 PO3 SO_HEADERS_INTERFACE ATTRIBUTE14 RECORD 1090 Common Key (Positions 1-91) 1070 Varchar2 91 1 Record Number 1070 Varchar2 4 92 Constant '1090' Record Layout 1070 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1070 Varchar2 3 98 Constant 'PO4' Purchase Order Header Flexfield 15 1070 Varchar2 10 80 101 A2 PO4 SO_HEADERS_INTERFACE ATTRIBUTE15 RECORD 1190 Common Key (Positions 1-91) 1190 Varchar2 91 1 Record Number 1190 Varchar2 4 92 Constant '1190' Record Layout 1190 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1190 Varchar2 3 98 Constant 'ST1' Ship to Site (Internal) 1190 Number 20 22 101 AD ST1 SO_HEADERS_INTERFACE SHIP_ADDRESS_ID Ship to Site (Ext) 1190 Varchar2 30 20 123 AD ST1 SO_HEADERS_INTERFACE Ship to Customer 1190 Varchar2 40 60 143 AD ST1 SO_HEADERS_INTERFACE SHIP_TO_CUSTOMER Ship to Address 1 1190 Varchar2 50 35 203 AD ST1 SO_HEADERS_INTERFACE SHIP_ADDRESS1 Ship to Address 2 1190 Varchar2 60 35 238 AD ST1 SO_HEADERS_INTERFACE SHIP_ADDRESS2 Ship to Address 3 1190 Varchar2 70 35 273 AD ST1 SO_HEADERS_INTERFACE SHIP_ADDRESS3 Ship to Address 4 1190 Varchar2 80 35 308 AD ST1 SO_HEADERS_INTERFACE SHIP_ADDRESS4 Ship to City 1190 Varchar2 90 30 343 AD ST1 SO_HEADERS_INTERFACE SHIP_CITY Ship to Postal Code 1190 Varchar2100 15 373 AD ST1 SO_HEADERS_INTERFACE SHIP_Purchase Order HeaderSTAL_CODE Ship to Country (Internal) COUNTRY 1190 Varchar2110 20 388 AD ST1 SO_HEADERS_INTERFACE SHIP_COUNTRY Ship to Country (Ext1) 1190 Varchar2120 3 408 AD ST1 SO_HEADERS_INTERFACE Ship to State (Internal) STATE 1190 Varchar2130 20 411 AD ST1 SO_HEADERS_INTERFACE SHIP_STATE Ship to State (Ext1) 1190 Varchar2140 10 431 AD ST1 SO_HEADERS_INTERFACE Ship to Province (Internal) 1190 Varchar2150 20 441 AD ST1 SO_HEADERS_INTERFACE Ship to Province (Ext1) 1190 Varchar2160 10 461 AD ST1 SO_HEADERS_INTERFACE Ship to County 1190 Varchar2170 25 471 AD ST1 SO_HEADERS_INTERFACE SHIP_COUNTY RECORD 1200 Common Key (Positions 1-91) 1200 Varchar2 91 1 Record Number 1200 Varchar2 4 92 Constant '1200' Record Layout 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 SO_HEADERS_INTERFACE SHIP_TO_CONTACT_LAST_NAME Ship to Contact First Name 1200 Varchar2 20 30 151 CN ST1 SO_HEADERS_INTERFACE SHIP_TO_CONTACT_FIRST_NAME Ship To Contact Job Title 1200 Varchar2 30 40 181 CN ST1 SO_HEADERS_INTERFACE Ship To Contact Area Code 1 1200 Varchar2 40 10 221 CN ST1 SO_HEADERS_INTERFACE Ship to Phone 1 1200 Varchar2 50 60 231 CN ST1 SO_HEADERS_INTERFACE Ship To Contact Area Code 2 1200 Varchar2 60 10 291 CN ST1 SO_HEADERS_INTERFACE Ship to Phone 2 1200 Varchar2 70 60 301 CN ST1 SO_HEADERS_INTERFACE Ship To Contact Area Code 3 1200 Varchar2 80 10 361 CN ST1 SO_HEADERS_INTERFACE Ship to Phone 3 1200 Varchar2 90 60 371 CN ST1 SO_HEADERS_INTERFACE RECORD 1210 Common Key (Positions 1-91) 1210 Varchar2 91 1 Record Number 1210 Varchar2 4 92 Constant '1210' Record Layout 1210 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1210 Varchar2 3 98 Constant 'BT1' Bill To Site Code (Internal) 1210 Number 20 22 101 AD BT1 SO_HEADERS_INTERFACE INVOICE_ADDRESS_ID Bill To Site Code (Ext) 1210 Varchar2 30 20 123 AD BT1 SO_HEADERS_INTERFACE Bill To Customer 1210 Varchar2 40 50 143 AD BT1 SO_HEADERS_INTERFACE INVOICE_CUSTOMER Bill To Address 1 1210 Varchar2 50 35 193 AD BT1 SO_HEADERS_INTERFACE INVOICE_ADDRESS1 Bill To Address 2 1210 Varchar2 60 35 228 AD BT1 SO_HEADERS_INTERFACE INVOICE_ADDRESS2 Bill To Address 3 1210 Varchar2 70 35 263 AD BT1 SO_HEADERS_INTERFACE INVOICE_ADDRESS3 Bill To Address 4 1210 Varchar2 80 35 298 AD BT1 SO_HEADERS_INTERFACE INVOICE_ADDRESS4 Bill To City 1210 Varchar2 90 30 333 AD BT1 SO_HEADERS_INTERFACE INVOICE_CITY Bill To Postal Code 1210 Varchar2100 15 363 AD BT1 SO_HEADERS_INTERFACE INVOICE_Purchase Order HeaderSTAL_CODE Bill To Country (Internal) COUNTRY 1210 Varchar2110 20 378 AD BT1 SO_HEADERS_INTERFACE INVOICE_COUNTRY Bill To Country (Ext1) 1210 Varchar2120 3 398 AD BT1 SO_HEADERS_INTERFACE Bill To State (Internal) STATE 1210 Varchar2130 20 401 AD BT1 SO_HEADERS_INTERFACE INVOICE_STATE Bill To State (Ext1) 1210 Varchar2140 10 421 AD BT1 SO_HEADERS_INTERFACE Bill To Province (Internal) 1210 Varchar2150 20 431 AD BT1 SO_HEADERS_INTERFACE Bill To Province (Ext1) 1210 Varchar2160 10 451 AD BT1 SO_HEADERS_INTERFACE Bill To County 1210 Varchar2170 25 461 AD BT1 SO_HEADERS_INTERFACE INVOICE_COUNTY RECORD 1220 Common Key (Positions 1-91) 1220 Varchar2 91 1 Record Number 1220 Varchar2 4 92 Constant '1220' Record Layout 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 SO_HEADERS_INTERFACE INVOICE_TO_CONTACT_LAST_NAME Bill to Contact First Name 1220 Varchar2 20 30 151 CN BT1 SO_HEADERS_INTERFACE INVOICE_TO_CONTACT_FIRST_NAME Bill to Contact Job Title 1220 Varchar2 30 40 181 CN BT1 SO_HEADERS_INTERFACE Bill to Contact Area Code 1 1220 Varchar2 40 10 221 CN BT1 SO_HEADERS_INTERFACE Bill to Phone 1 1220 Varchar2 50 60 231 CN BT1 SO_HEADERS_INTERFACE Bill to Contact Area Code 2 1220 Varchar2 60 10 291 CN BT1 SO_HEADERS_INTERFACE Bill to Phone 2 1220 Varchar2 70 60 301 CN BT1 SO_HEADERS_INTERFACE Bill to Contact Area Code 3 1220 Varchar2 80 10 361 CN BT1 SO_HEADERS_INTERFACE Bill to Phone 3 1220 Varchar2 90 60 371 CN BT1 SO_HEADERS_INTERFACE RECORD 1230 Common Key (Positions 1-91) 1230 Varchar2 91 1 Record Number 1230 Varchar2 4 92 Constant '1230' Record Layout 1230 Varchar2 2 96 Constant 'CN' Record Layout Qualifier 1230 Varchar2 3 98 Constant 'OBY' Ordered by Contact First Name 1230 Varchar2 10 30 101 CN OBY SO_HEADERS_INTERFACE ORDERED_BY_CONTACT_FIRST_NAME Ordered by Contact Last Name 1230 Varchar2 20 50 131 CN OBY SO_HEADERS_INTERFACE ORDERED_BY_CONTACT_LAST_NAME RECORD 2000 Common Key (Positions 1-91) 2000 Varchar2 91 1 Record Number 2000 Varchar2 4 92 Constant '2000' Record Layout 2000 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 2000 Varchar2 3 98 Constant 'IT1' Line Number 2000 Number 10 22 101 IT IT1 SO_LINES_INTERFACE LINE_NUMBER Order Quantity 2000 Number 20 22 123 IT IT1 SO_LINES_INTERFACE ORDERED_QUANTITY Unit of Measurement (Internal) UOM 2000 Varchar2 30 3 145 IT IT1 SO_LINES_INTERFACE UNIT_CODE Unit of Measurement (Ext1) 2000 Varchar2 40 2 98 IT IT1 SO_LINES_INTERFACE Unit of Measurement (Ext2) 2000 Varchar2 50 2 101 IT IT1 SO_LINES_INTERFACE Unit of Measurement (Ext3) 2000 Varchar2 60 2 123 IT IT1 SO_LINES_INTERFACE Unit of Measurement (Ext4) 2000 Varchar2 70 2 145 IT IT1 SO_LINES_INTERFACE Unit of Measurement (Ext5) 2000 Varchar2 80 2 148 IT IT1 SO_LINES_INTERFACE Line Part Number 2000 Varchar2 90 80 150 IT IT1 SO_LINES_INTERFACE Line Header Revision Number 2000 Varchar2100 3 230 IT IT1 SO_LINES_INTERFACE Supplier Product Number 2000 Varchar2110 25 233 IT IT1 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT1 List Price 2000 Number 120 22 258 IT IT1 SO_LINES_INTERFACE LIST_PRICE Line Header Description 2000 Varchar2130 80 280 IT IT1 SO_LINES_INTERFACE Contract Purchase Order Header Number 2000 Varchar2140 20 360 IT IT1 SO_LINES_INTERFACE Supplier Quote Number 2000 Varchar2150 25 380 IT IT1 SO_LINES_INTERFACE RECORD 2120 Common Key (Positions 1-91) 2120 Varchar2 91 1 Record Number 2120 Varchar2 4 92 Constant '2120' Record Layout 2120 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 2120 Varchar2 3 98 Constant 'IT2' Inventory Header Segment 2 2120 Varchar2 10 80 101 IT IT2 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT2 Inventory Header Segment 3 2120 Varchar2 20 80 181 IT IT2 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT3 Inventory Header Segment 4 2120 Varchar2 30 80 261 IT IT2 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT4 Inventory Header Segment 5 2120 Varchar2 40 80 341 IT IT2 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT5 Inventory Header Segment 6 2120 Varchar2 50 80 421 IT IT2 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT6 RECORD 2130 Common Key (Positions 1-91) 2130 Varchar2 91 1 Record Number 2130 Varchar2 4 92 Constant '2130' Record Layout 2130 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 2130 Varchar2 3 98 Constant 'IT3' Inventory Header Segment 7 2130 Varchar2 10 80 101 IT IT3 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT7 Inventory Header Segment 8 2130 Varchar2 20 80 181 IT IT3 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT8 Inventory Header Segment 9 2130 Varchar2 30 80 261 IT IT3 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT9 Inventory Header Segment 10 2130 Varchar2 40 80 341 IT IT3 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT10 Inventory Header Segment 11 2130 Varchar2 50 80 421 IT IT3 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT11 RECORD 2140 Common Key (Positions 1-91) 2140 Varchar2 91 1 Record Number 2140 Varchar2 4 92 Constant '2140' Record Layout 2140 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 2140 Varchar2 3 98 Constant 'IT4' Inventory Header Segment 12 2140 Varchar2 10 80 101 IT IT4 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT12 Inventory Header Segment 13 2140 Varchar2 20 80 181 IT IT4 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT13 Inventory Header Segment 14 2140 Varchar2 30 80 261 IT IT4 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT14 Inventory Header Segment 15 2140 Varchar2 40 80 341 IT IT4 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT15 Inventory Header Segment 16 2140 Varchar2 50 80 421 IT IT4 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT16 RECORD 2150 Common Key (Positions 1-91) Varchar2 91 1 Record Number 2150 Varchar2 4 92 Constant '2150' Record Layout 2150 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 2150 Varchar2 3 98 Constant 'IT5' Inventory Header Segment 17 2150 Varchar2 10 80 101 IT IT5 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT17 Inventory Header Segment 18 2150 Varchar2 20 80 181 IT IT5 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT18 Inventory Header Segment 19 2150 Varchar2 30 80 261 IT IT5 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT19 Inventory Header Segment 20 2150 Varchar2 40 80 341 IT IT5 SO_LINES_INTERFACE INVENTORY_Header_SEGMENT20 RECORD 2160 Common Key (Positions 1-91) 2160 Varchar2 91 1 Record Number 2160 Varchar2 4 92 Constant '2160' Record Layout 2160 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 2160 Varchar2 3 98 Constant 'PC1' Pricing Context 2160 Varchar2 10 30 101 A1 PC1 SO_LINES_INTERFACE PRICING_CONTEXT Pricing Flexfield 1 2160 Varchar2 20 80 131 A1 PC1 SO_LINES_INTERFACE PRICING_ATTRIBUTE1 Pricing Flexfield 2 2160 Varchar2 30 80 211 A1 PC1 SO_LINES_INTERFACE PRICING_ATTRIBUTE2 Pricing Flexfield 3 2160 Varchar2 40 80 291 A1 PC1 SO_LINES_INTERFACE PRICING_ATTRIBUTE3 Pricing Flexfield 4 2160 Varchar2 50 80 371 A1 PC1 SO_LINES_INTERFACE PRICING_ATTRIBUTE4 RECORD 2170 Common Key (Positions 1-91) 2170 Varchar2 91 1 Record Number 2170 Varchar2 4 92 Constant '2170' Record Layout 2170 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2170 Varchar2 3 98 Constant 'PC2' Pricing Flexfield 5 2170 Varchar2 10 80 101 A2 PC2 SO_LINES_INTERFACE PRICING_ATTRIBUTE5 Pricing Flexfield 6 2170 Varchar2 20 80 181 A2 PC2 SO_LINES_INTERFACE PRICING_ATTRIBUTE6 Pricing Flexfield 7 2170 Varchar2 30 80 261 A2 PC2 SO_LINES_INTERFACE PRICING_ATTRIBUTE7 Pricing Flexfield 8 2170 Varchar2 40 80 341 A2 PC2 SO_LINES_INTERFACE PRICING_ATTRIBUTE8 Pricing Flexfield 9 2170 Varchar2 50 80 421 A2 PC2 SO_LINES_INTERFACE PRICING_ATTRIBUTE9 RECORD 2180 Common Key (Positions 1-91) 2180 Varchar2 91 1 Record Number 2180 Varchar2 4 92 Constant '2180' Record Layout 2180 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2180 Varchar2 3 98 Constant 'PC3' Pricing Flexfield 10 2180 Varchar2 10 80 101 A2 PC3 SO_LINES_INTERFACE PRICING_ATTRIBUTE10 Pricing Flexfield 11 2180 Varchar2 20 80 181 A2 PC3 SO_LINES_INTERFACE PRICING_ATTRIBUTE11 Pricing Flexfield 12 2180 Varchar2 30 80 261 A2 PC3 SO_LINES_INTERFACE PRICING_ATTRIBUTE12 Pricing Flexfield 13 2180 Varchar2 40 80 341 A2 PC3 SO_LINES_INTERFACE PRICING_ATTRIBUTE13 Pricing Flexfield 14 2180 Varchar2 50 80 421 A2 PC3 SO_LINES_INTERFACE PRICING_ATTRIBUTE14 RECORD 2190 Common Key (Positions 1-91) 2190 Varchar2 91 1 Record Number 2190 Varchar2 4 92 Constant '2190' Record Layout 2190 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2190 Varchar2 3 98 Constant 'PC4' Pricing Flexfield 15 2190 Varchar2 10 80 101 A2 PC4 SO_LINES_INTERFACE PRICING_ATTRIBUTE15 RECORD 2200 Common Key (Positions 1-91) 2200 Varchar2 91 1 Record Number 2200 Varchar2 4 92 Constant '2200' Record Layout 2200 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 2200 Varchar2 3 98 Constant 'IT6' Order Source ID 2200 Number 10 22 101 IT IT6 SO_LINES_INTERFACE ORDER_SOURCE_ID Order System Reference 2200 Varchar2 20 50 123 IT IT6 SO_LINES_INTERFACE ORIGINAL_SYSTEM_REFERENCE Order System Line Reference 2200 Varchar2 30 50 173 IT IT6 SO_LINES_INTERFACE ORIGINAL_SYSTEM_LINE_REFERENCE Date Requested Current 2200 Date 40 15 223 IT IT6 SO_LINES_INTERFACE DATE_REQUESTED_CURRENT Selling Price 2200 Number 50 22 238 IT IT6 SO_LINES_INTERFACE SELLING_PRICE Calculated Price Flag 2200 Varchar2 60 1 260 IT IT6 SO_LINES_INTERFACE CALCULATE_PRICE Ship Method Code 2200 Varchar2 70 30 261 IT IT6 SO_LINES_INTERFACE SHIP_METHOD_CODE Shipment Priority Code 2200 Varchar2 80 30 291 IT IT6 SO_LINES_INTERFACE SHIP_PRIORITY_CODE RECORD 3010 Common Key (Positions 1-91) 3010 Varchar2 91 1 Record Number 3010 Varchar2 4 92 Constant '3010' Record Layout 3010 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 3010 Varchar2 3 98 Constant 'IT1' Context 3010 Varchar2 10 30 101 A1 IT1 SO_LINES_INTERFACE CONTEXT Purchase Order Header Flexfield 1 3010 Varchar2 20 80 131 A1 IT1 SO_LINES_INTERFACE ATTRIBUTE1 Purchase Order Header Flexfield 2 3010 Varchar2 30 80 211 A1 IT1 SO_LINES_INTERFACE ATTRIBUTE2 Purchase Order Header Flexfield 3 3010 Varchar2 40 80 291 A1 IT1 SO_LINES_INTERFACE ATTRIBUTE3 Purchase Order Header Flexfield 4 3010 Varchar2 50 80 371 A1 IT1 SO_LINES_INTERFACE ATTRIBUTE4 RECORD 3020 Common Key (Positions 1-91) 3020 Varchar2 91 1 Record Number 3020 Varchar2 4 92 Constant '3020' Record Layout 3020 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3020 Varchar2 3 98 Constant 'IT2' Purchase Order Header Flexfield 5 3020 Varchar2 10 80 101 A2 IT2 SO_LINES_INTERFACE ATTRIBUTE5 Purchase Order Header Flexfield 6 3020 Varchar2 20 80 181 A2 IT2 SO_LINES_INTERFACE ATTRIBUTE6 Purchase Order Header Flexfield 7 3020 Varchar2 30 80 261 A2 IT2 SO_LINES_INTERFACE ATTRIBUTE7 Purchase Order Header Flexfield 8 3020 Varchar2 40 80 341 A2 IT2 SO_LINES_INTERFACE ATTRIBUTE8 Purchase Order Header Flexfield 9 3020 Varchar2 50 80 421 A2 IT2 SO_LINES_INTERFACE ATTRIBUTE9 RECORD 3030 Common Key (Positions 1-91) 3030 Varchar2 91 1 Record Number 3030 Varchar2 4 92 Constant '3030' Record Layout 3030 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3030 Varchar2 3 98 Constant 'IT3' Purchase Order Header Flexfield 10 3030 Varchar2 10 80 101 A2 IT3 SO_LINES_INTERFACE ATTRIBUTE10 Purchase Order Header Flexfield 11 3030 Varchar2 20 80 181 A2 IT3 SO_LINES_INTERFACE ATTRIBUTE11 Purchase Order Header Flexfield 12 3030 Varchar2 30 80 261 A2 IT3 SO_LINES_INTERFACE ATTRIBUTE12 Purchase Order Header Flexfield 13 3030 Varchar2 40 80 341 A2 IT3 SO_LINES_INTERFACE ATTRIBUTE13 Purchase Order Header Flexfield 14 3030 Varchar2 50 80 421 A2 IT3 SO_LINES_INTERFACE ATTRIBUTE14 RECORD 3040 Common Key (Positions 1-91) 3040 Varchar2 91 1 Record Number 3040 Varchar2 4 92 Constant '3040' Record Layout 3040 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 3040 Varchar2 3 98 Constant 'IT4' Purchase Order Header Flexfield 15 3040 Varchar2 10 80 101 A2 IT4 SO_LINES_INTERFACE ATTRIBUTE15 RECORD 3050 Common Key (Positions 1-91) 3050 Varchar2 91 1 Record Number 3050 Varchar2 4 92 Constant '3050' Record Layout 3050 Varchar2 2 96 Constant 'AX' Record Layout Qualifier 3050 Varchar2 3 98 Constant 'ST1' Ship to Site (Internal) 3050 Varchar2 10 20 101 AX ST1 SO_LINES_INTERFACE SHIP_ADDRESS_ID Ship to Site (Ext) 3050 Varchar2 20 20 121 AX ST1 SO_LINES_INTERFACE Ship to Customer (Header Level) 3050 Varchar2 30 50 141 AX ST1 SO_LINES_INTERFACE Ship to Address 1 (Header Level) 3050 Varchar2 40 35 191 AX ST1 SO_LINES_INTERFACE SHIP_ADDRESS1 Ship to Address 2 (Header Level) 3050 Varchar2 50 35 226 AX ST1 SO_LINES_INTERFACE SHIP_ADDRESS2 Ship to Address 3 (Header Level) 3050 Varchar2 60 35 261 AX ST1 SO_LINES_INTERFACE SHIP_ADDRESS3 Ship to Address 4 (Header Level) 3050 Varchar2 70 35 296 AX ST1 SO_LINES_INTERFACE SHIP_ADDRESS4 Ship To City (Header Level) 3050 Varchar2 80 30 331 AX ST1 SO_LINES_INTERFACE SHIP_CITY Ship To Postal Code (Header) 3050 Varchar2 90 15 361 AX ST1 SO_LINES_INTERFACE SHIP_Purchase Order HeaderSTAL_CODE Ship To Country (Header Level) COUNTRY 3050 Varchar2100 3 376 AX ST1 SO_LINES_INTERFACE SHIP_COUNTRY Ship To Country (Ext1) 3050 Varchar2110 3 379 AX ST1 SO_LINES_INTERFACE Ship to Region 1 (Internal) REGION1 3050 Varchar2120 30 382 AX ST1 SO_LINES_INTERFACE SHIP_STATE Ship To Region 1 (Ext1) 3050 Varchar2130 10 412 AX ST1 SO_LINES_INTERFACE Ship To Region 2 (Internal) 3050 Varchar2140 30 422 AX ST1 SO_LINES_INTERFACE Ship To Region 2 (Ext1) 3050 Varchar2150 10 452 AX ST1 SO_LINES_INTERFACE Ship To Region 3 (Internal) REGION3 3050 Varchar2160 30 462 AX ST1 SO_LINES_INTERFACE SHIP_COUNTY Ship To Region 3 (Ext1) 3050 Varchar2170 10 492 AX ST1 SO_LINES_INTERFACE RECORD 3060 Common Key (Positions 1-91) 3060 Varchar2 91 1 Record Number 3060 Varchar2 4 92 Constant '3060' Record Layout 3060 Varchar2 2 96 Constant 'CN' Record Layout Qualifier 3060 Varchar2 3 98 Constant 'ST1' Ship to Contact Last Name 3060 Varchar2 10 50 101 CN ST1 SO_LINES_INTERFACE SHIP_TO_CONTACT_LAST_NAME Ship to Contact First Name 3060 Varchar2 20 30 151 CN ST1 SO_LINES_INTERFACE SHIP_TO_CONTACT_FIRST_NAME Ship To Contact Job Title 3060 Varchar2 30 40 181 CN ST1 SO_LINES_INTERFACE Ship To Contact Area Code 1 3060 Varchar2 40 10 221 CN ST1 SO_LINES_INTERFACE Ship to Phone 1 3060 Varchar2 50 60 231 CN ST1 SO_LINES_INTERFACE Ship To Contact Area Code 2 3060 Varchar2 60 10 291 CN ST1 SO_LINES_INTERFACE Ship to Phone 2 3060 Varchar2 70 60 301 CN ST1 SO_LINES_INTERFACE Ship To Contact Area Code 3 3060 Varchar2 80 10 361 CN ST1 SO_LINES_INTERFACE Ship to Phone 3 3060 Varchar2 90 60 371 CN ST1 SO_LINES_INTERFACE
Previous | Next | Contents | Index | Navigation | Glossary | Library |