"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"
Module: Cost Management
COST_BOOK_ID, COST_ORG_ID
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 |