QuickBooks

Account created - A new account was added

Bill created - A new bill was added

Customer created - A new customer was added

Estimate created - A new estimate was added

Expense created - A new expense was added

Invoice created - A new invoice was added

Payment created - A new payment was received

Purchase order created - A new purchase order was added

Sales receipt created - A new sales receipt was added

Create journal entry - Add a new journal entry

Class reference - A class reference associated with the transaction

Class reference - A class reference associated with the transaction

Department reference - A reference to a Department object specifying the location of the transaction

Department reference - A reference to a Department object specifying the location of the transaction

Credit account - The credit account

Credit amount - The credit amount

Debit account - The debit account

Debit amount - The debit amount

Create bill payment - Add a new bill payment

Bank Account - Account ID

Credit Card Account - Account ID

Lines - Line items for the bill payment

See Create bill payment - Lines.

Pay type - The payment type

Total amount - Total amount

Vendor - Vendor ID

Create invoice - Add a new invoice.

Line items - Add line items for the invoice

See Create invoice - Line items.

Message - Enter a message for the customer

Due date - Enter the date when the payment for the transaction is due

Invoice number - Enter the invoice number for the transaction

Billing address state - Enter the state abbreviation

For example: CA

Shipping address state - Enter the state abbreviation

For example: CA

Transaction class ID - Select the class ID for the transaction

Terms - Select the sales terms of the transaction

Allow online credit card payment - Specify if online credit card payments are allowed for this invoice. This corresponds to the <b>Cards</b> online payment check box in the QuickBooks user interface.

Allow online ACH payment - Specify if this invoice can be paid with online bank transfers. This corresponds to the <b>Free bank transfer</b> online payment check box in the QuickBooks user interface.

Customer name - The name of the customer

Billing address city

Billing address country

Billing address line 1

Billing address postal code

Shipping address city

Shipping address country

Shipping address line 1

Shipping address line 2

Shipping address postal code

Update customer - Update the information about a customer

Alternate phone - Alternate phone number

Family name - Family name or first name of a person

Fax phone - Fax phone number

Fully qualified name - Fully qualified name of the object

Warning  Takes the form of Customer:Job:Sub-job

Given name - Given name or first name of a person

Active - If true, this entity is currently enabled for use by QuickBooks

Middle name - Middle name of the person. The person can have zero or more middle names.

Mobile phone - Mobile phone number

Print on check name - Name of the person or organization as printed on a check

Email address - Primary email address

Primary phone - Primary phone number

Suffix - Suffix of the name

Customer ID - The ID of the customer

Company name - The name of the company associated with the person or organization

Display name - The name of the person or organization as displayed

Warning  Must be unique across all Customer, Vendor, and Employee objects. Cannot be removed with sparse update.

Title - Title of the person

Sync token - Version number of the object

Website address - Website address

Create refund receipt - Add a new refund receipt

Account - Bank or other current asset account from which payment money is refunded

Message - Enter a message for the customer

Invoice number - Enter the invoice number for the transaction

Lines - Line items for the refund receipt

See Create refund receipt - Lines.

Customer name - The name of the customer

Create customer - Add a new customer

Billing address city - City

Billing address country - Country

Billing address county subdivision code - Country subdivision code

Family name - Family name or first name of a person

Given name - Given name or first name of a person

Billing address line 1 - Line 1

Middle name - Middle name of the person. The person can have zero or more middle names.

Billing address postal code - Postal code

Suffix - Suffix of the name

Company name - The name of the company associated with the person

Display name - The name of the person or organization as displayed

Warning  Must be unique across all Customer, Vendor, and Employee objects. Cannot be removed with sparse update.

Title - Title of the person

Create employee - Add a new employee

Billing address city - City

Billing address country - Country

Billing address county subdivision code - Country subdivision code

Family name - Family name

Given name - Given name

Billing address line 1 - Line 1

Billing address postal code - Postal code

Get general ledger detail - Return a general ledger detail report

Columns - Comma separated, eg: account_name,subt_nat_amount

Account - Filters report contents to include information for specified accounts. Supported Values: One or more comma separated account IDs.

Class - Filters report contents to include information for specified classes if so configured in the company file. Supported Values: One or more comma separated class IDs.

Customer - Filters report contents to include information for specified customers. Supported Values: One or more comma separated customer IDs.

Department - Filters report contents to include information for specified departments if so configured in the company file. Supported Values: One or more comma separated department IDs.

Source account - Filters report contents to include information for specified source accounts. Supported Values: One or more comma separated account IDs.

Vendor - Filters report contents to include information for specified vendors. Supported Values: One or more comma separated vendor IDs.

End date - If not specified, the value of Date range is used. The start date and end date of the report is in the format YYYY-MM-DD.

YYYY-MM-DD

Start date - If not specified, the value of Date range is used. The start date and end date of the report is in the format YYYY-MM-DD.

YYYY-MM-DD

Sort order

Source account type

Account type - The account type

Accounting method - The accounting method used in the report

Sort by - The column type used in sorting report rows. Default is txn_type

Date range - The predefined date range. The default is This Fiscal Year-to-date.

Create credit memo - Add a new credit memo

Customer - Customer ID

Lines - Line items for the bill

See Create credit memo - Lines.

Create estimate - Add a new estimate

Customer - Customer ID

Lines - Line items for the estimate

See Create estimate - Lines.

Create sales receipt - Add a new sales receipt

Message - Enter a message for the customer

Invoice number - Enter the invoice number for the transaction

Lines - Line items for the sales receipt

See Create sales receipt - Lines.

Customer name - The name of the customer

Create inventory or service - Add a new inventory or service

Name - Enter a name (must be unique)

Asset Account ID - The ID of the asset account

Expense account - The ID of the expense account

Income account - The ID of the income account

Type - The type of the item

Create vendor - Add a new vendor

Title - Enter a prefix title

Billing address country subdivision code - Enter a subdivision code

Suffix - Enter a suffix for the vendor name

Billing address - Enter the address of the vendor

Billing address city - Enter the city

Company name - Enter the company name

Billing address country - Enter the country

Family name - Enter the family name or last name of the vendor. A given name or a family name is required.

Given or first name - Enter the given or first name of the vendor. A given name or a family name is required.

Middle name - Enter the middle name of the vendor. A middle name is optional.

Display name - Enter the name of the vendor as it will be displayed

Warning  Must be unique across all customer, vendor, and employee objects. Cannot be removed with a sparse update.

Billing address postal code - Enter the postal code

Update invoice - Update information about an invoice

Due date - Enter the date when the payment for the transaction is due

Lines - Line items for the invoice

See Update invoice - Lines.

Transaction class ID - Select the class ID for the transaction.

Allow online credit card payment - Specify if online credit card payments are allowed for this invoice. This corresponds to the <b>Cards</b> online payment check box in the QuickBooks user interface.

Allow online ACH payment - Specify if this invoice can be paid with online bank transfers. This corresponds to the <b>Free bank transfer</b> online payment check box in the QuickBooks user interface.

Customer ID - The ID of the customer

Invoice ID - The ID of the invoice

Sync token - Version number of the object. It is used to lock an object for use by one app at a time.

Add employee time - Create a time activity for an employee

End time

Start time

Employee ID - The ID of the employee

Add vendor time - Create a time activity for a vendor

End time

Start time

Vendor ID - The ID of the vendor

Create bill - Add a new bill

Lines - Line items for the bill

See Create bill - Lines.

Vendor - Vendor ID

Create expense - Add a new expense

Lines - Line items for the expense

See Create expense - Lines.

Account ID - The ID of the account

Payment type - The type of payment for the expense

Create purchase order - Add a new purchase order

Lines - Line items for the refund receipt

See Create purchase order - Lines.

AP Account - The ID of the AP account

Vendor ID - The ID of the vendor

Create class - Add a new class

Parent class - The ID for the referenced object

Warning  Required if this object is a subclass

Name - User recognizable name for the class

Create payment - Add a new payment

Customer ID - The ID of the customer

Total amount - The total amount of the payment

Create transfer - Add a new account transfer

From Account ID - The ID of the From account

To Account - The ID of the To account

Amount - The transfer amount

Find customer by ID - Return a customer using their ID

Customer ID - The ID of the customer

Find item by ID - Return an item using its Quickbooks ID

Item ID - Enter the ID of the item

Email sales receipt - Send a sales receipt by email

Email address - Enter the destination email

Sales receipt ID - Select the ID of the receipt

Email invoice - Send an invoice by email

Email - The destination email

Invoice ID - The ID for the invoice

Query by account ID - Use a query to return data for an account

Select statement - Enter the select statement for the query

select * from Account Where Metadata.LastUpdatedTime > '2021-01-01'