![]() |
![]() |
qbsql_id (Auto-increment. Do not update.) Invoice_TxnID (This field refers to the TxnID field of the 'invoice' table.) SortOrder (This field indicates the order of the line items on the invoice, lower sort order numbers appear first on the invoice.) TxnLineID (To cause this line item to be added to the invoice, set this to -1. To cause this line item to be updated on the invoice, leave it as the generated TxnLineID value from QuickBooks. Note that any existing line items on the invoice are deleted when an invoice is modified unless you specify they should be updated.) Item_ListID (Either this or the Item_FullName field are required if you're specifying an Amount, Quantity, or Rate.) Item_FullName Descrip (The text description of the line item. If you just want the text to appear on the invoice as a note, you can specify this field and then leave the Rate, Quantity, Item_*, and Amount fields empty.) Quantity (The quantity of this item on the invoice.) UnitOfMeasure OverrideUOMSet_ListID OverrideUOMSet_FullName Rate (The amount charged per quantity, i.e. Rate * Quantity = Amount. You should specify either Quantity and Rate *or* Quantity and Amount.) RatePercent Class_ListID Class_FullName Amount (The total amount of the invoice. ServiceDate SalesTaxCode_ListID SalesTaxCode_FullName Other1 Other2