QAD BI Upgrade Instructions > Upgrade to QAD BI 3.8.1 from QAD BI 3.7 > Data Warehouse Tables Changed
  
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.