879 Price Information Advice

To use the Unit Cost Price Information Transaction Set (879) with an EDI environment, follow the guidelines in this article.

Note: You can also download this information in Word format: 7

Functional Group PC

This X12 Transaction Set contains the format and establishes the data contents of the Unit Cost Price Information Transaction Set (879) for use within the context of an Electronic Data Interchange (EDI) environment. This transaction set can be used to enable a manufacturer, supplier, broker, or agent to provide a trading partner with pricing information.

Heading

Pos	Id	Segment Name	Req	Max Use	Repeat	Usage
0100	ST	Transaction Set Header	M	1		Must use
0200	G91	Price Change Status	M	1		Must use
LOOP ID – 0100					1
0400	N1	Party Identification	M	1		Must use
1600	G62	Date/Time	M	1		Must use

Detail

Pos	Id	Segment Name	Req	Max Use	Repeat	Usage
LOOP ID – 0200					>1
0200	G28	Line Item Numbers	M	1		Must Use
0300	G69	Line Item Description	O	1		Used
0550	G62	Date/Time	O	1		Used
LOOP ID – 0210					1
0650	G40	Bracket Price	M	1		Must Use

Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
0700	CTT	Transaction Totals	M	1			Must use
0750	SE	Transaction Set Trailer	M	1			Must use

Sample Spec 879 File

ISA*00*          *00*          *ZZ*TEST999999W    *01*12571829       *200207*1315*U*00401*000001985*0*P*>
GS*QG*TEST999999W*12571829*20200207*1315*1985*X*004010
ST*879*1985
G91*B
N1*VN*WM Distributing*92*44103001
G62*09*20200207
G28**0019254569598*VN*15MCP0011DXREF
G69*Product Item descriptions
G62*87*20200207
G40**429.00*****EA
G28**0081947202254*VN*MBPR16LDG01
G62*87*20200207
G40**38.45*****EA
G28**0081947202255*VN*MBPR16LDG01CL
G62*87*20200207
G40**51.78*****EA
G28**0081947202256*VN*MBPR16LDG01KL
G62*87*20200207
G40**51.78*****EA
G28**0081788202888*VN*ULEDATUS
G62*87*20200207
G40**128.67*****EA
CTT*5
SE*21*1985
GE*1*1985
IEA*1*000001985

ST Transaction Set Header

To indicate the start of a transaction set and to assign a control number

Pos: 0100
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Usage
ST01	143	Transaction Set Identifier Code Description: Code Uniquely identifying a Transaction Set All valid standard codes are used(Total codes: 318)	M	ID	3/3	Must use
ST02	329	Transaction Set Control Number Description: Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set	M	AN	4/9	Must use
ST03	1705	Implementation convention Reference Description: Reference assigned to identify implementation convention	O	AN	1/35	Used

Semantics

The transaction set identifier (ST01) is used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the invoice Transaction Set).
The Implementation convention reference (ST03) is used by the translation routines of the interchange partners to select the appropriate implementation convention to match the transaction set definition. When used, this implementation convention reference takes precedence over the implementation reference specified in the GS08.

G91 Price Change Status

To enable the supplier/broker to change pricing information

Pos: 0200
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 1

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G9101

259

Change Type Code
Description: Code indicating change type
Code List Summary(Total Codes: 21, included: 1)

Code	Name
B	Original Price Change Transaction

1/1

Must use

Loop Party Identification

To identify a party by type of organization, name and code

Pos: 0400
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 1

Loop Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
0400	N1	Party Identification	M	1			Must Use

N1 Party Identification

To identify a party by type of organization, name, and code

Pos: 0400
Max: 1
Heading – Mandatory
Loop: 0100
Elements: 4

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

N101

Entity Identifier Code
Description: Code Uniquely identifying an organizational entity, a physical location, property or an individual
Code List Summary(Total codes: 1500, included: 1)

Code	Name
VN	Vendor

User Note 1:Mandatory

2/3

Must use

N102

Name
Description: Free-form name
User Note 1: Mandatory when N101=VN

1/60

Must use

N103

Identification Code Qualifier
Description: Code designating the system/method of code structure used for identification code (67)
Code List Summary (Total codes: 241, included: 1)

Code	Name
92	Assigned by Buyer or Buyer’s Agent

1/2

Must use

N104

Identification Code
Description: Code identifying a party or other code (Walmart Drop Ship Vendor – Distributor ID/Facility ID depending upon the updates and your account configuration).

2/80

Must use

Syntax Rules

R0203 – At least one of N102 or N103 is required
P0304 – If either N103 or N104 is present, then the other is required

Comments

This segment, when used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency, the “ID Code” (N104) must provide a key to the table maintained by the transaction processing party.
N105 and N106 further define the type of entity in N101 (N105 and N106 are not used here).

G62 Date/Time

To specify pertinent dates and times.

Pos: 1600
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 2

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G6201

432

Date Qualifier
Description: Code specifying type of date
Code List Summary (Total Codes: 139, included: 1)

Code	Name
09	Process Date

2/2

Used

G6202

373

Date
Description: Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year.

8/8

Used

Syntax Rules

R0103 – At least one of G6201 or G6203 is required.
P0102 – If either G6201 or G6202 is present, then the other is required.
P0304 – If either G6203 or G6204 is present, then the other is required (G6203 or G6204 is not used here).

Loop Line Item Numbers

To provide basic product identification information.

Pos: 0200
Repeat: >1
Detail – Mandatory
Loop: 0200
Elements: N/A

Loop Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Usage
0200	G28	Line Item Numbers	M	1		Must Use
0300	G69	Line Item Description	O	5		Used
0550	G62	Date/Time	O	4		Used
0650		Loop 0210	M		100	Must Use

G28 Line Item Numbers

To provide basic product identification information.

Pos: 0200
Max: 1
Detail – Mandatory
Loop: 0200
Elements: 3

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G2802

766

U.P.C./EAN Consumer Package Code
Description: Walmart UPC Code Uniquely identifying the retail shelf unit.

13/13

Must Use

G2803

235

Product/Service ID Qualifier
Description: Code identifying the type/source of the descriptive number used in Product/Service ID (234).
Code List Summary (Total Codes: 519, included: 1)

Code	Name
VN	Vendor’s (Seller’s) Item/SKU number

2/2

Must Use

G2804

234

Product/Service ID
Description: Identifying number for a product or service (Vendor SKU).

1/48

Must Use

Syntax Rules

R010203 – At least one of G2801, G2802 or G2803 is required.
P0304 – If either G2803 or G2804 is present, then the other is required.
P0506 – If either G2805 or G2806 is present, then the other is required (G2805 or G2806 is not used here).

G69 Line Item Description

To specify the item description for which you want to update the unit cost.

Pos: 0300
Max: 1
Detail – Optional
Loop: 0200
Elements: 1

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Usage
G6901	369	Free Form Description	M	AN	1/45	Must Use

G62 Date/Time

To specify pertinent dates and times.

Pos: 0550
Max: 1
Detail – Optional
Loop: 0200
Elements: 2

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G6201

432

Date Qualifier
Description: Code specifying type of date
Code List Summary (Total Codes: 139, included: 1)

Code	Name
87	First Order Date

2/2

Used

G6202

373

Date
Description: Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year

8/8

Used

Syntax Rules

R0103 – At least one of G6201, or G6203 is required.
P0102 – If either G6201 or G6202 is present, then the other is required.
P0304 – If either G6203 or G6204 is present, then the other is required (G6203 or G6204 is not used here).

Loop Bracket Price

To provide a vendor’s pricing structure associated with a specific line item.

Pos: 0650
Repeat: 1
Detail – Mandatory
Loop: 0210
Elements: N/A

Loop Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
0650	G40	Bracket Price	M	1			Must Use

G40 Bracket Price

To provide a vendor’s pricing structure associated with a specific line item.

Pos: 0650
Max: 1
Detail – Mandatory
Loop: 0210
Elements: 3

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G4001

417

Price Bracket Identifier
Description: Identifier assigned by the vendor for a specific price bracket.

1/3

Used

G4002

418

Item List Cost – New
Description: Unit Cost Price within the appropriate price bracket for a line item.

1/9

Must Use

G4007

355

Unit or Basis for Measurement Code
Description: Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken.
Code List Summary (Total Codes: 844, included: 1)

Code	Name
EA	Each

2/2

Must Use

Semantics

G4009 is the shipping unit to billing unit conversion factor (G4009 is not used here).

Comments

G4007 is the invoicing unit of measure for the costs specified in G4002 and G4003.

CTT Transaction Totals

To transmit a hash total for a specific element in the transaction set.

Pos: 0700
Max: 1
Summary – Mandatory
Loop: N/A
Elements: 1

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Usage
CTT01	354	Number of Line Items	M	N0	1/6	Must Use

Comments

Number of G28 segments in the transaction set.

SE Transaction Set Trailer

To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments).

Pos: 0750
Max: 1
Summary – Mandatory
Loop: N/A
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Usage
SE01	96	Number of Included Segments Description: Total number of segments included in a transaction set including ST and SE segments.	M	N0	1/10	Must Use
SE02	329	Transaction Set Control Number Description: Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set.	M	AN	4/9	Must Use

Comments

SE is the last segment of each transaction set.

Version

Indicate the version number in ISA and GS segment Version number as 004010

Data Transfer - EDI

Functional Group PC

Heading

Detail

Summary

ST Transaction Set Header

Element Summary

Semantics

G91 Price Change Status

Element Summary

Loop Party Identification

Loop Summary

N1 Party Identification

Element Summary

Syntax Rules

Comments

G62 Date/Time

Element Summary

Syntax Rules

Loop Line Item Numbers

Loop Summary

G28 Line Item Numbers

Element Summary

Syntax Rules

G69 Line Item Description

Element Summary

G62 Date/Time

Element Summary

Syntax Rules

Loop Bracket Price

Loop Summary

G40 Bracket Price

Element Summary

Semantics

Comments

CTT Transaction Totals

Element Summary

Comments

SE Transaction Set Trailer

Element Summary

Comments

Version