INT_BASE_PI_RES_PCSS_QUOTE_HOME

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(5) 5
5 EFFECTIVEDATE DATE 4
6 BASEPREMAMT NUMERIC(11,2) 19
7 RISKSTATE CHARACTER(3) 3
8 DUEDATE DATE 4
9 EXPIRYDATE DATE 4
10 SALESTRANSDATE TIMESTAMP 8
11 ISSUEDPAIDFLAG CHARACTER VARYING(1) 1
12 TX_N INTEGER 4
13 COVERNUMBER CHARACTER VARYING(3) 3
14 TERMID CHARACTER VARYING(3) 3
15 PAYPLANCODE CHARACTER VARYING(1) 1
16 CONVERTEDTO CHARACTER(10) 10
17 COVERSUBCODE CHARACTER(3) 3
18 COVERSEQ CHARACTER VARYING(3) 3
19 TERMOFBUSINESSCODE CHARACTER VARYING(1) 1
20 RISKPOSTCODE CHARACTER(8) 8
21 COMM_ACCOUNT_1 CHARACTER(10) 10
22 COMM_ACCOUNT_2 CHARACTER(10) 10