| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBudgeting |
| 1 | FMBS_BO | Budget Addresses | 3 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 2 | FMBS_BS | Budget structures | 3 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 3 | FMBS_BS_T | Texts for Budget Structures | 3 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 4 | FMBS_CONTROL | Budget structure settings on FM area and fiscal year level | 5 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 5 | FMBS_VERS_ASS | Budget Addresses settings on the version level | 5 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 6 | FMHIEHEADERS | Hierarchy Nodes: Constant Parts ("Headers") | 4 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 7 | FMHIEIDS | Hierarchy IDs | 4 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 8 | FMHIEIDST | Texts for Hierarchy IDs | 4 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 9 | FMHIENODES | Hierarchy Nodes (Without Constant Part) | 4 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 10 | FMHIESETTINGS | Settings for Budget Hierarchies | 3 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| 11 | FMHIE_CHGCHK_FLG | Activate Checks for Hierarchy Change | 3 | BS | Name of Budget Structure | nvarchar | 10 | 0 | | |
| TOPTravel Planning |
| 12 | FTPT_IMR_CAR | IMR - Car Rental | 22 | BS | Booking source for reservation identification | nvarchar | 10 | 0 | | |
| 13 | FTPT_IMR_HTL | IMR - Hotel | 23 | BS | Booking source for reservation identification | nvarchar | 10 | 0 | | |
| 14 | FTPT_IMR_HTL_DIR | IMR - Hotel (Direct Access) | 20 | BS | Booking source for reservation identification | nvarchar | 10 | 0 | | |
