| id |
bigint(20)
|
|
|
|
| spent_on |
date
|
|
|
|
| posted_by |
varchar(96)
|
utf8mb4_general_ci
|
|
|
| posted_name |
varchar(96)
|
utf8mb4_general_ci
|
|
|
| branch |
varchar(48)
|
utf8mb4_general_ci
|
|
|
| vendor |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| category |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| amount |
decimal(12,2)
|
|
|
|
| pay_method |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| notes |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| image_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| ai_used |
tinyint(4)
|
|
|
|
| created |
datetime
|
|
|
|
| edited_by |
varchar(96)
|
utf8mb4_general_ci
|
|
|
| edited_at |
datetime
|
|
|
|
| direction |
varchar(4)
|
utf8mb4_general_ci
|
|
|
| etims |
tinyint(4)
|
|
|
|
| doc_no |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| account |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| details |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| vat_treatment |
varchar(8)
|
utf8mb4_general_ci
|
|
|
| net |
decimal(12,2)
|
|
|
|
| vat |
decimal(12,2)
|
|
|
|
| receipt_id |
varchar(40)
|
utf8mb4_general_ci
|
|
|
