| View Name: | MARITravelExpenseTypesAccounts |
| Based on table: | MPReise2KostenArtenKonten |
| Group: | Group: TravelExpenseTypes |
| Description: | Travel Expenses Module: Travel Expenses Types Company G/L Account Link |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| TravelCategory | Reisekostenart NVARCHAR (20) Primary |
MARITravelExpenseTypes.TravelCategory | |
| TravelCategorySubType | ReisekostenSubTyp INT Primary |
MARITravelExpenseTypesAccounts.TravelCategorySubType | |
| Company | Mandant SMALLINT Primary |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| Description | Bezeichnung NVARCHAR (50) |
||
| GLAccount | Sachkonto NVARCHAR (50) |
OACT.AcctCode | |
| AccountType | SachkontoTyp SMALLINT |
||
| GLAccount2 | Sachkonto2 NVARCHAR (50) |
OACT.AcctCode | |
| AccountType2 | Sachkonto2Typ SMALLINT |
||
| TaxCode | Steuercode NVARCHAR (10) |
||
| TaxCodeCancel | SteuerCodeAbzug NVARCHAR (10) |
||
| CalculationMethod | Berechnungsregel INT |
||
| OcrCode1 | Kostenstelle NVARCHAR (50) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| ProfitCenterType | KostenstelleTyp 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) | |
| ProjectCode | Kostentraeger NVARCHAR (50) |
OPRJ.PrjCode | |
| ProjectCodeType | KostentraegerTyp SMALLINT |
||
| ItemType | ArtikelTyp INT |
||
| ItemCode | Artikel NVARCHAR (50) |
OITM.ItemCode | |
| UoM | Einheit NVARCHAR (20) |
||
| PayrollType | Lohnart NVARCHAR (20) |
MARIPayrollTypes.PayrollType | |
| DefaultType | DefaultType INT |
||
| ProjectCompanyMode | ProjektMandantMode INT |
||
| TaxWtLiableMode | TaxWtLiable INT |
||
| TravelRequestMode | ReiseAntragsMode INT |
||
| QualityProcess | QualityProcess INT |
MARIQualityProcess.QualityProcess | |
| SacEntry | SacEntry INT |
V5.4 India Localization | OSAC.AbsEntry |
| CostMarginImputed | KostenAufschlagKalkulatorisch Float |
||
| SalesMarginImputed | VerkaufsAufschlagKalkulatorisch Float |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARITravelExpenseTypesAccounts | Travel Expenses Module: Travel Expenses Types Company G/L Account Link |
| MARITravelTripLine | Travel Expenses Module: Trip receipt line |