| Table Name: | MPProjektKunden |
| View Name: | MARIProjectCustomerLink |
| Group: | Group: ProjectMaster |
| Description: | Project Master: Customer Link |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Projektnummer | ProjectNumber NVARCHAR (20) Primary |
Project reference | MPProjektstamm.Projektnummer |
| Kunde | Customer NVARCHAR (20) Primary |
Business Partner code | OCRD.CardCode |
| KundenTyp | CustomerType TINYINT |
1=Main Customer, 2=Additional Addresses | |
| Lieferanschrift | DeliveryAddress NVARCHAR (50) |
unused | |
| Referenz | ReferenceText NVARCHAR (40) |
unused | |
| Mandant | Company SMALLINT Primary |
company ID | MPSysConnections.CompanyID (WHERE ConnectionType=6) |
| UpdateStamp | UpdateStamp INT |