| id |
bigint(20)
|
|
|
|
| scheme_id |
bigint(20)
|
|
|
Browse foreign values
|
| ledger_id |
bigint(20)
|
|
|
|
| agreement_no |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| agreement_date |
date
|
|
|
|
| valid_from |
date
|
|
|
|
| valid_to |
date
|
|
|
|
| customer_target_amount |
decimal(18,2)
|
|
|
|
| custom_discount_rate |
decimal(9,4)
|
|
|
|
| custom_fixed_discount_amount |
decimal(18,2)
|
|
|
|
| document_path |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('DRAFT', 'ACTIVE', 'EXPIRED', 'CANCELLED')
|
utf8mb4_unicode_ci
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| branch_id |
int(10)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(10)
|
|
|
|
| updated_by |
int(10)
|
|
|
|
| cancelled_by |
int(10)
|
|
|
|
| cancelled_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|