| Table Name: | MPAdressenKennzeichen |
| View Name: | MARIAddressProperties |
| Group: | |
| Description: | Additional Data for OCRD |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| CardCode | CardCode NVARCHAR (15) Primary |
OCRD.CardCode | |
| Mandant | Company INT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| DocWorkflow | DocWorkflowID INT |
MPSysDocWorkflow.DocWorkflow | |
| ProRataIDSales | ProRataIDSales INT |
MPSysProRata.ProRataID | |
| ProRataIDPurchase | ProRataIDPurchase INT |
MPSysProRata.ProRataID | |
| AccrualRuleIDSales | AccrualRuleIDSales INT |
||
| AccrualRuleIDPurchase | AccrualRuleIDPurchase INT |
||
| Vertragsgruppe1 | ContractGroup1 INT |
MPGruppen.GruppenID (WHERE Gruppenart=10008) | |
| Vertragsgruppe2 | ContractGroup2 INT |
MPGruppen.GruppenID (WHERE Gruppenart=10014) | |
| Vertragsgruppe3 | ContractGroup3 INT |
MPGruppen.GruppenID (WHERE Gruppenart=10018) | |
| Option1 | Option1 INT |
||
| Option2 | Option2 INT |
||
| OptionMemo | OptionMemo NTEXT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) Index |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |