879 Price Information Advice
Follow the guidelines in this article to use the Unit Cost Price Information Transaction Set (879) in an EDI environment.
Note: You can also download this information in Word format: Walmart.com Drop Ship Vendor_879_4010_EDI.docx
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 in an Electronic Data Interchange (EDI) environment. This transaction set can enable a manufacturer, supplier, broker, or agent to provide a trading partner with pricing information.
Heading
| Pos | Id | Segment Name | Req | Max Use | Repeat | Notes | 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 | Notes | 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 a 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 interchange partners' translation routines use the transaction set identifier (ST01) 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 precedes 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
RefIdElement NameReqTypeMin/MaxUsageG9101
259
Change Type Code
Description: Code indicating change type
Code List Summary (Total Codes: 21, included: 1)
| Code | Name |
|---|---|
| B | Original Price Change Transaction |
M
ID
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
RefIdElement NameReqTypeMin/MaxUsageN101
98
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
M
ID
2/3
Must use
N102
93
Name
Description: Free-form name
User Note 1: Mandatory when N101=VN
M
AN
1/60
Must use
N103
66
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 |
M
ID
1/2
Must use
N104
64
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).
M
AN
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
RefIdElement NameReqTypeMin/MaxUsageG6201
432
Date Qualifier
Description: Code specifying type of date
Code List Summary (Total Codes: 139, included: 1)
| Code | Name |
|---|---|
| 09 | Process Date |
X
ID
2/2
Used
G6202
373
Date
Description: Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year.
X
DT
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 | Notes | 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
RefIdElement NameReqTypeMin/MaxUsageG2802
766
U.P.C./EAN Consumer Package Code
Description: Walmart UPC Code Uniquely identifying the retail shelf unit.
M
N
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 |
M
ID
2/2
Must Use
G2804
234
Product/Service ID
Description: Identifying number for a product or service (Vendor SKU).
M
AN
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
RefIdElement NameReqTypeMin/MaxUsageG6201
432
Date Qualifier
Description: Code specifying type of date
Code List Summary (Total Codes: 139, included: 1)
| Code | Name |
|---|---|
| 87 | First Order Date |
X
ID
2/2
Used
G6202
373
Date
Description: Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year
X
DT
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
RefIdElement NameReqTypeMin/MaxUsageG4001
417
Price Bracket Identifier
Description: Identifier assigned by the vendor for a specific price bracket.
O
AN
1/3
Used
G4002
418
Item List Cost – New
Description: Unit Cost Price within the appropriate price bracket for a line item.
M
R
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 |
M
ID
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
Updated about 19 hours ago