The AP Invoice Snapshot fact table is an example of a Periodic or Summary fact table. The primary source of data for this table is another BI table (AP Vouchers / Invoices).

The interval for the Snapshot is determined by a parameter setting used by a batch job.

Valid snapshot intervals are:

• Weekly

• Monthly

• Both (Weekly and Monthly)

To Query this table, we would generally use the Effective Date dimension.