| 1 |
POLICYID |
BIGINT |
8 |
| 2 |
POLICYNUMBER |
CHARACTER VARYING(40) |
40 |
| 3 |
POLICY_PERIOD_START_LABEL |
CHARACTER VARYING(200) |
200 |
| 4 |
POLICY_PERIOD_END_LABEL |
CHARACTER VARYING(200) |
200 |
| 5 |
CLAIMID |
BIGINT |
8 |
| 6 |
CLAIM_NO |
CHARACTER VARYING(40) |
40 |
| 7 |
LOSS_DATE_LABEL |
CHARACTER VARYING(200) |
200 |
| 8 |
REPORT_DATE_LABEL |
CHARACTER VARYING(200) |
200 |
| 9 |
CLAIM_CLOSEDATE |
TIMESTAMP |
8 |
| 10 |
PRN |
CHARACTER VARYING(19) |
19 |
| 11 |
ACCIDENTTYPEID |
BIGINT |
8 |
| 12 |
ACC_DESC |
CHARACTER VARYING(256) |
256 |
| 13 |
COST_CENTRE |
CHARACTER VARYING(15) |
15 |
| 14 |
DIVISION |
CHARACTER VARYING(60) |
60 |
| 15 |
INCIDENDTID |
BIGINT |
8 |
| 16 |
INSUREDVEHICLEID |
BIGINT |
8 |
| 17 |
VEH_REG |
CHARACTER VARYING(40) |
40 |
| 18 |
SURNAME |
CHARACTER VARYING(90) |
90 |
| 19 |
FIRST_NAME |
CHARACTER VARYING(90) |
90 |
| 20 |
TRANSACTIONID |
BIGINT |
8 |
| 21 |
TRANSACTION_CREATETIME |
TIMESTAMP |
8 |
| 22 |
PAYMENT_YEAR |
BIGINT |
8 |
| 23 |
PAYMENT_MONTH |
CHARACTER VARYING(200) |
200 |
| 24 |
PAYMENT_PERIOD_START_LABEL |
CHARACTER VARYING(200) |
200 |
| 25 |
PAYMENT_PERIOD_END_LABEL |
CHARACTER VARYING(200) |
200 |
| 26 |
AMOUNT_PAID_NOT_SUBJECT_TO_GST |
NUMERIC(20,2) |
19 |
| 27 |
AMOUNT_PAID_SUBJECT_TO_GST |
NUMERIC(18,2) |
19 |
| 28 |
GST_APPLICABLE |
NUMERIC(18,2) |
19 |
| 29 |
AMOUNT_PAID_SUBJECT_TO_GST_INCL_GST |
NUMERIC(19,2) |
19 |