| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CMCBC_APPR_PROC | Assign Approval Process | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
2 | CMCBC_APPR_PROCN | Assign Approval Process | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
3 | CMCBC_ASSIGN_CTP | Assign Cash Budgeting Cycle Type to Be Checked | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
4 | CMCBC_CHK_RULE | Cash Budgeting Check Rule | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
5 | CMCBC_CYCLE_TP | Cash Budget Cycle Type | 2 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
6 | CMCBC_CYCLE_TP_T | Cash Budget Cycle Type Text | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
7 | CMCBC_NOTIFY_CTL | Cash Budgeting Notification and Alert Control | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
8 | CMCBC_PCS_ASSIGN | Assign Payment Control Strategy | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
9 | CMCBC_ROLL_TEMP | Rolling template | 5 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
10 | CMCBD_CYCLE | Cash Budgeting Cycle | 4 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
11 | CMCBD_ORG_QUERY | Organizational Hierarchy Query Assignment | 4 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
12 | CMCBD_PC_RL_CONT | Cash Budget: Payment control - relative control content | 4 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
13 | CMCBD_PC_SG_CONT | Cash Budget: Payment control rule - Single Control Content | 4 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
14 | CMCBD_PL_LAYOUT | Planning Layout master table | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
15 | CMCBD_PL_LIQ_DIM | Planning liquidity item and dimension | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
16 | CMCBD_PL_LIQ_PRI | Planning liquidity item priority and based on suggest level | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
17 | CMCBD_PL_LIQ_SC | Planning liquidity item and source | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |
18 | CMCBD_PL_TPLT | Cash Budgeting Liquidity Item Assignment Template | 3 | CYCLE_TYPE | Cycle Type | nvarchar | 4 | 0 | | |