Lots Data
File name |
|
Importance | If Applicable |
Description | Stock lots and expiration dates |
Criteria | All lots with stock remaining |
Columns
Pos | Name | Type | Importance | Description |
1. | Item Code | Char | Required | Product / SKU code |
2. | Location Code | Char | Required | Warehouse / branch code |
3. | Lot Number | Char | Required | Lot / batch number |
4. | Supplier Code | Char | If Applicable | Vendor code of the supplier |
5. | Manufacture Date | Date | If Applicable | Date the lot was manufactured. Format: YYYY/MM/DD |
6. | Actual Expiry Date | Date | If Applicable | Date the lot expires (for reference only). Format: YYYY/MM/DD |
7. | Effective Expiry Date | Date | If Applicable | Last date the lot can be sold, transferred, or used in manufacturing. May match the actual expiry date. Used in expiry calculations. Format: YYYY/MM/DD |
8. | Quantity | Decimal | Required | Quantity on hand.Expressed in Netstock unit of measure. |