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

VIEW: APPS.IGS_FI_CREDITS

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


This view is a multi-org filter flat view based on table IGS_FI_CREDITS_ALL.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CREDIT_ID NUMBER (15) Yes
CREDIT_NUMBER VARCHAR2 (60) Yes
STATUS VARCHAR2 (15) Yes
CREDIT_SOURCE VARCHAR2 (60)
PARTY_ID NUMBER (15) Yes
CREDIT_TYPE_ID NUMBER (15) Yes
CREDIT_INSTRUMENT VARCHAR2 (60) Yes
DESCRIPTION VARCHAR2 (240)
AMOUNT NUMBER
Yes
CURRENCY_CD VARCHAR2 (15) Yes
EXCHANGE_RATE NUMBER

TRANSACTION_DATE DATE
Yes
EFFECTIVE_DATE DATE
Yes
REVERSAL_DATE DATE

REVERSAL_REASON_CODE VARCHAR2 (30)
REVERSAL_COMMENTS VARCHAR2 (240)
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
ORG_ID NUMBER (15)
UNAPPLIED_AMOUNT NUMBER

SOURCE_TRANSACTION_ID NUMBER

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_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
CREDIT_CARD_APPROVAL_CODE VARCHAR2 (80)
No longer used
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

GL_DATE DATE

The General Ledger Date.
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.
SOURCE_INVOICE_ID NUMBER (15)
Invoice Identifier for the Source Invoice Id
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)
Waiver Program Name attached to a Fee Calendar Instance for which student has received waiver credit.
Query Text

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


SELECT ROW_ID
,      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
,      AWD_YR_CAL_TYPE
,      AWD_YR_CI_SEQUENCE_NUMBER
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      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_STATUS_CODE
,      CREDIT_CARD_PAYEE_CD
,      CREDIT_CARD_TANGIBLE_CD
,      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
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      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
,      SOURCE_INVOICE_ID
,      TAX_YEAR_CODE
,      WAIVER_NAME
FROM APPS.IGS_FI_CREDITS;

Dependencies

[top of page]

APPS.IGS_FI_CREDITS references the following:

SchemaAPPS
SynonymIGS_FI_CREDITS_ALL
APPS.IGS_FI_CREDITS is referenced by following:

SchemaAPPS
Package BodyIGF_AW_LI_IMPORT - show dependent code
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
ViewIGS_FI_BILL_DPSTS_V
Package BodyIGS_FI_BILL_EXTRACT - show dependent code
Package BodyIGS_FI_CHARGES_API_PVT - show dependent code
Package BodyIGS_FI_COM_REC_INTERFACE - show dependent code
Package BodyIGS_FI_CRDAPI_UTIL - show dependent code
PL/SQL PackageIGS_FI_CRDAPI_UTIL - show dependent code
ViewIGS_FI_CRDT_TRNSCTNS
ViewIGS_FI_CREDITS_V
Package BodyIGS_FI_CREDIT_PVT - show dependent code
Package BodyIGS_FI_DEPOSITS_PRCSS - show dependent code
Package BodyIGS_FI_GEN_007 - show dependent code
Package BodyIGS_FI_GEN_GL - show dependent code
PL/SQL PackageIGS_FI_GEN_REFUNDS - show dependent code
Package BodyIGS_FI_GEN_REFUNDS - show dependent code
Package BodyIGS_FI_GL_INTERFACE - show dependent code
Package BodyIGS_FI_POSTING_PROCESS - show dependent code
ViewIGS_FI_PP_INS_APPLS_V
Package BodyIGS_FI_PRC_APPL - show dependent code
Package BodyIGS_FI_PRC_BALANCES - show dependent code
Package BodyIGS_FI_PRC_FIN_LT_CHG - show dependent code
Package BodyIGS_FI_PRC_HOLDS - show dependent code
Package BodyIGS_FI_PRC_IMPCLC_ANC_CHGS - show dependent code
Package BodyIGS_FI_PRC_LOCKBOX - show dependent code
PL/SQL PackageIGS_FI_PRC_LOCKBOX - show dependent code
Package BodyIGS_FI_PRC_REFUNDS - show dependent code
Package BodyIGS_FI_PRC_STDNT_DPSTS - show dependent code
Package BodyIGS_FI_SS_ACCT_PAYMENT - show dependent code
Package BodyIGS_FI_WAV_UTILS_001 - show dependent code
Package BodyIGS_FI_WAV_UTILS_002 - show dependent code
PL/SQL PackageIGS_FI_WAV_UTILS_002 - show dependent code