FCT_BNK_UPFRONT_ASSET_LINE
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ODSTARTDATE | TIMESTAMP | 8 |
| 2 | BROKERCODE | CHARACTER VARYING(40) | 40 |
| 3 | ACCBROKERCODE | CHARACTER VARYING(40) | 40 |
| 4 | SALESOFFICER | CHARACTER VARYING(254) | 254 |
| 5 | PRODCODE | CHARACTER VARYING(30) | 30 |
| 6 | APPNAME | CHARACTER VARYING(500) | 500 |
| 7 | BRANCH | CHARACTER VARYING(10) | 10 |
| 8 | ACCTNO | CHARACTER VARYING(40) | 40 |
| 9 | LOANAMT | DOUBLE PRECISION | 8 |
| 10 | SETTLEDATE | DATE | 4 |
| 11 | SUNLOANS | CHARACTER VARYING(50) | 50 |
| 12 | ACCTSTATUS | CHARACTER VARYING(40) | 40 |