| id |
bigint(20)
|
|
|
|
| claim_id |
bigint(20)
|
|
|
|
| credit_note_entry_id |
bigint(20)
|
|
|
|
| voucher_type_id |
bigint(20)
|
|
|
|
| voucher_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| plan_hash |
char(64)
|
utf8mb4_unicode_ci
|
|
|
| status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| expected_ledger_rows |
smallint(5)
|
|
|
|
| actual_ledger_rows |
smallint(5)
|
|
|
|
| expected_audit_rows |
smallint(5)
|
|
|
|
| actual_audit_rows |
smallint(5)
|
|
|
|
| outstanding_id |
bigint(20)
|
|
|
|
| attempt_count |
int(10)
|
|
|
|
| requires_repair |
tinyint(1)
|
|
|
|
| last_error |
varchar(1000)
|
utf8mb4_unicode_ci
|
|
|
| prepared_by |
int(10)
|
|
|
|
| last_attempt_by |
int(10)
|
|
|
|
| posted_by |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| finance_year_id |
int(10)
|
|
|
|
| prepared_at |
datetime
|
|
|
|
| last_attempt_at |
datetime
|
|
|
|
| posted_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|