Data Types in Aurea CRM

In some dialog boxes, the field type is also displayed along with the field name and number.

The following data types are available:

• B = Boolean (logical)
• C = Character string
• D = Date
• F = Floating point number
• K = Variable catalog
• L = Long integer
• S = Short integer
• T = Time
• X = Fixed catalog
• Z = Decoded field. Values in these fields are automatically entered by the business logic. Z-fields do not exist in the database. (Examples: reference fields, fields that contain links to other records, rep fields, rep group fields, 2nd currency fields, external match-up fields etc.).

  Z-fields cannot be added as search fields or used for defining filters and queries.

  The content of a Z-field is not updated in lists if the target record is updated by another process. Workaround: Instead of the Z-field add a linked field of the target record to the list. Example: Instead of using the Company field (MA:76), add the Company field from FI as linked field to the MA List control.