# 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_ORG_ID, COST_BOOK_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 |  |  | This column is for Oracle Internal use only. 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, 2026, Oracle and/or its affiliates.