FWProductType

Attribute Name	Type	Field Size	Description	Required
ProductTypeId	int	4	Unique internal DB Identifier for the Product type record.	Required
ProductTypeKey	nvarchar	50	Business key to identify the activity this Product type refers to.	Required
ProductTypeName	nvarchar	255	The name of the product type.
Measure(1-9)	float	8	Amount that this product uses of measure x (1-9) per Unit.
Measure(1-9)Factor	float	8	Factor for single-dimension measure X. Typically used to convert Measure[X]. Amount attribute to a different unit of measure.
ServiceRate	float	8	Factor used to Calculate the ServiceDuration. This rate will be used to calculate it against the Measure specified in the ApplyToMeasure field.
ApplyToMeasure	tinyint	4	Specifies the Measure number to which the specified ServiceRate should be applied.
PreServiceDuration	int	4	Pre-Service Duration before servicing this Item.
ServiceDuration	int	4	Service Duration for this Product Type. If defined, then the Service Rate is ignored.
PUPreServiceDuration	int	4	Pre Service Duration for the pickup portion of an order.
PUServiceDuration	int	4	Service Duration for the pickup portion of an order.
DeliveryPreServiceDuration	int	4	Pre Service Duration for the Delivery portion of an order.
DeliveryServiceDuration	int	4	Service Duration for the Delivery portion of an order.
Profit	float	8	The item’s profit.
Requirements	nvarchar	255	The requirements for the Product key.
Commodities	nvarchar	255	The commodities for the Product key.
Comment	nvarchar	500	See Comment.
ModifiedBy	int	4	See ModifiedBy.
ModifyDate	datetime	8	See ModifyDate.
wGLNSyncInd	bit	1	Can be set to true or false depending on the response from wGLN. 0 – Failure. wGLN does not have the latest changes. 1 – wGLN is in sync with Route Planner.
wGLNResponse	nvarchar	512	This field holds the response from wGLN
WorkUnits	float	8	The amount of workload an product type contributes toward the maximum allowed by a resource's work units
HazMatType	int	4	Indicate the product is hazardous material.
Category	nvarchar	100	Captures category for order lines
ProdCategory	nvarchar	100	Captures product category for order lines
RequirementSetID	int	4	The Requirement Set ID taken from the FWRequirementSet table.