Table "FS Work Order Product"

ID 6402
Namespace: Microsoft.Integration.FieldService

Obsolete

This element will become obsolete from version 25.0. Field Service is moved to Field Service Integration app.

Properties

Name Value
ExternalName msdyn_workorderproduct
TableType CRM
Description In this entity you record all the products proposed and used for a work order
DataClassification SystemMetadata
ObsoleteReason Field Service is moved to Field Service Integration app.
ObsoleteState Pending
ObsoleteTag 25.0

Fields

Name Type Description
WorkOrderProductId Guid
CreatedOn DateTime
CreatedBy Guid
ModifiedOn DateTime
ModifiedBy Guid
CreatedOnBehalfBy Guid
ModifiedOnBehalfBy Guid
OwnerId Guid
OwningBusinessUnit Guid
OwningUser Guid
OwningTeam Guid
StateCode Option
StatusCode Option
VersionNumber BigInteger
ImportSequenceNumber Integer
OverriddenCreatedOn Date
TimeZoneRuleVersionNumber Integer
UTCConversionTimeZoneCode Integer
Name Text[200]
AdditionalCost Decimal
TransactionCurrencyId Guid
ExchangeRate Decimal
additionalcost_Base Decimal
Allocated Boolean
Booking Guid
CommissionCosts Decimal
commissioncosts_Base Decimal
CustomerAsset Guid
Description Blob
DisableEntitlement Boolean
DiscountAmount Decimal
DiscountAmount_Base Decimal
DiscountPercent Decimal
EstimateDiscountAmount Decimal
EstimateDiscountAmount_Base Decimal
EstimateDiscountPercent Decimal
EstimateQuantity Decimal
EstimateSubtotal Decimal
EstimateSubtotal_Base Decimal
EstimateTotalAmount Decimal
EstimateTotalAmount_Base Decimal
EstimateTotalCost Decimal
EtimateTotalCost_Base Decimal
EstimateUnitAmount Decimal
EstimateUnitAmount_Base Decimal
EstimateUnitCost Decimal
EstimateUnitCost_Base Decimal
InternalDescription Blob
InternalFlags Blob
LineOrder Integer
LineStatus Option
PriceList Guid
Product Guid
QtyToBill Decimal
Quantity Decimal
Subtotal Decimal
Subtotal_Base Decimal
Taxable Boolean
TotalAmount Decimal
TotalAmount_Base Decimal
TotalCost Decimal
TotalCost_Base Decimal
Unit Guid
UnitAmount Decimal
UnitAmount_Base Decimal
UnitCost Decimal
UnitCost_Base Decimal
WorkOrder Guid
WorkOrderIncident Guid
BookingName Text[100]
CustomerAssetName Text[100]
WorkOrderName Text[100]
WorkOrderIncidentName Text[100]
ProjectTask Guid
WorkOrderStatus Option
CompanyId Guid
QuantityConsumed Decimal
QuantityInvoiced Decimal
SystemId Guid
SystemRowVersion BigInteger

See also