| Table Name: | MPAdressen |
| View Name: | MARIAddresses |
| Group: | |
| Description: | Business Partner: Used only for synchronization with other databases |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Adresse | Address INT Primary |
||
| Mandant | Company SMALLINT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Kto | Account NVARCHAR (20) Index |
||
| KtoArt | AccountType NVARCHAR (4) |
||
| Kategorie | Category SMALLINT |
||
| Matchcode | Matchcode NVARCHAR (50) Index |
||
| Anrede | Salutation NVARCHAR (50) |
||
| Name1 | Name1 NVARCHAR (50) |
||
| Name2 | Name2 NVARCHAR (50) |
||
| LieferZusatz | DelAddon NVARCHAR (50) |
||
| LieferStrasse | DelAddress NVARCHAR (100) |
||
| LieferLand | DelCountry NVARCHAR (3) |
||
| LieferPLZ | DelZipcode NVARCHAR (10) |
||
| LieferOrt | DelCity NVARCHAR (100) |
||
| LieferBezirk | DelCounty NVARCHAR (100) |
||
| LieferBundesland | DelState NVARCHAR (3) |
||
| LieferGebaeude | DelBlock NVARCHAR (100) |
||
| PostZusatz | PostalAddon NVARCHAR (50) |
||
| PostStrasse | PostalStreet NVARCHAR (100) |
||
| PostLand | PostalCountry NVARCHAR (3) |
||
| PostPLZ | PostalZipCode NVARCHAR (10) |
||
| PostOrt | PostalCity NVARCHAR (100) |
||
| PostBezirk | PostalCounty NVARCHAR (100) |
||
| PostBundesland | PostalState NVARCHAR (3) |
||
| PostGebaeude | PostalBlock NVARCHAR (100) |
||
| Ansprache | Salutation2 NVARCHAR (50) |
||
| Telefon | Phone NVARCHAR (25) |
||
| Telefax | Fax NVARCHAR (25) |
||
| Mobilfunk | Mobile NVARCHAR (25) |
||
| Email NVARCHAR (50) |
|||
| Homepage | Homepage NVARCHAR (130) |
||
| Memo | Memo NTEXT |
||
| Sprache | LanguageCode NVARCHAR (3) |
||
| Erstkontakt | FirstContact Datetime |
||
| Gruppe | GroupId NVARCHAR (10) |
||
| Auswertungskennzeichen | InfoScreenMode NVARCHAR (10) |
||
| Referenz | ReferenceText NVARCHAR (20) |
||
| Aktiv | Active SMALLINT |
||
| EUUStID | EUVATID NVARCHAR (32) |
||
| WKz | Currency NVARCHAR (3) |
ISO Currency Code | |
| Vertreter | SecondManager NVARCHAR (10) |
||
| Zahlungskond | PaymentCondition NVARCHAR (10) |
OCTG.GroupNum | |
| Besteuerung | TaxModeCode SMALLINT |
||
| Steuercode | TaxCode NVARCHAR (10) |
||
| UpdateStamp | UpdateStamp INT |