| View Name: | MARICustomerLocationTreeLink |
| Based on table: | MPCustomerLocationTreeLink |
| 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 | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| CustomerLocationTreeLinkID | CustomerLocationTreeLinkID INT Primary |
||
| CustomerLocationTreeID | CustomerLocationTreeID INT Index |
MARICustomerLocationTree.CustomerLocationTreeID | |
| LinkType | LinkType INT |
||
| CompanyID | CompanyID SMALLINT Index |
MARISysConnections.CompanyID (WHERE ConnectionType=6) | |
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| UserCode | UserCode NVARCHAR (4) Index |
MARIUser.UserCode (WHERE BenutzerTyp=1) | |
| LinkMode | LinkMode INT |