| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInventory and Production |
| 1 | AITB | Item Groups - History | 18 | FrExpensAc | Foreign Expense Acct | nVarChar | 15 | 0 | | |
| 2 | AITW | Items - Warehouse - History | 27 | FrExpensAc | Foreign Expenses Acc. | nVarChar | 15 | 0 | | |
| 3 | AWHS | Warehouses - History | 20 | FrExpensAc | Expense Account - Foreign | nVarChar | 15 | 0 | | |
| 4 | OITB | Item Groups | 18 | FrExpensAc | Expense Account - Foreign | nVarChar | 15 | 0 | | |
| 5 | OITW | Items - Warehouse | 27 | FrExpensAc | Expense Account - Foreign | nVarChar | 15 | 0 | | |
| 6 | OWHS | Warehouses | 20 | FrExpensAc | Expense Account - Foreign | nVarChar | 15 | 0 | | |
| 7 | SITW | Items - Warehouse | 27 | FrExpensAc | Expense Account - Foreign | nVarChar | 15 | 0 | | |
| 8 | UITW | Items - Warehouse | 27 | FrExpensAc | Expense Account - Foreign | nVarChar | 15 | 0 | | |
