eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_FI_CR_ACTIVITIES_V

Product:	IGS - Student System (Obsolete)
Description:	Retrieves the records from the Credit Activities table.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CRA.ROWID
, CRA.CREDIT_ACTIVITY_ID
, CRA.CREDIT_ID
, CRA.STATUS
, LKV.MEANING
, CRA.TRANSACTION_DATE
, CRA.AMOUNT
, CRA.DR_ACCOUNT_CD
, ACC1.DESCRIPTION
, CRA.CR_ACCOUNT_CD
, ACC2.DESCRIPTION
, CRA.DR_GL_CCID
, CRA.CR_GL_CCID
, CRA.BILL_ID
, CRA.BILL_NUMBER
, CRA.BILL_DATE
, CRA.POSTING_ID
, CRA.CREATED_BY
, CRA.CREATION_DATE
, CRA.LAST_UPDATED_BY
, CRA.LAST_UPDATE_DATE
, CRA.LAST_UPDATE_LOGIN
, CRA.GL_DATE
, CRA.GL_POSTED_DATE
, CRA.POSTING_CONTROL_ID
FROM IGS_FI_CR_ACTIVITIES CRA
, IGS_FI_ACC ACC1
, IGS_FI_ACC ACC2
, IGS_LOOKUP_VALUES LKV
WHERE CRA.DR_ACCOUNT_CD = ACC1.ACCOUNT_CD (+)
AND CRA.CR_ACCOUNT_CD = ACC2.ACCOUNT_CD (+)
AND CRA.STATUS = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'IGS_FI_CREDIT_STATUS'

Columns

Name
ROW_ID
CREDIT_ACTIVITY_ID
CREDIT_ID
STATUS
STATUS_MEANING
TRANSACTION_DATE
AMOUNT
DR_ACCOUNT_CD
DR_ACCOUNT_DESC
CR_ACCOUNT_CD
CR_ACCOUNT_DESC
DR_GL_CCID
CR_GL_CCID
BILL_ID
BILL_NUMBER
BILL_DATE
POSTING_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
GL_DATE
GL_POSTED_DATE
POSTING_CONTROL_ID