| Table Name: | MPReise2KostenArtenKonten |
| View Name: | MARITravelExpenseTypesAccounts |
| Group: | Group: TravelExpenseTypes |
| Description: | Travel Expenses Module: Travel Expenses Types Company G/L Account Link |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Reisekostenart | TravelCategory NVARCHAR (20) Primary |
MPReise2KostenArten.Reisekostenart | |
| ReisekostenSubTyp | TravelCategorySubType INT Primary |
MPReise2KostenArtenKonten.ReisekostenSubTyp | |
| Mandant | Company SMALLINT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Bezeichnung | Description NVARCHAR (50) |
||
| Sachkonto | GLAccount NVARCHAR (50) |
OACT.AcctCode | |
| SachkontoTyp | AccountType SMALLINT |
||
| Sachkonto2 | GLAccount2 NVARCHAR (50) |
OACT.AcctCode | |
| Sachkonto2Typ | AccountType2 SMALLINT |
||
| Steuercode | TaxCode NVARCHAR (10) |
||
| SteuerCodeAbzug | TaxCodeCancel NVARCHAR (10) |
||
| Berechnungsregel | CalculationMethod INT |
||
| Kostenstelle | OcrCode1 NVARCHAR (50) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| KostenstelleTyp | ProfitCenterType SMALLINT |
||
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| Kostentraeger | ProjectCode NVARCHAR (50) |
OPRJ.PrjCode | |
| KostentraegerTyp | ProjectCodeType SMALLINT |
||
| ArtikelTyp | ItemType INT |
||
| Artikel | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| Einheit | UoM NVARCHAR (20) |
||
| Lohnart | PayrollType NVARCHAR (20) |
MPLohnArten.LohnArt | |
| DefaultType | DefaultType INT |
||
| ProjektMandantMode | ProjectCompanyMode INT |
||
| TaxWtLiable | TaxWtLiableMode INT |
||
| ReiseAntragsMode | TravelRequestMode INT |
||
| QualityProcess | QualityProcess INT |
MPQualityProcess.QualityProcess | |
| SacEntry | SacEntry INT |
V5.4 India Localization | OSAC.AbsEntry |
| KostenAufschlagKalkulatorisch | CostMarginImputed Float |
||
| VerkaufsAufschlagKalkulatorisch | SalesMarginImputed Float |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPReise2KostenArtenKonten | Travel Expenses Module: Travel Expenses Types Company G/L Account Link |
| MPReise2Zeile | Travel Expenses Module: Trip receipt line |