INT_BASE_PI_QUOTE_TRANSACTION_OUTDATA

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO SMALLINT 2
2 POLICY_NO INTEGER 4
3 POLICY INTEGER 4
4 AGREEMENT_TYPE CHARACTER(3) 3
5 ITEM_NO SMALLINT 2
6 PRODUCT CHARACTER(3) 3
7 PRODUCT_TYPE_CODE CHARACTER(3) 3
8 PRODUCT_CLASS_CODE CHARACTER(3) 3
9 PRODUCT_SUBCLASS CHARACTER(3) 3
10 RISK_STATE CHARACTER(2) 2
11 USERID CHARACTER(8) 8
12 USER_TYPE CHARACTER VARYING(1) 1
13 VEHICLE_AGE BIGINT 8
14 PRODUCT_EXTRA_KEY1 CHARACTER VARYING(10) 10
15 PRODUCT_EXTRA_KEY2 CHARACTER VARYING(10) 10
16 TRANSACTION_DATE DATE 4
17 TRANTIME_REF INTEGER 4
18 TRAN_BASIC_PREM NUMERIC(11,2) 19
19 SCHEDULE_START DATE 4
20 COVER_NOTE_END_DTE DATE 4
21 SCHEDULE_END DATE 4
22 INSTALMENT_FREQ CHARACTER(1) 1
23 TRAN_BASIC_CHARGES NUMERIC(11,2) 19
24 TRAN_BASIC_STMPDTY NUMERIC(11,2) 19
25 TRAN_BASIC_COMSN NUMERIC(11,2) 19
26 TRAN_BASIC_GST NUMERIC(11,2) 19
27 TRAN_BASIC_CHARGE2 INTEGER 4
28 TRAN_BASIC_CHARGE3 INTEGER 4
29 TRAN_BASIC_CHARGE4 INTEGER 4
30 TRAN_BASIC_CHARGE5 INTEGER 4
31 TRAN_BASIC_CHARGE6 INTEGER 4
32 RISK_POSTCODE CHARACTER VARYING(4) 4
33 CHANNEL_KEY1 CHARACTER VARYING(10) 10
34 CHANNEL_KEY2 CHARACTER VARYING(10) 10
35 UNIT_COUNT NUMERIC(1,0) 19
36 DUE_DATE DATE 4
37 SOURCE_SYSTEM_POLICY_ID CHARACTER VARYING(215) 215
38 RATING_ADDRESS INTEGER 4
39 MODULE_NO SMALLINT 2
40 CUSTOMER_REFERENCE CHARACTER(14) 14
41 BUSINESS_SOURCE CHARACTER(4) 4
42 COMPLETE_IND CHARACTER(1) 1
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 RISK_COUNT NUMERIC(32,12) 19
50 RISK_NO BIGINT 8
51 RISKDESC CHARACTER(100) 100
52 CRC CHARACTER(1) 1
53 CRCSTATUS CHARACTER(1) 1
54 FLOODOPTOUT CHARACTER(1) 1
55 FLOODRISK CHARACTER(1) 1
56 HOMEASSIST CHARACTER(1) 1
57 RD_ASSIST CHARACTER(1) 1
58 HIRE_CAR CHARACTER(1) 1
59 WINDSCREEN CHARACTER(1) 1
60 ROW_NUMBER BIGINT 8