Salelines Database Table

Distrbuted Access: Application controlled

Fields

qty

#101, Datatype: Integer
Quantity of item purchased in measurement units for the product. Fieldpine does not sell fractions of a unit, rather it uses a smaller unit of measure. While a product may be priced as $x/Kg, it will probably be measured in grams.

totalprice

#102, Datatype: Money/Currency

serialno

#104, Datatype: String 64 bytes

sid

#105, Datatype: Integer

pid

#106, Datatype: Integer

unitprice

#107, Datatype: Money/Currency

pidflag

#108, Datatype: Integer
Type of product being sold, such as real product, financial or modifier

Possible Values

Value	Description
0	Product Id. Pid refers to products database
2	Product Id. Pid refers to products database
5	Product Modifier. Pid is a modifier code

rid

#109, Datatype: Integer

discid_1

#110, Datatype: Integer

discid_2

#111, Datatype: Integer

disc_1_p

#112, Datatype: Money/Currency

disc_2_p

#113, Datatype: Money/Currency

seqnce

#114, Datatype: Integer

qtyflags

#115, Datatype: Integer

linesource

#120, Datatype: Integer
How this item was selected into the sale

Possible Values

Value	Description
1	Barcode scan
2	Manually keyed barcode
3	Chosen from lookup
4	Weighed item by keyed id
6	PosCommand from keyed id
10	OpenApi call
11	QR scan
12	OCR
13	Optical recognition
14	Voice

pricecause

#121, Datatype: Integer
Indicator for which method(s) were used to derive the final price charged. See also PriceCauseNNN which are used when several techniques are combined.

Possible Values

Value	Description	Details
1	Specific offer handling	offerid
2	Reward program	programid
3	Kit/Combo applied	Productkits.kitid
4	Quantity Disount	qtydiscounts.qid
5	Global Store wide discounts
6	Discounts Manual
7	Pricemaps	pricemaps.pmid
8	Customer 'discpct'	requested percentage * 100
9	User action via PosCommand sale(line,set,price,NN,ZZ)	ZZ
10	Discount applied	discounts.discid
11	Discount voucher
12	User manually set price
13	Pricemaps entry setting ticketprice
14	Pricemaps optional applied
15	PriceOptions applied
16	Barcode OneOff aka Markdown
17	ProductVariant	pvariant
18	modifierpriceline
19	sale(pidvalue(...))
20	Generic item sold using scales
21	Item was returned. Price is from original sale price
256	02 variable barcode used
257	Modifier Item
258	Fieldpine Internal - create direct
259	Fieldpine Internal - from disk record
260	Fieldpine Internal - hiregroup unitprice
261	Fieldpine Internal - departments unitprice
262	Fieldpine Internal - setfield
263	Fieldpine Internal - setfield
264	Fieldpine Internal - from disk record
265	Fieldpine Internal - hiregroup unitprice
266	Fieldpine Internal - deparments unitprice
267	Fieldpine Internal - pricebands and formulas
268	Fieldpine Internal - pricebands and formulas
269	Fieldpine Internal - pricebands and formulas
270	Fieldpine Internal - pricebands and formulas
700	Fieldpine Internal - pricebandmap to column	PriceBandMap.bandid
768	Fieldpine Internal - downloadable C program used
769	Fieldpine Internal - downloadable Javascript program used
770	Fieldpine Internal - downloadable WebAssembly program used

pricecausedata