dev.surenasolutions.in / 127.0.0.1 / surena_edbroad_old

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_edbroad_old 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_edbroad_old api_student
id : bigint(20)
name : varchar(100)
age : int(11)
grade : varchar(20)

v		surena_edbroad_old assign_item_to_subsidy_scheme
id : int(11)
subsidy_scheme_id : int(11)
item_id : int(11)
delete_status : tinyint(4)
created_at : timestamp
created_by : tinyint(4)
modified_at : timestamp
modified_by : tinyint(4)

v		surena_edbroad_old 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_edbroad_old auth_group
id : int(11)
name : varchar(150)

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

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

v		surena_edbroad_old 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_edbroad_old auth_user_groups
id : bigint(20)
user_id : int(11)
group_id : int(11)

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

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

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old crm_enquiry_links
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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old customer_segment
id : int(10) unsigned
title : varchar(100)
description : text
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_edbroad_old 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_edbroad_old daily_ledger_balance
summary_date : date
ledger_id : bigint(20) unsigned
branch_id : int(11)
dr_amount : decimal(18,2)
cr_amount : decimal(18,2)

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old date_range_filters
id : tinyint(3) unsigned
filter_name : varchar(50)
query_value : varchar(50)
is_active : tinyint(1)

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old django_content_type
id : int(11)
app_label : varchar(100)
model : varchar(100)

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

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

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old employees
id : int(11) unsigned
employee_code : varchar(50)
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)
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_edbroad_old exchange_items
id : int(11)
item_name : varchar(255)
item_code : varchar(50)
item_description : text
mrp : decimal(10,2)
gst_percent : decimal(5,2)
exchange_value : decimal(10,2)
branch_id : int(11)
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_edbroad_old expense_voucher
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
expense_head : varchar(200)
gst_aplicability : varchar(100)
ref_bill_no : varchar(50)
instrument_type : varchar(20)
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
payment_date : date
created_by : int(11)
modified_by : int(11)
finance_year_id : int(11)
bank_name : varchar(50)
reference_id : int(11)

v		surena_edbroad_old expense_voucher_allocations
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_edbroad_old final_ledger_balance
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_edbroad_old 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_edbroad_old 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_edbroad_old 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)
due_date : date

v		surena_edbroad_old items
id : int(10) unsigned
item_name : varchar(255)
item_code : varchar(50)
packing : varchar(50)
hsn_sac_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
price : decimal(10,2)
mrp : decimal(10,2)
cost : decimal(10,2)
purchase_price : decimal(10,2)
sale_price : decimal(10,2)
tax_rate : decimal(10,2)
stock_quantity : int(10) unsigned
max_qty : int(10) unsigned
min_qty : int(10) unsigned
reorder_days : int(10) unsigned
low_stock_alert : tinyint(1)
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime
valuation_method : enum('FIFO','WAC','STANDARD')
item_type : enum('GOODS','SERVICE')
item_name_key : varchar(255)
name_norm : varchar(255)
aliases_norm : varchar(512)

v		surena_edbroad_old 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_edbroad_old items_category
id : int(11)
category_name : varchar(100)
is_active : tinyint(1)
description : text
branch_id : int(10) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old items_hsn_sac
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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old items_stock_summary
id : bigint(20) unsigned
item_id : bigint(20) unsigned
branch_id : int(10) unsigned
opening_qty : decimal(12,2)
inward_qty : decimal(12,2)
outward_qty : decimal(12,2)
closing_qty : decimal(12,2)
last_updated : datetime

v		surena_edbroad_old items_tax_hsn_sac
id : bigint(20) unsigned
hsn_sac_code : varchar(50)
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_edbroad_old 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_edbroad_old 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_edbroad_old item_transactions
id : bigint(20) unsigned
item_id : bigint(20) unsigned
branch_id : int(10) unsigned
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)
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)

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old ledger_details
id : bigint(20) unsigned
ledger_name : varchar(250)
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
state_code : varchar(5)
country_id : smallint(5) unsigned
gst_verified : enum('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_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_amount : decimal(10,2)
credit_limit : decimal(18,2)
auto_block_on_overdue : tinyint(1)
delivery_source : enum('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')
charge_kind : enum('FREIGHT','DISCOUNT','PACKING','ROUND_OFF','OTHER')
system_ledger_applies_to : varchar(200)
is_carrier_agent : enum('Y','N')
is_default_carrier_agent : enum('Y','N')
opening_balance : decimal(18,2)
opening_balance_type : enum('DR','CR')
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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
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_edbroad_old 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')
delete_status : tinyint(1)
main_group : varchar(50)
parent_group_title : varchar(50)
description : text
active_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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 : 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_edbroad_old 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)
credit_period : int(11)
branch_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp
delete_status : tinyint(1)

v		surena_edbroad_old 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)
deleted_by : int(11)
deleted_at : datetime

v		surena_edbroad_old 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_edbroad_old ledger_shipping_details
id : int(10) unsigned
ledger_id : int(10) unsigned
ledger_cash_id : int(10) unsigned
parent_led_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)
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_edbroad_old 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_edbroad_old 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_edbroad_old mastergst_tokens
id : int(11)
gstin : varchar(15)
access_token : varchar(500)
token_expiry : datetime
created_at : timestamp

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

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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)
amount : decimal(12,2)
branch_id : int(10) unsigned
narration : text
received_status : enum('Y','N')
move_to_receipt : enum('Y','N')
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old posting_period_control
period_start : date
period_end : date
is_locked : enum('Y','N')
locked_by : int(11)
locked_at : datetime

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

v		surena_edbroad_old 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')
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_edbroad_old 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_edbroad_old 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)
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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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
total_amount : decimal(12,2)
round_off : decimal(10,2)

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_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_edbroad_old receipt_voucher_allocations
id : bigint(20) unsigned
receipt_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_edbroad_old 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_edbroad_old sales_entries
id : bigint(20) unsigned
voucher_number : varchar(50)
voucher_type_id : bigint(20)
entry_mode : enum('Cash','Party')
proforma_ref_id : int(11)
proforma_status : enum('Y','N')
sales_channel : varchar(50)
sales_person_id : int(10) unsigned
source_quotation_id : bigint(20) unsigned
source_sales_id : int(11)
quotation_moved_status : varchar(20)
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)
subsidy_scheme_id : tinyint(4)
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_edbroad_old 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
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_edbroad_old sales_invoice_discounts
id : int(11)
invoice_id : int(11)
branch_id : int(11)
exchange_id : tinyint(1)
subsidy_id : tinyint(1)
discount_coupon_code : varchar(50)
other_discount_amount : decimal(10,2)
total_discount : decimal(12,2)
remarks : varchar(255)
selected_other_discount_items : varchar(250)
selected_subsidy_items : varchar(255)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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
updated_at : datetime
round_off : decimal(10,2)
total_amount : decimal(12,2)
posting_status : varchar(50)

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old sales_targets
id : int(11)
finance_year_id : int(11)
branch_id : int(11)
target_amount : decimal(14,2)

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

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

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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')
is_report : enum('Y','N')
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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_edbroad_old 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')
is_list : enum('Y','N','','')
is_voucher_entry : enum('Y','N')
is_report : enum('Y','N')
url : varchar(255)
sequence : tinyint(3) unsigned
search_sequence : tinyint(3)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_edbroad_old subsidy_schemes
id : int(11)
scheme_name : varchar(255)
scheme_code : varchar(50)
description : varchar(50)
subsidy_type : enum('percent','flat')
subsidy_rate : decimal(5,2)
subsidy_flat_amount : decimal(12,2)
cap_amount : decimal(12,2)
active_status : tinyint(1)

v		surena_edbroad_old 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)
delete_status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old transaction_additional_charges
id : bigint(20) unsigned
voucher_type_id : tinyint(3) unsigned
transaction_id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
amount : decimal(12,2)
tax_percentage : decimal(5,2)
is_proportionate : tinyint(1)
branch_id : int(10) unsigned
delete_status : int(10) unsigned
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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)
status : enum('Active','Inactive')
last_login : datetime
created_by : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		surena_edbroad_old 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_edbroad_old 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
default_branch_id : int(10) unsigned
financial_year_id : smallint(5) unsigned
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old 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_edbroad_old voucher_additional_charges
id : bigint(20) unsigned
voucher_type_id : bigint(20) unsigned
ledger_id : bigint(20) unsigned
tax_proportionate_flag : tinyint(1)
tax_percentage_override : decimal(5,2)
hsn_sac_code : varchar(20)
remarks : varchar(255)
branch_id : int(11)
created_at : timestamp
updated_at : timestamp

v		surena_edbroad_old 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_edbroad_old 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)

v		surena_edbroad_old 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_edbroad_old 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_edbroad_old 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')
numbering_method : enum('Manual','Automatic')
retain_original_number : tinyint(1)
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)
track_additional_costs : tinyint(1)
auto_print_on_save : tinyint(1)
auto_whatsapp_on_save : tinyint(1)
entry_side : enum('DR','CR','BOTH')
is_active : tinyint(1)
sort_order : int(11)
primary_voucher_type_id : tinyint(3) unsigned
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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_edbroad_old voucher_type_ledger_mappings
id : int(10) unsigned
voucher_type_id : tinyint(3) unsigned
voucher_type : varchar(50)
ledger_id : bigint(20) unsigned
ledger_key_id : int(10) unsigned
is_tds_applicable : tinyint(1)
narration_template : varchar(255)
remarks : varchar(255)
voucher_flow_type : enum('manual','auto')
sort_order : tinyint(3) unsigned
entry_side : enum('DR','CR')
is_default : tinyint(1)
delete_status : tinyint(1)
created_at : datetime
updated_at : datetime

v		surena_edbroad_old 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_edbroad_old 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