Template: Inventory Production
Column Name | Required | Default Value | Note | |
---|---|---|---|---|
Production Transaction | TransactionID | Next Document Number. | The Transaction ID defaults from the default/provided Transaction Class if not provided. | |
TransactionDate | X | Date must be for a period open to inventory. | ||
SiteID | X | 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 | Primary | Must be blank, Input, Primary or By Product. | ||
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. | |||
WorkOrder | ||||
LineItemNote | ||||
LotOwner | Default Owner Preference | |||
Production Batch | BatchProductionSite | X | Required when new production batch is imported. | |
BatchDate | 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. | |||
BatchClass | ||||
QualityTestClass | ||||
BatchComment | Must be blank for non lot tracked items. | |||
OutsidePurchase | No | If 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 | 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. |
Note: User defined production transaction and production batch attributes are also displayed in the template.