CST_COST_ORG_BOOKS
This table contains the Cost organization and cost book association. It describes the Ledger, calendar, currency, accounting attributes of the defined cost-org book.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_COST_ORG_BOOKS_PK |
COST_ORG_ID, COST_BOOK_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Yes | Cost Organization Identifier. Cost Books are assigned to this Cost Organization | Active | ||
| CALENDAR_ID | NUMBER | 18 | Yes | CALENDAR_ID | |||
| COST_BOOK_ID | NUMBER | 18 | Yes | Cost Book Identiifier | Active | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | ||
| LEDGER_ID | NUMBER | 18 | 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. A Null value indicates Ledger-less cost organization and cost book entity, which may be used for costing simulations. | Active | |||
| PRIMARY_BOOK_FLAG | VARCHAR2 | 1 | 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, | Active | |||
| CONVERSION_TYPE | VARCHAR2 | 30 | Yes | Identifies the conversion type used for currency exchange requirements. | Active | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Identifies the currency used for representing the value of transactions in the cost organization, cost book and ledger setup. If Leder is specified, it takes the default curreny of Ledger | Active | ||
| MAINTAIN_TRANSACTIONS_FLAG | VARCHAR2 | 1 | Y - Indicates that transactions would be maintained for the cost organization, book and ledger setup. | Active | |||
| CREATE_ACCOUNTING_FLAG | VARCHAR2 | 1 | Y - Indicates that accounting entries would be created in SLA for the transactions asssociated with this cost organization, book and ledger setup. | Active | |||
| INACTIVE_DATE | DATE | Date on which this setup of cost organization, book and ledger would get deactivated and no further costing will be done for this book. All historical data for this book can still be viewed. | Active | ||||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | Active | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Organization Book (CST_COST_ORG_BOOKS) | ||||
| FIRST_LEDGER_PERIOD_NAME | VARCHAR2 | 15 | Yes | Single column FK: 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. | |||
| OPEN_PERIODS_NUM | NUMBER | 9 | This indicates the maximum number of concurrent open periods allowed within cost management. | ||||
| FROM_DATE | DATE | Yes | This identifies the Cost Org-Cost Book association start date | ||||
| TO_DATE | DATE | This identifies the Cost Org-Cost Book association end date | |||||
| CD_CONVERSION_TYPE | VARCHAR2 | 30 | Identifies the conversion type used for constant dollar amount calculations in business intelligence reports. | ||||
| USD_CONVERSION_TYPE | VARCHAR2 | 30 | Identifies the conversion type used for US dollar amount calculations in business intelligence reports. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_COST_ORG_BOOKS | cst_cost_books_b | COST_BOOK_ID |
| cst_period_statuses | cst_cost_org_books | COST_ORG_ID, COST_BOOK_ID |
| cst_cost_distributions | cst_cost_org_books | COST_ORGANIZATION_ID, COST_BOOK_ID |
| cst_period_close_actions | cst_cost_org_books | COST_ORG_ID, COST_BOOK_ID |
| cst_default_cost_profiles | cst_cost_org_books | COST_ORG_ID, COST_BOOK_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_COST_ORG_BOOKS_N1 | Non Unique | Default | LAST_UPDATE_DATE |
| CST_COST_ORG_BOOKS_PK | Unique | Default | COST_ORG_ID, COST_BOOK_ID |