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_PERSON_DEPOSITS

Object Details

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

View Type

A Business Intelligence System view

Stores all Student Deposits in Student Finance

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CREDIT_NUMBER	VARCHAR2	(60)	Yes	User Defined Deposit Transaction Identifier
_LA:CREDIT_STATUS	CHAR	(60)		Status of the deposit transaction - CLEARED, REVERSED, TRANSFERRED or FORFEITED. Would be controlled by a lookup type.
_LA:CREDIT_INSTRUMENT	CHAR	(75)		User defined lookup - CASH, CREDIT CARD, CHECK.
CREDIT_DESCRIPTION	VARCHAR2	(240)		Description of the deposit transaction
CREDIT_AMOUNT	NUMBER		Yes	Deposit Amount
UNAPPLIED_AMOUNT	NUMBER			The portion of the deposit amount that is available.
CURRENCY_CODE	VARCHAR2	(15)	Yes	This will always be local currency
EXCHANGE_RATE	NUMBER			Exchange Rate of the currency
TRANSACTION_DATE	DATE		Yes	Transaction Date
EFFECTIVE_DATE	DATE		Yes	Effective Date for this Deposit Transaction
CHECK_NUMBER	VARCHAR2	(30)		Check Number of the Deposit Transaction. This is applicable only if the credit instrument of the deposit is 'Check'.
_LA:CREDIT_CARD_CODE	CHAR	(66)		Credit Card (CC) Type.
CREDIT_CARD_HOLDER_NAME	VARCHAR2	(80)		Credit Card (CC) Holder Name.
CREDIT_CARD_NUMBER	VARCHAR2	(50)		Credit Card (CC) Number.
CREDIT_CARD_EXPIRATION_DATE	DATE			Credit Card (CC) Expiry Date.
CREDIT_CARD_APPROVAL_CODE	VARCHAR2	(80)		Credit Card (CC) Transaction approval code.
_LA:CREDIT_CARD_STATUS_CODE	CHAR	(82)		Credit Card (CC) Transaction Status.
CREDIT_CARD_PAYEE_CODE	VARCHAR2	(80)		Credit Card (CC) Transaction Payee.
CREDIT_CARD_TANGIBLE_CODE	VARCHAR2	(80)		Credit Card (CC) Transaction Tangible Code.
AWARD_YEAR_CALENDAR_TYPE	VARCHAR2	(10)		The Calendar Type for the Award Year
AWARD_YEAR_SEQUENCE_NUMBER	NUMBER	(6)		The Calendar Instance for the Award Year
FEE_CALENDAR_TYPE	VARCHAR2	(10)		The Calendar Type for the Fee Period
FEE_CAL_INST_SEQUENCE_NUMBER	NUMBER	(6)		The Calendar Instance for the Fee Period
CREDIT_GL_DATE	DATE			The General Ledger Date of the Deposit Record.
SOURCE_TRANSACTION_TYPE	VARCHAR2	(30)		Source Transaction Type of the deposit.
SOURCE_TRANSACTION_REFERENCE	VARCHAR2	(60)		Source Transaction Reference Number.
REVERSAL_DATE	DATE			The date this transaction is reversed.
_LA:REVERSAL_REASON_CODE	CHAR	(76)		Reason Code for reversal of the deposit transaction
REVERSAL_COMMENTS	VARCHAR2	(240)		Comments for reversal of the deposit transaction
RECEIPT_LOCKBOX_NUMBER	VARCHAR2	(30)		Lockbox Name.
BATCH_NAME	VARCHAR2	(30)		The Lockbox batch name.
DEPOSIT_DATE	DATE			The Bank Supplied Lockbox Deposit Date.
_LA:CREDIT_ACTIVITY_STATUS	CHAR	(60)		Status - CLEARED, REVERSED, TRANSFERRED, FORFEITED - System level Lookup Code for the deposit activity record
CREDIT_ACTIVITY_TXN_DATE	DATE		Yes	Transaction date of the deposit activity
CREDIT_ACTIVITY_AMOUNT	NUMBER		Yes	Amount of the activity
DEBIT_ACCOUNT_CODE	VARCHAR2	(40)		Debit Account String
CREDIT_ACCOUNT_CODE	VARCHAR2	(40)		Credit Account String
_KF:ACCOUNT_NUMBER:DEBIT	CHAR	(18)		Debit Accounting Flex field
_KF: ACCOUNT_NUMBER:CREDIT	CHAR	(18)		Credit Accounting Flex field
BILL_NUMBER	VARCHAR2	(50)		Bill Number String
BILL_DATE	DATE			Bill Date
CREDIT_ACTIVITY_GL_DATE	DATE			The General Ledger Date of the Deposit Activity Record.
GL_POSTED_DATE	DATE			The Date on which the deposit activity record is posted to the interface.
_DF	CHAR	(34)		Descriptive Flexfield
PARTY_NUMBER	VARCHAR2	(30)	Yes	Party Number of the deposit transaction
PARTY_NAME	VARCHAR2	(360)	Yes	Party Name of the deposit transaction
CREDIT_CARD_PAYEE_NAME	VARCHAR2	(80)		Name of the payee
AWARD_YR_START_EFFECTIVE_DATE	DATE			Date from which an award calendar instance becomes effective.
AWARD_YR_END_EFFECTIVE_DATE	DATE			Date from which an award calendar instance is no longer effective.
AWARD_YR_CAL_DESCRIPTION	VARCHAR2	(30)		Description of award calendar type used within the institution
AWARD_YR_CAL_ALTERNATE_CODE	VARCHAR2	(10)		Alternate code of award year calendar
FEE_CAL_START_EFFECTIVE_DATE	DATE			Date from which a fee calendar instance becomes effective.
FEE_CAL_END_EFFECTIVE_DATE	DATE			Date from which a fee calendar instance is no longer effective.
FEE_CALENDAR_DESCRIPTION	VARCHAR2	(30)		Description of fee calendar type used within the institution
FEE_CALENDAR_ALTERNATE_CODE	VARCHAR2	(10)		Alternate code of fee calendar
CREDIT_TYPE_NAME	VARCHAR2	(60)	Yes	Name of the Deposit Type
_LA:CREDIT_CLASS	CHAR	(65)		System level Lookup Meaning of the deposit class - Other Deposit, Enrollment Deposit.
LOCKBOX_DESCRIPTION	VARCHAR2	(240)		User defined description for the Lockbox.
DEBIT_ACCOUNT_CODE_DESC	VARCHAR2	(60)		Description of the debit account.
CREDIT_ACCOUNT_CODE_DESC	VARCHAR2	(60)		Description of the credit account.
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
CREDIT_IDENTIFIER	NUMBER	(15)	Yes	Sequence generated number to uniquely identify a deposit transaction
CREDIT_ACTIVITY_IDENTIFIER	NUMBER	(15)	Yes	Sequence generated number to uniquely identify a deposit transaction activity
PARTY_IDENTIFIER	NUMBER	(15)	Yes	Party Identifier of the deposit transaction
CREDIT_TYPE_IDENTIFIER	NUMBER	(15)	Yes	The deposit type that this deposit transaction uses to derive accounting
MERCHANT_IDENTIFIER	VARCHAR2	(80)		Credit Card (CC) Transaction Merchant.
LOCKBOX_INTERFACE_IDENTIFIER	NUMBER			The Unique Lockbox Interface Identifier.
DEBIT_GL_CODE_COMBINATION_ID	NUMBER	(15)		Debit Accounting Flex field
CREDIT_GL_CODE_COMBINATION_ID	NUMBER	(15)		Credit Accounting Flex field
BILL_IDENTIFIER	NUMBER			Bill Identifier if this transaction is placed in any Bill
POSTING_IDENTIFIER	NUMBER	(15)		Indicates if this transaction is posted in posting interface table
POSTING_CONTROL_IDENTIFIER	NUMBER	(15)		The Posting Batch Identifier.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column

Query Text

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


SELECT CREDIT_NUMBER
,      _LA:CREDIT_STATUS
,      _LA:CREDIT_INSTRUMENT
,      CREDIT_DESCRIPTION
,      CREDIT_AMOUNT
,      UNAPPLIED_AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      TRANSACTION_DATE
,      EFFECTIVE_DATE
,      CHECK_NUMBER
,      _LA:CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      _LA:CREDIT_CARD_STATUS_CODE
,      CREDIT_CARD_PAYEE_CODE
,      CREDIT_CARD_TANGIBLE_CODE
,      AWARD_YEAR_CALENDAR_TYPE
,      AWARD_YEAR_SEQUENCE_NUMBER
,      FEE_CALENDAR_TYPE
,      FEE_CAL_INST_SEQUENCE_NUMBER
,      CREDIT_GL_DATE
,      SOURCE_TRANSACTION_TYPE
,      SOURCE_TRANSACTION_REFERENCE
,      REVERSAL_DATE
,      _LA:REVERSAL_REASON_CODE
,      REVERSAL_COMMENTS
,      RECEIPT_LOCKBOX_NUMBER
,      BATCH_NAME
,      DEPOSIT_DATE
,      _LA:CREDIT_ACTIVITY_STATUS
,      CREDIT_ACTIVITY_TXN_DATE
,      CREDIT_ACTIVITY_AMOUNT
,      DEBIT_ACCOUNT_CODE
,      CREDIT_ACCOUNT_CODE
,      _KF:ACCOUNT_NUMBER:DEBIT
,      _KF: ACCOUNT_NUMBER:CREDIT
,      BILL_NUMBER
,      BILL_DATE
,      CREDIT_ACTIVITY_GL_DATE
,      GL_POSTED_DATE
,      _DF
,      PARTY_NUMBER
,      PARTY_NAME
,      CREDIT_CARD_PAYEE_NAME
,      AWARD_YR_START_EFFECTIVE_DATE
,      AWARD_YR_END_EFFECTIVE_DATE
,      AWARD_YR_CAL_DESCRIPTION
,      AWARD_YR_CAL_ALTERNATE_CODE
,      FEE_CAL_START_EFFECTIVE_DATE
,      FEE_CAL_END_EFFECTIVE_DATE
,      FEE_CALENDAR_DESCRIPTION
,      FEE_CALENDAR_ALTERNATE_CODE
,      CREDIT_TYPE_NAME
,      _LA:CREDIT_CLASS
,      LOCKBOX_DESCRIPTION
,      DEBIT_ACCOUNT_CODE_DESC
,      CREDIT_ACCOUNT_CODE_DESC
,      BILL_CUT_OFF_DATE
,      POSTING_BATCH_NAME
,      CREDIT_IDENTIFIER
,      CREDIT_ACTIVITY_IDENTIFIER
,      PARTY_IDENTIFIER
,      CREDIT_TYPE_IDENTIFIER
,      MERCHANT_IDENTIFIER
,      LOCKBOX_INTERFACE_IDENTIFIER
,      DEBIT_GL_CODE_COMBINATION_ID
,      CREDIT_GL_CODE_COMBINATION_ID
,      BILL_IDENTIFIER
,      POSTING_IDENTIFIER
,      POSTING_CONTROL_IDENTIFIER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.IGSFV_PERSON_DEPOSITS;

Dependencies

[top of page]

APPS.IGSFV_PERSON_DEPOSITS references the following:

APPS: GL_CODE_COMBINATIONS; HZ_PARTIES; IBY_PAYEE; IGS_CA_INST_ALL; IGS_FI_ACC_ALL; IGS_FI_BILL_ALL; IGS_FI_CREDITS_ALL; IGS_FI_CR_ACTIVITIES; IGS_FI_CR_TYPES_ALL; IGS_FI_LOCKBOXES; IGS_FI_POSTING_INT_ALL

APPS.IGSFV_PERSON_DEPOSITS is not referenced by any database object