[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view is used to fetch all the charges from the view igs_fi_inv_int. A link with igs_fi_fee_type is also made to fetch the fee class defined for the fee type.This view has been primarily created for Financial Aid Disbursement to access |
| Implementation/DBA Data: | Not implemented in this database |
SELECT A.ROWID
, A.INVOICE_ID
, A.PERSON_ID
, A.SPONSOR_CD
, A.FEE_TYPE
, A.FEE_CAT
, A.FEE_CAL_TYPE
, A.FEE_CI_SEQUENCE_NUMBER
, A.COURSE_CD
, A.ATTENDANCE_MODE
, A.ATTENDANCE_TYPE
, A.INVOICE_AMOUNT_DUE
, A.INVOICE_CREATION_DATE
, A.INVOICE_DESC
, A.TRANSACTION_TYPE
, A.CURRENCY_CD
, A.EXCHANGE_RATE
, A.ACCOUNT_ID
, A.TERM_ID
, A.STATUS
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ORG_ID
, A.MERCHANT_ID
, A.CREDIT_CARD_CODE
, A.CREDIT_CARD_HOLDER_NAME
, A.CREDIT_CARD_EXPIRATION_DATE
, A.CREDIT_CARD_APPROVAL_CODE
, A.CREDIT_CARD_APPROVAL_DATE
, A.PAYMENT_SERVER_ORDER_NUMBER
, A.PAYMENT_SERVER_TXN_DATE
, A.PAYMENT_SERVER_TXN_STATUS
, A.PAYMENT_SERVER_ERROR_CODE
, A.PAYMENT_SERVER_ERROR_MSG
, A.BEP_ERROR_CODE
, A.BEP_ERROR_MSG
, A.ERROR_LOCATION
, A.AUTHORIZED_AMOUNT
, A.RECEIPT_METHOD_ID
, A.RECEIPT_METHOD_NAME
, A.CUSTOMER_BANK_ACCOUNT_ID
, A.CUSTOMER_BANK_ACCOUNT_NAME
, A.PROCESSED_IN_SSA
, A.PAYMENT_METHOD
, A.PAYMENT_STATUS
, A.SUBACCOUNT_ID
, A.INVOICE_AMOUNT
, A.BILL_ID
, A.BILL_NUMBER
, A.BILL_DATE
, A.WAIVER_FLAG
, A.WAIVER_REASON
, A.EFFECTIVE_DATE
, A.INVOICE_NUMBER
, A.BILL_PAYMENT_DUE_DATE
, A.SOURCE_TRANSACTION_ID
, A.OPTIONAL_FEE_FLAG
, B.FEE_CLASS
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
FROM IGS_FI_INV_INT A
, IGS_FI_FEE_TYPE B
WHERE A.FEE_TYPE = B.FEE_TYPE