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