TRPMT_DEAL

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DEAL_ID BIGINT 8
2 DEAL_RV_ID BIGINT 8
3 DEAL_BRKRG_ID CHARACTER VARYING(255) 255
4 DEAL_BBVALUEADD DOUBLE PRECISION 8
5 DEAL_DATE_CREATED TIMESTAMP 8
6 DEAL_CUST_ID CHARACTER VARYING(255) 255
7 DEAL_CSTD_ID CHARACTER VARYING(255) 255
8 DEAL_CUSTTIER BIGINT 8
9 DEAL_DEPSTRUCT_ID CHARACTER VARYING(255) 255
10 DEAL_STATUS BIGINT 8
11 DEAL_OBUVALUEADD DOUBLE PRECISION 8
12 DEAL_DIV_ID CHARACTER VARYING(255) 255
13 DEAL_WAIVERCODE_ID CHARACTER VARYING(255) 255
14 DEAL_DATE_MODIFIED TIMESTAMP 8
15 DEAL_LUDED BIGINT 8
16 DEAL_ROE DOUBLE PRECISION 8
17 DEAL_SCRTY_ID CHARACTER VARYING(255) 255
18 USER_AREA CHARACTER VARYING(100) 100
19 USER_BRNC CHARACTER VARYING(100) 100
20 USER_STAT CHARACTER VARYING(100) 100
21 USER_ID CHARACTER VARYING(100) 100
22 USER_USERNAME CHARACTER VARYING(100) 100
23 DEAL_REGULATORY 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 DEAL_CALCULATED INTEGER 4
29 DEAL_BBVAEXIST DOUBLE PRECISION 8
30 DEAL_BBVANIEXALLUP DOUBLE PRECISION 8
31 DEAL_BBVANI DOUBLE PRECISION 8
32 DEAL_BBVANIALLUP DOUBLE PRECISION 8
33 DEAL_ROEEXIST DOUBLE PRECISION 8
34 DEAL_ROENI DOUBLE PRECISION 8
35 DEAL_ROENIALLUP DOUBLE PRECISION 8
36 DEAL_ROENIEXALLUP DOUBLE PRECISION 8
37 DEAL_ROE_ECO DOUBLE PRECISION 8
38 DEAL_ROEEXIST_ECO DOUBLE PRECISION 8
39 DEAL_ROENI_ECO DOUBLE PRECISION 8
40 DEAL_ROENIALLUP_ECO DOUBLE PRECISION 8
41 DEAL_ROENIEXALLUP_ECO DOUBLE PRECISION 8
42 DEAL_PRIMARY_PRICING BIGINT 8
43 DEAL_DISCRETION_ROE DOUBLE PRECISION 8
44 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
45 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
46 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
47 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8