VIEW: CE.CE_PAYMENT_TRANSACTIONS#

Source

View Text - Preformatted

select TRXN_REFERENCE_NUMBER TRXN_REFERENCE_NUMBER, SETTLE_BY_SYSTEM_FLAG SETTLE_BY_SYSTEM_FLAG, TRANSACTION_TYPE TRANSACTION_TYPE, TRXN_SUBTYPE_CODE_ID TRXN_SUBTYPE_CODE_ID, TRANSACTION_DATE TRANSACTION_DATE, ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE, TRANSACTION_DESCRIPTION TRANSACTION_DESCRIPTION, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, PAYMENT_AMOUNT PAYMENT_AMOUNT, SOURCE_PARTY_ID SOURCE_PARTY_ID, SOURCE_LEGAL_ENTITY_ID SOURCE_LEGAL_ENTITY_ID, SOURCE_BANK_ACCOUNT_ID SOURCE_BANK_ACCOUNT_ID, DESTINATION_PARTY_ID DESTINATION_PARTY_ID, DESTINATION_LEGAL_ENTITY_ID DESTINATION_LEGAL_ENTITY_ID, DESTINATION_BANK_ACCOUNT_ID DESTINATION_BANK_ACCOUNT_ID, DESTINATION_PARTY_SITE_ID DESTINATION_PARTY_SITE_ID, REPETITIVE_PAYMENT_CODE REPETITIVE_PAYMENT_CODE, TRXN_STATUS_CODE TRXN_STATUS_CODE, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, AUTHORIZE_FLAG AUTHORIZE_FLAG, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, PAYMENT_REASON_CODE PAYMENT_REASON_CODE, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS, REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1, REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2, REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3, CREATED_FROM_DIR CREATED_FROM_DIR, CREATE_FROM_STMTLINE_ID CREATE_FROM_STMTLINE_ID, BANK_TRXN_NUMBER BANK_TRXN_NUMBER, PAYMENT_REQUEST_NUMBER PAYMENT_REQUEST_NUMBER, PAPER_DOCUMENT_NUMBER PAPER_DOCUMENT_NUMBER, DOC_SEQUENCE_ID DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE, DOC_CATEGORY_CODE DOC_CATEGORY_CODE, PAYMENT_OFFSET_CCID PAYMENT_OFFSET_CCID, RECEIPT_OFFSET_CCID RECEIPT_OFFSET_CCID, CASHPOOL_ID CASHPOOL_ID, EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "CE"."CE_PAYMENT_TRANSACTIONS"

View Text - HTML Formatted

SELECT TRXN_REFERENCE_NUMBER TRXN_REFERENCE_NUMBER
, SETTLE_BY_SYSTEM_FLAG SETTLE_BY_SYSTEM_FLAG
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRXN_SUBTYPE_CODE_ID TRXN_SUBTYPE_CODE_ID
, TRANSACTION_DATE TRANSACTION_DATE
, ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE
, TRANSACTION_DESCRIPTION TRANSACTION_DESCRIPTION
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, SOURCE_PARTY_ID SOURCE_PARTY_ID
, SOURCE_LEGAL_ENTITY_ID SOURCE_LEGAL_ENTITY_ID
, SOURCE_BANK_ACCOUNT_ID SOURCE_BANK_ACCOUNT_ID
, DESTINATION_PARTY_ID DESTINATION_PARTY_ID
, DESTINATION_LEGAL_ENTITY_ID DESTINATION_LEGAL_ENTITY_ID
, DESTINATION_BANK_ACCOUNT_ID DESTINATION_BANK_ACCOUNT_ID
, DESTINATION_PARTY_SITE_ID DESTINATION_PARTY_SITE_ID
, REPETITIVE_PAYMENT_CODE REPETITIVE_PAYMENT_CODE
, TRXN_STATUS_CODE TRXN_STATUS_CODE
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, AUTHORIZE_FLAG AUTHORIZE_FLAG
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1
, REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2
, REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3
, CREATED_FROM_DIR CREATED_FROM_DIR
, CREATE_FROM_STMTLINE_ID CREATE_FROM_STMTLINE_ID
, BANK_TRXN_NUMBER BANK_TRXN_NUMBER
, PAYMENT_REQUEST_NUMBER PAYMENT_REQUEST_NUMBER
, PAPER_DOCUMENT_NUMBER PAPER_DOCUMENT_NUMBER
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, DOC_CATEGORY_CODE DOC_CATEGORY_CODE
, PAYMENT_OFFSET_CCID PAYMENT_OFFSET_CCID
, RECEIPT_OFFSET_CCID RECEIPT_OFFSET_CCID
, CASHPOOL_ID CASHPOOL_ID
, EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "CE"."CE_PAYMENT_TRANSACTIONS"