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: GMF.GL_ACCU_MAP

Object Details

Object Name:	GL_ACCU_MAP
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.GL_ACCU_MAP
Subobject Name:
Status:	VALID

This table contains the GL Account Unit Mapping information. The
Account Unit mapping are defined for a Company, Organization and
Warehouse. Organization and Warehouse are optional and a blank value
means all value. The GL Mapping program will try to select the
accounts with exact match of the Company, Organization and Warehouse.
If it fails, it tries the selection with the blank value of
Warehouse, and then with blank value of Organization till it finds
an Accounting Unit.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_ACCU_MAP_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCU_MAP_ID
GL_ACCU_MAP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CO_CODE ORGN_CODE WHSE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ACCU_MAP_ID	NUMBER	(15)	Yes	Surrogate for a row
ACCTG_UNIT_ID	NUMBER	(10)	Yes	Accounting Unit Surrogate.
CO_CODE	VARCHAR2	(4)	Yes	Company for which the mapping is defined
ORGN_CODE	VARCHAR2	(4)		Organization Code
WHSE_CODE	VARCHAR2	(4)		Warehouse Code
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.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfields
ATTRIBUTE_CATEGORY	VARCHAR2	(240)		Descriptive Flexfield
MIGRATED_IND	NUMBER	(2)		Migration Indicator

Query Text

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


SELECT ACCU_MAP_ID
,      ACCTG_UNIT_ID
,      CO_CODE
,      ORGN_CODE
,      WHSE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      MIGRATED_IND
FROM GMF.GL_ACCU_MAP;

Dependencies

[top of page]

GMF.GL_ACCU_MAP does not reference any database object

GMF.GL_ACCU_MAP is referenced by following:

APPS: GL_ACCU_MAP