Convert In-Place Assets

Table Mapping

Source Table	Data Filter	Target Table	Entities Impacted
astAssets	Id != 0 AND Id != 1 AND RecordType = 'InPlace'	ampc.asset	In-Place Asset

Column Mappings

Source Column	Target Column
AlternativeDescription	alternative_description
AssetTypeId	asset_type_id
BarCode	barcode
CalendarId	calendar_id
CapexAcquisitionStatusId	acquisition_status_id
CapexAcquisitionTypeId	acquisition_type_id
CapexAssetToBeReplaceId	replacement_asset_id
CapexBudgetAmount	budgeted_replacement_amount
Code	code
CommissionedOn	commissioned_on
CostCentreId	cost_centre_id
CurrentValue	current_value
Description	description
DevelopmentStatus	development_status
DowntimeCostPerHour	downtime_cost_per_hour
GeneralLedgerId	general_ledger_id
GeographicDataId	geographic_data_id
Id	asset_id
ImportanceId	asset_importance_id
InheritedFromId	inherited_from_id
IsActive	is_active
IsForSchedulingOnly	is_for_scheduled_work_only
IsHistorical	is_historical
IsInherited	is_inherited
IsMsi	is_msi
IsPermitRequired	is_permit_required
IsProposed	is_proposed
IsRunning	is_running
LastConfirmedOn	last_confirmed_on
LastModifiedByUserId	modified_by_user_id
LastModifiedOn	modified_on
LocationId	location_id
NearestRegularAssetId	nearest_regular_asset_id
Notes	notes
ParentAssetId	parent_asset_id
PurchasePrice	purchase_amount
RecordType	record_type
RollUpPointId	task_roll_up_point_id
RuleEvaluationPassed	rule_evaluation_passed
RulesLastEvaluatedOn	rules_last_evaluated_on
SequenceNumber	sequence_number
SerialNumber	serial_number
SiteId	site_id
SupplierId	supplier_id
SynchronisedWithTypeObjectUpTo	synchronised_with_type_object_up_to
Version	version

Enumeration Mappings

Mapping 1

Source Column (RecordType)	Target Column (record_type)
0	Regular
1	InPlace
2	EmptyPlaceholder
3	LinkedPlaceholder

Mapping 2

Source Column (DevelopmentStatus)	Target Column (development_status)
0	NewUnderDevelopment
1	NewAwaitingConfirmation
2	ModifiedUnderDevelopment
3	ModifiedAwaitingConfirmation
5	DeletedAwaitingConfirmation
6	DeletedConfirmed
7	Confirmed