Mapping Document

_{Generated on Tue, Nov 1, '16 based on ORMBA 2.2.1.0.0}

Dimensions

Name

Description

BD_ACCT

Account Dimension

BD_ADJ_TYPE

Adjustment Type Dimension

BD_ADJ_UDD1

Adjustment User Defined Dimension1

BD_ADJ_UDD2

Adjustment User Defined Dimension2

BD_ADJ_UDD3

Adjustment User Defined Dimension3

BD_ADJ_UDD4

Adjustment User Defined Dimension4

BD_ADJ_UDD5

Adjustment User Defined Dimension5

BD_BILL_CYC_SCH

Dimension for billing schedule.

BD_BILL_EXCP_UDD1

Dimension for billing error1.

BD_BILL_EXCP_UDD2

Dimension for billing error2.

BD_BILL_EXCP_UDD3

Dimension for billing error3.

BD_BILL_EXCP_UDD4

Dimension for billing error4.

BD_BILL_EXCP_UDD5

Dimension for billing error5.

BD_BILL_UDD1

Bill User Defined Dimension1

BD_BILL_UDD2

Bill User Defined Dimension2

BD_BILL_UDD3

Bill User Defined Dimension3

BD_BILL_UDD4

Bill User Defined Dimension4

BD_BILL_UDD5

Bill User Defined Dimension5

BD_CUST

Customer Dimension

BD_DIVISION

Division Dimension

BD_DST_CODE

Distribution Code Dimension

BD_FEED_UDD1

Feed User Defined Dimension1

BD_FEED_UDD2

Feed User Defined Dimension2

BD_FEED_UDD3

Feed User Defined Dimension3

BD_FEED_UDD4

Feed User Defined Dimension4

BD_FEED_UDD5

Feed User Defined Dimension5

BD_FISCAL_CAL

Fiscal Calendar Dimension

BD_GL_UDD1

General Ledger User Defined Dimension1

BD_GL_UDD2

General Ledger User Defined Dimension2

BD_GL_UDD3

General Ledger User Defined Dimension3

BD_GL_UDD4

General Ledger User Defined Dimension4

BD_GL_UDD5

General Ledger User Defined Dimension5

BD_MSG

Message Dimension

BD_PAY_EXCP_UDD1

Payment Expection User Defined Dimension1

BD_PAY_EXCP_UDD2

Payment Expection User Defined Dimension2

BD_PAY_EXCP_UDD3

Payment Expection User Defined Dimension3

BD_PAY_EXCP_UDD4

Payment Expection User Defined Dimension4

BD_PAY_EXCP_UDD5

Payment Expection User Defined Dimension5

BD_PAY_TNDR_UDD1

Pay Tender User Defined Dimension1

BD_PAY_TNDR_UDD2

Pay Tender User Defined Dimension2

BD_PAY_TNDR_UDD3

Pay Tender User Defined Dimension3

BD_PAY_TNDR_UDD4

Pay Tender User Defined Dimension4

BD_PAY_TNDR_UDD5

Pay Tender User Defined Dimension5

BD_PAY_UDD1

Payment User Defined Dimension1

BD_PAY_UDD2

Payment User Defined Dimension2

BD_PAY_UDD3

Payment User Defined Dimension3

BD_PAY_UDD4

Payment User Defined Dimension4

BD_PAY_UDD5

Payment User Defined Dimension5

BD_PRICEASGN

Prie Assignment Dimension

BD_PRICECOMP

Price Component Dimension

BD_PRICELIST

Price List Dimension

BD_PRICE_BUNDLE

Price Bundle Dimension

BD_PRICE_UDD1

Price User Defined Dimension1

BD_PRICE_UDD2

Price User Defined Dimension2

BD_PRICE_UDD3

Price User Defined Dimension3

BD_PRICE_UDD4

Price User Defined Dimension4

BD_PRICE_UDD5

Price User Defined Dimension5

BD_PRODUCT

Product Dimension

BD_RATE

Rate Dimension

BD_REFUND_UDD1

Refund User Defined Dimension1

BD_REFUND_UDD2

Refund User Defined Dimension2

BD_REFUND_UDD3

Refund User Defined Dimension3

BD_REFUND_UDD4

Refund User Defined Dimension4

BD_REFUND_UDD5

Refund User Defined Dimension5

BD_SA_TYPE

Service Agreement Type Dimension

BD_SA_UDD1

Service Agreement User Defined Dimension1

BD_SA_UDD2

Service Agreement User Defined Dimension2

BD_SA_UDD3

Service Agreement User Defined Dimension3

BD_SA_UDD4

Service Agreement User Defined Dimension4

BD_SA_UDD5

Service Agreement User Defined Dimension5

BD_TD_PRIORITY

To-Do Priority Dimension

BD_TD_ROLE

To-Do Role Dimension

BD_TD_TYPE

To-do Type Dimension

BD_TD_UDD1

To-Do User Defined Dimension1

BD_TD_UDD2

To-Do User Defined Dimension2

BD_TD_UDD3

To-Do User Defined Dimension3

BD_TD_UDD4

To-Do User Defined Dimension4

BD_TD_UDD5

To-Do User Defined Dimension5

BD_TENDER_TYPE

Tender Type Dimension

BD_TNDR_SRCE

Tender Source Dimension

BD_TXN_ERROR_UDD1

Transaction Error User Defined Dimension1

BD_TXN_ERROR_UDD2

Transaction Error User Defined Dimension2

BD_TXN_ERROR_UDD3

Transaction Error User Defined Dimension3

BD_TXN_ERROR_UDD4

Transaction Error User Defined Dimension4

BD_TXN_ERROR_UDD5

Transaction Error User Defined Dimension5

BD_TXN_LINE

Transaction Line Dimension

BD_TXN_REC_TYPE

Transction Rec Type Dimension

BD_TXN_SOURCE

Transaction Source Dimension

BD_TXN_UDD1

Transaction User Defined Dimension1

BD_TXN_UDD2

Transaction User Defined Dimension2

BD_TXN_UDD3

Transaction User Defined Dimension3

BD_TXN_UDD4

Transaction User Defined Dimension4

BD_TXN_UDD5

Transaction User Defined Dimension5

BD_USER

User Dimension

BD_WRITEOFF_UDD1

WRITEOFF User Defined Dimension1

BD_WRITEOFF_UDD2

WRITEOFF User Defined Dimension2

BD_WRITEOFF_UDD3

WRITEOFF User Defined Dimension3

BD_WRITEOFF_UDD4

WRITEOFF User Defined Dimension4

BD_WRITEOFF_UDD5

WRITEOFF User Defined Dimension5

Facts

Name

Description

BF_ADJUSTMENT

Adjustment Fact

BF_BILL

Bill

BF_EXCEPTION

Pay Exception Fact

BF_EXCEPTION

Pay Exception Fact

BF_FEED

Feed Fact

BF_GL

General Ledger Fact

BF_PAYMENT

Payment Fact

BF_PAY_TNDR

Payment Tender Fact

BF_PRICE

Price Fact

BF_REFUND

Fact table for Refund.

BF_SA

Service Agreement Fact

BF_TD

To-do Fact Dimension

BF_TXN

Transaction Fact

BF_TXN_ERROR

Transaction Error Fact

BF_WRITEOFF

Fact table for Writeoff.

Materialized Views

Name

Description

BM_TD_AGEING_MV

Materialised View -to-Do Ageing

BM_ACCT_BILL_CHRG_BY_DAY

Materialised View -Billable charges grouped by Account by day

BM_TD

Materialised View -To-Do by month

BM_ADJUSTMENT_BY_DAY

Materialised View -Adjustments by day

BM_CUST_ADJUSTMENT_BY_DAY

Materialised View -Adjustments charges grouped by customer by day

BM_CUST_ADJUSTMENT_BY_MONTH

Materialised View -Adjustments charges grouped by customer by month

BM_CUST_PAYMENT_BY_DAY

Materialised View -Payment charges grouped by customer by day

BM_CUST_PAYMENT_BY_MONTH

Materialised View -Payment charges grouped by customer by month

BM_CUST_PRDT_USAGE_BY_DAY

Materialised View -Product usages by customer by day

BM_CUST_PRDT_USAGE_BY_MONTH

Materialised View -Product usages by customer by month

BM_CUST_PROD_REV_BY_DAY

Materialised View -Product revenue by customer by day

BM_CUST_PYMT_TNDR_BY_DAY

Materialised View -Payment tender by customer by day

BM_CUST_PYMT_TNDR_BY_MONTH

Materialised View -Payment tender by customer by month

BM_CUST_REVENUE_BY_DAY

Materialised View -Revenue by customer by day

BM_CUST_REVENUE_BY_MONTH

Materialised View -Revenue by customer by month

BM_DIST_PAYMENT_BY_DAY

Materialised View -Payment grouped by Dst code by day

BM_FT_EXEC_SUMMARY

Materialised View -Ft execution summary

BM_PAYMENT_BY_DAY

Materialised View -Payment by day

BM_PL_BILL_CHRG_BY_DAY

Materialised View -Billable charges grouped by price list by day

BM_PRICELINE

Materialised View -Price line

BM_PRICE_BCH_BY_DAY

Materialised View -Price grouped by batch by day

BM_PRICE_BY_CUSTOMER

Materialised View -Price grouped by customer by month

BM_PRICE_BY_CUSTOMER_BY_DAY

Materialised View -Price grouped by customer by day

BM_PROD_BILL_CHRG_BY_DAY

Materialised View -Billable charges grouped by product by day

BM_PROD_REVENUE_BY_DAY

Materialised View -Revenue grouped by product by day

BM_PROPOSAL_BY_DAY

Materialised View -Proposals grouped by day

BM_PROPOSAL_BY_MONTH

Materialised View -Proposals grouped by month

BM_PYMT_TNDR_BY_DAY

Materialised View -Payment tender grouped by day

BM_PYMT_TNDR_BY_MONTH

Materialised View -Payment tender grouped by month

BM_REVENUE_BY_DAY

Materialised View -Revenue grouped by day

BM_SA_AGEING_BY_DAY

Materialised View -SA ageing grouped by day

BM_SA_LIFE_CYCLE_BY_DAY

Materialised View -SA life cycle grouped by day

BM_SA_LIFE_CYCLE_BY_MONTH

Materialised View -SA life cycle grouped by month

BM_SA_REVENUE_BY_DAY

Materialised View -Revenue grouped by SA by month

BM_TD_AGEING_BY_DAY

Materialised View -TD ageing grouped by day

BM_TD_BY_DAY

Materialised View -TD grouped by day

BM_TD_DETAILS

Materialised View -TD details grouped by month

BM_TD_DETAILS_BY_DAY

Materialised View -TD details grouped by day

BM_UNREALIZED_PYMT_BY_DAY

Materialised View -UNREALIZED payment by day

BM_UNREALIZED_PYMT_BY_MONTH

Materialised View -UNREALIZED payment by month

BM_CUST_PROD_REV_BY_MONTH

Materialised View -Product revenue by customer by month

BM_CUST_PRICING_BY_MONTH

Materialised View -Pricing by customer by month

BM_PL_PRICING_BY_MONTH

Materialised View -Pricing by price list by month

BM_BILL_ARREARS_BY_MONTH

Materialised View - Bill arrears grouped by bill schedule by month

BM_BILL_DET_OPS_BY_MONTH

Materialised View - Bill detail operations by month

BM_BILL_OPS_BY_MONTH

Materialised View - Bill operations by month

BM_DIST_PAYMENT_BY_MONTH_MV

Materialised View -GL by Month

BM_ACCT_BILL_CHRG_BY_MONTH_MV

Materialised View -Billable charges grouped by Account by month

BM_PL_BILL_CHRG_BY_MONTH_MV

Materialised View -Billable charges grouped by pricelist by month

BM_PROD_BILL_CHRG_BY_MONTH_MV

Materialised View -Billable charges grouped by Product by month

BM_REVENUE_BY_MONTH_MV

Materialised View -Revenue by month

BM_PAYMENT_BY_MONTH_MV

Materialised View -Payment by month

BM_PROD_REVENUE_BY_MONTH_MV

Materialised View -Revenue grouped by Product by month

BM_SA_REVENUE_BY_MONTH_MV

Materialised View -Revenue grouped by Service Agreement by month

BM_PRICE_BCH_MV

Materialised View -Billablecharges grouped by price

BM_SA_AGEING_MV

Materialised View -Service Agreement by Month

BM_ADJUSTMENT_BY_MONTH_MV

Materialised View -Adjustment by month