|
|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Navigation | Glossary | Library |
This section is best viewed when printed in landscape orientation.
See: Data File Definition Format Legend for a description of the columns making up the data file definition table.
Category
Field Description Rec Format Pos Width Start Application Table Application Column
RECORD 0010 (ASNI/SBNI)
Common Key (Positions 1-91) 0010 Varchar2 91 1
Record Number 0010 Varchar2 4 92 Constant '0010'
Record Layout 0010 Varchar2 2 96 Constant 'CT'
Record Layout Qualifier 0010 Varchar2 3 98 Constant 'CTL'
Communication Method 0010 Varchar2 10 2 101 CT CTL
Test Indicator 0010 Varchar2 20 1 103 CT CTL
Document ID 0010 Varchar2 30 6 104 CT CTL
Document Type 0010 Varchar2 40 5 110 CT CTL
Document Purpose Code (Internal) 0010 Varchar2 50 2 115 CT CTL
Document Code 0010 Varchar2 60 35 117 CT CTL
Trading Partner Translator Code 0010 Varchar2 70 30 152 CT CTL
Trading Partner Location Code 0010 Varchar2 80 35 182 CT CTL
Trading Partner Description 0010 Varchar2 90 74 217 CT CTL
Trading Partner Reference 1 0010 Varchar2 100 80 291 CT CTL
Trading Partner Reference 2 0010 Varchar2 110 80 371 CT CTL
Transaction Date/Time 0010 Date 120 15 451 CT CTL
Transaction Run ID 0010 Number 130 15 466 CT CTL
Control Number 1 0010 Varchar2 140 10 481 CT CTL
Control Number 2 0010 Varchar2 150 10 491 CT CTL
Control Number 3 0010 Varchar2 160 10 501 CT CTL
RECORD 1000 (ASNI/SBNI)
Common Key (Positions 1-91) 1000 Varchar2 91 1
Record Number 1000 Varchar2 4 92 Constant '1000'
Record Layout 1000 Varchar2 2 96 Constant 'L1'
Record Layout Qualifier 1000 Varchar2 3 98 Constant 'DL1'
Shipment Number 1000 Varchar2 10 30 101 L1 DL1 RCV_SHIPMENT_HEADERSPICK_SLIP_NUMBER
Notice Creation Date 1000 Date 20 15 131 L1 DL1 RCV_SHIPMENT_HEADERSNOTICE_CREATION_DATE
Bill of Lading 1000 Varchar2 30 25 146 L1 DL1 RCV_SHIPMENT_HEADERSBILL_OF_LADING_NUMBER
Waybill number 1000 Varchar2 40 15 171 L1 DL1 RCV_SHIPMENT_HEADERSWAY_BILL_NUMBER
Carrier Reference (PRO/Invoice) 1000 Varchar2 50 30 186 L1 DL1 RCV_SHIPMENT_HEADERSFREIGHT_BILL_NUMBER
Pack Slip Number 1000 Varchar2 60 25 216 L1 DL1 RCV_SHIPMENT_HEADERSPACK_SLIP_NUMBER
Shipped Date 1000 Date 70 25 241 L1 DL1 RCV_SHIPMENT_HEADERSSHIPPED_DATE
Expected Arrival Date 1000 Date 80 15 266 L1 DL1 RCV_SHIPMENT_HEADERSEXPECTED_ARRIVAL_DATE
Number of Containers 1000 Number 90 22 281 L1 DL1 RCV_SHIPMENT_HEADERSNUMBER_OF_PACKAGES
Document Purpose Code (Application) 1000 Varchar2 120 25 303 L1 DL1
RECORD 1010 (ASNI/SBNI)
Common Key (Positions 1-91) 1010 Varchar2 91 1
Record Number 1010 Varchar2 4 92 Constant '1010'
Record Layout 1010 Varchar2 2 96 Constant 'L2'
Record Layout Qualifier 1010 Varchar2 3 98 Constant 'DL2'
Equipment Number 1010 Varchar2 10 10 101 L2 DL2 RCV_SHIPMENT_HEADERSEQUIPMENT_NUMBER
Carrier (Internal) SHIP_VIA 1010 Varchar2 20 25 111 L2 DL2 RCV_SHIPMENT_HEADERSSHIPPING_METHOD_CODE
Carrier 1010 Varchar2 30 10 136 L2 DL2
Mode of Transportation (Internal) 1010 Varchar2 40 2 146 L2 DL2 RCV_SHIPMENT_HEADERSMODE_OF_TRANSPORTATION
Mode of Transportation 1010 Varchar2 50 10 148 L2 DL2
Total Gross Weight 1010 Number 60 22 158 L2 DL2 RCV_SHIPMENT_HEADERSTOTAL_GROSS_WEIGHT
Weight Gross UOM (Internal) UOM 1010 Varchar2 70 3 180 L2 DL2 RCV_SHIPMENT_HEADERSGROSS_WEIGHT_UOM_INT
Weight Gross UOM (Ext1) 1010 Varchar2 80 3 183 L2 DL2
Total Net Weight 1010 Number 90 22 186 L2 DL2 RCV_SHIPMENT_HEADERSTOTAL_NET_WEIGHT
Weight Net UOM (Internal) UOM 1010 Varchar2 100 3 208 L2 DL2 RCV_SHIPMENT_HEADERSNET_WEIGHT_UOM_INT
Weight Net UOM (Ext1) 1010 Varchar2 110 3 211 L2 DL2
Total Tare Weight 1010 Number 120 22 214 L2 DL2 RCV_SHIPMENT_HEADERSTOTAL_TARE_WEIGHT
Weight Tare UOM (Internal) UOM 1010 Varchar2 130 3 236 L2 DL2 RCV_SHIPMENT_HEADERSTARE_WEIGHT_UOM_INT
Weight Tare UOM (Ext1) 1010 Varchar2 140 3 239 L2 DL2
Packaging Code (Internal) 1010 Varchar2 150 5 242 L2 DL2 RCV_SHIPMENT_HEADERSPACKAGING_CODE
Packaging Code (Ext 1) 1010 Varchar2 160 5 247 L2 DL2
Packaging Code (Ext 2) 1010 Varchar2 170 5 252 L2 DL2
RECORD 1020 (ASNI/SBNI)
Common Key (Positions 1-91) 1020 Varchar2 91 1
Record Number 1020 Varchar2 4 92 Constant '1020'
Record Layout 1020 Varchar2 2 96 Constant 'L3'
Record Layout Qualifier 1020 Varchar2 3 98 Constant 'DL3'
Shipment Method of Payment (Internal) 1020 Varchar2 10 5 101 L3 DL3 RCV_SHIPMENT_HEADERSSHIPMENT_METHOD_OF_PAYMENT_INT
Shipment Method of Payment (Ext 1) 1020 Varchar2 20 5 106 L3 DL3
RECORD 1030 (ASNI/SBNI)
Common Key (Positions 1-91) 1030 Varchar2 91 1
Record Number 1030 Varchar2 4 92 Constant '1030'
Record Layout 1030 Varchar2 2 96 Constant 'L4'
Record Layout Qualifier 1030 Varchar2 3 98 Constant 'DL4'
Invoice Number 1030 Varchar2 10 30 101 L4 DL4 RCV_SHIPMENT_HEADERSINVOICE_NUM
Invoice Date 1030 Date 20 15 131 L4 DL4 RCV_SHIPMENT_HEADERSINVOICE_DATE
Invoice Amount 1030 Number 30 22 146 L4 DL4 RCV_SHIPMENT_HEADERSINVOICE_AMOUNT
Currency Code (Internal) CURRENCY 1030 Varchar2 40 15 168 L4 DL4 RCV_SHIPMENT_HEADERSCURRENCY_CODE_INT
Currency Code (Ext 1) 1030 Varchar2 50 15 183 L4 DL4 RCV_SHIPMENT_HEADERSCURRENCY_CODE_EXT1
Currency Exchange Rate 1030 Number 60 22 198 L4 DL4 RCV_SHIPMENT_HEADERSCONVERSION_RATE
Currency Rate Date 1030 Date 70 15 220 L4 DL4 RCV_SHIPMENT_HEADERSCONVERSION_DATE
Tax Exempt Number 1030 Varchar2 80 15 235 L4 DL4 RCV_SHIPMENT_HEADERSTAX_EXEMPT_NUM
Tax Amount 1030 Number 90 22 250 L4 DL4 RCV_SHIPMENT_HEADERSTAX_AMOUNT
Payment Terms (Internal) PAYMENT_TERMS1030 Varchar2 100 50 272 L4 DL4 RCV_SHIPMENT_HEADERSPAYMENT_TERMS_INT
Payment Terms (ext 1) 1030 Varchar2 110 20 322 L4 DL4
Payment Terms (ext 2) 1030 Varchar2 120 10 342 L4 DL4
Payment Terms (ext 3) 1030 Varchar2 130 10 352 L4 DL4
Payment Terms (ext 4) 1030 Varchar2 140 10 362 L4 DL4
Payment Terms (ext 5) 1030 Varchar2 150 10 372 L4 DL4
RECORD 1040 (ASNI/SBNI)
Common Key (Positions 1-91) 1040 Varchar2 91 1
Record Number 1040 Varchar2 4 92 Constant '1040'
Record Layout 1040 Varchar2 2 96 Constant 'L5'
Record Layout Qualifier 1040 Varchar2 3 98 Constant 'DL5'
Allowance/Charge Amount (Freight) 1040 Number 10 22 101 l5 DL5 RCV_SHIPMENT_HEADERSFREIGHT_AMOUNT
USS GL Transaction Code 1040 Varchar2 20 30 123 l5 DL5 RCV_SHIPMENT_LINES USGGL_TRANSACTION_CODE
RECORD 1050 (ASNI/SBNI)
Common Key (Positions 1-91) 1050 Varchar2 91 1
Record Number 1050 Varchar2 4 92 Constant '1050'
Record Layout 1050 Varchar2 2 96 Constant 'HZ'
Record Layout Qualifier 1050 Varchar2 3 98 Constant 'HZ1'
Special Handling Code (Internal) 1050 Varchar2 10 3 101 HZ HZ1 RCV_SHIPMENT_LINES SPECIAL_HANDLING_INT
Special Handling Code (Ext 1) 1050 Varchar2 20 3 104 HZ HZ1 RCV_SHIPMENT_LINES SPECIAL_HANDLING_EXT1
Hazardous Material Code (Internal) 1050 Varchar2 30 1 107 HZ HZ1 RCV_SHIPMENT_LINES HAZARD_CODE_INT
Hazardous Material Code (Ext 1) 1050 Varchar2 40 1 108 HZ HZ1 RCV_SHIPMENT_LINES HAZARD_CODE_EXT1
Hazardous Material Class (Internal) 1050 Varchar2 50 4 109 HZ HZ1 RCV_SHIPMENT_LINES HAZARD_CLASS_INT
Hazardous Material Class (Ext 1) 1050 Varchar2 60 4 113 HZ HZ1 RCV_SHIPMENT_LINES HAZARD_CLASS_EXT1
Hazard Class Description 1050 Varchar2 70 80 117 HZ HZ1 RCV_SHIPMENT_LINES HAZARD_DESCRIPTION
RECORD 1090 (ASNI/SBNI)
Common Key (Positions 1-91) 1090 Varchar2 91 1
Record Number 1090 Varchar2 4 92 Constant '1090'
Record Layout 1090 Varchar2 2 96 Constant 'NT'
Record Layout Qualifier 1090 Varchar2 3 98 Constant 'NH1'
Notes/Comments (Header level) 1090 Varchar2 10 240 101 NT NH1 RCV_SHIPMENT_HEADERSCOMMENTS
RECORD 1100 (ASNI/SBNI)
Common Key (Positions 1-91) 1100 Varchar2 91 1
Record Number 1100 Varchar2 4 92 Constant '1100'
Record Layout 1100 Varchar2 2 96 Constant 'AI'
Record Layout Qualifier 1100 Varchar2 3 98 Constant 'SU'
Vendor Site Code (Internal) 1100 Varchar2 10 20 101 AI SU PO_VENDOR_SITES VENDOR_SITE_CODE
Vendor Site Code (External) 1100 Varchar2 20 20 121 AI SU
Vendor Name 1100 Varchar2 30 60 141 AI SU
Vendor Address Line 1 1100 Varchar2 40 35 201 AI SU
Vendor Address Line 2 1100 Varchar2 50 35 236 AI SU
Vendor Address Line 3 1100 Varchar2 60 35 271 AI SU
Vendor Address Line 4 1100 Varchar2 70 35 306 AI SU
Vendor City 1100 Varchar2 80 30 341 AI SU
Vendor Postal Code 1100 Varchar2 90 15 371 AI SU
Vendor Country (Internal) COUNTRY 1100 Varchar2 100 20 386 AI SU
Vendor Country (Ext1) 1100 Varchar2 110 3 406 AI SU
Vendor State (Internal) STATE 1100 Varchar2 120 20 409 AI SU
Vendor State (Ext 1) 1100 Varchar2 130 10 429 AI SU
Vendor Province (Internal) PROVINCE 1100 Varchar2 140 20 439 AI SU
Vendor Province (Ext1) 1100 Varchar2 150 25 459 AI SU
RECORD 1120 (ASNI/SBNI)
Common Key (Positions 1-91) 1120 Varchar2 91 1
Record Number 1120 Varchar2 4 92 Constant '1120'
Record Layout 1120 Varchar2 2 96 Constant 'AX'
Record Layout Qualifier 1120 Varchar2 3 98 Constant 'ST'
Destination Code (Internal) SHIP_TO_SITE 1120 Varchar2 10 20 101 AX ST
Destination Code (Ext 1) 1120 Varchar2 20 20 121 AX ST
Destination Name 1120 Varchar2 30 60 141 AX ST
Destination Address Line 1 1120 Varchar2 40 35 201 AX ST
Destination Address Line 2 1120 Varchar2 50 35 236 AX ST
Destination Address Line 3 1120 Varchar2 60 35 271 AX ST
Destination City 1120 Varchar2 70 30 306 AX ST
Destination Postal Code 1120 Varchar2 80 15 336 AX ST
Destination Country (Internal) COUNTRY 1120 Varchar2 90 20 351 AX ST
Destination Country (Ext 1) 1120 Varchar2 100 3 371 AX ST
Destination Region 1(Internal) REGION1 1120 Varchar2 110 25 374 AX ST
Destination Region 1 (Ext 1) 1120 Varchar2 120 10 399 AX ST
Destination Region 2 (Internal) REGION2 1120 Varchar2 130 25 409 AX ST
Destination Region 2 (Ext 1) 1120 Varchar2 140 10 434 AX ST
Destination Region 3 (Internal) REGION3 1120 Varchar2 150 25 444 AX ST
Destination Region 3 (Ext 1) 1120 Varchar2 160 10 469 AX ST
RECORD 1130 (ASNI/SBNI)
Common Key (Positions 1-91) 1130 Varchar2 91 1
Record Number 1130 Varchar2 4 92 Constant '1130'
Record Layout 1130 Varchar2 2 96 Constant 'CN'
Record Layout Qualifier 1130 Varchar2 3 98 Constant 'ST'
Destination Contact Last Name 1130 Varchar2 10 35 101 CN ST RCV_SHIPMENT_HEADERSDELIVER_TO_PERSON_NAME
Destination Contact First Name 1130 Varchar2 20 35 136 CN ST RCV_SHIPMENT_HEADERS
Destination Contact Job Title 1130 Varchar2 30 40 171 CN ST RCV_SHIPMENT_HEADERS
RECORD 1200 (ASNI/SBNI)
Common Key (Positions 1-91) 1200 Varchar2 91 1
Record Number 1200 Varchar2 4 92 Constant '1200'
Record Layout 1200 Varchar2 2 96 Constant 'A1'
Record Layout Qualifier 1200 Varchar2 3 98 Constant 'SH1'
Shipment Header Flexfield Context 1200 Varchar2 10 30 101 A1 SH1 RCV_SHIPMENT_HEADERSCONTEXT
Shipment Header Flexfield 1 1200 Varchar2 20 80 131 A1 SH1 RCV_SHIPMENT_HEADERSATTRIBUTE1
Shipment Header Flexfield 2 1200 Varchar2 30 80 211 A1 SH1 RCV_SHIPMENT_HEADERSATTRIBUTE2
Shipment Header Flexfield 3 1200 Varchar2 40 80 291 A1 SH1 RCV_SHIPMENT_HEADERSATTRIBUTE3
Shipment Header Flexfield 4 1200 Varchar2 50 80 371 A1 SH1 RCV_SHIPMENT_HEADERSATTRIBUTE4
RECORD 1210 (ASNI/SBNI)
Common Key (Positions 1-91) 1210 Varchar2 91 1
Record Number 1210 Varchar2 4 92 Constant '1210'
Record Layout 1210 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 1210 Varchar2 3 98 Constant 'SH2'
Shipment Header Flexfield 5 1210 Varchar2 10 80 101 A2 SH2 RCV_SHIPMENT_HEADERSATTRIBUTE5
Shipment Header Flexfield 6 1210 Varchar2 20 80 181 A2 SH2 RCV_SHIPMENT_HEADERSATTRIBUTE6
Shipment Header Flexfield 7 1210 Varchar2 30 80 261 A2 SH2 RCV_SHIPMENT_HEADERSATTRIBUTE7
Shipment Header Flexfield 8 1210 Varchar2 40 80 341 A2 SH2 RCV_SHIPMENT_HEADERSATTRIBUTE8
Shipment Header Flexfield 9 1210 Varchar2 50 80 421 A2 SH2 RCV_SHIPMENT_HEADERSATTRIBUTE9
RECORD 1230 (ASNI/SBNI)
Common Key (Positions 1-91) 1220 Varchar2 91 1
Record Number 1220 Varchar2 4 92 Constant '1220'
Record Layout 1220 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 1220 Varchar2 3 98 Constant 'SH3'
Shipment Header Flexfield 10 1220 Varchar2 10 80 101 A2 SH3 RCV_SHIPMENT_HEADERSATTRIBUTE10
Shipment Header Flexfield 11 1220 Varchar2 20 80 181 A2 SH3 RCV_SHIPMENT_HEADERSATTRIBUTE11
Shipment Header Flexfield 12 1220 Varchar2 30 80 261 A2 SH3 RCV_SHIPMENT_HEADERSATTRIBUTE12
Shipment Header Flexfield 13 1220 Varchar2 40 80 341 A2 SH3 RCV_SHIPMENT_HEADERSATTRIBUTE13
Shipment Header Flexfield 14 1220 Varchar2 50 80 421 A2 SH3 RCV_SHIPMENT_HEADERSATTRIBUTE14
RECORD 1230 (ASNI/SBNI)
Common Key (Positions 1-91) 1230 Varchar2 91 1
Record Number 1230 Varchar2 4 92 Constant '1230'
Record Layout 1230 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 1230 Varchar2 3 98 Constant 'SH4'
Shipment Header Flexfield 15 1230 Varchar2 10 80 101 A2 SH4 RCV_SHIPMENT_HEADERSATTRIBUTE15
RECORD 2000 (ASNI/SBNI)
Common Key (Positions 1-91) 2000 Varchar2 91 1
Record Number 2000 Varchar2 4 92 Constant '2000'
Record Layout 2000 Varchar2 2 96 Constant 'L1'
Record Layout Qualifier 2000 Varchar2 3 98 Constant 'IT1'
Buyer Part Number ITEM 2000 Varchar2 10 30 101 L1 IT1 RCV_SHIPMENT_LINES ITEM_NUMBER
Vendor Part Number 2000 Varchar2 20 25 131 L1 IT1 RCV_SHIPMENT_LINES VENDOR_ITEM_NUM
Buyer Revision Part Number 2000 Varchar2 30 3 156 L1 IT1 RCV_SHIPMENT_LINES ITEM_REVISION
Substitute Part Number 2000 Varchar2 40 30 159 L1 IT1 RCV_SHIPMENT_LINES SUBSTITUE_ITEM_NUM
Purchase Order Number 2000 Varchar2 50 22 189 L1 IT1 RCV_SHIPMENT_LINES PURCHASE_ORDER_NUM
Purchase Order Release Number 2000 Number 60 30 211 L1 IT1 RCV_SHIPMENT_LINES PURCHASE_ORDER_RELEASE_NUM
Purchase Order Line Number 2000 Number 70 11 241 L1 IT1 RCV_SHIPMENT_LINES ORIGINAL_SYSTEM_LINE_REFERENCE
Shipped Quantity 2000 Number 80 22 252 L1 IT1 RCV_SHIPMENT_LINES SHIPPED_QUANTITY
Shipment Line Unit of Measure (Internal) UOM 2000 Varchar2 90 5 274 L1 IT1 RCV_SHIPMENT_LINES UNIT_CODE_INT
Shipment Line Unit of Measure (Ext1) 2000 Number 100 3 279 L1 IT1
Vendor Cum Shipped Quantity 2000 Number 110 22 282 L1 IT1 RCV_SHIPMENT_LINES VENDOR_CUM_SHIPPED_QTY
Return Authorization 2000 Varchar2 120 30 304 L1 IT1 RCV_SHIPMENT_LINES RETURN_AUTHORIZATION
Item Bill of Lading 2000 Varchar2 130 25 334 L1 IT1 RCV_SHIPMENT_LINES BILL_OF_LADING
Product Description 2000 Varchar2 140 80 334 L1 IT1 RCV_SHIPMENT_LINES ITEM_DESCRIPTION
PO Line Shipment Number 2000 Number 150 22 359 L1 IT1 RCV_SHIPMENT_LINES
RECORD 2010 (ASNI/SBNI)
Common Key (Positions 1-91) 2010 Varchar2 91 1
Record Number 2010 Varchar2 4 92 Constant '2010'
Record Layout 2010 Varchar2 2 96 Constant 'L2'
Record Layout Qualifier 2010 Varchar2 3 98 Constant 'IT2'
Invoiced Quantity 2010 Number 10 22 101 L2 IT2 RCV_SHIPMENT_LINES QUANTITY_INVOICED
Selling Price 2010 Number 20 22 123 L2 IT2 RCV_SHIPMENT_LINES SELLING_PRICE
Carrier Number 2010 Varchar2 30 35 145 L2 IT2 RCV_SHIPMENT_LINES TRUCK_NUM
Container Number 2010 Varchar2 40 35 180 L2 IT2 RCV_SHIPMENT_LINES CONTAINER_NUM
Bar Code Label 2010 Varchar2 50 35 215 L2 IT2 RCV_SHIPMENT_LINES BARCODE_LABEL
Lot Number 2010 Varchar2 60 30 250 L2 IT2 RCV_SHIPMENT_LINES LOT_NUMBER
USS GL Transaction Code 2010 Varchar2 70 30 280 L2 IT2 RCV_SHIPMENT_LINES USGGL_TRANSACTION_CODE
RECORD 2020 (ASNI/SBNI)
Common Key (Positions 1-91) 2020 Varchar2 91 1
Record Number 2020 Varchar2 4 92 Constant '2020'
Record Layout 2020 Varchar2 2 96 Constant 'L3'
Record Layout Qualifier 2020 Varchar2 3 98 Constant 'IT3'
Currency Code (Internal) 2020 Varchar2 10 15 101 L3 IT3 RCV_SHIPMENT_LINES CURRENCY_CODE_INT
Currency Code (Ext 1) 2020 Varchar2 20 5 116 L3 IT3
Currency Exchange Rate 2020 Number 30 22 121 L3 IT3 RCV_SHIPMENT_LINES CONVERSION_RATE
Currency Rate Date 2020 Date 40 15 143 L3 IT3 RCV_SHIPMENT_LINES CONVERSION_DATE
Item Tax Amount 2020 Number 50 15 158 L3 IT3 RCV_SHIPMENT_LINES TAX_AMOUNT
Item Tax Name (Internal) TAX_NAME 2020 Varchar2 60 15 173 L3 IT3 RCV_SHIPMENT_LINES TAX_NAME
Item Tax Name (Ext 1) 2020 Varchar2 70 15 188 L3 IT3
RECORD 2030 (ASNI/SBNI)
Common Key (Positions 1-91) 2030 Varchar2 91 1
Record Number 2030 Varchar2 4 92 Constant '2030'
Record Layout 2030 Varchar2 2 96 Constant 'NT'
Record Layout Qualifier 2030 Varchar2 3 98 Constant 'ND1'
Notes 2030 Varchar2 10 240 101 NT ND1 RCV_SHIPMENT_LINES SHIPPING_INSTRUCTIONS
RECORD 2100 (ASNI/SBNI)
Common Key (Positions 1-91) 2100 Varchar2 91 1
Record Number 2100 Varchar2 4 92 Constant '2100'
Record Layout 2100 Varchar2 2 96 Constant 'A1'
Record Layout Qualifier 2100 Varchar2 3 98 Constant 'SL1'
Shipment Line Flexfield Context 2100 Varchar2 10 30 101 A1 SL1 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTECATEGORY
Shipment Line Flexfield 1 2100 Varchar2 20 80 131 A1 SL1 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE1
Shipment Line Flexfield 2 2100 Varchar2 30 80 211 A1 SL1 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE2
Shipment Line Flexfield 3 2100 Varchar2 40 80 291 A1 SL1 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE3
Shipment Line Flexfield 4 2100 Varchar2 50 80 371 A1 SL1 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE4
RECORD 2110 (ASNI/SBNI)
Common Key (Positions 1-91) 2110 Varchar2 91 1
Record Number 2110 Varchar2 4 92 Constant '2110'
Record Layout 2110 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2110 Varchar2 3 98 Constant 'SL2'
Shipment Line Flexfield 5 2110 Varchar2 10 80 101 A2 SL2 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE5
Shipment Line Flexfield 6 2110 Varchar2 20 80 181 A2 SL2 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE6
Shipment Line Flexfield 7 2110 Varchar2 30 80 261 A2 SL2 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE7
Shipment Line Flexfield 8 2110 Varchar2 40 80 341 A2 SL2 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE8
Shipment Line Flexfield 9 2110 Varchar2 50 80 421 A2 SL2 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE9
RECORD 2120 (ASNI/SBNI)
Common Key (Positions 1-91) 2120 Varchar2 91 1
Record Number 2120 Varchar2 4 92 Constant '2120'
Record Layout 2120 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2120 Varchar2 3 98 Constant 'SL3'
Shipment Line Flexfield 10 2120 Varchar2 10 80 101 A2 SL3 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE10
Shipment Line Flexfield 11 2120 Varchar2 20 80 181 A2 SL3 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE11
Shipment Line Flexfield 12 2120 Varchar2 30 80 261 A2 SL3 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE12
Shipment Line Flexfield 13 2120 Varchar2 40 80 341 A2 SL3 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE13
Shipment Line Flexfield 14 2120 Varchar2 50 80 421 A2 SL3 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE14
RECORD 2130 (ASNI/SBNI)
Common Key (Positions 1-91) 2130 Varchar2 91 1
Record Number 2130 Varchar2 4 92 Constant '2130'
Record Layout 2130 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2130 Varchar2 3 98 Constant 'SL4'
Shipment Line Flexfield 15 2130 Varchar2 10 80 101 A2 SL4 RCV_SHIPMENT_LINES SHIP_LINE_ATTRIBUTE15
RECORD 2140 (ASNI/SBNI)
Common Key (Positions 1-91) 2140 Varchar2 91 1
Record Number 2140 Varchar2 4 92 Constant '2140'
Record Layout 2140 Varchar2 2 96 Constant 'A1'
Record Layout Qualifier 2140 Varchar2 3 98 Constant 'RC1'
Transaction Flexfield Context 2140 Varchar2 10 30 101 A1 RC1 RCV_SHIPMENT_LINES CONTEXT
Transaction Flexfield 1 2140 Varchar2 20 80 131 A1 RC1 RCV_SHIPMENT_LINES ATTRIBUTE1
Transaction Flexfield 2 2140 Varchar2 30 80 211 A1 RC1 RCV_SHIPMENT_LINES ATTRIBUTE2
Transaction Flexfield 3 2140 Varchar2 40 80 291 A1 RC1 RCV_SHIPMENT_LINES ATTRIBUTE3
Transaction Flexfield 4 2140 Varchar2 50 80 371 A1 RC1 RCV_SHIPMENT_LINES ATTRIBUTE4
RECORD 2150 (ASNI/SBNI)
Common Key (Positions 1-91) 2150 Varchar2 91 1
Record Number 2150 Varchar2 4 92 Constant '2150'
Record Layout 2150 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2150 Varchar2 3 98 Constant 'RC2'
Transaction Flexfield 5 2150 Varchar2 10 80 101 A2 RC2 RCV_SHIPMENT_LINES ATTRIBUTE5
Transaction Flexfield 6 2150 Varchar2 20 80 181 A2 RC2 RCV_SHIPMENT_LINES ATTRIBUTE6
Transaction Flexfield 7 2150 Varchar2 30 80 261 A2 RC2 RCV_SHIPMENT_LINES ATTRIBUTE7
Transaction Flexfield 8 2150 Varchar2 40 80 341 A2 RC2 RCV_SHIPMENT_LINES ATTRIBUTE8
Transaction Flexfield 9 2150 Varchar2 50 80 421 A2 RC2 RCV_SHIPMENT_LINES ATTRIBUTE9
RECORD 2160 (ASNI/SBNI)
Common Key (Positions 1-91) 2160 Varchar2 91 1
Record Number 2160 Varchar2 4 92 Constant '2160'
Record Layout 2160 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2160 Varchar2 3 98 Constant 'RC3'
Transaction Flexfield 10 2160 Varchar2 10 80 101 A2 RC3 RCV_SHIPMENT_LINES ATTRIBUTE10
Transaction Flexfield 11 2160 Varchar2 20 80 181 A2 RC3 RCV_SHIPMENT_LINES ATTRIBUTE11
Transaction Flexfield 12 2160 Varchar2 30 80 261 A2 RC3 RCV_SHIPMENT_LINES ATTRIBUTE12
Transaction Flexfield 13 2160 Varchar2 40 80 341 A2 RC3 RCV_SHIPMENT_LINES ATTRIBUTE13
Transaction Flexfield 14 2160 Varchar2 50 80 421 A2 RC3 RCV_SHIPMENT_LINES ATTRIBUTE14
RECORD 2170 (ASNI/SBNI)
Common Key (Positions 1-91) 2170 Varchar2 91 1
Record Number 2170 Varchar2 4 92 Constant '2170'
Record Layout 2170 Varchar2 2 96 Constant 'A2'
Record Layout Qualifier 2170 Varchar2 3 98 Constant 'RC4'
Transaction Flexfield 15 2170 Varchar2 10 80 101 A2 RC4 RCV_SHIPMENT_LINES ATTRIBUTE15
RECORD 3000 (ASNI/SBNI)
Common Key (Positions 1-91) 3000 Varchar2 91 1
Record Number 3000 Varchar2 4 92 Constant '3000'
Record Layout 3000 Varchar2 2 96 Constant 'AX'
Record Layout Qualifier 3000 Varchar2 3 98 Constant 'ST'
Destination Site Code (Internal) SHIP_TO_SITE 3000 Varchar2 10 20 101 AX ST
Destination Site Code (Ext 1) 3000 Varchar2 20 20 121 AX ST
Destination Name 3000 Varchar2 30 60 141 AX ST
Destination Address Line 1 3000 Varchar2 40 35 201 AX ST
Destination Address Line 2 3000 Varchar2 50 35 236 AX ST
Destination Address Line 3 3000 Varchar2 60 35 271 AX ST
Destination City 3000 Varchar2 70 30 306 AX ST
Destination Postal Code 3000 Varchar2 80 15 336 AX ST
Destination Country (Internal) 3000 Varchar2 90 20 351 AX ST
Destination Country (External) 3000 Varchar2 100 3 371 AX ST
Destination Region 1(Internal) 3000 Varchar2 110 25 374 AX ST
Destination Region 1 (Ext 1) 3000 Varchar2 120 10 399 AX ST
Destination Region 2 (Internal) 3000 Varchar2 130 25 409 AX ST
Destination Region 2 (Ext 2) 3000 Varchar2 140 10 434 AX ST
Destination Region 3 (Internal) 3000 Varchar2 150 25 444 AX ST
Destination Region 3 (Ext 2) 3000 Varchar2 160 10 469 AX ST
RECORD 3020 (ASNI/SBNI)
Common Key (Positions 1-91) 3020 Varchar2 91 1
Record Number 3020 Varchar2 4 92 Constant '3020'
Record Layout 3020 Varchar2 2 96 Constant 'CO'
Record Layout Qualifier 3020 Varchar2 3 98 Constant 'ST'
Deliver to Location Code (Internal) 3020 Varchar2 10 10 101 CO ST RCV_SHIPMENT_LINES DELIVER_TO_LOCATION_CODE_INT
Deliver to Location Code (Ext 1) 3020 Varchar2 20 10 111 CO ST ECE_XREF_DATA XREF_EXT_VALUE1
Deliver to Location Code (Ext 2) 3020 Varchar2 30 10 121 CO ST ECE_XREF_DATA XREF_EXT_VALUE2
Deliver to Location Code (Ext 3) 3020 Varchar2 40 10 131 CO ST ECE_XREF_DATA XREF_EXT_VALUE3
Deliver to Location Code (Ext 4) 3020 Varchar2 50 10 141 CO ST ECE_XREF_DATA XREF_EXT_VALUE4
Deliver to Location Code (Ext 5) 3020 Varchar2 60 10 151 CO ST ECE_XREF_DATA XREF_EXT_VALUE5
Delivery to Person name 3020 Varchar2 70 10 161 CO ST RCV_SHIPMENT_LINES DELIVER_TO_PERSON_NAME
| Previous | Next | Contents | Index | Navigation | Glossary | Library |