| 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 | |
Allowed | The value defaults from the transaction class, if not provided. |
NegativeAvailableBalances | |
Not Allowed | |
| The value defaults from the transaction class, if not provided. |
AutoCreateNewLots-Input | |
Not Allowed | The value defaults from the transaction class, if not provided. |
NegativeAvailableBalances-Input | |
Not Allowed | |
| 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 |
ProductionSiteBatchProductionSite | X | | Required when new production batch is imported. |
ProductionDateBatchDate | 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.