JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ServiceEquipment

Return a list of: ServiceEquipment

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

AddressExtensionsExtensionAggregate String False

AddressCity String False

AddressLine1 String False

AddressLine2 String False

AddressLine3 String False

AddressPostalCode String False

AddressState String False

AddressContactPerson String False

AddressCountry String False

AddressId String False

AssetTag String False

CustomerId String False

InstallDate Datetime False

Id [KEY] String False

KeyItemId [KEY] String False

LastCalculatedDate Datetime False

LastPreventiveMaintenanceDate Datetime False

LastServiceDate Datetime False

Note String False

OfficeId String False

PreventiveMaintenanceDay Int False

PreventiveMaintenanceMonth String False

Quantity Decimal False

ReadingsAggregate String False

Reference String False

RegisterDate Datetime False

SellerWarrantyCodeExtensionsExtensionAggregate String False

SellerWarrantyCodeEndDate Datetime False

SellerWarrantyCodeId String False

SellerWarrantyCodeStartDate Datetime False

SerialNumber String False

ServiceAreaId String False

ShippedDate Datetime False

StatusId String False

TechnicianId String False

TimeZoneId String False

UserDefined01 String False

UserDefined02 String False

UserDefined03 String False

UserDefined04 String False

UserDefined05 String False

VendorId String False

VendorWarrantyCodeExtensionsExtensionAggregate String False

VendorWarrantyCodeEndDate Datetime False

VendorWarrantyCodeId String False

VendorWarrantyCodeStartDate Datetime False

Version String False

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