TRPMT_FEE

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FEE_ID CHARACTER VARYING(255) 255
2 FEE_RV_ID BIGINT 8
3 FEE_AMOUNT DOUBLE PRECISION 8
4 FEE_FTYP_ID CHARACTER VARYING(255) 255
5 FEE_FREQ BIGINT 8
6 FEE_TBCAMOUNT DOUBLE PRECISION 8
7 FEE_DISCRETION_REQUIRED INTEGER 4
8 FEE_WAIVED INTEGER 4
9 DATE_CREATED TIMESTAMP 8
10 CREATED_BY CHARACTER VARYING(255) 255
11 DATE_MODIFIED TIMESTAMP 8
12 MODIFIED_BY CHARACTER VARYING(255) 255
13 FEE_FEEST_ID CHARACTER VARYING(255) 255
14 FEE_FTYP_IDX CHARACTER VARYING(255) 255
15 FEE_PCT_BASED INTEGER 4
16 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
18 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8