|
id
|
int(11)
|
|
|
|
|
date
|
date
|
|
|
|
|
product_id
|
int(11)
|
|
|
|
|
sale_item_id
|
int(11)
|
|
|
|
|
sale_id
|
int(11)
|
|
|
|
|
purchase_item_id
|
int(11)
|
|
|
|
|
quantity
|
decimal(15,4)
|
|
|
|
|
purchase_net_unit_cost
|
decimal(25,4)
|
|
|
|
|
purchase_unit_cost
|
decimal(25,4)
|
|
|
|
|
sale_net_unit_price
|
decimal(25,4)
|
|
|
|
|
sale_unit_price
|
decimal(25,4)
|
|
|
|
|
quantity_balance
|
decimal(15,4)
|
|
|
|
|
inventory
|
tinyint(1)
|
|
|
0
|
|
overselling
|
tinyint(1)
|
|
|
0
|
|
option_id
|
int(11)
|
|
|
|
|
purchase_id
|
int(11)
|
|
|
|
|
transfer_id
|
int(11)
|
|
|
|