DBA Data[Home] [Help] [Dependency Information]

TABLE: GMF.GL_ACCT_TYP

Object Details
Object Name: GL_ACCT_TYP
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.GL_ACCT_TYP
Subobject Name:
Status: VALID


This table consists of four pre-defined General Ledger account types
which are used to classify accounts into four broad categories. This
table is not used with Oracle Financials integration.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_ACCT_TYP_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnACCT_TYPE_CODE
GL_ACCT_TYP_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnACCT_TYPE
Columns
Name Datatype Length Mandatory Comments
ACCT_TYPE NUMBER (5) Yes Surrogate to ACCT_TYPE_CODE
ACCT_TYPE_CODE VARCHAR2 (4) Yes Account Type Code. A = Asset; L = Liabilities; E = Equity; O = Operating
ACCT_TYPE_DESC1 VARCHAR2 (70)
Account Type Description
ACCT_TYPE_DESC2 VARCHAR2 (16)
Short Account Type Description
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 (10)
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 (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
Query Text

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


SELECT ACCT_TYPE
,      ACCT_TYPE_CODE
,      ACCT_TYPE_DESC1
,      ACCT_TYPE_DESC2
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GMF.GL_ACCT_TYP;

Dependencies

[top of page]

GMF.GL_ACCT_TYP does not reference any database object

GMF.GL_ACCT_TYP is referenced by following:

SchemaAPPS
SynonymGL_ACCT_TYP