| id |
int(11)
|
|
|
|
| purchase_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| invoice_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| supplier_id |
int(11)
|
|
|
|
| purchase_date |
date
|
|
|
|
| payment_type |
enum('contado', 'credito')
|
utf8mb4_unicode_ci
|
|
|
| payment_method |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| cash_session_id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| subtotal |
decimal(12,2)
|
|
|
|
| tax_amount |
decimal(12,2)
|
|
|
|
| discount_amount |
decimal(12,2)
|
|
|
|
| total |
decimal(12,2)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('completed', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| supplier_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| supplier_id_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| due_date |
date
|
|
|
|
| discount_total |
decimal(12,2)
|
|
|
|
| tax_total |
decimal(12,2)
|
|
|
|
| grand_total |
decimal(12,2)
|
|
|
|