| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | FINACHD | Accounting Document Header | 5 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
TOPFinancials |
2 | ACCSYSTEM01 | Settings for Company on Accounting System | 3 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
3 | ACCSYSTEM02 | Number Range Object for Accounting System and Company | 3 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
4 | FINGLACCTCOMP0C | G/L Account on Accounting System/Company Level | 3 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
5 | FINORDUE0C | FIN Objects for Receivables/Payables | 7 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
6 | FINXCOMPANY0C | Local Values for FIN_COMPANY (Not Used in Live System) | 2 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
7 | FINXCOMPANY0T | Local Texts for FIN_COMPANY (Not Used in Live System) | 3 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
8 | FINXLOCATION0C | Local Values for FIN_LOCATION (Not Used in Live System) | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
9 | FINXPRODUCT01 | Local Values for FIN_PRODUCT (Not Used in Live System) | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
TOPInventory Accounting |
10 | CFIFA0C | FIN Objects for Fixed Assets | 3 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
11 | CFIOCONSI0C | FIN Objects for Consignment | 8 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
12 | CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) | 8 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
13 | CFIORGEN0C | FIN Objects for Internal Orders | 5 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
14 | CFIORMNF0C | FIN Objects for Manufacturing Orders | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
15 | CFIORMNT0C | FIN Objects for Maintenance Orders | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
16 | CFIORNTA0C | FIN Objects for Network Items | 5 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
17 | CFIORNTW0C | FIN Objects for Networks | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
18 | CFIORPURITM0C | FIN Objects for Purchase Order Items | 9 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
19 | CFIORQMM0C | FIN Objects for QM Orders | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
20 | CFIORSRV0C | FIN Objects for Service Orders | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
21 | CFIORWBS0C | FIN Objects for WBS Elements | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
22 | CFIOSENTR0C | FIN Objects for Services | 9 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
23 | CFIPVLOCPRD0C | Product Depending on Company/Location | 3 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
24 | CFIPVLOCPRDBTC0C | Product Depending on Company/Location/Batch | 3 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
25 | FAIBSV01 | Incoming/Outgoing Invoices | 9 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
26 | FAIBSV01C | Rule for Balance Sheet Valuation | 4 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
27 | FAIBSV02 | Valuated Receipts | 7 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
28 | FAIBSV03 | Logistical Goods Movements | 7 | FIN_COMPANY | Company | nvarchar | 22 | 0 | | |
29 | UAINV_DYNRELACT | Activation of Dynamic Price Release | 2 | FIN_COMPANY | Company Code | nvarchar | 4 | 0 | | |
30 | UAI_ABGRIR_ACTIV | Activation of Transaction-Based GR/IR Clearing | 3 | FIN_COMPANY | Company Code | nvarchar | 4 | 0 | | |