| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FMBCS_FMBL_CD | Empty table for change documents on FMBL incl. local. fields | 56 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
TOPBudgeting |
2 | FMBL | Funds management budget document lines (entry documents) | 56 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
3 | FMHBL | Funds management budget document lines (held documents) | 56 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
4 | FMLA | Layout Variant | 13 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
5 | FMPEPLAY_H | FMPEP - Layout Customizing Settings - Header | 3 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
6 | FMPEP_VARIANTH | Session variants (header part) for transaction FMPEP | 26 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
7 | FMPEP_VARIANTL | Session variants (line part) for transaction FMPEP | 64 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
TOPBudgeting and Availability Control |
8 | GMBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 20 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
9 | GMHBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 21 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
10 | GRISDEA | Actual Line Item Table for Insurance (DE) - Rollup | 58 | DISTKEY | Distribution Key | nvarchar | 8 | 0 | | |
11 | GRISDEP | Plan Line Item Table for Insurance (DE) - Rollup | 122 | DISTKEY | Distribution Key | nvarchar | 8 | 0 | | |
12 | GRISDET | Summary Table for Insurance (DE) - Rollup | 107 | DISTKEY | Distribution Key | nvarchar | 8 | 0 | | |
13 | ISALLOC | Distribution table | 2 | DISTKEY | Distribution Key | nvarchar | 8 | 0 | | |
TOPFunds Management |
14 | BPREP_HRFPM_BCS | Variants of Budget Creation for PBC | 8 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
15 | FMALLOC | Distribution of Collective Budget Administration | 2 | DISTKEY | Distribution keys | nvarchar | 4 | 0 | | |
16 | FMIA | Actual Line Item Table for Funds Management | 50 | DISTKEY | Distribution keys | nvarchar | 4 | 0 | | |
17 | FMIT | Totals Table for Funds Management | 66 | DISTKEY | Distribution keys | nvarchar | 4 | 0 | | |
TOPInformation system |
18 | FMKF_REPTERM | Key Figure Terms for Reporting Because of New Budget Tables | 20 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |
19 | FMKF_REPTERM2 | Key Figure Terms for Reporting Because of New Budget Tables | 13 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | |