| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | FIAPSAC_EXGRTY | Assignment of Expenditure Types to Expenditure Groups | 3 | EXPTYPE | Expenditure Types | nvarchar | 2 | 0 | | |
| 2 | FIAPSAC_EXPTYPE | Expenditure types | 2 | EXPTYPE | Expenditure Types | nvarchar | 2 | 0 | | |
| 3 | FIAPSAC_EXPTYPET | Texts of Expenditure types | 2 | EXPTYPE | Expenditure Types | nvarchar | 2 | 0 | | |
| 4 | TIVYCCOND2EXP | Advance Payment Condition to Expence Types | 2 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 5 | TIVYCCOST2EXP | Cost Element to Expense Type | 2 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 6 | TIVYCEXP | Expense Type | 2 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 7 | TIVYCEXP2CC | Company code to expense type | 3 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 8 | TIVYCEXPT | Text table for expense type tables | 3 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 9 | VIYCCE2EXP | Cost Element to Expense Type | 3 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 10 | VIYCCE2POOL | Cost Elements in Pool | 5 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 11 | VIYCCOST2DC | Application of Distribution / Denominator Method | 12 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 12 | VIYCCOST2MC | Application of Mark-up and Capping After Distribution | 10 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 13 | VIYCCOST2OBJ | Determined Costs for Objects in CAM recovery | 6 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 14 | VIYCCOST2POOL | Determined Costs for Lease in CAM Recovery | 9 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 15 | VIYCEXP | Expense Type to Expense Pool | 3 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 16 | VIYCEXPITEM | Expense Items | 48 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 17 | VIYCMETERCOSTS | Meter Based Costs | 5 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| 18 | VIYCSTLMTRCOST | Settled Meter Costs with lease | 10 | EXPTYPE | Expense Type | nvarchar | 4 | 0 | | |
| TOPData Conversion |
| 19 | DMC_COBJ | DMC: Conversion Object | 26 | EXPTYPE | Which OLO Module Is Used | nvarchar | 4 | 0 | | |
| 20 | DMC_IMPTY | DMC: Types of Import/Export Interfaces for Applications | 3 | EXPTYPE | Which OLO Module Is Used | nvarchar | 4 | 0 | | |
| TOPLocalization |
| 21 | J_3RFTAXRO | Tax Accounting: Object table | 9 | EXPTYPE | Type of Expenses | nvarchar | 1 | 0 | | |
