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: TableGMF.GL_PLCY_MST
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_PLCY_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCO_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.
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
MTL_ANALYSIS_CODE#1 VARCHAR2 (32) Yes Material Analysis code #1
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
,      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
,      MTL_ANALYSIS_CODE#1
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:

SchemaGMF
ViewGL_PLCY_MST#