| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CPD/D_MP_STATUS | Status Header | 9 | END_PERIOD | End Date of Status Period | nvarchar | 8 | 0 | | |
2 | /CPD/D_MP_ST_VHR | Status Versions | 10 | END_PERIOD | End Date of Status Period | nvarchar | 8 | 0 | | |
3 | GHO_DM_EFFECTS | Deferment Event Effects | 13 | END_PERIOD | End Period for Event Effect | decimal | 15 | 0 | | |
4 | GHO_DM_EVENT | Deferment Event Data | 5 | END_PERIOD | Deferment Event End Period | decimal | 15 | 0 | | |
5 | GHO_DM_RESULTS | Deferment Results | 10 | END_PERIOD | Deferment Result End Period | decimal | 15 | 0 | | |
6 | GHO_EFF_SRC_DATA | Table to store event effects data of defer used in alloc run | 21 | END_PERIOD | End Period for Event Effect | decimal | 15 | 0 | | |
7 | GHO_EVT_SRC_DATA | Table to store deferment events souce data used in alloc run | 13 | END_PERIOD | Deferment Event End Period | decimal | 15 | 0 | | |
TOPBalanced Scorecard |
8 | UMB_SA100 | Strategic Advice | 15 | END_PERIOD | End of Validity Period | nvarchar | 7 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
9 | DFMCA_BRF510 | BRF: Parameters for Creating Tax Obligation | 11 | END_PERIOD | BRF: Expression | nvarchar | 20 | 0 | | |
10 | DFMCA_BRF520 | BRF: Parameters for Deregistration of Tax Obligation | 10 | END_PERIOD | BRF: Expression | nvarchar | 20 | 0 | | |
11 | DFMCA_BRF670 | BRF: Filing Obligation Registration | 10 | END_PERIOD | BRF: Expression | nvarchar | 20 | 0 | | |
12 | DFMCA_BRF680 | BRF: Filing Obligation Deregistration | 9 | END_PERIOD | BRF: Expression | nvarchar | 20 | 0 | | |