| Property | Value |
|---|---|
| View Name | BM_TD_AGEING_MV |
| Subject Area | To-Do |
| ODI Package | BM_TD_AGEING_MV |
| ETL View | BM_TD_AGEING_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_TD |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| INACTIVE_03 | |||
| INACTIVE_06 | |||
| INACTIVE_09 | |||
| INACTIVE_12 | |||
| MON_FK | Foreign Key | ||
| DIV_FK | Foreign Key |
| Property | Value |
|---|---|
| View Name | BM_ACCT_BILL_CHRG_BY_DAY |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_ACCT_BILL_CHRG_BY_DAY |
| ETL View | BM_ACCT_BILL_CHRG_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_CALC_CCY | |||
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| ACCT_NBR | Account Identifier | ACCT_NBR | |
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PRD_CD | Account Product Code | PRD_CD | |
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| CORP_CALC_AMT | |||
| NUM_BILLABLE_CHG | |||
| DIV_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| BILL_MON_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_TD |
| Subject Area | To-Do |
| ODI Package | BM_TD |
| ETL View | BM_TD_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_TD |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CREATED | |||
| ASSIGNED | |||
| COMPLETED | |||
| OPEN_TASKS | |||
| IN_PROGRESS | |||
| OPEN_HOURS | |||
| ASSIGN_HOURS | |||
| COMP_HOURS | |||
| DIV_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| ACCT_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| TD_MESSAGE_FK | Foreign Key | ||
| TD_PRIORITY_FK | Foreign Key | ||
| TD_ROLE_FK | Foreign Key | ||
| TD_TYPE_FK | Foreign Key | ||
| TD_USER_FK | Foreign Key | ||
| DATE_FK | Foreign Key | ||
| MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_ADJUSTMENT_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_ADJUSTMENT_BY_DAY |
| ETL View | BM_ADJUSTMENT_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_ADJUSTMENT |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_ADJ_CCY | |||
| ADJ_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_ADJ_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_ADJ_CR_AMT | |||
| DIV_ADJ_DR_AMT | |||
| CORP_ADJ_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_ADJ_CR_AMT | |||
| CORP_ADJ_DR_AMT | |||
| DIV_FK | Foreign Key | ||
| ADJ_TYPE_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_ADJUSTMENT_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_ADJUSTMENT_BY_DAY |
| ETL View | BM_CUST_ADJUSTMENT_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_ADJUSTMENT |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_ADJ_CCY | |||
| ADJ_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_ADJ_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_ADJ_CR_AMT | |||
| DIV_ADJ_DR_AMT | |||
| CORP_ADJ_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_ADJ_CR_AMT | |||
| CORP_ADJ_DR_AMT | |||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| ADJ_TYPE_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_ADJUSTMENT_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_ADJUSTMENT_BY_MONTH |
| ETL View | BM_CUST_ADJUSTMENT_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_ADJUSTMENT |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_ADJ_CCY | |||
| ADJ_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_ADJ_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_ADJ_CR_AMT | |||
| DIV_ADJ_DR_AMT | |||
| CORP_ADJ_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_ADJ_CR_AMT | |||
| CORP_ADJ_DR_AMT | |||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| ADJ_TYPE_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_PAYMENT_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_PAYMENT_BY_DAY |
| ETL View | BM_CUST_PAYMENT_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAYMENT |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_PAY_CCY | |||
| PAY_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_PAY_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| CORP_PAY_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_PAYMENT_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_PAYMENT_BY_MONTH |
| ETL View | BM_CUST_PAYMENT_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAYMENT |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_PAY_CCY | |||
| PAY_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_PAY_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| CORP_PAY_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_PRDT_USAGE_BY_DAY |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_CUST_PRDT_USAGE_BY_DAY |
| ETL View | BM_CUST_PRDT_USAGE_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| AVL_SQI_CD1 | |||
| AVL_BILL_SQ1 | |||
| AVL_SQI_CD2 | |||
| AVL_BILL_SQ2 | |||
| AVL_SQI_CD3 | |||
| AVL_BILL_SQ3 | |||
| AVL_SQI_CD4 | |||
| AVL_BILL_SQ4 | |||
| AVL_SQI_CD5 | |||
| AVL_BILL_SQ5 | |||
| AVL_SQI_CD6 | |||
| AVL_BILL_SQ6 | |||
| AVL_SQI_CD7 | |||
| AVL_BILL_SQ7 | |||
| AVL_SQI_CD8 | |||
| AVL_BILL_SQ8 | |||
| AVL_SQI_CD9 | |||
| AVL_BILL_SQ9 | |||
| AVL_SQI_CD10 | |||
| AVL_BILL_SQ10 | |||
| AVL_SQI_CD11 | |||
| AVL_BILL_SQ11 | |||
| AVL_SQI_CD12 | |||
| AVL_BILL_SQ12 | |||
| AVL_SQI_CD13 | |||
| AVL_BILL_SQ13 | |||
| AVL_SQI_CD14 | |||
| AVL_BILL_SQ14 | |||
| AVL_SQI_CD15 | |||
| AVL_BILL_SQ15 | |||
| AVL_SQI_CD16 | |||
| AVL_BILL_SQ16 | |||
| AVL_SQI_CD17 | |||
| AVL_BILL_SQ17 | |||
| AVL_SQI_CD18 | |||
| AVL_BILL_SQ18 | |||
| AVL_SQI_CD19 | |||
| AVL_BILL_SQ19 | |||
| AVL_SQI_CD20 | |||
| AVL_BILL_SQ20 | |||
| AVL_SQI_CD21 | |||
| AVL_BILL_SQ21 | |||
| AVL_SQI_CD22 | |||
| AVL_BILL_SQ22 | |||
| AVL_SQI_CD23 | |||
| AVL_BILL_SQ23 | |||
| AVL_SQI_CD24 | |||
| AVL_BILL_SQ24 | |||
| AVL_SQI_CD25 | |||
| AVL_BILL_SQ25 | |||
| CUST_FK | Foreign Key | ||
| USAGE_ACCT_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time |
| Property | Value |
|---|---|
| View Name | BM_CUST_PRDT_USAGE_BY_MONTH |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_CUST_PRDT_USAGE_BY_MONTH |
| ETL View | BM_CUST_PRDT_USAGE_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| AVL_SQI_CD1 | |||
| AVL_BILL_SQ1 | |||
| AVL_SQI_CD2 | |||
| AVL_BILL_SQ2 | |||
| AVL_SQI_CD3 | |||
| AVL_BILL_SQ3 | |||
| AVL_SQI_CD4 | |||
| AVL_BILL_SQ4 | |||
| AVL_SQI_CD5 | |||
| AVL_BILL_SQ5 | |||
| AVL_SQI_CD6 | |||
| AVL_BILL_SQ6 | |||
| AVL_SQI_CD7 | |||
| AVL_BILL_SQ7 | |||
| AVL_SQI_CD8 | |||
| AVL_BILL_SQ8 | |||
| AVL_SQI_CD9 | |||
| AVL_BILL_SQ9 | |||
| AVL_SQI_CD10 | |||
| AVL_BILL_SQ10 | |||
| AVL_SQI_CD11 | |||
| AVL_BILL_SQ11 | |||
| AVL_SQI_CD12 | |||
| AVL_BILL_SQ12 | |||
| AVL_SQI_CD13 | |||
| AVL_BILL_SQ13 | |||
| AVL_SQI_CD14 | |||
| AVL_BILL_SQ14 | |||
| AVL_SQI_CD15 | |||
| AVL_BILL_SQ15 | |||
| AVL_SQI_CD16 | |||
| AVL_BILL_SQ16 | |||
| AVL_SQI_CD17 | |||
| AVL_BILL_SQ17 | |||
| AVL_SQI_CD18 | |||
| AVL_BILL_SQ18 | |||
| AVL_SQI_CD19 | |||
| AVL_BILL_SQ19 | |||
| AVL_SQI_CD20 | |||
| AVL_BILL_SQ20 | |||
| AVL_SQI_CD21 | |||
| AVL_BILL_SQ21 | |||
| AVL_SQI_CD22 | |||
| AVL_BILL_SQ22 | |||
| AVL_SQI_CD23 | |||
| AVL_BILL_SQ23 | |||
| AVL_SQI_CD24 | |||
| AVL_BILL_SQ24 | |||
| AVL_SQI_CD25 | |||
| AVL_BILL_SQ25 | |||
| AVL_SQI_CD01_DESCR | |||
| AVL_SQI_CD02_DESCR | |||
| AVL_SQI_CD03_DESCR | |||
| AVL_SQI_CD04_DESCR | |||
| AVL_SQI_CD05_DESCR | |||
| AVL_SQI_CD06_DESCR | |||
| AVL_SQI_CD07_DESCR | |||
| AVL_SQI_CD08_DESCR | |||
| AVL_SQI_CD09_DESCR | |||
| AVL_SQI_CD10_DESCR | |||
| AVL_SQI_CD11_DESCR | |||
| AVL_SQI_CD12_DESCR | |||
| AVL_SQI_CD13_DESCR | |||
| AVL_SQI_CD14_DESCR | |||
| AVL_SQI_CD15_DESCR | |||
| AVL_SQI_CD16_DESCR | |||
| AVL_SQI_CD17_DESCR | |||
| AVL_SQI_CD18_DESCR | |||
| AVL_SQI_CD19_DESCR | |||
| AVL_SQI_CD20_DESCR | |||
| AVL_SQI_CD21_DESCR | |||
| AVL_SQI_CD22_DESCR | |||
| AVL_SQI_CD23_DESCR | |||
| AVL_SQI_CD24_DESCR | |||
| AVL_SQI_CD25_DESCR | |||
| CUST_FK | Foreign Key | ||
| USAGE_ACCT_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time |
| Property | Value |
|---|---|
| View Name | BM_CUST_PROD_REV_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_PROD_REV_BY_DAY |
| ETL View | BM_CUST_PROD_REV_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_CALC_CCY | |||
| CALC_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_REV_AMT | |||
| DIV_TAX_AMT | |||
| CORP_CALC_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_REV_AMT | |||
| CORP_TAX_AMT | |||
| SRC_PRD_CD | Natural Key | ||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_PYMT_TNDR_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_PYMT_TNDR_BY_DAY |
| ETL View | BM_CUST_PYMT_TNDR_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAY_TNDR |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| CURRENCY_CD | Currency Code | CURRENCY_CD | |
| MONTH_NBR | |||
| YEAR | |||
| TENDER_AMT | Tender Amount | TENDER_AMT | |
| CORP_TENDER_AMT | |||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| TENDER_TYPE_FK | Foreign Key | ||
| TNDR_SOURCE_FK | Foreign Key | ||
| EVENT_PAY_DT_FK | Foreign Key | ||
| EVENT_PAY_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_PYMT_TNDR_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_PYMT_TNDR_BY_MONTH |
| ETL View | BM_CUST_PYMT_TNDR_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAY_TNDR |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| CURRENCY_CD | Currency Code | CURRENCY_CD | |
| MONTH_NBR | |||
| YEAR | |||
| TENDER_AMT | Tender Amount | TENDER_AMT | |
| CORP_TENDER_AMT | |||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| TENDER_TYPE_FK | Foreign Key | ||
| TNDR_SOURCE_FK | Foreign Key | ||
| EVENT_PAY_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_REVENUE_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_REVENUE_BY_DAY |
| ETL View | BM_CUST_REVENUE_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_CALC_CCY | |||
| CALC_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| YEAR | |||
| DIV_CALC_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_REVENUE_AMT | |||
| DIV_TAX_AMT | |||
| CORP_CALC_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_REVENUE_AMT | |||
| CORP_TAX_AMT | |||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_REVENUE_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_REVENUE_BY_MONTH |
| ETL View | BM_CUST_REVENUE_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_CALC_CCY | |||
| CALC_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| YEAR | |||
| DIV_CALC_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_REVENUE_AMT | |||
| DIV_TAX_AMT | |||
| CORP_CALC_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_REVENUE_AMT | |||
| CORP_TAX_AMT | |||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_DIST_PAYMENT_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_DIST_PAYMENT_BY_DAY |
| ETL View | BM_DIST_PAYMENT_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_GL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| DST_ID | Distribution Code | DST_ID | |
| DIST_DESCR | |||
| GL_ACCT | GL Account | GL_ACCT | |
| MONTH_NBR | |||
| MON_YEAR | |||
| GL_AMT | |||
| GL_CONTRA_AMT | |||
| CORP_CCY | |||
| CORP_GL_AMT | |||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| DST_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_FT_EXEC_SUMMARY |
| Subject Area | Financial Transaction |
| ODI Package | BM_FT_EXEC_SUMMARY |
| ETL View | BM_FT_EXEC_SUMMARY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE, BF_ADJUSTMENT, BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| MAIN_TYPE | |||
| SUB_MAIN_TYPE | |||
| CORP_CCY | |||
| AMT | |||
| MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PAYMENT_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_PAYMENT_BY_DAY |
| ETL View | BM_PAYMENT_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAYMENT |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_PAY_CCY | |||
| PAY_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_PAY_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| CORP_CCY | |||
| CORP_CNCL_AMT | |||
| CORP_PAY_AMT | |||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PL_BILL_CHRG_BY_DAY |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PL_BILL_CHRG_BY_DAY |
| ETL View | BM_PL_BILL_CHRG_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CALC_CCY | |||
| PRICELIST_ID | Price List ID | PRICELIST_ID | |
| PRICELIST_DESCR | |||
| PRICE_ASGN_ID | Price Assignment ID | PRICE_ASGN_ID | |
| LOWER_LIMIT | Lower limit | LOWER_LIMIT | |
| UPPER_LIMIT | Upper Limit | UPPER_LIMIT | |
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PRD_CD | Account Product Code | PRD_CD | |
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| CORP_CCY | |||
| CORP_CALC_AMT | |||
| DIV_FK | Foreign Key | ||
| PRICELIST_ID_FK | Foreign Key | ||
| PRICE_ASGN_ID_FK | Foreign Key | ||
| PRICE_COMP_ID_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| BILL_DT_FK | Foreign Key | ||
| BILL_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PRICELINE |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PRICELINE |
| ETL View | BM_PRICELINE_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BD_PRICEASGN, BD_PRICECOMP, BD_PRODUCT, BD_PRICELIST |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| PRICE_ASGN_ID | Price Assignment ID | PRICE_ASGN_ID | |
| PRODUCT_CD | Product Code | PRODUCT_CD | |
| BUNDLE_CD | |||
| PRODUCT_DESCR | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| TIER_TYPE_FLAG | |||
| PA_CCY_CD | |||
| PA_TYPE_FLAG | PA Type Flag | PA_TYPE_FLAG | |
| TIER_TYPE_DESCR | |||
| RATE_TYPE_FLG | |||
| RATE_TYPE_DESCR | |||
| APPLIED_ON_SQ_CD | |||
| APPLIED_ON_SQ_DESCR | |||
| BASED_ON_SQ_CD | |||
| BASED_ON_SQ_DESCR | |||
| PRICE_LINE_DESCR | |||
| PRICELIST_ID | Price List ID | PRICELIST_ID | |
| PRICE_STATUS_DESCR | |||
| IGNORE_SW | Ignore Transaction | IGNORE_SW | |
| PA_START_DT | Price Assignment Start Date | PA_START_DT | |
| PA_END_DT | Price Assignment End Date | PA_END_DT | |
| COMP_KEY1 | |||
| COMP_KEY2 | |||
| COMP_KEY3 | |||
| COMP_KEY4 | |||
| COMP_KEY5 | |||
| PRICECRITERIA_CD | Tiering Criteria | PRICECRITERIA_CD | |
| PARAM_CD1 | |||
| PARAM_CD2 | |||
| PARAM_CD3 | |||
| PARAM_CD4 | |||
| PARAM_CD5 | |||
| PARAM_CD6 | |||
| PARAM_CD7 | |||
| PARAM_CD8 | |||
| PARAM_CD9 | |||
| PARAM_CD10 | |||
| PARAM_VAL1 | |||
| PARAM_VAL2 | |||
| PARAM_VAL3 | |||
| PARAM_VAL4 | |||
| PARAM_VAL5 | |||
| PARAM_VAL6 | |||
| PARAM_VAL7 | |||
| PARAM_VAL8 | |||
| PARAM_VAL9 | |||
| PARAM_VAL10 | |||
| PRICE_LINE_KEY | Surrogate Key | ||
| PRODUCT_FK | Foreign Key | ||
| PRICELIST_FK | Foreign Key | ||
| PRICEASGN_FK | Foreign Key | ||
| DATA_SOURCE_IND | Data Source Indicator | This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID) | |
| EFF_START_DTTM | Effective Start Date/Time |
| Property | Value |
|---|---|
| View Name | BM_PRICE_BCH_BY_DAY |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PRICE_BCH_BY_DAY |
| ETL View | BM_PRICE_BCH_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CALC_CCY | |||
| DIV_CALC_CCY | |||
| MANUAL_BCH_AMT | |||
| MANUAL_BCH_DIV_AMT | |||
| MANUAL_BCH_CORP_AMT | |||
| MANUAL_BCH_CNT | |||
| THRU_FEED_BCH_AMT | |||
| THRU_FEED_BCH_DIV_AMT | |||
| THRU_FEED_BCH_CORP_AMT | |||
| THRU_FEED_BCH_CNT | |||
| MEMO_BCH_AMT | |||
| MEMO_BCH_DIV_AMT | |||
| MEMO_BCH_CORP_AMT | |||
| MEMO_BCH_CNT | |||
| PASS_THRU_BCH_AMT | |||
| PASS_THRU_BCH_DIV_AMT | |||
| PASS_THRU_BCH_CORP_AMT | |||
| PASS_THRU_BCH_CNT | |||
| TIERED_STEP_CNT | |||
| TIERED_THRS_CNT | |||
| TIERED_FLAT_CNT | |||
| PER_TRANS_CNT | |||
| AGG_TRANS_CNT | |||
| PA_STANDARD_CNT | |||
| PA_AGREED_CNT | |||
| PRODUCT_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PRICE_BY_CUSTOMER |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PRICE_BY_CUSTOMER |
| ETL View | BM_PRICE_BY_CUSTOMER_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| PRODUCT_CD | Product Code | PRODUCT_CD | |
| PROD_DESCR | |||
| CALC_AMT | Calculated Amount | CALC_AMT | |
| CALC_CCY | |||
| DIV_CALC_AMT | |||
| DIV_CALC_CCY | |||
| MIN_PRICE | |||
| MAX_PRICE | |||
| AVG_PRICE | |||
| MIN_CHARGES | |||
| MAX_CHARGES | |||
| BILLABLE_CHG_CNT | |||
| STANDARD_AMT | |||
| STANDARD_CNT | |||
| AGGREED_AMT | |||
| AGGREED_CNT | |||
| DIV_FK | Foreign Key | ||
| INV_CUST_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| USAGE_ACCT_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time |
| Property | Value |
|---|---|
| View Name | BM_PRICE_BY_CUSTOMER_BY_DAY |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PRICE_BY_CUSTOMER_BY_DAY |
| ETL View | BM_PRICE_BY_CUSTOMER_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| PRODUCT_CD | Product Code | PRODUCT_CD | |
| PROD_DESCR | |||
| CALC_AMT | Calculated Amount | CALC_AMT | |
| CALC_CCY | |||
| DIV_CALC_AMT | |||
| DIV_CALC_CCY | |||
| MIN_PRICE | |||
| MAX_PRICE | |||
| AVG_PRICE | |||
| MIN_CHARGES | |||
| MAX_CHARGES | |||
| BILLABLE_CHG_CNT | |||
| STANDARD_AMT | |||
| STANDARD_CNT | |||
| AGGREED_AMT | |||
| AGGREED_CNT | |||
| DIV_FK | Foreign Key | ||
| INV_CUST_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| USAGE_ACCT_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time |
| Property | Value |
|---|---|
| View Name | BM_PROD_BILL_CHRG_BY_DAY |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PROD_BILL_CHRG_BY_DAY |
| ETL View | BM_PROD_BILL_CHRG_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CALC_CCY | |||
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PRD_CD | Account Product Code | PRD_CD | |
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| CORP_CCY | |||
| CORP_CALC_AMT | |||
| DIV_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| BILL_DT_FK | Foreign Key | ||
| BILL_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PROD_REVENUE_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_PROD_REVENUE_BY_DAY |
| ETL View | BM_PROD_REVENUE_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CALC_CCY | |||
| CALC_CCY | |||
| CORP_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_REVENUE_AMT | |||
| DIV_TAX_AMT | |||
| CORP_CALC_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_REVENUE_AMT | |||
| CORP_TAX_AMT | |||
| SRC_PRD_CD | Natural Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PROPOSAL_BY_DAY |
| Subject Area | Service Agreement |
| ODI Package | BM_PROPOSAL_BY_DAY |
| ETL View | BM_PROPOSAL_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_SA |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CAL_DATE | |||
| OPEN_PROPOSALS | |||
| ACCEPTED_PROPOSALS | |||
| DECLINED_PROPOSALS | |||
| REASON_DESCR | |||
| MON_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PROPOSAL_BY_MONTH |
| Subject Area | Service Agreement |
| ODI Package | BM_PROPOSAL_BY_MONTH |
| ETL View | BM_PROPOSAL_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_SA |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| MONTH_NAME | |||
| YEAR | |||
| OPEN_PROPOSALS | |||
| ACCEPTED_PROPOSALS | |||
| DECLINED_PROPOSALS | |||
| REASON_DESCR | |||
| MON_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PYMT_TNDR_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_PYMT_TNDR_BY_DAY |
| ETL View | BM_PYMT_TNDR_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAY_TNDR |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| CURRENCY_CD | Currency Code | CURRENCY_CD | |
| MONTH_NBR | |||
| YEAR | |||
| TENDER_AMT | Tender Amount | TENDER_AMT | |
| CORP_TENDER_AMT | |||
| DIV_FK | Foreign Key | ||
| TENDER_TYPE_FK | Foreign Key | ||
| TNDR_SOURCE_FK | Foreign Key | ||
| EVENT_PAY_DT_FK | Foreign Key | ||
| EVENT_PAY_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PYMT_TNDR_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_PYMT_TNDR_BY_MONTH |
| ETL View | BM_PYMT_TNDR_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAY_TNDR |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| CURRENCY_CD | Currency Code | CURRENCY_CD | |
| MONTH_NBR | |||
| YEAR | |||
| TENDER_AMT | Tender Amount | TENDER_AMT | |
| CORP_TENDER_AMT | |||
| DIV_FK | Foreign Key | ||
| TENDER_TYPE_FK | Foreign Key | ||
| TNDR_SOURCE_FK | Foreign Key | ||
| EVENT_PAY_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_REVENUE_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_REVENUE_BY_DAY |
| ETL View | BM_REVENUE_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_CALC_CCY | |||
| CALC_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| YEAR | |||
| DIV_CALC_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_REVENUE_AMT | |||
| DIV_TAX_AMT | |||
| CORP_CALC_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_REVENUE_AMT | |||
| CORP_TAX_AMT | |||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_SA_AGEING_BY_DAY |
| Subject Area | Service Agreement |
| ODI Package | BM_SA_AGEING_BY_DAY |
| ETL View | BM_SA_AGEING_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_SA |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CAL_DATE | |||
| INACTIVE_30 | |||
| INACTIVE_60 | |||
| INACTIVE_90 | |||
| INACTIVE_120 | |||
| DIV_FK | Foreign Key |
| Property | Value |
|---|---|
| View Name | BM_SA_LIFE_CYCLE_BY_DAY |
| Subject Area | Service Agreement |
| ODI Package | BM_SA_LIFE_CYCLE_BY_DAY |
| ETL View | BM_SA_LIFE_CYCLE_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_SA |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CAL_DATE | |||
| NEW_CONTRACTS | |||
| LOST_CONTRACTS | |||
| PREMATURE_CLOSURES | |||
| OPEN_CONTRACTS | |||
| CHURN | |||
| OPEN_PROPOSALS | |||
| ACCEPTED_PROPOSALS | |||
| DECLINED_PROPOSALS | |||
| MONTH_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_SA_LIFE_CYCLE_BY_MONTH |
| Subject Area | Service Agreement |
| ODI Package | BM_SA_LIFE_CYCLE_BY_MONTH |
| ETL View | BM_SA_LIFE_CYCLE_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_SA |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| MONTH_NAME | |||
| YEAR | |||
| NEW_CONTRACTS | |||
| LOST_CONTRACTS | |||
| PREMATURE_CLOSURES | |||
| OPEN_CONTRACTS | |||
| CHURN | |||
| INACTIVE_SINCE_3_MONTHS | |||
| OPEN_PROPOSALS | |||
| ACCEPTED_PROPOSALS | |||
| DECLINED_PROPOSALS | |||
| MONTH_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_SA_REVENUE_BY_DAY |
| Subject Area | Service Agreement |
| ODI Package | BM_SA_REVENUE_BY_DAY |
| ETL View | BM_SA_REVENUE_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CALC_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_DESCR | |||
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| ACCT_NBR | Account Identifier | ACCT_NBR | |
| SA_ID | Contract | SA_ID | |
| MONTH_NBR | |||
| YEAR | |||
| END_MONTH_NBR | |||
| END_YEAR | |||
| DIV_CALC_AMT | |||
| CORP_CCY | |||
| CORP_CALC_AMT | |||
| MON_YEAR | |||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| FREEZE_DT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| END_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_TD_AGEING_BY_DAY |
| Subject Area | To-Do |
| ODI Package | BM_TD_AGEING_BY_DAY |
| ETL View | BM_TD_AGEING_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_TD |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CAL_DATE | |||
| INACTIVE_30 | |||
| INACTIVE_60 | |||
| INACTIVE_90 | |||
| INACTIVE_120 | |||
| DIV_FK | Foreign Key |
| Property | Value |
|---|---|
| View Name | BM_TD_BY_DAY |
| Subject Area | To-Do |
| ODI Package | BM_TD_BY_DAY |
| ETL View | BM_TD_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_TD |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CAL_DATE | |||
| CREATED | |||
| ASSIGNED | |||
| COMPLETED | |||
| OPEN_TASKS | |||
| IN_PROGRESS | |||
| OPEN_HOURS | |||
| ASSIGN_HOURS | |||
| COMP_HOURS | |||
| DIV_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| ACCT_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| TD_MESSAGE_FK | Foreign Key | ||
| TD_PRIORITY_FK | Foreign Key | ||
| TD_ROLE_FK | Foreign Key | ||
| TD_TYPE_FK | Foreign Key | ||
| TD_USER_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_TD_DETAILS |
| Subject Area | To-Do |
| ODI Package | BM_TD_DETAILS |
| ETL View | BM_TD_DETAILS_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_TD |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| TD_ENTRY_ID | To Do ID | TD_ENTRY_ID | |
| TASK_STATUS | |||
| OPEN_HOURS | |||
| ASSIGN_HOURS | |||
| COMP_HOURS | |||
| DIV_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| ACCT_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| TD_MESSAGE_FK | Foreign Key | ||
| TD_PRIORITY_FK | Foreign Key | ||
| TD_ROLE_FK | Foreign Key | ||
| TD_TYPE_FK | Foreign Key | ||
| TD_USER_FK | Foreign Key | ||
| DATE_FK | Foreign Key | ||
| MON_FK | Foreign Key | ||
| CREATE_DT_FK | Foreign Key | ||
| ASSIGN_DT_FK | Foreign Key | ||
| COMP_DT_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_TD_DETAILS_BY_DAY |
| Subject Area | To-Do |
| ODI Package | BM_TD_DETAILS_BY_DAY |
| ETL View | BM_TD_DETAILS_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_TD |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CAL_DATE | |||
| TD_ENTRY_ID | To Do ID | TD_ENTRY_ID | |
| TASK_STATUS | |||
| OPEN_HOURS | |||
| ASSIGN_HOURS | |||
| COMP_HOURS | |||
| DIV_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| ACCT_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| TD_MESSAGE_FK | Foreign Key | ||
| TD_PRIORITY_FK | Foreign Key | ||
| TD_ROLE_FK | Foreign Key | ||
| TD_TYPE_FK | Foreign Key | ||
| TD_USER_FK | Foreign Key | ||
| CREATE_DT_FK | Foreign Key | ||
| ASSIGN_DT_FK | Foreign Key | ||
| COMP_DT_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_UNREALIZED_PYMT_BY_DAY |
| Subject Area | Financial Transaction |
| ODI Package | BM_UNREALIZED_PYMT_BY_DAY |
| ETL View | BM_UNREALIZED_PYMT_BY_DAY_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAY_EXCP |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CAL_DATE | |||
| PAY_EXCP_TYPE | |||
| PAY_EXCP_FLG | Payment Exception Type | PAY_EXCP_FLG | |
| PAY_EXCP_FLG_DESCR | |||
| PAY_TYPE | |||
| PAY_COUNT | |||
| DIV_FK | Foreign Key | ||
| TENDER_TYPE_FK | Foreign Key | ||
| TNDR_SOURCE_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_UNREALIZED_PYMT_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_UNREALIZED_PYMT_BY_MONTH |
| ETL View | BM_UNREALIZED_PYMT_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAY_EXCP |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| PAY_EXCP_TYPE | |||
| PAY_EXCP_FLG | Payment Exception Type | PAY_EXCP_FLG | |
| PAY_EXCP_FLG_DESCR | |||
| PAY_TYPE | |||
| PAY_COUNT | |||
| MON_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| TENDER_TYPE_FK | Foreign Key | ||
| TNDR_SOURCE_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_PROD_REV_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_CUST_PROD_REV_BY_MONTH |
| ETL View | BM_CUST_PROD_REV_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_CALC_CCY | |||
| CALC_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_REV_AMT | |||
| DIV_TAX_AMT | |||
| CORP_CALC_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_REV_AMT | |||
| CORP_TAX_AMT | |||
| SRC_PRD_CD | Natural Key | ||
| CUST_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_CUST_PRICING_BY_MONTH |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_CUST_PRICING_BY_MONTH |
| ETL View | BM_CUST_PRICING_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CALC_CCY | |||
| RCMAP_TIERED_FLAG | |||
| RC_TYPE_FLG | Rate Component Type | RC_TYPE_FLG | |
| RC_TYPE_DESCR | |||
| LOWER_LIMIT | Lower limit | LOWER_LIMIT | |
| IN_LIMIT1 | |||
| IN_LIMIT2 | |||
| IN_LIMIT3 | |||
| UPPER_LIMIT | Upper Limit | UPPER_LIMIT | |
| PRICE | |||
| BILL_SQ_CD | |||
| BILL_SQ | Billable Service Quantity | BILL_SQ | |
| BILL_SQ_DESCR | |||
| THR_SQ | |||
| IN_LIMIT1_SQ | |||
| IN_LIMIT2_SQ | |||
| IN_LIMIT3_SQ | |||
| IN_LIMIT4_SQ | |||
| DIV_CALC_AMT | |||
| NUM_BILLABLE_CHG | |||
| DIV_TOT_AMT | |||
| PARENT_AMT | |||
| PROD_AMT | |||
| DIV_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| INV_CUST_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| PRICELIST_ID_FK | Foreign Key | ||
| PRICE_ASGN_ID_FK | Foreign Key | ||
| PRICE_COMP_ID_FK | Foreign Key | ||
| PRICE_LINE_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PL_PRICING_BY_MONTH |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PL_PRICING_BY_MONTH |
| ETL View | BM_PL_PRICING_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CALC_CCY | |||
| RCMAP_TIERED_FLAG | |||
| RC_TYPE_FLG | Rate Component Type | RC_TYPE_FLG | |
| RC_TYPE_DESCR | |||
| LOWER_LIMIT | Lower limit | LOWER_LIMIT | |
| IN_LIMIT1 | |||
| IN_LIMIT2 | |||
| IN_LIMIT3 | |||
| UPPER_LIMIT | Upper Limit | UPPER_LIMIT | |
| PRICE | |||
| BILL_SQ_CD | |||
| BILL_SQ | Billable Service Quantity | BILL_SQ | |
| BILL_SQ_DESCR | |||
| THR_SQ | |||
| IN_LIMIT1_SQ | |||
| IN_LIMIT2_SQ | |||
| IN_LIMIT3_SQ | |||
| IN_LIMIT4_SQ | |||
| DIV_CALC_AMT | |||
| NUM_BILLABLE_CHG | |||
| DIV_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| INV_CUST_FK | Foreign Key | ||
| PRICELIST_ID_FK | Foreign Key | ||
| PRICE_ASGN_ID_FK | Foreign Key | ||
| PRICE_COMP_ID_FK | Foreign Key | ||
| PRICE_LINE_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_BILL_ARREARS_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_BILL_ARREARS_BY_MONTH |
| ETL View | BM_BILL_ARREARS_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| AMOUNT | Monetary Amount | AMOUNT | |
| SRC_BSEG_ID | Natural Key | ||
| BILL_CYC_SCH_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| MONTH_FK | Foreign Key | ||
| ARS_DT_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_BILL_DET_OPS_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_BILL_DET_OPS_BY_MONTH |
| ETL View | BM_BILL_DET_OPS_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| NUM_ERRORS | |||
| NUM_BILL_SEG | |||
| NUM_NEGATIVE_BILL | |||
| NUM_ZERO_AMOUNT | |||
| NUM_REVIEWED_BILL | |||
| NUM_AMOUNT_EXCEEDS_THRS | |||
| NUM_CALC_LINES | |||
| AVERAGE_CALC_LINES | |||
| AVERAGE_BILLED_AMOUNT | |||
| BILL_CYC_SCH_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| MONTH_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_BILL_OPS_BY_MONTH |
| Subject Area | Financial Transaction |
| ODI Package | BM_BILL_OPS_BY_MONTH |
| ETL View | BM_BILL_OPS_BY_MONTH_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| NUM_ERRORS | |||
| NUM_BILL_LINES | |||
| NUM_NEGATIVE_BILL | |||
| NUM_ZERO_AMOUNT | |||
| NUM_REVIEWED_BILL | |||
| NUM_AMOUNT_EXCEEDS_THRS | |||
| NUM_CALC_LINES | |||
| AVERAGE_CALC_LINES | |||
| AVERAGE_BILLED_AMOUNT | |||
| BILL_CYC_SCH_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| MONTH_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_DIST_PAYMENT_BY_MONTH_MV |
| Subject Area | Financial Transaction General Ledger |
| ODI Package | BM_DIST_PAYMENT_BY_MONTH_MV |
| ETL View | BM_DIST_PAYMENT_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_GL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| DST_ID | Distribution Code | DST_ID | |
| DIST_DESCR | |||
| GL_ACCT | GL Account | GL_ACCT | |
| MONTH_NBR | |||
| MON_YEAR | |||
| GL_AMT | |||
| GL_CONTRA_AMT | |||
| CORP_CCY | |||
| CORP_GL_AMT | |||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| DST_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_ACCT_BILL_CHRG_BY_MONTH_MV |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_ACCT_BILL_CHRG_BY_MONTH_MV |
| ETL View | BM_ACCT_BILL_CHRG_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_CALC_CCY | |||
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| ACCT_NBR | Account Identifier | ACCT_NBR | |
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PRD_CD | Account Product Code | PRD_CD | |
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| CORP_CALC_AMT | |||
| NUM_BILLABLE_CHG | |||
| DIV_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| BILL_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PL_BILL_CHRG_BY_MONTH_MV |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PL_BILL_CHRG_BY_MONTH_MV |
| ETL View | BM_PL_BILL_CHRG_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CALC_CCY | |||
| PRICELIST_ID | Price List ID | PRICELIST_ID | |
| PRICELIST_DESCR | |||
| PRICE_ASGN_ID | Price Assignment ID | PRICE_ASGN_ID | |
| LOWER_LIMIT | Lower limit | LOWER_LIMIT | |
| UPPER_LIMIT | Upper Limit | UPPER_LIMIT | |
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PRD_CD | Account Product Code | PRD_CD | |
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| CORP_CCY | |||
| CORP_CALC_AMT | |||
| DIV_FK | Foreign Key | ||
| PRICELIST_ID_FK | Foreign Key | ||
| PRICE_ASGN_ID_FK | Foreign Key | ||
| PRICE_COMP_ID_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| BILL_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PROD_BILL_CHRG_BY_MONTH_MV |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PROD_BILL_CHRG_BY_MONTH_MV |
| ETL View | BM_PROD_BILL_CHRG_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CALC_CCY | |||
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PRD_CD | Account Product Code | PRD_CD | |
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| CORP_CCY | |||
| CORP_CALC_AMT | |||
| DIV_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| BILL_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_REVENUE_BY_MONTH_MV |
| Subject Area | Financial Transaction |
| ODI Package | BM_REVENUE_BY_MONTH_MV |
| ETL View | BM_REVENUE_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_CALC_CCY | |||
| CALC_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| YEAR | |||
| DIV_CALC_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_REVENUE_AMT | |||
| DIV_TAX_AMT | |||
| CORP_CALC_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_REVENUE_AMT | |||
| CORP_TAX_AMT | |||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PAYMENT_BY_MONTH_MV |
| Subject Area | Financial Transaction |
| ODI Package | BM_PAYMENT_BY_MONTH_MV |
| ETL View | BM_PAYMENT_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PAYMENT |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_PAY_CCY | |||
| PAY_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_PAY_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| CORP_CCY | |||
| CORP_CNCL_AMT | |||
| CORP_PAY_AMT | |||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PROD_REVENUE_BY_MONTH_MV |
| Subject Area | Financial Transaction |
| ODI Package | BM_PROD_REVENUE_BY_MONTH_MV |
| ETL View | BM_PROD_REVENUE_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CALC_CCY | |||
| CALC_CCY | |||
| CORP_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| L2_PARENT_CD | |||
| L2_PARENT_DESC | |||
| L1_PARENT_CD | |||
| L1_PARENT_DESC | |||
| PROD_DESCR | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_CALC_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_REVENUE_AMT | |||
| DIV_TAX_AMT | |||
| CORP_CALC_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_REVENUE_AMT | |||
| CORP_TAX_AMT | |||
| SRC_PRD_CD | Natural Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| PRODUCT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_SA_REVENUE_BY_MONTH_MV |
| Subject Area | Service Agreement |
| ODI Package | BM_SA_REVENUE_BY_MONTH_MV |
| ETL View | BM_SA_REVENUE_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_BILL |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| DIV_CALC_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_DESCR | |||
| CUST_ID | Customer ID | CUST_ID | |
| CUST_NAME | |||
| ACCT_NBR | Account Identifier | ACCT_NBR | |
| SA_ID | Contract | SA_ID | |
| MONTH_NBR | |||
| YEAR | |||
| END_MONTH_NBR | |||
| END_YEAR | |||
| DIV_CALC_AMT | |||
| CORP_CCY | |||
| CORP_CALC_AMT | |||
| MON_YEAR | |||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| CUST_FK | Foreign Key | ||
| INV_ACCT_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| END_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_PRICE_BCH_MV |
| Subject Area | Pricing and Billable Charge |
| ODI Package | BM_PRICE_BCH_MV |
| ETL View | BM_PRICE_BCH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_PRICE |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CALC_CCY | |||
| DIV_CALC_CCY | |||
| MANUAL_BCH_AMT | |||
| MANUAL_BCH_DIV_AMT | |||
| MANUAL_BCH_CORP_AMT | |||
| MANUAL_BCH_CNT | |||
| THRU_FEED_BCH_AMT | |||
| THRU_FEED_BCH_DIV_AMT | |||
| THRU_FEED_BCH_CORP_AMT | |||
| THRU_FEED_BCH_CNT | |||
| MEMO_BCH_AMT | |||
| MEMO_BCH_DIV_AMT | |||
| MEMO_BCH_CORP_AMT | |||
| MEMO_BCH_CNT | |||
| PASS_THRU_BCH_AMT | |||
| PASS_THRU_BCH_DIV_AMT | |||
| PASS_THRU_BCH_CORP_AMT | |||
| PASS_THRU_BCH_CNT | |||
| TIERED_STEP_CNT | |||
| TIERED_THRS_CNT | |||
| TIERED_FLAT_CNT | |||
| PER_TRANS_CNT | |||
| AGG_TRANS_CNT | |||
| PA_STANDARD_CNT | |||
| PA_AGREED_CNT | |||
| PRODUCT_FK | Foreign Key | ||
| DIV_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |
| Property | Value |
|---|---|
| View Name | BM_SA_AGEING_MV |
| Subject Area | Service Agreement |
| ODI Package | BM_SA_AGEING_MV |
| ETL View | BM_SA_AGEING_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_SA |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| INACTIVE_03 | |||
| INACTIVE_06 | |||
| INACTIVE_09 | |||
| INACTIVE_12 | |||
| DIV_FK | Foreign Key | ||
| MON_FK | Foreign Key |
| Property | Value |
|---|---|
| View Name | BM_ADJUSTMENT_BY_MONTH_MV |
| Subject Area | Financial Transaction |
| ODI Package | BM_ADJUSTMENT_BY_MONTH_MV |
| ETL View | BM_ADJUSTMENT_BY_MONTH_MV_VW |
| Scheduling Frequency | Daily Once |
| Refresh type | On Demand |
| Associated Fact table | BF_ADJUSTMENT |
| Target Field | Field Description | Source Field | Transformation or Calculation Logic |
|---|---|---|---|
| DIV_CD | |||
| DIV_DESCR | |||
| CORP_CALC_CCY | |||
| DIV_ADJ_CCY | |||
| ADJ_CCY | |||
| SA_TYPE_CD | Contract Type | SA_TYPE_CD | |
| SA_TYPE_DESC | |||
| CUST_CL_CD | Customer Class | CUST_CL_CD | |
| CUST_CL_VAL | |||
| MONTH_NBR | |||
| MON_YEAR | |||
| DIV_ADJ_AMT | |||
| DIV_CNCL_AMT | |||
| DIV_NET_AMT | |||
| DIV_ADJ_CR_AMT | |||
| DIV_ADJ_DR_AMT | |||
| CORP_ADJ_AMT | |||
| CORP_CNCL_AMT | |||
| CORP_NET_AMT | |||
| CORP_ADJ_CR_AMT | |||
| CORP_ADJ_DR_AMT | |||
| DIV_FK | Foreign Key | ||
| ADJ_TYPE_FK | Foreign Key | ||
| SA_TYPE_FK | Foreign Key | ||
| FREEZE_MON_FK | Foreign Key | ||
| ILM_DTM | Information Lifecycle Management Date/Time | ||
| FACT_CNT | Fact count | 1 |