JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

SalesTerritorySalesHistory

Return a list of: SalesTerritorySalesHistory

Columns

Name Type Description
ExtensionsExtensionAggregate String
Country String
CreatedDate Datetime
Description String
HistoryOptionsExtensionsExtensionAggregate String
HistoryOptionsKeepCalendar Bool
HistoryOptionsKeepPeriod Bool
IsActive Bool
Id String
ModifiedDate Datetime
SalesHistoryExtensionsExtensionAggregate String
SalesHistoryCommissionSummaryExtensionsExtensionAggregate String
SalesHistoryCommissionSummaryCommissionedSalesCurrency String
SalesHistoryCommissionSummaryCommissionedSales Decimal
SalesHistoryCommissionSummaryCostOfSalesCurrency String
SalesHistoryCommissionSummaryCostOfSales Decimal
SalesHistoryCommissionSummaryNoncommissionedSalesCurrency String
SalesHistoryCommissionSummaryNoncommissionedSales Decimal
SalesHistoryCommissionSummaryTotalCommissionsAmountCurrency String
SalesHistoryCommissionSummaryTotalCommissionsAmount Decimal
SalesHistoryKeyPeriod [KEY] Int
SalesHistoryKeySalesTerritoryId [KEY] String
SalesHistoryKeySummaryType [KEY] String
SalesHistoryKeyYear [KEY] Int
SalesManagerFirstName String
SalesManagerId String
SalesManagerLastName String
SalesManagerMiddleName String
SalesSummaryExtensionsExtensionAggregate String
SalesSummaryLastYearExtensionsExtensionAggregate String
SalesSummaryLastYearCommissionedSalesCurrency String
SalesSummaryLastYearCommissionedSales Decimal
SalesSummaryLastYearCostOfSalesCurrency String
SalesSummaryLastYearCostOfSales Decimal
SalesSummaryLastYearNoncommissionedSalesCurrency String
SalesSummaryLastYearNoncommissionedSales Decimal
SalesSummaryLastYearTotalCommissionsAmountCurrency String
SalesSummaryLastYearTotalCommissionsAmount Decimal
SalesSummaryYearToDateExtensionsExtensionAggregate String
SalesSummaryYearToDateCommissionedSalesCurrency String
SalesSummaryYearToDateCommissionedSales Decimal
SalesSummaryYearToDateCostOfSalesCurrency String
SalesSummaryYearToDateCostOfSales Decimal
SalesSummaryYearToDateNoncommissionedSalesCurrency String
SalesSummaryYearToDateNoncommissionedSales Decimal
SalesSummaryYearToDateTotalCommissionsAmountCurrency String
SalesSummaryYearToDateTotalCommissionsAmount Decimal

Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462