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.

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

TABLE: GL.GL_COA_MAPPINGS

Object Details

Object Name:	GL_COA_MAPPINGS
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_COA_MAPPINGS
Subobject Name:
Status:	VALID

GL_COA_MAPPINGS stores the chart of accounts mappings defined in the Chart of Accounts Mappings form. Each row includes the name, from chart of accounts, to chart of accounts, and description of the mapping. There is a one-to-many relationship between the chart of accounts mappings stored in this table and the detail mapping information stored in the GL_CONS_FLEXFIELD_MAP and GL_CONS_SEGMENT_MAP tables.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_COA_MAPPINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COA_MAPPING_ID
GL_COA_MAPPINGS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME

Columns

Name	Datatype	Length	Mandatory	Comments
COA_MAPPING_ID	NUMBER	(15)	Yes	Key flexfield structure mapping defining column
TO_COA_ID	NUMBER	(15)	Yes	Target key flexfield structure defining column
FROM_COA_ID	NUMBER	(15)	Yes	Source key flexfield structure defining column
NAME	VARCHAR2	(33)	Yes	Chart of accounts mapping name
SECURITY_FLAG	VARCHAR2	(1)	Yes	Enable definition access set security flag
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
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
DESCRIPTION	VARCHAR2	(240)		Description
START_DATE_ACTIVE	DATE			Date after which the chart of accounts mapping is active
END_DATE_ACTIVE	DATE			Date before which the chart of accounts mapping is active

Query Text

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


SELECT COA_MAPPING_ID
,      TO_COA_ID
,      FROM_COA_ID
,      NAME
,      SECURITY_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM GL.GL_COA_MAPPINGS;

Dependencies

[top of page]

GL.GL_COA_MAPPINGS does not reference any database object

GL.GL_COA_MAPPINGS is referenced by following:

GL: GL_COA_MAPPINGS#