|
|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Navigation | Glossary | Library |
This section is best viewed when printed in landscape orientation.
See: Data File Definition Format Legend for a description of the columns making up the data file definition table.
Field Description Code Category Rec Format Pos Width Start Rec 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 Varchar2 100 80 291 CT CTL
Trading Partner Reference 2 0010 Varchar2 110 80 371 CT CTL
Transaction Date/Time 0010 Date 120 15 451 CT CTL
Transaction Run ID 0010 Number 130 15 466 CT CTL
Transaction Control 1 (Inbound) 0010 Varchar2 140 10 481 CT CTL
Transaction Control 2 (Inbound) 0010 Varchar2 150 10 491 CT CTL
Transaction Control 3 (Inbound) 0010 Varchar2 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 'HA'
Record Layout Qualifier 1000 Varchar2 3 98 Constant 'HD1'
Vendor Document Number 1000 Varchar2 10 25 101 HA HD1 PO_HEADERS_INTERFACE VENDOR_DOC_NUM
Effective Date 1000 Date 20 15 126 HA HD1 PO_HEADERS_INTERFACE EFFECTIVE_DATE
Expiration Date 1000 Date 30 15 141 HA HD1 PO_HEADERS_INTERFACE EXPIRATION_DATE
From RFQ Number 1000 Varchar2 40 25 156 HA HD1 PO_HEADERS_INTERFACE FROM_RFQ_NUM
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 'HB'
Record Layout Qualifier 1010 Varchar2 3 98 Constant 'HD2'
Amount Agreed 1010 Number 10 22 101 HB HD2 PO_HEADERS_INTERFACE AMOUNT_AGREED
Currency Code (Internal) CURRENCY 1010 Varchar2 20 15 123 HB HD2 PO_HEADERS_INTERFACE CURRENCY_CODE
Currency Code (Ext1) 1010 Varchar2 30 3 138 HB HD2
Currency Conversion Rate 1010 Number 40 22 141 HB HD2 PO_HEADERS_INTERFACE RATE
Currency Conversion Date 1010 Date 50 15 163 HB HD2 PO_HEADERS_INTERFACE RATE_DATE
Currency Conversion Type (Internal) CURR_CONV_TYPE 1010 Varchar2 60 30 178 HB HD2 PO_HEADERS_INTERFACE RATE_TYPE
Currency Conversion Type (Ext1) 1010 Varchar2 70 10 208 HB HD2
Payment Terms (Internal) PAYMENT_TERMS 1010 Varchar2 80 40 218 HB HD2 PO_HEADERS_INTERFACE PAYMENT_TERMS
Payment Terms (Ext1) 1010 Varchar2 90 40 258 HB HD2
Payment Terms (Ext2) 1010 Varchar2 100 40 298 HB HD2
Payment Terms (Ext3) 1010 Varchar2 110 40 338 HB HD2
Payment Terms (Ext4) 1010 Varchar2 120 40 378 HB HD2
Payment Terms (Ext5) 1010 Varchar2 130 40 418 HB HD2
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 'HD'
Record Layout Qualifier 1020 Varchar2 3 98 Constant 'HD3'
Ship Via (Internal) SHIP_VIA 1020 Varchar2 10 25 101 HD HD3 PO_HEADERS_INTERFACE FREIGHT_CARRIER
Ship Via (Ext1) 1020 Varchar2 20 20 126 HD HD3
FOB Code (Internal) FOB 1020 Varchar2 30 25 146 HD HD3 PO_HEADERS_INTERFACE FOB
FOB Code (Ext1) 1020 Varchar2 40 10 171 HD HD3
Freight Terms Code (Internal) FREIGHT_TERMS 1020 Varchar2 50 25 181 HD HD3 PO_HEADERS_INTERFACE FREIGHT_TERMS
Freight Terms Code (Ext1) 1020 Varchar2 60 10 206 HD HD3
RECORD 1030
Common Key (Positions 1-91) 1030 Varchar2 91 1
Record Number 1030 Varchar2 4 92 Constant '1040'
Record Layout 1030 Varchar2 2 96 Constant 'HD'
Record Layout Qualifier 1030 Varchar2 3 98 Constant 'HD4'
Action Type Code (Internal) ACTION_TYPE 1030 Varchar2 10 25 101 HD HD4 PO_HEADERS_INTERFACE ACTION
Action Type Code (Ext1) 1030 Varchar2 20 80 126 HD HD4
RECORD 1040
Common Key (Positions 1-91) 1040 Varchar2 91 1
Record Number 1040 Varchar2 4 92 Constant '1050'
Record Layout 1040 Varchar2 2 96 Constant 'NT'
Record Layout Qualifier 1040 Varchar2 3 98 Constant 'HCM'
Comments 1040 Varchar2 10 240 101 NT MCM PO_HEADERS_INTERFACE COMMENTS
RECORD 1100
Common Key (Positions 1-91) 1100 Varchar2 91 1
Record Number 1100 Varchar2 4 92 Constant '1100'
Record Layout 1100 Varchar2 2 96 Constant 'AD'
Record Layout Qualifier 1100 Varchar2 3 98 Constant 'ST1'
Ship To Code (Internal) 1100 Number 10 22 101 AD ST1 PO_HEADERS_INTERFACE SHIP_TO_LOCATION_ID
Ship To Code (External) 1100 Varchar2 20 20 123 AD ST1
Ship To Customer Name 1100 Varchar2 30 60 143 AD ST1
Ship To Address 1 1100 Varchar2 40 35 203 AD ST1
Ship To Address 2 1100 Varchar2 50 35 238 AD ST1
Ship To Address 3 1100 Varchar2 60 35 273 AD ST1
Ship To Address 4 1100 Varchar2 70 35 308 AD ST1
Ship To City 1100 Varchar2 80 30 343 AD ST1
Ship To Postal Code 1100 Varchar2 90 15 373 AD ST1
Ship To Country (Internal) COUNTRY 1100 Varchar2 100 20 388 AD ST1
Ship To Country (Ext1) 1100 Varchar2 110 3 408 AD ST1
Ship To State (Internal) STATE 1100 Varchar2 120 20 411 AD ST1
Ship To State (Ext1) 1100 Varchar2 130 10 431 AD ST1
Ship To Province (Internal) PROVINCE 1100 Varchar2 140 20 441 AD ST1
Ship To Province (Ext1) 1100 Varchar2 150 10 461 AD ST1
Ship To County 1100 Varchar2 160 10 471 AD ST1
RECORD 1110
Common Key (Positions 1-91) 1110 Varchar2 91 1
Record Number 1110 Varchar2 4 92 Constant '1110'
Record Layout 1110 Varchar2 2 96 Constant 'AD'
Record Layout Qualifier 1110 Varchar2 3 98 Constant 'BT1'
Bill To Code (Internal) 1110 Number 10 22 101 AD BT1 PO_HEADERS_INTERFACE BILL_TO_LOCATION_ID
Bill To Code (External) 1110 Varchar2 20 20 123 AD BT1
Bill To Customer Name 1110 Varchar2 30 60 143 AD BT1
Bill To Address 1 1110 Varchar2 40 35 203 AD BT1
Bill To Address 2 1110 Varchar2 50 35 238 AD BT1
Bill To Address 3 1110 Varchar2 60 35 273 AD BT1
Bill To Address 4 1110 Varchar2 70 35 308 AD BT1
Bill To City 1110 Varchar2 80 30 343 AD BT1
Bill To Postal Code 1110 Varchar2 90 15 373 AD BT1
Bill To Country (Internal) COUNTRY 1110 Varchar2 100 20 388 AD BT1
Bill To Country (Ext1) 1110 Varchar2 110 3 408 AD BT1
Bill To State (Internal) STATE 1110 Varchar2 120 20 411 AD BT1
Bill To State (Ext1) 1110 Varchar2 130 10 431 AD BT1
Bill To Province (Internal) PROVINCE 1110 Varchar2 140 20 441 AD BT1
Bill To Province (Ext1) 1110 Varchar2 150 10 461 AD BT1
Bill To County 1110 Varchar2 160 25 471 AD BT1
RECORD 1120
Common Key (Positions 1-91) 1120 Varchar2 91 1
Record Number 1120 Varchar2 4 92 Constant '1120'
Record Layout 1120 Varchar2 2 96 Constant 'VN'
Record Layout Qualifier 1120 Varchar2 3 98 Constant 'VN1'
Vendor Site Location (Internal) VENDOR_SITE 1120 Varchar2 10 15 101 VN VN1 PO_HEADERS_INTERFACE VENDOR_SITE_CODE
Vendor Site Location (External) 1120 Varchar2 20 15 116 VN VN1
Vendor Name (Internal) VENDOR_NAME 1120 Varchar2 30 80 131 VN VN1 PO_HEADERS_INTERFACE VENDOR_NAME
Vendor Name(External) 1120 Varchar2 40 80 211 VN VN1
Vendor Contact Last Name 1120 Varchar2 50 50 291 VN VN1 PO_HEADERS_INTERFACE VENDOR_CONTACT
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 'A1'
Record Layout Qualifier 1200 Varchar2 3 98 Constant 'HD1'
Header Flexfield Context 1200 Varchar2 10 30 101 A1 HD1 PO_HEADERS_INTERFACE ATTRIBUTE_CATEGORY
Header Flexfield 1 1200 Varchar2 20 80 131 A1 HD1 PO_HEADERS_INTERFACE ATTRIBUTE1
Header Flexfield 2 1200 Varchar2 30 80 211 A1 HD1 PO_HEADERS_INTERFACE ATTRIBUTE2
Header Flexfield 3 1200 Varchar2 40 80 291 A1 HD1 PO_HEADERS_INTERFACE ATTRIBUTE3
Header Flexfield 4 1200 Varchar2 50 80 371 A1 HD1 PO_HEADERS_INTERFACE ATTRIBUTE4
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 'A2'
Record Layout Qualifier 1210 Varchar2 3 98 Constant 'HD2'
Header Flexfield 5 1210 Varchar2 10 80 101 A2 HD2 PO_HEADERS_INTERFACE ATTRIBUTE5
Header Flexfield 6 1210 Varchar2 20 80 181 A2 HD2 PO_HEADERS_INTERFACE ATTRIBUTE6
Header Flexfield 7 1210 Varchar2 30 80 261 A2 HD2 PO_HEADERS_INTERFACE ATTRIBUTE7
Header Flexfield 8 1210 Varchar2 40 80 341 A2 HD2 PO_HEADERS_INTERFACE ATTRIBUTE8
Header Flexfield 9 1210 Varchar2 50 80 421 A2 HD2 PO_HEADERS_INTERFACE ATTRIBUTE9
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 'A2'
Record Layout Qualifier 1220 Varchar2 3 98 Constant 'HD3'
Header Flexfield 10 1220 Varchar2 10 80 101 A2 HD3 PO_HEADERS_INTERFACE ATTRIBUTE10
Header Flexfield 11 1220 Varchar2 20 80 181 A2 HD3 PO_HEADERS_INTERFACE ATTRIBUTE11
Header Flexfield 12 1220 Varchar2 30 80 261 A2 HD3 PO_HEADERS_INTERFACE ATTRIBUTE12
Header Flexfield 13 1220 Varchar2 40 80 341 A2 HD3 PO_HEADERS_INTERFACE ATTRIBUTE13
Header Flexfield 14 1220 Varchar2 50 80 421 A2 HD3 PO_HEADERS_INTERFACE ATTRIBUTE14
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 'A2'
Record Layout Qualifier 1230 Varchar2 3 98 Constant 'HD4'
Header Flexfield 15 1230 Varchar2 10 80 101 A2 HD4 PO_HEADERS_INTERFACE ATTRIBUTE15
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 'IA'
Record Layout Qualifier 2000 Varchar2 3 98 Constant 'IT1'
Line Number 2000 Number 10 22 101 IA IT1 PO_LINES_INTERFACE LINE_NUM
Item 2000 Varchar2 20 80 123 IA IT1 PO_LINES_INTERFACE ITEM
Vendor Product Number 2000 Varchar2 30 25 203 IA IT1 PO_LINES_INTERFACE VENDOR_PRODUCT_NUM
Item Category (Internal) ITEM_CATEGORY 2000 Varchar2 40 46 228 IA IT1 PO_LINES_INTERFACE CATEGORY
Item Category (Ext1) 2000 Varchar2 50 100 274 IA IT1
RECORD 2010
Common Key (Positions 1-91) 2010 Varchar2 91 1
Record Number 2010 Varchar2 4 92 Constant '2010'
Record Layout 2010 Varchar2 2 96 Constant 'IB'
Record Layout Qualifier 2010 Varchar2 3 98 Constant 'IT2'
Quantity 2010 Number 10 22 101 IB IT2 PO_LINES_INTERFACE QUANTITY
Minimum Order Quantity 2010 Number 20 22 123 IB IT2 PO_LINES_INTERFACE MIN_ORDER_QUANTITY
Maximum Order Quantity 2010 Number 30 22 145 IB IT2 PO_LINES_INTERFACE MAX_ORDER_QUANTITY
Unit of Measure (Internal) UOM 2010 Varchar2 40 25 167 IB IT2 PO_LINES_INTERFACE UNIT_OF_MEASURE
Unit of Measure (Ext1) 2010 Varchar2 50 25 192 IB IT2
Effective Date 2010 Date 60 15 217 IB IT2 PO_LINES_INTERFACE EFFECTIVE_DATE
Expiration Date 2010 Date 70 15 232 IB IT2 PO_LINES_INTERFACE EXPIRATION_DATE
Item Description 2010 Varchar2 80 80 247 IB IT2 PO_LINES_INTERFACE ITEM_DESCRIPTION
RECORD 2020
Common Key (Positions 1-91) 2020 Varchar2 91 1
Record Number 2020 Varchar2 4 92 Constant '2020'
Record Layout 2020 Varchar2 2 96 Constant 'IC'
Record Layout Qualifier 2020 Varchar2 3 98 Constant 'IT3'
Unit Price 2020 Number 10 22 101 IC IT3 PO_LINES_INTERFACE UNIT_PRICE
List Price Per Unit 2020 Number 20 22 123 IC IT3 PO_LINES_INTERFACE LIST_PRICE_PER_UNIT
Market Price 2020 Number 30 22 145 IC IT3 PO_LINES_INTERFACE MARKET_PRICE
Price Discount 2020 Number 40 22 167 IC IT3 PO_LINES_INTERFACE PRICE_DISCOUNT
Promised Date 2020 Date 50 15 189 IC IT3 PO_LINES_INTERFACE PROMISED_DATE
RECORD 2030
Common Key (Positions 1-91) 2030 Varchar2 91 1
Record Number 2030 Varchar2 4 92 Constant '2030'
Record Layout 2030 Varchar2 2 96 Constant 'ID'
Record Layout Qualifier 2030 Varchar2 3 98 Constant 'IT4'
Payment Terms (Internal) PAYMENT_TERM 2030 Varchar2 10 40 101 ID IT4 PO_LINES_INTERFACE PAYMENT_TERMS
Payment Terms (Ext1) 2030 Varchar2 20 40 141 ID IT4
Payment Terms (Ext2) 2030 Varchar2 30 40 181 ID IT4
Payment Terms (Ext3) 2030 Varchar2 40 40 221 ID IT4
Payment Terms (Ext4) 2030 Varchar2 50 40 261 ID IT4
Payment Terms (Ext5) 2030 Varchar2 60 40 301 ID IT4
RECORD 2040
Common Key (Positions 1-91) 2040 Varchar2 91 1
Record Number 2040 Varchar2 4 92 Constant '2040'
Record Layout 2040 Varchar2 2 96 Constant 'IE'
Record Layout Qualifier 2040 Varchar2 3 98 Constant 'IT5'
Ship Via (Internal) SHIP_VIA 2040 Varchar2 10 25 101 IE IT5 PO_LINES_INTERFACE FREIGHT_CARRIER
Ship Via (Ext1) 2040 Varchar2 20 20 126 IE IT5
Ship Via (Ext2) 2040 Varchar2 30 20 146 IE IT5
Ship Via (Ext3) 2040 Varchar2 40 80 166 IE IT5
FOB Code (Internal) FOB 2040 Varchar2 50 25 246 IE IT5 PO_LINES_INTERFACE FOB
FOB Code (Ext1) 2040 Varchar2 60 10 271 IE IT5
Freight Terms Code (Internal) FREIGHT_TERMS 2040 Varchar2 70 25 281 IE IT5 PO_LINES_INTERFACE FREIGHT_TERMS
Freight Terms Code (Ext1) 2040 Varchar2 80 80 306 IE IT5
RECORD 2050
Common Key (Positions 1-91) 2050 Varchar2 91 1
Record Number 2050 Varchar2 4 92 Constant '2050'
Record Layout 2050 Varchar2 2 96 Constant 'IF'
Record Layout Qualifier 2050 Varchar2 3 98 Constant 'IT6'
Shipment Number 2050 Number 10 22 101 IF IT6 PO_LINES_INTERFACE SHIPMENT_NUM
UN Number 2050 Varchar2 20 25 123 IF IT6 PO_LINES_INTERFACE UN_NUMBER
Hazard Class (Internal) HAZ_CLASS 2050 Varchar2 30 40 148 IF IT6 PO_LINES_INTERFACE HAZARD_CLASS
Hazard Class (Ext1) 2050 Varchar2 40 80 188 IF IT6
Weight 2050 Number 50 22 268 IF IT6 PO_LINES_INTERFACE UNIT_WEIGHT
Weight UOM Code (Internal) UOM 2050 Varchar2 60 3 290 IF IT6 PO_LINES_INTERFACE WEIGHT_UOM_CODE
Weight UOM Code (Ext1) 2050 Varchar2 70 3 293 IF IT6
Volume 2050 Number 80 22 296 IF IT6 PO_LINES_INTERFACE UNIT_VOLUME
Volume UOM Code (Internal) UOM 2050 Varchar2 90 3 318 IF IT6 PO_LINES_INTERFACE VOLUME_UOM_CODE
Volume UOM Code (Ext1) 2050 Varchar2 100 3 321 IF IT6
Lead Time 2050 Number 110 22 324 IF IT6 PO_LINES_INTERFACE LEAD_TIME
Lead Time Unit (Internal) UOM 2050 Varchar2 120 25 346 IF IT6 PO_LINES_INTERFACE LEAD_TIME_UNIT
Lead Time Unit (Ext1) 2050 Varchar2 130 3 371 IF IT6
RECORD 2100
Common Key (Positions 1-91) 2100 Varchar2 91 1
Record Number 2100 Varchar2 4 92 Constant '2100'
Record Layout 2100 Varchar2 2 96 Constant 'AD'
Record Layout Qualifier 2100 Varchar2 3 98 Constant 'SH2'
Ship To Code (Internal) 2100 Number 10 22 101 AD SH2 PO_LINES_INTERFACE SHIP_TO_LOCATION
Ship To Code (Ext1) 2100 Varchar2 20 20 123 AD SH2
Ship To Customer Name 2100 Varchar2 30 60 143 AD SH2
Ship To Address 1 2100 Varchar2 40 35 203 AD SH2
Ship To Address 2 2100 Varchar2 50 35 238 AD SH2
Ship To Address 3 2100 Varchar2 60 35 273 AD SH2
Ship To Address 4 2100 Varchar2 70 35 308 AD SH2
Ship To City 2100 Varchar2 80 30 343 AD SH2
Ship To Postal Code 2100 Varchar2 90 15 373 AD SH2
Ship To Country (Internal) COUNTRY 2100 Varchar2 100 20 388 AD SH2
Ship To Country (Ext1) 2100 Varchar2 110 3 408 AD SH2
Ship To State (Internal) STATE 2100 Varchar2 120 20 411 AD SH2
Ship To State (Ext1) 2100 Varchar2 130 10 431 AD SH2
Ship To Province (Internal) PROVINCE 2100 Varchar2 140 20 441 AD SH2
Ship To Province (Ext1) 2100 Varchar2 150 10 461 AD SH2
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 'A1'
Record Layout Qualifier 2200 Varchar2 3 98 Constant 'LN1'
Line Flexfield Context 2200 Varchar2 10 30 101 A1 LN1 PO_LINES_INTERFACE LINE_ATTRIBUTE_CATEGORY_LINES
Line Flexfield 1 2200 Varchar2 20 80 131 A1 LN1 PO_LINES_INTERFACE LINE_ATTRIBUTE1
Line Flexfield 2 2200 Varchar2 30 80 211 A1 LN1 PO_LINES_INTERFACE LINE_ATTRIBUTE2
Line Flexfield 3 2200 Varchar2 40 80 291 A1 LN1 PO_LINES_INTERFACE LINE_ATTRIBUTE3
Line Flexfield 4 2200 Varchar2 50 80 371 A1 LN1 PO_LINES_INTERFACE LINE_ATTRIBUTE4
RECORD 2210
Common Key (Positions 1-91) 2210 Varchar2 91 1
Record Number 2210 Varchar2 4 92 Constant '2210'
Record Layout 2210 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2210 Varchar2 3 98 Constant 'LN2'
Line Flexfield 5 2210 Varchar2 10 80 101 A2 LN2 PO_LINES_INTERFACE LINE_ATTRIBUTE5
Line Flexfield 6 2210 Varchar2 20 80 181 A2 LN2 PO_LINES_INTERFACE LINE_ATTRIBUTE6
Line Flexfield 7 2210 Varchar2 30 80 261 A2 LN2 PO_LINES_INTERFACE LINE_ATTRIBUTE7
Line Flexfield 8 2210 Varchar2 40 80 341 A2 LN2 PO_LINES_INTERFACE LINE_ATTRIBUTE8
Line Flexfield 9 2210 Varchar2 50 80 421 A2 LN2 PO_LINES_INTERFACE LINE_ATTRIBUTE9
RECORD 2220
Common Key (Positions 1-91) 2220 Varchar2 91 1
Record Number 2220 Varchar2 4 92 Constant '2220'
Record Layout 2220 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2220 Varchar2 3 98 Constant 'LN3'
Line Flexfield 10 2220 Varchar2 10 80 101 A2 LN3 PO_LINES_INTERFACE LINE_ATTRIBUTE10
Line Flexfield 11 2220 Varchar2 20 80 181 A2 LN3 PO_LINES_INTERFACE LINE_ATTRIBUTE11
Line Flexfield 12 2220 Varchar2 30 80 261 A2 LN3 PO_LINES_INTERFACE LINE_ATTRIBUTE12
Line Flexfield 13 2220 Varchar2 40 80 341 A2 LN3 PO_LINES_INTERFACE LINE_ATTRIBUTE13
Line Flexfield 14 2220 Varchar2 50 80 421 A2 LN3 PO_LINES_INTERFACE LINE_ATTRIBUTE14
RECORD 2230
Common Key (Positions 1-91) 2230 Varchar2 91 1
Record Number 2230 Varchar2 4 92 Constant '2230'
Record Layout 2230 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2230 Varchar2 3 98 Constant 'LN4'
Line Flexfield 15 2230 Varchar2 10 80 101 A2 LN4 PO_LINES_INTERFACE LINE_ATTRIBUTE15
RECORD 2240
Common Key (Positions 1-91) 2240 Varchar2 91 1
Record Number 2240 Varchar2 4 92 Constant '2240'
Record Layout 2240 Varchar2 2 96 Constant 'A1'
Record Layout Qualifier 2240 Varchar2 3 98 Constant 'SH1'
Shipment Flexfield Context 2240 Varchar2 10 30 101 A1 SH1 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE_CATEGORY
Shipment Flexfield 1 2240 Varchar2 20 80 131 A1 SH1 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE1
Shipment Flexfield 2 2240 Varchar2 30 80 211 A1 SH1 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE2
Shipment Flexfield 3 2240 Varchar2 40 80 291 A1 SH1 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE3
Shipment Flexfield 4 2240 Varchar2 50 80 371 A1 SH1 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE4
RECORD 2250
Common Key (Positions 1-91) 2250 Varchar2 91 1
Record Number 2250 Varchar2 4 92 Constant '2250'
Record Layout 2250 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2250 Varchar2 3 98 Constant 'SH2'
Shipment Flexfield 5 2250 Varchar2 10 80 101 A2 SH2 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE5
Shipment Flexfield 6 2250 Varchar2 20 80 181 A2 SH2 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE6
Shipment Flexfield 7 2250 Varchar2 30 80 261 A2 SH2 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE7
Shipment Flexfield 8 2250 Varchar2 40 80 341 A2 SH2 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE8
Shipment Flexfield 9 2250 Varchar2 50 80 421 A2 SH2 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE9
RECORD 2260
Common Key (Positions 1-91) 2260 Varchar2 91 1
Record Number 2260 Varchar2 4 92 Constant '2250'
Record Layout 2260 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2260 Varchar2 3 98 Constant 'SH3'
Shipment Flexfield 10 2260 Varchar2 10 80 101 A2 SH3 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE10
Shipment Flexfield 11 2260 Varchar2 20 80 181 A2 SH3 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE11
Shipment Flexfield 12 2260 Varchar2 30 80 261 A2 SH3 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE12
Shipment Flexfield 13 2260 Varchar2 40 80 341 A2 SH3 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE13
Shipment Flexfield 14 2260 Varchar2 50 80 421 A2 SH3 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE14
RECORD 2270
Common Key (Positions 1-91) 2270 Varchar2 91 1
Record Number 2270 Varchar2 4 92 Constant '2270'
Record Layout 2270 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2270 Varchar2 3 98 Constant 'SH4'
Shipment Flexfield 15 2270 Varchar2 10 80 101 A2 SH4 PO_LINES_INTERFACE SHIPMENT_ATTRIBUTE15
RECORD 2280
Common Key (Positions 1-91) 2280 Varchar2 91 1
Record Number 2280 Varchar2 4 92 Constant '2280'
Record Layout 2280 Varchar2 2 96 Constant 'A1'
Record Layout Qualifier 2280 Varchar2 3 98 Constant 'IT1'
Item Flexfield Context 2280 Varchar2 10 30 101 A1 IT1 PO_LINES_INTERFACE ITEM_ATTRIBUTE_CATEGORY
Item Flexfield 1 2280 Varchar2 20 80 131 A1 IT1 PO_LINES_INTERFACE ITEM_ATTRIBUTE1
Item Flexfield 2 2280 Varchar2 30 80 211 A1 IT1 PO_LINES_INTERFACE ITEM_ATTRIBUTE2
Item Flexfield 3 2280 Varchar2 40 80 291 A1 IT1 PO_LINES_INTERFACE ITEM_ATTRIBUTE3
Item Flexfield 4 2280 Varchar2 50 80 371 A1 IT1 PO_LINES_INTERFACE ITEM_ATTRIBUTE4
RECORD 2290
Common Key (Positions 1-91) 2290 Varchar2 91 1
Record Number 2290 Varchar2 4 92 Constant '2290'
Record Layout 2290 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2290 Varchar2 3 98 Constant 'IT2'
Item Flexfield 5 2290 Varchar2 10 80 101 A2 IT2 PO_LINES_INTERFACE ITEM_ATTRIBUTE5
Item Flexfield 6 2290 Varchar2 20 80 181 A2 IT2 PO_LINES_INTERFACE ITEM_ATTRIBUTE6
Item Flexfield 7 2290 Varchar2 30 80 261 A2 IT2 PO_LINES_INTERFACE ITEM_ATTRIBUTE7
Item Flexfield 8 2290 Varchar2 40 80 341 A2 IT2 PO_LINES_INTERFACE ITEM_ATTRIBUTE8
Item Flexfield 9 2290 Varchar2 50 80 421 A2 IT2 PO_LINES_INTERFACE ITEM_ATTRIBUTE9
RECORD 2300
Common Key (Positions 1-91) 2300 Varchar2 91 1
Record Number 2300 Varchar2 4 92 Constant '2300'
Record Layout 2300 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2300 Varchar2 3 98 Constant 'IT3'
Item Flexfield 10 2300 Varchar2 10 80 101 A2 IT3 PO_LINES_INTERFACE ITEM_ATTRIBUTE10
Item Flexfield 11 2300 Varchar2 20 80 181 A2 IT3 PO_LINES_INTERFACE ITEM_ATTRIBUTE11
Item Flexfield 12 2300 Varchar2 30 80 261 A2 IT3 PO_LINES_INTERFACE ITEM_ATTRIBUTE12
Item Flexfield 13 2300 Varchar2 40 80 341 A2 IT3 PO_LINES_INTERFACE ITEM_ATTRIBUTE13
Item Flexfield 14 2300 Varchar2 50 80 421 A2 IT3 PO_LINES_INTERFACE ITEM_ATTRIBUTE14
RECORD 2310
Common Key (Positions 1-91) 2310 Varchar2 91 1
Record Number 2310 Varchar2 4 92 Constant '2310'
Record Layout 2310 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2310 Varchar2 3 98 Constant 'IT4'
Item Flexfield 15 2310 Varchar2 10 80 101 A2 IT4 PO_LINES_INTERFACE ITEM_ATTRIBUTE15
| Previous | Next | Contents | Index | Navigation | Glossary | Library |