| # |
Name |
Data Type |
Length |
| 1 |
LODGEMENT_DATE |
CHARACTER VARYING(200) |
200 |
| 2 |
INSURED_NAME |
CHARACTER VARYING(181) |
181 |
| 3 |
POLICY_NUMBER |
CHARACTER VARYING(40) |
40 |
| 4 |
CLAIM_NUMBER |
CHARACTER VARYING(40) |
40 |
| 5 |
PAID_AMOUNT |
NUMERIC(38,2) |
19 |
| 6 |
RECOVERIES_AMOUNT |
NUMERIC(38,2) |
19 |
| 7 |
EXCESS_AMOUNT |
NUMERIC(38,2) |
19 |
| 8 |
TOTAL_NET_INCURRED |
NUMERIC(38,2) |
19 |
| 9 |
CLAIM_STATE_NAME |
CHARACTER VARYING(50) |
50 |
| 10 |
FINALISED_DATE |
CHARACTER VARYING(200) |
200 |
| 11 |
EXCESS_APPLICABLE |
NUMERIC(18,2) |
19 |
| 12 |
FLEET_IND |
CHARACTER VARYING(9) |
9 |