879 Unit Cost 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 Draft Standard for Trial Use contains the format and establishes the data contents of the Unit Cost Price Information Transaction Set (879) for use in an 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 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 : 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 : 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 : 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
| Ref | ID | Element Name | Req | Type | Min/Max | Usage |
|---|---|---|---|---|---|---|
| G9101 | 259 | Change Type Code: Code indicating change type. For example, code B indicates an original price change transaction. (Total codes: 21) | M | ID | 1/1 | Must use |
N1: Loop party identification
Identifies 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
Identifies a party by type of organization, name, and code.
- Pos: 0400
- Max: 1
- Heading – Mandatory
- Loop: 0100
- Elements: 4
Element summary
| Ref | ID | Element Name | Req | Type | Min/Max | Usage |
|---|---|---|---|---|---|---|
| N101 | 98 | Entity Identifier Code: Uniquely identifies an organizational entity, a physical location, property or an individual. For example, the code VN identifies a vendor. (Total codes: 1500) | M | ID | 2/3 | Must use |
| N102 | 93 | Name: Free-form name. Mandatory when N101=VN. | M | AN | 1/60 | Must use |
| N103 | 66 | Identification Code Qualifier: Code designating the system/method of code structure used for the identification code. For example, code 92 indicates Assigned by Buyer or Buyer’s Agent. (Total codes: 241) | M | ID | 1/2 | Must use |
| N104 | 64 | Identification Code: 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 and time
Specifies dates and times.
- Pos: 1600
- Max: 1
- Heading – Mandatory
- Loop: N/A
- Elements: 2
Element summary
| Ref | ID | Element Name | Req | Type | Min/Max | Usage |
|---|---|---|---|---|---|---|
| G6201 | 432 | Date Qualifier: Code specifying type of date. For example, code 09 indicates Process Date. (Total Codes: 139) | X | ID | 2/2 | Used |
| G6202 | 373 | Date: 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
Provides 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
Provides basic product identification information.
- Pos: 0200
- Max: 1
- Detail – Mandatory
- Loop: 0200
- Elements: 3
Element summary
| Ref | ID | Element Name | Req | Type | Min/Max | Usage |
|---|---|---|---|---|---|---|
| G2802 | 766 | U.P.C./EAN Consumer Package Code: Walmart UPC Code uniquely identifying the retail shelf unit. | M | N | 13/13 | Must use |
| G2803 | 235 | Product/Service ID Qualifier: Code identifying the type/source of the descriptive number used in Product/Service ID 234. For example, code VN indicates Vendor’s (Seller’s) Item/SKU number. (Total Codes: 519) | M | ID | 2/2 | Must use |
| G2804 | 234 | Product/Service ID: 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
Specifies 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 and time
Specifies dates and times.
- Pos: 0550
- Max: 1
- Detail – Optional
- Loop: 0200
- Elements: 2
Element summary
| Ref | ID | Element Name | Req | Type | Min/Max | Usage |
|---|---|---|---|---|---|---|
| G6201 | 432 | Date Qualifier: Code specifying type of date. For example, 87 indicates First Order Date.(Total Codes: 139) | X | ID | 2/2 | Used |
| G6202 | 373 | Date: 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
Provides 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
Provides a vendor’s pricing structure associated with a specific line item.
- Pos: 0650
- Max: 1
- Detail – Mandatory
- Loop: 0210
- Elements: 3
Element summary
| Ref | ID | Element Name | Req | Type | Min/Max | Usage |
|---|---|---|---|---|---|---|
| G4001 | 417 | Price Bracket Identifier: Identifier assigned by the vendor for a specific price bracket. | O | AN | 1/3 | Used |
| G4002 | 418 | Item List Cost – New: 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: Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken. For example EA indicates Each. (Total Codes: 844,) | 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
Indicates 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 14 days ago