3128 lines
97 KiB
Text
3128 lines
97 KiB
Text
2025-06-23 23:52:27,792 WARNING database DDL Query made to DB:
|
|
create table `tabPromotional Scheme Price Discount` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`disable` int(1) not null default 0,
|
|
`apply_multiple_pricing_rules` int(1) not null default 0,
|
|
`rule_description` text,
|
|
`min_qty` decimal(21,9) not null default 0,
|
|
`max_qty` decimal(21,9) not null default 0,
|
|
`min_amount` decimal(21,9) not null default 0,
|
|
`max_amount` decimal(21,9) not null default 0,
|
|
`rate_or_discount` varchar(140) default 'Discount Percentage',
|
|
`rate` decimal(21,9) not null default 0,
|
|
`discount_amount` decimal(21,9) not null default 0,
|
|
`discount_percentage` decimal(21,9) not null default 0,
|
|
`for_price_list` varchar(140),
|
|
`warehouse` varchar(140),
|
|
`threshold_percentage` decimal(21,9) not null default 0,
|
|
`validate_applied_rule` int(1) not null default 0,
|
|
`priority` varchar(140),
|
|
`apply_discount_on_rate` int(1) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:27,846 WARNING database DDL Query made to DB:
|
|
create table `tabAllowed To Transact With` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:27,907 WARNING database DDL Query made to DB:
|
|
create table `tabBank Transaction Payments` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`payment_document` varchar(140),
|
|
`payment_entry` varchar(140),
|
|
`allocated_amount` decimal(21,9) not null default 0,
|
|
`clearance_date` date,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:27,979 WARNING database DDL Query made to DB:
|
|
create table `tabShareholder` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`title` varchar(140),
|
|
`naming_series` varchar(140),
|
|
`folio_no` varchar(140) unique,
|
|
`company` varchar(140),
|
|
`is_company` int(1) not null default 0,
|
|
`contact_list` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,044 WARNING database DDL Query made to DB:
|
|
create table `tabPricing Rule Brand` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`brand` varchar(140),
|
|
`uom` varchar(140),
|
|
index `brand`(`brand`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,115 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Opening Entry` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`period_start_date` datetime(6),
|
|
`period_end_date` date,
|
|
`status` varchar(140) default 'Draft',
|
|
`posting_date` date,
|
|
`set_posting_date` int(1) not null default 0,
|
|
`company` varchar(140),
|
|
`pos_profile` varchar(140),
|
|
`pos_closing_entry` varchar(140),
|
|
`user` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,178 WARNING database DDL Query made to DB:
|
|
create table `tabTax Withheld Vouchers` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`voucher_type` varchar(140),
|
|
`voucher_name` varchar(140),
|
|
`taxable_amount` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,261 WARNING database DDL Query made to DB:
|
|
create table `tabSales Taxes and Charges` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`charge_type` varchar(140),
|
|
`row_id` varchar(140),
|
|
`account_head` varchar(140),
|
|
`description` text,
|
|
`included_in_print_rate` int(1) not null default 0,
|
|
`included_in_paid_amount` int(1) not null default 0,
|
|
`cost_center` varchar(140),
|
|
`rate` decimal(21,9) not null default 0,
|
|
`account_currency` varchar(140),
|
|
`tax_amount` decimal(21,9) not null default 0,
|
|
`total` decimal(21,9) not null default 0,
|
|
`tax_amount_after_discount_amount` decimal(21,9) not null default 0,
|
|
`base_tax_amount` decimal(21,9) not null default 0,
|
|
`base_total` decimal(21,9) not null default 0,
|
|
`base_tax_amount_after_discount_amount` decimal(21,9) not null default 0,
|
|
`item_wise_tax_detail` longtext,
|
|
`dont_recompute_tax` int(1) not null default 0,
|
|
index `account_head`(`account_head`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,323 WARNING database DDL Query made to DB:
|
|
create table `tabSubscription Plan Detail` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`plan` varchar(140),
|
|
`qty` int(11) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,390 WARNING database DDL Query made to DB:
|
|
create table `tabJournal Entry Template` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`template_title` varchar(140) unique,
|
|
`voucher_type` varchar(140),
|
|
`naming_series` varchar(140),
|
|
`company` varchar(140),
|
|
`is_opening` varchar(140) default 'No',
|
|
`multi_currency` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,458 WARNING database DDL Query made to DB:
|
|
create table `tabTax Withholding Rate` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`from_date` date,
|
|
`to_date` date,
|
|
`tax_withholding_rate` decimal(21,9) not null default 0,
|
|
`single_threshold` decimal(21,9) not null default 0,
|
|
`cumulative_threshold` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,541 WARNING database DDL Query made to DB:
|
|
create table `tabShare Transfer` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`transfer_type` varchar(140),
|
|
`date` date,
|
|
`from_shareholder` varchar(140),
|
|
`from_folio_no` varchar(140),
|
|
`to_shareholder` varchar(140),
|
|
`to_folio_no` varchar(140),
|
|
`equity_or_liability_account` varchar(140),
|
|
`asset_account` varchar(140),
|
|
`share_type` varchar(140),
|
|
`from_no` int(11) not null default 0,
|
|
`rate` decimal(21,9) not null default 0,
|
|
`no_of_shares` int(11) not null default 0,
|
|
`to_no` int(11) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`company` varchar(140),
|
|
`remarks` longtext,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,624 WARNING database DDL Query made to DB:
|
|
create table `tabOverdue Payment` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`sales_invoice` varchar(140),
|
|
`payment_schedule` varchar(140),
|
|
`dunning_level` int(11) not null default 1,
|
|
`payment_term` varchar(140),
|
|
`description` text,
|
|
`due_date` date,
|
|
`overdue_days` varchar(140),
|
|
`mode_of_payment` varchar(140),
|
|
`invoice_portion` decimal(21,9) not null default 0,
|
|
`payment_amount` decimal(21,9) not null default 0,
|
|
`outstanding` decimal(21,9) not null default 0,
|
|
`paid_amount` decimal(21,9) not null default 0,
|
|
`discounted_amount` decimal(21,9) not null default 0,
|
|
`interest` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,678 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Payment Method` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`default` int(1) not null default 0,
|
|
`allow_in_returns` int(1) not null default 0,
|
|
`mode_of_payment` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,740 WARNING database DDL Query made to DB:
|
|
create table `tabBank Clearance Detail` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`payment_document` varchar(140),
|
|
`payment_entry` varchar(140),
|
|
`against_account` varchar(140),
|
|
`amount` varchar(140),
|
|
`posting_date` date,
|
|
`cheque_number` varchar(140),
|
|
`cheque_date` date,
|
|
`clearance_date` date,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,805 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Gateway Account` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`payment_gateway` varchar(140),
|
|
`payment_channel` varchar(140) default 'Email',
|
|
`is_default` int(1) not null default 0,
|
|
`payment_account` varchar(140),
|
|
`currency` varchar(140),
|
|
`message` text default 'Please click on the link below to make your payment',
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,863 WARNING database DDL Query made to DB:
|
|
create table `tabApplicable On Account` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`applicable_on_account` varchar(140),
|
|
`is_mandatory` int(1) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:28,950 WARNING database DDL Query made to DB:
|
|
create table `tabTax Rule` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`tax_type` varchar(140) default 'Sales',
|
|
`use_for_shopping_cart` int(1) not null default 1,
|
|
`sales_tax_template` varchar(140),
|
|
`purchase_tax_template` varchar(140),
|
|
`customer` varchar(140),
|
|
`supplier` varchar(140),
|
|
`item` varchar(140),
|
|
`billing_city` varchar(140),
|
|
`billing_county` varchar(140),
|
|
`billing_state` varchar(140),
|
|
`billing_zipcode` varchar(140),
|
|
`billing_country` varchar(140),
|
|
`tax_category` varchar(140),
|
|
`customer_group` varchar(140),
|
|
`supplier_group` varchar(140),
|
|
`item_group` varchar(140),
|
|
`shipping_city` varchar(140),
|
|
`shipping_county` varchar(140),
|
|
`shipping_state` varchar(140),
|
|
`shipping_zipcode` varchar(140),
|
|
`shipping_country` varchar(140),
|
|
`from_date` date,
|
|
`to_date` date,
|
|
`priority` int(11) not null default 1,
|
|
`company` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,042 WARNING database DDL Query made to DB:
|
|
create table `tabPromotional Scheme` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`apply_on` varchar(140) default 'Item Code',
|
|
`disable` int(1) not null default 0,
|
|
`mixed_conditions` int(1) not null default 0,
|
|
`is_cumulative` int(1) not null default 0,
|
|
`apply_rule_on_other` varchar(140),
|
|
`other_item_code` varchar(140),
|
|
`other_item_group` varchar(140),
|
|
`other_brand` varchar(140),
|
|
`selling` int(1) not null default 0,
|
|
`buying` int(1) not null default 0,
|
|
`applicable_for` varchar(140),
|
|
`valid_from` date,
|
|
`valid_upto` date,
|
|
`company` varchar(140),
|
|
`currency` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,142 WARNING database DDL Query made to DB:
|
|
create table `tabSubscription` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`party_type` varchar(140),
|
|
`party` varchar(140),
|
|
`company` varchar(140),
|
|
`status` varchar(140),
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`cancelation_date` date,
|
|
`trial_period_start` date,
|
|
`trial_period_end` date,
|
|
`follow_calendar_months` int(1) not null default 0,
|
|
`generate_new_invoices_past_due_date` int(1) not null default 0,
|
|
`submit_invoice` int(1) not null default 1,
|
|
`current_invoice_start` date,
|
|
`current_invoice_end` date,
|
|
`days_until_due` int(11) not null default 0,
|
|
`generate_invoice_at` varchar(140) default 'End of the current subscription period',
|
|
`number_of_days` int(11) not null default 0,
|
|
`cancel_at_period_end` int(1) not null default 0,
|
|
`sales_tax_template` varchar(140),
|
|
`purchase_tax_template` varchar(140),
|
|
`apply_additional_discount` varchar(140),
|
|
`additional_discount_percentage` decimal(21,9) not null default 0,
|
|
`additional_discount_amount` decimal(21,9) not null default 0,
|
|
`cost_center` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,206 WARNING database DDL Query made to DB:
|
|
create table `tabCurrency Exchange Settings Result` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`key` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,272 WARNING database DDL Query made to DB:
|
|
create table `tabDiscounted Invoice` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`sales_invoice` varchar(140),
|
|
`customer` varchar(140),
|
|
`posting_date` date,
|
|
`outstanding_amount` decimal(21,9) not null default 0,
|
|
`debit_to` varchar(140),
|
|
index `sales_invoice`(`sales_invoice`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,333 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Profile User` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`default` int(1) not null default 0,
|
|
`user` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,388 WARNING database DDL Query made to DB:
|
|
create table `tabTax Withholding Account` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
`account` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,462 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Entry Reference` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`reference_doctype` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`due_date` date,
|
|
`bill_no` varchar(140),
|
|
`payment_term` varchar(140),
|
|
`payment_term_outstanding` decimal(21,9) not null default 0,
|
|
`account_type` varchar(140),
|
|
`payment_type` varchar(140),
|
|
`reconcile_effect_on` date,
|
|
`total_amount` decimal(21,9) not null default 0,
|
|
`outstanding_amount` decimal(21,9) not null default 0,
|
|
`allocated_amount` decimal(21,9) not null default 0,
|
|
`exchange_rate` decimal(21,9) not null default 0,
|
|
`exchange_gain_loss` decimal(21,9) not null default 0,
|
|
`account` varchar(140),
|
|
`payment_request` varchar(140),
|
|
index `reference_doctype`(`reference_doctype`),
|
|
index `reference_name`(`reference_name`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,525 WARNING database DDL Query made to DB:
|
|
create table `tabSales Invoice Payment` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`default` int(1) not null default 0,
|
|
`mode_of_payment` varchar(140),
|
|
`amount` decimal(21,9) not null default 0,
|
|
`reference_no` varchar(140),
|
|
`account` varchar(140),
|
|
`type` varchar(140),
|
|
`base_amount` decimal(21,9) not null default 0,
|
|
`clearance_date` date,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,582 WARNING database DDL Query made to DB:
|
|
create table `tabCost Center Allocation Percentage` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`cost_center` varchar(140),
|
|
`percentage` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,683 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Ledger Entry` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`posting_date` date,
|
|
`company` varchar(140),
|
|
`account_type` varchar(140),
|
|
`account` varchar(140),
|
|
`party_type` varchar(140),
|
|
`party` varchar(140),
|
|
`due_date` date,
|
|
`voucher_detail_no` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`finance_book` varchar(140),
|
|
`voucher_type` varchar(140),
|
|
`voucher_no` varchar(140),
|
|
`against_voucher_type` varchar(140),
|
|
`against_voucher_no` varchar(140),
|
|
`amount` decimal(21,9) not null default 0,
|
|
`account_currency` varchar(140),
|
|
`amount_in_account_currency` decimal(21,9) not null default 0,
|
|
`delinked` int(1) not null default 0,
|
|
`remarks` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `posting_date`(`posting_date`),
|
|
index `company`(`company`),
|
|
index `account`(`account`),
|
|
index `party_type`(`party_type`),
|
|
index `party`(`party`),
|
|
index `voucher_detail_no`(`voucher_detail_no`),
|
|
index `voucher_type`(`voucher_type`),
|
|
index `voucher_no`(`voucher_no`),
|
|
index `against_voucher_type`(`against_voucher_type`),
|
|
index `against_voucher_no`(`against_voucher_no`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,732 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabPayment Ledger Entry`
|
|
ADD INDEX IF NOT EXISTS `against_voucher_no_against_voucher_type_index`(against_voucher_no, against_voucher_type)
|
|
2025-06-23 23:52:29,753 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabPayment Ledger Entry`
|
|
ADD INDEX IF NOT EXISTS `voucher_no_voucher_type_index`(voucher_no, voucher_type)
|
|
2025-06-23 23:52:29,797 WARNING database DDL Query made to DB:
|
|
create sequence if not exists bisect_nodes_id_seq nocache nocycle
|
|
2025-06-23 23:52:29,810 WARNING database DDL Query made to DB:
|
|
create table `tabBisect Nodes` (
|
|
name bigint primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`root` varchar(140),
|
|
`left_child` varchar(140),
|
|
`right_child` varchar(140),
|
|
`period_from_date` datetime(6),
|
|
`period_to_date` datetime(6),
|
|
`difference` decimal(21,9) not null default 0,
|
|
`balance_sheet_summary` decimal(21,9) not null default 0,
|
|
`profit_loss_summary` decimal(21,9) not null default 0,
|
|
`generated` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,864 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Customer Group` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`customer_group` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:29,933 WARNING database DDL Query made to DB:
|
|
create table `tabPeriod Closing Voucher` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`transaction_date` date,
|
|
`company` varchar(140),
|
|
`fiscal_year` varchar(140),
|
|
`period_start_date` date,
|
|
`period_end_date` date,
|
|
`amended_from` varchar(140),
|
|
`closing_account_head` varchar(140),
|
|
`gle_processing_status` varchar(140),
|
|
`remarks` text,
|
|
`error_message` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,001 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Terms Template` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`template_name` varchar(140) unique,
|
|
`allocate_payment_based_on_payment_terms` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,077 WARNING database DDL Query made to DB:
|
|
create table `tabRepost Allowed Types` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`document_type` varchar(140),
|
|
`allowed` int(1) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,134 WARNING database DDL Query made to DB:
|
|
create table `tabSales Partner Item` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`sales_partner` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,202 WARNING database DDL Query made to DB:
|
|
create table `tabRepost Accounting Ledger` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
`delete_cancelled_entries` int(1) not null default 0,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,277 WARNING database DDL Query made to DB:
|
|
create table `tabProcess Payment Reconciliation Log` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`process_pr` varchar(140),
|
|
`status` varchar(140),
|
|
`allocated` int(1) not null default 0,
|
|
`reconciled` int(1) not null default 0,
|
|
`total_allocations` int(11) not null default 0,
|
|
`reconciled_entries` int(11) not null default 0,
|
|
`error_log` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,348 WARNING database DDL Query made to DB:
|
|
create table `tabSales Invoice Advance` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`reference_type` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`remarks` text,
|
|
`reference_row` varchar(140),
|
|
`advance_amount` decimal(21,9) not null default 0,
|
|
`allocated_amount` decimal(21,9) not null default 0,
|
|
`exchange_gain_loss` decimal(21,9) not null default 0,
|
|
`ref_exchange_rate` decimal(21,9) not null default 0,
|
|
`difference_posting_date` date,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,418 WARNING database DDL Query made to DB:
|
|
create table `tabCashier Closing` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`naming_series` varchar(140) default 'POS-CLO-',
|
|
`user` varchar(140),
|
|
`date` date,
|
|
`from_time` time(6),
|
|
`time` time(6),
|
|
`expense` decimal(21,9) not null default 0,
|
|
`custody` decimal(21,9) not null default 0,
|
|
`returns` decimal(21,9) not null default 0,
|
|
`outstanding_amount` decimal(21,9) not null default 0,
|
|
`net_amount` decimal(21,9) not null default 0,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,478 WARNING database DDL Query made to DB:
|
|
create table `tabBudget Account` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`account` varchar(140),
|
|
`budget_amount` decimal(21,9) not null default 0,
|
|
index `account`(`account`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,548 WARNING database DDL Query made to DB:
|
|
create table `tabLedger Merge` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`root_type` varchar(140),
|
|
`account` varchar(140),
|
|
`account_name` varchar(140),
|
|
`company` varchar(140),
|
|
`status` varchar(140),
|
|
`is_group` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,846 WARNING database DDL Query made to DB:
|
|
create table `tabSales Invoice Item` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`barcode` varchar(140),
|
|
`has_item_scanned` int(1) not null default 0,
|
|
`item_code` varchar(140),
|
|
`item_name` varchar(140),
|
|
`customer_item_code` varchar(140),
|
|
`description` longtext,
|
|
`item_group` varchar(140),
|
|
`brand` varchar(140),
|
|
`image` text,
|
|
`qty` decimal(21,9) not null default 0,
|
|
`stock_uom` varchar(140),
|
|
`uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 0,
|
|
`stock_qty` decimal(21,9) not null default 0,
|
|
`price_list_rate` decimal(21,9) not null default 0,
|
|
`base_price_list_rate` decimal(21,9) not null default 0,
|
|
`margin_type` varchar(140),
|
|
`margin_rate_or_amount` decimal(21,9) not null default 0,
|
|
`rate_with_margin` decimal(21,9) not null default 0,
|
|
`discount_percentage` decimal(21,9) not null default 0,
|
|
`discount_amount` decimal(21,9) not null default 0,
|
|
`distributed_discount_amount` decimal(21,9) not null default 0,
|
|
`base_rate_with_margin` decimal(21,9) not null default 0,
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`item_tax_template` varchar(140),
|
|
`base_rate` decimal(21,9) not null default 0,
|
|
`base_amount` decimal(21,9) not null default 0,
|
|
`pricing_rules` text,
|
|
`stock_uom_rate` decimal(21,9) not null default 0,
|
|
`is_free_item` int(1) not null default 0,
|
|
`grant_commission` int(1) not null default 0,
|
|
`net_rate` decimal(21,9) not null default 0,
|
|
`net_amount` decimal(21,9) not null default 0,
|
|
`base_net_rate` decimal(21,9) not null default 0,
|
|
`base_net_amount` decimal(21,9) not null default 0,
|
|
`delivered_by_supplier` int(1) not null default 0,
|
|
`income_account` varchar(140),
|
|
`is_fixed_asset` int(1) not null default 0,
|
|
`asset` varchar(140),
|
|
`finance_book` varchar(140),
|
|
`expense_account` varchar(140),
|
|
`discount_account` varchar(140),
|
|
`deferred_revenue_account` varchar(140),
|
|
`service_stop_date` date,
|
|
`enable_deferred_revenue` int(1) not null default 0,
|
|
`service_start_date` date,
|
|
`service_end_date` date,
|
|
`weight_per_unit` decimal(21,9) not null default 0,
|
|
`total_weight` decimal(21,9) not null default 0,
|
|
`weight_uom` varchar(140),
|
|
`warehouse` varchar(140),
|
|
`target_warehouse` varchar(140),
|
|
`quality_inspection` varchar(140),
|
|
`serial_and_batch_bundle` varchar(140),
|
|
`use_serial_batch_fields` int(1) not null default 0,
|
|
`allow_zero_valuation_rate` int(1) not null default 0,
|
|
`incoming_rate` decimal(21,9) not null default 0,
|
|
`item_tax_rate` text,
|
|
`actual_batch_qty` decimal(21,9) not null default 0,
|
|
`serial_no` text,
|
|
`batch_no` varchar(140),
|
|
`actual_qty` decimal(21,9) not null default 0,
|
|
`company_total_stock` decimal(21,9) not null default 0,
|
|
`sales_order` varchar(140),
|
|
`so_detail` varchar(140),
|
|
`sales_invoice_item` varchar(140),
|
|
`delivery_note` varchar(140),
|
|
`dn_detail` varchar(140),
|
|
`delivered_qty` decimal(21,9) not null default 0,
|
|
`pos_invoice` varchar(140),
|
|
`pos_invoice_item` varchar(140),
|
|
`purchase_order` varchar(140),
|
|
`purchase_order_item` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`page_break` int(1) not null default 0,
|
|
index `item_code`(`item_code`),
|
|
index `serial_and_batch_bundle`(`serial_and_batch_bundle`),
|
|
index `batch_no`(`batch_no`),
|
|
index `sales_order`(`sales_order`),
|
|
index `so_detail`(`so_detail`),
|
|
index `delivery_note`(`delivery_note`),
|
|
index `dn_detail`(`dn_detail`),
|
|
index `pos_invoice`(`pos_invoice`),
|
|
index `purchase_order`(`purchase_order`),
|
|
index `project`(`project`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:30,928 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Term` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`payment_term_name` varchar(140) unique,
|
|
`invoice_portion` decimal(21,9) not null default 0,
|
|
`mode_of_payment` varchar(140),
|
|
`due_date_based_on` varchar(140),
|
|
`credit_days` int(11) not null default 0,
|
|
`credit_months` int(11) not null default 0,
|
|
`discount_type` varchar(140) default 'Percentage',
|
|
`discount` decimal(21,9) not null default 0,
|
|
`discount_validity_based_on` varchar(140) default 'Day(s) after invoice date',
|
|
`discount_validity` int(11) not null default 0,
|
|
`description` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,018 WARNING database DDL Query made to DB:
|
|
create table `tabPromotional Scheme Product Discount` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`disable` int(1) not null default 0,
|
|
`apply_multiple_pricing_rules` int(1) not null default 0,
|
|
`rule_description` text,
|
|
`min_qty` decimal(21,9) not null default 0,
|
|
`max_qty` decimal(21,9) not null default 0,
|
|
`min_amount` decimal(21,9) not null default 0,
|
|
`max_amount` decimal(21,9) not null default 0,
|
|
`same_item` int(1) not null default 0,
|
|
`free_item` varchar(140),
|
|
`free_qty` decimal(21,9) not null default 0,
|
|
`free_item_uom` varchar(140),
|
|
`free_item_rate` decimal(21,9) not null default 0,
|
|
`round_free_qty` int(1) not null default 0,
|
|
`warehouse` varchar(140),
|
|
`threshold_percentage` decimal(21,9) not null default 0,
|
|
`priority` varchar(140),
|
|
`is_recursive` int(1) not null default 0,
|
|
`recurse_for` decimal(21,9) not null default 0,
|
|
`apply_recursion_over` decimal(21,9) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,082 WARNING database DDL Query made to DB:
|
|
create table `tabMode of Payment` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`mode_of_payment` varchar(140) unique,
|
|
`enabled` int(1) not null default 1,
|
|
`type` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,148 WARNING database DDL Query made to DB:
|
|
create table `tabPricing Rule Item Code` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`item_code` varchar(140),
|
|
`uom` varchar(140),
|
|
index `item_code`(`item_code`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,215 WARNING database DDL Query made to DB:
|
|
create table `tabPricing Rule Detail` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`pricing_rule` varchar(140),
|
|
`item_code` varchar(140),
|
|
`margin_type` varchar(140),
|
|
`rate_or_discount` varchar(140),
|
|
`child_docname` varchar(140),
|
|
`rule_applied` int(1) not null default 1,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,278 WARNING database DDL Query made to DB:
|
|
create table `tabBank Account Subtype` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`account_subtype` varchar(140) unique,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,400 WARNING database DDL Query made to DB:
|
|
create table `tabProcess Statement Of Accounts` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`report` varchar(140),
|
|
`from_date` date,
|
|
`posting_date` date,
|
|
`company` varchar(140),
|
|
`account` varchar(140),
|
|
`categorize_by` varchar(140) default 'Categorize by Voucher (Consolidated)',
|
|
`territory` varchar(140),
|
|
`ignore_exchange_rate_revaluation_journals` int(1) not null default 0,
|
|
`ignore_cr_dr_notes` int(1) not null default 0,
|
|
`to_date` date,
|
|
`finance_book` varchar(140),
|
|
`currency` varchar(140),
|
|
`payment_terms_template` varchar(140),
|
|
`sales_partner` varchar(140),
|
|
`sales_person` varchar(140),
|
|
`show_remarks` int(1) not null default 0,
|
|
`based_on_payment_terms` int(1) not null default 0,
|
|
`customer_collection` varchar(140),
|
|
`collection_name` varchar(140),
|
|
`primary_mandatory` int(1) not null default 1,
|
|
`show_net_values_in_party_account` int(1) not null default 0,
|
|
`orientation` varchar(140),
|
|
`include_break` int(1) not null default 1,
|
|
`include_ageing` int(1) not null default 0,
|
|
`ageing_based_on` varchar(140) default 'Due Date',
|
|
`letter_head` varchar(140),
|
|
`terms_and_conditions` varchar(140),
|
|
`enable_auto_email` int(1) not null default 0,
|
|
`sender` varchar(140),
|
|
`frequency` varchar(140),
|
|
`filter_duration` int(11) not null default 1,
|
|
`start_date` date,
|
|
`pdf_name` varchar(140),
|
|
`subject` varchar(140),
|
|
`body` longtext,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,498 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Closing Entry` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`period_start_date` datetime(6),
|
|
`period_end_date` datetime(6),
|
|
`posting_date` date,
|
|
`posting_time` time(6),
|
|
`pos_opening_entry` varchar(140),
|
|
`status` varchar(140) default 'Draft',
|
|
`company` varchar(140),
|
|
`pos_profile` varchar(140),
|
|
`user` varchar(140),
|
|
`grand_total` decimal(21,9) not null default 0,
|
|
`net_total` decimal(21,9) not null default 0,
|
|
`total_quantity` decimal(21,9) not null default 0,
|
|
`error_message` text,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,570 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Item` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`supplier` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,633 WARNING database DDL Query made to DB:
|
|
create table `tabProcess Statement Of Accounts Customer` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`customer` varchar(140),
|
|
`customer_name` varchar(140),
|
|
`billing_email` varchar(140),
|
|
`primary_email` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,709 WARNING database DDL Query made to DB:
|
|
create table `tabDunning Type` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`dunning_type` varchar(140) unique,
|
|
`is_default` int(1) not null default 0,
|
|
`company` varchar(140),
|
|
`dunning_fee` decimal(21,9) not null default 0,
|
|
`rate_of_interest` decimal(21,9) not null default 0,
|
|
`income_account` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,772 WARNING database DDL Query made to DB:
|
|
create table `tabSubscription Invoice` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`document_type` varchar(140),
|
|
`invoice` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,835 WARNING database DDL Query made to DB:
|
|
create table `tabRepost Accounting Ledger Items` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`voucher_type` varchar(140),
|
|
`voucher_no` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,898 WARNING database DDL Query made to DB:
|
|
create table `tabUnreconcile Payment Entries` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`account` varchar(140),
|
|
`party_type` varchar(140),
|
|
`party` varchar(140),
|
|
`reference_doctype` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`allocated_amount` decimal(21,9) not null default 0,
|
|
`account_currency` varchar(140),
|
|
`unlinked` int(1) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:31,954 WARNING database DDL Query made to DB:
|
|
create table `tabPSOA Project` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`project_name` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,137 WARNING database DDL Query made to DB:
|
|
create table `tabPurchase Invoice Item` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`item_code` varchar(140),
|
|
`product_bundle` varchar(140),
|
|
`item_name` varchar(140),
|
|
`description` longtext,
|
|
`brand` varchar(140),
|
|
`item_group` varchar(140),
|
|
`image` text,
|
|
`received_qty` decimal(21,9) not null default 0,
|
|
`qty` decimal(21,9) not null default 0,
|
|
`rejected_qty` decimal(21,9) not null default 0,
|
|
`uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 1.0,
|
|
`stock_uom` varchar(140),
|
|
`stock_qty` decimal(21,9) not null default 0,
|
|
`price_list_rate` decimal(21,9) not null default 0,
|
|
`base_price_list_rate` decimal(21,9) not null default 0,
|
|
`margin_type` varchar(140),
|
|
`margin_rate_or_amount` decimal(21,9) not null default 0,
|
|
`rate_with_margin` decimal(21,9) not null default 0,
|
|
`discount_percentage` decimal(21,9) not null default 0,
|
|
`discount_amount` decimal(21,9) not null default 0,
|
|
`distributed_discount_amount` decimal(21,9) not null default 0,
|
|
`base_rate_with_margin` decimal(21,9) not null default 0,
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`item_tax_template` varchar(140),
|
|
`base_rate` decimal(21,9) not null default 0,
|
|
`base_amount` decimal(21,9) not null default 0,
|
|
`pricing_rules` text,
|
|
`stock_uom_rate` decimal(21,9) not null default 0,
|
|
`is_free_item` int(1) not null default 0,
|
|
`apply_tds` int(1) not null default 1,
|
|
`net_rate` decimal(21,9) not null default 0,
|
|
`net_amount` decimal(21,9) not null default 0,
|
|
`base_net_rate` decimal(21,9) not null default 0,
|
|
`base_net_amount` decimal(21,9) not null default 0,
|
|
`valuation_rate` decimal(21,9) not null default 0,
|
|
`sales_incoming_rate` decimal(21,9) not null default 0,
|
|
`item_tax_amount` decimal(21,9) not null default 0,
|
|
`landed_cost_voucher_amount` decimal(21,9) not null default 0,
|
|
`rm_supp_cost` decimal(21,9) not null default 0,
|
|
`warehouse` varchar(140),
|
|
`serial_and_batch_bundle` varchar(140),
|
|
`use_serial_batch_fields` int(1) not null default 0,
|
|
`from_warehouse` varchar(140),
|
|
`quality_inspection` varchar(140),
|
|
`rejected_warehouse` varchar(140),
|
|
`rejected_serial_and_batch_bundle` varchar(140),
|
|
`serial_no` text,
|
|
`rejected_serial_no` text,
|
|
`batch_no` varchar(140),
|
|
`manufacturer` varchar(140),
|
|
`manufacturer_part_no` varchar(140),
|
|
`expense_account` varchar(140),
|
|
`wip_composite_asset` varchar(140),
|
|
`is_fixed_asset` int(1) not null default 0,
|
|
`asset_location` varchar(140),
|
|
`asset_category` varchar(140),
|
|
`deferred_expense_account` varchar(140),
|
|
`service_stop_date` date,
|
|
`enable_deferred_expense` int(1) not null default 0,
|
|
`service_start_date` date,
|
|
`service_end_date` date,
|
|
`allow_zero_valuation_rate` int(1) not null default 0,
|
|
`item_tax_rate` longtext,
|
|
`bom` varchar(140),
|
|
`include_exploded_items` int(1) not null default 0,
|
|
`purchase_invoice_item` varchar(140),
|
|
`purchase_order` varchar(140),
|
|
`po_detail` varchar(140),
|
|
`purchase_receipt` varchar(140),
|
|
`pr_detail` varchar(140),
|
|
`sales_invoice_item` varchar(140),
|
|
`material_request` varchar(140),
|
|
`material_request_item` varchar(140),
|
|
`weight_per_unit` decimal(21,9) not null default 0,
|
|
`total_weight` decimal(21,9) not null default 0,
|
|
`weight_uom` varchar(140),
|
|
`project` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`page_break` int(1) not null default 0,
|
|
index `item_code`(`item_code`),
|
|
index `serial_and_batch_bundle`(`serial_and_batch_bundle`),
|
|
index `batch_no`(`batch_no`),
|
|
index `purchase_order`(`purchase_order`),
|
|
index `po_detail`(`po_detail`),
|
|
index `purchase_receipt`(`purchase_receipt`),
|
|
index `pr_detail`(`pr_detail`),
|
|
index `material_request`(`material_request`),
|
|
index `material_request_item`(`material_request_item`),
|
|
index `project`(`project`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,204 WARNING database DDL Query made to DB:
|
|
create table `tabCost Center Allocation` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`main_cost_center` varchar(140),
|
|
`company` varchar(140),
|
|
`valid_from` date,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,297 WARNING database DDL Query made to DB:
|
|
create table `tabShare Balance` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`share_type` varchar(140),
|
|
`from_no` int(11) not null default 0,
|
|
`rate` int(11) not null default 0,
|
|
`no_of_shares` int(11) not null default 0,
|
|
`to_no` int(11) not null default 0,
|
|
`amount` int(11) not null default 0,
|
|
`is_company` int(1) not null default 0,
|
|
`current_state` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,367 WARNING database DDL Query made to DB:
|
|
create table `tabTax Withholding Category` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`category_name` varchar(140),
|
|
`round_off_tax_amount` int(1) not null default 0,
|
|
`consider_party_ledger_amount` int(1) not null default 0,
|
|
`tax_on_excess_amount` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,450 WARNING database DDL Query made to DB:
|
|
create table `tabInvoice Discounting` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`posting_date` date,
|
|
`loan_start_date` date,
|
|
`loan_period` int(11) not null default 0,
|
|
`loan_end_date` date,
|
|
`status` varchar(140),
|
|
`company` varchar(140),
|
|
`total_amount` decimal(21,9) not null default 0,
|
|
`bank_charges` decimal(21,9) not null default 0,
|
|
`short_term_loan` varchar(140),
|
|
`bank_account` varchar(140),
|
|
`bank_charges_account` varchar(140),
|
|
`accounts_receivable_credit` varchar(140),
|
|
`accounts_receivable_discounted` varchar(140),
|
|
`accounts_receivable_unpaid` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,521 WARNING database DDL Query made to DB:
|
|
create table `tabFiscal Year` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`year` varchar(140) unique,
|
|
`disabled` int(1) not null default 0,
|
|
`is_short_year` int(1) not null default 0,
|
|
`year_start_date` date,
|
|
`year_end_date` date,
|
|
`auto_created` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,612 WARNING database DDL Query made to DB:
|
|
create table `tabSouth Africa VAT Account` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`account` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,823 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Invoice Item` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`barcode` varchar(140),
|
|
`has_item_scanned` int(1) not null default 0,
|
|
`item_code` varchar(140),
|
|
`item_name` varchar(140),
|
|
`customer_item_code` varchar(140),
|
|
`description` longtext,
|
|
`item_group` varchar(140),
|
|
`brand` varchar(140),
|
|
`image` text,
|
|
`qty` decimal(21,9) not null default 0,
|
|
`stock_uom` varchar(140),
|
|
`uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 0,
|
|
`stock_qty` decimal(21,9) not null default 0,
|
|
`price_list_rate` decimal(21,9) not null default 0,
|
|
`base_price_list_rate` decimal(21,9) not null default 0,
|
|
`margin_type` varchar(140),
|
|
`margin_rate_or_amount` decimal(21,9) not null default 0,
|
|
`rate_with_margin` decimal(21,9) not null default 0,
|
|
`discount_percentage` decimal(21,9) not null default 0,
|
|
`discount_amount` decimal(21,9) not null default 0,
|
|
`distributed_discount_amount` decimal(21,9) not null default 0,
|
|
`base_rate_with_margin` decimal(21,9) not null default 0,
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`item_tax_template` varchar(140),
|
|
`base_rate` decimal(21,9) not null default 0,
|
|
`base_amount` decimal(21,9) not null default 0,
|
|
`pricing_rules` text,
|
|
`is_free_item` int(1) not null default 0,
|
|
`grant_commission` int(1) not null default 0,
|
|
`net_rate` decimal(21,9) not null default 0,
|
|
`net_amount` decimal(21,9) not null default 0,
|
|
`base_net_rate` decimal(21,9) not null default 0,
|
|
`base_net_amount` decimal(21,9) not null default 0,
|
|
`delivered_by_supplier` int(1) not null default 0,
|
|
`income_account` varchar(140),
|
|
`is_fixed_asset` int(1) not null default 0,
|
|
`asset` varchar(140),
|
|
`finance_book` varchar(140),
|
|
`expense_account` varchar(140),
|
|
`deferred_revenue_account` varchar(140),
|
|
`service_stop_date` date,
|
|
`enable_deferred_revenue` int(1) not null default 0,
|
|
`service_start_date` date,
|
|
`service_end_date` date,
|
|
`weight_per_unit` decimal(21,9) not null default 0,
|
|
`total_weight` decimal(21,9) not null default 0,
|
|
`weight_uom` varchar(140),
|
|
`warehouse` varchar(140),
|
|
`target_warehouse` varchar(140),
|
|
`quality_inspection` varchar(140),
|
|
`serial_and_batch_bundle` varchar(140),
|
|
`use_serial_batch_fields` int(1) not null default 0,
|
|
`allow_zero_valuation_rate` int(1) not null default 0,
|
|
`item_tax_rate` text,
|
|
`actual_batch_qty` decimal(21,9) not null default 0,
|
|
`actual_qty` decimal(21,9) not null default 0,
|
|
`serial_no` text,
|
|
`batch_no` varchar(140),
|
|
`sales_order` varchar(140),
|
|
`so_detail` varchar(140),
|
|
`pos_invoice_item` varchar(140),
|
|
`delivery_note` varchar(140),
|
|
`dn_detail` varchar(140),
|
|
`delivered_qty` decimal(21,9) not null default 0,
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`page_break` int(1) not null default 0,
|
|
index `item_code`(`item_code`),
|
|
index `sales_order`(`sales_order`),
|
|
index `so_detail`(`so_detail`),
|
|
index `delivery_note`(`delivery_note`),
|
|
index `dn_detail`(`dn_detail`),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,888 WARNING database DDL Query made to DB:
|
|
create table `tabUnreconcile Payment` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
`voucher_type` varchar(140),
|
|
`voucher_no` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:32,958 WARNING database DDL Query made to DB:
|
|
create table `tabItem Tax Template` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`title` varchar(140),
|
|
`company` varchar(140),
|
|
`disabled` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:33,022 WARNING database DDL Query made to DB:
|
|
create table `tabProcess Statement Of Accounts CC` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`cc` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:33,176 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Entry` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`naming_series` varchar(140),
|
|
`payment_type` varchar(140),
|
|
`payment_order_status` varchar(140),
|
|
`posting_date` date,
|
|
`company` varchar(140),
|
|
`mode_of_payment` varchar(140),
|
|
`party_type` varchar(140),
|
|
`party` varchar(140),
|
|
`party_name` varchar(140),
|
|
`book_advance_payments_in_separate_party_account` int(1) not null default 0,
|
|
`reconcile_on_advance_payment_date` int(1) not null default 0,
|
|
`bank_account` varchar(140),
|
|
`party_bank_account` varchar(140),
|
|
`contact_person` varchar(140),
|
|
`contact_email` varchar(140),
|
|
`party_balance` decimal(21,9) not null default 0,
|
|
`paid_from` varchar(140),
|
|
`paid_from_account_type` varchar(140),
|
|
`paid_from_account_currency` varchar(140),
|
|
`paid_from_account_balance` decimal(21,9) not null default 0,
|
|
`paid_to` varchar(140),
|
|
`paid_to_account_type` varchar(140),
|
|
`paid_to_account_currency` varchar(140),
|
|
`paid_to_account_balance` decimal(21,9) not null default 0,
|
|
`paid_amount` decimal(21,9) not null default 0,
|
|
`paid_amount_after_tax` decimal(21,9) not null default 0,
|
|
`source_exchange_rate` decimal(21,9) not null default 0,
|
|
`base_paid_amount` decimal(21,9) not null default 0,
|
|
`base_paid_amount_after_tax` decimal(21,9) not null default 0,
|
|
`received_amount` decimal(21,9) not null default 0,
|
|
`received_amount_after_tax` decimal(21,9) not null default 0,
|
|
`target_exchange_rate` decimal(21,9) not null default 0,
|
|
`base_received_amount` decimal(21,9) not null default 0,
|
|
`base_received_amount_after_tax` decimal(21,9) not null default 0,
|
|
`total_allocated_amount` decimal(21,9) not null default 0,
|
|
`base_total_allocated_amount` decimal(21,9) not null default 0,
|
|
`unallocated_amount` decimal(21,9) not null default 0,
|
|
`difference_amount` decimal(21,9) not null default 0,
|
|
`purchase_taxes_and_charges_template` varchar(140),
|
|
`sales_taxes_and_charges_template` varchar(140),
|
|
`apply_tax_withholding_amount` int(1) not null default 0,
|
|
`tax_withholding_category` varchar(140),
|
|
`base_total_taxes_and_charges` decimal(21,9) not null default 0,
|
|
`total_taxes_and_charges` decimal(21,9) not null default 0,
|
|
`reference_no` varchar(140),
|
|
`reference_date` date,
|
|
`clearance_date` date,
|
|
`project` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`status` varchar(140) default 'Draft',
|
|
`custom_remarks` int(1) not null default 0,
|
|
`remarks` text,
|
|
`base_in_words` text,
|
|
`is_opening` varchar(140) default 'No',
|
|
`letter_head` varchar(140),
|
|
`print_heading` varchar(140),
|
|
`bank` varchar(140),
|
|
`bank_account_no` varchar(140),
|
|
`payment_order` varchar(140),
|
|
`in_words` text,
|
|
`auto_repeat` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`title` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `party_type`(`party_type`),
|
|
index `reference_date`(`reference_date`),
|
|
index `is_opening`(`is_opening`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:33,498 WARNING database DDL Query made to DB:
|
|
create table `tabPurchase Invoice` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`title` varchar(140) default '{supplier_name}',
|
|
`naming_series` varchar(140),
|
|
`supplier` varchar(140),
|
|
`supplier_name` varchar(140),
|
|
`tax_id` varchar(140),
|
|
`company` varchar(140),
|
|
`posting_date` date,
|
|
`posting_time` time(6),
|
|
`set_posting_time` int(1) not null default 0,
|
|
`due_date` date,
|
|
`is_paid` int(1) not null default 0,
|
|
`is_return` int(1) not null default 0,
|
|
`return_against` varchar(140),
|
|
`update_outstanding_for_self` int(1) not null default 1,
|
|
`update_billed_amount_in_purchase_order` int(1) not null default 0,
|
|
`update_billed_amount_in_purchase_receipt` int(1) not null default 1,
|
|
`apply_tds` int(1) not null default 0,
|
|
`tax_withholding_category` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`bill_no` varchar(140),
|
|
`bill_date` date,
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`currency` varchar(140),
|
|
`conversion_rate` decimal(21,9) not null default 0,
|
|
`use_transaction_date_exchange_rate` int(1) not null default 0,
|
|
`buying_price_list` varchar(140),
|
|
`price_list_currency` varchar(140),
|
|
`plc_conversion_rate` decimal(21,9) not null default 0,
|
|
`ignore_pricing_rule` int(1) not null default 0,
|
|
`scan_barcode` varchar(140),
|
|
`update_stock` int(1) not null default 0,
|
|
`set_warehouse` varchar(140),
|
|
`set_from_warehouse` varchar(140),
|
|
`is_subcontracted` int(1) not null default 0,
|
|
`rejected_warehouse` varchar(140),
|
|
`supplier_warehouse` varchar(140),
|
|
`total_qty` decimal(21,9) not null default 0,
|
|
`total_net_weight` decimal(21,9) not null default 0,
|
|
`base_total` decimal(21,9) not null default 0,
|
|
`base_net_total` decimal(21,9) not null default 0,
|
|
`total` decimal(21,9) not null default 0,
|
|
`net_total` decimal(21,9) not null default 0,
|
|
`tax_withholding_net_total` decimal(21,9) not null default 0,
|
|
`base_tax_withholding_net_total` decimal(21,9) not null default 0,
|
|
`tax_category` varchar(140),
|
|
`taxes_and_charges` varchar(140),
|
|
`shipping_rule` varchar(140),
|
|
`incoterm` varchar(140),
|
|
`named_place` varchar(140),
|
|
`base_taxes_and_charges_added` decimal(21,9) not null default 0,
|
|
`base_taxes_and_charges_deducted` decimal(21,9) not null default 0,
|
|
`base_total_taxes_and_charges` decimal(21,9) not null default 0,
|
|
`taxes_and_charges_added` decimal(21,9) not null default 0,
|
|
`taxes_and_charges_deducted` decimal(21,9) not null default 0,
|
|
`total_taxes_and_charges` decimal(21,9) not null default 0,
|
|
`base_grand_total` decimal(21,9) not null default 0,
|
|
`base_rounding_adjustment` decimal(21,9) not null default 0,
|
|
`base_rounded_total` decimal(21,9) not null default 0,
|
|
`base_in_words` varchar(240),
|
|
`grand_total` decimal(21,9) not null default 0,
|
|
`rounding_adjustment` decimal(21,9) not null default 0,
|
|
`use_company_roundoff_cost_center` int(1) not null default 0,
|
|
`rounded_total` decimal(21,9) not null default 0,
|
|
`in_words` varchar(240),
|
|
`total_advance` decimal(21,9) not null default 0,
|
|
`outstanding_amount` decimal(21,9) not null default 0,
|
|
`disable_rounded_total` int(1) not null default 0,
|
|
`apply_discount_on` varchar(140) default 'Grand Total',
|
|
`base_discount_amount` decimal(21,9) not null default 0,
|
|
`additional_discount_percentage` decimal(21,9) not null default 0,
|
|
`discount_amount` decimal(21,9) not null default 0,
|
|
`other_charges_calculation` longtext,
|
|
`mode_of_payment` varchar(140),
|
|
`base_paid_amount` decimal(21,9) not null default 0,
|
|
`clearance_date` date,
|
|
`cash_bank_account` varchar(140),
|
|
`paid_amount` decimal(21,9) not null default 0,
|
|
`allocate_advances_automatically` int(1) not null default 0,
|
|
`only_include_allocated_payments` int(1) not null default 0,
|
|
`write_off_amount` decimal(21,9) not null default 0,
|
|
`base_write_off_amount` decimal(21,9) not null default 0,
|
|
`write_off_account` varchar(140),
|
|
`write_off_cost_center` varchar(140),
|
|
`supplier_address` varchar(140),
|
|
`address_display` text,
|
|
`contact_person` varchar(140),
|
|
`contact_display` text,
|
|
`contact_mobile` text,
|
|
`contact_email` text,
|
|
`dispatch_address` varchar(140),
|
|
`dispatch_address_display` longtext,
|
|
`shipping_address` varchar(140),
|
|
`shipping_address_display` text,
|
|
`billing_address` varchar(140),
|
|
`billing_address_display` text,
|
|
`payment_terms_template` varchar(140),
|
|
`ignore_default_payment_terms_template` int(1) not null default 0,
|
|
`tc_name` varchar(140),
|
|
`terms` longtext,
|
|
`status` varchar(140) default 'Draft',
|
|
`per_received` decimal(21,9) not null default 0,
|
|
`credit_to` varchar(140),
|
|
`party_account_currency` varchar(140),
|
|
`is_opening` varchar(140) default 'No',
|
|
`against_expense_account` text,
|
|
`unrealized_profit_loss_account` varchar(140),
|
|
`subscription` varchar(140),
|
|
`auto_repeat` varchar(140),
|
|
`from_date` date,
|
|
`to_date` date,
|
|
`letter_head` varchar(140),
|
|
`group_same_items` int(1) not null default 0,
|
|
`select_print_heading` varchar(140),
|
|
`language` varchar(140),
|
|
`on_hold` int(1) not null default 0,
|
|
`release_date` date,
|
|
`hold_comment` text,
|
|
`is_internal_supplier` int(1) not null default 0,
|
|
`represents_company` varchar(140),
|
|
`supplier_group` varchar(140),
|
|
`inter_company_invoice_reference` varchar(140),
|
|
`is_old_subcontracting_flow` int(1) not null default 0,
|
|
`remarks` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `supplier`(`supplier`),
|
|
index `posting_date`(`posting_date`),
|
|
index `return_against`(`return_against`),
|
|
index `bill_no`(`bill_no`),
|
|
index `credit_to`(`credit_to`),
|
|
index `release_date`(`release_date`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:33,763 WARNING database DDL Query made to DB:
|
|
create table `tabPOS Profile` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
`customer` varchar(140),
|
|
`country` varchar(140),
|
|
`disabled` int(1) not null default 0,
|
|
`warehouse` varchar(140),
|
|
`campaign` varchar(140),
|
|
`company_address` varchar(140),
|
|
`hide_images` int(1) not null default 0,
|
|
`hide_unavailable_items` int(1) not null default 0,
|
|
`auto_add_item_to_cart` int(1) not null default 0,
|
|
`validate_stock_on_save` int(1) not null default 0,
|
|
`print_receipt_on_order_complete` int(1) not null default 0,
|
|
`update_stock` int(1) not null default 1,
|
|
`ignore_pricing_rule` int(1) not null default 0,
|
|
`allow_rate_change` int(1) not null default 0,
|
|
`allow_discount_change` int(1) not null default 0,
|
|
`disable_grand_total_to_default_mop` int(1) not null default 0,
|
|
`allow_partial_payment` int(1) not null default 0,
|
|
`print_format` varchar(140),
|
|
`letter_head` varchar(140),
|
|
`tc_name` varchar(140),
|
|
`select_print_heading` varchar(140),
|
|
`selling_price_list` varchar(140),
|
|
`currency` varchar(140),
|
|
`write_off_account` varchar(140),
|
|
`write_off_cost_center` varchar(140),
|
|
`write_off_limit` decimal(21,9) not null default 1.0,
|
|
`account_for_change_amount` varchar(140),
|
|
`disable_rounded_total` int(1) not null default 0,
|
|
`income_account` varchar(140),
|
|
`expense_account` varchar(140),
|
|
`taxes_and_charges` varchar(140),
|
|
`tax_category` varchar(140),
|
|
`apply_discount_on` varchar(140) default 'Grand Total',
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:33,834 WARNING database DDL Query made to DB:
|
|
create table `tabLoyalty Point Entry Redemption` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`sales_invoice` varchar(140),
|
|
`redemption_date` date,
|
|
`redeemed_points` int(11) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:33,908 WARNING database DDL Query made to DB:
|
|
create table `tabRepost Payment Ledger` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
`posting_date` date,
|
|
`voucher_type` varchar(140),
|
|
`add_manually` int(1) not null default 0,
|
|
`repost_status` varchar(140),
|
|
`repost_error_log` longtext,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:33,983 WARNING database DDL Query made to DB:
|
|
create table `tabAccounting Period` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`period_name` varchar(140),
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`company` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:34,126 WARNING database DDL Query made to DB:
|
|
create table `tabBank Statement Import` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company` varchar(140),
|
|
`bank_account` varchar(140),
|
|
`bank` varchar(140),
|
|
`custom_delimiters` int(1) not null default 0,
|
|
`delimiter_options` varchar(140) default ',;\\t|',
|
|
`google_sheets_url` varchar(140),
|
|
`import_file` text,
|
|
`status` varchar(140) default 'Pending',
|
|
`template_options` longtext,
|
|
`template_warnings` longtext,
|
|
`show_failed_logs` int(1) not null default 0,
|
|
`reference_doctype` varchar(140) default 'Bank Transaction',
|
|
`import_type` varchar(140) default 'Insert New Records',
|
|
`submit_after_import` int(1) not null default 1,
|
|
`mute_emails` int(1) not null default 1,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:34,187 WARNING database DDL Query made to DB:
|
|
create table `tabClosed Document` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`document_type` varchar(140),
|
|
`closed` int(1) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:34,359 WARNING database DDL Query made to DB:
|
|
create table `tabPayment Request` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`payment_request_type` varchar(140) default 'Inward',
|
|
`transaction_date` date,
|
|
`naming_series` varchar(140),
|
|
`company` varchar(140),
|
|
`mode_of_payment` varchar(140),
|
|
`party_type` varchar(140),
|
|
`party` varchar(140),
|
|
`party_name` varchar(140),
|
|
`reference_doctype` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`grand_total` decimal(21,9) not null default 0,
|
|
`currency` varchar(140),
|
|
`is_a_subscription` int(1) not null default 0,
|
|
`outstanding_amount` decimal(21,9) not null default 0,
|
|
`party_account_currency` varchar(140),
|
|
`bank_account` varchar(140),
|
|
`bank` varchar(140),
|
|
`bank_account_no` varchar(140),
|
|
`account` varchar(140),
|
|
`iban` varchar(140),
|
|
`branch_code` varchar(140),
|
|
`swift_number` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`print_format` varchar(140),
|
|
`email_to` varchar(140),
|
|
`subject` varchar(140),
|
|
`payment_gateway_account` varchar(140),
|
|
`status` varchar(140) default 'Draft',
|
|
`make_sales_invoice` int(1) not null default 0,
|
|
`message` text,
|
|
`mute_email` int(1) not null default 0,
|
|
`payment_url` varchar(500),
|
|
`payment_gateway` varchar(140),
|
|
`payment_account` varchar(140),
|
|
`payment_channel` varchar(140),
|
|
`payment_order` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`phone_number` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `reference_name`(`reference_name`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:34,432 WARNING database DDL Query made to DB:
|
|
create table `tabPurchase Taxes and Charges Template` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`title` varchar(140),
|
|
`is_default` int(1) not null default 0,
|
|
`disabled` int(1) not null default 0,
|
|
`company` varchar(140),
|
|
`tax_category` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:34,502 WARNING database DDL Query made to DB:
|
|
create table `tabJournal Entry Template Account` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`account` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:34,628 WARNING database DDL Query made to DB:
|
|
create table `tabDunning` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`naming_series` varchar(140) default 'DUNN-.MM.-.YY.-',
|
|
`customer` varchar(140),
|
|
`customer_name` varchar(140),
|
|
`company` varchar(140),
|
|
`posting_date` date,
|
|
`posting_time` time(6),
|
|
`status` varchar(140) default 'Unresolved',
|
|
`currency` varchar(140),
|
|
`conversion_rate` decimal(21,9) not null default 0,
|
|
`dunning_type` varchar(140),
|
|
`rate_of_interest` decimal(21,9) not null default 0,
|
|
`total_interest` decimal(21,9) not null default 0,
|
|
`dunning_fee` decimal(21,9) not null default 0,
|
|
`dunning_amount` decimal(21,9) not null default 0,
|
|
`base_dunning_amount` decimal(21,9) not null default 0,
|
|
`spacer` varchar(140),
|
|
`total_outstanding` decimal(21,9) not null default 0,
|
|
`grand_total` decimal(21,9) not null default 0,
|
|
`language` varchar(140),
|
|
`body_text` longtext,
|
|
`letter_head` varchar(140),
|
|
`closing_text` longtext,
|
|
`income_account` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`customer_address` varchar(140),
|
|
`address_display` text,
|
|
`contact_person` varchar(140),
|
|
`contact_display` text,
|
|
`contact_mobile` text,
|
|
`contact_email` varchar(140),
|
|
`company_address` varchar(140),
|
|
`company_address_display` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:35,551 WARNING database DDL Query made to DB:
|
|
create table `tabCampaign Email Schedule` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`email_template` varchar(140),
|
|
`send_after_days` int(11) not null default 0,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:35,612 WARNING database DDL Query made to DB:
|
|
create table `tabAppointment Booking Slots` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`day_of_week` varchar(140),
|
|
`from_time` time(6),
|
|
`to_time` time(6),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:35,675 WARNING database DDL Query made to DB:
|
|
create sequence if not exists prospect_opportunity_id_seq nocache nocycle
|
|
2025-06-23 23:52:35,688 WARNING database DDL Query made to DB:
|
|
create table `tabProspect Opportunity` (
|
|
name bigint primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`opportunity` varchar(140),
|
|
`amount` decimal(21,9) not null default 0,
|
|
`stage` varchar(140),
|
|
`deal_owner` varchar(140),
|
|
`probability` decimal(21,9) not null default 0,
|
|
`expected_closing` date,
|
|
`currency` varchar(140),
|
|
`contact_person` varchar(140),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:35,749 WARNING database DDL Query made to DB:
|
|
create sequence if not exists crm_note_id_seq nocache nocycle
|
|
2025-06-23 23:52:35,762 WARNING database DDL Query made to DB:
|
|
create table `tabCRM Note` (
|
|
name bigint primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`note` longtext,
|
|
`added_by` varchar(140),
|
|
`added_on` datetime(6),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:35,858 WARNING database DDL Query made to DB:
|
|
create table `tabProspect` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`company_name` varchar(140) unique,
|
|
`customer_group` varchar(140),
|
|
`no_of_employees` varchar(140),
|
|
`annual_revenue` decimal(21,9) not null default 0,
|
|
`market_segment` varchar(140),
|
|
`industry` varchar(140),
|
|
`territory` varchar(140),
|
|
`prospect_owner` varchar(140),
|
|
`website` varchar(140),
|
|
`fax` varchar(140),
|
|
`company` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:35,931 WARNING database DDL Query made to DB:
|
|
create table `tabAvailability Of Slots` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`day_of_week` varchar(140),
|
|
`from_time` time(6),
|
|
`to_time` time(6),
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:36,074 WARNING database DDL Query made to DB:
|
|
create table `tabOpportunity` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`opportunity_from` varchar(140),
|
|
`party_name` varchar(140),
|
|
`customer_name` varchar(140),
|
|
`status` varchar(140) default 'Open',
|
|
`opportunity_type` varchar(140) default 'Sales',
|
|
`source` varchar(140),
|
|
`opportunity_owner` varchar(140),
|
|
`sales_stage` varchar(140) default 'Prospecting',
|
|
`expected_closing` date,
|
|
`probability` decimal(21,9) not null default 100.0,
|
|
`no_of_employees` varchar(140),
|
|
`annual_revenue` decimal(21,9) not null default 0,
|
|
`customer_group` varchar(140),
|
|
`industry` varchar(140),
|
|
`market_segment` varchar(140),
|
|
`website` varchar(140),
|
|
`city` varchar(140),
|
|
`state` varchar(140),
|
|
`country` varchar(140),
|
|
`territory` varchar(140),
|
|
`currency` varchar(140),
|
|
`conversion_rate` decimal(21,9) not null default 0,
|
|
`opportunity_amount` decimal(21,9) not null default 0,
|
|
`base_opportunity_amount` decimal(21,9) not null default 0,
|
|
`company` varchar(140),
|
|
`campaign` varchar(140),
|
|
`transaction_date` date,
|
|
`language` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`title` varchar(140),
|
|
`first_response_time` decimal(21,9),
|
|
`order_lost_reason` text,
|
|
`contact_person` varchar(140),
|
|
`job_title` varchar(140),
|
|
`contact_email` varchar(140),
|
|
`contact_mobile` varchar(140),
|
|
`whatsapp` varchar(140),
|
|
`phone` varchar(140),
|
|
`phone_ext` varchar(140),
|
|
`customer_address` varchar(140),
|
|
`address_display` text,
|
|
`contact_display` text,
|
|
`base_total` decimal(21,9) not null default 0,
|
|
`total` decimal(21,9) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index `customer_group`(`customer_group`),
|
|
index `territory`(`territory`),
|
|
index `company`(`company`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:36,209 WARNING database DDL Query made to DB:
|
|
create table `tabOpportunity Lost Reason` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`lost_reason` 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:36,290 WARNING database DDL Query made to DB:
|
|
create table `tabCompetitor` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`competitor_name` varchar(140) unique,
|
|
`website` 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:36,382 WARNING database DDL Query made to DB:
|
|
create table `tabOpportunity Item` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`item_code` varchar(140),
|
|
`item_name` varchar(140),
|
|
`uom` varchar(140),
|
|
`qty` decimal(21,9) not null default 1.0,
|
|
`brand` varchar(140),
|
|
`item_group` varchar(140),
|
|
`description` longtext,
|
|
`image` text,
|
|
`base_rate` decimal(21,9) not null default 0,
|
|
`base_amount` decimal(21,9) not null default 0,
|
|
`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:36,445 WARNING database DDL Query made to DB:
|
|
create table `tabLead Source` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`source_name` varchar(140) unique,
|
|
`details` 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:36,526 WARNING database DDL Query made to DB:
|
|
create table `tabAppointment` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`scheduled_time` datetime(6),
|
|
`status` varchar(140),
|
|
`customer_name` varchar(140),
|
|
`customer_phone_number` varchar(140),
|
|
`customer_skype` varchar(140),
|
|
`customer_email` varchar(140),
|
|
`customer_details` longtext,
|
|
`appointment_with` varchar(140),
|
|
`party` varchar(140),
|
|
`calendar_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:36,608 WARNING database DDL Query made to DB:
|
|
create table `tabContract Fulfilment Checklist` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`fulfilled` int(1) not null default 0,
|
|
`requirement` varchar(140),
|
|
`notes` text,
|
|
`amended_from` 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:36,667 WARNING database DDL Query made to DB:
|
|
create table `tabSales Stage` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`stage_name` 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:36,731 WARNING database DDL Query made to DB:
|
|
create table `tabOpportunity 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',
|
|
`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:36,798 WARNING database DDL Query made to DB:
|
|
create table `tabCompetitor 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',
|
|
`competitor` 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:36,865 WARNING database DDL Query made to DB:
|
|
create table `tabCampaign` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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_name` varchar(140),
|
|
`naming_series` 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:36,944 WARNING database DDL Query made to DB:
|
|
create table `tabEmail Campaign` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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_name` varchar(140),
|
|
`email_campaign_for` varchar(140) default 'Lead',
|
|
`recipient` varchar(140),
|
|
`sender` varchar(140),
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`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:37,008 WARNING database DDL Query made to DB:
|
|
create table `tabOpportunity Lost Reason 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',
|
|
`lost_reason` 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:37,100 WARNING database DDL Query made to DB:
|
|
create table `tabContract` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`party_type` varchar(140) default 'Customer',
|
|
`is_signed` int(1) not null default 0,
|
|
`party_name` varchar(140),
|
|
`party_user` varchar(140),
|
|
`status` varchar(140),
|
|
`fulfilment_status` varchar(140),
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`signee` varchar(140),
|
|
`signed_on` datetime(6),
|
|
`ip_address` varchar(140),
|
|
`contract_template` varchar(140),
|
|
`contract_terms` longtext,
|
|
`requires_fulfilment` int(1) not null default 0,
|
|
`fulfilment_deadline` date,
|
|
`signee_company` longtext,
|
|
`signed_by_company` varchar(140),
|
|
`document_type` varchar(140),
|
|
`document_name` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-06-23 23:52:37,187 WARNING database DDL Query made to DB:
|
|
create table `tabContract 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) unique,
|
|
`contract_terms` longtext,
|
|
`requires_fulfilment` 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:37,259 WARNING database DDL Query made to DB:
|
|
create table `tabContract Template Fulfilment Terms` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`requirement` 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:37,394 WARNING database DDL Query made to DB:
|
|
create table `tabProspect Lead` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`lead` varchar(140),
|
|
`lead_name` varchar(140),
|
|
`email` varchar(140),
|
|
`mobile_no` varchar(140),
|
|
`lead_owner` varchar(140),
|
|
`status` 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:37,527 WARNING database DDL Query made to DB:
|
|
create table `tabLead` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`salutation` varchar(140),
|
|
`first_name` varchar(140),
|
|
`middle_name` varchar(140),
|
|
`last_name` varchar(140),
|
|
`lead_name` varchar(140),
|
|
`job_title` varchar(140),
|
|
`gender` varchar(140),
|
|
`source` varchar(140),
|
|
`lead_owner` varchar(140),
|
|
`status` varchar(140) default 'Lead',
|
|
`customer` varchar(140),
|
|
`type` varchar(140),
|
|
`request_type` varchar(140),
|
|
`email_id` varchar(140),
|
|
`website` varchar(140),
|
|
`mobile_no` varchar(140),
|
|
`whatsapp_no` varchar(140),
|
|
`phone` varchar(140),
|
|
`phone_ext` varchar(140),
|
|
`company_name` varchar(140),
|
|
`no_of_employees` varchar(140),
|
|
`annual_revenue` decimal(21,9) not null default 0,
|
|
`industry` varchar(140),
|
|
`market_segment` varchar(140),
|
|
`territory` varchar(140),
|
|
`fax` varchar(140),
|
|
`city` varchar(140),
|
|
`state` varchar(140),
|
|
`country` varchar(140),
|
|
`qualification_status` varchar(140),
|
|
`qualified_by` varchar(140),
|
|
`qualified_on` date,
|
|
`campaign_name` varchar(140),
|
|
`company` varchar(140),
|
|
`language` varchar(140),
|
|
`image` text,
|
|
`title` varchar(140),
|
|
`disabled` int(1) not null default 0,
|
|
`unsubscribed` int(1) not null default 0,
|
|
`blog_subscriber` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `lead_name`(`lead_name`),
|
|
index `lead_owner`(`lead_owner`),
|
|
index `status`(`status`),
|
|
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:37,599 WARNING database DDL Query made to DB:
|
|
create table `tabLost Reason 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',
|
|
`lost_reason` 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:37,656 WARNING database DDL Query made to DB:
|
|
create table `tabMarket Segment` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`market_segment` 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
|