Tableau Connector for Salesforce

Build 25.0.9434

OrderSummary

Schema file for OrderSummary.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

OwnerId String False

ID of the user who owns the record.

OwnerIdType String False

Specifies the type of the 'OwnerId' polymorphic field to use in the statement.

OwnerIdExternalFieldName String False

Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

OrderNumber String False

Order identification number.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

LastReferencedDate Datetime True

Date and time when the record was last referenced.

OriginalOrderId String True

Order.Id

ID of the OriginalOrder associated with this record.

AccountId String True

Account.Id

ID of the Account associated with this record.

ChangeOrderId String True

Order.Id

ID of the ChangeOrder associated with this record.

BillingStreet String False

Street address for Billing purposes.

BillingCity String False

City for Billing address.

BillingState String False

State or province for Billing address.

BillingPostalCode String False

Postal code for Billing address.

BillingCountry String False

Country for Billing address.

BillingLatitude Double False

Latitude coordinate for Billing address geolocation.

BillingLongitude Double False

Longitude coordinate for Billing address geolocation.

BillingGeocodeAccuracy String False

Accuracy level of the geocode for the Billing address.

BillingEmailAddress String False

Field containing BillingEmailAddress information.

BillingPhoneNumber String False

BillingPhone identification number.

TaxLocaleType String True

Type classification for TaxLocale.

OrderedDate Datetime True

Date associated with Ordered.

Status String False

Status of the record.

Description String False

Text description of the record.

SalesStoreId String True

WebStore.Id

ID of the SalesStore associated with this record.

SalesStoreIdType String False

Specifies the type of the 'SalesStoreId' polymorphic field to use in the statement.

SalesStoreIdExternalFieldName String False

Specifies the external field name of the 'SalesStoreId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

SalesChannelId String True

SalesChannel.Id

ID of the SalesChannel associated with this record.

PoNumber String False

Po identification number.

PoDate Datetime False

Date associated with Po.

OrderLifeCycleType String True

Type classification for OrderLifeCycle.

BillToContactId String False

Contact.Id

ID of the BillToContact associated with this record.

ExternalReferenceIdentifier String False

Field containing ExternalReferenceIdentifier information.

IsSuspended Bool False

Indicates whether the record has the Suspended characteristic.

ActiveProcessExceptionCount Int True

Number of ActiveProcessException associated with this record.

RoutingAttempts Int False

Field containing RoutingAttempts information.

OrderProductLineCount Int True

Number of OrderProductLine associated with this record.

BusinessModel String False

Field containing BusinessModel information.

SourceProcess String True

Field containing SourceProcess information.

SourceOrderSummaryId String True

OrderSummary.Id

ID of the SourceOrderSummary associated with this record.

Pricebook2Id String True

Pricebook2.Id

ID of the Pricebook2 associated with this record.

OperationInProgress String True

Field containing OperationInProgress information.

EffectiveDate Date True

Date associated with Effective.

OriginalOrderName String True

Field containing OriginalOrderName information.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434