JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

SalesTerritory

Return a list of: SalesTerritory

Columns

Name Type Description
ExtensionsExtensionAggregate String
Country String
CreatedDate Datetime
Description String
HistoryOptionsExtensionsExtensionAggregate String
HistoryOptionsKeepCalendar Bool
HistoryOptionsKeepPeriod Bool
IsActive Bool
Id [KEY] String
ModifiedDate Datetime
SalesHistoryAggregate String
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