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 |