| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | AADM | Administration - Log | 175 | GLMethod | Set G/L Account By | VarChar | 1 | 0 | W | C=Item Group, L=Item Level, W=Warehouse |
| 2 | OADM | Administration | 175 | GLMethod | Set G/L Account By | VarChar | 1 | 0 | W | C=Item Group, L=Item Level, W=Warehouse |
| TOPFinance |
| 3 | AGAR | G/L Account Advanced Rules - History | 28 | GLMethod | Get G/L Account By | VarChar | 1 | 0 | A | A=General, C=Item Group, W=Warehouse |
| 4 | OGAR | G/L Account Advanced Rules | 28 | GLMethod | Get G/L Account By | VarChar | 1 | 0 | A | A=General, C=Item Group, W=Warehouse |
| TOPGeneral |
| 5 | AGRS | G/L Account Advanced Rules for Resources - History | 28 | GLMethod | Get G/L Account By | VarChar | 1 | 0 | A | A=General, C=Item Group, W=Warehouse |
| 6 | OGRS | G/L Account Advanced Rules for Resources | 28 | GLMethod | Get G/L Account By | VarChar | 1 | 0 | A | A=General, C=Resource Group, W=Warehouse |
| TOPInventory and Production |
| 7 | AITM | Items - History | 206 | GLMethod | Set G/L Accounts By | VarChar | 1 | 0 | W | C=Item Group, L=Item Level, W=Warehouse |
| 8 | OITM | Items | 206 | GLMethod | Set G/L Accounts By | VarChar | 1 | 0 | W | C=Item Group, L=Item Level, W=Warehouse |
| 9 | SITM | Items | 206 | GLMethod | Set G/L Accounts By | VarChar | 1 | 0 | W | C=Item Group, L=Item Level, W=Warehouse |
| 10 | UITM | Items | 206 | GLMethod | Set G/L Accounts By | VarChar | 1 | 0 | W | C=Item Group, L=Item Level, W=Warehouse |
