| Table Name: | MPChefInfoCashFlowRunLine |
| View Name: | MARIChefInfoCashFlowRunLine |
| Group: | Group: InfoScreenManagementBreakEven |
| Description: | Info Screen Management: Stored line data per run |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| CashFlowRun | CashFlowRun INT Primary |
MPChefInfoCashFlowRun.CashFlowRun | |
| ProjectNumber | ProjectNumber NVARCHAR (20) Primary |
MPProjektstamm.Projektnummer | |
| Line | Line INT Primary |
||
| Company | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| SourceType | SourceType INT |
||
| SourceClass | SourceClass INT |
||
| SourceDocType | SourceDocType INT |
||
| SourceDocument | SourceDocument INT |
||
| SourceBusinessPartner | SourceBusinessPartner NVARCHAR (20) |
||
| SourceDocNum | SourceDocNum INT |
||
| SourceDocExternalNumber | SourceDocExternalNumber NVARCHAR (20) |
||
| SourceKey | SourceKey NVARCHAR (20) |
||
| SourceDate | SourceDate Datetime |
||
| SourcePeriod | SourcePeriod INT |
||
| DimensionClassID | DimensionClassID INT |
||
| DimensionKey | DimensionKey NVARCHAR (20) |
||
| KeyVisible | KeyVisible NVARCHAR (20) |
||
| Matchcode | Matchcode NVARCHAR (50) Index |
||
| LineType | LineType INT |
||
| AuswertungViewMode | AnalysisViewMode INT |
||
| AuswertungLine | AnalysisLine INT |
||
| PhaseID | PhaseID INT |
MPProjektPhasen.PhasenID | |
| PhaseGroup | PhaseGroup INT |
||
| Qty | Quantity NUMERIC(19,6) |
||
| CurrencySource | CurrencySource NVARCHAR (3) |
||
| CurrencySourceLoc | CurrencySourceLoc NVARCHAR (3) |
||
| CurrRate | CurrRate NUMERIC(19,6) |
||
| CurrRateLoc | CurrRateLoc NUMERIC(19,6) |
||
| UnitPriceSource | UnitPriceSource NUMERIC(19,6) |
||
| UnitPriceSourceLoc | UnitPriceSourceLoc NUMERIC(19,6) |
||
| UnitPriceSourceSys | UnitPriceSourceSys NUMERIC(19,6) |
||
| CorrectionValue | CorrectionValue NUMERIC(19,6) |
||
| CorrectionValueLoc | CorrectionValueLoc NUMERIC(19,6) |
||
| CorrectionValueSys | CorrectionValueSys NUMERIC(19,6) |
||
| CashMode | CashMode INT |
||
| CashInReal | CashInReal NUMERIC(19,6) |
||
| CashInRealLoc | CashInRealLoc NUMERIC(19,6) |
||
| CashInRealSys | CashInRealSys NUMERIC(19,6) |
||
| CashInEstimate | CashInEstimate NUMERIC(19,6) |
||
| CashInEstimateLoc | CashInEstimateLoc NUMERIC(19,6) |
||
| CashInEstimateSys | CashInEstimateSys NUMERIC(19,6) |
||
| CashOutReal | CashOutReal NUMERIC(19,6) |
||
| CashOutRealLoc | CashOutRealLoc NUMERIC(19,6) |
||
| CashOutRealSys | CashOutRealSys NUMERIC(19,6) |
||
| CashOutEstimate | CashOutEstimate NUMERIC(19,6) |
||
| CashOutEstimateLoc | CashOutEstimateLoc NUMERIC(19,6) |
||
| CashOutEstimateSys | CashOutEstimateSys NUMERIC(19,6) |
||
| TaxIn | TaxIn NUMERIC(19,6) |
||
| TaxInLoc | TaxInLoc NUMERIC(19,6) |
||
| TaxInSys | TaxInSys NUMERIC(19,6) |
||
| TaxOut | TaxOut NUMERIC(19,6) |
||
| TaxOutLoc | TaxOutLoc NUMERIC(19,6) |
||
| TaxOutSys | TaxOutSys NUMERIC(19,6) |
||
| DueDateMode | DueDateMode INT |
||
| DueDate | DueDate Datetime |
||
| CashDate | CashDate Datetime |
||
| CashPeriod | CashPeriod INT |
||
| Info | Info NTEXT |
||
| DisplayOptions | DisplayOptions INT |