FCT_BNK_SMB_TBS_WEEKLY_ACCOUNT_SALES_REPORT_INSIGHT
Description
OBP DPS SMB and TBS Weekly TD and CASA Account Sales Report of Accounts product customer with salesperson(account created by) userid name region and position
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | USER_ID | CHARACTER VARYING(254) | 254 |
| 2 | PREFERRED_NAME | CHARACTER VARYING(201) | 201 |
| 3 | POSITION_TITLE | CHARACTER VARYING(256) | 256 |
| 4 | REGION | CHARACTER VARYING(240) | 240 |
| 5 | WEEK_ENDING | TIMESTAMP | 8 |
| 6 | MONTH_NAME | CHARACTER VARYING(9) | 9 |
| 7 | DATE_OPENED | TIMESTAMP | 8 |
| 8 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 9 | CUSTOMER_NAME | CHARACTER VARYING(500) | 500 |
| 10 | PRODUCT_CODE | CHARACTER VARYING(30) | 30 |
| 11 | OFFER_DESCRIPTION | CHARACTER VARYING(120) | 120 |
| 12 | BRANCH_ID | CHARACTER VARYING(10) | 10 |
| 13 | COST_CENTRE_NAME | CHARACTER VARYING(240) | 240 |
| 14 | BRANCH_TYPE | CHARACTER VARYING(2) | 2 |