| Table Name: | MPCustomerLocationTreeElement |
| View Name: | MARICustomerLocationTreeElement |
| Group: | Group: CustomerServiceObject |
| Description: | Tree elements to manage levels, rooms of the customer |
| ClassID: | 388. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| CustomerLocationTreeElementID | CustomerLocationTreeElementID INT Primary |
||
| CustomerLocationTreeID | CustomerLocationTreeID INT Index |
MPCustomerLocationTree.CustomerLocationTreeID | |
| Indent | Indent INT |
||
| Parent | Parent INT |
||
| Position | Position INT Index |
||
| IndentType | IndentType SMALLINT |
||
| ElementName | ElementName NVARCHAR (100) |
||
| ElementNameShort | ElementNameShort NVARCHAR (50) |
||
| ElementNameFull | ElementNameFull NVARCHAR (255) |
||
| PictureID | PictureID INT |
MPBilder.BildID | |
| Barcode | Barcode NVARCHAR (100) |
||
| Address | Address NVARCHAR (50) |
||
| Address2 | Address2 NVARCHAR (50) |
||
| Address3 | Address3 NVARCHAR (50) |
||
| AddrStreet | AddrStreet NVARCHAR (100) |
||
| AddrStreetNo | AddrStreetNo NVARCHAR (100) |
||
| AddrBlock | AddrBlock NVARCHAR (100) |
||
| AddrCity | AddrCity NVARCHAR (100) |
||
| AddrZipCode | AddrZipCode NVARCHAR (20) |
||
| AddrCounty | AddrCounty NVARCHAR (100) |
||
| AddrState | AddrState NVARCHAR (3) |
||
| AddrCountry | AddrCountry NVARCHAR (3) |
||
| AddrBuilding | AddrBuilding NTEXT |
||
| Longitude | Longitude Float |
||
| Latitude | Latitude Float |
||
| AddrType | AddrType NVARCHAR (100) |
||
| Responsible | Responsible NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| CustomerLocationContactPerson | CustomerLocationContactPerson INT |
OCPR.CntctCode | |
| CustomerLocationRemark | CustomerLocationRemark NVARCHAR (100) |
||
| 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 |
||
| InActive | InActive SMALLINT (0=false,-1=true) |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MPCustomerEquipmentCard | Advanced table to sbo standard customer equipment card | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPCustomerEquipmentLocation | Current location of a CSO at the client/Project | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPEquipmentDetails | Equipment: Master Data "date from" based | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPEquipmentLocation | Equipment: Current Location of this equipment | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPWorkItem | The table is used basically for service task and other tasks. For each dimension using this table, special views have been created. See also the description of the field WorkItemType.
|