| View Name: | MARIEquipmentSubjectBooking |
| Based on table: | MPEquipmentSubjectBooking |
| Group: | Group: Equipment |
| Description: | Time/Costbooking on Equipment data |
| ClassID: | 236. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentBookingID | EquipmentBookingID INT Primary |
||
| EquipmentCategory | EquipmentCategory INT |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) Index |
MARIEquipmentMaster.EquipmentCode | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) Index |
MARIEquipmentCategorySubject.EquipmentSubject | |
| BookingType | BookingType INT |
||
| EntryCategory | EntryCategory INT |
Booking Type ==normal, 1=ISC | |
| BusinessUnit | EquipmentBusinessUnit INT |
MARIBusinessUnitMaster.BusinessUnit | |
| BookingDate | BookingDate Datetime Index |
||
| Period | BookingPeriod INT Index |
MARIPeriods.Period | |
| BookingWeek | BookingWeek INT |
MARIPeriodsCalendarWeeks.BookingWeek | |
| BookingLineType | BookingLineType INT |
||
| ProjectNumber | ProjectNumber NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | PhaseID INT |
MARIProjectPhases.PhaseID | |
| ActivityText | Activity NVARCHAR (100) |
||
| Employee | Employee NVARCHAR (20) Index |
MARIEmployeeMaster.Employee | |
| ContractID | ContractID INT Index |
MARIContract.ContractID | |
| ContractPositionID | ContractPositionID INT |
MARIContractPositions.ContractPositionID | |
| ContractParentPositionID | ContractParentPositionID INT |
MARIContractPositions.ContractParentPositionID | |
| NumberOfEquipments | NumberOfEquipments NUMERIC(19,6) |
||
| Quantity | Quantity NUMERIC(19,6) |
||
| InvQty | QuantityInv 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) |
MARIUser.ApprovalUser (WHERE BenutzerTyp=1) | |
| ApprovalText | ApprovalText NTEXT |
||
| ISCTransaction | ISCTransaction INT Index |
||
| SalesDeliveryPos | SalesDeliveryPos INT Index |
Link to delivery note position | MARIContractDocumentPositions.SalesDeliveryPos |
| SalesInvoicePos | SalesInvoicePos INT Index |
Link to invoice position | MARIContractDocumentPositions.SalesInvoicePos |
| PurchaseDeliveryPos | PurchaseDeliveryPos INT Index |
Link to goods receipt PO position | MARIPurchaseProcessDocumentPositions.PurchaseDeliveryPos |
| PurchaseInvoicePos | PurchaseInvoicePos INT Index |
Lonk to A/P invoice position | MARIPurchaseProcessDocumentPositions.PurchaseInvoicePos |
| PurchaseContract | PurchaseContract INT |
MARIPurchaseProcess.PurchaseContract | |
| PurchaseContractPosition | PurchaseContractPosition INT |
MARIPurchaseProcessPositions.PurchaseContractPosition | |
| 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 |
MARIProjectWorkPackageEntry.WorkPackageEntryID | |
| LocationID | LocationID INT Index |
Brasilia | |
| ExpenseLineId | ExpenseLineId INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| DocumentID | DocumentID INT |
MARIDocuments.DocumentID | |
| UpdateStamp | UpdateStamp INT |