| Table Name: | MPCustomerLocationTreeLink |
| View Name: | MARICustomerLocationTreeLink |
| Group: | Group: CustomerServiceObject |
| Description: | Link of a customer and a user to a tree or an element of the tree |
| ClassID: | 398. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| CustomerLocationTreeLinkID | CustomerLocationTreeLinkID INT Primary |
||
| CustomerLocationTreeID | CustomerLocationTreeID INT Index |
MPCustomerLocationTree.CustomerLocationTreeID | |
| LinkType | LinkType INT |
||
| CompanyID | CompanyID SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| UserCode | UserCode NVARCHAR (4) Index |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| LinkMode | LinkMode INT |