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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_PARTY_CHARGES

Object Details

Object Name:	IGSFV_PARTY_CHARGES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_PARTY_CHARGES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Contains details of charges for a person

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_IDENTIFIER	NUMBER	(15)	Yes	Party Identifier
INVOICE_IDENTIFIER	NUMBER	(15)	Yes	Invoice identifier
INVOICE_LINE_IDENTIFIER	NUMBER	(15)	Yes	Invoice line Identifier
INVOICE_NUMBER	VARCHAR2	(60)		Invoice number
INVOICE_LINE_NUMBER	NUMBER	(15)	Yes	Invoice line number
_LA:TRANSACTION_TYPE	CHAR	(63)		Transaction type
INVOICE_CREATION_DATE	DATE		Yes	Invoice creation date
INVOICE_DESCRIPTION	VARCHAR2	(240)		Invoice description
INVOICE_LINE_DESCRIPTION	VARCHAR2	(240)		Invoice line description
INVOICE_AMOUNT	NUMBER			Invoice amount
INVOICE_LINE_AMOUNT	NUMBER			Invoice line amount
INVOICE_AMOUNT_DUE	NUMBER		Yes	Invoice amount due
CURRENCY_CODE	VARCHAR2	(15)	Yes	This will always be local currency
EXCHANGE_RATE	NUMBER			Should be 1
EFFECTIVE_DATE	DATE			Effective date
FEE_CALENDAR_TYPE	VARCHAR2	(10)	Yes	The Calendar Type for the Fee Period
FEE_CAL_INST_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The Calendar Instance for the Fee Period
DEBIT_ACCOUNT_CODE	VARCHAR2	(40)		Debit account string
CREDIT_ACCOUNT_CODE	VARCHAR2	(40)		Credit account string
DEBIT_ACCOUNT_GL_CCID	NUMBER	(15)		Debit Accounting Flex field
CREDIT_ACCOUNT_GL_CCID	NUMBER	(15)		Credit Accounting Flex field
FEE_TYPE	VARCHAR2	(10)	Yes	Fee type
FEE_CATEGORY	VARCHAR2	(10)		Fee category
BILL_NUMBER	VARCHAR2	(50)		Bill number
BILL_DATE	DATE			Bill date
INVOICE_LINE_GL_DATE	DATE			The General Ledger Date of the charge line record
GL_POSTED_DATE	DATE			The Date on which the invoice line record is posted to the interface
REVERSAL_GL_DATE	DATE			The date on which this invoice is reversed
ERROR_STRING	VARCHAR2	(1000)		Error string that is generated by Build accounts process when it fails to generate account code.
ERROR_ACCOUNT	VARCHAR2	(1)		Error Account Flag. Default value is 'N'.
WAIVER_FLAG	VARCHAR2	(1)		Waiver flag, if this Transaction is waived
WAIVER_REASON	VARCHAR2	(240)		Waiver reason, if this Transaction is waived
BILL_PAYMENT_DUE_DATE	DATE			This field would be updated by the Bill Process
OPTIONAL_FEE_FLAG	VARCHAR2	(1)		Decline optional fee status
_LA:CHARGE_METHOD	CHAR	(58)		Charge method type, if this is an assessment item
CHARGE_ELEMENTS	NUMBER	(7)		Number of charge elements, if this is an assessment item
EFTSU	NUMBER	(7)		Unit Effective Full Time Student Units
CREDIT_POINTS	NUMBER	(6)		Unit Credit Points
COURSE_CODE	VARCHAR2	(6)		Program code
LOCATION_CODE	VARCHAR2	(10)		The location to which the transaction belongs
ATTENDANCE_MODE	VARCHAR2	(2)		Attendance mode
ATTENDANCE_TYPE	VARCHAR2	(2)		Attendance Type
TAX_YEAR_CODE	VARCHAR2	(30)		Indicates the calendar year, in which the charge is reported to the Internal Revenue Services
WAIVER_NAME	VARCHAR2	(30)		Waiver Program Name attached to a Fee Calendar Instance for which waiver adjustment charge was created.
UNIT_ATTEMPT_STATUS	VARCHAR2	(10)		Unit Attempt Status
ORG_UNIT_CODE	VARCHAR2	(30)		Org unit code
PARTY_NUMBER	VARCHAR2	(30)	Yes	Party number
PARTY_NAME	VARCHAR2	(360)	Yes	Party name
DEBIT_ACC_DESCRIPTION	VARCHAR2	(60)		Description of Debit Account
CREDIT_ACC_DESCRIPTION	VARCHAR2	(60)		Description of Credit Account
_KF:ACCOUNT_NUMBER:DEBIT	CHAR	(18)		Debit Accounting Flex field
_KF:ACCOUNT_NUMBER:CREDIT	CHAR	(18)		Credit Accounting Flex field
BILL_CUT_OFF_DATE	DATE			The Cut Off Date until which the transactions were included in the Bill.
POSTING_BATCH_NAME	VARCHAR2	(30)		The Posting Batch Name - Can be used to locate a particular posting batch for subsequent processing
WAIVER_DESCRIPTION	VARCHAR2	(240)		User defined description for waiver program
UNIT_PROGRAM_TYPE_LEVEL_CODE	VARCHAR2	(10)		Unit Program Type Level Code
UNIT_PROGRAM_TYPE_LEVEL_DESC	VARCHAR2	(80)		Unit Program Type Level Description
UNIT_LEVEL_DESC	VARCHAR2	(60)		Unit Level Description
TAX_YEAR_NAME	VARCHAR2	(30)		Indicates the 1098-T Reporting Tax Year, in which the charge is reported to the Internal Revenue Services
TAX_YEAR_EFFECTIVE_START_DATE	DATE			The 1098-T tax year effective start date.
TAX_YEAR_EFFECTIVE_END_DATE	DATE			The 1098-T tax year effective end date.
_DF	CHAR	(39)		Descriptive Flexfield
BILL_IDENTIFIER	NUMBER			Bill Identifier if this transaction is placed in any Bill
UNIT_OFFER_OPTION_IDENTIFIER	NUMBER	(7)		The unit offering option to which the student is enrolled
POSTING_IDENTIFIER	NUMBER	(15)		Posting Identifier
POSTING_CONTROL_IDENTIFIER	NUMBER	(15)		The Posting Batch Identifier
UNIT_TYPE_IDENTIFIER	NUMBER			Unit Program Type Level Identifier
UNIT_LEVEL_IDENTIFIER	VARCHAR2	(10)		Unit Level Identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARTY_IDENTIFIER
,      INVOICE_IDENTIFIER
,      INVOICE_LINE_IDENTIFIER
,      INVOICE_NUMBER
,      INVOICE_LINE_NUMBER
,      _LA:TRANSACTION_TYPE
,      INVOICE_CREATION_DATE
,      INVOICE_DESCRIPTION
,      INVOICE_LINE_DESCRIPTION
,      INVOICE_AMOUNT
,      INVOICE_LINE_AMOUNT
,      INVOICE_AMOUNT_DUE
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EFFECTIVE_DATE
,      FEE_CALENDAR_TYPE
,      FEE_CAL_INST_SEQUENCE_NUMBER
,      DEBIT_ACCOUNT_CODE
,      CREDIT_ACCOUNT_CODE
,      DEBIT_ACCOUNT_GL_CCID
,      CREDIT_ACCOUNT_GL_CCID
,      FEE_TYPE
,      FEE_CATEGORY
,      BILL_NUMBER
,      BILL_DATE
,      INVOICE_LINE_GL_DATE
,      GL_POSTED_DATE
,      REVERSAL_GL_DATE
,      ERROR_STRING
,      ERROR_ACCOUNT
,      WAIVER_FLAG
,      WAIVER_REASON
,      BILL_PAYMENT_DUE_DATE
,      OPTIONAL_FEE_FLAG
,      _LA:CHARGE_METHOD
,      CHARGE_ELEMENTS
,      EFTSU
,      CREDIT_POINTS
,      COURSE_CODE
,      LOCATION_CODE
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      TAX_YEAR_CODE
,      WAIVER_NAME
,      UNIT_ATTEMPT_STATUS
,      ORG_UNIT_CODE
,      PARTY_NUMBER
,      PARTY_NAME
,      DEBIT_ACC_DESCRIPTION
,      CREDIT_ACC_DESCRIPTION
,      _KF:ACCOUNT_NUMBER:DEBIT
,      _KF:ACCOUNT_NUMBER:CREDIT
,      BILL_CUT_OFF_DATE
,      POSTING_BATCH_NAME
,      WAIVER_DESCRIPTION
,      UNIT_PROGRAM_TYPE_LEVEL_CODE
,      UNIT_PROGRAM_TYPE_LEVEL_DESC
,      UNIT_LEVEL_DESC
,      TAX_YEAR_NAME
,      TAX_YEAR_EFFECTIVE_START_DATE
,      TAX_YEAR_EFFECTIVE_END_DATE
,      _DF
,      BILL_IDENTIFIER
,      UNIT_OFFER_OPTION_IDENTIFIER
,      POSTING_IDENTIFIER
,      POSTING_CONTROL_IDENTIFIER
,      UNIT_TYPE_IDENTIFIER
,      UNIT_LEVEL_IDENTIFIER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PARTY_CHARGES;

Dependencies

[top of page]

APPS.IGSFV_PARTY_CHARGES references the following:

APPS: GL_CODE_COMBINATIONS; HZ_PARTIES; IGS_FI_1098T_SETUP; IGS_FI_ACC_ALL; IGS_FI_BILL_ALL; IGS_FI_INVLN_INT_ALL; IGS_FI_INV_INT_ALL; IGS_FI_POSTING_INT_ALL; IGS_FI_WAIVER_PGMS; IGS_PS_UNIT_LEVEL_ALL; IGS_PS_UNIT_TYPE_LVL

APPS.IGSFV_PARTY_CHARGES is not referenced by any database object