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  |   On Demand  |   Home  |   qad.com




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