|
|
|
|
|
|
|
|
|
| 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 Rec. Qual. Application Table Application+L25 Column
RECORD 0010 (DSNO)
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 Qualifier 0010 Varchar2 3 98 Constant 'CTL'
Communication Method 0010 Varchar2 10 2 101 CT CTL
Trading Partner Test Flag 0010 Varchar2 20 1 103 CT CTL ECE_TP_DETAILS TEST_FLAG
Transaction Type 0010 Varchar2 30 6 104 CT CTL ECE_TP_DETAILS DOCUMENT_ID
Document Type 0010 Varchar2 40 5 110 CT CTL ECE_TP_DETAILS DOCUMENT_TYPE
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 35 152 CT CTL ECE_TP_DETAILS TRANSLATOR_CODE
Trading Partner Location Code External 0010 Varchar2 80 35 187 CT CTL ECE_TP_HEADERS TP_LOCATION_CODE_EXT
Trading Partner Description 0010 Varchar2 90 71 222 CT CTL ECE_TP_HEADERS TP_DESCRIPTION
Trading Partner Reference Ext1 0010 Varchar2 100 80 293 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT1
Trading Partner Reference Ext2 0010 Varchar2 110 80 373 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT2
Transaction Date/Time 0010 Date 120 15 453 CT CTL
Transaction Run ID 0010 Varchar2 130 15 468 CT CTL
Transaction Control 1 0010 Varchar2 140 10 483 CT CTL
Transaction Control 2 0010 Varchar2 150 10 493 CT CTL
Transaction Control 3 0010 Varchar2 160 10 503 CT CTL
RECORD 0020 (DSNO)
Common Key (Positions 1-91) 0020 Varchar2 91 1
Record Number 0020 Varchar2 4 92 Constant '0020'
Record Layout 0020 Varchar2 2 96 Constant 'A1'
Record Qualifier 0020 Varchar2 3 98 Constant 'TH1'
Trading Partner Header Flexfield Context 0020 Varchar2 10 30 101 A1 TH1 ECE_TP_HEADERS ATTRIBUTE_CATEGORY
Trading Partner Header Flexfield 1 0020 Varchar2 20 80 131 A1 TH1 ECE_TP_HEADERS ATTRIBUTE1
Trading Partner Header Flexfield 2 0020 Varchar2 30 80 211 A1 TH1 ECE_TP_HEADERS ATTRIBUTE2
Trading Partner Header Flexfield 3 0020 Varchar2 40 80 291 A1 TH1 ECE_TP_HEADERS ATTRIBUTE3
Trading Partner Header Flexfield 4 0020 Varchar2 50 80 371 A1 TH1 ECE_TP_HEADERS ATTRIBUTE4
RECORD 0030 (DSNO)
Common Key (Positions 1-91) 0030 Varchar2 91 1
Record Number 0030 Varchar2 4 92 Constant '0030'
Record Layout 0030 Varchar2 2 96 Constant 'A2'
Record Qualifier 0030 Varchar2 3 98 Constant 'TH2'
Trading Partner Header Flexfield 5 0030 Varchar2 10 80 101 A2 TH2 ECE_TP_HEADERS ATTRIBUTE5
Trading Partner Header Flexfield 6 0030 Varchar2 20 80 181 A2 TH2 ECE_TP_HEADERS ATTRIBUTE6
Trading Partner Header Flexfield 7 0030 Varchar2 30 80 261 A2 TH2 ECE_TP_HEADERS ATTRIBUTE7
Trading Partner Header Flexfield 8 0030 Varchar2 40 80 341 A2 TH2 ECE_TP_HEADERS ATTRIBUTE8
Trading Partner Header Flexfield 9 0030 Varchar2 50 80 421 A2 TH2 ECE_TP_HEADERS ATTRIBUTE9
RECORD 0040 (DSNO)
Common Key (Positions 1-91) 0040 Varchar2 91 1
Record Number 0040 Varchar2 4 92 Constant '0040'
Record Layout 0040 Varchar2 2 96 Constant 'A2'
Record Qualifier 0040 Varchar2 3 98 Constant 'TH3'
Trading Partner Header Flexfield 10 0040 Varchar2 10 80 101 A2 TH3 ECE_TP_HEADERS ATTRIBUTE10
Trading Partner Header Flexfield 11 0040 Varchar2 20 80 181 A2 TH3 ECE_TP_HEADERS ATTRIBUTE11
Trading Partner Header Flexfield 12 0040 Varchar2 30 80 261 A2 TH3 ECE_TP_HEADERS ATTRIBUTE12
Trading Partner Header Flexfield 13 0040 Varchar2 40 80 341 A2 TH3 ECE_TP_HEADERS ATTRIBUTE13
Trading Partner Header Flexfield 14 0040 Varchar2 50 80 421 A2 TH3 ECE_TP_HEADERS ATTRIBUTE14
RECORD 0050 (DSNO)
Common Key (Positions 1-91) 0050 Varchar2 91 1
Record Number 0050 Varchar2 4 92 Constant '0050'
Record Layout 0050 Varchar2 2 96 Constant 'A2'
Record Qualifier 0050 Varchar2 3 98 Constant 'TH4'
Trading Partner Header Flexfield 15 0050 Varchar2 10 80 101 A2 TH4 ECE_TP_HEADERS ATTRIBUTE15
RECORD 1000 (DSNO)
Common Key (Positions 1-91) 1000 Varchar2 91 1
Record Number 1000 Varchar2 4 92 Constant '1000'
Record Layout 1000 Varchar2 2 96 Constant 'D1'
Record Qualifier 1000 Varchar2 3 98 Constant 'DP1'
Departure Name 1000 Varchar2 10 30 101 D1 DP1 WSH_DEPARTURES NAME
Departure Date 1000 Date 20 15 131 D1 DP1 WSH_DEPARTURES ACTUAL_DEPARTURE_DATE
Delivery Name 1000 Varchar2 30 30 146 D1 DP1 WSH_DELIVERIES DELIVERY_NAME
Master Bill of Lading Number 1000 Varchar2 40 30 176 D1 DP1 WSH_DEPARTURES BILL_OF_LADING
Shipper Number 1000 Varchar2 50 30 206 D1 DP1 WSH_DELIVERIES SHIPPER_NUMBER
Waybill Number 1000 Varchar2 60 30 236 D1 DP1 WSH_DELIVERIES WAYBILL
Bill of Lading Number 1000 Varchar2 70 30 266 D1 DP1 WSH_DELIVERIES DELIVERY_NAME
Invoice Number 1000 Varchar2 80 30 296 D1 DP1 WSH_DELIVERIES DELIVERY_NAME
Packing Slip Number 1000 Varchar2 90 30 326 D1 DP1 WSH_DELIVERIES DELIVERY_NAME
Actual Ship Date 1000 Date 100 15 356 D1 DP1 WSH_DEPARTURES ACTUAL_DEPARTURE_DATE
Expected Arrival Date 1000 Date 110 15 371 D1 DP1 WSH_DELIVERIES EXPECTED_ARRIVAL_DATE
Time Stamp Date 1000 Date 120 15 386 D1 DP1 WSH_DELIVERIES ASN_DATE_SENT
Time Stamp Sequence Number 1000 Number 130 22 401 D1 DP1 WSH_DELIVERIES ASN_SEQ_NUMBER
RECORD 1010 (DSNO)
Common Key (Positions 1-91) 1010 Varchar2 91 1
Record Number 1010 Varchar2 4 92 Constant '1010'
Record Layout 1010 Varchar2 2 96 Constant 'D2'
Record Qualifier 1010 Varchar2 3 98 Constant 'DP2'
Equipment Code (Int) EQUIPMENT 1010 Varchar2 10 30 101 D2 DP2 MTL_SYSTEM_ITEMS ITEM_TYPE
Equipment Code (Ext1) 1010 Varchar2 20 80 131 D2 DP2 ECE_XREF_DATA XREF_EXT_VALUE1
Equipment Prefix 1010 Varchar2 30 10 211 D2 DP2 WSH_DEPARTURES VEHICLE_NUMBER
Equipment Number 1010 Varchar2 40 30 221 D2 DP2 WSH_DEPARTURES VEHICLE_NUMBER
Equipment Seal Number 1010 Varchar2 50 15 251 D2 DP2 WSH_DEPARTURES SEAL_CODE
Carrier Name (Int) SHIP_VIA 1010 Varchar2 60 30 266 D2 DP2 WSH_DEPARTURES FREIGHT_CARRIER_CODE
Carrier Name (Ext1) 1010 Varchar2 70 20 296 D2 DP2 ECE_XREF_DATA XREF_EXT_VALUE1
Carrier Name (Ext 2) (Transportation Method) 1010 Varchar2 80 20 316 D2 DP2
RECORD 1015 (DSNO)
Common Key (Positions 1-91) 1015 Varchar2 91 1
Record Number 1015 Varchar2 4 92 Constant '1015'
Record Layout 1015 Varchar2 2 96 Constant 'D3'
Record Qualifier 1015 Varchar2 3 98 Constant 'DP3'
Departure Gross Weight 1015 Number 10 22 101 D3 DP3 WSH_DEPARTURES GROSS_WEIGHT
Departure Gross Weight UOM (Int) UOM 1015 Varchar2 20 5 123 D3 DP3 WSH_DEPARTURES WEIGHT_UOM_CODE
Departure Gross Weight UOM (Ext1) 1015 Varchar2 30 5 128 D3 DP3 ECE_XREF_DATA XREF_EXT_VALUE1
Departure Net Weight 1015 Number 40 22 133 D3 DP3 WSH_DEPARTURES NET_WEIGHT
Departure Net Weight UOM (Int) UOM 1015 Varchar2 50 5 155 D3 DP3 WSH_DEPARTURES WEIGHT_UOM_CODE
Departure Net Weight UOM (Ext1) 1015 Varchar2 60 5 160 D3 DP3 ECE_XREF_DATA XREF_EXT_VALUE1
Departure Tare Weight 1015 Number 70 22 165 D3 DP3
Departure Tare Weight UOM (Int) UOM 1015 Varchar2 80 5 187 D3 DP3 WSH_DEPARTURES WEIGHT_UOM_CODE
Departure Tare Weight UOM (Ext1) 1015 Varchar2 90 5 192 D3 DP3 ECE_XREF_DATA XREF_EXT_VALUE1
Departure Volume 1015 Number 100 22 197 D3 DP3 WSH_DEPARTURES VOLUME
Departure Volume UOM (Int) UOM 1015 Varchar2 110 5 219 D3 DP3 WSH_DEPARTURES VOLUME_UOM_CODE
Departure Volume UOM (Ext1) 1015 Varchar2 120 5 224 D3 DP3
RECORD 1020 (DSNO)
Common Key (Positions 1-91) 1020 Varchar2 91 1
Record Number 1020 Varchar2 4 92 Constant '1020'
Record Layout 1020 Varchar2 2 96 Constant 'D4'
Record Qualifier 1020 Varchar2 3 98 Constant 'DP4'
Picked By Name 1020 Varchar2 10 50 101 D4 DP4 FND_USERS USER_NAME
Packed By Name 1020 Varchar2 20 50 151 D4 DP4 FND_USERS USER_NAME
RECORD 1030 (DSNO)
Common Key (Positions 1-91) 1030 Varchar2 91 1
Record Number 1030 Varchar2 4 92 Constant '1030'
Record Layout 1030 Varchar2 2 96 Constant 'D5'
Record Qualifier 1030 Varchar2 3 98 Constant 'DP5'
Routing Instructions 1030 Varchar2 10 150 101 D5 DP5 WSH_DEPARTURES ROUTING_INSTRUCTIONS
RECORD 2000 (DSNO)
Common Key (Positions 1-91) 2000 Varchar2 91 1
Record Number 2000 Varchar2 4 92 Constant '2000'
Record Layout 2000 Varchar2 2 96 Constant 'AX'
Record Qualifier 2000 Varchar2 3 98 Constant 'SF'
Warehouse Code (Int) WAREHOUSE 2000 Varchar2 10 30 101 AX SF MTL_PARAMETERS ORGANIZATION_CODE
Warehouse Code (Ext) 2000 Varchar2 20 20 131 AX SF
Warehouse Name 2000 Varchar2 30 60 151 AX SF HR_ORGANIZATION_UNITS NAME
Warehouse Address Line 1 2000 Varchar2 40 35 211 AX SF HR_LOCATIONS ADDRESS_LINE_1
Warehouse Address Line 2 2000 Varchar2 50 35 246 AX SF HR_LOCATIONS ADDRESS_LINE_2
Warehouse Address Line 3 2000 Varchar2 60 35 281 AX SF HR_LOCATIONS ADDRESS_LINE_3
Warehouse City 2000 Varchar2 70 30 316 AX SF HR_LOCATIONS TOWN_OR_CITY
Warehouse Postal Code 2000 Varchar2 80 15 346 AX SF HR_LOCATIONS POSTAL_CODE
Warehouse Country (Int) COUNTRY 2000 Varchar2 90 20 361 AX SF HR_LOCATIONS COUNTRY
Warehouse Country (Ext1) 2000 Varchar2 100 3 381 AX SF ECE_XREF_DATA XREF_EXT_VALUE1
Warehouse Region 1 (Int) (county) REGION1 2000 Varchar2 110 25 384 AX SF HR_LOCATIONS REGION_1
Warehouse Region 1 (Ext1) (county) 2000 Varchar2 120 10 409 AX SF ECE_XREF_DATA XREF_EXT_VALUE1
Warehouse Region 2 (Int) (State) REGION2 2000 Varchar2 130 25 419 AX SF HR_LOCATIONS REGION_2
Warehouse Region 2 (Ext1) (State) 2000 Varchar2 140 10 444 AX SF ECE_XREF_DATA XREF_EXT_VALUE1
Warehouse Region 3 (Int) REGION3 2000 Varchar2 150 25 454 AX SF HR_LOCATIONS REGION_3
Warehouse Region 3 (Ext1) 2000 Varchar2 160 10 479 AX SF ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 2010 (DSNO)
Common Key (Positions 1-91) 2010 Varchar2 91 1
Record Number 2010 Varchar2 4 92 Constant '2010'
Record Layout 2010 Varchar2 2 96 Constant 'CM'
Record Qualifier 2010 Varchar2 3 98 Constant 'SF'
Warehouse Phone 1 2010 Varchar2 10 80 101 CM SF HR_LOCATIONS TELEPHONE_NUMBER_1
Warehouse Phone 2 2010 Varchar2 20 80 181 CM SF HR_LOCATIONS TELEPHONE_NUMBER_2
Warehouse Phone 3 2010 Varchar2 30 80 261 CM SF HR_LOCATIONS TELEPHONE_NUMBER_3
RECORD 2100 (DSNO)
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 Qualifier 2100 Varchar2 3 98 Constant 'IC'
Pooled Code (Int) 2100 Varchar2 10 20 101 AD IC RA_ADDRESSES_ALL ORIG_SYSTEM_REFERENCE
Pooled Code (Ext1) 2100 Varchar2 20 20 121 AD IC ECE_TP_HEADERS TP_LOCATION_CODE_EXT
Pooled Name 2100 Varchar2 30 60 141 AD IC RA_CUSTOMERS CUSTOMER_NAME
Pooled Address Line 1 2100 Varchar2 40 35 201 AD IC RA_ADDRESSES_ALL ADDRESS1
Pooled Address Line 2 2100 Varchar2 50 35 236 AD IC RA_ADDRESSES_ALL ADDRESS2
Pooled Address Line 3 2100 Varchar2 60 35 271 AD IC RA_ADDRESSES_ALL ADDRESS3
Pooled Address Line 4 2100 Varchar2 70 35 306 AD IC RA_ADDRESSES_ALL ADDRESS4
Pooled City 2100 Varchar2 80 30 341 AD IC RA_ADDRESSES_ALL CITY
Pooled Postal Code 2100 Varchar2 90 15 371 AD IC RA_ADDRESSES_ALL POSTAL_CODE
Pooled Country (Int) COUNTRY 2100 Varchar2 100 20 386 AD IC RA_ADDRESSES_ALL COUNTRY
Pooled Country (Ext1) 2100 Varchar2 110 3 406 AD IC ECE_XREF_DATA XREF_EXT_VALUE1
Pooled State (Int) STATE 2100 Varchar2 120 20 409 AD IC RA_ADDRESSES_ALL STATE
Pooled State (Ext1) 2100 Varchar2 130 10 429 AD IC ECE_XREF_DATA XREF_EXT_VALUE1
Pooled Province (Int) PROVINCE 2100 Varchar2 140 20 439 AD IC RA_ADDRESSES_ALL PROVINCE
Pooled Province (Ext1) 2100 Varchar2 150 10 459 AD IC ECE_XREF_DATA XREF_EXT_VALUE1
Pooled County 2100 Varchar2 160 25 469 AD IC RA_ADDRESSES_ALL COUNTY
RECORD 2105 (DSNO)
Common Key (Positions 1-91) 2105 Varchar2 91 1
Record Number 2105 Varchar2 4 92 Constant '2105'
Record Layout 2105 Varchar2 2 96 Constant 'AE'
Record Qualifier 2105 Varchar2 3 98 Constant 'IC'
Pooled Code (Ext2) for TP REFERENCE 1 2105 Varchar2 10 80 101 AE IC ECE_TP_HEADERS TP_REFERENCE_EXT1
Pooled Code (Ext3) for TP REFERENCE 2 2105 Varchar2 20 80 181 AE IC ECE_TP_HEADERS TP_REFERENCE_EXT2
RECORD 2110 (DSNO)
Common Key (Positions 1-91) 2110 Varchar2 91 1
Record Number 2110 Varchar2 4 92 Constant '2110'
Record Layout 2110 Varchar2 2 96 Constant 'CN'
Record Qualifier 2110 Varchar2 3 98 Constant 'IC'
Pooled Contact Last Name 2110 Varchar2 10 35 101 CN IC
Pooled Contact First Name 2110 Varchar2 20 35 136 CN IC
Pooled Contact Job Title 2110 Varchar2 30 40 171 CN IC
Pooled Area Code 2110 Varchar2 40 10 211 CN IC RA_PHONES AREA_CODE
Pooled Telephone Number 2110 Varchar2 50 60 221 CN IC RA_PHONES PHONE_NUMBER
RECORD 2200 (DSNO)
Common Key (Positions 1-91) 2200 Varchar2 91 1
Record Number 2200 Varchar2 4 92 Constant '2200'
Record Layout 2200 Varchar2 2 96 Constant 'AD'
Record Qualifier 2200 Varchar2 3 98 Constant 'CSG'
Consignee Code (Int) 2200 Varchar2 10 20 101 AD CSG RA_ADDRESSES_ALL ORIG_SYSTEM_REFERENCE
Consignee Code (Ext1) 2200 Varchar2 20 20 121 AD CSG ECE_TP_HEADERS TP_LOCATION_CODE_EXT
Consignee Name 2200 Varchar2 30 60 141 AD CSG RA_CUSTOMERS CUSTOMER_NAME
Consignee Address Line 1 2200 Varchar2 40 35 201 AD CSG RA_ADDRESSES_ALL ADDRESS1
Consignee Address Line 2 2200 Varchar2 50 35 236 AD CSG RA_ADDRESSES_ALL ADDRESS2
Consignee Address Line 3 2200 Varchar2 60 35 271 AD CSG RA_ADDRESSES_ALL ADDRESS3
Consignee Address Line 4 2200 Varchar2 70 35 306 AD CSG RA_ADDRESSES_ALL ADDRESS4
Consignee City 2200 Varchar2 80 30 341 AD CSG RA_ADDRESSES_ALL CITY
Consignee Postal Code 2200 Varchar2 90 15 371 AD CSG RA_ADDRESSES_ALL POSTAL_CODE
Consignee Country (Int) COUNTRY 2200 Varchar2 100 20 386 AD CSG RA_ADDRESSES_ALL COUNTRY
Consignee Country (Ext1) 2200 Varchar2 110 3 406 AD CSG ECE_XREF_DATA XREF_EXT_VALUE1
Consignee State (Int) STATE 2200 Varchar2 120 20 409 AD CSG RA_ADDRESSES_ALL STATE
Consignee State (Ext1) 2200 Varchar2 130 10 429 AD CSG ECE_XREF_DATA XREF_EXT_VALUE1
Consignee Province (Int) PROVINCE 2200 Varchar2 140 20 439 AD CSG RA_ADDRESSES_ALL PROVINCE
Consignee Province (Ext1) 2200 Varchar2 150 10 459 AD CSG ECE_XREF_DATA XREF_EXT_VALUE1
Consignee County 2200 Varchar2 160 25 469 AD CSG RA_ADDRESSES_ALL COUNTY
RECORD 2205 (DSNO)
Common Key (Positions 1-91) 2205 Varchar2 91 1
Record Number 2205 Varchar2 4 92 Constant '2205'
Record Layout 2205 Varchar2 2 96 Constant 'AE'
Record Qualifier 2205 Varchar2 3 98 Constant 'CSG'
Consignee Code (Ext2) for TP REFERENCE 1 2205 Varchar2 10 80 101 AE CSG ECE_TP_HEADERS TP_REFERENCE_EXT1
Consignee Code (Ext3) for TP REFERENCE 2 2205 Varchar2 20 80 181 AE CSG ECE_TP_HEADERS TP_REFERENCE_EXT2
RECORD 2210 (DSNO)
Common Key (Positions 1-91) 2210 Varchar2 91 1
Record Number 2210 Varchar2 4 92 Constant '2210'
Record Layout 2210 Varchar2 2 96 Constant 'CN'
Record Qualifier 2210 Varchar2 3 98 Constant 'CSG'
Consignee Contact Last Name 2210 Varchar2 10 35 101 CN CSG
Consignee Contact First Name 2210 Varchar2 20 35 136 CN CSG
Consignee Contact Job Title 2210 Varchar2 30 40 171 CN CSG
Consignee Area Code 2210 Varchar2 40 10 211 CN CSG RA_PHONES AREA_CODE
Consignee Telephone Number 2210 Varchar2 50 60 221 CN CSG RA_PHONES PHONE_NUMBER
RECORD 2300 (DSNO)
Common Key (Positions 1-91) 2300 Varchar2 91 1
Record Number 2300 Varchar2 4 92 Constant '2300'
Record Layout 2300 Varchar2 2 96 Constant 'AD'
Record Qualifier 2300 Varchar2 3 98 Constant 'ST'
Destination Code (Int) 2300 Varchar2 10 20 101 AD ST RA_ADDRESSES_ALL ORIG_SYSTEM_REFERENCE
Destination Code (Ext1) 2300 Varchar2 20 20 121 AD ST ECE_TP_HEADERS TP_LOCATION_CODE_EXT
Destination Name 2300 Varchar2 30 60 141 AD ST RA_CUSTOMERS CUSTOMER_NAME
Destination Address Line 1 2300 Varchar2 40 35 201 AD ST RA_ADDRESSES_ALL ADDRESS1
Destination Address Line 2 2300 Varchar2 50 35 236 AD ST RA_ADDRESSES_ALL ADDRESS2
Destination Address Line 3 2300 Varchar2 60 35 271 AD ST RA_ADDRESSES_ALL ADDRESS3
Destination Address Line 4 2300 Varchar2 70 35 306 AD ST RA_ADDRESSES_ALL ADDRESS4
Destination City 2300 Varchar2 80 30 341 AD ST RA_ADDRESSES_ALL CITY
Destination Postal Code 2300 Varchar2 90 15 371 AD ST RA_ADDRESSES_ALL POSTAL_CODE
Destination Country (Int) COUNTRY 2300 Varchar2 100 20 386 AD ST RA_ADDRESSES_ALL COUNTRY
Destination Country (Ext1) 2300 Varchar2 110 3 406 AD ST ECE_XREF_DATA XREF_EXT_VALUE1
Destination State (Int) STATE 2300 Varchar2 120 20 409 AD ST RA_ADDRESSES_ALL STATE
Destination State (Ext1) 2300 Varchar2 130 10 429 AD ST ECE_XREF_DATA XREF_EXT_VALUE1
Destination Province (Int) PROVINCE 2300 Varchar2 140 20 439 AD ST RA_ADDRESSES_ALL PROVINCE
Destination Province (Ext1) 2300 Varchar2 150 10 459 AD ST ECE_XREF_DATA XREF_EXT_VALUE1
Destination County 2300 Varchar2 160 25 469 AD ST RA_ADDRESSES_ALL COUNTY
RECORD 2305 (DSNO)
Common Key (Positions 1-91) 2305 Varchar2 91 1
Record Number 2305 Varchar2 4 92 Constant '2305'
Record Layout 2305 Varchar2 2 96 Constant 'AE'
Record Qualifier 2305 Varchar2 3 98 Constant 'ST'
Destination Code (Ext2) for TP REFERENCE 1 2305 Varchar2 10 80 101 AE ST ECE_TP_HEADERS TP_REFERENCE_EXT1
Destination Code (Ext3) for TP REFERENCE 2 2305 Varchar2 20 80 181 AE ST ECE_TP_HEADERS TP_REFERENCE_EXT2
RECORD 2310 (DSNO)
Common Key (Positions 1-91) 2310 Varchar2 91 1
Record Number 2310 Varchar2 4 92 Constant '2310'
Record Layout 2310 Varchar2 2 96 Constant 'CN'
Record Qualifier 2310 Varchar2 3 98 Constant 'ST'
Destination Contact Last Name 2310 Varchar2 10 35 101 CN ST RA_CONTACTS LAST_NAME
Destination Contact First Name 2310 Varchar2 20 35 136 CN ST RA_CONTACTS FIRST_NAME
Destination Contact Job Title 2310 Varchar2 30 40 171 CN ST RA_CONTACTS JOB_TITLE
Destination Area Code 2310 Varchar2 40 10 211 CN ST RA_PHONES AREA_CODE
Destination Phone 2310 Varchar2 50 60 221 CN ST RA_PHONES PHONE_NUMBER
RECORD 3000 (DSNO)
Common Key (Positions 1-91) 3000 Varchar2 91 1
Record Number 3000 Varchar2 4 92 Constant '3000'
Record Layout 3000 Varchar2 2 96 Constant 'A1'
Record Qualifier 3000 Varchar2 3 98 Constant 'SF1'
Warehouse Flexfield Context 3000 Varchar2 10 30 101 A1 SF1 HR_LOCATIONS ATTRIBUTE_CATEGORY
Warehouse Flexfield 1 3000 Varchar2 20 80 131 A1 SF1 HR_LOCATIONS ATTRIBUTE1
Warehouse Flexfield 2 3000 Varchar2 30 80 211 A1 SF1 HR_LOCATIONS ATTRIBUTE2
Warehouse Flexfield 3 3000 Varchar2 40 80 291 A1 SF1 HR_LOCATIONS ATTRIBUTE3
Warehouse Flexfield 4 3000 Varchar2 50 80 371 A1 SF1 HR_LOCATIONS ATTRIBUTE4
RECORD 3010 (DSNO)
Common Key (Positions 1-91) 3010 Varchar2 91 1
Record Number 3010 Varchar2 4 92 Constant '3010'
Record Layout 3010 Varchar2 2 96 Constant 'A2'
Record Qualifier 3010 Varchar2 3 98 Constant 'SF2'
Warehouse Flexfield 5 3010 Varchar2 10 80 101 A2 SF2 HR_LOCATIONS ATTRIBUTE5
Warehouse Flexfield 6 3010 Varchar2 20 80 181 A2 SF2 HR_LOCATIONS ATTRIBUTE6
Warehouse Flexfield 7 3010 Varchar2 30 80 261 A2 SF2 HR_LOCATIONS ATTRIBUTE7
Warehouse Flexfield 8 3010 Varchar2 40 80 341 A2 SF2 HR_LOCATIONS ATTRIBUTE8
Warehouse Flexfield 9 3010 Varchar2 50 80 421 A2 SF2 HR_LOCATIONS ATTRIBUTE9
RECORD 3020 (DSNO)
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 Qualifier 3020 Varchar2 3 98 Constant 'SF3'
Warehouse Flexfield 10 3020 Varchar2 10 80 101 A2 SF3 HR_LOCATIONS ATTRIBUTE10
Warehouse Flexfield 11 3020 Varchar2 20 80 181 A2 SF3 HR_LOCATIONS ATTRIBUTE11
Warehouse Flexfield 12 3020 Varchar2 30 80 261 A2 SF3 HR_LOCATIONS ATTRIBUTE12
Warehouse Flexfield 13 3020 Varchar2 40 80 341 A2 SF3 HR_LOCATIONS ATTRIBUTE13
Warehouse Flexfield 14 3020 Varchar2 50 80 421 A2 SF3 HR_LOCATIONS ATTRIBUTE14
RECORD 3030 (DSNO)
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 Qualifier 3030 Varchar2 3 98 Constant 'SF4'
Warehouse Flexfield 15 3030 Varchar2 10 80 101 A2 SF4 HR_LOCATIONS ATTRIBUTE15
Warehouse Flexfield 16 3030 Varchar2 20 80 181 A2 SF4 HR_LOCATIONS ATTRIBUTE16
Warehouse Flexfield 17 3030 Varchar2 30 80 261 A2 SF4 HR_LOCATIONS ATTRIBUTE17
Warehouse Flexfield 18 3030 Varchar2 40 80 341 A2 SF4 HR_LOCATIONS ATTRIBUTE18
Warehouse Flexfield 19 3030 Varchar2 50 80 421 A2 SF4 HR_LOCATIONS ATTRIBUTE19
RECORD 3040 (DSNO)
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 Qualifier 3040 Varchar2 3 98 Constant 'SF5'
Warehouse Flexfield 20 3040 Varchar2 10 80 101 A2 SF5 HR_LOCATIONS ATTRIBUTE20
RECORD 3100 (DSNO)
Common Key (Positions 1-91) 3100 Varchar2 91 1
Record Number 3100 Varchar2 4 92 Constant '3100'
Record Layout 3100 Varchar2 2 96 Constant 'A1'
Record Qualifier 3100 Varchar2 3 98 Constant 'ST1'
Destination Flexfield Context 3100 Varchar2 10 30 101 A1 ST1 RA_SITE_USES_ALL ATTRIBUTE_CATEGORY
Destination Flexfield 1 3100 Varchar2 20 80 131 A1 ST1 RA_SITE_USES_ALL ATTRIBUTE1
Destination Flexfield 2 3100 Varchar2 30 80 211 A1 ST1 RA_SITE_USES_ALL ATTRIBUTE2
Destination Flexfield 3 3100 Varchar2 40 80 291 A1 ST1 RA_SITE_USES_ALL ATTRIBUTE3
Destination Flexfield 4 3100 Varchar2 50 80 371 A1 ST1 RA_SITE_USES_ALL ATTRIBUTE4
RECORD 3110 (DSNO)
Common Key (Positions 1-91) 3110 Varchar2 91 1
Record Number 3110 Varchar2 4 92 Constant '3110'
Record Layout 3110 Varchar2 2 96 Constant 'A2'
Record Qualifier 3110 Varchar2 3 98 Constant 'ST2'
Destination Flexfield 5 3110 Varchar2 10 80 101 A2 ST2 RA_SITE_USES_ALL ATTRIBUTE5
Destination Flexfield 6 3110 Varchar2 20 80 181 A2 ST2 RA_SITE_USES_ALL ATTRIBUTE6
Destination Flexfield 7 3110 Varchar2 30 80 261 A2 ST2 RA_SITE_USES_ALL ATTRIBUTE7
Destination Flexfield 8 3110 Varchar2 40 80 341 A2 ST2 RA_SITE_USES_ALL ATTRIBUTE8
Destination Flexfield 9 3110 Varchar2 50 80 421 A2 ST2 RA_SITE_USES_ALL ATTRIBUTE9
RECORD 3120 (DSNO)
Common Key (Positions 1-91) 3120 Varchar2 91 1
Record Number 3120 Varchar2 4 92 Constant '3120'
Record Layout 3120 Varchar2 2 96 Constant 'A2'
Record Qualifier 3120 Varchar2 3 98 Constant 'ST3'
Destination Flexfield 10 3120 Varchar2 10 80 101 A2 ST3 RA_SITE_USES_ALL ATTRIBUTE10
Destination Flexfield 11 3120 Varchar2 20 80 181 A2 ST3 RA_SITE_USES_ALL ATTRIBUTE11
Destination Flexfield 12 3120 Varchar2 30 80 261 A2 ST3 RA_SITE_USES_ALL ATTRIBUTE12
Destination Flexfield 13 3120 Varchar2 40 80 341 A2 ST3 RA_SITE_USES_ALL ATTRIBUTE13
Destination Flexfield 14 3120 Varchar2 50 80 421 A2 ST3 RA_SITE_USES_ALL ATTRIBUTE14
RECORD 3130 (DSNO)
Common Key (Positions 1-91) 3130 Varchar2 91 1
Record Number 3130 Varchar2 4 92 Constant '3130'
Record Layout 3130 Varchar2 2 96 Constant 'A2'
Record Qualifier 3130 Varchar2 3 98 Constant 'ST4'
Destination Flexfield 15 3130 Varchar2 10 80 101 A2 ST4 RA_SITE_USES_ALL ATTRIBUTE15
Destination Flexfield 16 3130 Varchar2 20 80 181 A2 ST4 RA_SITE_USES_ALL ATTRIBUTE16
Destination Flexfield 17 3130 Varchar2 30 80 261 A2 ST4 RA_SITE_USES_ALL ATTRIBUTE17
Destination Flexfield 18 3130 Varchar2 40 80 341 A2 ST4 RA_SITE_USES_ALL ATTRIBUTE18
Destination Flexfield 19 3130 Varchar2 50 80 421 A2 ST4 RA_SITE_USES_ALL ATTRIBUTE19
RECORD 3140 (DSNO)
Common Key (Positions 1-91) 3140 Varchar2 91 1
Record Number 3140 Varchar2 4 92 Constant '3140'
Record Layout 3140 Varchar2 2 96 Constant 'A2'
Record Qualifier 3140 Varchar2 3 98 Constant 'ST5'
Destination Flexfield 20 3140 Varchar2 10 80 101 A2 ST5 RA_SITE_USES_ALL ATTRIBUTE20
Destination Flexfield 21 3140 Varchar2 20 80 181 A2 ST5 RA_SITE_USES_ALL ATTRIBUTE21
Destination Flexfield 22 3140 Varchar2 30 80 261 A2 ST5 RA_SITE_USES_ALL ATTRIBUTE22
Destination Flexfield 23 3140 Varchar2 40 80 341 A2 ST5 RA_SITE_USES_ALL ATTRIBUTE23
Destination Flexfield 24 3140 Varchar2 50 80 421 A2 ST5 RA_SITE_USES_ALL ATTRIBUTE24
RECORD 3150 (DSNO)
Common Key (Positions 1-91) 3150 Varchar2 91 1
Record Number 3150 Varchar2 4 92 Constant '3150'
Record Layout 3150 Varchar2 2 96 Constant 'A2'
Record Qualifier 3150 Varchar2 3 98 Constant 'ST6'
Destination Flexfield 25 3150 Varchar2 10 80 101 A2 ST6 RA_SITE_USES_ALL ATTRIBUTE25
RECORD 3200 (DSNO)
Common Key (Positions 1-91) 3200 Varchar2 91 1
Record Number 3200 Varchar2 4 92 Constant '3200'
Record Layout 3200 Varchar2 2 96 Constant 'A1'
Record Qualifier 3200 Varchar2 3 98 Constant 'CU1'
Customer Flexfield Context 3200 Varchar2 10 30 101 A1 CU1 RA_CUSTOMERS ATTRIBUTE_CATEGORY
Customer Flexfield 1 3200 Varchar2 20 80 131 A1 CU1 RA_CUSTOMERS ATTRIBUTE1
Customer Flexfield 2 3200 Varchar2 30 80 211 A1 CU1 RA_CUSTOMERS ATTRIBUTE2
Customer Flexfield 3 3200 Varchar2 40 80 291 A1 CU1 RA_CUSTOMERS ATTRIBUTE3
Customer Flexfield 4 3200 Varchar2 50 80 371 A1 CU1 RA_CUSTOMERS ATTRIBUTE4
RECORD 3210 (DSNO)
Common Key (Positions 1-91) 3210 Varchar2 91 1
Record Number 3210 Varchar2 4 92 Constant '3210'
Record Layout 3210 Varchar2 2 96 Constant 'A2'
Record Qualifier 3210 Varchar2 3 98 Constant 'CU2'
Customer Flexfield 5 3210 Varchar2 10 80 101 A2 CU2 RA_CUSTOMERS ATTRIBUTE5
Customer Flexfield 6 3210 Varchar2 20 80 181 A2 CU2 RA_CUSTOMERS ATTRIBUTE6
Customer Flexfield 7 3210 Varchar2 30 80 261 A2 CU2 RA_CUSTOMERS ATTRIBUTE7
Customer Flexfield 8 3210 Varchar2 40 80 341 A2 CU2 RA_CUSTOMERS ATTRIBUTE8
Customer Flexfield 9 3210 Varchar2 50 80 421 A2 CU2 RA_CUSTOMERS ATTRIBUTE9
RECORD 3220 (DSNO)
Common Key (Positions 1-91) 3220 Varchar2 91 1
Record Number 3220 Varchar2 4 92 Constant '3220'
Record Layout 3220 Varchar2 2 96 Constant 'A2'
Record Qualifier 3220 Varchar2 3 98 Constant 'CU3'
Customer Flexfield 10 3220 Varchar2 10 80 101 A2 CU3 RA_CUSTOMERS ATTRIBUTE10
Customer Flexfield 11 3220 Varchar2 20 80 181 A2 CU3 RA_CUSTOMERS ATTRIBUTE11
Customer Flexfield 12 3220 Varchar2 30 80 261 A2 CU3 RA_CUSTOMERS ATTRIBUTE12
Customer Flexfield 13 3220 Varchar2 40 80 341 A2 CU3 RA_CUSTOMERS ATTRIBUTE13
Customer Flexfield 14 3220 Varchar2 50 80 421 A2 CU3 RA_CUSTOMERS ATTRIBUTE14
RECORD 3230 (DSNO)
Common Key (Positions 1-91) 3230 Varchar2 91 1
Record Number 3230 Varchar2 4 92 Constant '3230'
Record Layout 3230 Varchar2 2 96 Constant 'A2'
Record Qualifier 3230 Varchar2 3 98 Constant 'CU4'
Customer Flexfield 15 3230 Varchar2 10 80 101 A2 CU4 RA_CUSTOMERS ATTRIBUTE15
RECORD 3300 (DSNO)
Common Key (Positions 1-91) 3300 Varchar2 91 1
Record Number 3300 Varchar2 4 92 Constant '3300'
Record Layout 3300 Varchar2 2 96 Constant 'A1'
Record Qualifier 3300 Varchar2 3 98 Constant 'CG1'
Customer Global Flexfield Context 3300 Varchar2 10 30 101 A1 CG1 RA_CUSTOMERS GLOBAL_ATTRIBUTE_CATEGORY
Customer Global Flexfield 1 3300 Varchar2 20 80 131 A1 CG1 RA_CUSTOMERS GLOBAL_ATTRIBUTE1
Customer Global Flexfield 2 3300 Varchar2 30 80 211 A1 CG1 RA_CUSTOMERS GLOBAL_ATTRIBUTE2
Customer Global Flexfield 3 3300 Varchar2 40 80 291 A1 CG1 RA_CUSTOMERS GLOBAL_ATTRIBUTE3
Customer Global Flexfield 4 3300 Varchar2 50 80 371 A1 CG1 RA_CUSTOMERS GLOBAL_ATTRIBUTE4
RECORD 3310 (DSNO)
Common Key (Positions 1-91) 3310 Varchar2 91 1
Record Number 3310 Varchar2 4 92 Constant '3310'
Record Layout 3310 Varchar2 2 96 Constant 'A2'
Record Qualifier 3310 Varchar2 3 98 Constant 'CG2'
Customer Global Flexfield 5 3310 Varchar2 10 80 101 A2 CG2 RA_CUSTOMERS GLOBAL_ATTRIBUTE5
Customer Global Flexfield 6 3310 Varchar2 20 80 181 A2 CG2 RA_CUSTOMERS GLOBAL_ATTRIBUTE6
Customer Global Flexfield 7 3310 Varchar2 30 80 261 A2 CG2 RA_CUSTOMERS GLOBAL_ATTRIBUTE7
Customer Global Flexfield 8 3310 Varchar2 40 80 341 A2 CG2 RA_CUSTOMERS GLOBAL_ATTRIBUTE8
Customer Global Flexfield 9 3310 Varchar2 50 80 421 A2 CG2 RA_CUSTOMERS GLOBAL_ATTRIBUTE9
RECORD 3320 (DSNO)
Common Key (Positions 1-91) 3320 Varchar2 91 1
Record Number 3320 Varchar2 4 92 Constant '3320'
Record Layout 3320 Varchar2 2 96 Constant 'A2'
Record Qualifier 3320 Varchar2 3 98 Constant 'CG3'
Customer Global Flexfield 10 3320 Varchar2 10 80 101 A2 CG3 RA_CUSTOMERS GLOBAL_ATTRIBUTE10
Customer Global Flexfield 11 3320 Varchar2 20 80 181 A2 CG3 RA_CUSTOMERS GLOBAL_ATTRIBUTE11
Customer Global Flexfield 12 3320 Varchar2 30 80 261 A2 CG3 RA_CUSTOMERS GLOBAL_ATTRIBUTE12
Customer Global Flexfield 13 3320 Varchar2 40 80 341 A2 CG3 RA_CUSTOMERS GLOBAL_ATTRIBUTE13
Customer Global Flexfield 14 3320 Varchar2 50 80 421 A2 CG3 RA_CUSTOMERS GLOBAL_ATTRIBUTE14
RECORD 3330 (DSNO)
Common Key (Positions 1-91) 3330 Varchar2 91 1
Record Number 3330 Varchar2 4 92 Constant '3330'
Record Layout 3330 Varchar2 2 96 Constant 'A2'
Record Qualifier 3330 Varchar2 3 98 Constant 'CG4'
Customer Global Flexfield 15 3330 Varchar2 10 80 101 A2 CG4 RA_CUSTOMERS GLOBAL_ATTRIBUTE15
Customer Global Flexfield 16 3330 Varchar2 20 80 181 A2 CG4 RA_CUSTOMERS GLOBAL_ATTRIBUTE16
Customer Global Flexfield 17 3330 Varchar2 30 80 261 A2 CG4 RA_CUSTOMERS GLOBAL_ATTRIBUTE17
Customer Global Flexfield 18 3330 Varchar2 40 80 341 A2 CG4 RA_CUSTOMERS GLOBAL_ATTRIBUTE18
Customer Global Flexfield 19 3330 Varchar2 50 80 421 A2 CG4 RA_CUSTOMERS GLOBAL_ATTRIBUTE19
RECORD 3340 (DSNO)
Common Key (Positions 1-91) 3340 Varchar2 91 1
Record Number 3340 Varchar2 4 92 Constant '3340'
Record Layout 3340 Varchar2 2 96 Constant 'A2'
Record Qualifier 3340 Varchar2 3 98 Constant 'CG5'
Customer Global Flexfield 20 3340 Varchar2 10 80 101 A2 CG5 RA_CUSTOMERS GLOBAL_ATTRIBUTE20
RECORD 3400 (DSNO)
Common Key (Positions 1-91) 3400 Varchar2 91 1
Record Number 3400 Varchar2 4 92 Constant '3400'
Record Layout 3400 Varchar2 2 96 Constant 'A1'
Record Qualifier 3400 Varchar2 3 98 Constant 'DP1'
Departure Flexfield Context 3400 Varchar2 10 30 101 A1 DP1 WSH_DEPARTURES ATTRIBUTE_CATEGORY
Departure Flexfield 1 3400 Varchar2 20 80 131 A1 DP1 WSH_DEPARTURES ATTRIBUTE1
Departure Flexfield 2 3400 Varchar2 30 80 211 A1 DP1 WSH_DEPARTURES ATTRIBUTE2
Departure Flexfield 3 3400 Varchar2 40 80 291 A1 DP1 WSH_DEPARTURES ATTRIBUTE3
Departure Flexfield 4 3400 Varchar2 50 80 371 A1 DP1 WSH_DEPARTURES ATTRIBUTE4
RECORD 3410 (DSNO)
Common Key (Positions 1-91) 3410 Varchar2 91 1
Record Number 3410 Varchar2 4 92 Constant '3410'
Record Layout 3410 Varchar2 2 96 Constant 'A2'
Record Qualifier 3410 Varchar2 3 98 Constant 'DP2'
Departure Flexfield 5 3410 Varchar2 10 80 101 A2 DP2 WSH_DEPARTURES ATTRIBUTE5
Departure Flexfield 6 3410 Varchar2 20 80 181 A2 DP2 WSH_DEPARTURES ATTRIBUTE6
Departure Flexfield 7 3410 Varchar2 30 80 261 A2 DP2 WSH_DEPARTURES ATTRIBUTE7
Departure Flexfield 8 3410 Varchar2 40 80 341 A2 DP2 WSH_DEPARTURES ATTRIBUTE8
Departure Flexfield 9 3410 Varchar2 50 80 421 A2 DP2 WSH_DEPARTURES ATTRIBUTE9
RECORD 3420 (DSNO)
Common Key (Positions 1-91) 3420 Varchar2 91 1
Record Number 3420 Varchar2 4 92 Constant '3420'
Record Layout 3420 Varchar2 2 96 Constant 'A2'
Record Qualifier 3420 Varchar2 3 98 Constant 'DP3'
Departure Flexfield 10 3420 Varchar2 10 80 101 A2 DP3 WSH_DEPARTURES ATTRIBUTE10
Departure Flexfield 11 3420 Varchar2 20 80 181 A2 DP3 WSH_DEPARTURES ATTRIBUTE11
Departure Flexfield 12 3420 Varchar2 30 80 261 A2 DP3 WSH_DEPARTURES ATTRIBUTE12
Departure Flexfield 13 3420 Varchar2 40 80 341 A2 DP3 WSH_DEPARTURES ATTRIBUTE13
Departure Flexfield 14 3420 Varchar2 50 80 421 A2 DP3 WSH_DEPARTURES ATTRIBUTE14
RECORD 3430 (DSNO)
Common Key (Positions 1-91) 3430 Varchar2 91 1
Record Number 3430 Varchar2 4 92 Constant '3430'
Record Layout 3430 Varchar2 2 96 Constant 'A2'
Record Qualifier 3430 Varchar2 3 98 Constant 'DP4'
Departure Flexfield 15 3430 Varchar2 10 80 101 A2 DP4 WSH_DEPARTURES ATTRIBUTE15
RECORD 3500 (DSNO)
Common Key (Positions 1-91) 3500 Varchar2 91 1
Record Number 3500 Varchar2 4 92 Constant '3500'
Record Layout 3500 Varchar2 2 96 Constant 'A1'
Record Qualifier 3500 Varchar2 3 98 Constant 'DL1'
Delivery Flexfield Context 3500 Varchar2 10 30 101 A1 DL1 WSH_DELIVERIES ATTRIBUTE_CATEGORY
Delivery Flexfield 1 3500 Varchar2 20 80 131 A1 DL1 WSH_DELIVERIES ATTRIBUTE1
Delivery Flexfield 2 3500 Varchar2 30 80 211 A1 DL1 WSH_DELIVERIES ATTRIBUTE2
Delivery Flexfield 3 3500 Varchar2 40 80 291 A1 DL1 WSH_DELIVERIES ATTRIBUTE3
Delivery Flexfield 4 3500 Varchar2 50 80 371 A1 DL1 WSH_DELIVERIES ATTRIBUTE4
RECORD 3510 (DSNO)
Common Key (Positions 1-91) 3510 Varchar2 91 1
Record Number 3510 Varchar2 4 92 Constant '3510'
Record Layout 3510 Varchar2 2 96 Constant 'A2'
Record Qualifier 3510 Varchar2 3 98 Constant 'DL2'
Delivery Flexfield 5 3510 Varchar2 10 80 101 A2 DL2 WSH_DELIVERIES ATTRIBUTE5
Delivery Flexfield 6 3510 Varchar2 20 80 181 A2 DL2 WSH_DELIVERIES ATTRIBUTE6
Delivery Flexfield 7 3510 Varchar2 30 80 261 A2 DL2 WSH_DELIVERIES ATTRIBUTE7
Delivery Flexfield 8 3510 Varchar2 40 80 341 A2 DL2 WSH_DELIVERIES ATTRIBUTE8
Delivery Flexfield 9 3510 Varchar2 50 80 421 A2 DL2 WSH_DELIVERIES ATTRIBUTE9
RECORD 3520 (DSNO)
Common Key (Positions 1-91) 3520 Varchar2 91 1
Record Number 3520 Varchar2 4 92 Constant '3520'
Record Layout 3520 Varchar2 2 96 Constant 'A2'
Record Qualifier 3520 Varchar2 3 98 Constant 'DL3'
Delivery Flexfield 10 3520 Varchar2 10 80 101 A2 DL3 WSH_DELIVERIES ATTRIBUTE10
Delivery Flexfield 11 3520 Varchar2 20 80 181 A2 DL3 WSH_DELIVERIES ATTRIBUTE11
Delivery Flexfield 12 3520 Varchar2 30 80 261 A2 DL3 WSH_DELIVERIES ATTRIBUTE12
Delivery Flexfield 13 3520 Varchar2 40 80 341 A2 DL3 WSH_DELIVERIES ATTRIBUTE13
Delivery Flexfield 14 3520 Varchar2 50 80 421 A2 DL3 WSH_DELIVERIES ATTRIBUTE14
RECORD 3530 (DSNO)
Common Key (Positions 1-91) 3530 Varchar2 91 1
Record Number 3530 Varchar2 4 92 Constant '3530'
Record Layout 3530 Varchar2 2 96 Constant 'A2'
Record Qualifier 3530 Varchar2 3 98 Constant 'DL4'
Delivery Flexfield 15 3530 Varchar2 10 80 101 A2 DL4 WSH_DELIVERIES ATTRIBUTE15
RECORD 4000 (DSNO)
Common Key (Positions 1-91) 4000 Varchar2 91 1
Record Number 4000 Varchar2 4 92 Constant '4000'
Record Layout 4000 Varchar2 2 96 Constant 'AC'
Record Qualifier 4000 Varchar2 3 98 Constant 'HA1'
Allowance/Charge Indicator 4000 Varchar2 10 1 101 AC HA1
Allowance/Charge Amount 4000 Number 20 22 102 AC HA1 SO_FREIGHT_CHARGES AMOUNT
Currency Code 4000 Varchar2 30 15 124 AC HA1 SO_FREIGHT_CHARGES CURRENCY_CODE
Currency Conversion Type Code 4000 Varchar2 40 30 139 AC HA1 SO_FREIGHT_CHARGES CONVERSION_TYPE_CODE
Currency Conversion Date 4000 Date 50 15 169 AC HA1 SO_FREIGHT_CHARGES CONVERSION_DATE
Currency Conversion Rate 4000 Number 60 22 184 AC HA1 SO_FREIGHT_CHARGES CONVERSION_RATE
Allowance/Charge Handling Code (Int) AC_HANDL 4000 Varchar2 70 30 206 AC HA1 SO_FREIGHT_CHARGE_TYPES NAME
Allowance/Charge Handling Code (Ext1) 4000 Varchar2 80 30 236 AC HA1 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 4010 (DSNO)
Common Key (Positions 1-91) 4010 Varchar2 91 1
Record Number 4010 Varchar2 4 92 Constant '4010'
Record Layout 4010 Varchar2 2 96 Constant 'A5'
Record Qualifier 4010 Varchar2 3 98 Constant 'HA2'
Allowance/Charge Flexfield Context 4010 Varchar2 10 30 101 A5 HA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE_CATEGORY
Allowance/Charge Special Services Code (Int) AC_SPECS 4010 Varchar2 20 70 131 A5 HA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE1
Allowance/Charge Flexfield 1 (Ext1) 4010 Varchar2 30 25 201 A5 HA2 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Special Charges Code (Int) AC_SPECC 4010 Varchar2 40 70 226 A5 HA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE2
Allowance/Charge Flexfield 2 (Ext1) 4010 Varchar2 50 25 296 A5 HA2 ECE_XREF_DATA XREF_EXT_VALUE1
AETC Number (Int) 4010 Varchar2 60 70 321 A5 HA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE3
Allowance/Charge Flexfield 3 (Ext1) 4010 Varchar2 70 25 391 A5 HA2 ECE_XREF_DATA XREF_EXT_VALUE1
AETC Responsibility Code (Int) AETC_RESP 4010 Varchar2 80 70 416 A5 HA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE4
Allowance/Charge Flexfield 4 (Ext1) 4010 Varchar2 90 25 486 A5 HA2 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 4020 (DSNO)
Common Key (Positions 1-91) 4020 Varchar2 91 1
Record Number 4020 Varchar2 4 92 Constant '4020'
Record Layout 4020 Varchar2 2 96 Constant 'A6'
Record Qualifier 4020 Varchar2 3 98 Constant 'HA3'
AETC Reason Code (Int) AETC_RSN 4020 Varchar2 10 70 101 A6 HA3 SO_FREIGHT_CHARGES AC_ATTRIBUTE5
Allowance/Charge Flexfield 5 (Ext1) 4020 Varchar2 20 25 171 A6 HA3 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 6 (Int) User Choice 4020 Varchar2 30 70 196 A6 HA3 SO_FREIGHT_CHARGES AC_ATTRIBUTE6
Allowance/Charge Flexfield 6 (Ext1) 4020 Varchar2 40 25 266 A6 HA3 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 7 (Int) User Choice 4020 Varchar2 50 70 291 A6 HA3 SO_FREIGHT_CHARGES AC_ATTRIBUTE7
Allowance/Charge Flexfield 7 (Ext1) 4020 Varchar2 60 25 361 A6 HA3 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 8 (Int) User Choice 4020 Varchar2 70 70 386 A6 HA3 SO_FREIGHT_CHARGES AC_ATTRIBUTE8
Allowance/Charge Flexfield 8 (Ext1) 4020 Varchar2 80 25 456 A6 HA3 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 4030 (DSNO)
Common Key (Positions 1-91) 4030 Varchar2 91 1
Record Number 4030 Varchar2 4 92 Constant '4030'
Record Layout 4030 Varchar2 2 96 Constant 'A6'
Record Qualifier 4030 Varchar2 3 98 Constant 'HA4'
Allowance/Charge Flexfield 9 (Int) User Choice 4030 Varchar2 10 70 101 A6 HA4 SO_FREIGHT_CHARGES AC_ATTRIBUTE9
Allowance/Charge Flexfield 9 (Ext1) 4030 Varchar2 20 25 171 A6 HA4 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 10 (Int) User Choice 4030 Varchar2 30 70 196 A6 HA4 SO_FREIGHT_CHARGES AC_ATTRIBUTE10
Allowance/Charge Flexfield 10 (Ext1) 4030 Varchar2 40 25 266 A6 HA4 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 11 (Int) User Choice 4030 Varchar2 50 70 291 A6 HA4 SO_FREIGHT_CHARGES AC_ATTRIBUTE11
Allowance/Charge Flexfield 11 (Ext1) 4030 Varchar2 60 25 361 A6 HA4 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 12 (Int) User Choice 4030 Varchar2 70 70 386 A6 HA4 SO_FREIGHT_CHARGES AC_ATTRIBUTE12
Allowance/Charge Flexfield 12 (Ext1) 4030 Varchar2 80 25 456 A6 HA4 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 4040 (DSNO)
Common Key (Positions 1-91) 4040 Varchar2 91 1
Record Number 4040 Varchar2 4 92 Constant '4040'
Record Layout 4040 Varchar2 2 96 Constant 'A6'
Record Qualifier 4040 Varchar2 3 98 Constant 'HA5'
Allowance/Charge Flexfield 13 (Int) User Choice 4040 Varchar2 10 70 101 A6 HA5 SO_FREIGHT_CHARGES AC_ATTRIBUTE13
Allowance/Charge Flexfield 13 (Ext1) 4040 Varchar2 20 25 171 A6 HA5 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 14 (Int) User Choice 4040 Varchar2 30 70 196 A6 HA5 SO_FREIGHT_CHARGES AC_ATTRIBUTE14
Allowance/Charge Flexfield 14 (Ext1) 4040 Varchar2 40 25 266 A6 HA5 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 15 (Int) User Choice 4040 Varchar2 50 70 291 A6 HA5 SO_FREIGHT_CHARGES AC_ATTRIBUTE15
Allowance/Charge Flexfield 15 (Ext1) 4040 Varchar2 60 25 361 A6 HA5 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 4050 (DSNO)
Common Key (Positions 1-91) 4050 Varchar2 91 1
Record Number 4050 Varchar2 4 92 Constant '4050'
Record Layout 4050 Varchar2 2 96 Constant 'A1'
Record Qualifier 4050 Varchar2 3 98 Constant 'FH1'
Freight Charges Flexfield Context 4050 Varchar2 10 30 101 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE_CATEGORY
Freight Charges Flexfield 1 4050 Varchar2 20 80 131 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE1
Freight Charges Flexfield 2 4050 Varchar2 30 80 211 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE2
Freight Charges Flexfield 3 4050 Varchar2 40 80 291 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE3
Freight Charges Flexfield 4 4050 Varchar2 50 80 371 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE4
RECORD 4060 (DSNO)
Common Key (Positions 1-91) 4060 Varchar2 91 1
Record Number 4060 Varchar2 4 92 Constant '4060'
Record Layout 4060 Varchar2 2 96 Constant 'A2'
Record Qualifier 4060 Varchar2 3 98 Constant 'FH2'
Freight Charges Flexfield 5 4060 Varchar2 10 80 101 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE5
Freight Charges Flexfield 6 4060 Varchar2 20 80 181 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE6
Freight Charges Flexfield 7 4060 Varchar2 30 80 261 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE7
Freight Charges Flexfield 8 4060 Varchar2 40 80 341 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE8
Freight Charges Flexfield 9 4060 Varchar2 50 80 421 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE9
RECORD 4070 (DSNO)
Common Key (Positions 1-91) 4070 Varchar2 91 1
Record Number 4070 Varchar2 4 92 Constant '4070'
Record Layout 4070 Varchar2 2 96 Constant 'A2'
Record Qualifier 4070 Varchar2 3 98 Constant FH3'
Freight Charges Flexfield 10 4070 Varchar2 10 80 101 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE10
Freight Charges Flexfield 11 4070 Varchar2 20 80 181 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE11
Freight Charges Flexfield 12 4070 Varchar2 30 80 261 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE12
Freight Charges Flexfield 13 4070 Varchar2 40 80 341 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE13
Freight Charges Flexfield 14 4070 Varchar2 50 80 421 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE14
RECORD 4080 (DSNO)
Common Key (Positions 1-91) 4080 Varchar2 91 1
Record Number 4080 Varchar2 4 92 Constant '4080'
Record Layout 4080 Varchar2 2 96 Constant 'A2'
Record Qualifier 4080 Varchar2 3 98 Constant 'FH4'
Freight Charges Flexfield 15 4080 Varchar2 10 80 101 A2 FH4 SO_FREIGHT_CHARGES ATTRIBUTE15
RECORD 5000 (DSNO)
Common Key (Positions 1-91) 5000 Varchar2 91 1
Record Number 5000 Varchar2 4 92 Constant '5000'
Record Layout 5000 Varchar2 2 96 Constant 'TR'
Record Qualifier 5000 Varchar2 3 98 Constant 'CTR'
Master Serial Number 5000 Varchar2 10 30 101 TR CTR WSH_PACKED_CONTAINERS MASTER_SERIAL_NUMBER
Container Serial Number 5000 Varchar2 20 30 131 TR CTR WSH_PACKED_CONTAINERS SERIAL_NUMBER
Container Lot Number 5000 Varchar2 30 30 161 TR CTR WSH_PACKED_CONTAINERS LOT_NUMBER
Parent Container Sequence Number 5000 Number 40 22 191 TR CTR WSH_PACKED_CONTAINERS PARENT_SEQUENCE_NUMBER
Container Sequence Number 5000 Number 50 22 213 TR CTR WSH_PACKED_CONTAINERS SEQUENCE_NUMBER
Container Quantity 5000 Number 60 22 235 TR CTR WSH_PACKED_CONTAINERS QUANTITY
Container Type Code (Int) CONTAINER_TYPE 5000 Varchar2 70 30 257 TR CTR MTL_SYSTEM_ITEMS CONTAINER_TYPE_CODE
Container Type Code (Ext1) 5000 Varchar2 80 30 287 TR CTR ECE_XREF_DATA XREF_EXT_VALUE1
Container Gross Weight 5000 Number 90 22 317 TR CTR WSH_PACKED_CONTAINERS GROSS_WEIGHT
Container Gross Weight UOM (Int) UOM 5000 Varchar2 100 5 339 TR CTR WSH_PACKED_CONTAINERS WEIGHT_UOM_CODE
Container Gross Weight UOM (Ext1) 5000 Varchar2 110 5 344 TR CTR ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 5010 (DSNO)
Common Key (Positions 1-91) 5010 Varchar2 91 1
Record Number 5010 Varchar2 4 92 Constant '5010'
Record Layout 5010 Varchar2 2 96 Constant 'A1'
Record Qualifier 5010 Varchar2 3 98 Constant 'CT1'
Container Flexfield Context 5010 Varchar2 10 30 101 A1 CT1 WSH_PACKED_CONTAINERS ATTRIBUTE_CATEGORY
Container Flexfield 1 5010 Varchar2 20 80 131 A1 CT1 WSH_PACKED_CONTAINERS ATTRIBUTE1
Container Flexfield 2 5010 Varchar2 30 80 211 A1 CT1 WSH_PACKED_CONTAINERS ATTRIBUTE2
Container Flexfield 3 5010 Varchar2 40 80 291 A1 CT1 WSH_PACKED_CONTAINERS ATTRIBUTE3
Container Flexfield 4 5010 Varchar2 50 80 371 A1 CT1 WSH_PACKED_CONTAINERS ATTRIBUTE4
RECORD 5020 (DSNO)
Common Key (Positions 1-91) 5020 Varchar2 91 1
Record Number 5020 Varchar2 4 92 Constant '5020'
Record Layout 5020 Varchar2 2 96 Constant 'A2'
Record Qualifier 5020 Varchar2 3 98 Constant 'CT2'
Container Flexfield 5 5020 Varchar2 10 80 101 A2 CT2 WSH_PACKED_CONTAINERS ATTRIBUTE5
Container Flexfield 6 5020 Varchar2 20 80 181 A2 CT2 WSH_PACKED_CONTAINERS ATTRIBUTE6
Container Flexfield 7 5020 Varchar2 30 80 261 A2 CT2 WSH_PACKED_CONTAINERS ATTRIBUTE7
Container Flexfield 8 5020 Varchar2 40 80 341 A2 CT2 WSH_PACKED_CONTAINERS ATTRIBUTE8
Container Flexfield 9 5020 Varchar2 50 80 421 A2 CT2 WSH_PACKED_CONTAINERS ATTRIBUTE9
RECORD 5030 (DSNO)
Common Key (Positions 1-91) 5030 Varchar2 91 1
Record Number 5030 Varchar2 4 92 Constant '5030'
Record Layout 5030 Varchar2 2 96 Constant 'A2'
Record Qualifier 5030 Varchar2 3 98 Constant 'CT3'
Container Flexfield 10 5030 Varchar2 10 80 101 A2 CT3 WSH_PACKED_CONTAINERS ATTRIBUTE10
Container Flexfield 11 5030 Varchar2 20 80 181 A2 CT3 WSH_PACKED_CONTAINERS ATTRIBUTE11
Container Flexfield 12 5030 Varchar2 30 80 261 A2 CT3 WSH_PACKED_CONTAINERS ATTRIBUTE12
Container Flexfield 13 5030 Varchar2 40 80 341 A2 CT3 WSH_PACKED_CONTAINERS ATTRIBUTE13
Container Flexfield 14 5030 Varchar2 50 80 421 A2 CT3 WSH_PACKED_CONTAINERS ATTRIBUTE14
RECORD 5040 (DSNO)
Common Key (Positions 1-91) 5040 Varchar2 91 1
Record Number 5040 Varchar2 4 92 Constant '5040'
Record Layout 5040 Varchar2 2 96 Constant 'A2'
Record Qualifier 5040 Varchar2 3 98 Constant 'CT4'
Container Flexfield 15 5040 Varchar2 10 80 101 A2 CT4 WSH_PACKED_CONTAINERS ATTRIBUTE15
RECORD 6000 (DSNO)
Common Key (Positions 1-91) 6000 Varchar2 91 1
Record Number 6000 Varchar2 4 92 Constant '6000'
Record Layout 6000 Varchar2 2 96 Constant 'P1'
Record Qualifier 6000 Varchar2 3 98 Constant 'PO1'
Purchase Order Number 6000 Varchar2 10 50 101 P1 PO1 SO_HEADERS_ALL PURCHASE_ORDER_NUM
Purchase Order Date 6000 Date 20 15 151 P1 PO1 SO_HEADERS_ALL DATE_ORDERED
Sales Order Number 6000 Varchar2 30 30 166 P1 PO1 SO_HEADERS_ALL ORDER_NUMBER
Sales Order Date 6000 Date 40 15 196 P1 PO1 SO_HEADERS_ALL DATE_ORDERED
Agreement Number (Int) AGREEMENT 6000 Varchar2 50 50 211 P1 PO1 SO_AGREEMENTS AGREEMENT_NUM
Agreement Number (contract) (Ext1) 6000 Varchar2 60 50 261 P1 PO1 ECE_XREF_DATA XREF_EXT_VALUE1
Order Type (Int) ORDER_TYPE 6000 Varchar2 70 30 311 P1 PO1 SO_ORDER_TYPES_ALL NAME
Order Type (Ext1) 6000 Varchar2 80 10 341 P1 PO1 ECE_XREF_DATA XREF_EXT_VALUE1
Order Context 6000 Varchar2 90 30 351 P1 PO1 SO_HEADERS_ALL ORDER_CATEGORY
Customer Request Date 6000 Date 100 15 381 P1 PO1 SO_HEADERS_ALL DATE_REQUESTED_CURRENT
Ship Partial Flag 6000 Varchar2 110 1 396 P1 PO1 SO_HEADERS_ALL SHIP_PARTIAL_FLAG
Freight Terms Code (Int) FREIGHT_TERMS 6000 Varchar2 120 30 397 P1 PO1 SO_HEADERS_ALL PAYMENT_TYPE_CODE
Freight Terms Code (Ext1) 6000 Varchar2 130 10 427 P1 PO1 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 6010 (DSNO)
Common Key (Positions 1-91) 6010 Varchar2 91 1
Record Number 6010 Varchar2 4 92 Constant '6010'
Record Layout 6010 Varchar2 2 96 Constant 'P2'
Record Qualifier 6010 Varchar2 3 98 Constant 'PO2'
Tax Exempt Flag 6010 Varchar2 10 1 101 P2 PO2 SO_HEADERS_ALL TAX_EXEMPT_FLAG
Tax Exempt Number 6010 Number 20 80 102 P2 PO2 SO_HEADERS_ALL TAX_EXEMPT_NUM
Tax Exempt Reason Code (Int) TAX_EXRSN 6010 Varchar2 30 30 182 P2 PO2 SO_HEADERS_ALL TAX_EXEMPT_REASON_CODE
Tax Exempt Reason Code (Ext1) 6010 Varchar2 40 80 212 P2 PO2 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 6020 (DSNO)
Common Key (Positions 1-91) 6020 Varchar2 91 1
Record Number 6020 Varchar2 4 92 Constant '6020'
Record Layout 6020 Varchar2 2 96 Constant 'P3'
Record Qualifier 6020 Varchar2 3 98 Constant 'PO3'
Currency Code 6020 Varchar2 10 15 101 P3 PO3 SO_HEADERS_ALL CURRENCY_CODE
Currency Conversion Type Code 6020 Varchar2 20 30 116 P3 PO3 SO_HEADERS_ALL CONVERSION_TYPE_CODE
Currency Conversion Date 6020 Date 30 15 146 P3 PO3 SO_HEADERS_ALL CONVERSION_DATE
Currency Conversion Rate 6020 Number 40 22 161 P3 PO3 SO_HEADERS_ALL CONVERSION_RATE
Payment Terms (Int) PAYMENT_TERMS 6020 Varchar2 50 15 183 P3 PO3 RA_TERMS DESCRIPTION
Payment Terms (Ext1) 6020 Varchar2 60 30 198 P3 PO3 ECE_XREF_DATA XREF_EXT_VALUE1
Payment Terms (Ext2) 6020 Varchar2 70 30 228 P3 PO3 ECE_XREF_DATA XREF_EXT_VALUE2
Payment Terms (Ext3) 6020 Varchar2 80 30 258 P3 PO3 ECE_XREF_DATA XREF_EXT_VALUE3
Payment Terms (Ext4) 6020 Varchar2 90 30 288 P3 PO3 ECE_XREF_DATA XREF_EXT_VALUE4
Payment Terms (Ext5) 6020 Varchar2 100 30 318 P3 PO3 ECE_XREF_DATA XREF_EXT_VALUE5
Payment Amount 6020 Number 110 22 348 P3 PO3 SO_HEADERS_ALL PAYMENT_AMOUNT
RECORD 6030 (DSNO)
Common Key (Positions 1-91) 6030 Varchar2 91 1
Record Number 6030 Varchar2 4 92 Constant '6030'
Record Layout 6030 Varchar2 2 96 Constant 'P4'
Record Qualifier 6030 Varchar2 3 98 Constant 'PO4'
FOB Location Code (Int) FOB 6030 Varchar2 10 30 101 P4 PO4 SO_HEADERS_ALL FOB_CODE
FOB Location Code (Ext1) 6030 Varchar2 20 30 131 P4 PO4 ECE_XREF_DATA XREF_EXT_VALUE1
FOB Payment Method Code (Int) FOB_PAYMENT 6030 Varchar2 30 30 161 P4 PO4 SO_HEADERS_ALL FREIGHT_TERMS_CODE
FOB Payment Method Code (Ext1) 6030 Varchar2 40 30 191 P4 PO4 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 6040 (DSNO)
Common Key (Positions 1-91) 6040 Varchar2 91 1
Record Number 6040 Varchar2 4 92 Constant '6040'
Record Layout 6040 Varchar2 2 96 Constant 'NT'
Record Qualifier 6040 Varchar2 3 98 Constant 'SHP'
Shipping Instructions 6040 Varchar2 10 240 101 NT SHP SO_HEADERS_ALL SHIPPING_INSTRUCTIONS
RECORD 6045 (DSNO)
Common Key (Positions 1-91) 6045 Varchar2 91 1
Record Number 6045 Varchar2 4 92 Constant '6045'
Record Layout 6045 Varchar2 2 96 Constant 'NT'
Record Qualifier 6045 Varchar2 3 98 Constant 'PAC'
Packing Instructions 6045 Varchar2 20 240 101 NT PAC SO_HEADERS_ALL PACKING_INSTRUCTIONS
RECORD 6050 (DSNO)
Common Key (Positions 1-91) 6050 Varchar2 91 1
Record Number 6050 Varchar2 4 92 Constant '6050'
Record Layout 6050 Varchar2 2 96 Constant 'AD'
Record Qualifier 6050 Varchar2 3 98 Constant 'OBY'
Order By Code (Int) 6050 Varchar2 10 20 101 AD OBY RA_ADDRESSES_ALL ORIG_SYSTEM_REFERENCE
Order By Code (Ext1) 6050 Varchar2 20 20 121 AD OBY ECE_TP_HEADERS TP_LOCATION_CODE_EXT
Order By Name 6050 Varchar2 30 60 141 AD OBY RA_CUSTOMERS NAME
Order By Address Line 1 6050 Varchar2 40 35 201 AD OBY RA_ADDRESSES_ALL ADDRESS1
Order By Address Line 2 6050 Varchar2 50 35 236 AD OBY RA_ADDRESSES_ALL ADDRESS2
Order By Address Line 3 6050 Varchar2 60 35 271 AD OBY RA_ADDRESSES_ALL ADDRESS3
Order By Address Line 4 6050 Varchar2 70 35 306 AD OBY RA_ADDRESSES_ALL ADDRESS4
Order By City 6050 Varchar2 80 30 341 AD OBY RA_ADDRESSES_ALL CITY
Order By Postal Code 6050 Varchar2 90 15 371 AD OBY RA_ADDRESSES_ALL POSTAL_CODE
Order By Country (Int) COUNTRY 6050 Varchar2 100 20 386 AD OBY RA_ADDRESSES_ALL COUNTRY
Order By Country (Ext1) 6050 Varchar2 110 3 406 AD OBY ECE_XREF_DATA XREF_EXT_VALUE1
Order By State (Int) STATE 6050 Varchar2 120 20 409 AD OBY RA_ADDRESSES_ALL STATE
Order By State (Ext1) 6050 Varchar2 130 10 429 AD OBY ECE_XREF_DATA XREF_EXT_VALUE1
Order By Province (Int) PROVINCE 6050 Varchar2 140 20 439 AD OBY RA_ADDRESSES_ALL PROVINCE
Order By Province (Ext1) 6050 Varchar2 150 10 459 AD OBY ECE_XREF_DATA XREF_EXT_VALUE1
Order By County 6050 Varchar2 160 25 469 AD OBY RA_ADDRESSES_ALL COUNTY
RECORD 6055 (DSNO)
Common Key (Positions 1-91) 6055 Varchar2 91 1
Record Number 6055 Varchar2 4 92 Constant '6055'
Record Layout 6055 Varchar2 2 96 Constant 'AE'
Record Qualifier 6055 Varchar2 3 98 Constant 'OBY'
Order By Code (Ext2) for TP REFERENCE 1 6055 Varchar2 10 80 101 AE OBY ECE_TP_HEADERS TP_REFERENCE_EXT1
Order By Code (Ext3) for TP REFERENCE 2 6055 Varchar2 20 80 181 ECE_TP_HEADERS TP_REFERENCE_EXT2
RECORD 6060 (DSNO)
Common Key (Positions 1-91) 6060 Varchar2 91 1
Record Number 6060 Varchar2 4 92 Constant '6060'
Record Layout 6060 Varchar2 2 96 Constant 'CN'
Record Qualifier 6060 Varchar2 3 98 Constant 'OBY'
Order By Contact Last Name 6060 Varchar2 10 35 101 CN OBY RA_CONTACTS LAST_NAME
Order By Contact First Name 6060 Varchar2 20 35 136 CN OBY RA_CONTACTS FIRST_NAME
Order By Contact Job Title 6060 Varchar2 30 40 171 CN OBY RA_CONTACTS JOB_TITLE
Order By Area Code 6060 Varchar2 40 10 211 CN OBY RA_PHONES AREA_CODE
Order By Telephone Number 6060 Varchar2 50 60 221 CN OBY RA_PHONES PHONE_NUMBER
RECORD 6070 (DSNO)
Common Key (Positions 1-91) 6070 Varchar2 91 1
Record Number 6070 Varchar2 4 92 Constant '6070'
Record Layout 6070 Varchar2 2 96 Constant 'AD'
Record Qualifier 6070 Varchar2 3 98 Constant 'BT'
Invoice Code (Int) 6070 Varchar2 10 20 101 AD BT RA_ADDRESSES_ALL ORIG_SYSTEM_REFERENCE
Invoice Code (Ext1) 6070 Varchar2 20 20 121 AD BT ECE_TP_HEADERS TP_LOCATION_CODE_EXT
Invoice Name 6070 Varchar2 30 60 141 AD BT RA_CUSTOMERS NAME
Invoice Address Line 1 6070 Varchar2 40 35 201 AD BT RA_ADDRESSES_ALL ADDRESS1
Invoice Address Line 2 6070 Varchar2 50 35 236 AD BT RA_ADDRESSES_ALL ADDRESS2
Invoice Address Line 3 6070 Varchar2 60 35 271 AD BT RA_ADDRESSES_ALL ADDRESS3
Invoice Address Line 4 6070 Varchar2 70 35 306 AD BT RA_ADDRESSES_ALL ADDRESS4
Invoice City 6070 Varchar2 80 30 341 AD BT RA_ADDRESSES_ALL CITY
Invoice Postal Code 6070 Varchar2 90 15 371 AD BT RA_ADDRESSES_ALL POSTAL_CODE
Invoice Country (Int) COUNTRY 6070 Varchar2 100 20 386 AD BT RA_ADDRESSES_ALL COUNTRY
Invoice Country (Ext1) 6070 Varchar2 110 3 406 AD BT ECE_XREF_DATA XREF_EXT_VALUE1
Invoice State (Int) STATE 6070 Varchar2 120 20 409 AD BT RA_ADDRESSES_ALL STATE
Invoice State (Ext1) 6070 Varchar2 130 10 429 AD BT ECE_XREF_DATA XREF_EXT_VALUE1
Invoice Province (Int) PROVINCE 6070 Varchar2 140 20 439 AD BT RA_ADDRESSES_ALL PROVINCE
Invoice Province (Ext1) 6070 Varchar2 150 10 459 AD BT ECE_XREF_DATA XREF_EXT_VALUE1
Invoice County 6070 Varchar2 160 25 469 AD BT RA_ADDRESSES_ALL COUNTY
RECORD 6075 (DSNO)
Common Key (Positions 1-91) 6075 Varchar2 91 1
Record Number 6075 Varchar2 4 92 Constant '6075'
Record Layout 6075 Varchar2 2 96 Constant 'AE'
Record Qualifier 6075 Varchar2 3 98 Constant 'BT'
Invoice Code (Ext2) for TP REFERENCE 1 6075 Varchar2 10 80 101 AE BT ECE_TP_HEADERS TP_REFERENCE_EXT1
Invoice Code (Ext3) for TP REFERENCE 2 6075 Varchar2 20 80 181 AE BT ECE_TP_HEADERS TP_REFERENCE_EXT2
RECORD 6080 (DSNO)
Common Key (Positions 1-91) 6080 Varchar2 91 1
Record Number 6080 Varchar2 4 92 Constant '6080'
Record Layout 6080 Varchar2 2 96 Constant 'CN'
Record Qualifier 6080 Varchar2 3 98 Constant 'BT'
Invoice Contact Last Name 6080 Varchar2 10 35 101 CN BT RA_CONTACTS LAST_NAME
Invoice Contact First Name 6080 Varchar2 20 35 136 CN BT RA_CONTACTS FIRST_NAME
Invoice Contact Job Title 6080 Varchar2 30 40 171 CN BT RA_CONTACTS JOB_TITLE
Invoice Area Code 6080 Varchar2 40 10 211 CN BT RA_PHONES AREA_CODE
Invoice Telephone Number 6080 Varchar2 50 60 221 CN BT RA_PHONES PHONE_NUMBER
RECORD 6100 (DSNO)
Common Key (Positions 1-91) 6100 Varchar2 91 1
Record Number 6100 Varchar2 4 92 Constant '6100'
Record Layout 6100 Varchar2 2 96 Constant 'A1'
Record Qualifier 6100 Varchar2 3 98 Constant 'PH1'
Picking Header Flexfield Context 6100 Varchar2 10 30 101 A1 PH1 SO_PICKING_HEADERS_ALL CONTEXT
Picking Header Flexfield 1 6100 Varchar2 20 80 131 A1 PH1 SO_PICKING_HEADERS_ALL ATTRIBUTE1
Picking Header Flexfield 2 6100 Varchar2 30 80 211 A1 PH1 SO_PICKING_HEADERS_ALL ATTRIBUTE2
Picking Header Flexfield 3 6100 Varchar2 40 80 291 A1 PH1 SO_PICKING_HEADERS_ALL ATTRIBUTE3
Picking Header Flexfield 4 6100 Varchar2 50 80 371 A1 PH1 SO_PICKING_HEADERS_ALL ATTRIBUTE4
RECORD 6110 (DSNO)
Common Key (Positions 1-91) 6110 Varchar2 91 1
Record Number 6110 Varchar2 4 92 Constant '6110'
Record Layout 6110 Varchar2 2 96 Constant 'A2'
Record Qualifier 6110 Varchar2 3 98 Constant 'PH2'
Picking Header Flexfield 5 6110 Varchar2 10 80 101 A2 PH2 SO_PICKING_HEADERS_ALL ATTRIBUTE5
Picking Header Flexfield 6 6110 Varchar2 20 80 181 A2 PH2 SO_PICKING_HEADERS_ALL ATTRIBUTE6
Picking Header Flexfield 7 6110 Varchar2 30 80 261 A2 PH2 SO_PICKING_HEADERS_ALL ATTRIBUTE7
Picking Header Flexfield 8 6110 Varchar2 40 80 341 A2 PH2 SO_PICKING_HEADERS_ALL ATTRIBUTE8
Picking Header Flexfield 9 6110 Varchar2 50 80 421 A2 PH2 SO_PICKING_HEADERS_ALL ATTRIBUTE9
RECORD 6120 (DSNO)
Common Key (Positions 1-91) 6120 Varchar2 91 1
Record Number 6120 Varchar2 4 92 Constant '6120'
Record Layout 6120 Varchar2 2 96 Constant 'A2'
Record Qualifier 6120 Varchar2 3 98 Constant 'PH3'
Picking Header Flexfield 10 6120 Varchar2 10 80 101 A2 PH3 SO_PICKING_HEADERS_ALL ATTRIBUTE10
Picking Header Flexfield 11 6120 Varchar2 20 80 181 A2 PH3 SO_PICKING_HEADERS_ALL ATTRIBUTE11
Picking Header Flexfield 12 6120 Varchar2 30 80 261 A2 PH3 SO_PICKING_HEADERS_ALL ATTRIBUTE12
Picking Header Flexfield 13 6120 Varchar2 40 80 341 A2 PH3 SO_PICKING_HEADERS_ALL ATTRIBUTE13
Picking Header Flexfield 14 6120 Varchar2 50 80 421 A2 PH3 SO_PICKING_HEADERS_ALL ATTRIBUTE14
RECORD 6130 (DSNO)
Common Key (Positions 1-91) 6130 Varchar2 91 1
Record Number 6130 Varchar2 4 92 Constant '6130'
Record Layout 6130 Varchar2 2 96 Constant 'A2'
Record Qualifier 6130 Varchar2 3 98 Constant 'PH4'
Picking Header Flexfield 15 6130 Varchar2 10 80 101 A2 PH4 SO_PICKING_HEADERS_ALL ATTRIBUTE15
RECORD 6200 (DSNO)
Common Key (Positions 1-91) 6200 Varchar2 91 1
Record Number 6200 Varchar2 4 92 Constant '6200'
Record Layout 6200 Varchar2 2 96 Constant 'A1'
Record Qualifier 6200 Varchar2 3 98 Constant 'OR1'
Order Header Flexfield Context 6200 Varchar2 10 30 101 A1 OR1 SO_HEADERS_ALL CONTEXT
Order Header Flexfield 1 6200 Varchar2 20 80 131 A1 OR1 SO_HEADERS_ALL ATTRIBUTE1
Order Header Flexfield 2 6200 Varchar2 30 80 211 A1 OR1 SO_HEADERS_ALL ATTRIBUTE2
Order Header Flexfield 3 6200 Varchar2 40 80 291 A1 OR1 SO_HEADERS_ALL ATTRIBUTE3
Order Header Flexfield 4 6200 Varchar2 50 80 371 A1 OR1 SO_HEADERS_ALL ATTRIBUTE4
RECORD 6210 (DSNO)
Common Key (Positions 1-91) 6210 Varchar2 91 1
Record Number 6210 Varchar2 4 92 Constant '6210'
Record Layout 6210 Varchar2 2 96 Constant 'A2'
Record Qualifier 6210 Varchar2 3 98 Constant 'OR2'
Order Header Flexfield 5 6210 Varchar2 10 80 101 A2 OR2 SO_HEADERS_ALL ATTRIBUTE5
Order Header Flexfield 6 6210 Varchar2 20 80 181 A2 OR2 SO_HEADERS_ALL ATTRIBUTE6
Order Header Flexfield 7 6210 Varchar2 30 80 261 A2 OR2 SO_HEADERS_ALL ATTRIBUTE7
Order Header Flexfield 8 6210 Varchar2 40 80 341 A2 OR2 SO_HEADERS_ALL ATTRIBUTE8
Order Header Flexfield 9 6210 Varchar2 50 80 421 A2 OR2 SO_HEADERS_ALL ATTRIBUTE9
RECORD 6220 (DSNO)
Common Key (Positions 1-91) 6220 Varchar2 91 1
Record Number 6220 Varchar2 4 92 Constant '6220'
Record Layout 6220 Varchar2 2 96 Constant 'A2'
Record Qualifier 6220 Varchar2 3 98 Constant 'OR3'
Order Header Flexfield 10 6220 Varchar2 10 80 101 A2 OR3 SO_HEADERS_ALL ATTRIBUTE10
Order Header Flexfield 11 6220 Varchar2 20 80 181 A2 OR3 SO_HEADERS_ALL ATTRIBUTE11
Order Header Flexfield 12 6220 Varchar2 30 80 261 A2 OR3 SO_HEADERS_ALL ATTRIBUTE12
Order Header Flexfield 13 6220 Varchar2 40 80 341 A2 OR3 SO_HEADERS_ALL ATTRIBUTE13
Order Header Flexfield 14 6220 Varchar2 50 80 421 A2 OR3 SO_HEADERS_ALL ATTRIBUTE14
RECORD 6230 (DSNO)
Common Key (Positions 1-91) 6230 Varchar2 91 1
Record Number 6230 Varchar2 4 92 Constant '6230'
Record Layout 6230 Varchar2 2 96 Constant 'A2'
Record Qualifier 6230 Varchar2 3 98 Constant 'OR4'
Order Header Flexfield 15 6230 Varchar2 10 80 101 A2 OR4 SO_HEADERS_ALL ATTRIBUTE15
RECORD 6300 (DSNO)
Common Key (Positions 1-91) 6300 Varchar2 91 1
Record Number 6300 Varchar2 4 92 Constant '6300'
Record Layout 6300 Varchar2 2 96 Constant 'A1'
Record Qualifier 6300 Varchar2 3 98 Constant 'HG1'
Order Header Global Flexfield Context 6300 Varchar2 10 30 101 A1 HG1 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE_CATEGORY
Order Header Global Flexfield 1 6300 Varchar2 20 80 131 A1 HG1 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE1
Order Header Global Flexfield 2 6300 Varchar2 30 80 211 A1 HG1 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE2
Order Header Global Flexfield 3 6300 Varchar2 40 80 291 A1 HG1 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE3
Order Header Global Flexfield 4 6300 Varchar2 50 80 371 A1 HG1 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE4
RECORD 6310 (DSNO)
Common Key (Positions 1-91) 6310 Varchar2 91 1
Record Number 6310 Varchar2 4 92 Constant '6310'
Record Layout 6310 Varchar2 2 96 Constant 'A2'
Record Qualifier 6310 Varchar2 3 98 Constant 'HG2'
Order Header Global Flexfield 5 6310 Varchar2 10 80 101 A2 HG2 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE5
Order Header Global Flexfield 6 6310 Varchar2 20 80 181 A2 HG2 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE6
Order Header Global Flexfield 7 6310 Varchar2 30 80 261 A2 HG2 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE7
Order Header Global Flexfield 8 6310 Varchar2 40 80 341 A2 HG2 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE8
Order Header Global Flexfield 9 6310 Varchar2 50 80 421 A2 HG2 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE9
RECORD 6320 (DSNO)
Common Key (Positions 1-91) 6320 Varchar2 91 1
Record Number 6320 Varchar2 4 92 Constant '6320'
Record Layout 6320 Varchar2 2 96 Constant 'A2'
Record Qualifier 6320 Varchar2 3 98 Constant 'HG3'
Order Header Global Flexfield 10 6320 Varchar2 10 80 101 A2 HG3 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE10
Order Header Global Flexfield 11 6320 Varchar2 20 80 181 A2 HG3 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE11
Order Header Global Flexfield 12 6320 Varchar2 30 80 261 A2 HG3 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE12
Order Header Global Flexfield 13 6320 Varchar2 40 80 341 A2 HG3 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE13
Order Header Global Flexfield 14 6320 Varchar2 50 80 421 A2 HG3 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE14
RECORD 6330 (DSNO)
Common Key (Positions 1-91) 6330 Varchar2 91 1
Record Number 6330 Varchar2 4 92 Constant '6330'
Record Layout 6330 Varchar2 2 96 Constant 'A2'
Record Qualifier 6330 Varchar2 3 98 Constant 'HG4'
Order Header Global Flexfield 15 6330 Varchar2 10 80 101 A2 HG4 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE15
Order Header Global Flexfield 16 6330 Varchar2 20 80 181 A2 HG4 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE16
Order Header Global Flexfield 17 6330 Varchar2 30 80 261 A2 HG4 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE17
Order Header Global Flexfield 18 6330 Varchar2 40 80 341 A2 HG4 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE18
Order Header Global Flexfield 19 6330 Varchar2 50 80 421 A2 HG4 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE19
RECORD 6340 (DSNO)
Common Key (Positions 1-91) 6340 Varchar2 91 1
Record Number 6340 Varchar2 4 92 Constant '6340'
Record Layout 6340 Varchar2 2 96 Constant 'A2'
Record Qualifier 6340 Varchar2 3 98 Constant 'HG5'
Order Header Global Flexfield 20 6340 Varchar2 10 80 101 A2 HG5 SO_HEADER_ATTRIBUTES GLOBAL_ATTRIBUTE20
RECORD 7000 (DSNO)
Common Key (Positions 1-91) 7000 Varchar2 91 1
Record Number 7000 Varchar2 4 92 Constant '7000'
Record Layout 7000 Varchar2 2 96 Constant 'I1'
Record Qualifier 7000 Varchar2 3 98 Constant 'IT1'
Original System Line Reference 7000 Varchar2 10 22 101 I1 IT1 SO_LINES_ALL ORIGINAL_SYSTEM_LINE_REFERENCE
Sales Order Line Number 7000 Varchar2 20 11 123 I1 IT1 SO_LINES_ALL LINE_NUMBER
Customer Part Number 7000 Varchar2 30 50 134 I1 IT1 MTL_CUSTOMER_ITEMS CUSTOMER_ITEM_NUMBER
Supplier Part Number 7000 Varchar2 40 50 184 I1 IT1 MTL_ITEM_FLEXFIELDS ITEM_NUMBER
Requested Date 7000 Date 50 15 234 I1 IT1 SO_LINES_ALL DATE_REQUESTED_CURRENT
Promise Date 7000 Date 60 15 249 I1 IT1 SO_LINES_ALL PROMISE_DATE
Shipped Quantity 7000 Number 70 22 264 I1 IT1 SO_LINES_ALL SHIPPED_QUANTITY
Item UOM Code (Int) UOM 7000 Varchar2 80 3 286 I1 IT1 WSH_CONTAINER_CONTENTS UOM_CODE
Item UOM Code (Ext1) 7000 Varchar2 90 5 289 I1 IT1 ECE_XREF_DATA XREF_EXT_VALUE1
Customer Model Serial Number 7000 Varchar2 100 50 294 I1 IT1 SO_LINES_ALL CUSTOMER_MODEL_SERIAL_NUMBER
Commodity Code 7000 Varchar2 110 30 344 I1 IT1 MTL_COMMODITY_CODES COMMODITY_CODE
Item Type Code (Int) ITEM_TYPE 7000 Varchar2 120 30 374 I1 IT1 SO_LINES_ALL ITEM_TYPE_CODE
Item Type Code (Ext1) 7000 Varchar2 130 30 404 I1 IT1 ECE_XREF_DATA XREF_EXT_VALUE1
Container Item Flag 7000 Varchar2 140 1 434 I1 IT1 MTL_SYSTEM_ITEMS CONTAINER_ITEM_FLAG
Container Type Code 7000 Varchar2 150 30 435 I1 IT1 MTL_SYSTEM_ITEMS CONTAINER_TYPE_CODE
RECORD 7010 (DSNO)
Common Key (Positions 1-91) 7010 Varchar2 91 1
Record Number 7010 Varchar2 4 92 Constant '7010'
Record Layout 7010 Varchar2 2 96 Constant 'I2'
Record Qualifier 7010 Varchar2 3 98 Constant 'IT2'
Order Line Ordered Quantity 7010 Number 10 22 101 I2 IT2 SO_LINES_ALL ORDERED_QUANTITY
Order Line Cancelled Quantity 7010 Number 20 22 123 I2 IT2 SO_LINES_ALL CANCELLED_QUANTITY
Packed Quantity 7010 Number 30 22 145 I2 IT2 WSH_CONTAINER_CONTENTS PACKED_QUANTITY
List Price 7010 Number 40 22 167 I2 IT2 SO_LINES_ALL LIST_PRICE
Selling Price 7010 Number 50 22 189 I2 IT2 SO_LINES_ALL SELLING_PRICE
RECORD 7020 (DSNO)
Common Key (Positions 1-91) 7020 Varchar2 91 1
Record Number 7020 Varchar2 4 92 Constant '7020'
Record Layout 7020 Varchar2 2 96 Constant 'I3'
Record Qualifier 7020 Varchar2 3 98 Constant 'IT3'
Configuration Item Flag 7020 Varchar2 10 1 101 I3 IT3 SO_PICKING_LINES_ALL CONFIGURATION_ITEM_FLAG
Order Item Option Flag 7020 Varchar2 20 1 102 I3 IT3 SO_LINES_ALL OPTION_FLAG
Ship Model Complete Flag 7020 Varchar2 30 1 103 I3 IT3 SO_LINES_ALL SHIP_MODEL_COMPLETE_FLAG
Included Item Flag 7020 Varchar2 40 1 104 I3 IT3 SO_PICKING_LINES_ALL INCLUDED_ITEM_FLAG
Shipment Order Status Code (Int) SHIP_ORDER_STATUS 7020 Number 50 22 105 I3 IT3 SO_LINES_ALL S4
Shipment Order Status Code (Ext1) 7020 Varchar2 60 20 127 I3 IT3 ECE_XREF_DATA XREF_EXT_VALUE1
Customer Dock Code 7020 Varchar2 70 30 147 I3 IT3 SO_LINES_ALL CUSTOMER_DOCK_CODE
Customer Production Line 7020 Varchar2 80 30 177 I3 IT3 SO_LINES_ALL CUSTOMER_PRODUCTION_LINE
Customer Job 7020 Varchar2 90 30 207 I3 IT3 SO_LINES_ALL CUSTOMER_JOB
Planning Production Sequence Number 7020 Varchar2 100 30 237 I3 IT3 SO_LINES_ALL PLANNING_PRODUCTION_SEQ_NUMBER
Priority Code (Int) SHIP_PRIOR 7020 Varchar2 110 30 267 I3 IT3 SO_LINES_ALL SHIPMENT_PRIORITY_CODE
Priority Code (Ext1) 7020 Varchar2 120 30 297 I3 IT3 ECE_XREF_DATA XREF_EXT_VALUE1
Ship Confirm Date 7020 Date 130 15 327 I3 IT3 SO_PICKING_LINES_ALL DATE_CONFIRMED
Transaction Reference Key 7020 Varchar2 140 30 342 I3 IT3 RLA_DEMAND_LINES_ALL REQUIREMENT_EXT
Customer Item Description 7020 Varchar2 150 125 372 I3 IT3 MTL_CUSTOMER_ITEMS CUSTOMER_ITEM_DESC
RECORD 7030 (DSNO)
Common Key (Positions 1-91) 7030 Varchar2 91 1
Record Number 7030 Varchar2 4 92 Constant '7030'
Record Layout 7030 Varchar2 2 96 Constant 'I4'
Record Qualifier 7030 Varchar2 3 98 Constant 'IT4'
Component Ratio 7030 Number 10 22 101 I4 IT4 SO_PICKING_LINES_ALL COMPONENT_RATIO
Component Code 7030 Varchar2 20 240 123 I4 IT4 SO_LINES_ALL COMPONENT_CODE
RECORD 7040 (DSNO)
Common Key (Positions 1-91) 7040 Varchar2 91 1
Record Number 7040 Varchar2 4 92 Constant '7040'
Record Layout 7040 Varchar2 2 96 Constant 'HZ'
Record Qualifier 7040 Varchar2 3 98 Constant 'HZ1'
Hazardous Material Code (Int) 7040 Varchar2 10 5 101 HZ HZ1
Hazardous Material Code (Ext) 7040 Varchar2 20 5 106 HZ HZ1
Hazard Material Class (Int) HAZ_CLASS 7040 Varchar2 30 40 111 HZ HZ1 PO_HAZARD_CLASSES HAZARD_CLASS
Hazard Material Class (Ext1) 7040 Varchar2 40 4 151 HZ HZ1 ECE_XREF_DATA XREF_EXT_VALUE1
Hazardous Class Description 7040 Varchar2 50 80 155 HZ HZ1 PO_HAZARD_CLASSES DESCRIPTION
RECORD 7200 (DSNO)
Common Key (Positions 1-91) 7200 Varchar2 91 1
Record Number 7200 Varchar2 4 92 Constant '7200'
Record Layout 7200 Varchar2 2 96 Constant 'A1'
Record Qualifier 7200 Varchar2 3 98 Constant 'PR1'
Order Line Pricing Flexfield Context 7200 Varchar2 10 30 101 A1 PR1 SO_LINES_ALL PRICING_CONTEXT
Order Line Pricing Flexfield 1 7200 Varchar2 20 80 131 A1 PR1 SO_LINES_ALL PRICING_ATTRIBUTE1
Order Line Pricing Flexfield 2 7200 Varchar2 30 80 211 A1 PR1 SO_LINES_ALL PRICING_ATTRIBUTE2
Order Line Pricing Flexfield 3 7200 Varchar2 40 80 291 A1 PR1 SO_LINES_ALL PRICING_ATTRIBUTE3
Order Line Pricing Flexfield 4 7200 Varchar2 50 80 371 A1 PR1 SO_LINES_ALL PRICING_ATTRIBUTE4
RECORD 7210 (DSNO)
Common Key (Positions 1-91) 7210 Varchar2 91 1
Record Number 7210 Varchar2 4 92 Constant '7210'
Record Layout 7210 Varchar2 2 96 Constant 'A2'
Record Qualifier 7210 Varchar2 3 98 Constant 'PR2'
Order Line Pricing Flexfield 5 7210 Varchar2 10 80 101 A2 PR2 SO_LINES_ALL PRICING_ATTRIBUTE5
Order Line Pricing Flexfield 6 7210 Varchar2 20 80 181 A2 PR2 SO_LINES_ALL PRICING_ATTRIBUTE6
Order Line Pricing Flexfield 7 7210 Varchar2 30 80 261 A2 PR2 SO_LINES_ALL PRICING_ATTRIBUTE7
Order Line Pricing Flexfield 8 7210 Varchar2 40 80 341 A2 PR2 SO_LINES_ALL PRICING_ATTRIBUTE8
Order Line Pricing Flexfield 9 7210 Varchar2 50 80 421 A2 PR2 SO_LINES_ALL PRICING_ATTRIBUTE9
RECORD 7220 (DSNO)
Common Key (Positions 1-91) 7220 Varchar2 91 1
Record Number 7220 Varchar2 4 92 Constant '7220'
Record Layout 7220 Varchar2 2 96 Constant 'A2'
Record Qualifier 7220 Varchar2 3 98 Constant 'PR3'
Order Line Pricing Flexfield 10 7220 Varchar2 10 80 101 A2 PR3 SO_LINES_ALL PRICING_ATTRIBUTE10
Order Line Pricing Flexfield 11 7220 Varchar2 20 80 181 A2 PR3 SO_LINES_ALL PRICING_ATTRIBUTE11
Order Line Pricing Flexfield 12 7220 Varchar2 30 80 261 A2 PR3 SO_LINES_ALL PRICING_ATTRIBUTE12
Order Line Pricing Flexfield 13 7220 Varchar2 40 80 341 A2 PR3 SO_LINES_ALL PRICING_ATTRIBUTE13
Order Line Pricing Flexfield 14 7220 Varchar2 50 80 421 A2 PR3 SO_LINES_ALL PRICING_ATTRIBUTE14
RECORD 7230 (DSNO)
Common Key (Positions 1-91) 7230 Varchar2 91 1
Record Number 7230 Varchar2 4 92 Constant '7230'
Record Layout 7230 Varchar2 2 96 Constant 'A2'
Record Qualifier 7230 Varchar2 3 98 Constant 'PR4'
Order Line Pricing Flexfield 15 7230 Varchar2 10 80 101 A2 PR4 SO_LINES_ALL PRICING_ATTRIBUTE15
RECORD 7240 (DSNO)
Common Key (Positions 1-91) 7240 Varchar2 91 1
Record Number 7240 Varchar2 4 92 Constant '7240'
Record Layout 7240 Varchar2 2 96 Constant 'A1'
Record Qualifier 7240 Varchar2 3 98 Constant 'LI1'
Order Line Flexfield Context 7240 Varchar2 10 30 101 A1 LI1 SO_LINES_ALL CONTEXT
Order Line Flexfield 1 7240 Varchar2 20 80 131 A1 LI1 SO_LINES_ALL ATTRIBUTE1
Order Line Flexfield 2 7240 Varchar2 30 80 211 A1 LI1 SO_LINES_ALL ATTRIBUTE2
Order Line Flexfield 3 7240 Varchar2 40 80 291 A1 LI1 SO_LINES_ALL ATTRIBUTE3
Order Line Flexfield 4 7240 Varchar2 50 80 371 A1 LI1 SO_LINES_ALL ATTRIBUTE4
RECORD 7250 (DSNO)
Common Key (Positions 1-91) 7250 Varchar2 91 1
Record Number 7250 Varchar2 4 92 Constant '7250'
Record Layout 7250 Varchar2 2 96 Constant 'A2'
Record Qualifier 7250 Varchar2 3 98 Constant 'LI2'
Order Line Flexfield 5 7250 Varchar2 10 80 101 A2 LI2 SO_LINES_ALL ATTRIBUTE5
Order Line Flexfield 6 7250 Varchar2 20 80 181 A2 LI2 SO_LINES_ALL ATTRIBUTE6
Order Line Flexfield 7 7250 Varchar2 30 80 261 A2 LI2 SO_LINES_ALL ATTRIBUTE7
Order Line Flexfield 8 7250 Varchar2 40 80 341 A2 LI2 SO_LINES_ALL ATTRIBUTE8
Order Line Flexfield 9 7250 Varchar2 50 80 421 A2 LI2 SO_LINES_ALL ATTRIBUTE9
RECORD 7260 (DSNO)
Common Key (Positions 1-91) 7260 Varchar2 91 1
Record Number 7260 Varchar2 4 92 Constant '7260'
Record Layout 7260 Varchar2 2 96 Constant 'A2'
Record Qualifier 7260 Varchar2 3 98 Constant 'LI3'
Order Line Flexfield 10 7260 Varchar2 10 80 101 A2 LI3 SO_LINES_ALL ATTRIBUTE10
Order Line Flexfield 11 7260 Varchar2 20 80 181 A2 LI3 SO_LINES_ALL ATTRIBUTE11
Order Line Flexfield 12 7260 Varchar2 30 80 261 A2 LI3 SO_LINES_ALL ATTRIBUTE12
Order Line Flexfield 13 7260 Varchar2 40 80 341 A2 LI3 SO_LINES_ALL ATTRIBUTE13
Order Line Flexfield 14 7260 Varchar2 50 80 421 A2 LI3 SO_LINES_ALL ATTRIBUTE14
RECORD 7270 (DSNO)
Common Key (Positions 1-91) 7270 Varchar2 91 1
Record Number 7270 Varchar2 4 92 Constant '7270'
Record Layout 7270 Varchar2 2 96 Constant 'A2'
Record Qualifier 7270 Varchar2 3 98 Constant 'LI4'
Order Line Flexfield 15 7270 Varchar2 10 80 101 A2 LI4 SO_LINES_ALL ATTRIBUTE15
RECORD 7280 (DSNO)
Common Key (Positions 1-91) 7280 Varchar2 91 1
Record Number 7280 Varchar2 4 92 Constant '7280'
Record Layout 7280 Varchar2 2 96 Constant 'A1'
Record Qualifier 7280 Varchar2 3 98 Constant 'LD1'
Order Line Details Flexfield Context 7280 Varchar2 10 30 101 A1 LD1 SO_LINE_DETAILS CONTEXT
Order Line Details Flexfield 1 7280 Varchar2 20 80 131 A1 LD1 SO_LINE_DETAILS ATTRIBUTE1
Order Line Details Flexfield 2 7280 Varchar2 30 80 211 A1 LD1 SO_LINE_DETAILS ATTRIBUTE2
Order Line Details Flexfield 3 7280 Varchar2 40 80 291 A1 LD1 SO_LINE_DETAILS ATTRIBUTE3
Order Line Details Flexfield 4 7280 Varchar2 50 80 371 A1 LD1 SO_LINE_DETAILS ATTRIBUTE4
RECORD 7290 (DSNO)
Common Key (Positions 1-91) 7290 Varchar2 91 1
Record Number 7290 Varchar2 4 92 Constant '7290'
Record Layout 7290 Varchar2 2 96 Constant 'A2'
Record Qualifier 7290 Varchar2 3 98 Constant 'LD2'
Order Line Details Flexfield 5 7290 Varchar2 10 80 101 A2 LD2 SO_LINE_DETAILS ATTRIBUTE5
Order Line Details Flexfield 6 7290 Varchar2 20 80 181 A2 LD2 SO_LINE_DETAILS ATTRIBUTE6
Order Line Details Flexfield 7 7290 Varchar2 30 80 261 A2 LD2 SO_LINE_DETAILS ATTRIBUTE7
Order Line Details Flexfield 8 7290 Varchar2 40 80 341 A2 LD2 SO_LINE_DETAILS ATTRIBUTE8
Order Line Details Flexfield 9 7290 Varchar2 50 80 421 A2 LD2 SO_LINE_DETAILS ATTRIBUTE9
RECORD 7300 (DSNO)
Common Key (Positions 1-91) 7300 Varchar2 91 1
Record Number 7300 Varchar2 4 92 Constant '7300'
Record Layout 7300 Varchar2 2 96 Constant 'A2'
Record Qualifier 7300 Varchar2 3 98 Constant 'LD3'
Order Line Details Flexfield 10 7300 Varchar2 10 80 101 A2 LD3 SO_LINE_DETAILS ATTRIBUTE10
Order Line Details Flexfield 11 7300 Varchar2 20 80 181 A2 LD3 SO_LINE_DETAILS ATTRIBUTE11
Order Line Details Flexfield 12 7300 Varchar2 30 80 261 A2 LD3 SO_LINE_DETAILS ATTRIBUTE12
Order Line Details Flexfield 13 7300 Varchar2 40 80 341 A2 LD3 SO_LINE_DETAILS ATTRIBUTE13
Order Line Details Flexfield 14 7300 Varchar2 50 80 421 A2 LD3 SO_LINE_DETAILS ATTRIBUTE14
RECORD 7310 (DSNO)
Common Key (Positions 1-91) 7310 Varchar2 91 1
Record Number 7310 Varchar2 4 92 Constant '7310'
Record Layout 7310 Varchar2 2 96 Constant 'A2'
Record Qualifier 7310 Varchar2 3 98 Constant 'LD4'
Order Line Details Flexfield 15 7310 Varchar2 10 80 101 A2 LD4 SO_LINE_DETAILS ATTRIBUTE15
RECORD 7320 (DSNO)
Common Key (Positions 1-91) 7320 Varchar2 91 1
Record Number 7320 Varchar2 4 92 Constant '7320'
Record Layout 7320 Varchar2 2 96 Constant 'A1'
Record Qualifier 7320 Varchar2 3 98 Constant 'LG1'
Order Line Global Flexfield Context 7320 Varchar2 10 30 101 A1 LG1 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE_CATEGORY
Order Line Global Flexfield 1 7320 Varchar2 20 80 131 A1 LG1 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE1
Order Line Global Flexfield 2 7320 Varchar2 30 80 211 A1 LG1 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE2
Order Line Global Flexfield 3 7320 Varchar2 40 80 291 A1 LG1 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE3
Order Line Global Flexfield 4 7320 Varchar2 50 80 371 A1 LG1 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE4
RECORD 7330 (DSNO)
Common Key (Positions 1-91) 7330 Varchar2 91 1
Record Number 7330 Varchar2 4 92 Constant '7330'
Record Layout 7330 Varchar2 2 96 Constant 'A2'
Record Qualifier 7330 Varchar2 3 98 Constant 'LG2'
Order Line Global Flexfield 5 7330 Varchar2 10 80 101 A2 LG2 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE5
Order Line Global Flexfield 6 7330 Varchar2 20 80 181 A2 LG2 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE6
Order Line Global Flexfield 7 7330 Varchar2 30 80 261 A2 LG2 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE7
Order Line Global Flexfield 8 7330 Varchar2 40 80 341 A2 LG2 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE8
Order Line Global Flexfield 9 7330 Varchar2 50 80 421 A2 LG2 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE9
RECORD 7340 (DSNO)
Common Key (Positions 1-91) 7340 Varchar2 91 1
Record Number 7340 Varchar2 4 92 Constant '7340'
Record Layout 7340 Varchar2 2 96 Constant 'A2'
Record Qualifier 7340 Varchar2 3 98 Constant 'LG3'
Order Line Global Flexfield 10 7340 Varchar2 10 80 101 A2 LG3 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE10
Order Line Global Flexfield 11 7340 Varchar2 20 80 181 A2 LG3 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE11
Order Line Global Flexfield 12 7340 Varchar2 30 80 261 A2 LG3 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE12
Order Line Global Flexfield 13 7340 Varchar2 40 80 341 A2 LG3 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE13
Order Line Global Flexfield 14 7340 Varchar2 50 80 421 A2 LG3 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE14
RECORD 7350 (DSNO)
Common Key (Positions 1-91) 7350 Varchar2 91 1
Record Number 7350 Varchar2 4 92 Constant '7350'
Record Layout 7350 Varchar2 2 96 Constant 'A2'
Record Qualifier 7350 Varchar2 3 98 Constant 'LG4'
Order Line Global Flexfield 15 7350 Varchar2 10 80 101 A2 LG4 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE15
Order Line Global Flexfield 16 7350 Varchar2 20 80 181 A2 LG4 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE16
Order Line Global Flexfield 17 7350 Varchar2 30 80 261 A2 LG4 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE17
Order Line Global Flexfield 18 7350 Varchar2 40 80 341 A2 LG4 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE18
Order Line Global Flexfield 19 7350 Varchar2 50 80 421 A2 LG4 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE19
RECORD 7360 (DSNO)
Common Key (Positions 1-91) 7360 Varchar2 91 1
Record Number 7360 Varchar2 4 92 Constant '7360'
Record Layout 7360 Varchar2 2 96 Constant 'A2'
Record Qualifier 7360 Varchar2 3 98 Constant 'LG5'
Order Line Global Flexfield 20 7360 Varchar2 10 80 101 A2 LG5 SO_LINE_ATTRIBUTES GLOBAL_ATTRIBUTE20
RECORD 7370 (DSNO)
Common Key (Positions 1-91) 7370 Varchar2 91 1
Record Number 7370 Varchar2 4 92 Constant '7370'
Record Layout 7370 Varchar2 2 96 Constant 'A1'
Record Qualifier 7370 Varchar2 3 98 Constant 'DG1'
Order Line Detail Global Flexfield Context 7370 Varchar2 10 30 101 A1 DG1 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE_CATEGORY
Order Line Detail Global Flexfield 1 7370 Varchar2 20 80 131 A1 DG1 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE1
Order Line Detail Global Flexfield 2 7370 Varchar2 30 80 211 A1 DG1 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE2
Order Line Detail Global Flexfield 3 7370 Varchar2 40 80 291 A1 DG1 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE3
Order Line Detail Global Flexfield 4 7370 Varchar2 50 80 371 A1 DG1 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE4
RECORD 7380 (DSNO)
Common Key (Positions 1-91) 7380 Varchar2 91 1
Record Number 7380 Varchar2 4 92 Constant '7380'
Record Layout 7380 Varchar2 2 96 Constant 'A2'
Record Qualifier 7380 Varchar2 3 98 Constant 'DG2'
Order Line Detail Global Flexfield 5 7380 Varchar2 10 80 101 A2 DG2 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE5
Order Line Detail Global Flexfield 6 7380 Varchar2 20 80 181 A2 DG2 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE6
Order Line Detail Global Flexfield 7 7380 Varchar2 30 80 261 A2 DG2 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE7
Order Line Detail Global Flexfield 8 7380 Varchar2 40 80 341 A2 DG2 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE8
Order Line Detail Global Flexfield 9 7380 Varchar2 50 80 421 A2 DG2 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE9
RECORD 7390 (DSNO)
Common Key (Positions 1-91) 7390 Varchar2 91 1
Record Number 7390 Varchar2 4 92 Constant '7390'
Record Layout 7390 Varchar2 2 96 Constant 'A2'
Record Qualifier 7390 Varchar2 3 98 Constant 'DG3'
Order Line Detail Global Flexfield 10 7390 Varchar2 10 80 101 A2 DG3 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE10
Order Line Detail Global Flexfield 11 7390 Varchar2 20 80 181 A2 DG3 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE11
Order Line Detail Global Flexfield 12 7390 Varchar2 30 80 261 A2 DG3 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE12
Order Line Detail Global Flexfield 13 7390 Varchar2 40 80 341 A2 DG3 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE13
Order Line Detail Global Flexfield 14 7390 Varchar2 50 80 421 A2 DG3 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE14
RECORD 7400 (DSNO)
Common Key (Positions 1-91) 7400 Varchar2 91 1
Record Number 7400 Varchar2 4 92 Constant '7400'
Record Layout 7400 Varchar2 2 96 Constant 'A2'
Record Qualifier 7400 Varchar2 3 98 Constant 'DG4'
Order Line Detail Global Flexfield 15 7400 Varchar2 10 80 101 A2 DG4 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE15
Order Line Detail Global Flexfield 16 7400 Varchar2 20 80 181 A2 DG4 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE16
Order Line Detail Global Flexfield 17 7400 Varchar2 30 80 261 A2 DG4 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE17
Order Line Detail Global Flexfield 18 7400 Varchar2 40 80 341 A2 DG4 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE18
Order Line Detail Global Flexfield 19 7400 Varchar2 50 80 421 A2 DG4 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE19
RECORD 7410 (DSNO)
Common Key (Positions 1-91) 7410 Varchar2 91 1
Record Number 7410 Varchar2 4 92 Constant '7410'
Record Layout 7410 Varchar2 2 96 Constant 'A2'
Record Qualifier 7410 Varchar2 3 98 Constant 'DG5'
Order Line Detail Global Flexfield 20 7410 Varchar2 10 80 101 A2 DG5 SO_LINE_DETAIL_ATTRIBUTESGLOBAL_ATTRIBUTE20
RECORD 7420 (DSNO)
Common Key (Positions 1-91) 7420 Varchar2 91 1
Record Number 7420 Varchar2 4 92 Constant '7420'
Record Layout 7420 Varchar2 2 96 Constant 'A1'
Record Qualifier 7420 Varchar2 3 98 Constant 'PL1'
Picking Line Flexfield Context 7420 Varchar2 10 30 101 A1 PL1 SO_PICKING_LINES_ALL CONTEXT
Picking Line Flexfield 1 7420 Varchar2 20 80 131 A1 PL1 SO_PICKING_LINES_ALL ATTRIBUTE1
Picking Line Flexfield 2 7420 Varchar2 30 80 211 A1 PL1 SO_PICKING_LINES_ALL ATTRIBUTE2
Picking Line Flexfield 3 7420 Varchar2 40 80 291 A1 PL1 SO_PICKING_LINES_ALL ATTRIBUTE3
Picking Line Flexfield 4 7420 Varchar2 50 80 371 A1 PL1 SO_PICKING_LINES_ALL ATTRIBUTE4
RECORD 7430 (DSNO)
Common Key (Positions 1-91) 7430 Varchar2 91 1
Record Number 7430 Varchar2 4 92 Constant '7430'
Record Layout 7430 Varchar2 2 96 Constant 'A2'
Record Qualifier 7430 Varchar2 3 98 Constant 'PL2'
Picking Line Flexfield 5 7430 Varchar2 10 80 101 A2 PL2 SO_PICKING_LINES_ALL ATTRIBUTE5
Picking Line Flexfield 6 7430 Varchar2 20 80 181 A2 PL2 SO_PICKING_LINES_ALL ATTRIBUTE6
Picking Line Flexfield 7 7430 Varchar2 30 80 261 A2 PL2 SO_PICKING_LINES_ALL ATTRIBUTE7
Picking Line Flexfield 8 7430 Varchar2 40 80 341 A2 PL2 SO_PICKING_LINES_ALL ATTRIBUTE8
Picking Line Flexfield 9 7430 Varchar2 50 80 421 A2 PL2 SO_PICKING_LINES_ALL ATTRIBUTE9
RECORD 7440 (DSNO)
Common Key (Positions 1-91) 7440 Varchar2 91 1
Record Number 7440 Varchar2 4 92 Constant '7440'
Record Layout 7440 Varchar2 2 96 Constant 'A2'
Record Qualifier 7440 Varchar2 3 98 Constant 'PL3'
Picking Line Flexfield 10 7440 Varchar2 10 80 101 A2 PL3 SO_PICKING_LINES_ALL ATTRIBUTE10
Picking Line Flexfield 11 7440 Varchar2 20 80 181 A2 PL3 SO_PICKING_LINES_ALL ATTRIBUTE11
Picking Line Flexfield 12 7440 Varchar2 30 80 261 A2 PL3 SO_PICKING_LINES_ALL ATTRIBUTE12
Picking Line Flexfield 13 7440 Varchar2 40 80 341 A2 PL3 SO_PICKING_LINES_ALL ATTRIBUTE13
Picking Line Flexfield 14 7440 Varchar2 50 80 421 A2 PL3 SO_PICKING_LINES_ALL ATTRIBUTE14
RECORD 7450 (DSNO)
Common Key (Positions 1-91) 7450 Varchar2 91 1
Record Number 7450 Varchar2 4 92 Constant '7450'
Record Layout 7450 Varchar2 2 96 Constant 'A2'
Record Qualifier 7450 Varchar2 3 98 Constant 'PL4'
Picking Line Flexfield 15 7450 Varchar2 10 80 101 A2 PL4 SO_PICKING_LINES_ALL ATTRIBUTE15
RECORD 7460 (DSNO)
Common Key (Positions 1-91) 7460 Varchar2 91 1
Record Number 7460 Varchar2 4 92 Constant '7460'
Record Layout 7460 Varchar2 2 96 Constant 'A1'
Record Qualifier 7460 Varchar2 3 98 Constant 'LP1'
Line Part Flexfield Context 7460 Varchar2 10 30 101 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE_CATEGORY
Line Part Flexfield 1 7460 Varchar2 20 80 131 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE1
Line Part Flexfield 2 7460 Varchar2 30 80 211 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE2
Line Part Flexfield 3 7460 Varchar2 40 80 291 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE3
Line Part Flexfield 4 7460 Varchar2 50 80 371 A1 LP1 MTL_ITEM_FLEXFIELDS ATTRIBUTE4
RECORD 7470 (DSNO)
Common Key (Positions 1-91) 7470 Varchar2 91 1
Record Number 7470 Varchar2 4 92 Constant '7470'
Record Layout 7470 Varchar2 2 96 Constant 'A2'
Record Qualifier 7470 Varchar2 3 98 Constant 'LP2'
Line Part Flexfield 5 7470 Varchar2 10 80 101 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE5
Line Part Flexfield 6 7470 Varchar2 20 80 181 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE6
Line Part Flexfield 7 7470 Varchar2 30 80 261 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE7
Line Part Flexfield 8 7470 Varchar2 40 80 341 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE8
Line Part Flexfield 9 7470 Varchar2 50 80 421 A2 LP2 MTL_ITEM_FLEXFIELDS ATTRIBUTE9
RECORD 7480 (DSNO)
Common Key (Positions 1-91) 7480 Varchar2 91 1
Record Number 7480 Varchar2 4 92 Constant '7480'
Record Layout 7480 Varchar2 2 96 Constant 'A2'
Record Qualifier 7480 Varchar2 3 98 Constant 'LP3'
Line Part Flexfield 10 7480 Varchar2 10 80 101 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE10
Line Part Flexfield 11 7480 Varchar2 20 80 181 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE11
Line Part Flexfield 12 7480 Varchar2 30 80 261 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE12
Line Part Flexfield 13 7480 Varchar2 40 80 341 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE13
Line Part Flexfield 14 7480 Varchar2 50 80 421 A2 LP3 MTL_ITEM_FLEXFIELDS ATTRIBUTE14
RECORD 7490 (DSNO)
Common Key (Positions 1-91) 7490 Varchar2 91 1
Record Number 7490 Varchar2 4 92 Constant '7490'
Record Layout 7490 Varchar2 2 96 Constant 'A2'
Record Qualifier 7490 Varchar2 3 98 Constant 'LP4'
Line Part Flexfield 15 7490 Varchar2 10 80 101 A2 LP4 MTL_ITEM_FLEXFIELDS ATTRIBUTE15
RECORD 7600 (DSNO)
Common Key (Positions 1-91) 7600 Varchar2 91 1
Record Number 7600 Varchar2 4 92 Constant '7600'
Record Layout 7600 Varchar2 2 96 Constant 'A1'
Record Qualifier 7600 Varchar2 3 98 Constant 'IN1'
Order Line Industry Flexfield Context 7600 Varchar2 10 30 101 A1 IN1 SO_LINE_ATTRIBUTES INDUSTRY_CONTEXT
Order Line Industry Flexfield 1 7600 Varchar2 20 80 131 A1 IN1 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE1
Order Line Industry Flexfield 2 7600 Varchar2 30 80 211 A1 IN1 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE2
Order Line Industry Flexfield 3 7600 Varchar2 40 80 291 A1 IN1 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE3
Order Line Industry Flexfield 4 7600 Varchar2 50 80 371 A1 IN1 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE4
RECORD 7610 (DSNO)
Common Key (Positions 1-91) 7610 Varchar2 91 1
Record Number 7610 Varchar2 4 92 Constant '7610'
Record Layout 7610 Varchar2 2 96 Constant 'A2'
Record Qualifier 7610 Varchar2 3 98 Constant 'IN2'
Order Line Industry Flexfield 5 7610 Varchar2 10 80 101 A2 IN2 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE5
Order Line Industry Flexfield 6 7610 Varchar2 20 80 181 A2 IN2 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE6
Order Line Industry Flexfield 7 7610 Varchar2 30 80 261 A2 IN2 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE7
Order Line Industry Flexfield 8 7610 Varchar2 40 80 341 A2 IN2 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE8
Order Line Industry Flexfield 9 7610 Varchar2 50 80 421 A2 IN2 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE9
RECORD 7620 (DSNO)
Common Key (Positions 1-91) 7620 Varchar2 91 1
Record Number 7620 Varchar2 4 92 Constant '7620'
Record Layout 7620 Varchar2 2 96 Constant 'A2'
Record Qualifier 7620 Varchar2 3 98 Constant 'IN3'
Order Line Industry Flexfield 10 7620 Varchar2 10 80 101 A2 IN3 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE10
Order Line Industry Flexfield 11 7620 Varchar2 20 80 181 A2 IN3 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE11
Order Line Industry Flexfield 12 7620 Varchar2 30 80 261 A2 IN3 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE12
Order Line Industry Flexfield 13 7620 Varchar2 40 80 341 A2 IN3 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE13
Order Line Industry Flexfield 14 7620 Varchar2 50 80 421 A2 IN3 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE14
RECORD 7630 (DSNO)
Common Key (Positions 1-91) 7630 Varchar2 91 1
Record Number 7630 Varchar2 4 92 Constant '7630'
Record Layout 7630 Varchar2 2 96 Constant 'A2'
Record Qualifier 7630 Varchar2 3 98 Constant 'IN4'
Order Line Industry Flexfield 15 7630 Varchar2 10 80 101 A2 IN4 SO_LINE_ATTRIBUTES INDUSTRY_ATTRIBUTE15
RECORD 8000 (DSNO)
Common Key (Positions 1-91) 8000 Varchar2 91 1
Record Number 8000 Varchar2 4 92 Constant '8000'
Record Layout 8000 Varchar2 2 96 Constant 'AC'
Record Qualifier 8000 Varchar2 3 98 Constant 'IA1'
Allowance/Charge Indicator 8000 Varchar2 10 1 101 AC IA1
Allowance/Charge Amount 8000 Number 20 22 102 AC IA1 SO_FREIGHT_CHARGES AMOUNT
Currency Code 8000 Varchar2 30 15 124 AC IA1 SO_FREIGHT_CHARGES CURRENCY_CODE
Currency Conversion Type Code 8000 Varchar2 40 30 139 AC IA1 SO_FREIGHT_CHARGES CONVERSION_TYPE_CODE
Currency Conversion Date 8000 Date 50 15 169 AC IA1 SO_FREIGHT_CHARGES CONVERSION_DATE
Currency Conversion Rate 8000 Number 60 22 184 AC IA1 SO_FREIGHT_CHARGES CONVERSION_RATE
Allowance/Charge Handling Code (Int) AC_HANDL 8000 Varchar2 70 30 206 AC IA1 SO_FREIGHT_CHARGE_TYPES NAME
Allowance/Charge Handling Code (Ext1) 8000 Varchar2 80 30 236 AC IA1 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 8010 (DSNO)
Common Key (Positions 1-91) 8010 Varchar2 91 1
Record Number 8010 Varchar2 4 92 Constant '8010'
Record Layout 8010 Varchar2 2 96 Constant 'A5'
Record Qualifier 8010 Varchar2 3 98 Constant 'IA2'
Allowance/Charge Flexfield Context 8010 Varchar2 10 30 101 A5 IA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE_CATEGORY
Allowance/Charge Special Services Code (Int) AC_SPECS 8010 Varchar2 20 70 131 A5 IA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE1
Allowance/Charge Flexfield 1 (Ext1) 8010 Varchar2 30 25 201 A5 IA2 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Special Charges Code (Int) AC_SPECC 8010 Varchar2 40 70 226 A5 IA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE2
Allowance/Charge Flexfield 2 (Ext1) 8010 Varchar2 50 25 296 A5 IA2 ECE_XREF_DATA XREF_EXT_VALUE1
AETC Number (Int) 8010 Varchar2 60 70 321 A5 IA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE3
Allowance/Charge Flexfield 3 (Ext1) 8010 Varchar2 70 25 391 A5 IA2 ECE_XREF_DATA XREF_EXT_VALUE1
AETC Responsibility Code (Int) AETC_RESP 8010 Varchar2 80 70 416 A5 IA2 SO_FREIGHT_CHARGES AC_ATTRIBUTE4
Allowance/Charge Flexfield 4 (Ext1) 8010 Varchar2 90 25 486 A5 IA2 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 8020 (DSNO)
Common Key (Positions 1-91) 8020 Varchar2 91 1
Record Number 8020 Varchar2 4 92 Constant '8020'
Record Layout 8020 Varchar2 2 96 Constant 'A6'
Record Qualifier 8020 Varchar2 3 98 Constant 'IA3'
AETC Reason Code (Int) AETC_RSN 8020 Varchar2 10 70 101 A6 IA3 SO_FREIGHT_CHARGES AC_ATTRIBUTE5
Allowance/Charge Flexfield 5 (Ext1) 8020 Varchar2 20 25 171 A6 IA3 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 6 (Int) User Choice 8020 Varchar2 30 70 196 A6 IA3 SO_FREIGHT_CHARGES AC_ATTRIBUTE6
Allowance/Charge Flexfield 6 (Ext1) 8020 Varchar2 40 25 266 A6 IA3 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 7 (Int) User Choice 8020 Varchar2 50 70 291 A6 IA3 SO_FREIGHT_CHARGES AC_ATTRIBUTE7
Allowance/Charge Flexfield 7 (Ext1) 8020 Varchar2 60 25 361 A6 IA3 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 8 (Int) User Choice 8020 Varchar2 70 70 386 A6 IA3 SO_FREIGHT_CHARGES AC_ATTRIBUTE8
Allowance/Charge Flexfield 8 (Ext1) 8020 Varchar2 80 25 456 A6 IA3 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 8030 (DSNO)
Common Key (Positions 1-91) 8030 Varchar2 91 1
Record Number 8030 Varchar2 4 92 Constant '8030'
Record Layout 8030 Varchar2 2 96 Constant 'A6'
Record Qualifier 8030 Varchar2 3 98 Constant 'IA4'
Allowance/Charge Flexfield 9 (Int) User Choice 8030 Varchar2 10 70 101 A6 IA4 SO_FREIGHT_CHARGES AC_ATTRIBUTE9
Allowance/Charge Flexfield 9 (Ext1) 8030 Varchar2 20 25 171 A6 IA4 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 10 (Int) User Choice 8030 Varchar2 30 70 196 A6 IA4 SO_FREIGHT_CHARGES AC_ATTRIBUTE10
Allowance/Charge Flexfield 10 (Ext1) 8030 Varchar2 40 25 266 A6 IA4 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 11 (Int) User Choice 8030 Varchar2 50 70 291 A6 IA4 SO_FREIGHT_CHARGES AC_ATTRIBUTE11
Allowance/Charge Flexfield 11 (Ext1) 8030 Varchar2 60 25 361 A6 IA4 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 12 (Int) User Choice 8030 Varchar2 70 70 386 A6 IA4 SO_FREIGHT_CHARGES AC_ATTRIBUTE12
Allowance/Charge Flexfield 12 (Ext1) 8030 Varchar2 80 25 456 A6 IA4 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 8040 (DSNO)
Common Key (Positions 1-91) 8040 Varchar2 91 1
Record Number 8040 Varchar2 4 92 Constant '8040'
Record Layout 8040 Varchar2 2 96 Constant 'A6'
Record Qualifier 8040 Varchar2 3 98 Constant 'IA5'
Allowance/Charge Flexfield 13 (Int) User Choice 8040 Varchar2 10 70 101 A6 IA5 SO_FREIGHT_CHARGES AC_ATTRIBUTE13
Allowance/Charge Flexfield 13 (Ext1) 8040 Varchar2 20 25 171 A6 IA5 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 14 (Int) User Choice 8040 Varchar2 30 70 196 A6 IA5 SO_FREIGHT_CHARGES AC_ATTRIBUTE14
Allowance/Charge Flexfield 14 (Ext1) 8040 Varchar2 40 25 266 A6 IA5 ECE_XREF_DATA XREF_EXT_VALUE1
Allowance/Charge Flexfield 15 (Int) User Choice 8040 Varchar2 50 70 291 A6 IA5 SO_FREIGHT_CHARGES AC_ATTRIBUTE15
Allowance/Charge Flexfield 15 (Ext1) 8040 Varchar2 60 25 361 A6 IA5 ECE_XREF_DATA XREF_EXT_VALUE1
RECORD 8050 (DSNO)
Common Key (Positions 1-91) 8050 Varchar2 91 1
Record Number 8050 Varchar2 4 92 Constant '8050'
Record Layout 8050 Varchar2 2 96 Constant 'A1'
Record Qualifier 8050 Varchar2 3 98 Constant 'FH1'
Freight Charges Flexfield Context 8050 Varchar2 10 30 101 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE_CATEGORY
Freight Charges Flexfield 1 8050 Varchar2 20 80 131 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE1
Freight Charges Flexfield 2 8050 Varchar2 30 80 211 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE2
Freight Charges Flexfield 3 8050 Varchar2 40 80 291 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE3
Freight Charges Flexfield 4 8050 Varchar2 50 80 371 A1 FH1 SO_FREIGHT_CHARGES ATTRIBUTE4
RECORD 8060 (DSNO)
Common Key (Positions 1-91) 8060 Varchar2 91 1
Record Number 8060 Varchar2 4 92 Constant '8060'
Record Layout 8060 Varchar2 2 96 Constant 'A2'
Record Qualifier 8060 Varchar2 3 98 Constant 'FH2'
Freight Charges Flexfield 5 8060 Varchar2 10 80 101 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE5
Freight Charges Flexfield 6 8060 Varchar2 20 80 181 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE6
Freight Charges Flexfield 7 8060 Varchar2 30 80 261 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE7
Freight Charges Flexfield 8 8060 Varchar2 40 80 341 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE8
Freight Charges Flexfield 9 8060 Varchar2 50 80 421 A2 FH2 SO_FREIGHT_CHARGES ATTRIBUTE9
RECORD 8070 (DSNO)
Common Key (Positions 1-91) 8070 Varchar2 91 1
Record Number 8070 Varchar2 4 92 Constant '8070'
Record Layout 8070 Varchar2 2 96 Constant 'A2'
Record Qualifier 8070 Varchar2 3 98 Constant FH3'
Freight Charges Flexfield 10 8070 Varchar2 10 80 101 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE10
Freight Charges Flexfield 11 8070 Varchar2 20 80 181 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE11
Freight Charges Flexfield 12 8070 Varchar2 30 80 261 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE12
Freight Charges Flexfield 13 8070 Varchar2 40 80 341 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE13
Freight Charges Flexfield 14 8070 Varchar2 50 80 421 A2 FH3 SO_FREIGHT_CHARGES ATTRIBUTE14
RECORD 8080 (DSNO)
Common Key (Positions 1-91) 8080 Varchar2 91 1
Record Number 8080 Varchar2 4 92 Constant '8080'
Record Layout 8080 Varchar2 2 96 Constant 'A2'
Record Qualifier 8080 Varchar2 3 98 Constant 'FH4'
Freight Charges Flexfield 15 8080 Varchar2 10 80 101 A2 FH4 SO_FREIGHT_CHARGES ATTRIBUTE15
RECORD 9000 (DSNO)
Common Key (Positions 1-91) 9000 Varchar2 91 1
Record Number 9000 Varchar2 4 92 Constant '9000'
Record Layout 9000 Varchar2 2 96 Constant 'LS'
Record Qualifier 9000 Varchar2 3 98 Constant 'DET'
Customer Requested Lot Flag 9000 Varchar2 10 1 101 LS DET SO_PICKING_LINE_DETAILS CUSTOMER_REQUESTED_LOT_FLAG
Revision 9000 Varchar2 20 3 102 LS DET SO_PICKING_LINE_DETAILS REVISION
Lot Number 9000 Varchar2 30 30 105 LS DET SO_PICKING_LINE_DETAILS LOT_NUMBER
Serial Number 9000 Varchar2 40 30 135 LS DET SO_PICKING_LINE_DETAILS SERIAL_NUMBER
Shipped Quantity 9000 Number 50 22 165 LS DET SO_PICKING_LINE_DETAILS SHIPPED_QUANTITY
Pick Slip Number 9000 Number 60 22 187 LS DET SO_PICKING_LINE_DETAILS PICK_SLIP_NUMBER
RECORD 9010 (DSNO)
Common Key (Positions 1-91) 9010 Varchar2 91 1
Record Number 9010 Varchar2 4 92 Constant '9010'
Record Layout 9010 Varchar2 2 96 Constant 'A1'
Record Qualifier 9010 Varchar2 3 98 Constant 'PD1'
Picking Line Detail Flexfield Context 9010 Varchar2 10 30 101 A1 PD1 SO_PICKING_LINE_DETAILS CONTEXT
Picking line Detail Flexfield 1 9010 Varchar2 20 80 131 A1 PD1 SO_PICKING_LINE_DETAILS ATTRIBUTE1
Picking line Detail Flexfield 2 9010 Varchar2 30 80 211 A1 PD1 SO_PICKING_LINE_DETAILS ATTRIBUTE2
Picking line Detail Flexfield 3 9010 Varchar2 40 80 291 A1 PD1 SO_PICKING_LINE_DETAILS ATTRIBUTE3
Picking line Detail Flexfield 4 9010 Varchar2 50 80 371 A1 PD1 SO_PICKING_LINE_DETAILS ATTRIBUTE4
RECORD 9020 (DSNO)
Common Key (Positions 1-91) 9020 Varchar2 91 1
Record Number 9020 Varchar2 4 92 Constant '9020'
Record Layout 9020 Varchar2 2 96 Constant 'A2'
Record Qualifier 9020 Varchar2 3 98 Constant 'PD2'
Picking line Detail Flexfield 5 9020 Varchar2 10 80 101 A2 PD2 SO_PICKING_LINE_DETAILS ATTRIBUTE5
Picking line Detail Flexfield 6 9020 Varchar2 20 80 181 A2 PD2 SO_PICKING_LINE_DETAILS ATTRIBUTE6
Picking line Detail Flexfield 7 9020 Varchar2 30 80 261 A2 PD2 SO_PICKING_LINE_DETAILS ATTRIBUTE7
Picking line Detail Flexfield 8 9020 Varchar2 40 80 341 A2 PD2 SO_PICKING_LINE_DETAILS ATTRIBUTE8
Picking line Detail Flexfield 9 9020 Varchar2 50 80 421 A2 PD2 SO_PICKING_LINE_DETAILS ATTRIBUTE9
RECORD 9030 (DSNO)
Common Key (Positions 1-91) 9030 Varchar2 91 1
Record Number 9030 Varchar2 4 92 Constant '9030'
Record Layout 9030 Varchar2 2 96 Constant 'A2'
Record Qualifier 9030 Varchar2 3 98 Constant 'PD3'
Picking line Detail Flexfield 10 9030 Varchar2 10 80 101 A2 PD3 SO_PICKING_LINE_DETAILS ATTRIBUTE10
Picking line Detail Flexfield 11 9030 Varchar2 20 80 181 A2 PD3 SO_PICKING_LINE_DETAILS ATTRIBUTE11
Picking line Detail Flexfield 12 9030 Varchar2 30 80 261 A2 PD3 SO_PICKING_LINE_DETAILS ATTRIBUTE12
Picking line Detail Flexfield 13 9030 Varchar2 40 80 341 A2 PD3 SO_PICKING_LINE_DETAILS ATTRIBUTE13
Picking line Detail Flexfield 14 9030 Varchar2 50 80 421 A2 PD3 SO_PICKING_LINE_DETAILS ATTRIBUTE14
RECORD 9040 (DSNO)
Common Key (Positions 1-91) 9040 Varchar2 91 1
Record Number 9040 Varchar2 4 92 Constant '9040'
Record Layout 9040 Varchar2 2 96 Constant 'A2'
Record Qualifier 9040 Varchar2 3 98 Constant 'PD4'
Picking line Detail Flexfield 15 9040 Varchar2 10 80 101 A2 PD4 SO_PICKING_LINE_DETAILS ATTRIBUTE15
| Previous | Next | Contents | Index | Navigation | Glossary | Library |