NHibernate.Exceptions.GenericADOException occurred
  HResult=0x80131600
  Message=could not execute native bulk manipulation query:INSERT INTO [ScaleCalibration](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
KnownLengthFormat,
KnownLengthInches,
layerId,
ModifiedBy,
ModifiedDate,
ScaleDefinition_id,
ScaleDistanceInPixels,
ScaleDistanceInRealityFormat,
ScaleDistanceInRealityInches,
Shape,
SourceBlueprintFileId,
Style,
Tenant,
Type,
url_Value,
ScaleDefinition_woid,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
KnownLengthFormat,
KnownLengthInches,
layerId,
ModifiedBy,
ModifiedDate,
null,
ScaleDistanceInPixels,
ScaleDistanceInRealityFormat,
ScaleDistanceInRealityInches,
Shape,
SourceBlueprintFileId,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ScaleCalibration]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ScaleDefinition](CreatedBy,
CreatedDate,
Id,
IsActive,
KnownLengthFormat,
KnownLengthInches,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
ScaleCalibration_id,
Tenant,
Type,
ScaleCalibration_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
KnownLengthFormat,
KnownLengthInches,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
ScaleCalibration_id,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ScaleDefinition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
UPDATE calibration
							SET calibration.[ScaleDefinition_id] = (
								SELECT ScaleDefinition_id
								FROM [ScaleCalibration]
								WHERE woid = '00000000-0000-0000-0000-000000000000'
								AND Id = calibration.[Id]),
								calibration.[ScaleDefinition_woid] = '59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
							FROM [ScaleCalibration] calibration
							WHERE calibration.woid = '59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
							AND calibration.[ScaleDefinition_id] IS NULL
INSERT INTO [Calibration](calibrationId,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ScaleDefinition_id,
ScaleDistanceInPixels,
ScaleDistanceInRealityFormat,
ScaleDistanceInRealityInches,
Tenant,
ScaleDefinition_woid,
woid)
						 SELECT calibrationId,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ScaleDefinition_id,
ScaleDistanceInPixels,
ScaleDistanceInRealityFormat,
ScaleDistanceInRealityInches,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Calibration]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TakeoffBlueprint](blueprint_Id,
Calibration_id,
CreatedBy,
CreatedDate,
Grayscale,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
workorder_Id,
Calibration_woid,
woid)
						 SELECT blueprint_Id,
Calibration_id,
CreatedBy,
CreatedDate,
Grayscale,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
workorder_Id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TakeoffBlueprint]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ScaleArea](blueprintId,
Calibration_id,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
Calibration_woid,
woid)
						 SELECT blueprintId,
Calibration_id,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ScaleArea]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [LaborCategory](CreatedBy,
CreatedDate,
directcostcurrencyCode,
directcostcurrencySymbol,
directcostValue,
Id,
IsActive,
Level,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
profitcurrencyCode,
profitcurrencySymbol,
profitFraction,
profitMethod,
profitValue,
profitValueType,
Tenant,
TenantFacility_id,
totalcostcurrencyCode,
totalcostcurrencySymbol,
totalcostValue,
totalsellcurrencyCode,
totalsellcurrencySymbol,
totalsellValue,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
directcostcurrencyCode,
directcostcurrencySymbol,
directcostValue,
Id,
IsActive,
Level,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
profitcurrencyCode,
profitcurrencySymbol,
profitFraction,
profitMethod,
profitValue,
profitValueType,
Tenant,
TenantFacility_id,
totalcostcurrencyCode,
totalcostcurrencySymbol,
totalcostValue,
totalsellcurrencyCode,
totalsellcurrencySymbol,
totalsellValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [LaborCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductsPallet](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductsPallet]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Location](blueprintId,
Building,
CreatedBy,
CreatedDate,
DisplayName,
Floor,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Name,
Number,
ScopeNote,
Shape,
Style,
Tenant,
Type,
url_Value,
Zone,
woid)
						 SELECT blueprintId,
Building,
CreatedBy,
CreatedDate,
DisplayName,
Floor,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Name,
Number,
ScopeNote,
Shape,
Style,
Tenant,
Type,
url_Value,
Zone,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Location]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Layer](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Type,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Layer]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostObjectLayer](BidOriginId,
Layer_id,
Layer_woid)
						 SELECT BidOriginId,
Layer_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostObjectLayer]
						 WHERE Layer_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Image](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Image]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [DistributedCost](AmountCurrencyCode,
AmountCurrencySymbol,
AmountValue,
Category,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
woid)
						 SELECT AmountCurrencyCode,
AmountCurrencySymbol,
AmountValue,
Category,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [DistributedCost]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Budget](AlternatesSettings,
AlternatesSummaryCalculationMode,
BaseBidSettings,
CreatedBy,
CreatedDate,
Id,
IsActive,
LockedCostObjects,
ModifiedBy,
ModifiedDate,
SettingsVersionStamp,
Tenant,
woid)
						 SELECT AlternatesSettings,
AlternatesSummaryCalculationMode,
BaseBidSettings,
CreatedBy,
CreatedDate,
Id,
IsActive,
LockedCostObjects,
ModifiedBy,
ModifiedDate,
SettingsVersionStamp,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Budget]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [BidOrigin](CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Status,
Tenant,
Type,
woid)
						 SELECT CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Status,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [BidOrigin]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Annotation](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Annotation]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableSetDefinition](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
ShortName,
Tenant,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
ShortName,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableSetDefinition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableSetValue](CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsDefault,
ModifiedBy,
ModifiedDate,
Name,
Reference,
Tenant,
VariableSetDefinition_id,
VariableSetDefinition_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsDefault,
ModifiedBy,
ModifiedDate,
Name,
Reference,
Tenant,
VariableSetDefinition_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableSetValue]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableDefinitionCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableDefinitionCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [UomGroupCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [UomGroupCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [UomGroup](BaseUom_id,
Category_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Category_woid,
woid)
						 SELECT BaseUom_id,
Category_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [UomGroup]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CommonSizeCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CommonSizeCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CommonSize](BaseUom_id,
Category_id,
ConversionFactor,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Category_woid,
woid)
						 SELECT BaseUom_id,
Category_id,
ConversionFactor,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CommonSize]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CustomMaterial](Category_Id,
CostCurrencyCode,
CostCurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
DefaultCommonSize_id,
Id,
IsActive,
ManufacturerSku,
ManufacturerUrlValue,
ModifiedBy,
ModifiedDate,
Name,
ProfitCurrencyCode,
ProfitCurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
PurchaseUomGroup_id,
SellCurrencyCode,
SellCurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
WeightSymbol,
WeightUnit,
WeightValue,
Category_woid,
DefaultCommonSize_woid,
PurchaseUomGroup_woid,
woid)
						 SELECT Category_Id,
CostCurrencyCode,
CostCurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
DefaultCommonSize_id,
Id,
IsActive,
ManufacturerSku,
ManufacturerUrlValue,
ModifiedBy,
ModifiedDate,
Name,
ProfitCurrencyCode,
ProfitCurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
PurchaseUomGroup_id,
SellCurrencyCode,
SellCurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
WeightSymbol,
WeightUnit,
WeightValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CustomMaterial]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [UomGroupCommonSize](CommonSize_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
IsDefault,
ModifiedBy,
ModifiedDate,
Tenant,
UomGroup_id,
CommonSize_woid,
UomGroup_woid,
woid)
						 SELECT CommonSize_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
IsDefault,
ModifiedBy,
ModifiedDate,
Tenant,
UomGroup_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [UomGroupCommonSize]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductLabelDescription](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
X_Description,
Y_Description,
Z_Description,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
X_Description,
Y_Description,
Z_Description,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductLabelDescription]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductLibraryCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Type,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductLibraryCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Formula](Body,
CompiledBody,
CompiledBodySelf,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ReturnTypeKind,
Tenant,
woid)
						 SELECT Body,
CompiledBody,
CompiledBodySelf,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ReturnTypeKind,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Formula]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [InlineFormula](Formula_id,
Formula_woid)
						 SELECT Formula_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [InlineFormula]
						 WHERE Formula_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [PartBase](Category_id,
CreatedBy,
CreatedDate,
Dimensions,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
OriginalNameValue,
Tenant,
Category_woid,
woid)
						 SELECT Category_id,
CreatedBy,
CreatedDate,
Dimensions,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
OriginalNameValue,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [PartBase]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Assembly](PartBase_id,
PartBase_woid)
						 SELECT PartBase_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Assembly]
						 WHERE PartBase_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Product](BaseUom_id,
ImageIdentifier,
ImageName,
PartBase_id,
ProductAdditions_id,
ProductLabelDescription_Id,
X_id,
Y_id,
Z_id,
PartBase_woid,
ProductLabelDescription_woid,
X_woid,
Y_woid,
Z_woid)
						 SELECT BaseUom_id,
ImageIdentifier,
ImageName,
PartBase_id,
ProductAdditions_id,
ProductLabelDescription_Id,
X_id,
Y_id,
Z_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Product]
						 WHERE PartBase_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Part](PartBase_id,
PartBase_woid)
						 SELECT PartBase_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Part]
						 WHERE PartBase_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductEvaluationSpecifications](Completed,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Type,
VersionStamp,
woid)
						 SELECT Completed,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Type,
VersionStamp,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductEvaluationSpecifications]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductEvaluationSpecification](AdditionalCostsCashItems,
AdditionalCostsMaterials,
AdditionalCostsOperations,
Completed,
CreatedBy,
CreatedDate,
DimensionsCount,
DimensionsXFormat,
DimensionsXInches,
DimensionsYFormat,
DimensionsYInches,
DimensionsZFormat,
DimensionsZInches,
Facility_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecifications_id,
ProductTemplate_id,
Quantity,
Tenant,
Facility_woid,
ProductEvaluationSpecifications_woid,
ProductTemplate_woid,
woid)
						 SELECT AdditionalCostsCashItems,
AdditionalCostsMaterials,
AdditionalCostsOperations,
Completed,
CreatedBy,
CreatedDate,
DimensionsCount,
DimensionsXFormat,
DimensionsXInches,
DimensionsYFormat,
DimensionsYInches,
DimensionsZFormat,
DimensionsZInches,
Facility_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecifications_id,
ProductTemplate_id,
Quantity,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductEvaluationSpecification]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [AttachedProduct](AttachingDate,
CreatedBy,
CreatedDate,
DefaultShapeRepresentation,
EachTakeOffMethodType,
EvaluationSpecifications_id,
Fill,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
ProductsPallet_id,
SpriteType,
State,
TakeOffMethod,
TaxRegulationsType,
Tenant,
EvaluationSpecifications_woid,
ProductsPallet_woid,
woid)
						 SELECT AttachingDate,
CreatedBy,
CreatedDate,
DefaultShapeRepresentation,
EachTakeOffMethodType,
EvaluationSpecifications_id,
Fill,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
ProductsPallet_id,
SpriteType,
State,
TakeOffMethod,
TaxRegulationsType,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [AttachedProduct]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [AttachedProductDistributedCost](AttachedProduct_id,
CreatedBy,
CreatedDate,
DistributedCost_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
AttachedProduct_woid,
DistributedCost_woid,
woid)
						 SELECT AttachedProduct_id,
CreatedBy,
CreatedDate,
DistributedCost_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [AttachedProductDistributedCost]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TypicalGroup](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
MarkerType,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
MarkerType,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TypicalGroup]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostObject](AttachedProduct_id,
BidOriginId,
BidOriginIdVersionStamp,
blueprintId,
CostObjectBaseBidVersionId,
CostObjectState,
CreatedBy,
CreatedDate,
DisplayName,
DistributedCostsVersionStamp,
EachTakeOffMethodType,
EvaluationSpecifications_id,
Id,
IsActive,
layerId,
MeasurementCalculationMessage,
MeasurementLengthFormat,
MeasurementLengthInches,
MeasurementScaleSourceScaleArea_id,
MeasurementScaleSourceScaleDistanceInPixels,
MeasurementScaleSourceScaleDistanceInRealityFormat,
MeasurementScaleSourceScaleDistanceInRealityInches,
MeasurementScaleSourceSheetSettings_id,
MeasurementScaleSourceType,
MeasurementSurfaceAreaSquareInches,
ModifiedBy,
ModifiedDate,
PriceAdjustmentVersionStamp,
RawFabricationPriceAdjustmentFixedValuecurrencyCode,
RawFabricationPriceAdjustmentFixedValuecurrencySymbol,
RawFabricationPriceAdjustmentFixedValueValue,
RawFabricationPriceAdjustmentPercentageFraction,
RawInstalationPriceAdjustmentFixedValuecurrencyCode,
RawInstalationPriceAdjustmentFixedValuecurrencySymbol,
RawInstalationPriceAdjustmentFixedValueValue,
RawInstalationPriceAdjustmentPercentageFraction,
SequenceIdentifier,
Shape,
SheetLocation_id,
SourceProductName,
Style,
TakeOffMethod,
TaxRegulationsType,
TaxRegulationsVersionStamp,
Tenant,
Type,
TypicalGroupId,
url_Value,
AttachedProduct_woid,
EvaluationSpecifications_woid,
MeasurementScaleSourceScaleArea_woid,
MeasurementScaleSourceSheetSettings_woid,
SheetLocation_woid,
woid)
						 SELECT AttachedProduct_id,
BidOriginId,
BidOriginIdVersionStamp,
blueprintId,
CostObjectBaseBidVersionId,
CostObjectState,
CreatedBy,
CreatedDate,
DisplayName,
DistributedCostsVersionStamp,
EachTakeOffMethodType,
EvaluationSpecifications_id,
Id,
IsActive,
layerId,
MeasurementCalculationMessage,
MeasurementLengthFormat,
MeasurementLengthInches,
MeasurementScaleSourceScaleArea_id,
MeasurementScaleSourceScaleDistanceInPixels,
MeasurementScaleSourceScaleDistanceInRealityFormat,
MeasurementScaleSourceScaleDistanceInRealityInches,
MeasurementScaleSourceSheetSettings_id,
MeasurementScaleSourceType,
MeasurementSurfaceAreaSquareInches,
ModifiedBy,
ModifiedDate,
PriceAdjustmentVersionStamp,
RawFabricationPriceAdjustmentFixedValuecurrencyCode,
RawFabricationPriceAdjustmentFixedValuecurrencySymbol,
RawFabricationPriceAdjustmentFixedValueValue,
RawFabricationPriceAdjustmentPercentageFraction,
RawInstalationPriceAdjustmentFixedValuecurrencyCode,
RawInstalationPriceAdjustmentFixedValuecurrencySymbol,
RawInstalationPriceAdjustmentFixedValueValue,
RawInstalationPriceAdjustmentPercentageFraction,
SequenceIdentifier,
Shape,
SheetLocation_id,
SourceProductName,
Style,
TakeOffMethod,
TaxRegulationsType,
TaxRegulationsVersionStamp,
Tenant,
Type,
TypicalGroupId,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostObject]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [EvaluatedCostObject](CostsAmounts,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecificationsId,
ProductEvaluationSpecificationsVersionStamp,
Tenant,
ValidityIsValid,
ValidityMessage,
VersionStamp,
woid)
						 SELECT CostsAmounts,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecificationsId,
ProductEvaluationSpecificationsVersionStamp,
Tenant,
ValidityIsValid,
ValidityMessage,
VersionStamp,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [EvaluatedCostObject]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [BudgetCostObject](BaseFacilityId,
BaselinePricecurrencyCode,
BaselinePricecurrencySymbol,
BaselinePriceValue,
BaselineProfitcurrencyCode,
BaselineProfitcurrencySymbol,
BaselineProfitFraction,
BaselineProfitMethod,
BaselineProfitValue,
BaselineProfitValueType,
BidOriginId,
BidOriginIdVersionStamp,
BudgetPriceAdjustmentFabricationcurrencyCode,
BudgetPriceAdjustmentFabricationcurrencySymbol,
BudgetPriceAdjustmentFabricationFraction,
BudgetPriceAdjustmentFabricationMethod,
BudgetPriceAdjustmentFabricationValue,
BudgetPriceAdjustmentFabricationValueType,
BudgetPriceAdjustmentInstallationcurrencyCode,
BudgetPriceAdjustmentInstallationcurrencySymbol,
BudgetPriceAdjustmentInstallationFraction,
BudgetPriceAdjustmentInstallationMethod,
BudgetPriceAdjustmentInstallationValue,
BudgetPriceAdjustmentInstallationValueType,
CashSummaryTotalCostcurrencyCode,
CashSummaryTotalCostcurrencySymbol,
CashSummaryTotalCostValue,
CashSummaryTotalProfitcurrencyCode,
CashSummaryTotalProfitcurrencySymbol,
CashSummaryTotalProfitFraction,
CashSummaryTotalProfitMethod,
CashSummaryTotalProfitValue,
CashSummaryTotalProfitValueType,
CostcurrencyCode,
CostcurrencySymbol,
CostValue,
CreatedBy,
CreatedDate,
DirectPriceAdjustmentFabricationcurrencyCode,
DirectPriceAdjustmentFabricationcurrencySymbol,
DirectPriceAdjustmentFabricationFraction,
DirectPriceAdjustmentFabricationMethod,
DirectPriceAdjustmentFabricationValue,
DirectPriceAdjustmentFabricationValueType,
DirectPriceAdjustmentInstallationcurrencyCode,
DirectPriceAdjustmentInstallationcurrencySymbol,
DirectPriceAdjustmentInstallationFraction,
DirectPriceAdjustmentInstallationMethod,
DirectPriceAdjustmentInstallationValue,
DirectPriceAdjustmentInstallationValueType,
DistributedCostRedistributionWeightcurrencyCode,
DistributedCostRedistributionWeightcurrencySymbol,
DistributedCostRedistributionWeightValue,
DistributedCostsVersionStamp,
EvaluatedCostObjectVersionStamp,
ExtendedFabricationCostcurrencyCode,
ExtendedFabricationCostcurrencySymbol,
ExtendedFabricationCostValue,
ExtendedInstallCostcurrencyCode,
ExtendedInstallCostcurrencySymbol,
ExtendedInstallCostValue,
ExtendedLaborCostcurrencyCode,
ExtendedLaborCostcurrencySymbol,
ExtendedLaborCostValue,
ExtendedMaterialCostcurrencyCode,
ExtendedMaterialCostcurrencySymbol,
ExtendedMaterialCostValue,
Id,
InstallBaselinePricecurrencyCode,
InstallBaselinePricecurrencySymbol,
InstallBaselinePriceValue,
InstallBaselineProfitcurrencyCode,
InstallBaselineProfitcurrencySymbol,
InstallBaselineProfitFraction,
InstallBaselineProfitMethod,
InstallBaselineProfitValue,
InstallBaselineProfitValueType,
InstallCostcurrencyCode,
InstallCostcurrencySymbol,
InstallCostValue,
InstallDurationSeconds,
InstallPreSellTaxPricecurrencyCode,
InstallPreSellTaxPricecurrencySymbol,
InstallPreSellTaxPriceValue,
InstallPriceAdjustmentcurrencyCode,
InstallPriceAdjustmentcurrencySymbol,
InstallPriceAdjustmentFraction,
InstallPriceAdjustmentMethod,
InstallPriceAdjustmentValue,
InstallPriceAdjustmentValueType,
InstallPricecurrencyCode,
InstallPricecurrencySymbol,
InstallPriceValue,
InstallProfitcurrencyCode,
InstallProfitcurrencySymbol,
InstallProfitFraction,
InstallProfitMethod,
InstallProfitPerHourcurrencyCode,
InstallProfitPerHourcurrencySymbol,
InstallProfitPerHourFraction,
InstallProfitPerHourMethod,
InstallProfitPerHourValue,
InstallProfitPerHourValueType,
InstallProfitValue,
InstallProfitValueType,
InstallSellTaxcurrencyCode,
InstallSellTaxcurrencySymbol,
InstallSellTaxValue,
InstallUseTaxcurrencyCode,
InstallUseTaxcurrencySymbol,
InstallUseTaxValue,
IsActive,
LaborDurationSeconds,
LaborProfitPerHourcurrencyCode,
LaborProfitPerHourcurrencySymbol,
LaborProfitPerHourFraction,
LaborProfitPerHourMethod,
LaborProfitPerHourValue,
LaborProfitPerHourValueType,
LibraryFabricationCostcurrencyCode,
LibraryFabricationCostcurrencySymbol,
LibraryFabricationCostValue,
LibraryInstallCostcurrencyCode,
LibraryInstallCostcurrencySymbol,
LibraryInstallCostValue,
LibraryMaterialCostcurrencyCode,
LibraryMaterialCostcurrencySymbol,
LibraryMaterialCostValue,
LibraryOverheadCostcurrencyCode,
LibraryOverheadCostcurrencySymbol,
LibraryOverheadCostValue,
ModifiedBy,
ModifiedDate,
PreSellTaxPricecurrencyCode,
PreSellTaxPricecurrencySymbol,
PreSellTaxPriceValue,
PriceAdjustmentcurrencyCode,
PriceAdjustmentcurrencySymbol,
PriceAdjustmentFraction,
PriceAdjustmentMethod,
PriceAdjustmentValue,
PriceAdjustmentValueType,
PriceAdjustmentVersionStamp,
PricecurrencyCode,
PricecurrencySymbol,
PriceValue,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
SellTaxcurrencyCode,
SellTaxcurrencySymbol,
SellTaxValue,
TaxRegulationsType,
TaxRegulationsVersionStamp,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalDurationSeconds,
TotalPreSellTaxPricecurrencyCode,
TotalPreSellTaxPricecurrencySymbol,
TotalPreSellTaxPriceValue,
TotalPricecurrencyCode,
TotalPricecurrencySymbol,
TotalPriceValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitPerHourcurrencyCode,
TotalProfitPerHourcurrencySymbol,
TotalProfitPerHourFraction,
TotalProfitPerHourMethod,
TotalProfitPerHourValue,
TotalProfitPerHourValueType,
TotalProfitValue,
TotalProfitValueType,
TotalSellTaxcurrencyCode,
TotalSellTaxcurrencySymbol,
TotalSellTaxValue,
UseTaxcurrencyCode,
UseTaxcurrencySymbol,
UseTaxValue,
ValidityIsValid,
ValidityMessage,
woid)
						 SELECT BaseFacilityId,
BaselinePricecurrencyCode,
BaselinePricecurrencySymbol,
BaselinePriceValue,
BaselineProfitcurrencyCode,
BaselineProfitcurrencySymbol,
BaselineProfitFraction,
BaselineProfitMethod,
BaselineProfitValue,
BaselineProfitValueType,
BidOriginId,
BidOriginIdVersionStamp,
BudgetPriceAdjustmentFabricationcurrencyCode,
BudgetPriceAdjustmentFabricationcurrencySymbol,
BudgetPriceAdjustmentFabricationFraction,
BudgetPriceAdjustmentFabricationMethod,
BudgetPriceAdjustmentFabricationValue,
BudgetPriceAdjustmentFabricationValueType,
BudgetPriceAdjustmentInstallationcurrencyCode,
BudgetPriceAdjustmentInstallationcurrencySymbol,
BudgetPriceAdjustmentInstallationFraction,
BudgetPriceAdjustmentInstallationMethod,
BudgetPriceAdjustmentInstallationValue,
BudgetPriceAdjustmentInstallationValueType,
CashSummaryTotalCostcurrencyCode,
CashSummaryTotalCostcurrencySymbol,
CashSummaryTotalCostValue,
CashSummaryTotalProfitcurrencyCode,
CashSummaryTotalProfitcurrencySymbol,
CashSummaryTotalProfitFraction,
CashSummaryTotalProfitMethod,
CashSummaryTotalProfitValue,
CashSummaryTotalProfitValueType,
CostcurrencyCode,
CostcurrencySymbol,
CostValue,
CreatedBy,
CreatedDate,
DirectPriceAdjustmentFabricationcurrencyCode,
DirectPriceAdjustmentFabricationcurrencySymbol,
DirectPriceAdjustmentFabricationFraction,
DirectPriceAdjustmentFabricationMethod,
DirectPriceAdjustmentFabricationValue,
DirectPriceAdjustmentFabricationValueType,
DirectPriceAdjustmentInstallationcurrencyCode,
DirectPriceAdjustmentInstallationcurrencySymbol,
DirectPriceAdjustmentInstallationFraction,
DirectPriceAdjustmentInstallationMethod,
DirectPriceAdjustmentInstallationValue,
DirectPriceAdjustmentInstallationValueType,
DistributedCostRedistributionWeightcurrencyCode,
DistributedCostRedistributionWeightcurrencySymbol,
DistributedCostRedistributionWeightValue,
DistributedCostsVersionStamp,
EvaluatedCostObjectVersionStamp,
ExtendedFabricationCostcurrencyCode,
ExtendedFabricationCostcurrencySymbol,
ExtendedFabricationCostValue,
ExtendedInstallCostcurrencyCode,
ExtendedInstallCostcurrencySymbol,
ExtendedInstallCostValue,
ExtendedLaborCostcurrencyCode,
ExtendedLaborCostcurrencySymbol,
ExtendedLaborCostValue,
ExtendedMaterialCostcurrencyCode,
ExtendedMaterialCostcurrencySymbol,
ExtendedMaterialCostValue,
Id,
InstallBaselinePricecurrencyCode,
InstallBaselinePricecurrencySymbol,
InstallBaselinePriceValue,
InstallBaselineProfitcurrencyCode,
InstallBaselineProfitcurrencySymbol,
InstallBaselineProfitFraction,
InstallBaselineProfitMethod,
InstallBaselineProfitValue,
InstallBaselineProfitValueType,
InstallCostcurrencyCode,
InstallCostcurrencySymbol,
InstallCostValue,
InstallDurationSeconds,
InstallPreSellTaxPricecurrencyCode,
InstallPreSellTaxPricecurrencySymbol,
InstallPreSellTaxPriceValue,
InstallPriceAdjustmentcurrencyCode,
InstallPriceAdjustmentcurrencySymbol,
InstallPriceAdjustmentFraction,
InstallPriceAdjustmentMethod,
InstallPriceAdjustmentValue,
InstallPriceAdjustmentValueType,
InstallPricecurrencyCode,
InstallPricecurrencySymbol,
InstallPriceValue,
InstallProfitcurrencyCode,
InstallProfitcurrencySymbol,
InstallProfitFraction,
InstallProfitMethod,
InstallProfitPerHourcurrencyCode,
InstallProfitPerHourcurrencySymbol,
InstallProfitPerHourFraction,
InstallProfitPerHourMethod,
InstallProfitPerHourValue,
InstallProfitPerHourValueType,
InstallProfitValue,
InstallProfitValueType,
InstallSellTaxcurrencyCode,
InstallSellTaxcurrencySymbol,
InstallSellTaxValue,
InstallUseTaxcurrencyCode,
InstallUseTaxcurrencySymbol,
InstallUseTaxValue,
IsActive,
LaborDurationSeconds,
LaborProfitPerHourcurrencyCode,
LaborProfitPerHourcurrencySymbol,
LaborProfitPerHourFraction,
LaborProfitPerHourMethod,
LaborProfitPerHourValue,
LaborProfitPerHourValueType,
LibraryFabricationCostcurrencyCode,
LibraryFabricationCostcurrencySymbol,
LibraryFabricationCostValue,
LibraryInstallCostcurrencyCode,
LibraryInstallCostcurrencySymbol,
LibraryInstallCostValue,
LibraryMaterialCostcurrencyCode,
LibraryMaterialCostcurrencySymbol,
LibraryMaterialCostValue,
LibraryOverheadCostcurrencyCode,
LibraryOverheadCostcurrencySymbol,
LibraryOverheadCostValue,
ModifiedBy,
ModifiedDate,
PreSellTaxPricecurrencyCode,
PreSellTaxPricecurrencySymbol,
PreSellTaxPriceValue,
PriceAdjustmentcurrencyCode,
PriceAdjustmentcurrencySymbol,
PriceAdjustmentFraction,
PriceAdjustmentMethod,
PriceAdjustmentValue,
PriceAdjustmentValueType,
PriceAdjustmentVersionStamp,
PricecurrencyCode,
PricecurrencySymbol,
PriceValue,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
SellTaxcurrencyCode,
SellTaxcurrencySymbol,
SellTaxValue,
TaxRegulationsType,
TaxRegulationsVersionStamp,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalDurationSeconds,
TotalPreSellTaxPricecurrencyCode,
TotalPreSellTaxPricecurrencySymbol,
TotalPreSellTaxPriceValue,
TotalPricecurrencyCode,
TotalPricecurrencySymbol,
TotalPriceValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitPerHourcurrencyCode,
TotalProfitPerHourcurrencySymbol,
TotalProfitPerHourFraction,
TotalProfitPerHourMethod,
TotalProfitPerHourValue,
TotalProfitPerHourValueType,
TotalProfitValue,
TotalProfitValueType,
TotalSellTaxcurrencyCode,
TotalSellTaxcurrencySymbol,
TotalSellTaxValue,
UseTaxcurrencyCode,
UseTaxcurrencySymbol,
UseTaxValue,
ValidityIsValid,
ValidityMessage,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [BudgetCostObject]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [DistributedCostSummary](BudgetCostObject_id,
Category,
CostCurrencyCode,
CostCurrencySymbol,
CostValue,
CreatedBy,
CreatedDate,
DistributedCostId,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
BudgetCostObject_woid,
woid)
						 SELECT BudgetCostObject_id,
Category,
CostCurrencyCode,
CostCurrencySymbol,
CostValue,
CreatedBy,
CreatedDate,
DistributedCostId,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [DistributedCostSummary]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialCostSummary](BaseUoMName,
BudgetCostObject_id,
CreatedBy,
CreatedDate,
FacilityId,
Id,
IsActive,
MaterialId,
ModifiedBy,
ModifiedDate,
Name,
Quantity,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitValue,
TotalProfitValueType,
TotalSellcurrencyCode,
TotalSellcurrencySymbol,
TotalSellValue,
UnitCostcurrencyCode,
UnitCostcurrencySymbol,
UnitCostValue,
UnitProfitCurrencyCode,
UnitProfitCurrencySymbol,
UnitProfitFraction,
UnitProfitMethod,
UnitProfitValue,
UnitProfitValueType,
UnitSellCurrencyCode,
UnitSellCurrencySymbol,
UnitSellValue,
BudgetCostObject_woid,
woid)
						 SELECT BaseUoMName,
BudgetCostObject_id,
CreatedBy,
CreatedDate,
FacilityId,
Id,
IsActive,
MaterialId,
ModifiedBy,
ModifiedDate,
Name,
Quantity,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitValue,
TotalProfitValueType,
TotalSellcurrencyCode,
TotalSellcurrencySymbol,
TotalSellValue,
UnitCostcurrencyCode,
UnitCostcurrencySymbol,
UnitCostValue,
UnitProfitCurrencyCode,
UnitProfitCurrencySymbol,
UnitProfitFraction,
UnitProfitMethod,
UnitProfitValue,
UnitProfitValueType,
UnitSellCurrencyCode,
UnitSellCurrencySymbol,
UnitSellValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialCostSummary]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialKitSummary](BudgetCostObject_id,
CreatedBy,
CreatedDate,
FacilityId,
Id,
IsActive,
MaterialKitId,
ModifiedBy,
ModifiedDate,
Quantity,
Tenant,
BudgetCostObject_woid,
woid)
						 SELECT BudgetCostObject_id,
CreatedBy,
CreatedDate,
FacilityId,
Id,
IsActive,
MaterialKitId,
ModifiedBy,
ModifiedDate,
Quantity,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialKitSummary]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostObjectDistributedCost](CostObject_id,
CreatedBy,
CreatedDate,
DistributedCost_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
CostObject_woid,
DistributedCost_woid,
woid)
						 SELECT CostObject_id,
CreatedBy,
CreatedDate,
DistributedCost_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostObjectDistributedCost]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostObjectTag](CostObject_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tag_id,
Tenant,
CostObject_woid,
woid)
						 SELECT CostObject_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tag_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostObjectTag]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [AttachedProductTag](AttachedProduct_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tag_id,
Tenant,
AttachedProduct_woid,
woid)
						 SELECT AttachedProduct_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tag_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [AttachedProductTag]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableSetInstance](CreatedBy,
CreatedDate,
Definition_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecification_id,
Tenant,
Value_id,
Definition_woid,
ProductEvaluationSpecification_woid,
Value_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Definition_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecification_id,
Tenant,
Value_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableSetInstance]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostFormulaAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
InlineFormula_id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
Amount_woid,
InlineFormula_woid,
PartBase_woid,
woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
InlineFormula_id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostFormulaAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableDefinition](CreatedBy,
CreatedDate,
DefaultValue_id,
Description,
DisplayName,
Id,
IsActive,
IsInnergy,
Kind,
MaxValue,
MinValue,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Type_id,
ValidationType_id,
VariableCategory_id,
VariableSetDefinition_id,
DefaultValue_woid,
VariableCategory_woid,
VariableSetDefinition_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
null,
Description,
DisplayName,
Id,
IsActive,
IsInnergy,
Kind,
MaxValue,
MinValue,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Type_id,
ValidationType_id,
VariableCategory_id,
VariableSetDefinition_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableDefinition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
Variable_id,
Amount_woid,
Item_woid,
Part_woid,
Variable_woid,
woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
Variable_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableAddition](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
Variable_id,
PartBase_woid,
Variable_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
Variable_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableSetAddition](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
VariableSetDefinition_id,
PartBase_woid,
VariableSetDefinition_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
VariableSetDefinition_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableSetAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [EvaluationSnapshot](CreatedBy,
CreatedDate,
Id,
IsActive,
Location,
ModifiedBy,
ModifiedDate,
PartBase_id,
Quantity,
Tenant,
X,
Y,
Z,
PartBase_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
Location,
ModifiedBy,
ModifiedDate,
PartBase_id,
Quantity,
Tenant,
X,
Y,
Z,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [EvaluationSnapshot]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [EvaluationBundleSnapshot](BundleId,
CreatedBy,
CreatedDate,
EvaluationSnapshot_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
SourcePath,
Tenant,
Value,
EvaluationSnapshot_woid,
woid)
						 SELECT BundleId,
CreatedBy,
CreatedDate,
EvaluationSnapshot_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
SourcePath,
Tenant,
Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [EvaluationBundleSnapshot]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [EvaluationVariableSnapshot](CreatedBy,
CreatedDate,
EvaluationSnapshot_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
SourcePath,
Tenant,
Value,
VariableId,
EvaluationSnapshot_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
EvaluationSnapshot_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
SourcePath,
Tenant,
Value,
VariableId,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [EvaluationVariableSnapshot]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [PartAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
X_id,
Y_id,
Z_id,
Amount_woid,
Item_woid,
Part_woid,
woid,
X_woid,
Y_woid,
Z_woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
X_id,
Y_id,
Z_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [PartAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationType](CreatedBy,
CreatedDate,
Id,
IsActive,
IsRequired,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Value,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsRequired,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationType]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Operation](BaseUom_id,
Category_id,
CreatedBy,
CreatedDate,
Description,
Id,
Included,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
NotIncluded,
OperationType_Id,
SequenceIdentifier,
Tenant,
Category_woid,
OperationType_woid,
woid)
						 SELECT BaseUom_id,
Category_id,
CreatedBy,
CreatedDate,
Description,
Id,
Included,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
NotIncluded,
OperationType_Id,
SequenceIdentifier,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Operation]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableValue](Boolean,
CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Number,
Operation_id,
Tenant,
Text,
Type_id,
VariableDefinition_id,
Material_woid,
Operation_woid,
VariableDefinition_woid,
woid)
						 SELECT Boolean,
CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Number,
Operation_id,
Tenant,
Text,
Type_id,
VariableDefinition_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableValue]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
UPDATE vd
							SET vd.[DefaultValue_id] = (
								SELECT DefaultValue_id
								FROM [VariableDefinition]
								WHERE woid = '00000000-0000-0000-0000-000000000000'
								AND Id = vd.[Id]),
								vd.[DefaultValue_woid] = '59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
							FROM [VariableDefinition] vd
							WHERE vd.woid = '59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
							AND vd.[DefaultValue_id] IS NULL
INSERT INTO [VariableInstance](CreatedBy,
CreatedDate,
Definition_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecification_id,
Tenant,
Value_id,
VariableSetValue_id,
Definition_woid,
ProductEvaluationSpecification_woid,
Value_woid,
VariableSetValue_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Definition_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecification_id,
Tenant,
Value_id,
VariableSetValue_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableInstance]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
Variable_id,
Amount_woid,
Item_woid,
Part_woid,
Variable_woid,
woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
Variable_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductivityRegister](CreatedBy,
CreatedDate,
Entries,
Id,
InitialState,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
woid)
						 SELECT CreatedBy,
CreatedDate,
Entries,
Id,
InitialState,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductivityRegister]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [PrecedingOperation](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Operation_id,
Predecessor_id,
Tenant,
Operation_woid,
Predecessor_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Operation_id,
Predecessor_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [PrecedingOperation]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [LaborItem](Category_id,
CreatedBy,
CreatedDate,
Department_id,
directcostcurrencyCode,
directcostcurrencySymbol,
DirectCostDataSource,
directcostValue,
Id,
IsActive,
Location_id,
ModifiedBy,
ModifiedDate,
Name,
profitcurrencyCode,
profitcurrencySymbol,
profitFraction,
profitMethod,
profitValue,
profitValueType,
Tenant,
totalcostcurrencyCode,
totalcostcurrencySymbol,
totalcostValue,
TotalLaborTime,
totalsellcurrencyCode,
totalsellcurrencySymbol,
totalsellValue,
Unit,
Category_woid,
Location_woid,
woid)
						 SELECT Category_id,
CreatedBy,
CreatedDate,
Department_id,
directcostcurrencyCode,
directcostcurrencySymbol,
DirectCostDataSource,
directcostValue,
Id,
IsActive,
Location_id,
ModifiedBy,
ModifiedDate,
Name,
profitcurrencyCode,
profitcurrencySymbol,
profitFraction,
profitMethod,
profitValue,
profitValueType,
Tenant,
totalcostcurrencyCode,
totalcostcurrencySymbol,
totalcostValue,
TotalLaborTime,
totalsellcurrencyCode,
totalsellcurrencySymbol,
totalsellValue,
Unit,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [LaborItem]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationCostSummary](BaseUoMName,
BudgetCostObject_id,
CreatedBy,
CreatedDate,
Duration,
FacilityId,
HourlyRatecurrencyCode,
HourlyRatecurrencySymbol,
HourlyRateValue,
Id,
IsActive,
LaborItemId,
LaborItemName,
ModifiedBy,
ModifiedDate,
OperationId,
OperationName,
OperationType,
Quantity,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitValue,
TotalProfitValueType,
TotalSellcurrencyCode,
TotalSellcurrencySymbol,
TotalSellValue,
UnitCostcurrencyCode,
UnitCostcurrencySymbol,
UnitCostValue,
BudgetCostObject_woid,
LaborItemwoid,
woid)
						 SELECT BaseUoMName,
BudgetCostObject_id,
CreatedBy,
CreatedDate,
Duration,
FacilityId,
HourlyRatecurrencyCode,
HourlyRatecurrencySymbol,
HourlyRateValue,
Id,
IsActive,
LaborItemId,
LaborItemName,
ModifiedBy,
ModifiedDate,
OperationId,
OperationName,
OperationType,
Quantity,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitValue,
TotalProfitValueType,
TotalSellcurrencyCode,
TotalSellcurrencySymbol,
TotalSellValue,
UnitCostcurrencyCode,
UnitCostcurrencySymbol,
UnitCostValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationCostSummary]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationDuration](CreatedBy,
CreatedDate,
Equation,
Id,
IsActive,
LaborItem_id,
Location_id,
ModifiedBy,
ModifiedDate,
Operation_id,
ProductivityRegister_id,
RegressionMethod,
RSquared,
Tenant,
TimeUnit,
LaborItem_woid,
Location_woid,
Operation_woid,
ProductivityRegister_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Equation,
Id,
IsActive,
LaborItem_id,
Location_id,
ModifiedBy,
ModifiedDate,
Operation_id,
ProductivityRegister_id,
RegressionMethod,
RSquared,
Tenant,
TimeUnit,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationDuration]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Type,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialKit](Category_id,
CostcurrencyCode,
CostcurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
SellcurrencyCode,
SellcurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
Category_woid,
woid)
						 SELECT Category_id,
CostcurrencyCode,
CostcurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
SellcurrencyCode,
SellcurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialKit]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [AssemblyAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
X_id,
Y_id,
Z_id,
Amount_woid,
Item_woid,
Part_woid,
woid,
X_woid,
Y_woid,
Z_woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
X_id,
Y_id,
Z_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [AssemblyAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [PartBaseAdditionDefinedValue](AssemblyAddition_id,
CreatedBy,
CreatedDate,
Id,
InlineFormula_id,
IsActive,
ModifiedBy,
ModifiedDate,
PartAddition_id,
Tenant,
Type,
VariableDefinition_id,
VariableValue_id,
AssemblyAddition_woid,
InlineFormula_woid,
PartAddition_woid,
VariableDefinition_woid,
VariableValue_woid,
woid)
						 SELECT AssemblyAddition_id,
CreatedBy,
CreatedDate,
Id,
InlineFormula_id,
IsActive,
ModifiedBy,
ModifiedDate,
PartAddition_id,
Tenant,
Type,
VariableDefinition_id,
VariableValue_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [PartBaseAdditionDefinedValue]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CharacteristicType](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CharacteristicType]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CustomMaterialCharacteristic](Characteristic_id,
CreatedBy,
CreatedDate,
CustomMaterial_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Characteristic_woid,
CustomMaterial_woid,
woid)
						 SELECT Characteristic_id,
CreatedBy,
CreatedDate,
CustomMaterial_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CustomMaterialCharacteristic]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Material](Category_id,
CostcurrencyCode,
CostcurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
DefaultCommonSize_id,
Description,
ExternalApproval,
GrainDirection,
Id,
Inventoried,
IsActive,
IsInnergy,
ManufacturerSku,
ManufacturerUrlLinkAddress,
ModifiedBy,
ModifiedDate,
Name,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
PurchaseUomGroup_id,
SellcurrencyCode,
SellcurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
WeightSymbol,
WeightUnit,
WeightValue,
Category_woid,
DefaultCommonSize_woid,
PurchaseUomGroup_woid,
woid)
						 SELECT Category_id,
CostcurrencyCode,
CostcurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
DefaultCommonSize_id,
Description,
ExternalApproval,
GrainDirection,
Id,
Inventoried,
IsActive,
IsInnergy,
ManufacturerSku,
ManufacturerUrlLinkAddress,
ModifiedBy,
ModifiedDate,
Name,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
PurchaseUomGroup_id,
SellcurrencyCode,
SellcurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
WeightSymbol,
WeightUnit,
WeightValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Material]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialKitMaterial](CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
MaterialAmount,
MaterialKit_id,
ModifiedBy,
ModifiedDate,
Tenant,
Material_woid,
MaterialKit_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
MaterialAmount,
MaterialKit_id,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialKitMaterial]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialCharacteristic](Characteristic_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Tenant,
Characteristic_woid,
Material_woid,
woid)
						 SELECT Characteristic_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialCharacteristic]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialSubstitute](CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Substitute_id,
Tenant,
Material_woid,
Substitute_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Substitute_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialSubstitute]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [BurdenCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [BurdenCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Burden](BurdenValueSource,
Category_id,
CreatedBy,
CreatedDate,
currencyCode,
currencySymbol,
Fraction,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Value,
Category_woid,
woid)
						 SELECT BurdenValueSource,
Category_id,
CreatedBy,
CreatedDate,
currencyCode,
currencySymbol,
Fraction,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Burden]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [LaborItemBurden](Burden_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
LaborItem_id,
ModifiedBy,
ModifiedDate,
Tenant,
Burden_woid,
LaborItem_woid,
woid)
						 SELECT Burden_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
LaborItem_id,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [LaborItemBurden]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [SummaryBurden](Category_id,
CreatedBy,
CreatedDate,
currencyCode,
currencySymbol,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
TotalLaborTime,
Value,
Category_woid,
woid)
						 SELECT Category_id,
CreatedBy,
CreatedDate,
currencyCode,
currencySymbol,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
TotalLaborTime,
Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [SummaryBurden]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [FormulaCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [FormulaCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [FormulaArgument](CreatedBy,
CreatedDate,
Formula_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
TypeKind,
Formula_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Formula_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
TypeKind,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [FormulaArgument]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ReusableFormula](Category_id,
Formula_id,
IsInnergy,
Name,
Category_woid,
Formula_woid)
						 SELECT Category_id,
Formula_id,
IsInnergy,
Name,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ReusableFormula]
						 WHERE Formula_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [FormulaDependency](Child_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Parent_id,
Tenant,
Child_woid,
Parent_woid,
woid)
						 SELECT Child_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [FormulaDependency]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TaxRegulations](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Type,
UseMarginFraction,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Type,
UseMarginFraction,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TaxRegulations]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TaxQuestionnaireAnswer](AnswerType,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
TaxRegulations_id,
Tenant,
TaxRegulations_woid,
woid)
						 SELECT AnswerType,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
TaxRegulations_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TaxQuestionnaireAnswer]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TaxQuestionNote](Content,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
QuestionCategory,
TaxRegulations_id,
Tenant,
TaxRegulations_woid,
woid)
						 SELECT Content,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
QuestionCategory,
TaxRegulations_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TaxQuestionNote]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TaxRate](CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
RateFraction,
TaxRegulations_id,
Tenant,
TaxRegulations_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
RateFraction,
TaxRegulations_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TaxRate]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ImageAttachment](CreatedBy,
CreatedDate,
Id,
Image_id,
ImageIdentifier,
ImageName,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
ThumbnailIdentifier,
ThumbnailName,
Image_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
Image_id,
ImageIdentifier,
ImageName,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
ThumbnailIdentifier,
ThumbnailName,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ImageAttachment]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TypicalGroupMarker](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
Location_id,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
TypicalGroupId,
url_Value,
Location_woid,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
Location_id,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
TypicalGroupId,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TypicalGroupMarker]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
UPDATE [TypicalGroupMarker]
SET Location_woid = NULL
WHERE Location_id IS NULL
AND Location_woid IS NOT NULL

UPDATE [TakeoffBlueprint]
SET Calibration_woid = NULL
WHERE Calibration_id IS NULL
AND Calibration_woid IS NOT NULL

UPDATE [ScaleDefinition]
SET ScaleCalibration_woid = NULL
WHERE ScaleCalibration_id IS NULL
AND ScaleCalibration_woid IS NOT NULL

UPDATE [Calibration]
SET ScaleDefinition_woid = NULL
WHERE ScaleDefinition_id IS NULL
AND ScaleDefinition_woid IS NOT NULL

UPDATE [ScaleCalibration]
SET ScaleDefinition_woid = NULL
WHERE ScaleDefinition_id IS NULL
AND ScaleDefinition_woid IS NOT NULL

UPDATE [ScaleArea]
SET Calibration_woid = NULL
WHERE Calibration_id IS NULL
AND Calibration_woid IS NOT NULL

UPDATE [AttachedProduct]
SET EvaluationSpecifications_woid = NULL
WHERE EvaluationSpecifications_id IS NULL
AND EvaluationSpecifications_woid IS NOT NULL

UPDATE [AttachedProduct]
SET ProductsPallet_woid = NULL
WHERE ProductsPallet_id IS NULL
AND ProductsPallet_woid IS NOT NULL

UPDATE [AttachedProductDistributedCost]
SET AttachedProduct_woid = NULL
WHERE AttachedProduct_id IS NULL
AND AttachedProduct_woid IS NOT NULL

UPDATE [AttachedProductDistributedCost]
SET DistributedCost_woid = NULL
WHERE DistributedCost_id IS NULL
AND DistributedCost_woid IS NOT NULL

UPDATE [AttachedProductTag]
SET AttachedProduct_woid = NULL
WHERE AttachedProduct_id IS NULL
AND AttachedProduct_woid IS NOT NULL

UPDATE [ProductEvaluationSpecification]
SET Facility_woid = NULL
WHERE Facility_id IS NULL
AND Facility_woid IS NOT NULL

UPDATE [ProductEvaluationSpecification]
SET ProductEvaluationSpecifications_woid = NULL
WHERE ProductEvaluationSpecifications_id IS NULL
AND ProductEvaluationSpecifications_woid IS NOT NULL

UPDATE [ProductEvaluationSpecification]
SET ProductTemplate_woid = NULL
WHERE ProductTemplate_id IS NULL
AND ProductTemplate_woid IS NOT NULL

UPDATE [CustomMaterial]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [CustomMaterial]
SET DefaultCommonSize_woid = NULL
WHERE DefaultCommonSize_id IS NULL
AND DefaultCommonSize_woid IS NOT NULL

UPDATE [CustomMaterial]
SET PurchaseUomGroup_woid = NULL
WHERE PurchaseUomGroup_id IS NULL
AND PurchaseUomGroup_woid IS NOT NULL

UPDATE [CustomMaterialCharacteristic]
SET Characteristic_woid = NULL
WHERE Characteristic_id IS NULL
AND Characteristic_woid IS NOT NULL

UPDATE [CustomMaterialCharacteristic]
SET CustomMaterial_woid = NULL
WHERE CustomMaterial_id IS NULL
AND CustomMaterial_woid IS NOT NULL

UPDATE [CostObjectLayer]
SET Layer_woid = NULL
WHERE Layer_id IS NULL
AND Layer_woid IS NOT NULL

UPDATE [CostObject]
SET AttachedProduct_woid = NULL
WHERE AttachedProduct_id IS NULL
AND AttachedProduct_woid IS NOT NULL

UPDATE [CostObject]
SET EvaluationSpecifications_woid = NULL
WHERE EvaluationSpecifications_id IS NULL
AND EvaluationSpecifications_woid IS NOT NULL

UPDATE [CostObject]
SET MeasurementScaleSourceScaleArea_woid = NULL
WHERE MeasurementScaleSourceScaleArea_id IS NULL
AND MeasurementScaleSourceScaleArea_woid IS NOT NULL

UPDATE [CostObject]
SET MeasurementScaleSourceSheetSettings_woid = NULL
WHERE MeasurementScaleSourceSheetSettings_id IS NULL
AND MeasurementScaleSourceSheetSettings_woid IS NOT NULL

UPDATE [CostObject]
SET SheetLocation_woid = NULL
WHERE SheetLocation_id IS NULL
AND SheetLocation_woid IS NOT NULL

UPDATE [CostObjectDistributedCost]
SET CostObject_woid = NULL
WHERE CostObject_id IS NULL
AND CostObject_woid IS NOT NULL

UPDATE [CostObjectDistributedCost]
SET DistributedCost_woid = NULL
WHERE DistributedCost_id IS NULL
AND DistributedCost_woid IS NOT NULL

UPDATE [CostObjectTag]
SET CostObject_woid = NULL
WHERE CostObject_id IS NULL
AND CostObject_woid IS NOT NULL

UPDATE [DistributedCostSummary]
SET BudgetCostObject_woid = NULL
WHERE BudgetCostObject_id IS NULL
AND BudgetCostObject_woid IS NOT NULL

UPDATE [MaterialCostSummary]
SET BudgetCostObject_woid = NULL
WHERE BudgetCostObject_id IS NULL
AND BudgetCostObject_woid IS NOT NULL

UPDATE [MaterialKitSummary]
SET BudgetCostObject_woid = NULL
WHERE BudgetCostObject_id IS NULL
AND BudgetCostObject_woid IS NOT NULL

UPDATE [OperationCostSummary]
SET BudgetCostObject_woid = NULL
WHERE BudgetCostObject_id IS NULL
AND BudgetCostObject_woid IS NOT NULL

UPDATE [OpportunityWorkOrder]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [VariableDefinition]
SET DefaultValue_woid = NULL
WHERE DefaultValue_id IS NULL
AND DefaultValue_woid IS NOT NULL

UPDATE [VariableDefinition]
SET VariableCategory_woid = NULL
WHERE VariableCategory_id IS NULL
AND VariableCategory_woid IS NOT NULL

UPDATE [VariableDefinition]
SET VariableSetDefinition_woid = NULL
WHERE VariableSetDefinition_id IS NULL
AND VariableSetDefinition_woid IS NOT NULL

UPDATE [VariableDefinitionCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [VariableInstance]
SET Definition_woid = NULL
WHERE Definition_id IS NULL
AND Definition_woid IS NOT NULL

UPDATE [VariableInstance]
SET ProductEvaluationSpecification_woid = NULL
WHERE ProductEvaluationSpecification_id IS NULL
AND ProductEvaluationSpecification_woid IS NOT NULL

UPDATE [VariableInstance]
SET Value_woid = NULL
WHERE Value_id IS NULL
AND Value_woid IS NOT NULL

UPDATE [VariableInstance]
SET VariableSetValue_woid = NULL
WHERE VariableSetValue_id IS NULL
AND VariableSetValue_woid IS NOT NULL

UPDATE [VariableValue]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [VariableValue]
SET Operation_woid = NULL
WHERE Operation_id IS NULL
AND Operation_woid IS NOT NULL

UPDATE [VariableValue]
SET VariableDefinition_woid = NULL
WHERE VariableDefinition_id IS NULL
AND VariableDefinition_woid IS NOT NULL

UPDATE [VariableSetInstance]
SET Definition_woid = NULL
WHERE Definition_id IS NULL
AND Definition_woid IS NOT NULL

UPDATE [VariableSetInstance]
SET ProductEvaluationSpecification_woid = NULL
WHERE ProductEvaluationSpecification_id IS NULL
AND ProductEvaluationSpecification_woid IS NOT NULL

UPDATE [VariableSetInstance]
SET Value_woid = NULL
WHERE Value_id IS NULL
AND Value_woid IS NOT NULL

UPDATE [VariableSetValue]
SET VariableSetDefinition_woid = NULL
WHERE VariableSetDefinition_id IS NULL
AND VariableSetDefinition_woid IS NOT NULL

UPDATE [UomGroup]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [UomGroupCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [UomGroupCommonSize]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [UomGroupCommonSize]
SET UomGroup_woid = NULL
WHERE UomGroup_id IS NULL
AND UomGroup_woid IS NOT NULL

UPDATE [CommonSize]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [CommonSizeCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [Product]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [Product]
SET ProductLabelDescription_woid = NULL
WHERE ProductLabelDescription_id IS NULL
AND ProductLabelDescription_woid IS NOT NULL

UPDATE [Product]
SET X_woid = NULL
WHERE X_id IS NULL
AND X_woid IS NOT NULL

UPDATE [Product]
SET Y_woid = NULL
WHERE Y_id IS NULL
AND Y_woid IS NOT NULL

UPDATE [Product]
SET Z_woid = NULL
WHERE Z_id IS NULL
AND Z_woid IS NOT NULL

UPDATE [EvaluationBundleSnapshot]
SET EvaluationSnapshot_woid = NULL
WHERE EvaluationSnapshot_id IS NULL
AND EvaluationSnapshot_woid IS NOT NULL

UPDATE [EvaluationSnapshot]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [EvaluationVariableSnapshot]
SET EvaluationSnapshot_woid = NULL
WHERE EvaluationSnapshot_id IS NULL
AND EvaluationSnapshot_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Item_woid = NULL
WHERE Item_id IS NULL
AND Item_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Part_woid = NULL
WHERE Part_id IS NULL
AND Part_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET X_woid = NULL
WHERE X_id IS NULL
AND X_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Y_woid = NULL
WHERE Y_id IS NULL
AND Y_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Z_woid = NULL
WHERE Z_id IS NULL
AND Z_woid IS NOT NULL

UPDATE [CostFormulaAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [CostFormulaAddition]
SET InlineFormula_woid = NULL
WHERE InlineFormula_id IS NULL
AND InlineFormula_woid IS NOT NULL

UPDATE [CostFormulaAddition]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [MaterialAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [MaterialAddition]
SET Item_woid = NULL
WHERE Item_id IS NULL
AND Item_woid IS NOT NULL

UPDATE [MaterialAddition]
SET Part_woid = NULL
WHERE Part_id IS NULL
AND Part_woid IS NOT NULL

UPDATE [MaterialAddition]
SET Variable_woid = NULL
WHERE Variable_id IS NULL
AND Variable_woid IS NOT NULL

UPDATE [OperationAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [OperationAddition]
SET Item_woid = NULL
WHERE Item_id IS NULL
AND Item_woid IS NOT NULL

UPDATE [OperationAddition]
SET Part_woid = NULL
WHERE Part_id IS NULL
AND Part_woid IS NOT NULL

UPDATE [OperationAddition]
SET Variable_woid = NULL
WHERE Variable_id IS NULL
AND Variable_woid IS NOT NULL

UPDATE [PartAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [PartAddition]
SET Item_woid = NULL
WHERE Item_id IS NULL
AND Item_woid IS NOT NULL

UPDATE [PartAddition]
SET Part_woid = NULL
WHERE Part_id IS NULL
AND Part_woid IS NOT NULL

UPDATE [PartAddition]
SET X_woid = NULL
WHERE X_id IS NULL
AND X_woid IS NOT NULL

UPDATE [PartAddition]
SET Y_woid = NULL
WHERE Y_id IS NULL
AND Y_woid IS NOT NULL

UPDATE [PartAddition]
SET Z_woid = NULL
WHERE Z_id IS NULL
AND Z_woid IS NOT NULL

UPDATE [PartBase]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET AssemblyAddition_woid = NULL
WHERE AssemblyAddition_id IS NULL
AND AssemblyAddition_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET InlineFormula_woid = NULL
WHERE InlineFormula_id IS NULL
AND InlineFormula_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET PartAddition_woid = NULL
WHERE PartAddition_id IS NULL
AND PartAddition_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET VariableDefinition_woid = NULL
WHERE VariableDefinition_id IS NULL
AND VariableDefinition_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET VariableValue_woid = NULL
WHERE VariableValue_id IS NULL
AND VariableValue_woid IS NOT NULL

UPDATE [VariableAddition]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [VariableAddition]
SET Variable_woid = NULL
WHERE Variable_id IS NULL
AND Variable_woid IS NOT NULL

UPDATE [VariableSetAddition]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [VariableSetAddition]
SET VariableSetDefinition_woid = NULL
WHERE VariableSetDefinition_id IS NULL
AND VariableSetDefinition_woid IS NOT NULL

UPDATE [ProductLibraryCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [Part]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [Assembly]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [Operation]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [Operation]
SET OperationType_woid = NULL
WHERE OperationType_id IS NULL
AND OperationType_woid IS NOT NULL

UPDATE [PrecedingOperation]
SET Operation_woid = NULL
WHERE Operation_id IS NULL
AND Operation_woid IS NOT NULL

UPDATE [PrecedingOperation]
SET Predecessor_woid = NULL
WHERE Predecessor_id IS NULL
AND Predecessor_woid IS NOT NULL

UPDATE [OperationDuration]
SET LaborItem_woid = NULL
WHERE LaborItem_id IS NULL
AND LaborItem_woid IS NOT NULL

UPDATE [OperationDuration]
SET Location_woid = NULL
WHERE Location_id IS NULL
AND Location_woid IS NOT NULL

UPDATE [OperationDuration]
SET Operation_woid = NULL
WHERE Operation_id IS NULL
AND Operation_woid IS NOT NULL

UPDATE [OperationDuration]
SET ProductivityRegister_woid = NULL
WHERE ProductivityRegister_id IS NULL
AND ProductivityRegister_woid IS NOT NULL

UPDATE [OperationCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [Vendor]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialKit]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [MaterialKitMaterial]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialKitMaterial]
SET MaterialKit_woid = NULL
WHERE MaterialKit_id IS NULL
AND MaterialKit_woid IS NOT NULL

UPDATE [MaterialAttachment]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialImage]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [Material]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [Material]
SET DefaultCommonSize_woid = NULL
WHERE DefaultCommonSize_id IS NULL
AND DefaultCommonSize_woid IS NOT NULL

UPDATE [Material]
SET PurchaseUomGroup_woid = NULL
WHERE PurchaseUomGroup_id IS NULL
AND PurchaseUomGroup_woid IS NOT NULL

UPDATE [MaterialCharacteristic]
SET Characteristic_woid = NULL
WHERE Characteristic_id IS NULL
AND Characteristic_woid IS NOT NULL

UPDATE [MaterialCharacteristic]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialInventoryLevels]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [MaterialInventoryLevels]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialSubstitute]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialSubstitute]
SET Substitute_woid = NULL
WHERE Substitute_id IS NULL
AND Substitute_woid IS NOT NULL

UPDATE [MaterialCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [LaborCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [LaborItem]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [LaborItem]
SET Location_woid = NULL
WHERE Location_id IS NULL
AND Location_woid IS NOT NULL

UPDATE [Burden]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [BurdenCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [LaborItemBurden]
SET Burden_woid = NULL
WHERE Burden_id IS NULL
AND Burden_woid IS NOT NULL

UPDATE [LaborItemBurden]
SET LaborItem_woid = NULL
WHERE LaborItem_id IS NULL
AND LaborItem_woid IS NOT NULL

UPDATE [SummaryBurden]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [FormulaArgument]
SET Formula_woid = NULL
WHERE Formula_id IS NULL
AND Formula_woid IS NOT NULL

UPDATE [FormulaDependency]
SET Child_woid = NULL
WHERE Child_id IS NULL
AND Child_woid IS NOT NULL

UPDATE [FormulaDependency]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [InlineFormula]
SET Formula_woid = NULL
WHERE Formula_id IS NULL
AND Formula_woid IS NOT NULL

UPDATE [ReusableFormula]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [ReusableFormula]
SET Formula_woid = NULL
WHERE Formula_id IS NULL
AND Formula_woid IS NOT NULL

UPDATE [FormulaCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [StockedMaterial]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [StockedMaterial]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [TenantFacility]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [TaxQuestionnaireAnswer]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [TaxQuestionNote]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [TaxRate]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [ProjectWorkOrderCostObject]
SET CostObject_woid = NULL
WHERE CostObject_id IS NULL
AND CostObject_woid IS NOT NULL

UPDATE [Requisition]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [Requisition]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialApprovalItem]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [BomEntry]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [BomEntry]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [SovCostObject]
SET CostObject_woid = NULL
WHERE CostObject_id IS NULL
AND CostObject_woid IS NOT NULL

UPDATE [ImageAttachment]
SET Image_woid = NULL
WHERE Image_id IS NULL
AND Image_woid IS NOT NULL


[SQL: INSERT INTO [ScaleCalibration](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
KnownLengthFormat,
KnownLengthInches,
layerId,
ModifiedBy,
ModifiedDate,
ScaleDefinition_id,
ScaleDistanceInPixels,
ScaleDistanceInRealityFormat,
ScaleDistanceInRealityInches,
Shape,
SourceBlueprintFileId,
Style,
Tenant,
Type,
url_Value,
ScaleDefinition_woid,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
KnownLengthFormat,
KnownLengthInches,
layerId,
ModifiedBy,
ModifiedDate,
null,
ScaleDistanceInPixels,
ScaleDistanceInRealityFormat,
ScaleDistanceInRealityInches,
Shape,
SourceBlueprintFileId,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ScaleCalibration]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ScaleDefinition](CreatedBy,
CreatedDate,
Id,
IsActive,
KnownLengthFormat,
KnownLengthInches,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
ScaleCalibration_id,
Tenant,
Type,
ScaleCalibration_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
KnownLengthFormat,
KnownLengthInches,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
ScaleCalibration_id,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ScaleDefinition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
UPDATE calibration
							SET calibration.[ScaleDefinition_id] = (
								SELECT ScaleDefinition_id
								FROM [ScaleCalibration]
								WHERE woid = '00000000-0000-0000-0000-000000000000'
								AND Id = calibration.[Id]),
								calibration.[ScaleDefinition_woid] = '59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
							FROM [ScaleCalibration] calibration
							WHERE calibration.woid = '59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
							AND calibration.[ScaleDefinition_id] IS NULL
INSERT INTO [Calibration](calibrationId,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ScaleDefinition_id,
ScaleDistanceInPixels,
ScaleDistanceInRealityFormat,
ScaleDistanceInRealityInches,
Tenant,
ScaleDefinition_woid,
woid)
						 SELECT calibrationId,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ScaleDefinition_id,
ScaleDistanceInPixels,
ScaleDistanceInRealityFormat,
ScaleDistanceInRealityInches,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Calibration]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TakeoffBlueprint](blueprint_Id,
Calibration_id,
CreatedBy,
CreatedDate,
Grayscale,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
workorder_Id,
Calibration_woid,
woid)
						 SELECT blueprint_Id,
Calibration_id,
CreatedBy,
CreatedDate,
Grayscale,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
workorder_Id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TakeoffBlueprint]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ScaleArea](blueprintId,
Calibration_id,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
Calibration_woid,
woid)
						 SELECT blueprintId,
Calibration_id,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ScaleArea]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [LaborCategory](CreatedBy,
CreatedDate,
directcostcurrencyCode,
directcostcurrencySymbol,
directcostValue,
Id,
IsActive,
Level,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
profitcurrencyCode,
profitcurrencySymbol,
profitFraction,
profitMethod,
profitValue,
profitValueType,
Tenant,
TenantFacility_id,
totalcostcurrencyCode,
totalcostcurrencySymbol,
totalcostValue,
totalsellcurrencyCode,
totalsellcurrencySymbol,
totalsellValue,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
directcostcurrencyCode,
directcostcurrencySymbol,
directcostValue,
Id,
IsActive,
Level,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
profitcurrencyCode,
profitcurrencySymbol,
profitFraction,
profitMethod,
profitValue,
profitValueType,
Tenant,
TenantFacility_id,
totalcostcurrencyCode,
totalcostcurrencySymbol,
totalcostValue,
totalsellcurrencyCode,
totalsellcurrencySymbol,
totalsellValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [LaborCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductsPallet](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductsPallet]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Location](blueprintId,
Building,
CreatedBy,
CreatedDate,
DisplayName,
Floor,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Name,
Number,
ScopeNote,
Shape,
Style,
Tenant,
Type,
url_Value,
Zone,
woid)
						 SELECT blueprintId,
Building,
CreatedBy,
CreatedDate,
DisplayName,
Floor,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Name,
Number,
ScopeNote,
Shape,
Style,
Tenant,
Type,
url_Value,
Zone,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Location]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Layer](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Type,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Layer]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostObjectLayer](BidOriginId,
Layer_id,
Layer_woid)
						 SELECT BidOriginId,
Layer_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostObjectLayer]
						 WHERE Layer_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Image](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Image]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [DistributedCost](AmountCurrencyCode,
AmountCurrencySymbol,
AmountValue,
Category,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
woid)
						 SELECT AmountCurrencyCode,
AmountCurrencySymbol,
AmountValue,
Category,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [DistributedCost]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Budget](AlternatesSettings,
AlternatesSummaryCalculationMode,
BaseBidSettings,
CreatedBy,
CreatedDate,
Id,
IsActive,
LockedCostObjects,
ModifiedBy,
ModifiedDate,
SettingsVersionStamp,
Tenant,
woid)
						 SELECT AlternatesSettings,
AlternatesSummaryCalculationMode,
BaseBidSettings,
CreatedBy,
CreatedDate,
Id,
IsActive,
LockedCostObjects,
ModifiedBy,
ModifiedDate,
SettingsVersionStamp,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Budget]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [BidOrigin](CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Status,
Tenant,
Type,
woid)
						 SELECT CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Status,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [BidOrigin]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Annotation](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Annotation]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableSetDefinition](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
ShortName,
Tenant,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
ShortName,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableSetDefinition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableSetValue](CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsDefault,
ModifiedBy,
ModifiedDate,
Name,
Reference,
Tenant,
VariableSetDefinition_id,
VariableSetDefinition_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsDefault,
ModifiedBy,
ModifiedDate,
Name,
Reference,
Tenant,
VariableSetDefinition_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableSetValue]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableDefinitionCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableDefinitionCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [UomGroupCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [UomGroupCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [UomGroup](BaseUom_id,
Category_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Category_woid,
woid)
						 SELECT BaseUom_id,
Category_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [UomGroup]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CommonSizeCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CommonSizeCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CommonSize](BaseUom_id,
Category_id,
ConversionFactor,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Category_woid,
woid)
						 SELECT BaseUom_id,
Category_id,
ConversionFactor,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CommonSize]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CustomMaterial](Category_Id,
CostCurrencyCode,
CostCurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
DefaultCommonSize_id,
Id,
IsActive,
ManufacturerSku,
ManufacturerUrlValue,
ModifiedBy,
ModifiedDate,
Name,
ProfitCurrencyCode,
ProfitCurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
PurchaseUomGroup_id,
SellCurrencyCode,
SellCurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
WeightSymbol,
WeightUnit,
WeightValue,
Category_woid,
DefaultCommonSize_woid,
PurchaseUomGroup_woid,
woid)
						 SELECT Category_Id,
CostCurrencyCode,
CostCurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
DefaultCommonSize_id,
Id,
IsActive,
ManufacturerSku,
ManufacturerUrlValue,
ModifiedBy,
ModifiedDate,
Name,
ProfitCurrencyCode,
ProfitCurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
PurchaseUomGroup_id,
SellCurrencyCode,
SellCurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
WeightSymbol,
WeightUnit,
WeightValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CustomMaterial]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [UomGroupCommonSize](CommonSize_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
IsDefault,
ModifiedBy,
ModifiedDate,
Tenant,
UomGroup_id,
CommonSize_woid,
UomGroup_woid,
woid)
						 SELECT CommonSize_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
IsDefault,
ModifiedBy,
ModifiedDate,
Tenant,
UomGroup_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [UomGroupCommonSize]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductLabelDescription](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
X_Description,
Y_Description,
Z_Description,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
X_Description,
Y_Description,
Z_Description,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductLabelDescription]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductLibraryCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Type,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductLibraryCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Formula](Body,
CompiledBody,
CompiledBodySelf,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ReturnTypeKind,
Tenant,
woid)
						 SELECT Body,
CompiledBody,
CompiledBodySelf,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ReturnTypeKind,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Formula]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [InlineFormula](Formula_id,
Formula_woid)
						 SELECT Formula_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [InlineFormula]
						 WHERE Formula_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [PartBase](Category_id,
CreatedBy,
CreatedDate,
Dimensions,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
OriginalNameValue,
Tenant,
Category_woid,
woid)
						 SELECT Category_id,
CreatedBy,
CreatedDate,
Dimensions,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
OriginalNameValue,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [PartBase]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Assembly](PartBase_id,
PartBase_woid)
						 SELECT PartBase_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Assembly]
						 WHERE PartBase_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Product](BaseUom_id,
ImageIdentifier,
ImageName,
PartBase_id,
ProductAdditions_id,
ProductLabelDescription_Id,
X_id,
Y_id,
Z_id,
PartBase_woid,
ProductLabelDescription_woid,
X_woid,
Y_woid,
Z_woid)
						 SELECT BaseUom_id,
ImageIdentifier,
ImageName,
PartBase_id,
ProductAdditions_id,
ProductLabelDescription_Id,
X_id,
Y_id,
Z_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Product]
						 WHERE PartBase_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Part](PartBase_id,
PartBase_woid)
						 SELECT PartBase_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Part]
						 WHERE PartBase_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductEvaluationSpecifications](Completed,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Type,
VersionStamp,
woid)
						 SELECT Completed,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Type,
VersionStamp,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductEvaluationSpecifications]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductEvaluationSpecification](AdditionalCostsCashItems,
AdditionalCostsMaterials,
AdditionalCostsOperations,
Completed,
CreatedBy,
CreatedDate,
DimensionsCount,
DimensionsXFormat,
DimensionsXInches,
DimensionsYFormat,
DimensionsYInches,
DimensionsZFormat,
DimensionsZInches,
Facility_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecifications_id,
ProductTemplate_id,
Quantity,
Tenant,
Facility_woid,
ProductEvaluationSpecifications_woid,
ProductTemplate_woid,
woid)
						 SELECT AdditionalCostsCashItems,
AdditionalCostsMaterials,
AdditionalCostsOperations,
Completed,
CreatedBy,
CreatedDate,
DimensionsCount,
DimensionsXFormat,
DimensionsXInches,
DimensionsYFormat,
DimensionsYInches,
DimensionsZFormat,
DimensionsZInches,
Facility_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecifications_id,
ProductTemplate_id,
Quantity,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductEvaluationSpecification]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [AttachedProduct](AttachingDate,
CreatedBy,
CreatedDate,
DefaultShapeRepresentation,
EachTakeOffMethodType,
EvaluationSpecifications_id,
Fill,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
ProductsPallet_id,
SpriteType,
State,
TakeOffMethod,
TaxRegulationsType,
Tenant,
EvaluationSpecifications_woid,
ProductsPallet_woid,
woid)
						 SELECT AttachingDate,
CreatedBy,
CreatedDate,
DefaultShapeRepresentation,
EachTakeOffMethodType,
EvaluationSpecifications_id,
Fill,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
ProductsPallet_id,
SpriteType,
State,
TakeOffMethod,
TaxRegulationsType,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [AttachedProduct]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [AttachedProductDistributedCost](AttachedProduct_id,
CreatedBy,
CreatedDate,
DistributedCost_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
AttachedProduct_woid,
DistributedCost_woid,
woid)
						 SELECT AttachedProduct_id,
CreatedBy,
CreatedDate,
DistributedCost_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [AttachedProductDistributedCost]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TypicalGroup](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
MarkerType,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
MarkerType,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TypicalGroup]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostObject](AttachedProduct_id,
BidOriginId,
BidOriginIdVersionStamp,
blueprintId,
CostObjectBaseBidVersionId,
CostObjectState,
CreatedBy,
CreatedDate,
DisplayName,
DistributedCostsVersionStamp,
EachTakeOffMethodType,
EvaluationSpecifications_id,
Id,
IsActive,
layerId,
MeasurementCalculationMessage,
MeasurementLengthFormat,
MeasurementLengthInches,
MeasurementScaleSourceScaleArea_id,
MeasurementScaleSourceScaleDistanceInPixels,
MeasurementScaleSourceScaleDistanceInRealityFormat,
MeasurementScaleSourceScaleDistanceInRealityInches,
MeasurementScaleSourceSheetSettings_id,
MeasurementScaleSourceType,
MeasurementSurfaceAreaSquareInches,
ModifiedBy,
ModifiedDate,
PriceAdjustmentVersionStamp,
RawFabricationPriceAdjustmentFixedValuecurrencyCode,
RawFabricationPriceAdjustmentFixedValuecurrencySymbol,
RawFabricationPriceAdjustmentFixedValueValue,
RawFabricationPriceAdjustmentPercentageFraction,
RawInstalationPriceAdjustmentFixedValuecurrencyCode,
RawInstalationPriceAdjustmentFixedValuecurrencySymbol,
RawInstalationPriceAdjustmentFixedValueValue,
RawInstalationPriceAdjustmentPercentageFraction,
SequenceIdentifier,
Shape,
SheetLocation_id,
SourceProductName,
Style,
TakeOffMethod,
TaxRegulationsType,
TaxRegulationsVersionStamp,
Tenant,
Type,
TypicalGroupId,
url_Value,
AttachedProduct_woid,
EvaluationSpecifications_woid,
MeasurementScaleSourceScaleArea_woid,
MeasurementScaleSourceSheetSettings_woid,
SheetLocation_woid,
woid)
						 SELECT AttachedProduct_id,
BidOriginId,
BidOriginIdVersionStamp,
blueprintId,
CostObjectBaseBidVersionId,
CostObjectState,
CreatedBy,
CreatedDate,
DisplayName,
DistributedCostsVersionStamp,
EachTakeOffMethodType,
EvaluationSpecifications_id,
Id,
IsActive,
layerId,
MeasurementCalculationMessage,
MeasurementLengthFormat,
MeasurementLengthInches,
MeasurementScaleSourceScaleArea_id,
MeasurementScaleSourceScaleDistanceInPixels,
MeasurementScaleSourceScaleDistanceInRealityFormat,
MeasurementScaleSourceScaleDistanceInRealityInches,
MeasurementScaleSourceSheetSettings_id,
MeasurementScaleSourceType,
MeasurementSurfaceAreaSquareInches,
ModifiedBy,
ModifiedDate,
PriceAdjustmentVersionStamp,
RawFabricationPriceAdjustmentFixedValuecurrencyCode,
RawFabricationPriceAdjustmentFixedValuecurrencySymbol,
RawFabricationPriceAdjustmentFixedValueValue,
RawFabricationPriceAdjustmentPercentageFraction,
RawInstalationPriceAdjustmentFixedValuecurrencyCode,
RawInstalationPriceAdjustmentFixedValuecurrencySymbol,
RawInstalationPriceAdjustmentFixedValueValue,
RawInstalationPriceAdjustmentPercentageFraction,
SequenceIdentifier,
Shape,
SheetLocation_id,
SourceProductName,
Style,
TakeOffMethod,
TaxRegulationsType,
TaxRegulationsVersionStamp,
Tenant,
Type,
TypicalGroupId,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostObject]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [EvaluatedCostObject](CostsAmounts,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecificationsId,
ProductEvaluationSpecificationsVersionStamp,
Tenant,
ValidityIsValid,
ValidityMessage,
VersionStamp,
woid)
						 SELECT CostsAmounts,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecificationsId,
ProductEvaluationSpecificationsVersionStamp,
Tenant,
ValidityIsValid,
ValidityMessage,
VersionStamp,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [EvaluatedCostObject]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [BudgetCostObject](BaseFacilityId,
BaselinePricecurrencyCode,
BaselinePricecurrencySymbol,
BaselinePriceValue,
BaselineProfitcurrencyCode,
BaselineProfitcurrencySymbol,
BaselineProfitFraction,
BaselineProfitMethod,
BaselineProfitValue,
BaselineProfitValueType,
BidOriginId,
BidOriginIdVersionStamp,
BudgetPriceAdjustmentFabricationcurrencyCode,
BudgetPriceAdjustmentFabricationcurrencySymbol,
BudgetPriceAdjustmentFabricationFraction,
BudgetPriceAdjustmentFabricationMethod,
BudgetPriceAdjustmentFabricationValue,
BudgetPriceAdjustmentFabricationValueType,
BudgetPriceAdjustmentInstallationcurrencyCode,
BudgetPriceAdjustmentInstallationcurrencySymbol,
BudgetPriceAdjustmentInstallationFraction,
BudgetPriceAdjustmentInstallationMethod,
BudgetPriceAdjustmentInstallationValue,
BudgetPriceAdjustmentInstallationValueType,
CashSummaryTotalCostcurrencyCode,
CashSummaryTotalCostcurrencySymbol,
CashSummaryTotalCostValue,
CashSummaryTotalProfitcurrencyCode,
CashSummaryTotalProfitcurrencySymbol,
CashSummaryTotalProfitFraction,
CashSummaryTotalProfitMethod,
CashSummaryTotalProfitValue,
CashSummaryTotalProfitValueType,
CostcurrencyCode,
CostcurrencySymbol,
CostValue,
CreatedBy,
CreatedDate,
DirectPriceAdjustmentFabricationcurrencyCode,
DirectPriceAdjustmentFabricationcurrencySymbol,
DirectPriceAdjustmentFabricationFraction,
DirectPriceAdjustmentFabricationMethod,
DirectPriceAdjustmentFabricationValue,
DirectPriceAdjustmentFabricationValueType,
DirectPriceAdjustmentInstallationcurrencyCode,
DirectPriceAdjustmentInstallationcurrencySymbol,
DirectPriceAdjustmentInstallationFraction,
DirectPriceAdjustmentInstallationMethod,
DirectPriceAdjustmentInstallationValue,
DirectPriceAdjustmentInstallationValueType,
DistributedCostRedistributionWeightcurrencyCode,
DistributedCostRedistributionWeightcurrencySymbol,
DistributedCostRedistributionWeightValue,
DistributedCostsVersionStamp,
EvaluatedCostObjectVersionStamp,
ExtendedFabricationCostcurrencyCode,
ExtendedFabricationCostcurrencySymbol,
ExtendedFabricationCostValue,
ExtendedInstallCostcurrencyCode,
ExtendedInstallCostcurrencySymbol,
ExtendedInstallCostValue,
ExtendedLaborCostcurrencyCode,
ExtendedLaborCostcurrencySymbol,
ExtendedLaborCostValue,
ExtendedMaterialCostcurrencyCode,
ExtendedMaterialCostcurrencySymbol,
ExtendedMaterialCostValue,
Id,
InstallBaselinePricecurrencyCode,
InstallBaselinePricecurrencySymbol,
InstallBaselinePriceValue,
InstallBaselineProfitcurrencyCode,
InstallBaselineProfitcurrencySymbol,
InstallBaselineProfitFraction,
InstallBaselineProfitMethod,
InstallBaselineProfitValue,
InstallBaselineProfitValueType,
InstallCostcurrencyCode,
InstallCostcurrencySymbol,
InstallCostValue,
InstallDurationSeconds,
InstallPreSellTaxPricecurrencyCode,
InstallPreSellTaxPricecurrencySymbol,
InstallPreSellTaxPriceValue,
InstallPriceAdjustmentcurrencyCode,
InstallPriceAdjustmentcurrencySymbol,
InstallPriceAdjustmentFraction,
InstallPriceAdjustmentMethod,
InstallPriceAdjustmentValue,
InstallPriceAdjustmentValueType,
InstallPricecurrencyCode,
InstallPricecurrencySymbol,
InstallPriceValue,
InstallProfitcurrencyCode,
InstallProfitcurrencySymbol,
InstallProfitFraction,
InstallProfitMethod,
InstallProfitPerHourcurrencyCode,
InstallProfitPerHourcurrencySymbol,
InstallProfitPerHourFraction,
InstallProfitPerHourMethod,
InstallProfitPerHourValue,
InstallProfitPerHourValueType,
InstallProfitValue,
InstallProfitValueType,
InstallSellTaxcurrencyCode,
InstallSellTaxcurrencySymbol,
InstallSellTaxValue,
InstallUseTaxcurrencyCode,
InstallUseTaxcurrencySymbol,
InstallUseTaxValue,
IsActive,
LaborDurationSeconds,
LaborProfitPerHourcurrencyCode,
LaborProfitPerHourcurrencySymbol,
LaborProfitPerHourFraction,
LaborProfitPerHourMethod,
LaborProfitPerHourValue,
LaborProfitPerHourValueType,
LibraryFabricationCostcurrencyCode,
LibraryFabricationCostcurrencySymbol,
LibraryFabricationCostValue,
LibraryInstallCostcurrencyCode,
LibraryInstallCostcurrencySymbol,
LibraryInstallCostValue,
LibraryMaterialCostcurrencyCode,
LibraryMaterialCostcurrencySymbol,
LibraryMaterialCostValue,
LibraryOverheadCostcurrencyCode,
LibraryOverheadCostcurrencySymbol,
LibraryOverheadCostValue,
ModifiedBy,
ModifiedDate,
PreSellTaxPricecurrencyCode,
PreSellTaxPricecurrencySymbol,
PreSellTaxPriceValue,
PriceAdjustmentcurrencyCode,
PriceAdjustmentcurrencySymbol,
PriceAdjustmentFraction,
PriceAdjustmentMethod,
PriceAdjustmentValue,
PriceAdjustmentValueType,
PriceAdjustmentVersionStamp,
PricecurrencyCode,
PricecurrencySymbol,
PriceValue,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
SellTaxcurrencyCode,
SellTaxcurrencySymbol,
SellTaxValue,
TaxRegulationsType,
TaxRegulationsVersionStamp,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalDurationSeconds,
TotalPreSellTaxPricecurrencyCode,
TotalPreSellTaxPricecurrencySymbol,
TotalPreSellTaxPriceValue,
TotalPricecurrencyCode,
TotalPricecurrencySymbol,
TotalPriceValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitPerHourcurrencyCode,
TotalProfitPerHourcurrencySymbol,
TotalProfitPerHourFraction,
TotalProfitPerHourMethod,
TotalProfitPerHourValue,
TotalProfitPerHourValueType,
TotalProfitValue,
TotalProfitValueType,
TotalSellTaxcurrencyCode,
TotalSellTaxcurrencySymbol,
TotalSellTaxValue,
UseTaxcurrencyCode,
UseTaxcurrencySymbol,
UseTaxValue,
ValidityIsValid,
ValidityMessage,
woid)
						 SELECT BaseFacilityId,
BaselinePricecurrencyCode,
BaselinePricecurrencySymbol,
BaselinePriceValue,
BaselineProfitcurrencyCode,
BaselineProfitcurrencySymbol,
BaselineProfitFraction,
BaselineProfitMethod,
BaselineProfitValue,
BaselineProfitValueType,
BidOriginId,
BidOriginIdVersionStamp,
BudgetPriceAdjustmentFabricationcurrencyCode,
BudgetPriceAdjustmentFabricationcurrencySymbol,
BudgetPriceAdjustmentFabricationFraction,
BudgetPriceAdjustmentFabricationMethod,
BudgetPriceAdjustmentFabricationValue,
BudgetPriceAdjustmentFabricationValueType,
BudgetPriceAdjustmentInstallationcurrencyCode,
BudgetPriceAdjustmentInstallationcurrencySymbol,
BudgetPriceAdjustmentInstallationFraction,
BudgetPriceAdjustmentInstallationMethod,
BudgetPriceAdjustmentInstallationValue,
BudgetPriceAdjustmentInstallationValueType,
CashSummaryTotalCostcurrencyCode,
CashSummaryTotalCostcurrencySymbol,
CashSummaryTotalCostValue,
CashSummaryTotalProfitcurrencyCode,
CashSummaryTotalProfitcurrencySymbol,
CashSummaryTotalProfitFraction,
CashSummaryTotalProfitMethod,
CashSummaryTotalProfitValue,
CashSummaryTotalProfitValueType,
CostcurrencyCode,
CostcurrencySymbol,
CostValue,
CreatedBy,
CreatedDate,
DirectPriceAdjustmentFabricationcurrencyCode,
DirectPriceAdjustmentFabricationcurrencySymbol,
DirectPriceAdjustmentFabricationFraction,
DirectPriceAdjustmentFabricationMethod,
DirectPriceAdjustmentFabricationValue,
DirectPriceAdjustmentFabricationValueType,
DirectPriceAdjustmentInstallationcurrencyCode,
DirectPriceAdjustmentInstallationcurrencySymbol,
DirectPriceAdjustmentInstallationFraction,
DirectPriceAdjustmentInstallationMethod,
DirectPriceAdjustmentInstallationValue,
DirectPriceAdjustmentInstallationValueType,
DistributedCostRedistributionWeightcurrencyCode,
DistributedCostRedistributionWeightcurrencySymbol,
DistributedCostRedistributionWeightValue,
DistributedCostsVersionStamp,
EvaluatedCostObjectVersionStamp,
ExtendedFabricationCostcurrencyCode,
ExtendedFabricationCostcurrencySymbol,
ExtendedFabricationCostValue,
ExtendedInstallCostcurrencyCode,
ExtendedInstallCostcurrencySymbol,
ExtendedInstallCostValue,
ExtendedLaborCostcurrencyCode,
ExtendedLaborCostcurrencySymbol,
ExtendedLaborCostValue,
ExtendedMaterialCostcurrencyCode,
ExtendedMaterialCostcurrencySymbol,
ExtendedMaterialCostValue,
Id,
InstallBaselinePricecurrencyCode,
InstallBaselinePricecurrencySymbol,
InstallBaselinePriceValue,
InstallBaselineProfitcurrencyCode,
InstallBaselineProfitcurrencySymbol,
InstallBaselineProfitFraction,
InstallBaselineProfitMethod,
InstallBaselineProfitValue,
InstallBaselineProfitValueType,
InstallCostcurrencyCode,
InstallCostcurrencySymbol,
InstallCostValue,
InstallDurationSeconds,
InstallPreSellTaxPricecurrencyCode,
InstallPreSellTaxPricecurrencySymbol,
InstallPreSellTaxPriceValue,
InstallPriceAdjustmentcurrencyCode,
InstallPriceAdjustmentcurrencySymbol,
InstallPriceAdjustmentFraction,
InstallPriceAdjustmentMethod,
InstallPriceAdjustmentValue,
InstallPriceAdjustmentValueType,
InstallPricecurrencyCode,
InstallPricecurrencySymbol,
InstallPriceValue,
InstallProfitcurrencyCode,
InstallProfitcurrencySymbol,
InstallProfitFraction,
InstallProfitMethod,
InstallProfitPerHourcurrencyCode,
InstallProfitPerHourcurrencySymbol,
InstallProfitPerHourFraction,
InstallProfitPerHourMethod,
InstallProfitPerHourValue,
InstallProfitPerHourValueType,
InstallProfitValue,
InstallProfitValueType,
InstallSellTaxcurrencyCode,
InstallSellTaxcurrencySymbol,
InstallSellTaxValue,
InstallUseTaxcurrencyCode,
InstallUseTaxcurrencySymbol,
InstallUseTaxValue,
IsActive,
LaborDurationSeconds,
LaborProfitPerHourcurrencyCode,
LaborProfitPerHourcurrencySymbol,
LaborProfitPerHourFraction,
LaborProfitPerHourMethod,
LaborProfitPerHourValue,
LaborProfitPerHourValueType,
LibraryFabricationCostcurrencyCode,
LibraryFabricationCostcurrencySymbol,
LibraryFabricationCostValue,
LibraryInstallCostcurrencyCode,
LibraryInstallCostcurrencySymbol,
LibraryInstallCostValue,
LibraryMaterialCostcurrencyCode,
LibraryMaterialCostcurrencySymbol,
LibraryMaterialCostValue,
LibraryOverheadCostcurrencyCode,
LibraryOverheadCostcurrencySymbol,
LibraryOverheadCostValue,
ModifiedBy,
ModifiedDate,
PreSellTaxPricecurrencyCode,
PreSellTaxPricecurrencySymbol,
PreSellTaxPriceValue,
PriceAdjustmentcurrencyCode,
PriceAdjustmentcurrencySymbol,
PriceAdjustmentFraction,
PriceAdjustmentMethod,
PriceAdjustmentValue,
PriceAdjustmentValueType,
PriceAdjustmentVersionStamp,
PricecurrencyCode,
PricecurrencySymbol,
PriceValue,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
SellTaxcurrencyCode,
SellTaxcurrencySymbol,
SellTaxValue,
TaxRegulationsType,
TaxRegulationsVersionStamp,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalDurationSeconds,
TotalPreSellTaxPricecurrencyCode,
TotalPreSellTaxPricecurrencySymbol,
TotalPreSellTaxPriceValue,
TotalPricecurrencyCode,
TotalPricecurrencySymbol,
TotalPriceValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitPerHourcurrencyCode,
TotalProfitPerHourcurrencySymbol,
TotalProfitPerHourFraction,
TotalProfitPerHourMethod,
TotalProfitPerHourValue,
TotalProfitPerHourValueType,
TotalProfitValue,
TotalProfitValueType,
TotalSellTaxcurrencyCode,
TotalSellTaxcurrencySymbol,
TotalSellTaxValue,
UseTaxcurrencyCode,
UseTaxcurrencySymbol,
UseTaxValue,
ValidityIsValid,
ValidityMessage,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [BudgetCostObject]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [DistributedCostSummary](BudgetCostObject_id,
Category,
CostCurrencyCode,
CostCurrencySymbol,
CostValue,
CreatedBy,
CreatedDate,
DistributedCostId,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
BudgetCostObject_woid,
woid)
						 SELECT BudgetCostObject_id,
Category,
CostCurrencyCode,
CostCurrencySymbol,
CostValue,
CreatedBy,
CreatedDate,
DistributedCostId,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [DistributedCostSummary]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialCostSummary](BaseUoMName,
BudgetCostObject_id,
CreatedBy,
CreatedDate,
FacilityId,
Id,
IsActive,
MaterialId,
ModifiedBy,
ModifiedDate,
Name,
Quantity,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitValue,
TotalProfitValueType,
TotalSellcurrencyCode,
TotalSellcurrencySymbol,
TotalSellValue,
UnitCostcurrencyCode,
UnitCostcurrencySymbol,
UnitCostValue,
UnitProfitCurrencyCode,
UnitProfitCurrencySymbol,
UnitProfitFraction,
UnitProfitMethod,
UnitProfitValue,
UnitProfitValueType,
UnitSellCurrencyCode,
UnitSellCurrencySymbol,
UnitSellValue,
BudgetCostObject_woid,
woid)
						 SELECT BaseUoMName,
BudgetCostObject_id,
CreatedBy,
CreatedDate,
FacilityId,
Id,
IsActive,
MaterialId,
ModifiedBy,
ModifiedDate,
Name,
Quantity,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitValue,
TotalProfitValueType,
TotalSellcurrencyCode,
TotalSellcurrencySymbol,
TotalSellValue,
UnitCostcurrencyCode,
UnitCostcurrencySymbol,
UnitCostValue,
UnitProfitCurrencyCode,
UnitProfitCurrencySymbol,
UnitProfitFraction,
UnitProfitMethod,
UnitProfitValue,
UnitProfitValueType,
UnitSellCurrencyCode,
UnitSellCurrencySymbol,
UnitSellValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialCostSummary]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialKitSummary](BudgetCostObject_id,
CreatedBy,
CreatedDate,
FacilityId,
Id,
IsActive,
MaterialKitId,
ModifiedBy,
ModifiedDate,
Quantity,
Tenant,
BudgetCostObject_woid,
woid)
						 SELECT BudgetCostObject_id,
CreatedBy,
CreatedDate,
FacilityId,
Id,
IsActive,
MaterialKitId,
ModifiedBy,
ModifiedDate,
Quantity,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialKitSummary]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostObjectDistributedCost](CostObject_id,
CreatedBy,
CreatedDate,
DistributedCost_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
CostObject_woid,
DistributedCost_woid,
woid)
						 SELECT CostObject_id,
CreatedBy,
CreatedDate,
DistributedCost_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostObjectDistributedCost]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostObjectTag](CostObject_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tag_id,
Tenant,
CostObject_woid,
woid)
						 SELECT CostObject_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tag_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostObjectTag]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [AttachedProductTag](AttachedProduct_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tag_id,
Tenant,
AttachedProduct_woid,
woid)
						 SELECT AttachedProduct_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tag_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [AttachedProductTag]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableSetInstance](CreatedBy,
CreatedDate,
Definition_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecification_id,
Tenant,
Value_id,
Definition_woid,
ProductEvaluationSpecification_woid,
Value_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Definition_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecification_id,
Tenant,
Value_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableSetInstance]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CostFormulaAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
InlineFormula_id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
Amount_woid,
InlineFormula_woid,
PartBase_woid,
woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
InlineFormula_id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CostFormulaAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableDefinition](CreatedBy,
CreatedDate,
DefaultValue_id,
Description,
DisplayName,
Id,
IsActive,
IsInnergy,
Kind,
MaxValue,
MinValue,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Type_id,
ValidationType_id,
VariableCategory_id,
VariableSetDefinition_id,
DefaultValue_woid,
VariableCategory_woid,
VariableSetDefinition_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
null,
Description,
DisplayName,
Id,
IsActive,
IsInnergy,
Kind,
MaxValue,
MinValue,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Type_id,
ValidationType_id,
VariableCategory_id,
VariableSetDefinition_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableDefinition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
Variable_id,
Amount_woid,
Item_woid,
Part_woid,
Variable_woid,
woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
Variable_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableAddition](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
Variable_id,
PartBase_woid,
Variable_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
Variable_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableSetAddition](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
VariableSetDefinition_id,
PartBase_woid,
VariableSetDefinition_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
OrderIndex,
PartBase_id,
Tenant,
VariableSetDefinition_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableSetAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [EvaluationSnapshot](CreatedBy,
CreatedDate,
Id,
IsActive,
Location,
ModifiedBy,
ModifiedDate,
PartBase_id,
Quantity,
Tenant,
X,
Y,
Z,
PartBase_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
Location,
ModifiedBy,
ModifiedDate,
PartBase_id,
Quantity,
Tenant,
X,
Y,
Z,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [EvaluationSnapshot]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [EvaluationBundleSnapshot](BundleId,
CreatedBy,
CreatedDate,
EvaluationSnapshot_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
SourcePath,
Tenant,
Value,
EvaluationSnapshot_woid,
woid)
						 SELECT BundleId,
CreatedBy,
CreatedDate,
EvaluationSnapshot_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
SourcePath,
Tenant,
Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [EvaluationBundleSnapshot]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [EvaluationVariableSnapshot](CreatedBy,
CreatedDate,
EvaluationSnapshot_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
SourcePath,
Tenant,
Value,
VariableId,
EvaluationSnapshot_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
EvaluationSnapshot_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
SourcePath,
Tenant,
Value,
VariableId,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [EvaluationVariableSnapshot]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [PartAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
X_id,
Y_id,
Z_id,
Amount_woid,
Item_woid,
Part_woid,
woid,
X_woid,
Y_woid,
Z_woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
X_id,
Y_id,
Z_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [PartAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationType](CreatedBy,
CreatedDate,
Id,
IsActive,
IsRequired,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Value,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsRequired,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationType]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Operation](BaseUom_id,
Category_id,
CreatedBy,
CreatedDate,
Description,
Id,
Included,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
NotIncluded,
OperationType_Id,
SequenceIdentifier,
Tenant,
Category_woid,
OperationType_woid,
woid)
						 SELECT BaseUom_id,
Category_id,
CreatedBy,
CreatedDate,
Description,
Id,
Included,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
NotIncluded,
OperationType_Id,
SequenceIdentifier,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Operation]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [VariableValue](Boolean,
CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Number,
Operation_id,
Tenant,
Text,
Type_id,
VariableDefinition_id,
Material_woid,
Operation_woid,
VariableDefinition_woid,
woid)
						 SELECT Boolean,
CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Number,
Operation_id,
Tenant,
Text,
Type_id,
VariableDefinition_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableValue]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
UPDATE vd
							SET vd.[DefaultValue_id] = (
								SELECT DefaultValue_id
								FROM [VariableDefinition]
								WHERE woid = '00000000-0000-0000-0000-000000000000'
								AND Id = vd.[Id]),
								vd.[DefaultValue_woid] = '59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
							FROM [VariableDefinition] vd
							WHERE vd.woid = '59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
							AND vd.[DefaultValue_id] IS NULL
INSERT INTO [VariableInstance](CreatedBy,
CreatedDate,
Definition_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecification_id,
Tenant,
Value_id,
VariableSetValue_id,
Definition_woid,
ProductEvaluationSpecification_woid,
Value_woid,
VariableSetValue_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Definition_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
ProductEvaluationSpecification_id,
Tenant,
Value_id,
VariableSetValue_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [VariableInstance]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
Variable_id,
Amount_woid,
Item_woid,
Part_woid,
Variable_woid,
woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
Variable_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ProductivityRegister](CreatedBy,
CreatedDate,
Entries,
Id,
InitialState,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
woid)
						 SELECT CreatedBy,
CreatedDate,
Entries,
Id,
InitialState,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ProductivityRegister]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [PrecedingOperation](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Operation_id,
Predecessor_id,
Tenant,
Operation_woid,
Predecessor_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Operation_id,
Predecessor_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [PrecedingOperation]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [LaborItem](Category_id,
CreatedBy,
CreatedDate,
Department_id,
directcostcurrencyCode,
directcostcurrencySymbol,
DirectCostDataSource,
directcostValue,
Id,
IsActive,
Location_id,
ModifiedBy,
ModifiedDate,
Name,
profitcurrencyCode,
profitcurrencySymbol,
profitFraction,
profitMethod,
profitValue,
profitValueType,
Tenant,
totalcostcurrencyCode,
totalcostcurrencySymbol,
totalcostValue,
TotalLaborTime,
totalsellcurrencyCode,
totalsellcurrencySymbol,
totalsellValue,
Unit,
Category_woid,
Location_woid,
woid)
						 SELECT Category_id,
CreatedBy,
CreatedDate,
Department_id,
directcostcurrencyCode,
directcostcurrencySymbol,
DirectCostDataSource,
directcostValue,
Id,
IsActive,
Location_id,
ModifiedBy,
ModifiedDate,
Name,
profitcurrencyCode,
profitcurrencySymbol,
profitFraction,
profitMethod,
profitValue,
profitValueType,
Tenant,
totalcostcurrencyCode,
totalcostcurrencySymbol,
totalcostValue,
TotalLaborTime,
totalsellcurrencyCode,
totalsellcurrencySymbol,
totalsellValue,
Unit,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [LaborItem]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationCostSummary](BaseUoMName,
BudgetCostObject_id,
CreatedBy,
CreatedDate,
Duration,
FacilityId,
HourlyRatecurrencyCode,
HourlyRatecurrencySymbol,
HourlyRateValue,
Id,
IsActive,
LaborItemId,
LaborItemName,
ModifiedBy,
ModifiedDate,
OperationId,
OperationName,
OperationType,
Quantity,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitValue,
TotalProfitValueType,
TotalSellcurrencyCode,
TotalSellcurrencySymbol,
TotalSellValue,
UnitCostcurrencyCode,
UnitCostcurrencySymbol,
UnitCostValue,
BudgetCostObject_woid,
LaborItemwoid,
woid)
						 SELECT BaseUoMName,
BudgetCostObject_id,
CreatedBy,
CreatedDate,
Duration,
FacilityId,
HourlyRatecurrencyCode,
HourlyRatecurrencySymbol,
HourlyRateValue,
Id,
IsActive,
LaborItemId,
LaborItemName,
ModifiedBy,
ModifiedDate,
OperationId,
OperationName,
OperationType,
Quantity,
Tenant,
TotalCostcurrencyCode,
TotalCostcurrencySymbol,
TotalCostValue,
TotalProfitcurrencyCode,
TotalProfitcurrencySymbol,
TotalProfitFraction,
TotalProfitMethod,
TotalProfitValue,
TotalProfitValueType,
TotalSellcurrencyCode,
TotalSellcurrencySymbol,
TotalSellValue,
UnitCostcurrencyCode,
UnitCostcurrencySymbol,
UnitCostValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationCostSummary]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [OperationDuration](CreatedBy,
CreatedDate,
Equation,
Id,
IsActive,
LaborItem_id,
Location_id,
ModifiedBy,
ModifiedDate,
Operation_id,
ProductivityRegister_id,
RegressionMethod,
RSquared,
Tenant,
TimeUnit,
LaborItem_woid,
Location_woid,
Operation_woid,
ProductivityRegister_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Equation,
Id,
IsActive,
LaborItem_id,
Location_id,
ModifiedBy,
ModifiedDate,
Operation_id,
ProductivityRegister_id,
RegressionMethod,
RSquared,
Tenant,
TimeUnit,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [OperationDuration]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Type,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Type,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialKit](Category_id,
CostcurrencyCode,
CostcurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
SellcurrencyCode,
SellcurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
Category_woid,
woid)
						 SELECT Category_id,
CostcurrencyCode,
CostcurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
SellcurrencyCode,
SellcurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialKit]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [AssemblyAddition](Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
X_id,
Y_id,
Z_id,
Amount_woid,
Item_woid,
Part_woid,
woid,
X_woid,
Y_woid,
Z_woid)
						 SELECT Amount_id,
CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
Item_id,
ModifiedBy,
ModifiedDate,
OrderIndex,
Part_id,
Tenant,
X_id,
Y_id,
Z_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [AssemblyAddition]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [PartBaseAdditionDefinedValue](AssemblyAddition_id,
CreatedBy,
CreatedDate,
Id,
InlineFormula_id,
IsActive,
ModifiedBy,
ModifiedDate,
PartAddition_id,
Tenant,
Type,
VariableDefinition_id,
VariableValue_id,
AssemblyAddition_woid,
InlineFormula_woid,
PartAddition_woid,
VariableDefinition_woid,
VariableValue_woid,
woid)
						 SELECT AssemblyAddition_id,
CreatedBy,
CreatedDate,
Id,
InlineFormula_id,
IsActive,
ModifiedBy,
ModifiedDate,
PartAddition_id,
Tenant,
Type,
VariableDefinition_id,
VariableValue_id,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [PartBaseAdditionDefinedValue]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CharacteristicType](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CharacteristicType]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [CustomMaterialCharacteristic](Characteristic_id,
CreatedBy,
CreatedDate,
CustomMaterial_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Characteristic_woid,
CustomMaterial_woid,
woid)
						 SELECT Characteristic_id,
CreatedBy,
CreatedDate,
CustomMaterial_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [CustomMaterialCharacteristic]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Material](Category_id,
CostcurrencyCode,
CostcurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
DefaultCommonSize_id,
Description,
ExternalApproval,
GrainDirection,
Id,
Inventoried,
IsActive,
IsInnergy,
ManufacturerSku,
ManufacturerUrlLinkAddress,
ModifiedBy,
ModifiedDate,
Name,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
PurchaseUomGroup_id,
SellcurrencyCode,
SellcurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
WeightSymbol,
WeightUnit,
WeightValue,
Category_woid,
DefaultCommonSize_woid,
PurchaseUomGroup_woid,
woid)
						 SELECT Category_id,
CostcurrencyCode,
CostcurrencySymbol,
CostDataSource,
CostValue,
CreatedBy,
CreatedDate,
DefaultCommonSize_id,
Description,
ExternalApproval,
GrainDirection,
Id,
Inventoried,
IsActive,
IsInnergy,
ManufacturerSku,
ManufacturerUrlLinkAddress,
ModifiedBy,
ModifiedDate,
Name,
ProfitcurrencyCode,
ProfitcurrencySymbol,
ProfitFraction,
ProfitMethod,
ProfitValue,
ProfitValueType,
PurchaseUomGroup_id,
SellcurrencyCode,
SellcurrencySymbol,
SellValue,
SequenceIdentifier,
Status,
Tenant,
WeightSymbol,
WeightUnit,
WeightValue,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Material]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialKitMaterial](CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
MaterialAmount,
MaterialKit_id,
ModifiedBy,
ModifiedDate,
Tenant,
Material_woid,
MaterialKit_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
MaterialAmount,
MaterialKit_id,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialKitMaterial]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialCharacteristic](Characteristic_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Tenant,
Characteristic_woid,
Material_woid,
woid)
						 SELECT Characteristic_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialCharacteristic]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [MaterialSubstitute](CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Substitute_id,
Tenant,
Material_woid,
Substitute_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
Material_id,
ModifiedBy,
ModifiedDate,
Substitute_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [MaterialSubstitute]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [BurdenCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [BurdenCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [Burden](BurdenValueSource,
Category_id,
CreatedBy,
CreatedDate,
currencyCode,
currencySymbol,
Fraction,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Value,
Category_woid,
woid)
						 SELECT BurdenValueSource,
Category_id,
CreatedBy,
CreatedDate,
currencyCode,
currencySymbol,
Fraction,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [Burden]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [LaborItemBurden](Burden_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
LaborItem_id,
ModifiedBy,
ModifiedDate,
Tenant,
Burden_woid,
LaborItem_woid,
woid)
						 SELECT Burden_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
LaborItem_id,
ModifiedBy,
ModifiedDate,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [LaborItemBurden]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [SummaryBurden](Category_id,
CreatedBy,
CreatedDate,
currencyCode,
currencySymbol,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
TotalLaborTime,
Value,
Category_woid,
woid)
						 SELECT Category_id,
CreatedBy,
CreatedDate,
currencyCode,
currencySymbol,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
TotalLaborTime,
Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [SummaryBurden]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [FormulaCategory](CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
Parent_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
IsInnergy,
ModifiedBy,
ModifiedDate,
Name,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [FormulaCategory]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [FormulaArgument](CreatedBy,
CreatedDate,
Formula_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
TypeKind,
Formula_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Formula_id,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
OrderIndex,
Tenant,
TypeKind,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [FormulaArgument]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ReusableFormula](Category_id,
Formula_id,
IsInnergy,
Name,
Category_woid,
Formula_woid)
						 SELECT Category_id,
Formula_id,
IsInnergy,
Name,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ReusableFormula]
						 WHERE Formula_woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [FormulaDependency](Child_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Parent_id,
Tenant,
Child_woid,
Parent_woid,
woid)
						 SELECT Child_id,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Parent_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [FormulaDependency]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TaxRegulations](CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Type,
UseMarginFraction,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Tenant,
Type,
UseMarginFraction,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TaxRegulations]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TaxQuestionnaireAnswer](AnswerType,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
TaxRegulations_id,
Tenant,
TaxRegulations_woid,
woid)
						 SELECT AnswerType,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
TaxRegulations_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TaxQuestionnaireAnswer]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TaxQuestionNote](Content,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
QuestionCategory,
TaxRegulations_id,
Tenant,
TaxRegulations_woid,
woid)
						 SELECT Content,
CreatedBy,
CreatedDate,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
QuestionCategory,
TaxRegulations_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TaxQuestionNote]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TaxRate](CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
RateFraction,
TaxRegulations_id,
Tenant,
TaxRegulations_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Description,
Id,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
RateFraction,
TaxRegulations_id,
Tenant,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TaxRate]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [ImageAttachment](CreatedBy,
CreatedDate,
Id,
Image_id,
ImageIdentifier,
ImageName,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
ThumbnailIdentifier,
ThumbnailName,
Image_woid,
woid)
						 SELECT CreatedBy,
CreatedDate,
Id,
Image_id,
ImageIdentifier,
ImageName,
IsActive,
ModifiedBy,
ModifiedDate,
Name,
Tenant,
ThumbnailIdentifier,
ThumbnailName,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [ImageAttachment]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
INSERT INTO [TypicalGroupMarker](blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
Location_id,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
TypicalGroupId,
url_Value,
Location_woid,
woid)
						 SELECT blueprintId,
CreatedBy,
CreatedDate,
DisplayName,
Id,
IsActive,
layerId,
Location_id,
ModifiedBy,
ModifiedDate,
Shape,
Style,
Tenant,
Type,
TypicalGroupId,
url_Value,
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9',
'59f9f6cc-8cf1-4fc5-afea-4f68a8279ba9'
						 FROM [TypicalGroupMarker]
						 WHERE woid = '00000000-0000-0000-0000-000000000000'
UPDATE [TypicalGroupMarker]
SET Location_woid = NULL
WHERE Location_id IS NULL
AND Location_woid IS NOT NULL

UPDATE [TakeoffBlueprint]
SET Calibration_woid = NULL
WHERE Calibration_id IS NULL
AND Calibration_woid IS NOT NULL

UPDATE [ScaleDefinition]
SET ScaleCalibration_woid = NULL
WHERE ScaleCalibration_id IS NULL
AND ScaleCalibration_woid IS NOT NULL

UPDATE [Calibration]
SET ScaleDefinition_woid = NULL
WHERE ScaleDefinition_id IS NULL
AND ScaleDefinition_woid IS NOT NULL

UPDATE [ScaleCalibration]
SET ScaleDefinition_woid = NULL
WHERE ScaleDefinition_id IS NULL
AND ScaleDefinition_woid IS NOT NULL

UPDATE [ScaleArea]
SET Calibration_woid = NULL
WHERE Calibration_id IS NULL
AND Calibration_woid IS NOT NULL

UPDATE [AttachedProduct]
SET EvaluationSpecifications_woid = NULL
WHERE EvaluationSpecifications_id IS NULL
AND EvaluationSpecifications_woid IS NOT NULL

UPDATE [AttachedProduct]
SET ProductsPallet_woid = NULL
WHERE ProductsPallet_id IS NULL
AND ProductsPallet_woid IS NOT NULL

UPDATE [AttachedProductDistributedCost]
SET AttachedProduct_woid = NULL
WHERE AttachedProduct_id IS NULL
AND AttachedProduct_woid IS NOT NULL

UPDATE [AttachedProductDistributedCost]
SET DistributedCost_woid = NULL
WHERE DistributedCost_id IS NULL
AND DistributedCost_woid IS NOT NULL

UPDATE [AttachedProductTag]
SET AttachedProduct_woid = NULL
WHERE AttachedProduct_id IS NULL
AND AttachedProduct_woid IS NOT NULL

UPDATE [ProductEvaluationSpecification]
SET Facility_woid = NULL
WHERE Facility_id IS NULL
AND Facility_woid IS NOT NULL

UPDATE [ProductEvaluationSpecification]
SET ProductEvaluationSpecifications_woid = NULL
WHERE ProductEvaluationSpecifications_id IS NULL
AND ProductEvaluationSpecifications_woid IS NOT NULL

UPDATE [ProductEvaluationSpecification]
SET ProductTemplate_woid = NULL
WHERE ProductTemplate_id IS NULL
AND ProductTemplate_woid IS NOT NULL

UPDATE [CustomMaterial]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [CustomMaterial]
SET DefaultCommonSize_woid = NULL
WHERE DefaultCommonSize_id IS NULL
AND DefaultCommonSize_woid IS NOT NULL

UPDATE [CustomMaterial]
SET PurchaseUomGroup_woid = NULL
WHERE PurchaseUomGroup_id IS NULL
AND PurchaseUomGroup_woid IS NOT NULL

UPDATE [CustomMaterialCharacteristic]
SET Characteristic_woid = NULL
WHERE Characteristic_id IS NULL
AND Characteristic_woid IS NOT NULL

UPDATE [CustomMaterialCharacteristic]
SET CustomMaterial_woid = NULL
WHERE CustomMaterial_id IS NULL
AND CustomMaterial_woid IS NOT NULL

UPDATE [CostObjectLayer]
SET Layer_woid = NULL
WHERE Layer_id IS NULL
AND Layer_woid IS NOT NULL

UPDATE [CostObject]
SET AttachedProduct_woid = NULL
WHERE AttachedProduct_id IS NULL
AND AttachedProduct_woid IS NOT NULL

UPDATE [CostObject]
SET EvaluationSpecifications_woid = NULL
WHERE EvaluationSpecifications_id IS NULL
AND EvaluationSpecifications_woid IS NOT NULL

UPDATE [CostObject]
SET MeasurementScaleSourceScaleArea_woid = NULL
WHERE MeasurementScaleSourceScaleArea_id IS NULL
AND MeasurementScaleSourceScaleArea_woid IS NOT NULL

UPDATE [CostObject]
SET MeasurementScaleSourceSheetSettings_woid = NULL
WHERE MeasurementScaleSourceSheetSettings_id IS NULL
AND MeasurementScaleSourceSheetSettings_woid IS NOT NULL

UPDATE [CostObject]
SET SheetLocation_woid = NULL
WHERE SheetLocation_id IS NULL
AND SheetLocation_woid IS NOT NULL

UPDATE [CostObjectDistributedCost]
SET CostObject_woid = NULL
WHERE CostObject_id IS NULL
AND CostObject_woid IS NOT NULL

UPDATE [CostObjectDistributedCost]
SET DistributedCost_woid = NULL
WHERE DistributedCost_id IS NULL
AND DistributedCost_woid IS NOT NULL

UPDATE [CostObjectTag]
SET CostObject_woid = NULL
WHERE CostObject_id IS NULL
AND CostObject_woid IS NOT NULL

UPDATE [DistributedCostSummary]
SET BudgetCostObject_woid = NULL
WHERE BudgetCostObject_id IS NULL
AND BudgetCostObject_woid IS NOT NULL

UPDATE [MaterialCostSummary]
SET BudgetCostObject_woid = NULL
WHERE BudgetCostObject_id IS NULL
AND BudgetCostObject_woid IS NOT NULL

UPDATE [MaterialKitSummary]
SET BudgetCostObject_woid = NULL
WHERE BudgetCostObject_id IS NULL
AND BudgetCostObject_woid IS NOT NULL

UPDATE [OperationCostSummary]
SET BudgetCostObject_woid = NULL
WHERE BudgetCostObject_id IS NULL
AND BudgetCostObject_woid IS NOT NULL

UPDATE [OpportunityWorkOrder]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [VariableDefinition]
SET DefaultValue_woid = NULL
WHERE DefaultValue_id IS NULL
AND DefaultValue_woid IS NOT NULL

UPDATE [VariableDefinition]
SET VariableCategory_woid = NULL
WHERE VariableCategory_id IS NULL
AND VariableCategory_woid IS NOT NULL

UPDATE [VariableDefinition]
SET VariableSetDefinition_woid = NULL
WHERE VariableSetDefinition_id IS NULL
AND VariableSetDefinition_woid IS NOT NULL

UPDATE [VariableDefinitionCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [VariableInstance]
SET Definition_woid = NULL
WHERE Definition_id IS NULL
AND Definition_woid IS NOT NULL

UPDATE [VariableInstance]
SET ProductEvaluationSpecification_woid = NULL
WHERE ProductEvaluationSpecification_id IS NULL
AND ProductEvaluationSpecification_woid IS NOT NULL

UPDATE [VariableInstance]
SET Value_woid = NULL
WHERE Value_id IS NULL
AND Value_woid IS NOT NULL

UPDATE [VariableInstance]
SET VariableSetValue_woid = NULL
WHERE VariableSetValue_id IS NULL
AND VariableSetValue_woid IS NOT NULL

UPDATE [VariableValue]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [VariableValue]
SET Operation_woid = NULL
WHERE Operation_id IS NULL
AND Operation_woid IS NOT NULL

UPDATE [VariableValue]
SET VariableDefinition_woid = NULL
WHERE VariableDefinition_id IS NULL
AND VariableDefinition_woid IS NOT NULL

UPDATE [VariableSetInstance]
SET Definition_woid = NULL
WHERE Definition_id IS NULL
AND Definition_woid IS NOT NULL

UPDATE [VariableSetInstance]
SET ProductEvaluationSpecification_woid = NULL
WHERE ProductEvaluationSpecification_id IS NULL
AND ProductEvaluationSpecification_woid IS NOT NULL

UPDATE [VariableSetInstance]
SET Value_woid = NULL
WHERE Value_id IS NULL
AND Value_woid IS NOT NULL

UPDATE [VariableSetValue]
SET VariableSetDefinition_woid = NULL
WHERE VariableSetDefinition_id IS NULL
AND VariableSetDefinition_woid IS NOT NULL

UPDATE [UomGroup]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [UomGroupCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [UomGroupCommonSize]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [UomGroupCommonSize]
SET UomGroup_woid = NULL
WHERE UomGroup_id IS NULL
AND UomGroup_woid IS NOT NULL

UPDATE [CommonSize]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [CommonSizeCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [Product]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [Product]
SET ProductLabelDescription_woid = NULL
WHERE ProductLabelDescription_id IS NULL
AND ProductLabelDescription_woid IS NOT NULL

UPDATE [Product]
SET X_woid = NULL
WHERE X_id IS NULL
AND X_woid IS NOT NULL

UPDATE [Product]
SET Y_woid = NULL
WHERE Y_id IS NULL
AND Y_woid IS NOT NULL

UPDATE [Product]
SET Z_woid = NULL
WHERE Z_id IS NULL
AND Z_woid IS NOT NULL

UPDATE [EvaluationBundleSnapshot]
SET EvaluationSnapshot_woid = NULL
WHERE EvaluationSnapshot_id IS NULL
AND EvaluationSnapshot_woid IS NOT NULL

UPDATE [EvaluationSnapshot]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [EvaluationVariableSnapshot]
SET EvaluationSnapshot_woid = NULL
WHERE EvaluationSnapshot_id IS NULL
AND EvaluationSnapshot_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Item_woid = NULL
WHERE Item_id IS NULL
AND Item_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Part_woid = NULL
WHERE Part_id IS NULL
AND Part_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET X_woid = NULL
WHERE X_id IS NULL
AND X_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Y_woid = NULL
WHERE Y_id IS NULL
AND Y_woid IS NOT NULL

UPDATE [AssemblyAddition]
SET Z_woid = NULL
WHERE Z_id IS NULL
AND Z_woid IS NOT NULL

UPDATE [CostFormulaAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [CostFormulaAddition]
SET InlineFormula_woid = NULL
WHERE InlineFormula_id IS NULL
AND InlineFormula_woid IS NOT NULL

UPDATE [CostFormulaAddition]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [MaterialAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [MaterialAddition]
SET Item_woid = NULL
WHERE Item_id IS NULL
AND Item_woid IS NOT NULL

UPDATE [MaterialAddition]
SET Part_woid = NULL
WHERE Part_id IS NULL
AND Part_woid IS NOT NULL

UPDATE [MaterialAddition]
SET Variable_woid = NULL
WHERE Variable_id IS NULL
AND Variable_woid IS NOT NULL

UPDATE [OperationAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [OperationAddition]
SET Item_woid = NULL
WHERE Item_id IS NULL
AND Item_woid IS NOT NULL

UPDATE [OperationAddition]
SET Part_woid = NULL
WHERE Part_id IS NULL
AND Part_woid IS NOT NULL

UPDATE [OperationAddition]
SET Variable_woid = NULL
WHERE Variable_id IS NULL
AND Variable_woid IS NOT NULL

UPDATE [PartAddition]
SET Amount_woid = NULL
WHERE Amount_id IS NULL
AND Amount_woid IS NOT NULL

UPDATE [PartAddition]
SET Item_woid = NULL
WHERE Item_id IS NULL
AND Item_woid IS NOT NULL

UPDATE [PartAddition]
SET Part_woid = NULL
WHERE Part_id IS NULL
AND Part_woid IS NOT NULL

UPDATE [PartAddition]
SET X_woid = NULL
WHERE X_id IS NULL
AND X_woid IS NOT NULL

UPDATE [PartAddition]
SET Y_woid = NULL
WHERE Y_id IS NULL
AND Y_woid IS NOT NULL

UPDATE [PartAddition]
SET Z_woid = NULL
WHERE Z_id IS NULL
AND Z_woid IS NOT NULL

UPDATE [PartBase]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET AssemblyAddition_woid = NULL
WHERE AssemblyAddition_id IS NULL
AND AssemblyAddition_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET InlineFormula_woid = NULL
WHERE InlineFormula_id IS NULL
AND InlineFormula_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET PartAddition_woid = NULL
WHERE PartAddition_id IS NULL
AND PartAddition_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET VariableDefinition_woid = NULL
WHERE VariableDefinition_id IS NULL
AND VariableDefinition_woid IS NOT NULL

UPDATE [PartBaseAdditionDefinedValue]
SET VariableValue_woid = NULL
WHERE VariableValue_id IS NULL
AND VariableValue_woid IS NOT NULL

UPDATE [VariableAddition]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [VariableAddition]
SET Variable_woid = NULL
WHERE Variable_id IS NULL
AND Variable_woid IS NOT NULL

UPDATE [VariableSetAddition]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [VariableSetAddition]
SET VariableSetDefinition_woid = NULL
WHERE VariableSetDefinition_id IS NULL
AND VariableSetDefinition_woid IS NOT NULL

UPDATE [ProductLibraryCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [Part]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [Assembly]
SET PartBase_woid = NULL
WHERE PartBase_id IS NULL
AND PartBase_woid IS NOT NULL

UPDATE [Operation]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [Operation]
SET OperationType_woid = NULL
WHERE OperationType_id IS NULL
AND OperationType_woid IS NOT NULL

UPDATE [PrecedingOperation]
SET Operation_woid = NULL
WHERE Operation_id IS NULL
AND Operation_woid IS NOT NULL

UPDATE [PrecedingOperation]
SET Predecessor_woid = NULL
WHERE Predecessor_id IS NULL
AND Predecessor_woid IS NOT NULL

UPDATE [OperationDuration]
SET LaborItem_woid = NULL
WHERE LaborItem_id IS NULL
AND LaborItem_woid IS NOT NULL

UPDATE [OperationDuration]
SET Location_woid = NULL
WHERE Location_id IS NULL
AND Location_woid IS NOT NULL

UPDATE [OperationDuration]
SET Operation_woid = NULL
WHERE Operation_id IS NULL
AND Operation_woid IS NOT NULL

UPDATE [OperationDuration]
SET ProductivityRegister_woid = NULL
WHERE ProductivityRegister_id IS NULL
AND ProductivityRegister_woid IS NOT NULL

UPDATE [OperationCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [Vendor]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialKit]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [MaterialKitMaterial]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialKitMaterial]
SET MaterialKit_woid = NULL
WHERE MaterialKit_id IS NULL
AND MaterialKit_woid IS NOT NULL

UPDATE [MaterialAttachment]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialImage]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [Material]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [Material]
SET DefaultCommonSize_woid = NULL
WHERE DefaultCommonSize_id IS NULL
AND DefaultCommonSize_woid IS NOT NULL

UPDATE [Material]
SET PurchaseUomGroup_woid = NULL
WHERE PurchaseUomGroup_id IS NULL
AND PurchaseUomGroup_woid IS NOT NULL

UPDATE [MaterialCharacteristic]
SET Characteristic_woid = NULL
WHERE Characteristic_id IS NULL
AND Characteristic_woid IS NOT NULL

UPDATE [MaterialCharacteristic]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialInventoryLevels]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [MaterialInventoryLevels]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialSubstitute]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialSubstitute]
SET Substitute_woid = NULL
WHERE Substitute_id IS NULL
AND Substitute_woid IS NOT NULL

UPDATE [MaterialCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [LaborCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [LaborItem]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [LaborItem]
SET Location_woid = NULL
WHERE Location_id IS NULL
AND Location_woid IS NOT NULL

UPDATE [Burden]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [BurdenCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [LaborItemBurden]
SET Burden_woid = NULL
WHERE Burden_id IS NULL
AND Burden_woid IS NOT NULL

UPDATE [LaborItemBurden]
SET LaborItem_woid = NULL
WHERE LaborItem_id IS NULL
AND LaborItem_woid IS NOT NULL

UPDATE [SummaryBurden]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [FormulaArgument]
SET Formula_woid = NULL
WHERE Formula_id IS NULL
AND Formula_woid IS NOT NULL

UPDATE [FormulaDependency]
SET Child_woid = NULL
WHERE Child_id IS NULL
AND Child_woid IS NOT NULL

UPDATE [FormulaDependency]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [InlineFormula]
SET Formula_woid = NULL
WHERE Formula_id IS NULL
AND Formula_woid IS NOT NULL

UPDATE [ReusableFormula]
SET Category_woid = NULL
WHERE Category_id IS NULL
AND Category_woid IS NOT NULL

UPDATE [ReusableFormula]
SET Formula_woid = NULL
WHERE Formula_id IS NULL
AND Formula_woid IS NOT NULL

UPDATE [FormulaCategory]
SET Parent_woid = NULL
WHERE Parent_id IS NULL
AND Parent_woid IS NOT NULL

UPDATE [StockedMaterial]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [StockedMaterial]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [TenantFacility]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [TaxQuestionnaireAnswer]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [TaxQuestionNote]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [TaxRate]
SET TaxRegulations_woid = NULL
WHERE TaxRegulations_id IS NULL
AND TaxRegulations_woid IS NOT NULL

UPDATE [ProjectWorkOrderCostObject]
SET CostObject_woid = NULL
WHERE CostObject_id IS NULL
AND CostObject_woid IS NOT NULL

UPDATE [Requisition]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [Requisition]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [MaterialApprovalItem]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [BomEntry]
SET CommonSize_woid = NULL
WHERE CommonSize_id IS NULL
AND CommonSize_woid IS NOT NULL

UPDATE [BomEntry]
SET Material_woid = NULL
WHERE Material_id IS NULL
AND Material_woid IS NOT NULL

UPDATE [SovCostObject]
SET CostObject_woid = NULL
WHERE CostObject_id IS NULL
AND CostObject_woid IS NOT NULL

UPDATE [ImageAttachment]
SET Image_woid = NULL
WHERE Image_id IS NULL
AND Image_woid IS NOT NULL


]
  Source=NHibernate
  StackTrace:
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at Sm.Aspen.Data.Repositories.Sales.WorkOrders.OpportunityWorkOrderRepository.Snapshot(EntityId workOrderId, EntityId baseWorkOrderId) in C:\Repositories\innergy-2\src\Sm.Aspen.Data\Repositories\Sales\WorkOrders\OpportunityWorkOrderRepository.cs:line 86

Inner Exception 1:
SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_InlineFormula_Formula_Formula_id_Formula_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.Formula".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Product_InlineFormula_X_id_X_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.InlineFormula".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ProductEvaluationSpecification_Product_ProductTemplate_id_ProductTemplate_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.Product".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_VariableSetInstance_ProductEvaluationSpecification_ProductEvaluationSpecification_id_ProductEvaluationSpecification_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.ProductEvaluationSpecification".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CostFormulaAddition_InlineFormula_Amount_id_Amount_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.InlineFormula".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MaterialAddition_InlineFormula_Amount_id_Amount_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.InlineFormula".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PartAddition_InlineFormula_Amount_id_Amount_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.InlineFormula".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_VariableInstance_ProductEvaluationSpecification_ProductEvaluationSpecification_id_ProductEvaluationSpecification_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.ProductEvaluationSpecification".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OperationAddition_InlineFormula_Amount_id_Amount_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.InlineFormula".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_AssemblyAddition_InlineFormula_Amount_id_Amount_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.InlineFormula".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PartBaseAdditionDefinedValue_PartAddition_PartAddition_id_PartAddition_woid". The conflict occurred in database "demo.innergy.com-2017-10-19-9-49", table "dbo.PartAddition".
Snapshot isolation transaction aborted due to update conflict. You cannot use snapshot isolation to access table 'dbo.TaxRegulations' directly or indirectly in database 'demo.innergy.com-2017-10-19-9-49' to update, delete, or insert the row that has been modified or deleted by another transaction. Retry the transaction or change the isolation level for the update/delete statement.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.