QAD BI Upgrade Instructions > Upgrade to QAD BI 3.7 from QAD BI 3.6.x > 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 in Existing Modules
Common Module Modified Tables
 
dim_account
dim_shipment_date
stage_credit_term
dim_account_currency
dim_site
stage_currency
dim_approver
dim_sub_account
stage_customer
dim_base_currency
dim_supplier
stage_customer_ar_list
dim_buyer
dim_transaction_currency
stage_customer_bill
dim_channel
dim_transaction_type
stage_customer_bill1
dim_corporate_currency
dim_unit_of_measure
stage_customer_dim_bill
dim_cost_center
load_ct_mstr
stage_customer_dim_ship
dim_credit_term
load_ctd_det
stage_customer_dim_sold
dim_currency
load_cu_mstr
stage_customer_invoice_list
dim_customer
load_ee_Address
stage_customer_master
dim_customer_bill_to
load_ee_BudgetGroup
stage_customer_sales_list
dim_customer_ship_to
load_ee_Company
stage_customer_ship
dim_customer_sold_to
load_ee_CostCentre
stage_customer_ship1
dim_discount_cost_center
load_ee_Creditor
stage_customer_sold
dim_discount_sub_account
load_ee_Currency
stage_customer_sold1
dim_due_date
load_ee_Debtor
stage_date_qad
dim_effective_date
load_ee_Division
stage_domain
dim_entered_date
load_ee_DomainProperty
stage_eam_entity
dim_entity
load_ee_Domains
stage_ee_account
dim_item
load_ee_DomainSharedSet
stage_ee_address
dim_last_receipt_date
load_ee_PaymentCondition
stage_ee_ic_creditor
dim_location
load_ee_PaymentGroup
stage_ee_ic_debtor
dim_order_date
load_ee_Project
stage_ee_project_status
dim_payment_due_date
load_ee_SharedSet
stage_entity
dim_performance_date
load_en_mstr
stage_project
dim_project
load_pj_mstr
stage_site
dim_receipt_date
load_tr_hist
stage_sub_account
dim_requestor
perm_transaction_hist
stage_supplier
dim_required_date
permsup_transaction_hist
stage_tr_hist_list
dim_service_type
stage_business_relation
stage_unit_of_measure1
dim_ship_to_address
stage_cost_center
 
Financials Module Modified Tables
 
dim_ap_transaction_type
fact_gl_transaction
stage_ee_credit_invoice_move
dim_ar_transaction_type
load_ap_transaction_type
stage_ee_posting
dim_daybook
load_ar_transaction_type
stage_gl_balance_close03
dim_layer
load_ee_CompanySharedSet
stage_gl_balance_close04
extract_ap_master
load_ee_Journal
stage_gl_balance_ptd
extract_ap_voucher_master
load_ee_Layer
stage_gl_balance_qtd
fact_ap_invoice_snapshot
load_ee_Period
stage_gl_balance_ytd
fact_ap_voucher
load_vo_mstr
stage_gl_balance2
fact_ap_voucher_history
perm_ap_master
stage_gl_transaction_budget
fact_ar_invoice
perm_ee_posting
stage_gl_transaction1
fact_ar_invoice_history
perm_ee_posting_line
stage_layer
fact_ar_invoice_snapshot
stage_ap_transaction_type
stage_se_ap_snap4
fact_ar_payment
stage_ar_transaction_type
work_ap_change_list1
fact_gl_balance
stage_ee_credit_invoice
 
Operations Module Modified Tables
 
dim_po_line_status
stage_inv_bal_mth_trans1
stage_op_transaction2
dim_po_line_type
stage_inv_bal_mth_trans2
stage_po_order_hist
extract_inv_trans_hist_cons
stage_inv_bal_revalue2
stage_po_order_hist_initial
extract_inv_transaction_hist
stage_inv_mth_balance
stage_po_order_hist_initial1
extract_op_transaction_hist
stage_inv_mth_balance_hist_calc
stage_po_order_hist_initial3
extract_po_transaction_hist
stage_inv_mth_balance1
stage_po_order_hist_initial4
fact_inv_mth_balance
stage_inv_mth_end_cst
stage_po_order_hist_initial5
fact_inv_transaction
stage_inv_mth_end_cst1
stage_po_order_hist_initial6
fact_op_transaction
stage_inv_transaction_con_cus3
stage_po_order_hist_initial7
fact_po_order_history
stage_inv_transaction_con_cus4
stage_po_order_hist1
load_prh_hist
stage_inv_transaction1
stage_po_order_hist2
load_wr_route
stage_inv_trx_chg_mths
stage_po_order_hist3
perm_op_hist
stage_inv_trx_chg_mths1
stage_po_order_hist4
stage_inv_bal_item_list
stage_op_tr_hist_rjct_wo
stage_po_order_hist5
stage_inv_bal_mth_current
stage_op_tr_hist_rjct_wo1
stage_po_order_snap1
stage_inv_bal_mth_current4
stage_op_trans_scrapi
stage_po_order_snap3
stage_inv_bal_mth_date
stage_op_transaction
stage_po_order_snapshot
stage_inv_bal_mth_date1
stage_op_transaction_merge
work_inv_change_hist_list
stage_inv_bal_mth_date2
stage_op_transaction0
work_inv_change_list
stage_inv_bal_mth_list
stage_op_transaction1
work_inv_change_list1
stage_inv_bal_mth_trans
 
 
Order Management Module Modified Tables
 
extract_om_transaction_hist
stage_om_booking1
stage_om_order_line
fact_om_booking
stage_om_invoice_line_list
stage_om_order_line_all
fact_om_shipment
stage_om_invoice_line_ranged
stage_om_order_snap
load_idh_hist
stage_om_invoice_transaction
stage_om_order_snap1
load_ih_hist
stage_om_invoice_transaction1
stage_om_order_snap3
stage_om_ar_master_extract
stage_om_invoice1
stage_om_order1
stage_om_booking
stage_om_order
stage_om_order2
stage_om_booking_previous
stage_om_order_inv_line
stage_om_order3
stage_om_booking_transaction
stage_om_order_inv_line1
stage_om_shipment1
stage_om_booking_transaction1
 
 
Tables Added to Existing Modules
Common Module Added Tables
 
dim_cal_int_end_date
stage_ee_address
dim_cal_int_start_date
stage_ee_budget_group
dim_calendar_interval
stage_ee_contact
dim_statutory_currency
stage_ee_cost_center
load_ee_Address
stage_ee_credit_term
load_ee_AddressType
stage_ee_currency
load_ee_CompanyProperty
stage_ee_customer
load_ee_Contact
stage_ee_customer_credit_rating
load_ee_CorporateGroup
stage_ee_customer_type
load_ee_Country
stage_ee_entity
load_ee_County
stage_ee_invoice_status
load_ee_CreditorType
stage_ee_payment_group
load_ee_DebtorCreditRating
stage_ee_project
load_ee_DebtorType
stage_ee_project_group
load_ee_Lng
stage_ee_project_status
load_ee_PaymentConditionStaged
stage_ee_purchase_type
load_ee_ProjectGroup
stage_ee_sub_account
load_ee_ProjectStatus
stage_ee_supplier
load_ee_PurchaseType
stage_ee_supplier_type
load_ee_Reason
stage_entity1
load_ee_State
stage_se_cost_center
load_ee_Usr
stage_se_credit_term
stage_business_relation
stage_se_currency
stage_calendar_interval
stage_se_customer
stage_calendar_interval_financial
stage_se_ee_cost_center
stage_calendar_interval_month
stage_se_ee_entity
stage_calendar_interval_week
stage_se_ee_sub_account
stage_date_qad5
stage_se_entity
stage_eam_date_qad4
stage_se_project
stage_eam_domain
stage_se_sub_account
stage_eam_entity
stage_se_supplier
stage_eam_site
stage_site1
Financials Module Added Tables
 
dim_accounting_period
load_ee_JournalGroup
stage_ee_accounting_period
dim_ee_invoice_status
stage_accounting_period
 
Operations Module Added Tables
 
stage_inv_mth_end_cst
stage_inv_trx_chg_mths
stage_inv_trx_chg_mths1
stage_inv_mth_end_cst1
 
 
Tables Deleted
No tables were deleted for the BI 3.7 release.