| View Name: | MARILocation |
| Based on table: | MPLocation |
| Group: | Group: Location |
| Description: | Location: Place (India Localization) |
| ClassID: | 249. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| LocationID | LocationID INT Primary |
||
| A0Salutation | A0Anrede NVARCHAR (50) |
||
| A0Name1 | A0Name1 NVARCHAR (100) |
||
| A0Name2 | A0Name2 NVARCHAR (50) |
||
| A0Name3 | A0Zusatz NVARCHAR (50) |
||
| A0Matchcode | A0Matchcode NVARCHAR (100) Index |
||
| A0Street | A0Strasse NVARCHAR (100) |
||
| A0StreetNumber | A0Hausnummer NVARCHAR (100) |
||
| A0Country | A0Land NVARCHAR (3) |
||
| A0ZIP | A0PLZ NVARCHAR (20) |
||
| A0City | A0Ort NVARCHAR (100) |
||
| A0County | A0Bezirk NVARCHAR (100) |
||
| A0State | A0Bundesland NVARCHAR (3) |
||
| A0Block | A0Gebaeude NVARCHAR (100) |
||
| A0ContactPerson | A0AnsprechpartnerID INT |
Not used | OCPR.CntctCode |
| A0AddressName1 | A0AdressName NVARCHAR (50) |
||
| A0AddressName2 | A0AdressName2 NVARCHAR (50) |
||
| A0AddressName3 | A0AdressName3 NVARCHAR (50) |
||
| A0Building | A0GebaeudeStockwerk NTEXT |
||
| A0AddressMemo | A0AdressMemo NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
||
| A0AddrType | A0AddrType NVARCHAR (100) |
||
| A0AddressLineNum | A0AdressLineNum INT |
||
| A0GlbLocNum | A0GlbLocNum NVARCHAR (50) |
||
| A0Longitude | A0Longitude Float |
||
| A0Latitude | A0Latitude Float |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| CreateDate | Erstanlage Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIEmployeeMaster | Employee Master: Employee Master |
| MARIProjectPhases | Project Phases Master: Master Data (linked to project and planning version) |
| MARIProjectMaster | Project Master: Master Data |
| MARITravelTrip | Travel Expenses Module: Business Trip Master |
| MARIBusinessUnitMaster | Business Units: Master Data |
| MARIEquipmentDetails | Equipment: Master Data "date from" based |
| MARILocationCompany | Location: Link to locations in SBO database (India Localization) |
| MARILocationDistance | Distance between locations |