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




Transportation Management Module
 
Table 4.7
Parameters for the Transportation Management Module (Page 1 of 3)
Parameter Name
Parameter Default Value
Parameter Sample Value
Parameter Comments
Explanation/Notes
Module
Manual/ Programmatic
JOB_TM_PROCESS_BATCH_ID
1506
 
The batch id for the current DAILY_TM_PROCESS_JOB job.
 
TMS
P
TM_EXCHANGE_RATE_TYPE
FIXED
 
Determines what Exchange Rate Type to use for currency conversion (FIXED, SPOT, and so on).
 
TMS
M
TM_JOB_CHAINING_ENABLED
N
 
Y if a job starts the next TMS job in the list automatically as it ends, N otherwise.
 
TMS
M
TM_CORP_CURRENCY_CODE
USD
EUR
Corporate currency code
 
TMS
M
TM_LOAD_JOB00XX
 
 
TM Job number 00XX
TM modules jobs in the proper order. Do not modify; add any custom jobs to the end of the job chain.
TMS
M
TM_LOAD_LOOKBACK_DAYS
428
 
The number of days to look back into TMS when extracting data.
 
TMS
M
TM_LOAD_SINGLE_SOURCE
N
 
Flag to identify whether to load only a single source or all defined sources (Y/N).
 
TMS
M
TM_LOAD_SOURCE_S01
 
 
Name of the source system loaded as the 01 job.
 
TMS
M
TM_LOAD_TRANS_TYPES
‘S’, ‘T’
 
 
 
TMS
M
TM_LOAD_TRANS_TYPES_S01
‘S’, ‘T’
 
 
 
TMS
M
TM_PROCESS_CONNECTION_NAME
 
 
Indicates the connection name the TM process job uses.
 
TMS
P
TM_PROCESS_DAYS
100
 
The number of days of TM to extract and process from permanent staging tables.
 
TMS
M
TM_PROCESS_RUNNING
N
 
Flag indicating if TM Process is running. Y/N
 
TMS
P
TM_TOLERANCE_DAYS
3
 
Grace period (in days) after which package is deemed to be failed delivery
 
TMS
M
TM_WEIGHT_CAT_MAX
150
 
MAX Weight Value to individually categorize
 
TMS
M
TM_WEIGHT_CAT_UNITS
1
 
Units to increment each weight category. Value MUST be greater than 0
 
TMS
M
TM_WEIGHT_CAT_UOM
LB
 
Unit of Measure for Weight Category Buckets (LB or KG)
 
TMS
M
TM_SourceConvert_SchemaORA
p2009dev
 
The name of the Oracle schema. Not necessary for Progress source because it always uses PUB.
 
TMS
M
TM_SourceConvert_TargetSource
oracle
 
Tells the conversion procedure what the type of db the load tables will source from. Values either: oracle or progress
 
TMS
M
TM_SourceConvert_TMSMSTRConnectionName
TMS_MASTER
 
The name of the connection the TMS load tables are using. ***All load tables using this connection are updated.
 
TMS
M
 
Table 4.8
System Information
Related to:
Information Needed
Progress Database
Have they already set up ODBC connections to Progress? If not, answer the following Progress database questions for each data source being implemented.
Progress Database
ERP Version
Progress Database
Progress Version (must be 10.1B03 or above)
Progress Database
Preferred connection name.
Progress Database
Host Name
Progress Database
Port Number
Progress Database
Database Name
Progress Database
User ID
Progress Database
Password
Tomcat
URL
Tomcat
Port Number
SQL Server
Host Name
SQL Server
Port Number
Email for Portal
Host Name
Email for Portal
Port Number
Email for Portal
Authorization? Y or N
 
Table 4.9
Parameter Values that Need to Be Set Before History Load (Page 1 of 5)
Parameter Name
Parameter Default Value
Parameter Comments
Notes
Module
AP_EE_HISTORY_DATE_MIN
<customer defined - usually three years back. YYYYMMDD>
The date the AP aging table refreshes from. Three years back is common. For example, 20081231
 
FIN
AP_EE_SNAPSHOT_HIST_START_DATE
2008-12-31
The first date in the AP aging snapshot table in the format YYYY-MM-DD for the first run
Date used for start of AP snapshot in History load. Used for History load only; Daily loads use AP_EE_SNAPSHOT_NUM_DAYS
FIN
AP_SE_SNAPSHOT_HIST_START_DATE
2009-01-01
The first date in the AP aging snapshot table in the format YYYY-MM-DD for the first run
 
FIN
AR_EE_HISTORY_DATE_MIN
<customer defined - usually three years back. YYYYMMDD>
The date the AP aging table refreshes from. Three years back is common. For example, 20081231
 
FIN
AR_EE_SNAPSHOT_HIST_START_DATE
2008-12-31
The first date in the AR aging snapshot table in the format YYYY-MM-DD for the first run
 
FIN
AR_SE_SNAPSHOT_HIST_START_DATE
2009-01-01
The first date in the AR aging snapshot table in the format YYYY-MM-DD for the first run
 
FIN
CORP_CURRENCY_CODE
USD
Corporate currency code used for high-level reporting
The currency code for corporate amounts calculations. Same for entire warehouse.
COM
DAILY_LOAD_SOURCE_S01
<Enter data source name here for initial setup>
Name of the source system loaded as the 01 job.
The connection name of the first or primary source system.
COM
DAILY_LOAD_SOURCE_S02 - DAILY_LOAD_SOURCE_Sxx
Does not exist by default; add if additional source(s)
 
If needed, the connection name(s) of the second and subsequent source systems
COM
DEFAULT_ACCOUNT
00000
The default value used for unknown account
Must not be a real account code
COM
DEFAULT_COST_CENTER
0000
The default value used for unknown cost center
Must not be a real cost center code
COM
DEFAULT_DOMAIN
00000
The default value used for unknown domain
Must not be a real domain code
COM
DEFAULT_ENTITY
0000
The default value used for unknown entity
Must not be a real entity code
COM
DEFAULT_PROJECT
00000
The default value used for unknown project
Must not be a real project code
COM
DEFAULT_SOURCE
 
The default value used for unknown source system
Must not be a real source system code
COM
DEFAULT_SUB_ACCOUNT
0000000
The default value used for unknown sub-account
Must not be a real sub-account code
COM
GL_LOAD_DAYS
152
The number of days to load from the look back days forward for GL-related transactional tables
NOTE: Set to a high value for History loads to load all data desired for historical purposes. Then set to a lower value for Daily loads. Must always be larger than GL_LOAD_LOOKBACK_DAYS.
FIN
GL_LOAD_LOOKBACK_DAYS
150
The number of days to look back for changes in QAD in a table for GL-related transactional tables.
NOTE: Set to a high value for History loads to load all data desired for historical purposes. Then set to a lower value for Daily loads. Must always be smaller than GL_LOAD_ DAYS.
FIN
GL_PERIOD1_FISCAL_ACCOUNT_ZERO_TYPES
 
Account types to set to zero in fact_gl_balances when a new fiscal period starts. If null, none are set. The proper values in this parameter should be a list of account codes such that the string would be appropriate in an "IN" clause.
 
FIN
HIST_LOAD_SOURCE_S01
<Enter data source name here for initial setup>
QMI
Name of the source system loaded as the 01 job.
COM
HIST_LOAD_SOURCE_S02 - HIST_LOAD_SOURCE_Sxx
Does not exist by default; add if additional source
2010SE
 
COM
INITIAL_JOB_SETUP_CONNECTION_01
<Enter data source name here for initial setup>
Name of the connection 01 used as a source system for cloning jobs.
 
COM
INITIAL_JOB_SETUP_CONNECTION_01_RUN
N
This determines if the Initial Job Setup has been run against this data source yet or not. Any new data source must 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
INITIAL_JOB_SETUP_CONNECTION_01_TYPE
<Enter source type - SE, EE, or EAM>
Connection Type - SE for Standard Edition Financials, EE for 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.
COM
INITIAL_JOB_SETUP_CONNECTION_02_DAILY_MODULES
COM, OM, OP, FIN, EAM
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
INITIAL_JOB_SETUP_CONNECTION_02_HIST_MODULES
COM, OM, OP, FIN, EAM
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
INITIAL_JOB_SETUP_CONNECTION_02
 
Name of the connection 02 used as a source system for cloning jobs.
 
COM
INITIAL_JOB_SETUP_CONNECTION_02_RUN
 
This determines if the Initial Job Setup has been run against this data source yet or not. Any new data source must 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
INITIAL_JOB_SETUP_CONNECTION_02_TYPE
<Enter source type - SE, EE, or EAM>
Connection Type - SE for Standard Edition Financials, EE for Enterprise Edition Financials, EAM for Enterprise Asset Management. Defaults to SE.
 
COM
INITIAL_JOB_SETUP_CONNECTION_02_DAILY_MODULES
COM, OM, OP, FIN, EAM
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
INITIAL_JOB_SETUP_CONNECTION_02_HIST_MODULES
COM, OM, OP, FIN, EAM
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
INITIAL_JOB_SETUP_DATE
<Set to today's date before starting the initial history load>
Added in 3.4.1. INITIAL_JOB_SETUP uses this date to populate ussthe majority of the previously manually populated date fields for job setup.
 
COM