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

TABLE: IGS.IGS_FI_CREDITS_ALL

Object Details
Object Name: IGS_FI_CREDITS_ALL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_FI_CREDITS_ALL
Subobject Name:
Status: VALID


IGS_FI_CREDITS_ALL Contains information about all credit or payment transactions.It is the central repository for all credits and payments related information in Student Finance.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_CREDITS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREDIT_ID
IGS_FI_CREDITS_ALL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
ColumnCREDIT_NUMBER
ColumnORG_ID
IGS_FI_CREDITS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREDIT_NUMBER
IGS_FI_CREDITS_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREDIT_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
CREDIT_ID NUMBER (15) Yes Sequence generated number to uniquely identify a credit transaction
CREDIT_NUMBER VARCHAR2 (60) Yes User Defined Credit Transaction Identifier
STATUS VARCHAR2 (15) Yes Status of the transaction - CLEARED and RESERVED. Would be controlled by a lookup type.
CREDIT_SOURCE VARCHAR2 (60)
This is to identify a source , e.g. PELL, PERKIN, INDIVIDUAL etc - User defined Lookups
PARTY_ID NUMBER (15) Yes Beneficiary of the credit transaction
CREDIT_TYPE_ID NUMBER (15) Yes The credit type that this credit transaction uses to derive accounting
CREDIT_INSTRUMENT VARCHAR2 (60) Yes User defined lookup - CASH, CREDIT CARD, CHECK etc.
DESCRIPTION VARCHAR2 (240)
Description of the credit transaction
AMOUNT NUMBER
Yes Credit Amount
CURRENCY_CD VARCHAR2 (15) Yes This will always be local currency
EXCHANGE_RATE NUMBER

Should be 1
TRANSACTION_DATE DATE
Yes Transaction Date
EFFECTIVE_DATE DATE
Yes Effective Date for this Credit Transaction
REVERSAL_DATE DATE

The date this transaction is reversed.
REVERSAL_REASON_CODE VARCHAR2 (30)
Lookup code for Reversal Reason - IGS_FI_REVERSAL_REASON
REVERSAL_COMMENTS VARCHAR2 (240)
Textual comments
ORG_ID NUMBER (15)
Multi-Org operating units
UNAPPLIED_AMOUNT NUMBER

The portion of the credit amount that remains to be applied to any open debit item.
SOURCE_TRANSACTION_ID NUMBER

This field would be used to capture source transaction id when any credit transaction is created from other system viz. AR LockBox etc.
SUBACCOUNT_ID NUMBER (15)
No longer used.
RECEIPT_LOCKBOX_NUMBER VARCHAR2 (30)
User defined Lockbox Name.
MERCHANT_ID VARCHAR2 (80)
No longer used
CREDIT_CARD_CODE VARCHAR2 (80)
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard DFF Column.
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE16 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE17 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE18 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE19 VARCHAR2 (150)
Standard DFF Column.
ATTRIBUTE20 VARCHAR2 (150)
Standard DFF Column.
AWD_YR_CAL_TYPE VARCHAR2 (10)
The Calendar Type for the Award Year
AWD_YR_CI_SEQUENCE_NUMBER NUMBER (6)
The Calendar Instance for the Award Year
FEE_CAL_TYPE VARCHAR2 (10)
The Calendar Type for the Fee Period
FEE_CI_SEQUENCE_NUMBER NUMBER (6)
The Calendar Instance for the Fee Period
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column.
LAST_UPDATE_DATE DATE
Yes Standard WHO Column.
CREATED_BY NUMBER (15) Yes Standard WHO Column.
CREATION_DATE DATE
Yes Standard WHO Column.
REQUEST_ID NUMBER (15)
Standard Concurrent Process Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Concurrent Process Column
PROGRAM_ID NUMBER (15)
Standard Concurrent Process Column
PROGRAM_UPDATE_DATE DATE

Standard Concurrent Process Column
GL_DATE DATE

The General Ledger Date of the Credit Record.
CHECK_NUMBER VARCHAR2 (30)
Check Number of the Receipt Transaction. This is applicable only if the credit instrument of the receipt is 'Check'.
SOURCE_TRANSACTION_TYPE VARCHAR2 (30)
Source Transaction Type of the receipt. This will signify the classification of source transaction reference.
SOURCE_TRANSACTION_REF VARCHAR2 (60)
Source Transaction Reference Number.
LOCKBOX_INTERFACE_ID NUMBER

The Unique Lockbox Interface Identifier.
BATCH_NAME VARCHAR2 (30)
The Lockbox batch name.
DEPOSIT_DATE DATE

The Bank Supplied Lockbox Deposit Date.
CREDIT_CARD_STATUS_CODE VARCHAR2 (30)
Status of the Credit Card Transaction.
CREDIT_CARD_PAYEE_CD VARCHAR2 (80)
No longer used
CREDIT_CARD_TANGIBLE_CD VARCHAR2 (80)
No longer used
SOURCE_INVOICE_ID NUMBER (15)
Invoice Identifier for the Source Charge transaction
TAX_YEAR_CODE VARCHAR2 (30)
Indicates the 1098-T Reporting Tax Year, in which the credit is reported to the Internal Revenue Services
WAIVER_NAME VARCHAR2 (30)
Indicates the Waiver Program Name attached to fee calendar instance for which the person has received waiver credit.
Query Text

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


SELECT CREDIT_ID
,      CREDIT_NUMBER
,      STATUS
,      CREDIT_SOURCE
,      PARTY_ID
,      CREDIT_TYPE_ID
,      CREDIT_INSTRUMENT
,      DESCRIPTION
,      AMOUNT
,      CURRENCY_CD
,      EXCHANGE_RATE
,      TRANSACTION_DATE
,      EFFECTIVE_DATE
,      REVERSAL_DATE
,      REVERSAL_REASON_CODE
,      REVERSAL_COMMENTS
,      ORG_ID
,      UNAPPLIED_AMOUNT
,      SOURCE_TRANSACTION_ID
,      SUBACCOUNT_ID
,      RECEIPT_LOCKBOX_NUMBER
,      MERCHANT_ID
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      AWD_YR_CAL_TYPE
,      AWD_YR_CI_SEQUENCE_NUMBER
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GL_DATE
,      CHECK_NUMBER
,      SOURCE_TRANSACTION_TYPE
,      SOURCE_TRANSACTION_REF
,      LOCKBOX_INTERFACE_ID
,      BATCH_NAME
,      DEPOSIT_DATE
,      CREDIT_CARD_STATUS_CODE
,      CREDIT_CARD_PAYEE_CD
,      CREDIT_CARD_TANGIBLE_CD
,      SOURCE_INVOICE_ID
,      TAX_YEAR_CODE
,      WAIVER_NAME
FROM IGS.IGS_FI_CREDITS_ALL;

Dependencies

[top of page]

IGS.IGS_FI_CREDITS_ALL does not reference any database object

IGS.IGS_FI_CREDITS_ALL is referenced by following:

SchemaAPPS
SynonymIGS_FI_CREDITS_ALL