Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »


Column NameRequiredDefault ValueNote
Adjustment TransactionTransactionDateX Date must be for a period open to inventory.
SiteIDX Must be a valid & active site ID.
Reference   
AutoCreateNewLots Allowed 
NegativeAvailableBalances Not Allowed 
HeaderNote   
ItemIDX Must be a valid item ID.
LineItemUnitsX 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. 
LineItemWeightX 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. 
ProductionBatchX 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

          

ProductionSiteX Required when new production batch is imported.
ProductionDateX 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 NoIf 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 NoIf 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. 
  • No labels