TRPMT_FTYP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FTYP_ID CHARACTER VARYING(255) 255
2 FTYP_RV_ID BIGINT 8
3 FTYP_DIV_ID CHARACTER VARYING(255) 255
4 FTYP_FACTYPE_ID CHARACTER VARYING(255) 255
5 FTYP_AMTBASEDON BIGINT 8
6 FTYP_DESC CHARACTER VARYING(255) 255
7 FTYP_FREQ BIGINT 8
8 FTYP_FACPROD_ID CHARACTER VARYING(255) 255
9 FTYP_SCALEMIN1 DOUBLE PRECISION 8
10 FTYP_SCALEMIN2 DOUBLE PRECISION 8
11 FTYP_SCALEMIN3 DOUBLE PRECISION 8
12 FTYP_SCALEMIN4 DOUBLE PRECISION 8
13 FTYP_SCALEMIN5 DOUBLE PRECISION 8
14 FTYP_SCALEVAL0 DOUBLE PRECISION 8
15 FTYP_SCALEVAL1 DOUBLE PRECISION 8
16 FTYP_SCALEVAL2 DOUBLE PRECISION 8
17 FTYP_SCALEVAL3 DOUBLE PRECISION 8
18 FTYP_SCALEVAL4 DOUBLE PRECISION 8
19 FTYP_SCALEVAL5 DOUBLE PRECISION 8
20 FTYP_ACTIVE INTEGER 4
21 FTYP_PCTREVISE INTEGER 4
22 FTYP_CHRGDADV INTEGER 4
23 FTYP_STDFEE INTEGER 4
24 DATE_CREATED TIMESTAMP 8
25 CREATED_BY CHARACTER VARYING(255) 255
26 DATE_MODIFIED TIMESTAMP 8
27 MODIFIED_BY CHARACTER VARYING(255) 255
28 FTYP_BAB_CALC INTEGER 4
29 FTYP_BAB_FV_BASED INTEGER 4
30 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
32 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
33 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8