Tableau Connector for Microsoft Dynamics CRM

Build 24.0.9060

SalesOrder

This is a table representing the SalesOrder entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the sales order.

AccountId_Id String True

Unique identifier of the account associated with the order.

AccountId_LogicalName String True

AccountId_Name String True

BillTo_AddressId String False

Unique identifier of the billing address.

BillTo_City String False

City name in the billing address.

BillTo_ContactName String False

Contact name for the billing address.

BillTo_Country String False

Country/region name in the billing address.

BillTo_Fax String False

Fax number for the billing address.

BillTo_Line1 String False

First line for entering billing address information.

BillTo_Line2 String False

Second line for entering billing address information.

BillTo_Line3 String False

Third line for entering billing address information.

BillTo_Name String False

Name to enter for the billing address.

BillTo_PostalCode String False

ZIP Code or postal code in the billing address.

BillTo_StateOrProvince String False

State or province in the billing address.

BillTo_Telephone String False

Telephone number associated with the billing address.

CampaignId_Id String False

Unique identifier of the source campaign associated with the order.

CampaignId_LogicalName String False

CampaignId_Name String False

ContactId_Id String True

Unique identifier of the contact associated with the order.

ContactId_LogicalName String True

ContactId_Name String True

CreatedBy_Id String True

Unique identifier of the user who created the order.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the order was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the salesorder.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CustomerId_Id String False

Unique identifier for the account or contact associated with the order.

CustomerId_LogicalName String False

CustomerId_Name String False

DateFulfilled Datetime False

Date on which the order was fulfilled.

Description String False

Description of the order.

DiscountAmount Double False

Discount specified as a monetary amount for the order.

DiscountAmount_Base Double True

Base currency equivalent of the discount specified as a monetary amount for the order.

DiscountPercentage Double False

Discount specified as a percentage for the order.

ExchangeRate Double True

Exchange rate for the currency associated with the sales order with respect to the base currency.

FreightAmount Double False

Cost of freight for the order.

FreightAmount_Base Double True

Base currency equivalent of the cost of freight for the order.

FreightTermsCode String False

Freight terms for the order.

ImportSequenceNumber Integer False

Unique identifier of the data import or data migration that created this record.

IsPriceLocked Boolean True

Information that specifies whether the order pricing is locked.

LastBackofficeSubmit Datetime False

Date and time when the order was last submitted to Microsoft Great Plains.

ModifiedBy_Id String True

Unique identifier of the user who last modified the order.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the order was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the salesorder.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the order.

OpportunityId_Id String False

Unique identifier of the opportunity with which the order is associated.

OpportunityId_LogicalName String False

OpportunityId_Name String False

OrderNumber String False

Order number.

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

Unique identifier of the user or team who owns the order.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the order.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the order.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the order.

OwningUser_LogicalName String True

OwningUser_Name String True

PaymentTermsCode String False

Payment terms for the order.

PriceLevelId_Id String False

Unique identifier of the price list associated with the order.

PriceLevelId_LogicalName String False

PriceLevelId_Name String False

PricingErrorCode String False

Pricing error for the order.

PriorityCode String False

Priority of the order.

QuoteId_Id String False

Unique identifier of the quote from which the order was created.

QuoteId_LogicalName String False

QuoteId_Name String False

RequestDeliveryBy Datetime False

Requested delivery date for the order.

SalesOrderId String False

Unique identifier of the order.

ShippingMethodCode String False

Method of shipment for the order.

ShipTo_AddressId String False

Unique identifier of the shipping address.

ShipTo_City String False

City name in the shipping address.

ShipTo_ContactName String False

Contact name for the shipping address.

ShipTo_Country String False

Country/region name in the shipping address.

ShipTo_Fax String False

Fax number for the shipping address.

ShipTo_FreightTermsCode String False

Freight terms for the shipping address.

ShipTo_Line1 String False

First line for entering shipping address information.

ShipTo_Line2 String False

Second line for entering shipping address information.

ShipTo_Line3 String False

Third line for entering shipping address information.

ShipTo_Name String False

Name to enter for the shipping address.

ShipTo_PostalCode String False

ZIP Code or postal code in the shipping address.

ShipTo_StateOrProvince String False

State or province in the shipping address.

ShipTo_Telephone String False

Telephone number associated with the shipping address.

StateCode String True

Status of the order.

StatusCode String False

Reason for the status of the order.

SubmitDate Datetime False

Date on which the order was submitted.

SubmitStatus Integer False

Submittal status for the order.

SubmitStatusDescription String False

Description of the submittal status for the order.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TotalAmount Double True

Total amount for the order.

TotalAmount_Base Double True

Base currency equivalent of the total amount for the order.

TotalAmountLessFreight Double True

Total amount minus the freight charges for the order.

TotalAmountLessFreight_Base Double True

Base currency equivalent of the total amount minus the freight charges for the order.

TotalDiscountAmount Double True

Total discount for the order.

TotalDiscountAmount_Base Double True

Base currency equivalent of the total discount for the order.

TotalLineItemAmount Double True

Total line item amount for the order.

TotalLineItemAmount_Base Double True

Base currency equivalent of the total line item amount for the order.

TotalLineItemDiscountAmount Double True

Total line item discount for the order.

TotalLineItemDiscountAmount_Base Double True

Base currency equivalent of the total line item discount for the order.

TotalTax Double True

Total tax for the order.

TotalTax_Base Double True

Base currency equivalent of the total tax for the order.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the sales order.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCConversionTimeZoneCode Integer False

Time zone code that was in use when the record was created.

WillCall Boolean False

Information that specifies whether the customer will call for the ordered products or the products are to be shipped.

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