* id role_id branch_id permission_key enabled created_at updated_at

* id alert_type alert_message triggered_on item_id ledger_id invoice_id lead_id branch_id user_id alert_level is_read resolved created_at updated_at

* id name age grade

* id employee_id branch_id calendar_id effective_from effective_to assignment_status created_by_user_id created_at updated_at

* id employee_id branch_id shift_type_id effective_from effective_to assignment_status created_by_user_id created_at updated_at

* id snapshot_id employee_id employee_code attendance_date attendance_day_id finance_year_id day_classification attendance_resolution_status attendance_finalized check_in_local_time check_out_local_time duration_minutes source_mode shift_type_id shift_code shift_name shift_start_time shift_end_time shift_required_minutes shift_grace_in_minutes shift_grace_out_minutes approved_leave_fraction leave_day_portion approved_overtime_minutes evidence_count evidence_hash flags_json source_snapshot_json row_hash created_at

* id snapshot_id employee_id employee_code employee_name designation source_branch_id scheduled_workdays present_days absent_days weekly_off_days holiday_days approved_leave_days payable_attendance_days payable_attendance_days_status total_worked_minutes approved_overtime_minutes late_count early_out_count short_hours_count attendance_exception_count summary_json row_hash created_at

* id snapshot_uuid period_id branch_id period_start period_end snapshot_version source_period_lock_version source_attendance_day_count source_employee_count source_evidence_count source_leave_day_count source_overtime_review_count source_correction_count readiness_json source_counts_json snapshot_hash created_by_user_id created_at_utc created_at

* id branch_id period_start period_end period_status lock_version close_comment close_snapshot_json closed_by_user_id closed_at_utc created_by_user_id created_at updated_at

* id period_id event_type actor_user_id event_at_utc details_json created_at

* id event_type entity_type entity_id branch_id actor_user_id event_at_utc details_json created_at

* id branch_id shift_code shift_name start_time end_time crosses_midnight grace_in_minutes grace_out_minutes required_minutes half_day_minutes overtime_after_minutes minimum_overtime_minutes is_flexible is_active delete_status created_by_user_id created_at updated_at

* id branch_id calendar_code calendar_name timezone_name effective_from effective_to is_default is_active delete_status created_by_user_id created_at updated_at

* id calendar_id work_date day_type day_name is_paid notes delete_status created_by_user_id created_at updated_at

* id calendar_id weekday_iso week_pattern created_at

* id entity_type entity_id version event_type reason branch_id finance_year_id changed_by changed_at changed_ip snapshot diff aux hash prev_hash invoice_no voucher_no voucher_date

* id name

* id group_id permission_id

* id request_token user_id recipient otp_hash expires_at attempts used_at created_at

* id name content_type_id codename

* id password last_login is_superuser username first_name last_name email is_staff is_active date_joined

* id user_id alias alias_type otp_destination is_active created_at

* id user_id group_id

* id user_id permission_id

* id bank_code bank_name short_name swift_code is_active branch_id created_at updated_at

* id connector_code key_id connector_key display_name device_id branch_id secret_fingerprint status connector_version heartbeat_status allowed_ip_cidrs last_ip last_heartbeat_at created_by created_at updated_at

* id provider_code device_code serial_number model branch_id timezone_name connection_mode device_host http_scheme http_port sdk_port status last_seen_at notes created_by created_at updated_at

* id device_id entity_type entity_id action_code actor_user_id request_id before_json after_json metadata_json event_at_utc created_at

* id provider_code model_pattern profile_version supports_user_management supports_face supports_fingerprint supports_card supports_time_sync supports_config_read supports_config_write supports_remote_commands supports_event_pull supports_event_push capabilities_json is_active created_by created_at updated_at

* id command_uuid device_id connector_instance_id command_type command_status priority payload_json result_json error_message requested_by requested_at not_before_at expires_at claimed_at started_at completed_at attempt_count created_at updated_at

* id device_id connector_instance_id device_name firmware_version firmware_released_date local_time timezone_raw time_mode network_endpoint_supported network_interface_id addressing_type ip_address subnet_mask default_gateway mac_address mtu dns_json endpoint_count read_supported_count configuration_read_surface_detected access_control_config_read_supported system_capabilities_read_supported system_status_read_supported storage_read_supported safe_endpoints_json profile_hash collected_at_utc created_at updated_at

* id device_id device_user_id enrollment_type enrollment_key enrollment_status template_hash enrolled_at last_verified_at metadata_json created_by created_at updated_at

* id device_id device_person_id display_name device_user_role device_user_status sync_status source_mode profile_hash last_synced_at last_seen_on_device_at raw_profile_json created_by created_at updated_at

* id device_id employee_id device_person_id status valid_from_utc valid_until_utc created_at updated_at

* id device_id connector_instance_id employee_mapping_id employee_id external_event_id event_fingerprint event_type verify_mode direction device_person_id occurred_at_utc device_local_time device_timezone raw_payload_json processing_status received_at_utc processed_at_utc processing_error created_at

* id connector_instance_id device_id state_type state_key state_value_json expires_at created_at updated_at

* id customer_id customer_name mobile_number call_type due_amount assigned_agent scheduled_date call_status remarks next_followup_date miss_count created_at updated_at

* locdvr_id location_id dvr_name model serial dvr_ip dvr_port dvr_usr dvr_pwd dvr_agchannels dvr_ipchannels motion_enabled httpport rtspport stime etime rec_date status rtsp_URL created_by_user_id

* id video_service_url

* id category_name active_status sort_order branch_id created_at updated_at

* id branch_id job_date shift operator_code operator_name machine_name job_no notes source_pdf_name report_info_json delete_status created_by created_at updated_at

* id job_id part_name source_name part_id gallery_file_id unit_price line_total match_status reference_thumbnail qty operation_remark delete_status created_at updated_at

* id branch_id part_id original_name stored_pdf_path stored_image_path thumbnail_path original_mime source_type file_size page_count production_info_json created_by created_at delete_status deleted_at

* id branch_id original_name stored_pdf_path stored_image_path thumbnail_path original_mime source_type file_size page_count plate_size total_cut_length total_travel_length pierce_count planned_process_time planned_cut_time planned_travel_time planned_pierce_time created_by created_at delete_status

* id branch_id part_id original_name stored_pdf_path stored_image_path thumbnail_path original_mime source_type file_size page_count production_info_json created_by created_at delete_status

* id branch_id part_id original_name stored_pdf_path stored_image_path thumbnail_path original_mime source_type file_size page_count production_info_json created_by created_at delete_status deleted_at

* id voucher_no voucher_type_id voucher_date contra_type from_account_id to_account_id instrument_type bank_name instrument_number amount narration branch_id finance_year_id created_by updated_by delete_status created_at updated_at

* coupon_code max_global_uses max_uses_per_customer is_scratch valid_from valid_to

* id coupon_code customer_id rule_id order_ref qty amount branch_id redeemed_at

* id enquiry_id medium template_id status scheduled_at sent_at created_by created_at updated_at delete_status

* id role_name is_active

* id enquiry_id link_type target_id created_by created_at

* id lead_type customer_company contact_person phone whatsapp address city pincode source stage next_followup customer_role next_steps description next_action routed_at auto_routed auto_route_json auto_route_conf handled_by branch_id status created_by created_at updated_at delete_status

* id source_name background_class badge_bg_color badge_text_color badge_color is_active

* id stage_name background_class badge_bg_color badge_text_color badge_color is_active

* id enquiry_id customer_company contact_phone city stage remarks created_by created_at updated_at delete_status

* id lead_id service_type machine_model serial_no preferred_visit_date technician_id priority warranty notes created_at updated_at

* id type_name is_active

* id entity_type entity_id task_type title due_at assigned_to status notes branch_id created_by created_at updated_at delete_status

* id ticket_no ticket_type entry_type entry_date ledger_id customer_name contact_person phone whatsapp city pincode address sales_person_id other_reference reference_notes is_exchange new_machine_price total_exchange net_payable exchange_status inspection_by pickup_date pickup_location exchange_remark status_id branch_id finance_year_id company_id created_by updated_by created_at updated_at delete_status

* id ticket_id machine_name model year machine_condition expected_value approved_value is_delete

* ticket_id source_id stage_id next_followup_date plan_date customer_role suggested_action assignee_id description

* ticket_id service_type_id machine_model serial_no preferred_visit_date technician_id priority notes visit_address delete_status created_at updated_at

* id status_code status_label badge_bg_color badge_text_color badge_color is_active delete_status created_at updated_at

* id status_code status_label background_class is_active

* id enquiry_id scheduled_at address city pincode assigned_to status notes created_by created_at updated_at delete_status

* id title description is_default active_status branch_id_deleted created_by modified_by created_at updated_at delete_status

* company_id branch_id customer_ledger_id latitude longitude enabled updated_by updated_at

* summary_date branch_id finance_year_id total_sales total_purchases total_receipts total_payments source_modified_at refreshed_at

* summary_date ledger_id branch_id dr_amount cr_amount id finance_year_id balance_date ledger_name led_group_id group_title root_group_id root_group_title main_group sub_group

* id branch_id finance_year_id balance_date ledger_id ledger_name led_group_id group_title root_group_id root_group_title main_group sub_group entry_side opening_debit opening_credit day_debit day_credit closing_debit closing_credit closing_balance created_at updated_at

* branch_id finance_year_id summary_year summary_month total_sales total_purchases total_receipts total_payments total_sales_return total_purchase_return total_revenue total_expenditure total_profit period_end source_modified_at refreshed_at

* id branch_id finance_year_id summary_date total_sales total_purchases total_receipts total_payments total_sales_return total_purchase_return total_revenue total_expenditure total_profit top_customer_id top_customer top_customer_amount top_item_id top_item top_item_quantity top_item_revenue total_customers total_suppliers total_visits total_leads total_employees source_modified_at last_updated

* branch_id finance_year_id fiscal_year_start total_sales total_purchases total_receipts total_payments total_sales_return total_purchase_return total_revenue total_expenditure total_profit period_start period_end source_modified_at refreshed_at

* id filter_name query_value is_active is_default

* id branch_id fiscal_year_id base_price quantity created_by modified_by created_at modified_at

* id sheet_id row_order sl_no product_name standard_discount additional_discount otl_discount special_discount plant_discount other_discount_1 other_discount_2 other_discount_3 freight_percent gst_percent created_at modified_at

* id entry_type ledger_id category_type_deleted category_value_deleted is_full_cash_discount is_proportionate_deleted is_round_off_discount item_wise_proportionate is_delete created_at modified_at

* id ref_entry_id ref_invoice_no ref_invoice_date voucher_number voucher_type_id entry_mode urd voucher_date voucher_time due_date ledger_id party_cat_id amount sgst_amount cgst_amount igst_amount cess_amount round_off invoice_amount payment_status narration receiver_name receiver_contact_number branch_id user_id modified_user_id finance_year_id delete_status created_at updated_at posting_status source_module source_id source_reference source_locked

* id expense_entry_id ledger_id hsn_sac_id amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage tax_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status created_at updated_at

* id claim_id approval_rule_id approval_level required_role_id assigned_user_id decision acted_by remarks requested_at acted_at branch_id delete_status created_at updated_at

* id scheme_id approval_level minimum_claim_amount maximum_claim_amount approver_role_id is_mandatory is_final_level branch_id is_active delete_status created_by updated_by created_at updated_at

* id claim_no claim_sequence_no idempotency_key scheme_id agreement_id ledger_id period_from period_to turnover_basis gross_sales_amount sales_return_amount eligible_turnover_amount collection_amount target_amount achievement_percent applicable_discount_rate fixed_discount_amount discount_amount cgst_amount sgst_amount igst_amount cess_amount round_off gross_credit_amount document_type agreement_pre_supply invoice_link_confirmed taxable_value_reduction itc_reversal_required decision_reason status calculation_version row_version source_snapshot_hash snapshot_at credit_note_entry_id credit_note_voucher_no branch_id finance_year_id created_by updated_by submitted_by approved_by posted_by rejected_by reversed_by submitted_at approved_at posted_at rejected_at reversed_at rejection_reason reversal_reason delete_status deleted_by deleted_at created_at updated_at discount_basis_mode discount_base_amount discount_amount_semantics taxable_discount_amount allocation_engine

* id claim_id event_type from_status to_status snapshot_hash remarks user_id branch_id created_at

* id branch_id finance_year_id prefix padding next_number last_claim_id updated_by created_at updated_at

* id entity_type entity_id event_type before_snapshot after_snapshot branch_id user_id request_ip created_at

* id claim_id credit_note_entry_id sales_entry_id invoice_outstanding_id allocation_date allocated_amount allocation_type status reversal_of_id remarks branch_id finance_year_id created_by reversed_by reversed_at created_at updated_at

* id claim_id credit_note_entry_id reversal_run_id claim_no_snapshot document_type operation_mode voucher_type_id voucher_number voucher_date source_state_hash plan_hash claim_row_version_before credit_note_posting_status_before credit_note_payment_status_before cancellation_effective_date cancellation_reason status cancelled_by cancelled_at branch_id finance_year_id created_at

* id cancellation_id claim_id credit_note_entry_id event_type state_hash_before state_hash_after details_json action_hash user_id branch_id finance_year_id request_ip created_at

* id claim_id credit_note_entry_id link_scope invoice_allocation_id sales_entry_id source_invoice_no linked_amount document_type branch_id finance_year_id created_by delete_status created_at updated_at

* id scheme_id ledger_id agreement_no agreement_date valid_from valid_to customer_target_amount custom_discount_rate custom_fixed_discount_amount document_path status remarks branch_id delete_status created_by updated_by cancelled_by cancelled_at created_at updated_at

* id claim_id scheme_gst_treatment document_type tax_effect agreement_pre_supply invoice_link_confirmed taxable_value_reduction itc_reversal_required decision_reason final_discount_amount final_cgst_amount final_sgst_amount final_igst_amount final_cess_amount final_gross_credit_amount reviewed_by reviewed_at branch_id delete_status created_at updated_at

* id plan_run_id claim_id credit_note_entry_id plan_overall_hash generation_hash voucher_type_id voucher_series_id voucher_sequence_no voucher_number voucher_date taxable_amount cgst_amount sgst_amount igst_amount cess_amount round_off_amount gross_credit_amount item_line_count status branch_id finance_year_id created_by created_at

* id plan_run_id line_no ledger_id hsn_sac_id hsn_sac_code hsn_description hsn_type amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage generated_tax_amount generated_cgst_amount generated_sgst_amount generated_igst_amount generated_cess_amount generated_gross_credit_amount snapshot_cgst_amount snapshot_sgst_amount snapshot_igst_amount snapshot_cess_amount snapshot_gross_credit_amount source_item_rows source_invoice_count line_hash branch_id finance_year_id created_at

* id claim_id claim_no_snapshot claim_source_snapshot_hash document_review_hash document_type tax_effect jurisdiction branch_gstin recipient_gstin branch_state_id recipient_state_id selected_invoice_count source_item_rows trace_row_count hsn_line_count posting_line_count snapshot_taxable_amount snapshot_cgst_amount snapshot_sgst_amount snapshot_igst_amount snapshot_cess_amount snapshot_gross_credit_amount generated_taxable_amount generated_cgst_amount generated_sgst_amount generated_igst_amount generated_cess_amount generated_gross_credit_amount round_off_amount trace_set_hash hsn_plan_hash posting_plan_hash overall_plan_hash status branch_id finance_year_id created_by created_at

* id plan_run_id line_no role ledger_id ledger_name_snapshot entry_side dr_amount cr_amount line_hash branch_id finance_year_id created_at

* id plan_run_id generation_id claim_id credit_note_entry_id voucher_type_id voucher_no voucher_date plan_overall_hash generation_hash frozen_posting_plan_hash execution_plan_hash status expected_ledger_rows actual_ledger_rows expected_audit_rows actual_audit_rows outstanding_id attempt_count requires_repair last_error prepared_by last_attempt_by posted_by branch_id finance_year_id prepared_at last_attempt_at posted_at created_at updated_at

* id posting_run_id line_no source_plan_line_id source_plan_line_no source_line_hash role ledger_id ledger_name_snapshot ledger_group_id entry_side dr_amount cr_amount correspondent_ledger_id corr_ledger_group_id sort_order is_main_row cash_or_bank by_or_to txn_date narration row_fingerprint ledger_posting_id audit_posting_id created_at updated_at

* id claim_id credit_note_entry_id source_itc_tracking_id claim_no_snapshot document_type source_itc_status_snapshot source_itc_reversal_amount_snapshot actual_posted_gst_amount_snapshot reversal_effective_date step11b_policy_foundation_hash source_state_hash accounting_period_policy_hash accounting_period_snapshot_hash tax_filing_guard_source tax_period_from tax_period_to tax_period_reference tax_filing_reference tax_filing_status_snapshot review_outcome_code review_reason is_final record_hash reviewed_by reviewed_at branch_id finance_year_id created_at

* id compliance_id claim_id credit_note_entry_id source_itc_tracking_id event_type details_json action_hash user_id branch_id finance_year_id request_ip created_at

* id plan_run_id line_no claim_id invoice_allocation_id tax_allocation_id sales_entry_id sales_entry_item_id item_id hsn_sac_id invoice_voucher_no invoice_date hsn_sac_code hsn_description hsn_type source_item_taxable_amount discount_taxable_amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage snapshot_cgst_amount snapshot_sgst_amount snapshot_igst_amount snapshot_cess_amount snapshot_gross_credit_amount trace_mode trace_hash branch_id finance_year_id created_at

* id claim_id sales_entry_id invoice_voucher_no invoice_date invoice_gross_amount invoice_taxable_amount return_taxable_amount eligible_amount collected_amount allocation_percent discount_amount cgst_amount sgst_amount igst_amount cess_amount gross_credit_amount allocation_status exclude_reason source_snapshot_hash branch_id finance_year_id delete_status created_at updated_at

* id itc_tracking_id claim_id original_file_name stored_file_name storage_path mime_type byte_size sha256_hex branch_id finance_year_id uploaded_by delete_status deleted_by created_at deleted_at

* id claim_id status recipient_gstin itc_reversal_amount confirmation_reference confirmation_date evidence_path remarks confirmed_by confirmed_at branch_id delete_status created_at updated_at

* id itc_tracking_id claim_id action_type from_status to_status expected_itc_reversal_amount stored_itc_reversal_amount_before stored_itc_reversal_amount_after recipient_gstin_snapshot confirmation_reference_snapshot confirmation_date_snapshot evidence_count before_snapshot after_snapshot action_hash user_id branch_id finance_year_id request_ip created_at

* id claim_id credit_note_entry_id voucher_type_id voucher_no plan_hash status expected_ledger_rows actual_ledger_rows expected_audit_rows actual_audit_rows outstanding_id attempt_count requires_repair last_error prepared_by last_attempt_by posted_by branch_id finance_year_id prepared_at last_attempt_at posted_at created_at updated_at

* id posting_run_id line_no ledger_id ledger_group_id entry_side dr_amount cr_amount correspondent_ledger_id corr_ledger_group_id sort_order is_main_row cash_or_bank by_or_to txn_date narration row_fingerprint ledger_posting_id audit_posting_id created_at updated_at

* id reversal_run_id line_no source_allocation_id source_sales_entry_id source_invoice_outstanding_id source_allocated_amount source_allocation_type source_allocation_status source_reversal_of_id source_snapshot_hash planned_action execution_status executed_reversal_allocation_id created_at updated_at

* id reversal_run_id claim_id event_type from_status to_status state_hash_before state_hash_after details_json action_hash user_id branch_id finance_year_id request_ip created_at

* id reversal_run_id line_no source_outstanding_id source_voucher_type_id source_voucher_id source_voucher_number source_ledger_id source_dr_amount source_cr_amount source_delete_status source_is_cancelled source_snapshot_hash planned_action execution_status post_state_hash executed_at created_at updated_at

* id branch_id finance_year_id period_label period_start period_end is_open remarks row_version opened_by opened_at closed_by closed_at created_by updated_by created_at updated_at

* id period_id branch_id finance_year_id event_type state_hash_before state_hash_after details_json action_hash user_id request_ip created_at

* id claim_id claim_no_snapshot operation_mode document_type source_credit_note_entry_id source_voucher_type_id source_voucher_no source_state_hash source_claim_row_version source_claim_snapshot_hash source_posting_family source_posting_run_id source_posting_plan_hash source_itc_status reason requested_effective_date plan_hash idempotency_key status expected_allocation_rows actual_allocation_rows expected_ledger_rows actual_ledger_rows expected_audit_rows actual_audit_rows expected_outstanding_rows actual_outstanding_rows requires_repair last_error prepared_by last_attempt_by completed_by branch_id finance_year_id prepared_at last_attempt_at completed_at created_at updated_at

* id reversal_run_id line_no source_posting_family source_posting_run_line_id source_ledger_posting_id source_audit_posting_id source_row_fingerprint ledger_id ledger_group_id original_entry_side original_dr_amount original_cr_amount reversal_entry_side reversal_dr_amount reversal_cr_amount correspondent_ledger_id corr_ledger_group_id sort_order is_main_row cash_or_bank by_or_to txn_date narration reversal_row_fingerprint reversal_ledger_posting_id reversal_audit_posting_id execution_status created_at updated_at

* id branch_id finance_year_id reversal_plan_write_enabled allocation_reversal_execute_enabled outstanding_reversal_execute_enabled reversal_execute_enabled cancellation_execute_enabled gst_reversal_execute_enabled created_by updated_by created_at updated_at

* id scheme_code scheme_name scheme_type calculation_method turnover_basis claim_frequency valid_from valid_to minimum_turnover maximum_turnover target_amount default_discount_rate fixed_discount_amount maximum_discount_amount return_treatment agreement_required invoice_link_required gst_treatment_mode itc_confirmation_required approval_required allow_partial_claim allow_multiple_claims_per_period discount_ledger_id priority notes branch_id is_active delete_status created_by updated_by deleted_by deleted_at created_at updated_at discount_basis_mode

* id scheme_id slab_no basis_type from_value to_value discount_rate fixed_discount_amount is_active delete_status created_by updated_by created_at updated_at

* id scheme_id target_type target_ref_id target_action branch_id delete_status created_by updated_by created_at updated_at

* id branch_id module_enabled posting_enabled credit_allocation_enabled gst_plan_enabled gst_credit_note_generation_enabled gst_posting_enabled itc_tracking_write_enabled approval_enabled allow_document_type_override require_itc_before_posting claim_prefix claim_number_padding created_by updated_by created_at updated_at

* id claim_id invoice_allocation_id sales_entry_id sales_entry_item_id item_id hsn_sac_id allocation_level source_taxable_amount return_taxable_amount eligible_taxable_amount discount_taxable_amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage cgst_amount sgst_amount igst_amount cess_amount gross_credit_amount branch_id finance_year_id delete_status created_at updated_at

* target_id discount_rule_id target_type target_ref_id customer_segment_id discount_value operator_override min_qty_override min_amount_override combine_override priority_override branch_id delete_status created_at updated_at

* id sales_entry_id voucher_type_id delivery_note_no dispatch_doc_no dispatch_date dispatched_through destination carrier_ledger_id bill_of_lading lr_rr_date motor_vehicle_no buyer_order_no buyer_date tracking_no tracking_date debit_note_no debit_note_date grn_no branch_id created_by created_at updated_at delete_status

* id action_time object_id object_repr action_flag change_message content_type_id user_id

* id app_label model

* id app name applied

* session_key session_data expire_date

* id branch_id finance_year_id item_id last_purchase_price last_purchase_entry_id last_purchase_item_id last_purchase_date average_sales_price sales_value_sum sales_quantity_sum sales_row_count lpp_refreshed_at asp_refreshed_at refreshed_at version_no refreshed_by

* competitor_price_id item_id competitor_name price branch_id last_checked is_active delete_status created_by updated_by created_at updated_at

* id item_id strategy undercut_value branch_id is_active delete_status created_by updated_by created_at updated_at

* id branch_id item_id brand_id category_id pricing_strategy costing_method min_margin_percent allow_competitor_price competitor_alignment_mode competitor_floor_margin_pct stock_low_threshold stock_high_threshold stock_low_markup_pct stock_high_markdown_pct average_sales_lookback_days rounding_rule effective_from effective_to delete_status created_at updated_at

* id rule_name rule_type reference_id discount_type discount_value valid_from valid_to branch_id is_active delete_status created_by updated_by created_at updated_at

* id rule_type reference_id margin_percent branch_id is_active delete_status created_by updated_by created_at updated_at

* id branch_id scope_type scope_id price_source calculation_type calculation_value minimum_price maximum_price cap_at_mrp rounding_method rounding_increment effective_from effective_to is_active delete_status notes version_no created_by updated_by created_at updated_at

* id rule_id branch_id event_type before_snapshot after_snapshot user_id request_ip created_at

* id entry_id voucher_type_id invoice_type ack_no ack_date irn status signed_invoice signed_qr_code ewb_no ewb_date ewb_valid_till remarks e_invoice_send_data e_invoice_response e_way_send_data e_way_response e_way_cancelled_date e_invoice_cancelled_date e_way_allow_cancel e_invoice_allow_cancel active created_by modified_by created_at updated_at

* id entry_type voucher_type_id entry_id payload response created_by added_at

* id invoice_type voucher_type_id entry_id irn_no ewb_no cancelled_date added_by added_at

* id user_id message_id filename pdf_path content_sha256 category category_label is_relevant processed_at email_from email_to email_subject email_date vendor_name document_date total_amount currency document_number confidence_score relevance_reason uploaded_to_mysql invoice_check_status invoice_checked_at invoice_check_error email_body email_snippet extracted_text json_path json_content

* id document_id user_id message_id invoice_number gst_number supplier_name invoice_json is_purchase_invoice is_invoice_moved extraction_status extraction_confidence extraction_model schema_version extracted_at extraction_error source_pdf_path created_at updated_at

* user_id message_id email_from email_to email_subject email_date email_received_at processed_at

* user_id company_names gst_number registered_address known_vendors known_clients

* id google_id email name picture access_token refresh_token token_expiry created_at remember_token_hash remember_token_expires smtp_host smtp_port smtp_username smtp_password smtp_encryption smtp_from_email smtp_from_name smtp_enabled smtp_updated_at sync_keywords last_sync_time

* id mail_driver mail_from_name mail_from_email enable_queue host port username password encryption is_active branch_id created_at updated_at

* id employee_code photo full_name designation email mobile_number date_of_joining date_of_birth branch_id user_role_id is_sales_person is_telecaller reporting_manager_id login_user_id address city state_id country_id pincode is_active delete_status created_at updated_at

* id correction_request_id event_type actor_user_id event_at_utc details_json created_at

* id correction_uuid attendance_day_id employee_id branch_id attendance_date request_type reason_code reason_text requested_check_in_local_time requested_check_out_local_time clear_check_out daily_updated_at_snapshot before_snapshot_json after_snapshot_json status requested_by_user_id requested_at_utc reviewed_by_user_id reviewed_at_utc review_comment self_approval applied_at_utc created_at updated_at

* id attendance_uuid employee_id user_id branch_id finance_year_id attendance_date timezone_name check_in_at_utc check_out_at_utc check_in_local_time check_out_local_time check_in_source check_out_source source_mode resolution_status decision_policy_version duration_minutes is_finalized finalized_at_utc created_at updated_at

* id attendance_day_id evidence_key source_type source_record_id evidence_role occurred_at_utc local_time timezone_name is_explicit confidence metadata_json created_at

* id attendance_day_id employee_id branch_id potential_minutes approved_minutes review_status reviewed_by_user_id review_comment reviewed_at_utc created_at updated_at

* id leave_request_id event_type actor_user_id event_at_utc details_json created_at

* id request_uuid employee_id branch_id leave_type_id date_from date_to total_requested_days request_reason request_status requested_by_user_id requested_at_utc reviewed_by_user_id review_comment reviewed_at_utc created_at updated_at

* id leave_request_id employee_id branch_id leave_date day_portion day_fraction created_at

* id branch_id leave_code leave_name is_paid annual_entitlement_days allow_half_day exclude_weekly_off exclude_holidays is_active delete_status created_by_user_id created_at updated_at

* id event_uuid payload_hash tracking_session_id sequence_no employee_id user_id device_id branch_id finance_year_id latitude longitude accuracy altitude speed heading recorded_at_device received_at_server monotonic_elapsed_ms is_mocked source activity_context quality_flags accepted_for_metrics created_at

* branch_id employee_context revision enabled upload_interval_seconds batch_size stationary_interval_seconds max_pending_points

* id operation_uuid session_uuid event_type user_id employee_id device_id branch_id finance_year_id payload_hash response_json received_at created_at

* id event_uuid event_type severity company_id branch_id finance_year_id user_id employee_id device_id tracking_session_id visit_id detail_json occurred_at

* id company_id branch_id finance_year_id employee_context changed_by source request_ip old_value_json new_value_json created_at

* company_id branch_id detailed_days summary_days archive_enabled updated_by created_at updated_at

* id session_uuid employee_id user_id device_id device_uuid branch_id finance_year_id company_id employee_context policy_version policy_snapshot_json started_at ended_at authorized_until start_latitude start_longitude start_accuracy end_latitude end_longitude end_accuracy status active_employee_id last_location_at last_received_at last_point_id total_distance_meters total_active_seconds total_idle_seconds total_visits summary_state summary_version created_at updated_at

* id branch_id employee_context policy_version tracking_enabled background_tracking_enabled minimum_time_interval_seconds minimum_distance_meters geofence_radius_meters stale_location_minutes low_accuracy_threshold_meters offline_tracking_allowed require_location_for_checkin require_location_for_checkout mock_location_policy start_day_required end_day_required max_session_seconds timezone_name updated_by created_at updated_at

* company_id branch_id finance_year_id user_id employee_id employee_context enabled expires_at created_at updated_at

* id visit_uuid tracking_session_id employee_id branch_id finance_year_id visit_type customer_ledger_id service_ticket_id planned_crm_visit_id customer_location_id checkin_at checkout_at checkin_latitude checkin_longitude checkin_accuracy checkout_latitude checkout_longitude checkout_accuracy customer_latitude customer_longitude checkin_distance_meters checkout_distance_meters geofence_radius_meters geofence_status status active_session_id outcome remarks row_version created_at updated_at

* id item_name item_code item_description mrp_delete gst_percent_delete exchange_value_delete branch_id delete_status created_at updated_at

* id exchange_id year_from year_to exchange_value is_active created_at modified_at

* id expense_type expense_invoice_no expense_invoice_date voucher_number voucher_type_id entry_mode urd voucher_date voucher_time due_date ledger_id party_cat_id amount sgst_amount cgst_amount igst_amount cess_amount round_off price pri_discount after_prim_dis_price proportionate_discount additional_discount total_discount add_charges taxable_amount item_tax_amount add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount invoice_amount freight_charges payment_status narration receiver_name receiver_contact_number branch_id user_id modified_user_id finance_year_id delete_status is_cancelled created_at updated_at posting_status calc_add_discount_from

* id expense_entry_id item_id ledger_id hsn_sac_id uom_id quantity rate price discount_type discount_value discount_amount proportionate_discount proportionate_discount_selected_items taxable_amount proportionate_add_charges_amount amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage tax_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status is_cancelled created_at updated_at

* id invoice_id discount_details total_fixed_discount total_prop_discount remarks selected_prop_discount_items_old selected_prop_discount_items delete_status created_at updated_at

* id voucher_type_id voucher_no voucher_date ledger_id expense_ledger_id gst_aplicability itc_eligible ref_bill_no amount branch_id user_id narration delete_status created_at updated_at created_by modified_by finance_year_id

* id expense_id invoice_id allocated_amount remarks delete_status created_at updated_at

* id expense_id invoice_id allocated_amount remarks delete_status created_at updated_at

* id voucher_type_id entry_date entry_id e_type consignor_name consignor_gstin consignor_state consignor_actual_state consignor_address1 consignor_address2 consignor_pincode consignor_place dispatch_from_name dispatch_from_state dispatch_from_address1 dispatch_from_pincode dispatch_from_place consignee_name consignee_gstin consignee_state consignee_actual_state consignee_address1 consignee_address2 consignee_pincode consignee_place ship_to_name ship_to_gstin ship_to_state ship_to_address1 ship_to_pincode ship_to_place supplyType subSupplyType subSupplyDesc docType transporter_name transporter_id transport_mode transport_doc_no vehicle_no transport_date vehicle_type transDistance transactionType reason_for_transportation is_active created_by modified_by created_at updated_at

* ledger_id branch_id finance_year_id opening_balance transaction_dr transaction_cr closing_balance

* ledger_id branch_id finance_year_id opening_balance transaction_dr transaction_cr closing_balance

* id branch_id year fiscal_year start_date end_date delete_status created_at updated_at

* id environment invoice_type ip_address client_id client_secret username password gstin email authtoken_url gst_verification_url eInvoice_url eWay_url eWay_cancel_url eInvoice_cancel_url is_active created_at updated_at

* id invoice_type auth_code expiry_time created_at

* id type_name tax_type_code description is_default is_active delete_status created_at updated_at

* id crm_user_id branch_id provider scraper_user_id gmail_email gmail_name gmail_picture delete_status connected_at updated_at

* id voucher_type_id voucher_id voucher_number ledger_id invoice_date dr_amount cr_amount branch_id finance_year_id narration created_at updated_at delete_status is_cancelled due_date

* id branch_id voucher_type_id template active

* id display_scheme scheme_price item_price required_exchange_discount calc_add_discount_from eway_required_above_amount

* id item_name alias_name item_code packing packing_numbers item_type1 hsn_sac_id ledger_id item_cat_id godown_id uom_id alternative_uom_id brand_id company_id item_type valuation_method standard_cost price_basis mrp alternative_value profit_logic price_type profit_value price average_price last_purchase_price purchase_price sale_price_delete tax_rate stock_quantity opening_value max_qty min_qty reorder_days low_stock_alert is_subsidy_item is_edit_mrp show_without_stock branch_id_deleted item_name_key name_norm aliases_norm delete_status_deleted created_by modified_by created_at updated_at

* id item_id branch_id is_deleted created_at updated_at

* id brand_name description branch_id_deleted is_active delete_status created_at updated_at

* id category_name agri_type is_active sort_order description background_color bullet_symbol branch_id_deleted delete_status created_at updated_at

* id item_cat_id discount_source source_id discount_type discount_value is_active branch_id created_at updated_at

* id company_name description branch_id is_active delete_status created_at updated_at

* id code title description active_status created_at updated_at

* id category_name description discount_type_id discount_type is_default delete_status created_at updated_at

* id discount_type_name description is_active delete_status created_at updated_at

* id godown_name code description branch_id address city pincode state_id country_id contact_number email incharge_name is_primary active_status delete_status created_at updated_at

* id hsn_sac_code effective_date active_status gst cgst sgst igst cess branch_id is_delete created_at updated_at

* id item_id godown_id branch_id finance_year_id opening_qty opening_rate opening_value created_by modified_by created_at updated_at

* id scheme_name discount_type_id discount_type applicable_districts effective_from effective_to poster_image branch_id is_active delete_status created_at updated_at

* id item_id branch_id trans_type trans_ref_id trans_date qty_in qty_out balance_qty narration created_at

* id item_id branch_id opening_qty inward_qty outward_qty closing_qty last_updated

* id hsn_sac_code hsn_description hsn_type tax_percentage cgst sgst igst cess tax_type tax_group_name effective_date active_status branch_id_deleted company_id state_id country_id is_delete created_at updated_at

* id uom_name uom_code description branch_id_deleted created_at updated_at delete_status

* id branch_id finance_year_id balance_date item_id godown_id batch_no valuation_method_used opening_qty opening_value in_qty in_value out_qty out_value closing_qty closing_value

* id branch_id finance_year_id balance_date item_id godown_id item_name item_cat_id stock_group valuation_method_used opening_qty opening_value opening_rate in_qty in_value in_rate out_qty out_value out_rate closing_qty closing_value closing_rate created_at updated_at

* id branch_id finance_year_id item_id godown_id item_cat_id valuation_method_used earliest_affected_date reason marked_at

* id branch_id finance_year_id item_id godown_id item_cat_id valuation_method_used earliest_affected_date reason marked_at

* id started_at finished_at authorized_user_id branch_id finance_year_id valuation_method_used item_scope godown_scope earliest_affected_date rows_read rows_deleted rows_inserted rows_updated batch_count lock_wait_ms total_duration_ms php_peak_memory_bytes outcome error_category created_at

* branch_id item_id price_basis base_price unit_price applied_rules_json rules_hash valid_from valid_to updated_at

* id item_id branch_id financial_year_id stock_qty total_in_qty total_in_value total_out_qty wac_rate stock_value last_txn_id updated_at

* id item_id branch_id financial_year_id finance_year_id godown_id uom_id voucher_type_id voucher_no in_out_type quantity rate taxable_amount ref_type ref_id ref_line_id transaction_value transaction_date voucher_id voucher_type reference_table reference_id narration created_at delete_status is_cancelled is_auto_added

* id voucher_number voucher_type_id voucher_date journal_date branch_id finance_year_id narration posting_status delete_status created_by updated_by created_at updated_at

* id journal_voucher_id ledger_id dr_amount cr_amount delete_status is_cancelled created_at updated_at

* id ledger_id branch_id account_holder_name account_no ifsc_code bank_ledger_name branch_name account_type upi_id swift_code micr_code bank_details_applies_to_invoice is_primary opening_balance_deleted balance_type notes active_status delete_status created_at updated_at

* id ledger_id contact_person_name contact_person_last_name designation contact_number whatsapp_number email_address is_primary created_at updated_at

* id ledger_name alias_name primary_group_id reverse_charge is_gst_applicable hsn_code_id trade_name contact_person_name mail_to address city pincode state_id district_id country_id customer_type_id caste_category gender gst_verified gst_registration_types_id gst_number pan_number company_contact_number whatsapp_number mobile email_id website tags party_type_id_del party_cat_id parent_group_id account_group_id led_group_id credit_days credit_limit auto_block_on_overdue delivery_source delivery_source_id branch_id delete_status module ledger_key_id voucher_type_id tds_section_code ledger_type sale_order charge_kind is_cash_ledger_override_id system_ledger_applies_to is_carrier_agent is_default_carrier_agent finance_year_id created_by modified_by created_at updated_at

* id ledger_name trade_name led_type_id voucher_type_id sales_entry_id billing_id address_type caste_category gender address city pincode state_id country_id gst_registration_types_id gst_number gst_verified pan_number company_contact_number whatsapp_number email_id delivery_source branch_id delete_status created_at updated_at

* id title parent_group_id is_primary is_secondary is_custom sub_group entry_side delete_status main_group child_group description active_status branch_id created_at updated_at sort_order report_side report_type report_schedule

* id ledger_key header_field description section_code ledger_type editable apply_on_deleted module account_category account_group default_ledger is_active created_at created_by updated_at updated_by external_ref_code

* id ledger_id finance_year_id financial_year opening_debit opening_credit branch_id created_by modified_by created_at updated_at delete_status

* id ledger_id address_type is_primary ship_to gst_no gst_verified address city state_id country_id pincode contact_person contact_no email_id branch_id created_at updated_at

* id posting_date txn_date voucher_id voucher_no voucher_type_id voucher_date ledger_id entry_side dr_amount cr_amount branch_id finance_year_id user_id narration sort_order is_main_row cash_or_bank by_or_to other_details correspondent_ledger_id created_at updated_at delete_status is_cancelled deleted_by deleted_at

* id posting_date voucher_id line_no voucher_no voucher_type_id voucher_date ledger_id ledger_group_id amount_signed currency_code fx_rate amount_base branch_id finance_year_id user_id narration correspondent_ledger_id corr_ledger_group_id instrument_no instrument_date recon_status recon_date cost_center_id project_id source_module source_id tds_deduction_id created_at updated_at delete_status deleted_by deleted_at

* id ledger_id ledger_cash_id parent_led_id shipping_id voucher_type_id is_primary address_type ship_to mailing_name shipping_address shipping_contact shipping_city shipping_state_id shipping_country_id shipping_pincode shipping_gstin gst_verified contact_person contact_no email_id place_of_supply delivery_source_deleted godown_id_deleted plant_id_deleted branch_id created_at updated_at

* id ref_table ref_id voucher_type_id voucher_type voucher_id voucher_number voucher_date ledger_id ledger_name parent_group_id parent_group_title ledger_group_id ledger_group_title dr_amount cr_amount narration delete_status correspondent_ledger correspondent_ledger_id branch_id created_at updated_at by to is_other_details is_cash_bank_detailsreport correspondent_date alias_ledger_id

* id title group_type is_default description active_status created_at updated_at

* id gstin access_token token_expiry created_at

* id phone_number message_text status created_at

* id identifier_hash request_ip device_uuid success reason_code user_id created_at

* id user_id employee_id device_uuid device_name platform app_version status last_ip last_seen_at revoked_at revoke_reason created_at updated_at

* id session_uuid user_id employee_id device_id access_token_hash refresh_token_hash access_expires_at refresh_expires_at offline_valid_until last_seen_at last_ip user_agent revoked_at revoke_reason created_at updated_at

* id review_id field_operation_id action_code from_state to_state actor_user_id company_id branch_id finance_year_id details_json created_at

* id field_operation_id operation_uuid entity_uuid company_id branch_id finance_year_id submitting_user_id employee_id review_state receiving_ledger_id receipt_voucher_id receipt_voucher_no reviewed_by reviewed_at rejection_reason row_version created_at updated_at

* entity_uuid field_operation_id ticket_id ticket_type employee_id branch_id finance_year_id company_id created_at

* id token_hash ledger_id branch_id finance_year_id from_date to_date created_by_user_id employee_id device_id expires_at revoked_at view_count last_viewed_at created_at updated_at

* id operation_uuid entity_uuid entity_type action_type status user_id employee_id branch_id finance_year_id customer_ledger_id title captured_at_utc payload_json device_id created_at updated_at

* id attachment_uuid field_operation_id entity_uuid entity_type evidence_role attachment_kind original_name client_mime_type verified_mime_type byte_size sha256 total_chunks received_chunks upload_state stored_path latitude longitude accuracy_meters captured_at_utc user_id employee_id branch_id finance_year_id device_id completed_at created_at updated_at

* user_id alert_id branch_id read_at updated_at

* summary_month branch_id total_sales total_purchases total_receipts total_payments credit_note debit_note finance_year_id

* id part_id part_title part_title_real part_cost image_path image_url gallery_file_id image_hash visual_hash calculation_json is_active delete_status created_at updated_at

* id part_id part_title part_cost image_path image_url is_active delete_status created_at updated_at

* id part_id part_title part_cost image_path image_url gallery_file_id image_hash is_active delete_status created_at updated_at

* id part_id part_title part_cost image_path image_url gallery_file_id image_hash is_active delete_status created_at updated_at

* id party_id comment_type comment_text commenter comment_date branch_id delete_status created_at updated_at

* id title description sale_order_mode active_status branch_id created_by modified_by created_at updated_at delete_status

* id transaction_id voucher_type_id voucher_date ledger_id ledger_account_id ledger_account_name instrument_type instrument_number bank_name amount branch_id narration received_status move_to_receipt is_subsidy_payment delete_status created_at updated_at

* id date time ledger_id type promise_amount promise_date note call_by created_at modified_at

* id ledger_id user_id status lock_date_time

* id payment_transaction_id purchase_entry_id allocated_amount branch_id delete_status created_at updated_at

* id name sort_order is_active branch_id created_at updated_at

* id entry_type voucher_type_id cash_or_bank instrument_type voucher_no voucher_date ledger_id ledger_account_id expense_head gst_aplicability ref_bill_no instrument_number amount branch_id reference_type_id advance_reference_id user_id narration delete_status is_cancelled created_at updated_at created_by modified_by finance_year_id bank_name account_no ifsc_code reference_id

* id payment_voucher_id voucher_type_id invoice_id advance_voucher_type_id advance_invoice_id allocated_amount remarks delete_status is_cancelled created_at updated_at

* id batch_uuid branch_id payroll_month period_start period_end payroll_run_id source_run_uuid source_run_version source_run_input_hash source_result_hash source_finalize_event_id source_payslip_count source_payslip_set_hash source_accounting_configuration_id source_accounting_configuration_version source_accounting_configuration_hash posting_version posting_status line_count total_debit total_credit posting_hash native_voucher_type_id native_reference_type native_reference_id native_reference_no created_by posted_by created_at_utc posted_at_utc posting_attempted_at_utc posting_error_code posting_error_message created_at updated_at

* id payroll_accounting_configuration_id mapping_role component_id component_code ledger_id entry_side amount_source display_order mapping_hash created_at updated_at

* id config_uuid branch_id finance_year_id config_version config_status journal_voucher_type_id salary_expense_ledger_id salary_payable_ledger_id config_hash lock_version notes created_by updated_by approved_by approved_at_utc created_at updated_at

* id payroll_accounting_batch_id branch_id payroll_month action_code actor_user_id request_id details_json event_at_utc created_at

* id payroll_accounting_batch_id line_no ledger_role ledger_id employee_id payroll_payslip_id component_id component_code description debit_amount credit_amount source_hash line_hash created_at

* id policy_uuid branch_id policy_version policy_status effective_from effective_to proration_method fixed_days_divisor rounding_mode rounding_scale policy_hash lock_version notes created_by updated_by approved_by approved_at_utc created_at updated_at

* id employee_id branch_id structure_version_id effective_from effective_to assignment_status assignment_version reference_monthly_gross reference_monthly_ctc notes created_by updated_by created_at updated_at

* id assignment_id component_id value_source calculation_method amount_value rate_value basis_code formula_expression created_at updated_at

* id branch_id entity_type entity_id action_code actor_user_id request_id event_at_utc details_json created_at

* id payslip_uuid branch_id payroll_month period_start period_end payroll_run_id payroll_run_employee_id employee_id employee_code employee_name designation payslip_version payslip_status source_run_uuid source_run_version source_run_input_hash source_result_hash source_finalize_event_id payable_attendance_days gross_amount deduction_amount employer_contribution_amount net_amount payslip_hash generated_by generated_at_utc created_at

* id payroll_payslip_id source_run_component_id component_id component_code component_name component_type display_order is_taxable affects_gross affects_net is_statutory calculated_amount source_component_input_hash component_hash created_at

* id run_uuid branch_id payroll_month period_start period_end run_version run_status attendance_period_id attendance_snapshot_id attendance_snapshot_uuid attendance_snapshot_version attendance_snapshot_hash source_period_lock_version payroll_policy_id payroll_policy_version payroll_policy_hash payroll_policy_proration_method payroll_policy_fixed_days_divisor payroll_policy_rounding_mode payroll_policy_rounding_scale eligible_employee_count assigned_employee_count snapshot_employee_count captured_employee_count input_hash lock_version notes created_by updated_by created_at_utc updated_at_utc created_at updated_at

* id payroll_run_id employee_id employee_code employee_name designation attendance_employee_snapshot_id attendance_employee_row_hash scheduled_workdays present_days absent_days weekly_off_days holiday_days approved_leave_days payable_attendance_days payable_attendance_days_status total_worked_minutes approved_overtime_minutes late_count early_out_count short_hours_count attendance_exception_count salary_assignment_id salary_assignment_version structure_version_id salary_assignment_effective_from salary_assignment_effective_to reference_monthly_gross reference_monthly_ctc input_hash calculation_status gross_amount deduction_amount employer_contribution_amount net_amount created_at updated_at

* id payroll_run_employee_id component_id component_code component_name component_type source_assignment_component_id value_source calculation_method amount_value rate_value basis_code formula_expression proration_policy display_order is_required is_taxable affects_gross affects_net is_statutory input_hash calculated_amount calculation_trace_json created_at updated_at

* id payroll_run_id branch_id entity_type entity_id action_code actor_user_id request_id event_at_utc details_json created_at

* id branch_id component_code component_name component_type calculation_method basis_code default_amount default_rate formula_expression proration_policy is_taxable affects_gross affects_net is_statutory display_order is_active delete_status created_by updated_by created_at updated_at

* id payroll_salary_payment_batch_id allocation_uuid payroll_payslip_id source_payslip_uuid source_payslip_hash payroll_run_employee_id employee_id employee_code employee_name net_payable_amount paid_amount outstanding_amount payment_status allocation_hash lock_version created_at updated_at

* id payment_batch_uuid branch_id payroll_month period_start period_end payroll_run_id source_run_uuid source_run_version source_run_input_hash source_result_hash source_finalize_event_id source_payslip_count source_payslip_set_hash source_accounting_batch_id source_accounting_posting_version source_accounting_posting_hash source_accounting_native_reference_type source_accounting_native_reference_id source_accounting_native_reference_no payment_version payment_status payee_count net_payable_total paid_total outstanding_total payment_batch_hash lock_version notes created_by updated_by created_at_utc updated_at_utc completed_by completed_at_utc created_at updated_at

* id payroll_salary_payment_batch_id payroll_salary_payment_allocation_id payroll_salary_payment_transaction_id action_code details_json actor_user_id event_at_utc created_at

* id payment_transaction_uuid payroll_salary_payment_batch_id payroll_salary_payment_allocation_id payment_sequence payment_date payment_method cash_bank_ledger_id amount transaction_status instrument_type instrument_number external_reference narration native_payment_voucher_id native_payment_voucher_no native_payment_voucher_type_id native_ledger_posting_reference source_allocation_hash transaction_hash created_by posted_by created_at_utc posted_at_utc created_at updated_at

* id branch_id structure_code structure_name description is_active delete_status created_by updated_by created_at updated_at

* id structure_id version_no effective_from effective_to version_status lock_version notes created_by approved_by approved_at_utc created_at updated_at

* id structure_version_id component_id calculation_method amount_value rate_value basis_code formula_expression proration_policy display_order is_required created_at updated_at

* id plant_name plant_code address city pincode state_id country_id contact_number email is_active branch_id delete_status created_at updated_at

* id voucher_id voucher_type table_name row_data deleted_by deleted_at recovered

* id voucher_type_id ref_id ref_table posting_action message posting_time posted_by

* id voucher_type_id voucher_id posting_status posted_by posting_at

* period_start period_end is_locked locked_by locked_at

* id branch_id item_id reason created_at

* id purchase_invoice_no purchase_invoice_date voucher_number voucher_type_id entry_mode grn_ref_id purchase_order_ref_id purchase_ref_id email_scraper_invoices_id grn_status urd sales_channel sales_person_id source_quotation_id voucher_date voucher_time due_date ledger_id godown_id party_cat_id invoice_amount price after_prim_dis_price pri_discount proportionate_discount additional_discount total_discount discount_coupon_code applied_discount_category applied_discount_category_id taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status narration receiver_name receiver_contact_number branch_id user_id modified_user_id finance_year_id delete_status is_cancelled created_at updated_at round_off total_amount irn ack_no ack_date qr_code einvoice_status einvoice_error ewaybill_no ewaybill_date ewaybill_status ewaybill_error posting_status calc_add_discount_from

* id voucher_number voucher_type voucher_date due_date ledger_id voucher_type_id finance_year_id invoice_no invoice_date price total_discount applied_discount_category_id taxable_amount total_amount tax_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status narration branch_id delete_status created_at updated_at

* id purchase_entry_id godown_id item_id ledger_id hsn_sac_id uom_id quantity rate price discount_type discount_value discount_amount proportionate_discount proportionate_discount_selected_items taxable_amount proportionate_add_charges_amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage tax_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status is_cancelled created_at updated_at

* id purchase_entry_id item_id godown_id voucher_type_id hsn_sac_id uom_id quantity rate price discount_type_id discount_value discount_amount taxable_amount gst_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage gst_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status created_at updated_at

* id invoice_id discount_details total_fixed_discount total_prop_discount remarks selected_prop_discount_items_old selected_prop_discount_items delete_status created_at updated_at

* id po_number supplier_id order_date status total_amount branch_id delete_status created_at updated_at

* id purchase_order_id item_id quantity unit_price total_price po_item_status expected_date remarks delete_status modified_by created_at updated_at

* id entry_id voucher_type_id received_date receipt_note_no received_doc received_through godown_id carrier_ledger_id bill_of_lading motor_vehicle_no branch_id created_by created_at updated_at delete_status

* id item_id supplier_id branch_id company_id default_split_qty last_po_qty last_po_date priority_no is_default remarks delete_status created_by modified_by created_at updated_at

* id voucher_number voucher_type_id voucher_date ledger_id party_cat_id godown_id discounted_rate pri_discount proportionate_discount total_discount total_deduction_amount taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status posting_status narration receiver_name receiver_contact_number branch_id finance_year_id delete_status created_at user_id updated_at modified_user_id total_amount round_off ewaybill_status

* id purchase_return_id purchase_entry_id purchase_return_reason_id item_id godown_id hsn_sac_id uom_id quantity discounted_rate deduction_type deduction_value deduction_amount discounted_price proportionate_discount taxable_amount proportionate_add_charges_amount taxable_amount_with_charges taxable_unit_price gst_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage gst_amount cgst_amount sgst_amount igst_amount cess_amount deduction_reason branch_id delete_status created_at updated_at

* id purchase_return_id purchase_entry_id purchase_entry_item_id item_id branch_id return_quantity unit_price_discounted return_amount return_reason_id remarks delete_status created_at updated_at

* id voucher_number voucher_date ledger_id total_return_qty total_return_amount branch_id return_status approved_by created_by delete_status created_at updated_at

* id payment_id generated_time expires_at payment_status paid_time status_updated_time payment_link bank_reference user_id username

* id payment_id received_time callback_status bank_reference source_ip raw_payload

* id voucher_number voucher_type_id sales_channel sales_person_id source_quotation_id voucher_date voucher_time due_date ledger_id party_cat_id invoice_amount price pri_discount proportionate_discount total_discount discount_coupon_code applied_discount_category applied_discount_category_id taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status narration additional_discount_remarks discount_details receiver_name receiver_contact_number branch_id user_id finance_year_id delete_status created_at updated_at round_off total_amount irn ack_no ack_date qr_code einvoice_status einvoice_error ewaybill_no ewaybill_date ewaybill_status ewaybill_error posting_status

* id sales_entry_id godown_id item_id hsn_sac_id uom_id quantity rate price discount_type discount_source_id discount_value discount_amount proportionate_discount taxable_amount proportionate_add_charges_amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage tax_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status created_at updated_at

* id receipt_transaction_id sales_entry_id allocated_amount created_at updated_at

* id voucher_type_id cash_or_bank voucher_no voucher_date ledger_id ledger_account_id instrument_type instrument_number bank_name amount tds_amount branch_id user_id finance_year_id reference_type_id advance_reference_id narration delete_status is_cancelled created_by modified_by created_at updated_at

* id receipt_voucher_id voucher_type_id invoice_id advance_voucher_type_id advance_invoice_id allocated_amount remarks delete_status is_cancelled created_at updated_at

* id entry_type entry_id ledger_id transaction_date voucher_number narration debit_amount credit_amount branch_id item_id hsn_code gst_percentage stock_qty stock_value created_at updated_at

* id voucher_type_id voucher_id voucher_number cancelled_date cancelled_reason cancelled_by added_at

* id voucher_number voucher_type_id entry_mode entry_status source_sales_id source_proforma_id source_quotation_id source_delivery_note_id source_sales_order_id source_subsidy_id delivery_note_type sales_channel sales_person_id voucher_date confirm_decline_date voucher_time due_date ledger_id order_no party_cat_id godown_id other_deduction invoice_amount_deleted price after_prim_dis_price subsidy_scheme_id subsidy_scheme_discount pri_discount proportionate_discount additional_discount other_proportionate_discount total_discount discount_coupon_code applied_discount_category applied_discount_category_id subsidy_diff_amt taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount round_off total_amount payment_status narration additional_discount_remarks discount_details receiver_name receiver_contact_number branch_id user_id modified_user_id finance_year_id delete_status is_cancelled created_at updated_at einvoice_status ewaybill_status posting_status decline_reason confirm_reason calc_add_discount_from

* id sales_entry_id godown_id subsidy_scheme_id subsidy_billed other_discount_applicable item_id ledger_id hsn_sac_id uom_id requested_qty quantity mrp rc_rate is_rate_edit_applicable rate price discount_type discount_source_id discount_value discount_amount proportionate_discount proportionate_discount_selected_items proportionate_other_discount taxable_amount proportionate_add_charges_amount taxable_amount_with_charges taxable_unit_price tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage tax_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status is_cancelled created_at updated_at

* id invoice_id exchange_id exchange_item_age exchange_value exchange_company_name discount_coupon_code credit_note_discount_type credit_note_discount_value credit_note_details selected_prop_credit_note_items discount_details total_fixed_discount total_prop_discount remarks selected_prop_discount_items_old selected_prop_discount_items delete_status created_at updated_at

* id discount_id old_item_id machine_name list_price exchange_value remarks

* id discount_id discount_type amount reason

* id invoice_id scheme_id scheme_document_id document_name document_verified remarks branch_id created_by modified_by created_at updated_at

* sales_entry_id recipient status message_id error_message pdf_bytes updated_at

* sales_entry_id branch_id recipient updated_at

* sales_entry_id recipient status message_id error_message updated_at

* id voucher_number voucher_type_id voucher_date ledger_id party_cat_id godown_id discounted_rate pri_discount proportionate_discount total_discount total_deduction_amount taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status return_status narration receiver_name receiver_contact_number branch_id finance_year_id delete_status created_at user_id modified_user_id updated_at round_off total_amount posting_status einvoice_status ewaybill_status

* id sales_return_id sales_entry_id sales_voucher_no sales_return_reason_id item_id godown_id hsn_sac_id uom_id quantity billed_rate billed_qty discounted_rate deduction_type deduction_value deduction_amount discounted_price proportionate_discount taxable_amount proportionate_add_charges_amount taxable_amount_with_charges taxable_unit_price gst_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage gst_amount cgst_amount sgst_amount igst_amount cess_amount deduction_reason branch_id delete_status created_at updated_at

* id reason_title description is_active created_at updated_at

* id branch_id price_base discount_base additional_discount_enabled enable_scheme_discount allow_negative_stock default_payment_mode default_terms_days round_off_method invoice_prefix invoice_start_number delete_status created_at updated_at

* id finance_year_id branch_id target_amount

* id delete_status created_at updated_at

* id ip_address description is_active created_at

* id branch_name branch_code address city pincode state_id country_id contact_number email gstin website logo dark_logo light_logo is_main_branch delete_status created_at updated_at

* id country_name short_name is_default branch_id delete_status created_at updated_at

* id state_id district_name short_name delete_status branch_id is_default created_at updated_at

* id main_menu display_name url icon sequence is_voucher_entry voucher_entry_order is_report delete_status created_at updated_at

* id main_menu display_name url icon sequence is_voucher_entry voucher_entry_order is_report delete_status created_at updated_at

* id state_name short_name delete_status is_default branch_id created_at updated_at

* id sub_menu display_name mmenu_id is_master master_order is_list list_order is_voucher_entry voucher_entry_order is_report url entry_url sequence search_sequence delete_status created_at updated_at

* id sub_menu display_name mmenu_id is_master master_order is_list list_order is_voucher_entry voucher_entry_order is_report url entry_url sequence search_sequence delete_status created_at updated_at

* id sub_menu display_name mmenu_id is_master master_order is_list list_order is_voucher_entry voucher_entry_order is_report url entry_url sequence search_sequence delete_status created_at updated_at

* id voucher_type_id voucher_no from_branch to_branch from_godown to_godown whatsapp_no movement_date transfer_qty price remarks branch_id finance_year_id posting_status ewaybill_status delete_status created_by modified_by created_at modified_at

* id stock_movement_id item_id hsn_sac_id uom_id quantity rate price branch_id delete_status created_at updated_at

* id request_no branch_id finance_year_id delivery_branch status remarks created_by approved_by approved_at created_at updated_at

* id request_id item_id available_qty reorder_qty required_qty suggested_qty priority reason created_by created_at updated_at

* id company_id branch_id reorder_run_id reorder_item_id item_id vendor_ledger_id required_qty allocated_qty rate discount_percent tax_percent base_amount discount_amount tax_amount net_amount allocation_type allocation_reason priority_rank source_rate_id source_mapping_id po_created_status purchase_order_id status is_active delete_status created_by updated_by created_at updated_at

* id item_id vendor_ledger_id branch_id rate available_qty lead_days priority_rank remarks last_confirmed_at is_active created_by created_at updated_at

* id voucher_type_id cash_or_bank voucher_no voucher_date ledger_id ledger_account_id instrument_type instrument_number bank_name amount tds_amount branch_id user_id finance_year_id reference_type_id advance_reference_id narration delete_status created_by modified_by created_at updated_at

* id receipt_voucher_id voucher_type_id invoice_id advance_voucher_type_id advance_invoice_id allocated_amount remarks delete_status created_at updated_at

* id scheme_name scheme_code active_status is_delete created_by created_at modified_by modified_at

* id scheme_id sales_entries_id application_name_eng application_name_kan address_phone_eng address_phone_kan social_category_eng social_category_kan landholding_category_eng landholding_category_kan land_address_eng land_address_kan survey_extent_eng survey_extent_kan horticulture_crop_details_eng horticulture_crop_details_kan rtc_details_eng rtc_details_kan rtc_applicant_name_present rtc_applicant_name_present_kan rtc_horticulture_crop_mentioned rtc_horticulture_crop_mentioned_kan rtc_crop_extent_eng rtc_crop_extent_kan machine_name_technical_details_eng machine_name_technical_details_kan purchased_from_eng purchased_from_kan purchase_details_eng purchase_details_kan usage_of_equipment_eng usage_of_equipment_kan total_price total_price_kan requested_subsidy_amount requested_subsidy_amount_kan social_category_other_eng social_category_other_kan landholding_category_other_eng landholding_category_other_kan created_at modified_at

* id scheme_id doc_code doc_name is_mandatory sequence_no notes branch_id is_active delete_status created_at updated_at

* id scheme_id caste_category_id gender subsidy_type subsidy_value cap_amount active_status is_delete created_at created_by modified_at modified_by

* id subsidy_scheme_id item_id is_active created_at created_by modified_at modified_by

* id subsidy_scheme_items_id rc_rate tax_percentage rc_rate_include_tax quantity eligible effective_from effective_to delete_status created_at updated_at

* id item_id sub_item_id branch_id in_qty out_qty uom_id item_value active from_date to_date created_at updated_at

* raw_row_id import_batch_id voucher_table voucher_id voucher_no created_at

* id import_batch_id raw_row_id issue_code details created_at

* import_batch_id sheet_name header_row_no h1 h2 h3 h4 h5 h6 h7 h8 h9 h10 created_at

* id import_batch_id sheet_name row_in_sheet c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 created_at

* id import_batch_id raw_row_id txn_date particulars instrument_text vch_type voucher_type_id vch_no debit_amount credit_amount ledger_id correspondent_ledger_id is_ledger is_main_ledger is_main is_correspondent is_others txn_date_forwardfill vch_type_forwardfill vch_no_forwardfill main_ledger_name_ff main_ledger_id_ff is_pair_head is_item item_id item_qty rate_per_item item_uom item_name_key ledger_type created_at

* id ledger_id voucher_type voucher_number voucher_date delete_status type amount narration branch_id created_at updated_at

* id vendor_id ledger_id section_code finance_year_id cumulative_amount created_at updated_at

* id voucher_id voucher_type ledger_id vendor_id section_code amount narration finance_year_id branch_id voucher_date created_at delete_status deleted_by deleted_at

* id section_code description applicable_on rate_percent threshold_per_txn threshold_annual resident_only is_active created_at updated_at

* id agent_id agent_number customer_number caller_id source_module custom_identifier smartflo_uuid status hangup_cause duration_sec recording_url raw_request raw_response raw_webhook created_at updated_at

* id call_id event_type event_time payload_json

* menu_family source_table record_id display_name old_order

* id voucher_type_id transaction_id ledger_id amount description hsn_code_id tax_percentage sgst_percentage cgst_percentage igst_percentage cess_percentage tax_amt sgst_amt cgst_amt igst_amt cess_amt is_proportionate branch_id delete_status created_at updated_at

* id module operation_mode target_transaction_id voucher_type_id client_draft_uuid idempotency_key branch_id finance_year_id user_id status revision base_transaction_version base_transaction_hash base_transaction_updated_at header_data summary_data posted_transaction_id commit_mode created_at updated_at last_sync_at frozen_at discarded_at posted_at

* id draft_id component_key component_data revision created_at updated_at

* id draft_id row_uuid item_id row_data display_order is_deleted created_at updated_at

* id title description account_group_id active_status delete_status created_at updated_at

* id voucher_no voucher_date ledger_id ledger_account_id amount gst_amount is_gst_applicable expenditure_category_id branch_id instrument_type instrument_number narration delete_status created_at updated_at expense_date expense_type

* id module idempotency_key request_hash branch_id finance_year_id user_id status transaction_id voucher_type_id voucher_number response_data created_at updated_at completed_at

* id voucher_type_id voucher_no voucher_date ledger_id ledger_account_id instrument_type instrument_number amount expense_head gst branch_id user_id narration delete_status created_at updated_at payment_date created_by modified_by finance_year_id bank_name reference_id reference

* id voucher_no voucher_date ledger_id ledger_account_id instrument_type instrument_number amount tds_amount branch_id narration delete_status created_at updated_at received_date user_id finance_year_id bank_name reference_id

* id draft_id module event_type branch_id finance_year_id user_id client_draft_uuid idempotency_key metadata created_at

* id rule_name rule_scope operator value target_id customer_segment_id coupon_code min_qty min_amount valid_from valid_to priority combine_method is_active branch_id delete_status created_at updated_at

* id user_code name username password email mobile role_id branch_id ledger_id status last_login created_by created_at updated_at delete_status

* id user_id branch_id is_active is_default delete_status created_at updated_at

* id user_email username password_hash role_id emp_id ledger_id default_branch_id financial_year_id signature call_followup sales_print_documents delete_status created_at updated_at

* id user_id submenu_id is_voucher_entry sort_order created_at updated_at

* id user_id financial_year_id is_active delete_status created_at updated_at

* id role_id menu_id submenu_id can_add can_edit can_delete can_view branch_id delete_status created_at updated_at

* id role_name dashboard_link dashboard_link_lock_screen is_super_admin branch_id delete_status created_at updated_at

* id applies_to ledger_id tax_proportionate_flag tax_percentage_override_del hsn_sac_code_del remarks branch_id created_at updated_at

* id voucher_type_id financial_year_id branch_id starting_number number_width prefix_zero restart_periodicity restart_applicable_from restart_number prefix_applicable_from prefix_text suffix_applicable_from suffix_text created_at updated_at

* id voucher_code branch_id financial_year_id prefix suffix current_number reset_frequency number_padding

* id voucher_type branch_id financial_year_id prefix suffix current_number

* id voucher_type voucher_id tax_code tax_name tax_rate tax_amount ledger_id branch_id created_at updated_at taxable_value charge_type additional_charge_id

* id voucher_code title abbreviation primary_voucher is_optional is_primary_voucher is_posting is_default update_item_transaction allow_narration auto_print_on_save auto_whatsapp_on_save entry_side is_active is_delete sort_order primary_voucher_type_id invoice_bank_id created_at updated_at

* id code title abbreviation voucher_mode numbering_method retain_original_number is_optional allow_narration track_additional_costs auto_print_on_save auto_whatsapp_on_save nature is_custom is_active sort_order primary_voucher_type_id created_at updated_at

* id voucher_type_id branch_id finance_year_id voucher_type ledger_id ledger_key_id is_tds_applicable narration_template remarks voucher_flow_type sort_order entry_side is_default is_group_ledger delete_status created_at updated_at

* id provider api_url api_key auth_token sender_number is_active branch_id created_at updated_at