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: IGI.IGI_AR_SYSTEM_OPTIONS_ALL

Object Details

Object Name:	IGI_AR_SYSTEM_OPTIONS_ALL
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_AR_SYSTEM_OPTIONS_ALL
Subobject Name:
Status:	VALID

IGI_AR_SYSTEM_OPTIONS_ALL is an extended Receivables System Options table containing data for each of the receivable requirements.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	General Ledger Set of Books used. Only one supported currently.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ACCOUNTING_METHOD	VARCHAR2	(30)		Lookup code for the accounting method
ARC_CASH_SOB_ID	NUMBER	(15)		General Ledger Set of Books used for cash basis accounting method
ARC_UNALLOC_REV_CCID	NUMBER	(15)		Used only for Cash Basis accounting method. Revenue account to be used when applying a cash receipt with a balance other than zero to an invoice with a zero balance.
RPI_HEADER_CONTEXT_CODE	VARCHAR2	(30)		Context code label
RPI_HEADER_CHARGE_ID	VARCHAR2	(30)		Standing charge identifier label
RPI_HEADER_GENERATE_SEQ	VARCHAR2	(30)		Generate sequence label
RPI_LINE_CONTEXT_CODE	VARCHAR2	(30)		Context code label. Defaulted from header level. May change in future.
RPI_LINE_CHARGE_ID	VARCHAR2	(30)		Standing charge identifier label. Defaulted from header level. May change in future.
RPI_LINE_GENERATE_SEQ	VARCHAR2	(30)		Generate sequence label. Defaulted from header level. May change in future.
RPI_LINE_CHARGE_LINE_NUM	VARCHAR2	(30)		Charge line number label
RPI_LINE_PRICE_BREAK_NUM	VARCHAR2	(30)		Price break label
ARC_AUTO_GL_IMPORT_FLAG	VARCHAR2	(1)		Automatically submit journal import if enabled
DUNNING_RECEIVABLES_TRX_ID	NUMBER	(15)		Unique identifier for transactions used in Dunning Letters
ORG_ID	NUMBER	(15)		Organization identifier
ARC_JE_SOURCE_NAME	VARCHAR2	(25)		Journal Source to be used to create journal batches in General Ledger.

Query Text

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


SELECT SET_OF_BOOKS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACCOUNTING_METHOD
,      ARC_CASH_SOB_ID
,      ARC_UNALLOC_REV_CCID
,      RPI_HEADER_CONTEXT_CODE
,      RPI_HEADER_CHARGE_ID
,      RPI_HEADER_GENERATE_SEQ
,      RPI_LINE_CONTEXT_CODE
,      RPI_LINE_CHARGE_ID
,      RPI_LINE_GENERATE_SEQ
,      RPI_LINE_CHARGE_LINE_NUM
,      RPI_LINE_PRICE_BREAK_NUM
,      ARC_AUTO_GL_IMPORT_FLAG
,      DUNNING_RECEIVABLES_TRX_ID
,      ORG_ID
,      ARC_JE_SOURCE_NAME
FROM IGI.IGI_AR_SYSTEM_OPTIONS_ALL;

Dependencies

[top of page]

IGI.IGI_AR_SYSTEM_OPTIONS_ALL does not reference any database object

IGI.IGI_AR_SYSTEM_OPTIONS_ALL is referenced by following:

IGI: IGI_AR_SYSTEM_OPTIONS_ALL#