CMT_STG_PI_QUOTE_TRANSACTION_JCI

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
2 POLICY_NO INTEGER 4
3 ITEM_NO SMALLINT 2
4 PRODUCT_TYPE_CODE CHARACTER(3) 3
5 PRODUCT_CLASS_CODE CHARACTER(3) 3
6 PRODUCT_SUBCLASS CHARACTER(3) 3
7 PRODUCT_EXTRA_KEY1 CHARACTER VARYING(10) 10
8 PRODUCT_EXTRA_KEY2 CHARACTER VARYING(10) 10
9 RISK_STATE CHARACTER(2) 2
10 TRANSACTION_DATE DATE 4
11 TRANTIME_REF INTEGER 4
12 SCHEDULE_START DATE 4
13 SCHEDULE_END DATE 4
14 INSTALMENT_FREQ CHARACTER(1) 1
15 TRAN_BASIC_PREM NUMERIC(11,2) 19
16 TRAN_BASIC_CHARGES NUMERIC(11,2) 19
17 TRAN_BASIC_STMPDTY NUMERIC(11,2) 19
18 TRAN_BASIC_COMSN NUMERIC(11,2) 19
19 TRAN_BASIC_GST NUMERIC(11,2) 19
20 TRAN_BASIC_CHARGE2 NUMERIC(11,2) 19
21 TRAN_BASIC_CHARGE3 NUMERIC(11,2) 19
22 TRAN_BASIC_CHARGE4 NUMERIC(11,2) 19
23 TRAN_BASIC_CHARGE5 NUMERIC(11,2) 19
24 TRAN_BASIC_CHARGE6 NUMERIC(11,2) 19
25 RISK_POSTCODE CHARACTER(4) 4
26 CHANNEL_KEY1 CHARACTER VARYING(10) 10
27 CHANNEL_KEY2 CHARACTER VARYING(10) 10
28 TEAM_KEY1 CHARACTER VARYING(10) 10
29 TEAM_KEY2 CHARACTER VARYING(10) 10
30 RISK_TYPE CHARACTER VARYING(25) 25
31 RISK_COUNT NUMERIC(16,6) 19
32 UNIT_COUNT NUMERIC(16,6) 19
33 DM_TIMESTAMP TIMESTAMP 8
34 DUE_DATE DATE 4
35 SOURCE_SYSTEM_POLICY_ID CHARACTER VARYING(40) 40
36 ISSUED_POLICY_ID CHARACTER VARYING(40) 40
37 PAYMENT_DATE DATE 4
38 PAID_CHANNEL_KEY1 CHARACTER VARYING(10) 10
39 PAID_TEAM_KEY1 CHARACTER VARYING(10) 10
40 RATING_ADDRESS INTEGER 4
41 MODULE_NO SMALLINT 2
42 CUSTREF CHARACTER(14) 14
43 BUSINESS_SOURCE CHARACTER(4) 4
44 COMPLETE_IND CHARACTER(1) 1
45 PREV_INSURER CHARACTER(4) 4
46 DRIVER_BIRTHDATE DATE 4
47 CUSTOMER_ID INTEGER 4
48 NVIC CHARACTER(6) 6
49 MANUFCT_YEAR SMALLINT 2
50 VEHICLE_MAKE CHARACTER(4) 4
51 VEHICLE_MODEL CHARACTER(7) 7
52 TXN_HIST_FLAG CHARACTER(1) 1