FND Design Data [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: TableGMF.GL_ACCT_MST
Primary Key: GL_ACCT_MST_PK
  1. ColumnACCT_ID
Primary Key: GL_ACCT_MST_U1
  1. ColumnCO_CODE
  2. ColumnACCT_NO
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_ACCT_MST FK Joins to TableGL_ACCT_CLS GL_ACCT_MST.ACCT_CLASS_CODE
GL_ACCT_MST FK Joins to TableGL_ACCT_TYP GL_ACCT_MST.ACCT_TYPE_CODE
GL_ACCT_MST FK Joins to TableGL_ACCT_USG GL_ACCT_MST.ACCT_USAGE_CODE
GL_ACCT_MST FK Joins to TableGL_PLCY_MST GL_ACCT_MST.CO_CODE
GL_ACCT_MST FK Joins to TableGL_TEXT_HDR GL_ACCT_MST.TEXT_CODE
GL_ACCT_MST FK Joins to TableSY_UOMS_MST GL_ACCT_MST.QUANTITY_UM
TableGL_ACCT_KEY FK Joins to GL_ACCT_MST GL_ACCT_KEY.CO_CODE
GL_ACCT_KEY.ACCT_NO
TableGL_ACCT_MAP FK Joins to GL_ACCT_MST GL_ACCT_MAP.ACCT_ID
TableGL_ACCT_VAL FK Joins to GL_ACCT_MST GL_ACCT_VAL.CO_CODE
GL_ACCT_VAL.ACCT_NO
TableGL_SUBR_LED FK Joins to GL_ACCT_MST GL_SUBR_LED.ACCT_ID
TableGL_SUBR_TST FK Joins to GL_ACCT_MST GL_SUBR_TST.ACCT_ID
TablePO_DIST_DTL FK Joins to GL_ACCT_MST PO_DIST_DTL.ACCT_ID