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_PLCY_MST

Object Details

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

Fiscal policy of a company. Fiscal policy defines the GL attributes
of the company.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_PLCY_MST_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CO_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CO_CODE	VARCHAR2	(4)	Yes	Company for which fiscal policy is defined
NUMBER_OF_OPEN_PERIODS	NUMBER	(5)	Yes	Max number of open periods allowed at one time for the company.
AUTO_LINK_FLAG	NUMBER	(5)		0=do not auto generate account keys; 1=do auto generate account keys. *** obsolete column ***
BASE_CURRENCY_CODE	VARCHAR2	(4)	Yes	Base currency of the company.
FRONT_CURR_IND	NUMBER	(5)		0=no currency conversion; 1=currency conversion. *** obsolete column ***
VOUCHER_REVERSAL_DAY	NUMBER	(5)		day in the period that a reversing voucher should be created. *** obsolete column ***
PRIMARY_LEDGER_CODE	VARCHAR2	(4)	Yes	ledger of the company.
UPD_OPEN_BAL	NUMBER	(5)		0=no entry of beginning balance in jv period; 1=entry in jv period.
SEGMENT_DELIMITER	VARCHAR2	(1)	Yes	symbol used to segregate account key information.
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.
DFLTS_IND	NUMBER	(5)		0=Do not check for account mapping defaults during Subledger Update; 1=Do check for account mapping defaults during Subledger Update.
SET_OF_BOOKS_NAME	VARCHAR2	(40)		The GL Set of Books that this company belongs to.
MTL_CMPNTCLS_ID	NUMBER	(10)	Yes	The Inventory cost component class for this company.
MTL_ANALYSIS_CODE	VARCHAR2	(4)	Yes	The Inventory cost analysis code for this company.
GL_COST_MTHD	VARCHAR2	(4)	Yes	The cost method used for this company.
CREV_CURR_MTHD	VARCHAR2	(4)		The current cost method for this company. Used during Inventory Cost Revaluation.
CREV_CURR_CALENDAR	VARCHAR2	(4)		The current cost calendar for this company. Used during Inventory Cost Revaluation
CREV_CURR_PERIOD	VARCHAR2	(4)		The current cost period for this calendar. Used during Inventory Cost Revaluation
CREV_PRIOR_MTHD	VARCHAR2	(4)		The prior cost method for this company. Used during Inventory Cost Revaluation
CREV_PRIOR_CALENDAR	VARCHAR2	(4)		The prior cost calendar for this company. Used during Inventory Cost Revaluation
CREV_PRIOR_PERIOD	VARCHAR2	(4)		The prior cost period for this company. Used during Inventory Cost Revaluation
GL_TRANS_DATE	DATE			The default GL Transaction date used in Subledger Update for this company. Used during Inventory Cost Revaluation
COST_BASIS	NUMBER		Yes	The cost basis for this company.
SOB_ID	NUMBER	(10)		GL Set of Books Identifier
OPERATING_UNIT	VARCHAR2	(60)		GL Operating Unit
ORG_ID	NUMBER	(10)		GL Organization Identifier
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE19	VARCHAR2	(240)		Descriptive FlexfieldDescriptive Flexfield
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity Identifier
MIGRATED_IND	VARCHAR2	(1)		Migration Indicator
NEW_LEGAL_ENTITY_NAME	VARCHAR2	(240)		New Legal Entity Name
NEW_LE_COST_MTHD_CODE	VARCHAR2	(10)		New Cost Method Code
NEW_LE_FLAG	VARCHAR2	(1)		Legal Entity Migration Flag

Query Text

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


SELECT CO_CODE
,      NUMBER_OF_OPEN_PERIODS
,      AUTO_LINK_FLAG
,      BASE_CURRENCY_CODE
,      FRONT_CURR_IND
,      VOUCHER_REVERSAL_DAY
,      PRIMARY_LEDGER_CODE
,      UPD_OPEN_BAL
,      SEGMENT_DELIMITER
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      DFLTS_IND
,      SET_OF_BOOKS_NAME
,      MTL_CMPNTCLS_ID
,      MTL_ANALYSIS_CODE
,      GL_COST_MTHD
,      CREV_CURR_MTHD
,      CREV_CURR_CALENDAR
,      CREV_CURR_PERIOD
,      CREV_PRIOR_MTHD
,      CREV_PRIOR_CALENDAR
,      CREV_PRIOR_PERIOD
,      GL_TRANS_DATE
,      COST_BASIS
,      SOB_ID
,      OPERATING_UNIT
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      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
,      LEGAL_ENTITY_ID
,      MIGRATED_IND
,      NEW_LEGAL_ENTITY_NAME
,      NEW_LE_COST_MTHD_CODE
,      NEW_LE_FLAG
FROM GMF.GL_PLCY_MST;

Dependencies

[top of page]

GMF.GL_PLCY_MST does not reference any database object

GMF.GL_PLCY_MST is referenced by following:

APPS: GL_PLCY_MST