| Table Name: | MPReise2KostenArtenKontenMatrix |
| View Name: | MARITravelExpenseTypesAccountsMatrix |
| Group: | Group: TravelExpenseTypes |
| Description: | Travel Expenses Module: Travel Expenses Types Company G/L Account Link (Matrix) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Reisekostenart | TravelCategory NVARCHAR (20) Primary |
MPReise2KostenArten.Reisekostenart | |
| ReisekostenSubTyp | TravelExpenseSubType INT Primary |
||
| Mandant | Company INT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| SachkontenNr | AcctCodeNumber SMALLINT Primary |
||
| Position | PositionID SMALLINT Primary |
||
| Sachkonto | GLAccount NVARCHAR (20) |
OACT.AcctCode | |
| AnteilProzent | PercentageValue NUMERIC(19,6) |
||
| Steuercode | TaxCode NVARCHAR (10) |
||
| Berechnungsregel | CalculationRule INT |
||
| UpdateStamp | UpdateStamp INT |