Fields

Advantage:2E fields

Each Advantage:2E Field has a Name and a Field Type
Advantage:2E Field Naming rules
•unique within the model
•up to 25 characters including embedded blanks
•e.g. Customer Code is a valid

Advantage:2E Field Name
•implementation name is different

Advantage:2E Field Types
•depends on the type of values
•broadly classified as alphanumeric, numeric & special field types

FieldType Name Description Type Length Example
CDE Code A 6 Stock Code
DTE Date P 7,0 Date of birth
IGC Idegraphic text A 20 Kanji name
NAR Narrative text A 30 Comments
NBR Number P 5.0 # of employees
PCT Percentage P 5.2 Profit margin
PRC Price or tariff P 7.2 Unit Price
QTY Quantity P 5.0 Stock quantity
REF Reference - - Field based on another
SGT Surrogate P 7.0 System Key
STS Status A 1 Yes/No
TME Time P 6.0 Change Time
TXT Descriptive name A 25 Product name
VAL Monetary value P 11.2 Stock value
VNM Valid system nameA 10 File name

*******************************************************************************

Field Usage:
Two types are Database fields and Function Fields
Database fields:
Code fields (CDE) :- used for key fields e.g. Employee Code.
Data attribute (ATR):- Used for non-key fields e.g. Employee Name.

Function Fields:
Fields used only in functions but do not reside in database, fields can be added to data dictionary and accessed in device designs and action diagrams. There are 6 function field usage types: They are as follows.
CNT (Count)
MAX(maximum)
MIN(minimum)
DRV(Derived)
SUM(sum)
USR(User-defined)

Creating/Defining Fields in Synon In the Object type column of Define Objects panel, enter FLD
Type Field Name in Object Name column
Type Advantage:2E field type in the Object attr column
Type Referenced field if the field refers to another field for domainIn the Field Usage column, type CDE (Code) or ATR (attribute) or a function field usage

Advantage:2E conditions
Specifies the values or set of values a field may takeCondition has a Name, a type and an associated value
1. Value (VAL) Condition
Used to specify single values that status field can taketwo related values: internal value - value in the implemented database external value - value displayed/entered on the screene.g. Premium paid condition has file value “Y”
2. List (LST) Condition
used to specify list of values that status field can takescreen functions implement prompt key (F4)e.g. Invoice Flag can have valid values U, D, P, H, C and the condition Invoice not due has file value “U”.
3. Compare (CMP) Condition
defined in terms of a fixed value and an operatorvalid operators: *EQ, *NE, *GT, *LT, *GE, *LEe.g. Order Quantity field can have an associated condition by name greater than 10 with operator *GT and value 10.
4. Range (RNG) Condition
defines range of values that field can takedefined in terms of From and To valuese.g. Stock Quantity field can have an associated condition by name between 10 and 100 with From value as 10 and To value as 100