Cost Organization Books
The Cost Organization Books view object contains the relationship between the cost organization and cost book. It describes the ledger, calendar, currency, and accounting attributes of the defined cost organization and book.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CostOrgBooksExtractPVO
Primary Keys : CostOrgBookPEOCostBookId, CostOrgBookPEOCostOrgId
Initial Extract Date : CostOrgBookPEOCreationDate
Incremental Extract Date : CostOrgBookPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
CostOrgBookPEOAttributeCategory | Context name for Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar1 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar10 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar11 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar12 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar13 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar14 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar15 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar16 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar17 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar18 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar19 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar2 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar20 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar3 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar4 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar5 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar6 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar7 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar8 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeChar9 | Character segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeDate1 | Date segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeDate2 | Date segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeDate3 | Date segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeDate4 | Date segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeDate5 | Date segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber1 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber10 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber2 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber3 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber4 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber5 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber6 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber7 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber8 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeNumber9 | Number segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeTimestamp1 | Date and time segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeTimestamp2 | Date and time segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeTimestamp3 | Date and time segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeTimestamp4 | Date and time segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOAttributeTimestamp5 | Date and time segment for the Cost Organization Book descriptive flexfield. |
CostOrgBookPEOCalendarId | Value that uniquely identifies the calendar used. |
CostOrgBookPEOCdConversionType | Type of conversion used for constant dollar amount calculations in business intelligence reports. |
CostOrgBookPEOConversionType | Type of conversion used for currency exchange requirements. |
CostOrgBookPEOCostBookId | Value that uniquely identifies the cost book. This is the primary key of the Cost Books view object. |
CostOrgBookPEOCostOrgId | Value that uniquely identifies the cost organization. Cost books are assigned to this cost organization. |
CostOrgBookPEOCreateAccountingFlag | Contains one of the following values Y or N. If Y, then the accounting entries are created in SLA for the transactions associated with this cost organization, book, and ledger setup. If N, then the accounting entries aren't created in SLA for the transactions associated with this cost organization, book, and ledger setup. This attribute doesn't have a default value. |
CostOrgBookPEOCreatedBy | User who created the cost organization and book relationship. |
CostOrgBookPEOCreationDate | Date and time when the cost organization and book relationship was created. |
CostOrgBookPEOCurrencyCode | Code that 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 currency of the ledger. |
CostOrgBookPEOFirstLedgerPeriodName | First period of the associated accounting period set for cost transactions to be accounted in. It allows the costing period maintenance for this period and all subsequent periods. |
CostOrgBookPEOFromDate | Date when the cost organization and cost book association starts. |
CostOrgBookPEOInactiveDate | Date when 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. |
CostOrgBookPEOLastUpdateDate | Date when the cost organization and book relationship was last updated. |
CostOrgBookPEOLastUpdateLogin | Session login associated with the user who last updated the cost organization and book relationship. |
CostOrgBookPEOLastUpdatedBy | User who last updated the cost organization and book relationship. |
CostOrgBookPEOLedgerId | Value that uniquely identifies the 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 a cost organization and cost book entity without a ledger, which may be used for costing simulations. |
CostOrgBookPEOMaintainTransactionsFlag | Contains one of the following values Y or N. If Y, then the transactions would be maintained for the cost organization, cost book, and ledger setup. If N, then the transactions wouldn't be maintained for the cost organization, cost book, and ledger setup. This attribute doesn't have a default value. |
CostOrgBookPEOOpenPeriodsNum | Maximum number of concurrent open periods allowed within cost management for this cost organization and cost book association. |
CostOrgBookPEOPrimaryBookFlag | Contains one of the following values Y or N. If Y, then the ledger is a primary ledger. If N, then either the ledger is a secondary ledger or without a ledger. This attribute doesn't have a default value. |
CostOrgBookPEOToDate | Date when the cost organization and cost book association ends. |
CostOrgBookPEOUsdConversionType | Type of conversion used for US dollar amount calculations in business intelligence reports. |