TRPMT_DLFTYP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DLFTYP_ID CHARACTER VARYING(255) 255
2 DLFTYP_RV_ID BIGINT 8
3 DLFTYP_DIV_ID CHARACTER VARYING(255) 255
4 DLFTYP_BASEDON BIGINT 8
5 DLFTYP_DESC CHARACTER VARYING(255) 255
6 DLFTYP_SCALFROM BIGINT 8
7 DLFTYP_MINFEE DOUBLE PRECISION 8
8 DLFTYP_SCALEMIN1 DOUBLE PRECISION 8
9 DLFTYP_SCALEMIN2 DOUBLE PRECISION 8
10 DLFTYP_SCALEMIN3 DOUBLE PRECISION 8
11 DLFTYP_SCALEMIN4 DOUBLE PRECISION 8
12 DLFTYP_SCALEMIN5 DOUBLE PRECISION 8
13 DLFTYP_SCALEVAL0 DOUBLE PRECISION 8
14 DLFTYP_SCALEVAL1 DOUBLE PRECISION 8
15 DLFTYP_SCALEVAL2 DOUBLE PRECISION 8
16 DLFTYP_SCALEVAL3 DOUBLE PRECISION 8
17 DLFTYP_SCALEVAL4 DOUBLE PRECISION 8
18 DLFTYP_SCALEVAL5 DOUBLE PRECISION 8
19 DLFTYP_ACTIVE INTEGER 4
20 DLFTYP_PCTREVISE INTEGER 4
21 DLFTYP_CHRGDADV INTEGER 4
22 DLFTYP_STDFEE INTEGER 4
23 DATE_CREATED TIMESTAMP 8
24 CREATED_BY CHARACTER VARYING(255) 255
25 DATE_MODIFIED TIMESTAMP 8
26 MODIFIED_BY CHARACTER VARYING(255) 255
27 DLFTYP_FORINCFAC INTEGER 4
28 DLFTYP_FORNEWFAC INTEGER 4
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