Power BI Connector for FinancialForce

Build 21.0.7930

Quote

This is a table representing the Quote entities in FinancialForce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the Quote.

IsDeleted Boolean True

Label Deleted corresponds to this field.

Name String False

Label Quote Name 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.

LastViewedDate Datetime True

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True

Label Last Referenced Date corresponds to this field.

OpportunityId String False

Opportunity.Id

Label Opportunity ID corresponds to this field.

Pricebook2Id String False

Pricebook2.Id

Label Price Book ID corresponds to this field.

ContactId String False

Contact.Id

Label Contact ID corresponds to this field.

QuoteNumber String True

Label Quote Number corresponds to this field.

IsSyncing Boolean True

Label Syncing corresponds to this field.

ShippingHandling Double False

Label Shipping and Handling corresponds to this field.

Tax Double False

Label Tax corresponds to this field.

Status String False

Label Status corresponds to this field.

ExpirationDate Datetime False

Label Expiration Date corresponds to this field.

Description String False

Label Description corresponds to this field.

Subtotal Double True

Label Subtotal corresponds to this field.

TotalPrice Double True

Label Total Price corresponds to this field.

LineItemCount Int True

Label Line Items corresponds to this field.

BillingStreet String False

Label Bill To Street corresponds to this field.

BillingCity String False

Label Bill To City corresponds to this field.

BillingState String False

Label Bill To State/Province corresponds to this field.

BillingPostalCode String False

Label Bill To Zip/Postal Code corresponds to this field.

BillingCountry String False

Label Bill To Country corresponds to this field.

BillingLatitude Double False

Label Bill To Latitude corresponds to this field.

BillingLongitude Double False

Label Bill To Longitude corresponds to this field.

ShippingStreet String False

Label Ship To Street corresponds to this field.

ShippingCity String False

Label Ship To City corresponds to this field.

ShippingState String False

Label Ship To State/Province corresponds to this field.

ShippingPostalCode String False

Label Ship To Zip/Postal Code corresponds to this field.

ShippingCountry String False

Label Ship To Country corresponds to this field.

ShippingLatitude Double False

Label Ship To Latitude corresponds to this field.

ShippingLongitude Double False

Label Ship To Longitude corresponds to this field.

QuoteToStreet String False

Label Quote To Street corresponds to this field.

QuoteToCity String False

Label Quote To City corresponds to this field.

QuoteToState String False

Label Quote To State/Province corresponds to this field.

QuoteToPostalCode String False

Label Quote To Zip/Postal Code corresponds to this field.

QuoteToCountry String False

Label Quote To Country corresponds to this field.

QuoteToLatitude Double False

Label Quote To Latitude corresponds to this field.

QuoteToLongitude Double False

Label Quote To Longitude corresponds to this field.

AdditionalStreet String False

Label Additional To Street corresponds to this field.

AdditionalCity String False

Label Additional To City corresponds to this field.

AdditionalState String False

Label Additional To State/Province corresponds to this field.

AdditionalPostalCode String False

Label Additional To Zip/Postal Code corresponds to this field.

AdditionalCountry String False

Label Additional To Country corresponds to this field.

AdditionalLatitude Double False

Label Additional To Latitude corresponds to this field.

AdditionalLongitude Double False

Label Additional To Longitude corresponds to this field.

BillingName String False

Label Bill To Name corresponds to this field.

ShippingName String False

Label Ship To Name corresponds to this field.

QuoteToName String False

Label Quote To Name corresponds to this field.

AdditionalName String False

Label Additional To Name corresponds to this field.

Email String False

Label Email corresponds to this field.

Phone String False

Label Phone corresponds to this field.

Fax String False

Label Fax corresponds to this field.

Discount Double True

Label Discount corresponds to this field.

GrandTotal Double True

Label Grand Total corresponds to this field.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930