INT_PI_CLAIM_TRANSACTION

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_TRANSACTIONLINEITEM_ID BIGINT 8
2 CCR_CC_TRANSACTION_ID BIGINT 8
3 CCR_CC_TRANSACTION_PUBLICID CHARACTER VARYING(64) 64
4 CCR_CC_TRANSACTION_CREATETIME TIMESTAMP 8
5 CCR_CC_TRANSACTION_UPDATETIME TIMESTAMP 8
6 CCR_CC_TRANSACTION_CLAIMID BIGINT 8
7 CCR_CC_TRANSACTION_EXPOSUREID BIGINT 8
8 CCR_CC_TRANSACTION_SC_JOBFK BIGINT 8
9 CCR_CC_TRANSACTION_CHECKID BIGINT 8
10 SC_BATCHID CHARACTER VARYING(255) 255
11 CCR_CC_TRANSACTION_SC_CHECKPAYAPPLICATION BIGINT 8
12 CCR_CC_TRANSACTION_TRANSACTIONSETID BIGINT 8
13 CCR_CC_CHECK_ISSUEDATE TIMESTAMP 8
14 CCR_CC_CHECK_RETIRED BIGINT 8
15 CCR_CC_CHECK_SC_CHECKPAYAPPLICATION BIGINT 8
16 CCR_CC_CHECK_CHECKNUMBER CHARACTER VARYING(255) 255
17 CCR_CC_CHECK_STATUS_ID BIGINT 8
18 CCR_CC_CHECK_STATUS_TYPECODE CHARACTER VARYING(50) 50
19 SC_GLSERVICEACKTIME TIMESTAMP 8
20 SC_BULKJOURNALITEMID BIGINT 8
21 CCR_CCTL_TRANSACTION_NAME CHARACTER VARYING(256) 256
22 CCR_CCTL_TRANSACTION_TYPECODE CHARACTER VARYING(50) 50
23 CCR_CCTL_TRANSACTIONSTATUS_NAME CHARACTER VARYING(256) 256
24 CCR_CCTL_TRANSACTIONSTATUS_TYPECODE CHARACTER VARYING(50) 50
25 CCR_CCTL_COSTTYPE_NAME CHARACTER VARYING(256) 256
26 CCR_CCTL_COSTTYPE_TYPECODE CHARACTER VARYING(50) 50
27 CCR_CCTL_COSTCATEGORY_NAME CHARACTER VARYING(256) 256
28 CCR_CCTL_COSTCATEGORY_TYPECODE CHARACTER VARYING(50) 50
29 CCR_CC_TRANSACTION_DOESNOTERODERESERVES CHARACTER VARYING(1) 1
30 CCR_CC_TRANSACTION_SC_DEDUCTEXCESS CHARACTER VARYING(1) 1
31 CCR_CCTL_TRANSACTIONLIFECYCLESTATE_TYPECODE CHARACTER VARYING(50) 50
32 CCR_CCTL_SC_GSTSTATUS_NAME CHARACTER VARYING(256) 256
33 CCR_CC_TRANSACTIONLINEITEM_RETIRED BIGINT 8
34 CCR_CCX_SC_PAYMENTREFNUMBER_VEHICLEINCIDENTID BIGINT 8
35 CCR_CC_CHECK_DATEOFSERVICE TIMESTAMP 8
36 CCR_CC_TRANSACTIONLINEITEM_SC_GSTAMOUNT NUMERIC(18,2) 19
37 CCR_CC_TRANSACTIONLINEITEM_SC_ITCAMOUNT NUMERIC(18,2) 19
38 CCR_CC_TRANSACTIONLINEITEM_SC_DAMAMOUNT NUMERIC(18,2) 19
39 CCR_CC_TRANSACTIONLINEITEM_SC_SETTLEMENTAMOUNT NUMERIC(18,2) 19
40 CCR_CC_TRANSACTIONLINEITEM_SC_DAMSETTLEMENTAMOUNT NUMERIC(18,2) 19
41 CCR_CC_TRANSACTIONLINEITEM_TRANSACTIONAMOUNT NUMERIC(18,2) 19
42 CCR_CC_TRANSACTIONLINEITEM_SC_EXCESS NUMERIC(18,2) 19
43 CCR_CC_TRANSACTIONLINEITEM_SC_EXCESSGST NUMERIC(18,2) 19
44 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
45 CCR_CC_CHECK_PAYTO CHARACTER VARYING(255) 255