Section title: X12 EDI Examples
back to previous

ASC X12 Version: 004010 | Transaction Set: 832 | TR3 ID: 004010X353

Example 2 - Sales Catalog

New Haven Electronics Inc. is sending a sales catalog to their trading partner that includes four items. More items will be added later to this catalog. New Haven Electronics is a source for electronic components. The catalog changes monthly, with a new catalog issued on the 15TH of each month and effective on the 21st of the month. Pricing is handled separately from this catalog.

The Table 1/Header part of the transaction provides information pertinent to the catalog and trade party relationship, including customer support contact information, the catalog effective date, ordering restrictions, and name/address information of the seller.

The Table 2/Detail part of the transaction provides information for 5 items, including item identification, order restrictions for a line, and item descriptions - both freeform and semi-structured based on UNSPSC (United Nations Standard Product and Service Code) industry standard commodity codes.

This is an example of a more complex sales catalog which includes standardized and freeform item category information as well as item measurements, tier pricing and effective dates.

Transmission Explanation

Table 1

ST*832*1001~

Indicates the start of a price/sales catalog transaction set and assigns a control number of 1001.

BCT*SC*20200001*******NEW HAVEN ELECTRONICS CATALOG*00~

This is a sales catalog (SC), catalog version 20200001. The catalog description/name is New Haven Electronics Catalog. This is an original (00) transaction.

PER*SU*CUSTOMER SUPPORT*TE*888-555-0748*EM*CUSTOMERSUP@NEWHAVEN ELECTRONICS.COM~

The supplier's (SU) Customer Support group can be reached by telephone (TE) at 888-555-0748 or using email (EM) at customersup@newhavenelectronics.com.

DTM*007*20200621~

The catalog effective date (007) is June 21, 2020. This pertains to all items in the catalog.

DTM*036*20200720~

The catalog expiration date (036) is July 20, 2020. This pertains to all items in the catalog.

CTB*OR**57*4~

There is an order restriction (OR) on the catalog. The minimum order quantity for items in the catalog is 4.

N1*SE*NEW HAVEN ELECTRONICS*1*9876543211~

The selling entity (SE) is New Haven Electronics, with a DUNS (1) number of 9876543211.

N2*CATALOG SUPPORT DEPARTMENT~

The address pertains to the Catalog Support Department.

N3*666 HARPER AVENUE*SUITE 200~

The street address is 666 HARPER Avenue, Suite 200.

N4*NORTH HOLLYWOOD*CA*94001~

The location address is North Hollywood, CA, 94001.

N9*AH*NHE-20200589~

The transaction references agreement number (AH) NHE-20200589.

Table 2

LIN*1*VN*12336206*MG*12336206*MF*AMERICAN TRANS-COIL~

Line item 1 references vendor item number (VN) 12336206, with manufacturer part number (MG) 12336206, and the manufacturer (MF) is American Trans-Coil.

DTM*007*20200621~

The item effective date (007) is June 21, 2020.

CTB*OR**57*2~

There is an order restriction (OR) on this item. The minimum order quantity (57) is two.

PID*F****ISOLATOR RADIO FREQ~

The freeform product description (F) is Isolator Radio Frequency.

LIN*2*VN*1N1616JAN*MG*1N1616JAN*MF*GENERAL ELECTRIC CORP~

Line item 2 references vendor item number (VN) 1N161JAN, with manufacturer part number (MG) 1N1616JAN, and the manufacturer (MF) is General Electric Corporation.

DTM*007*20200621~

The item effective date (007) is June 21, 2020.

CTB*OR**57*5~

There is an order restriction (OR) on this item. The minimum order quantity (57) is five.

PID*F****DIODE~

The freeform product description (F) is Diode.

LIN*3*VN*9400CN*MG*9400CN*MF*TELEDYNE CORP~

Line item 3 references vendor item number (VN) is 9400CN, with manufacturer part number (MG) 9400CN, and the manufacturer (MF) is Teledyne Corporation.

DTM*007*20200621~

The item effective date (007) is June 21, 2020.

CTB*OR**57*5~

There is an order restriction (OR) on this item. The minimum order quantity for this item is five.

PID*F****INTEGRATED CIRCUIT~

The freeform item description (F) is Integrated Circuit.

LIN*4*VP*XXX1001*PD*AAA BATTERY*MF*BATTERY CO.*MG*BAT1234-5~

Line item 4 references vendor's part number (VP) XXX1001, the product description (PD) is AAA Battery, the manufacturer (MF) is Battery Co., and the manufacturer part number (MG) is BAT1234-5.

DTM*007*20200621~

The item effective date (007) is June 21, 2020.

CTB*OR**57*1~

There is an order restriction (OR) on this item. The minimum order quantity (57) is one.

As part of providing the item information, many suppliers/manufacturers provide item classification information to their trade partners. For the LIN*4 battery, the supplier provides product category information using the PID segment. AIA approved options include using a standard commodity code system, such as UNSPSC, or using a proprietary category system that follows the UNSPSC structure.

For the proprietary category system, PID05 and PID06 carry the classification information. Four freeform PID segments are transmitted. The UNSPSC hierarchy level name is sent in PID05. For PID06-Surface/Layer/Position, the trade parties have agreed to use codes R1 through R4 to correlate to UNSPSC hierarchy levels (R1 Segment, R2 Family, R3 Class, R4 Commodity) pertaining to the PID05 value.
 PID*F****POWER GENERATION AND DISTRIBUTION MACHINERY AND ACCESSORIES*R1~
 PID*F****BATTERIES, GENERATORS AND KINETIC POWER TRANSMISSION*R2~
 PID*F****PID*F****BATTERIES AND ACCESSORIES*R3~
 PID*F****ALKALINE BATTERIES*R4~

If using UNSPSC categorization with industry standard commodity codes, four semi-structured PID segments are transmitted. For the alkaline battery item example, the UNSPSC hierarchy classification 26111702 is broken-down into the four hierarchy levels as follows:
 Segment 26 Power Generation and Distribution Machinery and Accessories
 Family 11 Batteries, Generators and Kinetic Power Transmission
 Class 17 Batteries and Accessories
 Commodity 02 Alkaline Batteries

The following four PID*X segments illustrate the semi-structured approach using PID data elements 01, 03, 04, 05, 06 and 07. (The trade parties have agreed to use code ZZ in PID03 (data element 559 - Agency Qualifier Code) to represent the UNSPSC classification since code UA (UNSPSC) is not available in X12 version 004010.)

PID*X**ZZ*26*POWER GENERATION AND DISTRIBUTION MACHINERY AND ACCESSORIES*R1*UNSPSC~

This is a semi-structured (X) description, using (ZZ) to represent the United Nations Standard Product and Service Code (UNSPSC), with (Segment) categorization code 26, and a description of Power Generation and Distribution Machinery and Accessories. R1 is the Surface/Layer/Position Segment level referencing code list UNSPSC.

PID*X**ZZ*11*BATTERIES, GENERATORS AND KINETIC POWER TRANSMISSION*R2*UNSPSC~

This is a semi-structured (X) description, using (ZZ) to represent the United Nations Standard Product and Service Code (UNSPSC), with (Family) categorization code 11, and a description of Batteries, Generators and Kinetic Power Transmission. R2 is the Surface/Layer/Position Family level referencing code list UNSPSC.

PID*X**ZZ*17*BATTERIES AND ACCESSORIES*R3*UNSPSC~

This is a semi-structured (X) description, using (ZZ) to represent the United Nations Standard Product and Service Code (UNSPSC), with (Class) categorization code 17, and a description of Batteries, and accessories. R3 is the Surface/Layer/Position Class level referencing code list UNSPSC.

PID*X**ZZ*02*ALKALINE BATTERIES*R4*UNSPSC~

This is a semi-structured (X) description, using (ZZ) to represent the United Nations Standard Product and Service Code (UNSPSC), with (Commodity) categorization code 02, and a description of Batteries, and accessories. R4 is the Surface/Layer/Position Commodity level referencing code list UNSPSC.

PID*F****ALKALINE BATTERIES TYPE AAA~

The freeform item description (F) is Alkaline Batteries Type AAA.

PO4*8***PKG~

There are 8 eaches (batteries) inside a package (PKG).

TD4*HM~

The item has a hazardous material (HM) designation.

LDT*AE*2*DW~

The product lead time from the date of the purchase order receipt to shipment (AE) is two workdays (DW).

N9*URL*HTTP://WWW.BATTERY.COM/TAAA/BATT1234-5~

The URL for battery information is http://www.battery.com/taaa/batt1234-5.

LIN*5*MG*NMB43-FT*VP*583XX*MF*WIRE & CABLE INC~

Line item 5 references manufacturer part number (MG) NMB43-FT, the vendor part number (VP) is 583XX, and the manufacturer (MF) is Wire & Cable Inc.

DTM*007*20200621~

The item effective date (007) is June 21, 2020.

PID*F****4-3 W/G NM-B WIRE BLACK,1000 FEET~

The freeform item description (F) is 4-3 W/G NM-B Wire, Black, 1,000 feet in length.

MEA*PD*DI*1.666*IN~

The MEA segment provides a physical dimension (PD) of the wire. The diameter (DI) is 1.666 inches (IN).

PO4**1*RL*REL******1000***FT~

There is 1 reel (RL). The packaging code is reel (REL). It is 1000 feet (FT) long.

TD4*FR~

The item has a fragile (FR) designation.

CTP**PBQ**1*EA~

This segment starts step ladder unit pricing from a quantity (PBQ) of 1 each (EA). The following CTP segments provide the price breaks at 10, 20, 30, and 50 units. The DTM segments provide the price effective date range.

DTM*007*20200625~

The item price effective date (007) is June 25, 2020.

DTM*036*20200720~

The item price expiration date (036) is July 20, 2020.

CTP**ICL*1150*10*EA~

For a quantity up to (ICL) 10 units, the price is $1150 each.

CTP**ICL*1125*20*EA~

For a quantity from 11 units up to (ICL) 20 units, the price is $1125 each.

CTP**ICL*1115*30*EA~

For a quantity from 21 units up to (ICL) 30 units, the price is $1115 each.

CTP**MAX*1100*50*EA~

For a quantity from 31 units up to a maximum (MAX) of 50 units, the price is $1100 each.

Table 3

CTT*5~

Indicates that the product activity data transaction contains five-line items.

SE*50*1001~

Indicates that the product activity transaction, with transaction set control number 1001, has ended with a total of 50 segments.

Transmission

ST*832*1001~BCT*SC*20200001*******NEW HAVEN ELECTRONICS CATALOG*00~PER*SU*CUSTOMER SUPPORT*TE*888-555-0748*EM*CUSTOMERSUP@NEWHAVEN ELECTRONICS.COM~DTM*007*20200621~DTM*036*20200720~CTB*OR**57*4~N1*SE*NEW HAVEN ELECTRONICS*1*9876543211~N2*CATALOG SUPPORT DEPARTMENT~N3*666 HARPER AVENUE*SUITE 200~N4*NORTH HOLLYWOOD*CA*94001~N9*AH*NHE-20200589~LIN*1*VN*12336206*MG*12336206*MF*AMERICAN TRANS-COIL~DTM*007*20200621~CTB*OR**57*2~PID*F****ISOLATOR RADIO FREQ~LIN*2*VN*1N1616JAN*MG*1N1616JAN*MF*GENERAL ELECTRIC CORP~DTM*007*20200621~CTB*OR**57*5~PID*F****DIODE~LIN*3*VN*9400CN*MG*9400CN*MF*TELEDYNE CORP~DTM*007*20200621~CTB*OR**57*5~PID*F****INTEGRATED CIRCUIT~LIN*4*VP*XXX1001*PD*AAA BATTERY*MF*BATTERY CO.*MG*BAT1234-5~DTM*007*20200621~CTB*OR**57*1~PID*X**ZZ*26*POWER GENERATION AND DISTRIBUTION MACHINERY AND ACCESSORIES*R1*UNSPSC~ PID*X**ZZ*11*BATTERIES,GENERATORS AND KINETIC POWER TRANSMISSION*R2*UNSPSC~PID*X**ZZ*17*BATTERIES AND ACCESSORIES*R3*UNSPSC~PID*X**ZZ*02*ALKALINE BATTERIES*R4*UNSPSC~ PID*F****ALKALINE BATTERIES TYPE AAA~PO4*8***PKG~TD4*HM~LDT*AE*2*DW~N9*URL*HTTP://WWW.BATTERY.COM/TAAA/BATT1234-5~LIN*5*MG*NMB43-FT*VP*583XX*MF*WIRE & CABLE INC~DTM*007*20200621~PID*F****4-3 W/G NM-B WIRE BLACK,1000 FEET~MEA*PD*DI*1.666*IN~PO4*1*1*RL*REL******1000***FT~TD4*FR~CTP**PBQ**1*EA~DTM*007*20200625~DTM*036*20200720~CTP**ICL*1150*10*EA~CTP**ICL*1125*20*EA~CTP**ICL*1115*30*EA~CTP**MAX*1100*50*EA~CTT*5~SE*50*1001~