3112 lines
97 KiB
Text
3112 lines
97 KiB
Text
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
|