TRPMT_LEASE

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LEASE_ID CHARACTER VARYING(255) 255
2 DISCRIMINATOR CHARACTER VARYING(5) 5
3 LEASE_RV_ID BIGINT 8
4 LEASE_ADJUST_VAR CHARACTER VARYING(255) 255
5 LEASE_ALL_UP_RATE DOUBLE PRECISION 8
6 LEASE_IS_ALL_UP_RATE_SELECTED INTEGER 4
7 LEASE_AMOUNT DOUBLE PRECISION 8
8 LEASE_BRKRG_ID CHARACTER VARYING(255) 255
9 LEASE_DAILY_LDG_RATE DOUBLE PRECISION 8
10 LEASE_DEAL_ID BIGINT 8
11 LEASE_FEEST_ID CHARACTER VARYING(255) 255
12 LEASE_INITIAL_MARGIN DOUBLE PRECISION 8
13 LEASE_INT_RATE DOUBLE PRECISION 8
14 IS_INCLUDED_IN_DEAL INTEGER 4
15 LEASE_FACPROD_ID CHARACTER VARYING(255) 255
16 LEASE_PRODOPT_ID CHARACTER VARYING(255) 255
17 LEASE_RESIDUAL DOUBLE PRECISION 8
18 LEASE_RESIDUAL_PERCENT DOUBLE PRECISION 8
19 LEASE_ROE DOUBLE PRECISION 8
20 LEASE_SCRTY_ID CHARACTER VARYING(255) 255
21 LEASE_SPREAD DOUBLE PRECISION 8
22 LEASE_STANDALONE_SECURITY CHARACTER VARYING(255) 255
23 LEASE_TERM BIGINT 8
24 LEASE_USE_TO_ADJUST_TGT INTEGER 4
25 LEASE_VALUEADD DOUBLE PRECISION 8
26 DATE_CREATED TIMESTAMP 8
27 CREATED_BY CHARACTER VARYING(255) 255
28 DATE_MODIFIED TIMESTAMP 8
29 MODIFIED_BY CHARACTER VARYING(255) 255
30 LEASE_EXISTING BIGINT 8
31 LEASE_EXIST_AMT DOUBLE PRECISION 8
32 LEASE_ROE_ECONOMIC DOUBLE PRECISION 8
33 LEASE_FIXEDBASERATE DOUBLE PRECISION 8
34 LEASE_FIXED_TERM BIGINT 8
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8