TRPMT_FACPROD

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FACPROD_ID CHARACTER VARYING(255) 255
2 FACPROD_RV_ID BIGINT 8
3 FACPROD_BAL_FACTOR DOUBLE PRECISION 8
4 FACPROD_FACTYPE_ID CHARACTER VARYING(255) 255
5 FACPROD_PRODNAME CHARACTER VARYING(255) 255
6 FACPROD_ACTIVE INTEGER 4
7 FACPROD_RENTAL INTEGER 4
8 FACPROD_MEZZDEBT INTEGER 4
9 FACPROD_ONGOING INTEGER 4
10 FACPROD_RESI INTEGER 4
11 DATE_CREATED TIMESTAMP 8
12 CREATED_BY CHARACTER VARYING(255) 255
13 DATE_MODIFIED TIMESTAMP 8
14 MODIFIED_BY CHARACTER VARYING(255) 255
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8