FCT_MFUD_INVOICE_UNDER_EXCESS
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | POLICYID | BIGINT | 8 |
| 2 | POLICYNUMBER | CHARACTER VARYING(40) | 40 |
| 3 | POLICY_START_YEAR | BIGINT | 8 |
| 4 | POLICY_END_YEAR | BIGINT | 8 |
| 5 | CLAIMID | BIGINT | 8 |
| 6 | CLAIM_CLOSEDATE | TIMESTAMP | 8 |
| 7 | TRANSACTIONID | BIGINT | 8 |
| 8 | TRANSACTION_CREATETIME | TIMESTAMP | 8 |
| 9 | INVOICE_YEAR | BIGINT | 8 |
| 10 | INVOICE_MONTH | CHARACTER VARYING(200) | 200 |
| 11 | INVOICE_NUMBER | CHARACTER VARYING(200) | 200 |
| 12 | AMOUNT_PAID_NOT_SUBJECT_TO_GST | NUMERIC(20,2) | 19 |
| 13 | AMOUNT_PAID_SUBJECT_TO_GST | NUMERIC(18,2) | 19 |
| 14 | GST_APPLICABLE | NUMERIC(18,2) | 19 |