This is an old revision of the document!


QuickBooks SQL Mirror: The 'invoice_invoiceline' Table

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 
quickbooks_integration_php_consolibyte_sqlmirror_table_invoice_invoiceline.1258468976.txt.gz · Last modified: 2013/01/21 12:44 (external edit)