QAD BI Upgrade Instructions > Upgrade to QAD BI 3.9 from QAD BI 3.8.1/3.8.2 > 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_credit_term
load_comd_det
load_tr_hist
dim_ee_saf
load_ee_DInvoice
load_tr_hist_history
dim_item
load_ee_Saf
load_vd_mstr
load_ad_mstr
load_ee_SafConcept
perm_transaction_hist
load_ar_mstr
load_exr_rate
stage_ee_saf
load_cm_mstr
load_icc_ctrl
stage_gl_calendar_year
load_com_mstr
load_pt_mstr
stage_transaction_hist
Financials Module Modified Tables
 
extract_ee_customer_invoice
stage_ee_ap_supplier_invoice_history2
extract_ee_customer_invoice_stage
stage_ee_ap_supplier_invoice_history3
extract_ee_posting_line
stage_ee_ap_supplier_invoice_history4
extract_ee_posting_saf
stage_ee_ap_supplier_invoice_movement_hist
extract_ee_supplier_invoice
stage_ee_ap_supplier_invoice1
extract_ee_supplier_invoice_stage
stage_ee_ap_supplier_invoice2
extract_gl_trans_hist
stage_ee_ar_customer_invoice_hist
fact_gl_transaction
stage_ee_ar_customer_invoice_hist1
load_ap_mstr
stage_ee_ar_customer_invoice_history
load_ard_det
stage_ee_ar_customer_invoice_history0
load_ck_mstr
stage_ee_ar_customer_invoice_history1
load_ckd_det
stage_ee_ar_customer_invoice_history2
load_ee_ad_mstr
stage_ee_ar_customer_invoice_history3
load_ee_CInvoice
stage_ee_ar_customer_invoice_movement_hist
load_ee_CInvoiceMovement
stage_ee_ar_customer_invoice_stage_hist
load_ee_Posting
stage_ee_ar_customer_invoice1
load_ee_Posting_all
stage_ee_customer_invoice_perm
load_ee_PostingLine_all
stage_ee_customer_invoice_stage_perm
load_ee_PostingSaf
stage_ee_gl_transaction1
load_gl_transaction_type
stage_ee_posting_line_perm
load_vo_mstr
stage_ee_posting_saf
perm_ee_customer_invoice
stage_ee_supplier_invoice_perm
perm_ee_customer_invoice_stage
stage_ee_supplier_invoice_stage_perm
perm_ee_posting_line
stage_gl_balance1
perm_ee_supplier_invoice
stage_gl_transaction1
perm_ee_supplier_invoice_stage
stage_gl_transaction2
stage_ap_invoice_snaps
stage_gl_transaction3
stage_ap_voucher_chk_match
stage_se_ap_inv_snap
stage_ar_invoice_snap
stage_se_ap_snap1
stage_ee_ap_supplier_invoice
stage_se_ap_snap2
stage_ee_ap_supplier_invoice_hist
stage_se_ar_inv_snap
stage_ee_ap_supplier_invoice_hist1
stage_se_ar_snap1
stage_ee_ap_supplier_invoice_history0
stage_se_ar_snap2
stage_ee_ap_supplier_invoice_history1
stage_se_ar_snap3
Operations Module Modified Tables
 
fact_po_order
stage_inv_transaction1
stage_po_order_hist_initial3
fact_inv_transaction
stage_inv_trx_chg_mth1
stage_po_order_hist_initial6
fact_po_order_history
stage_po_credit_term
stage_po_order_hist_initial7
fact_po_order_performance
stage_po_credit_term1
stage_po_order_hist1
load_pod_det
stage_po_ord_perf
stage_po_order_hist2
load_shft_det
stage_po_order_hist
stage_po_order_hist3
load_wod_det
stage_po_order_hist_initial
stage_po_order_hist4
load_wod_det_hist
stage_po_order_hist_initial1
stage_po_order_hist5
stage_inv_mth_balance
 
 
Order Management Module Modified Tables
 
extract_om_invoice_line
stage_om_booking1
stage_om_order_inv_line
extract_om_transaction_hist
stage_om_booking2
stage_om_order_inv_line1
fact_om_booking
stage_om_booking3
stage_om_order_inv_line2
fact_om_invoice
stage_om_booking4
stage_om_order_line
fact_om_order
stage_om_invoice
stage_om_order_line_all
fact_om_order_history
stage_om_invoice_line
stage_om_order_snap1
fact_om_order_performance
stage_om_invoice_order_line
stage_om_order_snap2
fact_om_shipment
stage_om_invoice_transaction
stage_om_order_snap3
load_cncu_mstr
stage_om_invoice1
stage_om_order_transaction
load_idh_hist
stage_om_invoice2
stage_om_order_transaction4
load_idh_hist
stage_om_invoice3
stage_om_order1
load_ih_hist
stage_om_ord_perf
stage_om_order2
load_sod_det
stage_om_ord_perf_full
stage_om_order3
perm_om_invoice_line
stage_om_ord_perf1
stage_om_shipment
stage_om_booking
stage_om_order
stage_om_shipment_transaction
stage_om_booking_previous
stage_om_order_header
stage_om_shipment1
stage_om_booking_transaction
stage_om_order_header_all
stage_om_shipment2
stage_om_booking_transaction1
stage_om_order_inv_header
stage_om_shipment3
stage_om_booking_transaction2
 
 
EAM Module Modified Tables
 
fact_eam_inv_transaction
load_eam_part_type
stage_eam_inv_trans_perm
load_eam_account
load_eam_squawks
stage_eam_inv_transaction
load_eam_domain
perm_eam_inv_transaction
 
Tables Added to Existing Modules
For the BI 3.9 release, there were no tables added to the Common and Financial Modules.
Order Management Module Added Tables
 
load_abs_mstr
load_tr_hist_ship_id
stage_om_schedule_detail2
load_absr_det
perm_customer_consigment
stage_om_scheduled_order_perf
load_idh_hist_cust_ref
stage_om_booking_transaction_all
stage_om_scheduled_order_perf1
load_idh_hist_pr_list
stage_om_invoice_scheduled_transaction
stage_om_scheduled_order_transaction
load_idh_hist_rlse_id
stage_om_ord_perf_all
stage_om_scheduled_order_transaction1
load_pc_mstr
stage_om_order_transaction7
stage_om_shipment_requirement
load_sch_mstr
stage_om_price_list
stage_om_shipment_requirement1
load_schd_det
stage_om_schedule_detail
stage_om_shipment_requirement2
load_tr_hist_ref
stage_om_schedule_detail1
 
Operations Module Added Tables
 
dim_liability_date
stage_po_order_hist_daily2
stage_po_order_hist_daily5
stage_po_order_hist_daily
stage_po_order_hist_daily3
stage_po_order_hist_daily6
stage_po_order_hist_daily1
stage_po_order_hist_daily4
stage_po_order_hist_daily7
List of Tables Deleted
For the BI 3.9 release, there were no tables deleted.