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

  • 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