2025-06-23 23:52:02,555 WARNING database DDL Query made to DB: create table `tabOAuth Bearer Token` ( 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', `client` varchar(140), `user` varchar(140), `scopes` text, `access_token` varchar(140) unique, `refresh_token` varchar(140), `expiration_time` datetime(6), `expires_in` int(11) not null default 0, `status` 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-23 23:52:02,639 WARNING database DDL Query made to DB: create table `tabWebhook` ( 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', `webhook_doctype` varchar(140), `webhook_docevent` varchar(140), `enabled` int(1) not null default 1, `condition` text, `request_url` text, `is_dynamic_url` int(1) not null default 0, `timeout` int(11) not null default 5, `background_jobs_queue` varchar(140), `request_method` varchar(140) default 'POST', `request_structure` varchar(140), `enable_security` int(1) not null default 0, `webhook_secret` text, `webhook_json` longtext, `preview_document` 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-23 23:52:02,699 WARNING database DDL Query made to DB: create table `tabWebhook Data` ( 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', `fieldname` varchar(140), `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-23 23:52:02,806 WARNING database DDL Query made to DB: create table `tabLDAP Group Mapping` ( 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', `ldap_group` varchar(140), `erpnext_role` 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-23 23:52:02,880 WARNING database DDL Query made to DB: create table `tabSocial Login Key` ( 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', `enable_social_login` int(1) not null default 0, `social_login_provider` varchar(140) default 'Custom', `client_id` varchar(140), `provider_name` varchar(140), `client_secret` text, `icon` varchar(140), `base_url` varchar(140), `sign_ups` varchar(140), `authorize_url` varchar(140), `access_token_url` varchar(140), `redirect_url` varchar(140), `api_endpoint` varchar(140), `custom_base_url` int(1) not null default 0, `api_endpoint_args` longtext, `auth_url_data` longtext, `user_id_property` 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-23 23:52:02,951 WARNING database DDL Query made to DB: create table `tabIntegration 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', `request_id` varchar(140), `integration_request_service` varchar(140), `is_remote_request` int(1) not null default 0, `request_description` varchar(140), `status` varchar(140) default 'Queued', `url` text, `request_headers` longtext, `data` longtext, `output` longtext, `error` longtext, `reference_doctype` varchar(140), `reference_docname` 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-23 23:52:03,021 WARNING database DDL Query made to DB: create table `tabGoogle Calendar` ( 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', `enable` int(1) not null default 1, `calendar_name` varchar(140) unique, `user` varchar(140), `pull_from_google_calendar` int(1) not null default 1, `sync_as_public` int(1) not null default 0, `push_to_google_calendar` int(1) not null default 1, `google_calendar_id` varchar(140), `refresh_token` text, `authorization_code` text, `next_sync_token` 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-23 23:52:03,136 WARNING database DDL Query made to DB: create table `tabNetwork Printer 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', `server_ip` varchar(140) default 'localhost', `port` int(11) not null default 631, `printer_name` 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-23 23:52:03,378 WARNING database DDL Query made to DB: create table `tabPrint Heading` ( 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', `print_heading` varchar(140), `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-23 23:52:03,440 WARNING database DDL Query made to DB: create table `tabPrint Format Field 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', `document_type` varchar(140), `field` varchar(140), `template_file` varchar(140), `module` varchar(140), `standard` int(1) not null default 0, `template` 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-23 23:52:03,523 WARNING database DDL Query made to DB: create table `tabLetter Head` ( 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', `letter_head_name` varchar(140) unique, `source` varchar(140), `footer_source` varchar(140) default 'HTML', `disabled` int(1) not null default 0, `is_default` int(1) not null default 0, `image` text, `image_height` decimal(21,9) not null default 0, `image_width` decimal(21,9) not null default 0, `align` varchar(140) default 'Left', `content` longtext, `footer` longtext, `footer_image` text, `footer_image_height` decimal(21,9) not null default 0, `footer_image_width` decimal(21,9) not null default 0, `footer_align` varchar(140), `header_script` longtext, `footer_script` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `is_default`(`is_default`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:03,762 WARNING database DDL Query made to DB: create table `tabAddress` ( 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', `address_title` varchar(140), `address_type` varchar(140), `address_line1` varchar(240), `address_line2` varchar(240), `city` varchar(140), `county` varchar(140), `state` varchar(140), `country` varchar(140), `pincode` varchar(140), `email_id` varchar(140), `phone` varchar(140), `fax` varchar(140), `is_primary_address` int(1) not null default 0, `is_shipping_address` int(1) not null default 0, `disabled` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `city`(`city`), index `country`(`country`), index `pincode`(`pincode`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:03,991 WARNING database DDL Query made to DB: create table `tabAddress 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', `country` varchar(140) unique, `is_default` int(1) not null default 0, `template` 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-23 23:52:04,050 WARNING database DDL Query made to DB: create table `tabSalutation` ( 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', `salutation` 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-23 23:52:04,108 WARNING database DDL Query made to DB: create table `tabGender` ( 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', `gender` 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-23 23:52:04,164 WARNING database DDL Query made to DB: create table `tabContact Email` ( 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_id` varchar(140), `is_primary` 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-23 23:52:04,252 WARNING database DDL Query made to DB: create table `tabContact` ( 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', `first_name` varchar(140), `middle_name` varchar(140), `last_name` varchar(140), `full_name` varchar(140), `email_id` varchar(140), `user` varchar(140), `address` varchar(140), `sync_with_google_contacts` int(1) not null default 0, `status` varchar(140) default 'Passive', `salutation` varchar(140), `designation` varchar(140), `gender` varchar(140), `phone` varchar(140), `mobile_no` varchar(140), `company_name` varchar(140), `image` text, `google_contacts` varchar(140), `google_contacts_id` varchar(140), `pulled_from_google_contacts` int(1) not null default 0, `is_primary_contact` int(1) not null default 0, `department` varchar(140), `unsubscribed` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `email_id`(`email_id`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:04,347 WARNING database DDL Query made to DB: create table `tabContact Phone` ( 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', `phone` varchar(140), `is_primary_phone` int(1) not null default 0, `is_primary_mobile_no` 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-23 23:52:04,439 WARNING database DDL Query made to DB: create table `tabReview Level` ( 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', `level_name` varchar(140) unique, `role` varchar(140) unique, `review_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-23 23:52:04,632 WARNING database DDL Query made to DB: create table `tabEnergy Point 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', `enabled` int(1) not null default 1, `rule_name` varchar(140) unique, `reference_doctype` varchar(140), `for_doc_event` varchar(140) default 'Custom', `field_to_check` varchar(140), `points` int(11) not null default 0, `for_assigned_users` int(1) not null default 0, `user_field` varchar(140), `multiplier_field` varchar(140), `max_points` int(11) not null default 0, `apply_only_once` int(1) not null default 0, `condition` 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-23 23:52:04,744 WARNING database DDL Query made to DB: create table `tabEnergy Point 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', `user` varchar(140), `type` varchar(140), `points` int(11) not null default 0, `rule` varchar(140), `reference_doctype` varchar(140), `reference_name` varchar(140), `reverted` int(1) not null default 0, `revert_of` varchar(140), `reason` text, `seen` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `user`(`user`), index `reference_name`(`reference_name`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:04,805 WARNING database DDL Query made to DB: create table `tabAssignment Rule 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', `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-23 23:52:04,998 WARNING database DDL Query made to DB: create table `tabReminder` ( 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', `user` varchar(140), `remind_at` datetime(6), `description` text, `reminder_doctype` varchar(140), `reminder_docname` varchar(140), `notified` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `user`(`user`), index `remind_at`(`remind_at`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:05,056 WARNING database DDL Query made to DB: create table `tabMilestone Tracker` ( 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) unique, `track_field` 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-23 23:52:05,122 WARNING database DDL Query made to DB: create table `tabMilestone` ( 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), `track_field` varchar(140), `value` varchar(140), `milestone_tracker` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `reference_type`(`reference_type`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:05,160 WARNING database DDL Query made to DB: ALTER TABLE `tabMilestone` ADD INDEX IF NOT EXISTS `reference_type_reference_name_index`(reference_type, reference_name) 2025-06-23 23:52:05,203 WARNING database DDL Query made to DB: create table `tabAssignment Rule Day` ( 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` 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-23 23:52:05,281 WARNING database DDL Query made to DB: create table `tabAuto Repeat` ( 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_document` varchar(140), `submit_on_creation` int(1) not null default 0, `start_date` date, `end_date` date, `disabled` int(1) not null default 0, `frequency` varchar(140), `repeat_on_day` int(11) not null default 0, `repeat_on_last_day` int(1) not null default 0, `next_schedule_date` date, `notify_by_email` int(1) not null default 0, `recipients` text, `template` varchar(140), `subject` varchar(140), `message` text default 'Please find attached {{ doc.doctype }} #{{ doc.name }}', `print_format` varchar(140), `status` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `next_schedule_date`(`next_schedule_date`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:05,359 WARNING database DDL Query made to DB: create table `tabAssignment 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', `document_type` varchar(140), `due_date_based_on` varchar(140), `priority` int(11) not null default 0, `disabled` int(1) not null default 0, `description` text default 'Automatic Assignment', `assign_condition` longtext, `unassign_condition` longtext, `close_condition` longtext, `rule` varchar(140), `field` varchar(140), `last_user` 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-23 23:52:05,414 WARNING database DDL Query made to DB: create table `tabAuto Repeat Day` ( 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` 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-23 23:52:21,156 WARNING database DDL Query made to DB: create table `tabCampaign 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', `campaign` 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-23 23:52:21,224 WARNING database DDL Query made to DB: create table `tabPayment Entry Deduction` ( 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), `cost_center` varchar(140), `amount` decimal(21,9) not null default 0, `is_exchange_gain_loss` int(1) not null default 0, `description` 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-23 23:52:21,305 WARNING database DDL Query made to DB: create table `tabBank` ( 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', `bank_name` varchar(140) unique, `swift_number` varchar(140) unique, `website` varchar(140), `plaid_access_token` 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-23 23:52:21,365 WARNING database DDL Query made to DB: create table `tabPOS Invoice 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', `pos_invoice` varchar(140), `posting_date` date, `customer` varchar(140), `grand_total` decimal(21,9) not null default 0, `is_return` int(1) not null default 0, `return_against` 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-23 23:52:21,437 WARNING database DDL Query made to DB: create table `tabSubscription Plan` ( 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_name` varchar(140) unique, `currency` varchar(140), `item` varchar(140), `price_determination` varchar(140), `cost` decimal(21,9) not null default 0, `price_list` varchar(140), `billing_interval` varchar(140) default 'Day', `billing_interval_count` int(11) not null default 1, `product_price_id` varchar(140), `payment_gateway` 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-23 23:52:21,550 WARNING database DDL Query made to DB: create table `tabAccounting Dimension 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', `company` varchar(140), `reference_document` varchar(140), `default_dimension` varchar(140), `mandatory_for_bs` int(1) not null default 0, `mandatory_for_pl` int(1) not null default 0, `automatically_post_balancing_accounting_entry` int(1) not null default 0, `offsetting_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-23 23:52:21,603 WARNING database DDL Query made to DB: create table `tabMonthly Distribution 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', `month` varchar(140), `percentage_allocation` 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-23 23:52:21,654 WARNING database DDL Query made to DB: create table `tabShipping Rule Country` ( 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', `country` 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-23 23:52:21,726 WARNING database DDL Query made to DB: create table `tabProcess Payment Reconciliation Log Allocations` ( 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), `reference_row` varchar(140), `invoice_type` varchar(140), `invoice_number` varchar(140), `allocated_amount` decimal(21,9) not null default 0, `unreconciled_amount` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `is_advance` varchar(140), `difference_amount` decimal(21,9) not null default 0, `gain_loss_posting_date` date, `difference_account` varchar(140), `exchange_rate` decimal(21,9) not null default 0, `currency` varchar(140), `reconciled` 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-23 23:52:21,783 WARNING database DDL Query made to DB: create table `tabAdvance Tax` ( 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), `reference_detail` varchar(140), `account_head` varchar(140), `allocated_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-23 23:52:21,837 WARNING database DDL Query made to DB: create table `tabPOS Opening Entry 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', `mode_of_payment` varchar(140), `opening_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-23 23:52:21,908 WARNING database DDL Query made to DB: create table `tabAdvance 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', `add_deduct_tax` varchar(140), `charge_type` varchar(140), `row_id` varchar(140), `account_head` varchar(140), `description` text, `included_in_paid_amount` int(1) not null default 0, `cost_center` varchar(140), `rate` decimal(21,9) not null default 0, `currency` varchar(140), `tax_amount` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `allocated_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, 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-23 23:52:21,979 WARNING database DDL Query made to DB: create table `tabLoyalty Program` ( 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', `loyalty_program_name` varchar(140) unique, `loyalty_program_type` varchar(140), `from_date` date, `to_date` date, `customer_group` varchar(140), `customer_territory` varchar(140), `auto_opt_in` int(1) not null default 0, `conversion_factor` decimal(21,9) not null default 0, `expiry_duration` int(11) not null default 0, `expense_account` varchar(140), `company` 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-23 23:52:22,062 WARNING database DDL Query made to DB: create table `tabPayment Terms Template 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_term` varchar(140), `description` text, `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, 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-23 23:52:22,115 WARNING database DDL Query made to DB: create table `tabPOS Search Fields` ( 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', `field` varchar(140), `fieldname` 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-23 23:52:22,224 WARNING database DDL Query made to DB: create table `tabOpening Invoice Creation Tool 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', `invoice_number` varchar(140), `party_type` varchar(140), `party` varchar(140), `temporary_opening_account` varchar(140), `posting_date` date, `due_date` date, `item_name` varchar(140) default 'Opening Invoice Item', `outstanding_amount` decimal(21,9) not null default 0, `qty` varchar(140) default '1', `cost_center` 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-23 23:52:22,285 WARNING database DDL Query made to DB: create table `tabAccounting Dimension` ( 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), `label` varchar(140) unique, `fieldname` varchar(140), `disabled` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `document_type`(`document_type`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:22,415 WARNING database DDL Query made to DB: create table `tabCoupon 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', `coupon_name` varchar(140) unique, `coupon_type` varchar(140), `customer` varchar(140), `coupon_code` varchar(140) unique, `pricing_rule` varchar(140), `valid_from` date, `valid_upto` date, `maximum_use` int(11) not null default 0, `used` int(11) not null default 0, `description` 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-23 23:52:22,491 WARNING database DDL Query made to DB: create table `tabPOS Invoice Merge 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', `posting_date` date, `posting_time` time(6), `merge_invoices_based_on` varchar(140), `pos_closing_entry` varchar(140), `customer` varchar(140), `customer_group` varchar(140), `consolidated_invoice` varchar(140), `consolidated_credit_note` 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-23 23:52:22,574 WARNING database DDL Query made to DB: create table `tabShipping 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', `label` varchar(140) unique, `disabled` int(1) not null default 0, `shipping_rule_type` varchar(140), `company` varchar(140), `account` varchar(140), `cost_center` varchar(140), `calculate_based_on` varchar(140) default 'Fixed', `shipping_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-23 23:52:22,638 WARNING database DDL Query made to DB: create table `tabPSOA 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_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-23 23:52:22,696 WARNING database DDL Query made to DB: create table `tabPOS Closing Entry Taxes` ( 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_head` varchar(140), `rate` 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-23 23:52:22,753 WARNING database DDL Query made to DB: create table `tabBank Account 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', `account_type` 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-23 23:52:22,815 WARNING database DDL Query made to DB: create table `tabParty 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), `advance_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-23 23:52:22,987 WARNING database DDL Query made to DB: create table `tabGL 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, `transaction_date` date, `fiscal_year` varchar(140), `due_date` date, `account` varchar(140), `account_currency` varchar(140), `against` text, `party_type` varchar(140), `party` varchar(140), `voucher_type` varchar(140), `voucher_no` varchar(140), `voucher_subtype` text, `transaction_currency` varchar(140), `against_voucher_type` varchar(140), `against_voucher` varchar(140), `voucher_detail_no` varchar(140), `transaction_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, `debit_in_transaction_currency` 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, `credit_in_transaction_currency` decimal(21,9) not null default 0, `cost_center` varchar(140), `project` varchar(140), `finance_book` varchar(140), `company` varchar(140), `is_opening` varchar(140), `is_advance` varchar(140), `to_rename` int(1) not null default 1, `is_cancelled` int(1) not null default 0, `remarks` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `posting_date`(`posting_date`), index `account`(`account`), index `party_type`(`party_type`), index `party`(`party`), index `voucher_no`(`voucher_no`), index `against_voucher`(`against_voucher`), index `voucher_detail_no`(`voucher_detail_no`), index `company`(`company`), index `to_rename`(`to_rename`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:23,076 WARNING database DDL Query made to DB: ALTER TABLE `tabGL Entry` ADD INDEX IF NOT EXISTS `voucher_type_voucher_no_index`(voucher_type, voucher_no) 2025-06-23 23:52:23,098 WARNING database DDL Query made to DB: ALTER TABLE `tabGL Entry` ADD INDEX IF NOT EXISTS `posting_date_company_index`(posting_date, company) 2025-06-23 23:52:23,120 WARNING database DDL Query made to DB: ALTER TABLE `tabGL Entry` ADD INDEX IF NOT EXISTS `party_type_party_index`(party_type, party) 2025-06-23 23:52:23,157 WARNING database DDL Query made to DB: create table `tabItem Tax Template 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', `tax_type` varchar(140), `tax_rate` 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-23 23:52:23,219 WARNING database DDL Query made to DB: create table `tabCurrency Exchange Settings Details` ( 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), `value` 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-23 23:52:23,359 WARNING database DDL Query made to DB: create table `tabRepost Payment 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-23 23:52:23,415 WARNING database DDL Query made to DB: create table `tabPOS Closing Entry 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', `mode_of_payment` varchar(140), `opening_amount` decimal(21,9) not null default 0, `expected_amount` decimal(21,9) not null default 0, `closing_amount` decimal(21,9) not null default 0, `difference` 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-23 23:52:23,489 WARNING database DDL Query made to DB: create table `tabExchange Rate Revaluation 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), `party_type` varchar(140), `party` varchar(140), `account_currency` varchar(140), `balance_in_account_currency` decimal(21,9) not null default 0, `new_balance_in_account_currency` decimal(21,9) not null default 0, `current_exchange_rate` decimal(21,9) not null default 0, `new_exchange_rate` decimal(21,9) not null default 0, `balance_in_base_currency` decimal(21,9) not null default 0, `new_balance_in_base_currency` decimal(21,9) not null default 0, `gain_loss` decimal(21,9) not null default 0, `zero_balance` 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-23 23:52:23,546 WARNING database DDL Query made to DB: create table `tabTransaction Deletion Record Details` ( 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', `doctype_name` varchar(140), `docfield_name` varchar(140), `no_of_docs` int(11) not null default 0, `done` 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-23 23:52:23,603 WARNING database DDL Query made to DB: create table `tabFinance Book` ( 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', `finance_book_name` 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-23 23:52:23,667 WARNING database DDL Query made to DB: create table `tabShare 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', `title` varchar(140) unique, `description` 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-23 23:52:23,747 WARNING database DDL Query made to DB: create table `tabLoyalty Point 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', `loyalty_program` varchar(140), `loyalty_program_tier` varchar(140), `customer` varchar(140), `invoice_type` varchar(140), `invoice` varchar(140), `redeem_against` varchar(140), `loyalty_points` int(11) not null default 0, `purchase_amount` decimal(21,9) not null default 0, `expiry_date` date, `posting_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-23 23:52:23,828 WARNING database DDL Query made to DB: create table `tabPurchase 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', `category` varchar(140) default 'Total', `add_deduct_tax` varchar(140) default 'Add', `charge_type` varchar(140) default 'On Net Total', `row_id` varchar(140), `included_in_print_rate` int(1) not null default 0, `included_in_paid_amount` int(1) not null default 0, `account_head` varchar(140), `description` text, `is_tax_withholding_account` int(1) not null default 0, `rate` decimal(21,9) not null default 0, `cost_center` varchar(140), `account_currency` varchar(140), `tax_amount` decimal(21,9) not null default 0, `tax_amount_after_discount_amount` decimal(21,9) not null default 0, `total` 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, 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-23 23:52:23,879 WARNING database DDL Query made to DB: create table `tabTerritory 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', `territory` 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-23 23:52:23,940 WARNING database DDL Query made to DB: create table `tabPurchase 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-23 23:52:23,993 WARNING database DDL Query made to DB: create table `tabLedger Merge 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', `account` varchar(140), `account_name` varchar(140), `merged` 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-23 23:52:24,049 WARNING database DDL Query made to DB: create table `tabShipping Rule Condition` ( 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_value` decimal(21,9) not null default 0, `to_value` decimal(21,9) not null default 0, `shipping_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-23 23:52:24,102 WARNING database DDL Query made to DB: create table `tabCustomer 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', `customer` 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-23 23:52:24,188 WARNING database DDL Query made to DB: create table `tabBank 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_name` varchar(140), `account` varchar(140), `bank` varchar(140), `account_type` varchar(140), `account_subtype` varchar(140), `disabled` int(1) not null default 0, `is_default` int(1) not null default 0, `is_company_account` int(1) not null default 0, `company` varchar(140), `party_type` varchar(140), `party` varchar(140), `iban` varchar(30), `branch_code` varchar(140), `bank_account_no` varchar(30), `integration_id` varchar(140) unique, `last_integration_date` date, `mask` 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-23 23:52:24,274 WARNING database DDL Query made to DB: create table `tabBank Guarantee` ( 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', `bg_type` varchar(140), `reference_doctype` varchar(140), `reference_docname` varchar(140), `customer` varchar(140), `supplier` varchar(140), `project` varchar(140), `amount` decimal(21,9) not null default 0, `start_date` date, `validity` int(11) not null default 0, `end_date` date, `bank` varchar(140), `bank_account` varchar(140), `account` varchar(140), `bank_account_no` varchar(140), `iban` varchar(140), `branch_code` varchar(140), `swift_number` varchar(140), `more_information` longtext, `bank_guarantee_number` varchar(140) unique, `name_of_beneficiary` varchar(140), `margin_money` decimal(21,9) not null default 0, `charges` decimal(21,9) not null default 0, `fixed_deposit_number` 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-23 23:52:24,333 WARNING database DDL Query made to DB: create table `tabCustomer 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', `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-23 23:52:24,382 WARNING database DDL Query made to DB: create table `tabSupplier 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', `supplier_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-23 23:52:24,442 WARNING database DDL Query made to DB: create table `tabMonthly Distribution` ( 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', `distribution_id` varchar(140) unique, `fiscal_year` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `fiscal_year`(`fiscal_year`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:24,676 WARNING database DDL Query made to DB: create table `tabPOS 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` varchar(140), `tax_id` varchar(140), `pos_profile` varchar(140), `consolidated_invoice` varchar(140), `is_pos` int(1) not null default 1, `is_return` int(1) not null default 0, `update_billed_amount_in_sales_order` int(1) not null default 0, `update_billed_amount_in_delivery_note` int(1) not null default 1, `company` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `due_date` date, `amended_from` varchar(140), `return_against` varchar(140), `project` varchar(140), `cost_center` varchar(140), `po_no` varchar(140), `po_date` date, `customer_address` varchar(140), `address_display` text, `contact_person` varchar(140), `contact_display` text, `contact_mobile` varchar(140), `contact_email` varchar(140), `territory` varchar(140), `shipping_address_name` varchar(140), `shipping_address` text, `company_address` varchar(140), `company_address_display` text, `company_contact_person` 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, `set_warehouse` varchar(140), `update_stock` int(1) not null default 0, `scan_barcode` varchar(140), `total_billing_amount` decimal(21,9) not null default 0, `total_qty` 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, `total_net_weight` decimal(21,9) not null default 0, `taxes_and_charges` varchar(140), `shipping_rule` varchar(140), `tax_category` varchar(140), `other_charges_calculation` longtext, `base_total_taxes_and_charges` decimal(21,9) not null default 0, `total_taxes_and_charges` decimal(21,9) not null default 0, `loyalty_points` int(11) not null default 0, `loyalty_amount` decimal(21,9) not null default 0, `redeem_loyalty_points` int(1) not null default 0, `loyalty_program` varchar(140), `loyalty_redemption_account` varchar(140), `loyalty_redemption_cost_center` varchar(140), `coupon_code` varchar(140), `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, `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(140), `grand_total` decimal(21,9) not null default 0, `rounding_adjustment` decimal(21,9) not null default 0, `rounded_total` decimal(21,9) not null default 0, `in_words` varchar(140), `total_advance` decimal(21,9) not null default 0, `outstanding_amount` decimal(21,9) not null default 0, `allocate_advances_automatically` int(1) not null default 0, `payment_terms_template` varchar(140), `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), `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), `tc_name` varchar(140), `terms` longtext, `letter_head` varchar(140), `group_same_items` int(1) not null default 0, `language` varchar(140), `select_print_heading` varchar(140), `inter_company_invoice_reference` varchar(140), `customer_group` varchar(140), `campaign` varchar(140), `is_discounted` int(1) not null default 0, `status` varchar(140) default 'Draft', `source` varchar(140), `debit_to` varchar(140), `party_account_currency` varchar(140), `is_opening` varchar(140) default 'No', `remarks` 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, `from_date` date, `to_date` date, `auto_repeat` varchar(140), `against_income_account` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `customer`(`customer`), index `posting_date`(`posting_date`), index `return_against`(`return_against`), index `debit_to`(`debit_to`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:24,768 WARNING database DDL Query made to DB: create table `tabParty Link` ( 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', `primary_role` varchar(140), `secondary_role` varchar(140), `primary_party` varchar(140), `secondary_party` 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-23 23:52:24,840 WARNING database DDL Query made to DB: create table `tabPayment Order` ( 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 'PMO-', `company` varchar(140), `payment_order_type` varchar(140), `party` varchar(140), `posting_date` date, `company_bank` varchar(140), `company_bank_account` varchar(140), `account` 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-23 23:52:24,921 WARNING database DDL Query made to DB: create table `tabBudget` ( 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', `budget_against` varchar(140) default 'Cost Center', `company` varchar(140), `cost_center` varchar(140), `naming_series` varchar(140), `project` varchar(140), `fiscal_year` varchar(140), `monthly_distribution` varchar(140), `amended_from` varchar(140), `applicable_on_material_request` int(1) not null default 0, `action_if_annual_budget_exceeded_on_mr` varchar(140) default 'Stop', `action_if_accumulated_monthly_budget_exceeded_on_mr` varchar(140) default 'Warn', `applicable_on_purchase_order` int(1) not null default 0, `action_if_annual_budget_exceeded_on_po` varchar(140) default 'Stop', `action_if_accumulated_monthly_budget_exceeded_on_po` varchar(140) default 'Warn', `applicable_on_booking_actual_expenses` int(1) not null default 0, `action_if_annual_budget_exceeded` varchar(140) default 'Stop', `action_if_accumulated_monthly_budget_exceeded` varchar(140) default 'Warn', `_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-23 23:52:24,982 WARNING database DDL Query made to DB: create table `tabPOS Field` ( 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', `fieldname` varchar(140), `label` varchar(140), `fieldtype` varchar(140), `options` text, `default_value` varchar(140), `reqd` int(1) not null default 0, `read_only` 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-23 23:52:25,046 WARNING database DDL Query made to DB: create table `tabPayment Order 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), `amount` decimal(21,9) not null default 0, `supplier` varchar(140), `payment_request` varchar(140), `mode_of_payment` varchar(140), `bank_account` varchar(140), `account` varchar(140), `payment_reference` 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-23 23:52:25,122 WARNING database DDL Query made to DB: create table `tabAccount Closing 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', `closing_date` date, `account` varchar(140), `cost_center` varchar(140), `debit` decimal(21,9) not null default 0, `credit` decimal(21,9) not null default 0, `account_currency` varchar(140), `debit_in_account_currency` decimal(21,9) not null default 0, `credit_in_account_currency` decimal(21,9) not null default 0, `project` varchar(140), `company` varchar(140), `finance_book` varchar(140), `period_closing_voucher` varchar(140), `is_period_closing_voucher_entry` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `closing_date`(`closing_date`), index `account`(`account`), index `company`(`company`), index `period_closing_voucher`(`period_closing_voucher`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:25,193 WARNING database DDL Query made to DB: create table `tabAccounting Dimension Filter` ( 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', `accounting_dimension` varchar(140), `disabled` int(1) not null default 0, `company` varchar(140), `apply_restriction_on_values` int(1) not null default 1, `allow_or_restrict` 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-23 23:52:25,254 WARNING database DDL Query made to DB: create table `tabAllowed Dimension` ( 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', `accounting_dimension` varchar(140), `dimension_value` 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-23 23:52:25,337 WARNING database DDL Query made to DB: create table `tabAccount` ( 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, `account_name` varchar(140), `account_number` varchar(140), `is_group` int(1) not null default 0, `company` varchar(140), `root_type` varchar(140), `report_type` varchar(140), `account_currency` varchar(140), `parent_account` varchar(140), `account_type` varchar(140), `tax_rate` decimal(21,9) not null default 0, `freeze_account` varchar(140), `balance_must_be` varchar(140), `lft` int(11) not null default 0, `rgt` int(11) not null default 0, `old_parent` varchar(140), `include_in_gross` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `parent_account`(`parent_account`), index `account_type`(`account_type`), index `lft`(`lft`), index `rgt`(`rgt`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:25,386 WARNING database DDL Query made to DB: ALTER TABLE `tabAccount` ADD INDEX IF NOT EXISTS `lft_rgt_index`(lft, rgt) 2025-06-23 23:52:25,443 WARNING database DDL Query made to DB: create table `tabPayment 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', `payment_term` varchar(140), `description` text, `due_date` date, `mode_of_payment` varchar(140), `invoice_portion` decimal(21,9) not null default 0, `discount_type` varchar(140) default 'Percentage', `discount_date` date, `discount` 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, `base_payment_amount` decimal(21,9) not null default 0, `base_outstanding` decimal(21,9) not null default 0, `base_paid_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-23 23:52:25,542 WARNING database DDL Query made to DB: create table `tabProcess Subscription` ( 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, `subscription` 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-23 23:52:25,604 WARNING database DDL Query made to DB: create table `tabBank Transaction Mapping` ( 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', `bank_transaction_field` varchar(140), `file_field` 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-23 23:52:25,746 WARNING database DDL Query made to DB: create table `tabPricing 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', `naming_series` varchar(140) default 'PRLE-.####', `title` varchar(140), `disable` int(1) not null default 0, `apply_on` varchar(140) default 'Item Code', `price_or_product_discount` varchar(140), `warehouse` varchar(140), `mixed_conditions` int(1) not null default 0, `is_cumulative` int(1) not null default 0, `coupon_code_based` 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), `customer` varchar(140), `customer_group` varchar(140), `territory` varchar(140), `sales_partner` varchar(140), `campaign` varchar(140), `supplier` varchar(140), `supplier_group` varchar(140), `min_qty` decimal(21,9) not null default 0, `max_qty` decimal(21,9) not null default 0, `min_amt` decimal(21,9) not null default 0, `max_amt` 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_rate` decimal(21,9) not null default 0, `free_item_uom` varchar(140), `round_free_qty` int(1) not null default 0, `dont_enforce_free_item_qty` int(1) not null default 0, `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, `valid_from` date, `valid_upto` date, `company` varchar(140), `currency` varchar(140), `margin_type` varchar(140) default 'Percentage', `margin_rate_or_amount` decimal(21,9) not null default 0, `rate_or_discount` varchar(140) default 'Discount Percentage', `apply_discount_on` varchar(140) default 'Grand Total', `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), `condition` longtext, `apply_multiple_pricing_rules` int(1) not null default 0, `apply_discount_on_rate` int(1) not null default 0, `threshold_percentage` decimal(21,9) not null default 0, `validate_applied_rule` int(1) not null default 0, `rule_description` text, `has_priority` int(1) not null default 0, `priority` varchar(140), `promotional_scheme_id` varchar(140), `promotional_scheme` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `warehouse`(`warehouse`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:25,817 WARNING database DDL Query made to DB: create table `tabMode of Payment 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), `default_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-23 23:52:25,880 WARNING database DDL Query made to DB: create table `tabProcess Deferred Accounting` ( 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), `type` varchar(140), `account` varchar(140), `posting_date` date, `start_date` date, `end_date` 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-23 23:52:25,975 WARNING database DDL Query made to DB: create table `tabBank Transaction` ( 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 'ACC-BTN-.YYYY.-', `date` date, `status` varchar(140) default 'Pending', `bank_account` varchar(140), `company` varchar(140), `amended_from` varchar(140), `deposit` decimal(21,9) not null default 0, `withdrawal` decimal(21,9) not null default 0, `currency` varchar(140), `description` text, `reference_number` varchar(140), `transaction_id` varchar(140) unique, `transaction_type` varchar(50), `allocated_amount` decimal(21,9) not null default 0, `unallocated_amount` decimal(21,9) not null default 0, `party_type` varchar(140), `party` varchar(140), `bank_party_name` varchar(140), `bank_party_account_number` varchar(140), `bank_party_iban` 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-23 23:52:26,039 WARNING database DDL Query made to DB: create table `tabLedger Health Monitor 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-23 23:52:26,096 WARNING database DDL Query made to DB: create table `tabPricing Rule Item 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', `item_group` varchar(140), `uom` varchar(140), index `item_group`(`item_group`), 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-23 23:52:26,174 WARNING database DDL Query made to DB: create table `tabProcess Payment Reconciliation` ( 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), `party_type` varchar(140), `party` varchar(140), `receivable_payable_account` varchar(140), `default_advance_account` varchar(140), `from_invoice_date` date, `to_invoice_date` date, `from_payment_date` date, `to_payment_date` date, `cost_center` varchar(140), `bank_cash_account` varchar(140), `status` varchar(140), `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-23 23:52:26,243 WARNING database DDL Query made to DB: create table `tabSales Invoice 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', `activity_type` varchar(140), `description` text, `from_time` datetime(6), `to_time` datetime(6), `billing_hours` decimal(21,9) not null default 0, `billing_amount` decimal(21,9) not null default 0, `time_sheet` varchar(140), `timesheet_detail` varchar(140), `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-23 23:52:26,301 WARNING database DDL Query made to DB: create table `tabLoyalty Program Collection` ( 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', `tier_name` varchar(140), `min_spent` decimal(21,9) not null default 0, `collection_factor` 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-23 23:52:26,354 WARNING database DDL Query made to DB: create table `tabPOS Item 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', `item_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-23 23:52:26,456 WARNING database DDL Query made to DB: create sequence if not exists ledger_health_id_seq nocache nocycle 2025-06-23 23:52:26,469 WARNING database DDL Query made to DB: create table `tabLedger Health` ( 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', `voucher_type` varchar(140), `voucher_no` varchar(140), `checked_on` datetime(6), `debit_credit_mismatch` int(1) not null default 0, `general_and_payment_ledger_mismatch` 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-23 23:52:26,541 WARNING database DDL Query made to DB: create table `tabCost 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_name` varchar(140), `cost_center_number` varchar(140), `parent_cost_center` varchar(140), `company` varchar(140), `is_group` int(1) not null default 0, `disabled` int(1) not null default 0, `lft` int(11) not null default 0, `rgt` int(11) not null default 0, `old_parent` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `lft`(`lft`), index `rgt`(`rgt`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:52:26,598 WARNING database DDL Query made to DB: ALTER TABLE `tabCost Center` ADD INDEX IF NOT EXISTS `lft_rgt_index`(lft, rgt) 2025-06-23 23:52:26,639 WARNING database DDL Query made to DB: create table `tabTax 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', `title` varchar(140) unique, `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-23 23:52:26,709 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-23 23:52:26,998 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-23 23:52:27,191 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-23 23:52:27,256 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-23 23:52:27,317 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-23 23:52:27,418 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-23 23:52:27,486 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-23 23:52:27,582 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-23 23:52:27,653 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-23 23:52:27,716 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