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: GMF.GL_ACCT_HRC

Object Details

Object Name:	GL_ACCT_HRC
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.GL_ACCT_HRC
Subobject Name:
Status:	VALID

This table contains the account selection priority for the companies
and the account titles. These priorities are used by the GL Mapping
program to retrieve the accounts for sub-ledger posting, in the order
of account selection priority. In a new install of GEMMS, this table
is pre-loaded with the default selection priorities for a blank
company( valid for all companies) and all applicable account titles.
These priorities can then be modified for specific companies &
account titles. Note that a priority of 1 is the highest priority and
the priority will descrease for higher numbers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_ACCT_HRC_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCT_HRC_ID
GL_ACCT_HRC_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CO_CODE ACCT_TTL_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ACCT_HRC_ID	NUMBER	(15)	Yes	Surrogate for a row
CO_CODE	VARCHAR2	(4)		Company for which the account selection priorities are defined.
ACCT_TTL_TYPE	NUMBER		Yes	Account title within the company, for which the account selection priorites are defined
ORGN_CODE_PRI	NUMBER		Yes	Organization priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
WHSE_CODE_PRI	NUMBER		Yes	Warehouse Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
ITEM_PRI	NUMBER		Yes	Item Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
VENDOR_PRI	NUMBER		Yes	Vendor Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
CUSTOMER_PRI	NUMBER		Yes	Customer Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
REASON_CODE_PRI	NUMBER		Yes	Reason Code Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
ICGL_CLASS_PRI	NUMBER		Yes	Item GL Class priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
VENDGL_CLASS_PRI	NUMBER		Yes	Vendor GL Class priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
CUSTGL_CLASS_PRI	NUMBER		Yes	Customer GL Class priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
CURRENCY_CODE_PRI	NUMBER		Yes	Currency Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
ROUTING_PRI	NUMBER		Yes	Routing Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
CHARGE_PRI	NUMBER		Yes	Sales Order Charges Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
TAX_AUTH_PRI	NUMBER		Yes	Tax Authority Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
AQUI_COST_CODE_PRI	NUMBER		Yes	Aquisition Cost Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
RESOURCE_PRI	NUMBER	(5)	Yes	Resource Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
COST_CMPNTCLS_PRI	NUMBER	(5)	Yes	Compnent Class Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
COST_ANALYSIS_PRI	NUMBER	(5)	Yes	Analysis Code Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER			Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER		Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
ORDER_TYPE_PRI	NUMBER	(5)	Yes	Sales Order Type Priority. -1 = Not Applicable for the Account Title; 0 = Applicable but not used in the selection criteria; >0 = Indicates the order of the selection priority
GL_BUSINESS_CLASS_PRI	NUMBER	(5)	Yes	Business Class Priority
GL_PRODUCT_LINE_PRI	NUMBER	(5)	Yes	Product Line Priority
LINE_TYPE_PRI	NUMBER	(5)	Yes	Line Type Priority
AR_TRX_TYPE_PRI	NUMBER	(5)		AR Transaction Type Priority

Query Text

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


SELECT ACCT_HRC_ID
,      CO_CODE
,      ACCT_TTL_TYPE
,      ORGN_CODE_PRI
,      WHSE_CODE_PRI
,      ITEM_PRI
,      VENDOR_PRI
,      CUSTOMER_PRI
,      REASON_CODE_PRI
,      ICGL_CLASS_PRI
,      VENDGL_CLASS_PRI
,      CUSTGL_CLASS_PRI
,      CURRENCY_CODE_PRI
,      ROUTING_PRI
,      CHARGE_PRI
,      TAX_AUTH_PRI
,      AQUI_COST_CODE_PRI
,      RESOURCE_PRI
,      COST_CMPNTCLS_PRI
,      COST_ANALYSIS_PRI
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      ORDER_TYPE_PRI
,      GL_BUSINESS_CLASS_PRI
,      GL_PRODUCT_LINE_PRI
,      LINE_TYPE_PRI
,      AR_TRX_TYPE_PRI
FROM GMF.GL_ACCT_HRC;

Dependencies

[top of page]

GMF.GL_ACCT_HRC does not reference any database object

GMF.GL_ACCT_HRC is referenced by following:

APPS: GL_ACCT_HRC