| Table Name: | MPEquipmentSubjectBooking |
| View Name: | MARIEquipmentSubjectBooking |
| Group: | Group: Equipment |
| Description: | Time/Costbooking on Equipment data |
| ClassID: | 236. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentBookingID | EquipmentBookingID INT Primary |
||
| EquipmentCategory | EquipmentCategory INT |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) Index |
MPEquipment.EquipmentCode | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) Index |
MPEquipmentCategorySubject.EquipmentSubject | |
| BookingType | BookingType INT |
||
| EntryCategory | EntryCategory INT |
Booking Type ==normal, 1=ISC | |
| EquipmentBusinessUnit | BusinessUnit INT |
MPSetupGeschaeftsbereich.GeschaeftsbereichID | |
| BookingDate | BookingDate Datetime Index |
||
| BookingPeriod | Period INT Index |
MPPerioden.PeriodeJahr | |
| BookingWeek | BookingWeek INT |
MPPeriodenKW.KW | |
| BookingLineType | BookingLineType INT |
||
| ProjectNumber | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| PhaseID | PhaseID INT |
MPProjektPhasen.PhasenID | |
| Activity | ActivityText NVARCHAR (100) |
||
| Employee | Employee NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| ContractID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| ContractPositionID | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| ContractParentPositionID | ContractParentPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| NumberOfEquipments | NumberOfEquipments NUMERIC(19,6) |
||
| Quantity | Quantity NUMERIC(19,6) |
||
| QuantityInv | InvQty NUMERIC(19,6) |
||
| QuantityDays | QuantityDays NUMERIC(19,6) |
||
| QuantityDaysInv | QuantityDaysInv NUMERIC(19,6) |
||
| QuantityMonth | QuantityMonth NUMERIC(19,6) |
||
| QuantityMonthInv | QuantityMonthInv NUMERIC(19,6) |
||
| StartTime | StartTime Datetime |
||
| StartTimeInv | StartTimeInv Datetime |
||
| EndTime | EndTime Datetime |
||
| EndTimeInv | EndTimeInv Datetime |
||
| CounterStart | CounterStart NUMERIC(19,6) |
||
| CounterEnd | CounterEnd NUMERIC(19,6) |
||
| UnitCostPriceSource | UnitCostPriceSource NUMERIC(19,6) |
||
| UnitCostPriceSourceLoc | UnitCostPriceSourceLoc NUMERIC(19,6) |
||
| UnitCostPriceSys | UnitCostPriceSys NUMERIC(19,6) |
||
| CostPriceSource | CostPriceSource NUMERIC(19,6) |
||
| CostPriceSourceLoc | CostPriceSourceLoc NUMERIC(19,6) |
||
| CostPriceSys | CostPriceSys NUMERIC(19,6) |
||
| CostCurrencySource | CostCurrencySource NVARCHAR (3) |
||
| CostCurrencySourceLoc | CostCurrencySourceLoc NVARCHAR (3) |
||
| CostExchangeRateSourceLoc | CostExchangeRateSourceLoc Float |
||
| CostExchangeRateSourceSys | CostExchangeRateSourceSys Float |
||
| UnitSalesPriceContract | UnitSalesPriceContract NUMERIC(19,6) |
||
| UnitSalesPriceLoc | UnitSalesPriceLoc NUMERIC(19,6) |
||
| UnitSalesPriceSys | UnitSalesPriceSys NUMERIC(19,6) |
||
| SalesPriceContract | SalesPriceContract NUMERIC(19,6) |
||
| SalesPriceLoc | SalesPriceLoc NUMERIC(19,6) |
||
| SalesPriceSys | SalesPriceSys NUMERIC(19,6) |
||
| SalesCurrencyContract | SalesCurrencyContract NVARCHAR (3) |
||
| SalesCurrencyLocal | SalesCurrencyLocal NVARCHAR (3) |
||
| CurrencySys | CurrencySys NVARCHAR (3) |
||
| SalesExchangeRateContractLoc | SalesExchangeRateContractLoc Float |
||
| SalesExchangeRateContractSys | SalesExchangeRateContractSys Float |
||
| CostPriceIndividual | CostPriceIndividual SMALLINT (0=false,-1=true) |
||
| SalesPriceIndividual | SalesPriceIndividual SMALLINT (0=false,-1=true) |
||
| Approval | Approval INT Index |
||
| ApprovalDate | ApprovalDate Datetime |
||
| ApprovalUser | ApprovalUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ApprovalText | ApprovalText NTEXT |
||
| ISCTransaction | ISCTransaction INT Index |
||
| SalesDeliveryPos | SalesDeliveryPos INT Index |
Link to delivery note position | MPVKVertraegeBelegePositionen.MPBelPosID |
| SalesInvoicePos | SalesInvoicePos INT Index |
Link to invoice position | MPVKVertraegeBelegePositionen.MPBelPosID |
| PurchaseDeliveryPos | PurchaseDeliveryPos INT Index |
Link to goods receipt PO position | MPEKVertraegeBelegePositionen.MPBelPosID |
| PurchaseInvoicePos | PurchaseInvoicePos INT Index |
Lonk to A/P invoice position | MPEKVertraegeBelegePositionen.MPBelPosID |
| PurchaseContract | PurchaseContract INT |
MPEKVertraege.VertragsID | |
| PurchaseContractPosition | PurchaseContractPosition INT |
MPEKVertraegePositionen.Vertragsposition | |
| SourceType | SourceType INT |
Source 0:Standard, 1=MARIInterface, 2=Support Module, 3=Vacation Approval, 4=TimeTouch, 5=WorkItem | clsImportItemBooking_eSourceType |
| SourceReference | SourceReference INT |
Id of the referenced table | |
| SourceReferencePos | SourceReferencePos INT |
||
| WorkPackageEntryID | WorkPackageEntryID INT Index |
MPProjektArbeitspaketerfassung.ArbeitspaketerfassungsID | |
| LocationID | LocationID INT Index |
Brasilia | |
| ExpenseLineId | ExpenseLineId INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| DocumentID | DocumentID INT |
MPDokumente.DocID | |
| UpdateStamp | UpdateStamp INT |