ServiceQuoteLabor
Return a list of: ServiceQuoteLabor
Columns
Name | Type | Description |
ExtensionsExtensionAggregate | String | |
BillToAddressId | String | |
BillToCustomerId | String | |
CurrencyKeyISOCode | String | |
CustomerId | String | |
CustomerName | String | |
CustomerPONumber | String | |
EntryDateTime | Datetime | |
EstimatedArrivalDateTime | Datetime | |
ExchangeDate | Datetime | |
ExchangeRate | Decimal | |
FrontOfficeIntegrationId | String | |
Id | String | |
Note | String | |
OfficeId | String | |
RateTypeId | String | |
ShipToAddressId | String | |
TransactionState | String | |
UserDefined01 | String | |
UserDefined02 | String | |
UserDefined03 | String | |
UserDefined04 | String | |
UserDefined05 | String | |
AuditsAggregate | String | |
CustomerReference | String | |
Description | String | |
DistributionsAggregate | String | |
DocumentTotalCurrency | String | |
DocumentTotal | Decimal | |
EstimatedTimeToRepair | Decimal | |
IsOnHold | Bool | |
LaborChargesExtensionsExtensionAggregate | String | |
LaborChargesBillablePercent | Decimal | |
LaborChargesTotalAmountCurrency | String | |
LaborChargesTotalAmount | Decimal | |
LaborChargesTotalCostCurrency | String | |
LaborChargesTotalCost | Decimal | |
MiscellaneousChargesExtensionsExtensionAggregate | String | |
MiscellaneousChargesBillablePercent | Decimal | |
MiscellaneousChargesTotalAmountCurrency | String | |
MiscellaneousChargesTotalAmount | Decimal | |
MiscellaneousChargesTotalCostCurrency | String | |
MiscellaneousChargesTotalCost | Decimal | |
PartsChargesExtensionsExtensionAggregate | String | |
PartsChargesBillablePercent | Decimal | |
PartsChargesTotalAmountCurrency | String | |
PartsChargesTotalAmount | Decimal | |
PartsChargesTotalCostCurrency | String | |
PartsChargesTotalCost | Decimal | |
PaymentTermsId | String | |
PreTaxDocumentAmountCurrency | String | |
PreTaxDocumentAmount | Decimal | |
PriceLevelId | String | |
Priority | Int | |
ResponseDateTime | Datetime | |
SalesPersonId | String | |
ServiceAreaId | String | |
ServiceContractId | String | |
ServiceContractLineSequenceNumber | Decimal | |
ServiceTypeId | String | |
ShipToAddressExtensionsExtensionAggregate | String | |
ShipToAddressCity | String | |
ShipToAddressLine1 | String | |
ShipToAddressLine2 | String | |
ShipToAddressLine3 | String | |
ShipToAddressPostalCode | String | |
ShipToAddressState | String | |
ShipToAddressCountryRegion | String | |
ShipToAddressContactPerson | String | |
ShipToAddressPhone1CountryCode | String | |
ShipToAddressPhone1Extension | String | |
ShipToAddressPhone1 | String | |
StatusCodeId | String | |
TaxAmountCurrency | String | |
TaxAmount | Decimal | |
TaxExemptNumber1 | String | |
TaxExemptNumber2 | String | |
TaxScheduleId | String | |
TechnicianId | String | |
TimeZoneId | String | |
AdditionalChargesAggregate | String | |
EquipmentCodesAggregate | String | |
ExpensesAggregate | String | |
LaborExtensionsExtensionAggregate | String | |
LaborEntryDateTime | Datetime | |
LaborEquipmentLineSequenceNumber | Int | |
LaborFrontOfficeIntegrationId | String | |
LaborItemDescription | String | |
LaborItemId | String | |
LaborKeyLineSequenceNumber [KEY] | Int | |
LaborKeyServiceDocumentId [KEY] | String | |
LaborNote | String | |
LaborPriceLevelId | String | |
LaborTaxAmountCurrency | String | |
LaborTaxAmount | Decimal | |
LaborTechnicianId | String | |
LaborTotalAmountCurrency | String | |
LaborTotalAmount | Decimal | |
LaborUnitCostCurrency | String | |
LaborUnitCost | Decimal | |
LaborUnitPriceCurrency | String | |
LaborUnitPrice | Decimal | |
LaborUofM | String | |
LaborBillableLaborPercent | Decimal | |
LaborBillableTime | Int | |
LaborDistanceTraveledExtensionsExtensionAggregate | String | |
LaborDistanceTraveledEnding | Int | |
LaborDistanceTraveledStarting | Int | |
LaborDistanceTraveledUsed | Int | |
LaborEndDateTime | Datetime | |
LaborQuantity | Decimal | |
LaborQuantitySold | Decimal | |
LaborStartDateTime | Datetime | |
LaborTotalCostCurrency | String | |
LaborTotalCost | Decimal | |
LaborTransactionTime | Int | |
LaborUseType | String | |
LaborWorkTypeId | String | |
PartsAggregate | 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 |