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.

[Home] [Help]

Table: GL_ACCT_MST

Product:	GMF - Process Manufacturing Financials
Description:	Contains the Company specific Chart of Accounts. Note that in the Oracle Financials integrated setup this table is populated with Oracle Financials Accounts while entering the Account Mapping information.
Implementation/DBA Data:	GMF.GL_ACCT_MST

Primary Key: GL_ACCT_MST_PK

ACCT_ID

Primary Key: GL_ACCT_MST_U1

CO_CODE
ACCT_NO

Foreign Keys

Table	Foreign Table	Foreign Key Column
GL_ACCT_MST	GL_ACCT_CLS	GL_ACCT_MST.ACCT_CLASS_CODE
GL_ACCT_MST	GL_ACCT_TYP	GL_ACCT_MST.ACCT_TYPE_CODE
GL_ACCT_MST	GL_ACCT_USG	GL_ACCT_MST.ACCT_USAGE_CODE
GL_ACCT_MST	GL_PLCY_MST	GL_ACCT_MST.CO_CODE
GL_ACCT_MST	GL_TEXT_HDR	GL_ACCT_MST.TEXT_CODE
GL_ACCT_MST	SY_UOMS_MST	GL_ACCT_MST.QUANTITY_UM
GL_ACCT_KEY	GL_ACCT_MST	GL_ACCT_KEY.CO_CODE GL_ACCT_KEY.ACCT_NO
GL_ACCT_MAP	GL_ACCT_MST	GL_ACCT_MAP.ACCT_ID
GL_ACCT_VAL	GL_ACCT_MST	GL_ACCT_VAL.CO_CODE GL_ACCT_VAL.ACCT_NO
GL_SUBR_LED	GL_ACCT_MST	GL_SUBR_LED.ACCT_ID
GL_SUBR_TST	GL_ACCT_MST	GL_SUBR_TST.ACCT_ID
PO_DIST_DTL	GL_ACCT_MST	PO_DIST_DTL.ACCT_ID