W23 Detail Activity - Inventory
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 of Measurement Code
Identifier (ID)
Mandatory
2
2
-
Code identifying the basic unit of measurement.
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
Identifier (ID)
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).
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).
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).
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.