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