TRPMT_TERM_LOAN

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TERMLOAN_ID CHARACTER VARYING(255) 255
2 DISCRIMINATOR CHARACTER VARYING(15) 15
3 TRML_RV_ID BIGINT 8
4 TRML_ADJUST_VAR CHARACTER VARYING(255) 255
5 TRML_AMT DOUBLE PRECISION 8
6 TRML_D_LEND_RATE DOUBLE PRECISION 8
7 TERMLOAN_DEAL_ID BIGINT 8
8 TERMLOAN_FEEST_ID CHARACTER VARYING(255) 255
9 TRML_FIXED_TERM BIGINT 8
10 TRML_INTRST_RATE DOUBLE PRECISION 8
11 TRML_IO_TERM BIGINT 8
12 IS_INCLUDED_IN_DEAL INTEGER 4
13 TERMLOAN_FACPROD_ID CHARACTER VARYING(255) 255
14 TERMLOAN_PRODOPT_ID CHARACTER VARYING(255) 255
15 TRML_RES_PCT DOUBLE PRECISION 8
16 TRML_ROE DOUBLE PRECISION 8
17 TRML_SPREAD DOUBLE PRECISION 8
18 TRML_TERM BIGINT 8
19 TRML_USE_TO_ADJUST_TGT INTEGER 4
20 TRML_VALUEADD DOUBLE PRECISION 8
21 DATE_CREATED TIMESTAMP 8
22 CREATED_BY CHARACTER VARYING(255) 255
23 DATE_MODIFIED TIMESTAMP 8
24 MODIFIED_BY CHARACTER VARYING(255) 255
25 TERMLOAN_EXISTING BIGINT 8
26 TRML_EXIST_AMT DOUBLE PRECISION 8
27 TRML_ROE_ECO DOUBLE PRECISION 8
28 TRML_FIXEDBASERATE DOUBLE PRECISION 8
29 TRML_D_TP_LEND_RATE DOUBLE PRECISION 8
30 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
32 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
33 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8