INT_BASE_PI_RES_QUOTE_TRANSACTION_T1

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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