| View Name: | MARIProjectItemBooking |
| Based on table: | MPProjektArtikelerfassung |
| Group: | Group: ProjectTimeKeepingHeader |
| Description: | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf |
| ClassID: | 131. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ItemBookingID | ArtikelerfassungsID INT Primary |
Unique key | |
| TimeKeepingHeaderID | BuchungsKopfID INT Index |
(Optional link to the employee month table) | MARIProjectTimeKeepingHeader.TimeKeepingHeaderID |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
Link to the project master | MARIProjectMaster.ProjectNumber |
| PhaseID | PhasenID INT Index |
Link to the phase | MARIProjectPhases.PhaseID |
| ActivityText | Aktivitaet NVARCHAR (100) |
Free activity text | |
| Resource | Ressource NVARCHAR (20) Index |
Employee linked to the item booking | MARIEmployeeMaster.Resource |
| EmployeeNumber | Personalnummer NVARCHAR (20) Index |
Employee responsible for the item movement | MARIEmployeeMaster.EmployeeNumber |
| Period | Periode INT Index |
financial period yyyymmm linked to PM periods | MARIPeriods.Period |
| CalendarWeek | KW INT |
Calendar week based on ISO | MARIPeriodsCalendarWeeks.CalendarWeek |
| EntryType | BuchungsTyp SMALLINT |
Linked to project type | |
| EntryCategory | ErfassungsTyp SMALLINT |
||
| ContractID | VertragsID INT Index |
Linked sales contract | MARIContract.ContractID |
| ContractPositionID | Vertragsposition INT Index |
Linked sales contract position | MARIContractPositions.ContractPositionID |
| ParentContractPos | ParentVKPos INT Index |
Special mode with a linke to father position | MARIContractPositions.ParentContractPos |
| ParentContractIndexPos | IndexVKPos INT |
Special mode with a linke to father position | MARIContractPositions.ParentContractIndexPos |
| IndexText | IndexText NVARCHAR (50) |
Special mode text | |
| EquipmentCode | EquipmentCode NVARCHAR (20) |
Linked used equipment | MARIEquipmentMaster.EquipmentCode |
| POProcessPos | ERVertragsposition INT |
Revenue Return Account Position | MARIPurchaseProcessPositions.POProcessPos |
| ItemCode | KHKArtikel NVARCHAR (50) |
Linked item number | OITM.ItemCode |
| Company | KHKMandant SMALLINT |
Linked company id | MARISysConnections.Company (WHERE ConnectionType=6) |
| DeliveryDate | Liefertag Datetime |
Date of the movement | |
| Quantity | Menge NUMERIC(19,6) |
||
| InvQty | MengeFAK NUMERIC(19,6) |
||
| QuantityCount | MengeAnzahl NUMERIC(19,6) |
||
| InvQuantityCount | MengeAnzahlFAK NUMERIC(19,6) |
||
| QuantityCountText | MengeAnzahlText NVARCHAR (100) |
||
| QuantityFormularID | MengenFormelID INT Index |
MARISetupQuantityFormular.QuantityFormularID | |
| PurchasePrice | EKPreis NUMERIC(19,6) |
Purchase Unit Price in System Currency | |
| PurchasePriceLoc | EKPreisLoc NUMERIC(19,6) |
||
| PurchasePriceLocRate | EKPreisLocKurs Float |
||
| PurchasePriceFC | EKPreisFW NUMERIC(19,6) |
||
| PurchasePriceFCRate | EKPreisFWKurs Float |
||
| PurchasePriceFCCurr | EKPreisFWWKZ NVARCHAR (3) |
||
| SalesPrice | VKPreis NUMERIC(19,6) |
Sales Unit Price in System Currency | |
| SalesPriceLoc | VKPreisLoc NUMERIC(19,6) |
||
| SalesPriceLocRate | VKPreisLocKurs Float |
||
| SalesPriceFC | VKPreisFW NUMERIC(19,6) |
Sales Unit Price in Contract Currency | |
| SalesPriceFCRate | VKPreisFWKurs Float |
||
| LocCurrency | LocWKZ NVARCHAR (3) |
||
| Currency | WKZ NVARCHAR (3) |
Sales ISO Currency Code | |
| UnitPriceManual | EinzelPreisManuell SMALLINT |
||
| ApprovalMode | Freigabe SMALLINT (0=false,-1=true) |
||
| ApprovedDate | FreigegebenAm Datetime |
||
| ApprovedUser | FreigegebenID NVARCHAR (4) |
MARIUser.ApprovedUser (WHERE BenutzerTyp=1) | |
| ApprovalText | FreigabeText NTEXT |
||
| TAN | TAN INT Index |
Linked interman service charge booking | MARIJournalEntryExport.TAN |
| DeliveryID | LieferscheinID INT Index |
Linked sales delivery note position id | MARIContractDocumentPositions.DeliveryID |
| InvoiceID | FakturaID INT Index |
Linked sales invoice position id | MARIContractDocumentPositions.InvoiceID |
| PODeliveryID | EKLieferscheinID INT Index |
Linked goods receipt PO position id | MARIPurchaseProcessDocumentPositions.PODeliveryID |
| POInvoiceID | EKFakturaID INT Index |
Linked A/P invoice position id | MARIPurchaseProcessDocumentPositions.POInvoiceID |
| SerialnumberType | SeriennummernTyp INT |
||
| SourceType | QuellTyp INT |
Source 0:Standard, 1=MARIInterface, 2=Support Module, 3=Vacation Approval, 4=TimeTouch, 5=WorkItem | clsImportItemBooking_eSourceType |
| SourceReference | QuellReferenz INT |
Reference ID baed on the SourceType | |
| SourceReferencePos | QuellReferenzPos INT |
Detailed reference, when the SourceReference is pointing to a header | |
| WorkPackageEntryID | ArbeitspaketerfassungsID INT Index |
MARIProjectWorkPackageEntry.WorkPackageEntryID | |
| DocumentID | DokumentID INT Index |
Linked attachement document | MARIDocuments.DocumentID |
| Warehouse | Lagerort NVARCHAR (10) |
OWHS.WhsCode | |
| BinLocations | LagerPlaetze NTEXT |
||
| ContainerBins | Gebinde NTEXT |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) Index |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIProjectItemBookingSerialNumbers | Time Keeping: ProjectTimeKeepingItemsSeries: Serial numbers |