| id |
int(11)
|
|
|
|
| vendorid |
int(11)
|
|
|
|
| deleted_vendor_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| number |
int(11)
|
|
|
|
| prefix |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| number_format |
int(11)
|
|
|
|
| datecreated |
datetime
|
|
|
|
| date |
date
|
|
|
|
| adminnote |
text
|
utf8mb4_general_ci
|
|
|
| terms |
text
|
utf8mb4_general_ci
|
|
|
| vendornote |
text
|
utf8mb4_general_ci
|
|
|
| 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)
|
|
|
|
| discount_percent |
decimal(15,2)
|
|
|
|
| discount_total |
decimal(15,2)
|
|
|
|
| discount_type |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| 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_debit_note |
tinyint(1)
|
|
|
|
| show_quantity_as |
int(11)
|
|
|
|
| reference_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
