ServiceQuoteAdditionalCharges
Return a list of: ServiceQuoteAdditionalCharges
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 | |
AdditionalChargesExtensionsExtensionAggregate | String | |
AdditionalChargesEntryDateTime | Datetime | |
AdditionalChargesEquipmentLineSequenceNumber | Int | |
AdditionalChargesFrontOfficeIntegrationId | String | |
AdditionalChargesItemDescription | String | |
AdditionalChargesItemId | String | |
AdditionalChargesKeyLineSequenceNumber [KEY] | Int | |
AdditionalChargesKeyServiceDocumentId [KEY] | String | |
AdditionalChargesNote | String | |
AdditionalChargesPriceLevelId | String | |
AdditionalChargesTaxAmountCurrency | String | |
AdditionalChargesTaxAmount | Decimal | |
AdditionalChargesTechnicianId | String | |
AdditionalChargesTotalAmountCurrency | String | |
AdditionalChargesTotalAmount | Decimal | |
AdditionalChargesUnitCostCurrency | String | |
AdditionalChargesUnitCost | Decimal | |
AdditionalChargesUnitPriceCurrency | String | |
AdditionalChargesUnitPrice | Decimal | |
AdditionalChargesUofM | String | |
AdditionalChargesBillableMiscellaneousPercent | Decimal | |
AdditionalChargesPurchaseOrderConsolidateOnPO | Bool | |
AdditionalChargesPurchaseOrderCreatePO | Bool | |
AdditionalChargesPurchaseOrderPromiseDate | Datetime | |
AdditionalChargesPurchaseOrderVendorId | String | |
AdditionalChargesPurchaseOrderLineKeyLineSequenceNumber | Int | |
AdditionalChargesPurchaseOrderLineKeyPurchaseTransactionId | String | |
AdditionalChargesQuantitySold | Decimal | |
AdditionalChargesTotalCostCurrency | String | |
AdditionalChargesTotalCost | Decimal | |
EquipmentCodesAggregate | String | |
ExpensesAggregate | String | |
LaborAggregate | 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 |