INT_PI_HOME_TRANSACTION

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_TRANSACTION_ID BIGINT 8
2 CCR_CC_TRANSACTION_CREATETIME TIMESTAMP 8
3 CCR_CC_TRANSACTION_CLAIMID BIGINT 8
4 CCR_CCTL_TRANSACTION_NAME CHARACTER VARYING(256) 256
5 CCR_CCTL_TRANSACTIONSTATUS_NAME CHARACTER VARYING(256) 256
6 CCR_CCTL_COSTTYPE_NAME CHARACTER VARYING(256) 256
7 CCR_CCTL_COSTCATEGORY_NAME CHARACTER VARYING(256) 256
8 CCR_CCTL_EXPOSURETYPE_NAME CHARACTER VARYING(256) 256
9 CCR_CC_CHECK_PAYTODENORM CHARACTER VARYING(255) 255
10 CCR_CC_CHECK_SCHEDULEDSENDDATE TIMESTAMP 8
11 CCR_CC_TRANSACTION_DOESNOTERODERESERVES CHARACTER VARYING(1) 1
12 PAYMENT_INCLUDE_FLAG SMALLINT 2
13 TRAN_TYPE_CATEGORY_SEQUENCE BIGINT 8
14 CCR_CC_TRANSACTIONLINEITEM_SC_GSTAMOUNT NUMERIC(18,2) 19
15 CCR_CC_TRANSACTIONLINEITEM_SC_ITCAMOUNT NUMERIC(18,2) 19
16 CCR_CC_TRANSACTIONLINEITEM_SC_DAMAMOUNT NUMERIC(18,2) 19
17 CCR_CC_TRANSACTIONLINEITEM_SC_SETTLEMENTAMOUNT NUMERIC(18,2) 19
18 CCR_CC_TRANSACTIONLINEITEM_TRANSACTIONAMOUNT NUMERIC(18,2) 19