Permitting users to add rows

To provide users with the ability to add rows to the extension table from the object itself, complete these steps.

  1. Open the Extension Table Definition form.
  2. Complete these entries in the Main tab.
    Description
    Specify a description for the extension table. The description is the label that identifies the table to users. Click Language Translation to specify the translated description label.
    Supported Symbol
    Specify the business object in which to add the extension table.
    Allow users to add rows
    Select the Allow users to add rows check box.
    Database Table Name
    Specify a name for the extension table. Prefix the table name with C_. After you click Save, you cannot change this table name.
    Sort Order
    Specify the database column that is used to sort the rows in the extension table. Typically, this value is LINE_ID.
    View ID
    This table number is assigned by Optiva. The value is -1 until you click Save.
    Lookup Sequence
    Specify a numeric value. This value indicates the order in which the table is listed in the Business object > Extension Tables filter. What if you specify 1 for Extension Table B and 2 for Extension Table A? In the business object > Extension Table filter, Extension Table B is listed above Extension Table A.
  3. Add at least one row in the Columns tab. This tab must include the name of the column that you specified in the Sort Order field. For this example, it is LINE_ID.

    For this example, specify these values for the LINE_ID.

    Description Column
    DB Name Specify LINE_ID.
    Data Type Select auto long. This is the recommended value for LINE_ID.
    Length Leave blank for Data Types: Auto long, Integer, Long, Double, and Date
    Required Yes
    Column Label Line No
    Read Only Yes - The line number is incremented by Optiva.
    Primary Key Yes or No
    See Specifying the criteria in the Columns tab.
  4. Specify who has access to the extension table in the object form. You must specify at least one user, role or group. Then, specify the level of security access for the corresponding users, roles, and groups. The privileges are Read and Read/Write.
  5. Click Save. The extension table is created in the Optiva database.