CMR_RCV_DISTRIBUTIONS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

CMR_SUB_LEDGER_ID LINE_NUMBER EVENT_ID ACCOUNTING_LINE_TYPE ACCOUNTING_EVENT_ID ACCOUNTEDQTY ACCOUNTEDDEBITAMT ACCOUNTEDCREDITAMT ENTEREDDEBITAMT ENTEREDCREDITAMT ENTERED_CURRENCY_CODE LEDGER_CURRENCY_CODE CODE_COMBINATION_ID PJC_TXN_STATUS_CODE EVENT_COST_ID BALANCE_TYPE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Query

SQL_Statement

SELECT CMR_SUB_LEDGER_ID, LINE_NUMBER, EVENT_ID, ACCOUNTING_LINE_TYPE, ACCOUNTING_EVENT_ID, DECODE(SIGN(ledger_amount),1,accounted_qty, 0, 0, -1*accounted_qty) AccountedQty, DECODE(SIGN(ledger_amount),1, ledger_amount, 0, DECODE(MOD(line_number,2),0,0,NULL), NULL) AccountedDebitAmt, DECODE(SIGN(ledger_amount),-1, abs(ledger_amount), 0, DECODE(MOD(line_number,2),1,0,NULL), NULL) AccountedCreditAmt, DECODE(SIGN(entered_currency_amount),1, entered_currency_amount, 0, DECODE(MOD(line_number,2),0,0,NULL),NULL) EnteredDebitAmt, DECODE(SIGN(entered_currency_amount),-1, abs(entered_currency_amount), 0,DECODE(MOD(line_number,2),1,0,NULL),NULL) EnteredCreditAmt, ENTERED_CURRENCY_CODE, LEDGER_CURRENCY_CODE, CODE_COMBINATION_ID, PJC_TXN_STATUS_CODE, EVENT_COST_ID, BALANCE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE FROM CMR_RCV_DISTRIBUTIONS