Salelines PHYSICAL Table Structure

This page contains technical detail about the physical database structure. This documentation is not required for normal day to day operation of the Point Of Sale.

Overview

This table holds individual items purchased on a sale. It is a child of the sales table. Salelines may be present for other structures that arent technically sales (such as writeoffs in progress) as it also holds details of any open sale being used at counters

Mesh

On mesh configured systems, this table is maintained as an output

Columns

FieldName	Datatype	Meta Info	Gnap	Description
sid	long		105/E	Internal sale number allocated to this sale. References Sales.sid
pid	long		106/E	The internal product number of the item sold.
qty	long		101/E	Quantity of item sold, in measurement units, which is often "units" or "grams"
unitprice	money		107/s
totalprice	money		102/s	Total price charged to customer
pidflag	long		108/E	Indicates what type of item is being stored in this row. Code Description 0 Item is a product that can be found in the products table 2 Item is a product that can be found in the products table 4 5 Item is a modifier 10000, 10002, 10005 Item is cancelled/void etc and not visible to customer.
rid	long		109/E
discid_1	long		110/E
discid_2	long		111/E
disc_1_p	money		112/s
disc_2_p	money		113/s
seqnce	long		114/E	An ordinal sequence number for this saleline. Used to place salelines in order they were created
qtyflags	long		115/E
kitchenprinted	string		116/s
fueldispenser	long		117/E	The pump/dispenser this item came from for integrated fuel controllers.
fueltrantype	long		118/E
fueltrannum	long		119/E
serialno	char(32)		104/s
linesource	long		120/E	How this item came to be recognised and added to the sale Code Description 1 Was scanned by barcode 2 Manually entered barcode (the staff physically keyed in the number) 3 Item was selected from a product finder screen 4 Sold using LED style controls on User Interface (typically selling by keying PLU) 5 Treat as 4 above 6 Treat as 4 above
pricecause	long		121/E	This field holds a reason for the price being derived. Not all pricing techniques will store a cause reason. The following codes are defined. Code Description PriceCauseData 0 or NULL No information recorded 1 Special offer handling offerid 2 Reward Program programid 3 Kits/Combo kitid (reference to kit definition, typically Productkits table) 4 QtyDiscounts qid 5 Global store wide discounts 6 DiscountsManual applied 7 PriceMaps entry. (P1547) pmid 8 Customer discount percentage applied. Percentage used times 100 9 Price was set via PosCommand directly Price set 10 Discount applied discid 11 Discount Voucher applied 12 User manually set price Where multiple price changes occur on an item, only the last cause will be stored. Which change is "last" may change without warning.
pricecausedata	long		122/E	Additional key information for the pricecause field.
linetaxflags	long		123/E
pvariant	long		124/E
histtaxrate1	long		125/E
histtaxrate2	long		126/E
changereason	char(64)		127/s	Descriptive message entered by staff member as to why this saleline was editted. Capturing change reasons needs to be enabled specifically.
tax_totinc	money		128/s	Total price charged to customer, including all relevant taxes
tax_totex	money		129/s	Total price charged to customer, excluding all relevant taxes
tax_tr1	money		130/s	Total amount of Tax #1
tax_tr2	money		131/s	Total amount of Tax #2
tax_tr3	money		132/s	Total amount of Tax #3
linelocation	long		133/E
slcdt	date		134/s
physkey	string			Unique Physical key of this saleline
trackedid	string			Reference to the exact item if tracked items are being used
qtyqoh	number			Internal use only. Used to maintain stock levels where sales are fully distributed and visible at all sites all the time
regno	string			Contains a vehicle registration number if this item relates to a vehicle
commentscust	string			Line specific comments that are considered safe to show customers and are intended for customers
commentsint	string			Line specific customers that are NOT to be shown to customers and are reserved for retailer staff
picktid	number			User id who claimed to pick this item for web fulfilment
pickqty	number			Amount actually picked, which can differ to customers order quantity
picktotalprice	money			Total price to charge after picking.

Indexing

The primary key on this table is sid,seqnce. The field physkey is also a unique key, if present, although historic records may not contain values for this field

Reporting servers often add an index on pid to speed reports that select by product