Field

Entries in this tab will come automatically when you press Create Fields button from the tab name Tab. You can customize fields here like set any Display logic, Read Only, Displayed, Same Line etc.

Field description is below

Column

Columns of the table linked with the tab. Indicate the Column in the table which is linked with the respective field.

Info Window

Info and search/select Window

The Info window is used to search and select records as well as display information relevant to the selection. Show here info window which are created against table linked with respective field column. For more detail you can also go through search reference in section 2.4 Column

Entity Type

By default it will set as User maintained. But if you want that this Column should not get affected from the download of a module from Vienna Market then mark it as Other Customization.

Field Group

Indicate logical grouping of fields. The Field Group indicates the logical group that this field belongs to which Field Group (e.g. History, Amounts, and Quantities)

Centrally maintained

Information maintained in System Element table if checkbox value is true. The Centrally Maintained checkbox indicates if the Name, Description and Help maintained in 'System Element' table or 'Window' table.

Displayed

Determines, if this field is displayed. If the field is displayed, the field Display Logic will determine at runtime, if it is actually displayed.

Read Only

Field is read only. The Read Only indicates that this field may only be Read. It may not be updated.

Display Logic

If the Field is displayed, the result determines if the field is actually displayed

Format := {expression} [{logic operator} {expression}] 

expression := @{context}@{relation operator}{value}  

logic operator = single pipe symbol {|}, use for logical OR  

single ampersand symbol {&}, use for logical AND 

context := any global or window context  

value := strings or numbers 

relation operator := eq{=}, gt{>}, le{<}, not{^ !}  

Examples:  

@AD_Table_ID@=14 | @Language@!GERGER  

Above format use two expression  

{expression}{ logic}{ expression} 

{AD_Table_ID variable value from context is EQUAL TO 14}{OR}{Language variable value from context IS NOT GERGER} 

Above format is true if one of the expression is true. 

@PriceLimit@>10 | @PriceList@>@PriceActual@ 

@Name@>J 

Strings may be in single quotes (optional)

Display Length

Length of the display in characters

The display length is mainly for String fields. The length has no impact, if the data type of the field is - Integer, Number, Amount (length determined by the system) – YesNo (Checkbox) - List, Table, TableDir (length of combo boxes are determined by their content at runtime)

Encrypted

Display or Storage is encrypted

Display encryption (in Window/Tab/Field) - all characters are displayed as '*' - in the database it is stored in clear text. You will not be able to report on these columns.

Data storage encryption (in Table/Column) - data is stored encrypted in the database (dangerous!) and you will not be able to report on those columns. Independent from Display encryption.

Sequence

Method of ordering elements; lowest number comes first

The Sequence indicates the order of elements

Same Line

Displayed on same line as previous field

The Same Line checkbox indicates that the field will display on the same line as the previous field.

Multi-Row Sequence

Indicate the ordering fields in Multi-Row (Grid) View; lowest number comes first

The Sequence indicates the order of elements

Default Focus

Field received the default focus

When opening a tab, the selected field gets the default focus to enter data.

Record Sort No

Determines in what order the records are displayed

The Record Sort No indicates the ascending sort sequence of the records. If the number is negative, the records are sorted descending. Example: A tab with C_DocType_ID (1), DocumentNo (-2) will be sorted ascending by document type and descending by document number (SQL: ORDER BY C_DocType, DocumentNo DESC)

Heading only

Field without Column - Only label is displayed

The Heading Only checkbox indicates if just the label will display on the screen

Field Only

Label is not displayed

The Field Only checkbox indicates that the column will display without a label.

Reference Overwrite

System Reference - optional Overwrite

You can overwrite the Display Type, but only use this if you aware of the consequences.

Mandatory Overwrite

Overwrite Field Mandatory status

The field must have a value for the record to be saved to the database.

Default Logic:

Default Logic is the field where you can define any default value for a column, i.e. whenever a window opens it’ll show the value or evaluate the expression which you entered here.

Default value hierarchy, separated by;

The defaults are evaluated in the order of definition; the first not null value becomes the default value of the column. The values are separated by comma or semicolon.

For set default value user can set Literals: 'Text' or 123
Can set variables in format @Variable@ -
1. Set Login information from context as default value e.g. @#Date@, @#AD_Org_ID@, @#AD_Client_ID@ etc.
2. Current table column values from context e.g. @ColumnName@, set default value if not null.
3. SQL code with the tag: @SQL=SELECT something AS DefaultValue FROM ...TableName, it should be scalar query.

The SQL statement can contain variables. There should be only one SQL statement.

Default definitions are ignored for record columns set as Key and Parent.

if Data Access Level to Table-> System, then Default value of AD_Client_ID and AD_Org_ID is 0.
If Data Access Level to Table -> System + Client, then default value of AD_Org_ID is 0.
Other than this Default Value is set according to the value defined in AD_Column table for particular column.

Zoom Window

Indicate the window which user want to open from Zoom icon.

It is responsibility of user to link here valid window which is according to column value of respective field. First system will check the Zoom Target window on field level if not found any information then zoom to window which is set on Table level (window field on Table tab).

Copy

Copy contents of this field using the Copy Record function.

Indicates that this field will be copied using the Copy Record function. Certain fields like DocumentNo, DocAction, Posted, Created, etc. will not be copied even if the Copy is enabled.