Return Bill Line Item Fact Table

The return bill line item fact table captures the returned transaction events at the line item level. It captures data such as return date and time, bill amount, unique identifier for bill and line item, item code, quantity, discount, and rate. This table is linked to multiple dimension tables, including date, time, users, zone till, item, outlier status, return type, and membership type, allowing for detailed analysis and reporting of return transactions.

Databricks Table Name: return_bill_lineitem

Return Bill Line item - Entity Relationship Diagram (ERD)

Zoom in the table for more clarity. Click the table title to view its details.