Database Naming Conventions

Class

Title with a capital letter, for example, Customer. When these are viewed in the Report Writer, they are always displayed in red and are not prefixed with an image.

Attributes

These always begin with a lower case letter and are prefixed with a specific image depending on their type:

• alphanumeric attributes are prefixed with this image: . For example, code.
• numeric attributes are prefixed with the following: . For example, creditLimit.
• dates attributes are prefixed with this image: . For example, createDate.
• true/false attributes are prefixed with the following image: . For example, isCheckingCredit.

If two or more words are used to describe an attribute, subsequent words are prefixed with a capital letter, for example, creditLimit, emailAddress.

Collections

These always begin with all and are prefixed with this image: . For example, allUnappliedTransactions, allUserFields.

References

These always begin with my and are prefixed with this image: . For example, myAddress and myARControl.

Trees

These are named as per the trees set up in the relevant module Tree Maintenance form, and are prefixed with this image: . For example, Customer Type.

User Defined Fields

These are named as per the user defined fields set up in the relevant module, and are prefixed with this image: . For example, Business Type.