| View Name: | MARIWorkInProgress |
| Based on table: | MPFiBuBewertungen |
| Group: | Group: InfoScreenManagementBreakEven |
| Description: | Work In Progress: Header (one line per project and month) |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| WIPID | BewertungsID INT Primary |
||
| ClassID | ClassID INT Index |
ClassID | |
| ClassKey | ClassKey NVARCHAR (55) Index |
||
| Period | Periode INT Index |
MARIPeriods.Period | |
| AccountingMethod | Methode SMALLINT Index |
||
| LineType | Typ INT Index |
||
| ValueService | WertDienstleistung NUMERIC(19,6) |
||
| ValueItems | WertArtikel NUMERIC(19,6) |
||
| ValueTravelExpenses | WertReise NUMERIC(19,6) |
||
| ContractValueFixedPrice | VertragswertFestpreis NUMERIC(19,6) |
||
| ContractValueService | VertragswertDienstleistung NUMERIC(19,6) |
||
| ContractValueItems | VertragswertArtikel NUMERIC(19,6) |
||
| ContractValueTravelExpenses | VertragswertReisekosten NUMERIC(19,6) |
||
| InvoicedValue | WertAbgerechnet NUMERIC(19,6) |
||
| CostWithFuture | KostenMitZukunft NUMERIC(19,6) |
||
| ColumnDefinitionID | ColumnDefinitionID INT |
||
| WorkInProgressID | WorkInProgressID INT |
MARIWorkInProgressDefinition.WorkInProgressID | |
| WorkInProgressVersion | WorkInProgressVersion INT |
||
| PlanningVersionGroup1 | PlanningVersionGroup1 INT |
||
| PlanningVersionGroup2 | PlanningVersionGroup2 INT |
||
| PlanningVersionGroup3 | PlanningVersionGroup3 INT |
||
| Company | Mandant INT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| Currency | WKZ NVARCHAR (3) |
ISO Currency Code | |
| TransID | Tan INT |
MARIJournalEntryExport.TransID | |
| TransIDCancelation | TanStorno INT |
MARIJournalEntryExport.TransIDCancelation | |
| UpdateStamp | UpdateStamp INT |