DSCO
/
Drop Ship Inventory Inquiry/Advice v5010
  • Specification
  • EDI Inspector
Stedi maintains this guide based on public documentation from DSCO. Contact DSCO for official EDI specifications. To report any errors in this guide, please contact us.
Go to Stedi Network
DSCO logo

X12 846 Drop Ship Inventory Inquiry/Advice v5010

X12 Release 5010
Delimiters
  • ~ Segment
  • * Element
  • > Component
  • ^ Repetition
EDI samples
  • Multiple Warehouse Suppliers: IN STOCK/NEW ITEMS
View the latest version of this implementation guide as an interactive webpage
https://www.stedi.com/app/guides/view/dsco/drop-ship-inventory-inquiryadvice-v5010/01HEKW2Y9HSJGQTCQ490Q4PCHE
Powered by
Build EDI implementation guides at stedi.com
Overview
ISA
-
Interchange Control Header
Max use 1
Required
GS
-
Functional Group Header
Max use 1
Required
heading
detail
LIN Loop
LIN
0100
Item Identification
Max use 1
Required
PID
0300
Product/Item Description
Max use 200
Optional
DTM
1000
Date/Time Reference Period End
Max use 1
Optional
DTM
1000
Date/Time Reference Period Start
Max use 1
Optional
CTP
1100
Item Cost
Max use 25
Optional
CTP
1100
Sales Cost
Max use 25
Optional
CTP
1100
Sales Price
Max use 25
Optional
REF
1400
Reference Information Mutually Defined Made to Order Flag
Max use 1
Optional
REF
1400
Reference Information Mutually Defined Status
Max use 1
Optional
QTY Loop
QTY
3200
Quantity Information
Max use 1
Required
MEA
3400
Measurements
Max use 25
Optional
SCH Loop
LS
3850
Loop Header
Max use 1
Required
LE
3950
Loop Trailer
Max use 1
Required
GE
-
Functional Group Trailer
Max use 1
Required
IEA
-
Interchange Control Trailer
Max use 1
Required
ISA

Interchange Control Header

RequiredMax use 1
Example
ISA-01
I01
Authorization Information Qualifier
Required
Identifier (ID)
00
No Authorization Information Present (No Meaningful Information in I02)
ISA-02
I02
Authorization Information
Required
String (AN)
Min 10Max 10
ISA-03
I03
Security Information Qualifier
Required
Identifier (ID)
00
No Security Information Present (No Meaningful Information in I04)
ISA-04
I04
Security Information
Required
String (AN)
Min 10Max 10
ISA-05
I05
Interchange ID Qualifier
Required
Identifier (ID)
Min 2Max 2
Codes
ISA-06
I06
Interchange Sender ID
Required
String (AN)
Min 15Max 15
ISA-07
I05
Interchange ID Qualifier
Required
Identifier (ID)
Min 2Max 2
Codes
ISA-08
I07
Interchange Receiver ID
Required
String (AN)
Min 15Max 15
ISA-09
I08
Interchange Date
Required
Date (DT)
YYMMDD format
ISA-10
I09
Interchange Time
Required
Time (TM)
HHMM format
ISA-11
I65
Repetition Separator
Required
String (AN)
Min 1Max 1
^
Repetition Separator
ISA-12
I11
Interchange Control Version Number
Required
Identifier (ID)
00501
Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003
ISA-13
I12
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9
ISA-14
I13
Acknowledgment Requested
Required
Identifier (ID)
Min 1Max 1
0
No Interchange Acknowledgment Requested
1
Interchange Acknowledgment Requested (TA1)
ISA-15
I14
Interchange Usage Indicator
Required
Identifier (ID)
Min 1Max 1
I
Information
P
Production Data
T
Test Data
ISA-16
I15
Component Element Separator
Required
String (AN)
Min 1Max 1
>
Component Element Separator

Functional Group Header

RequiredMax use 1
Example
GS-01
479
Functional Identifier Code
Required
Identifier (ID)
IB
Inventory Inquiry/Advice (846)
GS-02
142
Application Sender's Code
Required
String (AN)
Min 2Max 15
GS-03
124
Application Receiver's Code
Required
String (AN)
Min 2Max 15
Required
Date (DT)
CCYYMMDD format
Required
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format
GS-06
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9
GS-07
455
Responsible Agency Code
Required
Identifier (ID)
Min 1Max 2
T
Transportation Data Coordinating Committee (TDCC)
X
Accredited Standards Committee X12
GS-08
480
Version / Release / Industry Identifier Code
Required
String (AN)
005010
Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003

Heading

ST
0100
Heading > ST

Transaction Set Header

RequiredMax use 1
Example
ST-01
143
Transaction Set Identifier Code
Required
Identifier (ID)
846
Inventory Inquiry/Advice
ST-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9
BIA
0200
Heading > BIA

Beginning Segment for Inventory Inquiry/Advice

RequiredMax use 1
Example
BIA-01
353
Transaction Set Purpose Code
Required
Identifier (ID)
00
Original
BIA-02
755
Report Type Code
Required
Identifier (ID)
MM
Manufacturer Inventory Report
BIA-03
127
Reference Identification
Required
String (AN)
Min 1Max 30
Usage notes
Required
Date (DT)
CCYYMMDD format
Required
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format
CUR
0400
Heading > CUR

Currency

OptionalMax use 1
Example
CUR-01
98
Entity Identifier Code
Required
Identifier (ID)
SE
Selling Party
CUR-02
100
Currency Code
Required
Identifier (ID)
USD
US Dollar
REF
0600
Heading > REF

Reference Information

OptionalMax use 12
Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
IA
Internal Vendor Number
REF-02
127
Reference Identification
Optional
String (AN)
Min 1Max 50
Usage notes
Heading end

Detail

LIN Loop
RequiredMax >1
LIN
0100
Detail > LIN Loop > LIN

Item Identification

RequiredMax use 1
Example
If either Product/Service ID Qualifier (LIN-04) or Product/Service ID (LIN-05) is present, then the other is required
If either Product/Service ID Qualifier (LIN-06) or Product/Service ID (LIN-07) is present, then the other is required
If either Product/Service ID Qualifier (LIN-08) or Product/Service ID (LIN-09) is present, then the other is required
If either Product/Service ID Qualifier (LIN-10) or Product/Service ID (LIN-11) is present, then the other is required
If either Product/Service ID Qualifier (LIN-14) or Product/Service ID (LIN-15) is present, then the other is required
If either Product/Service ID Qualifier (LIN-16) or Product/Service ID (LIN-17) is present, then the other is required
If either Product/Service ID Qualifier (LIN-18) or Product/Service ID (LIN-19) is present, then the other is required
If either Product/Service ID Qualifier (LIN-20) or Product/Service ID (LIN-21) is present, then the other is required
If either Product/Service ID Qualifier (LIN-22) or Product/Service ID (LIN-23) is present, then the other is required
LIN-01
350
Assigned Identification
Optional
String (AN)
Min 1Max 20
Usage notes
LIN-02
235
Product/Service ID Qualifier
Required
Identifier (ID)
SK
Stock Keeping Unit (SKU)
LIN-03
234
Product/Service ID
Required
String (AN)
Min 1Max 48
Usage notes
LIN-04
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-05
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-06
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-07
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-08
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-09
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-10
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-11
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-12
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-13
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-14
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-15
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-16
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-17
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-18
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-19
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-20
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-21
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
LIN-22
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BL
Brand/Label
BP
Buyer's Part Number
C3
Classification
CB
Buyer's Catalog Number
EN
European Article Number (EAN) (2-5-5-1)
IB
International Standard Book Number (ISBN)
MG
Manufacturer's Part Number
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-23
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
PID
0300
Detail > LIN Loop > PID

Product/Item Description

OptionalMax use 200
Example
PID-01
349
Item Description Type
Required
Identifier (ID)
F
Free-form
PID-02
750
Product/Process Characteristic Code
Optional
Identifier (ID)
08
Product
PID-05
352
Description
Optional
String (AN)
Min 1Max 80
Usage notes
DTM
1000
Detail > LIN Loop > DTM

Date/Time Reference Period End

OptionalMax use 1
Example
Variants (all may be used)
DTMDate/Time Reference Period Start
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
194
Period End
Optional
Date (DT)
CCYYMMDD format
DTM
1000
Detail > LIN Loop > DTM

Date/Time Reference Period Start

OptionalMax use 1
Example
Variants (all may be used)
DTMDate/Time Reference Period End
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
193
Period Start
Optional
Date (DT)
CCYYMMDD format
CTP
1100
Detail > LIN Loop > CTP

Item Cost

OptionalMax use 25
Example
Variants (all may be used)
CTPSales CostCTPSales Price
CTP-01
687
Class of Trade Code
Optional
Identifier (ID)
AS
Seller
CTP-02
236
Price Identifier Code
Required
Identifier (ID)
WHL
Wholesale
CTP-03
212
Unit Price
Optional
Decimal number (R)
Min 1Max 15
Usage notes
CTP
1100
Detail > LIN Loop > CTP

Sales Cost

OptionalMax use 25
Example
Variants (all may be used)
CTPItem CostCTPSales Price
CTP-01
687
Class of Trade Code
Optional
Identifier (ID)
AS
Seller
CTP-02
236
Price Identifier Code
Required
Identifier (ID)
UCP
Unit cost price
CTP-03
212
Unit Price
Optional
Decimal number (R)
Min 1Max 15
Usage notes
CTP
1100
Detail > LIN Loop > CTP

Sales Price

OptionalMax use 25
Usage notes
Example
Variants (all may be used)
CTPItem CostCTPSales Cost
CTP-01
687
Class of Trade Code
Optional
Identifier (ID)
AS
Seller
CTP-02
236
Price Identifier Code
Required
Identifier (ID)
DPR
Discount Price
CTP-03
212
Unit Price
Optional
Decimal number (R)
Min 1Max 15
Usage notes
REF
1400
Detail > LIN Loop > REF

Reference Information Mutually Defined Made to Order Flag

OptionalMax use 1
Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
ZZ
Mutually Defined
REF-02
127
Reference Identification
Optional
String (AN)
0
item IS NOT a made-to-order item
1
item IS a made-to-order item
REF-03
352
Description
Required
String (AN)
made_to_order_flag
Made-To-Order-Flag
REF
1400
Detail > LIN Loop > REF

Reference Information Mutually Defined Status

OptionalMax use 1
Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
ZZ
Mutually Defined
REF-02
127
Reference Identification
Optional
String (AN)
Usage notes
discontinued
Discontinued
hidden
Hidden
in-stock
In stock
out-ofstock
Out of stock
REF-03
352
Description
Required
String (AN)
status
Item Status
QTY Loop
RequiredMax >1
QTY
3200
Detail > LIN Loop > QTY Loop > QTY

Quantity Information

RequiredMax use 1
Example
QTY-01
673
Quantity Qualifier
Required
Identifier (ID)
33
Quantity Available for Sale (stock quantity)
QTY-02
380
Quantity
Required
Decimal number (R)
Min 1Max 15
Usage notes
QTY-03
C001
Composite Unit of Measure
RequiredMax use 1
To identify a composite unit of measure (See Figures Appendix for examples of use)
C001-01
355
Unit or Basis for Measurement Code
Required
Identifier (ID)
EA
Each
MEA
3400
Detail > LIN Loop > QTY Loop > MEA

Measurements

OptionalMax use 25
Example
MEA-05
740
Range Minimum
Optional
Decimal number (R)
Min 1Max 15
Usage notes
MEA-06
741
Range Maximum
Optional
Decimal number (R)
Min 1Max 15
Usage notes
SCH Loop
OptionalMax >1
SCH
3600
Detail > LIN Loop > QTY Loop > SCH Loop > SCH

Line Item Schedule

RequiredMax use 1
Example
SCH-01
380
Quantity
Required
Decimal number (R)
Min 1Max 15
Usage notes
SCH-02
355
Unit or Basis for Measurement Code
Required
Identifier (ID)
EA
Each
SCH-05
374
Date/Time Qualifier
Required
Identifier (ID)
Usage notes
018
Available
Required
Date (DT)
CCYYMMDD format
Usage notes
SCH Loop end
LS
3850
Detail > LIN Loop > QTY Loop > LS

Loop Header

RequiredMax use 1
Example
LS-01
447
Loop Identifier Code
Required
String (AN)
Min 2Max 3
REF Loop
OptionalMax >1
REF
3900
Detail > LIN Loop > QTY Loop > REF Loop > REF

Reference Information

RequiredMax use 1
Usage notes
Example
At least one of Reference Identification (REF-02) or Description (REF-03) is required
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
WS
Warehouse storage location number
REF-02
127
Reference Identification
Optional
String (AN)
Min 1Max 50
Usage notes
REF-03
352
Description
Optional
String (AN)
Min 1Max 80
Usage notes
DTM
4000
Detail > LIN Loop > QTY Loop > REF Loop > DTM

Date/Time Reference

OptionalMax use >1
Usage notes
Example
If either Date Time Period Format Qualifier (DTM-05) or Date Time Period (DTM-06) is present, then the other is required
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
018
Available
Optional
Date (DT)
CCYYMMDD format
Usage notes
DTM-05
1250
Date Time Period Format Qualifier
Optional
Identifier (ID)
UN
Unstructured
DTM-06
1251
Date Time Period
Optional
String (AN)
Min 1Max 35
Usage notes
REF Loop end
LE
3950
Detail > LIN Loop > QTY Loop > LE

Loop Trailer

RequiredMax use 1
Example
LE-01
447
Loop Identifier Code
Required
String (AN)
Min 3Max 3
QTY Loop end
LIN Loop end
Detail end

Summary

SE
0200
Summary > SE

Transaction Set Trailer

RequiredMax use 1
Example
SE-01
96
Number of Included Segments
Required
Numeric (N0)
Min 1Max 10
SE-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9
Summary end

Functional Group Trailer

RequiredMax use 1
Example
GE-01
97
Number of Transaction Sets Included
Required
Numeric (N0)
Min 1Max 6
GE-02
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9

Interchange Control Trailer

RequiredMax use 1
Example
IEA-01
I16
Number of Included Functional Groups
Required
Numeric (N0)
Min 1Max 5
IEA-02
I12
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9
EDI Samples

Multiple Warehouse Suppliers: IN STOCK/NEW ITEMS

ISA*00* *00* *ZZ*SENDER *ZZ*RECEIVER *231120*0409*^*00501*000000001*0*T*>~
GS*IB*SENDERGS*RECEIVERGS*20231120*040942*000000001*X*005010~
ST*846*0001~
BIA*00*MM*1*20170124*064000~
CUR*SE*USD~
REF*IA*123456~
LIN**SK*1111*UP*111111111111*EN*1111111111111~
PID*F*08***Fake title of SKU 1111~
CTP*AS*WHL*47.23~
REF*ZZ*in-stock*status~
QTY*33*145*EA~
LS*REF~
REF*WS*WH01*100~
REF*WS*WH02*45~
DTM*018*20300106***UN*100~
LE*REF~
LIN**SK*2222*UP*222222222222*EN*2222222222222~
PID*F*08***Fake title of SKU 2222~
CTP*AS*WHL*62.23~
REF*ZZ*in-stock*status~
QTY*33*100*EA~
SCH*100*EA***018*20300106~
LS*REF~
REF*WS*WH01*100~
LE*REF~
LIN**SK*3333*UP*333333333333*EN*3333333333333~
PID*F*08***Fake title of SKU 3333~
CTP*AS*WHL*25.23~
REF*ZZ*in-stock*status~
QTY*33*100*EA~
SCH*100*EA***018*20300106~
LS*REF~
REF*WS*WH01*100~
REF*WS*WH02*45~
DTM*018*20300106***UN*100~
LE*REF~
SE*35*0001~
GE*1*000000001~
IEA*1*000000001~

Single Warehouse Suppliers: IN STOCK/NEW ITEMS

ISA*00* *00* *ZZ*SENDER *ZZ*RECEIVER *231120*0409*^*00501*000000001*0*T*>~
GS*IB*SENDERGS*RECEIVERGS*20231120*040950*000000001*X*005010~
ST*846*0001~
BIA*00*MM*1*20170124*064000~
CUR*SE*USD~
REF*IA*123456~
LIN**SK*1111*UP*111111111111*EN*1111111111111~
PID*F*08***Fake title of SKU 1111~
CTP*AS*WHL*47.23~
REF*ZZ*in-stock*status~
QTY*33*145*EA~
LS*REF~
LE*RED~
LIN**SK*2222*UP*222222222222*EN*2222222222222~
PID*F*08***Fake title of SKU 2222~
CTP*AS*WHL*62.23~
REF*ZZ*in-stock*status~
QTY*33*100*EA~
LS*REF~
LE*REF~
LIN**SK*3333*UP*333333333333*EN*3333333333333~
PID*F*08***Fake title of SKU 3333~
CTP*AS*WHL*25.23~
REF*ZZ*in-stock*status~
REF*ZZ*1*made_to_order_flag~
QTY*33*55*EA~
SCH*99*EA***018*20300106~
LS*REF~
LE*REF~
SE*28*0001~
GE*1*000000001~
IEA*1*000000001~

Stedi is a registered trademark of Stedi, Inc. All names, logos, and brands of third parties listed on this page are trademarks of their respective owners (including “X12”, which is a trademark of X12 Incorporated). Stedi, Inc. and its products and services are not endorsed by, sponsored by, or affiliated with these third parties. Use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.