INT_BASE_PI_QUOTE_TRANSACTION_20190926

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO SMALLINT 2
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 RISK_STATE CHARACTER(2) 2
8 USERID CHARACTER(8) 8
9 USER_TYPE CHARACTER VARYING(1) 1
10 PRODUCT_EXTRA_KEY1 CHARACTER VARYING(10) 10
11 PRODUCT_EXTRA_KEY2 CHARACTER VARYING(10) 10
12 TRANSACTION_DATE DATE 4
13 TRANTIME_REF INTEGER 4
14 TRAN_BASIC_PREM NUMERIC(11,2) 19
15 SCHEDULE_START DATE 4
16 SCHEDULE_END DATE 4
17 INSTALMENT_FREQ CHARACTER(1) 1
18 TRAN_BASIC_CHARGES NUMERIC(11,2) 19
19 TRAN_BASIC_STMPDTY NUMERIC(11,2) 19
20 TRAN_BASIC_COMSN NUMERIC(11,2) 19
21 TRAN_BASIC_GST NUMERIC(11,2) 19
22 TRAN_BASIC_CHARGE2 INTEGER 4
23 TRAN_BASIC_CHARGE3 INTEGER 4
24 TRAN_BASIC_CHARGE4 INTEGER 4
25 TRAN_BASIC_CHARGE5 INTEGER 4
26 TRAN_BASIC_CHARGE6 INTEGER 4
27 RISK_POSTCODE CHARACTER VARYING(4) 4
28 CHANNEL_KEY1 CHARACTER VARYING(10) 10
29 CHANNEL_KEY2 CHARACTER VARYING(10) 10
30 UNIT_COUNT NUMERIC(1,0) 19
31 DUE_DATE DATE 4
32 SOURCE_SYSTEM_POLICY_ID CHARACTER VARYING(215) 215
33 RATING_ADDRESS INTEGER 4
34 MODULE_NO SMALLINT 2
35 RISK_TYPE1 CHARACTER VARYING(255) 255
36 RISK_TYPE2 CHARACTER VARYING(40) 40
37 RISK_TYPE3 CHARACTER VARYING(40) 40
38 CUSTOMER_REFERENCE CHARACTER(14) 14
39 BUSINESS_SOURCE CHARACTER(4) 4
40 COMPLETE_IND CHARACTER(1) 1
41 PREV_INSURER CHARACTER(4) 4
42 DRIVER_BIRTHDATE DATE 4
43 CUSTOMER_ID INTEGER 4
44 NVIC CHARACTER(6) 6
45 MANUFCT_YEAR SMALLINT 2
46 VEHICLE_MAKE CHARACTER(4) 4
47 VEHICLE_MODEL CHARACTER(7) 7
48 TXN_HIST_FLAG CHARACTER VARYING(1) 1
49 QUOTE_TYPE CHARACTER VARYING(1) 1
50 RISK_COUNT NUMERIC(32,12) 19
51 RISK_NO BIGINT 8
52 RISKDESC CHARACTER(100) 100
53 CRC CHARACTER(1) 1
54 CRCSTATUS CHARACTER(1) 1
55 FLOODOPTOUT CHARACTER(1) 1
56 FLOODRISK CHARACTER(1) 1
57 RD_ASSIST CHARACTER(1) 1
58 HIRE_CAR CHARACTER(1) 1
59 WINDSCREEN CHARACTER(1) 1