Previous  Next          Contents  Index  Navigation  Glossary  Library

Outbound Purchase Order Data File Organization

The data file produced by this transaction consists of three levels of data: header, line, and shipments.

Each purchase order contains one header record that applies to the entire order. The PO header is followed by one or more PO lines, each representing the item or service purchased. Each line is followed by one or more shipments, each representing a specific shipment scheduled for the line item.

With blanket purchase agreements, each agreement line price break is stored at the PO shipment level. The unit price for items on a blanket release are based on the shipment quantity. If the shipment quantity does not qualify for a price break, the item master unit price is used.

The output file is structured as follows:

Summary Tables

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

Record Summary

Seq. Data Data Level Record Number Note
1 Common Control Record CONTROL 0010
2 Trading Partner Header Flexfields TRADING PARTNER 0020-0050 Flexfields
4 Purchase Order Basic Header PURCHASE ORDER HEADER 1000
5 Payment Terms PURCHASE ORDER HEADER 1010  
6 Purchase Order Basic Header PURCHASE ORDER HEADER 1020  
7 Purchase Order Notes to Supplier PURCHASE ORDER HEADER 1030  
8 Purchase Order Flexfields PURCHASE ORDER HEADER 1040-1070 Flexfields
9 Supplier Flexfields PURCHASE ORDER HEADER 1080-1110 Flexfields
10 Supplier Site Flexfields PURCHASE ORDER HEADER 1120-1150 Flexfields
11 Supplier Site Address/Code PURCHASE ORDER HEADER 1160
12 Supplier Site Contacts PURCHASE ORDER HEADER 1170-1180
13 Ship to Address/code PURCHASE ORDER HEADER 1190
14 Ship to Contacts PURCHASE ORDER HEADER 1200
15 Bill to Address/Code PURCHASE ORDER HEADER 1210
16 Bill to Contact PURCHASE ORDER HEADER 1220
17 Buyer Name PURCHASE ORDER HEADER 1230
18 Extension Tables:
Purchase Order Header Data 		PURCHASE ORDER ITEM 1900 (Custom)
19 Basic Item Data PURCHASE ORDER ITEM 2000
20 Basic Item Data PURCHASE ORDER ITEM 2010
21 Basic Item Data,
Hazardous Material Codes 		PURCHASE ORDER ITEM 2020
22 Item Note to Supplier PURCHASE ORDER ITEM 2030  
23 Line Flexfields PURCHASE ORDER ITEM 2040-2070 Flexfields
24 Line Part Flexfields PURCHASE ORDER ITEM 2080-2110 Flexfields
25 Extension Tables:
Purchase Order Item Data 		PURCHASE ORDER ITEM 2900 (Custom)
26 Basic Shipment Data PURCHASE ORDER SHIPMENT 3000
27 Shipment Flexfields PURCHASE ORDER SHIPMENT 3010-3040 Flexfields
28 Ship To Address/Code PURCHASE ORDER SHIPMENT 3050
29 Ship To Contact PURCHASE ORDER SHIPMENT 3060
30 Extension Tables:
Purchase Order Item Data 		PURCHASE ORDER SHIPMENT 3900 (Custom)
Table 1 - 82.

Transaction Specific Data in the Common Key

Position Code Content
1-25 TP_CD Trading Partner Code as defined in the EDI Translator
26-47 PO Purchase order number
48-69 ITEM Item number
70-91 SHIPMENT Shipment Number
Table 1 - 83.

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 PO     0010 CT CTL
2 Trading Partner Header Flexfields TP_CD PO     0020 A3 TH1
3 Trading Partner Header Flexfields TP_CD PO     0030 A4 TH2
4 Trading Partner Header Flexfields TP_CD PO     0040 A4 TH3
5 Trading Partner Header Flexfields TP_CD PO     0050 A4 TH4
8 Purchase Order Basic Header TP_CD PO     1000 PO PO1
9 Payment Terms TP_CD PO     1010 PO PO2
10 Purchase Order Basic Header TP_CD PO     1020 PO PO3
11 Purchase Order Notes to Supplier TP_CD PO     1030 PO PO4
12 Purchase Order Flexfields TP_CD PO     1040 A1 PO1
13 Purchase Order Flexfields TP_CD PO     1050 A2 PO2
14 Purchase Order Flexfields TP_CD PO     1060 A2 PO3
15 Purchase Order Flexfields TP_CD PO     1070 A2 PO4
16 Supplier Flexfields TP_CD PO     1080 A1 SU1
17 Supplier Flexfields TP_CD PO     1090 A2 SU2
18 Supplier Flexfields TP_CD PO     1100 A2 SU3
19 Supplier Flexfields TP_CD PO     1110 A2 SU4
20 Supplier Site Flexfields TP_CD PO     1120 A1 SS1
21 Supplier Site Flexfields TP_CD PO     1130 A2 SS2
22 Supplier Site Flexfields TP_CD PO     1140 A2 SS3
23 Supplier Site Flexfields TP_CD PO     1150 A2 SS4
24 Supplier Site Address TP_CD PO     1160 AD SU1
25 Supplier Site Contact TP_CD PO     1170 CN SS1
26 Supplier Site Contact TP_CD PO     1180 CN SS2
27 Ship to Address/Code TP_CD PO     1190 AX ST1
28 Ship to Contacts TP_CD PO     1200 CN ST1
29 Bill to Address/Code TP_CD PO     1210 AX BT1
30 Bill to Contact TP_CD PO     1220 CN BT1
29 Buyer Name TP_CD PO     1230 PO PO5
30 Extension Tables:
Purchase Order Header Data 		TP_CD PO     1900 (Custom)
31 Basic Item Data TP_CD PO ITEM   2000 IT IT1
32 Basic Item Data TP_CD PO ITEM   2010 IT IT2
33 Basic Item Data,
Hazardous Material Codes 		TP_CD PO ITEM   2020 IT IT3
34 Item Note to Supplier TP_CD PO ITEM   2030 IT IT4
35 Line Flexfields TP_CD PO ITEM   2040 A1 LN1
36 Line Flexfields TP_CD PO ITEM   2050 A2 LN2
37 Line Flexfields TP_CD PO ITEM   2060 A2 LN3
38 Line Flexfields TP_CD PO ITEM   2070 A2 LN4
39 Line Part Flexfields TP_CD PO ITEM   2080 A1 LP1
40 Line Part Flexfields TP_CD PO ITEM   2090 A2 LP2
41 Line Part Flexfields TP_CD PO ITEM   2100 A2 LP3
42 Line Part Flexfields TP_CD PO ITEM   2110 A2 LP4
43 Extension Tables:
Purchase Order Item Data 		TP_CD PO ITEM   2900 (Custom)
44 Basic Shipment Data TP_CD PO ITEM SHIPMENT 3000 SH SH1
45 Shipment Flexfields TP_CD PO ITEM SHIPMENT 3010 A1 SH1
46 Shipment Flexfields TP_CD PO ITEM SHIPMENT 3020 A2 SH2
47 Shipment Flexfields TP_CD PO ITEM SHIPMENT 3030 A2 SH3
48 Shipment Flexfields TP_CD PO ITEM SHIPMENT 3040 A2 SH4
49 Ship To Address/Code TP_CD PO ITEM SHIPMENT 3050 AX SL1
50 Ship To Contact TP_CD PO ITEM SHIPMENT 3060 CN SL1
51 Extension Tables:
Purchase Order Shipment Data 		TP_CD PO ITEM SHIPMENT 3900 (Custom)
Table 1 - 84. (Page 3 of 3)

See Also

Outbound Purchase Order Data File Definition

         Previous  Next          Contents  Index  Navigation  Glossary  Library