PSC_BNP_PAYMENT_V

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
TRANSACTION_ID LINE_KEY AGENCY_ID TRANSACTION_DATE TRANSACTION_AMOUNT CURRENCY_CODE PAYMENT_METHOD_CODE PAYMENT_REFERENCE_ID EVENT_ID TRUST_ACCOUNT_NUMBER DEPOSIT_PAYMENT DRAWER_ID SESSION_ID CASHIER_ID ACCOUNTING_DATE ACCTG_EVENT_STATUS

Query

SQL_Statement

SELECT HDR.PAYMENT_HISTORY_KEY TRANSACTION_ID, CSH.RECEIPT_LINE_NUMBER LINE_KEY, CSH.AGENCY_ID, HDR.PAYMENT_DATE TRANSACTION_DATE, CSH.LINE_AMOUNT TRANSACTION_AMOUNT, CSH.CURRENCY_CODE, CSH.PAYMENT_METHOD_CODE, CSH.PAYMENT_REFERENCE_ID, CSH.EVENT_ID, HDR.TRUST_ACCOUNT_NUMBER, CASE WHEN HDR.TRUST_ACCOUNT_NUMBER IS NOT NULL THEN 'Y' ELSE 'N' END DEPOSIT_PAYMENT, CSH.DRAWER_ID, CSH.SESSION_ID, CSH.CASHIER_ID, CSH.ACCOUNTING_DATE, CSH.ACCTG_EVENT_STATUS FROM PSC_BNP_CSH_DRW_PAY_HIST CSH INNER JOIN PSC_BNP_PAYMENT_HIST_HDR HDR ON CSH.PAYMENT_REFERENCE_ID = HDR.PAYMENT_REFERENCE_ID WHERE CSH.ACCTG_EVENT_STATUS IN ('ORA_NONE', 'ORA_ERROR') AND HDR.TRUST_ACCOUNT_NUMBER IS NULL