TRPMT_PRODOPT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRODOPT_ID CHARACTER VARYING(255) 255
2 PRODOPT_RV_ID BIGINT 8
3 PRODOPT_DESC CHARACTER VARYING(255) 255
4 PRODOPT_FIXEDTERM BIGINT 8
5 PRODOPT_INTCHFREQ BIGINT 8
6 PRODOPT_INTRTCODE CHARACTER VARYING(255) 255
7 PRODOPT_INTRATETYPE BIGINT 8
8 PRODOPT_INTRESFREQ BIGINT 8
9 PRODOPT_PMTTIMING BIGINT 8
10 PRODOPT_FACPROD_ID CHARACTER VARYING(255) 255
11 PRODOPT_PRODCODE CHARACTER VARYING(255) 255
12 PRODOPT_REPAYTYPE BIGINT 8
13 PRODOPT_ACTIVE INTEGER 4
14 PRODOPT_ISFIXEDRATE INTEGER 4
15 PRODOPT_ISFIXEDTERM INTEGER 4
16 DATE_CREATED TIMESTAMP 8
17 CREATED_BY CHARACTER VARYING(255) 255
18 DATE_MODIFIED TIMESTAMP 8
19 MODIFIED_BY CHARACTER VARYING(255) 255
20 PRODOPT_ALLUPRTCODE CHARACTER VARYING(255) 255
21 PRODOPT_ISALLUPRT INTEGER 4
22 PRODOPT_TREASURYFEE DOUBLE PRECISION 8
23 PRODOPT_TPINTRTCODE CHARACTER VARYING(255) 255
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8