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
    The procedure that populates the table has changed
    List of Tables Modified
    Common Module Modified Tables
     
    dim_business_relation
    load_tr_hist_history
    stage_daybook
    dim_credit_term
    load_tr_hist_list
    stage_eam_date_qad3
    dim_customer
    load_transaction_type
    stage_item
    dim_date_qad
    perm_code_master
    stage_item_costs
    dim_daybook
    perm_item_master
    stage_item_list
    dim_ee_invoice_status
    perm_shop_cal
    stage_item_master
    dim_ee_saf
    perm_transaction_hist
    stage_item_site
    dim_item
    stage_ar_master
    stage_layer
    dim_layer
    stage_business_relation
    stage_project
    load_ar_mstr
    stage_calendar_interval_week
    stage_se_ar_master
    load_in_mstr
    stage_code_master
    stage_se_cost_center
    load_ld_det
    stage_credit_term
    stage_se_customer
    load_pt_mstr
    stage_customer
    stage_supplier
    load_tr_hist
    stage_date_qad
    stage_transaction_hist
     
    Financials Module Modified Tables
     
    dim_ap_transaction_type
    ods_gen_led_rep_line_calcs
    stage_gen_led_report_line5
    dim_ar_transaction_type
    ods_gen_led_rep_line_range
    stage_gen_led_report_line6
    extract_gl_balance
    stage_gen_led_rep_code_comb
    stage_se_ap_snap1
    load_acd_det
    stage_gen_led_rep_line_ran
    stage_se_ar_snap1
    load_bgd_det
    stage_gen_led_rep_line_ran1
    work_ap_change_list
    load_gen_led_report
    stage_gen_led_rep_line_ran2
    work_ap_change_list1
    load_gen_led_report_line
    stage_gen_led_rep_line_range
    work_ap_change_list2
    load_gen_led_report_line_calcs
    stage_gen_led_report_line
    work_ap_change_list3
    load_gen_led_report_line_range
    stage_gen_led_report_line1
    work_ap_change_list4
    load_gltr_hist_history
    stage_gen_led_report_line2
    work_ap_change_list5
    ods_gen_led_rep
    stage_gen_led_report_line3
    work_gl_trans_change_list
    ods_gen_led_rep_line
    stage_gen_led_report_line4
     
    Operations Module Modified Tables
     
    dim_buyer
    perm_mrp_detail
    stage_mrp_calculations1
    fact_inv_mth_balance
    permsup_mrp_detail
    stage_mrp_calculations2
    fact_inv_transaction
    stage_inv_bal_mth_date
    stage_po_order_hist
    fact_op_item_efficiency
    stage_inv_mth_balance_hist_calc
    stage_po_order_hist1
    fact_po_order
    stage_inv_trx_chg_mths
    stage_po_order_hist5
    fact_po_order_history
    stage_mrp_calculations
    stage_po_receipt3
    Order Management Module Modified Tables
     
    extract_om_transaction_hist
    stage_om_invoice3
    stage_om_order_inv_line2
    fact_om_booking
    stage_om_ord_perf
    stage_om_order_line_all
    fact_om_invoice
    stage_om_ord_perf_curr
    stage_om_order_snap
    fact_om_order
    stage_om_ord_perf_curr1
    stage_om_order_snap1
    fact_om_order_history
    stage_om_ord_perf_date
    stage_om_order_snap2
    fact_om_order_performance
    stage_om_ord_perf_date1
    stage_om_order_snap3
    fact_om_shipment
    stage_om_ord_perf_full
    stage_om_order_transaction
    perm_om_invoice_line
    stage_om_ord_perf_ship
    stage_om_order_transaction1
    stage_om_booking_orig_order
    stage_om_ord_perf1
    stage_om_order_transaction2
    stage_om_booking_transaction
    stage_om_order
    stage_om_order_transaction3
    stage_om_booking_transaction1
    stage_om_order_header
    stage_om_order_transaction4
    stage_om_booking_transaction2
    stage_om_order_header_all
    stage_om_order_transaction5
    stage_om_booking1
    stage_om_order_hist_end_date
    stage_om_order1
    stage_om_invoice
    stage_om_order_hist_revalue
    stage_om_order3
    stage_om_invoice_line_list
    stage_om_order_hist_revalue2
    stage_om_shipment
    stage_om_invoice_line_ranged
    stage_om_order_hist_revalue3
    stage_om_shipment_transaction
    stage_om_invoice_order_line
    stage_om_order_hist_revalue4
    stage_om_shipment1
    stage_om_invoice_order_list
    stage_om_order_inv_header
    stage_om_shipment2
    stage_om_invoice_transaction
    stage_om_order_inv_line
    stage_om_shipment3
    stage_om_invoice_transaction1
    stage_om_order_inv_line1
    work_om_change_list1
    stage_om_invoice2
     
     
    Tables Added to Existing Modules
    Common Module Added Tables
     
    load_com_mstr
    load_ee_pti_det
    stage_pti_det
    load_comd_det
     
     
    For the 3.8.1 released, all EE financial related tables and jobs have been deleted and replaced.
    Order Management Module Added Tables
     
    load_tr_hist_remarks
    stage_om_order_transaction6
    Financials Module Added Tables
    For the 3.8.1 released, all EE financial related tables and jobs have been deleted and replaced.
    Operations Module Added Tables
     
    dim_po_buyer
    stage_po_buyer_code_master
    stage_po_buyer_po_header
    stage_po_buyer
     
     
    List of Tables Deleted
    For the 3.8.1 released, all EE financial related tables and jobs have been deleted and replaced.