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
|
|
|
|
|
|
•
|
permsup_transaction_hist
|
|
Operations Module
|
•
|
extract_inv_trans_hist_cons
|
|
|
|
•
|
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_inv_mth_balance_hist_calc
|
|
|
|
|
|
|
•
|
stage_po_order_hist_initial4
|
|
|
|
|
•
|
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_date1
|
|
|
|
|
•
|
stage_inv_bal_mth_date2
|
|
|
|
Order Management Module
:
|
•
|
extract_om_transaction_hist
|
|
|
•
|
stage_om_booking_previous
|
|
|
|
|
|
•
|
stage_om_booking_transaction
|
|
|
|
|
|
•
|
stage_om_booking_transaction1
|
|
|
|
|
|
•
|
stage_om_invoice_transaction
|
|
|
|
•
|
stage_om_booking_max_tran
|
|
|
•
|
stage_om_invoice_transaction1
|
|
|
List of Tables Added for BI 3.6.1
|
|
|
|
|
|
•
|
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_om_invoice_transaction1
|
|
|
•
|
extract_om_transaction_hist
|
|
|
•
|
stage_inv_bal_mth_trans
|
|
|
|
•
|
extract_po_transaction_hist
|
|
|
•
|
stage_inv_bal_mth_trans1
|
|
|
|
|
|
•
|
stage_inv_bal_mth_trans2
|
|
|
|
|
|
|
|
|
|
|
•
|
stage_po_order_hist_initial4
|
|
|
|
|
•
|
stage_inv_mth_balance_hist_calc
|
|
|
•
|
stage_po_order_hist_initial5
|
|
|
|
|
|
•
|
stage_po_order_hist_initial6
|
|
|
|
|
•
|
stage_inv_transaction_con_cus3
|
|
|
|
•
|
permsup_transaction_hist
|
|
|
•
|
stage_inv_transaction_con_cus4
|
|
|
|
•
|
stage_inv_bal_item_list
|
|
|
|
|
•
|
stage_inv_bal_mth_current
|
|
|
•
|
stage_om_booking_max_tran
|
|
|
•
|
work_inv_change_hist_list
|
|
|
•
|
stage_inv_bal_mth_current4
|
|
|
•
|
stage_om_booking_previous
|
|
|
|
|
|
•
|
stage_om_booking_transaction
|
|
|
|
•
|
stage_inv_bal_mth_date1
|
|
|
•
|
stage_om_booking_transaction1
|
|
|
List of Tables Added for BI 3.5.1
|
|
|
|
|
|
•
|
stage_inv_trx_chg_mths1
|
|
List of Tables Deleted for BI 3.5.1
No tables deleted for BI 3.5.1 upgrade.
