Previous | Next | Contents | Index | Navigation | Glossary | Library |
Attention: 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.
Description Category Rec Format PosWidth RecQualApplication Table Application Column RECORD 0010 (SPSO) Common Key (Positions 1-91) 0010 Varchar2 91 1 Record Number 0010 Varchar2 4 92 Constant '0010' Record Layout Code 0010 Varchar2 2 96 Constant 'CT' Record Layout Qualifier 0010 Varchar2 3 98 Constant 'CTL' Communication Method 0010 Varchar210 2 101 CT CTL CHV_SCHEDULE_HEADERS COMMUNICATION_CODE Test Indicator 0010 Varchar220 1 103 CT CTL ECE_TP_DETAILS TEST_FLAG Document ID 0010 Varchar230 6 104 CT CTL Document Type 0010 Varchar240 5 110 CT CTL PO_VENDOR_SITES VENDOR_SITE_CODE Document Purpose Code 0010 Varchar250 2 115 CT CTL Document Code 0010 Varchar260 35 117 CT CTL CHV_SCHEDULE_HEADERS SCHEDULE_NUM Trading Partner Translator Code 0010 Varchar270 30 152 CT CTL ECE_TP_DETAILS TP_TRANSLATOR_CODE Trading Partner Location Code 0010 Varchar280 35 182 CT CTL ECE_TP_HEADERS TP_LOCATION_CODE_EXT Trading Partner Description 0010 Varchar290 74 217 CT CTL ECE_TP_HEADERS TP_DESCRIPTION Trading Partner Reference 1 0010 Varchar2100 80 291 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT1 Trading Partner Reference 2 0010 Varchar2110 80 371 CT CTL ECE_TP_HEADERS TP_REFERENCE_EXT2 Transaction Date/Time 0010 Date 120 15 451 CT CTL Transaction Run ID 0010 Number 130 15 466 CT CTL Control 1 0010 Number 140 10 481 CT CTL Control 2 0010 Number 150 10 491 CT CTL Control 3 0010 Number 160 10 501 CT CTL RECORD 0020 (SPSO) Common Key (Positions 1-91) 0020 Varchar2 91 1 Record Number 0020 Varchar2 4 92 Constant '0020' Record Layout Code 0020 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 0020 Varchar2 3 98 Constant 'TH1' Trading Partner Flexfield Context 0020 Varchar210 30 101 A1 TH1 ECE_TP_HEADERS ATTRIBUTE_CATEGORY Trading Partner Flexfield 1 0020 Varchar220 80 131 A1 TH1 ECE_TP_HEADERS ATTRIBUTE1 Trading Partner Flexfield 2 0020 Varchar230 80 211 A1 TH1 ECE_TP_HEADERS ATTRIBUTE2 Trading Partner Flexfield 3 0020 Varchar240 80 291 A1 TH1 ECE_TP_HEADERS ATTRIBUTE3 Trading Partner Flexfield 4 0020 Varchar250 80 371 A1 TH1 ECE_TP_HEADERS ATTRIBUTE4 RECORD 0030 (SPSO) Common Key (Positions 1-91) 0030 Varchar2 91 1 Record Number 0030 Varchar2 4 92 Constant '0030' Record Layout Code 0030 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 0030 Varchar2 3 98 Constant 'TH2' Trading Partner Flexfield 5 0030 Varchar210 80 101 A2 TH2 ECE_TP_HEADERS ATTRIBUTE5 Trading Partner Flexfield 6 0030 Varchar220 80 181 A2 TH2 ECE_TP_HEADERS ATTRIBUTE6 Trading Partner Flexfield 7 0030 Varchar230 80 261 A2 TH2 ECE_TP_HEADERS ATTRIBUTE7 Trading Partner Flexfield 8 0030 Varchar240 80 341 A2 TH2 ECE_TP_HEADERS ATTRIBUTE8 Trading Partner Flexfield 9 0030 Varchar250 80 421 A2 TH2 ECE_TP_HEADERS ATTRIBUTE9 RECORD 0040 (SPSO) Common Key (Positions 1-91) 0040 Varchar2 91 1 Record Number 0040 Varchar2 4 92 Constant '0040' Record Layout Code 0040 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 0040 Varchar2 3 98 Constant 'TH3' Trading Partner Flexfield 10 0040 Varchar210 80 101 A2 TH3 ECE_TP_HEADERS ATTRIBUTE10 Trading Partner Flexfield 11 0040 Varchar220 80 181 A2 TH3 ECE_TP_HEADERS ATTRIBUTE11 Trading Partner Flexfield 12 0040 Varchar230 80 261 A2 TH3 ECE_TP_HEADERS ATTRIBUTE12 Trading Partner Flexfield 13 0040 Varchar240 80 341 A2 TH3 ECE_TP_HEADERS ATTRIBUTE13 Trading Partner Flexfield 14 0040 Varchar250 80 421 A2 TH3 ECE_TP_HEADERS ATTRIBUTE14 RECORD 0050 (SPSO) Common Key (Positions 1-91) 0050 Varchar2 91 1 Record Number 0050 Varchar2 4 92 Constant '0050' Record Layout Code 0050 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 0050 Varchar2 3 98 Constant 'TH4' Trading Partner Flexfield 15 0050 Varchar210 80 101 A2 TH4 ECE_TP_HEADERS ATTRIBUTE15 RECORD 1000 (SPSO) Common Key (Positions 1-91) 1000 Varchar2 91 1 Record Number 1000 Varchar2 4 92 Constant '1000' Record Layout Code 1000 Varchar2 2 96 Constant 'HD' Record Layout Qualifier 1000 Varchar2 3 98 Constant 'FRC' Schedule ID 1000 Number 10 22 101 HD FRC CHV_SCHEDULE_HEADERS SCHEDULE_ID Schedule Revision 1000 Varchar230 30 123 HD FRC CHV_SCHEDULE_HEADERS SCHEDULE_REVISION Schedule Type 1000 Varchar240 25 153 HD FRC CHV_SCHEDULE_HEADERS SCHEDULE_TYPE Schedule Sub-Type 1000 Varchar250 25 178 HD FRC CHV_SCHEDULE_HEADERS SCHEDULE_SUBTYPE Multiple Ship To Organization Flag 1000 Varchar260 1 203 HD FRC Forecast Horizon Start Date 1000 Date 70 15 204 HD FRC CHV_SCHEDULE_HEADERS SCHEDULE_HORIZON_START Forecast Horizon End Date 1000 Date 80 15 219 HD FRC CHV_SCHEDULE_HEADERS SCHEDULE_HORIZON_END Schedule Generation Date 1000 Date 90 15 234 HD FRC CHV_SCHEDULE_HEADERS CREATION_DATE Schedule Status 1000 Varchar2140 25 249 HD FRC CHV_SCHEDULE_HEADERS SCHEDULE_STATUS RECORD1010 (SPSO) Common Key (Positions 1-91) 1010 Varchar2 91 1 Record Number 1010 Varchar2 4 92 Constant '1010' Record Layout Code 1010 Varchar2 2 96 Constant 'SP' Record Layout Qualifier 1010 Varchar2 3 98 Constant 'SU' Supplier Number (Internal) SUPPLIER_NUMBER 1010 Varchar210 30 101 SP SU PO_VENDORS SEGMENT1 Supplier Number (Ext) 1010 Varchar220 30 131 SP SU RECORD 1020 (SPSO) Common Key (Positions 1-91) 1020 Varchar2 91 1 Record Number 1020 Varchar2 4 92 Constant '1020' Record Layout Code 1020 Varchar2 2 96 Constant 'AD' Record Layout Qualifier 1020 Varchar2 3 98 Constant 'SS' Supplier Site Code (internal) SUPPLIER_SITE 1020 Varchar210 20 101 AD SS PO_VENDOR_SITES VENDOR_SITE_CODE Supplier Site Code (Ext) 1020 Varchar220 20 121 AD SS ECE_XREF_DATA XREF_EXT_VALUE1 Supplier Name 1020 Varchar230 60 141 AD SS PO_VENDORS VENDOR_NAME Supplier Site Address Line 1 1020 Varchar240 35 201 AD SS PO_VENDOR_SITES ADDRESS_LINE1 Supplier Site Address Line 2 1020 Varchar250 35 236 AD SS PO_VENDOR_SITES ADDRESS_LINE2 Supplier Site Address Line 3 1020 Varchar260 35 271 AD SS PO_VENDOR_SITES ADDRESS_LINE3 Supplier Site Address Line 4 1020 Varchar270 35 306 AD SS Supplier Site City 1020 Varchar280 30 341 AD SS PO_VENDOR_SITES CITY Supplier Site Postal Code 1020 Varchar290 15 371 AD SS PO_VENDOR_SITES ZIP Supplier Site Country COUNTRY 1020 Varchar2100 20 386 AD SS PO_VENDOR_SITES COUNTRY Supplier Site Country (Ext1) 1020 Varchar2110 3 406 AD SS ECE_XREF_DATA XREF_EXT_VALUE1 Supplier Site State STATE 1020 Varchar2120 20 409 AD SS PO_VENDOR_SITES STATE Supplier Site State (Ext1) 1020 Varchar2130 10 429 AD SS ECE_XREF_DATA XREF_EXT_VALUE1 Supplier Site Province PROVINCE 1020 Varchar2140 20 439 AD SS PO_VENDOR_SITES PROVINCE Supplier Site Province (Ext1) 1020 Varchar2150 10 459 AD SS ECE_XREF_DATA XREF_EXT_VALUE1 Supplier Site County 1020 Varchar2160 25 469 AD SS RECORD 1030 (SPSO) Common Key (Positions 1-91) 1030 Varchar2 91 1 Record Number 1030 Varchar2 4 92 Constant '1030' Record Layout Code 1030 Varchar2 2 96 Constant 'CN' Record Layout Qualifier 1030 Varchar2 3 98 Constant 'SS' Supplier Site Area Code 1030 Varchar210 10 101 CN SS PO_VENDOR_SITES AREA_CODE Supplier Site Telephone 1030 Varchar220 15 111 CN SS PO_VENDOR_SITES PHONE RECORD 1050 (SPSO) Common Key (Positions 1-91) 1050 Varchar2 91 1 Record Number 1050 Varchar2 4 92 Constant '1050' Record Layout Code 1050 Varchar2 2 96 Constant 'AX' Record Layout Qualifier 1050 Varchar2 3 98 Constant 'ST1' Ship To Code (Internal) SHIP_TO_SITE 1050 Varchar210 20 101 AX ST1 HR_LOCATIONS LOCATION_CODE Ship To Code (Ext) 1050 Varchar220 20 121 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Name 1050 Varchar230 60 141 AX ST1 HR_ORGANIZATION_UNITS NAME Ship To Address Line 1 1050 Varchar240 35 201 AX ST1 HR_LOCATIONS ADDRESS_LINE_1 Ship To Address Line 2 1050 Varchar250 35 236 AX ST1 HR_LOCATIONS ADDRESS_LINE_2 Ship To Address Line 3 1050 Varchar260 35 271 AX ST1 HR_LOCATIONS ADDRESS_LINE_3 Ship To City 1050 Varchar270 30 306 AX ST1 HR_LOCATIONS TOWN_OR_CITY Ship To Postal Code 1050 Varchar280 15 336 AX ST1 HR_LOCATIONS POSTAL_CODE Ship To Country (Internal) COUNTRY 1050 Varchar290 20 351 AX ST1 HR_LOCATIONS COUNTRY Ship To Country (Ext1) 1050 Varchar2100 3 371 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 1 (Internal) REGION1 1050 Varchar2110 25 374 AX ST1 HR_LOCATIONS REGION_1 Ship To Region 2 (Ext1) 1050 Varchar2120 10 399 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 2 (Internal) REGION2 1050 Varchar2130 25 409 AX ST1 HR_LOCATIONS REGION_2 Ship To Region 2 (Ext1) 1050 Varchar2140 10 434 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 3 (Internal) REGION3 1050 Varchar2150 25 444 AX ST1 HR_LOCATIONS REGION_3 Ship To Region 3 (Ext 1) 1050 Varchar2160 10 469 AX ST1 ECE_XREF_DATA XREF_EXT_VALUE1 RECORD 1060 (SPSO) Common Key (Positions 1-91) 1060 Varchar2 91 1 Record Number 1060 Varchar2 4 92 Constant '1060'' Record Layout Code 1060 Varchar2 2 96 Constant 'ST' Record Layout Qualifier 1060 Varchar2 3 98 Constant 'ST2' Ship To Organization Code (Internal SHIP_TO_ORG 1060 Varchar210 10 101 ST ST2 MTL_PARAMETERS ORGANIZATION_CODE Ship To Organization Code (Ext 1) 1060 Varchar220 20 111 ST ST2 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Telephone 1060 Varchar230 15 131 ST ST2 HR_LOCATIONS TELEPHONE_NUMBER_1 Ship To Org Enable CUM Flag 1060 Varchar240 1 146 ST ST2 CHV_ORG_OPTIONS ENABLE_CUM_FLAG Ship To Org CUM Period Start Date 1060 Date 50 15 147 ST ST2 CHV_CUM_PERIODS CUM_PERIOD_START_DATE RECORD 1500 (SPSO) Common Key (Positions 1-91) 1500 Varchar2 91 1 Record Number 1500 Varchar2 4 92 Constant '1500' Record Layout Code 1500 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1500 Varchar2 3 98 Constant 'SH1' Schedule Header Flexfield Context 1500 Varchar210 30 101 A1 SH1 CHV_SCHEDULE_HEADERS ATTRIBUTE_CATEGORY Schedule Header Flexfield 1 1500 Varchar220 80 131 A1 SH1 CHV_SCHEDULE_HEADERS ATTRIBUTE1 Schedule Header Flexfield 2 1500 Varchar230 80 211 A1 SH1 CHV_SCHEDULE_HEADERS ATTRIBUTE2 Schedule Header Flexfield 3 1500 Varchar240 80 291 A1 SH1 CHV_SCHEDULE_HEADERS ATTRIBUTE3 Schedule Header Flexfield 4 1500 Varchar250 80 371 A1 SH1 CHV_SCHEDULE_HEADERS ATTRIBUTE4 RECORD 1510 (SPSO) Common Key (Positions 1-91) 1510 Varchar2 91 1 Record Number 1510 Varchar2 4 92 Constant '1510' Record Layout Code 1510 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1510 Varchar2 3 98 Constant 'SH2' Schedule Header Flexfield 5 1510 Varchar210 80 101 A2 SH2 CHV_SCHEDULE_HEADERS ATTRIBUTE5 Schedule Header Flexfield 6 1510 Varchar220 80 181 A2 SH2 CHV_SCHEDULE_HEADERS ATTRIBUTE6 Schedule Header Flexfield 7 1510 Varchar230 80 261 A2 SH2 CHV_SCHEDULE_HEADERS ATTRIBUTE7 Schedule Header Flexfield 8 1510 Varchar240 80 341 A2 SH2 CHV_SCHEDULE_HEADERS ATTRIBUTE8 Schedule Header Flexfield 9 1510 Varchar250 80 421 A2 SH2 CHV_SCHEDULE_HEADERS ATTRIBUTE9 RECORD 1520 (SPSO) Common Key (Positions 1-91) 1520 Varchar2 91 1 Record Number 1520 Varchar2 4 92 Constant '1520' Record Layout Code 1520 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1520 Varchar2 3 98 Constant 'SH3' Schedule Header Flexfield 10 1520 Varchar210 80 101 A2 SH3 CHV_SCHEDULE_HEADERS ATTRIBUTE10 Schedule Header Flexfield 11 1520 Varchar220 80 181 A2 SH3 CHV_SCHEDULE_HEADERS ATTRIBUTE11 Schedule Header Flexfield 12 1520 Varchar230 80 261 A2 SH3 CHV_SCHEDULE_HEADERS ATTRIBUTE12 Schedule Header Flexfield 13 1520 Varchar240 80 341 A2 SH3 CHV_SCHEDULE_HEADERS ATTRIBUTE13 Schedule Header Flexfield 14 1520 Varchar250 80 421 A2 SH3 CHV_SCHEDULE_HEADERS ATTRIBUTE14 RECORD 1530 (SPSO) Common Key (Positions 1-91) 1530 Varchar2 91 1 Record Number 1530 Varchar2 4 92 Constant '1530' Record Layout Code 1530 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1530 Varchar2 3 98 Constant 'SH4' Schedule Header Flexfield 15 1530 Varchar210 80 101 A2 SH4 CHV_SCHEDULE_HEADERS ATTRIBUTE15 RECORD 1600 (SPSO) Common Key (Positions 1-91) 1600 Varchar2 91 1 Record Number 1600 Varchar2 4 92 Constant '1600' Record Layout Code 1600 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1600 Varchar2 3 98 Constant 'VN1' Vendor Flexfield Context 1600 Varchar210 30 101 A1 VN1 PO_VENDORS ATTRIBUTE_CATEGORY Vendor Flexfield 1 1600 Varchar220 80 131 V VN1 PO_VENDORS ATTRIBUTE1 Vendor Flexfield 2 1600 Varchar230 80 211 A1 VN1 PO_VENDORS ATTRIBUTE2 Vendor Flexfield 3 1600 Varchar240 80 291 A1 VN1 PO_VENDORS ATTRIBUTE3 Vendor Flexfield 4 1600 Varchar250 80 371 A1 VN1 PO_VENDORS ATTRIBUTE4 RECORD 1610 (SPSO) Common Key (Positions 1-91) 1610 Varchar2 91 1 Record Number 1610 Varchar2 4 92 Constant '1610' Record Layout Code 1610 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1610 Varchar2 3 98 Constant 'VN2' Vendor Flexfield 5 1610 Varchar210 80 101 A2 VN2 PO_VENDORS ATTRIBUTE5 Vendor Flexfield 6 1610 Varchar220 80 181 A2 VN2 PO_VENDORS ATTRIBUTE6 Vendor Flexfield 7 1610 Varchar230 80 261 A2 VN2 PO_VENDORS ATTRIBUTE7 Vendor Flexfield 8 1610 Varchar240 80 341 A2 VN2 PO_VENDORS ATTRIBUTE8 Vendor Flexfield 9 1610 Varchar250 80 421 A2 VN2 PO_VENDORS ATTRIBUTE9 RECORD 1620 (SPSO) Common Key (Positions 1-91) 1620 Varchar2 91 1 Record Number 1620 Varchar2 4 92 Constant '1620' Record Layout Code 1620 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1620 Varchar2 3 98 Constant 'VN3' Vendor Flexfield 10 1620 Varchar210 80 101 A2 VN3 PO_VENDORS ATTRIBUTE10 Vendor Flexfield 11 1620 Varchar220 80 181 A2 VN3 PO_VENDORS ATTRIBUTE11 Vendor Flexfield 12 1620 Varchar230 80 261 A2 VN3 PO_VENDORS ATTRIBUTE12 Vendor Flexfield 13 1620 Varchar240 80 341 A2 VN3 PO_VENDORS ATTRIBUTE13 Vendor Flexfield 14 1620 Varchar250 80 421 A2 VN3 PO_VENDORS ATTRIBUTE14 RECORD 1630 (SPSO) Common Key (Positions 1-91) 1630 Varchar2 91 1 Record Number 1630 Varchar2 4 92 Constant '1630' Record Layout Code 1630 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1630 Varchar2 3 98 Constant 'VN4' Vendor Flexfield 15 1630 Varchar210 80 101 A2 VN4 PO_VENDORS ATTRIBUTE15 RECORD 1650 (SPSO) Common Key (Positions 1-91) 1650 Varchar2 91 1 Record Number 1650 Varchar2 4 92 Constant '1650' Record Layout Code 1650 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1650 Varchar2 3 98 Constant 'VS1' Vendor Site Flexfield Context 1650 Varchar210 30 101 A1 VS1 PO_VENDOR_SITES ATTRIBUTE_CATEGORY Vendor Site Flexfield 1 1650 Varchar220 80 131 A1 VS1 PO_VENDOR_SITES ATTRIBUTE1 Vendor Site Flexfield 2 1650 Varchar230 80 211 A1 VS1 PO_VENDOR_SITES ATTRIBUTE2 Vendor Site Flexfield 3 1650 Varchar240 80 291 A1 VS1 PO_VENDOR_SITES ATTRIBUTE3 Vendor Site Flexfield 4 1650 Varchar250 80 371 A1 VS1 PO_VENDOR_SITES ATTRIBUTE4 RECORD 1660 (SPSO) Common Key (Positions 1-91) 1660 Varchar2 91 1 Record Number 1660 Varchar2 4 92 Constant '1660' Record Layout Code 1660 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1660 Varchar2 3 98 Constant 'VS2' Vendor Site Flexfield 5 1660 Varchar210 80 101 A2 VS2 PO_VENDOR_SITES ATTRIBUTE5 Vendor Site Flexfield 6 1660 Varchar220 80 181 A2 VS2 PO_VENDOR_SITES ATTRIBUTE6 Vendor Site Flexfield 7 1660 Varchar230 80 261 A2 VS2 PO_VENDOR_SITES ATTRIBUTE7 Vendor Site Flexfield 8 1660 Varchar240 80 341 A2 VS2 PO_VENDOR_SITES ATTRIBUTE8 Vendor Site Flexfield 9 1660 Varchar250 80 421 A2 VS2 PO_VENDOR_SITES ATTRIBUTE9 RECORD 1670 (SPSO) Common Key (Positions 1-91) 1670 Varchar2 91 1 Record Number 1670 Varchar2 4 92 Constant '1670' Record Layout Code 1670 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1670 Varchar2 3 98 Constant 'VS3' Vendor Site Flexfield 10 1670 Varchar210 80 101 A2 VS3 PO_VENDOR_SITES ATTRIBUTE10 Vendor Site Flexfield 11 1670 Varchar220 80 181 A2 VS3 PO_VENDOR_SITES ATTRIBUTE11 Vendor Site Flexfield 12 1670 Varchar230 80 261 A2 VS3 PO_VENDOR_SITES ATTRIBUTE12 Vendor Site Flexfield 13 1670 Varchar240 80 341 A2 VS3 PO_VENDOR_SITES ATTRIBUTE13 Vendor Site Flexfield 14 1670 Varchar250 80 421 A2 VS3 PO_VENDOR_SITES ATTRIBUTE14 RECORD 1680 (SPSO) Common Key (Positions 1-91) 1680 Varchar2 91 1 Record Number 1680 Varchar2 4 92 Constant '1680' Record Layout Code 1680 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1680 Varchar2 3 98 Constant 'VS4' Vendor Site Flexfield 15 1680 Varchar210 80 101 A2 VS4 PO_VENDOR_SITES ATTRIBUTE15 RECORD 1700 (SPSO) Common Key (Positions 1-91) 1700 Varchar2 91 1 Record Number 1700 Varchar2 4 92 Constant '1700' Record Layout Code 1700 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1700 Varchar2 3 98 Constant 'ST1' Ship To Flexfield Context 1700 Varchar210 30 101 A1 ST1 HR_LOCATIONS ATTRIBUTE_CATEGORY Ship To Flexfield 1 1700 Varchar220 80 131 A1 ST1 HR_LOCATIONS ATTRIBUTE1 Ship To Flexfield 2 1700 Varchar230 80 211 A1 ST1 HR_LOCATIONS ATTRIBUTE2 Ship To Flexfield 3 1700 Varchar240 80 291 A1 ST1 HR_LOCATIONS ATTRIBUTE3 Ship To Flexfield 4 1700 Varchar250 80 371 A1 ST1 HR_LOCATIONS ATTRIBUTE4 RECORD 1710 (SPSO) Common Key (Positions 1-91) 1710 Varchar2 91 1 Record Number 1710 Varchar2 4 92 Constant '1710' Record Layout Code 1710 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1710 Varchar2 3 98 Constant 'ST2' Ship To Flexfield 5 1710 Varchar210 80 101 A2 ST2 HR_LOCATIONS ATTRIBUTE5 Ship To Flexfield 6 1710 Varchar220 80 181 A2 ST2 HR_LOCATIONS ATTRIBUTE6 Ship To Flexfield 7 1710 Varchar230 80 261 A2 ST2 HR_LOCATIONS ATTRIBUTE7 Ship To Flexfield 8 1710 Varchar240 80 341 A2 ST2 HR_LOCATIONS ATTRIBUTE8 Ship To Flexfield 9 1710 Varchar250 80 421 A2 ST2 HR_LOCATIONS ATTRIBUTE9 RECORD 1720 (SPSO) Common Key (Positions 1-91) 1720 Varchar2 91 1 Record Number 1720 Varchar2 4 92 Constant '1720' Record Layout Code 1720 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1720 Varchar2 3 98 Constant 'ST3' Ship To Flexfield 10 1720 Varchar210 80 101 A2 ST3 HR_LOCATIONS ATTRIBUTE10 Ship To Flexfield 11 1720 Varchar220 80 181 A2 ST3 HR_LOCATIONS ATTRIBUTE11 Ship To Flexfield 12 1720 Varchar230 80 261 A2 ST3 HR_LOCATIONS ATTRIBUTE12 Ship To Flexfield 13 1720 Varchar240 80 341 A2 ST3 HR_LOCATIONS ATTRIBUTE13 Ship To Flexfield 14 1720 Varchar250 80 421 A2 ST3 HR_LOCATIONS ATTRIBUTE14 RECORD 1730 (SPSO) Common Key (Positions 1-91) 1730 Varchar2 91 1 Record Number 1730 Varchar2 4 92 Constant '1730' Record Layout Code 1730 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1730 Varchar2 3 98 Constant 'ST4' Ship To Flexfield 15 1730 Varchar210 80 101 A2 ST4 HR_LOCATIONS ATTRIBUTE15 RECORD 1750 (SPSO) Common Key (Positions 1-91) 1750 Varchar2 91 1 Record Number 1750 Varchar2 4 92 Constant '1750' Record Layout Code 1750 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 1750 Varchar2 3 98 Constant 'OP1' Ship To Options Flexfield Context 1750 Varchar210 30 101 A1 OP1 CHV_ORG_OPTIONS ATTRIBUTE_CATEGORY Ship To Options Flexfield 1 1750 Varchar220 80 131 A1 OP1 CHV_ORG_OPTIONS ATTRIBUTE1 Ship To Options Flexfield 2 1750 Varchar230 80 211 A1 OP1 CHV_ORG_OPTIONS ATTRIBUTE2 Ship To Options Flexfield 3 1750 Varchar240 80 291 A1 OP1 CHV_ORG_OPTIONS ATTRIBUTE3 Ship To Options Flexfield 4 1750 Varchar250 80 371 A1 OP1 CHV_ORG_OPTIONS ATTRIBUTE4 RECORD 1760 (SPSO) Common Key (Positions 1-91) 1760 Varchar2 91 1 Record Number 1760 Varchar2 4 92 Constant '1760' Record Layout Code 1760 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1760 Varchar2 3 98 Constant 'OP2' Ship To Options Flexfield 5 1760 Varchar210 80 101 A2 OP2 CHV_ORG_OPTIONS ATTRIBUTE5 Ship To Options Flexfield 6 1760 Varchar220 80 181 A2 OP2 CHV_ORG_OPTIONS ATTRIBUTE6 Ship To Options Flexfield 7 1760 Varchar230 80 261 A2 OP2 CHV_ORG_OPTIONS ATTRIBUTE7 Ship To Options Flexfield 8 1760 Varchar240 80 341 A2 OP2 CHV_ORG_OPTIONS ATTRIBUTE8 Ship To Options Flexfield 9 1760 Varchar250 80 421 A2 OP2 CHV_ORG_OPTIONS ATTRIBUTE9 RECORD 1770 (SPSO) Common Key (Positions 1-91) 1770 Varchar2 91 1 Record Number 1770 Varchar2 4 92 Constant '1770' Record Layout Code 1770 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1770 Varchar2 3 98 Constant 'OP3' Ship To Options Flexfield 10 1770 Varchar210 80 101 A2 OP3 CHV_ORG_OPTIONS ATTRIBUTE10 Ship To Options Flexfield 11 1770 Varchar220 80 181 A2 OP3 CHV_ORG_OPTIONS ATTRIBUTE11 Ship To Options Flexfield 12 1770 Varchar230 80 261 A2 OP3 CHV_ORG_OPTIONS ATTRIBUTE12 Ship To Options Flexfield 13 1770 Varchar240 80 341 A2 OP3 CHV_ORG_OPTIONS ATTRIBUTE13 Ship To Options Flexfield 14 1770 Varchar250 80 421 A2 OP3 CHV_ORG_OPTIONS ATTRIBUTE14 RECORD 1780 (SPSO) Common Key (Positions 1-91) 1780 Varchar2 91 1 Record Number 1780 Varchar2 4 92 Constant '1780' Record Layout Code 1780 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 1780 Varchar2 3 98 Constant 'OP4' Ship To Options Flexfield 15 1780 Varchar210 80 101 A2 OP4 CHV_ORG_OPTIONS ATTRIBUTE15 RECORD 2000 (SPSO) Common Key (Positions 1-91) 2000 Varchar2 91 1 Record Number 2000 Varchar2 4 92 Constant '2000' Record Layout Code 2000 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 2000 Varchar2 3 98 Constant 'IT1' Buyer Product Code BUYER_PRODUCT 2000 Varchar210 50 101 IT IT1 MTL_ITEM_FLEXFIELDS ITEM_NUMBER Supplier Product Code 2000 Varchar220 25 151 IT IT1 PO_APPROVED_SUPPLIER_LISTPRIMARY_VENDOR_ITEM Purchasing Starting CUM Quantity 2000 Number 30 22 176 IT IT1 CHV_SCHEDULE_ITEMS STARTING_CUM_QUANTITY Purchasing Starting Authorization Quantity 2000 Number 40 22 198 IT IT1 CHV_SCHEDULE_ITEMS STARTING_AUTH_QUANTITY Purchasing Unit of Measure (Interna UOM 2000 Varchar250 25 220 IT IT1 CHV_SCHEDULE_ITEMS PURCHASING_UNIT_OF_MEASURE Purchasing Unit of Measure (Ext1) 2000 Varchar260 3 245 IT IT1 ECE_XREF_DATA ECE_XREF_VALUE1 Supply Agreement Number 2000 Varchar270 20 248 IT IT1 PO_HEADERS SEGMENT1 Supply Agreement Type 2000 Varchar280 25 268 IT IT1 PO_HEADERS TYPE_LOOKUP_CODE Supply Agreement Line Number 2000 Number 90 22 293 IT IT1 PO_LINES LINE_NUM Primary Starting CUM Quantity 2000 Number 140 22 315 IT IT1 CHV_SCHEDULE_ITEMS STARTING_CUM_QTY_PRIMARY Primary Authorization Quantity 2000 Number 150 22 337 IT IT1 CHV_SCHEDULE_ITEMS STARTING_AUTH_QTY_PRIMARY RECORD 2010 (SPSO) Common Key (Positions 1-91) 2010 Varchar2 91 1 Record Number 2010 Varchar2 4 92 Constant '2010' Record Layout Code 2010 Varchar2 2 96 Constant 'IT' Record Layout Qualifier 2010 Varchar2 3 98 Constant 'IT2' Product Description 2010 Varchar210 100 101 IT IT2 MTL_SYSTEM_ITEMS DESCRIPTION RECORD 2020 (SPSO) Common Key (Positions 1-91) 2020 Varchar2 91 1 Record Number 2020 Varchar2 4 92 Constant '2020' Record Layout Code 2020 Varchar2 2 96 Constant 'HZ' Record Layout Qualifier 2020 Varchar2 3 98 Constant 'HZ1' Hazard Class (Internal) HAZ_CLASS 2020 Varchar210 40 101 HZ HZ1 PO_HAZARD_CLASSES HAZARD_CLASS Hazard Class (Ext1) 2020 Varchar220 40 141 HZ HZ1 ECE_XREF_DATA ECE_XREF_VALUE1 Hazard Material Code (Internal) HAZ_MAT 2020 Varchar230 25 181 HZ HZ1 PO_UN_NUMBERS UN_NUMBER Hazard Material (Ext1) 2020 Varchar240 25 206 HZ HZ1 ECE_XREF_DATA ECE_XREF_VALLUES Hazard Class Description 2020 Varchar250 240 231 HZ HZ1 PO_HAZARD_CLASSES DESCRIPTION RECORD 2030 (SPSO) Common Key (Positions 1-91) 2030 Varchar2 91 1 Record Number 2030 Varchar2 4 92 Constant '2030' Record Layout Code 2030 Varchar2 2 96 Constant 'CN' Record Layout Qualifier 2030 Varchar2 3 98 Constant 'IT1' Buyer - Last Name 2030 Varchar210 40 101 CN IT1 PER_PEOPLE_F LAST_NAME Buyer - Work Telephone 2030 Varchar220 60 141 CN IT1 PER_PEOPLE_F WORK_TELEPHONE Item Scheduler - Last Name 2030 Varchar230 40 201 CN IT1 PER_PEOPLE_F LAST_NAME Item Scheduler - Work Telephone 2030 Varchar240 60 241 CN IT1 PER_PEOPLE_F WORK_TELEPHONE Item Planner - Last Name 2030 Varchar250 40 301 CN IT1 PER_PEOPLE_F LAST_NAME Item Planner - Work Telephone 2030 Varchar260 60 341 CN IT1 PER_PEOPLE_F WORK_TELEPHONE RECORD 2040 (SPSO) Common Key (Positions 1-91) 2040 Varchar2 91 1 Record Number 2040 Varchar2 4 92 Constant '2040' Record Layout Code 2040 Varchar2 2 96 Constant 'LS' Record Layout Qualifier 2040 Varchar2 3 98 Constant 'LS1' Last Receipt Shipment Code 2040 Varchar210 30 101 LS LS1 Last Receipt Date 2040 Date 20 15 131 LS LS1 Last Receipt Quantity 2040 Number 30 22 146 LS LS1 CUM Quantity after last Receipt 2040 Number 40 22 168 LS LS1 CUM Quantity Start Date 2040 Date 50 15 190 LS LS1 RECORD 2050 (SPSO) Common Key (Positions 1-91) 2050 Varchar2 91 1 Record Number 2050 Varchar2 4 92 Constant '2050' Record Layout Code 2050 Varchar2 2 96 Constant 'AX' Record Layout Qualifier 2050 Varchar2 3 98 Constant 'SI2' Ship To Code (Internal) SHIP_TO_SITE 2050 Varchar210 20 101 AX SI2 MTL_PARAMETERS ORGANIZATION_CODE Ship To Code (Ext) 2050 Varchar220 20 121 AX SI2 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Name 2050 Varchar230 60 141 AX SI2 HR_ORGANIZATION_UNITS NAME Ship To Address Line 1 2050 Varchar240 35 201 AX SI2 HR_LOCATIONS ADDRESS_LINE_1 Ship To Address Line 2 2050 Varchar250 35 236 AX SI2 HR_LOCATIONS ADDRESS_LINE_2 Ship To Address Line 3 2050 Varchar260 35 271 AX SI2 HR_LOCATIONS ADDRESS_LINE_3 Ship To City 2050 Varchar270 30 306 AX SI2 HR_LOCATIONS TOWN_OR_CITY Ship To Postal Code 2050 Varchar280 15 336 AX SI2 HR_LOCATIONS POSTAL_CODE Ship To Country (Internal) COUNTRY 2050 Varchar290 20 351 AX SI2 HR_LOCATIONS COUNTRY Ship To Country (Ext1) 2050 Varchar2100 3 371 AX SI2 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 1 (Internal) REGION1 2050 Varchar2110 25 374 AX SI2 HR_LOCATIONS REGION_1 Ship To Region 1 (Ext1) 2050 Varchar2120 10 399 AX SI2 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 2 (Internal) REGION2 2050 Varchar2130 25 409 AX SI2 HR_LOCATIONS REGION_2 Ship To Region 2 (Ext1) 2050 Varchar2140 10 434 AX SI2 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Region 3 (Internal) REGION3 2050 Varchar2150 25 444 AX SI2 HR_LOCATIONS REGION_3 Ship To Region 3 (Ext1) 2050 Varchar2160 10 469 AX SI2 ECE_XREF_DATA XREF_EXT_VALUE1 RECORD 2060 (SPSO) Common Key (Positions 1-91) 2060 Varchar2 91 1 Record Number 2060 Varchar2 4 92 Constant '2060' Record Layout Code 2060 Varchar2 2 96 Constant 'ST' Record Layout Qualifier 2060 Varchar2 3 98 Constant 'SI3' Ship To Location Code SHIP_TO_LOCATION 2060 Varchar210 20 101 ST SI3 HR_LOCATIONS LOCATION_CODE Ship To Location Code (Ext1) 2060 Varchar220 20 121 ST SI3 ECE_XREF_DATA XREF_EXT_VALUE1 Ship To Org Enable CUM Flag 2060 Varchar230 1 141 ST SI3 CHV_ORG_OPTIONS ENABLE_CUM_FLAG Ship To Org CUM Period Start Date 2060 Date 40 15 142 ST SI3 CHV_CUM_PERIODS CUM_PERIOD_START_DATE RECORD 2100 (SPSO) Common Key (Positions 1-91) 2100 Varchar2 91 1 Record Number 2100 Varchar2 4 92 Constant '2100' Record Layout Code 2100 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 2100 Varchar2 3 98 Constant 'AS1' Approved Supplier List Flexfield Context 2100 Varchar210 30 101 A1 AS1 PO_ASL_ATTRIBUTES ATTRIBUTE_CATEGORY Approved Supplier List Flexfield 1 2100 Varchar220 80 131 A1 AS1 PO_ASL_ATTRIBUTES ATTRIBUTE1 Approved Supplier List Flexfield 2 2100 Varchar230 80 211 A1 AS1 PO_ASL_ATTRIBUTES ATTRIBUTE2 Approved Supplier List Flexfield 3 2100 Varchar240 80 291 A1 AS1 PO_ASL_ATTRIBUTES ATTRIBUTE3 Approved Supplier List Flexfield 4 2100 Varchar250 80 371 A1 AS1 PO_ASL_ATTRIBUTES ATTRIBUTE4 RECORD 2110 (SPSO) Common Key (Positions 1-91) 2110 Varchar2 91 1 Record Number 2110 Varchar2 4 92 Constant '2110' Record Layout Code 2110 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2110 Varchar2 3 98 Constant 'AS2' Approved Supplier List Flexfield 5 2110 Varchar210 80 101 A2 AS2 PO_ASL_ATTRIBUTES ATTRIBUTE5 Approved Supplier List Flexfield 6 2110 Varchar220 80 181 A2 AS2 PO_ASL_ATTRIBUTES ATTRIBUTE6 Approved Supplier List Flexfield 7 2110 Varchar230 80 261 A2 AS2 PO_ASL_ATTRIBUTES ATTRIBUTE7 Approved Supplier List Flexfield 8 2110 Varchar240 80 341 A2 AS2 PO_ASL_ATTRIBUTES ATTRIBUTE8 Approved Supplier List Flexfield 9 2110 Varchar250 80 421 A2 AS2 PO_ASL_ATTRIBUTES ATTRIBUTE9 RECORD 2120 (SPSO) Common Key (Positions 1-91) 2120 Varchar2 91 1 Record Number 2120 Varchar2 4 92 Constant '2120' Record Layout Code 2120 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2120 Varchar2 3 98 Constant 'AS3' Approved Supplier List Flexfield 10 2120 Varchar210 80 101 A2 AS3 PO_ASL_ATTRIBUTES ATTRIBUTE10 Approved Supplier List Flexfield 11 2120 Varchar220 80 181 A2 AS3 PO_ASL_ATTRIBUTES ATTRIBUTE11 Approved Supplier List Flexfield 12 2120 Varchar230 80 261 A2 AS3 PO_ASL_ATTRIBUTES ATTRIBUTE12 Approved Supplier List Flexfield 13 2120 Varchar240 80 341 A2 AS3 PO_ASL_ATTRIBUTES ATTRIBUTE13 Approved Supplier List Flexfield 14 2120 Varchar250 80 421 A2 AS3 PO_ASL_ATTRIBUTES ATTRIBUTE14 RECORD 2130 (SPSO) Common Key (Positions 1-91) 2130 Varchar2 91 1 Record Number 2130 Varchar2 4 92 Constant '2130' Record Layout Code 2130 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2130 Varchar2 3 98 Constant 'AS4' Approved Supplier List Flexfield 15 2130 Varchar210 80 101 A2 AS4 PO_ASL_ATTRIBUTES ATTRIBUTE15 RECORD 2150 (SPSO) Common Key (Positions 1-91) 2150 Varchar2 91 1 Record Number 2150 Varchar2 4 92 Constant '2150' Record Layout Code 2150 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 2150 Varchar2 3 98 Constant 'IT1' Item Flexfield Context 2150 Varchar210 30 101 A1 IT1 MTL_ITEM_FLEXFIELDS ATTRIBUTE_CATEGORY Item Flexfield 1 2150 Varchar220 80 131 A1 IT1 MTL_ITEM_FLEXFIELDS ATTRIBUTE1 Item Flexfield 2 2150 Varchar230 80 211 A1 IT1 MTL_ITEM_FLEXFIELDS ATTRIBUTE2 Item Flexfield 3 2150 Varchar240 80 291 A1 IT1 MTL_ITEM_FLEXFIELDS ATTRIBUTE3 Item Flexfield 4 2150 Varchar250 80 371 A1 IT1 MTL_ITEM_FLEXFIELDS ATTRIBUTE4 RECORD 2160 (SPSO) Common Key (Positions 1-91) 2160 Varchar2 91 1 Record Number 2160 Varchar2 4 92 Constant '2160' Record Layout Code 2160 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2160 Varchar2 3 98 Constant 'IT2' Item Flexfield 5 2160 Varchar210 80 101 A2 IT2 MTL_ITEM_FLEXFIELDS ATTRIBUTE5 Item Flexfield 6 2160 Varchar220 80 181 A2 IT2 MTL_ITEM_FLEXFIELDS ATTRIBUTE6 Item Flexfield 7 2160 Varchar230 80 261 A2 IT2 MTL_ITEM_FLEXFIELDS ATTRIBUTE7 Item Flexfield 8 2160 Varchar240 80 341 A2 IT2 MTL_ITEM_FLEXFIELDS ATTRIBUTE8 Item Flexfield 9 2160 Varchar250 80 421 A2 IT2 MTL_ITEM_FLEXFIELDS ATTRIBUTE9 RECORD 2170 (SPSO) Common Key (Positions 1-91) 2170 Varchar2 91 1 Record Number 2170 Varchar2 4 92 Constant '2170' Record Layout Code 2170 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2170 Varchar2 3 98 Constant 'IT3' Item Flexfield 10 2170 Varchar210 80 101 A2 IT3 MTL_ITEM_FLEXFIELDS ATTRIBUTE10 Item Flexfield 11 2170 Varchar220 80 181 A2 IT3 MTL_ITEM_FLEXFIELDS ATTRIBUTE11 Item Flexfield 12 2170 Varchar230 80 261 A2 IT3 MTL_ITEM_FLEXFIELDS ATTRIBUTE12 Item Flexfield 13 2170 Varchar240 80 341 A2 IT3 MTL_ITEM_FLEXFIELDS ATTRIBUTE13 Item Flexfield 14 2170 Varchar250 80 421 A2 IT3 MTL_ITEM_FLEXFIELDS ATTRIBUTE14 RECORD 2180 (SPSO) Common Key (Positions 1-91) 2180 Varchar2 91 1 Record Number 2180 Varchar2 4 92 Constant '2180' Record Layout Code 2180 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2180 Varchar2 3 98 Constant 'IT4' Item Flexfield 15 2180 Varchar210 80 101 A2 IT4 MTL_ITEM_FLEXFIELDS ATTRIBUTE15 RECORD 2200 (SPSO) Common Key (Positions 1-91) 2200 Varchar2 91 1 Record Number 2200 Varchar2 4 92 Constant '2200' Record Layout Code 2200 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 2200 Varchar2 3 98 Constant 'DI1' Ship To Flexfield Context 2200 Varchar210 30 101 A1 DI1 HR_LOCATIONS ATTRIBUTE_CATEGORY Ship To Flexfield 1 2200 Varchar220 80 131 A1 DI1 HR_LOCATIONS ATTRIBUTE1 Ship To Flexfield 2 2200 Varchar230 80 211 A1 DI1 HR_LOCATIONS ATTRIBUTE2 Ship To Flexfield 3 2200 Varchar240 80 291 A1 DI1 HR_LOCATIONS ATTRIBUTE3 Ship To Flexfield 4 2200 Varchar250 80 371 A1 DI1 HR_LOCATIONS ATTRIBUTE4 RECORD 2210 (SPSO) Common Key (Positions 1-91) 2210 Varchar2 91 1 Record Number 2210 Varchar2 4 92 Constant '2210' Record Layout Code 2210 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2210 Varchar2 3 98 Constant 'DI2' Ship To Flexfield 5 2210 Varchar210 80 101 A2 DI2 HR_LOCATIONS ATTRIBUTE5 Ship To Flexfield 6 2210 Varchar220 80 181 A2 DI2 HR_LOCATIONS ATTRIBUTE6 Ship To Flexfield 7 2210 Varchar230 80 261 A2 DI2 HR_LOCATIONS ATTRIBUTE7 Ship To Flexfield 8 2210 Varchar240 80 341 A2 DI2 HR_LOCATIONS ATTRIBUTE8 Ship To Flexfield 9 2210 Varchar250 80 421 A2 DI2 HR_LOCATIONS ATTRIBUTE9 RECORD 2220 (SPSO) Common Key (Positions 1-91) 2220 Varchar2 91 1 Record Number 2220 Varchar2 4 92 Constant '2220' Record Layout Code 2220 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2220 Varchar2 3 98 Constant 'DI3' Ship To Flexfield 10 2220 Varchar210 80 101 A2 DI3 HR_LOCATIONS ATTRIBUTE10 Ship To Flexfield 11 2220 Varchar220 80 181 A2 DI3 HR_LOCATIONS ATTRIBUTE11 Ship To Flexfield 12 2220 Varchar230 80 261 A2 DI3 HR_LOCATIONS ATTRIBUTE12 Ship To Flexfield 13 2220 Varchar240 80 341 A2 DI3 HR_LOCATIONS ATTRIBUTE13 Ship To Flexfield 14 2220 Varchar250 80 421 A2 DI3 HR_LOCATIONS ATTRIBUTE14 RECORD 2230 (SPSO) 2230 Varchar2 Common Key (Positions 1-91) 2230 Varchar2 91 1 Record Number 2230 Varchar2 4 92 Constant '2230' Record Layout Code 2230 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2230 Varchar2 3 98 Constant 'DI4' Ship To Flexfield 15 2230 Varchar210 80 101 A2 DI4 HR_LOCATIONS ATTRIBUTE15 RECORD 2250 (SPSO) Common Key (Positions 1-91) 2250 Varchar2 91 1 Record Number 2250 Varchar2 4 92 Constant '2250' Record Layout Code 2250 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 2250 Varchar2 3 98 Constant 'SO1' Ship To Options Flexfield Context 2250 Varchar210 30 101 A1 SO1 CHV_ORG_OPTIONS ATTRIBUTE_CATEGORY Ship To Options Flexfield 1 2250 Varchar220 80 131 A1 SO1 CHV_ORG_OPTIONS ATTRIBUTE1 Ship To Options Flexfield 2 2250 Varchar230 80 211 A1 SO1 CHV_ORG_OPTIONS ATTRIBUTE2 Ship To Options Flexfield 3 2250 Varchar240 80 291 A1 SO1 CHV_ORG_OPTIONS ATTRIBUTE3 Ship To Options Flexfield 4 2250 Varchar250 80 371 A1 SO1 CHV_ORG_OPTIONS ATTRIBUTE4 RECORD 2260 (SPSO) Common Key (Positions 1-91) 2260 Varchar2 91 1 Record Number 2260 Varchar2 4 92 Constant '2600' Record Layout Code 2260 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2260 Varchar2 3 98 Constant 'SO2' Ship To Options Flexfield 5 2260 Varchar210 80 101 A2 SO2 CHV_ORG_OPTIONS ATTRIBUTE5 Ship To Options Flexfield 6 2260 Varchar220 80 181 A2 SO2 CHV_ORG_OPTIONS ATTRIBUTE6 Ship To Options Flexfield 7 2260 Varchar230 80 261 A2 SO2 CHV_ORG_OPTIONS ATTRIBUTE7 Ship To Options Flexfield 8 2260 Varchar240 80 341 A2 SO2 CHV_ORG_OPTIONS ATTRIBUTE8 Ship To Options Flexfield 9 2260 Varchar250 80 421 A2 SO2 CHV_ORG_OPTIONS ATTRIBUTE9 RECORD 2270 (SPSO) Common Key (Positions 1-91) 2270 Varchar2 91 1 Record Number 2270 Varchar2 4 92 Constant '2270' Record Layout Code 2270 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2270 Varchar2 3 98 Constant 'SO3' Ship To Options Flexfield 10 2270 Varchar210 80 101 A2 SO3 CHV_ORG_OPTIONS ATTRIBUTE10 Ship To Options Flexfield 11 2270 Varchar220 80 181 A2 SO3 CHV_ORG_OPTIONS ATTRIBUTE11 Ship To Options Flexfield 12 2270 Varchar230 80 261 A2 SO3 CHV_ORG_OPTIONS ATTRIBUTE12 Ship To Options Flexfield 13 2270 Varchar240 80 341 A2 SO3 CHV_ORG_OPTIONS ATTRIBUTE13 Ship To Options Flexfield 14 2270 Varchar250 80 421 A2 SO3 CHV_ORG_OPTIONS ATTRIBUTE14 RECORD 2280 (SPSO) Common Key (Positions 1-91) 2280 Varchar2 91 1 Record Number 2280 Varchar2 4 92 Constant '2280' Record Layout Code 2280 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2280 Varchar2 3 98 Constant 'SO4' Ship To Options Flexfield 15 2280 Varchar210 80 101 A2 SO4 CHV_ORG_OPTIONS ATTRIBUTE15 RECORD 2300 (SPSO) Common Key (Positions 1-91) 2300 Varchar2 91 1 Record Number 2300 Varchar2 4 92 Constant '2300' Record Layout Code 2300 Varchar2 2 96 Constant 'A1' Record Layout Qualifier 2300 Varchar2 3 98 Constant 'SI1' Schedule Item Flexfield Context 2300 Varchar210 30 101 A1 SI1 CHV_SCHEDULE_ITEMS ATTRIBUTE_CATEGORY Schedule Item Flexfield 1 2300 Varchar220 80 131 A1 SI1 CHV_SCHEDULE_ITEMS ATTRIBUTE1 Schedule Item Flexfield 2 2300 Varchar230 80 211 A1 SI1 CHV_SCHEDULE_ITEMS ATTRIBUTE2 Schedule Item Flexfield 3 2300 Varchar240 80 291 A1 SI1 CHV_SCHEDULE_ITEMS ATTRIBUTE3 Schedule Item Flexfield 4 2300 Varchar250 80 371 A1 SI1 CHV_SCHEDULE_ITEMS ATTRIBUTE4 RECORD 2310 (SPSO) Common Key (Positions 1-91) 2310 Varchar2 91 1 Record Number 2310 Varchar2 4 92 Constant '2310' Record Layout Code 2310 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2310 Varchar2 3 98 Constant 'SI2' Schedule Item Flexfield 5 2310 Varchar210 80 101 A2 SI2 CHV_SCHEDULE_ITEMS ATTRIBUTE5 Schedule Item Flexfield 6 2310 Varchar220 80 181 A2 SI2 CHV_SCHEDULE_ITEMS ATTRIBUTE6 Schedule Item Flexfield 7 2310 Varchar230 80 261 A2 SI2 CHV_SCHEDULE_ITEMS ATTRIBUTE7 Schedule Item Flexfield 8 2310 Varchar240 80 341 A2 SI2 CHV_SCHEDULE_ITEMS ATTRIBUTE8 Schedule Item Flexfield 9 2310 Varchar250 80 421 A2 SI2 CHV_SCHEDULE_ITEMS ATTRIBUTE9 RECORD 2320 (SPSO) Common Key (Positions 1-91) 2320 Varchar2 91 1 Record Number 2320 Varchar2 4 92 Constant '2320' Record Layout Code 2320 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2320 Varchar2 3 98 Constant 'SI3' Schedule Item Flexfield 10 2320 Varchar210 80 101 A2 SI3 CHV_SCHEDULE_ITEMS ATTRIBUTE10 Schedule Item Flexfield 11 2320 Varchar220 80 181 A2 SI3 CHV_SCHEDULE_ITEMS ATTRIBUTE11 Schedule Item Flexfield 12 2320 Varchar230 80 261 A2 SI3 CHV_SCHEDULE_ITEMS ATTRIBUTE12 Schedule Item Flexfield 13 2320 Varchar240 80 341 A2 SI3 CHV_SCHEDULE_ITEMS ATTRIBUTE13 Schedule Item Flexfield 14 2320 Varchar250 80 421 A2 SI3 CHV_SCHEDULE_ITEMS ATTRIBUTE14 RECORD 2330 (SPSO) Common Key (Positions 1-91) 2330 Varchar2 91 1 Record Number 2330 Varchar2 4 92 Constant '2330' Record Layout Code 2330 Varchar2 2 96 Constant 'A2' Record Layout Qualifier 2330 Varchar2 3 98 Constant 'SI4' Schedule Item Flexfield 15 2330 Varchar210 80 101 A2 SI4 CHV_SCHEDULE_ITEMS ATTRIBUTE15 RECORD 4000 (SPSO) Common Key (Positions 1-91) 4000 Varchar2 91 1 Record Number 4000 Varchar2 4 92 Constant '4000' Record Layout Code 4000 Varchar2 2 96 Constant 'SC' Record Layout Qualifier 4000 Varchar2 3 98 Constant 'SCH' Schedule Item Detail Sequence 4000 Number 10 22 101 SC SCH Incremented Detail Category 4000 Varchar220 25 123 SC SCH Detail Descriptor (Internal) SS_DESCRIPTOR 4000 Varchar230 25 148 SC SCH CHV_HORIZONTAL_SCHEDULES BUCKET_DESCRIPTORn Detail Descriptor (Ext1) 4000 Varchar240 10 173 SC SCH ECE_XREF_DATA ECE_EXT_VALUE1 Starting Date 4000 Date 50 15 183 SC SCH CHV_HORIZONTAL_SCHEDULES BUCKET_START_DATEn Ending Date 4000 Date 60 15 198 SC SCH CHV_HORIZONTAL_SCHEDULES BUCKET_END_DATEn Forecast Quantity 4000 Number 70 22 213 SC SCH CHV_HORIZONTAL_SCHEDULES BUCKET_FORECAST_QUANTITYn Release Quantity 4000 Number 80 22 235 SC SCH CHV_HORIZONTAL_SCHEDULES BUCKET_RELEASE_QUANTITYn Total Quantity 4000 Number 90 22 257 SC SCH CHV_HORIZONTAL_SCHEDULES BUCKET_TOTAL_QUANTITYn Document Type 4000 Varchar2100 25 279 SC SCH æSHIPMENT" if last receipt Document Number 4000 Varchar2110 20 304 SC SCH only if last receipt record Document Release Number 4000 Number 120 22 324 SC SCH Document Line Number 4000 Number 130 22 346 SC SCH
Previous | Next | Contents | Index | Navigation | Glossary | Library |