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

  • Common Module
     
    Table 4.1
    Parameters for the Common Module (Page 1 of 13)
    Parameter Name
    Parameter Default Value
    Parameter Sample Value
    Parameter Comments
    Explanation/Notes
    Module
    Manual/ Programmatic
    ALTERNATE_EXCHANGE_DOMAIN
     
    USA
    Alternate exchange rate domain name
    Used to calculate exchange rates if the domain in which the calculation is occurring does not have an exchange rate defined
    COM
    M
    AR_PAYMENT_PROCESS_DAYS
    60
    60
    Default value must be 60 days to search for any backdated payments.
     
    COM
    M
    AR_PROCESS_CONNECTION_NAME
     
    2010SE
    Indicates the connection name the AR process job uses.
     
    COM
    P
    COM_PROCESS_CONNECTION_NAME
     
    2010SE
    Indicates the connection name the common process job uses.
     
    COM
    P
    COM_PROCESS_DAYS
    750
     
    The number of days for Dimension tables to extract and process from load tables based on last update date.
     
    COM
    M
    COM_PROCESS_RUNNING
    N
    N
    Indicates if a Common process is currently running (Y,N)
    Used to prevent multiple copies of the COMMON job from running at the same time. Under normal conditions, you should not update this manually. However, if a job fails and is deleted, you may need to reset this to "N" to run the job again. But use caution and ensure that there really is no copy of the job running before changing from to "N" from "Y".
    COM
    P
    COM_PROCESS_RUNNING_JOB_NAME
     
    DAILY_PERM_2010SE
    Indicates the current or last run job name for COMMON processing.
     
    COM
    P
    CORP_CALENDAR_DOMAIN
    <Enter domain here for corporate calendar setup>
    10USA
    The Domain Code used for the corporate financial calendar
    Not used currently
    COM
    M
    CORP_CALENDAR_SOURCE
    <Enter data source name here for corporate calendar setup>
    QMI
    The Source System Code used for the corporate financial calendar
    Not used currently
    COM
    M
    CORP_CURRENCY_CODE
    USD
    USD
    Corporate currency code used for high-level reporting
     
    COM
    M
    DAILY_DATE_ROLL_OVERRIDE
     
    2010-01-01
    YYYY-MM-DD Leave blank to keep dim_date_qad based on today's date; Enter Date to make DAILY job reset the current calendar date to override date.
    Added in 3.7. Used to override current date in the daily_date_roll_qad (which resets the dim_date_qad dimension’s flags for current day, week, month, period, etc.) LEAVE BLANK FOR NORMAL PROCESSING.
    COM
    M
    DAILY_HISTORY_DATE_SET_CURRENT
    Y
    Y
    Default Y indicates that jobs will always set the SALES and PO HISTORY DATE to the current date. If there is a need to run loads using a date before today, set the Value to N and change the values of the history dates to the date needed.
    3.4.1 - Added to determine if the SALES_ORDER_HISTORY_DATES and PO_ORDER_HISTORY_DATES that are set by their respective step jobs should increment by one (better for testing purposes) or are set to current date (presuming that current date minus process days is greater than the last _HISTORY_DATE to avoid data gaps).
    COM
    P
    DAILY_LOAD_JOB_CURNO
    0
    21
    Current Daily Load Job Number
     
    COM
    P
    DAILY_LOAD_JOB0001
     
    SET_CONNECTION_QMI
    Inserted via WsParameterWrite
     
    COM
    P
    DAILY_LOAD_JOB0002 - DAILY_LOAD_JOBxxxx
    Does not exist until INITIAL_JOB_SETUP is run; jobs and their order determined by INITIAL_JOB_SETUP job; should be a complete set of jobs for each source, in order
     
    Inserted via WsParameterWrite
     
    COM
    P
    DAILY_LOAD_SOURCE_CURNO
    0
    0
    Current Source System Number being run
     
    COM
    P
    DAILY_LOAD_SOURCE_S01
    <Enter data source name here for initial setup>
    QMI
    Name of the source system loaded as the 01 job.
    The connection name of the first or primary source system.
    COM
    M
    DAILY_LOAD_SOURCE_S02 - DAILY_LOAD_SOURCE_Sxx
    Does not exist by default; add if additional source(s)
    2010SE
     
    If needed, the connection name(s) of the second and subsequent source systems
    COM
    M
    DAILY_LOAD_SOURCE_S99
    Dummy Parameter
    Dummy Parameter
    Add more by just inserting more parameters
    Add parameters with consecutive numbers for each additional source system.
    COM
    Do Not Edit
    DAILY_MULTI_SOURCE_STAGING
     
     
    'Y' - Run procedures for all sources; 'N' - Run procedure for source specified in %_PROCESS_CONNECTION_NAME
    Added in 3.7; for future use
    COM
    M
    DATE_EARLIEST_POSSIBLE
    1900-01-01
    1900-01-01
    The latest date value possible used for unknown dates and setting history dates
     
    COM
    M
    DATE_LATEST_POSSIBLE
    2999-12-31
    2999-12-31
    The earliest date value possible used for unknown dates and setting history dates
     
    COM
    M
    DEFAULT_ACCOUNT
    00000
    00000
    The default value used for unknown account
    Must not be a real account code
    COM
    M
    DEFAULT_COST_CENTER
    0000
    0000
    The default value used for unknown cost center
    Must not be a real cost center code
    COM
    M
    DEFAULT_DOMAIN
    00000
    Unknown Domain
    The default value used for unknown domain
    Must not be a real domain code
    COM
    M
    DEFAULT_ENTITY
    0000
    0000
    The default value used for unknown entity
    Must not be a real entity code
    COM
    M
    DEFAULT_PROJECT
    00000
    00000
    The default value used for unknown project
    Must not be a real project code
    COM
    M
    DEFAULT_SOURCE
     
    Unknown Source
    The default value used for unknown source system
    Must not be a real source system code
    COM
    M
    DEFAULT_SUB_ACCOUNT
    0000000
    0000000
    The default value used for unknown sub-account
    Must not be a real sub-account code
    COM
    M
    FIN_FIRST_DAY_NAME
    SUN
    SUN
    The short day name of the first day of the week. Used in financial calendar derivation.
     
    COM
    M
    HIST_LOAD_JOB_CURNO
    0
    21
    Current History Load Job Number
     
    COM
    P
    HIST_LOAD_JOB_PREFIX
    HIST_LOAD_
    HIST_LOAD_
    Base name of the History Load job
     
    COM
    P
    HIST_LOAD_JOB0001
     
    SET_CONNECTION_QMI
    Inserted via WsParameterWrite
     
    COM
    P
    HIST_LOAD_JOB0002 - HIST_LOAD_JOBxxxx
    Does not exist until INITIAL_JOB_SETUP is run; jobs and their order determined by INITIAL_JOB_SETUP job; should be a complete set of jobs for each source, in order
     
    Inserted via WsParameterWrite
     
    COM
    P
    HIST_LOAD_SOURCE_CURNO
    1
    1
    Current Source System Number being run
     
    COM
    P
    HIST_LOAD_SOURCE_S01
    <Enter data source name here for initial setup>
    QMI
    Name of the source system loaded as the 01 job.
     
    COM
    M
    HIST_LOAD_SOURCE_S02 - HIST_LOAD_SOURCE_Sxx
    Does not exist by default; add if additional source
    2010SE
     
     
    COM
    M
    HIST_LOAD_SOURCE_S99
    Add more by just inserting more parameters
    Add more by just inserting more parameters
    Dummy Parameter
     
    COM
    Do Not Edit
    HIST_LOAD_TR_HIST_RUNNING
    N
    C
    Indicates a tr_hist history load processes is underway. C for completed, Y for yes or N for no.
     
    COM
    P
    INITIAL_JOB_SETUP_CONNECTION_01
    <Enter data source name here for initial setup>
    QMI
    Name of the connection 01 used as a source system for cloning jobs.
     
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_01_RUN
    N
    Y
    This determines if the Initial Job Setup has been run against this data source yet or not. Any new data source should have an N. Value is set to C when historic load has completed.
    Used by INITIAL_JOB_SETUP job to ensure that existing data sources are NOT rerun as part of the historic load when new sources are added.
    COM
    M/P
    INITIAL_JOB_SETUP_CONNECTION_01_TYPE
    <Enter source type - SE, EE, EAM>
    EE
    Connection Type - SE for ERP with Standard Edition Financials, EE for ERP with Enterprise Edition Financials, and EAM for Enterprise Asset Management. Defaults to SE
    Used to determine whether to set up EE Financial or SE Financial jobs for this data source, or whether to use the EAM job chain instead of the ERP job chain.
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_01_DAILY_MODULES
    COM, OM, OP, FIN, EAM
    COM, FIN
    Example: 'COM, FIN' - List Modules to be part of DAILY job chain.
    Added in 3.7 - Set to list of modules appropriate to the source. Default is fine for most installations as any uninstalled modules are skipped.
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_01_HIST_MODULES
    COM, OM, OP, FIN, EAM
    COM, FIN
    Example: 'COM, FIN' - List Modules to be part of HIST job chain.
    Added in 3.7 - Set to list of modules appropriate to the source. Default is fine for most installations as any uninstalled modules are skipped.
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_01_VERSION
     
    2011
    Version - specify version of the QAD Application, to skip tables in BI that don't exist in older versions Example : 2012
    Only specify the whole number value of the release version (e.g., 2010, 2011, 2012, 2013); do not include any point values (e.g., do NOT enter 2011.1 – just enter 2011)
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_02
     
    2010SE
    Name of the connection 02 used as a source system for cloning jobs.
     
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_02_RUN
     
    Y
    This determines if the Initial Job Setup has been run against this data source yet or not. Any new data source should have an N.
    Added in 3.4.1 – Used by INITIAL_JOB_SETUP job to ensure that existing data sources are NOT rerun as part of the historic load when new sources are added.
    COM
    M/P
    INITIAL_JOB_SETUP_CONNECTION_02_TYPE
     
    SE
    Connection Type - SE for ERP with Standard Edition Financials, EE for ERP with Enterprise Edition Financials, and EAM for Enterprise Asset Management. Defaults to SEConnection
     
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_02_DAILY_MODULES
    COM, OM, OP, FIN, EAM
    COM, FIN
    Example: 'COM, FIN' - List Modules to be part of DAILY job chain.
    Added in 3.7 - Set to list of modules appropriate to the source. Default is fine for most installations as any uninstalled modules are skipped.
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_02_HIST_MODULES
    COM, OM, OP, FIN, EAM
    COM, FIN
    Example: 'COM, FIN' - List Modules to be part of HIST job chain.
    Added in 3.7 - Set to list of modules appropriate to the source. Default is fine for most installations as any uninstalled modules are skipped.
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_02_VERSION
     
    2011
    Version - specify version of the QAD Application, to skip tables in BI that don't exist in older versions Example : 2012
    Only specify the whole number value of the release version (e.g., 2010, 2011, 2012, 2013); do not include any point values (e.g., do NOT enter 2011.1 – just enter 2011)
    COM
    M
    INITIAL_JOB_SETUP_CONNECTION_99
    Add more by just inserting more parameters
    Add more by just inserting more parameters
    Dummy Parameter
     
    COM
     
    INITIAL_JOB_SETUP_DATE
    <Set to today's date before starting the initial history load>
    Set to today's date (current date) so INITIAL_JOB_SETUP uses this date to populate various other parameters. YYYY-MM-DD
    Added in 3.4.1. INITIAL_JOB_SETUP uses this date to populate most of the previously manually populated date fields for job setup.
     
    COM
    M
    INITIAL_JOB_SETUP_ENABLED
    Y
    N
    Indicates that the job cloning functionality is unlocked. This is a Y or N flag - initially Y then change to N when job cloning has been completed.
    If this is set to "N", the INITIAL_JOB_SETUP job does not do anything. If set to "Y", running the INITIAL_JOB_SETUP job creates the jobs for each source defined in the DAILY and HIST source parameters, then set the value back to "N" so that the initial job cannot be accidentally run again.
    COM
    M/P
    INITIAL_JOB_SETUP_JOBINJOB_01
    DAILY_XXXXXXXX
    DAILY_XXXXXXXX
    Name of the 01 job that contains other jobs.
     
    COM
    Do Not Edit
    INITIAL_JOB_SETUP_JOBINJOB_02
    HIST_LOAD_XXXXXXXX
    HIST_LOAD_XXXXXXXX
    Name of the 02 job that contains other jobs.
     
    COM
    Do Not Edit
    INITIAL_JOB_SETUP_JOBINJOB_03
     
     
    Name of the 03 job that contains other jobs.
     
    COM
    Do Not Edit
    INITIAL_JOB_SETUP_JOBINJOB_04
     
     
    Name of the 04 job that contains other jobs.
     
    COM
    Do Not Edit
    INITIAL_JOB_SETUP_JOBINJOB_99
    Add more by just inserting more parameters
    Add more by just inserting more parameters
    Dummy Parameter
     
    COM
    Do Not Edit
    JOB_CHAINING_ENABLED
    Y
    Y
    Y if a job starts the next job in the list automatically as it ends, N otherwise
     
    COM
    M
    JOB_COM_PROCESS_BATCH_ID
    0
    748
    The batch id for the current DAILY_COMMON_PROCESS job.
     
    COM
    P
    load_tr_hist_tr_qty_cn_adj
    0
    tr_hist.tr_qty_cn_adj
    Internal use only. Specifies the column name in tr_hist for consignment adjustments, or 0 if not supported on this version of the source system.
     
    COM
    P
    NOT_APPLICABLE_FLAG_VALUE
    N
    N
    The value assigned for a flag field that is not applicable.
     
    COM
    M
    NOT_APPLICABLE_NUM_VALUE
    0
    0
    The value assigned for a numeric field that is not applicable.
     
    COM
    M
    NOT_APPLICABLE_TEXT_VALUE
    Not Applicable
    Not Applicable
    The value assigned for a field that is not applicable.
     
    COM
    M
    PERM_HIST_DATE
    1900-01-01
    1900-01-01
    History Date for Permanent Staging Tables
     
    COM
    P
    PERM_HIST_PREFIX
    HIST
    HIST
    History load job name prefix
     
    COM
    Do Not Edit
    QAD_MASTER_CONNECTION_NAME
    QAD_MASTER
    QAD_MASTER
    The name of the master generic connection used for all load tables
     
    COM
    Do Not Edit
    TR_HIST_CONNECTION_NAME
     
    2010SE
    Inserted via WsParameterWrite
     
    COM
    P
    TR_HIST_DATE_MAX
     
    2012-08-08
    DON’T UPDATE MANUALLY. Maximum tr_hist Date (YYYY-MM-DD) from last run for this source.
    Copied from TR_HIST_DATE_MAX_SXX for the source currently being processed.
    COM
    P
    TR_HIST_DATE_MAX_SXX
     
    2012-08-08
    DON’T UPDATE MANUALLY. Maximum tr_hist Date (YYYY-MM-DD) from last run for this source.
    Added in 3.6.1. Used with TR_HIST_PROCESS_DAYS and tr_trnbr to ensure that most recent transactions are retrieved, even after tr_trnbr roll over.
    COM
    P
    TR_HIST_DOMAIN
     
    'AUTO','QP','QPAU','QPCAN','QPMEX','train'
    DON’T UPDATE MANUALLY. Domain to extract this iteration
     
    COM
    P
    TR_HIST_DOMAIN_SXX
    Does not exist until after a load of source_XX’s data
    '10USA','11CAN','12MEX','20FRA','21NL','22UK','30CHN','31AUS','CAN','FRA','QMSEMEA','QMSUS','Train','UK','USA'
    Inserted via WsParameterWrite
    List of domains in the source; set programatically.
    COM
    P
    TR_HIST_LOAD_MAXSIZE
    1000000
    1000000
    The maximum number of rows to load in an iteration loading tr_hist
     
    COM
    P
    TR_HIST_LOOP_NO
    0
    0
    DON’T UPDATE MANUALLY. The iteration number loading tr_hist.
     
    COM
    P
    TR_HIST_MAX_VALUE
    99999999
    99999999
    The rollover number for the tr_hist.tr_trnbr field.
    Added in 3.6.1. This is the maximum number allowed for the tr_hist.tr_trnbr field, or in other words, the number after which the tr_trnbr rolls over and start at the first available low number. The default value is 99999999. If the tr_sq01 sequence is set to a different maximum value, enter that here.
    COM
    M
    TR_HIST_PCT_OF_MAX_REF
    50
    30
    Percent of the TR_HIST_MAX_VALUE to use as a reference point to look at smaller or bigger numbers when dealing with the rollover.
    Added in 3.6.1. This is the percent of the TR_HIST_MAX_VALUE to use as a reference point to look for new low-numbered transactions when dealing with the rollover. The default value is 50. When this value is 50, you search the transactions with numbers less than 50% of the TR_HIST_MAX_VALUE for the highest number with a transaction date within the processing window.
    COM
    M
    TR_HIST_PRE_ROLLOVER_COUNT
    5000
    7000
    Number of records that would typically be in three days worth of data to ensure readiness for tr_hist.tr_trnbr rollover.
    Added in 3.6.1. This is the number of records that would typically be in three days worth of data to ensure readiness for tr_hist.tr_trnbr rollover. Once the tr_trnbr for a source is detected to be within TR_HIST_PRE_ROLLOVER_COUNT of TR_HIST_MAX_VALUE, the BI system sets the TR_HIST_TRAN_MAX_Sxx value for the source to 0. This forces the tr_hist extraction to scan the whole table for records that have been processed within the last TR_HIST_PROCESS_DAYS. The default value is 5000.
    COM
    M
    TR_HIST_PROCESS_DAYS
    3
    6
    Number of look back days when extracting data from tr_hist. The records being extracted are tr_trnbr records that are > than the highest transaction_number records already extracted for that source except for tr_nbr rollover where dates come into play.
    Added in 3.6.1. This is the number of look-back days when extracting data from tr_hist. The records being extracted are records where tr_trnbr is greater than the highest transaction_number records already extracted for that source, except after tr_trnbr rollover, when newer transactions may have smaller trnbrs than older transactions. The BI DW must also take into account the transaction date in order to find the lower-numbered transactions that are new. This parameter says to extract from the ERP transactions entered within the last X days. If the number of days since the TR_HIST_DATE_MAX_Sxx is greater than the TR_HIST_PROCESS_DAYS parameter, a task that checks this during the run fails and indicates that this number needs to be increased. The default value is 3.
    COM
    M
    TR_HIST_ROW_COUNT
    0
    24186
    DON’T UPDATE MANUALLY. Number of rows loaded into tr_hist.
     
    COM
    P
    TR_HIST_SOURCE_SXX
    Does not exist until after a load of source's data
    QMI
    Inserted via WsParameterWrite
     
    COM
    P
    TR_HIST_TRAN_MAX
     
    2134
    DON’T UPDATE MANUALLY. Maximum Transaction Id to extract this iteration.
     
    COM
    P
    TR_HIST_TRAN_MAX_SXX
    Does not exist until after a load of source's data
    27971
    DON’T UPDATE MANUALLY. Maximum Transaction Id to extract this iteration.
     
    COM
    P
    TR_HIST_TRAN_MIN
    -1
    -1
    DON’T UPDATE MANUALLY. Minimum Transaction Id to extract this iteration.
     
    COM
    P
    TR_QTY_CN_ADJ
    tr_hist.tr_qty_cn_adj
    0
    Internal use only. Specifies the column name in tr_hist for consignment adjustments, or 0 if not supported on this version of the source system.
    Is set internally; do not set manually. Used by load_tr_hist and load_tr_hist_history
    COM
    P
    UNKNOWN_NUM_VALUE
    9999
    9999
    Default value to insert for a column containing NULLs. Used for Primary Key Columns.
     
    COM
    M
    UNKNOWN_VALUE
    Unknown
    Unknown
    Default value to insert for a column containing NULLs. Used for Primary Key Columns.
     
    COM
    M
     
    Table 4.2
    Parameters for Various Module
    Parameter Name
    Parameter Default Value
    Parameter Sample Value
    Parameter Comments
    Explanation/Notes
    Module
    Manual/ Programmatic
    load_xxxxxx_0
    Does not exist until after a load
    1301
    Rowcount from native load at 31/01/11 04:36:45
    One row per load table; value is number of rows loaded the last time the specified table was loaded; comment indicates date/time of last load
    Various
    P