Deployed assets to IT assets mapping table
This table lists the mapping expressions in the mapping file that creates authorized assets from deployed assets (AssetInitDPA75toAssets75.fsn).
| Maximo Assets 7.5 | Source - Deployed Assets 7.5 | ||
|---|---|---|---|
| Class name | Property | <Class Name>.<Property Name> | |
| Key | Name | ||
| Key: PK=Primary Key AK=Alternate Key FK=Foreign Key GV=Generated Value | |||
| IT Asset | PK | assetnum | "C–" + 'Deployed Asset.Nodeid' |
| PK | moved | 0 | |
| PK | orgid | "<ORGID>" | |
| PK | siteid | "<SITEID>" | |
| GV | assetid | ||
| GV | assetuid | ||
| Computer | PK, FK | assetid | |
| PK, FK | assetnum | ||
| PK, FK | assetuid | ||
| PK, FK | moved | ||
| PK, FK | orgid | ||
| PK, FK | siteid | ||
| ancestor | // The Ancestor property is the top root assetnum
of the Parent. // The Integration Composer adapter sets this property value based on the Parent property value for this computer. This expression should not be modified. The ancestor will be updated correctly with the value of the parent. |
||
| assettag | 'Deployed Asset.Assettag' | ||
| assettype | "IT" | ||
| autowogen | 0 | ||
| binnum | |||
| budgetcost | 0 | ||
| calnum | |||
| changeby | "FSN" | ||
| GV | changedate | ||
| children | 0 | ||
| classstructureid | item.classstructureid | ||
| conditioncode | |||
| description | "NODE NAME:" + 'Deployed Asset.Nodename' + ";" + 'Deployed Asset.Description' | ||
| direction | |||
| disabled | 0 | ||
| enddescription | |||
| endmeasure | |||
| eq1 | |||
| eq10 | |||
| eq11 | |||
| eq12 | |||
| eq2 | |||
| eq23 | |||
| eq24 | |||
| eq3 | |||
| eq4 | |||
| eq5 | |||
| eq6 | |||
| eq7 | |||
| eq8 | |||
| eq9 | |||
| externalrefid | |||
| failurecode | |||
| glaccount | |||
| groupname | |||
| hasId | 0 | ||
| installdate | |||
| invcost | 0 | ||
| islinear | |||
| isrunning | 1 | ||
| itemnum | item.itemnum | ||
| itemsetid | |||
| itemtype | |||
| langcode | "EN" | ||
| location | |||
| mainthierchy | 0 | ||
| manufacturer | |||
| ownersysid | |||
| parent | "C–" + the parent 'Deployed Asset.Nodeid' | ||
| priority | |||
| purchaseprice | 0 | ||
| replacecost | 0 | ||
| rotsuspacct | |||
| sendersysid | |||
| serialnum | 'Deployed Asset.Serialnumber' | ||
| shiftnum | |||
| sourcesysid | |||
| startdescription | |||
| startmeasure | |||
| status | "NOT READY" | ||
| statusdate | |||
| tloamdispcharge | |||
| tloamdispdate | |||
| tloamdisprecipient | |||
| tloamdispremark | |||
| tloamdispreq | |||
| tloamdisptype | |||
| tloamdispvalue | |||
| tloamhash | |||
| tloamlicencecompliance | |||
| tloampartition | 0 OR 1 | ||
| tloamrefreshcycle | |||
| tloamrefreshdate | |||
| tloamrefreshplandate | |||
| tloamrefreshremarks | |||
| tloamrefreshstatus | |||
| toolcontrolaccount | |||
| toolrate | |||
| totalcost | 0 | ||
| totdowntime | 0 | ||
| totunchargedcost | 0 | ||
| unchargedcost | 0 | ||
| usage | |||
| vendor | |||
| warrantyexpdate | |||
| ytdcost | 0 | ||
| Spare Parts | PK, FK | assetnum | |
| PK | itemnum | item.itemnum | |
| PK, FK | orgid | "<ORGID>" | |
| PK, FK | siteid | "<SITEID>" | |
| description | |||
| hasld | |||
| issuedqty | |||
| itemsetid | "SET1" | ||
| langcode | "EN" | ||
| quantity | sparepart.quantity + 1 | ||
| GV | sparepartid | ||