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_OTC_CHARGES_V

Product:	IGS - Student System (Obsolete)
Description:	The view contains information on the charges(of type external) that are created at the time of receipt creation.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT INV.ROWID
, OINV.OTC_CHARGE_ID
, OINV.CREDIT_ID
, INV.INVOICE_ID
, INVLN.GL_DATE
, INV.PERSON_ID
, INV.SPONSOR_CD
, INV.FEE_TYPE
, INV.FEE_CAT
, INV.FEE_CAL_TYPE
, INV.FEE_CI_SEQUENCE_NUMBER
, INV.COURSE_CD
, INV.ATTENDANCE_MODE
, INV.ATTENDANCE_TYPE
, INV.INVOICE_AMOUNT_DUE
, INV.INVOICE_CREATION_DATE
, INV.INVOICE_DESC
, INV.TRANSACTION_TYPE
, INV.CURRENCY_CD
, INV.ACCOUNT_ID
, INV.TERM_ID
, INV.STATUS
, INV.ATTRIBUTE_CATEGORY
, INV.ATTRIBUTE1
, INV.ATTRIBUTE2
, INV.ATTRIBUTE3
, INV.ATTRIBUTE4
, INV.ATTRIBUTE5
, INV.ATTRIBUTE6
, INV.ATTRIBUTE7
, INV.ATTRIBUTE8
, INV.ATTRIBUTE9
, INV.ATTRIBUTE10
, INV.ORG_ID
, INV.MERCHANT_ID
, INV.CREDIT_CARD_CODE
, INV.CREDIT_CARD_HOLDER_NAME
, INV.CREDIT_CARD_EXPIRATION_DATE
, INV.CREDIT_CARD_APPROVAL_CODE
, INV.CREDIT_CARD_APPROVAL_DATE
, INV.PAYMENT_SERVER_ORDER_NUMBER
, INV.PAYMENT_SERVER_TXN_DATE
, INV.PAYMENT_SERVER_TXN_STATUS
, INV.PAYMENT_SERVER_ERROR_CODE
, INV.PAYMENT_SERVER_ERROR_MSG
, INV.BEP_ERROR_CODE
, INV.BEP_ERROR_MSG
, INV.ERROR_LOCATION
, INV.AUTHORIZED_AMOUNT
, INV.RECEIPT_METHOD_ID
, INV.RECEIPT_METHOD_NAME
, INV.CUSTOMER_BANK_ACCOUNT_ID
, INV.CUSTOMER_BANK_ACCOUNT_NAME
, INV.PROCESSED_IN_SSA
, INV.PAYMENT_METHOD
, INV.PAYMENT_STATUS
, INV.SUBACCOUNT_ID
, INV.INVOICE_AMOUNT
, INV.BILL_ID
, INV.BILL_NUMBER
, INV.BILL_DATE
, INV.WAIVER_FLAG
, NULL
, INV.WAIVER_REASON
, INV.EFFECTIVE_DATE
, INV.INVOICE_NUMBER
, INV.BILL_PAYMENT_DUE_DATE
, INV.SOURCE_TRANSACTION_ID
, INVLN.REC_ACCOUNT_CD
, AC1.DESCRIPTION
, INVLN.REV_ACCOUNT_CD
, AC2.DESCRIPTION
, INVLN.REC_GL_CCID
, INVLN.REV_GL_CCID
, INVLN.POSTING_ID
, INVLN.POSTING_CONTROL_ID
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY
, INV.CREATION_DATE
, INV.CREATED_BY
, INV.LAST_UPDATE_LOGIN
, INV.REQUEST_ID
, INV.PROGRAM_APPLICATION_ID
, INV.PROGRAM_ID
, INV.PROGRAM_UPDATE_DATE
FROM IGS_FI_INV_INT INV
, IGS_FI_OTC_CHARGES OINV
, IGS_FI_INVLN_INT INVLN
, IGS_FI_ACC AC1
, IGS_FI_ACC AC2
WHERE INV.INVOICE_ID = OINV.INVOICE_ID
AND INV.INVOICE_ID = INVLN.INVOICE_ID
AND INVLN.REC_ACCOUNT_CD = AC1.ACCOUNT_CD (+)
AND INVLN.REV_ACCOUNT_CD = AC2.ACCOUNT_CD (+)

Columns

Name
ROW_ID
OTC_CHARGE_ID
CREDIT_ID
INVOICE_ID
GL_DATE
PERSON_ID
SPONSOR_CD
FEE_TYPE
FEE_CAT
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
COURSE_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
INVOICE_AMOUNT_DUE
INVOICE_CREATION_DATE
INVOICE_DESC
TRANSACTION_TYPE
CURRENCY_CD
ACCOUNT_ID
TERM_ID
STATUS
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ORG_ID
MERCHANT_ID
CREDIT_CARD_CODE
CREDIT_CARD_HOLDER_NAME
CREDIT_CARD_EXPIRATION_DATE
CREDIT_CARD_APPROVAL_CODE
CREDIT_CARD_APPROVAL_DATE
PAYMENT_SERVER_ORDER_NUMBER
PAYMENT_SERVER_TXN_DATE
PAYMENT_SERVER_TXN_STATUS
PAYMENT_SERVER_ERROR_CODE
PAYMENT_SERVER_ERROR_MSG
BEP_ERROR_CODE
BEP_ERROR_MSG
ERROR_LOCATION
AUTHORIZED_AMOUNT
RECEIPT_METHOD_ID
RECEIPT_METHOD_NAME
CUSTOMER_BANK_ACCOUNT_ID
CUSTOMER_BANK_ACCOUNT_NAME
PROCESSED_IN_SSA
PAYMENT_METHOD
PAYMENT_STATUS
SUBACCOUNT_ID
INVOICE_AMOUNT
BILL_ID
BILL_NUMBER
BILL_DATE
WAIVER_FLAG
WAIVER_REASON
WAIVER_REASON_CODE
EFFECTIVE_DATE
INVOICE_NUMBER
BILL_PAYMENT_DUE_DATE
SOURCE_TRANSACTION_ID
REC_ACCOUNT_CD
REC_ACCOUNT_DESC
REV_ACCOUNT_CD
REV_ACCOUNT_DESC
REC_GL_CCID
REV_GL_CCID
POSTING_ID
POSTING_CONTROL_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE