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

  • Data Warehouse Tables Changed
    The following section lists the Data Warehouse tables that have been changed, added, or deleted.
    Note: The tables on the Modified list may have been changed structurally. For example:
    Columns added or deleted
    Indexes added or deleted
    Changes made to business display names
    Changes to visibility of particular columns in the BI Portal
    Any combination of these modifications
    List of Tables Modified for BI 3.6.1
    Common Module
     
    load_tr_hist
    perm_transaction_hist
    stage_tr_hist_list
    permsup_transaction_hist
    Operations Module
     
    extract_inv_trans_hist_cons
    stage_inv_bal_mth_list
    stage_op_transaction_merge
    extract_inv_transaction_hist
    stage_inv_bal_mth_trans
    stage_op_transaction_merge
    extract_po_transaction_hist
    stage_inv_bal_mth_trans1
    stage_op_transaction_merge
    extract_op_transaction_hist
    stage_inv_bal_mth_trans2
    stage_op_transaction0
    fact_inv_mth_balance
    stage_inv_mth_balance
    stage_op_transaction1
    fact_inv_transaction
    stage_inv_mth_balance_hist_calc
    stage_op_transaction2
    fact_op_transaction
    stage_inv_mth_balance1
    stage_po_order_hist_initial4
    perm_op_hist
    stage_inv_transaction_con_cus3
    stage_po_order_hist_initial5
    stage_inv_bal_mth_current
    stage_inv_transaction_con_cus4
    stage_po_order_hist_initial6
    stage_inv_bal_mth_current4
    stage_op_tr_hist_rjct_wo
    work_inv_change_hist_list
    stage_inv_bal_mth_date
    stage_op_trans_scrapi
    work_inv_change_list
    stage_inv_bal_mth_date1
    stage_op_transaction
    work_inv_change_list1
    stage_inv_bal_mth_date2
     
     
    Order Management Module
     
    :
    extract_om_transaction_hist
    stage_om_booking_previous
    stage_om_order
    stage_om_booking
    stage_om_booking_transaction
    stage_om_order1
    fact_om_booking
    stage_om_booking_transaction1
    stage_om_order2
    fact_om_shipment
    stage_om_invoice_transaction
    stage_om_order3
    stage_om_booking_max_tran
    stage_om_invoice_transaction1
     
    List of Tables Added for BI 3.6.1
     
    stage_inv_mth_end_cst
    stage_inv_mth_end_cst1
    stage_inv_trx_chg_mths
    stage_inv_trx_chg_mths1
    List of Tables Deleted for BI 3.6.1
    No tables deleted for BI 3.6.1 upgrade.
    List of Tables Modified for BI 3.5.1
     
    extract_inv_trans_hist_cons
    stage_inv_bal_mth_date2
    stage_om_invoice_transaction
    extract_inv_transaction_hist
    stage_inv_bal_mth_list
    stage_om_invoice_transaction1
    extract_om_transaction_hist
    stage_inv_bal_mth_trans
    stage_om_order
    extract_po_transaction_hist
    stage_inv_bal_mth_trans1
    stage_om_order1
    fact_inv_mth_balance
    stage_inv_bal_mth_trans2
    stage_om_order2
    fact_inv_transaction
    stage_inv_bal_revalue1
    stage_om_order3
    fact_om_booking
    stage_inv_mth_balance
    stage_po_order_hist_initial4
    fact_om_shipment
    stage_inv_mth_balance_hist_calc
    stage_po_order_hist_initial5
    load_tr_hist
    stage_inv_mth_balance1
    stage_po_order_hist_initial6
    perm_transaction_hist
    stage_inv_transaction_con_cus3
    stage_tr_hist_list
    permsup_transaction_hist
    stage_inv_transaction_con_cus4
    stage_tr_hist_list
    stage_inv_bal_item_list
    stage_om_booking
    stage_unit_of_measure3
    stage_inv_bal_mth_current
    stage_om_booking_max_tran
    work_inv_change_hist_list
    stage_inv_bal_mth_current4
    stage_om_booking_previous
    work_inv_change_list
    stage_inv_bal_mth_date
    stage_om_booking_transaction
    work_inv_change_list1
    stage_inv_bal_mth_date1
    stage_om_booking_transaction1
     
    List of Tables Added for BI 3.5.1
     
    stage_inv_mth_end_cst
    stage_inv_mth_end_cst1
    stage_inv_trx_chg_mths
    stage_inv_trx_chg_mths1
    List of Tables Deleted for BI 3.5.1
    No tables deleted for BI 3.5.1 upgrade.