Data Warehouse Tables Changed
The following sections list the Data Warehouse tables that have been changed, added, or deleted. Note that those 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.
List of Tables Modified
|
•
|
fact_ap_invoice_snapshot
|
|
•
|
fact_ap_voucher_history
|
|
•
|
fact_ar_invoice_history
|
|
•
|
fact_ar_invoice_snapshot
|
|
•
|
fact_ee_ap_invoice_snapshot
|
|
•
|
fact_om_order_performance
|
|
•
|
fact_po_order_performance
|
|
•
|
stage_ap_check_voucher_sum
|
|
•
|
stage_ap_voucher_hist_final
|
|
•
|
stage_ap_voucher_history
|
|
•
|
stage_om_invoice_order_line
|
|
•
|
stage_om_order_hist_end_date1
|
|
•
|
stage_om_order_hist_end_date2
|
|
•
|
stage_om_order_inv_line
|
|
•
|
stage_om_order_inv_line1
|
|
•
|
stage_om_order_inv_line2
|
|
•
|
stage_om_order_line_all
|
|
•
|
stage_om_order_transaction
|
|
•
|
stage_om_order_transaction1
|
|
•
|
stage_om_order_transaction4
|
|
•
|
stage_om_order_transaction5
|
|
•
|
stage_po_ord_perf_curr1
|
|
•
|
stage_po_ord_perf_date1
|
|
•
|
stage_po_order_hist_initial1
|
|
•
|
stage_po_order_hist_initial3
|
|
•
|
stage_po_order_hist_initial6
|
|
•
|
stage_po_receipts_perf1
|
|
•
|
stage_po_receipts_perf2
|
|
•
|
stage_po_receipts_perf_rank
|
|
•
|
stage_po_receipts_perf_top
|
|
•
|
work_om_change_hist_list
|
|
•
|
work_po_change_hist_list
|
List of Tables Added
|
•
|
dim_order_line_order_type
|
|
•
|
load_order_line_order_type
|
|
•
|
stage_order_line_order_type
|
|
•
|
stage_po_receipt_ontime_tolerance
|
|
•
|
stage_po_receipt_vep_perf
|
List of Tables Deleted
|
•
|
stage_po_booking_orig_order
|
|
•
|
stage_po_booking_previous
|
|
•
|
stage_po_booking_transaction
|
|
•
|
stage_po_booking_transaction1
|
|
•
|
stage_po_booking_transaction2
|
