Power BI Connector for Certinia

Build 24.0.9060

OpportunityLineItem

This is a table representing the OpportunityLineItem entities in FinancialForce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the OpportunityLineItem.

OpportunityId String False

Opportunity.Id

Label Opportunity ID corresponds to this field.

SortOrder Int True

Label Sort Order corresponds to this field.

PricebookEntryId String False

PricebookEntry.Id

Label Price Book Entry ID corresponds to this field.

Quantity Double False

Label Quantity corresponds to this field.

TotalPrice Double False

Label Total Price corresponds to this field.

UnitPrice Double False

Label Sales Price corresponds to this field.

ListPrice Double True

Label List Price corresponds to this field.

ServiceDate Datetime False

Label Date corresponds to this field.

Description String False

Label Line Description corresponds to this field.

CreatedDate Datetime True

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True

Label System Modstamp corresponds to this field.

IsDeleted Boolean True

Label Deleted corresponds to this field.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060