| # |
Name |
Data Type |
Length |
| 1 |
POLICYNUMBER |
CHARACTER VARYING(40) |
40 |
| 2 |
CTPNUMBER |
CHARACTER VARYING(40) |
40 |
| 3 |
RNWALTERM |
INTEGER |
4 |
| 4 |
CLASS |
CHARACTER(4) |
4 |
| 5 |
USERTRAN |
CHARACTER(4) |
4 |
| 6 |
USERTRANDESC |
CHARACTER VARYING(100) |
100 |
| 7 |
TRANDATE |
DATE |
4 |
| 8 |
EFFECTDTE |
DATE |
4 |
| 9 |
TERMSTART |
DATE |
4 |
| 10 |
TRANCNT |
INTEGER |
4 |
| 11 |
DUEDATE |
DATE |
4 |
| 12 |
BASEPREM |
NUMERIC(38,2) |
19 |
| 13 |
DISCOUNTLOADING |
NUMERIC(38,2) |
19 |
| 14 |
INSURERPREM |
NUMERIC(38,2) |
19 |
| 15 |
GST |
NUMERIC(38,2) |
19 |
| 16 |
STAMPDUTY |
NUMERIC(38,2) |
19 |
| 17 |
LEVIES |
NUMERIC(38,2) |
19 |
| 18 |
SIRALEVY |
NUMERIC(38,2) |
19 |
| 19 |
LTCSLEVY |
NUMERIC(38,2) |
19 |
| 20 |
ADMIN |
NUMERIC(38,2) |
19 |
| 21 |
ADMINGST |
NUMERIC(38,2) |
19 |
| 22 |
GROSSPREMIUM |
NUMERIC(38,2) |
19 |
| 23 |
COMMISSION |
NUMERIC(38,2) |
19 |
| 24 |
GSTONCOMM |
NUMERIC(38,2) |
19 |
| 25 |
NETPREMIUM |
NUMERIC(38,2) |
19 |
| 26 |
REMAMOUNT |
NUMERIC(38,2) |
19 |