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