eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_FI_REFUND_INT_ALL

Object Details

Object Name:	IGS_FI_REFUND_INT_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_FI_REFUND_INT_ALL
Subobject Name:
Status:	VALID

IGS_FI_REFUND_INT_ALL describes the interface table for transfer of refund data to a payables system.
An interface table for exporting refund transactions to a Non-Oracle Payables system. This table is an interface table for transfer of refunds data to a payables system.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Refunds (Non-Oracle Payables) Transactions Extract
Category: BUSINESS_ENTITY IGS_PARTY_REFUND

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_REFUND_INT_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REFUND_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REFUND_ID	NUMBER	(15)	Yes	Refund voucher id.
VOUCHER_DATE	DATE		Yes	Date on which the refund voucher is created.
PERSON_ID	NUMBER	(15)	Yes	A unique identification number, used to identify a particular person.
PAY_PERSON_ID	NUMBER	(15)	Yes	Identifier for payee of the refund voucher.
DR_GL_CCID	NUMBER	(38)		General ledger account code combination identifier. Populated if Oracle Accounts Receivables is installed.
CR_GL_CCID	NUMBER	(38)		General ledger account code combination identifier. Populated if Oracle Accounts Receivables is installed.
DR_ACCOUNT_CD	VARCHAR2	(40)		Account code. Populated if Oracle Accounts Receivables is not installed.
CR_ACCOUNT_CD	VARCHAR2	(40)		Account code. Populated if Oracle Accounts Receivables is not installed.
REFUND_AMOUNT	NUMBER		Yes	Amount of refund. The value cannot be zero.
FEE_TYPE	VARCHAR2	(10)	Yes	This field describes the fee types used for the purpose of applying fees and charges.
FEE_CAL_TYPE	VARCHAR2	(10)	Yes	The code of a Fee calendar type which defines the period of time in which the fee type will operate.
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	This field uniquely identifies the calendar instance.
PAYMENT_NUMBER	VARCHAR2	(40)		Number or reference of the payment.-OBSOLETE
PAYMENT_DATE	DATE			Date of the payment.-OBSOLETE
PAYMENT_MODE	VARCHAR2	(30)		Mode of payment i.e. CHECK or EFT-OBSOLETE
SOURCE_REFUND_ID	NUMBER	(15)		Refund identifier of the reversed refund
INVOICE_ID	NUMBER	(15)		Invoice id for the charge created by this refund transaction
REASON	VARCHAR2	(2000)		Reversal reason of the refund transaction.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield Segment column
ORG_ID	NUMBER	(15)		Unique Organisation identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who columns
CREATION_DATE	DATE		Yes	Standard Who columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who columns
LAST_UPDATE_DATE	DATE		Yes	Standard Who columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who columns
REQUEST_ID	NUMBER	(15)		Concurrent manager columns
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent manager columns
PROGRAM_ID	NUMBER	(15)		Concurrent manager columns
PROGRAM_UPDATE_DATE	DATE			Concurrent manager columns
GL_DATE	DATE			The General Ledger Date of the Refund Interface record.

Query Text

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


SELECT 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 IGS.IGS_FI_REFUND_INT_ALL;

Dependencies

[top of page]

IGS.IGS_FI_REFUND_INT_ALL does not reference any database object

IGS.IGS_FI_REFUND_INT_ALL is referenced by following:

APPS: IGS_FI_REFUND_INT_ALL