SalespersonSalesHistory
Return a list of: SalespersonSalesHistory
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| AddressExtensionsExtensionAggregate | String | |
| AddressCity | String | |
| AddressLine1 | String | |
| AddressLine2 | String | |
| AddressLine3 | String | |
| AddressPostalCode | String | |
| AddressState | String | |
| AddressCountryRegion | String | |
| AddressFaxCountryCode | String | |
| AddressFaxExtension | String | |
| AddressFax | String | |
| AddressPhone1CountryCode | String | |
| AddressPhone1Extension | String | |
| AddressPhone1 | String | |
| AddressPhone2CountryCode | String | |
| AddressPhone2Extension | String | |
| AddressPhone2 | String | |
| AddressPhone3CountryCode | String | |
| AddressPhone3Extension | String | |
| AddressPhone3 | String | |
| CommissionBasedOn | String | |
| CommissionPercent | Decimal | |
| CreatedDate | Datetime | |
| EmployeeId | String | |
| FirstName | String | |
| HistoryOptionsExtensionsExtensionAggregate | String | |
| HistoryOptionsKeepCalendar | Bool | |
| HistoryOptionsKeepPeriod | Bool | |
| InternetAddressesAdditionalInformation | String | |
| InternetAddressesEmailBccAddress | String | |
| InternetAddressesEmailCcAddress | String | |
| InternetAddressesEmailToAddress | String | |
| InternetAddressesInternetField1 | String | |
| InternetAddressesInternetField2 | String | |
| InternetAddressesInternetField3 | String | |
| InternetAddressesInternetField4 | String | |
| InternetAddressesInternetField5 | String | |
| InternetAddressesInternetField6 | String | |
| InternetAddressesInternetField7 | String | |
| InternetAddressesInternetField8 | String | |
| InternetAddressesMessengerAddress | String | |
| IsActive | Bool | |
| Id | String | |
| LastName | String | |
| MiddleName | 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 | |
| SalesHistoryKeySalespersonId [KEY] | String | |
| SalesHistoryKeySummaryType [KEY] | String | |
| SalesHistoryKeyYear [KEY] | Int | |
| 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 | |
| SalesTerritoryId | String | |
| VendorId | String |
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 |