BillLinkedTransactions
Create, update, delete, and query QuickBooks Invoice Line Items.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| LinkedTxnId [KEY] | String | True | False | False |
The Id of the line item of the bill. | |
| BillId [KEY] | String | False |
Bills.Id | True | True |
The Id of the bill. |
| SyncToken | String | True | False | False |
Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online. | |
| MetaData_CreateTime | Datetime | True | True | True |
The time the record was created. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
The time the record was last updated. | |
| DocNumber | String | False | True | True |
The reference number for the transaction. | |
| TxnDate | Date | False | True | True |
The date entered by the user when this transaction occurred. | |
| PrivateNote | String | False | False | False |
A private note for the transaction, which does not appear on the transaction records. | |
| LinkedTxn_TxnId | String | False | False | False |
The Id of the line item. | |
| LinkedTxn_TxnType | String | False | False | False |
The line number of the line item. | |
| LinkedTxn_TxnLineId | String | False | False | False |
The description of the line item. | |
| LineAggregate | String | False | False | False |
An XML aggregate of line items associated with the transaction. | |
| VendorRef | String | False |
Vendors.Id | True | True |
The Id of the vendor. |
| VendorRef_Name | String | True |
Vendors.DisplayName | False | False |
The name of the vendor associated with the transaction. |
| APAccountRef | String | False |
Accounts.Id | True | True |
The Id of the accounts-payable account. |
| APAccountRef_Name | String | True |
Accounts.Name | False | False |
The name of the accounts-payable account. |
| SalesTermRef | String | False |
Terms.Id | True | True |
The Id of the sales terms entity of the bill. |
| SalesTermRef_Name | String | True |
Terms.Name | False | False |
A name that identifies the sales terms entity of the bill. |
| TxnTaxDetail_TxnTaxCodeRef | String | False |
TaxCodes.Id | False | False |
The tax code for the transaction. |
| TxnTaxDetail_TotalTax | String | False | False | False |
The total tax calculated for the transaction, excluding any tax lines manually inserted into the transaction line list. | |
| TxnTaxDetail_TaxLineAggregate | String | False | False | False |
An XML aggregate of tax line items. | |
| DueDate | Date | False | True | False |
The date when the invoice is to be paid, not including any early payment discount incentives or late payment penalties. If the date is not supplied, the current date on the server is used. | |
| TotalAmt | Decimal | True | True | True |
The total amount of the transaction. This includes the total of all the charges, allowances, and taxes. | |
| Balance | Decimal | False | False | False |
This field indicates whether the transaction is a finance charge. | |
| DepartmentRef | String | False |
Departments.Id | False | False |
The Id of the department, which stores the location of the transaction as defined using location tracking in QuickBooks Online. |
| DepartmentRef_Name | String | True |
Departments.Name | False | False |
The name of the department, which stores the location of the transaction as defined using location tracking in QuickBooks Online. |
| CurrencyRef | String | False | False | False |
The Id of the currency used in the transaction. | |
| CurrencyRef_Name | String | True | False | False |
The name of the currency used in the transaction. | |
| ExchangeRate | Decimal | False | False | False |
The currency exchange rate. Valid only if the company file is set up to use multicurrency feature. In QuickBooks, exchange rates are always recorded as the number of home currency units it takes to equal one foreign currency unit. This field is available for only the UK, AU, IN, and CA editions. | |
| GlobalTaxCalculation | String | False | False | False |
The method in which tax is applied. This field is valid in the UK, AU, IN, and CA editions. The allowed values are TaxExcluded, TaxInclusive, NotApplicable. |