| id |
bigint(20)
|
|
|
|
| ledger_name |
varchar(250)
|
utf8mb4_unicode_ci
|
|
|
| primary_group_id |
int(11)
|
|
|
|
| reverse_charge |
enum('NA', 'NO', 'YES')
|
utf8mb4_unicode_ci
|
|
|
| is_gst_applicable |
enum('NA', 'NO', 'YES')
|
utf8mb4_unicode_ci
|
|
|
| hsn_code_id |
bigint(20)
|
|
|
|
| trade_name |
varchar(250)
|
utf8mb4_unicode_ci
|
|
|
| contact_person_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| mail_to |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| address |
text
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| pincode |
char(6)
|
utf8mb4_unicode_ci
|
|
|
| state_id |
smallint(5)
|
|
|
|
| district_id |
int(11)
|
|
|
|
| country_id |
smallint(5)
|
|
|
|
| customer_type_id |
tinyint(4)
|
|
|
|
| caste_category |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| gender |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| gst_verified |
enum('NA', 'NO', 'YES')
|
utf8mb4_unicode_ci
|
|
|
| gst_registration_types_id |
int(11)
|
|
|
|
| gst_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| pan_number |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| company_contact_number |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| whatsapp_number |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| mobile |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| email_id |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| website |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| tags |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| party_type_id_del |
int(11)
|
|
|
|
| party_cat_id |
int(10)
|
|
|
|
| parent_group_id |
bigint(20)
|
|
|
|
| account_group_id |
int(11)
|
|
|
|
| led_group_id |
bigint(20)
|
|
|
|
| credit_days |
int(10)
|
|
|
|
| credit_limit |
decimal(18,0)
|
|
|
|
| auto_block_on_overdue |
tinyint(1)
|
|
|
|
| delivery_source |
enum('NA', 'PLANT', 'GODOWN')
|
utf8mb4_unicode_ci
|
|
|
| delivery_source_id |
int(11)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| module |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| ledger_key_id |
int(10)
|
|
|
|
| voucher_type_id |
int(10)
|
|
|
|
| tds_section_code |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| ledger_type |
enum('SYSTEM', 'BANK', 'TAX', 'CHARGES', 'DEBTOR', 'CREDITOR', 'EMPLOYEE', 'OTHER', 'CASH', 'INCOME', 'EXPENSE', 'SERVICE')
|
utf8mb4_unicode_ci
|
|
|
| sale_order |
enum('NA', 'REQUEST', 'CONFIRM')
|
utf8mb4_unicode_ci
|
|
|
| charge_kind |
enum('FREIGHT', 'DISCOUNT', 'PACKING', 'ROUND_OFF', 'OTHER')
|
utf8mb4_unicode_ci
|
|
|
| is_cash_ledger_override_id |
enum('Y', 'N')
|
utf8mb4_unicode_ci
|
|
|
| system_ledger_applies_to |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| is_carrier_agent |
enum('Y', 'N')
|
utf8mb4_unicode_ci
|
|
|
| is_default_carrier_agent |
enum('Y', 'N')
|
utf8mb4_unicode_ci
|
|
|
| finance_year_id |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
