TRPMT_OVERDRAFT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 OVERDRAFT_ID CHARACTER VARYING(255) 255
2 OVDR_RV_ID BIGINT 8
3 OVDR_ADJUST_VAR CHARACTER VARYING(255) 255
4 OVDR_AMT DOUBLE PRECISION 8
5 TRML_D_LEND_RATE DOUBLE PRECISION 8
6 OVERDRAFT_DEAL_ID BIGINT 8
7 OVERDRAFT_FEEST_ID CHARACTER VARYING(255) 255
8 OVDR_GROSSINTRATE DOUBLE PRECISION 8
9 IS_INCLUDED_IN_DEAL INTEGER 4
10 OVERDRAFT_FACPROD_ID CHARACTER VARYING(255) 255
11 OVERDRAFT_PRODOPT_ID CHARACTER VARYING(255) 255
12 OVDR_ROE DOUBLE PRECISION 8
13 OVDR_SPREAD DOUBLE PRECISION 8
14 OVDR_TERM BIGINT 8
15 OVDR_USE_TO_ADJUST_TGT INTEGER 4
16 OVDR_VALUEADD DOUBLE PRECISION 8
17 DATE_CREATED TIMESTAMP 8
18 CREATED_BY CHARACTER VARYING(255) 255
19 DATE_MODIFIED TIMESTAMP 8
20 MODIFIED_BY CHARACTER VARYING(255) 255
21 OVDR_USAGE_OVERRIDDEN INTEGER 4
22 OVDR_USAGE DOUBLE PRECISION 8
23 OVERDRAFT_EXISTING BIGINT 8
24 OVDR_EXIST_AMT DOUBLE PRECISION 8
25 OVDR_ROE_ECO DOUBLE PRECISION 8
26 OVDR_FIXEDBASERATE DOUBLE PRECISION 8
27 OVDR_FIXED_TERM BIGINT 8
28 TRML_D_TP_LEND_RATE DOUBLE PRECISION 8
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8