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  |   On Demand  |   Home  |   qad.com




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
List of Tables Modified for BI 3.6.1
Common Module
 
load_tr_hist
perm_transaction_hist
stage_tr_hist_list
permsup_transaction_hist
Operations Module
 
extract_inv_trans_hist_cons
stage_inv_bal_mth_list
stage_op_transaction_merge
extract_inv_transaction_hist
stage_inv_bal_mth_trans
stage_op_transaction_merge
extract_po_transaction_hist
stage_inv_bal_mth_trans1
stage_op_transaction_merge
extract_op_transaction_hist
stage_inv_bal_mth_trans2
stage_op_transaction0
fact_inv_mth_balance
stage_inv_mth_balance
stage_op_transaction1
fact_inv_transaction
stage_inv_mth_balance_hist_calc
stage_op_transaction2
fact_op_transaction
stage_inv_mth_balance1
stage_po_order_hist_initial4
perm_op_hist
stage_inv_transaction_con_cus3
stage_po_order_hist_initial5
stage_inv_bal_mth_current
stage_inv_transaction_con_cus4
stage_po_order_hist_initial6
stage_inv_bal_mth_current4
stage_op_tr_hist_rjct_wo
work_inv_change_hist_list
stage_inv_bal_mth_date
stage_op_trans_scrapi
work_inv_change_list
stage_inv_bal_mth_date1
stage_op_transaction
work_inv_change_list1
stage_inv_bal_mth_date2
 
 
Order Management Module
 
:
extract_om_transaction_hist
stage_om_booking_previous
stage_om_order
stage_om_booking
stage_om_booking_transaction
stage_om_order1
fact_om_booking
stage_om_booking_transaction1
stage_om_order2
fact_om_shipment
stage_om_invoice_transaction
stage_om_order3
stage_om_booking_max_tran
stage_om_invoice_transaction1
 
List of Tables Added for BI 3.6.1
 
stage_inv_mth_end_cst
stage_inv_mth_end_cst1
stage_inv_trx_chg_mths
stage_inv_trx_chg_mths1
List of Tables Deleted for BI 3.6.1
No tables deleted for BI 3.6.1 upgrade.
List of Tables Modified for BI 3.5.1
 
extract_inv_trans_hist_cons
stage_inv_bal_mth_date2
stage_om_invoice_transaction
extract_inv_transaction_hist
stage_inv_bal_mth_list
stage_om_invoice_transaction1
extract_om_transaction_hist
stage_inv_bal_mth_trans
stage_om_order
extract_po_transaction_hist
stage_inv_bal_mth_trans1
stage_om_order1
fact_inv_mth_balance
stage_inv_bal_mth_trans2
stage_om_order2
fact_inv_transaction
stage_inv_bal_revalue1
stage_om_order3
fact_om_booking
stage_inv_mth_balance
stage_po_order_hist_initial4
fact_om_shipment
stage_inv_mth_balance_hist_calc
stage_po_order_hist_initial5
load_tr_hist
stage_inv_mth_balance1
stage_po_order_hist_initial6
perm_transaction_hist
stage_inv_transaction_con_cus3
stage_tr_hist_list
permsup_transaction_hist
stage_inv_transaction_con_cus4
stage_tr_hist_list
stage_inv_bal_item_list
stage_om_booking
stage_unit_of_measure3
stage_inv_bal_mth_current
stage_om_booking_max_tran
work_inv_change_hist_list
stage_inv_bal_mth_current4
stage_om_booking_previous
work_inv_change_list
stage_inv_bal_mth_date
stage_om_booking_transaction
work_inv_change_list1
stage_inv_bal_mth_date1
stage_om_booking_transaction1
 
List of Tables Added for BI 3.5.1
 
stage_inv_mth_end_cst
stage_inv_mth_end_cst1
stage_inv_trx_chg_mths
stage_inv_trx_chg_mths1
List of Tables Deleted for BI 3.5.1
No tables deleted for BI 3.5.1 upgrade.