| id |
int(11)
|
|
|
|
| payable_no |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| source_type |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| source_id |
int(11)
|
|
|
|
| source_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| payee_type |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| payee_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| title |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| amount |
decimal(14,2)
|
|
|
|
| paid_amount |
decimal(14,2)
|
|
|
|
| currency |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| exchange_rate |
decimal(12,4)
|
|
|
|
| status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| due_date |
date
|
|
|
|
| paid_at |
datetime
|
|
|
|
| paid_by |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| payment_note |
text
|
utf8mb4_general_ci
|
|
|
| note |
text
|
utf8mb4_general_ci
|
|
|
| created_by |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
