| View Name: | MARIAddressProperties |
| Based on table: | MPAdressenKennzeichen |
| Group: | |
| Description: | Additional Data for OCRD |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| CardCode | CardCode NVARCHAR (15) Primary |
OCRD.CardCode | |
| Company | Mandant INT Primary |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| DocWorkflowID | DocWorkflow INT |
MARISysDocWorkflow.DocWorkflowID | |
| ProRataIDSales | ProRataIDSales INT |
MARISysProRata.ProRataIDSales | |
| ProRataIDPurchase | ProRataIDPurchase INT |
MARISysProRata.ProRataIDPurchase | |
| AccrualRuleIDSales | AccrualRuleIDSales INT |
||
| AccrualRuleIDPurchase | AccrualRuleIDPurchase INT |
||
| ContractGroup1 | Vertragsgruppe1 INT |
MARIGroups.ContractGroup1 (WHERE Gruppenart=10008) | |
| ContractGroup2 | Vertragsgruppe2 INT |
MARIGroups.ContractGroup2 (WHERE Gruppenart=10014) | |
| ContractGroup3 | Vertragsgruppe3 INT |
MARIGroups.ContractGroup3 (WHERE Gruppenart=10018) | |
| Option1 | Option1 INT |
||
| Option2 | Option2 INT |
||
| OptionMemo | OptionMemo NTEXT |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) Index |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |