ReimburseCharges
Displays billable expenses marked to be reimbursed by customers, showing charges that will later be invoiced as pass-through costs.
View Specific Information
Select
The driver uses the QuickBooks Online API to retrieve the details of ReimburseCharges. Columns that can be filtered include: Id, CustomerRef, MetaData_CreateTime, MetaData_CreateTime, and HasBeenInvoiced.
Select
All filterable columns support the following operators:
- =
- !=
- >=
- <=
- >
- <
- IN
- LIKE
- CONTAINS
The driver processes other filters client-side within the driver.
Example:
SELECT * FROM ReimburseCharges;
SELECT * FROM ReimburseCharges WHERE Id = '548';
SELECT * FROM ReimburseCharges WHERE Id IN ('548','365');
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier (Id) that is assigned by QuickBooks Online to this reimbursable charge. It is used to retrieve or reference the charge programmatically and is required for updates or deletions. The default sort order is ascending (ASC). | |
| SyncToken | String | The version control token for this reimbursable charge that is used to manage concurrent access and ensure that only one application modifies the charge at a time. QuickBooks Online increments this token each time the charge is modified, and only the latest token is accepted for edits. | |
| Amount | Decimal | The total amount of this reimbursable charge line item. This field represents the amount that is recorded to be billed back to the customer. | |
| CustomerRef | String |
Customers.Id | The unique Id of the customer that is associated with this reimbursable charge. |
| CustomerRef_Name | String |
Customers.DisplayName | The display name of the customer that is associated with this reimbursable charge. |
| CurrencyRef | String | The three-letter ISO 4217 code of the currency that is used for this reimbursable charge transaction (for example, USD, CAD, EUR). | |
| CurrencyRef_Name | String | The full display name of the currency that is used for this reimbursable charge transaction (for example, US Dollar, Canadian Dollar). | |
| LineAggregate | String | An XML aggregate that is serialized into a single string representing all line items that are associated with this reimbursable charge transaction. Each line element typically includes Line/Id, Line/Amount, Line/Description and any applicable detail elements. | |
| PrivateNote | String | A user-entered, organization-private note about this reimbursable charge transaction. This note does not appear on customer-facing invoices by default. | |
| LinkedTxnAggregate | String | An XML aggregate that is serialized into a single string representing all transactions that are linked to this reimbursable charge. This collection typically includes the Invoice Id when the reimbursable charge has been linked with an invoice. | |
| ExchangeRate | Decimal | The currency exchange rate that QuickBooks Online applies to convert this reimbursable charge amount to the home currency. This field is valid only when multicurrency is enabled for the company. In QuickBooks Online, exchange rates are always recorded as the number of home currency units it takes to equal one foreign currency unit. | |
| MetaData_CreateTime | Datetime | The date and time stamp (Coordinated Universal Time) when QuickBooks Online created this reimbursable charge record. | |
| MetaData_LastUpdatedTime | Datetime | The date and time stamp (Coordinated Universal Time) when this reimbursable charge record was last modified in QuickBooks Online. | |
| HasBeenInvoiced | Boolean | Indicates whether this reimbursable charge has already been linked to an invoice (true) or has not yet been invoiced (false). | |
| HomeTotalAmt | Decimal | The total amount of the reimbursable charge transaction in the home currency. This amount includes the total of all charges, allowances, and taxes applied within the transaction. |