TRPMT_BAB

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BAB_ID CHARACTER VARYING(255) 255
2 BAB_RV_ID BIGINT 8
3 BAB_DEAL_ID BIGINT 8
4 BAB_AMT DOUBLE PRECISION 8
5 BAB_EXIST_AMT DOUBLE PRECISION 8
6 BAB_ROE DOUBLE PRECISION 8
7 BAB_ROE_ECO DOUBLE PRECISION 8
8 BAB_TERM BIGINT 8
9 BAB_BILL_USAGE BIGINT 8
10 BAB_AV_BILL_TERM BIGINT 8
11 BAB_EXISTING BIGINT 8
12 BAB_VALUEADD DOUBLE PRECISION 8
13 BAB_USE_TO_ADJUST_TGT INTEGER 4
14 BAB_FEEST_ID CHARACTER VARYING(255) 255
15 BAB_FACPROD_ID CHARACTER VARYING(255) 255
16 BAB_PRODOPT_ID CHARACTER VARYING(255) 255
17 BAB_ADJUST_VAR CHARACTER VARYING(255) 255
18 BAB_FEE_ID CHARACTER VARYING(255) 255
19 BAB_IS_INCLUDED_IN_DEAL INTEGER 4
20 DATE_CREATED TIMESTAMP 8
21 CREATED_BY CHARACTER VARYING(255) 255
22 DATE_MODIFIED TIMESTAMP 8
23 MODIFIED_BY CHARACTER VARYING(255) 255
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8