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

VIEW: APPS.IGSFV_PARTY_CREDITS

Object Details
Object Name: IGSFV_PARTY_CREDITS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_PARTY_CREDITS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Stores all Party Credits in Student Finance


[View Source]

Columns
Name Datatype Length Mandatory Comments
CREDIT_NUMBER VARCHAR2 (60) Yes User Defined Credit Transaction Identifier
_LA:CREDIT_STATUS CHAR (60)
Status of the credit transaction - CLEARED, REVERSED, TRANSFERRED or FORFEITED. Would be controlled by a lookup type.
_LA:CREDIT_SOURCE CHAR (61)
This is to identify a credit source , e.g. PELL, PERKIN, INDIVIDUAL - User defined Lookups
_LA:CREDIT_INSTRUMENT CHAR (75)
User defined lookup - CASH, CREDIT CARD, CHECK
CREDIT_DESCRIPTION VARCHAR2 (240)
Description of the credit transaction
CREDIT_AMOUNT NUMBER
Yes Credit Amount
UNAPPLIED_AMOUNT NUMBER

The portion of the credit 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 Credit Transaction
CHECK_NUMBER VARCHAR2 (30)
Check Number of the Credit Transaction. This is applicable only if the credit instrument of the credit is 'Check'.
_LA:CREDIT_CARD_CODE CHAR (66)
No longer used
CREDIT_CARD_HOLDER_NAME VARCHAR2 (80)
No longer used
CREDIT_CARD_NUMBER VARCHAR2 (50)
No longer used
CREDIT_CARD_EXPIRATION_DATE DATE

No longer used
CREDIT_CARD_APPROVAL_CODE VARCHAR2 (80)
No longer used
_LA:CREDIT_CARD_STATUS_CODE CHAR (82)
Credit Card (CC) Transaction Status.
CREDIT_CARD_PAYEE_CODE VARCHAR2 (80)
No longer used
CREDIT_CARD_TANGIBLE_CODE VARCHAR2 (80)
No longer used
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 Credit Record.
SOURCE_TRANSACTION_TYPE VARCHAR2 (30)
Source Transaction Type of the credit.
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 credit transaction
REVERSAL_COMMENTS VARCHAR2 (240)
Comments for reversal of the credit 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.
TAX_YEAR_CODE VARCHAR2 (30)
Indicates the calendar year, in which the credit is reported to the Internal Revenue Services
WAIVER_NAME VARCHAR2 (30)
Waiver Program Name attached to a Fee Calendar Instance for which student has received waiver credit.
_LA:CREDIT_ACTIVITY_STATUS CHAR (60)
Status - CLEARED, REVERSED, TRANSFERRED, FORFEITED - System level Lookup Code for the credit activity record
CREDIT_ACTIVITY_TXN_DATE DATE
Yes Transaction date of the credit 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 Credit Activity Record.
GL_POSTED_DATE DATE

The Date on which the credit activity record is posted to the interface.
_DF CHAR (34)
Descriptive Flexfield
PARTY_NUMBER VARCHAR2 (30) Yes Party Number of the credit transaction
PARTY_NAME VARCHAR2 (360) Yes Party Name of the credit 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
AWRAD_YR_CAL_ALT_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_ALT_CODE VARCHAR2 (10)
Alternate code of fee calendar
CREDIT_TYPE_NAME VARCHAR2 (60) Yes Name of the Credit Type
_LA:CREDIT_CLASS CHAR (65)
System level Lookup Meaning of the credit class
WAIVER_DESCRIPTION VARCHAR2 (240)
User defined description for waiver program
LOCKBOX_DESCRIPTION VARCHAR2 (240)
User defined description for the Lockbox.
TAX_YEAR_NAME VARCHAR2 (30)
Indicates the 1098-T Reporting Tax Year, in which the credit 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.
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
SOURCE_INVOICE_DESCRIPTION VARCHAR2 (240)
Invoice description for the source charge transaction
CREDIT_IDENTIFIER NUMBER (15) Yes Sequence generated number to uniquely identify a credit transaction
CREDIT_ACTIVITY_IDENTIFIER NUMBER (15) Yes Sequence generated number to uniquely identify a credit transaction activity
PARTY_IDENTIFIER NUMBER (15) Yes Party Identifier of the credit transaction
CREDIT_TYPE_IDENTIFIER NUMBER (15) Yes The credit type that this credit transaction uses to derive accounting
MERCHANT_IDENTIFIER VARCHAR2 (80)
No longer used
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.
SOURCE_INVOICE_IDENTIFIER NUMBER (15)
Invoice Identifier for the Source Charge transaction
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_SOURCE
,      _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
,      TAX_YEAR_CODE
,      WAIVER_NAME
,      _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
,      AWRAD_YR_CAL_ALT_CODE
,      FEE_CAL_START_EFFECTIVE_DATE
,      FEE_CAL_END_EFFECTIVE_DATE
,      FEE_CALENDAR_DESCRIPTION
,      FEE_CALENDAR_ALT_CODE
,      CREDIT_TYPE_NAME
,      _LA:CREDIT_CLASS
,      WAIVER_DESCRIPTION
,      LOCKBOX_DESCRIPTION
,      TAX_YEAR_NAME
,      TAX_YEAR_EFFECTIVE_START_DATE
,      TAX_YEAR_EFFECTIVE_END_DATE
,      DEBIT_ACCOUNT_CODE_DESC
,      CREDIT_ACCOUNT_CODE_DESC
,      BILL_CUT_OFF_DATE
,      POSTING_BATCH_NAME
,      SOURCE_INVOICE_DESCRIPTION
,      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
,      SOURCE_INVOICE_IDENTIFIER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.IGSFV_PARTY_CREDITS;

Dependencies

[top of page]

APPS.IGSFV_PARTY_CREDITS references the following:

SchemaAPPS
SynonymGL_CODE_COMBINATIONS
SynonymHZ_PARTIES
SynonymIBY_PAYEE
SynonymIGS_CA_INST_ALL
SynonymIGS_FI_1098T_SETUP
SynonymIGS_FI_ACC_ALL
SynonymIGS_FI_BILL_ALL
SynonymIGS_FI_CREDITS_ALL
SynonymIGS_FI_CR_ACTIVITIES
SynonymIGS_FI_CR_TYPES_ALL
SynonymIGS_FI_INV_INT_ALL
SynonymIGS_FI_LOCKBOXES
SynonymIGS_FI_POSTING_INT_ALL
SynonymIGS_FI_WAIVER_PGMS

APPS.IGSFV_PARTY_CREDITS is not referenced by any database object