dev.surenasolutions.in / 127.0.0.1 / surena_crm

There are no favourite tables.

New
information_schema
mysql
payitsea_jnablr
performance_schema
phpmyadmin
rajkamal_crm
sgm_crm
surena
- surena_code_editor
- surena_crm
- edbroad
  - surena_edbroad_1
  - surena_edbroad_old
test

Customise appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		surena_crm alert_logs
id : bigint(20) unsigned
alert_type : varchar(50)
alert_message : text
triggered_on : date
item_id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
invoice_id : bigint(20) unsigned
lead_id : bigint(20) unsigned
branch_id : int(10) unsigned
user_id : bigint(20) unsigned
alert_level : enum('info','warning','critical')
is_read : tinyint(1)
resolved : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm api_student
id : bigint(20)
name : varchar(100)
age : int(11)
grade : varchar(20)

v		surena_crm audit_logs
id : bigint(20) unsigned
entity_type : varchar(64)
entity_id : bigint(20) unsigned
version : int(10) unsigned
event_type : enum('create','update','delete','reverse','post','unpost','approve','reject')
reason : varchar(255)
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
changed_by : int(10) unsigned
changed_at : datetime
changed_ip : varbinary(16)
snapshot : longtext
diff : longtext
aux : longtext
hash : char(64)
prev_hash : char(64)
invoice_no : varchar(64)
voucher_no : varchar(64)
voucher_date : date

v		surena_crm auth_group
id : int(11)
name : varchar(150)

v		surena_crm auth_group_permissions
id : bigint(20)
group_id : int(11)
permission_id : int(11)

v		surena_crm auth_permission
id : int(11)
name : varchar(255)
content_type_id : int(11)
codename : varchar(100)

v		surena_crm auth_user
id : int(11)
password : varchar(128)
last_login : datetime(6)
is_superuser : tinyint(1)
username : varchar(150)
first_name : varchar(150)
last_name : varchar(150)
email : varchar(254)
is_staff : tinyint(1)
is_active : tinyint(1)
date_joined : datetime(6)

v		surena_crm auth_user_groups
id : bigint(20)
user_id : int(11)
group_id : int(11)

v		surena_crm auth_user_user_permissions
id : bigint(20)
user_id : int(11)
permission_id : int(11)

v		surena_crm bank_master
id : int(11)
bank_code : varchar(15)
bank_name : varchar(120)
short_name : varchar(50)
swift_code : varchar(20)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm call_followup_master
id : bigint(20)
customer_id : bigint(20)
customer_name : varchar(255)
mobile_number : varchar(20)
call_type : enum('PROMOTION','PENDING_DUE')
due_amount : decimal(15,2)
assigned_agent : bigint(20)
scheduled_date : date
call_status : enum('PENDING','CONNECTED','NOT_REACHABLE','FOLLOW_UP','PAID','NOT_INTERESTED','PROMISED_TO_PAY')
remarks : text
next_followup_date : date
miss_count : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm caste_category
id : int(11)
category_name : varchar(100)
active_status : tinyint(1)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		surena_crm cnc_jobs
id : int(10) unsigned
branch_id : int(10) unsigned
job_date : date
shift : enum('Morning','Evening','Night')
operator_code : varchar(32)
operator_name : varchar(100)
machine_name : varchar(100)
job_no : varchar(50)
notes : varchar(255)
delete_status : tinyint(1)
created_by : int(11)
created_at : timestamp
updated_at : timestamp

v		surena_crm cnc_job_parts
id : int(10) unsigned
job_id : int(10) unsigned
part_name : varchar(150)
qty : int(10) unsigned
operation_remark : varchar(200)
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm contra_vouchers
id : bigint(20) unsigned
voucher_no : varchar(50)
voucher_type_id : int(10)
voucher_date : date
contra_type : enum('BANK_TO_BANK','BANK_TO_CASH','CASH_TO_BANK','CASH_TO_CASH')
from_account_id : bigint(20) unsigned
to_account_id : bigint(20) unsigned
instrument_type : enum('CASH','CHEQUE','NEFT','RTGS','IMPS','UPI','DD','OTHERS','ONLINE')
bank_name : varchar(100)
instrument_number : varchar(100)
amount : decimal(18,2)
narration : text
branch_id : int(10) unsigned
finance_year_id : int(11)
created_by : bigint(20) unsigned
updated_by : bigint(20)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm coupon_limits
coupon_code : varchar(64)
max_global_uses : int(11)
max_uses_per_customer : int(11)
is_scratch : tinyint(1)
valid_from : date
valid_to : date

v		surena_crm coupon_redemptions
id : bigint(20)
coupon_code : varchar(64)
customer_id : bigint(20)
rule_id : bigint(20)
order_ref : varchar(100)
qty : int(11)
amount : decimal(12,2)
branch_id : int(11)
redeemed_at : datetime

v		surena_crm crm_brochure_queue
id : int(11)
enquiry_id : int(11)
medium : enum('WHATSAPP','EMAIL','BOTH')
template_id : int(11)
status : enum('PENDING','SENT','FAILED')
scheduled_at : datetime
sent_at : datetime
created_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm crm_customer_role
id : int(11)
role_name : varchar(255)
is_active : tinyint(4)

v		surena_crm crm_enquiry_links_old)
id : int(11)
enquiry_id : int(11)
link_type : enum('QUOTE','BROCHURE','VISIT')
target_id : int(11)
created_by : int(11)
created_at : datetime

v		surena_crm crm_leads
id : int(11)
lead_type : enum('Sales Lead','Service Lead')
customer_company : varchar(150)
contact_person : varchar(120)
phone : varchar(20)
whatsapp : varchar(20)
address : varchar(255)
city : varchar(100)
pincode : varchar(10)
source : varchar(100)
stage : varchar(50)
next_followup : date
customer_role : varchar(100)
next_steps : varchar(255)
description : text
next_action : enum('NONE','SEND_QUOTATION','SEND_BROCHURE','SITE_VISIT')
routed_at : datetime
auto_routed : tinyint(1)
auto_route_json : longtext
auto_route_conf : decimal(4,2)
handled_by : int(11)
branch_id : int(11)
status : enum('Active','Converted','Lost','Closed')
created_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm crm_lead_sources
id : int(10) unsigned
source_name : varchar(50)
background_class : varchar(50)
badge_bg_color : varchar(15)
badge_text_color : varchar(15)
badge_color : varchar(7)
is_active : tinyint(1)

v		surena_crm crm_lead_stages
id : int(10) unsigned
stage_name : varchar(50)
background_class : varchar(50)
badge_bg_color : varchar(15)
badge_text_color : varchar(15)
badge_color : varchar(7)
is_active : tinyint(1)

v		surena_crm crm_quotations
id : int(11)
enquiry_id : int(11)
customer_company : varchar(150)
contact_phone : varchar(20)
city : varchar(100)
stage : enum('DRAFT','SENT','ACCEPTED','REJECTED')
remarks : text
created_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm crm_service_details
id : int(11)
lead_id : int(11)
service_type : enum('Installation','Repair','Maintenance','Demo','Other')
machine_model : varchar(120)
serial_no : varchar(60)
preferred_visit_date : date
technician_id : int(11)
priority : enum('Low','Medium','High','Urgent')
warranty : enum('IN','OUT','NA')
notes : text
created_at : datetime
updated_at : datetime

v		surena_crm crm_service_types
id : int(10) unsigned
type_name : varchar(50)
is_active : tinyint(1)

v		surena_crm crm_tasks
id : int(11)
entity_type : enum('ENQUIRY','QUOTE','VISIT','BROCHURE')
entity_id : int(11)
task_type : enum('CALL','SEND_QUOTATION','SEND_BROCHURE','SITE_VISIT','REMINDER')
title : varchar(160)
due_at : datetime
assigned_to : int(11)
status : enum('OPEN','IN_PROGRESS','DONE','CANCELLED')
notes : text
branch_id : int(11)
created_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm crm_tickets
id : bigint(20) unsigned
ticket_no : varchar(30)
ticket_type : enum('SALES','SERVICE')
entry_type : varchar(10)
entry_date : date
ledger_id : tinyint(4)
customer_name : varchar(150)
contact_person : varchar(100)
phone : varchar(20)
whatsapp : varchar(20)
city : varchar(100)
pincode : varchar(10)
address : varchar(255)
sales_person_id : int(10)
other_reference : varchar(50)
reference_notes : longtext
is_exchange : enum('Y','N')
new_machine_price : decimal(10,2)
total_exchange : decimal(10,2)
net_payable : decimal(10,2)
exchange_status : varchar(50)
inspection_by : int(10)
pickup_date : date
pickup_location : varchar(50)
exchange_remark : longtext
status_id : int(10) unsigned
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
company_id : int(10) unsigned
created_by : int(10) unsigned
updated_by : int(10) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm crm_tickets_exchange_machine_details
id : int(11)
ticket_id : int(11)
machine_name : varchar(250)
model : varchar(200)
year : varchar(10)
machine_condition : varchar(50)
expected_value : decimal(10,2)
approved_value : decimal(10,2)
is_delete : tinyint(1)

v		surena_crm crm_ticket_sales
ticket_id : bigint(20) unsigned
source_id : int(10) unsigned
stage_id : int(10) unsigned
next_followup_date : date
plan_date : date
customer_role : int(11)
suggested_action : enum('Visit','Revisit','Call','Email','Quotation','Brochure','Price')
assignee_id : int(10) unsigned
description : text

v		surena_crm crm_ticket_service
ticket_id : bigint(20) unsigned
service_type_id : int(10) unsigned
machine_model : varchar(150)
serial_no : varchar(100)
preferred_visit_date : date
technician_id : int(10) unsigned
priority : enum('LOW','MEDIUM','HIGH')
notes : text
visit_address : varchar(255)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm crm_ticket_status
id : int(10) unsigned
status_code : varchar(30)
status_label : varchar(50)
badge_bg_color : varchar(15)
badge_text_color : varchar(15)
badge_color : varchar(7)
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm crm_ticket_status_old
id : int(10) unsigned
status_code : varchar(30)
status_label : varchar(50)
background_class : varchar(50)
is_active : tinyint(1)

v		surena_crm crm_visits
id : int(11)
enquiry_id : int(11)
scheduled_at : datetime
address : varchar(255)
city : varchar(100)
pincode : varchar(10)
assigned_to : int(11)
status : enum('PLANNED','STARTED','DONE','CANCELLED')
notes : text
created_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm customer_segment
id : int(10) unsigned
title : varchar(100)
description : text
is_default : enum('Y','N')
active_status : tinyint(1)
branch_id : int(11)
created_by : int(11)
modified_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm daily_financial_summary
summary_date : date
branch_id : int(11)
total_sales : decimal(12,2)
total_purchases : decimal(12,2)
total_receipts : decimal(12,2)
total_payments : decimal(12,2)

v		surena_crm daily_ledger_balance_del
id : bigint(20) unsigned
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
balance_date : date
ledger_id : bigint(20) unsigned
ledger_name : varchar(250)
led_group_id : bigint(20) unsigned
group_title : varchar(100)
root_group_id : bigint(20) unsigned
root_group_title : varchar(100)
main_group : varchar(50)
sub_group : varchar(50)
entry_side : enum('DR','CR')
opening_balance : decimal(18,2)
day_debit : decimal(18,2)
day_credit : decimal(18,2)
closing_balance : decimal(18,2)
created_at : datetime
updated_at : datetime

v		surena_crm daily_ledger_movement
id : bigint(20) unsigned
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
balance_date : date
ledger_id : bigint(20) unsigned
ledger_name : varchar(250)
led_group_id : bigint(20) unsigned
group_title : varchar(100)
root_group_id : bigint(20) unsigned
root_group_title : varchar(100)
main_group : varchar(50)
sub_group : varchar(50)
entry_side : enum('DR','CR')
opening_debit : decimal(18,2)
opening_credit : decimal(18,2)
day_debit : decimal(18,2)
day_credit : decimal(18,2)
closing_debit : decimal(18,2)
closing_credit : decimal(18,2)
closing_balance : decimal(18,2)
created_at : datetime
updated_at : datetime

v		surena_crm daily_ledger_movement_old
id : bigint(20) unsigned
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
balance_date : date
ledger_id : bigint(20) unsigned
ledger_name : varchar(250)
led_group_id : bigint(20) unsigned
group_title : varchar(100)
root_group_id : bigint(20) unsigned
root_group_title : varchar(100)
main_group : varchar(50)
sub_group : varchar(50)
entry_side : enum('DR','CR')
opening_debit : decimal(18,2)
opening_credit : decimal(18,2)
day_debit : decimal(18,2)
day_credit : decimal(18,2)
closing_debit : decimal(18,2)
closing_credit : decimal(18,2)
closing_balance : decimal(18,2)
created_at : datetime
updated_at : datetime

v		surena_crm dashboard_monthly_summary
summary_year : int(11)
summary_month : int(11)
total_sales : decimal(12,2)
total_purchases : decimal(12,2)
total_sales_return : decimal(12,2)
total_purchase_return : decimal(12,2)
total_revenue : decimal(12,2)
total_expenditure : decimal(12,2)
total_profit : decimal(12,2)
created_at : datetime

v		surena_crm dashboard_summary_snapshot
id : tinyint(1)
total_sales : decimal(12,2)
total_purchases : decimal(12,2)
total_sales_return : decimal(12,2)
total_purchase_return : decimal(12,2)
total_revenue : decimal(12,2)
total_expenditure : decimal(12,2)
total_profit : decimal(12,2)
top_customer : varchar(255)
top_item : varchar(255)
total_customers : int(11)
total_suppliers : int(11)
total_visits : int(11)
total_leads : int(11)
total_employees : int(11)
summary_date : date
last_updated : datetime

v		surena_crm dashboard_yearly_summary
summary_year : int(11)
total_sales : decimal(14,2)
total_purchases : decimal(14,2)
total_sales_return : decimal(14,2)
total_purchase_return : decimal(14,2)
total_revenue : decimal(14,2)
total_expenditure : decimal(14,2)
total_profit : decimal(14,2)
created_at : datetime

v		surena_crm date_range_filters
id : tinyint(3) unsigned
filter_name : varchar(50)
query_value : varchar(50)
is_active : tinyint(1)

v		surena_crm discount_categories
id : int(11)
entry_type : enum('Discounts','Adjustments')
ledger_id : int(11)
category_type : enum('Fixed','Percentage')
category_value : decimal(10,2)
is_full_cash_discount : enum('Y','N')
is_proportionate : enum('Y','N')
item_wise_proportionate : enum('Y','N')
is_delete : enum('Y','N')
created_at : timestamp
modified_at : timestamp

v		surena_crm discount_rule_targets
target_id : bigint(20)
discount_rule_id : bigint(20)
target_type : enum('PRODUCT','CATEGORY','BRAND','GLOBAL','CUSTOMER_SEGMENT','CUSTOMER')
target_ref_id : bigint(20)
customer_segment_id : varchar(11)
discount_value : decimal(12,2)
operator_override : enum('PERCENTAGE','FLAT')
min_qty_override : decimal(12,4)
min_amount_override : decimal(12,4)
combine_override : enum('ADD','HIGHEST_ONLY','SEQUENTIAL','PRIORITY')
priority_override : int(11)
branch_id : int(11)
delete_status : int(10)
created_at : datetime
updated_at : datetime

v		surena_crm dispatch_details
id : bigint(20) unsigned
sales_entry_id : bigint(20) unsigned
voucher_type_id : int(11)
delivery_note_no : varchar(50)
dispatch_doc_no : varchar(50)
dispatch_date : date
dispatched_through : varchar(100)
destination : varchar(255)
carrier_ledger_id : int(20)
bill_of_lading : varchar(100)
lr_rr_date : date
motor_vehicle_no : varchar(50)
buyer_order_no : varchar(20)
buyer_date : date
branch_id : int(10) unsigned
created_by : int(10) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm django_admin_log
id : int(11)
action_time : datetime(6)
object_id : longtext
object_repr : varchar(200)
action_flag : smallint(5) unsigned
change_message : longtext
content_type_id : int(11)
user_id : int(11)

v		surena_crm django_content_type
id : int(11)
app_label : varchar(100)
model : varchar(100)

v		surena_crm django_migrations
id : bigint(20)
app : varchar(255)
name : varchar(255)
applied : datetime(6)

v		surena_crm django_session
session_key : varchar(40)
session_data : longtext
expire_date : datetime(6)

v		surena_crm dynamic_sales_price_competitor_prices
competitor_price_id : bigint(20) unsigned
item_id : bigint(20) unsigned
competitor_name : varchar(100)
price : decimal(15,2)
branch_id : int(10) unsigned
last_checked : timestamp
is_active : tinyint(1)
delete_status : tinyint(1)
created_by : int(10) unsigned
updated_by : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm dynamic_sales_price_competitor_rules
id : int(10) unsigned
item_id : int(10) unsigned
strategy : enum('MATCH_LOWEST','UNDERCUT_BY_FIXED','UNDERCUT_BY_PERCENT')
undercut_value : decimal(10,2)
branch_id : int(10) unsigned
is_active : tinyint(1)
delete_status : tinyint(1)
created_by : int(10) unsigned
updated_by : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm dynamic_sales_price_configs
id : bigint(20) unsigned
branch_id : int(10) unsigned
item_id : bigint(20) unsigned
brand_id : int(10) unsigned
category_id : int(10) unsigned
pricing_strategy : enum('MRP','COST_PRICE','AVERAGE_SALES_PRICE')
costing_method : enum('FIFO','LIFO','WAVG','MOVING_AVG')
min_margin_percent : decimal(6,2)
allow_competitor_price : tinyint(1)
competitor_alignment_mode : enum('IGNORE','MATCH_LOWEST','BEAT_LOWEST','WITHIN_RANGE')
competitor_floor_margin_pct : decimal(6,2)
stock_low_threshold : int(11)
stock_high_threshold : int(11)
stock_low_markup_pct : decimal(6,2)
stock_high_markdown_pct : decimal(6,2)
average_sales_lookback_days : int(11)
rounding_rule : enum('NONE','ROUND','CEIL','FLOOR','.99')
effective_from : date
effective_to : date
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm dynamic_sales_price_discounts
id : int(10) unsigned
rule_name : varchar(100)
rule_type : enum('PRODUCT','CATEGORY','BRAND','GLOBAL')
reference_id : int(10) unsigned
discount_type : enum('FLAT','PERCENT')
discount_value : decimal(10,2)
valid_from : date
valid_to : date
branch_id : int(10) unsigned
is_active : tinyint(1)
delete_status : tinyint(1)
created_by : int(10) unsigned
updated_by : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm dynamic_sales_price_margin_rules
id : int(10) unsigned
rule_type : enum('PRODUCT','CATEGORY','BRAND','GLOBAL')
reference_id : int(10) unsigned
margin_percent : decimal(5,2)
branch_id : int(10) unsigned
is_active : tinyint(1)
delete_status : tinyint(1)
created_by : int(10) unsigned
updated_by : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm einvoices_eway_bill
id : bigint(20)
entry_id : bigint(20)
voucher_type_id : bigint(20)
invoice_type : varchar(20)
ack_no : varchar(50)
ack_date : varchar(50)
irn : varchar(64)
status : varchar(10)
signed_invoice : longtext
signed_qr_code : longtext
ewb_no : varchar(50)
ewb_date : varchar(50)
ewb_valid_till : varchar(50)
remarks : varchar(255)
e_invoice_send_data : longtext
e_invoice_response : longtext
e_way_send_data : longtext
e_way_response : longtext
e_way_cancelled_date : varchar(50)
e_invoice_cancelled_date : varchar(50)
e_way_allow_cancel : enum('Y','N')
e_invoice_allow_cancel : enum('Y','N')
active : enum('Y','N')
created_by : varchar(10)
modified_by : varchar(10)
created_at : timestamp
updated_at : timestamp

v		surena_crm einvoice_eway_cancellation
id : int(11)
invoice_type : varchar(50)
voucher_type_id : int(11)
entry_id : int(11)
irn_no : varchar(50)
ewb_no : varchar(50)
cancelled_date : varchar(50)
added_by : int(11)
added_at : timestamp

v		surena_crm email_smtp_settings
id : int(11) unsigned
mail_driver : varchar(20)
mail_from_name : varchar(100)
mail_from_email : varchar(100)
enable_queue : tinyint(1)
host : varchar(100)
port : int(5)
username : varchar(100)
password : varchar(255)
encryption : enum('ssl','tls','none')
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm employees
id : int(11) unsigned
employee_code : varchar(50)
photo : varchar(100)
full_name : varchar(100)
designation : varchar(100)
email : varchar(100)
mobile_number : varchar(15)
date_of_joining : date
branch_id : int(11) unsigned
user_role_id : int(11) unsigned
is_sales_person : tinyint(1)
is_telecaller : tinyint(4)
reporting_manager_id : int(11) unsigned
login_user_id : int(11) unsigned
address : text
city : varchar(100)
state_id : int(11) unsigned
country_id : int(11) unsigned
pincode : varchar(10)
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm exchange_items
id : int(11)
item_name : varchar(255)
item_code : varchar(50)
item_description : text
mrp_delete : decimal(10,2)
gst_percent_delete : decimal(5,2)
exchange_value_delete : decimal(10,2)
branch_id : int(11)
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm exchange_items_value
id : int(11)
exchange_id : int(11)
year_from : int(11)
year_to : int(11)
exchange_value : decimal(10,2)
is_active : tinyint(4)
created_at : timestamp
modified_at : timestamp

v		surena_crm expense_voucher
id : bigint(20) unsigned
voucher_type_id : int(11)
voucher_no : varchar(50)
voucher_date : date
ledger_id : int(10) unsigned
expense_ledger_id : int(11)
gst_aplicability : enum('Y','N')
itc_eligible : enum('Y','N')
ref_bill_no : varchar(50)
amount : decimal(12,2)
branch_id : int(10) unsigned
user_id : int(11)
narration : text
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime
created_by : int(11)
modified_by : int(11)
finance_year_id : int(11)

v		surena_crm expense_voucher_allocations_deleted
id : bigint(20) unsigned
expense_id : bigint(20) unsigned
invoice_id : bigint(20) unsigned
allocated_amount : decimal(12,2)
remarks : text
delete_status : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm e_invoice_details
id : int(11)
voucher_type_id : int(11)
entry_id : int(11)
e_type : varchar(50)
consignor_name : varchar(150)
consignor_gstin : varchar(20)
consignor_state : varchar(50)
consignor_address1 : varchar(255)
consignor_pincode : varchar(10)
consignor_place : varchar(100)
consignee_name : varchar(150)
consignee_gstin : varchar(20)
consignee_state : varchar(50)
consignee_address1 : varchar(255)
consignee_pincode : varchar(10)
consignee_place : varchar(100)
transporter_name : varchar(150)
transporter_id : varchar(50)
transport_mode : varchar(50)
transport_doc_no : varchar(50)
vehicle_no : varchar(50)
transport_date : date
vehicle_type : varchar(50)
transDistance : varchar(50)
transactionType : int(11)
is_active : enum('Y','N')
created_at : timestamp
updated_at : timestamp

v		surena_crm final_ledger_balance_del
ledger_id : bigint(20) unsigned
branch_id : int(11)
finance_year_id : int(11)
opening_balance : decimal(18,2)
transaction_dr : decimal(18,2)
transaction_cr : decimal(18,2)
closing_balance : decimal(18,2)

v		surena_crm financial_years
id : smallint(5) unsigned
branch_id : smallint(5) unsigned
year : varchar(9)
fiscal_year : enum('Y','N')
start_date : date
end_date : date
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm gst_api_credentials
id : bigint(20)
environment : varchar(100)
invoice_type : varchar(100)
ip_address : varchar(45)
client_id : varchar(150)
client_secret : varchar(255)
username : varchar(100)
password : varchar(50)
gstin : varchar(50)
email : varchar(100)
authtoken_url : varchar(250)
eInvoice_url : varchar(250)
eWay_url : varchar(250)
eWay_cancel_url : varchar(250)
eInvoice_cancel_url : varchar(250)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm gst_authcode
id : int(11)
invoice_type : varchar(20)
auth_code : varchar(250)
expiry_time : varchar(20)
created_at : timestamp

v		surena_crm gst_registration_types
id : tinyint(3) unsigned
type_name : varchar(50)
description : varchar(255)
is_default : enum('Y','N')
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm invoice_outstanding
id : bigint(20) unsigned
voucher_type_id : tinyint(3) unsigned
voucher_id : bigint(20) unsigned
voucher_number : varchar(50)
ledger_id : bigint(20) unsigned
invoice_date : date
dr_amount : decimal(15,2)
cr_amount : decimal(15,2)
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
narration : text
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)
is_cancelled : enum('Y','N')
due_date : date

v		surena_crm invoice_print_settings
id : int(11)
branch_id : int(11)
voucher_type_id : int(11)
template : varchar(50)
active : enum('Y','N')

v		surena_crm invoice_settings
id : int(11)
display_scheme : enum('Y','N')
scheme_price : enum('MRP','RC-RATE')
item_price : enum('MRP','PRICE','AVERAGE_PRICE','LAST_PURCHASE_PRICE','SALES_PRICE')
required_exchange_discount : enum('Y','N')
calc_add_discount_from : enum('BASE','PRIMARY_DISCOUNT')
eway_required_above_amount : decimal(10,2)

v		surena_crm items
id : int(10) unsigned
item_name : varchar(255)
alias_name : varchar(255)
item_code : varchar(50)
packing : varchar(50)
hsn_sac_id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
item_cat_id : int(10) unsigned
godown_id : int(10) unsigned
uom_id : int(10) unsigned
brand_id : int(10) unsigned
company_id : int(10) unsigned
item_type : enum('GOODS','SERVICE')
valuation_method : enum('FIFO','WAC','STANDARD')
standard_cost : decimal(10,2)
price_basis : enum('MRP','BASE')
mrp : decimal(10,2)
profit_logic : varchar(100)
price_type : varchar(100)
profit_value : decimal(10,2)
price : decimal(10,2)
average_price : decimal(10,2)
last_purchase_price : decimal(10,2)
purchase_price : decimal(10,2)
sale_price_delete : decimal(10,2)
tax_rate : decimal(10,2)
stock_quantity_del : int(10) unsigned
opening_value_del : int(11)
max_qty : int(10) unsigned
min_qty : int(10) unsigned
reorder_days : int(10) unsigned
low_stock_alert : tinyint(1)
is_subsidy_item : enum('Y','N')
is_edit_mrp : enum('Y','N')
branch_id : int(10) unsigned
item_name_key : varchar(255)
name_norm : varchar(255)
aliases_norm : varchar(512)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm items_brands
id : int(10) unsigned
brand_name : varchar(100)
description : text
branch_id : int(11) unsigned
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm items_category
id : int(11)
category_name : varchar(100)
is_active : tinyint(1)
sort_order : int(11)
description : text
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm items_category_discounts_map
id : int(11) unsigned
item_cat_id : int(11) unsigned
discount_source : enum('CATEGORY','SCHEME')
source_id : int(11) unsigned
discount_type : enum('PERCENTAGE','FLAT','PERUNIT')
discount_value : decimal(10,2)
is_active : tinyint(1)
branch_id : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm items_company
id : int(10) unsigned
company_name : varchar(100)
description : text
branch_id : int(11) unsigned
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm items_delivery_sources
id : tinyint(3) unsigned
code : varchar(20)
title : varchar(100)
description : text
active_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm items_discount_categories
id : tinyint(3) unsigned
category_name : varchar(50)
description : text
discount_type_id : int(11) unsigned
discount_type : enum('FLAT','PERCENTAGE','PERUNIT')
is_default : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm items_discount_types
id : tinyint(3) unsigned
discount_type_name : varchar(50)
description : text
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm items_godowns
id : int(10) unsigned
godown_name : varchar(100)
code : varchar(20)
description : text
branch_id : int(10) unsigned
address : text
city : varchar(50)
pincode : char(6)
state_id : int(10) unsigned
country_id : int(10) unsigned
contact_number : varchar(20)
email : varchar(100)
incharge_name : varchar(100)
is_primary : tinyint(1)
active_status : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm items_hsn_sac_deleted
id : bigint(20) unsigned
hsn_sac_code : varchar(50)
effective_date : date
active_status : tinyint(1) unsigned
gst : decimal(5,2)
cgst : decimal(5,2)
sgst : decimal(5,2)
igst : decimal(5,2)
cess : decimal(5,2)
branch_id : int(10) unsigned
is_delete : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm items_opening_stock
id : bigint(20) unsigned
item_id : bigint(20) unsigned
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
opening_qty : decimal(12,2)
opening_rate : decimal(12,2)
opening_value : decimal(14,2)
created_at : datetime
updated_at : datetime

v		surena_crm items_scheme_discounts
id : int(10) unsigned
scheme_name : varchar(255)
discount_type_id : int(10) unsigned
discount_type : enum('FLAT','PERCENTAGE','PERUNIT')
applicable_districts : text
effective_from : date
effective_to : date
poster_image : varchar(255)
branch_id : int(10) unsigned
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm items_stock_ledger
id : bigint(20) unsigned
item_id : bigint(20) unsigned
branch_id : int(10) unsigned
trans_type : enum('SALE','PURCHASE','TRANSFER','ADJUSTMENT')
trans_ref_id : bigint(20) unsigned
trans_date : date
qty_in : decimal(12,2)
qty_out : decimal(12,2)
balance_qty : decimal(12,2)
narration : text
created_at : datetime

v		surena_crm items_tax_hsn_sac
id : bigint(20) unsigned
hsn_sac_code : varchar(50)
hsn_description : text
hsn_type : enum('HSN','SAC')
tax_percentage : decimal(5,2)
cgst : decimal(5,2)
sgst : decimal(5,2)
igst : decimal(5,2)
cess : decimal(5,2)
tax_type : enum('GST','VAT','SALES_TAX','CESS','TDS','EXCISE')
tax_group_name : varchar(50)
effective_date : date
active_status : tinyint(1) unsigned
branch_id : int(10) unsigned
company_id : int(10) unsigned
state_id : int(10) unsigned
country_id : int(10) unsigned
is_delete : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm items_uom
id : int(10) unsigned
uom_name : varchar(100)
uom_code : varchar(20)
description : varchar(255)
branch_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp
delete_status : tinyint(1)

v		surena_crm item_effective_pricing
branch_id : int(11)
item_id : bigint(20)
price_basis : enum('MRP','BASE')
base_price : decimal(12,2)
unit_price : decimal(12,2)
applied_rules_json : longtext
rules_hash : char(32)
valid_from : date
valid_to : date
updated_at : timestamp

v		surena_crm item_stock_summary
id : bigint(20) unsigned
item_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
financial_year_id : bigint(20) unsigned
stock_qty : decimal(14,3)
total_in_qty : decimal(14,3)
total_in_value : decimal(14,2)
total_out_qty : decimal(14,3)
wac_rate : decimal(14,4)
stock_value : decimal(14,2)
last_txn_id : bigint(20) unsigned
updated_at : datetime

v		surena_crm item_transactions
id : bigint(20) unsigned
item_id : bigint(20) unsigned
branch_id : int(10) unsigned
financial_year_id : int(11)
finance_year_id : int(10) unsigned
godown_id : int(10) unsigned
voucher_type_id : int(10) unsigned
in_out_type : enum('IN','OUT')
quantity : decimal(12,2)
rate : decimal(12,2)
ref_type : varchar(30)
ref_id : bigint(20)
ref_line_id : bigint(20)
transaction_value : decimal(14,2)
transaction_date : date
voucher_id : bigint(20) unsigned
voucher_type : varchar(50)
reference_table : varchar(50)
reference_id : bigint(20) unsigned
narration : text
created_at : timestamp
delete_status : int(10)
is_cancelled : enum('Y','N')

v		surena_crm journal_vouchers
id : bigint(20) unsigned
voucher_number : varchar(50)
voucher_type_id : int(11)
voucher_date : date
journal_date : date
branch_id : int(11) unsigned
finance_year_id : int(11) unsigned
narration : text
posting_status : enum('Draft','Posted')
delete_status : tinyint(1)
created_by : tinyint(1)
updated_by : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm journal_voucher_lines
id : bigint(20) unsigned
journal_voucher_id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
dr_amount : decimal(18,2)
cr_amount : decimal(18,2)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm ledger_bank_accounts
id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
branch_id : int(10) unsigned
account_name : varchar(120)
account_no : varchar(34)
ifsc_code : varchar(15)
bank_name : varchar(100)
branch_name : varchar(120)
account_type : enum('CURRENT','SAVINGS','OD','OCC','CASH_CREDIT','OTHER')
upi_id : varchar(120)
swift_code : varchar(20)
micr_code : varchar(15)
bank_details_applies_to : varchar(100)
is_primary : tinyint(1)
opening_balance : decimal(18,2)
balance_type : enum('DR','CR')
notes : varchar(255)
active_status : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm ledger_contact_details
id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
contact_person_name : varchar(100)
contact_person_last_name : varchar(100)
designation : varchar(100)
contact_number : varchar(20)
whatsapp_number : varchar(20)
email_address : varchar(100)
is_primary : enum('Y','N')
created_at : datetime
updated_at : datetime

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

v		surena_crm ledger_entries_cash
id : bigint(20) unsigned
ledger_name : varchar(250)
trade_name : varchar(250)
led_type_id : smallint(5) unsigned
voucher_type_id : int(10)
sales_entry_id : bigint(20) unsigned
caste_category : int(10) unsigned
gender : varchar(50)
address : varchar(500)
city : varchar(50)
pincode : char(6)
state_id : smallint(5) unsigned
country_id : smallint(5) unsigned
gst_registration_types_id : int(11)
gst_number : varchar(50)
pan_number : varchar(20)
company_contact_number : varchar(20)
whatsapp_number : varchar(20)
email_id : varchar(100)
delivery_source : enum('PLANT','GODOWN')
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm ledger_groups
id : smallint(5) unsigned
title : varchar(100)
parent_group_id : smallint(5) unsigned
is_primary : tinyint(1)
is_secondary : tinyint(1)
sub_group : enum('ASSET','LIABILITY','INCOME','EXPENSE','PARTY','CASH','BANK')
entry_side : enum('CR','DR')
delete_status : tinyint(1)
main_group : varchar(50)
child_group : varchar(50)
description : text
active_status : tinyint(1)
created_at : datetime
updated_at : datetime
sort_order : int(11)
report_side : enum('ASSET','LIABILITY','INCOME','EXPENSE')
report_type : enum('BS','PL')
report_schedule : varchar(50)
normal_balance : enum('DR','CR')

v		surena_crm ledger_keys
id : int(10) unsigned
ledger_key : varchar(50)
header_field : varchar(50)
description : varchar(255)
section_code : varchar(10)
ledger_type : enum('system','user')
editable : tinyint(1)
apply_on_deleted : enum('purchase','purchase_return','sales','sales_return','both','none')
module : varchar(50)
account_category : varchar(255)
account_group : varchar(100)
default_ledger : tinyint(1)
is_active : tinyint(1)
created_at : datetime
created_by : int(11)
updated_at : datetime
updated_by : int(11)
external_ref_code : varchar(50)

v		surena_crm ledger_opening_balances
id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
finance_year_id : int(11)
financial_year : varchar(10)
opening_debit : decimal(18,2)
opening_credit : decimal(18,2)
branch_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp
delete_status : tinyint(1)

v		surena_crm ledger_party_shipping_details
id : int(10) unsigned
ledger_id : int(10) unsigned
is_primary : enum('Y','N')
ship_to : varchar(100)
gst_no : varchar(50)
address : text
city : varchar(100)
state_id : int(10) unsigned
country_id : int(10) unsigned
pincode : varchar(20)
contact_person : varchar(50)
contact_no : varchar(10)
email_id : varchar(50)
branch_id : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm ledger_postings
id : bigint(20) unsigned
posting_date : date
txn_date : date
voucher_id : bigint(20)
voucher_no : varchar(50)
voucher_type_id : bigint(20) unsigned
voucher_date : date
ledger_id : bigint(20) unsigned
group_id : bigint(20) unsigned
parent_group_id : bigint(20) unsigned
entry_side : enum('CR','DR')
dr_amount : decimal(18,2)
cr_amount : decimal(18,2)
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
user_id : bigint(20) unsigned
narration : text
sort_order : tinyint(4)
is_main_row : tinyint(4)
cash_or_bank : enum('Cash','Bank','Party')
by_or_to : enum('By','To')
other_details : enum('Y','N')
correspondent_ledger_id : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)
is_cancelled : enum('Y','N')
deleted_by : int(11)
deleted_at : datetime

v		surena_crm ledger_postings_audit
id : bigint(20) unsigned
posting_date : date
voucher_id : bigint(20) unsigned
line_no : int(10) unsigned
voucher_no : varchar(50)
voucher_type_id : bigint(20) unsigned
voucher_date : date
ledger_id : bigint(20) unsigned
ledger_group_id : smallint(5) unsigned
amount_signed : decimal(18,2)
currency_code : char(3)
fx_rate : decimal(18,8)
amount_base : decimal(18,2)
branch_id : int(10) unsigned
finance_year_id : int(10) unsigned
user_id : bigint(20) unsigned
narration : text
correspondent_ledger_id : bigint(20) unsigned
corr_ledger_group_id : smallint(5) unsigned
instrument_no : varchar(50)
instrument_date : date
recon_status : tinyint(1)
recon_date : date
cost_center_id : bigint(20) unsigned
project_id : bigint(20) unsigned
source_module : varchar(50)
source_id : bigint(20) unsigned
tds_deduction_id : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)
deleted_by : int(11)
deleted_at : datetime

v		surena_crm ledger_shipping_details
id : int(10) unsigned
ledger_id : int(10) unsigned
ledger_cash_id : int(10) unsigned
parent_led_id : int(10) unsigned
shipping_id : int(10) unsigned
voucher_type_id : int(11)
is_primary : enum('Y','N')
ship_to : varchar(50)
mailing_name : varchar(50)
shipping_address : text
shipping_contact : varchar(20)
shipping_city : varchar(100)
shipping_state_id : int(10) unsigned
shipping_country_id : int(10) unsigned
shipping_pincode : varchar(20)
shipping_gstin : varchar(20)
contact_person : varchar(50)
contact_no : varchar(10)
email_id : varchar(50)
place_of_supply : varchar(100)
delivery_source : varchar(100)
godown_id : int(11)
plant_id : int(11)
branch_id : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm ledger_transactions
id : int(11)
ref_table : varchar(100)
ref_id : int(10)
voucher_type_id : tinyint(3) unsigned
voucher_type : varchar(50)
voucher_id : int(11)
voucher_number : varchar(100)
voucher_date : date
ledger_id : int(11)
ledger_name : varchar(100)
parent_group_id : int(10) unsigned
parent_group_title : varchar(50)
ledger_group_id : int(10) unsigned
ledger_group_title : varchar(100)
dr_amount : decimal(12,2)
cr_amount : decimal(12,2)
narration : text
delete_status : tinyint(1)
correspondent_ledger : varchar(50)
correspondent_ledger_id : int(11)
branch_id : int(11)
created_at : datetime
updated_at : datetime
by : varchar(50)
to : varchar(50)
is_other_details : enum('Y','N')
is_cash_bank_detailsreport : varchar(50)
correspondent_date : varchar(50)
alias_ledger_id : int(10) unsigned

v		surena_crm ledger_types_deleted
id : smallint(5) unsigned
title : varchar(100)
group_type : enum('PARTY','BANK','CASH','INCOME','EXPENSE','TAX','DUTY','LIABILITY','ASSET','PROVISION','SYSTEM')
is_default : tinyint(1)
description : text
active_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm mastergst_tokens
id : int(11)
gstin : varchar(15)
access_token : varchar(500)
token_expiry : datetime
created_at : timestamp

v		surena_crm message_queue
id : int(11)
phone_number : varchar(20)
message_text : text
status : enum('PENDING','SENT','FAILED')
created_at : timestamp

v		surena_crm monthly_financial_summary
summary_month : char(7)
branch_id : int(11)
total_sales : decimal(12,2)
total_purchases : decimal(12,2)
total_receipts : decimal(12,2)
total_payments : decimal(12,2)
credit_note : decimal(12,2)
debit_note : decimal(12,2)
finance_year_id : int(11)

v		surena_crm parts
id : int(10) unsigned
part_id : varchar(50)
part_title : varchar(255)
part_cost : decimal(12,2)
image_path : varchar(255)
image_url : varchar(255)
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm party_comments
id : bigint(20) unsigned
party_id : bigint(20) unsigned
comment_type : enum('Remark','Follow-Up','Issue','Info')
comment_text : text
commenter : varchar(100)
comment_date : date
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm party_type
id : int(10) unsigned
title : varchar(100)
description : text
sale_order_mode : enum('REQUESTED','CONFIRMED')
active_status : tinyint(1)
branch_id : int(11)
created_by : int(11)
modified_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm payment_details_draft
id : bigint(20) unsigned
transaction_id : bigint(20)
voucher_type_id : bigint(20)
voucher_date : date
ledger_id : bigint(20) unsigned
ledger_account_id : bigint(20) unsigned
ledger_account_name : varchar(200)
instrument_type : varchar(50)
instrument_number : varchar(100)
bank_name : varchar(250)
amount : decimal(12,2)
branch_id : int(10) unsigned
narration : text
received_status : enum('Y','N')
move_to_receipt : enum('Y','N')
is_subsidy_payment : enum('Y','N')
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm payment_followup
id : int(11)
date : date
time : time
ledger_id : int(11)
type : varchar(50)
promise_amount : decimal(10,2)
promise_date : date
note : longtext
call_by : int(11)
created_at : timestamp
modified_at : timestamp

v		surena_crm payment_followup_status
id : int(11)
ledger_id : int(11)
user_id : int(11)
status : varchar(50)
lock_date_time : timestamp

v		surena_crm payment_purchase_mapping
id : bigint(20) unsigned
payment_transaction_id : bigint(20) unsigned
purchase_entry_id : bigint(20) unsigned
allocated_amount : decimal(12,2)
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm payment_types
id : int(11)
name : varchar(100)
sort_order : int(11)
is_active : enum('Y','N')
created_at : timestamp
updated_at : timestamp

v		surena_crm payment_vouchers
id : bigint(20) unsigned
entry_type : enum('PAYMENT','EXPENSE')
voucher_type_id : int(11)
cash_or_bank : enum('Cash','Bank')
voucher_no : varchar(50)
voucher_date : date
ledger_id : bigint(20) unsigned
ledger_account_id : bigint(20) unsigned
expense_head : varchar(200)
gst_aplicability : varchar(100)
ref_bill_no : varchar(50)
instrument_type : enum('CASH','CHEQUE','NEFT','RTGS','IMPS','UPI','DD','OTHERS','ONLINE')
instrument_number : varchar(100)
amount : decimal(12,2)
branch_id : int(10) unsigned
user_id : int(11)
narration : text
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime
created_by : int(11)
modified_by : int(11)
finance_year_id : int(11)
bank_name : varchar(50)
account_no : varchar(20)
ifsc_code : varchar(20)
reference_id : int(11)

v		surena_crm payment_voucher_allocations
id : bigint(20) unsigned
payment_voucher_id : bigint(20) unsigned
voucher_type_id : bigint(20)
invoice_id : bigint(20) unsigned
allocated_amount : decimal(12,2)
remarks : text
delete_status : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm plant_details
id : int(10) unsigned
plant_name : varchar(100)
plant_code : varchar(50)
address : text
city : varchar(100)
pincode : varchar(10)
state_id : int(10) unsigned
country_id : int(10) unsigned
contact_number : varchar(15)
email : varchar(100)
is_active : tinyint(1)
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm postings_audit_log
id : bigint(20) unsigned
voucher_id : bigint(20) unsigned
voucher_type : varchar(50)
table_name : varchar(50)
row_data : longtext
deleted_by : int(10) unsigned
deleted_at : datetime
recovered : tinyint(1)

v		surena_crm posting_audit_log
id : bigint(20)
voucher_type_id : bigint(20)
ref_id : bigint(20)
ref_table : varchar(50)
posting_action : varchar(50)
message : text
posting_time : datetime
posted_by : bigint(20)

v		surena_crm posting_control
id : int(11)
voucher_type_id : bigint(20)
voucher_id : bigint(20)
posting_status : enum('POSTED','NOT_POSTED')
posted_by : bigint(20)
posting_at : datetime

v		surena_crm posting_period_control
period_start : date
period_end : date
is_locked : enum('Y','N')
locked_by : int(11)
locked_at : datetime

v		surena_crm pricing_recompute_queue
id : bigint(20)
branch_id : int(11)
item_id : bigint(20)
reason : varchar(40)
created_at : timestamp

v		surena_crm purchase_entries
id : bigint(20) unsigned
purchase_invoice_no : varchar(50)
purchase_invoice_date : date
voucher_number : varchar(50)
voucher_type_id : bigint(20)
entry_mode : enum('Cash','Party')
grn_ref_id : int(11)
grn_status : enum('Y','N')
urd : enum('Y','N')
sales_channel : varchar(50)
sales_person_id : int(10) unsigned
source_quotation_id : bigint(20) unsigned
voucher_date : date
voucher_time : time
due_date : date
ledger_id : int(10) unsigned
party_cat_id : int(11)
invoice_amount : decimal(12,2) unsigned
price : decimal(10,2)
after_prim_dis_price : decimal(10,2)
pri_discount : decimal(10,2)
proportionate_discount : decimal(10,2)
additional_discount : decimal(10,2)
total_discount : decimal(10,2)
discount_coupon_code : varchar(50)
applied_discount_category : enum('SCHEME','CATEGORY')
applied_discount_category_id : int(11)
taxable_amount : decimal(12,2)
item_tax_amout : decimal(10,2)
add_charges_fixed_tax_amount : decimal(10,2)
add_charges_proportionate_tax_amount : decimal(10,2)
total_tax_amount : decimal(10,2)
tds_amount : decimal(10,2)
freight_charges : decimal(10,2)
add_charges : decimal(10,2)
sgst_amount : decimal(10,2)
cgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
payment_status : enum('Pending','Paid','Partial')
narration : text
receiver_name : varchar(100)
receiver_contact_number : varchar(20)
branch_id : int(11)
user_id : bigint(20) unsigned
modified_user_id : bigint(20) unsigned
finance_year_id : bigint(20) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime
round_off : decimal(12,2)
total_amount : decimal(12,2)
irn : varchar(64)
ack_no : bigint(20)
ack_date : datetime
qr_code : text
einvoice_status : enum('PENDING','GENERATED','FAILED')
einvoice_error : text
ewaybill_no : bigint(20)
ewaybill_date : datetime
ewaybill_status : enum('PENDING','GENERATED','FAILED')
ewaybill_error : text
posting_status : enum('Pending','Posted')

v		surena_crm purchase_entries_old
id : bigint(20) unsigned
voucher_number : varchar(50)
voucher_type : tinyint(1)
voucher_date : date
due_date : date
ledger_id : int(10) unsigned
voucher_type_id : int(10) unsigned
finance_year_id : int(10) unsigned
invoice_no : varchar(50)
invoice_date : date
price : decimal(12,2)
total_discount : decimal(12,2)
applied_discount_category_id : int(11)
taxable_amount : decimal(12,2)
total_amount : decimal(12,2)
tax_amount : decimal(12,2)
freight_charges : decimal(12,2)
add_charges : decimal(12,2)
sgst_amount : decimal(12,2)
cgst_amount : decimal(12,2)
igst_amount : decimal(12,2)
cess_amount : decimal(12,2)
payment_status : enum('Pending','Partial','Paid')
narration : text
branch_id : int(11)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm purchase_entry_items
id : bigint(20) unsigned
purchase_entry_id : bigint(20) unsigned
godown_id : bigint(20) unsigned
item_id : bigint(20) unsigned
hsn_sac_id : bigint(20) unsigned
uom_id : bigint(20) unsigned
quantity : decimal(10,2)
rate : decimal(10,2)
price : decimal(10,2)
discount_type : varchar(50)
discount_source_id : bigint(20)
discount_value : decimal(10,2)
discount_amount : decimal(10,2)
proportionate_discount : decimal(10,2)
proportionate_discount_selected_items : decimal(10,2)
taxable_amount : decimal(12,2)
proportionate_add_charges_amount : decimal(12,2)
tax_percentage : decimal(5,2)
cgst_percentage : decimal(5,2)
sgst_percentage : decimal(5,2)
igst_percentage : decimal(5,2)
cess_percentage : decimal(5,2)
tax_amount : decimal(10,2)
cgst_amount : decimal(10,2)
sgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
branch_id : int(10) unsigned
delete_status : tinyint(3) unsigned
created_at : timestamp
updated_at : timestamp

v		surena_crm purchase_entry_items_old
id : bigint(20) unsigned
purchase_entry_id : bigint(20) unsigned
item_id : bigint(20) unsigned
godown_id : bigint(20) unsigned
voucher_type_id : bigint(20) unsigned
hsn_sac_id : bigint(20) unsigned
uom_id : bigint(20) unsigned
quantity : decimal(12,2)
rate : decimal(12,2)
price : decimal(12,2)
discount_type_id : tinyint(1) unsigned
discount_value : decimal(10,2)
discount_amount : decimal(12,2)
taxable_amount : decimal(14,2)
gst_percentage : decimal(5,2)
cgst_percentage : decimal(5,2)
sgst_percentage : decimal(5,2)
igst_percentage : decimal(5,2)
cess_percentage : decimal(5,2)
gst_amount : decimal(12,2)
cgst_amount : decimal(12,2)
sgst_amount : decimal(12,2)
igst_amount : decimal(12,2)
cess_amount : decimal(12,2)
branch_id : int(10) unsigned
delete_status : tinyint(1) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm purchase_invoice_discounts
id : int(11)
invoice_id : int(11)
discount_details : longtext
total_fixed_discount : decimal(12,2)
total_prop_discount : decimal(12,2)
remarks : varchar(255)
selected_prop_discount_items : varchar(250)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm purchase_orders
id : bigint(20) unsigned
po_number : varchar(100)
supplier_id : bigint(20) unsigned
order_date : date
status : enum('PENDING','APPROVED','REJECTED')
total_amount : decimal(12,2)
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm purchase_order_items
id : bigint(20) unsigned
purchase_order_id : bigint(20) unsigned
item_id : bigint(20) unsigned
quantity : decimal(12,2)
unit_price : decimal(12,2)
total_price : decimal(14,2)
delete_status : tinyint(1)
modified_by : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm purchase_received_details
id : int(10) unsigned
entry_id : int(10) unsigned
voucher_type_id : int(10) unsigned
received_date : date
receipt_note_no : varchar(50)
received_doc : varchar(50)
received_through : varchar(50)
godown_id : int(11)
carrier_ledger_id : int(20)
bill_of_lading : varchar(100)
motor_vehicle_no : varchar(50)
branch_id : int(10) unsigned
created_by : int(10) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm purchase_returns
id : bigint(20) unsigned
voucher_number : varchar(50)
voucher_type_id : int(10) unsigned
voucher_date : date
ledger_id : int(10) unsigned
discounted_rate : decimal(10,2)
pri_discount : decimal(10,2)
proportionate_discount : decimal(10,2)
total_discount : decimal(10,2)
total_deduction_amount : decimal(10,2)
taxable_amount : decimal(12,2)
item_tax_amout : decimal(12,2)
add_charges_fixed_tax_amount : decimal(12,2)
add_charges_proportionate_tax_amount : decimal(12,2)
total_tax_amount : decimal(10,2)
tds_amount : decimal(10,2)
freight_charges : decimal(10,2)
add_charges : decimal(10,2)
sgst_amount : decimal(10,2)
cgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
payment_status : enum('Pending','Paid','Partial')
posting_status : enum('Pending','Approved','Posted')
narration : text
receiver_name : varchar(100)
receiver_contact_number : varchar(20)
branch_id : int(11)
finance_year_id : int(11)
delete_status : tinyint(1)
created_at : datetime
user_id : int(10) unsigned
updated_at : datetime
modified_user_id : int(11)
total_amount : decimal(12,2)
round_off : decimal(10,2)
ewaybill_status : varchar(20)

v		surena_crm purchase_return_items
id : bigint(20) unsigned
purchase_return_id : bigint(20) unsigned
purchase_entry_id : bigint(20) unsigned
purchase_return_reason_id : bigint(20) unsigned
item_id : bigint(20) unsigned
godown_id : int(11)
hsn_sac_id : bigint(20) unsigned
uom_id : bigint(20) unsigned
quantity : decimal(10,2)
discounted_rate : decimal(10,2)
deduction_type : varchar(50)
deduction_value : decimal(10,2)
deduction_amount : decimal(10,2)
discounted_price : decimal(10,2)
proportionate_discount : decimal(10,2)
taxable_amount : decimal(12,2)
proportionate_add_charges_amount : decimal(12,2)
gst_percentage : decimal(5,2)
cgst_percentage : decimal(5,2)
sgst_percentage : decimal(5,2)
igst_percentage : decimal(5,2)
cess_percentage : decimal(5,2)
gst_amount : decimal(10,2)
cgst_amount : decimal(10,2)
sgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
deduction_reason : longtext
branch_id : int(10) unsigned
delete_status : tinyint(3) unsigned
created_at : timestamp
updated_at : timestamp

v		surena_crm purchase_return_items_old
id : bigint(20) unsigned
purchase_return_id : bigint(20) unsigned
purchase_entry_id : bigint(20) unsigned
purchase_entry_item_id : bigint(20) unsigned
item_id : bigint(20) unsigned
branch_id : int(10) unsigned
return_quantity : decimal(10,2)
unit_price_discounted : decimal(10,2)
return_amount : decimal(12,2)
return_reason_id : bigint(20) unsigned
remarks : text
delete_status : tinyint(4)
created_at : timestamp
updated_at : timestamp

v		surena_crm purchase_return_old
id : bigint(20) unsigned
voucher_number : varchar(50)
voucher_date : date
ledger_id : bigint(20) unsigned
total_return_qty : int(10) unsigned
total_return_amount : decimal(12,2)
branch_id : int(10)
return_status : enum('PENDING','APPROVED','REJECTED')
approved_by : bigint(20) unsigned
created_by : bigint(20) unsigned
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm quotation_entries
id : bigint(20) unsigned
voucher_number : varchar(50)
voucher_type_id : bigint(20)
sales_channel : varchar(50)
sales_person_id : int(10) unsigned
source_quotation_id : bigint(20) unsigned
voucher_date : date
voucher_time : time
due_date : date
ledger_id : int(10) unsigned
party_cat_id : int(11)
invoice_amount : decimal(12,2) unsigned
price : decimal(10,2)
pri_discount : decimal(10,2)
proportionate_discount : decimal(10,2)
total_discount : decimal(10,2)
discount_coupon_code : varchar(50)
applied_discount_category : enum('SCHEME','CATEGORY')
applied_discount_category_id : int(11)
taxable_amount : decimal(12,2)
item_tax_amout : decimal(10,2)
add_charges_fixed_tax_amount : decimal(10,2)
add_charges_proportionate_tax_amount : decimal(10,2)
total_tax_amount : decimal(10,2)
tds_amount : decimal(10,2)
freight_charges : decimal(10,2)
add_charges : decimal(10,2)
sgst_amount : decimal(10,2)
cgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
payment_status : enum('Pending','Paid','Partial')
narration : text
additional_discount_remarks : longtext
discount_details : longtext
receiver_name : varchar(100)
receiver_contact_number : varchar(20)
branch_id : int(11)
user_id : bigint(20) unsigned
finance_year_id : bigint(20) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime
round_off : decimal(12,2)
total_amount : decimal(12,2)
irn : varchar(64)
ack_no : bigint(20)
ack_date : datetime
qr_code : text
einvoice_status : enum('PENDING','GENERATED','FAILED')
einvoice_error : text
ewaybill_no : bigint(20)
ewaybill_date : datetime
ewaybill_status : enum('PENDING','GENERATED','FAILED')
ewaybill_error : text
posting_status : enum('Pending','Posted')

v		surena_crm quotation_entry_items
id : bigint(20) unsigned
sales_entry_id : bigint(20) unsigned
godown_id : bigint(20) unsigned
item_id : bigint(20) unsigned
hsn_sac_id : bigint(20) unsigned
uom_id : bigint(20) unsigned
quantity : decimal(10,2)
rate : decimal(10,2)
price : decimal(10,2)
discount_type : varchar(50)
discount_source_id : bigint(20)
discount_value : decimal(10,2)
discount_amount : decimal(10,2)
proportionate_discount : decimal(10,2)
taxable_amount : decimal(12,2)
proportionate_add_charges_amount : decimal(12,2)
tax_percentage : decimal(5,2)
cgst_percentage : decimal(5,2)
sgst_percentage : decimal(5,2)
igst_percentage : decimal(5,2)
cess_percentage : decimal(5,2)
tax_amount : decimal(10,2)
cgst_amount : decimal(10,2)
sgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
branch_id : int(10) unsigned
delete_status : tinyint(3) unsigned
created_at : timestamp
updated_at : timestamp

v		surena_crm receipt_sales_mapping
id : bigint(20) unsigned
receipt_transaction_id : bigint(20) unsigned
sales_entry_id : bigint(20) unsigned
allocated_amount : decimal(12,2)
created_at : timestamp
updated_at : timestamp

v		surena_crm receipt_vouchers
id : bigint(20) unsigned
voucher_type_id : int(10)
cash_or_bank : enum('Cash','Bank')
voucher_no : varchar(50)
voucher_date : date
ledger_id : bigint(20) unsigned
ledger_account_id : bigint(20) unsigned
instrument_type : enum('CASH','CHEQUE','NEFT','RTGS','IMPS','UPI','DD','OTHERS','ONLINE')
instrument_number : varchar(100)
bank_name : varchar(50)
amount : decimal(12,2)
tds_amount : decimal(12,2)
branch_id : int(10) unsigned
user_id : bigint(20) unsigned
finance_year_id : int(10) unsigned
reference_type_id : bigint(20)
advance_reference_id : bigint(20) unsigned
narration : text
delete_status : tinyint(1)
created_by : int(11)
modified_by : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm receipt_voucher_allocations
id : bigint(20) unsigned
receipt_voucher_id : bigint(20) unsigned
voucher_type_id : bigint(20)
invoice_id : bigint(20) unsigned
advance_voucher_type_id : bigint(20)
advance_invoice_id : bigint(20)
allocated_amount : decimal(12,2)
remarks : text
delete_status : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm report_data_entries
id : bigint(20) unsigned
entry_type : enum('SALE','RETURN','ADJUSTMENT')
entry_id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
transaction_date : date
voucher_number : varchar(100)
narration : text
debit_amount : decimal(15,2)
credit_amount : decimal(15,2)
branch_id : int(10) unsigned
item_id : bigint(20) unsigned
hsn_code : varchar(50)
gst_percentage : decimal(5,2)
stock_qty : decimal(10,2)
stock_value : decimal(15,2)
created_at : timestamp
updated_at : timestamp

v		surena_crm sales_cancelled_entries
id : int(11)
voucher_type_id : int(11)
voucher_id : int(11)
voucher_number : varchar(50)
cancelled_date : date
cancelled_reason : longtext
cancelled_by : int(11)
added_at : timestamp

v		surena_crm sales_entries
id : bigint(20) unsigned
voucher_number : varchar(50)
voucher_type_id : bigint(20)
entry_mode : enum('Cash','Party')
entry_status : enum('SALES','PROFORMA','QUOTATION','DELIVERY_NOTE','SALES_ORDER','DRAFT','DECLINE','REQUESTED','SERVICE')
source_sales_id : int(11)
source_proforma_id : int(11)
source_quotation_id : int(10) unsigned
source_delivery_note_id : int(10)
source_sales_order_id : int(11)
source_subsidy_id : int(11)
proforma_status_deleted : enum('Y','N')
quotation_moved_status_deleted : varchar(20)
delivery_note_type : enum('Inhouse','Sales_reference','Others')
sales_channel : varchar(50)
sales_person_id : int(10) unsigned
voucher_date : date
confirm_decline_date : date
voucher_time : time
due_date : date
ledger_id : int(10) unsigned
order_no : varchar(50)
party_cat_id : int(11)
invoice_amount : decimal(12,2) unsigned
price : decimal(10,2)
after_prim_dis_price : decimal(10,2)
subsidy_scheme_id : tinyint(4)
subsidy_scheme_discount : decimal(10,2)
pri_discount : decimal(10,2)
proportionate_discount : decimal(10,2)
additional_discount : decimal(10,2)
total_discount : decimal(10,2)
discount_coupon_code : varchar(50)
applied_discount_category : enum('SCHEME','CATEGORY')
applied_discount_category_id : int(11)
subsidy_diff_amt : decimal(12,2)
taxable_amount : decimal(12,2)
item_tax_amout : decimal(10,2)
add_charges_fixed_tax_amount : decimal(10,2)
add_charges_proportionate_tax_amount : decimal(10,2)
total_tax_amount : decimal(10,2)
tds_amount : decimal(10,2)
freight_charges : decimal(10,2)
add_charges : decimal(10,2)
sgst_amount : decimal(10,2)
cgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
payment_status : enum('Pending','Paid','Partial')
narration : text
additional_discount_remarks : longtext
discount_details : longtext
receiver_name : varchar(100)
receiver_contact_number : varchar(20)
branch_id : int(11)
user_id : bigint(20) unsigned
modified_user_id : bigint(20) unsigned
finance_year_id : bigint(20) unsigned
delete_status : tinyint(1)
is_cancelled : enum('Y','N')
created_at : datetime
updated_at : datetime
round_off : decimal(12,2)
total_amount : decimal(12,2)
einvoice_status : enum('PENDING','GENERATED','CANCELLED')
ewaybill_status : enum('PENDING','GENERATED','CANCELLED')
posting_status : enum('Pending','Posted')
decline_reason : longtext
confirm_reason : longtext

v		surena_crm sales_entry_items
id : bigint(20) unsigned
sales_entry_id : bigint(20) unsigned
godown_id : bigint(20) unsigned
subsidy_scheme_id : tinyint(4)
subsidy_billed : enum('Y','N')
other_discount_applicable : enum('Y','N')
item_id : bigint(20) unsigned
hsn_sac_id : bigint(20) unsigned
uom_id : bigint(20) unsigned
requested_qty : decimal(10,2)
quantity : decimal(10,2)
mrp : decimal(10,2)
rc_rate : decimal(10,2)
is_rate_edit_applicable : enum('Y','N')
rate : decimal(10,2)
price : decimal(10,2)
discount_type : varchar(50)
discount_source_id : bigint(20)
discount_value : decimal(10,2)
discount_amount : decimal(10,2)
proportionate_discount : decimal(10,2)
proportionate_discount_selected_items : decimal(10,2)
taxable_amount : decimal(12,2)
proportionate_add_charges_amount : decimal(12,2)
tax_percentage : decimal(5,2)
cgst_percentage : decimal(5,2)
sgst_percentage : decimal(5,2)
igst_percentage : decimal(5,2)
cess_percentage : decimal(5,2)
tax_amount : decimal(10,2)
cgst_amount : decimal(10,2)
sgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
branch_id : int(10) unsigned
delete_status : tinyint(3) unsigned
is_cancelled : enum('Y','N')
created_at : timestamp
updated_at : timestamp

v		surena_crm sales_invoice_discounts
id : int(11)
invoice_id : int(11)
exchange_id : tinyint(1)
exchange_item_age : tinyint(1)
exchange_value : decimal(10,2)
exchange_company_name : varchar(250)
discount_coupon_code : varchar(50)
credit_note_discount_type : varchar(50)
credit_note_discount_value : decimal(10,2)
discount_details : longtext
total_fixed_discount : decimal(12,2)
total_prop_discount : decimal(12,2)
remarks : varchar(255)
selected_prop_discount_items : longtext
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm sales_invoice_exchange
id : int(11)
discount_id : int(11)
old_item_id : int(11)
machine_name : varchar(255)
list_price : decimal(12,2)
exchange_value : decimal(12,2)
remarks : varchar(255)

v		surena_crm sales_invoice_other_discounts
id : int(11)
discount_id : int(11)
discount_type : enum('flat','percent')
amount : decimal(12,2)
reason : varchar(255)

v		surena_crm sales_invoice_subsidy
id : int(11)
invoice_id : int(11)
scheme_id : tinyint(10)
scheme_document_id : int(11)
document_name : varchar(255)
document_verified : enum('PENDING','UPLOADED','VERIFIED','REJECTED')
remarks : varchar(255)
branch_id : int(10)
created_by : int(10)
modified_by : int(10)
created_at : timestamp
updated_at : timestamp

v		surena_crm sales_returns
id : bigint(20) unsigned
voucher_number : varchar(50)
voucher_type_id : int(10) unsigned
voucher_date : date
ledger_id : int(10) unsigned
discounted_rate : decimal(10,2)
pri_discount : decimal(10,2)
proportionate_discount : decimal(10,2)
total_discount : decimal(10,2)
total_deduction_amount : decimal(10,2)
taxable_amount : decimal(12,2)
item_tax_amout : decimal(12,2)
add_charges_fixed_tax_amount : decimal(12,2)
add_charges_proportionate_tax_amount : decimal(12,2)
total_tax_amount : decimal(10,2)
tds_amount : decimal(10,2)
freight_charges : decimal(10,2)
add_charges : decimal(10,2)
sgst_amount : decimal(10,2)
cgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
payment_status : enum('Pending','Paid','Partial')
return_status : enum('Pending','Approved','Posted')
narration : text
receiver_name : varchar(100)
receiver_contact_number : varchar(20)
branch_id : int(11)
finance_year_id : int(10)
delete_status : tinyint(1)
created_at : datetime
user_id : int(10) unsigned
modified_user_id : int(10) unsigned
updated_at : datetime
round_off : decimal(10,2)
total_amount : decimal(12,2)
posting_status : varchar(50)
einvoice_status : enum('PENDING','GENERATED','CANCELLED')
ewaybill_status : enum('PENDING','GENERATED','CANCELLED')

v		surena_crm sales_return_items
id : bigint(20) unsigned
sales_return_id : bigint(20) unsigned
sales_entry_id : bigint(20) unsigned
sales_return_reason_id : bigint(20) unsigned
item_id : bigint(20) unsigned
godown_id : int(11)
hsn_sac_id : bigint(20) unsigned
uom_id : bigint(20) unsigned
quantity : decimal(10,2)
discounted_rate : decimal(10,2)
deduction_type : varchar(50)
deduction_value : decimal(10,2)
deduction_amount : decimal(10,2)
discounted_price : decimal(10,2)
proportionate_discount : decimal(10,2)
taxable_amount : decimal(12,2)
proportionate_add_charges_amount : decimal(12,2)
gst_percentage : decimal(5,2)
cgst_percentage : decimal(5,2)
sgst_percentage : decimal(5,2)
igst_percentage : decimal(5,2)
cess_percentage : decimal(5,2)
gst_amount : decimal(10,2)
cgst_amount : decimal(10,2)
sgst_amount : decimal(10,2)
igst_amount : decimal(10,2)
cess_amount : decimal(10,2)
deduction_reason : longtext
branch_id : int(10) unsigned
delete_status : tinyint(3) unsigned
created_at : timestamp
updated_at : timestamp

v		surena_crm sales_return_reasons
id : bigint(20) unsigned
reason_title : varchar(255)
description : text
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm sales_settings
id : int(10) unsigned
branch_id : int(10) unsigned
price_base : enum('MRP','PURCHASE_RATE')
discount_base : enum('MRP','PURCHASE_RATE')
additional_discount_enabled : tinyint(1)
enable_scheme_discount : tinyint(1)
allow_negative_stock : tinyint(1)
default_payment_mode : varchar(50)
default_terms_days : smallint(5) unsigned
round_off_method : enum('NEAREST','UP','DOWN')
invoice_prefix : varchar(20)
invoice_start_number : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm sales_targets
id : int(11)
finance_year_id : int(11)
branch_id : int(11)
target_amount : decimal(14,2)

v		surena_crm sample_table
id : int(11)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm setting_allowed_ips
id : int(11)
ip_address : varchar(50)
description : varchar(255)
is_active : tinyint(1)
created_at : datetime

v		surena_crm setting_branch_details
id : int(11)
branch_name : varchar(100)
branch_code : varchar(50)
address : text
city : varchar(50)
pincode : char(6)
state_id : int(11)
country_id : int(11)
contact_number : varchar(15)
email : varchar(100)
gstin : varchar(20)
website : varchar(100)
logo : varchar(255)
dark_logo : varchar(255)
light_logo : varchar(255)
is_main_branch : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm setting_countries
id : smallint(5) unsigned
country_name : varchar(30)
short_name : varchar(10)
is_default : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm setting_district
id : smallint(5) unsigned
state_id : int(11)
district_name : varchar(30)
short_name : varchar(10)
delete_status : tinyint(1)
is_default : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm setting_main_menu
id : int(11)
main_menu : varchar(30)
display_name : varchar(30)
url : varchar(255)
icon : varchar(50)
sequence : tinyint(3) unsigned
is_voucher_entry : enum('Y','N')
voucher_entry_order : int(11)
is_report : enum('Y','N')
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm setting_states
id : smallint(5) unsigned
state_name : varchar(30)
short_name : varchar(10)
delete_status : tinyint(1)
is_default : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm setting_sub_menu
id : smallint(5) unsigned
sub_menu : varchar(50)
display_name : varchar(50)
mmenu_id : smallint(5) unsigned
is_master : enum('Y','N')
master_order : int(11)
is_list : enum('Y','N','','')
list_order : int(11)
is_voucher_entry : enum('Y','N')
voucher_entry_order : int(11)
is_report : enum('Y','N')
url : varchar(255)
entry_url : varchar(255)
sequence : tinyint(3) unsigned
search_sequence : tinyint(3)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm subsidy_receipt_vouchers
id : bigint(20) unsigned
voucher_type_id : int(10)
cash_or_bank : enum('Cash','Bank')
voucher_no : varchar(50)
voucher_date : date
ledger_id : bigint(20) unsigned
ledger_account_id : bigint(20) unsigned
instrument_type : enum('CASH','CHEQUE','NEFT','RTGS','IMPS','UPI','DD','OTHERS','ONLINE')
instrument_number : varchar(100)
bank_name : varchar(50)
amount : decimal(12,2)
tds_amount : decimal(12,2)
branch_id : int(10) unsigned
user_id : bigint(20) unsigned
finance_year_id : int(10) unsigned
reference_type_id : bigint(20)
advance_reference_id : bigint(20) unsigned
narration : text
delete_status : tinyint(1)
created_by : int(11)
modified_by : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm subsidy_receipt_voucher_allocations
id : bigint(20) unsigned
receipt_voucher_id : bigint(20) unsigned
voucher_type_id : bigint(20)
invoice_id : bigint(20) unsigned
advance_voucher_type_id : bigint(20)
advance_invoice_id : bigint(20)
allocated_amount : decimal(12,2)
remarks : text
delete_status : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm subsidy_schemes
id : int(11)
scheme_name : varchar(255)
scheme_code : varchar(50)
active_status : tinyint(1)
is_delete : tinyint(4)
created_by : int(10)
created_at : timestamp
modified_by : int(10)
modified_at : timestamp

v		surena_crm subsidy_scheme_application_form
id : int(11)
scheme_id : int(11)
sales_entries_id : int(11)
application_name_eng : varchar(100)
application_name_kan : varchar(100)
address_phone_eng : text
address_phone_kan : text
social_category_eng : varchar(100)
social_category_kan : varchar(100)
landholding_category_eng : varchar(100)
landholding_category_kan : varchar(100)
land_address_eng : text
land_address_kan : text
survey_extent_eng : varchar(150)
survey_extent_kan : varchar(150)
horticulture_crop_details_eng : text
horticulture_crop_details_kan : text
rtc_details_eng : varchar(150)
rtc_details_kan : varchar(150)
rtc_applicant_name_present : enum('Yes','No')
rtc_applicant_name_present_kan : varchar(10)
rtc_horticulture_crop_mentioned : enum('Yes','No')
rtc_horticulture_crop_mentioned_kan : varchar(10)
rtc_crop_extent_eng : varchar(150)
rtc_crop_extent_kan : varchar(150)
machine_name_technical_details_eng : text
machine_name_technical_details_kan : text
purchased_from_eng : varchar(150)
purchased_from_kan : varchar(150)
purchase_details_eng : text
purchase_details_kan : text
usage_of_equipment_eng : text
usage_of_equipment_kan : text
total_price : decimal(12,2)
total_price_kan : decimal(12,2)
requested_subsidy_amount : decimal(12,2)
requested_subsidy_amount_kan : decimal(12,2)
social_category_other_eng : varchar(150)
social_category_other_kan : varchar(150)
landholding_category_other_eng : varchar(150)
landholding_category_other_kan : varchar(150)
created_at : timestamp
modified_at : timestamp

v		surena_crm subsidy_scheme_documents
id : int(11)
scheme_id : int(11)
doc_code : varchar(80)
doc_name : varchar(200)
is_mandatory : tinyint(1)
sequence_no : int(11)
notes : varchar(255)
branch_id : int(11)
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm subsidy_scheme_general_caste_rule
id : int(11)
scheme_id : int(11)
caste_category_id : int(11)
gender : varchar(50)
subsidy_type : enum('percent','flat')
subsidy_value : decimal(12,2)
cap_amount : decimal(12,2)
active_status : tinyint(1)
is_delete : tinyint(1)
created_at : timestamp
created_by : int(10)
modified_at : timestamp
modified_by : int(10)

v		surena_crm subsidy_scheme_items
id : int(11)
subsidy_scheme_id : int(11)
item_id : int(11)
is_active : tinyint(1)
created_at : timestamp
created_by : tinyint(4)
modified_at : timestamp
modified_by : tinyint(4)

v		surena_crm subsidy_scheme_items_amount
id : int(11)
subsidy_scheme_items_id : int(11)
rc_rate : int(11)
tax_percentage : decimal(5,2)
rc_rate_include_tax : decimal(10,2)
effective_from : date
effective_to : date
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_crm tally_posted_rows
raw_row_id : bigint(20) unsigned
import_batch_id : bigint(20) unsigned
voucher_table : varchar(64)
voucher_id : bigint(20) unsigned
voucher_no : varchar(50)
created_at : datetime

v		surena_crm tally_posting_issues
id : bigint(20) unsigned
import_batch_id : bigint(20) unsigned
raw_row_id : bigint(20) unsigned
issue_code : varchar(40)
details : text
created_at : datetime

v		surena_crm tally_source_batches
import_batch_id : bigint(20) unsigned
sheet_name : varchar(64)
header_row_no : int(11)
h1 : varchar(128)
h2 : varchar(128)
h3 : varchar(128)
h4 : varchar(128)
h5 : varchar(128)
h6 : varchar(128)
h7 : varchar(128)
h8 : varchar(128)
h9 : varchar(128)
h10 : varchar(128)
created_at : timestamp

v		surena_crm tally_source_raw10
id : bigint(20) unsigned
import_batch_id : bigint(20) unsigned
sheet_name : varchar(64)
row_in_sheet : int(11)
c1 : text
c2 : text
c3 : text
c4 : text
c5 : text
c6 : text
c7 : text
c8 : text
c9 : text
c10 : text
created_at : timestamp

v		surena_crm tally_source_typed
id : bigint(20) unsigned
import_batch_id : bigint(20) unsigned
raw_row_id : bigint(20) unsigned
txn_date : date
particulars : text
instrument_text : varchar(255)
vch_type : varchar(60)
voucher_type_id : bigint(20) unsigned
vch_no : varchar(120)
debit_amount : decimal(18,2)
credit_amount : decimal(18,2)
ledger_id : bigint(20) unsigned
correspondent_ledger_id : bigint(20) unsigned
is_ledger : tinyint(1)
is_main_ledger : tinyint(1)
is_main : tinyint(1)
is_correspondent : tinyint(1)
is_others : tinyint(1)
txn_date_forwardfill : date
vch_type_forwardfill : varchar(100)
vch_no_forwardfill : varchar(100)
main_ledger_name_ff : varchar(255)
main_ledger_id_ff : bigint(20) unsigned
is_pair_head : tinyint(1)
is_item : tinyint(1)
item_id : bigint(20) unsigned
item_qty : decimal(18,3)
rate_per_item : decimal(18,3)
item_uom : varchar(32)
item_name_key : varchar(255)
ledger_type : varchar(60)
created_at : timestamp

v		surena_crm tally_transactions
id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
voucher_type : varchar(50)
voucher_number : varchar(100)
voucher_date : date
delete_status : tinyint(1)
type : enum('Debit','Credit')
amount : decimal(15,2)
narration : text
branch_id : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		surena_crm tds_cumulative
id : bigint(20) unsigned
vendor_id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
section_code : varchar(10)
finance_year_id : int(10) unsigned
cumulative_amount : decimal(14,2)
created_at : datetime
updated_at : datetime

v		surena_crm tds_deductions
id : bigint(20) unsigned
voucher_id : bigint(20) unsigned
voucher_type : varchar(50)
ledger_id : bigint(20) unsigned
vendor_id : bigint(20) unsigned
section_code : varchar(10)
amount : decimal(12,2)
narration : varchar(255)
finance_year_id : int(10) unsigned
branch_id : int(10) unsigned
voucher_date : date
created_at : datetime
delete_status : int(11)
deleted_by : int(11)
deleted_at : datetime

v		surena_crm tds_master
id : int(10) unsigned
section_code : varchar(10)
description : varchar(255)
applicable_on : enum('Services','Goods','Rent','Commission','Interest','Others')
rate_percent : decimal(5,2)
threshold_per_txn : decimal(12,2)
threshold_annual : decimal(12,2)
resident_only : tinyint(1)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm telephony_calls
id : bigint(20) unsigned
agent_id : bigint(20) unsigned
agent_number : varchar(30)
customer_number : varchar(30)
caller_id : varchar(30)
source_module : varchar(50)
custom_identifier : varchar(64)
smartflo_uuid : varchar(64)
status : enum('initiated','ringing','answered','missed','completed','failed')
hangup_cause : varchar(100)
duration_sec : int(10) unsigned
recording_url : text
raw_request : longtext
raw_response : longtext
raw_webhook : longtext
created_at : timestamp
updated_at : timestamp

v		surena_crm telephony_call_events
id : bigint(20) unsigned
call_id : bigint(20) unsigned
event_type : varchar(50)
event_time : timestamp
payload_json : longtext

v		surena_crm transaction_additional_charges
id : bigint(20) unsigned
voucher_type_id : tinyint(10) unsigned
transaction_id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
amount : decimal(12,2)
hsn_code_id : bigint(20)
tax_percentage : decimal(5,2)
sgst_percentage : decimal(5,2)
cgst_percentage : decimal(5,2)
igst_percentage : decimal(5,2)
cess_percentage : decimal(5,2)
tax_amt : decimal(12,2)
sgst_amt : decimal(12,2)
cgst_amt : decimal(12,2)
igst_amt : decimal(12,2)
cess_amt : decimal(12,2)
is_proportionate : tinyint(1)
branch_id : int(10) unsigned
delete_status : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm transaction_expenditure_categories
id : int(10) unsigned
title : varchar(100)
description : text
account_group_id : tinyint(3) unsigned
active_status : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm transaction_expenditure_vouchers
id : bigint(20) unsigned
voucher_no : varchar(50)
voucher_date : date
ledger_id : bigint(20) unsigned
ledger_account_id : bigint(20) unsigned
amount : decimal(12,2)
gst_amount : decimal(12,2)
is_gst_applicable : tinyint(1)
expenditure_category_id : int(10) unsigned
branch_id : int(10) unsigned
instrument_type : enum('CASH','BANK','UPI','CHEQUE','NEFT','RTGS','OTHER')
instrument_number : varchar(100)
narration : text
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime
expense_date : date
expense_type : varchar(50)

v		surena_crm transaction_payment_vouchers_expense
id : bigint(20) unsigned
voucher_type_id : int(11)
voucher_no : varchar(50)
voucher_date : date
ledger_id : bigint(20) unsigned
ledger_account_id : bigint(20) unsigned
instrument_type : varchar(20)
instrument_number : varchar(100)
amount : decimal(12,2)
expense_head : varchar(100)
gst : varchar(20)
branch_id : int(10) unsigned
user_id : int(11)
narration : text
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime
payment_date : date
created_by : int(11)
modified_by : int(11)
finance_year_id : int(11)
bank_name : varchar(50)
reference_id : int(11)
reference : varchar(100)

v		surena_crm transaction_receipt_vouchers_old
id : bigint(20) unsigned
voucher_no : varchar(50)
voucher_date : date
ledger_id : bigint(20) unsigned
ledger_account_id : bigint(20) unsigned
instrument_type : varchar(50)
instrument_number : varchar(100)
amount : decimal(12,2)
tds_amount : decimal(12,2)
branch_id : int(10) unsigned
narration : text
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime
received_date : date
user_id : int(11)
finance_year_id : int(11)
bank_name : varchar(50)
reference_id : int(11)

v		surena_crm universal_discount_rules
id : bigint(20)
rule_name : varchar(255)
rule_scope : enum('PRODUCT','CATEGORY','BRAND','GLOBAL','CUSTOMER_SEGMENT','CUSTOMER')
operator : enum('FIXED','PERCENTAGE','CUSTOM_FORMULA')
value : decimal(10,2)
target_id : bigint(20)
customer_segment_id : bigint(20)
coupon_code : varchar(50)
min_qty : int(11)
min_amount : decimal(10,2)
valid_from : date
valid_to : date
priority : int(11)
combine_method : enum('ADD','HIGHEST_ONLY','SEQUENTIAL')
is_active : tinyint(1)
branch_id : int(20)
delete_status : int(11)
created_at : datetime
updated_at : datetime

v		surena_crm users
id : int(10) unsigned
user_code : varchar(50)
name : varchar(150)
username : varchar(100)
password : varchar(255)
email : varchar(150)
mobile : varchar(20)
role_id : int(11)
branch_id : int(11)
ledger_id : int(11)
status : enum('Active','Inactive')
last_login : datetime
created_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_crm user_branches
id : int(10) unsigned
user_id : int(10) unsigned
branch_id : smallint(5) unsigned
is_active : tinyint(1)
is_default : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm user_details
id : smallint(5) unsigned
user_email : varchar(100)
username : varchar(100)
password_hash : char(60)
role_id : smallint(5) unsigned
emp_id : smallint(5) unsigned
ledger_id : tinyint(4)
default_branch_id : int(10) unsigned
financial_year_id : smallint(5) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm user_favorites
id : bigint(20) unsigned
user_id : bigint(20) unsigned
submenu_id : smallint(5) unsigned
is_voucher_entry : enum('Y','N')
sort_order : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm user_financial_years
id : int(10) unsigned
user_id : int(10) unsigned
financial_year_id : smallint(5) unsigned
is_active : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm user_permissions
id : smallint(5) unsigned
role_id : smallint(5) unsigned
menu_id : smallint(5) unsigned
submenu_id : smallint(5) unsigned
can_add : tinyint(3) unsigned
can_edit : tinyint(3) unsigned
can_delete : tinyint(3) unsigned
can_view : tinyint(3) unsigned
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm user_roles
id : smallint(5) unsigned
role_name : varchar(50)
dashboard_link : varchar(255)
dashboard_link_lock_screen : varchar(255)
is_super_admin : tinyint(1) unsigned
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm voucher_additional_charges
id : bigint(20) unsigned
applies_to : varchar(50)
ledger_id : bigint(20) unsigned
tax_proportionate_flag : tinyint(1)
tax_percentage_override_del : decimal(5,2)
hsn_sac_code_del : varchar(20)
remarks : varchar(255)
branch_id : int(11)
created_at : timestamp
updated_at : timestamp

v		surena_crm voucher_numbering_config
id : int(11)
voucher_type_id : tinyint(3) unsigned
financial_year_id : int(10) unsigned
branch_id : int(10) unsigned
starting_number : int(11)
number_width : int(11)
prefix_zero : tinyint(1)
restart_periodicity : enum('None','Monthly','Yearly')
restart_applicable_from : date
restart_number : int(11)
prefix_applicable_from : date
prefix_text : varchar(20)
suffix_applicable_from : date
suffix_text : varchar(20)
created_at : datetime
updated_at : datetime

v		surena_crm voucher_series_master
id : int(11)
voucher_code : varchar(50)
branch_id : int(11)
financial_year_id : int(11)
prefix : varchar(10)
suffix : varchar(10)
current_number : int(11)
reset_frequency : varchar(50)
number_padding : tinyint(4)

v		surena_crm voucher_series_master_old
id : int(11)
voucher_type : varchar(50)
branch_id : int(11)
financial_year_id : int(11)
prefix : varchar(10)
suffix : varchar(10)
current_number : int(11)

v		surena_crm voucher_taxes
id : bigint(20) unsigned
voucher_type : varchar(50)
voucher_id : bigint(20) unsigned
tax_code : varchar(50)
tax_name : varchar(100)
tax_rate : decimal(8,3)
tax_amount : decimal(12,2)
ledger_id : bigint(20) unsigned
branch_id : int(11)
created_at : datetime
updated_at : datetime
taxable_value : decimal(18,2)
charge_type : enum('ITEM','ADDITIONAL_CHARGE')
additional_charge_id : bigint(20) unsigned

v		surena_crm voucher_types
id : tinyint(3) unsigned
voucher_code : varchar(50)
title : varchar(100)
abbreviation : varchar(20)
primary_voucher : enum('Purchase','Sales','Journal','Contra','Payment','Receipt','Draft','Credit_Note','Debit_Note','Quotation','Expense','Services')
is_optional : tinyint(1)
is_primary_voucher : tinyint(1)
is_posting : tinyint(1)
is_default : tinyint(1)
update_item_transaction : tinyint(1)
allow_narration : tinyint(1)
auto_print_on_save : tinyint(1)
auto_whatsapp_on_save : tinyint(1)
entry_side : enum('DR','CR','BOTH')
is_active : tinyint(1)
is_delete : tinyint(4)
sort_order : int(11)
primary_voucher_type_id : tinyint(3) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm voucher_types_old
id : tinyint(3) unsigned
code : varchar(50)
title : varchar(100)
abbreviation : varchar(10)
voucher_mode : enum('Purchase','Sales','Journal','Contra','Payment','Receipt')
numbering_method : enum('Manual','Automatic')
retain_original_number : tinyint(1)
is_optional : tinyint(1)
allow_narration : tinyint(1)
track_additional_costs : tinyint(1)
auto_print_on_save : tinyint(1)
auto_whatsapp_on_save : tinyint(1)
nature : enum('DR','CR','BOTH')
is_custom : tinyint(1)
is_active : tinyint(1)
sort_order : int(11)
primary_voucher_type_id : tinyint(3) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm voucher_type_ledger_mappings
id : int(10) unsigned
voucher_type_id : tinyint(3) unsigned
branch_id : int(10) unsigned
finance_year_id : int(11)
voucher_type : varchar(50)
ledger_id : bigint(20) unsigned
ledger_key_id : int(10) unsigned
is_tds_applicable : tinyint(1) unsigned
narration_template : varchar(255)
remarks : varchar(255)
voucher_flow_type : varchar(50)
sort_order : tinyint(3) unsigned
entry_side : enum('DR','CR','BOTH')
is_default : tinyint(1)
is_group_ledger : enum('NA','ADDITIONAL_DISCOUNT','ADDITIONAL_CHARGES','CREDIT_NOTE')
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_crm whatsapp_settings
id : int(11) unsigned
provider : varchar(100)
api_url : varchar(255)
api_key : varchar(255)
auth_token : varchar(255)
sender_number : varchar(20)
is_active : tinyint(1)
branch_id : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_crm yearly_financial_summary
summary_year : year(4)
branch_id : int(11)
total_sales : decimal(12,2)
total_purchases : decimal(12,2)
total_receipts : decimal(12,2)
total_payments : decimal(12,2)
credit_note : decimal(12,2)
debit_note : decimal(12,2)
finance_year_id : int(11)

Create relationship
FOREIGN KEY
on delete
on update