Skip to content

transaction_lines

The items on each sale. One row is one product on one sale.

One row is
one product on one sale
Columns
7
Rows in Sample
759,979
Rows in Standard
7,589,538
Rows in Full
75,761,789

Columns

ColumnTypeWhat it holdsValues or range
line_idkeyintegerUnique id for the row.
transaction_idintegerThe register sale. Links to transactions.
product_idintegerThe item sold to guests. Links to products.
quantityintegerUnits sold.1 to 9
unit_pricedecimalPrice per unit in dollars.3.25 to 144.99
line_amountdecimalQuantity times unit price.3.25 to 778
pos_category_codetextCategory code exactly as the register recorded it at the time.

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

line_idtransaction_idproduct_idquantityunit_priceline_amountpos_category_code
30104870210029280710242155FB-SNK
30104870310029280710239155FB-SNK
30104904610029290710147112.512.5FB-ENT
30104904710029290710154114.514.5FB-ENT
3010490481002929071016227.515FB-KID

Download from Kaggle