Day of the month Day of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY | | Type | DAY | | Data Type | dimension |
|
Day of the week Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY_OF_WEEK | | Type | DAY_OF_WEEK | | Data Type | dimension |
|
Hour of the day Hour of the day | | Field ID | _NORMALIZED_DATE_FIELD_HOUR | | Type | HOUR | | Data Type | dimension |
|
Month of the year Month of the year | | Field ID | _NORMALIZED_DATE_FIELD_MONTH | | Type | MONTH | | Data Type | dimension |
|
Month and day Month and day | | Field ID | _NORMALIZED_DATE_FIELD_MONTH_DAY | | Type | MONTH_DAY | | Data Type | dimension |
|
Quarter of the year Quarter of the year | | Field ID | _NORMALIZED_DATE_FIELD_QUARTER | | Type | QUARTER | | Data Type | dimension |
|
Week of the year Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK | | Type | WEEK | | Data Type | dimension |
|
Week of the year (start Sunday) Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY | | Type | WEEK | | Data Type | dimension |
|
Year Year such as 2017. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR | | Type | YEAR | | Data Type | dimension |
|
Year month Year and month. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH | | Type | YEAR_MONTH | | Data Type | dimension |
|
Date Year, month, and day. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Year month day hour Year, month, day, and hour. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR | | Type | YEAR_MONTH_DAY_HOUR | | Data Type | dimension |
|
Year Quarter Year and quarter. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_QUARTER | | Type | YEAR_QUARTER | | Data Type | dimension |
|
Year week Year and week. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_WEEK | | Type | YEAR_WEEK | | Data Type | dimension |
|
Company Address City City of the company address. | | Field ID | company_info/company_addr_city | | Type | TEXT | | Data Type | dimension |
|
Company Address Country Country of the company address. | | Field ID | company_info/company_addr_country | | Type | TEXT | | Data Type | dimension |
|
Company Address Region State or region of the company address. | | Field ID | company_info/company_addr_country_sub_division_code | | Type | TEXT | | Data Type | dimension |
|
Company Address Line 1 First line of the company address. | | Field ID | company_info/company_addr_line_1 | | Type | TEXT | | Data Type | dimension |
|
Company Address Postal Code Postal code of the company address. | | Field ID | company_info/company_addr_postal_code | | Type | TEXT | | Data Type | dimension |
|
Company Info Name Display name of the QuickBooks company. | | Field ID | company_info/company_name | | Type | TEXT | | Data Type | dimension |
|
Country Country configured on the company. | | Field ID | company_info/country | | Type | TEXT | | Data Type | dimension |
|
Customer Communication Email Email used for customer communication. | | Field ID | company_info/customer_communication_email | | Type | TEXT | | Data Type | dimension |
|
Email Primary company email. | | Field ID | company_info/email | | Type | TEXT | | Data Type | dimension |
|
Fiscal Year Start Month Month when the fiscal year starts. | | Field ID | company_info/fiscal_year_start_month | | Type | TEXT | | Data Type | dimension |
|
Company ID QuickBooks company identifier. | | Field ID | company_info/id | | Type | TEXT | | Data Type | dimension |
|
Company Info Last Updated Time Last update timestamp for the company info. | | Field ID | company_info/last_updated_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Legal Name Legal company name. | | Field ID | company_info/legal_name | | Type | TEXT | | Data Type | dimension |
|
Phone Number Primary company phone number. | | Field ID | company_info/phone_number | | Type | TEXT | | Data Type | dimension |
|
Supported Languages Languages enabled on the company. | | Field ID | company_info/supported_languages | | Type | TEXT | | Data Type | dimension |
|
Website Website URL configured on the company. | | Field ID | company_info/web_addr_uri | | Type | URL | | Data Type | dimension |
|
Active Whether the customer is active. | | Field ID | customer/active | | Type | BOOLEAN | | Data Type | dimension |
|
Customer Balance Open balance on the customer. | | Field ID | customer/balance | | Type | NUMBER | | Data Type | metric |
|
Billing Address City City of the billing address. | | Field ID | customer/billing_addr_city | | Type | TEXT | | Data Type | dimension |
|
Billing Address Country Country of the billing address. | | Field ID | customer/billing_addr_country | | Type | TEXT | | Data Type | dimension |
|
Billing Address Region State or region of the billing address. | | Field ID | customer/billing_addr_country_sub_division_code | | Type | TEXT | | Data Type | dimension |
|
Billing Address Line 1 First line of the billing address. | | Field ID | customer/billing_addr_line_1 | | Type | TEXT | | Data Type | dimension |
|
Billing Address Postal Code Postal code of the billing address. | | Field ID | customer/billing_addr_postal_code | | Type | TEXT | | Data Type | dimension |
|
Customer Company Name Company name of the customer. | | Field ID | customer/company_name | | Type | TEXT | | Data Type | dimension |
|
Customer Create Time Creation timestamp of the customer. | | Field ID | customer/create_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Customer Currency Currency used by the customer. | | Field ID | customer/currency_ref | | Type | TEXT | | Data Type | dimension |
|
Display Name Display name of the customer. | | Field ID | customer/display_name | | Type | TEXT | | Data Type | dimension |
|
Family Name Last name of the customer. | | Field ID | customer/family_name | | Type | TEXT | | Data Type | dimension |
|
Fully Qualified Name Fully qualified customer name. | | Field ID | customer/fully_qualified_name | | Type | TEXT | | Data Type | dimension |
|
Given Name First name of the customer. | | Field ID | customer/given_name | | Type | TEXT | | Data Type | dimension |
|
Customer ID Unique QuickBooks customer identifier. | | Field ID | customer/id | | Type | TEXT | | Data Type | dimension |
|
Customer Last Updated Time Last update timestamp of the customer. | | Field ID | customer/last_updated_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Mobile Phone Mobile phone number of the customer. | | Field ID | customer/mobile_free_form_number | | Type | TEXT | | Data Type | dimension |
|
Primary Email Primary email address of the customer. | | Field ID | customer/primary_email_addr | | Type | TEXT | | Data Type | dimension |
|
Primary Phone Primary phone number of the customer. | | Field ID | customer/primary_phone_free_form_number | | Type | TEXT | | Data Type | dimension |
|
Shipping Address City City of the shipping address. | | Field ID | customer/shipping_addr_city | | Type | TEXT | | Data Type | dimension |
|
Shipping Address Country Country of the shipping address. | | Field ID | customer/shipping_addr_country | | Type | TEXT | | Data Type | dimension |
|
Shipping Address Region State or region of the shipping address. | | Field ID | customer/shipping_addr_country_sub_division_code | | Type | TEXT | | Data Type | dimension |
|
Shipping Address Line 1 First line of the shipping address. | | Field ID | customer/shipping_addr_line_1 | | Type | TEXT | | Data Type | dimension |
|
Shipping Address Postal Code Postal code of the shipping address. | | Field ID | customer/shipping_addr_postal_code | | Type | TEXT | | Data Type | dimension |
|
Customer Sync Token QuickBooks sync token. | | Field ID | customer/sync_token | | Type | TEXT | | Data Type | dimension |
|
Apply Tax After Discount Whether taxes are applied after discount. | | Field ID | invoice/apply_tax_after_discount | | Type | BOOLEAN | | Data Type | dimension |
|
Invoice Balance Remaining balance on the invoice. | | Field ID | invoice/balance | | Type | NUMBER | | Data Type | metric |
|
Invoice Create Time Creation timestamp of the invoice. | | Field ID | invoice/create_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Invoice Currency Currency used by the invoice. | | Field ID | invoice/currency_ref | | Type | TEXT | | Data Type | dimension |
|
Customer Memo Memo displayed to the customer. | | Field ID | invoice/customer_memo | | Type | TEXT | | Data Type | dimension |
|
Invoice Customer Name Name of the related customer. | | Field ID | invoice/customer_name | | Type | TEXT | | Data Type | dimension |
|
Deposit Deposit amount recorded on the invoice. | | Field ID | invoice/deposit | | Type | NUMBER | | Data Type | metric |
|
Document Number Invoice document number. | | Field ID | invoice/doc_number | | Type | TEXT | | Data Type | dimension |
|
Due Date Due date of the invoice. | | Field ID | invoice/due_date | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Email Status Email delivery status of the invoice. | | Field ID | invoice/email_status | | Type | TEXT | | Data Type | dimension |
|
Invoice Exchange Rate Exchange rate on the invoice. | | Field ID | invoice/exchange_rate | | Type | NUMBER | | Data Type | metric |
|
Home Total Amount Home currency total amount. | | Field ID | invoice/home_total_amount | | Type | NUMBER | | Data Type | metric |
|
Invoice ID Unique QuickBooks invoice identifier. | | Field ID | invoice/id | | Type | TEXT | | Data Type | dimension |
|
Invoice Last Updated Time Last update timestamp of the invoice. | | Field ID | invoice/last_updated_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Invoice Line Count Number of lines on the invoice. | | Field ID | invoice/line_count | | Type | NUMBER | | Data Type | metric |
|
Print Status Print status of the invoice. | | Field ID | invoice/print_status | | Type | TEXT | | Data Type | dimension |
|
Invoice Private Note Private note of the invoice. | | Field ID | invoice/private_note | | Type | TEXT | | Data Type | dimension |
|
Invoice Sync Token QuickBooks sync token. | | Field ID | invoice/sync_token | | Type | TEXT | | Data Type | dimension |
|
Invoice Total Amount Total amount of the invoice. | | Field ID | invoice/total_amount | | Type | NUMBER | | Data Type | metric |
|
Total Tax Total tax amount. | | Field ID | invoice/total_tax | | Type | NUMBER | | Data Type | metric |
|
Invoice Transaction Date Invoice transaction date. | | Field ID | invoice/txn_date | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Amount Amount of the invoice line. | | Field ID | invoice_line/amount | | Type | NUMBER | | Data Type | metric |
|
Invoice Line Create Time Creation timestamp of the related invoice. | | Field ID | invoice_line/create_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Invoice Line Customer Name Name of the related customer. | | Field ID | invoice_line/customer_name | | Type | TEXT | | Data Type | dimension |
|
Description Description of the invoice line. | | Field ID | invoice_line/description | | Type | TEXT | | Data Type | dimension |
|
Expense Account ID Identifier of the linked expense account. | | Field ID | invoice_line/expense_account_id | | Type | TEXT | | Data Type | dimension |
|
Expense Account Name Name of the linked expense account. | | Field ID | invoice_line/expense_account_name | | Type | TEXT | | Data Type | dimension |
|
Invoice Line ID Synthetic identifier for the invoice line. | | Field ID | invoice_line/id | | Type | TEXT | | Data Type | dimension |
|
Invoice Document Number Document number of the related invoice. | | Field ID | invoice_line/invoice_doc_number | | Type | TEXT | | Data Type | dimension |
|
Invoice Line Last Updated Time Last update timestamp of the related invoice. | | Field ID | invoice_line/last_updated_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Line ID Identifier of the line in QuickBooks. | | Field ID | invoice_line/line_id | | Type | TEXT | | Data Type | dimension |
|
Line Number Position of the line on the invoice. | | Field ID | invoice_line/line_num | | Type | NUMBER | | Data Type | dimension |
|
Line Type Detail type of the line. | | Field ID | invoice_line/line_type | | Type | TEXT | | Data Type | dimension |
|
Sales Item ID Identifier of the related sales item. | | Field ID | invoice_line/sales_item_item_id | | Type | TEXT | | Data Type | dimension |
|
Sales Item Name Name of the related sales item. | | Field ID | invoice_line/sales_item_item_name | | Type | TEXT | | Data Type | dimension |
|
Sales Item Quantity Quantity of the sales item. | | Field ID | invoice_line/sales_item_qty | | Type | NUMBER | | Data Type | metric |
|
Service Date Service date of the sales item. | | Field ID | invoice_line/sales_item_service_date | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Sales Item Tax Code Tax code applied on the sales item. | | Field ID | invoice_line/sales_item_tax_code | | Type | TEXT | | Data Type | dimension |
|
Sales Item Unit Price Unit price of the sales item. | | Field ID | invoice_line/sales_item_unit_price | | Type | NUMBER | | Data Type | metric |
|
Invoice Line Transaction Date Transaction date of the related invoice. | | Field ID | invoice_line/txn_date | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Payment Create Time Creation timestamp of the payment. | | Field ID | payment/create_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Payment Currency Currency used by the payment. | | Field ID | payment/currency_ref | | Type | TEXT | | Data Type | dimension |
|
Payment Customer Name Name of the related customer. | | Field ID | payment/customer_name | | Type | TEXT | | Data Type | dimension |
|
Deposit Account ID Identifier of the deposit account. | | Field ID | payment/deposit_to_account_id | | Type | TEXT | | Data Type | dimension |
|
Deposit Account Name Name of the deposit account. | | Field ID | payment/deposit_to_account_name | | Type | TEXT | | Data Type | dimension |
|
Payment Exchange Rate Exchange rate on the payment. | | Field ID | payment/exchange_rate | | Type | NUMBER | | Data Type | metric |
|
Payment ID Unique QuickBooks payment identifier. | | Field ID | payment/id | | Type | TEXT | | Data Type | dimension |
|
Payment Last Updated Time Last update timestamp of the payment. | | Field ID | payment/last_updated_time | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Payment Line Count Number of linked lines on the payment. | | Field ID | payment/line_count | | Type | NUMBER | | Data Type | metric |
|
Payment Method ID Identifier of the related payment method. | | Field ID | payment/payment_method_id | | Type | TEXT | | Data Type | dimension |
|
Payment Method Name Name of the related payment method. | | Field ID | payment/payment_method_name | | Type | TEXT | | Data Type | dimension |
|
Payment Private Note Private note of the payment. | | Field ID | payment/private_note | | Type | TEXT | | Data Type | dimension |
|
Process Payment Whether the payment should be processed. | | Field ID | payment/process_payment | | Type | BOOLEAN | | Data Type | dimension |
|
Payment Sync Token QuickBooks sync token. | | Field ID | payment/sync_token | | Type | TEXT | | Data Type | dimension |
|
Payment Total Amount Total payment amount. | | Field ID | payment/total_amount | | Type | NUMBER | | Data Type | metric |
|
Payment Transaction Date Payment transaction date. | | Field ID | payment/txn_date | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Unapplied Amount Unapplied amount remaining on the payment. | | Field ID | payment/unapplied_amount | | Type | NUMBER | | Data Type | metric |
|
.svg){kind=logo}