| View Name: | MARITravelTripLine |
| Based on table: | MPReise2Zeile |
| Group: | Group: TravelTrip |
| Description: | Travel Expenses Module: Trip receipt line |
| ClassID: | 155. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| TripLine | ReiseZeile INT Primary |
||
| EditModeEmployee | EditierModeMA INT |
||
| EditModeSuperior | EditierModeBU INT |
||
| EditModeSales | EditierModeFakt INT |
||
| EmployeeNumber | Personalnummer NVARCHAR (20) Index |
MARIEmployeeMaster.EmployeeNumber | |
| TripID | ReiseID INT Index |
MARITravelTrip.TripID | |
| TravelTemplateVersion | ReiseTemplateVersion INT |
||
| LineOrder | Reihenfolge SMALLINT |
||
| TravelCategory | Reisekostenart NVARCHAR (20) |
MARITravelExpenseTypes.TravelCategory | |
| TravelExpenseSubType | ReisekostenSubTyp INT Index |
MARITravelExpenseTypesAccounts.TravelExpenseSubType | |
| TravelCategoryType | ReisekostenartenTyp SMALLINT |
||
| DocDate | Belegdatum Datetime |
||
| MealAllowanceType | VerpflegungsTyp SMALLINT |
||
| DayFrom | TagVon Datetime |
||
| DayTo | TagBis Datetime |
||
| DefaultProjectSplit | StandardProjektAufteilung SMALLINT (0=false,-1=true) |
||
| VehicleType | Fahrzeugart INT |
MARITravelMilageAllowanceHeader.VehicleType | |
| CompanyCarID | Firmenfahrzeug SMALLINT (0=false,-1=true) |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| LineMemo | ZeilenMemo NTEXT |
||
| PaymentType | BezahlungsTyp SMALLINT |
||
| DocumentNumber | Belegnummer NVARCHAR (50) Index |
||
| Period | Periode INT |
MARIPeriods.Period | |
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| AccountTaxMode | SachkontoSteuerMode INT |
||
| GLAccount | Sachkonto NVARCHAR (20) |
OACT.AcctCode | |
| TaxCode | Steuercode NVARCHAR (10) |
||
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| ExternalCreditor | FremdKreditor NVARCHAR (20) |
OCRD.CardCode | |
| ExternalID | FremdOP NVARCHAR (20) |
||
| OcrCode1 | Kostenstelle NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| 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) | |
| ItemCode | Artikel NVARCHAR (50) |
OITM.ItemCode | |
| UoM | Einheit NVARCHAR (20) |
||
| Quantity | Menge NUMERIC(19,6) |
||
| CurrencySys | WKZSys NVARCHAR (3) |
||
| CurrencyCompany | WKZMa NVARCHAR (3) |
||
| CurrencyForeign | WKZBeleg NVARCHAR (3) |
||
| ExchangeRateCompany | WkzMaKurs Float |
||
| ExchangeRateFC2Sys | WKzKursFw Float |
||
| GrossSetting | BruttoKennzeichen SMALLINT (0=false,-1=true) |
||
| UnitCostPriceSys | EinzelpreisKostenSys NUMERIC(19,6) |
||
| UnitCostPriceCompany | EinzelpreisKostenMA NUMERIC(19,6) |
||
| UnitCostPriceForeign | EinzelpreisKostenFw NUMERIC(19,6) |
||
| UnitReembursementPriceSys | EinzelAbzugsbetragSys NUMERIC(19,6) |
||
| UnitReembursementPriceCompany | EinzelAbzugsbetragMA NUMERIC(19,6) |
||
| UnitReembursementPriceForeign | EinzelAbzugsbetragFw NUMERIC(19,6) |
||
| TotalNetCostSys | GesamtNettoKostenSys NUMERIC(19,6) |
||
| TotalNetCostCompany | GesamtNettoKostenMa NUMERIC(19,6) |
||
| TotalNetCostForeign | GesamtNettoKostenFw NUMERIC(19,6) |
||
| TotalGrossCostSys | GesamtBruttoKostenSys NUMERIC(19,6) |
||
| TotalGrossCostCompany | GesamtBruttoKostenMa NUMERIC(19,6) |
||
| TotalGrossCostForeign | GesamtBruttoKostenFw NUMERIC(19,6) |
||
| TotalTaxCostSys | GesamtSteuerKostenSys NUMERIC(19,6) |
||
| TotalTaxCostCompany | GesamtSteuerKostenMA NUMERIC(19,6) |
||
| TotalTaxCostForeign | GesamtSteuerKostenFw NUMERIC(19,6) |
||
| CostApprovalMode | KostenFreigabeTyp SMALLINT Index |
||
| CostApprovalDate | KostenFreigabeAm Datetime |
||
| CostApprovalUser | KostenFreigabeID NVARCHAR (10) Index |
MARIUser.CostApprovalUser | |
| CostApprovalText | KostenFreigabeText NTEXT |
||
| TravelEntryID | ReiseBuchungKopf INT Index |
MARITravelAccountingHeader.TravelEntryID | |
| TANFinAcc | FibuTAN INT Index |
MARITravelPostingDocumentLine.TANFinAcc | |
| SourceDocumentType | QuellBelegTyp INT |
||
| SourceDocument | QuellBeleg INT |
||
| SourceDocumentPos | QuellBelegPos INT |
||
| EquipmentCategory | EquipmentCategory INT |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
||
| EquipmentSubject | EquipmentSubject NVARCHAR (20) |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARITravelPostingDocumentLine | Travel Expenses Module: Posting document lines |
| MARITravelTripLineDocument | Travel Expenses Module: Trip receipt line (document link for scanned documents) |
| MARITravelTripLineProject | Travel Expenses Module: Trip receipt project line for invoice |