| id |
int(11)
|
|
|
|
| date |
date
|
|
|
|
| category |
varchar(225)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| amount |
decimal(10,2)
|
|
|
|
| vat |
decimal(10,2)
|
|
|
|
| total |
decimal(10,2)
|
|
|
|
| reference_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| status |
enum('pending', 'partial', 'completed')
|
utf8mb4_general_ci
|
|
|
| flow_type |
enum('inflow', 'outflow')
|
utf8mb4_general_ci
|
|
|
| petty_cash |
tinyint(1)
|
|
|
|
| prepaid_expense |
tinyint(1)
|
|
|
|
| prepaid_start_date |
date
|
|
|
|
| prepaid_end_date |
date
|
|
|
|
| prepaid_write_off_date |
date
|
|
|
|
| paid_from_advance |
tinyint(1)
|
|
|
|
| trip_id |
int(11)
|
|
|
 Browse foreign values
|
| company |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| remarks |
text
|
utf8mb4_general_ci
|
|
|
| document_url |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| trn |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| supplier |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| truck_number |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| employee_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
