| id |
bigint(20)
|
|
|
|
| expense_invoice_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| expense_invoice_date |
date
|
|
|
|
| voucher_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| voucher_type_id |
bigint(20)
|
|
|
|
| entry_mode |
enum('Cash', 'Party')
|
utf8mb4_unicode_ci
|
|
|
| urd |
enum('Y', 'N')
|
utf8mb4_unicode_ci
|
|
|
| voucher_date |
date
|
|
|
|
| voucher_time |
time
|
|
|
|
| due_date |
date
|
|
|
|
| ledger_id |
int(10)
|
|
|
|
| party_cat_id |
int(11)
|
|
|
|
| amount |
decimal(10,2)
|
|
|
|
| sgst_amount |
decimal(10,2)
|
|
|
|
| cgst_amount |
decimal(10,2)
|
|
|
|
| igst_amount |
decimal(10,2)
|
|
|
|
| cess_amount |
decimal(10,2)
|
|
|
|
| round_off |
decimal(12,2)
|
|
|
|
| invoice_amount |
decimal(12,2)
|
|
|
|
| payment_status |
enum('Pending', 'Paid', 'Partial')
|
utf8mb4_unicode_ci
|
|
|
| narration |
text
|
utf8mb4_unicode_ci
|
|
|
| receiver_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| receiver_contact_number |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| branch_id |
int(11)
|
|
|
|
| user_id |
bigint(20)
|
|
|
|
| modified_user_id |
bigint(20)
|
|
|
|
| finance_year_id |
bigint(20)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| posting_status |
enum('Pending', 'Posted')
|
utf8mb4_unicode_ci
|
|
|
