2025-06-24 00:39:42,691 WARNING database DDL Query made to DB: create table `tabSalary Component` ( 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', `salary_component` varchar(140) unique, `salary_component_abbr` varchar(140), `type` varchar(140), `description` text, `depends_on_payment_days` int(1) not null default 1, `is_tax_applicable` int(1) not null default 1, `deduct_full_tax_on_selected_payroll_date` int(1) not null default 0, `variable_based_on_taxable_salary` int(1) not null default 0, `is_income_tax_component` int(1) not null default 0, `exempted_from_income_tax` int(1) not null default 0, `round_to_the_nearest_integer` int(1) not null default 0, `statistical_component` int(1) not null default 0, `do_not_include_in_total` int(1) not null default 0, `remove_if_zero_valued` int(1) not null default 1, `disabled` int(1) not null default 0, `condition` longtext, `amount` decimal(21,9) not null default 0, `amount_based_on_formula` int(1) not null default 0, `formula` longtext, `is_flexible_benefit` int(1) not null default 0, `max_benefit_amount` decimal(21,9) not null default 0, `pay_against_benefit_claim` int(1) not null default 0, `only_tax_impact` int(1) not null default 0, `create_separate_payment_entry_against_benefit_claim` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `variable_based_on_taxable_salary`(`variable_based_on_taxable_salary`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:39:42,781 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Proof Submission 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', `exemption_sub_category` varchar(140), `exemption_category` varchar(140), `max_amount` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `type_of_proof` varchar(140), `attach_proof` text, 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:39:42,880 WARNING database DDL Query made to DB: create table `tabSalary Structure Assignment` ( 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', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `designation` varchar(140), `grade` varchar(140), `salary_structure` varchar(140), `from_date` date, `income_tax_slab` varchar(140), `company` varchar(140), `payroll_payable_account` varchar(140), `currency` varchar(140), `base` decimal(21,9) not null default 0, `variable` decimal(21,9) not null default 0, `amended_from` varchar(140), `taxable_earnings_till_date` decimal(21,9) not null default 0, `tax_deducted_till_date` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `salary_structure`(`salary_structure`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:39:42,977 WARNING database DDL Query made to DB: create table `tabPayroll 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', `company` varchar(140), `start_date` date, `end_date` date, `_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:39:43,084 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Sub 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', `exemption_category` varchar(140), `max_amount` decimal(21,9) not null default 0, `is_active` 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:39:43,175 WARNING database DDL Query made to DB: create table `tabEmployee Cost Center` ( 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` 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:39:43,276 WARNING database DDL Query made to DB: create table `tabSalary Withholding` ( 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', `employee` varchar(140), `employee_name` varchar(140), `company` varchar(140), `posting_date` date, `payroll_frequency` varchar(140), `number_of_withholding_cycles` int(11) not null default 0, `status` varchar(140) default 'Draft', `from_date` date, `to_date` date, `date_of_joining` date, `relieving_date` date, `reason_for_withholding_salary` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `amended_from`(`amended_from`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:39:43,370 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption 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', `max_amount` decimal(21,9) not null default 0, `is_active` 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:39:43,489 WARNING database DDL Query made to DB: create table `tabGratuity` ( 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', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `designation` varchar(140), `current_work_experience` decimal(21,9) not null default 0, `posting_date` date, `gratuity_rule` varchar(140), `status` varchar(140) default 'Draft', `company` varchar(140), `amended_from` varchar(140), `pay_via_salary_slip` int(1) not null default 1, `amount` decimal(21,9) not null default 0, `paid_amount` decimal(21,9) not null default 0, `payroll_date` date, `salary_component` varchar(140), `cost_center` varchar(140), `mode_of_payment` varchar(140), `expense_account` varchar(140), `payable_account` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:39:43,580 WARNING database DDL Query made to DB: create table `tabSalary Slip Loan` ( 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', `loan` varchar(140), `loan_product` varchar(140), `loan_account` varchar(140), `interest_income_account` varchar(140), `principal_amount` decimal(21,9) not null default 0, `interest_amount` decimal(21,9) not null default 0, `total_payment` decimal(21,9) not null default 0, `loan_repayment_entry` 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:39:43,736 WARNING database DDL Query made to DB: create table `tabEmployee Benefit Application 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', `earning_component` varchar(140), `pay_against_benefit_claim` int(1) not null default 0, `max_benefit_amount` decimal(21,9) not null default 0, `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:39:43,887 WARNING database DDL Query made to DB: create table `tabSalary Withholding Cycle` ( 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, `is_salary_released` int(1) not null default 0, `journal_entry` 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:39:43,970 WARNING database DDL Query made to DB: create table `tabSalary Slip Leave` ( 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', `leave_type` varchar(140), `total_allocated_leaves` decimal(21,9) not null default 0, `expired_leaves` decimal(21,9) not null default 0, `used_leaves` decimal(21,9) not null default 0, `pending_leaves` decimal(21,9) not null default 0, `available_leaves` 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:39:44,050 WARNING database DDL Query made to DB: create table `tabTaxable Salary Slab` ( 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_amount` decimal(21,9) not null default 0, `to_amount` decimal(21,9) not null default 0, `percent_deduction` decimal(21,9) not null default 0, `condition` 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:39:44,122 WARNING database DDL Query made to DB: create table `tabPayroll Period Date` ( 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', `start_date` date, `end_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:39:44,199 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Declaration 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', `exemption_sub_category` varchar(140), `exemption_category` varchar(140), `max_amount` decimal(21,9) not null default 0, `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:39:44,288 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Declaration` ( 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', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `company` varchar(140), `payroll_period` varchar(140), `currency` varchar(140), `amended_from` varchar(140), `total_declared_amount` decimal(21,9) not null default 0, `total_exemption_amount` decimal(21,9) 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:39:44,388 WARNING database DDL Query made to DB: create table `tabSalary Component 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:39:44,463 WARNING database DDL Query made to DB: create table `tabGratuity Rule Slab` ( 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_year` int(11) not null default 0, `to_year` int(11) not null default 0, `fraction_of_applicable_earnings` 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:39:44,536 WARNING database DDL Query made to DB: create table `tabSalary Slip Timesheet` ( 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', `time_sheet` varchar(140), `working_hours` 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:39:44,639 WARNING database DDL Query made to DB: create table `tabAdditional Salary` ( 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), `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `company` varchar(140), `is_recurring` int(1) not null default 0, `disabled` int(1) not null default 0, `from_date` date, `to_date` date, `payroll_date` date, `amended_from` varchar(140), `salary_component` varchar(140), `type` varchar(140), `currency` varchar(140), `amount` decimal(21,9) not null default 0, `deduct_full_tax_on_selected_payroll_date` int(1) not null default 0, `overwrite_salary_structure_amount` int(1) not null default 1, `ref_doctype` varchar(140), `ref_docname` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `payroll_date`(`payroll_date`), index `salary_component`(`salary_component`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:39:44,741 WARNING database DDL Query made to DB: create table `tabIncome Tax Slab` ( 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', `disabled` int(1) not null default 0, `effective_from` date, `company` varchar(140), `currency` varchar(140), `standard_tax_exemption_amount` decimal(21,9) not null default 0, `allow_tax_exemption` int(1) not null default 0, `amended_from` varchar(140), `tax_relief_limit` decimal(21,9) 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:39:44,863 WARNING database DDL Query made to DB: create table `tabEmployee Tax Exemption Proof Submission` ( 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', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `currency` varchar(140), `amended_from` varchar(140), `submission_date` date, `payroll_period` varchar(140), `company` varchar(140), `total_actual_amount` decimal(21,9) not null default 0, `exemption_amount` decimal(21,9) not null default 0, `attachments` 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:39:44,980 WARNING database DDL Query made to DB: create table `tabEmployee Other Income` ( 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', `employee` varchar(140), `employee_name` varchar(140), `amended_from` varchar(140), `company` varchar(140), `payroll_period` varchar(140), `source` varchar(140), `amount` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `company`(`company`), index `payroll_period`(`payroll_period`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:39:45,125 WARNING database DDL Query made to DB: create table `tabPayroll 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), `currency` varchar(140), `exchange_rate` decimal(21,9) not null default 0, `payroll_payable_account` varchar(140), `status` varchar(140), `salary_slip_based_on_timesheet` int(1) not null default 0, `payroll_frequency` varchar(140), `start_date` date, `end_date` date, `deduct_tax_for_unclaimed_employee_benefits` int(1) not null default 0, `deduct_tax_for_unsubmitted_tax_exemption_proof` int(1) not null default 0, `branch` varchar(140), `department` varchar(140), `designation` varchar(140), `grade` varchar(140), `number_of_employees` int(11) not null default 0, `validate_attendance` int(1) not null default 0, `cost_center` varchar(140), `project` varchar(140), `payment_account` varchar(140), `bank_account` varchar(140), `salary_slips_created` int(1) not null default 0, `salary_slips_submitted` int(1) 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:39:45,224 WARNING database DDL Query made to DB: create table `tabEmployee Incentive` ( 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', `employee` varchar(140), `employee_name` varchar(140), `amended_from` varchar(140), `company` varchar(140), `department` varchar(140), `salary_component` varchar(140), `currency` varchar(140), `payroll_date` date, `incentive_amount` decimal(21,9) 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:39:46,384 WARNING database DDL Query made to DB: ALTER TABLE `tabTerms and Conditions` ADD COLUMN `hr` int(1) not null default 1 2025-06-24 00:39:46,449 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` ADD COLUMN `employment_type` varchar(140), ADD COLUMN `grade` varchar(140), ADD COLUMN `job_applicant` varchar(140), ADD COLUMN `default_shift` varchar(140), ADD COLUMN `expense_approver` varchar(140), ADD COLUMN `leave_approver` varchar(140), ADD COLUMN `shift_request_approver` varchar(140), ADD COLUMN `payroll_cost_center` varchar(140), ADD COLUMN `health_insurance_provider` varchar(140), ADD COLUMN `health_insurance_no` varchar(140) 2025-06-24 00:39:46,464 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 00:39:46,514 WARNING database DDL Query made to DB: ALTER TABLE `tabTask` ADD COLUMN `total_expense_claim` decimal(21,9) not null default 0 2025-06-24 00:39:46,531 WARNING database DDL Query made to DB: ALTER TABLE `tabTask` MODIFY `progress` decimal(21,9) not null default 0, MODIFY `total_billing_amount` decimal(21,9) not null default 0, MODIFY `task_weight` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0 2025-06-24 00:39:46,577 WARNING database DDL Query made to DB: ALTER TABLE `tabDepartment` ADD COLUMN `payroll_cost_center` varchar(140), ADD COLUMN `leave_block_list` varchar(140) 2025-06-24 00:39:46,624 WARNING database DDL Query made to DB: ALTER TABLE `tabTimesheet` ADD COLUMN `salary_slip` varchar(140) 2025-06-24 00:39:46,640 WARNING database DDL Query made to DB: ALTER TABLE `tabTimesheet` MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billed_hours` decimal(21,9) not null default 0, MODIFY `total_billable_hours` decimal(21,9) not null default 0, MODIFY `base_total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `per_billed` decimal(21,9) not null default 0, MODIFY `base_total_billable_amount` decimal(21,9) not null default 0, MODIFY `base_total_billed_amount` decimal(21,9) not null default 0 2025-06-24 00:39:46,699 WARNING database DDL Query made to DB: ALTER TABLE `tabCompany` ADD COLUMN `default_expense_claim_payable_account` varchar(140), ADD COLUMN `default_employee_advance_account` varchar(140), ADD COLUMN `default_payroll_payable_account` varchar(140) 2025-06-24 00:39:46,715 WARNING database DDL Query made to DB: ALTER TABLE `tabCompany` MODIFY `credit_limit` decimal(21,9) not null default 0, MODIFY `monthly_sales_target` decimal(21,9) not null default 0, MODIFY `total_monthly_sales` decimal(21,9) not null default 0 2025-06-24 00:39:46,767 WARNING database DDL Query made to DB: ALTER TABLE `tabProject` ADD COLUMN `total_expense_claim` decimal(21,9) not null default 0 2025-06-24 00:39:46,783 WARNING database DDL Query made to DB: ALTER TABLE `tabProject` MODIFY `gross_margin` decimal(21,9) not null default 0, MODIFY `total_sales_amount` decimal(21,9) not null default 0, MODIFY `total_billable_amount` decimal(21,9) not null default 0, MODIFY `total_costing_amount` decimal(21,9) not null default 0, MODIFY `total_billed_amount` decimal(21,9) not null default 0, MODIFY `estimated_costing` decimal(21,9) not null default 0, MODIFY `actual_time` decimal(21,9) not null default 0, MODIFY `per_gross_margin` decimal(21,9) not null default 0, MODIFY `percent_complete` decimal(21,9) not null default 0, MODIFY `total_purchase_cost` decimal(21,9) not null default 0, MODIFY `total_consumed_material_cost` decimal(21,9) not null default 0 2025-06-24 00:39:46,824 WARNING database DDL Query made to DB: ALTER TABLE `tabDesignation` ADD COLUMN `appraisal_template` varchar(140) 2025-06-24 00:40:05,914 WARNING database DDL Query made to DB: create table `tabCheck Run` ( 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', `end_date` date, `posting_date` date, `beg_balance` decimal(21,9) not null default 0, `company_discretionary_data` varchar(20), `initial_check_number` int(11) not null default 0, `final_check_number` int(11) not null default 0, `amount_check_run` decimal(21,9) not null default 0, `company` varchar(140), `bank_account` varchar(140), `pay_to_account` varchar(140) default 'company.default_payable_account', `amended_from` varchar(140), `transactions` longtext, `print_count` int(11) not null default 0, `status` varchar(140) default 'Draft', `ach_file_generated` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:40:06,158 WARNING database DDL Query made to DB: create table `tabCheck Run Settings` ( 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), `approver_role` varchar(140), `pay_to_account` varchar(140), `print_format` varchar(140), `include_purchase_invoices` int(1) not null default 1, `include_journal_entries` int(1) not null default 1, `include_expense_claims` int(1) not null default 1, `pre_check_overdue_items` int(1) not null default 0, `allow_cancellation` int(1) not null default 0, `cascade_cancellation` int(1) not null default 0, `validate_unique_check_number` int(1) not null default 0, `set_payment_entry_posting_date` varchar(140) default 'Use Today\'s Date', `number_of_invoices_per_voucher` int(11) not null default 0, `split_by_address` int(1) not null default 0, `automatically_release_on_hold_invoices` int(1) not null default 0, `file_preview_threshold` int(11) not null default 1000, `allow_stand_alone_debit_notes` varchar(140) default 'No', `purchase_invoice` varchar(140), `journal_entry` varchar(140), `expense_claim` varchar(140), `allow_only_verified_accounts_in_nacha_generation` int(1) not null default 0, `ach_file_extension` varchar(140) default 'ach', `ach_service_class_code` varchar(140), `ach_standard_class_code` varchar(140), `ach_description` varchar(10), `immediate_origin` varchar(140), `company_discretionary_data` varchar(20), `custom_post_processing_hook` varchar(140), `role_allowed_to_download_ach_file_multiple_times` varchar(140), `attach_positive_pay` int(1) not null default 0, `positive_pay_file_format` varchar(140) default 'CSV', `csv_delimiter` varchar(1) default ',', `csv_quoting` varchar(140) default 'Non-numeric', `_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:40:07,267 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` ADD COLUMN `check_run` varchar(140) 2025-06-24 00:40:07,283 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0, MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `total_allocated_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `party_balance` decimal(21,9) not null default 0, MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `difference_amount` decimal(21,9) not null default 0 2025-06-24 00:40:07,343 WARNING database DDL Query made to DB: ALTER TABLE `tabBank` ADD COLUMN `aba_number` varchar(140) 2025-06-24 00:40:07,583 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` ADD COLUMN `supplier_default_mode_of_payment` varchar(140) 2025-06-24 00:40:07,599 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0 2025-06-24 00:40:07,794 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` ADD COLUMN `mode_of_payment` varchar(140), ADD COLUMN `bank` varchar(140), ADD COLUMN `bank_account` text 2025-06-24 00:40:07,809 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 00:40:07,934 WARNING database DDL Query made to DB: ALTER TABLE `tabSupplier` ADD COLUMN `supplier_default_mode_of_payment` varchar(140), ADD COLUMN `number_of_invoices_per_check_voucher` int(11) not null default 0, ADD COLUMN `bank_account` text, ADD COLUMN `bank` varchar(140) 2025-06-24 00:40:08,145 WARNING database DDL Query made to DB: ALTER TABLE `tabBank Account` ADD COLUMN `allow_quick_check` int(1) not null default 1, ADD COLUMN `check_number` varchar(140), ADD COLUMN `company_ach_id` varchar(140) 2025-06-24 00:40:08,378 WARNING database DDL Query made to DB: create table `tabSite 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', `site_code` 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:40:09,239 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` ADD COLUMN `site_code` varchar(140), ADD COLUMN `service_date` date 2025-06-24 00:40:09,255 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `total` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0 2025-06-24 00:40:09,473 WARNING database DDL Query made to DB: create table `tabWiki Page Revision 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', `wiki_page` 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:40:09,583 WARNING database DDL Query made to DB: create table `tabWiki Space` ( 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', `space_name` varchar(140), `route` varchar(140) unique, `app_switcher_logo` text, `light_mode_logo` text, `dark_mode_logo` 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:40:09,712 WARNING database DDL Query made to DB: create table `tabWiki Feedback` ( 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', `wiki_page` varchar(140), `status` varchar(140) default 'Open', `rating` decimal(3,2), `feedback` text, `email_id` 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:40:09,818 WARNING database DDL Query made to DB: create table `tabWiki Page` ( 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), `route` varchar(140) unique, `published` int(1) not null default 0, `allow_guest` int(1) not null default 1, `content` longtext default 'No Content', `meta_description` text, `meta_image` text, `meta_keywords` 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:40:09,910 WARNING database DDL Query made to DB: create table `tabWiki App Switcher List Table` ( 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', `app_title` varchar(140), `wiki_space` 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:40:10,001 WARNING database DDL Query made to DB: create table `tabWiki Page Patch` ( 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', `wiki_page` varchar(140), `new_title` varchar(140), `new_sidebar_group` varchar(140), `message` text, `raised_by` varchar(140), `status` varchar(140) default 'Under Review', `approved_by` varchar(140), `new` int(1) not null default 0, `orignal_code` longtext, `new_code` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-24 00:40:10,094 WARNING database DDL Query made to DB: create table `tabWiki Sidebar` ( 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', `wiki_page` varchar(140) unique, `parent_label` 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:40:10,236 WARNING database DDL Query made to DB: create table `tabWiki Group 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', `parent_label` varchar(140), `wiki_page` varchar(140), `hide_on_sidebar` 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:40:10,411 WARNING database DDL Query made to DB: create table `tabWiki Page Revision` ( 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', `content` longtext, `raised_by` varchar(140), `raised_by_username` varchar(140), `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:41:08,200 WARNING database DDL Query made to DB: ALTER TABLE `tabCustomer` ADD COLUMN `exempt_from_sales_tax` int(1) not null default 0 2025-06-24 00:41:08,216 WARNING database DDL Query made to DB: ALTER TABLE `tabCustomer` MODIFY `default_commission_rate` decimal(21,9) not null default 0 2025-06-24 00:41:08,314 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Order` ADD COLUMN `exempt_from_sales_tax` int(1) not null default 0 2025-06-24 00:41:08,331 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Order` MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `per_billed` decimal(21,9) not null default 0, MODIFY `per_picked` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `loyalty_amount` decimal(21,9) not null default 0, MODIFY `advance_paid` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `amount_eligible_for_commission` decimal(21,9) not null default 0, MODIFY `commission_rate` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `total_commission` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `per_delivered` decimal(21,9) not null default 0 2025-06-24 00:41:08,417 WARNING database DDL Query made to DB: ALTER TABLE `tabQuotation` ADD COLUMN `exempt_from_sales_tax` int(1) not null default 0 2025-06-24 00:41:08,433 WARNING database DDL Query made to DB: ALTER TABLE `tabQuotation` MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0 2025-06-24 00:41:08,507 WARNING database DDL Query made to DB: ALTER TABLE `tabSupplier` ADD COLUMN `irs_1099` int(1) not null default 0 2025-06-24 00:41:08,621 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Invoice` ADD COLUMN `exempt_from_sales_tax` int(1) not null default 0 2025-06-24 00:41:08,638 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Invoice` MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_billing_hours` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `amount_eligible_for_commission` decimal(21,9) not null default 0, MODIFY `commission_rate` decimal(21,9) not null default 0, MODIFY `change_amount` decimal(21,9) not null default 0, MODIFY `total_commission` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `base_change_amount` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `loyalty_amount` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0 2025-06-24 13:47:05,837 WARNING database DDL Query made to DB: alter table `tabDocType` add column if not exists migration_hash varchar(140) 2025-06-24 13:47:06,554 WARNING database DDL Query made to DB: ALTER TABLE `tabPrint Heading` DROP INDEX `print_heading` 2025-06-24 13:47:07,298 WARNING database DDL Query made to DB: ALTER TABLE `tabPrint Heading` ADD UNIQUE INDEX IF NOT EXISTS print_heading (`print_heading`) 2025-06-24 13:47:09,300 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `difference_amount` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0, MODIFY `total_allocated_amount` decimal(21,9) not null default 0, MODIFY `party_balance` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0 2025-06-24 13:47:09,438 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0 2025-06-24 13:47:09,640 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 13:47:09,859 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0 2025-06-24 13:47:11,538 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `difference_amount` decimal(21,9) not null default 0, MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0, MODIFY `party_balance` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `total_allocated_amount` decimal(21,9) not null default 0 2025-06-24 13:47:11,765 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0 2025-06-24 13:47:11,965 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 13:47:12,093 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 13:47:12,222 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 13:54:52,878 WARNING database DDL Query made to DB: alter table `tabDocType` add column if not exists migration_hash varchar(140) 2025-06-24 13:54:53,578 WARNING database DDL Query made to DB: ALTER TABLE `tabPrint Heading` DROP INDEX `print_heading` 2025-06-24 13:54:54,313 WARNING database DDL Query made to DB: ALTER TABLE `tabPrint Heading` ADD UNIQUE INDEX IF NOT EXISTS print_heading (`print_heading`) 2025-06-24 13:54:56,339 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` MODIFY `total_allocated_amount` decimal(21,9) not null default 0, MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `difference_amount` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `party_balance` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0 2025-06-24 13:54:56,479 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0 2025-06-24 13:54:56,677 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 13:54:56,894 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0 2025-06-24 13:54:58,627 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `party_balance` decimal(21,9) not null default 0, MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0, MODIFY `difference_amount` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `total_allocated_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0 2025-06-24 13:54:58,912 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0 2025-06-24 13:54:59,210 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 13:54:59,405 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 13:54:59,598 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 20:42:10,792 WARNING database DDL Query made to DB: alter table `tabDocType` add column if not exists migration_hash varchar(140) 2025-06-24 20:42:11,863 WARNING database DDL Query made to DB: ALTER TABLE `tabPrint Heading` DROP INDEX `print_heading` 2025-06-24 20:42:13,435 WARNING database DDL Query made to DB: ALTER TABLE `tabPrint Heading` ADD UNIQUE INDEX IF NOT EXISTS print_heading (`print_heading`) 2025-06-24 20:42:14,837 WARNING database DDL Query made to DB: ALTER TABLE `tabCheck Run Settings` ADD COLUMN `show_due_date` varchar(140) default 'Show Due Date' 2025-06-24 20:42:14,853 WARNING database DDL Query made to DB: ALTER TABLE `tabCheck Run Settings` MODIFY `set_payment_entry_posting_date` varchar(140) default 'Use Today\'s Date' 2025-06-24 20:42:16,626 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `difference_amount` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `party_balance` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `total_allocated_amount` decimal(21,9) not null default 0 2025-06-24 20:42:16,771 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0 2025-06-24 20:42:16,988 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 20:42:17,215 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0 2025-06-24 20:42:20,668 WARNING database DDL Query made to DB: ALTER TABLE `tabPayment Entry` MODIFY `base_paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `received_amount` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `target_exchange_rate` decimal(21,9) not null default 0, MODIFY `received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `paid_to_account_balance` decimal(21,9) not null default 0, MODIFY `base_received_amount` decimal(21,9) not null default 0, MODIFY `base_received_amount_after_tax` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `total_allocated_amount` decimal(21,9) not null default 0, MODIFY `paid_amount_after_tax` decimal(21,9) not null default 0, MODIFY `base_total_allocated_amount` decimal(21,9) not null default 0, MODIFY `party_balance` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `paid_from_account_balance` decimal(21,9) not null default 0, MODIFY `unallocated_amount` decimal(21,9) not null default 0, MODIFY `source_exchange_rate` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `difference_amount` decimal(21,9) not null default 0 2025-06-24 20:42:20,903 WARNING database DDL Query made to DB: ALTER TABLE `tabPurchase Invoice` MODIFY `total_advance` decimal(21,9) not null default 0, MODIFY `base_write_off_amount` decimal(21,9) not null default 0, MODIFY `write_off_amount` decimal(21,9) not null default 0, MODIFY `base_rounded_total` decimal(21,9) not null default 0, MODIFY `net_total` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `base_paid_amount` decimal(21,9) not null default 0, MODIFY `conversion_rate` decimal(21,9) not null default 0, MODIFY `discount_amount` decimal(21,9) not null default 0, MODIFY `base_net_total` decimal(21,9) not null default 0, MODIFY `plc_conversion_rate` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_added` decimal(21,9) not null default 0, MODIFY `total_taxes_and_charges` decimal(21,9) not null default 0, MODIFY `taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `base_tax_withholding_net_total` decimal(21,9) not null default 0, MODIFY `total` decimal(21,9) not null default 0, MODIFY `total_net_weight` decimal(21,9) not null default 0, MODIFY `rounded_total` decimal(21,9) not null default 0, MODIFY `per_received` decimal(21,9) not null default 0, MODIFY `base_total` decimal(21,9) not null default 0, MODIFY `grand_total` decimal(21,9) not null default 0, MODIFY `total_qty` decimal(21,9) not null default 0, MODIFY `base_discount_amount` decimal(21,9) not null default 0, MODIFY `base_taxes_and_charges_deducted` decimal(21,9) not null default 0, MODIFY `paid_amount` decimal(21,9) not null default 0, MODIFY `base_grand_total` decimal(21,9) not null default 0, MODIFY `outstanding_amount` decimal(21,9) not null default 0, MODIFY `base_rounding_adjustment` decimal(21,9) not null default 0, MODIFY `additional_discount_percentage` decimal(21,9) not null default 0, MODIFY `rounding_adjustment` decimal(21,9) not null default 0, MODIFY `base_total_taxes_and_charges` decimal(21,9) not null default 0 2025-06-24 20:42:21,156 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 20:42:21,295 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0 2025-06-24 20:42:21,428 WARNING database DDL Query made to DB: ALTER TABLE `tabEmployee` MODIFY `ctc` decimal(21,9) not null default 0