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