The Attributes tab of the Message Definition Properties sheet lets you quickly set information for all fields of a RAP message.
| Property | Description |
|---|---|
| Name |
Name of the field. The value can contain any string. This element is used only for descriptive purposes. Same as RDS template FieldName field. |
| Destination Column Name |
Column into which the field data should be stored. There is one column per field. The value of this element can contain any string that is a valid SQL identifier. Same as RDS template DestColumnName field. |
| RAP Datatype |
Select from the list of supported datatypes. For more information on supported datatypes and conversions, see Supported Datatypes for Message Flow and related information in RAP – The Trading Edition Developers Guide. |
| Length |
Equivalent to <Precision> in RAP message templates. Required for decimal data. Limited to precision 38. Precision must be the same on RAPCache and RAPStore. Optional for string data. If string length is unspecified, the generated database table uses 255, the maximum length. Not used for other datatypes. |
| Precision |
Equivalent to <Scale> in RAP message templates. Required for decimal data. Not used for other datatypes. |
| Lookup table name |
Table to use to look up a value. Same as RDS template LookupTableName field. |
| Lookup column name |
Column to use to look up a value. The lookup column must be convertible into the RAP datatype of the lookup data. See Datatype Conversion in RAP – The Trading Edition Developers Guide. Same as RDS template LookupColumnName field. |
| Lookup column return |
Column from which to return data when doing a lookup. The lookup return column data type must be convertible into the RAP datatype of the destination column of the target table. Same as RDS template LookupColumnReturn field. |
Each field in a message definition has its own Properties sheet.