Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v sgm_crm agent_tracking_role_permissions
* id : bigint(20) unsigned
* role_id : smallint(5) unsigned
* branch_id : int(10) unsigned
* permission_key : varchar(50)
* enabled : tinyint(1)
* created_at : datetime(3)
* updated_at : datetime(3)
v sgm_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 sgm_crm api_student
* id : bigint(20)
* name : varchar(100)
* age : int(11)
* grade : varchar(20)
v sgm_crm attendance_employee_calendar_assignments
* id : bigint(20) unsigned
* employee_id : int(10) unsigned
* branch_id : int(11)
* calendar_id : int(10) unsigned
* effective_from : date
* effective_to : date
* assignment_status : enum('ACTIVE','INACTIVE')
* created_by_user_id : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm attendance_employee_shift_assignments
* id : bigint(20) unsigned
* employee_id : int(10) unsigned
* branch_id : int(11)
* shift_type_id : int(10) unsigned
* effective_from : date
* effective_to : date
* assignment_status : enum('ACTIVE','INACTIVE')
* created_by_user_id : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm attendance_monthly_close_day_snapshots
* id : bigint(20) unsigned
* snapshot_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* employee_code : varchar(50)
* attendance_date : date
* attendance_day_id : bigint(20) unsigned
* finance_year_id : smallint(5) unsigned
* day_classification : varchar(40)
* attendance_resolution_status : varchar(40)
* attendance_finalized : tinyint(1)
* check_in_local_time : datetime
* check_out_local_time : datetime
* duration_minutes : decimal(10,2) unsigned
* source_mode : varchar(30)
* shift_type_id : int(10) unsigned
* shift_code : varchar(30)
* shift_name : varchar(100)
* shift_start_time : time
* shift_end_time : time
* shift_required_minutes : smallint(5) unsigned
* shift_grace_in_minutes : smallint(5) unsigned
* shift_grace_out_minutes : smallint(5) unsigned
* approved_leave_fraction : decimal(3,2)
* leave_day_portion : varchar(20)
* approved_overtime_minutes : int(10) unsigned
* evidence_count : int(10) unsigned
* evidence_hash : char(64)
* flags_json : longtext
* source_snapshot_json : longtext
* row_hash : char(64)
* created_at : datetime
v sgm_crm attendance_monthly_close_employee_snapshots
* id : bigint(20) unsigned
* snapshot_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* employee_code : varchar(50)
* employee_name : varchar(100)
* designation : varchar(100)
* source_branch_id : int(11)
* scheduled_workdays : decimal(8,2)
* present_days : decimal(8,2)
* absent_days : decimal(8,2)
* weekly_off_days : decimal(8,2)
* holiday_days : decimal(8,2)
* approved_leave_days : decimal(8,2)
* payable_attendance_days : decimal(8,2)
* payable_attendance_days_status : varchar(40)
* total_worked_minutes : decimal(12,2)
* approved_overtime_minutes : int(10) unsigned
* late_count : int(10) unsigned
* early_out_count : int(10) unsigned
* short_hours_count : int(10) unsigned
* attendance_exception_count : int(10) unsigned
* summary_json : longtext
* row_hash : char(64)
* created_at : datetime
v sgm_crm attendance_monthly_close_snapshots
* id : bigint(20) unsigned
* snapshot_uuid : char(36)
* period_id : bigint(20) unsigned
* branch_id : int(11)
* period_start : date
* period_end : date
* snapshot_version : int(10) unsigned
* source_period_lock_version : int(10) unsigned
* source_attendance_day_count : int(10) unsigned
* source_employee_count : int(10) unsigned
* source_evidence_count : int(10) unsigned
* source_leave_day_count : int(10) unsigned
* source_overtime_review_count : int(10) unsigned
* source_correction_count : int(10) unsigned
* readiness_json : longtext
* source_counts_json : longtext
* snapshot_hash : char(64)
* created_by_user_id : smallint(5) unsigned
* created_at_utc : datetime
* created_at : datetime
v sgm_crm attendance_monthly_periods
* id : bigint(20) unsigned
* branch_id : int(11)
* period_start : date
* period_end : date
* period_status : enum('OPEN','CLOSED')
* lock_version : int(10) unsigned
* close_comment : varchar(500)
* close_snapshot_json : longtext
* closed_by_user_id : smallint(5) unsigned
* closed_at_utc : datetime
* created_by_user_id : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm attendance_monthly_period_events
* id : bigint(20) unsigned
* period_id : bigint(20) unsigned
* event_type : varchar(40)
* actor_user_id : smallint(5) unsigned
* event_at_utc : datetime
* details_json : longtext
* created_at : datetime
v sgm_crm attendance_operations_events
* id : bigint(20) unsigned
* event_type : varchar(50)
* entity_type : varchar(40)
* entity_id : bigint(20) unsigned
* branch_id : int(11)
* actor_user_id : smallint(5) unsigned
* event_at_utc : datetime
* details_json : longtext
* created_at : datetime
v sgm_crm attendance_shift_types
* id : int(10) unsigned
* branch_id : int(11)
* shift_code : varchar(30)
* shift_name : varchar(100)
* start_time : time
* end_time : time
* crosses_midnight : tinyint(1)
* grace_in_minutes : smallint(5) unsigned
* grace_out_minutes : smallint(5) unsigned
* required_minutes : smallint(5) unsigned
* half_day_minutes : smallint(5) unsigned
* overtime_after_minutes : smallint(5) unsigned
* minimum_overtime_minutes : smallint(5) unsigned
* is_flexible : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by_user_id : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm attendance_work_calendars
* id : int(10) unsigned
* branch_id : int(11)
* calendar_code : varchar(30)
* calendar_name : varchar(100)
* timezone_name : varchar(64)
* effective_from : date
* effective_to : date
* is_default : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by_user_id : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm attendance_work_calendar_dates
* id : bigint(20) unsigned
* calendar_id : int(10) unsigned
* work_date : date
* day_type : enum('HOLIDAY','WORKING')
* day_name : varchar(120)
* is_paid : tinyint(1)
* notes : varchar(500)
* delete_status : tinyint(1)
* created_by_user_id : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm attendance_work_calendar_weekly_offs
* id : int(10) unsigned
* calendar_id : int(10) unsigned
* weekday_iso : tinyint(3) unsigned
* week_pattern : enum('ALL','FIRST_THIRD','SECOND_FOURTH','FIRST','SECOND','THIRD','FOURTH','FIFTH','LAST')
* created_at : datetime
v sgm_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 sgm_crm auth_group
* id : int(11)
* name : varchar(150)
v sgm_crm auth_group_permissions
* id : bigint(20)
* group_id : int(11)
* permission_id : int(11)
v sgm_crm auth_login_otps
* id : bigint(20) unsigned
* request_token : char(64)
* user_id : smallint(5) unsigned
* recipient : varchar(191)
* otp_hash : varchar(255)
* expires_at : datetime
* attempts : tinyint(3) unsigned
* used_at : datetime
* created_at : datetime
v sgm_crm auth_permission
* id : int(11)
* name : varchar(255)
* content_type_id : int(11)
* codename : varchar(100)
v sgm_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 sgm_crm auth_user_aliases
* id : bigint(20) unsigned
* user_id : smallint(5) unsigned
* alias : varchar(191)
* alias_type : enum('EMAIL','MOBILE','OTHER')
* otp_destination : tinyint(1)
* is_active : tinyint(1)
* created_at : datetime
v sgm_crm auth_user_groups
* id : bigint(20)
* user_id : int(11)
* group_id : int(11)
v sgm_crm auth_user_user_permissions
* id : bigint(20)
* user_id : int(11)
* permission_id : int(11)
v sgm_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)
* branch_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v sgm_crm biometric_connector_instances
* id : bigint(20) unsigned
* connector_code : varchar(80)
* key_id : varchar(80)
* connector_key : varchar(80)
* display_name : varchar(160)
* device_id : bigint(20) unsigned
* branch_id : int(11)
* secret_fingerprint : char(64)
* status : enum('ACTIVE','INACTIVE','REVOKED')
* connector_version : varchar(40)
* heartbeat_status : enum('NEVER','HEALTHY','STALE','ERROR')
* allowed_ip_cidrs : text
* last_ip : varchar(45)
* last_heartbeat_at : datetime
* created_by : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm biometric_devices
* id : bigint(20) unsigned
* provider_code : varchar(30)
* device_code : varchar(80)
* serial_number : varchar(80)
* model : varchar(100)
* branch_id : int(11)
* timezone_name : varchar(64)
* connection_mode : enum('ISAPI_LAN','CONNECTOR_PUSH')
* device_host : varchar(255)
* http_scheme : enum('HTTP','HTTPS')
* http_port : smallint(5) unsigned
* sdk_port : smallint(5) unsigned
* status : enum('ACTIVE','INACTIVE','REVOKED')
* last_seen_at : datetime
* notes : text
* created_by : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm biometric_device_audit_events
* id : bigint(20) unsigned
* device_id : bigint(20) unsigned
* entity_type : varchar(50)
* entity_id : varchar(100)
* action_code : varchar(80)
* actor_user_id : smallint(5) unsigned
* request_id : varchar(80)
* before_json : longtext
* after_json : longtext
* metadata_json : longtext
* event_at_utc : datetime
* created_at : datetime
v sgm_crm biometric_device_capability_profiles
* id : bigint(20) unsigned
* provider_code : varchar(30)
* model_pattern : varchar(100)
* profile_version : varchar(40)
* supports_user_management : tinyint(1)
* supports_face : tinyint(1)
* supports_fingerprint : tinyint(1)
* supports_card : tinyint(1)
* supports_time_sync : tinyint(1)
* supports_config_read : tinyint(1)
* supports_config_write : tinyint(1)
* supports_remote_commands : tinyint(1)
* supports_event_pull : tinyint(1)
* supports_event_push : tinyint(1)
* capabilities_json : longtext
* is_active : tinyint(1)
* created_by : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm biometric_device_commands
* id : bigint(20) unsigned
* command_uuid : char(36)
* device_id : bigint(20) unsigned
* connector_instance_id : bigint(20) unsigned
* command_type : varchar(60)
* command_status : varchar(30)
* priority : smallint(5) unsigned
* payload_json : longtext
* result_json : longtext
* error_message : varchar(1000)
* requested_by : smallint(5) unsigned
* requested_at : datetime
* not_before_at : datetime
* expires_at : datetime
* claimed_at : datetime
* started_at : datetime
* completed_at : datetime
* attempt_count : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm biometric_device_configuration_state
* id : bigint(20) unsigned
* device_id : bigint(20) unsigned
* connector_instance_id : bigint(20) unsigned
* device_name : varchar(160)
* firmware_version : varchar(80)
* firmware_released_date : varchar(80)
* local_time : varchar(40)
* timezone_raw : varchar(80)
* time_mode : varchar(30)
* network_endpoint_supported : tinyint(1)
* network_interface_id : varchar(50)
* addressing_type : varchar(30)
* ip_address : varchar(64)
* subnet_mask : varchar(64)
* default_gateway : varchar(64)
* mac_address : varchar(64)
* mtu : int(10) unsigned
* dns_json : longtext
* endpoint_count : smallint(5) unsigned
* read_supported_count : smallint(5) unsigned
* configuration_read_surface_detected : tinyint(1)
* access_control_config_read_supported : tinyint(1)
* system_capabilities_read_supported : tinyint(1)
* system_status_read_supported : tinyint(1)
* storage_read_supported : tinyint(1)
* safe_endpoints_json : longtext
* profile_hash : char(64)
* collected_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm biometric_device_enrollments
* id : bigint(20) unsigned
* device_id : bigint(20) unsigned
* device_user_id : bigint(20) unsigned
* enrollment_type : varchar(30)
* enrollment_key : varchar(100)
* enrollment_status : varchar(30)
* template_hash : char(64)
* enrolled_at : datetime
* last_verified_at : datetime
* metadata_json : longtext
* created_by : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm biometric_device_users
* id : bigint(20) unsigned
* device_id : bigint(20) unsigned
* device_person_id : varchar(80)
* display_name : varchar(160)
* device_user_role : varchar(30)
* device_user_status : varchar(30)
* sync_status : varchar(30)
* source_mode : varchar(30)
* profile_hash : char(64)
* last_synced_at : datetime
* last_seen_on_device_at : datetime
* raw_profile_json : longtext
* created_by : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm biometric_employee_mappings
* id : bigint(20) unsigned
* device_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* device_person_id : varchar(80)
* status : enum('ACTIVE','INACTIVE')
* valid_from_utc : datetime
* valid_until_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm biometric_events_raw
* id : bigint(20) unsigned
* device_id : bigint(20) unsigned
* connector_instance_id : bigint(20) unsigned
* employee_mapping_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* external_event_id : varchar(128)
* event_fingerprint : char(64)
* event_type : varchar(30)
* verify_mode : varchar(30)
* direction : enum('IN','OUT','UNKNOWN')
* device_person_id : varchar(80)
* occurred_at_utc : datetime
* device_local_time : datetime
* device_timezone : varchar(64)
* raw_payload_json : longtext
* processing_status : enum('UNPROCESSED','UNMAPPED','PROCESSED','REJECTED')
* received_at_utc : datetime
* processed_at_utc : datetime
* processing_error : varchar(500)
* created_at : datetime
v sgm_crm biometric_sync_state
* id : bigint(20) unsigned
* connector_instance_id : bigint(20) unsigned
* device_id : bigint(20) unsigned
* state_type : enum('AUTH_NONCE','EVENT_CURSOR','DEVICE_STATE')
* state_key : varchar(191)
* state_value_json : longtext
* expires_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_crm camcom
* locdvr_id : int(11)
* location_id : int(11)
* dvr_name : varchar(200)
* model : varchar(100)
* serial : varchar(100)
* dvr_ip : varchar(200)
* dvr_port : varchar(10)
* dvr_usr : varchar(100)
* dvr_pwd : varchar(50)
* dvr_agchannels : int(11)
* dvr_ipchannels : int(11)
* motion_enabled : int(11)
* httpport : int(11)
* rtspport : int(11)
* stime : time
* etime : time
* rec_date : datetime
* status : int(11)
* rtsp_URL : varchar(500)
* created_by_user_id : int(11)
v sgm_crm camcom_settings
* id : tinyint(4)
* video_service_url : varchar(500)
v sgm_crm caste_category
* id : int(11)
* category_name : varchar(100)
* active_status : tinyint(1)
* sort_order : int(11)
* branch_id : int(10)
* created_at : timestamp
* updated_at : timestamp
v sgm_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)
* source_pdf_name : varchar(255)
* report_info_json : longtext
* delete_status : tinyint(1)
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v sgm_crm cnc_job_parts
* id : int(10) unsigned
* job_id : int(10) unsigned
* part_name : varchar(150)
* source_name : varchar(255)
* part_id : varchar(100)
* gallery_file_id : bigint(20) unsigned
* unit_price : decimal(15,2)
* line_total : decimal(15,2)
* match_status : enum('mapped','unknown','manual')
* reference_thumbnail : longtext
* qty : int(10) unsigned
* operation_remark : varchar(200)
* delete_status : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v sgm_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 sgm_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 sgm_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 sgm_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 sgm_crm crm_customer_role
* id : int(11)
* role_name : varchar(255)
* is_active : tinyint(4)
v sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_crm crm_service_types
* id : int(10) unsigned
* type_name : varchar(50)
* is_active : tinyint(1)
v sgm_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 sgm_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 : bigint(20) unsigned
* 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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_crm customer_segment
* id : int(10) unsigned
* title : varchar(100)
* description : text
* is_default : enum('Y','N')
* active_status : tinyint(1)
* branch_id_deleted : int(11)
* created_by : int(11)
* modified_by : int(11)
* created_at : datetime
* updated_at : datetime
* delete_status : tinyint(1)
v sgm_crm customer_tracking_locations
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* customer_ledger_id : bigint(20) unsigned
* latitude : decimal(10,7)
* longitude : decimal(10,7)
* enabled : tinyint(1)
* updated_by : int(10) unsigned
* updated_at : datetime(3)
v sgm_crm daily_financial_summary
* summary_date : date
* branch_id : int(11)
* finance_year_id : int(11)
* total_sales : decimal(12,2)
* total_purchases : decimal(12,2)
* total_receipts : decimal(12,2)
* total_payments : decimal(12,2)
* source_modified_at : datetime
* refreshed_at : datetime
v sgm_crm 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)
* id : bigint(20) unsigned
* finance_year_id : int(10) unsigned
* balance_date : date
* 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)
v sgm_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 sgm_crm dashboard_monthly_summary
* branch_id : int(11)
* finance_year_id : int(11)
* summary_year : smallint(6)
* summary_month : tinyint(4)
* total_sales : decimal(18,2)
* total_purchases : decimal(18,2)
* total_receipts : decimal(18,2)
* total_payments : decimal(18,2)
* total_sales_return : decimal(18,2)
* total_purchase_return : decimal(18,2)
* total_revenue : decimal(18,2)
* total_expenditure : decimal(18,2)
* total_profit : decimal(18,2)
* period_end : date
* source_modified_at : datetime
* refreshed_at : datetime
v sgm_crm dashboard_summary_snapshot
* id : bigint(20) unsigned
* branch_id : int(11)
* finance_year_id : int(11)
* summary_date : date
* total_sales : decimal(18,2)
* total_purchases : decimal(18,2)
* total_receipts : decimal(18,2)
* total_payments : decimal(18,2)
* total_sales_return : decimal(18,2)
* total_purchase_return : decimal(18,2)
* total_revenue : decimal(18,2)
* total_expenditure : decimal(18,2)
* total_profit : decimal(18,2)
* top_customer_id : bigint(20) unsigned
* top_customer : varchar(255)
* top_customer_amount : decimal(18,2)
* top_item_id : bigint(20) unsigned
* top_item : varchar(255)
* top_item_quantity : decimal(18,2)
* top_item_revenue : decimal(18,2)
* total_customers : int(11)
* total_suppliers : int(11)
* total_visits : int(11)
* total_leads : int(11)
* total_employees : int(11)
* source_modified_at : datetime
* last_updated : datetime
v sgm_crm dashboard_yearly_summary
* branch_id : int(11)
* finance_year_id : int(11)
* fiscal_year_start : year(4)
* total_sales : decimal(18,2)
* total_purchases : decimal(18,2)
* total_receipts : decimal(18,2)
* total_payments : decimal(18,2)
* total_sales_return : decimal(18,2)
* total_purchase_return : decimal(18,2)
* total_revenue : decimal(18,2)
* total_expenditure : decimal(18,2)
* total_profit : decimal(18,2)
* period_start : date
* period_end : date
* source_modified_at : datetime
* refreshed_at : datetime
v sgm_crm date_range_filters
* id : tinyint(3) unsigned
* filter_name : varchar(50)
* query_value : varchar(50)
* is_active : tinyint(1)
* is_default : tinyint(1)
v sgm_crm discount_calculation_sheets
* id : bigint(20) unsigned
* branch_id : int(11)
* fiscal_year_id : int(11)
* base_price : decimal(18,2)
* quantity : decimal(18,4)
* created_by : int(11)
* modified_by : int(11)
* created_at : datetime
* modified_at : datetime
v sgm_crm discount_calculation_sheet_rows
* id : bigint(20) unsigned
* sheet_id : bigint(20) unsigned
* row_order : int(10) unsigned
* sl_no : int(11)
* product_name : varchar(255)
* standard_discount : decimal(9,4)
* additional_discount : decimal(9,4)
* otl_discount : decimal(9,4)
* special_discount : decimal(9,4)
* plant_discount : decimal(9,4)
* other_discount_1 : decimal(9,4)
* other_discount_2 : decimal(9,4)
* other_discount_3 : decimal(9,4)
* freight_percent : decimal(9,4)
* gst_percent : decimal(9,4)
* created_at : datetime
* modified_at : datetime
v sgm_crm discount_categories
* id : int(11)
* entry_type : enum('Discounts','Adjustments')
* ledger_id : int(11)
* category_type_deleted : enum('Fixed','Percentage')
* category_value_deleted : decimal(10,2)
* is_full_cash_discount : enum('Y','N')
* is_proportionate_deleted : enum('Y','N')
* is_round_off_discount : enum('Y','N')
* item_wise_proportionate : enum('Y','N')
* is_delete : enum('Y','N')
* created_at : timestamp
* modified_at : timestamp
v sgm_crm discount_credit_note_entries
* id : bigint(20) unsigned
* ref_entry_id : bigint(20) unsigned
* ref_invoice_no : varchar(50)
* ref_invoice_date : date
* voucher_number : varchar(50)
* voucher_type_id : bigint(20)
* entry_mode : enum('Cash','Party')
* urd : enum('Y','N')
* voucher_date : date
* voucher_time : time
* due_date : date
* ledger_id : int(10) unsigned
* party_cat_id : int(11)
* amount : decimal(10,2)
* sgst_amount : decimal(10,2)
* cgst_amount : decimal(10,2)
* igst_amount : decimal(10,2)
* cess_amount : decimal(10,2)
* round_off : decimal(12,2)
* invoice_amount : decimal(12,2) unsigned
* 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
* posting_status : enum('Pending','Posted')
* source_module : varchar(40)
* source_id : bigint(20) unsigned
* source_reference : varchar(60)
* source_locked : tinyint(1) unsigned
v sgm_crm discount_credit_note_entry_items
* id : bigint(20) unsigned
* expense_entry_id : bigint(20) unsigned
* ledger_id : bigint(20) unsigned
* hsn_sac_id : bigint(20) unsigned
* amount : decimal(10,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 sgm_crm discount_rebate_approvals
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* approval_rule_id : bigint(20) unsigned
* approval_level : tinyint(3) unsigned
* required_role_id : smallint(5) unsigned
* assigned_user_id : int(10) unsigned
* decision : enum('PENDING','APPROVED','REJECTED','SKIPPED')
* acted_by : int(10) unsigned
* remarks : varchar(500)
* requested_at : datetime
* acted_at : datetime
* branch_id : int(10) unsigned
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_approval_rules
* id : bigint(20) unsigned
* scheme_id : bigint(20) unsigned
* approval_level : tinyint(3) unsigned
* minimum_claim_amount : decimal(18,2)
* maximum_claim_amount : decimal(18,2)
* approver_role_id : smallint(5) unsigned
* is_mandatory : tinyint(1)
* is_final_level : tinyint(1)
* 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 sgm_crm discount_rebate_claims
* id : bigint(20) unsigned
* claim_no : varchar(60)
* claim_sequence_no : smallint(5) unsigned
* idempotency_key : varchar(64)
* scheme_id : bigint(20) unsigned
* agreement_id : bigint(20) unsigned
* ledger_id : bigint(20) unsigned
* period_from : date
* period_to : date
* turnover_basis : enum('TAXABLE_VALUE','NET_INVOICE_VALUE','COLLECTION_VALUE')
* gross_sales_amount : decimal(18,2)
* sales_return_amount : decimal(18,2)
* eligible_turnover_amount : decimal(18,2)
* collection_amount : decimal(18,2)
* target_amount : decimal(18,2)
* achievement_percent : decimal(9,4)
* applicable_discount_rate : decimal(9,4)
* fixed_discount_amount : decimal(18,2)
* discount_amount : decimal(18,2)
* cgst_amount : decimal(18,2)
* sgst_amount : decimal(18,2)
* igst_amount : decimal(18,2)
* cess_amount : decimal(18,2)
* round_off : decimal(18,2)
* gross_credit_amount : decimal(18,2)
* document_type : enum('UNDECIDED','GST_CREDIT_NOTE','COMMERCIAL_CREDIT_NOTE','FINANCIAL_ADJUSTMENT')
* agreement_pre_supply : enum('Y','N','NA')
* taxable_value_reduction : enum('Y','N','NA')
* itc_reversal_required : enum('Y','N','NA')
* decision_reason : varchar(500)
* status : enum('DRAFT','CALCULATED','SUBMITTED','APPROVAL_PENDING','APPROVED','REJECTED','CREDIT_NOTE_CREATED','POSTED','CANCELLED','REVERSED')
* calculation_version : int(10) unsigned
* row_version : int(10) unsigned
* source_snapshot_hash : char(64)
* snapshot_at : datetime
* credit_note_entry_id : bigint(20) unsigned
* credit_note_voucher_no : varchar(50)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* submitted_by : int(10) unsigned
* approved_by : int(10) unsigned
* posted_by : int(10) unsigned
* rejected_by : int(10) unsigned
* reversed_by : int(10) unsigned
* submitted_at : datetime
* approved_at : datetime
* posted_at : datetime
* rejected_at : datetime
* reversed_at : datetime
* rejection_reason : varchar(500)
* reversal_reason : varchar(500)
* delete_status : tinyint(1)
* deleted_by : int(10) unsigned
* deleted_at : datetime
* created_at : datetime
* updated_at : datetime
* discount_basis_mode : enum('TAXABLE_BASE','DOCUMENT_VALUE')
* discount_base_amount : decimal(18,2)
* discount_amount_semantics : enum('TAXABLE_DISCOUNT','GROSS_CREDIT')
* taxable_discount_amount : decimal(18,2)
* allocation_engine : varchar(60)
v sgm_crm discount_rebate_claim_events
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* event_type : enum('DRAFT_CREATED','DRAFT_RECALCULATED','SUBMITTED','APPROVAL_REQUESTED','APPROVED','REJECTED','CREDIT_NOTE_CREATED','POSTED','CANCELLED','REVERSED')
* from_status : varchar(30)
* to_status : varchar(30)
* snapshot_hash : char(64)
* remarks : varchar(500)
* user_id : int(10) unsigned
* branch_id : int(10) unsigned
* created_at : datetime
v sgm_crm discount_rebate_claim_number_series
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* prefix : varchar(20)
* padding : tinyint(3) unsigned
* next_number : bigint(20) unsigned
* last_claim_id : bigint(20) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_config_audit
* id : bigint(20) unsigned
* entity_type : enum('SCHEME','AGREEMENT','APPROVAL_RULE')
* entity_id : bigint(20) unsigned
* event_type : enum('CREATE','UPDATE','DELETE')
* before_snapshot : longtext
* after_snapshot : longtext
* branch_id : int(10) unsigned
* user_id : int(10) unsigned
* request_ip : varbinary(16)
* created_at : datetime
v sgm_crm discount_rebate_credit_allocations
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* credit_note_entry_id : bigint(20) unsigned
* sales_entry_id : bigint(20) unsigned
* invoice_outstanding_id : bigint(20) unsigned
* allocation_date : date
* allocated_amount : decimal(18,2)
* allocation_type : enum('AUTO','MANUAL')
* status : enum('ACTIVE','REVERSED')
* reversal_of_id : bigint(20) unsigned
* remarks : varchar(500)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_by : int(10) unsigned
* reversed_by : int(10) unsigned
* reversed_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_credit_note_cancellations
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* credit_note_entry_id : bigint(20) unsigned
* reversal_run_id : bigint(20) unsigned
* claim_no_snapshot : varchar(60)
* document_type : varchar(40)
* operation_mode : varchar(30)
* voucher_type_id : bigint(20) unsigned
* voucher_number : varchar(50)
* voucher_date : date
* source_state_hash : char(64)
* plan_hash : char(64)
* claim_row_version_before : int(10) unsigned
* credit_note_posting_status_before : varchar(20)
* credit_note_payment_status_before : varchar(20)
* cancellation_effective_date : date
* cancellation_reason : varchar(500)
* status : varchar(20)
* cancelled_by : int(10) unsigned
* cancelled_at : datetime
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_at : datetime
v sgm_crm discount_rebate_credit_note_cancellation_events
* id : bigint(20) unsigned
* cancellation_id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* credit_note_entry_id : bigint(20) unsigned
* event_type : varchar(50)
* state_hash_before : char(64)
* state_hash_after : char(64)
* details_json : longtext
* action_hash : char(64)
* user_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* request_ip : varchar(45)
* created_at : datetime
v sgm_crm discount_rebate_customer_agreements
* id : bigint(20) unsigned
* scheme_id : bigint(20) unsigned
* ledger_id : bigint(20) unsigned
* agreement_no : varchar(80)
* agreement_date : date
* valid_from : date
* valid_to : date
* customer_target_amount : decimal(18,2)
* custom_discount_rate : decimal(9,4)
* custom_fixed_discount_amount : decimal(18,2)
* document_path : varchar(500)
* status : enum('DRAFT','ACTIVE','EXPIRED','CANCELLED')
* remarks : text
* branch_id : int(10) unsigned
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* cancelled_by : int(10) unsigned
* cancelled_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_document_reviews
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* scheme_gst_treatment : enum('AUTO','GST_CREDIT_NOTE','COMMERCIAL_CREDIT_NOTE','FINANCIAL_ADJUSTMENT')
* document_type : enum('GST_CREDIT_NOTE','COMMERCIAL_CREDIT_NOTE','FINANCIAL_ADJUSTMENT')
* tax_effect : enum('REDUCE_OUTPUT_TAX','NO_GST_REDUCTION')
* agreement_pre_supply : enum('Y','N','NA')
* taxable_value_reduction : enum('Y','N','NA')
* itc_reversal_required : enum('Y','N','NA')
* decision_reason : varchar(500)
* final_discount_amount : decimal(18,2)
* final_cgst_amount : decimal(18,2)
* final_sgst_amount : decimal(18,2)
* final_igst_amount : decimal(18,2)
* final_cess_amount : decimal(18,2)
* final_gross_credit_amount : decimal(18,2)
* reviewed_by : int(10) unsigned
* reviewed_at : datetime
* branch_id : int(10) unsigned
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_gst_credit_note_generations
* id : bigint(20) unsigned
* plan_run_id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* credit_note_entry_id : bigint(20) unsigned
* plan_overall_hash : char(64)
* generation_hash : char(64)
* voucher_type_id : bigint(20)
* voucher_series_id : bigint(20) unsigned
* voucher_sequence_no : bigint(20) unsigned
* voucher_number : varchar(50)
* voucher_date : date
* taxable_amount : decimal(18,2)
* cgst_amount : decimal(18,2)
* sgst_amount : decimal(18,2)
* igst_amount : decimal(18,2)
* cess_amount : decimal(18,2)
* round_off_amount : decimal(18,2)
* gross_credit_amount : decimal(18,2)
* item_line_count : int(10) unsigned
* status : enum('CREATED')
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_by : int(10) unsigned
* created_at : datetime
v sgm_crm discount_rebate_gst_hsn_plan_lines
* id : bigint(20) unsigned
* plan_run_id : bigint(20) unsigned
* line_no : int(10) unsigned
* ledger_id : bigint(20) unsigned
* hsn_sac_id : bigint(20) unsigned
* hsn_sac_code : varchar(30)
* hsn_description : varchar(255)
* hsn_type : varchar(20)
* amount : decimal(18,2)
* tax_percentage : decimal(9,4)
* cgst_percentage : decimal(9,4)
* sgst_percentage : decimal(9,4)
* igst_percentage : decimal(9,4)
* cess_percentage : decimal(9,4)
* generated_tax_amount : decimal(18,2)
* generated_cgst_amount : decimal(18,2)
* generated_sgst_amount : decimal(18,2)
* generated_igst_amount : decimal(18,2)
* generated_cess_amount : decimal(18,2)
* generated_gross_credit_amount : decimal(18,2)
* snapshot_cgst_amount : decimal(18,2)
* snapshot_sgst_amount : decimal(18,2)
* snapshot_igst_amount : decimal(18,2)
* snapshot_cess_amount : decimal(18,2)
* snapshot_gross_credit_amount : decimal(18,2)
* source_item_rows : int(10) unsigned
* source_invoice_count : int(10) unsigned
* line_hash : char(64)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_at : datetime
v sgm_crm discount_rebate_gst_plan_runs
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* claim_no_snapshot : varchar(60)
* claim_source_snapshot_hash : char(64)
* document_review_hash : char(64)
* document_type : varchar(40)
* tax_effect : varchar(40)
* jurisdiction : varchar(20)
* branch_gstin : varchar(20)
* recipient_gstin : varchar(50)
* branch_state_id : smallint(5) unsigned
* recipient_state_id : smallint(5) unsigned
* selected_invoice_count : int(10) unsigned
* source_item_rows : int(10) unsigned
* trace_row_count : int(10) unsigned
* hsn_line_count : int(10) unsigned
* posting_line_count : int(10) unsigned
* snapshot_taxable_amount : decimal(18,2)
* snapshot_cgst_amount : decimal(18,2)
* snapshot_sgst_amount : decimal(18,2)
* snapshot_igst_amount : decimal(18,2)
* snapshot_cess_amount : decimal(18,2)
* snapshot_gross_credit_amount : decimal(18,2)
* generated_taxable_amount : decimal(18,2)
* generated_cgst_amount : decimal(18,2)
* generated_sgst_amount : decimal(18,2)
* generated_igst_amount : decimal(18,2)
* generated_cess_amount : decimal(18,2)
* generated_gross_credit_amount : decimal(18,2)
* round_off_amount : decimal(18,2)
* trace_set_hash : char(64)
* hsn_plan_hash : char(64)
* posting_plan_hash : char(64)
* overall_plan_hash : char(64)
* status : varchar(20)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_by : int(10) unsigned
* created_at : datetime
v sgm_crm discount_rebate_gst_posting_plan_lines
* id : bigint(20) unsigned
* plan_run_id : bigint(20) unsigned
* line_no : int(10) unsigned
* role : varchar(40)
* ledger_id : bigint(20) unsigned
* ledger_name_snapshot : varchar(250)
* entry_side : enum('DR','CR')
* dr_amount : decimal(18,2)
* cr_amount : decimal(18,2)
* line_hash : char(64)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_at : datetime
v sgm_crm discount_rebate_gst_posting_runs
* id : bigint(20) unsigned
* plan_run_id : bigint(20) unsigned
* generation_id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* credit_note_entry_id : bigint(20) unsigned
* voucher_type_id : bigint(20)
* voucher_no : varchar(50)
* voucher_date : date
* plan_overall_hash : char(64)
* generation_hash : char(64)
* frozen_posting_plan_hash : char(64)
* execution_plan_hash : char(64)
* status : varchar(30)
* expected_ledger_rows : smallint(5) unsigned
* actual_ledger_rows : smallint(5) unsigned
* expected_audit_rows : smallint(5) unsigned
* actual_audit_rows : smallint(5) unsigned
* outstanding_id : bigint(20) unsigned
* attempt_count : int(10) unsigned
* requires_repair : tinyint(1) unsigned
* last_error : varchar(1000)
* prepared_by : int(10) unsigned
* last_attempt_by : int(10) unsigned
* posted_by : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* prepared_at : datetime
* last_attempt_at : datetime
* posted_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_gst_posting_run_lines
* id : bigint(20) unsigned
* posting_run_id : bigint(20) unsigned
* line_no : smallint(5) unsigned
* source_plan_line_id : bigint(20) unsigned
* source_plan_line_no : int(10) unsigned
* source_line_hash : char(64)
* role : varchar(40)
* ledger_id : bigint(20) unsigned
* ledger_name_snapshot : varchar(250)
* ledger_group_id : bigint(20) unsigned
* entry_side : enum('DR','CR')
* dr_amount : decimal(18,2)
* cr_amount : decimal(18,2)
* correspondent_ledger_id : bigint(20) unsigned
* corr_ledger_group_id : bigint(20) unsigned
* sort_order : smallint(5) unsigned
* is_main_row : tinyint(3) unsigned
* cash_or_bank : enum('Cash','Bank','Party')
* by_or_to : enum('By','To')
* txn_date : date
* narration : varchar(500)
* row_fingerprint : char(64)
* ledger_posting_id : bigint(20) unsigned
* audit_posting_id : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_gst_reversal_compliance
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* credit_note_entry_id : bigint(20) unsigned
* source_itc_tracking_id : bigint(20) unsigned
* claim_no_snapshot : varchar(60)
* document_type : varchar(40)
* source_itc_status_snapshot : varchar(30)
* source_itc_reversal_amount_snapshot : decimal(18,2)
* actual_posted_gst_amount_snapshot : decimal(18,2)
* reversal_effective_date : date
* step11b_policy_foundation_hash : char(64)
* source_state_hash : char(64)
* accounting_period_policy_hash : char(64)
* accounting_period_snapshot_hash : char(64)
* tax_filing_guard_source : varchar(100)
* tax_period_from : date
* tax_period_to : date
* tax_period_reference : varchar(191)
* tax_filing_reference : varchar(191)
* tax_filing_status_snapshot : varchar(60)
* review_outcome_code : varchar(50)
* review_reason : varchar(1000)
* is_final : tinyint(1)
* record_hash : char(64)
* reviewed_by : int(10) unsigned
* reviewed_at : datetime
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_at : datetime
v sgm_crm discount_rebate_gst_reversal_compliance_events
* id : bigint(20) unsigned
* compliance_id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* credit_note_entry_id : bigint(20) unsigned
* source_itc_tracking_id : bigint(20) unsigned
* event_type : varchar(50)
* details_json : longtext
* action_hash : char(64)
* user_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* request_ip : varchar(45)
* created_at : datetime
v sgm_crm discount_rebate_gst_source_trace
* id : bigint(20) unsigned
* plan_run_id : bigint(20) unsigned
* line_no : int(10) unsigned
* claim_id : bigint(20) unsigned
* invoice_allocation_id : bigint(20) unsigned
* tax_allocation_id : bigint(20) unsigned
* sales_entry_id : bigint(20) unsigned
* sales_entry_item_id : bigint(20) unsigned
* item_id : bigint(20) unsigned
* hsn_sac_id : bigint(20) unsigned
* invoice_voucher_no : varchar(60)
* invoice_date : date
* hsn_sac_code : varchar(30)
* hsn_description : varchar(255)
* hsn_type : varchar(20)
* source_item_taxable_amount : decimal(18,2)
* discount_taxable_amount : decimal(18,2)
* tax_percentage : decimal(9,4)
* cgst_percentage : decimal(9,4)
* sgst_percentage : decimal(9,4)
* igst_percentage : decimal(9,4)
* cess_percentage : decimal(9,4)
* snapshot_cgst_amount : decimal(18,2)
* snapshot_sgst_amount : decimal(18,2)
* snapshot_igst_amount : decimal(18,2)
* snapshot_cess_amount : decimal(18,2)
* snapshot_gross_credit_amount : decimal(18,2)
* trace_mode : varchar(60)
* trace_hash : char(64)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* created_at : datetime
v sgm_crm discount_rebate_invoice_allocations
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* sales_entry_id : bigint(20) unsigned
* invoice_voucher_no : varchar(50)
* invoice_date : date
* invoice_gross_amount : decimal(18,2)
* invoice_taxable_amount : decimal(18,2)
* return_taxable_amount : decimal(18,2)
* eligible_amount : decimal(18,2)
* collected_amount : decimal(18,2)
* allocation_percent : decimal(12,8)
* discount_amount : decimal(18,2)
* cgst_amount : decimal(18,2)
* sgst_amount : decimal(18,2)
* igst_amount : decimal(18,2)
* cess_amount : decimal(18,2)
* gross_credit_amount : decimal(18,2)
* allocation_status : enum('ELIGIBLE','SELECTED','EXCLUDED','POSTED','REVERSED')
* exclude_reason : varchar(255)
* source_snapshot_hash : char(64)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_itc_evidence
* id : bigint(20) unsigned
* itc_tracking_id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* original_file_name : varchar(255)
* stored_file_name : varchar(255)
* storage_path : varchar(500)
* mime_type : varchar(100)
* byte_size : bigint(20) unsigned
* sha256_hex : char(64)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* uploaded_by : int(10) unsigned
* delete_status : tinyint(1)
* deleted_by : int(10) unsigned
* created_at : datetime
* deleted_at : datetime
v sgm_crm discount_rebate_itc_tracking
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* status : enum('NOT_REQUIRED','PENDING','CONFIRMED','REJECTED')
* recipient_gstin : varchar(20)
* itc_reversal_amount : decimal(18,2)
* confirmation_reference : varchar(100)
* confirmation_date : date
* evidence_path : varchar(500)
* remarks : varchar(500)
* confirmed_by : int(10) unsigned
* confirmed_at : datetime
* branch_id : int(10) unsigned
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_itc_tracking_audit
* id : bigint(20) unsigned
* itc_tracking_id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* action_type : varchar(40)
* from_status : varchar(20)
* to_status : varchar(20)
* expected_itc_reversal_amount : decimal(18,2)
* stored_itc_reversal_amount_before : decimal(18,2)
* stored_itc_reversal_amount_after : decimal(18,2)
* recipient_gstin_snapshot : varchar(20)
* confirmation_reference_snapshot : varchar(100)
* confirmation_date_snapshot : date
* evidence_count : smallint(5) unsigned
* before_snapshot : longtext
* after_snapshot : longtext
* action_hash : char(64)
* user_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* request_ip : varchar(45)
* created_at : datetime
v sgm_crm discount_rebate_posting_runs
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* credit_note_entry_id : bigint(20) unsigned
* voucher_type_id : bigint(20) unsigned
* voucher_no : varchar(50)
* plan_hash : char(64)
* status : varchar(30)
* expected_ledger_rows : smallint(5) unsigned
* actual_ledger_rows : smallint(5) unsigned
* expected_audit_rows : smallint(5) unsigned
* actual_audit_rows : smallint(5) unsigned
* outstanding_id : bigint(20) unsigned
* attempt_count : int(10) unsigned
* requires_repair : tinyint(1) unsigned
* last_error : varchar(1000)
* prepared_by : int(10) unsigned
* last_attempt_by : int(10) unsigned
* posted_by : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* prepared_at : datetime
* last_attempt_at : datetime
* posted_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_posting_run_lines
* id : bigint(20) unsigned
* posting_run_id : bigint(20) unsigned
* line_no : smallint(5) unsigned
* ledger_id : bigint(20) unsigned
* ledger_group_id : smallint(5) unsigned
* entry_side : enum('DR','CR')
* dr_amount : decimal(18,2)
* cr_amount : decimal(18,2)
* correspondent_ledger_id : bigint(20) unsigned
* corr_ledger_group_id : smallint(5) unsigned
* sort_order : tinyint(4)
* is_main_row : tinyint(4)
* cash_or_bank : enum('Cash','Bank','Party')
* by_or_to : enum('By','To')
* txn_date : date
* narration : varchar(500)
* row_fingerprint : char(64)
* ledger_posting_id : bigint(20) unsigned
* audit_posting_id : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_reversal_allocation_lines
* id : bigint(20) unsigned
* reversal_run_id : bigint(20) unsigned
* line_no : int(10) unsigned
* source_allocation_id : bigint(20) unsigned
* source_sales_entry_id : bigint(20) unsigned
* source_invoice_outstanding_id : bigint(20) unsigned
* source_allocated_amount : decimal(18,2)
* source_allocation_type : varchar(20)
* source_allocation_status : varchar(20)
* source_reversal_of_id : bigint(20) unsigned
* source_snapshot_hash : char(64)
* planned_action : varchar(40)
* execution_status : varchar(20)
* executed_reversal_allocation_id : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_reversal_events
* id : bigint(20) unsigned
* reversal_run_id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* event_type : varchar(50)
* from_status : varchar(30)
* to_status : varchar(30)
* state_hash_before : char(64)
* state_hash_after : char(64)
* details_json : longtext
* action_hash : char(64)
* user_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* request_ip : varchar(45)
* created_at : datetime
v sgm_crm discount_rebate_reversal_outstanding_lines
* id : bigint(20) unsigned
* reversal_run_id : bigint(20) unsigned
* line_no : smallint(5) unsigned
* source_outstanding_id : bigint(20) unsigned
* source_voucher_type_id : bigint(20) unsigned
* source_voucher_id : bigint(20) unsigned
* source_voucher_number : varchar(50)
* source_ledger_id : bigint(20) unsigned
* source_dr_amount : decimal(18,2)
* source_cr_amount : decimal(18,2)
* source_delete_status : tinyint(1)
* source_is_cancelled : char(1)
* source_snapshot_hash : char(64)
* planned_action : varchar(40)
* execution_status : varchar(20)
* post_state_hash : char(64)
* executed_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_reversal_periods
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* period_label : varchar(100)
* period_start : date
* period_end : date
* is_open : tinyint(1) unsigned
* remarks : varchar(500)
* row_version : int(10) unsigned
* opened_by : int(10) unsigned
* opened_at : datetime
* closed_by : int(10) unsigned
* closed_at : datetime
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_reversal_period_events
* id : bigint(20) unsigned
* period_id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* event_type : varchar(40)
* state_hash_before : char(64)
* state_hash_after : char(64)
* details_json : longtext
* action_hash : char(64)
* user_id : int(10) unsigned
* request_ip : varchar(45)
* created_at : datetime
v sgm_crm discount_rebate_reversal_runs
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* claim_no_snapshot : varchar(60)
* operation_mode : varchar(30)
* document_type : varchar(40)
* source_credit_note_entry_id : bigint(20) unsigned
* source_voucher_type_id : bigint(20) unsigned
* source_voucher_no : varchar(50)
* source_state_hash : char(64)
* source_claim_row_version : int(10) unsigned
* source_claim_snapshot_hash : char(64)
* source_posting_family : varchar(20)
* source_posting_run_id : bigint(20) unsigned
* source_posting_plan_hash : char(64)
* source_itc_status : varchar(20)
* reason : varchar(500)
* requested_effective_date : date
* plan_hash : char(64)
* idempotency_key : char(64)
* status : varchar(30)
* expected_allocation_rows : int(10) unsigned
* actual_allocation_rows : int(10) unsigned
* expected_ledger_rows : smallint(5) unsigned
* actual_ledger_rows : smallint(5) unsigned
* expected_audit_rows : smallint(5) unsigned
* actual_audit_rows : smallint(5) unsigned
* expected_outstanding_rows : smallint(5) unsigned
* actual_outstanding_rows : smallint(5) unsigned
* requires_repair : tinyint(1) unsigned
* last_error : varchar(1000)
* prepared_by : int(10) unsigned
* last_attempt_by : int(10) unsigned
* completed_by : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* prepared_at : datetime
* last_attempt_at : datetime
* completed_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_reversal_run_lines
* id : bigint(20) unsigned
* reversal_run_id : bigint(20) unsigned
* line_no : smallint(5) unsigned
* source_posting_family : varchar(20)
* source_posting_run_line_id : bigint(20) unsigned
* source_ledger_posting_id : bigint(20) unsigned
* source_audit_posting_id : bigint(20) unsigned
* source_row_fingerprint : char(64)
* ledger_id : bigint(20) unsigned
* ledger_group_id : bigint(20) unsigned
* original_entry_side : enum('DR','CR')
* original_dr_amount : decimal(18,2)
* original_cr_amount : decimal(18,2)
* reversal_entry_side : enum('DR','CR')
* reversal_dr_amount : decimal(18,2)
* reversal_cr_amount : decimal(18,2)
* correspondent_ledger_id : bigint(20) unsigned
* corr_ledger_group_id : bigint(20) unsigned
* sort_order : smallint(5) unsigned
* is_main_row : tinyint(1) unsigned
* cash_or_bank : enum('Cash','Bank','Party')
* by_or_to : enum('By','To')
* txn_date : date
* narration : varchar(500)
* reversal_row_fingerprint : char(64)
* reversal_ledger_posting_id : bigint(20) unsigned
* reversal_audit_posting_id : bigint(20) unsigned
* execution_status : varchar(20)
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_reversal_settings
* id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* reversal_plan_write_enabled : tinyint(1) unsigned
* allocation_reversal_execute_enabled : tinyint(1) unsigned
* outstanding_reversal_execute_enabled : tinyint(1) unsigned
* reversal_execute_enabled : tinyint(1) unsigned
* cancellation_execute_enabled : tinyint(1) unsigned
* gst_reversal_execute_enabled : tinyint(1) unsigned
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_schemes
* id : bigint(20) unsigned
* scheme_code : varchar(40)
* scheme_name : varchar(150)
* scheme_type : enum('TRADE_DISCOUNT','VOLUME_DISCOUNT','ANNUAL_DISCOUNT','TARGET_ACHIEVEMENT','EARLY_PAYMENT','SETTLEMENT','PERFORMANCE','RENEWAL','COMMERCIAL_REBATE','OTHER')
* calculation_method : enum('PERCENTAGE','FIXED','SLAB')
* turnover_basis : enum('TAXABLE_VALUE','NET_INVOICE_VALUE','COLLECTION_VALUE')
* claim_frequency : enum('MONTHLY','QUARTERLY','HALF_YEARLY','ANNUAL','ON_DEMAND')
* valid_from : date
* valid_to : date
* minimum_turnover : decimal(18,2)
* maximum_turnover : decimal(18,2)
* target_amount : decimal(18,2)
* default_discount_rate : decimal(9,4)
* fixed_discount_amount : decimal(18,2)
* maximum_discount_amount : decimal(18,2)
* return_treatment : enum('SUBTRACT_POSTED','IGNORE')
* agreement_required : tinyint(1)
* gst_treatment_mode : enum('AUTO','GST_CREDIT_NOTE','COMMERCIAL_CREDIT_NOTE','FINANCIAL_ADJUSTMENT')
* itc_confirmation_required : tinyint(1)
* approval_required : tinyint(1)
* allow_partial_claim : tinyint(1)
* allow_multiple_claims_per_period : tinyint(1)
* discount_ledger_id : bigint(20) unsigned
* priority : smallint(5) unsigned
* notes : text
* branch_id : int(10) unsigned
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* deleted_by : int(10) unsigned
* deleted_at : datetime
* created_at : datetime
* updated_at : datetime
* discount_basis_mode : enum('TAXABLE_BASE','DOCUMENT_VALUE')
v sgm_crm discount_rebate_scheme_slabs
* id : bigint(20) unsigned
* scheme_id : bigint(20) unsigned
* slab_no : smallint(5) unsigned
* basis_type : enum('TURNOVER','ACHIEVEMENT_PERCENT','COLLECTION')
* from_value : decimal(18,4)
* to_value : decimal(18,4)
* discount_rate : decimal(9,4)
* fixed_discount_amount : decimal(18,2)
* 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 sgm_crm discount_rebate_scheme_targets
* id : bigint(20) unsigned
* scheme_id : bigint(20) unsigned
* target_type : enum('ALL','ITEM','CATEGORY','BRAND','CUSTOMER_SEGMENT','SALES_PERSON','TERRITORY')
* target_ref_id : bigint(20) unsigned
* target_action : enum('INCLUDE','EXCLUDE')
* branch_id : int(10) unsigned
* delete_status : tinyint(1)
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_settings
* id : int(10) unsigned
* branch_id : int(10) unsigned
* module_enabled : tinyint(1)
* posting_enabled : tinyint(1)
* credit_allocation_enabled : tinyint(1)
* gst_plan_enabled : tinyint(1)
* gst_credit_note_generation_enabled : tinyint(1)
* gst_posting_enabled : tinyint(1)
* itc_tracking_write_enabled : tinyint(1)
* approval_enabled : tinyint(1)
* allow_document_type_override : tinyint(1)
* require_itc_before_posting : tinyint(1)
* claim_prefix : varchar(20)
* claim_number_padding : tinyint(3) unsigned
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm discount_rebate_tax_allocations
* id : bigint(20) unsigned
* claim_id : bigint(20) unsigned
* invoice_allocation_id : bigint(20) unsigned
* sales_entry_id : bigint(20) unsigned
* sales_entry_item_id : bigint(20) unsigned
* item_id : bigint(20) unsigned
* hsn_sac_id : bigint(20) unsigned
* allocation_level : enum('INVOICE_RATE','ITEM')
* source_taxable_amount : decimal(18,2)
* return_taxable_amount : decimal(18,2)
* eligible_taxable_amount : decimal(18,2)
* discount_taxable_amount : decimal(18,2)
* tax_percentage : decimal(9,4)
* cgst_percentage : decimal(9,4)
* sgst_percentage : decimal(9,4)
* igst_percentage : decimal(9,4)
* cess_percentage : decimal(9,4)
* cgst_amount : decimal(18,2)
* sgst_amount : decimal(18,2)
* igst_amount : decimal(18,2)
* cess_amount : decimal(18,2)
* gross_credit_amount : decimal(18,2)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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
* tracking_no : varchar(50)
* tracking_date : date
* debit_note_no : varchar(50)
* debit_note_date : date
* grn_no : varchar(50)
* branch_id : int(10) unsigned
* created_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
* delete_status : tinyint(1)
v sgm_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 sgm_crm django_content_type
* id : int(11)
* app_label : varchar(100)
* model : varchar(100)
v sgm_crm django_migrations
* id : bigint(20)
* app : varchar(255)
* name : varchar(255)
* applied : datetime(6)
v sgm_crm django_session
* session_key : varchar(40)
* session_data : longtext
* expire_date : datetime(6)
v sgm_crm dynamic_pricing_source_cache
* id : bigint(20) unsigned
* branch_id : int(11)
* finance_year_id : int(11)
* item_id : int(11)
* last_purchase_price : decimal(18,4)
* last_purchase_entry_id : bigint(20) unsigned
* last_purchase_item_id : bigint(20) unsigned
* last_purchase_date : date
* average_sales_price : decimal(18,4)
* sales_value_sum : decimal(22,6)
* sales_quantity_sum : decimal(22,6)
* sales_row_count : int(10) unsigned
* lpp_refreshed_at : datetime
* asp_refreshed_at : datetime
* refreshed_at : datetime
* version_no : int(10) unsigned
* refreshed_by : int(11)
v sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_crm dynamic_sales_price_rules_v2
* id : bigint(20) unsigned
* branch_id : int(11)
* scope_type : varchar(20)
* scope_id : int(10) unsigned
* price_source : varchar(40)
* calculation_type : varchar(30)
* calculation_value : decimal(18,6)
* minimum_price : decimal(18,4)
* maximum_price : decimal(18,4)
* cap_at_mrp : tinyint(1)
* rounding_method : varchar(20)
* rounding_increment : decimal(18,4)
* effective_from : date
* effective_to : date
* is_active : tinyint(1)
* delete_status : tinyint(1)
* notes : varchar(1000)
* version_no : int(10) unsigned
* created_by : int(11)
* updated_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v sgm_crm dynamic_sales_price_rule_audit_v2
* id : bigint(20) unsigned
* rule_id : bigint(20) unsigned
* branch_id : int(11)
* event_type : varchar(20)
* before_snapshot : longtext
* after_snapshot : longtext
* user_id : int(11)
* request_ip : varbinary(16)
* created_at : timestamp
v sgm_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 sgm_crm einvoices_eway_log
* id : int(11)
* entry_type : varchar(50)
* voucher_type_id : int(11)
* entry_id : int(11)
* payload : longtext
* response : longtext
* created_by : int(11)
* added_at : timestamp
v sgm_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 sgm_crm email_scraper_documents
* id : varchar(64)
* user_id : int(11)
* message_id : varchar(190)
* filename : varchar(255)
* pdf_path : text
* content_sha256 : char(64)
* category : varchar(60)
* category_label : varchar(120)
* is_relevant : tinyint(1)
* processed_at : datetime
* email_from : text
* email_to : text
* email_subject : text
* email_date : varchar(80)
* vendor_name : varchar(190)
* document_date : varchar(40)
* total_amount : decimal(12,2)
* currency : varchar(10)
* document_number : varchar(190)
* confidence_score : decimal(5,4)
* relevance_reason : text
* uploaded_to_mysql : tinyint(4)
* invoice_check_status : varchar(32)
* invoice_checked_at : datetime
* invoice_check_error : text
* email_body : longtext
* email_snippet : text
* extracted_text : longtext
* json_path : text
* json_content : longtext
v sgm_crm email_scraper_invoices
* id : bigint(20) unsigned
* document_id : varchar(64)
* user_id : int(11)
* message_id : varchar(190)
* invoice_number : varchar(190)
* gst_number : varchar(30)
* supplier_name : varchar(200)
* invoice_json : longtext
* is_purchase_invoice : tinyint(1)
* is_invoice_moved : enum('Y','N')
* extraction_status : varchar(32)
* extraction_confidence : decimal(5,4)
* extraction_model : varchar(100)
* schema_version : smallint(5) unsigned
* extracted_at : datetime
* extraction_error : text
* source_pdf_path : text
* created_at : datetime
* updated_at : datetime
v sgm_crm email_scraper_messages
* user_id : int(11)
* message_id : varchar(190)
* email_from : text
* email_to : text
* email_subject : text
* email_date : varchar(80)
* email_received_at : datetime
* processed_at : datetime
v sgm_crm email_scraper_profiles
* user_id : int(11)
* company_names : longtext
* gst_number : varchar(30)
* registered_address : text
* known_vendors : longtext
* known_clients : longtext
v sgm_crm email_scraper_users
* id : int(11)
* google_id : varchar(120)
* email : varchar(190)
* name : varchar(190)
* picture : text
* access_token : text
* refresh_token : text
* token_expiry : bigint(20)
* created_at : datetime
* remember_token_hash : char(64)
* remember_token_expires : datetime
* smtp_host : varchar(190)
* smtp_port : int(11)
* smtp_username : varchar(190)
* smtp_password : text
* smtp_encryption : varchar(20)
* smtp_from_email : varchar(190)
* smtp_from_name : varchar(190)
* smtp_enabled : tinyint(1)
* smtp_updated_at : datetime
* sync_keywords : text
* last_sync_time : datetime
v sgm_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)
* branch_id : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_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
* date_of_birth : 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 sgm_crm employee_attendance_correction_events
* id : bigint(20) unsigned
* correction_request_id : bigint(20) unsigned
* event_type : varchar(30)
* actor_user_id : smallint(5) unsigned
* event_at_utc : datetime
* details_json : longtext
* created_at : datetime
v sgm_crm employee_attendance_correction_requests
* id : bigint(20) unsigned
* correction_uuid : char(36)
* attendance_day_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* branch_id : int(11)
* attendance_date : date
* request_type : varchar(40)
* reason_code : varchar(40)
* reason_text : varchar(500)
* requested_check_in_local_time : datetime
* requested_check_out_local_time : datetime
* clear_check_out : tinyint(1)
* daily_updated_at_snapshot : datetime
* before_snapshot_json : longtext
* after_snapshot_json : longtext
* status : enum('SUBMITTED','APPROVED','REJECTED','CANCELLED')
* requested_by_user_id : smallint(5) unsigned
* requested_at_utc : datetime
* reviewed_by_user_id : smallint(5) unsigned
* reviewed_at_utc : datetime
* review_comment : varchar(500)
* self_approval : tinyint(1)
* applied_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm employee_attendance_daily
* id : bigint(20) unsigned
* attendance_uuid : char(36)
* employee_id : int(10) unsigned
* user_id : smallint(5) unsigned
* branch_id : int(11)
* finance_year_id : smallint(5) unsigned
* attendance_date : date
* timezone_name : varchar(64)
* check_in_at_utc : datetime
* check_out_at_utc : datetime
* check_in_local_time : datetime
* check_out_local_time : datetime
* check_in_source : varchar(30)
* check_out_source : varchar(30)
* source_mode : varchar(30)
* resolution_status : varchar(40)
* decision_policy_version : varchar(80)
* duration_minutes : decimal(10,2) unsigned
* is_finalized : tinyint(1)
* finalized_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm employee_attendance_evidence
* id : bigint(20) unsigned
* attendance_day_id : bigint(20) unsigned
* evidence_key : varchar(191)
* source_type : varchar(30)
* source_record_id : bigint(20) unsigned
* evidence_role : varchar(30)
* occurred_at_utc : datetime
* local_time : datetime
* timezone_name : varchar(64)
* is_explicit : tinyint(1)
* confidence : varchar(30)
* metadata_json : longtext
* created_at : datetime
v sgm_crm employee_attendance_overtime_reviews
* id : bigint(20) unsigned
* attendance_day_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* branch_id : int(11)
* potential_minutes : int(10) unsigned
* approved_minutes : int(10) unsigned
* review_status : enum('PENDING','APPROVED','REJECTED')
* reviewed_by_user_id : smallint(5) unsigned
* review_comment : varchar(500)
* reviewed_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm employee_leave_events
* id : bigint(20) unsigned
* leave_request_id : bigint(20) unsigned
* event_type : varchar(40)
* actor_user_id : smallint(5) unsigned
* event_at_utc : datetime
* details_json : longtext
* created_at : datetime
v sgm_crm employee_leave_requests
* id : bigint(20) unsigned
* request_uuid : char(36)
* employee_id : int(10) unsigned
* branch_id : int(11)
* leave_type_id : int(10) unsigned
* date_from : date
* date_to : date
* total_requested_days : decimal(6,2)
* request_reason : varchar(500)
* request_status : enum('SUBMITTED','APPROVED','REJECTED','CANCELLED')
* requested_by_user_id : smallint(5) unsigned
* requested_at_utc : datetime
* reviewed_by_user_id : smallint(5) unsigned
* review_comment : varchar(500)
* reviewed_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm employee_leave_request_days
* id : bigint(20) unsigned
* leave_request_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* branch_id : int(11)
* leave_date : date
* day_portion : enum('FULL_DAY','FIRST_HALF','SECOND_HALF')
* day_fraction : decimal(3,2)
* created_at : datetime
v sgm_crm employee_leave_types
* id : int(10) unsigned
* branch_id : int(11)
* leave_code : varchar(30)
* leave_name : varchar(100)
* is_paid : tinyint(1)
* annual_entitlement_days : decimal(6,2)
* allow_half_day : tinyint(1)
* exclude_weekly_off : tinyint(1)
* exclude_holidays : tinyint(1)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by_user_id : smallint(5) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm employee_location_points
* id : bigint(20) unsigned
* event_uuid : char(36)
* payload_hash : char(64)
* tracking_session_id : bigint(20) unsigned
* sequence_no : bigint(20) unsigned
* employee_id : int(10) unsigned
* user_id : smallint(5) unsigned
* device_id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* latitude : decimal(10,7)
* longitude : decimal(10,7)
* accuracy : decimal(10,2)
* altitude : decimal(12,2)
* speed : decimal(10,3)
* heading : decimal(6,2)
* recorded_at_device : datetime(3)
* received_at_server : datetime(3)
* monotonic_elapsed_ms : bigint(20) unsigned
* is_mocked : tinyint(1)
* source : varchar(30)
* activity_context : varchar(30)
* quality_flags : int(10) unsigned
* accepted_for_metrics : tinyint(1)
* created_at : datetime(3)
v sgm_crm employee_tracking_capture_policy
* branch_id : int(10) unsigned
* employee_context : varchar(20)
* revision : int(10) unsigned
* enabled : tinyint(1)
* upload_interval_seconds : int(10) unsigned
* batch_size : int(10) unsigned
* stationary_interval_seconds : int(10) unsigned
* max_pending_points : int(10) unsigned
v sgm_crm employee_tracking_commands
* id : bigint(20) unsigned
* operation_uuid : char(36)
* session_uuid : char(36)
* event_type : varchar(30)
* user_id : smallint(5) unsigned
* employee_id : int(10) unsigned
* device_id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* payload_hash : char(64)
* response_json : longtext
* received_at : datetime(3)
* created_at : datetime(3)
v sgm_crm employee_tracking_operational_events
* id : bigint(20) unsigned
* event_uuid : char(36)
* event_type : varchar(50)
* severity : varchar(10)
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* user_id : int(10) unsigned
* employee_id : int(10) unsigned
* device_id : bigint(20) unsigned
* tracking_session_id : bigint(20) unsigned
* visit_id : bigint(20) unsigned
* detail_json : longtext
* occurred_at : datetime(3)
v sgm_crm employee_tracking_policy_audit
* id : bigint(20) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* employee_context : varchar(20)
* changed_by : int(10) unsigned
* source : varchar(40)
* request_ip : varbinary(16)
* old_value_json : longtext
* new_value_json : longtext
* created_at : datetime(3)
v sgm_crm employee_tracking_retention_policy
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* detailed_days : smallint(5) unsigned
* summary_days : smallint(5) unsigned
* archive_enabled : tinyint(1)
* updated_by : int(10) unsigned
* created_at : datetime(3)
* updated_at : datetime(3)
v sgm_crm employee_tracking_sessions
* id : bigint(20) unsigned
* session_uuid : char(36)
* employee_id : int(10) unsigned
* user_id : smallint(5) unsigned
* device_id : bigint(20) unsigned
* device_uuid : varchar(80)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* company_id : int(10) unsigned
* employee_context : varchar(20)
* policy_version : int(10) unsigned
* policy_snapshot_json : longtext
* started_at : datetime(3)
* ended_at : datetime(3)
* authorized_until : datetime(3)
* start_latitude : decimal(10,7)
* start_longitude : decimal(10,7)
* start_accuracy : decimal(10,2)
* end_latitude : decimal(10,7)
* end_longitude : decimal(10,7)
* end_accuracy : decimal(10,2)
* status : varchar(20)
* active_employee_id : int(10) unsigned
* last_location_at : datetime(3)
* last_received_at : datetime(3)
* last_point_id : bigint(20) unsigned
* total_distance_meters : decimal(14,2)
* total_active_seconds : int(10) unsigned
* total_idle_seconds : int(10) unsigned
* total_visits : int(10) unsigned
* summary_state : varchar(20)
* summary_version : int(10) unsigned
* created_at : datetime(3)
* updated_at : datetime(3)
v sgm_crm employee_tracking_settings
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* employee_context : varchar(20)
* policy_version : int(10) unsigned
* tracking_enabled : tinyint(1)
* background_tracking_enabled : tinyint(1)
* minimum_time_interval_seconds : int(10) unsigned
* minimum_distance_meters : int(10) unsigned
* geofence_radius_meters : int(10) unsigned
* stale_location_minutes : smallint(5) unsigned
* low_accuracy_threshold_meters : int(10) unsigned
* offline_tracking_allowed : tinyint(1)
* require_location_for_checkin : tinyint(1)
* require_location_for_checkout : tinyint(1)
* mock_location_policy : varchar(20)
* start_day_required : tinyint(1)
* end_day_required : tinyint(1)
* max_session_seconds : int(10) unsigned
* timezone_name : varchar(64)
* updated_by : smallint(5) unsigned
* created_at : datetime(3)
* updated_at : datetime(3)
v sgm_crm employee_tracking_test_allowlist
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* user_id : smallint(5) unsigned
* employee_id : int(10) unsigned
* employee_context : varchar(20)
* enabled : tinyint(1)
* expires_at : datetime(3)
* created_at : datetime(3)
* updated_at : datetime(3)
v sgm_crm employee_visit_tracking
* id : bigint(20) unsigned
* visit_uuid : char(36)
* tracking_session_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* visit_type : varchar(20)
* customer_ledger_id : bigint(20) unsigned
* service_ticket_id : bigint(20) unsigned
* planned_crm_visit_id : int(11)
* customer_location_id : bigint(20) unsigned
* checkin_at : datetime(3)
* checkout_at : datetime(3)
* checkin_latitude : decimal(10,7)
* checkin_longitude : decimal(10,7)
* checkin_accuracy : decimal(10,2)
* checkout_latitude : decimal(10,7)
* checkout_longitude : decimal(10,7)
* checkout_accuracy : decimal(10,2)
* customer_latitude : decimal(10,7)
* customer_longitude : decimal(10,7)
* checkin_distance_meters : decimal(12,2)
* checkout_distance_meters : decimal(12,2)
* geofence_radius_meters : int(10) unsigned
* geofence_status : varchar(40)
* status : varchar(20)
* active_session_id : bigint(20) unsigned
* outcome : varchar(40)
* remarks : text
* row_version : int(10) unsigned
* created_at : datetime(3)
* updated_at : datetime(3)
v sgm_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 sgm_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 sgm_crm expense_entries
* id : bigint(20) unsigned
* expense_type : enum('ledger_wise','items_wise')
* expense_invoice_no : varchar(50)
* expense_invoice_date : date
* voucher_number : varchar(50)
* voucher_type_id : bigint(20)
* entry_mode : enum('Cash','Party')
* urd : enum('Y','N')
* voucher_date : date
* voucher_time : time
* due_date : date
* ledger_id : int(10) unsigned
* party_cat_id : int(11)
* amount : decimal(10,2)
* sgst_amount : decimal(10,2)
* cgst_amount : decimal(10,2)
* igst_amount : decimal(10,2)
* cess_amount : decimal(10,2)
* round_off : decimal(12,2)
* price : decimal(10,2)
* pri_discount : decimal(10,2)
* after_prim_dis_price : decimal(12,2)
* proportionate_discount : decimal(10,2)
* additional_discount : decimal(10,2)
* total_discount : decimal(10,2)
* add_charges : decimal(10,2)
* taxable_amount : decimal(12,2)
* item_tax_amount : decimal(10,2)
* add_charges_fixed_tax_amount : decimal(10,2)
* add_charges_proportionate_tax_amount : decimal(10,2)
* total_tax_amount : decimal(12,2)
* tds_amount : decimal(10,2)
* invoice_amount : decimal(12,2)
* freight_charges : 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)
* is_cancelled : enum('Y','N')
* created_at : datetime
* updated_at : datetime
* posting_status : enum('Pending','Posted')
* calc_add_discount_from : enum('BASE','PRIMARY_DISCOUNT')
v sgm_crm expense_entry_items
* id : bigint(20) unsigned
* expense_entry_id : bigint(20) unsigned
* item_id : bigint(20) unsigned
* ledger_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 : enum('Fixed','Percentage')
* 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)
* amount : decimal(10,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 sgm_crm expense_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_old : varchar(600)
* selected_prop_discount_items : longtext
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_crm 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 sgm_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 sgm_crm e_invoice_details
* id : int(11)
* voucher_type_id : int(11)
* entry_date : date
* entry_id : int(11)
* e_type : varchar(50)
* consignor_name : varchar(150)
* consignor_gstin : varchar(20)
* consignor_state : varchar(50)
* consignor_actual_state : varchar(50)
* consignor_address1 : varchar(255)
* consignor_address2 : varchar(255)
* consignor_pincode : varchar(10)
* consignor_place : varchar(100)
* dispatch_from_name : varchar(150)
* dispatch_from_state : varchar(50)
* dispatch_from_address1 : varchar(255)
* dispatch_from_pincode : varchar(10)
* dispatch_from_place : varchar(100)
* consignee_name : varchar(150)
* consignee_gstin : varchar(20)
* consignee_state : varchar(50)
* consignee_actual_state : varchar(50)
* consignee_address1 : varchar(255)
* consignee_address2 : varchar(255)
* consignee_pincode : varchar(10)
* consignee_place : varchar(100)
* ship_to_name : varchar(150)
* ship_to_gstin : varchar(20)
* ship_to_state : varchar(50)
* ship_to_address1 : varchar(255)
* ship_to_pincode : varchar(10)
* ship_to_place : varchar(100)
* supplyType : varchar(10)
* subSupplyType : int(11)
* subSupplyDesc : longtext
* docType : varchar(10)
* 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)
* reason_for_transportation : longtext
* is_active : enum('Y','N')
* created_by : varchar(50)
* modified_by : varchar(50)
* created_at : timestamp
* updated_at : timestamp
v sgm_crm 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 sgm_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 sgm_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 sgm_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)
* gst_verification_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 sgm_crm gst_authcode
* id : int(11)
* invoice_type : varchar(20)
* auth_code : varchar(250)
* expiry_time : varchar(20)
* created_at : timestamp
v sgm_crm gst_registration_types
* id : tinyint(3) unsigned
* type_name : varchar(50)
* tax_type_code : 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 sgm_crm invoice_inbox_accounts
* id : int(10) unsigned
* crm_user_id : smallint(5) unsigned
* branch_id : int(10) unsigned
* provider : varchar(20)
* scraper_user_id : int(10) unsigned
* gmail_email : varchar(190)
* gmail_name : varchar(190)
* gmail_picture : text
* delete_status : tinyint(1)
* connected_at : datetime
* updated_at : datetime
v sgm_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 sgm_crm invoice_print_settings
* id : int(11)
* branch_id : int(11)
* voucher_type_id : int(11)
* template : varchar(50)
* active : enum('Y','N')
v sgm_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 sgm_crm items
* id : int(10) unsigned
* item_name : varchar(255)
* alias_name : varchar(255)
* item_code : varchar(50)
* packing : varchar(50)
* packing_numbers : varchar(50)
* item_type1 : enum('PART','ASSEMBLY')
* 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
* alternative_uom_id : int(10) unsigned
* brand_id : int(10) unsigned
* company_id : int(10) unsigned
* item_type : enum('GOODS','SERVICE','EXPENSE')
* valuation_method : enum('FIFO','WAC','STANDARD')
* standard_cost : decimal(10,2)
* price_basis : enum('MRP','BASE')
* mrp : decimal(10,2)
* alternative_value : 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 : int(10) unsigned
* opening_value : 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')
* show_without_stock : enum('Y','N')
* branch_id_deleted : int(10) unsigned
* item_name_key : varchar(255)
* name_norm : varchar(255)
* aliases_norm : varchar(512)
* delete_status_deleted : tinyint(1)
* created_by : int(11)
* modified_by : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_crm items_branchwise_details
* id : int(11)
* item_id : int(11)
* branch_id : int(11)
* is_deleted : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm items_brands
* id : int(10) unsigned
* brand_name : varchar(100)
* description : text
* branch_id_deleted : int(11) unsigned
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm items_category
* id : int(11)
* category_name : varchar(100)
* agri_type : enum('agri','non_agri')
* is_active : tinyint(1)
* sort_order : int(11)
* description : text
* background_color : varchar(20)
* bullet_symbol : varchar(20)
* branch_id_deleted : int(10) unsigned
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_crm items_opening_stock
* id : bigint(20) unsigned
* item_id : bigint(20) unsigned
* godown_id : int(10) 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_by : int(11)
* modified_by : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_crm 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 sgm_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_deleted : 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 sgm_crm items_uom
* id : int(10) unsigned
* uom_name : varchar(100)
* uom_code : enum('BAG','BAL','BDL','BKL','BOU','BOX','BTL','BUN','CAN','CBM','CCM','CMS','CTN','DOZ','DRM','GGK','GMS','GRS','GYD','KGS','KLR','KME','LTR','MTR','MLT','MTS','NOS','OTH','PAC','PCS','PRS','QTL','ROL','SET','SQF','SQM','SQY','TBS','TGM','THD','TON','TUB','UGS','UNT','YDS')
* description : varchar(255)
* branch_id_deleted : int(10) unsigned
* created_at : timestamp
* updated_at : timestamp
* delete_status : tinyint(1)
v sgm_crm item_batch_daily_movement
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* balance_date : date
* item_id : bigint(20) unsigned
* godown_id : int(10) unsigned
* batch_no : varchar(100)
* valuation_method_used : varchar(20)
* opening_qty : decimal(12,2)
* opening_value : decimal(14,2)
* in_qty : decimal(12,2)
* in_value : decimal(14,2)
* out_qty : decimal(12,2)
* out_value : decimal(14,2)
* closing_qty : decimal(12,2)
* closing_value : decimal(14,2)
v sgm_crm item_daily_movement
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* balance_date : date
* item_id : bigint(20) unsigned
* godown_id : int(10) unsigned
* item_name : varchar(255)
* item_cat_id : int(10) unsigned
* stock_group : varchar(100)
* valuation_method_used : varchar(20)
* opening_qty : decimal(14,2)
* opening_value : decimal(16,2)
* opening_rate : decimal(12,2)
* in_qty : decimal(14,2)
* in_value : decimal(16,2)
* in_rate : decimal(12,2)
* out_qty : decimal(14,2)
* out_value : decimal(16,2)
* out_rate : decimal(12,2)
* closing_qty : decimal(14,2)
* closing_value : decimal(16,2)
* closing_rate : decimal(12,2)
* created_at : datetime
* updated_at : datetime
v sgm_crm item_daily_movement_dirty
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* item_id : bigint(20) unsigned
* godown_id : int(10) unsigned
* item_cat_id : int(10) unsigned
* valuation_method_used : varchar(20)
* earliest_affected_date : date
* reason : varchar(50)
* marked_at : datetime
v sgm_crm item_daily_movement_dirty_scope_fix_backup_20260922
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* item_id : bigint(20) unsigned
* godown_id : int(10) unsigned
* item_cat_id : int(10) unsigned
* valuation_method_used : varchar(20)
* earliest_affected_date : date
* reason : varchar(50)
* marked_at : datetime
v sgm_crm item_daily_movement_rebuild_log
* id : bigint(20) unsigned
* started_at : datetime(6)
* finished_at : datetime(6)
* authorized_user_id : int(10) unsigned
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* valuation_method_used : varchar(20)
* item_scope : varchar(255)
* godown_scope : varchar(255)
* earliest_affected_date : date
* rows_read : bigint(20) unsigned
* rows_deleted : bigint(20) unsigned
* rows_inserted : bigint(20) unsigned
* rows_updated : bigint(20) unsigned
* batch_count : int(10) unsigned
* lock_wait_ms : decimal(12,3)
* total_duration_ms : decimal(12,3)
* php_peak_memory_bytes : bigint(20) unsigned
* outcome : enum('COMMIT','ROLLBACK','LOCKED')
* error_category : varchar(80)
* created_at : datetime
v sgm_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 sgm_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 sgm_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
* uom_id : int(10) unsigned
* voucher_type_id : int(10) unsigned
* voucher_no : varchar(50)
* in_out_type : enum('IN','OUT')
* quantity : decimal(12,2)
* rate : decimal(12,2)
* taxable_amount : decimal(12,2)
* ref_type : varchar(30)
* ref_id : varchar(50)
* ref_line_id : varchar(50)
* 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')
* is_auto_added : enum('Y','N')
v sgm_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 sgm_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)
* is_cancelled : enum('Y','N')
* created_at : datetime
* updated_at : datetime
v sgm_crm ledger_bank_accounts
* id : bigint(20) unsigned
* ledger_id : bigint(20) unsigned
* branch_id : int(10) unsigned
* account_holder_name : varchar(120)
* account_no : varchar(34)
* ifsc_code : varchar(15)
* bank_ledger_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_invoice : varchar(100)
* is_primary : tinyint(1)
* opening_balance_deleted : 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 sgm_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 sgm_crm ledger_details
* id : bigint(20) unsigned
* ledger_name : varchar(250)
* alias_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','CAPITAL','FIXED_ASSET','LOAN','DISCOUNT_CREDIT_NOTE')
* 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_by : int(11)
* modified_by : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_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
* billing_id : int(10) unsigned
* address_type : enum('PRIMARY','SECONDARY','CUSTOM')
* 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)
* gst_verified : enum('Y','N')
* 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 sgm_crm ledger_groups
* id : smallint(5) unsigned
* title : varchar(100)
* parent_group_id : smallint(5) unsigned
* is_primary : tinyint(1)
* is_secondary : tinyint(1)
* is_custom : 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)
* branch_id : int(11)
* 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)
v sgm_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 sgm_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_by : int(10) unsigned
* modified_by : int(10) unsigned
* created_at : timestamp
* updated_at : timestamp
* delete_status : tinyint(1)
v sgm_crm ledger_party_shipping_details
* id : int(10) unsigned
* ledger_id : int(10) unsigned
* address_type : enum('SECONDARY','SHIPPING')
* is_primary : enum('Y','N')
* ship_to : varchar(100)
* gst_no : varchar(50)
* gst_verified : enum('Y','N')
* 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 sgm_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
* 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 sgm_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 sgm_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')
* address_type : enum('PRIMARY','SECONDARY','SHIPPING','CUSTOM','COPY BILL TO')
* 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)
* gst_verified : enum('Y','N')
* contact_person : varchar(50)
* contact_no : varchar(10)
* email_id : varchar(50)
* place_of_supply : varchar(100)
* delivery_source_deleted : varchar(100)
* godown_id_deleted : int(11)
* plant_id_deleted : int(11)
* branch_id : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_crm mastergst_tokens
* id : int(11)
* gstin : varchar(15)
* access_token : varchar(500)
* token_expiry : datetime
* created_at : timestamp
v sgm_crm message_queue
* id : int(11)
* phone_number : varchar(20)
* message_text : text
* status : enum('PENDING','SENT','FAILED')
* created_at : timestamp
v sgm_crm mobile_api_auth_attempts
* id : bigint(20) unsigned
* identifier_hash : char(64)
* request_ip : varchar(45)
* device_uuid : varchar(80)
* success : tinyint(1)
* reason_code : varchar(60)
* user_id : int(11)
* created_at : datetime
v sgm_crm mobile_api_devices
* id : bigint(20) unsigned
* user_id : int(11)
* employee_id : int(11)
* device_uuid : varchar(80)
* device_name : varchar(160)
* platform : varchar(30)
* app_version : varchar(40)
* status : enum('ACTIVE','REVOKED')
* last_ip : varchar(45)
* last_seen_at : datetime
* revoked_at : datetime
* revoke_reason : varchar(120)
* created_at : datetime
* updated_at : datetime
v sgm_crm mobile_api_sessions
* id : bigint(20) unsigned
* session_uuid : char(36)
* user_id : int(11)
* employee_id : int(11)
* device_id : bigint(20) unsigned
* access_token_hash : char(64)
* refresh_token_hash : char(64)
* access_expires_at : datetime
* refresh_expires_at : datetime
* offline_valid_until : datetime
* last_seen_at : datetime
* last_ip : varchar(45)
* user_agent : varchar(255)
* revoked_at : datetime
* revoke_reason : varchar(120)
* created_at : datetime
* updated_at : datetime
v sgm_crm mobile_collection_finance_audit
* id : bigint(20) unsigned
* review_id : bigint(20) unsigned
* field_operation_id : bigint(20) unsigned
* action_code : varchar(40)
* from_state : varchar(30)
* to_state : varchar(30)
* actor_user_id : int(11)
* company_id : int(11)
* branch_id : int(11)
* finance_year_id : int(11)
* details_json : longtext
* created_at : datetime
v sgm_crm mobile_collection_finance_reviews
* id : bigint(20) unsigned
* field_operation_id : bigint(20) unsigned
* operation_uuid : char(36)
* entity_uuid : char(36)
* company_id : int(11)
* branch_id : int(11)
* finance_year_id : int(11)
* submitting_user_id : int(11)
* employee_id : int(11)
* review_state : varchar(30)
* receiving_ledger_id : int(11)
* receipt_voucher_id : int(11)
* receipt_voucher_no : varchar(100)
* reviewed_by : int(11)
* reviewed_at : datetime
* rejection_reason : varchar(500)
* row_version : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_crm mobile_customer_statement_shares
* id : bigint(20) unsigned
* token_hash : char(64)
* ledger_id : int(11)
* branch_id : int(11)
* finance_year_id : int(11)
* from_date : date
* to_date : date
* created_by_user_id : int(11)
* employee_id : int(11)
* device_id : bigint(20) unsigned
* expires_at : datetime
* revoked_at : datetime
* view_count : int(10) unsigned
* last_viewed_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm mobile_field_operations
* id : bigint(20) unsigned
* operation_uuid : char(36)
* entity_uuid : char(36)
* entity_type : varchar(30)
* action_type : varchar(40)
* status : varchar(30)
* user_id : int(11)
* employee_id : int(11)
* branch_id : int(11)
* finance_year_id : int(11)
* customer_ledger_id : int(11)
* title : varchar(255)
* captured_at_utc : datetime
* payload_json : longtext
* device_id : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm mobile_field_operation_attachments
* id : bigint(20) unsigned
* attachment_uuid : char(36)
* field_operation_id : bigint(20) unsigned
* entity_uuid : char(36)
* entity_type : varchar(30)
* evidence_role : varchar(80)
* attachment_kind : varchar(20)
* original_name : varchar(255)
* client_mime_type : varchar(150)
* verified_mime_type : varchar(150)
* byte_size : bigint(20) unsigned
* sha256 : char(64)
* total_chunks : int(10) unsigned
* received_chunks : int(10) unsigned
* upload_state : varchar(20)
* stored_path : varchar(500)
* latitude : decimal(10,7)
* longitude : decimal(10,7)
* accuracy_meters : decimal(10,2)
* captured_at_utc : datetime
* user_id : int(11)
* employee_id : int(11)
* branch_id : int(11)
* finance_year_id : int(11)
* device_id : bigint(20) unsigned
* completed_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm mobile_notification_reads
* user_id : int(11)
* alert_id : bigint(20)
* branch_id : int(11)
* read_at : datetime
* updated_at : datetime
v sgm_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 sgm_crm parts
* id : int(10) unsigned
* part_id : varchar(50)
* part_title : varchar(255)
* part_title_real : varchar(255)
* part_cost : decimal(12,2)
* image_path : varchar(255)
* image_url : varchar(255)
* gallery_file_id : bigint(20) unsigned
* image_hash : char(64)
* visual_hash : varchar(1024)
* calculation_json : longtext
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v sgm_crm parts_backup_20260818_170943
* 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 sgm_crm parts_backup_20260818_172626
* 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)
* gallery_file_id : bigint(20) unsigned
* image_hash : char(64)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v sgm_crm parts_backup_20260818_173857
* 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)
* gallery_file_id : bigint(20) unsigned
* image_hash : char(64)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v sgm_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 sgm_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 sgm_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 sgm_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 sgm_crm payment_followup_status
* id : int(11)
* ledger_id : int(11)
* user_id : int(11)
* status : varchar(50)
* lock_date_time : timestamp
v sgm_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 sgm_crm payment_types
* id : int(11)
* name : varchar(100)
* sort_order : int(11)
* is_active : enum('Y','N')
* branch_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v sgm_crm payment_vouchers
* id : bigint(20) unsigned
* entry_type : enum('PAYMENT','EXPENSE')
* voucher_type_id : int(11)
* cash_or_bank : enum('Cash','Bank')
* instrument_type : varchar(50)
* 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_number : varchar(100)
* amount : decimal(12,2)
* branch_id : int(10) unsigned
* reference_type_id : int(10) unsigned
* advance_reference_id : bigint(20) unsigned
* user_id : int(11)
* narration : text
* delete_status : tinyint(1)
* is_cancelled : enum('Y','N')
* 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 sgm_crm payment_voucher_allocations
* id : bigint(20) unsigned
* payment_voucher_id : bigint(20) unsigned
* voucher_type_id : bigint(20)
* invoice_id : bigint(20) unsigned
* advance_voucher_type_id : bigint(20) unsigned
* advance_invoice_id : bigint(20) unsigned
* allocated_amount : decimal(12,2)
* remarks : text
* delete_status : int(11)
* is_cancelled : enum('Y','N')
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_accounting_batches
* id : bigint(20) unsigned
* batch_uuid : char(36)
* branch_id : int(10) unsigned
* payroll_month : char(7)
* period_start : date
* period_end : date
* payroll_run_id : bigint(20) unsigned
* source_run_uuid : char(36)
* source_run_version : int(10) unsigned
* source_run_input_hash : char(64)
* source_result_hash : char(64)
* source_finalize_event_id : bigint(20) unsigned
* source_payslip_count : int(10) unsigned
* source_payslip_set_hash : char(64)
* source_accounting_configuration_id : bigint(20) unsigned
* source_accounting_configuration_version : int(10) unsigned
* source_accounting_configuration_hash : char(64)
* posting_version : int(10) unsigned
* posting_status : varchar(32)
* line_count : int(10) unsigned
* total_debit : decimal(18,2)
* total_credit : decimal(18,2)
* posting_hash : char(64)
* native_voucher_type_id : bigint(20) unsigned
* native_reference_type : varchar(50)
* native_reference_id : varchar(80)
* native_reference_no : varchar(80)
* created_by : bigint(20) unsigned
* posted_by : bigint(20) unsigned
* created_at_utc : datetime
* posted_at_utc : datetime
* posting_attempted_at_utc : datetime
* posting_error_code : varchar(80)
* posting_error_message : varchar(500)
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_accounting_component_mappings
* id : bigint(20) unsigned
* payroll_accounting_configuration_id : bigint(20) unsigned
* mapping_role : varchar(60)
* component_id : bigint(20) unsigned
* component_code : varchar(50)
* ledger_id : bigint(20) unsigned
* entry_side : varchar(2)
* amount_source : varchar(80)
* display_order : int(11)
* mapping_hash : char(64)
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_accounting_configurations
* id : bigint(20) unsigned
* config_uuid : char(36)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* config_version : int(10) unsigned
* config_status : varchar(20)
* journal_voucher_type_id : bigint(20) unsigned
* salary_expense_ledger_id : bigint(20) unsigned
* salary_payable_ledger_id : bigint(20) unsigned
* config_hash : char(64)
* lock_version : int(10) unsigned
* notes : varchar(500)
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* approved_by : bigint(20) unsigned
* approved_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_accounting_events
* id : bigint(20) unsigned
* payroll_accounting_batch_id : bigint(20) unsigned
* branch_id : int(10) unsigned
* payroll_month : char(7)
* action_code : varchar(80)
* actor_user_id : bigint(20) unsigned
* request_id : varchar(80)
* details_json : longtext
* event_at_utc : datetime
* created_at : datetime
v sgm_crm payroll_accounting_lines
* id : bigint(20) unsigned
* payroll_accounting_batch_id : bigint(20) unsigned
* line_no : smallint(5) unsigned
* ledger_role : varchar(60)
* ledger_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* payroll_payslip_id : bigint(20) unsigned
* component_id : bigint(20) unsigned
* component_code : varchar(50)
* description : varchar(255)
* debit_amount : decimal(18,2)
* credit_amount : decimal(18,2)
* source_hash : char(64)
* line_hash : char(64)
* created_at : datetime
v sgm_crm payroll_branch_policies
* id : bigint(20) unsigned
* policy_uuid : char(36)
* branch_id : int(10) unsigned
* policy_version : int(10) unsigned
* policy_status : enum('DRAFT','ACTIVE','RETIRED')
* effective_from : date
* effective_to : date
* proration_method : enum('CALENDAR_DAYS','WORKING_DAYS','FIXED_30_DAYS','NO_PRORATION')
* fixed_days_divisor : decimal(8,2)
* rounding_mode : enum('HALF_UP','HALF_EVEN','DOWN','UP')
* rounding_scale : tinyint(3) unsigned
* policy_hash : char(64)
* lock_version : int(10) unsigned
* notes : varchar(500)
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* approved_by : bigint(20) unsigned
* approved_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_employee_salary_assignments
* id : bigint(20) unsigned
* employee_id : int(10) unsigned
* branch_id : int(10) unsigned
* structure_version_id : bigint(20) unsigned
* effective_from : date
* effective_to : date
* assignment_status : enum('ACTIVE','INACTIVE')
* assignment_version : int(10) unsigned
* reference_monthly_gross : decimal(18,2)
* reference_monthly_ctc : decimal(18,2)
* notes : varchar(500)
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_employee_salary_assignment_components
* id : bigint(20) unsigned
* assignment_id : bigint(20) unsigned
* component_id : bigint(20) unsigned
* value_source : enum('STRUCTURE_DEFAULT','EMPLOYEE_OVERRIDE')
* calculation_method : enum('FIXED','PERCENTAGE','FORMULA','MANUAL')
* amount_value : decimal(18,2)
* rate_value : decimal(9,4)
* basis_code : varchar(50)
* formula_expression : varchar(500)
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_master_events
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* entity_type : varchar(60)
* entity_id : varchar(80)
* action_code : varchar(80)
* actor_user_id : bigint(20) unsigned
* request_id : varchar(80)
* event_at_utc : datetime
* details_json : longtext
* created_at : datetime
v sgm_crm payroll_payslips
* id : bigint(20) unsigned
* payslip_uuid : char(36)
* branch_id : int(10) unsigned
* payroll_month : char(7)
* period_start : date
* period_end : date
* payroll_run_id : bigint(20) unsigned
* payroll_run_employee_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* employee_code : varchar(50)
* employee_name : varchar(120)
* designation : varchar(120)
* payslip_version : int(10) unsigned
* payslip_status : varchar(32)
* source_run_uuid : char(36)
* source_run_version : int(10) unsigned
* source_run_input_hash : char(64)
* source_result_hash : char(64)
* source_finalize_event_id : bigint(20) unsigned
* payable_attendance_days : decimal(8,2)
* gross_amount : decimal(18,2)
* deduction_amount : decimal(18,2)
* employer_contribution_amount : decimal(18,2)
* net_amount : decimal(18,2)
* payslip_hash : char(64)
* generated_by : bigint(20) unsigned
* generated_at_utc : datetime
* created_at : datetime
v sgm_crm payroll_payslip_components
* id : bigint(20) unsigned
* payroll_payslip_id : bigint(20) unsigned
* source_run_component_id : bigint(20) unsigned
* component_id : bigint(20) unsigned
* component_code : varchar(50)
* component_name : varchar(120)
* component_type : varchar(32)
* display_order : smallint(5) unsigned
* is_taxable : tinyint(1)
* affects_gross : tinyint(1)
* affects_net : tinyint(1)
* is_statutory : tinyint(1)
* calculated_amount : decimal(18,2)
* source_component_input_hash : char(64)
* component_hash : char(64)
* created_at : datetime
v sgm_crm payroll_runs
* id : bigint(20) unsigned
* run_uuid : char(36)
* branch_id : int(10) unsigned
* payroll_month : char(7)
* period_start : date
* period_end : date
* run_version : int(10) unsigned
* run_status : varchar(32)
* attendance_period_id : bigint(20) unsigned
* attendance_snapshot_id : bigint(20) unsigned
* attendance_snapshot_uuid : char(36)
* attendance_snapshot_version : int(10) unsigned
* attendance_snapshot_hash : char(64)
* source_period_lock_version : int(10) unsigned
* payroll_policy_id : bigint(20) unsigned
* payroll_policy_version : int(10) unsigned
* payroll_policy_hash : char(64)
* payroll_policy_proration_method : varchar(32)
* payroll_policy_fixed_days_divisor : decimal(8,2)
* payroll_policy_rounding_mode : varchar(20)
* payroll_policy_rounding_scale : tinyint(3) unsigned
* eligible_employee_count : int(10) unsigned
* assigned_employee_count : int(10) unsigned
* snapshot_employee_count : int(10) unsigned
* captured_employee_count : int(10) unsigned
* input_hash : char(64)
* lock_version : int(10) unsigned
* notes : varchar(500)
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at_utc : datetime
* updated_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_run_employees
* id : bigint(20) unsigned
* payroll_run_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* employee_code : varchar(50)
* employee_name : varchar(120)
* designation : varchar(120)
* attendance_employee_snapshot_id : bigint(20) unsigned
* attendance_employee_row_hash : char(64)
* scheduled_workdays : decimal(8,2)
* present_days : decimal(8,2)
* absent_days : decimal(8,2)
* weekly_off_days : decimal(8,2)
* holiday_days : decimal(8,2)
* approved_leave_days : decimal(8,2)
* payable_attendance_days : decimal(8,2)
* payable_attendance_days_status : varchar(40)
* total_worked_minutes : decimal(12,2)
* approved_overtime_minutes : int(10) unsigned
* late_count : int(10) unsigned
* early_out_count : int(10) unsigned
* short_hours_count : int(10) unsigned
* attendance_exception_count : int(10) unsigned
* salary_assignment_id : bigint(20) unsigned
* salary_assignment_version : int(10) unsigned
* structure_version_id : bigint(20) unsigned
* salary_assignment_effective_from : date
* salary_assignment_effective_to : date
* reference_monthly_gross : decimal(18,2)
* reference_monthly_ctc : decimal(18,2)
* input_hash : char(64)
* calculation_status : varchar(32)
* gross_amount : decimal(18,2)
* deduction_amount : decimal(18,2)
* employer_contribution_amount : decimal(18,2)
* net_amount : decimal(18,2)
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_run_employee_components
* id : bigint(20) unsigned
* payroll_run_employee_id : bigint(20) unsigned
* component_id : bigint(20) unsigned
* component_code : varchar(50)
* component_name : varchar(120)
* component_type : varchar(32)
* source_assignment_component_id : bigint(20) unsigned
* value_source : varchar(32)
* calculation_method : varchar(32)
* amount_value : decimal(18,2)
* rate_value : decimal(9,4)
* basis_code : varchar(50)
* formula_expression : varchar(500)
* proration_policy : varchar(40)
* display_order : smallint(5) unsigned
* is_required : tinyint(1)
* is_taxable : tinyint(1)
* affects_gross : tinyint(1)
* affects_net : tinyint(1)
* is_statutory : tinyint(1)
* input_hash : char(64)
* calculated_amount : decimal(18,2)
* calculation_trace_json : longtext
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_run_events
* id : bigint(20) unsigned
* payroll_run_id : bigint(20) unsigned
* branch_id : int(10) unsigned
* entity_type : varchar(60)
* entity_id : varchar(80)
* action_code : varchar(80)
* actor_user_id : bigint(20) unsigned
* request_id : varchar(80)
* event_at_utc : datetime
* details_json : longtext
* created_at : datetime
v sgm_crm payroll_salary_components
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* component_code : varchar(50)
* component_name : varchar(120)
* component_type : enum('EARNING','DEDUCTION','EMPLOYER_CONTRIBUTION','INFORMATION')
* calculation_method : enum('FIXED','PERCENTAGE','FORMULA','MANUAL')
* basis_code : varchar(50)
* default_amount : decimal(18,2)
* default_rate : decimal(9,4)
* formula_expression : varchar(500)
* proration_policy : enum('PRORATE_WITH_PAYABLE_DAYS','NO_PRORATION','PAYROLL_POLICY')
* is_taxable : tinyint(1)
* affects_gross : tinyint(1)
* affects_net : tinyint(1)
* is_statutory : tinyint(1)
* display_order : smallint(5) unsigned
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_salary_payment_allocations
* id : bigint(20) unsigned
* payroll_salary_payment_batch_id : bigint(20) unsigned
* allocation_uuid : char(36)
* payroll_payslip_id : bigint(20) unsigned
* source_payslip_uuid : char(36)
* source_payslip_hash : char(64)
* payroll_run_employee_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* employee_code : varchar(100)
* employee_name : varchar(255)
* net_payable_amount : decimal(18,2)
* paid_amount : decimal(18,2)
* outstanding_amount : decimal(18,2)
* payment_status : varchar(20)
* allocation_hash : char(64)
* lock_version : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_salary_payment_batches
* id : bigint(20) unsigned
* payment_batch_uuid : char(36)
* branch_id : int(10) unsigned
* payroll_month : char(7)
* period_start : date
* period_end : date
* payroll_run_id : bigint(20) unsigned
* source_run_uuid : char(36)
* source_run_version : int(10) unsigned
* source_run_input_hash : char(64)
* source_result_hash : char(64)
* source_finalize_event_id : bigint(20) unsigned
* source_payslip_count : int(10) unsigned
* source_payslip_set_hash : char(64)
* source_accounting_batch_id : bigint(20) unsigned
* source_accounting_posting_version : int(10) unsigned
* source_accounting_posting_hash : char(64)
* source_accounting_native_reference_type : varchar(50)
* source_accounting_native_reference_id : varchar(80)
* source_accounting_native_reference_no : varchar(80)
* payment_version : int(10) unsigned
* payment_status : varchar(20)
* payee_count : int(10) unsigned
* net_payable_total : decimal(18,2)
* paid_total : decimal(18,2)
* outstanding_total : decimal(18,2)
* payment_batch_hash : char(64)
* lock_version : int(10) unsigned
* notes : varchar(500)
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at_utc : datetime
* updated_at_utc : datetime
* completed_by : bigint(20) unsigned
* completed_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_salary_payment_events
* id : bigint(20) unsigned
* payroll_salary_payment_batch_id : bigint(20) unsigned
* payroll_salary_payment_allocation_id : bigint(20) unsigned
* payroll_salary_payment_transaction_id : bigint(20) unsigned
* action_code : varchar(80)
* details_json : longtext
* actor_user_id : bigint(20) unsigned
* event_at_utc : datetime
* created_at : datetime
v sgm_crm payroll_salary_payment_transactions
* id : bigint(20) unsigned
* payment_transaction_uuid : char(36)
* payroll_salary_payment_batch_id : bigint(20) unsigned
* payroll_salary_payment_allocation_id : bigint(20) unsigned
* payment_sequence : int(10) unsigned
* payment_date : date
* payment_method : varchar(20)
* cash_bank_ledger_id : bigint(20) unsigned
* amount : decimal(18,2)
* transaction_status : varchar(20)
* instrument_type : varchar(50)
* instrument_number : varchar(100)
* external_reference : varchar(150)
* narration : varchar(500)
* native_payment_voucher_id : bigint(20) unsigned
* native_payment_voucher_no : varchar(80)
* native_payment_voucher_type_id : bigint(20) unsigned
* native_ledger_posting_reference : varchar(150)
* source_allocation_hash : char(64)
* transaction_hash : char(64)
* created_by : bigint(20) unsigned
* posted_by : bigint(20) unsigned
* created_at_utc : datetime
* posted_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_salary_structures
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* structure_code : varchar(50)
* structure_name : varchar(150)
* description : varchar(500)
* is_active : tinyint(1)
* delete_status : tinyint(1)
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_salary_structure_versions
* id : bigint(20) unsigned
* structure_id : bigint(20) unsigned
* version_no : int(10) unsigned
* effective_from : date
* effective_to : date
* version_status : enum('DRAFT','ACTIVE','RETIRED')
* lock_version : int(10) unsigned
* notes : varchar(500)
* created_by : bigint(20) unsigned
* approved_by : bigint(20) unsigned
* approved_at_utc : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm payroll_salary_structure_version_components
* id : bigint(20) unsigned
* structure_version_id : bigint(20) unsigned
* component_id : bigint(20) unsigned
* calculation_method : enum('FIXED','PERCENTAGE','FORMULA','MANUAL')
* amount_value : decimal(18,2)
* rate_value : decimal(9,4)
* basis_code : varchar(50)
* formula_expression : varchar(500)
* proration_policy : enum('PRORATE_WITH_PAYABLE_DAYS','NO_PRORATION','PAYROLL_POLICY')
* display_order : smallint(5) unsigned
* is_required : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_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 sgm_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 sgm_crm posting_period_control
* period_start : date
* period_end : date
* is_locked : enum('Y','N')
* locked_by : int(11)
* locked_at : datetime
v sgm_crm pricing_recompute_queue
* id : bigint(20)
* branch_id : int(11)
* item_id : bigint(20)
* reason : varchar(40)
* created_at : timestamp
v sgm_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)
* purchase_order_ref_id : int(11)
* purchase_ref_id : int(11)
* email_scraper_invoices_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
* godown_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)
* is_cancelled : enum('Y','N')
* 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')
* calc_add_discount_from : enum('BASE','PRIMARY_DISCOUNT')
v sgm_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 sgm_crm purchase_entry_items
* id : bigint(20) unsigned
* purchase_entry_id : bigint(20) unsigned
* godown_id : bigint(20) unsigned
* item_id : bigint(20) unsigned
* ledger_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 : enum('Fixed','Percentage')
* 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 sgm_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 sgm_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_old : varchar(600)
* selected_prop_discount_items : longtext
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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)
* po_item_status : enum('PO DRAFT','PO REQUESTED','VENDOR CONFIRMED','ORDER BOOKED','PARTIALLY RECEIVED','COMPLETED','CANCELLED')
* expected_date : date
* remarks : varchar(255)
* delete_status : tinyint(1)
* modified_by : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_crm purchase_received_details_deleted
* 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 sgm_crm purchase_reorder_vendor_mapping
* id : bigint(20) unsigned
* item_id : bigint(20) unsigned
* supplier_id : bigint(20) unsigned
* branch_id : int(10) unsigned
* company_id : int(10) unsigned
* default_split_qty : decimal(12,2)
* last_po_qty : decimal(12,2)
* last_po_date : date
* priority_no : int(10) unsigned
* is_default : enum('Y','N')
* remarks : varchar(255)
* delete_status : tinyint(1)
* created_by : int(11)
* modified_by : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_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
* party_cat_id : int(10) unsigned
* godown_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 : enum('PENDING','GENERATED','CANCELLED')
v sgm_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)
* taxable_amount_with_charges : decimal(12,2)
* taxable_unit_price : 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 sgm_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 sgm_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 sgm_crm qr_payment
* id : bigint(20) unsigned
* payment_id : varchar(40)
* generated_time : datetime
* expires_at : datetime
* payment_status : tinyint(1) unsigned
* paid_time : datetime
* status_updated_time : datetime
* bank_reference : varchar(100)
* user_id : smallint(5) unsigned
* username : varchar(100)
v sgm_crm qr_payment_callback
* id : bigint(20) unsigned
* payment_id : varchar(40)
* received_time : datetime
* callback_status : tinyint(1) unsigned
* bank_reference : varchar(100)
* source_ip : varchar(45)
* raw_payload : longtext
v sgm_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 sgm_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 sgm_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 sgm_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 : varchar(50)
* 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)
* is_cancelled : enum('Y','N')
* created_by : int(11)
* modified_by : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_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)
* is_cancelled : enum('Y','N')
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_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)
* 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)
* godown_id : int(11)
* other_deduction : decimal(12,2) unsigned
* invoice_amount_deleted : 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)
* other_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)
* 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)
* round_off : decimal(12,2)
* total_amount : decimal(12,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
* einvoice_status : enum('PENDING','GENERATED','CANCELLED')
* ewaybill_status : enum('PENDING','GENERATED','CANCELLED')
* posting_status : enum('Pending','Posted')
* decline_reason : longtext
* confirm_reason : longtext
* calc_add_discount_from : enum('BASE','PRIMARY_DISCOUNT')
v sgm_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
* ledger_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)
* proportionate_other_discount : decimal(10,2)
* taxable_amount : decimal(12,2)
* proportionate_add_charges_amount : decimal(12,2)
* taxable_amount_with_charges : decimal(12,2)
* taxable_unit_price : 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 sgm_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)
* credit_note_details : longtext
* selected_prop_credit_note_items : longtext
* discount_details : longtext
* total_fixed_discount : decimal(12,2)
* total_prop_discount : decimal(12,2)
* remarks : varchar(255)
* selected_prop_discount_items_old : longtext
* selected_prop_discount_items : longtext
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_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 sgm_crm sales_invoice_whatsapp_pdfs
* sales_entry_id : int(11)
* recipient : varchar(20)
* status : varchar(12)
* message_id : varchar(255)
* error_message : varchar(255)
* pdf_bytes : int(11)
* updated_at : timestamp
v sgm_crm sales_invoice_whatsapp_recipients
* sales_entry_id : int(11)
* branch_id : int(11)
* recipient : varchar(10)
* updated_at : timestamp
v sgm_crm sales_invoice_whatsapp_sends
* sales_entry_id : int(11)
* recipient : varchar(20)
* status : varchar(12)
* message_id : varchar(255)
* error_message : varchar(255)
* updated_at : timestamp
v sgm_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
* party_cat_id : int(10) unsigned
* godown_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 sgm_crm sales_return_items
* id : bigint(20) unsigned
* sales_return_id : bigint(20) unsigned
* sales_entry_id : bigint(20) unsigned
* sales_voucher_no : varchar(50)
* 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)
* billed_rate : decimal(10,2)
* billed_qty : 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)
* taxable_amount_with_charges : decimal(12,2)
* taxable_unit_price : 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 sgm_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 sgm_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 sgm_crm sales_targets
* id : int(11)
* finance_year_id : int(11)
* branch_id : int(11)
* target_amount : decimal(14,2)
v sgm_crm sample_table
* id : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm setting_allowed_ips
* id : int(11)
* ip_address : varchar(50)
* description : varchar(255)
* is_active : tinyint(1)
* created_at : datetime
v sgm_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)
* is_main_branch : tinyint(1)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm setting_countries
* id : smallint(5) unsigned
* country_name : varchar(30)
* short_name : varchar(10)
* is_default : tinyint(1)
* branch_id : int(11)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_crm setting_district
* id : smallint(5) unsigned
* state_id : int(11)
* district_name : varchar(30)
* short_name : varchar(10)
* delete_status : tinyint(1)
* branch_id : int(11)
* is_default : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_crm setting_main_menu_backup_20260919_exact_parity
* 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 sgm_crm setting_states
* id : smallint(5) unsigned
* state_name : varchar(30)
* short_name : varchar(10)
* delete_status : tinyint(1)
* is_default : tinyint(1)
* branch_id : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_crm setting_sub_menu_backup_20260919_copy_from_surena
* 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 sgm_crm setting_sub_menu_backup_20260919_exact_parity
* 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 sgm_crm stock_movement
* id : int(11)
* voucher_type_id : int(11)
* voucher_no : varchar(50)
* from_branch : int(11)
* to_branch : int(11)
* from_godown : int(11)
* to_godown : int(11)
* whatsapp_no : varchar(10)
* movement_date : date
* transfer_qty : decimal(10,2)
* price : decimal(10,2)
* remarks : longtext
* branch_id : int(11)
* finance_year_id : int(11)
* posting_status : enum('Pending','Posted')
* ewaybill_status : enum('PENDING','GENERATED','CANCELLED')
* delete_status : int(11)
* created_by : int(11)
* modified_by : int(11)
* created_at : timestamp
* modified_at : timestamp
v sgm_crm stock_movement_items
* id : bigint(20) unsigned
* stock_movement_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)
* branch_id : int(10) unsigned
* delete_status : tinyint(3) unsigned
* created_at : timestamp
* updated_at : timestamp
v sgm_crm stock_po_requisitions
* id : bigint(20) unsigned
* request_no : varchar(40)
* branch_id : int(10) unsigned
* finance_year_id : int(10) unsigned
* delivery_branch : varchar(150)
* status : enum('DRAFT','REQUESTED','VENDOR_PENDING','PARTIAL_CONFIRMED','APPROVED','PO_SENT','CLOSED','CANCELLED')
* remarks : text
* created_by : bigint(20) unsigned
* approved_by : bigint(20) unsigned
* approved_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm stock_po_requisition_items
* id : bigint(20) unsigned
* request_id : bigint(20) unsigned
* item_id : bigint(20) unsigned
* available_qty : decimal(14,2)
* reorder_qty : decimal(14,2)
* required_qty : decimal(14,2)
* suggested_qty : decimal(14,2)
* priority : enum('LOW','NORMAL','HIGH','URGENT')
* reason : varchar(255)
* created_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm stock_po_vendor_allocations
* id : int(10) unsigned
* company_id : int(10) unsigned
* branch_id : int(10) unsigned
* reorder_run_id : int(10) unsigned
* reorder_item_id : int(10) unsigned
* item_id : int(10) unsigned
* vendor_ledger_id : int(10) unsigned
* required_qty : decimal(15,3)
* allocated_qty : decimal(15,3)
* rate : decimal(15,4)
* discount_percent : decimal(8,3)
* tax_percent : decimal(8,3)
* base_amount : decimal(15,2)
* discount_amount : decimal(15,2)
* tax_amount : decimal(15,2)
* net_amount : decimal(15,2)
* allocation_type : enum('auto','manual')
* allocation_reason : varchar(255)
* priority_rank : int(10) unsigned
* source_rate_id : int(10) unsigned
* source_mapping_id : int(10) unsigned
* po_created_status : tinyint(1)
* purchase_order_id : int(10) unsigned
* status : enum('draft','allocated','po_created','cancelled')
* 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 sgm_crm stock_po_vendor_item_rates
* id : bigint(20) unsigned
* item_id : bigint(20) unsigned
* vendor_ledger_id : bigint(20) unsigned
* branch_id : int(10) unsigned
* rate : decimal(14,2)
* available_qty : decimal(14,2)
* lead_days : int(10) unsigned
* priority_rank : int(10) unsigned
* remarks : varchar(255)
* last_confirmed_at : datetime
* is_active : tinyint(1)
* created_by : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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)
* quantity : int(11)
* eligible : enum('Y','N')
* effective_from : date
* effective_to : date
* delete_status : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v sgm_crm sub_item
* id : int(10)
* item_id : int(10)
* sub_item_id : int(10)
* branch_id : int(11)
* in_qty : decimal(15,2)
* out_qty : decimal(15,2)
* uom_id : int(11)
* item_value : decimal(20,6)
* active : tinyint(1)
* from_date : date
* to_date : date
* created_at : timestamp
* updated_at : timestamp
v sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_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 sgm_crm telephony_call_events
* id : bigint(20) unsigned
* call_id : bigint(20) unsigned
* event_type : varchar(50)
* event_time : timestamp
* payload_json : longtext
v sgm_crm topbar_order_backup_20260823_120047
* menu_family : varchar(17)
* source_table : varchar(17)
* record_id : decimal(10,0)
* display_name : varchar(50)
* old_order : decimal(10,0)
v sgm_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)
* description : longtext
* 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 sgm_crm transaction_drafts
* id : bigint(20) unsigned
* module : varchar(64)
* operation_mode : varchar(16)
* target_transaction_id : bigint(20) unsigned
* voucher_type_id : bigint(20) unsigned
* client_draft_uuid : char(36)
* idempotency_key : char(36)
* branch_id : int(11)
* finance_year_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* status : varchar(32)
* revision : int(10) unsigned
* base_transaction_version : varchar(64)
* base_transaction_hash : char(64)
* base_transaction_updated_at : datetime
* header_data : longtext
* summary_data : longtext
* posted_transaction_id : bigint(20) unsigned
* commit_mode : varchar(32)
* created_at : datetime
* updated_at : datetime
* last_sync_at : datetime
* frozen_at : datetime
* discarded_at : datetime
* posted_at : datetime
v sgm_crm transaction_draft_components
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* component_key : varchar(64)
* component_data : longtext
* revision : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm transaction_draft_items
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* row_uuid : char(36)
* item_id : bigint(20) unsigned
* row_data : longtext
* display_order : int(10) unsigned
* is_deleted : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_crm transaction_idempotency_keys
* id : bigint(20) unsigned
* module : varchar(64)
* idempotency_key : char(36)
* request_hash : char(64)
* branch_id : int(11)
* finance_year_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* status : varchar(24)
* transaction_id : bigint(20) unsigned
* voucher_type_id : bigint(20) unsigned
* voucher_number : varchar(100)
* response_data : longtext
* created_at : datetime
* updated_at : datetime
* completed_at : datetime
v sgm_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 sgm_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 sgm_crm transaction_safety_events
* id : bigint(20) unsigned
* draft_id : bigint(20) unsigned
* module : varchar(64)
* event_type : varchar(48)
* branch_id : int(11)
* finance_year_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* client_draft_uuid : char(36)
* idempotency_key : char(36)
* metadata : longtext
* created_at : datetime
v sgm_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 sgm_crm users_del
* 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 sgm_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 sgm_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
* signature : varchar(255)
* call_followup : tinyint(1)
* sales_print_documents : varchar(64)
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_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 sgm_crm user_roles
* id : smallint(5) unsigned
* role_name : varchar(50)
* is_super_admin : tinyint(1) unsigned
* branch_id : int(10) unsigned
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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 sgm_crm voucher_series_master
* id : int(11)
* voucher_code : varchar(50)
* branch_id : int(11)
* financial_year_id : int(11)
* prefix : varchar(20)
* suffix : varchar(20)
* current_number : int(11)
* reset_frequency : varchar(50)
* number_padding : tinyint(4)
v sgm_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 sgm_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 sgm_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','Stock','Credit_Note_Others','Discount_Credit_Note')
* 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
* invoice_bank_id : int(11)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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','SERVICE','EXPENSE')
* delete_status : tinyint(1)
* created_at : datetime
* updated_at : datetime
v sgm_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 sgm_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)
v sgm_crm z_bak_cleanup_20260905_b1fy13_att
* id : bigint(20) unsigned
* attachment_uuid : char(36)
* field_operation_id : bigint(20) unsigned
* entity_uuid : char(36)
* entity_type : varchar(30)
* evidence_role : varchar(80)
* attachment_kind : varchar(20)
* original_name : varchar(255)
* client_mime_type : varchar(150)
* verified_mime_type : varchar(150)
* byte_size : bigint(20) unsigned
* sha256 : char(64)
* total_chunks : int(10) unsigned
* received_chunks : int(10) unsigned
* upload_state : varchar(20)
* stored_path : varchar(500)
* latitude : decimal(10,7)
* longitude : decimal(10,7)
* accuracy_meters : decimal(10,2)
* captured_at_utc : datetime
* user_id : int(11)
* employee_id : int(11)
* branch_id : int(11)
* finance_year_id : int(11)
* device_id : bigint(20) unsigned
* completed_at : datetime
* created_at : datetime
* updated_at : datetime
v sgm_crm z_bak_cleanup_20260905_b1fy13_ops
* id : bigint(20) unsigned
* operation_uuid : char(36)
* entity_uuid : char(36)
* entity_type : varchar(30)
* action_type : varchar(40)
* status : varchar(30)
* user_id : int(11)
* employee_id : int(11)
* branch_id : int(11)
* finance_year_id : int(11)
* customer_ledger_id : int(11)
* title : varchar(255)
* captured_at_utc : datetime
* payload_json : longtext
* device_id : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm z_bak_mcrm_20260905_operations
* id : bigint(20) unsigned
* operation_uuid : char(36)
* entity_uuid : char(36)
* entity_type : varchar(30)
* action_type : varchar(40)
* status : varchar(30)
* user_id : int(11)
* employee_id : int(11)
* branch_id : int(11)
* finance_year_id : int(11)
* customer_ledger_id : int(11)
* title : varchar(255)
* captured_at_utc : datetime
* payload_json : longtext
* device_id : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v sgm_crm z_bak_mcrm_20260905_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 sgm_crm z_bak_mcrm_20260905_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 sgm_crm z_bak_mcrm_20260905_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)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship