| Table Name: | MPEquipmentDetailsLink |
| View Name: | MARIEquipmentDetailsLink |
| Group: | Group: Equipment |
| Description: | Equipment Assembly: List of inner components |
| ClassID: | 466. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentDetailLinkID | EquipmentDetailLinkID INT Primary |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) Index |
MPEquipment.EquipmentCode (WHERE EquipmentType=452) | |
| ValidFrom | ValidFrom Datetime Index |
||
| LinkType | LinkType INT |
clsImportEquipmentMasterAssemblyLink_eEquipmentLinkType | |
| LinkEquipmentCode | LinkEquipmentCode NVARCHAR (20) Index |
MPEquipment.EquipmentCode (WHERE EquipmentType=223) | |
| LinkQuantity | LinkQuantity NUMERIC(19,6) |
||
| SortOrder | SortOrder INT |
||
| CostRatio | CostRatio NUMERIC(19,6) |
||
| RevenueRatio | RevenueRatio NUMERIC(19,6) |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |