Tables data block

The Tables data block shows the tables created / available in the context of the Assembly.

Step by Step — Utilizing the Tables Data Block

  1. Right-click the table you want to open. This opens the Table Record.
  2. In the Table Record, the Code field automatically fills with the name of the Table Code from the Cost Item Assembly Record.
  3. Complete the Description field using a name relative to the Table Record.
  4. Complete the fields below using the drop-down menus in the Setup data block:
    1. Assembly File
    2. Geographic Area
    3. Wage zone
    4. Org. Category
  5. Last Changed By and Last Changed On will automatically generate.
  6. Navigate to the Columns data block.
  7. For each column, users shall be able to define the following attributes:
    • Display Order: Determines the order in which columns will appear in the table.
    • Column Name: This is the name that will be referenced in formulas to return data from this column of the table. This name must be unique within the table.
    • Description: Descriptive information about the data that is stored in the column
    • Type: Defines the type of data that can be stored in the column.
      • Text for any alpha /numeric characters
      • Numeric restricts the input to any numeric value. Recommended if calculations will be performed on the data that is referenced in this field.
    • Unique Key: Checking this field means that data entered in this column cannot be repeated and will need to be unique relative to all the other data appearing in this field in the table. Every table must have only one field designated as the Unique Key field and this field is commonly used as the referenced field for looking up values used in calculations.
    • Order By: This field determines which table column is used to sort the resulting data in the selection register.
    • Default Visibility: The check box determines if a value appears in the default form.
  8. Navigate to the Tables data block. The Table data block is where users can enter their data into the table

    9. Users may create these tables using MS Excel and copy and paste into this table or directly fill in the values.

  9. The columns will display the Field Description in the first line, followed by the Column Name in parentheses in the second line.