2025-06-24 00:38:43,873 WARNING database DDL Query made to DB: create table `tabDunning Letter Text` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `language` varchar(140), `is_default_language` int(1) not null default 0, `body_text` longtext, `closing_text` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,146 WARNING database DDL Query made to DB: create table `tabSales Invoice` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) default '{customer_name}', `naming_series` varchar(140), `customer` varchar(140), `customer_name` text, `tax_id` varchar(140), `company` varchar(140), `company_tax_id` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `due_date` date, `is_pos` int(1) not null default 0, `pos_profile` varchar(140), `is_consolidated` int(1) not null default 0, `is_return` int(1) not null default 0, `return_against` varchar(140), `update_outstanding_for_self` int(1) not null default 1, `update_billed_amount_in_sales_order` int(1) not null default 0, `update_billed_amount_in_delivery_note` int(1) not null default 1, `is_debit_note` int(1) not null default 0, `amended_from` varchar(140), `cost_center` varchar(140), `project` varchar(140), `currency` varchar(140), `conversion_rate` decimal(21,9) not null default 0, `selling_price_list` varchar(140), `price_list_currency` varchar(140), `plc_conversion_rate` decimal(21,9) not null default 0, `ignore_pricing_rule` int(1) not null default 0, `scan_barcode` varchar(140), `update_stock` int(1) not null default 0, `set_warehouse` varchar(140), `set_target_warehouse` varchar(140), `total_qty` decimal(21,9) not null default 0, `total_net_weight` decimal(21,9) not null default 0, `base_total` decimal(21,9) not null default 0, `base_net_total` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `net_total` decimal(21,9) not null default 0, `tax_category` varchar(140), `taxes_and_charges` varchar(140), `shipping_rule` varchar(140), `incoterm` varchar(140), `named_place` varchar(140), `base_total_taxes_and_charges` decimal(21,9) not null default 0, `total_taxes_and_charges` decimal(21,9) not null default 0, `base_grand_total` decimal(21,9) not null default 0, `base_rounding_adjustment` decimal(21,9) not null default 0, `base_rounded_total` decimal(21,9) not null default 0, `base_in_words` text, `grand_total` decimal(21,9) not null default 0, `rounding_adjustment` decimal(21,9) not null default 0, `use_company_roundoff_cost_center` int(1) not null default 0, `rounded_total` decimal(21,9) not null default 0, `in_words` text, `total_advance` decimal(21,9) not null default 0, `outstanding_amount` decimal(21,9) not null default 0, `disable_rounded_total` int(1) not null default 0, `apply_discount_on` varchar(15) default 'Grand Total', `base_discount_amount` decimal(21,9) not null default 0, `is_cash_or_non_trade_discount` int(1) not null default 0, `additional_discount_account` varchar(140), `additional_discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `other_charges_calculation` longtext, `total_billing_hours` decimal(21,9) not null default 0, `total_billing_amount` decimal(21,9) not null default 0, `cash_bank_account` varchar(140), `base_paid_amount` decimal(21,9) not null default 0, `paid_amount` decimal(21,9) not null default 0, `base_change_amount` decimal(21,9) not null default 0, `change_amount` decimal(21,9) not null default 0, `account_for_change_amount` varchar(140), `allocate_advances_automatically` int(1) not null default 0, `only_include_allocated_payments` int(1) not null default 0, `write_off_amount` decimal(21,9) not null default 0, `base_write_off_amount` decimal(21,9) not null default 0, `write_off_outstanding_amount_automatically` int(1) not null default 0, `write_off_account` varchar(140), `write_off_cost_center` varchar(140), `redeem_loyalty_points` int(1) not null default 0, `loyalty_points` int(11) not null default 0, `loyalty_amount` decimal(21,9) not null default 0, `loyalty_program` varchar(140), `loyalty_redemption_account` varchar(140), `loyalty_redemption_cost_center` varchar(140), `customer_address` varchar(140), `address_display` text, `contact_person` varchar(140), `contact_display` text, `contact_mobile` text, `contact_email` varchar(140), `territory` varchar(140), `shipping_address_name` varchar(140), `shipping_address` text, `dispatch_address_name` varchar(140), `dispatch_address` text, `company_address` varchar(140), `company_address_display` text, `company_contact_person` varchar(140), `ignore_default_payment_terms_template` int(1) not null default 0, `payment_terms_template` varchar(140), `tc_name` varchar(140), `terms` longtext, `po_no` varchar(140), `po_date` date, `debit_to` varchar(140), `party_account_currency` varchar(140), `is_opening` varchar(4) default 'No', `unrealized_profit_loss_account` varchar(140), `against_income_account` text, `sales_partner` varchar(140), `amount_eligible_for_commission` decimal(21,9) not null default 0, `commission_rate` decimal(21,9) not null default 0, `total_commission` decimal(21,9) not null default 0, `letter_head` varchar(140), `group_same_items` int(1) not null default 0, `select_print_heading` varchar(140), `language` varchar(6), `subscription` varchar(140), `from_date` date, `auto_repeat` varchar(140), `to_date` date, `status` varchar(30) default 'Draft', `inter_company_invoice_reference` varchar(140), `campaign` varchar(140), `represents_company` varchar(140), `source` varchar(140), `customer_group` varchar(140), `is_internal_customer` int(1) not null default 0, `is_discounted` int(1) not null default 0, `remarks` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index `customer`(`customer`), index `posting_date`(`posting_date`), index `return_against`(`return_against`), index `project`(`project`), index `debit_to`(`debit_to`), index `inter_company_invoice_reference`(`inter_company_invoice_reference`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,344 WARNING database DDL Query made to DB: create table `tabJournal Entry` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `is_system_generated` int(1) not null default 0, `title` varchar(140), `voucher_type` varchar(140) default 'Journal Entry', `naming_series` varchar(140), `finance_book` varchar(140), `process_deferred_accounting` varchar(140), `reversal_of` varchar(140), `tax_withholding_category` varchar(140), `from_template` varchar(140), `company` varchar(140), `posting_date` date, `apply_tds` int(1) not null default 0, `cheque_no` varchar(140), `cheque_date` date, `user_remark` text, `total_debit` decimal(21,9) not null default 0, `total_credit` decimal(21,9) not null default 0, `difference` decimal(21,9) not null default 0, `multi_currency` int(1) not null default 0, `total_amount_currency` varchar(140), `total_amount` decimal(21,9) not null default 0, `total_amount_in_words` varchar(140), `clearance_date` date, `remark` text, `paid_loan` varchar(140), `inter_company_journal_entry_reference` varchar(140), `bill_no` varchar(140), `bill_date` date, `due_date` date, `write_off_based_on` varchar(140) default 'Accounts Receivable', `write_off_amount` decimal(21,9) not null default 0, `pay_to_recd_from` varchar(140), `letter_head` varchar(140), `select_print_heading` varchar(140), `mode_of_payment` varchar(140), `payment_order` varchar(140), `is_opening` varchar(140) default 'No', `stock_entry` varchar(140), `auto_repeat` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `voucher_type`(`voucher_type`), index `company`(`company`), index `posting_date`(`posting_date`), index `cheque_no`(`cheque_no`), index `cheque_date`(`cheque_date`), index `clearance_date`(`clearance_date`), index `is_opening`(`is_opening`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,408 WARNING database DDL Query made to DB: create table `tabCashier Closing Payments` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `mode_of_payment` varchar(140), `amount` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,470 WARNING database DDL Query made to DB: create table `tabSales Taxes and Charges Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `is_default` int(1) not null default 0, `disabled` int(1) not null default 0, `company` varchar(140), `tax_category` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,570 WARNING database DDL Query made to DB: create table `tabJournal Entry Account` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `account` varchar(140), `account_type` varchar(140), `bank_account` varchar(140), `party_type` varchar(140), `party` varchar(140), `cost_center` varchar(140), `project` varchar(140), `account_currency` varchar(140), `exchange_rate` decimal(21,9) not null default 0, `debit_in_account_currency` decimal(21,9) not null default 0, `debit` decimal(21,9) not null default 0, `credit_in_account_currency` decimal(21,9) not null default 0, `credit` decimal(21,9) not null default 0, `reference_type` varchar(140), `reference_name` varchar(140), `reference_due_date` date, `reference_detail_no` varchar(140), `is_advance` varchar(140), `user_remark` text, `against_account` text, index `account`(`account`), index `party_type`(`party_type`), index `reference_type`(`reference_type`), index `reference_name`(`reference_name`), index `reference_detail_no`(`reference_detail_no`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,640 WARNING database DDL Query made to DB: create table `tabExchange Rate Revaluation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `posting_date` date, `rounding_loss_allowance` decimal(21,9) not null default 0.05, `company` varchar(140), `gain_loss_unbooked` decimal(21,9) not null default 0, `gain_loss_booked` decimal(21,9) not null default 0, `total_gain_loss` decimal(21,9) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,742 WARNING database DDL Query made to DB: create table `tabCheque Print Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `has_print_format` int(1) not null default 0, `bank_name` varchar(140), `cheque_size` varchar(140) default 'Regular', `starting_position_from_top_edge` decimal(21,9) not null default 0, `cheque_width` decimal(21,9) not null default 20.0, `cheque_height` decimal(21,9) not null default 9.0, `scanned_cheque` text, `is_account_payable` int(1) not null default 1, `acc_pay_dist_from_top_edge` decimal(21,9) not null default 1.0, `acc_pay_dist_from_left_edge` decimal(21,9) not null default 9.0, `message_to_show` varchar(140) default 'Acc. Payee', `date_dist_from_top_edge` decimal(21,9) not null default 1.0, `date_dist_from_left_edge` decimal(21,9) not null default 15.0, `payer_name_from_top_edge` decimal(21,9) not null default 2.0, `payer_name_from_left_edge` decimal(21,9) not null default 3.0, `amt_in_words_from_top_edge` decimal(21,9) not null default 3.0, `amt_in_words_from_left_edge` decimal(21,9) not null default 4.0, `amt_in_word_width` decimal(21,9) not null default 15.0, `amt_in_words_line_spacing` decimal(21,9) not null default 0.5, `amt_in_figures_from_top_edge` decimal(21,9) not null default 3.5, `amt_in_figures_from_left_edge` decimal(21,9) not null default 16.0, `acc_no_dist_from_top_edge` decimal(21,9) not null default 5.0, `acc_no_dist_from_left_edge` decimal(21,9) not null default 4.0, `signatory_from_top_edge` decimal(21,9) not null default 6.0, `signatory_from_left_edge` decimal(21,9) not null default 15.0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,824 WARNING database DDL Query made to DB: create table `tabAdvance Payment Ledger Entry` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `voucher_type` varchar(140), `voucher_no` varchar(140), `against_voucher_type` varchar(140), `against_voucher_no` varchar(140), `amount` decimal(21,9) not null default 0, `currency` varchar(140), `event` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,887 WARNING database DDL Query made to DB: create table `tabFiscal Year Company` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:44,963 WARNING database DDL Query made to DB: create table `tabPromotional Scheme Price Discount` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `disable` int(1) not null default 0, `apply_multiple_pricing_rules` int(1) not null default 0, `rule_description` text, `min_qty` decimal(21,9) not null default 0, `max_qty` decimal(21,9) not null default 0, `min_amount` decimal(21,9) not null default 0, `max_amount` decimal(21,9) not null default 0, `rate_or_discount` varchar(140) default 'Discount Percentage', `rate` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `discount_percentage` decimal(21,9) not null default 0, `for_price_list` varchar(140), `warehouse` varchar(140), `threshold_percentage` decimal(21,9) not null default 0, `validate_applied_rule` int(1) not null default 0, `priority` varchar(140), `apply_discount_on_rate` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,020 WARNING database DDL Query made to DB: create table `tabAllowed To Transact With` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,112 WARNING database DDL Query made to DB: create table `tabBank Transaction Payments` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `payment_document` varchar(140), `payment_entry` varchar(140), `allocated_amount` decimal(21,9) not null default 0, `clearance_date` date, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,192 WARNING database DDL Query made to DB: create table `tabShareholder` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `naming_series` varchar(140), `folio_no` varchar(140) unique, `company` varchar(140), `is_company` int(1) not null default 0, `contact_list` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,265 WARNING database DDL Query made to DB: create table `tabPricing Rule Brand` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `brand` varchar(140), `uom` varchar(140), index `brand`(`brand`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,341 WARNING database DDL Query made to DB: create table `tabPOS Opening Entry` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `period_start_date` datetime(6), `period_end_date` date, `status` varchar(140) default 'Draft', `posting_date` date, `set_posting_date` int(1) not null default 0, `company` varchar(140), `pos_profile` varchar(140), `pos_closing_entry` varchar(140), `user` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,403 WARNING database DDL Query made to DB: create table `tabTax Withheld Vouchers` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `voucher_type` varchar(140), `voucher_name` varchar(140), `taxable_amount` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,483 WARNING database DDL Query made to DB: create table `tabSales Taxes and Charges` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `charge_type` varchar(140), `row_id` varchar(140), `account_head` varchar(140), `description` text, `included_in_print_rate` int(1) not null default 0, `included_in_paid_amount` int(1) not null default 0, `cost_center` varchar(140), `rate` decimal(21,9) not null default 0, `account_currency` varchar(140), `tax_amount` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `tax_amount_after_discount_amount` decimal(21,9) not null default 0, `base_tax_amount` decimal(21,9) not null default 0, `base_total` decimal(21,9) not null default 0, `base_tax_amount_after_discount_amount` decimal(21,9) not null default 0, `item_wise_tax_detail` longtext, `dont_recompute_tax` int(1) not null default 0, index `account_head`(`account_head`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,545 WARNING database DDL Query made to DB: create table `tabSubscription Plan Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `plan` varchar(140), `qty` int(11) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,612 WARNING database DDL Query made to DB: create table `tabJournal Entry Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `template_title` varchar(140) unique, `voucher_type` varchar(140), `naming_series` varchar(140), `company` varchar(140), `is_opening` varchar(140) default 'No', `multi_currency` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,686 WARNING database DDL Query made to DB: create table `tabTax Withholding Rate` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `from_date` date, `to_date` date, `tax_withholding_rate` decimal(21,9) not null default 0, `single_threshold` decimal(21,9) not null default 0, `cumulative_threshold` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,766 WARNING database DDL Query made to DB: create table `tabShare Transfer` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `transfer_type` varchar(140), `date` date, `from_shareholder` varchar(140), `from_folio_no` varchar(140), `to_shareholder` varchar(140), `to_folio_no` varchar(140), `equity_or_liability_account` varchar(140), `asset_account` varchar(140), `share_type` varchar(140), `from_no` int(11) not null default 0, `rate` decimal(21,9) not null default 0, `no_of_shares` int(11) not null default 0, `to_no` int(11) not null default 0, `amount` decimal(21,9) not null default 0, `company` varchar(140), `remarks` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,848 WARNING database DDL Query made to DB: create table `tabOverdue Payment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `sales_invoice` varchar(140), `payment_schedule` varchar(140), `dunning_level` int(11) not null default 1, `payment_term` varchar(140), `description` text, `due_date` date, `overdue_days` varchar(140), `mode_of_payment` varchar(140), `invoice_portion` decimal(21,9) not null default 0, `payment_amount` decimal(21,9) not null default 0, `outstanding` decimal(21,9) not null default 0, `paid_amount` decimal(21,9) not null default 0, `discounted_amount` decimal(21,9) not null default 0, `interest` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,906 WARNING database DDL Query made to DB: create table `tabPOS Payment Method` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `default` int(1) not null default 0, `allow_in_returns` int(1) not null default 0, `mode_of_payment` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:45,970 WARNING database DDL Query made to DB: create table `tabBank Clearance Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `payment_document` varchar(140), `payment_entry` varchar(140), `against_account` varchar(140), `amount` varchar(140), `posting_date` date, `cheque_number` varchar(140), `cheque_date` date, `clearance_date` date, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,040 WARNING database DDL Query made to DB: create table `tabPayment Gateway Account` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `payment_gateway` varchar(140), `payment_channel` varchar(140) default 'Email', `is_default` int(1) not null default 0, `payment_account` varchar(140), `currency` varchar(140), `message` text default 'Please click on the link below to make your payment', `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,098 WARNING database DDL Query made to DB: create table `tabApplicable On Account` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `applicable_on_account` varchar(140), `is_mandatory` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,183 WARNING database DDL Query made to DB: create table `tabTax Rule` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `tax_type` varchar(140) default 'Sales', `use_for_shopping_cart` int(1) not null default 1, `sales_tax_template` varchar(140), `purchase_tax_template` varchar(140), `customer` varchar(140), `supplier` varchar(140), `item` varchar(140), `billing_city` varchar(140), `billing_county` varchar(140), `billing_state` varchar(140), `billing_zipcode` varchar(140), `billing_country` varchar(140), `tax_category` varchar(140), `customer_group` varchar(140), `supplier_group` varchar(140), `item_group` varchar(140), `shipping_city` varchar(140), `shipping_county` varchar(140), `shipping_state` varchar(140), `shipping_zipcode` varchar(140), `shipping_country` varchar(140), `from_date` date, `to_date` date, `priority` int(11) not null default 1, `company` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,280 WARNING database DDL Query made to DB: create table `tabPromotional Scheme` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `apply_on` varchar(140) default 'Item Code', `disable` int(1) not null default 0, `mixed_conditions` int(1) not null default 0, `is_cumulative` int(1) not null default 0, `apply_rule_on_other` varchar(140), `other_item_code` varchar(140), `other_item_group` varchar(140), `other_brand` varchar(140), `selling` int(1) not null default 0, `buying` int(1) not null default 0, `applicable_for` varchar(140), `valid_from` date, `valid_upto` date, `company` varchar(140), `currency` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,386 WARNING database DDL Query made to DB: create table `tabSubscription` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `party_type` varchar(140), `party` varchar(140), `company` varchar(140), `status` varchar(140), `start_date` date, `end_date` date, `cancelation_date` date, `trial_period_start` date, `trial_period_end` date, `follow_calendar_months` int(1) not null default 0, `generate_new_invoices_past_due_date` int(1) not null default 0, `submit_invoice` int(1) not null default 1, `current_invoice_start` date, `current_invoice_end` date, `days_until_due` int(11) not null default 0, `generate_invoice_at` varchar(140) default 'End of the current subscription period', `number_of_days` int(11) not null default 0, `cancel_at_period_end` int(1) not null default 0, `sales_tax_template` varchar(140), `purchase_tax_template` varchar(140), `apply_additional_discount` varchar(140), `additional_discount_percentage` decimal(21,9) not null default 0, `additional_discount_amount` decimal(21,9) not null default 0, `cost_center` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,451 WARNING database DDL Query made to DB: create table `tabCurrency Exchange Settings Result` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `key` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,519 WARNING database DDL Query made to DB: create table `tabDiscounted Invoice` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `sales_invoice` varchar(140), `customer` varchar(140), `posting_date` date, `outstanding_amount` decimal(21,9) not null default 0, `debit_to` varchar(140), index `sales_invoice`(`sales_invoice`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,576 WARNING database DDL Query made to DB: create table `tabPOS Profile User` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `default` int(1) not null default 0, `user` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,634 WARNING database DDL Query made to DB: create table `tabTax Withholding Account` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `account` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,711 WARNING database DDL Query made to DB: create table `tabPayment Entry Reference` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `reference_doctype` varchar(140), `reference_name` varchar(140), `due_date` date, `bill_no` varchar(140), `payment_term` varchar(140), `payment_term_outstanding` decimal(21,9) not null default 0, `account_type` varchar(140), `payment_type` varchar(140), `reconcile_effect_on` date, `total_amount` decimal(21,9) not null default 0, `outstanding_amount` decimal(21,9) not null default 0, `allocated_amount` decimal(21,9) not null default 0, `exchange_rate` decimal(21,9) not null default 0, `exchange_gain_loss` decimal(21,9) not null default 0, `account` varchar(140), `payment_request` varchar(140), index `reference_doctype`(`reference_doctype`), index `reference_name`(`reference_name`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,776 WARNING database DDL Query made to DB: create table `tabSales Invoice Payment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `default` int(1) not null default 0, `mode_of_payment` varchar(140), `amount` decimal(21,9) not null default 0, `reference_no` varchar(140), `account` varchar(140), `type` varchar(140), `base_amount` decimal(21,9) not null default 0, `clearance_date` date, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,835 WARNING database DDL Query made to DB: create table `tabCost Center Allocation Percentage` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `cost_center` varchar(140), `percentage` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,936 WARNING database DDL Query made to DB: create table `tabPayment Ledger Entry` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `posting_date` date, `company` varchar(140), `account_type` varchar(140), `account` varchar(140), `party_type` varchar(140), `party` varchar(140), `due_date` date, `voucher_detail_no` varchar(140), `cost_center` varchar(140), `finance_book` varchar(140), `voucher_type` varchar(140), `voucher_no` varchar(140), `against_voucher_type` varchar(140), `against_voucher_no` varchar(140), `amount` decimal(21,9) not null default 0, `account_currency` varchar(140), `amount_in_account_currency` decimal(21,9) not null default 0, `delinked` int(1) not null default 0, `remarks` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `posting_date`(`posting_date`), index `company`(`company`), index `account`(`account`), index `party_type`(`party_type`), index `party`(`party`), index `voucher_detail_no`(`voucher_detail_no`), index `voucher_type`(`voucher_type`), index `voucher_no`(`voucher_no`), index `against_voucher_type`(`against_voucher_type`), index `against_voucher_no`(`against_voucher_no`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:46,986 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Ledger Entry` ADD INDEX IF NOT EXISTS `against_voucher_no_against_voucher_type_index`(against_voucher_no, against_voucher_type) 2025-06-24 00:38:47,009 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Ledger Entry` ADD INDEX IF NOT EXISTS `voucher_no_voucher_type_index`(voucher_no, voucher_type) 2025-06-24 00:38:47,053 WARNING database DDL Query made to DB: create sequence if not exists bisect_nodes_id_seq nocache nocycle 2025-06-24 00:38:47,066 WARNING database DDL Query made to DB: create table `tabBisect Nodes` ( name bigint primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `root` varchar(140), `left_child` varchar(140), `right_child` varchar(140), `period_from_date` datetime(6), `period_to_date` datetime(6), `difference` decimal(21,9) not null default 0, `balance_sheet_summary` decimal(21,9) not null default 0, `profit_loss_summary` decimal(21,9) not null default 0, `generated` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,123 WARNING database DDL Query made to DB: create table `tabPOS Customer Group` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `customer_group` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,190 WARNING database DDL Query made to DB: create table `tabPeriod Closing Voucher` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `transaction_date` date, `company` varchar(140), `fiscal_year` varchar(140), `period_start_date` date, `period_end_date` date, `amended_from` varchar(140), `closing_account_head` varchar(140), `gle_processing_status` varchar(140), `remarks` text, `error_message` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,260 WARNING database DDL Query made to DB: create table `tabPayment Terms Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `template_name` varchar(140) unique, `allocate_payment_based_on_payment_terms` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,331 WARNING database DDL Query made to DB: create table `tabRepost Allowed Types` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `document_type` varchar(140), `allowed` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,387 WARNING database DDL Query made to DB: create table `tabSales Partner Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `sales_partner` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,451 WARNING database DDL Query made to DB: create table `tabRepost Accounting Ledger` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `delete_cancelled_entries` int(1) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,521 WARNING database DDL Query made to DB: create table `tabProcess Payment Reconciliation Log` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `process_pr` varchar(140), `status` varchar(140), `allocated` int(1) not null default 0, `reconciled` int(1) not null default 0, `total_allocations` int(11) not null default 0, `reconciled_entries` int(11) not null default 0, `error_log` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,594 WARNING database DDL Query made to DB: create table `tabSales Invoice Advance` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `reference_type` varchar(140), `reference_name` varchar(140), `remarks` text, `reference_row` varchar(140), `advance_amount` decimal(21,9) not null default 0, `allocated_amount` decimal(21,9) not null default 0, `exchange_gain_loss` decimal(21,9) not null default 0, `ref_exchange_rate` decimal(21,9) not null default 0, `difference_posting_date` date, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,665 WARNING database DDL Query made to DB: create table `tabCashier Closing` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140) default 'POS-CLO-', `user` varchar(140), `date` date, `from_time` time(6), `time` time(6), `expense` decimal(21,9) not null default 0, `custody` decimal(21,9) not null default 0, `returns` decimal(21,9) not null default 0, `outstanding_amount` decimal(21,9) not null default 0, `net_amount` decimal(21,9) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,728 WARNING database DDL Query made to DB: create table `tabBudget Account` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `account` varchar(140), `budget_amount` decimal(21,9) not null default 0, index `account`(`account`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:47,793 WARNING database DDL Query made to DB: create table `tabLedger Merge` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `root_type` varchar(140), `account` varchar(140), `account_name` varchar(140), `company` varchar(140), `status` varchar(140), `is_group` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,094 WARNING database DDL Query made to DB: create table `tabSales Invoice Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `barcode` varchar(140), `has_item_scanned` int(1) not null default 0, `item_code` varchar(140), `item_name` varchar(140), `customer_item_code` varchar(140), `description` longtext, `item_group` varchar(140), `brand` varchar(140), `image` text, `qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `stock_qty` decimal(21,9) not null default 0, `price_list_rate` decimal(21,9) not null default 0, `base_price_list_rate` decimal(21,9) not null default 0, `margin_type` varchar(140), `margin_rate_or_amount` decimal(21,9) not null default 0, `rate_with_margin` decimal(21,9) not null default 0, `discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `distributed_discount_amount` decimal(21,9) not null default 0, `base_rate_with_margin` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `item_tax_template` varchar(140), `base_rate` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, `pricing_rules` text, `stock_uom_rate` decimal(21,9) not null default 0, `is_free_item` int(1) not null default 0, `grant_commission` int(1) not null default 0, `net_rate` decimal(21,9) not null default 0, `net_amount` decimal(21,9) not null default 0, `base_net_rate` decimal(21,9) not null default 0, `base_net_amount` decimal(21,9) not null default 0, `delivered_by_supplier` int(1) not null default 0, `income_account` varchar(140), `is_fixed_asset` int(1) not null default 0, `asset` varchar(140), `finance_book` varchar(140), `expense_account` varchar(140), `discount_account` varchar(140), `deferred_revenue_account` varchar(140), `service_stop_date` date, `enable_deferred_revenue` int(1) not null default 0, `service_start_date` date, `service_end_date` date, `weight_per_unit` decimal(21,9) not null default 0, `total_weight` decimal(21,9) not null default 0, `weight_uom` varchar(140), `warehouse` varchar(140), `target_warehouse` varchar(140), `quality_inspection` varchar(140), `serial_and_batch_bundle` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `allow_zero_valuation_rate` int(1) not null default 0, `incoming_rate` decimal(21,9) not null default 0, `item_tax_rate` text, `actual_batch_qty` decimal(21,9) not null default 0, `serial_no` text, `batch_no` varchar(140), `actual_qty` decimal(21,9) not null default 0, `company_total_stock` decimal(21,9) not null default 0, `sales_order` varchar(140), `so_detail` varchar(140), `sales_invoice_item` varchar(140), `delivery_note` varchar(140), `dn_detail` varchar(140), `delivered_qty` decimal(21,9) not null default 0, `pos_invoice` varchar(140), `pos_invoice_item` varchar(140), `purchase_order` varchar(140), `purchase_order_item` varchar(140), `cost_center` varchar(140), `project` varchar(140), `page_break` int(1) not null default 0, index `item_code`(`item_code`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `batch_no`(`batch_no`), index `sales_order`(`sales_order`), index `so_detail`(`so_detail`), index `delivery_note`(`delivery_note`), index `dn_detail`(`dn_detail`), index `pos_invoice`(`pos_invoice`), index `purchase_order`(`purchase_order`), index `project`(`project`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,175 WARNING database DDL Query made to DB: create table `tabPayment Term` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `payment_term_name` varchar(140) unique, `invoice_portion` decimal(21,9) not null default 0, `mode_of_payment` varchar(140), `due_date_based_on` varchar(140), `credit_days` int(11) not null default 0, `credit_months` int(11) not null default 0, `discount_type` varchar(140) default 'Percentage', `discount` decimal(21,9) not null default 0, `discount_validity_based_on` varchar(140) default 'Day(s) after invoice date', `discount_validity` int(11) not null default 0, `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,266 WARNING database DDL Query made to DB: create table `tabPromotional Scheme Product Discount` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `disable` int(1) not null default 0, `apply_multiple_pricing_rules` int(1) not null default 0, `rule_description` text, `min_qty` decimal(21,9) not null default 0, `max_qty` decimal(21,9) not null default 0, `min_amount` decimal(21,9) not null default 0, `max_amount` decimal(21,9) not null default 0, `same_item` int(1) not null default 0, `free_item` varchar(140), `free_qty` decimal(21,9) not null default 0, `free_item_uom` varchar(140), `free_item_rate` decimal(21,9) not null default 0, `round_free_qty` int(1) not null default 0, `warehouse` varchar(140), `threshold_percentage` decimal(21,9) not null default 0, `priority` varchar(140), `is_recursive` int(1) not null default 0, `recurse_for` decimal(21,9) not null default 0, `apply_recursion_over` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,334 WARNING database DDL Query made to DB: create table `tabMode of Payment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `mode_of_payment` varchar(140) unique, `enabled` int(1) not null default 1, `type` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,399 WARNING database DDL Query made to DB: create table `tabPricing Rule Item Code` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_code` varchar(140), `uom` varchar(140), index `item_code`(`item_code`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,467 WARNING database DDL Query made to DB: create table `tabPricing Rule Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `pricing_rule` varchar(140), `item_code` varchar(140), `margin_type` varchar(140), `rate_or_discount` varchar(140), `child_docname` varchar(140), `rule_applied` int(1) not null default 1, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,532 WARNING database DDL Query made to DB: create table `tabBank Account Subtype` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `account_subtype` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,650 WARNING database DDL Query made to DB: create table `tabProcess Statement Of Accounts` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `report` varchar(140), `from_date` date, `posting_date` date, `company` varchar(140), `account` varchar(140), `categorize_by` varchar(140) default 'Categorize by Voucher (Consolidated)', `territory` varchar(140), `ignore_exchange_rate_revaluation_journals` int(1) not null default 0, `ignore_cr_dr_notes` int(1) not null default 0, `to_date` date, `finance_book` varchar(140), `currency` varchar(140), `payment_terms_template` varchar(140), `sales_partner` varchar(140), `sales_person` varchar(140), `show_remarks` int(1) not null default 0, `based_on_payment_terms` int(1) not null default 0, `customer_collection` varchar(140), `collection_name` varchar(140), `primary_mandatory` int(1) not null default 1, `show_net_values_in_party_account` int(1) not null default 0, `orientation` varchar(140), `include_break` int(1) not null default 1, `include_ageing` int(1) not null default 0, `ageing_based_on` varchar(140) default 'Due Date', `letter_head` varchar(140), `terms_and_conditions` varchar(140), `enable_auto_email` int(1) not null default 0, `sender` varchar(140), `frequency` varchar(140), `filter_duration` int(11) not null default 1, `start_date` date, `pdf_name` varchar(140), `subject` varchar(140), `body` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,758 WARNING database DDL Query made to DB: create table `tabPOS Closing Entry` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `period_start_date` datetime(6), `period_end_date` datetime(6), `posting_date` date, `posting_time` time(6), `pos_opening_entry` varchar(140), `status` varchar(140) default 'Draft', `company` varchar(140), `pos_profile` varchar(140), `user` varchar(140), `grand_total` decimal(21,9) not null default 0, `net_total` decimal(21,9) not null default 0, `total_quantity` decimal(21,9) not null default 0, `error_message` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,825 WARNING database DDL Query made to DB: create table `tabSupplier Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `supplier` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,885 WARNING database DDL Query made to DB: create table `tabProcess Statement Of Accounts Customer` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `customer` varchar(140), `customer_name` varchar(140), `billing_email` varchar(140), `primary_email` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:48,964 WARNING database DDL Query made to DB: create table `tabDunning Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `dunning_type` varchar(140) unique, `is_default` int(1) not null default 0, `company` varchar(140), `dunning_fee` decimal(21,9) not null default 0, `rate_of_interest` decimal(21,9) not null default 0, `income_account` varchar(140), `cost_center` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,030 WARNING database DDL Query made to DB: create table `tabSubscription Invoice` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `document_type` varchar(140), `invoice` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,086 WARNING database DDL Query made to DB: create table `tabRepost Accounting Ledger Items` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `voucher_type` varchar(140), `voucher_no` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,150 WARNING database DDL Query made to DB: create table `tabUnreconcile Payment Entries` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `account` varchar(140), `party_type` varchar(140), `party` varchar(140), `reference_doctype` varchar(140), `reference_name` varchar(140), `allocated_amount` decimal(21,9) not null default 0, `account_currency` varchar(140), `unlinked` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,207 WARNING database DDL Query made to DB: create table `tabPSOA Project` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `project_name` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,401 WARNING database DDL Query made to DB: create table `tabPurchase Invoice Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_code` varchar(140), `product_bundle` varchar(140), `item_name` varchar(140), `description` longtext, `brand` varchar(140), `item_group` varchar(140), `image` text, `received_qty` decimal(21,9) not null default 0, `qty` decimal(21,9) not null default 0, `rejected_qty` decimal(21,9) not null default 0, `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 1.0, `stock_uom` varchar(140), `stock_qty` decimal(21,9) not null default 0, `price_list_rate` decimal(21,9) not null default 0, `base_price_list_rate` decimal(21,9) not null default 0, `margin_type` varchar(140), `margin_rate_or_amount` decimal(21,9) not null default 0, `rate_with_margin` decimal(21,9) not null default 0, `discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `distributed_discount_amount` decimal(21,9) not null default 0, `base_rate_with_margin` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `item_tax_template` varchar(140), `base_rate` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, `pricing_rules` text, `stock_uom_rate` decimal(21,9) not null default 0, `is_free_item` int(1) not null default 0, `apply_tds` int(1) not null default 1, `net_rate` decimal(21,9) not null default 0, `net_amount` decimal(21,9) not null default 0, `base_net_rate` decimal(21,9) not null default 0, `base_net_amount` decimal(21,9) not null default 0, `valuation_rate` decimal(21,9) not null default 0, `sales_incoming_rate` decimal(21,9) not null default 0, `item_tax_amount` decimal(21,9) not null default 0, `landed_cost_voucher_amount` decimal(21,9) not null default 0, `rm_supp_cost` decimal(21,9) not null default 0, `warehouse` varchar(140), `serial_and_batch_bundle` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `from_warehouse` varchar(140), `quality_inspection` varchar(140), `rejected_warehouse` varchar(140), `rejected_serial_and_batch_bundle` varchar(140), `serial_no` text, `rejected_serial_no` text, `batch_no` varchar(140), `manufacturer` varchar(140), `manufacturer_part_no` varchar(140), `expense_account` varchar(140), `wip_composite_asset` varchar(140), `is_fixed_asset` int(1) not null default 0, `asset_location` varchar(140), `asset_category` varchar(140), `deferred_expense_account` varchar(140), `service_stop_date` date, `enable_deferred_expense` int(1) not null default 0, `service_start_date` date, `service_end_date` date, `allow_zero_valuation_rate` int(1) not null default 0, `item_tax_rate` longtext, `bom` varchar(140), `include_exploded_items` int(1) not null default 0, `purchase_invoice_item` varchar(140), `purchase_order` varchar(140), `po_detail` varchar(140), `purchase_receipt` varchar(140), `pr_detail` varchar(140), `sales_invoice_item` varchar(140), `material_request` varchar(140), `material_request_item` varchar(140), `weight_per_unit` decimal(21,9) not null default 0, `total_weight` decimal(21,9) not null default 0, `weight_uom` varchar(140), `project` varchar(140), `cost_center` varchar(140), `page_break` int(1) not null default 0, index `item_code`(`item_code`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `batch_no`(`batch_no`), index `purchase_order`(`purchase_order`), index `po_detail`(`po_detail`), index `purchase_receipt`(`purchase_receipt`), index `pr_detail`(`pr_detail`), index `material_request`(`material_request`), index `material_request_item`(`material_request_item`), index `project`(`project`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,472 WARNING database DDL Query made to DB: create table `tabCost Center Allocation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `main_cost_center` varchar(140), `company` varchar(140), `valid_from` date, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,550 WARNING database DDL Query made to DB: create table `tabShare Balance` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `share_type` varchar(140), `from_no` int(11) not null default 0, `rate` int(11) not null default 0, `no_of_shares` int(11) not null default 0, `to_no` int(11) not null default 0, `amount` int(11) not null default 0, `is_company` int(1) not null default 0, `current_state` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,626 WARNING database DDL Query made to DB: create table `tabTax Withholding Category` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `category_name` varchar(140), `round_off_tax_amount` int(1) not null default 0, `consider_party_ledger_amount` int(1) not null default 0, `tax_on_excess_amount` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,713 WARNING database DDL Query made to DB: create table `tabInvoice Discounting` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `posting_date` date, `loan_start_date` date, `loan_period` int(11) not null default 0, `loan_end_date` date, `status` varchar(140), `company` varchar(140), `total_amount` decimal(21,9) not null default 0, `bank_charges` decimal(21,9) not null default 0, `short_term_loan` varchar(140), `bank_account` varchar(140), `bank_charges_account` varchar(140), `accounts_receivable_credit` varchar(140), `accounts_receivable_discounted` varchar(140), `accounts_receivable_unpaid` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,784 WARNING database DDL Query made to DB: create table `tabFiscal Year` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `year` varchar(140) unique, `disabled` int(1) not null default 0, `is_short_year` int(1) not null default 0, `year_start_date` date, `year_end_date` date, `auto_created` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:49,876 WARNING database DDL Query made to DB: create table `tabSouth Africa VAT Account` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `account` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:50,094 WARNING database DDL Query made to DB: create table `tabPOS Invoice Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `barcode` varchar(140), `has_item_scanned` int(1) not null default 0, `item_code` varchar(140), `item_name` varchar(140), `customer_item_code` varchar(140), `description` longtext, `item_group` varchar(140), `brand` varchar(140), `image` text, `qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `stock_qty` decimal(21,9) not null default 0, `price_list_rate` decimal(21,9) not null default 0, `base_price_list_rate` decimal(21,9) not null default 0, `margin_type` varchar(140), `margin_rate_or_amount` decimal(21,9) not null default 0, `rate_with_margin` decimal(21,9) not null default 0, `discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `distributed_discount_amount` decimal(21,9) not null default 0, `base_rate_with_margin` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `item_tax_template` varchar(140), `base_rate` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, `pricing_rules` text, `is_free_item` int(1) not null default 0, `grant_commission` int(1) not null default 0, `net_rate` decimal(21,9) not null default 0, `net_amount` decimal(21,9) not null default 0, `base_net_rate` decimal(21,9) not null default 0, `base_net_amount` decimal(21,9) not null default 0, `delivered_by_supplier` int(1) not null default 0, `income_account` varchar(140), `is_fixed_asset` int(1) not null default 0, `asset` varchar(140), `finance_book` varchar(140), `expense_account` varchar(140), `deferred_revenue_account` varchar(140), `service_stop_date` date, `enable_deferred_revenue` int(1) not null default 0, `service_start_date` date, `service_end_date` date, `weight_per_unit` decimal(21,9) not null default 0, `total_weight` decimal(21,9) not null default 0, `weight_uom` varchar(140), `warehouse` varchar(140), `target_warehouse` varchar(140), `quality_inspection` varchar(140), `serial_and_batch_bundle` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `allow_zero_valuation_rate` int(1) not null default 0, `item_tax_rate` text, `actual_batch_qty` decimal(21,9) not null default 0, `actual_qty` decimal(21,9) not null default 0, `serial_no` text, `batch_no` varchar(140), `sales_order` varchar(140), `so_detail` varchar(140), `pos_invoice_item` varchar(140), `delivery_note` varchar(140), `dn_detail` varchar(140), `delivered_qty` decimal(21,9) not null default 0, `cost_center` varchar(140), `project` varchar(140), `page_break` int(1) not null default 0, index `item_code`(`item_code`), index `sales_order`(`sales_order`), index `so_detail`(`so_detail`), index `delivery_note`(`delivery_note`), index `dn_detail`(`dn_detail`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:50,163 WARNING database DDL Query made to DB: create table `tabUnreconcile Payment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `voucher_type` varchar(140), `voucher_no` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:50,236 WARNING database DDL Query made to DB: create table `tabItem Tax Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `company` varchar(140), `disabled` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:50,305 WARNING database DDL Query made to DB: create table `tabProcess Statement Of Accounts CC` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `cc` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:50,460 WARNING database DDL Query made to DB: create table `tabPayment Entry` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `payment_type` varchar(140), `payment_order_status` varchar(140), `posting_date` date, `company` varchar(140), `mode_of_payment` varchar(140), `party_type` varchar(140), `party` varchar(140), `party_name` varchar(140), `book_advance_payments_in_separate_party_account` int(1) not null default 0, `reconcile_on_advance_payment_date` int(1) not null default 0, `bank_account` varchar(140), `party_bank_account` varchar(140), `contact_person` varchar(140), `contact_email` varchar(140), `party_balance` decimal(21,9) not null default 0, `paid_from` varchar(140), `paid_from_account_type` varchar(140), `paid_from_account_currency` varchar(140), `paid_from_account_balance` decimal(21,9) not null default 0, `paid_to` varchar(140), `paid_to_account_type` varchar(140), `paid_to_account_currency` varchar(140), `paid_to_account_balance` decimal(21,9) not null default 0, `paid_amount` decimal(21,9) not null default 0, `paid_amount_after_tax` decimal(21,9) not null default 0, `source_exchange_rate` decimal(21,9) not null default 0, `base_paid_amount` decimal(21,9) not null default 0, `base_paid_amount_after_tax` decimal(21,9) not null default 0, `received_amount` decimal(21,9) not null default 0, `received_amount_after_tax` decimal(21,9) not null default 0, `target_exchange_rate` decimal(21,9) not null default 0, `base_received_amount` decimal(21,9) not null default 0, `base_received_amount_after_tax` decimal(21,9) not null default 0, `total_allocated_amount` decimal(21,9) not null default 0, `base_total_allocated_amount` decimal(21,9) not null default 0, `unallocated_amount` decimal(21,9) not null default 0, `difference_amount` decimal(21,9) not null default 0, `purchase_taxes_and_charges_template` varchar(140), `sales_taxes_and_charges_template` varchar(140), `apply_tax_withholding_amount` int(1) not null default 0, `tax_withholding_category` varchar(140), `base_total_taxes_and_charges` decimal(21,9) not null default 0, `total_taxes_and_charges` decimal(21,9) not null default 0, `reference_no` varchar(140), `reference_date` date, `clearance_date` date, `project` varchar(140), `cost_center` varchar(140), `status` varchar(140) default 'Draft', `custom_remarks` int(1) not null default 0, `remarks` text, `base_in_words` text, `is_opening` varchar(140) default 'No', `letter_head` varchar(140), `print_heading` varchar(140), `bank` varchar(140), `bank_account_no` varchar(140), `payment_order` varchar(140), `in_words` text, `auto_repeat` varchar(140), `amended_from` varchar(140), `title` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `party_type`(`party_type`), index `reference_date`(`reference_date`), index `is_opening`(`is_opening`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:50,777 WARNING database DDL Query made to DB: create table `tabPurchase Invoice` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) default '{supplier_name}', `naming_series` varchar(140), `supplier` varchar(140), `supplier_name` varchar(140), `tax_id` varchar(140), `company` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `due_date` date, `is_paid` int(1) not null default 0, `is_return` int(1) not null default 0, `return_against` varchar(140), `update_outstanding_for_self` int(1) not null default 1, `update_billed_amount_in_purchase_order` int(1) not null default 0, `update_billed_amount_in_purchase_receipt` int(1) not null default 1, `apply_tds` int(1) not null default 0, `tax_withholding_category` varchar(140), `amended_from` varchar(140), `bill_no` varchar(140), `bill_date` date, `cost_center` varchar(140), `project` varchar(140), `currency` varchar(140), `conversion_rate` decimal(21,9) not null default 0, `use_transaction_date_exchange_rate` int(1) not null default 0, `buying_price_list` varchar(140), `price_list_currency` varchar(140), `plc_conversion_rate` decimal(21,9) not null default 0, `ignore_pricing_rule` int(1) not null default 0, `scan_barcode` varchar(140), `update_stock` int(1) not null default 0, `set_warehouse` varchar(140), `set_from_warehouse` varchar(140), `is_subcontracted` int(1) not null default 0, `rejected_warehouse` varchar(140), `supplier_warehouse` varchar(140), `total_qty` decimal(21,9) not null default 0, `total_net_weight` decimal(21,9) not null default 0, `base_total` decimal(21,9) not null default 0, `base_net_total` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `net_total` decimal(21,9) not null default 0, `tax_withholding_net_total` decimal(21,9) not null default 0, `base_tax_withholding_net_total` decimal(21,9) not null default 0, `tax_category` varchar(140), `taxes_and_charges` varchar(140), `shipping_rule` varchar(140), `incoterm` varchar(140), `named_place` varchar(140), `base_taxes_and_charges_added` decimal(21,9) not null default 0, `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, `base_total_taxes_and_charges` decimal(21,9) not null default 0, `taxes_and_charges_added` decimal(21,9) not null default 0, `taxes_and_charges_deducted` decimal(21,9) not null default 0, `total_taxes_and_charges` decimal(21,9) not null default 0, `base_grand_total` decimal(21,9) not null default 0, `base_rounding_adjustment` decimal(21,9) not null default 0, `base_rounded_total` decimal(21,9) not null default 0, `base_in_words` varchar(240), `grand_total` decimal(21,9) not null default 0, `rounding_adjustment` decimal(21,9) not null default 0, `use_company_roundoff_cost_center` int(1) not null default 0, `rounded_total` decimal(21,9) not null default 0, `in_words` varchar(240), `total_advance` decimal(21,9) not null default 0, `outstanding_amount` decimal(21,9) not null default 0, `disable_rounded_total` int(1) not null default 0, `apply_discount_on` varchar(140) default 'Grand Total', `base_discount_amount` decimal(21,9) not null default 0, `additional_discount_percentage` decimal(21,9) not null default 0, `discount_amount` decimal(21,9) not null default 0, `other_charges_calculation` longtext, `mode_of_payment` varchar(140), `base_paid_amount` decimal(21,9) not null default 0, `clearance_date` date, `cash_bank_account` varchar(140), `paid_amount` decimal(21,9) not null default 0, `allocate_advances_automatically` int(1) not null default 0, `only_include_allocated_payments` int(1) not null default 0, `write_off_amount` decimal(21,9) not null default 0, `base_write_off_amount` decimal(21,9) not null default 0, `write_off_account` varchar(140), `write_off_cost_center` varchar(140), `supplier_address` varchar(140), `address_display` text, `contact_person` varchar(140), `contact_display` text, `contact_mobile` text, `contact_email` text, `dispatch_address` varchar(140), `dispatch_address_display` longtext, `shipping_address` varchar(140), `shipping_address_display` text, `billing_address` varchar(140), `billing_address_display` text, `payment_terms_template` varchar(140), `ignore_default_payment_terms_template` int(1) not null default 0, `tc_name` varchar(140), `terms` longtext, `status` varchar(140) default 'Draft', `per_received` decimal(21,9) not null default 0, `credit_to` varchar(140), `party_account_currency` varchar(140), `is_opening` varchar(140) default 'No', `against_expense_account` text, `unrealized_profit_loss_account` varchar(140), `subscription` varchar(140), `auto_repeat` varchar(140), `from_date` date, `to_date` date, `letter_head` varchar(140), `group_same_items` int(1) not null default 0, `select_print_heading` varchar(140), `language` varchar(140), `on_hold` int(1) not null default 0, `release_date` date, `hold_comment` text, `is_internal_supplier` int(1) not null default 0, `represents_company` varchar(140), `supplier_group` varchar(140), `inter_company_invoice_reference` varchar(140), `is_old_subcontracting_flow` int(1) not null default 0, `remarks` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `supplier`(`supplier`), index `posting_date`(`posting_date`), index `return_against`(`return_against`), index `bill_no`(`bill_no`), index `credit_to`(`credit_to`), index `release_date`(`release_date`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,044 WARNING database DDL Query made to DB: create table `tabPOS Profile` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `customer` varchar(140), `country` varchar(140), `disabled` int(1) not null default 0, `warehouse` varchar(140), `campaign` varchar(140), `company_address` varchar(140), `hide_images` int(1) not null default 0, `hide_unavailable_items` int(1) not null default 0, `auto_add_item_to_cart` int(1) not null default 0, `validate_stock_on_save` int(1) not null default 0, `print_receipt_on_order_complete` int(1) not null default 0, `update_stock` int(1) not null default 1, `ignore_pricing_rule` int(1) not null default 0, `allow_rate_change` int(1) not null default 0, `allow_discount_change` int(1) not null default 0, `disable_grand_total_to_default_mop` int(1) not null default 0, `allow_partial_payment` int(1) not null default 0, `print_format` varchar(140), `letter_head` varchar(140), `tc_name` varchar(140), `select_print_heading` varchar(140), `selling_price_list` varchar(140), `currency` varchar(140), `write_off_account` varchar(140), `write_off_cost_center` varchar(140), `write_off_limit` decimal(21,9) not null default 1.0, `account_for_change_amount` varchar(140), `disable_rounded_total` int(1) not null default 0, `income_account` varchar(140), `expense_account` varchar(140), `taxes_and_charges` varchar(140), `tax_category` varchar(140), `apply_discount_on` varchar(140) default 'Grand Total', `cost_center` varchar(140), `project` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,112 WARNING database DDL Query made to DB: create table `tabLoyalty Point Entry Redemption` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `sales_invoice` varchar(140), `redemption_date` date, `redeemed_points` int(11) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,181 WARNING database DDL Query made to DB: create table `tabRepost Payment Ledger` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `posting_date` date, `voucher_type` varchar(140), `add_manually` int(1) not null default 0, `repost_status` varchar(140), `repost_error_log` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,262 WARNING database DDL Query made to DB: create table `tabAccounting Period` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `period_name` varchar(140), `start_date` date, `end_date` date, `company` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,399 WARNING database DDL Query made to DB: create table `tabBank Statement Import` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `bank_account` varchar(140), `bank` varchar(140), `custom_delimiters` int(1) not null default 0, `delimiter_options` varchar(140) default ',;\\t|', `google_sheets_url` varchar(140), `import_file` text, `status` varchar(140) default 'Pending', `template_options` longtext, `template_warnings` longtext, `show_failed_logs` int(1) not null default 0, `reference_doctype` varchar(140) default 'Bank Transaction', `import_type` varchar(140) default 'Insert New Records', `submit_after_import` int(1) not null default 1, `mute_emails` int(1) not null default 1, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,460 WARNING database DDL Query made to DB: create table `tabClosed Document` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `document_type` varchar(140), `closed` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,629 WARNING database DDL Query made to DB: create table `tabPayment Request` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `payment_request_type` varchar(140) default 'Inward', `transaction_date` date, `naming_series` varchar(140), `company` varchar(140), `mode_of_payment` varchar(140), `party_type` varchar(140), `party` varchar(140), `party_name` varchar(140), `reference_doctype` varchar(140), `reference_name` varchar(140), `grand_total` decimal(21,9) not null default 0, `currency` varchar(140), `is_a_subscription` int(1) not null default 0, `outstanding_amount` decimal(21,9) not null default 0, `party_account_currency` varchar(140), `bank_account` varchar(140), `bank` varchar(140), `bank_account_no` varchar(140), `account` varchar(140), `iban` varchar(140), `branch_code` varchar(140), `swift_number` varchar(140), `cost_center` varchar(140), `project` varchar(140), `print_format` varchar(140), `email_to` varchar(140), `subject` varchar(140), `payment_gateway_account` varchar(140), `status` varchar(140) default 'Draft', `make_sales_invoice` int(1) not null default 0, `message` text, `mute_email` int(1) not null default 0, `payment_url` varchar(500), `payment_gateway` varchar(140), `payment_account` varchar(140), `payment_channel` varchar(140), `payment_order` varchar(140), `amended_from` varchar(140), `phone_number` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `reference_name`(`reference_name`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,703 WARNING database DDL Query made to DB: create table `tabPurchase Taxes and Charges Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `is_default` int(1) not null default 0, `disabled` int(1) not null default 0, `company` varchar(140), `tax_category` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,771 WARNING database DDL Query made to DB: create table `tabJournal Entry Template Account` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `account` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:51,881 WARNING database DDL Query made to DB: create table `tabDunning` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140) default 'DUNN-.MM.-.YY.-', `customer` varchar(140), `customer_name` varchar(140), `company` varchar(140), `posting_date` date, `posting_time` time(6), `status` varchar(140) default 'Unresolved', `currency` varchar(140), `conversion_rate` decimal(21,9) not null default 0, `dunning_type` varchar(140), `rate_of_interest` decimal(21,9) not null default 0, `total_interest` decimal(21,9) not null default 0, `dunning_fee` decimal(21,9) not null default 0, `dunning_amount` decimal(21,9) not null default 0, `base_dunning_amount` decimal(21,9) not null default 0, `spacer` varchar(140), `total_outstanding` decimal(21,9) not null default 0, `grand_total` decimal(21,9) not null default 0, `language` varchar(140), `body_text` longtext, `letter_head` varchar(140), `closing_text` longtext, `income_account` varchar(140), `cost_center` varchar(140), `amended_from` varchar(140), `customer_address` varchar(140), `address_display` text, `contact_person` varchar(140), `contact_display` text, `contact_mobile` text, `contact_email` varchar(140), `company_address` varchar(140), `company_address_display` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:52,831 WARNING database DDL Query made to DB: create table `tabCampaign Email Schedule` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `email_template` varchar(140), `send_after_days` int(11) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:52,891 WARNING database DDL Query made to DB: create table `tabAppointment Booking Slots` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `day_of_week` varchar(140), `from_time` time(6), `to_time` time(6), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:52,951 WARNING database DDL Query made to DB: create sequence if not exists prospect_opportunity_id_seq nocache nocycle 2025-06-24 00:38:52,964 WARNING database DDL Query made to DB: create table `tabProspect Opportunity` ( name bigint primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `opportunity` varchar(140), `amount` decimal(21,9) not null default 0, `stage` varchar(140), `deal_owner` varchar(140), `probability` decimal(21,9) not null default 0, `expected_closing` date, `currency` varchar(140), `contact_person` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:53,022 WARNING database DDL Query made to DB: create sequence if not exists crm_note_id_seq nocache nocycle 2025-06-24 00:38:53,035 WARNING database DDL Query made to DB: create table `tabCRM Note` ( name bigint primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `note` longtext, `added_by` varchar(140), `added_on` datetime(6), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:53,126 WARNING database DDL Query made to DB: create table `tabProspect` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company_name` varchar(140) unique, `customer_group` varchar(140), `no_of_employees` varchar(140), `annual_revenue` decimal(21,9) not null default 0, `market_segment` varchar(140), `industry` varchar(140), `territory` varchar(140), `prospect_owner` varchar(140), `website` varchar(140), `fax` varchar(140), `company` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:38:53,197 WARNING database DDL Query made to DB: create table `tabAvailability Of Slots` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `day_of_week` varchar(140), `from_time` time(6), `to_time` time(6), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci