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

VIEW: APPS.IGS_FI_CREDITS_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CREDIT_ID NUMBER (15) Yes
STATUS VARCHAR2 (15) Yes
STATUS_DESC VARCHAR2 (80) Yes Description of Credit Status
CREDIT_NUMBER VARCHAR2 (60) Yes
CREDIT_SOURCE VARCHAR2 (80)
CREDIT_SOURCE_CODE VARCHAR2 (60)
PARTY_ID NUMBER (15) Yes
PERSON_NUMBER VARCHAR2 (30) Yes The person number of the Party Id.
FULL_NAME VARCHAR2 (450)
The Full Name of the Party Id.
API_PERSON_ID VARCHAR2 (20)
The Alternate Person Id of the Party Id.
CREDIT_TYPE_ID NUMBER (15) Yes
CREDIT_TYPE_NAME VARCHAR2 (60) Yes
CREDIT_INSTRUMENT VARCHAR2 (80) Yes
CREDIT_INSTRUMENT_CODE 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_REASON_MEANING VARCHAR2 (80)
The Reversal Reason description.
REVERSAL_COMMENTS VARCHAR2 (240)
UNAPPLIED_AMOUNT NUMBER

SOURCE_TRANSACTION_ID NUMBER

SUBACCOUNT_ID NUMBER (15)
OBSOLETE
SUBACCOUNT_NAME VARCHAR2 (0)
OBSOLETE
RECEIPT_LOCKBOX_NUMBER VARCHAR2 (30)
User defined Lockbox Name.
MERCHANT_ID VARCHAR2 (80)
No longer used
CREDIT_CLASS VARCHAR2 (80) Yes
CREDIT_CLASS_CODE VARCHAR2 (40) Yes
CREDIT_CARD_TYPE 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_STATUS_DESC VARCHAR2 (80)
Status Description 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
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
FEE_START_DT DATE

The effective start date for the Fee Period
FEE_END_DT DATE

The effective end date for the Fee Period
ORG_ID NUMBER (15)
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_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
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_TRANS_TYPE_MEANING VARCHAR2 (80)
Source Transaction Type meaning of the receipt.
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
,      STATUS
,      STATUS_DESC
,      CREDIT_NUMBER
,      CREDIT_SOURCE
,      CREDIT_SOURCE_CODE
,      PARTY_ID
,      PERSON_NUMBER
,      FULL_NAME
,      API_PERSON_ID
,      CREDIT_TYPE_ID
,      CREDIT_TYPE_NAME
,      CREDIT_INSTRUMENT
,      CREDIT_INSTRUMENT_CODE
,      DESCRIPTION
,      AMOUNT
,      CURRENCY_CD
,      EXCHANGE_RATE
,      TRANSACTION_DATE
,      EFFECTIVE_DATE
,      REVERSAL_DATE
,      REVERSAL_REASON_CODE
,      REVERSAL_REASON_MEANING
,      REVERSAL_COMMENTS
,      UNAPPLIED_AMOUNT
,      SOURCE_TRANSACTION_ID
,      SUBACCOUNT_ID
,      SUBACCOUNT_NAME
,      RECEIPT_LOCKBOX_NUMBER
,      MERCHANT_ID
,      CREDIT_CLASS
,      CREDIT_CLASS_CODE
,      CREDIT_CARD_TYPE
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_STATUS_CODE
,      CREDIT_CARD_STATUS_DESC
,      CREDIT_CARD_PAYEE_CD
,      CREDIT_CARD_TANGIBLE_CD
,      CREDIT_CARD_APPROVAL_CODE
,      AWD_YR_CAL_TYPE
,      AWD_YR_CI_SEQUENCE_NUMBER
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      FEE_START_DT
,      FEE_END_DT
,      ORG_ID
,      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_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_TRANS_TYPE_MEANING
,      SOURCE_TRANSACTION_REF
,      LOCKBOX_INTERFACE_ID
,      BATCH_NAME
,      DEPOSIT_DATE
,      SOURCE_INVOICE_ID
,      TAX_YEAR_CODE
,      WAIVER_NAME
FROM APPS.IGS_FI_CREDITS_V;

Dependencies

[top of page]

APPS.IGS_FI_CREDITS_V references the following:

SchemaAPPS
ViewIGF_LOOKUPS_VIEW
ViewIGS_CA_INST
PL/SQL PackageIGS_EN_GEN_003 - show dependent code
ViewIGS_FI_CREDITS
ViewIGS_FI_CR_TYPES
ViewIGS_FI_PARTIES_V
ViewIGS_LOOKUP_VALUES
APPS.IGS_FI_CREDITS_V is referenced by following:

SchemaAPPS
ViewIGS_FI_ACCT_V
Package BodyIGS_FI_PRC_BALANCES - show dependent code