(QuickBooks Desktop -> InvoiceLineRet) (QuickBooks Online -> InvoiceLineDetail)
| FIELD NAME QuickBooks Desktop | FIELD NAME QuickBooks Online | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
| TxnLineID | Id | true | false | |||
| ItemRef_ListID | ItemRef_Id | true | true | |||
| ItemRef_FullName | ItemRef_Name | true | true | |||
| Desc | Description | true | true | |||
| Quantity | Qty | true | true | |||
| UnitOfMeasure | UOMUnit | true | true | |||
| OverrideUOMSetRef_ListID | UOMSetRef_Id | true | true | |||
| OverrideUOMSetRef_FullName | UOMSetRef_Name | true | true | |||
| Rate | true | true | ||||
| RatePercent | RatePercent | true | true | |||
| ClassRef_ListID | ClassRef_Id | true | true | |||
| ClassRef_FullName | ClassRef_Name | true | true | |||
| Amount | Amount | true | true | |||
| TaxAmount | TaxInclusiveAmt | true | false | |||
| InvSiteRef_ListID | InventorySiteRef_Id | true | true | |||
| InvSiteRef_FullName | InventorySiteRef_Name | true | true | |||
| InvSiteLocRef_ListID | true | true | ||||
| InvSiteLocRef_FullName | true | true | ||||
| SerialNumber | true | true | ||||
| LotNumber | true | true | ||||
| ServiceDate | ServiceDate | true | true | |||
| SalesTaxCodeRef_ListID | TaxCodeRef_Id | true | true | |||
| SalesTaxCodeRef_FullName | TaxCodeRef_Name | true | true | |||
| IsTaxable | true | false | ||||
| Other1 | true | true | ||||
| Other2 | true | true | ||||
| LinkToTxn_TxnID | true | false | ||||
| LinkToTxn_TxnLineID | true | false | ||||
| CustomField1 | true | true | ||||
| CustomField2 | true | true | ||||
| CustomField3 | true | true | ||||
| CustomField4 | true | true | ||||
| CustomField5 | true | true | ||||
| CustomField6 | true | true | ||||
| CustomField7 | true | true | ||||
| CustomField8 | true | true | ||||
| CustomField9 | true | true | ||||
| CustomField10 | true | true | ||||
| CustomField11 | true | true | ||||
| CustomField12 | true | true | ||||
| CustomField13 | true | true | ||||
| CustomField14 | true | true | ||||
| CustomField15 | true | true | ||||
| PARENT_IDKEY | PARENT_ID | |||||
| GroupPARENT_IDKEY | PARENT_GroupID | |||||
| SeqNum | SeqNum |
Parent tables:
- Invoice
- InvoiceLineGroupRet