[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Stores all Student Deposits in Student Finance |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CR.CREDIT_NUMBER
, '_LA:CR.STATUS:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_STATUS:MEANING'
, '_LA:CR.CREDIT_INSTRUMENT:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_INSTRUMENT:MEANING'
, CR.DESCRIPTION
, CR.AMOUNT
, CR.UNAPPLIED_AMOUNT
, CR.CURRENCY_CD
, CR.EXCHANGE_RATE
, CR.TRANSACTION_DATE
, CR.EFFECTIVE_DATE
, CR.CHECK_NUMBER
, '_LA:CR.CREDIT_CARD_CODE:IGS_LOOKUP_VALUES:IGS_CREDIT_CARDS:MEANING'
, CR.CREDIT_CARD_HOLDER_NAME
, CR.CREDIT_CARD_NUMBER
, CR.CREDIT_CARD_EXPIRATION_DATE
, CR.CREDIT_CARD_APPROVAL_CODE
, '_LA:CR.CREDIT_CARD_STATUS_CODE:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_CARD_STATUS:MEANING'
, CR.CREDIT_CARD_PAYEE_CD
, CR.CREDIT_CARD_TANGIBLE_CD
, CR.AWD_YR_CAL_TYPE
, CR.AWD_YR_CI_SEQUENCE_NUMBER
, CR.FEE_CAL_TYPE
, CR.FEE_CI_SEQUENCE_NUMBER
, CR.GL_DATE
, CR.SOURCE_TRANSACTION_TYPE
, CR.SOURCE_TRANSACTION_REF
, CR.REVERSAL_DATE
, '_LA:CR.REVERSAL_REASON_CODE:IGS_LOOKUP_VALUES:IGS_FI_REVERSAL_REASON:MEANING'
, CR.REVERSAL_COMMENTS
, CR.RECEIPT_LOCKBOX_NUMBER
, CR.BATCH_NAME
, CR.DEPOSIT_DATE
, '_LA:CA.STATUS:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_STATUS:MEANING'
, CA.TRANSACTION_DATE
, CA.AMOUNT
, CA.DR_ACCOUNT_CD
, CA.CR_ACCOUNT_CD
, CA.BILL_NUMBER
, CA.BILL_DATE
, CA.GL_DATE
, CA.GL_POSTED_DATE
, PA.PARTY_NUMBER
, PA.PARTY_NAME
, CR.CREDIT_ID
, CA.CREDIT_ACTIVITY_ID
, CR.PARTY_ID
, CR.CREDIT_TYPE_ID
, CR.MERCHANT_ID
, CR.LOCKBOX_INTERFACE_ID
, CA.DR_GL_CCID
, CA.CR_GL_CCID
, CA.BILL_ID
, CA.POSTING_ID
, CA.POSTING_CONTROL_ID
, CA.CREATION_DATE
, CA.CREATED_BY
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
FROM IGS_FI_CREDITS_ALL CR
, IGS_FI_CR_ACTIVITIES CA
, HZ_PARTIES PA
, IGS_FI_CR_TYPES_ALL CP
WHERE CR.CREDIT_ID = CA.CREDIT_ID
AND CR.PARTY_ID = PA.PARTY_ID
AND CR.CREDIT_TYPE_ID = CP.CREDIT_TYPE_ID
AND CP.CREDIT_CLASS IN ('OTHDEPOSIT'
, 'ENRDEPOSIT') WITH READ ONLY