JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ServiceEquipmentReadings

Return a list of: ServiceEquipmentReadings

Columns

Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressContactPerson String
AddressCountry String
AddressId String
AssetTag String
CustomerId String
InstallDate Datetime
Id String
KeyItemId String
LastCalculatedDate Datetime
LastPreventiveMaintenanceDate Datetime
LastServiceDate Datetime
Note String
OfficeId String
PreventiveMaintenanceDay Int
PreventiveMaintenanceMonth String
Quantity Decimal
ReadingsExtensionsExtensionAggregate String
ReadingsKeySequenceNumber [KEY] Int
ReadingsKeyServiceEquipmentId [KEY] String
ReadingsKeyServiceEquipmentKeyItemId [KEY] String
ReadingsMeter1ExtensionsExtensionAggregate String
ReadingsMeter1CurrentReading Int
ReadingsMeter1Replaced Bool
ReadingsMeter2ExtensionsExtensionAggregate String
ReadingsMeter2CurrentReading Int
ReadingsMeter2Replaced Bool
ReadingsMeter3ExtensionsExtensionAggregate String
ReadingsMeter3CurrentReading Int
ReadingsMeter3Replaced Bool
ReadingsMeter4ExtensionsExtensionAggregate String
ReadingsMeter4CurrentReading Int
ReadingsMeter4Replaced Bool
ReadingsMeter5ExtensionsExtensionAggregate String
ReadingsMeter5CurrentReading Int
ReadingsMeter5Replaced Bool
ReadingsModifiedBy String
ReadingsModifiedDate Datetime
ReadingsReadingEnteredFrom String
Reference String
RegisterDate Datetime
SellerWarrantyCodeExtensionsExtensionAggregate String
SellerWarrantyCodeEndDate Datetime
SellerWarrantyCodeId String
SellerWarrantyCodeStartDate Datetime
SerialNumber String
ServiceAreaId String
ShippedDate Datetime
StatusId String
TechnicianId String
TimeZoneId String
UserDefined01 String
UserDefined02 String
UserDefined03 String
UserDefined04 String
UserDefined05 String
VendorId String
VendorWarrantyCodeExtensionsExtensionAggregate String
VendorWarrantyCodeEndDate Datetime
VendorWarrantyCodeId String
VendorWarrantyCodeStartDate Datetime
Version 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

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