| Table Name: | MPDBColumnsDefinitionCol |
| View Name: | MARIInfoScreenManagementBreakEvenColumnDef |
| Group: | Group: InfoScreenManagementBreakEven |
| Description: | Info Screen Management: Column Definition Columns |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| UniqueColID | UniqueColID INT Primary |
||
| ColumnDefinitionID | ColumnDefinitionID INT Primary |
MPDBColumnsDefinition.ColumnDefinitionID | |
| Reihenfolge | SortOrder INT Index |
||
| ColumnName | ColumnName NVARCHAR (50) |
||
| ColumnGroupName | ColumnGroupName NVARCHAR (50) |
||
| ColumnCode | ColumnCode NVARCHAR (2) |
||
| ColumnsDefTypeID | ColumnsDefTypeID INT |
||
| ShowSpalte | ShowColumn SMALLINT |
||
| StyleFormat | StyleFormat INT |
||
| StyleFarbe | StyleColour INT |
||
| TimeSelectionMode | TimeSelectionMode INT |
||
| GLAccount1 | GLAccount1 NVARCHAR (20) |
OACT.AcctCode | |
| GLAccount2 | GLAccount2 NVARCHAR (20) |
OACT.AcctCode | |
| GLAccount3 | GLAccount3 NVARCHAR (20) |
OACT.AcctCode | |
| GLAccount4 | GLAccount4 NVARCHAR (20) |
OACT.AcctCode | |
| OcrCode1 | OcrCode1 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OPRC.OcrCode (WHERE [DimCode]=3) | |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| BookingFlag | BookingFlag INT |
||
| FreigabeMode | ApprovalMode INT |
||
| PeriodeOffset1 | PeriodOffset1 INT |
||
| PeriodeOffset2 | PeriodOffset2 INT |
||
| PlanungsVersionMode | PlanningVersionMode INT |
||
| PlanungsVersionValue | PlanningVersionValue INT |
||
| FreeQueryID | FreeQueryID INT Index |
MPSysUserQuery.UserQueryID | |
| BreakEvenLine | BreakEvenLine INT |
||
| ShowTotalFromLine | ShowTotalFromLine INT |
||
| ExportColumnName | ExportColumnName NVARCHAR (100) |
||
| FormularValue | Formular NTEXT |
||
| UpdateStamp | UpdateStamp INT |
||
| Memo | Memo NTEXT |