Table

RMS table to which the RMS field belongs. Click the Table popup button to select.

Data Type

Data type of the RMS field. Click the Data Type popup button to select. Standard selections include: 

• Date
• Decimal
• Double
• Integer (long)
• Integer (small)/Boolean
• Memo
• Object
• Real
• String
• Time

Physical Name

Physical name of the RMS field in the Framework ECM database.

Example: 
- l_suburb_id
- s_addr_full
- d_created
- t_created

Logical Name

Logical, or user friendly, name of the RMS field.

Example:  
- The logical name of the physical field name s_addr_full would be Full Address.
- The logical name of the physical table name t_created would be Time Created.

Constant Name

This field/function is currently disabled.

Default Value

Default value of the RMS field.

Size

Size of data the RMS field can hold. This number is restricted to the settings imposed by theFramework ECM SQL database.

Example: Let's say the Framework ECM database restricts the number of characters of the Street Number to 15 characters. The builder may decide that they only ever reach 5 characters so the default value can be modified to 5 characters only. 
Character lengths above the system setting revert to the Framework ECM database size.

Order

Order number of the RMS field. This number determines the order of the RMS Fields list on the RMS Field screen.

Has Permission?

Does the RMS field have any associated security permissions? 

• No (default): The RMS field does not have any associated security permissions.
• Yes: The RMS field has associated security permissions. Security permissions are set on the Security Permission screen in the Security module.

In Reporting?

Can the RMS field be used in reporting? 

• No (default): The RMS field cannot be used in reporting.
• Yes: The RMS field can be used in reporting.

Primary Key?

Is the RMS field the primary key in the RMS table? 

• No (default): The RMS field is not the primary key in the RMS table.
• Yes: The RMS field is the primary key in the RMS table.

Note: All primary keys must be in the format l_[field]_id and have the data type ofInteger (long).