| id |
int(11)
|
|
|
|
| invoice_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| debtor_type |
enum('student', 'department', 'external', 'other')
|
utf8mb4_unicode_ci
|
|
|
| debtor_name |
varchar(300)
|
utf8mb4_unicode_ci
|
|
|
| debtor_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| account_code |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| description |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| invoice_date |
date
|
|
|
|
| due_date |
date
|
|
|
|
| amount |
decimal(14,2)
|
|
|
|
| paid_amount |
decimal(14,2)
|
|
|
|
| status |
enum('pending', 'partial', 'paid', 'overdue', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| revenue_account |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| journal_entry_id |
int(11)
|
|
|
|
| payment_entry_id |
int(11)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
