QAD BI Upgrade Instructions > Upgrade to QAD BI 3.6 from QAD BI 3.5 > Data Warehouse Tables Changed
  
Data Warehouse Tables Changed
The following sections list the Data Warehouse tables that have been changed, added, or deleted. The tables in the Modified list may have been changed structurally (for example, columns added or deleted), or they may have had indexes added or deleted, or they may have had changes made to business display names or visibility of particular columns in the BI Portal, or any combination of these modifications.
Tables Modified
Common Module Modified Tables
 
dim_account
load_cu_mstr
load_shop_cal
dim_credit_term
load_dom_mstr
load_si_mstr
dim_customer
load_ee_BusinessRelation
load_sp_mstr
dim_customer_bill_to
load_ee_Creditor
load_SYSCOLUMNS
dim_customer_ship_to
load_ee_Currency
load_tr_hist
dim_customer_sold_to
load_ee_Debtor
load_tr_hist_history
dim_date_qad
load_ee_Domains
load_tr_hist_list
dim_effective_date
load_ee_GL
load_transaction_type
dim_item
load_ee_SharedSet
load_um_mstr
dim_sales_person
load_en_mstr
load_usr_mstr
dim_sales_person1
load_exr_rate
load_vd_mstr
dim_sales_person2
load_glc_cal
perm_item_master
dim_sales_person3
load_hd_mstr
perm_shop_cal
dim_sales_person4
load_icc_ctrl
perm_transaction_hist
load_ac_mstr
load_in_mstr
stage_account
load_ad_mstr
load_loc_mstr
stage_customer
load_ar_mstr
load_pj_mstr
stage_customer_master
load_budget_actual
load_pl_mstr
stage_ee_account
load_cc_mstr
load_pt_mstr
stage_ee_ic_debtor
load_cm_mstr
load_ptp_det
stage_item
load_code_mstr
load_rnd_mstr
stage_item_costs
load_consignment_type
load_sb_mstr
stage_sales_person
load_ct_mstr
load_sct_det
stage_shop_cal
load_ctd_det
load_service_type
stage_transaction_hist
Financials Module Modified Tables
 
extract_gl_transaction_hist
load_ee_ad_mstr
load_ee_Project
fact_ap_invoice_snapshot
load_ee_CInvoice
load_ee_SysProperty
fact_ap_voucher_history
load_ee_CInvoiceMovement
load_gen_led_report
fact_ar_invoice_history
load_ee_Company
load_gen_led_report_line
fact_ar_invoice_snapshot
load_ee_CompanySharedSet
load_gen_led_report_line_calcs
fact_ee_ap_invoice_snapshot
load_ee_CostCenter
load_gen_led_report_line_range
fact_ee_ar_invoice_snapshot
load_ee_DInvoice
load_gl_transaction_type
fact_gl_transaction
load_ee_DInvoiceMovement
load_gltr_hist
load_acd_det
load_ee_Division
load_gltr_hist_history
load_ap_mstr
load_ee_DomainProperty
load_gltr_hist_list
load_ap_transaction_type
load_ee_Journal
load_vo_mstr
load_ar_transaction_type
load_ee_Layer
stage_ee_gl_balance7
load_ard_det
load_ee_Period
stage_ee_gl_balance8
load_bg_mstr
load_ee_Posting
stage_gl_balance1
load_bdg_det
load_ee_PostingHist
stage_gl_balance2
load_ck_mstr
load_ee_PostingLine
stage_gl_transaction1
load_ckd_det
 
 
Operations Module Modified Tables
 
dim_po_line_status
load_inv_trans_type_sales
stage_inv_transaction_con_cus3
dim_po_line_type
load_inv_trans_type_supplier
stage_inv_transaction_con_cus4
dim_shipment_type
load_inv_transaction_type
stage_inv_transaction_con_cus5
extract_inv_trans_hist_cons
load_is_mstr
stage_inv_transaction_con_sup
extract_inv_transaction_hist
load_ld_det
stage_inv_transaction_con_sup1
fact_inv_transaction
load_mrp_det
stage_inv_transaction_con_sup2
fact_po_order
load_po_line_status
stage_inv_transaction_non_cons
fact_po_order_history
load_po_line_type
stage_inv_transaction1
fact_po_order_performance
load_po_mstr
stage_inv_transaction2
fact_po_order_receipt
load_pod_det
stage_inv_transaction3
load_inv_trans_type_cnterr
load_prh_hist
stage_inv_transaction4
load_inv_trans_type_cnttr
load_vep_mstr
stage_po_order_hist
load_inv_trans_type_cons
load_vepd_det
stage_po_order_snap1
load_inv_trans_type_cust
stage_inv_bal_revalue1
stage_po_order_snap3
load_inv_trans_type_git
stage_inv_transaction
stage_po_order_snapshot
load_inv_trans_type_issued
stage_inv_transaction_con_cus
stage_po_receipt_perf
load_inv_trans_type_received
stage_inv_transaction_con_cus1
work_po_perf_list
load_inv_trans_type_recount
stage_inv_transaction_con_cus2
 
Order Management Module Modified Tables
 
extract_om_invoice_line
perm_om_invoice_line
stage_om_order_inv_line
fact_om_order_history
stage_om_invoice_line
stage_om_order_inv_line1
fact_om_order_performance
stage_om_invoice_order_line
stage_om_order_inv_line2
fact_om_order_shipment
stage_om_invoice1
stage_om_order_line
load_cncu_mstr
stage_om_ord_perf
stage_om_order_line_all
load_idh_hist
stage_om_ord_perf_date1
stage_om_order1
load_ih_hist
stage_om_ord_perf_full
stage_om_order3
load_order_line_order_type
stage_om_ord_perf_ship
stage_om_shipment
load_so_mstr
stage_om_ord_perf1
stage_om_shipment_transaction
load_sod_det
 
 
Tables Added
Common Module Added Tables
 
dim_snapshot_period_type
load_ee_PaymentCondition
load_snapshot_period_type
load_ee_BudgetGroup
load_ee_PaymentGroup
stage_ee_account
load_ee_CashGroup
load_ee_Unit
stage_se_account
load_ee_DomainSharedSet
 
 
Financials Module Added Tables
work_gl_trans_change_list
Operations Module Added Tables
 
dim_calendar_period
load_wr_route_hist
stage_op_transaction
dim_department
perm_op_hist
stage_op_transaction_merge
dim_op_oee_periods
perm_work_center_master
stage_op_transaction0
dim_production_line
perm_work_order_detail
stage_op_transaction1
dim_release_date
perm_work_order_master
stage_op_transaction2
dim_start_date
perm_work_order_routing
stage_op_work_center_period_hrs1
dim_work_center
stage_calendar_period
stage_op_work_order_detail_scrap
dim_work_center_machine
stage_exception_period_hrs
stage_op_work_order_detail_scrap2
extract_op_oee_dates
stage_op_equip_effect
stage_op_work_order_lot
extract_op_transaction_hist
stage_op_equipment_effectiveness
stage_op_work_order_lot_scrap
fact_op_equipment_effectiveness
stage_op_hist
stage_prod_line_hrs
fact_op_item_efficiency
stage_op_item_efficiency
stage_prod_line_period_hrs
fact_op_transaction
stage_op_item_efficiency1
stage_prod_line_period_hrs_ma
fact_wo_order
stage_op_item_efficiency2
stage_wo_mstr
fact_wo_routing_transaction
stage_op_item_moving_avg
stage_wo_order
load_cal_det
stage_op_oee_periods
stage_wo_order0
load_dpt_mstr
stage_op_oee_periods_month
stage_wo_routing_transaction
load_ln_mstr
stage_op_oee_periods_week
stage_wo_routing_transaction0
load_op_hist
stage_op_prod_line_period_hrs1
stage_wod_det
load_shft_det
stage_op_prod_line_period_hrs2
stage_work_center_period_hrs
load_wc_mstr
stage_op_prod_line_wc_period
stage_work_center_period_hrs_ma
load_wo_mstr
stage_op_resource_avail_hrs
stage_work_center_site
load_wo_mstr_hist
stage_op_resource_avail_keys
stage_work_center_site_hrs
load_wod_det
stage_op_tr_hist_rjct_wo
stage_wr_route
load_wod_det_hist
stage_op_tr_hist_rjct_wo1
work_op_wo_routing_costs
load_wr_route
stage_op_trans_scrapi
work_op_wo_routing_costs_cum
Order Management Module Added Tables
dim_om_service_type
Tables Deleted
No tables were deleted for Release BI 3.6.