FCT_OBP_SLN_FACILITY_UPL_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 FACILITY_ID CHARACTER VARYING(40) 40
3 APPLICATION_ID CHARACTER VARYING(50) 50
4 PRODUCT_CODE CHARACTER VARYING(50) 50
5 PURPOSE_CODE CHARACTER VARYING(40) 40
6 SUB_PURPOSE_CODE CHARACTER VARYING(255) 255
7 UPFRONT_REBATE_AUTH_USER_ID CHARACTER VARYING(254) 254
8 ONGOING_REBATE_AUTH_USER_ID CHARACTER VARYING(254) 254
9 LOAN_AMOUNT DOUBLE PRECISION 8
10 TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
11 BORROWER_CONTRIBUTION INTEGER 4
12 CC_BALANCE_TRANSFER_AMOUNT1 INTEGER 4
13 CC_BALANCE_TRANSFER_AMOUNT2 INTEGER 4
14 CC_BALANCE_TRANSFER_AMOUNT3 INTEGER 4
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
16 CDC_RECORD_TYPE CHARACTER VARYING(6) 6
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8