| id |
int(11)
|
|
|
|
| sent |
tinyint(1)
|
|
|
|
| datesend |
datetime
|
|
|
|
| vendor |
int(11)
|
|
|
|
| deleted_vendor_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| pur_request |
int(11)
|
|
|
|
| number |
int(11)
|
|
|
|
| prefix |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| number_format |
int(11)
|
|
|
|
| hash |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| datecreated |
datetime
|
|
|
|
| date |
date
|
|
|
|
| expirydate |
date
|
|
|
|
| currency |
int(11)
|
|
|
|
| subtotal |
decimal(15,2)
|
|
|
|
| total_tax |
decimal(15,2)
|
|
|
|
| total |
decimal(15,2)
|
|
|
|
| adjustment |
decimal(15,2)
|
|
|
|
| addedfrom |
int(11)
|
|
|
|
| status |
int(11)
|
|
|
|
| vendornote |
text
|
utf8mb4_general_ci
|
|
|
| adminnote |
text
|
utf8mb4_general_ci
|
|
|
| discount_percent |
decimal(15,2)
|
|
|
|
| discount_total |
decimal(15,2)
|
|
|
|
| discount_type |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| invoiceid |
int(11)
|
|
|
|
| invoiced_date |
datetime
|
|
|
|
| terms |
text
|
utf8mb4_general_ci
|
|
|
| reference_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| buyer |
int(11)
|
|
|
|
| billing_street |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| billing_city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| billing_state |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| billing_zip |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| billing_country |
int(11)
|
|
|
|
| shipping_street |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| shipping_city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| shipping_state |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| shipping_zip |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| shipping_country |
int(11)
|
|
|
|
| include_shipping |
tinyint(1)
|
|
|
|
| show_shipping_on_estimate |
tinyint(1)
|
|
|
|
| show_quantity_as |
int(11)
|
|
|
|
| pipeline_order |
int(11)
|
|
|
|
| is_expiry_notified |
int(11)
|
|
|
|
| acceptance_firstname |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| acceptance_lastname |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| acceptance_email |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| acceptance_date |
datetime
|
|
|
|
| acceptance_ip |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| signature |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| make_a_contract |
text
|
utf8mb4_general_ci
|
|
|
| currency_rate |
decimal(15,6)
|
|
|
|
| from_currency |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| to_currency |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| shipping_fee |
decimal(15,2)
|
|
|
|
