FCT_OBP_FLOW_OF_FUNDS_ACCT_INSIGHT
Description
Monthly FLow of Funds Summary of OBP Account amounts for opening and closing balnces Disbursements Payouts Repayments Interest with counterparty address country and GL identifier
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_DIM_ID | BIGINT | 8 |
| 2 | OPENING_PERIOD_DIM_ID | INTEGER | 4 |
| 3 | CLOSING_PERIOD_DIM_ID | INTEGER | 4 |
| 4 | PERIOD_TYPE_DIM_ID | BIGINT | 8 |
| 5 | FLOW_OF_FUNDS_MEASURES_DIM_ID | BIGINT | 8 |
| 6 | SOURCE_PRODUCT_DIM_ID | BIGINT | 8 |
| 7 | SOURCE_PRODUCT_CODE | CHARACTER VARYING(104) | 104 |
| 8 | BALANCE_SHEET_INDICATOR | CHARACTER VARYING(20) | 20 |
| 9 | PERS_INV_USAGE_TYPE_DIM_ID | BIGINT | 8 |
| 10 | OF_GENERAL_LEDGER_DIM_ID | BIGINT | 8 |
| 11 | CUSTOMER_ADDRESS_DIM_ID | BIGINT | 8 |
| 12 | COUNTERPARTY_TYPE_DIM_ID | BIGINT | 8 |
| 13 | MEASURE | DOUBLE PRECISION | 8 |