TRPMT_BROKERAGE

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BROKERAGE_ID CHARACTER VARYING(255) 255
2 BRKRG_RV_ID BIGINT 8
3 BRKRG_BRKRSRCCDE CHARACTER VARYING(255) 255
4 BRKRG_BRKRG_TYPE BIGINT 8
5 BRKRG_TRAILERPCT DOUBLE PRECISION 8
6 BRKRG_TRAILER DOUBLE PRECISION 8
7 BRKRG_UPFRONT_PCT DOUBLE PRECISION 8
8 BRKRG_UPFRONT DOUBLE PRECISION 8
9 BRKRG_OD_INCL INTEGER 4
10 BRKRG_ISTRLRPCT INTEGER 4
11 BRKRG_ISUPFRPCT INTEGER 4
12 DATE_CREATED TIMESTAMP 8
13 CREATED_BY CHARACTER VARYING(255) 255
14 DATE_MODIFIED TIMESTAMP 8
15 MODIFIED_BY CHARACTER VARYING(255) 255
16 BRKRG_TRAILFREQ BIGINT 8
17 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
19 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
20 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8