W23 Detail Activity - Inventory

To provide for product identification and detail activity of a specific product for a given shipping account/depositor

Position
Element
Name
Type
Requirement
Min
Max
Repeat
W23-01
Unit or Basis for Measurement Code
Identifier (ID)
Mandatory
2
2
-
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
W23-02
Beginning Balance Quantity
Decimal number (R)
Mandatory
1
9
-
Opening product inventory quantity for the current inventory reporting period.
W23-03
Quantity Available
Decimal number (R)
Mandatory
1
9
-
Current inventory quantity available for shipment (reflects quantity on hand less quantity damaged, committed or otherwise unavailable.)
W23-04
Ending Balance Quantity
Decimal number (R)
Mandatory
1
9
-
Closing product inventory quantity for the current inventory reporting period.
W23-05
UPC Case Code
String (AN)
Conditional
12
12
-
Code (Universal Product Code - ``UPC'') including two high order digits identifying the ``system'' (U.S. Grocery = 00, 06 or 07; U.S. Drug = 03). Using the U.S. Grocery system, the next ten digits are: Manufacturer (5) Case Code (5).
R0506: At least one of W23-05 or W23-06 is required
W23-06
Product/Service ID Qualifier
Identifier (ID)
Conditional
2
2
-
Code identifying the type/source of the descriptive number used in Product/Service ID (234).
P0607: If either W23-06 or W23-07 is present, then the other is required
W23-07
Product/Service ID
String (AN)
Conditional
1
30
-
Identifying number for a product or service.
W23-08
Product/Service ID Qualifier
Identifier (ID)
Conditional
2
2
-
Code identifying the type/source of the descriptive number used in Product/Service ID (234).
P0809: If either W23-08 or W23-09 is present, then the other is required
W23-09
Product/Service ID
String (AN)
Conditional
1
30
-
Identifying number for a product or service.
W23-10
Quantity Received
Decimal number (R)
Optional
1
7
-
Number of shipping units received.
W23-11
Number of Units Shipped
Decimal number (R)
Optional
1
10
-
Numeric value of units shipped in manufacturer's shipping units for a line item or transaction set.
W23-12
Quantity Damaged/On Hold
Decimal number (R)
Optional
1
9
-
Quantity of product received which cannot be shipped in its present form.
W23-13
Quantity Committed
Decimal number (R)
Optional
1
9
-
Quantity reserved for orders not shipped.
W23-14
Quantity in Transit
Decimal number (R)
Optional
1
9
-
Quantity of stock replenishment shipped but not received.
W23-15
Quantity Adjustment
Decimal number (R)
Optional
1
7
-
Amount that the quantity is adjusted.

Stedi is a registered trademark of Stedi, Inc. Stedi's EDI Reference is provided for marketing purposes and is free of charge. All names, logos, and brands of third parties listed on our site 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. Our use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.