|
id
|
int(10) unsigned
|
|
|
|
|
purchase_order_id
|
int(10) unsigned
|
|
|
|
|
part_id
|
int(10) unsigned
|
|
|
|
|
description
|
varchar(255)
|
|
|
|
|
part_number
|
varchar(100)
|
|
|
|
|
qty
|
int(10) unsigned
|
|
|
1
|
|
created_at
|
datetime
|
|
|
|
|
unit_price
|
decimal(10,2)
|
|
|
0.00
|
|
line_total
|
decimal(10,2)
|
|
|
0.00
|
|
line_type
|
varchar(20)
|
|
|
manual
|
|
item_name
|
varchar(191)
|
|
|
|
|
unit_cost
|
decimal(12,2)
|
|
|
0.00
|
|
total
|
decimal(12,2)
|
|
|
0.00
|
|
notes
|
varchar(255)
|
|
|
|