| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInventory and Production |
| 1 | OIVQ | FIFO Queue Working Table | 11 | StockActio | Stock Action Type | Int | 11 | 0 | -1 | -1=All Transactions, -2=Opening Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 58=Inventory Update, 59=Goods Receipt, 60=Goods Issue, 67=Inventory Transfer, 68=Work Instructions, 69=Landed Costs |
| 2 | SIVQ | FIFO Queue Working Table | 11 | StockActio | Stock Action Type | Int | 11 | 0 | -1 | -1=All Transactions, -2=Opening Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 58=Inventory Update, 59=Goods Receipt, 60=Goods Issue, 67=Inventory Transfer, 68=Work Instructions, 69=Landed Costs |
| 3 | UIVQ | FIFO Queue Working Table | 11 | StockActio | Stock Action Type | Int | 11 | 0 | -1 | -1=All Transactions, -2=Opening Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 58=Inventory Update, 59=Goods Receipt, 60=Goods Issue, 67=Inventory Transfer, 68=Work Instructions, 69=Landed Costs |
