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  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • 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