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 Glossary

  • Custom Columns Not Joined to the Baseline Module Tables
    Any columns in new custom tables that are not going to end up being joined to existing dim_ or fact_ tables as part of a view or similar methodology can forgo any prefixing of the column names. The table that they are in, however, should be properly prefixed with an xx as explained in “Custom Columns Joined to Standard Module”.
    Note: Putting in an xx_ prefix for these columns does ensure that we can easily find all custom columns in the system though.