INT_OBP_HST_FLX_OR_LNDG_PRD_GRP_XREF_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_OBP_HST_FLX_OR_LNDG_PRD_GRP_XREF

Columns
# Name Data Type Length
1 APPLICATION_ID CHARACTER VARYING(50) 50
2 PROD_GRP_SERIAL_NO BYTEINT 1
3 REQUEST_AMOUNT DOUBLE PRECISION 8
4 REQUEST_AMOUNT_CURRENCY CHARACTER VARYING(3) 3
5 REQUESTED_TENOR_DAYS DOUBLE PRECISION 8
6 REQUESTED_TENOR_MONTHS DOUBLE PRECISION 8
7 REQUESTED_TENOR_YEARS DOUBLE PRECISION 8
8 APPROVED_AMOUNT DOUBLE PRECISION 8
9 APPROVED_AMOUNT_CURRENCY CHARACTER VARYING(3) 3
10 APPROVED_TENOR_DAYS DOUBLE PRECISION 8
11 APPROVED_TENOR_MONTHS DOUBLE PRECISION 8
12 APPROVED_TENOR_YEARS DOUBLE PRECISION 8
13 IS_COLLATERAL_REQUIRED CHARACTER VARYING(1) 1
14 IS_MOF CHARACTER VARYING(1) 1
15 IS_SETTLEMENT_REQUIRED CHARACTER VARYING(1) 1
16 PURPOSE_TYPE CHARACTER VARYING(40) 40
17 PURPOSE CHARACTER VARYING(255) 255
18 FACILITY_CATEGORY CHARACTER VARYING(40) 40
19 IS_LRM_APPLICABLE CHARACTER VARYING(1) 1
20 IS_LEF_APPLICABLE CHARACTER VARYING(1) 1
21 IS_LMI_APPLICABLE CHARACTER VARYING(1) 1
22 IS_CVRD_BY_CONSMR_PROTECTION CHARACTER VARYING(1) 1
23 IS_GENERAL_INSURANCE_OPTED CHARACTER VARYING(1) 1
24 FACILITY_ID CHARACTER VARYING(40) 40
25 IS_FNDG_TBL_REQD CHARACTER VARYING(1) 1
26 PRICING_TKT_NO_FNDG_TBL CHARACTER VARYING(40) 40
27 CONTRI_AMOUNT DOUBLE PRECISION 8
28 CONTRI_AMOUNT_CCY CHARACTER VARYING(3) 3
29 LEGAL_FEE_AMOUNT DOUBLE PRECISION 8
30 LEGAL_FEE_CCY CHARACTER VARYING(3) 3
31 TOTAL_FEE_AMOUNT DOUBLE PRECISION 8
32 TOTAL_FEE_CCY CHARACTER VARYING(3) 3
33 PURCHASE_AMOUNT DOUBLE PRECISION 8
34 PURCHASE_CCY CHARACTER VARYING(3) 3
35 IS_CCI_CAPITALIZED CHARACTER VARYING(1) 1
36 IS_FEE_CAPITALIZED CHARACTER VARYING(1) 1
37 IS_LMI_CAPITALIZED CHARACTER VARYING(1) 1
38 IS_BUNDLE_FEE_CAPITALIZED CHARACTER VARYING(1) 1
39 CUSHION_APPROVED_AMT DOUBLE PRECISION 8
40 CUSHION_APPROVED_AMT_CCY CHARACTER VARYING(3) 3
41 TOT_CAPITALIZED_AMT DOUBLE PRECISION 8
42 TOT_CAPITALIZED_AMT_CCY CHARACTER VARYING(3) 3
43 CAP_ORIG_FEES DOUBLE PRECISION 8
44 CAP_ORIG_FEES_CCY CHARACTER VARYING(3) 3
45 CAP_LMI_AMOUNT DOUBLE PRECISION 8
46 CAP_LMI_AMOUNT_CCY CHARACTER VARYING(3) 3
47 CAP_CCI_AMOUNT DOUBLE PRECISION 8
48 CAP_CCI_AMOUNT_CCY CHARACTER VARYING(3) 3
49 CAP_INTR_AMOUNT DOUBLE PRECISION 8
50 CAP_INTR_AMOUNT_CCY CHARACTER VARYING(3) 3
51 CAP_SRVC_FEES DOUBLE PRECISION 8
52 CAP_SRVC_FEES_CCY CHARACTER VARYING(3) 3
53 CAP_BUNDLE_FEES DOUBLE PRECISION 8
54 CAP_BUNDLE_FEES_CCY CHARACTER VARYING(3) 3
55 LMI_BASE_AMT DOUBLE PRECISION 8
56 LMI_BASE_AMT_CCY CHARACTER VARYING(3) 3
57 BORROWING_ENTITY CHARACTER VARYING(50) 50
58 UNCAP_FACILITY_AMT DOUBLE PRECISION 8
59 UNCAP_FACILITY_AMT_CCY CHARACTER VARYING(3) 3
60 IS_FEE_INSURANCE_CAP CHARACTER VARYING(1) 1
61 CUSHION_AMOUNT DOUBLE PRECISION 8
62 CUSHION_AMOUNT_CCY CHARACTER VARYING(3) 3
63 CAP_ADV_INTR_AMOUNT DOUBLE PRECISION 8
64 CAP_ADV_INTR_AMOUNT_CCY CHARACTER VARYING(3) 3
65 PRE_APPROVED_LIMIT_REF_ID CHARACTER VARYING(255) 255
66 IS_PRE_APPROVED CHARACTER VARYING(1) 1
67 EXP_SETTLEMENT_DATE TIMESTAMP 8
68 COLLATERAL_REQUIRED CHARACTER VARYING(20) 20
69 IS_SETTLEMENT_SKIPPED CHARACTER(1) 1
70 FEE_LEVEL_TYPE CHARACTER VARYING(20) 20
71 FEE_LEVEL_ENTITY_ID CHARACTER VARYING(20) 20
72 IS_FLEXI_CREDIT_FACILITY CHARACTER(1) 1
73 CCI_QUOTE_ID CHARACTER VARYING(40) 40
74 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
75 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
76 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
77 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8