| Column | ColumnName | Required | Default Value | Unique By | Note | |
|---|---|---|---|---|---|---|
| Adjustment TransactionAdjustment Transaction | TransactionDate | X | X | Date must be for a period open to inventory. | ||
| SiteID | X | X | Must be a valid & active site ID. | |||
| Reference | X | |||||
| AutoCreateNewLots | Allowed | |||||
| NegativeAvailableBalances | Not Allowed | |||||
| HeaderNote | ||||||
| ItemID | X | Must be a valid item ID. | ||||
| LineItemUnits | X | Required if item managed by 'Units Only' or 'Units & Weight'. | ||||
| UnitsUOMID | Item's Inventory UOM. | Must contain a valid Units UOM from the Item's UOM schedule. | ||||
| LineItemWeight | X | Required if item managed by 'Weight Only' or 'Units & Weight'. | ||||
| WeightUOMID | Item's Inventory UOM. | Must contain a valid Weight UOM from the Item's UOM schedule. | ||||
| ProductionBatch | X | Required when new production batch is imported. Must be blank for non lot tracked items. | ||||
| WarehouseLotID | Must be blank for non warehouse lot tracked sites. | |||||
| LineItemReasonCode | Must be a valid reason code. | |||||
| LineItemNote | ||||||
Production Batch
| ProductionSite | X | Required when new production batch is imported. | |||
| ProductionDate | X | Required when new production batch is imported. | ||||
| ProductionLine | If entered, the value must be a valid production line value. Must be blank for non lot tracked items. | |||||
| ProductionShift | If entered, the value must be a valid production shift value. Must be blank for non lot tracked items. | |||||
| CountryOfOrigin | If entered, the value must be an active country. Must be blank for non lot tracked items. | |||||
| ExpirationDate | If entered, the value must be a valid date. Must be blank for non lot tracked items. | |||||
| BatchComment | ||||||
| OutsidePurchase | ||||||
| VendorPurchasedFrom | Must be blank for non lot tracked items. | |||||
| BatchClass | No | If entered, the value must be Yes or No. Must be blank for non lot tracked items. | ||||
| QualityTestClass | Must be blank for non lot tracked items. | |||||
| QualityTestID | ||||||
| Traded | No | If entered, the value must be Yes or No. Must be blank for non lot tracked items. | ||||
| Project | If entered, the value must be a valid open project. Must be blank for non lot tracked items. |
...