| 1 |
CCR_CC_TRANSACTION_ID |
BIGINT |
8 |
| 2 |
CLAIM_ID |
BIGINT |
8 |
| 3 |
CLAIM_NUMBER |
CHARACTER VARYING(40) |
40 |
| 4 |
EXPOSURE_ID |
BIGINT |
8 |
| 5 |
CCR_CC_TRANSACTION_PUBLICID |
CHARACTER VARYING(64) |
64 |
| 6 |
CCR_CCTL_TRANSACTION_NAME |
CHARACTER VARYING(256) |
256 |
| 7 |
CCR_CCTL_TRANSACTIONSTATUS_NAME |
CHARACTER VARYING(256) |
256 |
| 8 |
CCR_CCTL_COSTTYPE_NAME |
CHARACTER VARYING(256) |
256 |
| 9 |
CCR_CCTL_COSTTYPE_TYPECODE |
CHARACTER VARYING(50) |
50 |
| 10 |
CCR_CCTL_COSTCATEGORY_NAME |
CHARACTER VARYING(256) |
256 |
| 11 |
SC_CHECKPAYAPPLICATION_TYPECODE |
CHARACTER VARYING(50) |
50 |
| 12 |
TRANSACTION_DATE |
TIMESTAMP |
8 |
| 13 |
TRANSACTION_MONTH |
TIMESTAMP |
8 |
| 14 |
OS_EST_MVMT_FLAG |
CHARACTER VARYING(1) |
1 |
| 15 |
MAX_COMMIT_TIMESTAMP |
TIMESTAMP |
8 |
| 16 |
TRAN_DATE_SEQ |
BIGINT |
8 |
| 17 |
CCR_CC_TRANSACTION_SC_JOBFK |
BIGINT |
8 |
| 18 |
CCR_CC_TRANSACTION_TRANSACTIONSETID |
BIGINT |
8 |
| 19 |
CCR_CC_TRANSACTION_CHECKID |
BIGINT |
8 |
| 20 |
CCR_CC_TRANSACTION_CREATETIME |
TIMESTAMP |
8 |
| 21 |
CCR_CC_TRANSACTION_UPDATETIME |
TIMESTAMP |
8 |
| 22 |
CCR_CC_CHECK_ISSUEDATE |
TIMESTAMP |
8 |
| 23 |
CCR_CC_CHECK_PAYTO |
CHARACTER VARYING(255) |
255 |
| 24 |
CCR_CC_CHECK_STATUS_TYPECODE |
CHARACTER VARYING(50) |
50 |
| 25 |
CCR_CC_CHECK_CHECKNUMBER |
CHARACTER VARYING(255) |
255 |
| 26 |
CCR_CC_CHECK_DATEOFSERVICE |
TIMESTAMP |
8 |
| 27 |
SC_GLSERVICEACKTIME |
TIMESTAMP |
8 |
| 28 |
CCR_CC_TRANSACTION_SC_BATCHID |
CHARACTER VARYING(255) |
255 |
| 29 |
FIN_EXPOSURE_TYPE |
CHARACTER VARYING(10) |
10 |
| 30 |
RECOVERY_COST_CATEGORY |
CHARACTER VARYING(256) |
256 |
| 31 |
CCR_CCTL_EXPOSURETYPE_NAME |
CHARACTER VARYING(256) |
256 |
| 32 |
GSTAMOUNT |
NUMERIC(38,2) |
19 |
| 33 |
SC_ITCAMOUNT |
NUMERIC(38,2) |
19 |
| 34 |
SC_DAMAMOUNT |
NUMERIC(38,2) |
19 |
| 35 |
SC_SETTLEMENTAMOUNT |
NUMERIC(38,2) |
19 |
| 36 |
SC_DAMSETTLEMENTAMOUNT |
NUMERIC(38,2) |
19 |
| 37 |
TRANSACTIONAMOUNT |
NUMERIC(38,2) |
19 |
| 38 |
SC_EXCESS |
NUMERIC(38,2) |
19 |
| 39 |
SC_EXCESSGST |
NUMERIC(38,2) |
19 |
| 40 |
GL_EXCESS_ON_PAYMENT |
NUMERIC(38,2) |
19 |
| 41 |
GROSS_INCURRED_EX_GST |
NUMERIC(38,6) |
19 |
| 42 |
NET_INCURRED_EX_GST |
NUMERIC(38,6) |
19 |
| 43 |
OPEN_RECOVERY_RESERVES |
NUMERIC(38,2) |
19 |
| 44 |
OPEN_RECOVERY_RESERVES_EX_GST |
NUMERIC(38,6) |
19 |
| 45 |
OPEN_RESERVES |
NUMERIC(38,2) |
19 |
| 46 |
OPEN_RESERVES_EX_GST |
NUMERIC(38,6) |
19 |
| 47 |
TOTAL_PAYMENTS_EX_GST |
NUMERIC(38,2) |
19 |
| 48 |
TOTAL_RECOVERIES_EX_GST |
NUMERIC(38,2) |
19 |
| 49 |
TOTAL_RECOVERY_RESERVES |
NUMERIC(38,2) |
19 |
| 50 |
TOTAL_RESERVES |
NUMERIC(38,2) |
19 |
| 51 |
ACCT_624513_AMOUNT |
NUMERIC(38,2) |
19 |
| 52 |
ACCT_624520_AMOUNT |
NUMERIC(38,2) |
19 |
| 53 |
ACCT_624111_AMOUNT |
NUMERIC(38,2) |
19 |
| 54 |
ACCT_624131_AMOUNT |
NUMERIC(38,2) |
19 |
| 55 |
ACCT_624512_AMOUNT |
NUMERIC(38,2) |
19 |
| 56 |
TOTAL_RESERVES_EX_GST |
NUMERIC(38,6) |
19 |
| 57 |
INGOING_ESTIMATE_EX_GST |
NUMERIC(38,6) |
19 |
| 58 |
TOTAL_INGOING_ESTIMATE_EX_GST |
NUMERIC(38,6) |
19 |
| 59 |
PAYMENT_GST |
NUMERIC(38,2) |
19 |
| 60 |
RECOVERY_GST |
NUMERIC(38,2) |
19 |
| 61 |
SYSTEM_COST |
NUMERIC(38,2) |
19 |
| 62 |
TOTAL_NON_ERODING_PAYMENTS |
NUMERIC(38,2) |
19 |
| 63 |
TOTAL_PAYMENTS |
NUMERIC(38,2) |
19 |
| 64 |
GROSS_INCURRED |
NUMERIC(38,2) |
19 |