| Table Name: | MPProjektArtikelerfassung |
| View Name: | MARIProjectItemBooking |
| 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 | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ArtikelerfassungsID | ItemBookingID INT Primary |
Unique key | |
| BuchungsKopfID | TimeKeepingHeaderID INT Index |
(Optional link to the employee month table) | MPProjektBuchungskopf.BuchungsKopfID |
| Projektnummer | ProjectNumber NVARCHAR (20) Index |
Link to the project master | MPProjektstamm.Projektnummer |
| PhasenID | PhaseID INT Index |
Link to the phase | MPProjektPhasen.PhasenID |
| Aktivitaet | ActivityText NVARCHAR (100) |
Free activity text | |
| Ressource | Resource NVARCHAR (20) Index |
Employee linked to the item booking | MPPersonenstamm.Personalnummer |
| Personalnummer | EmployeeNumber NVARCHAR (20) Index |
Employee responsible for the item movement | MPPersonenstamm.Personalnummer |
| Periode | Period INT Index |
financial period yyyymmm linked to PM periods | MPPerioden.PeriodeJahr |
| KW | CalendarWeek INT |
Calendar week based on ISO | MPPeriodenKW.KW |
| BuchungsTyp | EntryType SMALLINT |
Linked to project type | |
| ErfassungsTyp | EntryCategory SMALLINT |
||
| VertragsID | ContractID INT Index |
Linked sales contract | MPVKVertraege.VertragsID |
| Vertragsposition | ContractPositionID INT Index |
Linked sales contract position | MPVKVertraegePositionen.Vertragsposition |
| ParentVKPos | ParentContractPos INT Index |
Special mode with a linke to father position | MPVKVertraegePositionen.Vertragsposition |
| IndexVKPos | ParentContractIndexPos INT |
Special mode with a linke to father position | MPVKVertraegePositionen.Vertragsposition |
| IndexText | IndexText NVARCHAR (50) |
Special mode text | |
| EquipmentCode | EquipmentCode NVARCHAR (20) |
Linked used equipment | MPEquipment.EquipmentCode |
| ERVertragsposition | POProcessPos INT |
Revenue Return Account Position | MPEKVertraegePositionen.Vertragsposition |
| KHKArtikel | ItemCode NVARCHAR (50) |
Linked item number | OITM.ItemCode |
| KHKMandant | Company SMALLINT |
Linked company id | MPSysConnections.CompanyID (WHERE ConnectionType=6) |
| Liefertag | DeliveryDate Datetime |
Date of the movement | |
| Menge | Quantity NUMERIC(19,6) |
||
| MengeFAK | InvQty NUMERIC(19,6) |
||
| MengeAnzahl | QuantityCount NUMERIC(19,6) |
||
| MengeAnzahlFAK | InvQuantityCount NUMERIC(19,6) |
||
| MengeAnzahlText | QuantityCountText NVARCHAR (100) |
||
| MengenFormelID | QuantityFormularID INT Index |
MPSetupMengenFormel.MengenFormelID | |
| EKPreis | PurchasePrice NUMERIC(19,6) |
Purchase Unit Price in System Currency | |
| EKPreisLoc | PurchasePriceLoc NUMERIC(19,6) |
||
| EKPreisLocKurs | PurchasePriceLocRate Float |
||
| EKPreisFW | PurchasePriceFC NUMERIC(19,6) |
||
| EKPreisFWKurs | PurchasePriceFCRate Float |
||
| EKPreisFWWKZ | PurchasePriceFCCurr NVARCHAR (3) |
||
| VKPreis | SalesPrice NUMERIC(19,6) |
Sales Unit Price in System Currency | |
| VKPreisLoc | SalesPriceLoc NUMERIC(19,6) |
||
| VKPreisLocKurs | SalesPriceLocRate Float |
||
| VKPreisFW | SalesPriceFC NUMERIC(19,6) |
Sales Unit Price in Contract Currency | |
| VKPreisFWKurs | SalesPriceFCRate Float |
||
| LocWKZ | LocCurrency NVARCHAR (3) |
||
| WKZ | Currency NVARCHAR (3) |
Sales ISO Currency Code | |
| EinzelPreisManuell | UnitPriceManual SMALLINT |
||
| Freigabe | ApprovalMode SMALLINT (0=false,-1=true) |
||
| FreigegebenAm | ApprovedDate Datetime |
||
| FreigegebenID | ApprovedUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| FreigabeText | ApprovalText NTEXT |
||
| TAN | TAN INT Index |
Linked interman service charge booking | MPFiBuPositionen.TAN |
| LieferscheinID | DeliveryID INT Index |
Linked sales delivery note position id | MPVKVertraegeBelegePositionen.MPBelPosID |
| FakturaID | InvoiceID INT Index |
Linked sales invoice position id | MPVKVertraegeBelegePositionen.MPBelPosID |
| EKLieferscheinID | PODeliveryID INT Index |
Linked goods receipt PO position id | MPEKVertraegeBelegePositionen.MPBelPosID |
| EKFakturaID | POInvoiceID INT Index |
Linked A/P invoice position id | MPEKVertraegeBelegePositionen.MPBelPosID |
| SeriennummernTyp | SerialnumberType INT |
||
| QuellTyp | SourceType INT |
Source 0:Standard, 1=MARIInterface, 2=Support Module, 3=Vacation Approval, 4=TimeTouch, 5=WorkItem | clsImportItemBooking_eSourceType |
| QuellReferenz | SourceReference INT |
Reference ID baed on the SourceType | |
| QuellReferenzPos | SourceReferencePos INT |
Detailed reference, when the SourceReference is pointing to a header | |
| ArbeitspaketerfassungsID | WorkPackageEntryID INT Index |
MPProjektArbeitspaketerfassung.ArbeitspaketerfassungsID | |
| DokumentID | DocumentID INT Index |
Linked attachement document | MPDokumente.DocID |
| Lagerort | Warehouse NVARCHAR (10) |
OWHS.WhsCode | |
| LagerPlaetze | BinLocations NTEXT |
||
| Gebinde | ContainerBins NTEXT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) Index |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPProjektArtikelerfassungSerie | Time Keeping: ProjectTimeKeepingItemsSeries: Serial numbers |