INT_BASE_PI_COVERNOTE_TRANSACTION

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO SMALLINT 2
2 POLICY INTEGER 4
3 POLICY_NO INTEGER 4
4 ITEM_NO SMALLINT 2
5 PRODUCT_TYPE_CODE CHARACTER(3) 3
6 PRODUCT_CLASS_CODE CHARACTER(3) 3
7 PRODUCT_SUBCLASS CHARACTER(3) 3
8 PRODUCT_EXTRA_KEY1 CHARACTER VARYING(10) 10
9 PRODUCT_EXTRA_KEY2 CHARACTER VARYING(10) 10
10 RISK_STATE CHARACTER(2) 2
11 TRANSACTION_DATE DATE 4
12 TRANTIME_REF INTEGER 4
13 SCHEDULE_START DATE 4
14 SCHEDULE_END DATE 4
15 RISK_POSTCODE CHARACTER VARYING(4) 4
16 CHANNEL_KEY1 CHARACTER VARYING(10) 10
17 CHANNEL_KEY2 CHARACTER VARYING(10) 10
18 USER_ID CHARACTER(8) 8
19 USER_TYPE CHARACTER VARYING(1) 1
20 BUSINESS_SOURCE CHARACTER(4) 4
21 PREV_POLICY_TYPE CHARACTER VARYING(3) 3
22 PREV_POLICY_NO INTEGER 4
23 INSTALMENT_FREQ CHARACTER(1) 1
24 DUE_DATE DATE 4
25 SOURCE_SYSTEM_POLICY_ID CHARACTER VARYING(215) 215
26 TRAN_BASIC_PREM NUMERIC(11,2) 19
27 TRAN_BASIC_CHARGES NUMERIC(11,2) 19
28 TRAN_BASIC_STMPDTY NUMERIC(11,2) 19
29 TRAN_BASIC_COMSN NUMERIC(11,2) 19
30 TRAN_BASIC_GST NUMERIC(11,2) 19
31 TRAN_BASIC_CHARGE2 NUMERIC(9,0) 19
32 TRAN_BASIC_CHARGE3 NUMERIC(9,0) 19
33 TRAN_BASIC_CHARGE4 NUMERIC(9,0) 19
34 TRAN_BASIC_CHARGE5 NUMERIC(9,0) 19
35 TRAN_BASIC_CHARGE6 NUMERIC(9,0) 19
36 RATING_ADDRESS INTEGER 4
37 MODULE_NO SMALLINT 2
38 RISK_TYPE1 CHARACTER VARYING(255) 255
39 RISK_TYPE2 CHARACTER VARYING(40) 40
40 RISK_TYPE3 CHARACTER VARYING(40) 40
41 RISK_NO BIGINT 8
42 RISK_COUNT NUMERIC(32,12) 19
43 CRC CHARACTER(1) 1
44 CRCSTATUS CHARACTER(1) 1
45 FLOODOPTOUT CHARACTER(1) 1
46 FLOODRISK CHARACTER(1) 1
47 RD_ASSIST CHARACTER(1) 1
48 HOMEASSIST CHARACTER(1) 1
49 HIRE_CAR CHARACTER(1) 1
50 WINDSCREEN CHARACTER(1) 1