Cost Accounting Only Transactions

The Cost Accounting Only Transactions view object contains the accounting only transactions created by the Create Cost Accounting Distributions process for events with no physical movement of items such as invoices to expense. The accounting only transactions are created specific to the cost organization and books and are created in the currency of the ledger as defined by the cost organization book combination.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstAcctgOnlyTxnsExtractPVO

Primary Keys : CstAcctgOnlyTxnsPEOAcctgOnlyTxnsId

Initial Extract Date : CstAcctgOnlyTxnsPEOCreationDate

Incremental Extract Date : CstAcctgOnlyTxnsPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CstAcctgOnlyTxnsPEOAccountingStatus	Indicates the accounting status of the transaction.
CstAcctgOnlyTxnsPEOAcctgOnlyTxnsId	Unique identifier of the Accounting Only Transaction row. This is the primary key of the Accounting Only Transactions view object.
CstAcctgOnlyTxnsPEOConsignedFlag	Indicates if the corresponding purchase order is a consigned PO.
CstAcctgOnlyTxnsPEOCostBookId	Unique identifier of the cost book associated to the cost organization. This is the primary key of the Cost Books view object.
CstAcctgOnlyTxnsPEOCostOrgId	Unique identifier of the cost organization associated to the plant where the accounting only transactions is executed.
CstAcctgOnlyTxnsPEOCostStatus	Indicates the costing status of the transaction.
CstAcctgOnlyTxnsPEOCreatedBy	User who created the accounting only transactions.
CstAcctgOnlyTxnsPEOCreationDate	Date and time when the accounting only transaction was created.
CstAcctgOnlyTxnsPEOCurrencyCode	Identifies currency of the amount for this accounting only transaction.
CstAcctgOnlyTxnsPEODistributionId	Unique identifier of the cost distribution header record. This is the primary key of the Cost Distributions view object.
CstAcctgOnlyTxnsPEOEntityCode	Reference to the entity code of the event.
CstAcctgOnlyTxnsPEOEventClassCode	Reference to event class for which the accounting template is defined.
CstAcctgOnlyTxnsPEOEventTypeCode	Reference to the event type for which the accounting template is defined.
CstAcctgOnlyTxnsPEOInventoryItemId	Identifies the Inventory Item for which this accounting only transaction is created.
CstAcctgOnlyTxnsPEOInventoryOrgId	Indicates the inventory org to which the item belongs.
CstAcctgOnlyTxnsPEOInvoiceToExpAmt	Identifies the amount to expense for this accounting only transaction.
CstAcctgOnlyTxnsPEOInvoiceToExpTxnId	Unique identifier of the invoice to expense transaction. This is the primary key of the Costing Invoice to Expense Transactions view object.
CstAcctgOnlyTxnsPEOLastUpdateDate	Date when the cost accounting only transaction row was last updated.
CstAcctgOnlyTxnsPEOLastUpdateLogin	Session login associated with the user who last updated the cost accounting only transaction row.
CstAcctgOnlyTxnsPEOLastUpdatedBy	User who last updated the cost accounting only transaction row.
CstAcctgOnlyTxnsPEOLeTimezoneCode	Legal Entity time zone. If NULL, then LE time zone isn't enabled for the data in the row and the dates are assumed to be in database time zone.
CstAcctgOnlyTxnsPEOPostedFlag	Indicates if the accounting only transaction has been accounted by the SLA. Possible values are: N, D, or F. N indicates not accounted. D indicates draft accounted. F indicates final accounted. The LOOKUP_TYPE for these values is CST_ACCOUNTED_FLAG.
CstAcctgOnlyTxnsPEOTransactionFlowType	Identifier of the transaction flow. A list of accepted values is defined in the lookup type ORA_CST_TRANSACTION_FLOW_TYPES.
CstAcctgOnlyTxnsPEOTxnAccountDate	Identifies the date to be used for accounting this accounting only transaction.