Results for “gl_acct_typ”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_ACCT_TYP is a reference (lookup) table owned by the GMF schema within Oracle Process Manufacturing Financials. It stores four pre-defined General Ledger account types that classify general ledger accounts into four broad categories: asset, liability, equity, and revenue/expense. Because the set of values is fixed and small, the table functions as a controlled vocabulary rather than a transactional store. The ETRM documentation explicitly notes that this table is not used with the Oracle Financials integrated setup; it exists to support the GMF (Process Manufacturing Financials) accounting model independently of the standard GL integration. Physically, the object comprises 12 columns and is defined with two unique indexes: GL_ACCT_TYP_PK on ACCT_TYPE_CODE and GL_ACCT_TYP_U1 on ACCT_TYPE.

From a Data Vault modeling perspective, the documented foreign key structure (this table referencing GL_TEXT_HDR, and being referenced by GL_ACCT_MST) is heuristic-classified as satellite-leaning. In practice, GL_ACCT_TYP behaves as a small reference or classification entity whose descriptive attributes and text-code linkage can be modeled as a satellite attached to the account-type business key.

Key Information Stored

The most significant columns documented for this table are:

• ACCT_TYPE_CODE — the primary key column and the surrogate/business key used by referencing tables; enforced by GL_ACCT_TYP_PK.
• ACCT_TYPE — the descriptive account-type identifier, enforced as a unique business key by GL_ACCT_TYP_U1.
• ACCT_TYPE_DESC1 — primary description text for the account type.
• ACCT_TYPE_DESC2 — secondary/additional description text.
• TEXT_CODE — foreign key to GL_TEXT_HDR, linking the account type to a text header record.
• TRANS_CNT — transaction count/usage indicator associated with the account type.
• DELETE_MARK — soft-delete flag indicating logical removal without physical deletion.
• CREATION_DATE, CREATED_BY — audit columns capturing row creation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns capturing the most recent modification and session context.

The distinction between the primary key (ACCT_TYPE_CODE) and the unique business key (ACCT_TYPE) is important: referential integrity from dependent tables is anchored on ACCT_TYPE_CODE, while ACCT_TYPE provides an alternate unique lookup path.

Common Use Cases and Queries

Typical usage centers on classifying accounts and validating account-type references during GMF setup and reporting. A common pattern retrieves the full classification set for display or validation:

• Listing all active account types: SELECT ACCT_TYPE_CODE, ACCT_TYPE, ACCT_TYPE_DESC1 FROM GMF.GL_ACCT_TYP WHERE DELETE_MARK = 0;
• Resolving account classification for a given account via the referencing table: SELECT m.ACCT_TYPE_CODE, t.ACCT_TYPE_DESC1 FROM GMF.GL_ACCT_MST m JOIN GMF.GL_ACCT_TYP t ON m.ACCT_TYPE_CODE = t.ACCT_TYPE_CODE;
• Joining to the text header for descriptive text: SELECT a.ACCT_TYPE_CODE, h.* FROM GMF.GL_ACCT_TYP a JOIN GL_TEXT_HDR h ON a.TEXT_CODE = h.TEXT_CODE;

Because the table holds only four pre-defined rows, it is frequently used as a decode source in reporting and as a validation list in account maintenance screens.

Related Objects

The documented foreign key relationships define the principal dependencies:

• GL_TEXT_HDR — referenced by GL_ACCT_TYP.TEXT_CODE; supplies associated text header records.
• GL_ACCT_MST — references GL_ACCT_TYP.ACCT_TYPE_CODE; the master account table that consumes the account-type classification.

These relationships establish GL_ACCT_TYP as an upstream classification reference for GL_ACCT_MST and a downstream consumer of GL_TEXT_HDR, positions confirmed by the ETRM FK metadata.