The InvLots entity is provided to enable the grouping of inventory items with common expiration dates. The attached contains the required format for InvLots.CSV with a sample record.
The Type defines how the sample file handles the CSV data type to produce the double quote delimiters for each field. Make sure to change the custom field format if any if the fields noted as “integer” contain alphanumeric data.
Fields:
Field Name | Type | Required | Description |
Code | “string” | Y | Unique code identifier. Must exist in the Inventory entity. |
LotNo | “integer” | Y | PIMS lot number assigned |
LotExpireDate | “date” |
| Lot expiration date |
QOH | “decimal” | Y | Lot quantity on hand. Can be 0. |