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




Order Management Module
 
Table 4.4
Parameters for the Order Management Module (Page 1 of 5)
Parameter Name
Parameter Default Value
Parameter Sample Value
Parameter Comments
Explanation/Notes
Module
Manual/ Programmatic
JOB_SALES_PROCESS_BATCH_ID
0
753
The batch id for the current DAILY_SALES_PROCESS job.
 
OM
P
load_ih_hist_ih_invoicetype
0
ih_hist.ih_invoicetype
Internal use only. Specifies the column name in ih_hist for invoice_type, or 0 if not supported on this version of the source system. There are two invoice type columns in the EE version of ih_hist. This allows us to capture both.
 
OM
P
load_sod_det_sod_compl_stat
N/A'
sod_det.sod_compl_stat
Internal use only. Specifies the column name in sod_det for complete state or N/A if not supported on this version of the source system. (EE vs SE)
 
OM
P
SALES_BOOKING_DATE
<Set to today's date before starting the initial history load>
2011-01-31
The processing date used for SALES bookings processing. Format is YYYY-MM-DD
 
OM
P
SALES_BOOKING_FIRST_DATE
<Set to today's date before starting the initial history load>
2011-01-28
The first processing date for loading bookings. Format is YYYY-MM-DD
 
OM
P
SALES_EARLY_TOLERANCE_DELAY
0
2
Number of days an item can be early and still considered On Time.
 
OM
M
SALES_LATE_TOLERANCE_DELAY
0
2
Number of days an item can be late and still considered On Time.
 
OM
M
SALES_LOAD_DAYS
3000
5000
The number of days to load from the look back days forward for SALES-related transactional tables
Obsolete
OM
M
SALES_LOAD_LOOKBACK_DAYS
2000
5000
The number of days to look back for changes in QAD in a table for SALES-related transactional tables
Obsolete
OM
M
SALES_LOOKBACK_DAYS
60
60
The number of days to look back in the ih_hist and idh_hist tables to pick up changed records.
 
OM
M
SALES_ORDER_HISTORY_DATE
<Set to today's date before starting the initial history load>
2011-01-30
The processing date used for SALES orders history calculations Format is YYYY-MM-DD
 
OM
M
SALES_ORDER_PERF_DATE
 
2011-01-28
The processing date used for SALES order performance table Format is YYYY-MM-DD
 
OM
P
SALES_ORDER_REVALUE_DAYS
10
10
The number of days after the end of the period to wait for revalue exchange rates to be entered before revaluing order history
 
OM
M
SALES_ORDER_REVALUE_PERIODS
1
1
The number of periods to revalue in order history
 
OM
M
SALES_PERCENT_QTY_OVER
0
2
Percentage over the ordered amount that can be delivered and the order still considered delivered in full.
Added in 3.7
OM
M
SALES_PERCENT_QTY_UNDER
0
3
Percentage under the ordered amount that can be delivered and the order still considered delivered in full.
Added in 3.7
OM
M
SALES_PROCESS_CONNECTION_NAME
 
2010SE
Indicates the connection name used by the SALES process job
 
OM
P
SALES_PROCESS_DAYS
10
20
The number of days of sales to extract and process from permanent staging tables.
 
OM
M
SALES_PROCESS_RUNNING
N
N
Indicates if a SALES process is currently running (Y,N)
Used to prevent multiple copies of the Order Management/Sales job from running at the same time. Under normal conditions, do not update this manually. However, if a job fails and is deleted, 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 chaning from to "N" from "Y".
OM
P
SALES_PROCESS_RUNNING_JOB_NAME
 
DAILY_SALES_PROCESS_2010SE
Inserted via WsParameterWrite
 
OM
P
SALES_SHIPMENT_FILTER
N
N
Filter the shipment data to remove consignments
 
OM
M
SALES_SNAPSHOT_DAYS
31
31
Number of days to look back when processing sales order snapshot
 
OM
M
SALES_SNAPSHOT_DOW
1
1
Day of Week Number of the Sales Snapshot Extract. Use % for all days.
 
OM
M
SALES_SNAPSHOT_FREQUENCY
M
M
The frequency of snapshots in the Sales order snapshot table. Possible values are: W for Weekly, M for Monthly, B for both weekly and monthly.
 
OM
M
SALES_SNAPSHOT_HIST_START_DATE
<Set to today's date before starting the initial history load>
2011-05-24
Used by the HIST_SALES_ROLLUP job to determine the date at which to start taking Sales order snapshots. Set to today's date by the INITIAL_SETUP_JOB, but can be set to an earlier date by the user if more history in the snapshot is desired.
 
OM
P
SALES_SNAPSHOT_REPLACE_FLAG
N
N
Indicates that snapshots are replaced or not. Y for replace, N for not replaced.
Y to replace the snapshot for recalculated periods when the snapshot job is run; N to add new records and not update previously calculated records. Default value is N.
OM
M
SALES_SNAPSHOT_START_DATE
 
2011-05-24
Internal use only. The setup procedure for the Sales snapshot table updates this parameter to determine the date at which to start by subtracting the SALES_SNAPSHOT_DAYS value from the current date.
 
OM
P