Accounts Receivable

The Accounts Receivable fact includes measures based on Open Items (Sales Invoices & Receipts) (tfacr200).

Transformation of extracted data:

Deleted lines

Deleted Accounts Receivables are stored in the Accounts Receivable fact table. Finalized records that have been archived remain available for analysis. Created records that have been deleted and were not finalized are hidden in the fact table and are not available for analysis.

Segment Type

The Accounts Receivable fact table contains all records to be used for segment header and segment line reporting. Therefore, you must filter on either the Segment Dashboard Filter, Segment Header Filter, or Segment Line Filter attributes of the Segment Type dimension. Otherwise, segment header and segment line measures are summarized.

This diagram shows the star schema: