| Table Name: | MPChefInfoCashFlowRunProject |
| View Name: | MARIChefInfoCashFlowRunProject |
| Group: | Group: InfoScreenManagementBreakEven |
| Description: | Info Screen Management: Status of a project |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ProjectNumber | ProjectNumber NVARCHAR (20) Primary |
MPProjektstamm.Projektnummer | |
| ProjectUpdateStamp | ProjectUpdateStamp INT |
||
| SavedDataID | SavedDataID INT Index |
||
| SavedDataDate | SavedDataDate Datetime |
||
| CashFlowDefinitionID | CashFlowDefinitionID INT Index |
||
| CashFlowDefinitionStamp | CashFlowDefinitionStamp INT |
||
| ContractKeys | ContractKeys NTEXT |
||
| ContractDocumentKeys | ContractDocumentKeys NTEXT |
||
| PurchaseProcessKeys | PurchaseProcessKeys NTEXT |
||
| PurchaseProcessDocumentKeys | PurchaseProcessDocumentKeys NTEXT |
||
| ARInvoicesOpenAmountSys | ARInvoicesOpenAmountSys NUMERIC(19,6) |
||
| ARInvoicesOpenAmountLoc | ARInvoicesOpenAmountLoc NUMERIC(19,6) |
||
| APInvoicesOpenAmountSys | APInvoicesOpenAmountSys NUMERIC(19,6) |
||
| APInvoicesOpenAmountLoc | APInvoicesOpenAmountLoc NUMERIC(19,6) |
||
| PlanningVersion | PlanningVersion INT |
||
| PlanningVersionStamp | PlanningVersionStamp INT |
||
| TimekeepingStamp | TimekeepingStamp INT |
||
| TravelExpenseStamp | TravelExpenseStamp INT |
||
| ItemBookingStamp | ItemBookingStamp INT |
||
| OJDTTransID | OJDTTransID INT Index |
||
| ErrorLevel | ErrorLevel INT |
||
| ErrorText | ErrorText NTEXT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |