|
id
|
int(11)
|
|
|
|
|
date
|
date
|
|
|
|
|
category
|
varchar(100)
|
|
|
|
|
item_name
|
varchar(500)
|
|
|
|
|
required_date
|
date
|
|
|
|
|
product_code
|
varchar(100)
|
|
|
|
|
brand
|
varchar(200)
|
|
|
|
|
size
|
varchar(200)
|
|
|
|
|
note
|
text
|
|
|
|
|
quantity
|
decimal(10,2)
|
|
|
0.00
|
|
unit
|
varchar(50)
|
|
|
เธเธดเนเธ
|
|
price_before_vat
|
decimal(12,2)
|
|
|
0.00
|
|
price_with_vat
|
decimal(12,2)
|
|
|
0.00
|
|
total_price
|
decimal(12,2)
|
|
|
0.00
|
|
pr_number
|
varchar(100)
|
|
|
|
|
foreman
|
varchar(200)
|
|
|
|
|
job_number
|
varchar(100)
|
|
|
|
|
job_name
|
varchar(500)
|
|
|
|
|
vendor
|
varchar(300)
|
|
|
|
|
vendor_phone
|
varchar(50)
|
|
|
|
|
po_number
|
varchar(100)
|
|
|
|
|
order_by
|
varchar(200)
|
|
|
|
|
order_date
|
date
|
|
|
|
|
appointment_date
|
date
|
|
|
|
|
received_date
|
date
|
|
|
|
|
received_by
|
varchar(200)
|
|
|
|
|
invoice_number
|
varchar(200)
|
|
|
|
|
status
|
varchar(50)
|
|
|
pending
|
|
created_by
|
varchar(100)
|
|
|
|
|
created_date
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|