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

TABLE: GMF.GL_ACCT_VAL

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


This table contains validation codes assigenment to Accounts. The
Accounts may only be auto-generated with the Accounting unit with
same Validation codes. 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_VAL_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCO_CODE
ColumnACCT_NO
ColumnVALIDATION_CODE
Columns
Name Datatype Length Mandatory Comments
CO_CODE VARCHAR2 (4) Yes Company of the Account
ACCT_NO VARCHAR2 (240) Yes Account Number
VALIDATION_CODE VARCHAR2 (4) Yes Validation Code assigned to the Account
INCLUDE_FLAG NUMBER (5) Yes Auto-genarate the Account Key for this Account. 0 = Exclude for account key auto-generation; 1 = Include for account key auto-generation
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 CO_CODE
,      ACCT_NO
,      VALIDATION_CODE
,      INCLUDE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GMF.GL_ACCT_VAL;

Dependencies

[top of page]

GMF.GL_ACCT_VAL does not reference any database object

GMF.GL_ACCT_VAL is referenced by following:

SchemaGMF
ViewGL_ACCT_VAL#