Template: Inventory Production


Column   NameRequiredDefault ValueNote
Production TransactionTransactionID
Next Document Number.The Transaction ID defaults from the default/provided Transaction Class if not provided. 
TransactionDateX Date must be for a   period open to inventory.
SiteIDX Must be a valid &   active site ID.
Reference


Transaction Class   The default production transaction class is used, if not provided. 
AutoCreateNewLots 
 The value defaults from the transaction class, if not provided.
NegativeAvailableBalances 
 The value defaults from the transaction class, if not provided.
AutoCreateNewLots-Input 
 The value defaults from the transaction class, if not provided.
NegativeAvailableBalances-Input 
 The value defaults from the transaction class, if not provided.
HeaderNote   
LineType PrimaryMust be blank, Input,   Primary or By Product. 
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. 
WorkOrder   
LineItemNote   
 LotOwner  Default Owner Preference 
Production Batch             BatchProductionSiteX Required when new   production batch is imported.
BatchDateX 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. 
BatchClass   
QualityTestClass   
BatchComment  Must be blank for non   lot tracked items. 
OutsidePurchase NoIf entered, the value   must be Yes or No. Must be blank for non lot tracked items. 
VendorPurchasedFrom  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. 

Note: User defined production transaction and production batch attributes are also displayed in the template.