EBMS Tables and Fields

Data within an ERP system such as EBMS is stored within relational tables or files.   For example a table stores the main customer information within EBMS.  Each customer is identified by a separate record.  Each record contains multiple fields or pieces of information.  

  1. EBMS stores customer information within the customer file or table.  The customer information can be viewed as a list within the Sales > Customers lookup list as shown below:

  2. Customer information are recorded within individual records.

  3. Customer information are stored within fields such as L_Name for Last Name or Address1 for the first line of the customer's address.   

The technical EBMS tables and fields can be identified by completing the following steps:

  1. Open the dialog that displays the specific field information such as a customer.

  2. Right-click on the desired field within the window and press the <Shift> and <Ctrl> buttons while selecting the What's This? option on the context menu.

  3. The What's This dialog will show the database File and Field names.

EBMS Placeholders

Placeholder reference to data can be added to a message using the EBMS database.  The place holder format is as follows:  <file.field>   (Less than symbol, file name, period, field name, and greater than symbol).

Review Features > Message Syntax for examples of using place holders in messages.