| View Name: | MARIInfoScreenManagementBreakEvenColumnDef |
| Based on table: | MPDBColumnsDefinitionCol |
| Group: | Group: InfoScreenManagementBreakEven |
| Description: | Info Screen Management: Column Definition Columns |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| UniqueColID | UniqueColID INT Primary |
||
| ColumnDefinitionID | ColumnDefinitionID INT Primary |
MARIInfoScreenManagementBreakEvenColumnHead.ColumnDefinitionID | |
| SortOrder | Reihenfolge INT Index |
||
| ColumnName | ColumnName NVARCHAR (50) |
||
| ColumnGroupName | ColumnGroupName NVARCHAR (50) |
||
| ColumnCode | ColumnCode NVARCHAR (2) |
||
| ColumnsDefTypeID | ColumnsDefTypeID INT |
||
| ShowColumn | ShowSpalte SMALLINT |
||
| StyleFormat | StyleFormat INT |
||
| StyleColour | StyleFarbe 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 |
||
| ApprovalMode | FreigabeMode INT |
||
| PeriodOffset1 | PeriodeOffset1 INT |
||
| PeriodOffset2 | PeriodeOffset2 INT |
||
| PlanningVersionMode | PlanungsVersionMode INT |
||
| PlanningVersionValue | PlanungsVersionValue INT |
||
| FreeQueryID | FreeQueryID INT Index |
MARISysUserQuery.FreeQueryID | |
| BreakEvenLine | BreakEvenLine INT |
||
| ShowTotalFromLine | ShowTotalFromLine INT |
||
| ExportColumnName | ExportColumnName NVARCHAR (100) |
||
| Formular | FormularValue NTEXT |
||
| UpdateStamp | UpdateStamp INT |
||
| Memo | Memo NTEXT |