Billed Date Dimension

Modified on Mon, 27 Jul at 9:06 PM

Calendar Summary

The Billed Date Dimension organizes activity by the billed date entered when creating Statement Charges in QuickBooks.

Calendar Type

Transaction date

Date Represents

Statement charge billed date

QuickBooks Source

Statement Charge

Primary Use

Billing-date analysis

Included Data Models

Customers: Sales, Accounts Receivable

Operations: Inventory, Job Cost Details

Finance: General Ledger Detail, Profit and Loss Detail

Auditing: Audit Trail

The billed date is entered when creating a Statement Charge in QuickBooks.

QuickBooks Statement Charge billed date source

The following fields are included in the Billed Date Dimension.

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