View Categories

InvoiceLineRet

(QuickBooks Desktop -> InvoiceLineRet) (QuickBooks Online -> InvoiceLineDetail)

FIELD NAME
QuickBooks Desktop
FIELD NAME
QuickBooks Online
QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnLineIDIdtruefalse
ItemRef_ListIDItemRef_Idtrue true
ItemRef_FullNameItemRef_Nametrue true
DescDescriptiontrue true
QuantityQtytrue true
UnitOfMeasureUOMUnittrue true
OverrideUOMSetRef_ListIDUOMSetRef_Idtrue true
OverrideUOMSetRef_FullNameUOMSetRef_Nametrue true
Ratetrue true
RatePercentRatePercenttrue true
ClassRef_ListIDClassRef_Idtrue true
ClassRef_FullNameClassRef_Nametrue true
AmountAmounttrue true
TaxAmountTaxInclusiveAmttrue false
InvSiteRef_ListIDInventorySiteRef_Idtrue true
InvSiteRef_FullNameInventorySiteRef_Nametrue true
InvSiteLocRef_ListIDtrue true
InvSiteLocRef_FullNametrue true
SerialNumbertrue true
LotNumbertrue true
ServiceDateServiceDatetrue true
SalesTaxCodeRef_ListIDTaxCodeRef_Idtrue true
SalesTaxCodeRef_FullNameTaxCodeRef_Nametrue true
IsTaxabletrue false
Other1true true
Other2true true
LinkToTxn_TxnIDtrue false
LinkToTxn_TxnLineIDtrue false
CustomField1true true
CustomField2true true
CustomField3true true
CustomField4true true
CustomField5true true
CustomField6true true
CustomField7true true
CustomField8true true
CustomField9true true
CustomField10true true
CustomField11true true
CustomField12true true
CustomField13true true
CustomField14true true
CustomField15true true
PARENT_IDKEYPARENT_ID
GroupPARENT_IDKEYPARENT_GroupID
SeqNumSeqNum

Parent tables:

  • Invoice
  • InvoiceLineGroupRet