| id |
bigint(20)
|
|
|
|
| voucher_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| voucher_type |
tinyint(1)
|
|
|
|
| voucher_date |
date
|
|
|
|
| due_date |
date
|
|
|
|
| ledger_id |
int(10)
|
|
|
|
| voucher_type_id |
int(10)
|
|
|
|
| finance_year_id |
int(10)
|
|
|
|
| invoice_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| invoice_date |
date
|
|
|
|
| price |
decimal(12,2)
|
|
|
|
| total_discount |
decimal(12,2)
|
|
|
|
| applied_discount_category_id |
int(11)
|
|
|
|
| taxable_amount |
decimal(12,2)
|
|
|
|
| total_amount |
decimal(12,2)
|
|
|
|
| tax_amount |
decimal(12,2)
|
|
|
|
| freight_charges |
decimal(12,2)
|
|
|
|
| add_charges |
decimal(12,2)
|
|
|
|
| sgst_amount |
decimal(12,2)
|
|
|
|
| cgst_amount |
decimal(12,2)
|
|
|
|
| igst_amount |
decimal(12,2)
|
|
|
|
| cess_amount |
decimal(12,2)
|
|
|
|
| payment_status |
enum('Pending', 'Partial', 'Paid')
|
utf8mb4_unicode_ci
|
|
|
| narration |
text
|
utf8mb4_unicode_ci
|
|
|
| branch_id |
int(11)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
