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.  

  1. For set default value user can set Literals: 'Text' or 123 

  2. 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.

  1. if Data Access Level to Table-> System, then Default value of AD_Client_ID and AD_Org_ID is 0. 
  2. If Data Access Level to Table -> System + Client, then default value of AD_Org_ID is 0. 
  3. 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.