Common Module

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
JOB_PROCESS_RUNNING_TYPE		D	Values: H, D, {blank} - Shows current job chain type, (H)IST or (D)AILY	Shows which scheduled job chain is currently or has most recently ran. Used to control the job chain procedure. Set by DAILY_START and HIST_START so no need to user edit.	COM	Do Not Edit
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	5000	Number of records that would typically be in three days worth of data to ensure readiness for tr_hist.tr_trnbr rollover.	TR_HIST processing in the common module takes longer when looking for the TR_HIST transaction number to roll back to all zeroes, but this number should not be smaller than the number of transactions performed every 2-3 days by a customer. We estimate 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