Skip to content

purchase_order_lines

Items on each purchase order. One row is one stock item on one order.

One row is
one stock item on one order
Columns
6
Rows in Sample
81,350
Rows in Standard
81,350
Rows in Full
81,350

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
po_line_idkeyintegerUnique id for the row.
purchase_order_idintegerLinks to purchase_orders.
item_idintegerThe stock item. Links to inventory_items.
quantitydecimalUnits ordered and received.0.1 to 26,231
unit_costdecimalCost per unit in dollars.0.7 to 157.42
line_amountdecimalQuantity times unit cost.5.03 to 93,544.7

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.

po_line_idpurchase_order_iditem_idquantityunit_costline_amount
60000016000015010305.89.52905.1
60000026000015011252.91.3328.77
60000036000015012602.38.45059.32
6000004600001501324.831768.8
600000560000250145.1128652.8

Download from Kaggle