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 |