INT_BASE_PI_RES_PCSS_QUOTE_MOTOR

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY CHARACTER(3) 3
2 QUOTENUMBER CHARACTER(10) 10
3 COVERAGECODE CHARACTER(2) 2
4 PRODUCTCODE CHARACTER VARYING(4) 4
5 RISKSTATE CHARACTER(3) 3
6 BASEPREMAMT NUMERIC(11,2) 19
7 EFFECTIVEDATE DATE 4
8 EXPIRYDATE DATE 4
9 COVERSUBCODE CHARACTER(3) 3
10 SALESTRANSDATE TIMESTAMP 8
11 PRODUCTTYPE CHARACTER(2) 2
12 DUEDATE DATE 4
13 CONVERTEDTO CHARACTER(10) 10
14 ISSUEDPAIDFLAG CHARACTER VARYING(1) 1
15 TX_N INTEGER 4
16 COVERNUMBER CHARACTER VARYING(3) 3
17 COVERSEQ CHARACTER VARYING(3) 3
18 TERMID CHARACTER VARYING(3) 3
19 PAYPLANCODE CHARACTER VARYING(1) 1
20 RISKPOSTCODE CHARACTER(8) 8
21 TERMOFBUSINESSCODE CHARACTER VARYING(1) 1
22 COMM_ACCOUNT_1 CHARACTER(10) 10
23 COMM_ACCOUNT_2 CHARACTER(10) 10