IBY_TRXN_EXT_SETTLEMENTS

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
SETTLEMENT_ID TRXN_EXTENSION_ID SETTLEMENT_GROUP_ID PAYMENT_CHANNEL_CODE INSTR_ASSIGNMENT_ID SETTLEMENT_RESULT_CODE SETTLEMENT_DATE PMT_SYS_ERR_CODE PMT_SYS_ERR_MSG PAYMENT_SYSTEM_ORDER_NUMBER PAYEE_ID ORG_TYPE ORG_ID INITIATOR_EXTENSION_ID ORIGIN_APPLICATION_ID

Name

SETTLEMENT_ID

TRXN_EXTENSION_ID

SETTLEMENT_GROUP_ID

PAYMENT_CHANNEL_CODE

INSTR_ASSIGNMENT_ID

SETTLEMENT_RESULT_CODE

SETTLEMENT_DATE

PMT_SYS_ERR_CODE

PMT_SYS_ERR_MSG

PAYMENT_SYSTEM_ORDER_NUMBER

PAYEE_ID

ORG_TYPE

ORG_ID

INITIATOR_EXTENSION_ID

ORIGIN_APPLICATION_ID

Query

SQL_Statement
SELECT s.transactionid SETTLEMENT_ID, x.trxn_extension_id TRXN_EXTENSION_ID, s.mbatchid SETTLEMENT_GROUP_ID, x.payment_channel_code PAYMENT_CHANNEL_CODE, x.instr_assignment_id INSTR_ASSIGNMENT_ID, DECODE(s.status, 0,'SETTLEMENT_SUCCESS', 1,'COMMUNICATION_ERROR', 2,'DUPLICATE_SETTLEMENT', 4,'GENERAL_INVALID_PARAM', 5,'PAYMENT_SYS_REJECT', 11,'SETTLEMENT_PENDING', 12,'SETTLEMENT_PENDING', 13,'SETTLEMENT_PENDING', 16,'PAYMENT_SYS_REJECT', 17,'PAYMENT_SYS_REJECT', 18,'SETTLEMENT_PENDING', 19,'GENERAL_INVALID_PARAM', 20,'PAYMENT_SYS_REJECT', 100,'SETTLEMENT_PENDING', 101,'COMMUNICATION_ERROR', 111,'SETTLEMENT_PENDING', 'GENERAL_SYS_ERROR' ) SETTLEMENT_RESULT_CODE, s.updatedate SETTLEMENT_DATE, s.bepcode PMT_SYS_ERR_CODE, s.bepmessage PMT_SYS_ERR_MSG, s.tangibleid PAYMENT_SYSTEM_ORDER_NUMBER, s.payeeid PAYEE_ID, s.org_type ORG_TYPE, s.org_id ORG_ID, s.initiator_extension_id INITIATOR_EXTENSION_ID, x.origin_application_id ORIGIN_APPLICATION_ID FROM IBY_FNDCPT_TX_EXTENSIONS X,IBY_FNDCPT_TX_OPERATIONS O,IBY_TRXN_SUMMARIES_ALL S WHERE (x.trxn_extension_id = o.trxn_extension_id) AND (o.transactionid = s.transactionid) AND ( (s.instrtype IN ('CREDITCARD', 'PURCHASECARD') AND (s.reqtype = 'ORAPMTCAPTURE' OR s.trxntypeid=3) ) OR (s.instrtype = 'PINLESSDEBITCARD' AND s.reqtype = 'ORAPMTREQ') OR (s.instrtype = 'BANKACCOUNT' AND s.reqtype = 'ORAPMTBATCHREQ') )

SQL_Statement

SELECT s.transactionid SETTLEMENT_ID, x.trxn_extension_id TRXN_EXTENSION_ID,

s.mbatchid SETTLEMENT_GROUP_ID, x.payment_channel_code PAYMENT_CHANNEL_CODE,

x.instr_assignment_id INSTR_ASSIGNMENT_ID,

DECODE(s.status, 0,'SETTLEMENT_SUCCESS', 1,'COMMUNICATION_ERROR', 2,'DUPLICATE_SETTLEMENT', 4,'GENERAL_INVALID_PARAM', 5,'PAYMENT_SYS_REJECT', 11,'SETTLEMENT_PENDING', 12,'SETTLEMENT_PENDING', 13,'SETTLEMENT_PENDING', 16,'PAYMENT_SYS_REJECT', 17,'PAYMENT_SYS_REJECT', 18,'SETTLEMENT_PENDING', 19,'GENERAL_INVALID_PARAM', 20,'PAYMENT_SYS_REJECT', 100,'SETTLEMENT_PENDING', 101,'COMMUNICATION_ERROR', 111,'SETTLEMENT_PENDING', 'GENERAL_SYS_ERROR' ) SETTLEMENT_RESULT_CODE, s.updatedate SETTLEMENT_DATE, s.bepcode PMT_SYS_ERR_CODE,

s.bepmessage PMT_SYS_ERR_MSG, s.tangibleid PAYMENT_SYSTEM_ORDER_NUMBER,

s.payeeid PAYEE_ID, s.org_type ORG_TYPE, s.org_id ORG_ID,

s.initiator_extension_id INITIATOR_EXTENSION_ID, x.origin_application_id ORIGIN_APPLICATION_ID

FROM IBY_FNDCPT_TX_EXTENSIONS X,IBY_FNDCPT_TX_OPERATIONS O,IBY_TRXN_SUMMARIES_ALL S

WHERE (x.trxn_extension_id = o.trxn_extension_id) AND (o.transactionid = s.transactionid) AND ( (s.instrtype IN ('CREDITCARD', 'PURCHASECARD') AND (s.reqtype = 'ORAPMTCAPTURE' OR s.trxntypeid=3) ) OR (s.instrtype = 'PINLESSDEBITCARD' AND s.reqtype = 'ORAPMTREQ') OR (s.instrtype = 'BANKACCOUNT' AND s.reqtype = 'ORAPMTBATCHREQ') )