In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • Defining Database Control Settings
    Use Database Control (36.24) to set the time zone of the database server and to register a code for defining unique record identifiers. You should do this before defining users since the time zone specified here defaults when new user records are created.

    Database Control (36.24)
    OID Generator Code
    The OID Generator Code in Database Control is used to assign unique object identifiers (OIDs) to database records for auditing purposes. The code is assigned during system implementation.
    Based on the OID generator code, the OID fields in the database are populated using an algorithm that ensures uniqueness across all records, tables, and QAD ERP application databases within the company. The value stored in the OID field for each record has the following decimal format:
    <date><seq_value>.<registration_id>
    Where:
    <date> is the server date with format yyymmdd.
    <seq_value> is obtained from a Progress database sequence.
    <registration_id> identifies the origin of the OID value.
    The registration ID is derived from the OID generator code by reversing the digits of the generator code value and placing the decimal point in front of the result.
    Server Time Zone
    Enter the time zone associated with the server machine for the current database. The system verifies that this is a valid time zone defined in Multiple Time Zones Maintenance (36.16.22.1).
    If you are using the optional Service/Support Management module and the Multiple Time Zone option is activated in Service Management Control (11.24) for any domain in the database, this field cannot be modified here. Instead, you must use the Server Time Zone Change Utility (11.21.22.22).
    See User Guide: Service/Support Management.
    When a new user is created in User Maintenance (36.3.1), the user time zone defaults from the server time zone.