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
W0201
Quantity On-hand
Decimal number (R)
Mandatory
1
9
-
Gross inventory quantity including damaged product.
W0202
Unit of Measurement Code
Identifier (ID)
Mandatory
2
2
-
Code identifying the basic unit of measurement.
W0202 qualifies W0201.
W0203
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).
R0304: At least one of W02-03 or W02-04 is required
W0204
Product/Service ID Qualifier
Identifier (ID)
Conditional
2
2
-
Code identifying the type/source of the descriptive number used in Product/Service ID (234).
P0405: If either W02-04 or W02-05 is present, then the other is required
W0205
Product/Service ID
String (AN)
Conditional
1
30
-
Identifying number for a product or service.
W0206
Warehouse Lot Number
String (AN)
Optional
1
12
-
Reference number assigned by the warehouse.
W0207
Weight
Decimal number (R)
Conditional
1
8
-
Numeric value of weight.
P070809: If either W02-07, W02-08 or W02-09 are present, then the others are required
W0208
Weight Qualifier
Identifier (ID)
Conditional
1
2
-
Code defining the type of weight.
W0209
Weight Unit Qualifier
Identifier (ID)
Conditional
1
1
-
Code specifying the weight unit.
W0210
Weight
Decimal number (R)
Conditional
1
8
-
Numeric value of weight.
P101112: If either W02-10, W02-11 or W02-12 are present, then the others are required
W0211
Weight Qualifier
Identifier (ID)
Conditional
1
2
-
Code defining the type of weight.
W0212
Weight Unit Qualifier
Identifier (ID)
Conditional
1
1
-
Code specifying the weight unit.
W0213
Quantity Committed
Decimal number (R)
Optional
1
9
-
Quantity reserved for orders not shipped.
W0214
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.)
W0215
Quantity in Transit
Decimal number (R)
Optional
1
9
-
Quantity of stock replenishment shipped but not received.
W0216
Quantity Damaged
Decimal number (R)
Optional
1
9
-
Quantity of Inventory that normally cannot be shipped in its present form.
W0217
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.
W0218
Quantity Backordered
Decimal number (R)
Optional
1
9
-
Quantity required to complete original order.
W0219
Quantity Deferred
Decimal number (R)
Optional
1
9
-
Quantity required for orders, but not reserved.

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.