| # |
Name |
Data Type |
Length |
| 1 |
QUOTE_NUMBER |
CHARACTER VARYING(12) |
12 |
| 2 |
PRODUCT_TYPE |
CHARACTER(3) |
3 |
| 3 |
SUB_PRODUCT_TYPE |
CHARACTER(3) |
3 |
| 4 |
QUOTE_DATE |
INTEGER |
4 |
| 5 |
PREMIUM |
NUMERIC(38,2) |
19 |
| 6 |
ANNUAL_OR_MONTHLY |
CHARACTER(1) |
1 |
| 7 |
CAR_YEAR |
SMALLINT |
2 |
| 8 |
CAR_MAKE |
CHARACTER(4) |
4 |
| 9 |
CAR_MODEL |
CHARACTER(7) |
7 |
| 10 |
REGISTRATION_NO |
CHARACTER(12) |
12 |
| 11 |
DATE_OF_BIRTH |
CHARACTER VARYING(200) |
200 |
| 12 |
GENDER |
CHARACTER VARYING(1) |
1 |
| 13 |
QUOTE_EXPIRY_DATE |
DATE |
4 |
| 14 |
STANDARD_EXCESS |
INTEGER |
4 |
| 15 |
VARIABLE_EXCESS |
INTEGER |
4 |
| 16 |
SUM_INSURED |
INTEGER |
4 |
| 17 |
RISK_DESCRIPTION1 |
CHARACTER(50) |
50 |
| 18 |
MARKTMAIL |
CHARACTER(1) |
1 |
| 19 |
ADDRESS_TYPE |
CHARACTER(5) |
5 |
| 20 |
ADDRESS_LINE_1 |
CHARACTER VARYING(30) |
30 |
| 21 |
ADDRESS_LINE_2 |
CHARACTER VARYING(143) |
143 |
| 22 |
ADDRESS_LINE_3 |
CHARACTER VARYING(243) |
243 |
| 23 |
LOCALITY |
CHARACTER VARYING(40) |
40 |
| 24 |
POST_CODE |
NUMERIC(6,0) |
19 |
| 25 |
STATE |
CHARACTER(30) |
30 |