| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNV_NCE_JOBS | NCE: Job states and logs | 6 | FRYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 2 | CNV_NCE_NRIV_EXT | NCE: Number intervals on basis of database analysis | 11 | FRYEAR | To fiscal year | nvarchar | 4 | 0 | | |
| 3 | CNV_NCE_NRIV_TMP | NCE: Number intervals on basis of NRIV | 11 | FRYEAR | To fiscal year | nvarchar | 4 | 0 | | |
| TOPConsolidation |
| 4 | TF810 | Top Groups, Organizational Changes | 4 | FRYEAR | Effective from fiscal year | nvarchar | 4 | 0 | | |
| 5 | TF822 | Organizational Changes: Version/Time-Dependent | 5 | FRYEAR | Effective from fiscal year | nvarchar | 4 | 0 | | |
| 6 | TF823 | Organizational Changes: Group Assignment | 5 | FRYEAR | Effective from fiscal year | nvarchar | 4 | 0 | | |
| TOPGeneral Ledger Accounting |
| 7 | FAGL_ORG_INFO | General Ledger: Configuration Information | 16 | FRYEAR | From fiscal year | nvarchar | 4 | 0 | | |
| TOPInvestment Programs |
| 8 | TAI11 | Group shares in Inv. Program Info System | 5 | FRYEAR | From year | nvarchar | 4 | 0 | | |
| TOPJoint Venture und Production Sharing Accounting |
| 9 | T8JZ | JV Global Company Parameters | 13 | FRYEAR | Joint Venture year for first period allowed | nvarchar | 4 | 0 | | |
| 10 | T8PSA_LIFT_ASSGN | PSA Lifting Partner Group to Partner Assignment | 4 | FRYEAR | PSA Effective Year | nvarchar | 4 | 0 | | |
| 11 | T8PSA_OPEN_PER | Open Periods | 3 | FRYEAR | PSA Effective Year | nvarchar | 4 | 0 | | |
| 12 | T8PSC_PERIOD | PSC open production periods | 3 | FRYEAR | PSC Effective Year | nvarchar | 4 | 0 | | |
