| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFinance |
| 1 | AACP | Periods Category-Log | 117 | NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | 0 | | |
| 2 | AGAR | G/L Account Advanced Rules - History | 40 | NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | 0 | | |
| 3 | OACP | Periods Category | 117 | NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | 0 | | |
| 4 | OGAR | G/L Account Advanced Rules | 40 | NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | 0 | | |
| TOPInventory and Production |
| 5 | AITB | Item Groups - History | 68 | NegStckAct | Negative Inventory Adjustment | nVarChar | 15 | 0 | | |
| 6 | AITW | Items - Warehouse - History | 61 | NegStckAct | Negative Stock Adjustment Acct | nVarChar | 15 | 0 | | |
| 7 | AWHS | Warehouses - History | 69 | NegStckAct | Negative Stock Adjustment Acct | nVarChar | 15 | 0 | | |
| 8 | OITB | Item Groups | 68 | NegStckAct | Negative Inventory Adjustment Acct | nVarChar | 15 | 0 | | |
| 9 | OITW | Items - Warehouse | 61 | NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | 0 | | |
| 10 | OIVL | Whse Journal | 39 | NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | 0 | | |
| 11 | OWHS | Warehouses | 69 | NegStckAct | Negative Inventory Adjustment Acct | nVarChar | 15 | 0 | | |
| 12 | SITW | Items - Warehouse | 61 | NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | 0 | | |
| 13 | SIVL | Whse Journal | 39 | NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | 0 | | |
| 14 | UITW | Items - Warehouse | 61 | NegStckAct | Neg. Inventory Adjustment Acct | nVarChar | 15 | 0 | | |
| 15 | UIVL | Whse Journal | 39 | NegStckAct | Neg. Inventory Adjustment Acct | nVarChar | 15 | 0 | | |
