Cost of Goods Sold Transactions

The Cost of Goods Sold Transactions view object stores COGS and RMA recognition transactions created by the Create Cost Accounting Distributions process.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstCogsTransactionsExtractPVO

Primary Keys : CstCogsTransactionsPEOTransactionId

Initial Extract Date : CstCogsTransactionsPEOCreationDate

Incremental Extract Date : CstCogsTransactionsPEOLastUpdateDate

Attributes

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

Name	Description
CstCogsTransactionsPEOAccountingStatus	Value that identifies the accounting status of the transaction. Possible values are: D, E, F, N, X, and Z. D indicates draft accounted. E indicates error. F indicates final accounted. N indicates not accounted. X indicates excluded from accounting. Z indicates not applicable.
CstCogsTransactionsPEOCogsPercentage	Value that identifies the percentage of COGS and RMA recognition.
CstCogsTransactionsPEOCostBookId	The unique identifier of the cost book associated with the cost organization.
CstCogsTransactionsPEOCostOrgId	The unique identifier of the cost organization associated with the inventory organization.
CstCogsTransactionsPEOCostStatus	Value that identifies the costing status of the transaction. Possible values are: C, E, P, N, P, X, and W. C indicates fully costed. E indicates error. N indicates not processed. P indicates partially costed. X indicates excluded. W indicates pending.
CstCogsTransactionsPEOCreatedBy	User who created the COGS transaction row.
CstCogsTransactionsPEOCreationDate	Date when the COGS transaction row was created.
CstCogsTransactionsPEOCstTransactionId	Value that uniquely identifies the costing transaction. This is the primary key of the costing transactions view object.
CstCogsTransactionsPEODeliveryId	Value that uniquely identifies the delivery associated with the shipment transaction.
CstCogsTransactionsPEODocumentType	Value that identifies the revenue event. Possibles values are: INV, CM, DM, REV_CONTRACT, and NULL. INV indicates invoice. CM indicates credit memo. DM indicates debit memo. REV_CONTRACT indicates revenue contract. NULL Indicates this is for ship-only and return-only flows
CstCogsTransactionsPEOInventoryItemId	Value that uniquely identifies the inventory item.
CstCogsTransactionsPEOInventoryOrgId	Value that uniquely identifies the inventory organization to which the item belongs.
CstCogsTransactionsPEOLastUpdateDate	Date when the COGS transaction row was last updated.
CstCogsTransactionsPEOLastUpdateLogin	Session login associated with the user who last updated the COGS transaction row.
CstCogsTransactionsPEOLastUpdatedBy	User who last updated the COGS transaction row.
CstCogsTransactionsPEOLeTimezoneCode	Value that identifies the 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.
CstCogsTransactionsPEOPeriodName	Value that identifies the period in which the transaction is processed. This value is populated for transactions of items using the periodic average cost method.
CstCogsTransactionsPEOPostedFlag	Value that identifies whether the cost information for the COGS transaction is available in cst_cogs_layer_costs table. Possible values are: N and Y.N indicates the cost record isn't yet created. Y indicates the cost record is created.
CstCogsTransactionsPEORevenueLineId	Value that uniquely identifies the costing revenue line. This is the primary key of the costing revenue lines view object.
CstCogsTransactionsPEORmaTransactionId	Value that uniquely identifies the receipt associated with the RMA receipt transaction.
CstCogsTransactionsPEOShipmentFullfillLineId	Value that uniquely identifies the fulfillment line in distributed order orchestration against which sales order shipment or RMA receipt transactions have been performed. In case of split, it has the reference to the unique identifier of the source fulfillment line.
CstCogsTransactionsPEOTransactionActionId	Value that identifies the transaction action. Possible values are: 1 and 9. 1 indicates COGS recognition. 9 indicates RMA recognition.
CstCogsTransactionsPEOTransactionDate	Date of COGS and RMA recognition transactions.
CstCogsTransactionsPEOTransactionId	Value that uniquely identifies the COGS transaction. This is the primary key of the COGS transactions view object.
CstCogsTransactionsPEOTransactionSourceTypeId	Value that identifies the transaction source type. This will be 0 for both COGS and RMA recognition transactions.
CstCogsTransactionsPEOTransactionTypeId	Value that identifies the transaction type. Possible values are: 1 and 9. 1 indicates COGS recognition. 9 indicates RMA recognition.
CstCogsTransactionsPEOVariancePostedFlag	Value that identifies whether the variance cost information is available in cst_cogs_variance_costs table. Possible values are: N and Y. N indicates the cost record isn't yet created. Y indicates the cost record is created.