Previous  Next          Contents  Index  Navigation  Glossary  Library

Outbound Planning Schedule and Shipping Schedule Summary Tables

These two transactions share the same data file and so are documented together.

The following tables provide a summary description of the data file:

Record Occurrences within the Transaction

Records Content Occurrences
0010-0070 EDI Gateway Control Records Only one record occurrence per transaction
1000-1900 Header Records Only one record occurrence per transaction
2000-2900 Item Records One set of records per item within the Planning Schedule header
4000-4900 Authorization Records One records per forecast, authorization or receipt data per item
Table 1 - 78. (Page 1 of 1)

Record Summary

Seq. Data Data Level Record Number Note
1 Control Record CONTROL 0010
2 Trading Partner Header Flexfields TRADING PARTNER 0020-0050 Flexfields
4 Basic Planning Schedule Header PLANNING SCHEDULE HEADER 1000
5 Supplier Numbers PLANNING SCHEDULE HEADER 1010  
6 Supplier Site Address/Code PLANNING SCHEDULE HEADER 1020  
7 Supplier Site Phone PLANNING SCHEDULE HEADER 1030  
8 Ship to Address/Code PLANNING SCHEDULE HEADER 1050
9 Ship to Miscellaneous Data PLANNING SCHEDULE HEADER 1060
10 Schedule Header Flex Fields PLANNING SCHEDULE HEADER 1500-1530 Flexfields
11 Supplier Flex Fields PLANNING SCHEDULE HEADER 1600-1630 Flexfields
12 Supplier Site Flex Fields PLANNING SCHEDULE HEADER 1650-1680 Flexfields
13 Shipping Organization Flex Fields PLANNING SCHEDULE HEADER 1700-1730 Flexfields
14 Ship To Options Flex Fields PLANNING SCHEDULE HEADER 1750-1780 Flexfields
15 Extension Tables:
Purchase Order Header Data 		PLANNING SCHEDULE ITEM 1900 (Custom)
16 Basic Item Data PLANNING SCHEDULE ITEM 2000
17 Product Description PLANNING SCHEDULE ITEM 2010
18 Hazardous Material Codes PLANNING SCHEDULE ITEM 2020
19 Contact Names PLANNING SCHEDULE ITEM 2030  
20 Last Receipt Data PLANNING SCHEDULE ITEM 2040
21 Ship To Organization Address/Code PLANNING SCHEDULE ITEM 2050
22 Ship To Organization Data PLANNING SCHEDULE ITEM 2060  
23 Approved Supplier List Flex Fields PLANNING SCHEDULE ITEM 2100-2130 Flexfields
24 Item Flex Fields PLANNING SCHEDULE ITEM 2150-2180 Flexfields
25 Ship To Organization Flex Fields PLANNING SCHEDULE ITEM 2200-2230 Flexfields
26 Organization Option Flex Fields PLANNING SCHEDULE ITEM 2250-2280 Flexfields
27 Schedule Item Flex Fields PLANNING SCHEDULE ITEM 2300-2330 Flexfields
28 Extension Tables: Item Data PLANNING SCHEDULE ITEM 2900 (Custom)
29 Forecast and Authorization Data PLANNING SCHEDULE AUTHORIZATION 4000
30 Extension Tables: Forecast and Authorization Data PLANNING SCHEDULE AUTHORIZATION 4900 (Custom)
Table 1 - 79. (Page 2 of 2)

Transaction-specific Data in the Common Key Positions 1-100

Position Code Content
1-25 TP_CD Trading Partner Code as defined in the EDI Translator
26-47 SP Planning Schedule number
48-69 ITEM Planning Schedule line number
70-91 SCHEDULE Schedule Bucket Number
92-95 (varies) Record Number
96-97 (varies) Record Layout
98-100 (varies) Record Layout Qualifier
Table 1 - 80. (Page 1 of 1)

Transaction-specific Data in the Common Key Positions 1-100 Per Record

Seq. Data Trading Partner Reference 1 Reference 2 Reference 3 Record Number Record Layout Record Layout Qualifier
Length 25 22 22 22 4 2 3
Position 1-25 26-47 48-69 70-91 92-95 96-97 98-100
1 Control Record TP_CD SP     0010 CT CTL
2 Trading Partner Header Flexfields TP_CD SP     0020 A1 TH1
3 Trading Partner Header Flexfields TP_CD SP     0030 A2 TH2
4 Trading Partner Header Flexfields TP_CD SP     0040 A2 TH3
5 Trading Partner Header Flexfields TP_CD SP     0050 A2 TH4
8 Planning Schedule Header TP_CD SP     1000 HD FRC
9 Planning Schedule Header TP_CD SP     1010 SP SU
10 Planning Schedule Header TP_CD SP     1020 AD SS
11 Planning Schedule Header TP_CD SP     1030 CN SS
12 Planning Schedule Header TP_CD SP     1050 AX ST1
13 Planning Schedule Header TP_CD SP     1060 ST ST2
14 Schedule Header Flex Fields TP_CD SP     1500 A1 SH1
15 Schedule Header Flex Fields TP_CD SP     1510-1530 A2 SH2-SH4
16 Supplier Flex Fields TP_CD SP     1600 A1 VN1
17 Supplier Flex Fields TP_CD SP     1610-1630 A2 VN2-VN4
18 Supplier Site Flex Fields TP_CD SP     1650 A1 VS1
19 Supplier Site Flex Fields TP_CD SP     1660-1680 A2 VS2-VS4
20 Shipping Organization Flex Fields TP_CD SP     1700 A1 ST1
21 Shipping Organization Flex Fields TP_CD SP     1710-1730 A2 ST2-ST4
22 Ship To Options Flex Fields TP_CD SP     1750 A1 OP1
23 Ship To Options Flex Fields TP_CD SP     1760-1780 A2 OP2-OP4
24 Extension Tables: Schedule Level TP_CD SP     1900 EX
25 Basic Item Data TP_CD SP ITEM   2000 IT IT1
26 Product Description TP_CD SP ITEM   2010 IT IT2
27 Hazardous Material Data TP_CD SP ITEM   2020 HZ HZ1
28 Contact Names TP_CD SP ITEM   2030 CN IT1
29 Last Receipt Data TP_CD SP ITEM   2040 LS LS1
30 Ship to Organization Address/Code TP_CD SP ITEM   2050 AX SI2
31 Ship to Organization Data TP_CD SP ITEM   2060 ST SI3
32 Approved Supplier List Flex Fields TP_CD SP ITEM   2100 A1 AS1
33 Approved Supplier List Flex Fields TP_CD SP ITEM   2110-2130 A2 AS2-AS4
34 Item Flex Fields TP_CD SP ITEM   2150 A1 IT1
35 Item Flex Fields TP_CD SP ITEM   2160-2180 A2 IT2-IT4
36 Ship to Organization Flex Fields (item) TP_CD SP ITEM   2200 A1 DI1
37 Ship to Organization Flex Fields (item) TP_CD SP ITEM   2210-2230 A2 DI2-DI4
38 Organization Option Flex Fields TP_CD SP ITEM   2250 A1 SO1
39 Organization Option Flex Fields TP_CD SP ITEM   2260-2280 A2 SO2-SO4
40 Schedule Item Flex Fields TP_CD SP ITEM   2300 A1 SI1
41 Schedule Item Flex Fields TP_CD SP ITEM   2310-2330 A2 SI2-SI4
42 Extension Tables: Item Level TP_CD SP ITEM   2900 EX
43 Forecast Dates, Authorization,
Receipt Data 		TP_CD SP ITEM SCHEDULE 4000 SC SCH
44 Extension Tables: Forecast Level TP_CD SP ITEM SCHEDULE 4900 EX
Table 1 - 81. (Page 3 of 3)

See Also

Outbound Planning Schedule and Shipping Schedule Data File Definition

         Previous  Next          Contents  Index  Navigation  Glossary  Library