| View Name: | MARIProjectWorkPackageEntry |
| Based on table: | MPProjektArbeitspaketerfassung |
| Group: | |
| Description: | Work Packages progress reporting by day |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| WorkPackageEntryID | ArbeitspaketerfassungsID INT Primary |
||
| TimeKeepingHeaderID | BuchungsKopfID INT |
MARIProjectTimeKeepingHeader.TimeKeepingHeaderID | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| ActivityText | Aktivitaet NVARCHAR (100) |
||
| Ressource | Ressource NVARCHAR (20) Index |
MARIEmployeeMaster.Ressource | |
| EmployeeNumber | Personalnummer NVARCHAR (20) Index |
MARIEmployeeMaster.EmployeeNumber | |
| Period | Periode INT Index |
MARIPeriods.Period | |
| CW | KW INT |
MARIPeriodsCalendarWeeks.CW | |
| EntryType | BuchungsTyp SMALLINT |
||
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT Index |
MARIContractPositions.ContractPositionID | |
| ParentContractPos | ParentVKPos INT Index |
MARIContractPositions.ParentContractPos | |
| ParentContractIndexPos | IndexVKPos INT |
MARIContractPositions.ParentContractIndexPos | |
| IndexText | IndexText NVARCHAR (50) |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MARIEquipmentMaster.EquipmentCode | |
| POProcessPos | ERVertragsposition INT |
MARIPurchaseProcessPositions.POProcessPos | |
| ItemCode | Artikel NVARCHAR (50) |
OITM.ItemCode | |
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| DeliveryDate | Liefertag Datetime |
||
| Quantity | Menge NUMERIC(19,6) |
||
| InvQty | MengeFAK NUMERIC(19,6) |
||
| PurchasePrice | EKPreis NUMERIC(19,6) |
||
| PurchasePriceLoc | EKPreisLoc NUMERIC(19,6) |
||
| PurchasePriceLocRate | EKPreisLocKurs Float |
||
| PurchasePriceFC | EKPreisFW NUMERIC(19,6) |
||
| PurchasePriceFCRate | EKPreisFWKurs Float |
Sys2FC | |
| PurchasePriceFCCurr | EKPreisFWWKZ NVARCHAR (3) |
||
| SalesPrice | VKPreis NUMERIC(19,6) |
||
| SalesPriceLoc | VKPreisLoc NUMERIC(19,6) |
||
| SalesPriceLocRate | VKPreisLocKurs Float |
||
| SalesPriceFC | VKPreisFW NUMERIC(19,6) |
||
| SalesPriceFCRate | VKPreisFWKurs Float |
||
| LocCurrency | LocWKZ NVARCHAR (3) |
||
| Currency | WKZ NVARCHAR (3) |
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 |
MARIJournalEntryExport.TAN | |
| DeliveryID | LieferscheinID INT Index |
MARIContractDocumentPositions.DeliveryID | |
| InvoiceID | FakturaID INT Index |
MARIContractDocumentPositions.InvoiceID | |
| PODeliveryID | EKLieferscheinID INT Index |
MARIPurchaseProcessDocumentPositions.PODeliveryID | |
| POInvoiceID | EKFakturaID INT Index |
MARIPurchaseProcessDocumentPositions.POInvoiceID | |
| SerialnumberType | SeriennummernTyp INT |
||
| SourceType | QuellTyp INT |
||
| SourceReference | QuellReferenz INT |
||
| SourceReferencePos | QuellReferenzPos INT |
||
| DocumentID | DokumentID INT |
MARIDocuments.DocumentID | |
| Warehouse | Lagerort NVARCHAR (10) |
OWHS.WhsCode | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
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 |
|---|---|
| MARIProjectItemBooking | 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 |
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MARIProjectWorkPackageEntryValues | Work Packages progress reporting by structure element |