DW_CST_COST_ORG_BOOKS_D

"This dimension table contains the Cost organization and cost book association. It describes the Ledger, calendar, currency, accounting attributes of the defined cost-org book"

Details

Module: Cost Management

Key Columns

COST_BOOK_ID, COST_ORG_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
COST_ORG_ID NUMBER 38 0 True Cost Organization Identifier. Cost Books are assigned to this Cost Organization DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
COST_BOOK_ID NUMBER 38 0 True Cost Book Identiifier DW_CST_COST_BOOKS_TL COST_BOOK_ID
SOURCE_RECORD_ID VARCHAR2 128     System Identifier    
LEDGER_ID NUMBER 38 0   "This is the unique Ledger corresponding to the cost organization and cost book. It can be Primary, Secondary or any other Ledger defined in Financial setups. When not populated it indicates Ledger-less cost organization and cost book entity, which may be used for costing simulations." DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER       Legal Entity Identifier DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
COST_ORG_CODE VARCHAR2 256     Cost org Code    
COST_BOOK_CODE VARCHAR2 32     Cost Book Code    
COST_ORG_STATUS VARCHAR2 32     Indicates if a cost organization is active or inactive. DW_ACTIVE_INACTIVE_LKP_TL ACTIVE_INACTIVE_LKP_CODE
CURRENCY_CODE VARCHAR2 16     "Identifies the currency used for representing the value of transactions in the cost organization, cost book and ledger setup. If Ledger is specified, it takes the default curreny of Ledger"    
PRIMARY_BOOK_FLAG VARCHAR2 16     "Identifies if the Cost Book has been associated with Primary/Secondary Ledger or its Ledger less book. This flag has three values as Primary Ledger - Y, Secondary Ledger -- N" DW_YN_LKP_TL YN_LKP_CODE
CREATE_ACCOUNTING_FLAG VARCHAR2 16     "Y - Indicates that accounting entries would be created in SLA for the transactions asssociated with this cost organization, book and ledger setup." DW_YN_LKP_TL YN_LKP_CODE
FIRST_LEDGER_PERIOD_NAME VARCHAR2 16     "This is the first period value of the associated accounting period set for cost transactions to be accounted in. It allows the costing period maintenance of open/close, etc for all subsequent periods including this period."    
FROM_DATE DATE       This identifies the Cost Org-Cost Book association start date    
TO_DATE DATE       This identifies the Cost Org-Cost Book association end date    
CALENDAR_NAME VARCHAR2 16     Period of time, extending from one date to another, defined by a party to quantify the fiscal position of the business. It can be divided into accounting periods.    
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Fiscal Period Set Name DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16     Period type. Examples are Weekly, Monthly, Quarterly DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE

Copyright © 2019, 2022, Oracle and/or its affiliates.