Costing Revenue Lines

The Costing Revenue Lines view object contains the revenue line details for the invoice or credit memo lines specific to the business unit level,transferred by the Cost of Goods Sold Processor and to be utilized for the COGS or RMA Recognition.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstRevenueLinesExtractPVO

Primary Keys : RevenueLinesPEORevenueLineId

Initial Extract Date : RevenueLinesPEOCreationDate

Incremental Extract Date : RevenueLinesPEOLastUpdateDate

Attributes

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

Name	Description
RevenueLinesPEOAcctdAmount	Accounted amount in the functional currency.
RevenueLinesPEOAtoTopModelFlineId	Value that uniquely identifies the ATO model fulfillment line. In the case of a nested ATO, it identifies the top-level ATO model fulfillment line.
RevenueLinesPEOAtoTopModelItemId	Value that uniquely identifies the ATO model item. In the case of a nested ATO, it identifies the top-level ATO model item.
RevenueLinesPEOBillToCustomerId	Value that uniquely identifies the bill to customer.
RevenueLinesPEOBillToSiteUseId	Value that uniquely identifies the bill to site.
RevenueLinesPEOBusinessUnitId	Value that uniquely identifies the billing or selling business unit.
RevenueLinesPEOConfigInventoryItemId	Value that uniquely identifies the configured item in the shippable ATO.
RevenueLinesPEOCreatedBy	User who created the cost revenue line.
RevenueLinesPEOCreationDate	Date and time when the revenue line was created.
RevenueLinesPEOCustomerTrxId	Value that uniquely identifies the customer transaction.
RevenueLinesPEOCustomerTrxLineId	Value that uniquely identifies the invoice transaction line.
RevenueLinesPEODeliveryId	Value that's used to store the associated delivery or RMA receipt transaction.
RevenueLinesPEODocumentType	Value that identifies the invoice and credit memo.
RevenueLinesPEODooFlinePriceAdjustmentId	Value that uniquely identifies the discount value for the item or manual price adjustment.
RevenueLinesPEODooFulfillLineId	Value that uniquely identifies the distributed order orchestration fulfillment key.
RevenueLinesPEODooOrderNumber	Distributed order orchestration order number.
RevenueLinesPEODooOrderType	Distributed order orchestration order type.
RevenueLinesPEODooReferenceFulfillLineId	Value that uniquely identifies the distributed order orchestration reference fulfillment line.
RevenueLinesPEOExtendedAmount	The transaction line extended amount.
RevenueLinesPEOExternalSystemRefId	Value that uniquely identifies the unique transaction in the source system.
RevenueLinesPEOExternalSystemReference	Value that uniquely identifies the external source system.
RevenueLinesPEOGlDate	General ledger date.
RevenueLinesPEOGrossMarginFlag	Indicates if the gross margin calculations have been done for the revenue line. Values are: N and R indicates Not processed, NULL indicates processed for gross margin calculations, U indicates that the inventory organization identifier is updated on already processed revenue line by the Create Cost Accounting Distributions process, P indicates that the inventory organization identifier isn't available on the costing revenue line and inventory organization identifier in Distributed Order Orchestration isn't associated to any cost organization.
RevenueLinesPEOInventoryItemId	Value that uniquely identifies the inventory item.
RevenueLinesPEOInventoryOrgId	Value that uniquely identifies the organization for the revenue line.
RevenueLinesPEOInvoiceCurrencyCode	Currency code for the invoice.
RevenueLinesPEOInvoiceDate	Creation date for the invoice.
RevenueLinesPEOInvoiceLineAmount	Invoice line amount for this record in the invoice currency.
RevenueLinesPEOInvoiceNumber	Line number of the invoice.
RevenueLinesPEOInvoiceSource	Source of the invoice.
RevenueLinesPEOLastUpdateDate	Date and time when the revenue line was last updated.
RevenueLinesPEOLastUpdateLogin	Session login associated with the user who last updated the cost revenue line.
RevenueLinesPEOLastUpdatedBy	User who last updated the cost revenue line.
RevenueLinesPEOLedgerId	Value that uniquely identifies the distinct ledger values corresponding to the receivables ledger lines.
RevenueLinesPEOLegalEntityId	Value that uniquely identifies the distinct legal entity values corresponding to the receivables revenue lines.
RevenueLinesPEOLoadRequestId	Value that uniquely identifies the load request used by file based data import process.
RevenueLinesPEOParentFulfillLineId	Value that uniquely identifies the parent fulfillment line for the model.
RevenueLinesPEOPostedFlag	The option that indicates if the revenue lines were posted. Possible values: Y-Yes, N-No
RevenueLinesPEOPreviousCustomerTrxId	Value that uniquely identifies the previous customer transaction.
RevenueLinesPEOPreviousCustomerTrxLineId	Value that uniquely identifies the previous invoice transaction line.
RevenueLinesPEOQuantityInvoiced	Quantity that was invoiced.
RevenueLinesPEOReferenceLineId	Value that uniquely identifies the reference line.
RevenueLinesPEORevenueAccount	Value that uniquely identifies the sales representative related code combination.
RevenueLinesPEORevenueAmount	Transaction line revenue amount.
RevenueLinesPEORevenueLineId	Value that uniquely identifies the revenue distribution auto created within costing. This is the primary key for the Costing Revenue Lines view object.
RevenueLinesPEORevenuePercentage	Transaction line revenue percentage.
RevenueLinesPEORootParentFulfillLineId	Value that uniquely identifies the root parent fulfillment line for the model.
RevenueLinesPEOTxnProcessingGroupId	Value that uniquely identifies the transaction processing group.
RevenueLinesPEOUnitSellingPrice	Selling price per unit for the transaction line.
RevenueLinesPEOUomCode	Code for the unit of measure.
RevenueLinesPEOWarehouseId	Value that uniquely identifies the inventory organization for the ship-from location.