| Table Name: | MPCustomerEquipmentLocation |
| View Name: | MARICustomerServiceObjectLocation |
| Group: | Group: CustomerServiceObject |
| Description: | Current location of a CSO at the client/Project |
| ClassID: | 386. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| CECEquipmentLocationID | CECEquipmentLocationID INT Primary |
||
| LocationTransactionID | LocationTransactionID INT Index |
||
| CustomerEquipmentCard | CustomerEquipmentCard INT Index |
MPCustomerEquipmentCard.MPinsID | |
| CompanyID | CompanyID SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Line | Line INT Index |
||
| CurrentLine | CurrentLine SMALLINT (0=false,-1=true) Index |
||
| LocationChangeDate | LocationChangeDate Datetime |
||
| RentalStartDate | RentalStartDate Datetime |
||
| RentalEndDate | RentalEndDate Datetime |
||
| LocationChangeDateNext | LocationChangeDateNext Datetime Index |
||
| LocationMode | LocationMode INT |
||
| Quantity | Quantity NUMERIC(19,6) |
||
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| Project | Project NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| ContractID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| ContractPositionID | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| PhaseID | PhaseID INT |
MPProjektPhasen.PhasenID | |
| Employee | Employee NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| MPBelID | MARIDocID INT |
MPVKVertraegeBelege.MPBelID | |
| MPBelPosID | MARIDocPosID INT |
MPVKVertraegeBelegePositionen.MPBelPosID | |
| AddressSource | AddressSource INT |
||
| AddressLink | AddressLink NVARCHAR (50) |
||
| Warehouse | Warehouse NVARCHAR (10) Index |
OWHS.WhsCode | |
| BinLocations | BinLocations NTEXT |
||
| ContainerBins | ContainerBins NTEXT |
||
| TimeBookingStatus | TimeBookingStatus INT |
||
| CustomerLocationTreeElementID | CustomerLocationTreeElementID INT Index |
MPCustomerLocationTreeElement.CustomerLocationTreeElementID | |
| LinkToCustomerEquipmentCard | LinkToCustomerEquipmentCard INT Index |
MPCustomerEquipmentCard.MPinsID | |
| Longitude | Longitude Float Index |
||
| Latitude | Latitude Float Index |
||
| SourceType | SourceType INT |
||
| SourceKey | SourceKey NVARCHAR (20) Index |
||
| NextLocationTransID | NextLocationTransID INT Index |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |