**These specifications are a base model. All customers are responsible for ensuring their map or EDI is compliant with their trading partner's most current specifications.
Target Corporation
EDI Guideline
Domestic
Target.com DVS Vendor
846
Inventory Inquiry/Advice
Version 4010
Revised: April 2022
Change Log
Date | Change | Comments |
April 2022 | BIA*01
LIN
LIN*01
LIN*03
SDQ
CTT | Added notes for segment codes. Revised segment level note. Clarified segment usage.
Clarified segment usage.
Removed ONBK codes.
Changed segment from ‘Optional’ to ‘Optional (Must Use)’. |
January 2022 | Revised note verbiage for SDQ*23 |
|
May 2021 | Added usage note for LIN*01 | Not used by Target. |
November 2020 | Converted from .pdf to .docx file format | Changes to file format only – no change to content. |
June 2019 | Revised note for SDQ*23. | “May start with a ‘T’” verbiage removed. |
846 Inventory Inquiry/Advice
Functional Group ID=IB
Introduction:
This Draft Standard for Trial Use contains the format and establishes the data contents of the Inventory Inquiry/Advice Transaction Set (846) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used in the following ways: (1) for a seller of goods and services to provide inventory information to a prospective purchaser, with no obligation to the purchaser to acquire these goods or services; (2) for a representative of a seller of goods and services to supply inventory information to that seller; (3) for one location to supply another location with inventory information; and (4) for an inquiry as to the availability of inventory with no obligation on the seller of goods and services to reserve that inventory.
Heading:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
M | 010 | ST | Transaction Set Header | M | 1 |
|
|
|
|
|
|
|
|
M | 020 | BIA | Beginning Segment for Inventory Inquiry/Advice | M | 1 |
|
|
|
|
|
|
|
|
Must Use | 060 | REF | Reference Identification | O | 12 |
|
|
|
|
|
|
|
|
|
|
| LOOP ID - N1 |
|
| 5 |
|
|
|
|
|
|
|
| 080 | N1 | Name | O | 1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Detail:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
|
|
| LOOP ID - LIN |
|
| 10000 |
|
|
|
|
|
|
|
M | 010 | LIN | Item Identification | M | 1 |
|
|
|
|
|
|
|
|
| 100 | DTM | Date/Time Reference | O | 10 |
|
|
|
|
|
|
|
|
| 110 | CTP | Pricing Information | O | 25 |
|
|
|
|
|
|
|
|
Must Use | 220 | SDQ | Destination Quantity | O | 500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Summary:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
Must Use | 010 | CTT | Transaction Totals | O | 1 |
| n1 |
|
|
|
|
|
|
M | 020 | SE | Transaction Set Trailer | M | 1 |
|
|
|
|
|
|
|
|
Transaction Set Notes
1. Number of line items (CTT01) is the accumulation of number of LIN segments. If used, hash total (CTT02) is the sum of the values of the quantities (QTY02) of each QTY segment.
Segment: ST Transaction Set Header
Position: 010
Loop:
Level: Heading
Usage: Mandatory
Max Use: 1
Purpose: To indicate the start of a transaction set and to assign a control number
Syntax Notes:
Semantic Notes: 1 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).
Comments:
Notes: |
| ****************** Sample ST Segment:
ST*846*1234 ***************** |
Data Element Summary
Ref. Data
Des. Element Name Attributes
M | ST01 | 143 | Transaction Set Identifier Code | M |
| ID 3/3 | ||||
| Code uniquely identifying a Transaction Set |
| ||||||||
| 846 |
| Inventory Inquiry/Advice |
| ||||||
M | ST02 | 329 | Transaction Set Control Number | M |
| AN 4/9 | ||||
| Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set |
| ||||||||
Segment: BIA Beginning Segment for Inventory Inquiry/Advice
Position: 020
Loop:
Level: Heading
Usage: Mandatory
Max Use: 1
Purpose: To indicate the beginning of an Inventory Inquiry/Advice Transaction Set
Syntax Notes:
Semantic Notes: 1 BIA03 identifies the number of the inquiry/advice that is transferred.
2 BIA04 identifies the date of the inquiry/advice that is transferred.
3 BIA05 identifies the time of the inquiry/advice that is transferred.
Comments:
Notes: |
| ************************** Sample BIA Segment:
BIA*00*MB*20090630125400*20090630 ************************* |
Data Element Summary
Ref. Data
Des. Element Name Attributes
M | BIA01 | 353 | Transaction Set Purpose Code | M |
| ID 2/2 | |||||
| Code identifying purpose of transaction set |
| |||||||||
| 00 |
| Original |
| |||||||
| Full An all item update feed sent daily. |
| |||||||||
| 04 |
| Change |
| |||||||
| Partial An update to items sent between full feeds. |
| |||||||||
M | BIA02 | 755 | Report Type Code | M |
| ID 2/2 | |||||
| Code indicating the title or contents of a document, report or supporting item |
| |||||||||
M | BIA03 | 127 | Reference Identification | M |
| AN 1/30 | |||||
| Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier |
| |||||||||
| Unique number identifying this transaction. |
| |||||||||
M | BIA04 | 373 | Date | M |
| DT 8/8 | |||||
| Date expressed as CCYYMMDD |
| |||||||||
Segment: REF Reference Identification
Position: 060
Loop:
Level: Heading
Usage: Optional (Must Use)
Max Use: 12
Purpose: To specify identifying information
Syntax Notes: 1 At least one of REF02 or REF03 is required.
2 If either C04003 or C04004 is present, then the other is required.
3 If either C04005 or C04006 is present, then the other is required.
Semantic Notes: 1 REF04 contains data relating to the value cited in REF02.
Comments:
Notes: |
| ********************* Sample REF segment:
REF*VR*12345
Note: Vendor number is a minimum of 4 digits ******************** |
Data Element Summary
Ref. Data
Des. Element Name Attributes
M | REF01 | 128 | Reference Identification Qualifier | M |
| ID 2/3 | ||||
| Code qualifying the Reference Identification |
| ||||||||
| VR |
| Vendor ID Number |
| ||||||
Must Use | REF02 | 127 | Reference Identification | X |
| AN 1/30 | ||||
| Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier |
| ||||||||
| Target.com assigned vendor number |
| ||||||||
Segment: N1 Name
Position: 080
Loop: N1 Optional
Level: Heading
Usage: Optional
Max Use: 1
Purpose: To identify a party by type of organization, name, and code
Syntax Notes: 1 At least one of N102 or N103 is required.
2 If either N103 or N104 is present, then the other is required.
Semantic Notes:
Comments: 1 This segment, 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.
2 N105 and N106 further define the type of entity in N101.
Notes: |
| ************** Sample N1 Segment:
N1*DS*VENDOR NAME ************** |
Data Element Summary
Ref. Data
Des. Element Name Attributes
M | N101 | 98 | Entity Identifier Code | M |
| ID 2/3 | ||||
| Code identifying an organizational entity, a physical location, property or an individual |
| ||||||||
| DS |
| Distributor |
| ||||||
| N102 | 93 | Name | X |
| AN 1/60 | ||||
| Free-form name |
| ||||||||
| Vendor Name |
| ||||||||
Segment: LIN Item Identification
Position: 010
Loop: LIN Mandatory
Level: Detail
Usage: Mandatory
Max Use: 1
Purpose: To specify basic item identification data
Syntax Notes: 1 If either LIN04 or LIN05 is present, then the other is required.
2 If either LIN06 or LIN07 is present, then the other is required.
3 If either LIN08 or LIN09 is present, then the other is required.
4 If either LIN10 or LIN11 is present, then the other is required.
5 If either LIN12 or LIN13 is present, then the other is required.
6 If either LIN14 or LIN15 is present, then the other is required.
7 If either LIN16 or LIN17 is present, then the other is required.
8 If either LIN18 or LIN19 is present, then the other is required.
9 If either LIN20 or LIN21 is present, then the other is required.
10 If either LIN22 or LIN23 is present, then the other is required.
11 If either LIN24 or LIN25 is present, then the other is required.
12 If either LIN26 or LIN27 is present, then the other is required.
13 If either LIN28 or LIN29 is present, then the other is required.
14 If either LIN30 or LIN31 is present, then the other is required.
Semantic Notes: 1 LIN01 is the line item identification
Comments: 1 See the Data Dictionary for a complete list of IDs.
2 LIN02 through LIN31 provide for fifteen different product/service IDs for each item. For example: Case, Color, Drawing No., U.P.C. No., ISBN No., Model No., or SKU.
Notes: |
| ****************** Sample LIN Segment:
LIN**SK*123456~
The manufacturer's style number is required and must appear first if multiple identifiers are sent. It must match value used in item setup, including letter case.
Example: LIN**SK*12345*IN*987654~ ****************** |
Data Element Summary
Ref. Data
Des. Element Name Attributes
| LIN01 | 350 | Assigned Identification | O |
| AN 1/20 | ||||
| Alphanumeric characters assigned for differentiation within a transaction set |
| ||||||||
| Optional line number. Must be sent in sequential order with no missing number if used. |
| ||||||||
M | LIN02 | 235 | Product/Service ID Qualifier | M |
| ID 2/2 | ||||
| Code identifying the type/source of the descriptive number used in Product/Service ID (234) |
| ||||||||
| SK |
| Stock Keeping Unit (SKU) |
| ||||||
M | LIN03 | 234 | Product/Service ID | M |
| AN 1/48 | ||||
| Identifying number for a product or service |
| ||||||||
| Manufacturer's style number Must send value identical to value used in item setup, including letter case. |
| ||||||||
| LIN04 | 235 | Product/Service ID Qualifier | X |
| ID 2/2 | ||||
| Code identifying the type/source of the descriptive number used in Product/Service ID (234) |
| ||||||||
| EN |
| European Article Number (EAN) (2-5-5-1) |
| ||||||
| EO |
| EAN/UCC 8 |
| ||||||
| IB |
| International Standard Book Number (ISBN) |
| ||||||
| IN |
| Buyer's Item Number |
| ||||||
| UA |
| U.P.C./EAN Case Code (2-5-5) |
| ||||||
| UK |
| U.P.C./EAN Shipping Container Code (1-2-5-5-1) |
| ||||||
| A 14-digit code that uniquely identifies the manufacturer's shipping unit, including the packaging indicator and check digit; the first digit is the packaging indicator, the next two digits are the number system characters, the next five digits are the manufacturer ID number, the second five digits are the item code, and the final digit is the check digit |
| ||||||||
| UP |
| U.P.C. Consumer Package Code (1-5-5-1) |
| ||||||
| LIN05 | 234 | Product/Service ID | X |
| AN 1/48 | ||||
| Identifying number for a product or service |
| ||||||||
| When LIN04 = IN, this will contain the Target.com item number (6 to 8 digits) When LIN04 = UP, this will contain the UPC (12 digits) When LIN04 = EO, this value is the 8 digit EAN When LIN04 = EN, this value is the 13 digit EAN When LIN04 = IB, this value is the ISBN When LIN04 = UK, this value is the 14 digit barcode |
| ||||||||
| LIN06 | 235 | Product/Service ID Qualifier | X |
| ID 2/2 | ||||
| Code identifying the type/source of the descriptive number used in Product/Service ID (234) |
| ||||||||
| EN |
| European Article Number (EAN) (2-5-5-1) |
| ||||||
| EO |
| EAN/UCC 8 |
| ||||||
| IB |
| International Standard Book Number (ISBN) |
| ||||||
| IN |
| Buyer's Item Number |
| ||||||
| UA |
| U.P.C./EAN Case Code (2-5-5) |
| ||||||
| UK |
| U.P.C./EAN Shipping Container Code (1-2-5-5-1) |
| ||||||
| A 14-digit code that uniquely identifies the manufacturer's shipping unit, including the packaging indicator and check digit; the first digit is the packaging indicator, the next two digits are the number system characters, the next five digits are the manufacturer ID number, the second five digits are the item code, and the final digit is the check digit |
| ||||||||
| UP |
| U.P.C. Consumer Package Code (1-5-5-1) |
| ||||||
| LIN07 | 234 | Product/Service ID | X |
| AN 1/48 | ||||
| Identifying number for a product or service |
| ||||||||
| When LIN06 = IN, this will contain the Target.com item number (6 to 8 digits) When LIN06 = UP, this will contain the UPC (12 digits) When LIN06 = EO, this value is the 8 digit EAN When LIN06 = EN, this value is the 13 digit EAN When LIN06 = IB, this value is the ISBN When LIN06 = UK, this value is the 14 digit barcode |
| ||||||||
Segment: DTM Date/Time Reference
Position: 100
Loop: LIN Mandatory
Level: Detail
Usage: Optional
Max Use: 10
Purpose: To specify pertinent dates and times
Syntax Notes: 1 At least one of DTM02 DTM03 or DTM05 is required.
2 If DTM04 is present, then DTM03 is required.
3 If either DTM05 or DTM06 is present, then the other is required.
Semantic Notes:
Comments:
Notes: |
| ******************** Sample DTM Segment:
DTM*128*20090703
******************** |
Data Element Summary
Ref. Data
Des. Element Name Attributes
M | DTM01 | 374 | Date/Time Qualifier | M |
| ID 3/3 | |||||
| Code specifying type of date or time, or both date and time |
| |||||||||
| 128 |
| Replacement Effective |
| |||||||
| For use only if the quantity status is On Order or Back Order |
| |||||||||
Must Use | DTM02 | 373 | Date | X |
| DT 8/8 | |||||
| Date expressed as CCYYMMDD |
| |||||||||
Segment: CTP Pricing Information
Position: 110
Loop: LIN Mandatory
Level: Detail
Usage: Optional
Max Use: 25
Purpose: To specify pricing information
Syntax Notes: 1 If either CTP04 or CTP05 is present, then the other is required.
2 If CTP06 is present, then CTP07 is required.
3 If CTP09 is present, then CTP02 is required.
4 If CTP10 is present, then CTP02 is required.
5 If CTP11 is present, then CTP03 is required.
Semantic Notes: 1 CTP07 is a multiplier factor to arrive at a final discounted price. A multiplier of .90 would be the factor if a 10% discount is given.
2 CTP08 is the rebate amount.
Comments: 1 See Figures Appendix for an example detailing the use of CTP03 and CTP04.
See Figures Appendix for an example detailing the use of CTP03, CTP04 and CTP07.
Notes: |
| ******************* Sample CTP Segment:
CTP*DI*CON*12.35 ******************* |
Data Element Summary
Ref. Data
Des. Element Name Attributes
| CTP01 | 687 | Class of Trade Code | O |
| ID 2/2 | ||||
| Code indicating class of trade |
| ||||||||
| DI |
| Distributor |
| ||||||
| CTP02 | 236 | Price Identifier Code | X |
| ID 3/3 | ||||
| Code identifying pricing specification |
| ||||||||
| CON |
| Contract Price |
| ||||||
| CTP03 | 212 | Unit Price | X |
| R 1/17 | ||||
| Price per unit of product, service, commodity, etc. |
| ||||||||
Segment: SDQ Destination Quantity
Position: 220
Loop: LIN Mandatory
Level: Detail
Usage: Optional (Must Use)
Max Use: 500
Purpose: To specify destination and quantity detail
Syntax Notes: 1 If either SDQ05 or SDQ06 is present, then the other is required.
2 If either SDQ07 or SDQ08 is present, then the other is required.
3 If either SDQ09 or SDQ10 is present, then the other is required.
4 If either SDQ11 or SDQ12 is present, then the other is required.
5 If either SDQ13 or SDQ14 is present, then the other is required.
6 If either SDQ15 or SDQ16 is present, then the other is required.
7 If either SDQ17 or SDQ18 is present, then the other is required.
8 If either SDQ19 or SDQ20 is present, then the other is required.
9 If either SDQ21 or SDQ22 is present, then the other is required.
Semantic Notes: 1 SDQ23 identifies the area within the location identified in SDQ03, SDQ05, SDQ07, SDQ09, SDQ11, SDQ13, SDQ15, SDQ17, SDQ19, and SDQ21.
Comments: 1 SDQ02 is used only if different than previously defined in the transaction set.
2 SDQ03 is the store number.
3 SDQ23 may be used to identify areas within a store, e.g., front room, back room, selling outpost, end aisle display, etc. The value is agreed to by trading partners or industry conventions.
Notes: |
| ********************** Sample SDQ Segment
SDQ*EA*54*AVAIL*10*******************TTTT
One SDQ segment should be present for every LIN.
Quantities must be reported as numeric values. For example, to report two thousand units the value should appear 2000 not 2,000.
Negative values are not accepted. *********************** |
Data Element Summary
Ref. Data
Des. Element Name Attributes
M | SDQ01 | 355 | Unit or Basis for Measurement Code | M |
| ID 2/2 | ||||
| Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken |
| ||||||||
| EA |
| Each |
| ||||||
| SDQ02 | 66 | Identification Code Qualifier | O |
| ID 1/2 | ||||
| Code designating the system/method of code structure used for Identification Code (67) |
| ||||||||
| 54 |
| Warehouse |
| ||||||
M | SDQ03 | 67 | Identification Code | M |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| AVAIL ( quantity available) |
| ||||||||
M | SDQ04 | 380 | Quantity | M |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| SDQ05 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| SDQ06 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| SDQ07 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| ALLOC (quantity allocated) |
| ||||||||
| SDQ08 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| SDQ09 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| HOLD (quantity on hold) |
| ||||||||
| SDQ10 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| SDQ11 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| Not used |
| ||||||||
| SDQ12 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| Not used |
| ||||||||
| SDQ13 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| Not used |
| ||||||||
| SDQ14 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| Not used |
| ||||||||
| SDQ15 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| Not used |
| ||||||||
| SDQ16 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| Not used |
| ||||||||
| SDQ17 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| Not used |
| ||||||||
| SDQ18 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| Not used |
| ||||||||
| SDQ19 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| Not used |
| ||||||||
| SDQ20 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| Not used |
| ||||||||
| SDQ21 | 67 | Identification Code | X |
| AN 2/80 | ||||
| Code identifying a party or other code |
| ||||||||
| Not used |
| ||||||||
| SDQ22 | 380 | Quantity | X |
| R 1/15 | ||||
| Numeric value of quantity |
| ||||||||
| Not used |
| ||||||||
Must Use | SDQ23 | 310 | Location Identifier | O |
| AN 1/30 | ||||
| Code which identifies a specific location |
| ||||||||
| Code which identifies a vendor's specific Warehouse location. A minimum of 4 characters, an EDC is an alpha and/or numeric code. Alpha characters must be sent in upper case. If assigned a 3 digit EDC, add a leading zero to meet 4 digit minimum. |
| ||||||||
Segment: CTT Transaction Totals
Position: 010
Loop:
Level: Summary
Usage: Optional (Must Use)
Max Use: 1
Purpose: To transmit a hash total for a specific element in the transaction set
Syntax Notes: 1 If either CTT03 or CTT04 is present, then the other is required.
2 If either CTT05 or CTT06 is present, then the other is required.
Semantic Notes:
Comments: 1 This segment is intended to provide hash totals to validate transaction completeness and correctness.
Notes: |
| ******************* Sample CTT Segment
CTT*2
Should equal the number of LIN segments ******************* |
Data Element Summary
Ref. Data
Des. Element Name Attributes
M | CTT01 | 354 | Number of Line Items | M |
| N0 1/6 | |
| Total number of line items in the transaction set |
| |||||
Segment: SE Transaction Set Trailer
Position: 020
Loop:
Level: Summary
Usage: Mandatory
Max Use: 1
Purpose: To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)
Syntax Notes:
Semantic Notes:
Comments: 1 SE is the last segment of each transaction set.
Notes: |
| ************************ Sample SE Segment
SE*115*1234 ************************ |
Data Element Summary
Ref. Data
Des. Element Name Attributes
M | SE01 | 96 | Number of Included Segments | M |
| N0 1/10 | |
| Total number of segments included in a transaction set including ST and SE segments |
| |||||
M | SE02 | 329 | Transaction Set Control Number | M |
| AN 4/9 | |
| Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set |
| |||||
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article