| Table Name: | MPProjektArbeitspaketerfassung |
| View Name: | MARIProjectWorkPackageEntry |
| Group: | |
| Description: | Work Packages progress reporting by day |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ArbeitspaketerfassungsID | WorkPackageEntryID INT Primary |
||
| BuchungsKopfID | TimeKeepingHeaderID INT |
MPProjektBuchungskopf.BuchungsKopfID | |
| Projektnummer | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| PhasenID | PhaseID INT Index |
MPProjektPhasen.PhasenID | |
| Aktivitaet | ActivityText NVARCHAR (100) |
||
| Ressource | Ressource NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| Personalnummer | EmployeeNumber NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| Periode | Period INT Index |
MPPerioden.PeriodeJahr | |
| KW | CW INT |
MPPeriodenKW.KW | |
| BuchungsTyp | EntryType SMALLINT |
||
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| Vertragsposition | ContractPositionID INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| ParentVKPos | ParentContractPos INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| IndexVKPos | ParentContractIndexPos INT |
MPVKVertraegePositionen.Vertragsposition | |
| IndexText | IndexText NVARCHAR (50) |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MPEquipment.EquipmentCode | |
| ERVertragsposition | POProcessPos INT |
MPEKVertraegePositionen.Vertragsposition | |
| Artikel | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Liefertag | DeliveryDate Datetime |
||
| Menge | Quantity NUMERIC(19,6) |
||
| MengeFAK | InvQty NUMERIC(19,6) |
||
| EKPreis | PurchasePrice NUMERIC(19,6) |
||
| EKPreisLoc | PurchasePriceLoc NUMERIC(19,6) |
||
| EKPreisLocKurs | PurchasePriceLocRate Float |
||
| EKPreisFW | PurchasePriceFC NUMERIC(19,6) |
||
| EKPreisFWKurs | PurchasePriceFCRate Float |
Sys2FC | |
| EKPreisFWWKZ | PurchasePriceFCCurr NVARCHAR (3) |
||
| VKPreis | SalesPrice NUMERIC(19,6) |
||
| VKPreisLoc | SalesPriceLoc NUMERIC(19,6) |
||
| VKPreisLocKurs | SalesPriceLocRate Float |
||
| VKPreisFW | SalesPriceFC NUMERIC(19,6) |
||
| VKPreisFWKurs | SalesPriceFCRate Float |
||
| LocWKZ | LocCurrency NVARCHAR (3) |
||
| WKZ | Currency NVARCHAR (3) |
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 |
MPFiBuPositionen.TAN | |
| LieferscheinID | DeliveryID INT Index |
MPVKVertraegeBelegePositionen.MPBelPosID | |
| FakturaID | InvoiceID INT Index |
MPVKVertraegeBelegePositionen.MPBelPosID | |
| EKLieferscheinID | PODeliveryID INT Index |
MPEKVertraegeBelegePositionen.MPBelPosID | |
| EKFakturaID | POInvoiceID INT Index |
MPEKVertraegeBelegePositionen.MPBelPosID | |
| SeriennummernTyp | SerialnumberType INT |
||
| QuellTyp | SourceType INT |
||
| QuellReferenz | SourceReference INT |
||
| QuellReferenzPos | SourceReferencePos INT |
||
| DokumentID | DocumentID INT |
MPDokumente.DocID | |
| Lagerort | Warehouse NVARCHAR (10) |
OWHS.WhsCode | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
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 |
|---|---|
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPProjektArbeitspaketerfassungWerte | Work Packages progress reporting by structure element |
| MPProjektArtikelerfassung | 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 |
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |