| id |
bigint(20)
|
|
|
|
| scheme_code |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| scheme_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| scheme_type |
enum('TRADE_DISCOUNT', 'VOLUME_DISCOUNT', 'ANNUAL_DISCOUNT', 'TARGET_ACHIEVEMENT', 'EARLY_PAYMENT', 'SETTLEMENT', 'PERFORMANCE', 'RENEWAL', 'COMMERCIAL_REBATE', 'OTHER')
|
utf8mb4_unicode_ci
|
|
|
| calculation_method |
enum('PERCENTAGE', 'FIXED', 'SLAB')
|
utf8mb4_unicode_ci
|
|
|
| turnover_basis |
enum('TAXABLE_VALUE', 'NET_INVOICE_VALUE', 'COLLECTION_VALUE')
|
utf8mb4_unicode_ci
|
|
|
| claim_frequency |
enum('MONTHLY', 'QUARTERLY', 'HALF_YEARLY', 'ANNUAL', 'ON_DEMAND')
|
utf8mb4_unicode_ci
|
|
|
| valid_from |
date
|
|
|
|
| valid_to |
date
|
|
|
|
| minimum_turnover |
decimal(18,2)
|
|
|
|
| maximum_turnover |
decimal(18,2)
|
|
|
|
| target_amount |
decimal(18,2)
|
|
|
|
| default_discount_rate |
decimal(9,4)
|
|
|
|
| fixed_discount_amount |
decimal(18,2)
|
|
|
|
| maximum_discount_amount |
decimal(18,2)
|
|
|
|
| return_treatment |
enum('SUBTRACT_POSTED', 'IGNORE')
|
utf8mb4_unicode_ci
|
|
|
| agreement_required |
tinyint(1)
|
|
|
|
| invoice_link_required |
tinyint(1)
|
|
|
|
| gst_treatment_mode |
enum('AUTO', 'GST_CREDIT_NOTE', 'COMMERCIAL_CREDIT_NOTE', 'FINANCIAL_ADJUSTMENT')
|
utf8mb4_unicode_ci
|
|
|
| itc_confirmation_required |
tinyint(1)
|
|
|
|
| approval_required |
tinyint(1)
|
|
|
|
| allow_partial_claim |
tinyint(1)
|
|
|
|
| allow_multiple_claims_per_period |
tinyint(1)
|
|
|
|
| discount_ledger_id |
bigint(20)
|
|
|
|
| priority |
smallint(5)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| branch_id |
int(10)
|
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(10)
|
|
|
|
| updated_by |
int(10)
|
|
|
|
| deleted_by |
int(10)
|
|
|
|
| deleted_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| discount_basis_mode |
enum('TAXABLE_BASE', 'DOCUMENT_VALUE')
|
utf8mb4_unicode_ci
|
|
|
