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

Version 1 Next »

 Column NameRequiredReDefault ValueNote
Receipt Transaction       TransactionDateX
Date must be for a period open to   inventory.
SiteIDX
Must be a valid & active site ID.
Reference


PONumber


AutoCreateNewLots
Not 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. 
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