| id |
int(11)
|
|
|
|
| entry_number |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| revenue_date |
date
|
|
|
|
| revenue_type |
enum('academic', 'contract', 'service', 'rental', 'training', 'other')
|
utf8mb4_unicode_ci
|
|
|
| account_code |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| payer_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| payer_type |
enum('student', 'department', 'external', 'other')
|
utf8mb4_unicode_ci
|
|
|
| description |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| amount |
decimal(14,2)
|
|
|
|
| vat_amount |
decimal(14,2)
|
|
|
|
| total_amount |
decimal(14,2)
|
|
|
|
| payment_method |
enum('cash', 'bank_transfer', 'check', 'other')
|
utf8mb4_unicode_ci
|
|
|
| reference_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| bank_account |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| journal_entry_id |
int(11)
|
|
|
|
| fiscal_year |
smallint(6)
|
|
|
|
| fiscal_period |
tinyint(4)
|
|
|
|
| status |
enum('draft', 'posted', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
