Fully Paid Date Dimension

Modified on Mon, 27 Jul at 9:23 PM

Calendar Summary

The Fully Paid Date Dimension organizes transactions by the last date on which an applied transaction reduces the original transaction balance to 0.00. The applied transaction may be a payment, credit, or another eligible reduction.

Calendar Type

QQube settlement date

Date Represents

Date the original balance reaches zero

QQube Source

Applied transaction activity

Primary Use

Commission and bill-payment analysis

Included Data Models

Customers: Sales

Operations: Purchases, Inventory, Job Cost Details

Finance: General Ledger Detail, Profit and Loss Detail

QQube Source

QQube defines the fully paid date as the last date on which an applied transaction causes the original transaction balance to reach 0.00. The applied transaction may be a payment, credit, or another eligible reduction.

Difference from QuickBooks

QuickBooks defines the fully paid date for an invoice as the date of the last payment. Credits applied later may not change the QuickBooks date.

QQube retains its established broader definition for consistent legacy reporting.

QQube Fully Paid Date definition and applied transaction example

Available Fields

The following fields are included in the Fully Paid Date Dimension.

Display Order	Field Name
1	Fully Paid Date
2	Fully Paid Date Calendar Month Number
3	Fully Paid Date Calendar Year Number
4	Fully Paid Date Day Holiday Name
5	Fully Paid Date Day is Holiday
6	Fully Paid Date Day is Weekend Day
7	Fully Paid Date Day is Working Day
8	Fully Paid Date Day Number in Month
9	Fully Paid Date Day Number in Quarter
10	Fully Paid Date Day Number in Week
11	Fully Paid Date Day Number in Year
12	Fully Paid Date Day of Week
13	Fully Paid Date Day of Week Abbr
14	Fully Paid Date Formal Date
15	Fully Paid Date Month Abbr
16	Fully Paid Date Month Begin Date
17	Fully Paid Date Month End Date
18	Fully Paid Date Month Name
19	Fully Paid Date Month Number
20	Fully Paid Date Month Number in Quarter
21	Fully Paid Date Month-Year
22	Fully Paid Date Quarter (FQ)
23	Fully Paid Date Quarter (Q)
24	Fully Paid Date Quarter Begin Date
25	Fully Paid Date Quarter End Date
26	Fully Paid Date Quarter Number
27	Fully Paid Date Quarter-Year (FQ)
28	Fully Paid Date Quarter-Year (Q)
29	Fully Paid Date Week Begin Date
30	Fully Paid Date Week End Date
31	Fully Paid Date Year (FY)
32	Fully Paid Date Year (Y)
33	Fully Paid Date Year Begin Date
34	Fully Paid Date Year End Date
35	Fully Paid Date Year Number