VIEW: IBY.IBY_TRXN_SUMMARIES_ALL#

Source

View Text - Preformatted

select TRXNMID TRXNMID, TRANSACTIONID TRANSACTIONID, TANGIBLEID TANGIBLEID, PAYEEID PAYEEID, BEPID BEPID, MPAYEEID MPAYEEID, ECAPPID ECAPPID, ORG_ID ORG_ID, PAYMENTMETHODNAME PAYMENTMETHODNAME, MTANGIBLEID MTANGIBLEID, PAYEEINSTRID PAYEEINSTRID, PAYERID PAYERID, PAYERINSTRID PAYERINSTRID, DETAILLOOKUP DETAILLOOKUP, AMOUNT AMOUNT, INSTRNUMBER INSTRNUMBER, CURRENCYNAMECODE CURRENCYNAMECODE, STATUS STATUS, UPDATEDATE UPDATEDATE, TRXNTYPEID TRXNTYPEID, ERRORLOCATION ERRORLOCATION, BEPCODE BEPCODE, BEPMESSAGE BEPMESSAGE, BATCHID BATCHID, SETTLEDATE SETTLEDATE, MBATCHID MBATCHID, REQDATE REQDATE, REQTYPE REQTYPE, REQSEQ REQSEQ, DESTURL DESTURL, NLSLANG NLSLANG, NEEDSUPDT NEEDSUPDT, OVERALL_SCORE OVERALL_SCORE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INSTRTYPE INSTRTYPE, SECURITY_GROUP_ID SECURITY_GROUP_ID, SALES_REP_PARTY_ID SALES_REP_PARTY_ID, BEPKEY BEPKEY, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, INSTRSUBTYPE INSTRSUBTYPE, SUB_KEY_ID SUB_KEY_ID, ECBATCHID ECBATCHID, TRXNREF TRXNREF, PROCESS_PROFILE_CODE PROCESS_PROFILE_CODE, ACCT_SITE_USE_ID ACCT_SITE_USE_ID, ORG_TYPE ORG_TYPE, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID, FACTORED_FLAG FACTORED_FLAG, INSTRNUM_HASH INSTRNUM_HASH, INSTRNUM_LENGTH INSTRNUM_LENGTH, PAYMENT_CHANNEL_CODE PAYMENT_CHANNEL_CODE, CC_ISSUER_RANGE_ID CC_ISSUER_RANGE_ID, INSTRNUM_SEC_SEGMENT_ID INSTRNUM_SEC_SEGMENT_ID, PROC_REFERENCE_CODE PROC_REFERENCE_CODE, PROC_REFERENCE_AMOUNT PROC_REFERENCE_AMOUNT, SETTLEMENT_CUSTOMER_REFERENCE SETTLEMENT_CUSTOMER_REFERENCE, BR_MATURITY_DATE BR_MATURITY_DATE, SETTLEMENT_DUE_DATE SETTLEMENT_DUE_DATE, CALL_APP_SERVICE_REQ_CODE CALL_APP_SERVICE_REQ_CODE, BANK_CHARGE_BEARER_CODE BANK_CHARGE_BEARER_CODE, DIRDEB_INSTRUCTION_CODE DIRDEB_INSTRUCTION_CODE, DEBIT_ADVICE_DELIVERY_METHOD DEBIT_ADVICE_DELIVERY_METHOD, DEBIT_ADVICE_EMAIL DEBIT_ADVICE_EMAIL, DEBIT_ADVICE_FAX DEBIT_ADVICE_FAX, PAYER_PARTY_ID PAYER_PARTY_ID, FIRST_TRXN_FLAG FIRST_TRXN_FLAG, ACCT_SITE_ID ACCT_SITE_ID, DEBIT_AUTH_FLAG DEBIT_AUTH_FLAG, DEBIT_AUTH_METHOD DEBIT_AUTH_METHOD, DEBIT_AUTH_REFERENCE DEBIT_AUTH_REFERENCE, PAYER_INSTR_ASSIGNMENT_ID PAYER_INSTR_ASSIGNMENT_ID, PAYER_NOTIFICATION_REQUIRED PAYER_NOTIFICATION_REQUIRED, PAYER_NOTIFICATION_CREATED PAYER_NOTIFICATION_CREATED, AR_RECEIPT_METHOD_ID AR_RECEIPT_METHOD_ID, BR_DRAWEE_ISSUED_FLAG BR_DRAWEE_ISSUED_FLAG, BR_SIGNED_FLAG BR_SIGNED_FLAG, SALT_VERSION SALT_VERSION, INITIATOR_EXTENSION_ID INITIATOR_EXTENSION_ID, LOGICAL_GROUP_REFERENCE LOGICAL_GROUP_REFERENCE, SEQ_TYPE SEQ_TYPE, SERVICE_LEVEL SERVICE_LEVEL, LOCALINSTR LOCALINSTR, CATEGORY_PURPOSE CATEGORY_PURPOSE, DEBIT_AUTHORIZATION_ID DEBIT_AUTHORIZATION_ID, CREDITOR_REFERENCE CREDITOR_REFERENCE from "IBY"."IBY_TRXN_SUMMARIES_ALL"

View Text - HTML Formatted

SELECT TRXNMID TRXNMID
, TRANSACTIONID TRANSACTIONID
, TANGIBLEID TANGIBLEID
, PAYEEID PAYEEID
, BEPID BEPID
, MPAYEEID MPAYEEID
, ECAPPID ECAPPID
, ORG_ID ORG_ID
, PAYMENTMETHODNAME PAYMENTMETHODNAME
, MTANGIBLEID MTANGIBLEID
, PAYEEINSTRID PAYEEINSTRID
, PAYERID PAYERID
, PAYERINSTRID PAYERINSTRID
, DETAILLOOKUP DETAILLOOKUP
, AMOUNT AMOUNT
, INSTRNUMBER INSTRNUMBER
, CURRENCYNAMECODE CURRENCYNAMECODE
, STATUS STATUS
, UPDATEDATE UPDATEDATE
, TRXNTYPEID TRXNTYPEID
, ERRORLOCATION ERRORLOCATION
, BEPCODE BEPCODE
, BEPMESSAGE BEPMESSAGE
, BATCHID BATCHID
, SETTLEDATE SETTLEDATE
, MBATCHID MBATCHID
, REQDATE REQDATE
, REQTYPE REQTYPE
, REQSEQ REQSEQ
, DESTURL DESTURL
, NLSLANG NLSLANG
, NEEDSUPDT NEEDSUPDT
, OVERALL_SCORE OVERALL_SCORE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INSTRTYPE INSTRTYPE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, SALES_REP_PARTY_ID SALES_REP_PARTY_ID
, BEPKEY BEPKEY
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, INSTRSUBTYPE INSTRSUBTYPE
, SUB_KEY_ID SUB_KEY_ID
, ECBATCHID ECBATCHID
, TRXNREF TRXNREF
, PROCESS_PROFILE_CODE PROCESS_PROFILE_CODE
, ACCT_SITE_USE_ID ACCT_SITE_USE_ID
, ORG_TYPE ORG_TYPE
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID
, FACTORED_FLAG FACTORED_FLAG
, INSTRNUM_HASH INSTRNUM_HASH
, INSTRNUM_LENGTH INSTRNUM_LENGTH
, PAYMENT_CHANNEL_CODE PAYMENT_CHANNEL_CODE
, CC_ISSUER_RANGE_ID CC_ISSUER_RANGE_ID
, INSTRNUM_SEC_SEGMENT_ID INSTRNUM_SEC_SEGMENT_ID
, PROC_REFERENCE_CODE PROC_REFERENCE_CODE
, PROC_REFERENCE_AMOUNT PROC_REFERENCE_AMOUNT
, SETTLEMENT_CUSTOMER_REFERENCE SETTLEMENT_CUSTOMER_REFERENCE
, BR_MATURITY_DATE BR_MATURITY_DATE
, SETTLEMENT_DUE_DATE SETTLEMENT_DUE_DATE
, CALL_APP_SERVICE_REQ_CODE CALL_APP_SERVICE_REQ_CODE
, BANK_CHARGE_BEARER_CODE BANK_CHARGE_BEARER_CODE
, DIRDEB_INSTRUCTION_CODE DIRDEB_INSTRUCTION_CODE
, DEBIT_ADVICE_DELIVERY_METHOD DEBIT_ADVICE_DELIVERY_METHOD
, DEBIT_ADVICE_EMAIL DEBIT_ADVICE_EMAIL
, DEBIT_ADVICE_FAX DEBIT_ADVICE_FAX
, PAYER_PARTY_ID PAYER_PARTY_ID
, FIRST_TRXN_FLAG FIRST_TRXN_FLAG
, ACCT_SITE_ID ACCT_SITE_ID
, DEBIT_AUTH_FLAG DEBIT_AUTH_FLAG
, DEBIT_AUTH_METHOD DEBIT_AUTH_METHOD
, DEBIT_AUTH_REFERENCE DEBIT_AUTH_REFERENCE
, PAYER_INSTR_ASSIGNMENT_ID PAYER_INSTR_ASSIGNMENT_ID
, PAYER_NOTIFICATION_REQUIRED PAYER_NOTIFICATION_REQUIRED
, PAYER_NOTIFICATION_CREATED PAYER_NOTIFICATION_CREATED
, AR_RECEIPT_METHOD_ID AR_RECEIPT_METHOD_ID
, BR_DRAWEE_ISSUED_FLAG BR_DRAWEE_ISSUED_FLAG
, BR_SIGNED_FLAG BR_SIGNED_FLAG
, SALT_VERSION SALT_VERSION
, INITIATOR_EXTENSION_ID INITIATOR_EXTENSION_ID
, LOGICAL_GROUP_REFERENCE LOGICAL_GROUP_REFERENCE
, SEQ_TYPE SEQ_TYPE
, SERVICE_LEVEL SERVICE_LEVEL
, LOCALINSTR LOCALINSTR
, CATEGORY_PURPOSE CATEGORY_PURPOSE
, DEBIT_AUTHORIZATION_ID DEBIT_AUTHORIZATION_ID
, CREDITOR_REFERENCE CREDITOR_REFERENCE
FROM "IBY"."IBY_TRXN_SUMMARIES_ALL"