This entity represents inventory lot information including quantities on hand and expiration dates. The attached contains the required format for the IInventoryLots.CSV with a sample record.
The Type defines how the sample file handles the data type to produce the correct delimiters for each field. Make sure to change the custom field format if any fields noted as "integer" contain alphanumeric data.
Fields
Field Name | Required | Type | Description |
CodeID | Y | String/Varchar(Max) | CodeID from ICodeBillables |
QOH | Y | Float | Amount of items in the lot number |
ExpirationDate | Y | DateTime2(7) | Date lot expires |
LotNumber | Y | String/Varchar(Max) | Unique lot number(s) for that CodeID |
SiteID |
| String/Varchar(Max) | Id of site if more than one site location is being converted |
Key |
| String/Varchar(4000) | Concatenation of Code, |, LotNumber (If using SiteID concatenate to the end) |
PmsID |
| String/Varchar(Max) | Concatenation of Code, |, LotNumber (If using SiteID concatenate to the end) |