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_CONTROL_ALL

Object Details

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

IGS_FI_CONTROL stores a flag to indicate if Oracle Accounts Receivables is installed or not.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_CONTROL_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REC_INSTALLED

Columns

Name	Datatype	Length	Mandatory	Comments
REC_INSTALLED	VARCHAR2	(1)	Yes	Flag to indicate if accounts receivables is installed
LAST_ACCOUNT_TRANS	DATE			Obsoleted- Date & Time of the last accounts transfer from accounts receivables
LAST_PAY_TERM_TRANS	DATE			Obsoleted-Date & Time of the last payment terms transfer from accounts receivables
LAST_PAYMENT_TRANS	DATE			Obsoleted-Date & Time of the last student payments transfer from accounts receivables
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ACCOUNTING_METHOD	VARCHAR2	(30)		The Accounting Method - CASH or ACCRUAL
INTERFACE_LINE_CONTEXT	VARCHAR2	(30)		This would point to DFF Set up in AR - Obsolete
INTERFACE_LINE_ATTRIBUTE	VARCHAR2	(30)		This would point to DFF Set up in AR - Obsolete
BATCH_SOURCE_ID	NUMBER	(15)		Batch Source Name for AR Defaults - Obsolete
CUST_TRX_TYPE_ID	NUMBER	(15)		Transaction Type Id for AR Defaults - Obsolete
TERM_ID	NUMBER	(15)		Payment Term ID For AR Defaults - Obsolete
LOCKBOX_CONTEXT	VARCHAR2	(30)		No longer used.
LOCKBOX_NUMBER_ATTRIBUTE	VARCHAR2	(150)		No longer used.
NEXT_INVOICE_NUMBER	VARCHAR2	(60)		No longer used.
SET_OF_BOOKS_ID	NUMBER	(15)		No Longer Used
ORG_ID	NUMBER	(15)		Multi Organisation Identifier
FEE_CALC_MTHD_CODE	VARCHAR2	(30)		The Fee Calculation Method to be used.
PRG_CHG_DT_ALIAS	VARCHAR2	(10)		No longer used
AR_INT_ORG_ID	NUMBER	(15)		No longer used.
REFUND_DR_GL_CCID	NUMBER	(38)		General ledger account code combination identifier
REFUND_CR_GL_CCID	NUMBER	(38)		General ledger account code combination identifier
REFUND_DR_ACCOUNT_CD	VARCHAR2	(40)		Account code
REFUND_CR_ACCOUNT_CD	VARCHAR2	(40)		Account code
REFUND_DT_ALIAS	VARCHAR2	(10)		Date alias for refunds Add drop period
PLANNED_CREDITS_IND	VARCHAR2	(1)		Suggests if the Student Finance sub system should consider planned credits for the transactions.
CONV_PROCESS_RUN_IND	NUMBER			Identifies if the Holds Balance Conversion Process is running
REC_GL_CCID	NUMBER	(38)		Receivables Account Code Combination identifier
CASH_GL_CCID	NUMBER	(38)		Cash Account Code Combination identifier
UNAPP_GL_CCID	NUMBER	(38)		Unapplied Account Code Combination identifier
REC_ACCOUNT_CD	VARCHAR2	(40)		Receivables Account Code String
REV_ACCOUNT_CD	VARCHAR2	(40)		Revenue Account Code String
CASH_ACCOUNT_CD	VARCHAR2	(40)		Cash Account Code String
UNAPP_ACCOUNT_CD	VARCHAR2	(40)		Unapplied Account Code String
CURRENCY_CD	VARCHAR2	(15)		The functional currency code for the system.
RFND_DESTINATION	VARCHAR2	(30)		Column for storing the Refund Destination.
AP_ORG_ID	NUMBER			Organization Identifier for the Payables Operating Unit.
DFLT_SUPPLIER_SITE_NAME	VARCHAR2	(15)		No longer used
MANAGE_ACCOUNTS	VARCHAR2	(30)		This column indicates the decision for the management of Accounts. The valid values are Student Finance and Other.
ACCT_CONV_FLAG	VARCHAR2	(1)		Flag for Account conversion process.
RES_DT_ALIAS	VARCHAR2	(10)		No longer used.
POST_WAIVER_GL_FLAG	VARCHAR2	(1)		Flag to identify if waiver credit transaction needs to be posted to General Ledger for a Cash base Accounting
WAIVER_NOTIFY_FINAID_FLAG	VARCHAR2	(1)		Flag to indicate if waiver transaction for the student should be reported to Financial Aid

Query Text

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


SELECT REC_INSTALLED
,      LAST_ACCOUNT_TRANS
,      LAST_PAY_TERM_TRANS
,      LAST_PAYMENT_TRANS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ACCOUNTING_METHOD
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE
,      BATCH_SOURCE_ID
,      CUST_TRX_TYPE_ID
,      TERM_ID
,      LOCKBOX_CONTEXT
,      LOCKBOX_NUMBER_ATTRIBUTE
,      NEXT_INVOICE_NUMBER
,      SET_OF_BOOKS_ID
,      ORG_ID
,      FEE_CALC_MTHD_CODE
,      PRG_CHG_DT_ALIAS
,      AR_INT_ORG_ID
,      REFUND_DR_GL_CCID
,      REFUND_CR_GL_CCID
,      REFUND_DR_ACCOUNT_CD
,      REFUND_CR_ACCOUNT_CD
,      REFUND_DT_ALIAS
,      PLANNED_CREDITS_IND
,      CONV_PROCESS_RUN_IND
,      REC_GL_CCID
,      CASH_GL_CCID
,      UNAPP_GL_CCID
,      REC_ACCOUNT_CD
,      REV_ACCOUNT_CD
,      CASH_ACCOUNT_CD
,      UNAPP_ACCOUNT_CD
,      CURRENCY_CD
,      RFND_DESTINATION
,      AP_ORG_ID
,      DFLT_SUPPLIER_SITE_NAME
,      MANAGE_ACCOUNTS
,      ACCT_CONV_FLAG
,      RES_DT_ALIAS
,      POST_WAIVER_GL_FLAG
,      WAIVER_NOTIFY_FINAID_FLAG
FROM IGS.IGS_FI_CONTROL_ALL;

Dependencies

[top of page]

IGS.IGS_FI_CONTROL_ALL does not reference any database object

IGS.IGS_FI_CONTROL_ALL is referenced by following:

APPS: IGS_FI_CONTROL_ALL