| id |
int(11)
|
|
|
|
| entry_number |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| entry_date |
date
|
|
|
|
| description |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| reference_type |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| reference_id |
int(11)
|
|
|
|
| reference_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| fiscal_year |
smallint(6)
|
|
|
|
| fiscal_period |
tinyint(4)
|
|
|
|
| total_debit |
decimal(14,2)
|
|
|
|
| total_credit |
decimal(14,2)
|
|
|
|
| status |
enum('draft', 'posted', 'reversed')
|
utf8mb4_unicode_ci
|
|
|
| approval_status |
enum('pending', 'approved', 'rejected')
|
utf8mb4_unicode_ci
|
|
|
| approval_required |
tinyint(1)
|
|
|
|
| reviewed_by |
int(11)
|
|
|
|
| reviewed_at |
timestamp
|
|
|
|
| review_notes |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| posted_by |
int(11)
|
|
|
|
| posted_at |
timestamp
|
|
|
|
| reversed_entry |
int(11)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
