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_INV_INT_V

Product:	IGS - Student System (Obsolete)
Description:	This view is created by joining view IGS_FI_INV_INT and IGS_LOOKUPS_VIEW to resolve meaning of lookup codes.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT INV.ROWID
, INV.INVOICE_ID
, INV.PERSON_ID
, INV.SPONSOR_CD
, INV.FEE_TYPE
, INV.FEE_CAT
, INV.FEE_CAL_TYPE
, 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.EXCHANGE_RATE
, 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
, LKV.MEANING
, INV.WAIVER_REASON
, INV.EFFECTIVE_DATE
, INV.INVOICE_NUMBER
, INV.BILL_PAYMENT_DUE_DATE
, INV.SOURCE_TRANSACTION_ID
, INV.OPTIONAL_FEE_FLAG
, 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
, INV.REVERSAL_GL_DATE
, INV.TAX_YEAR_CODE
, INV.WAIVER_NAME
FROM IGS_FI_INV_INT INV
, IGS_LOOKUP_VALUES LKV
WHERE INV.WAIVER_REASON = LKV.LOOKUP_CODE (+)
AND LKV.LOOKUP_TYPE (+) = 'IGS_FI_WAIVER_REASON'

Columns

Name
ROW_ID
INVOICE_ID
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
EXCHANGE_RATE
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
OPTIONAL_FEE_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REVERSAL_GL_DATE
TAX_YEAR_CODE
WAIVER_NAME