W02 Item Summary - Inventory
W02 Item Summary - Inventory
To provide for product identification and totals relevant to the current inventory levels of a specific product for a given shipping account/ depositor.
Position
Element
Name
Type
Requirement
Min
Max
Repeat
W02-01
Quantity On-hand
Decimal number (R)
Mandatory
1
9
-
Gross inventory quantity including damaged product.
At least one of W0203 or W0204 must be present.
W02-02
Unit of Measurement Code
Identifier (ID)
Mandatory
2
2
-
Code identifying the basic unit of measurement.
W02-03
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).
If any of W0206, W0207, or W0208 are present, then they all are required.
W02-04
Product/Service ID Qualifier
Identifier (ID)
Conditional
2
2
-
Code identifying the type/source of the descriptive number used in Product/Service ID (234).
If either W0204 or W0205 is present, then the other is required.
W02-05
Product/Service ID
String (AN)
Conditional
1
30
-
Identifying number for a product or service.
W02-06
Warehouse Lot Number
String (AN)
Optional
1
12
-
Reference number assigned by the warehouse.
W02-07
Weight
Decimal number (R)
Conditional
1
8
-
Numeric value of weight.
If either W0207, W0208 or W0209 are present, then the others are required.
W02-08
Weight Qualifier
Identifier (ID)
Conditional
1
2
-
Code defining the type of weight.
W02-09
Weight Unit Qualifier
Identifier (ID)
Conditional
1
1
-
Code specifying the weight unit.
W02-10
Weight
Decimal number (R)
Conditional
1
8
-
Numeric value of weight.
If either W0210, W0211 or W0212 are present, then the others are required.
W02-11
Weight Qualifier
Identifier (ID)
Conditional
1
2
-
Code defining the type of weight.
W02-12
Weight Unit Qualifier
Identifier (ID)
Conditional
1
1
-
Code specifying the weight unit.
W02-13
Quantity Committed
Decimal number (R)
Optional
1
9
-
Quantity reserved for orders not shipped.
W02-14
Quantity Available
Decimal number (R)
Optional
1
9
-
Current inventory quantity available for shipment (reflects quantity on hand less quantity damaged, committed or otherwise unavailable.)
W02-15
Quantity in Transit
Decimal number (R)
Optional
1
9
-
Quantity of stock replenishment shipped but not received.
W02-16
Quantity Damaged
Decimal number (R)
Optional
1
9
-
Quantity of Inventory that normally cannot be shipped in its present form.
W02-17
Quantity On Hold
Decimal number (R)
Optional
1
9
-
Quantity of product which cannot be shipped at the present time for any reason, exclusive of damaged quantity.
W02-18
Quantity Backordered
Decimal number (R)
Optional
1
9
-
Quantity required to complete original order.
W02-19
Quantity Deferred
Decimal number (R)
Optional
1
9
-
Quantity required for orders, but not reserved.