|
id
|
bigint(20) unsigned
|
|
|
|
|
sales_invoice_id
|
bigint(20) unsigned
|
|
|
|
|
warehouse_id
|
int(11)
|
|
|
|
|
part_id
|
bigint(20) unsigned
|
|
|
|
|
description_text
|
varchar(255)
|
|
|
|
|
description
|
varchar(255)
|
|
|
|
|
qty
|
decimal(15,2)
|
|
|
1.00
|
|
unit_price
|
decimal(15,2)
|
|
|
0.00
|
|
cost_price_snapshot
|
decimal(15,2)
|
|
|
0.00
|
|
discount_amount
|
decimal(15,2)
|
|
|
0.00
|
|
tax_amount
|
decimal(15,2)
|
|
|
0.00
|
|
line_total
|
decimal(15,2)
|
|
|
0.00
|
|
sold_at
|
datetime
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|