| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAccounting Engine |
| 1 | FINACITCASH | Line Items in the Cash Journal | 37 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 2 | FINACITCRV | Line Items in Cost and Revenue Journal | 35 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 3 | FINACITDUE | Line Items in the AP/AR Journal | 37 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 4 | FINACITFXA | Line Item in Asset Journal | 35 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 5 | FINACITGRI | Line Items in the GR/IR Journal | 35 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 6 | FINACITINV | Line Items in the Material Inventory Journal | 35 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 7 | FINACITWIP | Line Items in the WIP Journal | 35 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| TOPBusiness Accounting |
| 8 | UAV0PRICE001 | Price Table with Period Dependency | 17 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 9 | UAV0PRICE001H | Price History Table with Period Dependency | 21 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 10 | UAV0PRICE002 | Price Table with Date Dependency | 17 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 11 | UAV0PRICE002H | Price History Table with Date Dependency | 21 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 12 | UAV0PRICE003 | Price Table with Period Dependency | 17 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 13 | UAV0PRICE003H | Price History Table with Period Dependency | 21 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 14 | UAV0PRICE004 | Price Table with Date Dependency | 17 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 15 | UAV0PRICE004H | Price History Table with Date Dependency | 21 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| TOPBusiness Analytics |
| 16 | UABWEDGCALCFLAT | BW Extraction: Extracted Replacement Links for Costing | 4 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 17 | UAB_ARCH_LOCK | Persistent Locking for Archived Objects | 4 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| TOPFinancials |
| 18 | FINVALLEVEL0C | Valuation Levels | 3 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| TOPFinancials Basis |
| 19 | FOBJ_OBJ_W_POST | FIN Objects with Postings That Have Not Yet Been Processed | 2 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| TOPInventory Accounting |
| 20 | FAIBSV01 | Incoming/Outgoing Invoices | 4 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 21 | FAIBSV02 | Valuated Receipts | 4 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 22 | FAIBSV03 | Logistical Goods Movements | 4 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 23 | UAINVDEBCRI | Document Item for Revaluation Through Material Debit/Credit | 24 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
| 24 | UAINVREVALI | Document Item for Inventory Price Change and Revaluation | 28 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | | |
