Description
This bridge table allows the connection of date types to transactions and dates
Columns
| Column Name | Description |
|---|---|
record_key |
Unique identifier for the transaction record or distributed flat rate record |
business_id |
Unique identifier for the business |
date |
Used as the key to the dim_date table coresponding to when the record took place |
date_type |
Date types used for various financial summarizations; enumerated: 'Cash Basis Date' (defined as when the charge was due or payment was received and can be used for cash basis or accounts receivable [Date Assignment: If the transaction is a 'Payment Not Applied' then -1 is assigned, payment scheduled process date is used for 'Payment Applied' payments if it exists for the record (use created at date if it does not), finally, payment due date is used for all other transactions]), 'Revenue Recognized Date' (defined when the service was rendered and can be used for accrual basis or revenue recognition; note that for flat rates the records are distributed across service dates and not the original transaction amount [Date Assignment: If the record is a correction then use the greater of (a) applied date or (b) created date, next, use the date when the session occurred (flat rates are distributed) if it exists for the record, finally, use applied date]), 'Billing History Date' (defined as matching Business App's UI [Date Assignment: transactions are recognized on the date customers are billed, payment scheduled process date is used for 'Payment Applied', or the billed date if there is no scheduled processing]) |