[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Stores all refund transactions, which have been created due to excess unapplied credits. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT RE.FEE_TYPE
, RE.FEE_CAL_TYPE
, RE.REVERSAL_IND
, RE.VOUCHER_DATE
, RE.GL_DATE
, RE.REFUND_AMOUNT
, '_LA:RE.TRANSFER_STATUS:IGS_LOOKUP_VALUES:REFUND_TRANSFER_STATUS:MEANING'
, RE.REASON
, RE.REVERSAL_GL_DATE
, RE.DR_ACCOUNT_CD
, RE.CR_ACCOUNT_CD
, PA1.PARTY_NUMBER
, PA1.PARTY_NAME
, PA2.PARTY_NUMBER
, PA2.PARTY_NAME
, FE.DESCRIPTION
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, CI.ALTERNATE_CODE
, IV.INVOICE_NUMBER
, RE.DR_GL_CCID
, RE.CR_GL_CCID
, RE.REFUND_ID
, RE.PERSON_ID
, RE.PAY_PERSON_ID
, RE.FEE_CI_SEQUENCE_NUMBER
, RE.INVOICE_ID
, RE.SOURCE_REFUND_ID
, RE.CREATION_DATE
, RE.CREATED_BY
, RE.LAST_UPDATE_DATE
, RE.LAST_UPDATED_BY
FROM IGS_FI_REFUNDS RE
, HZ_PARTIES PA1
, HZ_PARTIES PA2
, IGS_FI_FEE_TYPE_ALL FE
, IGS_CA_INST_ALL CI
, IGS_FI_INV_INT_ALL IV
WHERE RE.PERSON_ID = PA1.PARTY_ID
AND RE.PAY_PERSON_ID = PA2.PARTY_ID
AND RE.INVOICE_ID = IV.INVOICE_ID
AND RE.FEE_TYPE = FE.FEE_TYPE
AND RE.FEE_CAL_TYPE = CI.CAL_TYPE
AND RE.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY