FCT_MFUD_PAYMENT_RECONCILIATION
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | TRANSACTION_ID | BIGINT | 8 |
| 2 | TRANSACTION_CREATETIME | TIMESTAMP | 8 |
| 3 | TRANSACTION_CREATETIME_YEAR | BIGINT | 8 |
| 4 | TRANSACTION_CREATETIME_MONTH | CHARACTER VARYING(200) | 200 |
| 5 | CLAIM_ID | BIGINT | 8 |
| 6 | CLAIM_NUMBER | CHARACTER VARYING(40) | 40 |
| 7 | POLICY_NUMBER | CHARACTER VARYING(40) | 40 |
| 8 | INSURED_NAME | CHARACTER VARYING(181) | 181 |
| 9 | TRANSACTION_TYPE | CHARACTER VARYING(256) | 256 |
| 10 | CHECK_SCHEDULEDSENDDATE | TIMESTAMP | 8 |
| 11 | TRANSACTIONAMOUNT | NUMERIC(18,2) | 19 |