The mapping details for the Account Dimension (DIM_ACCOUNT) tables are given here.
|
Map Reference Number |
Source View Name |
Logical Source View Name |
|
190 |
STG_BORROWING_V |
Stage Borrowing View |
|
350 |
STG_CUSTODIAL_ACCOUNTS_V |
Stage Custodial Accounts View |
|
465 |
STG_FORWARDS_V |
Stage Forwards View |
|
195 |
STG_FUTURES_V |
Stage Futures View |
|
197 |
STG_GUARANTEES_V |
Stage Guarantees View |
|
198 |
STG_INVESTMENTS_V |
Stage Investments View |
|
201 |
STG_LOAN_CONTRACTS_V |
Stage Loan Contracts View |
|
351 |
STG_MANAGED_INV_ADV_V |
Stage Managed Investment Account View |
|
202 |
STG_MM_CONTRACTS_V |
Stage Money Market Contracts View |
|
203 |
STG_MUTUAL_FUNDS_V |
Stage Mutual Funds View |
|
205 |
STG_OPTION_CONTRACTS_V |
Stage Option Contracts View |
|
341 |
STG_PAYMENT_SETTLEMENT_ACCT_V |
Stage Payment Settlement Account View |
|
206 |
STG_REPO_CONTRACTS_V |
Stage Repurchase Contracts View |
|
354 |
STG_SPEND_OBLIGATIONS_V |
Stage Spend Obligations View |
|
208 |
STG_SWAPS_CONTRACTS_V |
Stage Swaps Contracts View |
|
210 |
STG_TRUSTS_V |
Stage Trusts View |
All the above-mentioned Product Processor tables are mutually exclusive in terms of functionality. Therefore, V_ACCOUNT_NUMBER or V_CONTRACT_CODE (Primary Key of each Product Processor) must also have mutually exclusive values across all the tables. The same account number cannot be part of multiple Product Processor tables.