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 |