Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Contains details of charges for a person |
Implementation/DBA Data: | Not implemented in this database |
SELECT INV.PERSON_ID
, INV.INVOICE_ID
, INVLN.INVOICE_LINES_ID
, INV.INVOICE_NUMBER
, INVLN.LINE_NUMBER
, '_LA:TRANSACTION_TYPE:IGS_LOOKUP_VALUES:TRANSACTION_TYPE:MEANING'
, INV.INVOICE_CREATION_DATE
, INV.INVOICE_DESC
, INVLN.DESCRIPTION
, INV.INVOICE_AMOUNT
, INVLN.AMOUNT
, INV.INVOICE_AMOUNT_DUE
, INV.CURRENCY_CD
, INV.EXCHANGE_RATE
, INV.EFFECTIVE_DATE
, INV.FEE_CAL_TYPE
, INV.FEE_CI_SEQUENCE_NUMBER
, INVLN.REC_ACCOUNT_CD
, INVLN.REV_ACCOUNT_CD
, INVLN.REC_GL_CCID
, INVLN.REV_GL_CCID
, INV.FEE_TYPE
, INV.FEE_CAT
, INV.BILL_NUMBER
, INV.BILL_DATE
, INVLN.GL_DATE
, INVLN.GL_POSTED_DATE
, INV.REVERSAL_GL_DATE
, INVLN.ERROR_STRING
, INVLN.ERROR_ACCOUNT
, INV.WAIVER_FLAG
, INV.WAIVER_REASON
, INV.BILL_PAYMENT_DUE_DATE
, INV.OPTIONAL_FEE_FLAG
, '_LA:S_CHG_METHOD_TYPE:IGS_LOOKUP_VALUES:CHG_METHOD:MEANING'
, INVLN.CHG_ELEMENTS
, INVLN.EFTSU
, INVLN.CREDIT_POINTS
, INV.COURSE_CD
, INVLN.LOCATION_CD
, INV.ATTENDANCE_MODE
, INV.ATTENDANCE_TYPE
, INV.TAX_YEAR_CODE
, INV.WAIVER_NAME
, INVLN.UNIT_ATTEMPT_STATUS
, INVLN.ORG_UNIT_CD
, INV.BILL_ID
, INVLN.UOO_ID
, INVLN.POSTING_ID
, INVLN.POSTING_CONTROL_ID
, INVLN.UNIT_TYPE_ID
, INVLN.UNIT_LEVEL
, INVLN.CREATED_BY
, INVLN.CREATION_DATE
, INVLN.LAST_UPDATED_BY
, INVLN.LAST_UPDATE_DATE
FROM IGS_FI_INV_INT_ALL INV
, IGS_FI_INVLN_INT_ALL INVLN
WHERE INV.INVOICE_ID = INVLN.INVOICE_ID WITH READ ONLY