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

VIEW: APPS.IGS_FI_REFUND_INT

Object Details
Object Name: IGS_FI_REFUND_INT
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_REFUND_INT
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.


Interface view for transfer of data to account payables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique identifier for each row
REFUND_ID NUMBER (15) Yes Sequence generated primary key
VOUCHER_DATE DATE
Yes Date on which voucher was created
PERSON_ID NUMBER (15) Yes Person identifier
PAY_PERSON_ID NUMBER (15) Yes Identifier for payee
DR_GL_CCID NUMBER (38)
General ledger account code combination identifier
CR_GL_CCID NUMBER (38)
General ledger account code combination identifier
DR_ACCOUNT_CD VARCHAR2 (40)
Account code
CR_ACCOUNT_CD VARCHAR2 (40)
Account code
REFUND_AMOUNT NUMBER
Yes Refund amount,cannot be zero.
FEE_TYPE VARCHAR2 (10) Yes Fee type identifier
FEE_CAL_TYPE VARCHAR2 (10) Yes Fee calendar identifier
FEE_CI_SEQUENCE_NUMBER NUMBER (6) Yes Fee calendar instance identifier
PAYMENT_NUMBER VARCHAR2 (40)
Payment number-OBSOLETE
PAYMENT_DATE DATE

Payment date-OBSOLETE
PAYMENT_MODE VARCHAR2 (30)
Mode of payment i.e. CHECK or EFT-OBSOLETE
SOURCE_REFUND_ID NUMBER (15)
Refund id of the reversed refund.
INVOICE_ID NUMBER (15)
Invoice id for charge created for refund transaction
REASON VARCHAR2 (2000)
Mandatory if refund transaction has been reversed
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Descriptive Flex Field Column.
ATTRIBUTE1 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE2 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE3 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE4 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE5 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE6 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE7 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE8 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE9 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE10 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE11 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE12 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE13 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE14 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE15 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE16 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE17 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE18 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE19 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE20 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ORG_ID NUMBER (15)
Unique organizational identifier
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Concurrent manager column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent manager column
PROGRAM_ID NUMBER (15)
Concurrent manager column
PROGRAM_UPDATE_DATE DATE

Concurrent manager column
GL_DATE DATE

The General Ledger Date.
Query Text

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


SELECT ROW_ID
,      REFUND_ID
,      VOUCHER_DATE
,      PERSON_ID
,      PAY_PERSON_ID
,      DR_GL_CCID
,      CR_GL_CCID
,      DR_ACCOUNT_CD
,      CR_ACCOUNT_CD
,      REFUND_AMOUNT
,      FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      PAYMENT_NUMBER
,      PAYMENT_DATE
,      PAYMENT_MODE
,      SOURCE_REFUND_ID
,      INVOICE_ID
,      REASON
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GL_DATE
FROM APPS.IGS_FI_REFUND_INT;

Dependencies

[top of page]

APPS.IGS_FI_REFUND_INT references the following:

SchemaAPPS
SynonymIGS_FI_REFUND_INT_ALL

APPS.IGS_FI_REFUND_INT is not referenced by any database object