FCT_CTP_DDR_ACT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | POLICY_NUMBER | CHARACTER VARYING(39) | 39 |
| 2 | POLICY_TERM_MONTHS | INTEGER | 4 |
| 3 | POLICY_TERM_DAYS | INTEGER | 4 |
| 4 | VEHICLE_CLASS | CHARACTER(4) | 4 |
| 5 | VEHICLE_CLASS_DESCRIPTION | CHARACTER VARYING(60) | 60 |
| 6 | USER_TRANSACTION_TYPE | CHARACTER VARYING(60) | 60 |
| 7 | TRANSACTION_TYPE | CHARACTER VARYING(60) | 60 |
| 8 | TRANSACTION_DATE | INTEGER | 4 |
| 9 | ITEMPREM_EFFECTDTE | INTEGER | 4 |
| 10 | ITEMPREM_BASEPREM | NUMERIC(15,6) | 19 |
| 11 | ITEMPREM_CHARGES | NUMERIC(15,6) | 19 |
| 12 | ITEMPREM_GST | NUMERIC(15,6) | 19 |
| 13 | CALCULATED_ITEMPREM_AMT | NUMERIC(16,6) | 19 |
| 14 | ITEM_TBASICPREM | NUMERIC(11,2) | 19 |
| 15 | ITEM_TCHARGES | NUMERIC(11,2) | 19 |
| 16 | ITEM_GST | NUMERIC(11,2) | 19 |
| 17 | CALCULATED_ITEM_AMT | NUMERIC(12,2) | 19 |
| 18 | CALCULATED_VARIANCE | NUMERIC(17,6) | 19 |
| 19 | DISTRICT | CHARACTER VARYING(48) | 48 |
| 20 | ITC | CHARACTER(1) | 1 |
| 21 | CTPNO | CHARACTER(12) | 12 |
| 22 | PLATE_NUMBER | CHARACTER(12) | 12 |
| 23 | VEHICLE_CHASSIS_NUMBER | CHARACTER(25) | 25 |
| 24 | TERMSTART | INTEGER | 4 |
| 25 | DUEDATE | INTEGER | 4 |