Previous  Next          Contents  Index  Navigation  Glossary  Library

Inbound Price / Sales Catalog and Response to Request for Quote Data File Organization

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

Record Occurrences within the Transaction

Records Content Occurrences
0010 EDI Gateway Control Record Only one record occurrence per transaction
1000-1999 Transaction Header Only one set of records per price/sales catalog
2000-2999 Transaction Item One set of item records per item within the transaction.
Table 1 - 36. (Page 1 of 1)

Record Summary

Seq. Type of Data Data Level Record Number Notes
1 Control Record CONTROL 0010
2 Transaction Identification TRANSACTION HEADER 1000
3 Currency, Payment Terms TRANSACTION HEADER 1010  
4 FOB, Carrier, Freight Terms TRANSACTION HEADER 1020  
5 Miscellaneous Header Data TRANSACTION HEADER 1030  
6 Action Type, Group Code TRANSACTION HEADER 1040  
7 Note to Vendor TRANSACTION HEADER 1050  
8 Note to Receiver TRANSACTION HEADER 1060  
9 Comments TRANSACTION HEADER 1070  
10 Ship to Address TRANSACTION HEADER 1100  
11 Bill to Address TRANSACTION HEADER 1110  
12 Vendor Data TRANSACTION HEADER 1120  
13 Header Flex Fields 1-4, Context TRANSACTION HEADER 1200 Flexfields
14 Header Flex Fields 5-9 TRANSACTION HEADER 1210 Flexfields
15 Header Flex Fields 10-14 TRANSACTION HEADER 1220 Flexfields
16 Header Flex Fields 15 TRANSACTION HEADER 1230 Flexfields
17 Item Identification TRANSACTION ITEM 2000
18 Quantity, Description TRANSACTION ITEM 2010
19 Prices, Dates TRANSACTION ITEM 2020
20 Payment Terms (Item Level) TRANSACTION ITEM 2030
21 FOB, Carrier, Freight Terms (Item Level) TRANSACTION ITEM 2040
22 Hazardous data, Weight,
Volume, Lead Time 		TRANSACTION ITEM 2050  
23 Tax TRANSACTION ITEM 2060  
24 Note to Vendor (Item Level) TRANSACTION ITEM 2070  
26 Ship To Data (Item Level) TRANSACTION ITEM 2100  
26 Line Level Flex Field 1-4, Context TRANSACTION ITEM 2200 Flexfields
27 Line Level Flex Field 5-9 TRANSACTION ITEM 2210 Flexfields
28 Line Level Flex Field 10-14 TRANSACTION ITEM 2220 Flexfields
29 Line Level Flex Field 15 TRANSACTION ITEM 2230 Flexfields
30 Shipment Flex Field 1-4, Context TRANSACTION ITEM 2240 Flexfields
31 Shipment Flex Field 5-9 TRANSACTION ITEM 2250 Flexfields
32 Shipment Flex Field 10-14 TRANSACTION ITEM 2260 Flexfields
33 Shipment Flex Field 15 TRANSACTION ITEM 2270 Flexfields
34 Item Level Flex Field 1-4, Context TRANSACTION ITEM 2280 Flexfields
35 Item Level Flex Field 5-9 TRANSACTION ITEM 2290 Flexfields
36 Item Level Flex Field 10-14 TRANSACTION ITEM 2300 Flexfields
37 Item Level Flex Field 15 TRANSACTION ITEM 2310 Flexfields
Table 1 - 37. (Page 2 of 2)

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

Records Content Occurrences
1-25 TP_CD Trading Partner Code as defined in the EDI Translator
26-47 DOC Transaction Identification from trading partner
48-69 ITEM Supplier Item Number
70-91 (blank) Not Used
92-95 (varies) Record Number
96-97 (varies) Record Layout
98-100 (varies) Record Layout Qualifier
Table 1 - 38. (Page 2 of 2)

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

Seq. Record TP_CD Reference 1 Reference 2 Reference 3 Record Number Record Layout Record 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     0010 CT CTL
2 Transaction Identification TP_CD DOC     1000 HA HD1
3 Currency, Payment Terms TP_CD DOC     1010 HB HD2
4 FOB, Carrier, Freight Terms TP_CD DOC     1020 HC HD3
5 Miscellaneous Header Data TP_CD DOC     1030 HD HD4
6 Action Type, Group Code TP_CD DOC     1040 HE HD5
7 Note to Vendor TP_CD DOC     1050 NT HVN
8 Note to Receiver TP_CD DOC     1060 NT HRC
9 Comments TP_CD DOC     1070 NT HCM
10 Ship to Address TP_CD DOC     1100 AD ST1
11 Bill to Address TP_CD DOC     1110 AD BT1
12 Vendor Data TP_CD DOC     1120 VN VN1
13 Header Flex Fields 1-4, context TP_CD DOC     1200 A1 HD1
14 Header Flex Fields 5-9 TP_CD DOC     1210 A2 HD2
15 Header Flex Fields 10-14 TP_CD DOC     1220 A2 HD3
16 Header Flex Fields 15 TP_CD DOC     1230 A2 HD4
17 Item Identification TP_CD DOC ITEM   2000 IA IT1
18 Quantity, Description TP_CD DOC ITEM   2010 IB IT2
19 Prices, Dates TP_CD DOC ITEM   2020 IC IT3
20 Payment Terms (Item Level) TP_CD DOC ITEM   2030 ID IT4
21 FOB, Carrier, Freight Terms (Item Level) TP_CD DOC ITEM   2040 IE IT5
22 Hazardous data, Weight,
Volume, Lead Time 		TP_CD DOC ITEM   2050 IF IT6
23 Tax TP_CD DOC ITEM   2060 IG IT7
24 Note to Vendor (Item Level) TP_CD DOC ITEM   2070 NT DVN
25 Ship To Data (Item Level) TP_CD DOC ITEM   2100 AD SH2
26 Line Level Flex Field 1-4, Context TP_CD DOC ITEM   2200 A1 LN1
27 Line Level Flex Field 5-9 TP_CD DOC ITEM   2210 A2` LN2
28 Line Level Flex Field 10-14 TP_CD DOC ITEM   2220 A2` LN3
29 Line Level Flex Field 15 TP_CD DOC ITEM   2230 A2` LN4
30 Shipment Flex Field 1-4, Context TP_CD DOC ITEM   2240 A1 SH1
31 Shipment Flex Field 5-9 TP_CD DOC ITEM   2250 A2` SH2
32 Shipment Flex Field 10-14 TP_CD DOC ITEM   2260 A2` SH3
33 Shipment Flex Field 15 TP_CD DOC ITEM   2270 A2` SH4
34 Item Level Flex Field 1-4, Context TP_CD DOC ITEM   2280 A1 IT1
35 Item Level Flex Field 5-9 TP_CD DOC ITEM   2290 A2` IT2
36 Item Level Flex Field 10-14 TP_CD DOC ITEM   2300 A2` IT3
37 Item Level Flex Field 15 TP_CD DOC ITEM   2310 A2` IT4

Table 1 - 39. (Page 1 of 1)

See Also

Inbound Price / Sales Catalog and Response to Request for Quote Data File Definition

         Previous  Next          Contents  Index  Navigation  Glossary  Library