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




Operations Module
 
Table 4.5
Parameters for the Operations Module (Page 1 of 9)
Parameter Name
Parameter Default Value
Parameter Sample Value
Parameter Comments
Explanation/Notes
Module
Manual/ Programmatic
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.
When extracting from EE sources, invoice type needs to reference a new column in the ih_hist table.
OP
P
INV_BALANCE_HIST_START_DATE
2008-01-01
2008-01-01
The START date used for Inventory Transactions history loading
 
OP
M
INV_FUTURE_DEMAND_MONTHS
12
3
The number of months to include in future demand calculation (12 or less).
The days_on_hand_projected field calculates how many days there will be sufficient inventory for a particular item (by source/domain/site). The calculation requires the sum of future orders for the item that were created by MRP (Manufacturing Resource Planning, automated future orders based on need/use). This parameter allows you to limit how many months ahead to look for future orders in order to calculate projected days on hand values.
OP
M
INV_HISTORICAL_PERIOD_COUNT
-24
-24
Number of periods to use to determine Average daily issued quantity historical.
 
OP
M
INV_HISTORY_DATE
<Set to today's date before starting the initial history load>
2012-08-28
The first processing date for loading inventory. Format is YYYY-MM-DD. Set Programmatically by INITIAL_JOB_SETUP
 
OP
P
INV_LAST_IN_MSTR_EXTRACT
 
40574.53221
Last Extract Timestamp of data currently in load_in_mstr
 
OP
P
INV_PROCESS_CONNECTION_NAME
 
2010SE
Indicates the connection name used by the Inventory process job
 
OP
P
INV_PROCESS_DAYS
10
10
The number of days of Inventory to extract and process from permanent Data Store tables
 
OP
M
INV_PROCESS_RUNNING
N
N
Indicates if an Inventory process is currently running (Y,N)
Used to prevent multiple copies of the Inventory 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".
OP
P
INV_PROCESS_RUNNING_JOB_NAME
 
DAILY_INV_PROCESS_CHAINED
Indicates the current or last run job name for INVENTORY processing.
 
OP
P
INV_PROJECTED_DAYS_ON_HAND_MAX
999
99999
If there is no mrp_demand to calculate projected days on hand, the number to display to represent an infinite amount of days.
 
OP
M
INV_REVALUE_PERIODS
100
10
The number of periods to revalue in inventory balances
 
OP
M
INV_TRANS_TYPES
'CST-ADJ','CST-TR','CYC-CNT','CYC-ERR','CYC-RCNT','ISS-CHL','ISS-COR','ISS-DO','ISS-FAS','ISS-GIT','ISS-POIT','ISS-PRV','ISS-RV','ISS-SCRP','ISS-SO','ISS-TR','ISS-UNP','ISS-WO','PLCG-ADJ','RCT-CHL','RCT-DO','RCT-FAS','RCT-GIT','RCT-PO','RCT-POIT','RCT-RS','RCT-SOR','RCT-TR','RCT-UNP','RCT-WO','RJCT-WO','TAG-CNT','CN-CNT'
 
Transaction types (tr_type) that are related to inventory changes
 
OP
Do Not Edit
INV_TRANS_TYPES_CONS
'CN-SHIP','CN-USE','CN-ADJ','CN-RCT','CN-ISS'
'CN-SHIP','CN-USE','CN-ADJ','CN-RCT','CN-ISS'
Transaction types (tr_type) that are related to consignment inventory movements
 
OP
Do Not Edit
INV_TRANS_TYPES_COUNT_ERR
'CYC-ERR'
'CYC-ERR'
Transaction types (tr_type) that are related to count errors
 
OP
Do Not Edit
INV_TRANS_TYPES_COUNT_TR
'CYC-CNT'
'CYC-CNT'
Transaction types (tr_type) that are related to count transactions
 
OP
Do Not Edit
INV_TRANS_TYPES_CUST
'ISS-SO','RCT-SOR','ISS-COR'
'ISS-SO','RCT-SOR','ISS-COR'
Transaction types (tr_type) that are related to customers
 
OP
Do Not Edit
INV_TRANS_TYPES_GIT
'ISS-GIT','ISS-POIT', 'RCT-GIT','RCT-POIT'
'ISS-GIT','ISS-POIT', 'RCT-GIT','RCT-POIT'
Transaction types (tr_type) that are related to goods in transit (GIT).
 
OP
Do Not Edit
INV_TRANS_TYPES_ISSUED
'ISS_SO','ISS-COR','ISS-WO','ISS-FAS','ISS-DO','ISS-RMA'
'ISS_SO','ISS-COR','ISS-WO','ISS-FAS','ISS-DO','ISS-RMA'
Transaction types (tr_type) that are related to inventory issued
 
OP
Do Not Edit
INV_TRANS_TYPES_RECEIVED
'RCT-FAS','RCT-PO','RCT-WO','RCT-DO'
'RCT-FAS','RCT-PO','RCT-WO','RCT-DO'
Transaction types (tr_type) that are related to inventory received
 
OP
Do Not Edit
INV_TRANS_TYPES_RECOUNT
'CYC-RCNT'
'CYC-RCNT'
Transaction types (tr_type) that are related to recount transactions
 
OP
Do Not Edit
INV_TRANS_TYPES_SALES
'ISS-SO','ISS-COR'
'ISS-SO','ISS-COR'
Transaction types (tr_type) that are related to sales orders
 
OP
Do Not Edit
INV_TRANS_TYPES_SUPPLIER
'ISS-PRV','RCT-PO'
'ISS-PRV','RCT-PO'
Transaction types (tr_type) that are related to suppliers
 
OP
Do Not Edit
JOB_INV_PROCESS_BATCH_ID
0
754
The batch id for the current DAILY_INV_PROCESS_JOB job.
 
OP
P
JOB_OP_PROCESS_BATCH_ID
0
755
The batch id for the current DAILY_OP_PROCESS_JOB job.
 
OP
P
JOB_PO_PROCESS_BATCH_ID
0
752
The batch id for the current DAILY_PO_PROCESS_JOB job.
 
OP
P
OP_HIST_LOAD_MAXSIZE
5000000
5000000
The maximum number of rows to load in an iteration loading op_hist
 
OP
P
OP_HIST_LOAD_RUNNING
C
C
Indicates if a load of op_hist is running (Y/N/C)
 
OP
P
OP_HIST_TRAN_MAX
 
19975
DON’T UPDATE MANUALLY. Maximum Transaction Id to extract this iteration.
 
OP
P
OP_HIST_TRAN_MAX_Sxx
 
433
DON’T UPDATE MANUALLY. Maximum Transaction Id to extract this iteration.
 
OP
P
OP_LOAD_LOOKBACK_DAYS
20
20
The number of days to look back in QAD when extracting OP data
Used to limit the amount of data extracted from wo_mstr, wod_det, and wr_route to just those open or closed between today and (today - lookback days)
OP
M
OP_MOVING_AVG_WEEKS
13
13
The Number of Weeks to base Moving Average on.
 
OP
M
OP_OEE_SNAPSHOT_FREQUENCY
B
B
The frequency of snapshots in the OP OEE snapshot tables. Possible values are: W for Weekly, M for Monthly, B for both weekly and monthly.
 
OPOP
M
OP_PROCESS_CONNECTION_NAME
 
QMI
Indicates the connection name used by the OP process job.
 
OP
P
OP_PROCESS_DAYS
5
5
The number of days of OP to extract and process from permanent staging tables.
 
OP
M
OP_PROCESS_RUNNING
N
N
Indicates if an OP process is currently running (Y,N)
 
OP
P
OP_PROCESS_RUNNING_JOB_NAME
 
DAILY_OP_PROCESS_CHAINED
Indicates the current or last run job name for module processing.
 
OP
P
PO_BOOKING_DATE
<Set to today's date before starting the initial history load>
2011-01-28
The processing date used for PO bookings processing. Format is YYYY-MM-DD
 
OP
M/P
PO_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
 
OP
M/P
PO_EARLY_TOLERANCE_DELAY
2
4
Number of days an order is early and still is considered as "on-time".
 
OP
M
PO_LATE_TOLERANCE_DELAY
2
1
Number of days a PO can be late and still considered as on time.
 
OP
M
PO_LOOKBACK_DAYS
30
60
Set to the number of days the user is able to backdate the receipt date. This is used by the load table load_prh_hist.
 
OP
M
PO_ORDER_HISTORY_DATE
<Set to today's date before starting the initial history load>
2011-01-28
The processing date used for PO orders history calculations Format is YYYY-MM-DD
 
OP
P
PO_PERCENT_QTY_OVER
10
10
Percentage of Receipt Quantity over Order Quantity for a Purchase Order to still be considered In Full
 
OP
M
PO_PERCENT_QTY_UNDER
20
20
Percentage of Receipt Quantity under Order Quantity for a Purchase Order to still be considered In Full
 
OP
M
PO_PROCESS_CONNECTION_NAME
 
2010SE
Indicates the connection name used by the PO process job.
 
OP
P
PO_PROCESS_DAYS
10
10
The number of days of PO to extract and process from permanent staging tables.
 
OP
M
PO_PROCESS_RUNNING
N
N
Indicates if a PO process is currently running (Y,N)
Used to prevent multiple copies of the Purchasing 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".
OP
P
PO_PROCESS_RUNNING_JOB_NAME
 
DAILY_PO_PROCESS_2010SE
Indicates the current or last run job name for PO processing.
 
OP
P
PO_RET_QTY_TOLERANCE
15
15
Percentage of Returns Quantity used for calculating Defect Rate.
 
OP
M
PO_SNAPSHOT_FREQUENCY
B
M
The frequency of snapshots in the PO order snapshot table. Possible values are: W for Weekly, M for Monthly, B for both weekly and monthly.
 
OP
M
PO_SNAPSHOT_HIST_START_DATE
<Set to today's date before starting the initial history load>
2011-01-28
The first date in the PO order snapshot table in the format YYYY-MM-DD for the first run
 
OP
P
PO_SNAPSHOT_NUM_DAYS
31
31
The number of days of snapshots to load back each run.
 
OP
M
PO_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.
OP
M
PO_SNAPSHOT_START_DATE
 
1997-05-24
Internal use only. The setup procedure for the PO snapshot tables updates this parameter to determine the date at which to start.
 
OP
P