| View Name: | MARITravelTripLineProject |
| Based on table: | MPReise2ZeileProjekt |
| Group: | Group: TravelTrip |
| Description: | Travel Expenses Module: Trip receipt project line for invoice |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| TripProjectLine | ReiseZeileProjekt INT Primary |
||
| TripLine | ReiseZeile INT Index |
MARITravelTripLine.TripLine | |
| LineOrder | Reihenfolge SMALLINT |
||
| TripID | ReiseID INT Index |
MARITravelTrip.TripID | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT |
MARIContractPositions.ContractPositionID | |
| TripBaseProjectID | ReiseGrundprojektID INT Index |
MARITravelTripProjectLink.TripBaseProjectID | |
| HasSale | HatVK SMALLINT |
||
| PercentValue | Prozent NUMERIC(19,6) |
||
| InvQty | MengeFak NUMERIC(19,6) |
||
| ManualQuantity | MengeManuell SMALLINT |
||
| EditableQuantityChange | KannMengeManuell SMALLINT |
||
| SingleSalesPriceSys | EinzelpreisErloeseSys NUMERIC(19,6) |
||
| SingleSalesPriceCompany | EinzelpreisErloeseMA NUMERIC(19,6) |
||
| SingleSalesPriceForeign | EinzelpreisErloeseFW NUMERIC(19,6) |
||
| ManualPrice | PreisManuell SMALLINT |
||
| EnablePriceChange | KannPreisManuell SMALLINT |
||
| TotalSalesPriceSys | GesamtpreisErloeseSys NUMERIC(19,6) |
||
| TotalSalesPriceCompany | GesamtpreisErloeseMA NUMERIC(19,6) |
||
| TotalSalesPriceForeign | GesamtpreisErloeseFW NUMERIC(19,6) |
||
| CurrencySys | WKZSys NVARCHAR (3) |
||
| CurrencyComapny | WKZMa NVARCHAR (3) |
||
| CurrencyContract | WKZVertrag NVARCHAR (3) |
||
| ExchangeRateFC2Sys | WKzKursFw Float |
||
| ExchangeRateCompany | WkzMaKurs Float |
||
| ProjectCode | Kostentraeger NVARCHAR (20) |
OPRJ.PrjCode | |
| ItemCode | Artikel NVARCHAR (50) |
OITM.ItemCode | |
| UoM | Einheit NVARCHAR (20) |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) Index |
MARIEquipmentMaster.EquipmentCode | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) |
MARIEquipmentCategorySubject.EquipmentSubject | |
| SalesApprovalType | ErloesFreigabeTyp SMALLINT Index |
||
| SalesApprovalDate | ErloesFreigegebenAm Datetime |
||
| SalesApprovalUser | ErloesFreigegebenID NVARCHAR (10) Index |
MARIUser.SalesApprovalUser | |
| SalesApprovalText | ErloesFreigabeText NTEXT |
||
| InvoiceID | FakturaID INT Index |
||
| POInvoiceID | EKFakturaID INT Index |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIProjectTravelExpenseTemplates | Travel Expenses Module: Properties by Project |