PSC_BNP_DEPOSIT_ACCOUNT_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 ACCOUNT_PURPOSE ACCOUNT_TYPE AS FROM_CASH_DRAWER TRUST_ACCOUNT_NUMBER ACCOUNTING_DATE ACCTG_EVENT_STATUS

Query

SQL_Statement

SELECT LIN.PAYMENT_HISTORY_KEY TRANSACTION_ID, LIN.ITEM_REC_KEY LINE_KEY, LIN.AGENCY_ID, HDR.PAYMENT_DATE TRANSACTION_DATE, LIN.ITEM_UNIT_PRICE TRANSACTION_AMOUNT, LIN.ITEM_CURRENCY CURRENCY_CODE, HDR.PAYMENT_METHOD_CODE, LIN.PAYMENT_REFERENCE_ID, LIN.EVENT_ID, HDR.ACCOUNT_PURPOSE, HDR.ACCOUNT_TYPE, CASE WHEN HDR.PAYMENT_METHOD_CODE IN ('CASH', 'PRCK', 'CSCK') THEN 'Y' ELSE 'N' END AS FROM_CASH_DRAWER, HDR.TRUST_ACCOUNT_NUMBER, LIN.ACCOUNTING_DATE, LIN.ACCTG_EVENT_STATUS FROM PSC_BNP_PAYMENT_HIST_LIN LIN, PSC_BNP_PAYMENT_HIST_HDR HDR WHERE LIN.PAYMENT_HISTORY_KEY = HDR.PAYMENT_HISTORY_KEY AND LIN.ACCTG_EVENT_STATUS IN ('ORA_NONE', 'ORA_ERROR') AND HDR.PAYMENT_METHOD_CODE <> 'TRSA' AND HDR.TRUST_ACCOUNT_NUMBER IS NOT NULL