| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAccounting Engine |
| 1 | FINACITCASH | Line Items in the Cash Journal | 38 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 2 | FINACITCRV | Line Items in Cost and Revenue Journal | 36 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 3 | FINACITDUE | Line Items in the AP/AR Journal | 38 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 4 | FINACITFXA | Line Item in Asset Journal | 36 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 5 | FINACITGRI | Line Items in the GR/IR Journal | 36 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 6 | FINACITINV | Line Items in the Material Inventory Journal | 36 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 7 | FINACITWIP | Line Items in the WIP Journal | 36 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| TOPBusiness Accounting |
| 8 | UAV0PRICE001 | Price Table with Period Dependency | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 9 | UAV0PRICE001H | Price History Table with Period Dependency | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 10 | UAV0PRICE002 | Price Table with Date Dependency | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 11 | UAV0PRICE002H | Price History Table with Date Dependency | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 12 | UAV0PRICE003 | Price Table with Period Dependency | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 13 | UAV0PRICE003H | Price History Table with Period Dependency | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 14 | UAV0PRICE004 | Price Table with Date Dependency | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 15 | UAV0PRICE004H | Price History Table with Date Dependency | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| TOPBusiness Analytics |
| 16 | UABWEDGCALCFLAT | BW Extraction: Extracted Replacement Links for Costing | 2 | FOBJ_OBJECT_ID | Object Instance ID (Representation for BW Extraction) | nvarchar | 32 | 0 | | |
| 17 | UAB_ARCH_LOCK | Persistent Locking for Archived Objects | 3 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| TOPFinancials |
| 18 | FINORDUE0C | FIN Objects for Receivables/Payables | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 19 | FINORMNFRECID | Planned Receivers for Manufacturing Orders | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| TOPFinancials Basis |
| 20 | FOBJ_OBJ_W_POST | FIN Objects with Postings That Have Not Yet Been Processed | 3 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| TOPInventory Accounting |
| 21 | CFICC0C | FIN Objects for Cost Centers | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 22 | CFICR0C | FIN Objects for Cost Center/Resource Pool | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 23 | CFIFA0C | FIN Objects for Fixed Assets | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 24 | CFIOCONSI0C | FIN Objects for Consignment | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 25 | CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 26 | CFIORGEN0C | FIN Objects for Internal Orders | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 27 | CFIORMNF0C | FIN Objects for Manufacturing Orders | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 28 | CFIORMNT0C | FIN Objects for Maintenance Orders | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 29 | CFIORNTA0C | FIN Objects for Network Items | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 30 | CFIORNTW0C | FIN Objects for Networks | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 31 | CFIORPURITM0C | FIN Objects for Purchase Order Items | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 32 | CFIORQMM0C | FIN Objects for QM Orders | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 33 | CFIORSRV0C | FIN Objects for Service Orders | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 34 | CFIORWBS0C | FIN Objects for WBS Elements | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 35 | CFIOSENTR0C | FIN Objects for Services | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 36 | CFIPVLOCPRD0C | Product Depending on Company/Location | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 37 | CFIPVLOCPRDBTC0C | Product Depending on Company/Location/Batch | 2 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 38 | FAIBSV01 | Incoming/Outgoing Invoices | 5 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 39 | FAIBSV02 | Valuated Receipts | 5 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 40 | FAIBSV03 | Logistical Goods Movements | 5 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 41 | UAINVDEBCRI | Document Item for Revaluation Through Material Debit/Credit | 9 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
| 42 | UAINVREVALI | Document Item for Inventory Price Change and Revaluation | 10 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | | |
