Previous  Next          Contents  Index  Navigation  Glossary  Library

Inbound Purchase Order Data File Organization

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

Record Summary

Seq. Data Data Level Record Number Note
1 Control Record CONTROL 0010
4 Basic Purchase Order Header PURCHASE ORDER HEADER 1000
5 Payment Terms, Other PO Header Data PURCHASE ORDER HEADER 1010  
6 Basic Purchase Order Header PURCHASE ORDER HEADER 1020  
7 Purchase Order Flexfields PURCHASE ORDER HEADER 1040-1070 Flexfields
8 Ship to Address/Code (header level) PURCHASE ORDER HEADER 1190
9 Ship to Contacts (header level) PURCHASE ORDER HEADER 1200
10 Bill to Address/Code PURCHASE ORDER HEADER 1210
11 Bill to Contact PURCHASE ORDER HEADER 1220
12 Buyer Name PURCHASE ORDER HEADER 1230
13 Basic Purchase Order Header Data PURCHASE ORDER HEADER 1240  
14 Header Level Shipping Instructions PURCHASE ORDER HEADER 1250  
15 Basic Purchase Order Header Data PURCHASE ORDER HEADER 1260  
16 Extension Tables:
Purchase Order Header Data 		PURCHASE ORDER HEADER 1900 (Custom)
17 Basic Item Data PURCHASE ORDER ITEM 2000
18 Basic Item Data in Item Segments (2-6) PURCHASE ORDER ITEM 2120
19 Basic Item Data in Item Segments (7-11) PURCHASE ORDER ITEM 2130
20 Basic Item Data in Item Segments (12-16) PURCHASE ORDER ITEM 2140
21 Basic Item Data in Item Segments (17-20) PURCHASE ORDER ITEM 2150
22 Pricing Flexfields PURCHASE ORDER ITEM 2160-2190 Flexfields
23 Basic Item Data PURCHASE ORDER ITEM 2200
24 Purchase Order Item Flexfields PURCHASE ORDER ITEM 3010-3040 Flexfields
25 Ship to Address (Item Level) PURCHASE ORDER ITEM 3050  
26 Ship to Contact (Item Level) PURCHASE ORDER ITEM 3060  
28 Extension Tables:
Purchase Order Item Data 		PURCHASE ORDER ITEM 3900 (Custom)
Table 1 - 40.

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 Purchase order line number
70-91 (blank)
Table 1 - 41.

Seq. Data Trading Partner Reference 1 Reference 2 Reference 3 Record Number Record Layout Record Layout Qualifier
Length 25 22 224 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
8 Basic Purchase Order Header TP_CD PO     1000 PO PO1
9 Payment Terms, Other PO Header Data TP_CD PO     1010 PO PO2
10 Basic Purchase Order Header TP_CD PO     1020 PO PO3
11 Purchase Order Flexfields TP_CD PO     1040 A1 PO1
12 Purchase Order Flexfields TP_CD PO     1050 A2 PO2
13 Purchase Order Flexfields TP_CD PO     1060 A2 PO3
14 Purchase Order Flexfields TP_CD PO     1070 A2 PO4
15 Ship to Address/code TP_CD PO     1190 AD ST1
16 Ship to Contacts TP_CD PO     1200 CN ST1
17 Bill to Address/Code TP_CD PO     1210 AD BT1
18 Bill to Contact TP_CD PO     1220 CN BT1
19 Buyer Name TP_CD PO     1230 PO PO4
20 Basic Purchase Order Header TP_CD PO     1240 PO PO5
21 Shipping Instruction (Header level) TP_CD PO     1250 PO PO6
22 Basic Purchase Order Header TP_CD PO     1260 PO PO7
23 Extension Tables:
Purchase Order Header Data 		TP_CD PO     1900 (Custom)
24 Basic Item Data TP_CD PO ITEM   2000 IT IT1
25 Item Data in Segments (2-6) TP_CD PO ITEM   2120 IT IT2
26 Item Data in Segments (7-11) TP_CD PO ITEM   2130 IT IT3
27 Item Data in Segments (12-16) TP_CD PO ITEM   2140 IT IT4
28 Item Data in Segments (17-20) TP_CD PO ITEM   2150 IT IT5
29 Pricing Flexfields TP_CD PO ITEM   2160 A1 PR1
30 Pricing Flexfields TP_CD PO ITEM   2170 A2 PR2
31 Pricing Flexfields TP_CD PO ITEM   2180 A2 PR3
32 Pricing Flexfields TP_CD PO ITEM   2190 A2 PR4
33 Basic Item Data TP_CD PO ITEM   2200 IT IT6
34 Purchase Order Item Flexfields TP_CD PO ITEM   3010 A1 IT1
35 Purchase Order Item Flexfields TP_CD PO ITEM   3020 A2 IT2
36 Purchase Order Item Flexfields TP_CD PO ITEM   3030 A2 IT3
37 Purchase Order Item Flexfields TP_CD PO ITEM   3040 A2 IT4
38 Ship To Address/Code (Item Level) TP_CD PO ITEM   3050 AX ST2
39 Ship To Contact (Item Level) TP_CD PO ITEM   3060 CN ST2
41 Extension Tables:
Purchase Order Item Data 		TP_CD PO     3900   (Custom)
Table 1 - 42. (Page 4 of 4)

See Also

Inbound Purchase Order Data File Definition

         Previous  Next          Contents  Index  Navigation  Glossary  Library