TRPMT_BANKGUAR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BANKGUAR_ID CHARACTER VARYING(255) 255
2 BKGR_RV_ID BIGINT 8
3 BKGR_ADJUST_VAR CHARACTER VARYING(255) 255
4 BKGR_AMT DOUBLE PRECISION 8
5 BANKGUAR_DEAL_ID BIGINT 8
6 BANKGUAR_FEEST_ID CHARACTER VARYING(255) 255
7 IS_INCLUDED_IN_DEAL INTEGER 4
8 BANKGUAR_FACPROD_ID CHARACTER VARYING(255) 255
9 BKGR_ROE DOUBLE PRECISION 8
10 BKGR_SPREAD DOUBLE PRECISION 8
11 BKGR_TERM BIGINT 8
12 BKGR_USE_TO_ADJUST_TGT INTEGER 4
13 BKGR_VALUEADD DOUBLE PRECISION 8
14 DATE_CREATED TIMESTAMP 8
15 CREATED_BY CHARACTER VARYING(255) 255
16 DATE_MODIFIED TIMESTAMP 8
17 MODIFIED_BY CHARACTER VARYING(255) 255
18 BKGR_EXISTING BIGINT 8
19 BKGR_EXIST_AMT DOUBLE PRECISION 8
20 BKGR_ROE_ECO DOUBLE PRECISION 8
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8