DepositLineItems

Columns

Name

Type

ReadOnly

References

Filterable

Sortable

Description

LineId [KEY]

String

True

false

false

The Id of the line item of the invoice.

DepositId [KEY]

String

False

Deposits.Id

true

true

The Id of the invoice.

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.

TxnDate

Date

False

true

true

The date entered by the user when this transaction occurred.

PrivateNote

String

False

false

false

A private note that does not appear on the transaction records.

Line_Id

String

False

false

false

The Id of the line item.

Line_Description

String

False

false

false

The description of the line item.

Line_Amount

Decimal

False

false

false

The amount of the line item.

Line_DetailType

String

False

false

false

The detailType of the line item.

Line_DepositLineDetail_PaymentMethodRef

String

False

PaymentMethods.Id

false

false

The payment method id of the line item.

Line_DepositLineDetail_PaymentMethodRef_Name

String

False

PaymentMethods.Name

false

false

The payment method id of the line item.

Line_DepositLineDetail_AccountRef

String

False

Accounts.Id

false

false

Account where the funds are deposited to.

Line_DepositLineDetail_AccountRef_Name

String

False

Accounts.Name

false

false

Account where the funds are deposited to.

Line_DepositLineDetail_Entity

String

False

Customers.Id

false

false

Reference to a customer from which the deposit was recieved

Line_DepositLineDetail_Entity_Name

String

False

Customers.DisplayName

false

false

Reference to a customer from which the deposit was recieved

Line_DepositLineDetail_ClassRef

String

False

Class.Id

false

false

Reference to the Class associated with the transaction

Line_DepositLineDetail_ClassRef_Name

String

False

Class.FullyQualifiedName

false

false

Reference to the Class associated with the transaction

Line_DepositLineDetail_CheckNum

String

False

false

false

The check number for the deposit

Line_DepositLineDetail_TxnType

String

False

false

false

The type of the payment transaction. Different types indicate different types of line items.

Line_DepositLineDetail_TaxCodeRef

String

False

TaxCodes.Id

false

false

The Sales/Purchase tax code associated with the Line. This field is valid in the UK, AU, IN, and CA editions.

Line_DepositLineDetail_TaxApplicableOn

String

False

false

false

Indicates whether the tax applicable on the line is sales or purchase. This field is valid in the UK, AU, IN, and CA editions.

Line_LinkedTxn_TxnId

String

True

false

false

The id of the linked transaction

Line_LinkedTxn_TxnType

String

True

false

false

The type of the linked transaction. Different types indicate different types of line items.

Line_LinkedTxn_TxnLineId

String

True

false

false

The lineitem id of the linked transaction line item.

TxnTaxDetail_TxnTaxCodeRef

String

False

TaxCodes.Id

false

false

The tax code for the transaction. This field is valid in the UK, AU, IN, and CA editions.

TxnTaxDetail_TotalTax

String

False

false

false

The total tax calculated for the transaction, excluding any tax lines manually inserted into the transaction line list. This field is valid in the UK, AU, IN, and CA editions.

TxnTaxDetail_TaxLineAggregate

String

False

false

false

An XML aggregate of tax line items. This field is valid in the UK, AU, IN, and CA editions.

DepositToAccountRef

String

False

Accounts.Id

false

false

The Id of the asset account to be used for this deposit.

DepositToAccountRef_Name

String

False

Accounts.Name

false

false

The name of the asset account to be used for this deposit.

ClassRef

String

False

Class.Id

false

false

The Id of the class associated with the transaction.

ClassRef_Name

String

True

Class.FullyQualifiedName

false

false

The name of the class associated with the transaction.

TotalAmt

Decimal

True

true

true

This field indicates the total amount of the transaction. This includes the total of all the charges, allowances, and taxes.

CashBack_AccountRef

String

True

true

false

The asset account (bank account) Id to be used for this cash back transaction

CashBack_AccountRef_Name

String

False

false

false

The asset account (bank account) Name to be used for this cash back transaction

CashBack_Amount

Decimal

False

false

false

The amount of the cash back transaction.

CashBack_Memo

String

True

true

false

The memo associated with this cash back transaction.

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 store the location of the transaction as defined using location tracking in QuickBooks Online.

ApplyTaxAfterDiscount

Boolean

False

false

false

This field sets whether discounts are applied before the tax is calculated.

CurrencyRef

String

False

false

false

The Id of the currency used in the transaction.

CurrencyRef_Name