JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ServiceQuote

Return a list of: ServiceQuote

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

BillToAddressId String False

BillToCustomerId String False

CurrencyKeyISOCode String False

CustomerId String False

CustomerName String False

CustomerPONumber String False

EntryDateTime Datetime False

EstimatedArrivalDateTime Datetime False

ExchangeDate Datetime False

ExchangeRate Decimal False

FrontOfficeIntegrationId String False

Id [KEY] String False

Note String False

OfficeId String False

RateTypeId String False

ShipToAddressId String False

TransactionState String False

UserDefined01 String False

UserDefined02 String False

UserDefined03 String False

UserDefined04 String False

UserDefined05 String False

AuditsAggregate String False

CustomerReference String False

Description String False

DistributionsAggregate String False

DocumentTotalCurrency String False

DocumentTotal Decimal False

EstimatedTimeToRepair Decimal False

IsOnHold Bool False

LaborChargesExtensionsExtensionAggregate String False

LaborChargesBillablePercent Decimal False

LaborChargesTotalAmountCurrency String False

LaborChargesTotalAmount Decimal False

LaborChargesTotalCostCurrency String False

LaborChargesTotalCost Decimal False

MiscellaneousChargesExtensionsExtensionAggregate String False

MiscellaneousChargesBillablePercent Decimal False

MiscellaneousChargesTotalAmountCurrency String False

MiscellaneousChargesTotalAmount Decimal False

MiscellaneousChargesTotalCostCurrency String False

MiscellaneousChargesTotalCost Decimal False

PartsChargesExtensionsExtensionAggregate String False

PartsChargesBillablePercent Decimal False

PartsChargesTotalAmountCurrency String False

PartsChargesTotalAmount Decimal False

PartsChargesTotalCostCurrency String False

PartsChargesTotalCost Decimal False

PaymentTermsId String False

PreTaxDocumentAmountCurrency String False

PreTaxDocumentAmount Decimal False

PriceLevelId String False

Priority Int False

ResponseDateTime Datetime False

SalesPersonId String False

ServiceAreaId String False

ServiceContractId String False

ServiceContractLineSequenceNumber Decimal False

ServiceTypeId String False

ShipToAddressExtensionsExtensionAggregate String False

ShipToAddressCity String False

ShipToAddressLine1 String False

ShipToAddressLine2 String False

ShipToAddressLine3 String False

ShipToAddressPostalCode String False

ShipToAddressState String False

ShipToAddressCountryRegion String False

ShipToAddressContactPerson String False

ShipToAddressPhone1CountryCode String False

ShipToAddressPhone1Extension String False

ShipToAddressPhone1 String False

StatusCodeId String False

TaxAmountCurrency String False

TaxAmount Decimal False

TaxExemptNumber1 String False

TaxExemptNumber2 String False

TaxScheduleId String False

TechnicianId String False

TimeZoneId String False

AdditionalChargesAggregate String False

EquipmentCodesAggregate String False

ExpensesAggregate String False

LaborAggregate String False

PartsAggregate 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