Fields - InvoiceDet

Fields

Field Name	Data Type	Description, Example
Cmf(key)	string	Lightspeed Dealer Identifier
DealerId	string	Internal Dealer Identifier (intentionally left blank)
invoiceId(key)	int	Internal DMS invoice identifier
InvoiceNo	string	External DMS invoice identifier
CommonInvoiceID		Internal DMS identifier for accounting record
InvoiceDate	date	Date of invoice
Invoicelineno(key)	bigint	Line ID of the invoice
CustID	string	DMS customer identifier
salesmanId	string	DMS id of the salesman (cashier)
salesmanname	string	Name of salesman
cost	money	Cost of the part
price	money	Price of the part
partno	string	Part identifier
source	string	Abbreviated maker of the part
partdesc	string	Description of the part
qty	int	Amount sold of the part
pu	int	Amount of the part picked up from a special order
so	int	Amount of the part that was special ordered
lay	int	Amount of the part that was put on layaway
lost	int	Amount of the part that was considered a lost sale due to lack of inventory
stdprice	money	Standard price of the part
category	string	Dealer assigned part category
FlagInternal	int	0 = Sold to customer, 1 = Sold to internal department
SalesType	string	M – Major Unit; R – RO; C - Customer
cashiername	string	Name of cashier
comment	string	Comment field on invoice
datecreated	date	Date when invoice record was made
discountrate	money	Set to 0
discounttype	string	Set to ’blank’
invoicecollectamt	money	Amount due
invoicehandlingamt	money	Amount due for shipping
invoicediscount	money	Discount total from invoice
exttotalprice	money	Extended price on entire invoice
exttotalcost	money	Extended cost on entire invoice
totalmargin	money	Margin on entire invoice
invoicesubtotal	money	Subtotal on entire invoice
invoicetax	money	Tax on entire invoice
pickedupamountcollected	money	Special order deposits already collected
soldnowdiscount	money	Discount applied to invoice at time of sale
soldnownontaxable	money	Sum of nontaxable parts price on invoice
soldnowprepaidamount	money	Sum of previously paid special order deposits
soldnowsubtotal	money	Sum of parts price before taxes
soldnowtax	money	Sum of taxes on invoice
soldnowtaxable	money	Sum of taxable parts price on invoice
soldnowtotals	money	Total amount due at time of sale
specialorderdiscount	money	Discount applied to special order amount
specialordernontaxable	money	Sum of nontaxable parts price on special order
specialordersubtotal	money	Sum of parts price on special order before taxes
specialordertax	money	Sum of taxes on special order
specialordertaxsubtotal	money	Subtotal including tax prior to deposit
specialordertaxable	money	Sum of taxable parts prices on special order
specialordertotals	money	Total amount of parts prices without taxes on special order
majorunitid	long	MU id if part is sold to unit
ponumber	string	Convenience field for dealer to enter in PO number associated to the invoice
repairorderid	long	RO id if part is sold to service
isresale	int	Denotes from customer record if the customer should be sold to at wholesale - Can be treated like a bool
saletypedescription	string	Dealer specified description of sale
shippingvendor	string	Name of selected shipping carrier
shippingmethod	string	Name of shipping method
shipmentcompletedate	date	Date shipment was picked up
shiptoprefixname	string	Prefix of name for shipping recipient
shiptofirstname	string	First name for shipping recipient
shiptomiddlename	string	Middle name for shipping recipient
shiptolastname	string	Last name for shipping recipient
shiptosuffixname	string	Suffix of name for shipping recipient
shiptocompanyname	string	Name of company for shipping recipient
shiptoemail	string	Email address for shipping recipient
shiptoaddress1	string	First line of address for shipping recipient
shiptoaddress2	string	Second line of address for shipping recipient
shiptocity	string	City for shipping recipient
shiptozipcode	string	Zipcode for shipping recipient
shiptocounty	string	County for shipping recipient
shiptostate	string	State for shipping recipient
shiptocountry	string	Country for shipping recipient
surchargefee	money	Surcharge fee associated with shipping costs
isspecialorder	Int	Denotes if invoice is a special order - Can be treated like a bool
specialordercollectamount	money	Denotes how much the special order deposit should be
specialordernumber	int	SO number if part is on SO
layawaynumber	int	Layaway number if part is on Lay
taxresalenumber	string	Tax ID from customer record if invoice is resale
trackingnumbers	string	Convenience field for dealer to enter in a tracking number for shipment
dealadjustmentprice	money	Deposit amount generated when invoice is associated with a deal
depositapplied	money	Sum of previously taken deposits on invoice
eachprice	money	Price of individual parts
totalreturn	money	Sum of parts price returned
inventorysource	int	Denotes if part was added to invoice via price book record or inventory record – 1 = inventory, 0 = price book
layawaypickup	int	Denotes if invoice is a layaway
linediscount	int	Denotes if discount was applied to part directly
miscellaneousline	int	Denotes if part is a misc part
specialorderpickup	int	Denotes if part is a special order pickup
istaxable	int	Denotes if part should be taxed - Can be treated like a bool
warranty	int	Denotes if part is associated with a warranty
taxcategoryid	long	ID of the parts tax category
weborderpartnumber	string	Part number received from web order
ordertype	string	Order type requested when part is a special order
taxcategorydescription	string	Description of tax category used
totalqty	int	Total requested quantity of part
webordernumber	String	Order number for web order

Notes

Notes: Use InvoiceId or InvoiceDate to determine changes.

Example URL Example JSON Result