2978 lines
95 KiB
Groff
2978 lines
95 KiB
Groff
2025-05-20 13:10:03,662 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-05-20 13:10:03,732 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-05-20 13:10:03,805 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-05-20 13:10:03,883 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-05-20 13:10:03,973 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-05-20 13:10:04,045 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-05-20 13:10:04,138 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-05-20 13:10:04,352 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-05-20 13:10:04,418 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-05-20 13:10:04,489 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-05-20 13:10:04,556 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-05-20 13:10:04,705 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-05-20 13:10:05,016 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-05-20 13:10:05,341 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-05-20 13:10:05,408 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-05-20 13:10:05,473 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-05-20 13:10:05,544 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-05-20 13:10:05,687 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-05-20 13:10:05,744 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-05-20 13:10:05,908 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-05-20 13:10:05,975 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-05-20 13:10:06,042 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-05-20 13:10:06,151 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-05-20 13:10:07,182 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-05-20 13:10:07,243 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-05-20 13:10:07,312 WARNING database DDL Query made to DB:
|
|
create sequence if not exists prospect_opportunity_id_seq nocache nocycle
|
|
2025-05-20 13:10:07,327 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-05-20 13:10:07,385 WARNING database DDL Query made to DB:
|
|
create sequence if not exists crm_note_id_seq nocache nocycle
|
|
2025-05-20 13:10:07,401 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-05-20 13:10:07,497 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-05-20 13:10:07,580 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-05-20 13:10:07,726 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-05-20 13:10:07,883 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-05-20 13:10:07,968 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-05-20 13:10:08,063 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-05-20 13:10:08,135 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-05-20 13:10:08,221 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-05-20 13:10:08,306 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-05-20 13:10:08,375 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-05-20 13:10:08,445 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-05-20 13:10:08,519 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-05-20 13:10:08,588 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-05-20 13:10:08,680 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-05-20 13:10:08,760 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-05-20 13:10:08,858 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-05-20 13:10:08,948 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-05-20 13:10:09,030 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-05-20 13:10:09,174 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-05-20 13:10:09,319 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-05-20 13:10:09,407 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-05-20 13:10:09,471 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
|
|
2025-05-20 13:10:09,688 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Scorecard Scoring Standing` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`standing_name` varchar(140),
|
|
`standing_color` varchar(140),
|
|
`min_grade` decimal(21,9) not null default 0,
|
|
`max_grade` decimal(21,9) not null default 0,
|
|
`warn_rfqs` int(1) not null default 0,
|
|
`warn_pos` int(1) not null default 0,
|
|
`prevent_rfqs` int(1) not null default 0,
|
|
`prevent_pos` int(1) not null default 0,
|
|
`notify_supplier` int(1) not null default 0,
|
|
`notify_employee` int(1) not null default 0,
|
|
`employee_link` 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-05-20 13:10:09,783 WARNING database DDL Query made to DB:
|
|
create table `tabRequest for Quotation 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),
|
|
`supplier_part_no` varchar(140),
|
|
`item_name` varchar(140),
|
|
`schedule_date` date,
|
|
`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,
|
|
`warehouse` varchar(140),
|
|
`material_request` varchar(140),
|
|
`material_request_item` varchar(140),
|
|
`project_name` varchar(140),
|
|
`page_break` int(1) not null default 0,
|
|
index `item_code`(`item_code`),
|
|
index `item_name`(`item_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-05-20 13:10:09,858 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Scorecard Variable` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`variable_label` varchar(140) unique,
|
|
`is_custom` int(1) not null default 0,
|
|
`param_name` varchar(140) unique,
|
|
`path` 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-05-20 13:10:10,039 WARNING database DDL Query made to DB:
|
|
create table `tabPurchase Order 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',
|
|
`fg_item` varchar(140),
|
|
`fg_item_qty` decimal(21,9) not null default 1.0,
|
|
`item_code` varchar(140),
|
|
`supplier_part_no` varchar(140),
|
|
`item_name` varchar(140),
|
|
`brand` varchar(140),
|
|
`product_bundle` varchar(140),
|
|
`schedule_date` date,
|
|
`expected_delivery_date` date,
|
|
`item_group` varchar(140),
|
|
`description` longtext,
|
|
`image` text,
|
|
`qty` decimal(21,9) not null default 0,
|
|
`stock_uom` varchar(140),
|
|
`subcontracted_quantity` decimal(21,9) not null default 0,
|
|
`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,
|
|
`last_purchase_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,
|
|
`from_warehouse` varchar(140),
|
|
`warehouse` varchar(140),
|
|
`actual_qty` decimal(21,9) not null default 0,
|
|
`company_total_stock` decimal(21,9) not null default 0,
|
|
`material_request` varchar(140),
|
|
`material_request_item` varchar(140),
|
|
`sales_order` varchar(140),
|
|
`sales_order_item` varchar(140),
|
|
`sales_order_packed_item` varchar(140),
|
|
`supplier_quotation` varchar(140),
|
|
`supplier_quotation_item` varchar(140),
|
|
`delivered_by_supplier` int(1) not null default 0,
|
|
`against_blanket_order` int(1) not null default 0,
|
|
`blanket_order` varchar(140),
|
|
`blanket_order_rate` decimal(21,9) not null default 0,
|
|
`received_qty` decimal(21,9) not null default 0,
|
|
`returned_qty` decimal(21,9) not null default 0,
|
|
`billed_amt` decimal(21,9) not null default 0,
|
|
`expense_account` varchar(140),
|
|
`wip_composite_asset` varchar(140),
|
|
`manufacturer` varchar(140),
|
|
`manufacturer_part_no` varchar(140),
|
|
`bom` varchar(140),
|
|
`include_exploded_items` int(1) not null default 0,
|
|
`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),
|
|
`is_fixed_asset` int(1) not null default 0,
|
|
`item_tax_rate` longtext,
|
|
`production_plan` varchar(140),
|
|
`production_plan_item` varchar(140),
|
|
`production_plan_sub_assembly_item` varchar(140),
|
|
`page_break` int(1) not null default 0,
|
|
index `expected_delivery_date`(`expected_delivery_date`),
|
|
index `material_request`(`material_request`),
|
|
index `material_request_item`(`material_request_item`),
|
|
index `sales_order`(`sales_order`),
|
|
index `sales_order_item`(`sales_order_item`),
|
|
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-05-20 13:10:10,085 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabPurchase Order Item`
|
|
ADD INDEX IF NOT EXISTS `item_code_warehouse_index`(item_code, warehouse)
|
|
2025-05-20 13:10:10,150 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Scorecard` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`supplier_score` varchar(140),
|
|
`indicator_color` varchar(140),
|
|
`status` varchar(140),
|
|
`period` varchar(140) default 'Per Month',
|
|
`weighting_function` text default '{total_score} * max( 0, min ( 1 , (12 - {period_number}) / 12) )',
|
|
`warn_rfqs` int(1) not null default 0,
|
|
`warn_pos` int(1) not null default 0,
|
|
`prevent_rfqs` int(1) not null default 0,
|
|
`prevent_pos` int(1) not null default 0,
|
|
`notify_supplier` int(1) not null default 0,
|
|
`notify_employee` int(1) not null default 0,
|
|
`employee` 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-05-20 13:10:10,233 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Scorecard Criteria` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`criteria_name` varchar(140) unique,
|
|
`max_score` decimal(21,9) not null default 100.0,
|
|
`formula` text,
|
|
`weight` decimal(21,9) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:10,313 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Scorecard 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',
|
|
`supplier` varchar(140),
|
|
`naming_series` varchar(140),
|
|
`total_score` decimal(21,9) not null default 0,
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`scorecard` 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-05-20 13:10:10,456 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Quotation 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),
|
|
`supplier_part_no` varchar(140),
|
|
`item_name` varchar(140),
|
|
`lead_time_days` int(11) not null default 0,
|
|
`expected_delivery_date` date,
|
|
`is_free_item` int(1) not null default 0,
|
|
`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,
|
|
`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_price_list_rate` 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,
|
|
`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,
|
|
`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),
|
|
`prevdoc_doctype` varchar(140),
|
|
`material_request` varchar(140),
|
|
`sales_order` varchar(140),
|
|
`request_for_quotation` varchar(140),
|
|
`material_request_item` varchar(140),
|
|
`request_for_quotation_item` varchar(140),
|
|
`item_tax_rate` longtext,
|
|
`manufacturer` varchar(140),
|
|
`manufacturer_part_no` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`page_break` int(1) not null default 0,
|
|
index `item_code`(`item_code`),
|
|
index `item_name`(`item_name`),
|
|
index `material_request`(`material_request`),
|
|
index `sales_order`(`sales_order`),
|
|
index `material_request_item`(`material_request_item`),
|
|
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-05-20 13:10:10,640 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Quotation` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`company` varchar(140),
|
|
`status` varchar(140),
|
|
`transaction_date` date,
|
|
`valid_till` date,
|
|
`quotation_number` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`currency` varchar(140),
|
|
`conversion_rate` decimal(21,9) 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,
|
|
`total_qty` decimal(21,9) not null default 0,
|
|
`total_net_weight` decimal(21,9) not null default 0,
|
|
`base_total` decimal(21,9) not null default 0,
|
|
`base_net_total` decimal(21,9) not null default 0,
|
|
`total` decimal(21,9) not null default 0,
|
|
`net_total` decimal(21,9) not null default 0,
|
|
`tax_category` varchar(140),
|
|
`taxes_and_charges` varchar(140),
|
|
`shipping_rule` varchar(140),
|
|
`incoterm` varchar(140),
|
|
`named_place` varchar(140),
|
|
`base_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,
|
|
`apply_discount_on` varchar(140) default 'Grand Total',
|
|
`base_discount_amount` decimal(21,9) not null default 0,
|
|
`additional_discount_percentage` decimal(21,9) not null default 0,
|
|
`discount_amount` decimal(21,9) not null default 0,
|
|
`base_grand_total` decimal(21,9) not null default 0,
|
|
`base_rounding_adjustment` decimal(21,9) not null default 0,
|
|
`base_rounded_total` decimal(21,9) not null default 0,
|
|
`base_in_words` varchar(240),
|
|
`grand_total` decimal(21,9) not null default 0,
|
|
`rounding_adjustment` decimal(21,9) not null default 0,
|
|
`rounded_total` decimal(21,9) not null default 0,
|
|
`in_words` varchar(240),
|
|
`disable_rounded_total` int(1) not null default 0,
|
|
`other_charges_calculation` longtext,
|
|
`supplier_address` varchar(140),
|
|
`address_display` text,
|
|
`contact_person` varchar(140),
|
|
`contact_display` text,
|
|
`contact_mobile` text,
|
|
`contact_email` varchar(140),
|
|
`shipping_address` varchar(140),
|
|
`shipping_address_display` text,
|
|
`billing_address` varchar(140),
|
|
`billing_address_display` text,
|
|
`tc_name` varchar(140),
|
|
`terms` longtext,
|
|
`letter_head` varchar(140),
|
|
`group_same_items` int(1) not null default 0,
|
|
`select_print_heading` varchar(140),
|
|
`language` varchar(140),
|
|
`auto_repeat` varchar(140),
|
|
`is_subcontracted` int(1) not null default 0,
|
|
`opportunity` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `supplier`(`supplier`),
|
|
index `company`(`company`),
|
|
index `status`(`status`),
|
|
index `transaction_date`(`transaction_date`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:10,729 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Scorecard Scoring Variable` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`variable_label` varchar(140),
|
|
`description` text,
|
|
`value` decimal(21,9) not null default 0,
|
|
`param_name` varchar(140),
|
|
`path` 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-05-20 13:10:10,868 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`supplier_name` varchar(140),
|
|
`country` varchar(140),
|
|
`supplier_group` varchar(140),
|
|
`supplier_type` varchar(140) default 'Company',
|
|
`is_transporter` int(1) not null default 0,
|
|
`image` text,
|
|
`default_currency` varchar(140),
|
|
`default_bank_account` varchar(140),
|
|
`default_price_list` varchar(140),
|
|
`is_internal_supplier` int(1) not null default 0,
|
|
`represents_company` varchar(140),
|
|
`supplier_details` text,
|
|
`website` varchar(140),
|
|
`language` varchar(140),
|
|
`tax_id` varchar(140),
|
|
`tax_category` varchar(140),
|
|
`tax_withholding_category` varchar(140),
|
|
`supplier_primary_address` varchar(140),
|
|
`primary_address` text,
|
|
`supplier_primary_contact` varchar(140),
|
|
`mobile_no` varchar(140),
|
|
`email_id` varchar(140),
|
|
`payment_terms` varchar(140),
|
|
`allow_purchase_invoice_creation_without_purchase_order` int(1) not null default 0,
|
|
`allow_purchase_invoice_creation_without_purchase_receipt` int(1) not null default 0,
|
|
`is_frozen` int(1) not null default 0,
|
|
`disabled` int(1) not null default 0,
|
|
`warn_rfqs` int(1) not null default 0,
|
|
`warn_pos` int(1) not null default 0,
|
|
`prevent_rfqs` int(1) not null default 0,
|
|
`prevent_pos` int(1) not null default 0,
|
|
`on_hold` int(1) not null default 0,
|
|
`hold_type` varchar(140),
|
|
`release_date` date,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:10,980 WARNING database DDL Query made to DB:
|
|
create table `tabPurchase Order Item Supplied` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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_item_code` varchar(140),
|
|
`rm_item_code` varchar(140),
|
|
`stock_uom` varchar(140),
|
|
`reserve_warehouse` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 0,
|
|
`bom_detail_no` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`required_qty` decimal(21,9) not null default 0,
|
|
`supplied_qty` decimal(21,9) not null default 0,
|
|
`consumed_qty` decimal(21,9) not null default 0,
|
|
`returned_qty` decimal(21,9) not null default 0,
|
|
`total_supplied_qty` 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-05-20 13:10:11,156 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Scorecard Scoring Criteria` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`criteria_name` varchar(140),
|
|
`score` decimal(21,9) not null default 0,
|
|
`weight` decimal(21,9) not null default 0,
|
|
`max_score` decimal(21,9) not null default 100.0,
|
|
`formula` text,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:11,265 WARNING database DDL Query made to DB:
|
|
create table `tabRequest for Quotation` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`company` varchar(140),
|
|
`billing_address` varchar(140),
|
|
`billing_address_display` text,
|
|
`vendor` varchar(140),
|
|
`transaction_date` date,
|
|
`schedule_date` date,
|
|
`status` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`email_template` varchar(140),
|
|
`send_attached_files` int(1) not null default 1,
|
|
`send_document_print` int(1) not null default 0,
|
|
`message_for_supplier` longtext,
|
|
`incoterm` varchar(140),
|
|
`named_place` varchar(140),
|
|
`tc_name` varchar(140),
|
|
`terms` longtext,
|
|
`select_print_heading` varchar(140),
|
|
`letter_head` varchar(140),
|
|
`opportunity` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `company`(`company`),
|
|
index `transaction_date`(`transaction_date`),
|
|
index `status`(`status`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:11,592 WARNING database DDL Query made to DB:
|
|
create table `tabPurchase Order` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`title` varchar(140) default '{supplier_name}',
|
|
`naming_series` varchar(140),
|
|
`supplier` varchar(140),
|
|
`supplier_name` varchar(140),
|
|
`order_confirmation_no` varchar(140),
|
|
`order_confirmation_date` date,
|
|
`transaction_date` date,
|
|
`schedule_date` date,
|
|
`company` varchar(140),
|
|
`apply_tds` int(1) not null default 0,
|
|
`tax_withholding_category` varchar(140),
|
|
`is_subcontracted` int(1) not null default 0,
|
|
`supplier_warehouse` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`currency` varchar(140),
|
|
`conversion_rate` decimal(21,9) 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),
|
|
`set_from_warehouse` varchar(140),
|
|
`set_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,
|
|
`set_reserve_warehouse` varchar(140),
|
|
`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_in_words` varchar(240),
|
|
`base_rounded_total` decimal(21,9) not null default 0,
|
|
`grand_total` decimal(21,9) not null default 0,
|
|
`rounding_adjustment` decimal(21,9) not null default 0,
|
|
`rounded_total` decimal(21,9) not null default 0,
|
|
`disable_rounded_total` int(1) not null default 0,
|
|
`in_words` varchar(240),
|
|
`advance_paid` decimal(21,9) 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,
|
|
`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,
|
|
`customer` varchar(140),
|
|
`customer_name` varchar(140),
|
|
`customer_contact_person` varchar(140),
|
|
`customer_contact_display` text,
|
|
`customer_contact_mobile` text,
|
|
`customer_contact_email` longtext,
|
|
`payment_terms_template` varchar(140),
|
|
`tc_name` varchar(140),
|
|
`terms` longtext,
|
|
`status` varchar(140) default 'Draft',
|
|
`per_billed` decimal(21,9) not null default 0,
|
|
`per_received` decimal(21,9) not null default 0,
|
|
`letter_head` varchar(140),
|
|
`group_same_items` int(1) not null default 0,
|
|
`select_print_heading` varchar(140),
|
|
`language` varchar(140),
|
|
`from_date` date,
|
|
`to_date` date,
|
|
`auto_repeat` varchar(140),
|
|
`is_internal_supplier` int(1) not null default 0,
|
|
`represents_company` varchar(140),
|
|
`ref_sq` varchar(140),
|
|
`party_account_currency` varchar(140),
|
|
`inter_company_order_reference` varchar(140),
|
|
`is_old_subcontracting_flow` int(1) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `supplier`(`supplier`),
|
|
index `transaction_date`(`transaction_date`),
|
|
index `status`(`status`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:11,700 WARNING database DDL Query made to DB:
|
|
create table `tabPurchase Receipt Item Supplied` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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_item_code` varchar(140),
|
|
`rm_item_code` varchar(140),
|
|
`item_name` varchar(140),
|
|
`bom_detail_no` varchar(140),
|
|
`description` longtext,
|
|
`stock_uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 0,
|
|
`reference_name` varchar(140),
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`required_qty` decimal(21,9) not null default 0,
|
|
`consumed_qty` decimal(21,9) not null default 0,
|
|
`current_stock` decimal(21,9) not null default 0,
|
|
`batch_no` varchar(140),
|
|
`serial_no` text,
|
|
`purchase_order` 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-05-20 13:10:11,781 WARNING database DDL Query made to DB:
|
|
create table `tabSupplier Scorecard Standing` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`standing_name` varchar(140) unique,
|
|
`standing_color` varchar(140),
|
|
`min_grade` decimal(21,9) not null default 0,
|
|
`max_grade` decimal(21,9) not null default 0,
|
|
`warn_rfqs` int(1) not null default 0,
|
|
`warn_pos` int(1) not null default 0,
|
|
`prevent_rfqs` int(1) not null default 0,
|
|
`prevent_pos` int(1) not null default 0,
|
|
`notify_supplier` int(1) not null default 0,
|
|
`notify_employee` int(1) not null default 0,
|
|
`employee_link` 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-05-20 13:10:11,845 WARNING database DDL Query made to DB:
|
|
create table `tabRequest for Quotation Supplier` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`contact` varchar(140),
|
|
`quote_status` varchar(140),
|
|
`supplier_name` varchar(140),
|
|
`email_id` varchar(140),
|
|
`send_email` int(1) not null default 1,
|
|
`email_sent` 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-05-20 13:10:12,130 WARNING database DDL Query made to DB:
|
|
create table `tabProject` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`project_name` varchar(140) unique,
|
|
`status` varchar(140) default 'Open',
|
|
`project_type` varchar(140),
|
|
`is_active` varchar(140),
|
|
`percent_complete_method` varchar(140) default 'Task Completion',
|
|
`percent_complete` decimal(21,9) not null default 0,
|
|
`project_template` varchar(140),
|
|
`expected_start_date` date,
|
|
`expected_end_date` date,
|
|
`priority` varchar(140),
|
|
`department` varchar(140),
|
|
`customer` varchar(140),
|
|
`sales_order` varchar(140),
|
|
`copied_from` varchar(140),
|
|
`notes` longtext,
|
|
`actual_start_date` date,
|
|
`actual_time` decimal(21,9) not null default 0,
|
|
`actual_end_date` date,
|
|
`estimated_costing` decimal(21,9) not null default 0,
|
|
`total_costing_amount` decimal(21,9) not null default 0,
|
|
`total_purchase_cost` decimal(21,9) not null default 0,
|
|
`company` varchar(140),
|
|
`total_sales_amount` decimal(21,9) not null default 0,
|
|
`total_billable_amount` decimal(21,9) not null default 0,
|
|
`total_billed_amount` decimal(21,9) not null default 0,
|
|
`total_consumed_material_cost` decimal(21,9) not null default 0,
|
|
`cost_center` varchar(140),
|
|
`gross_margin` decimal(21,9) not null default 0,
|
|
`per_gross_margin` decimal(21,9) not null default 0,
|
|
`collect_progress` int(1) not null default 0,
|
|
`holiday_list` varchar(140),
|
|
`frequency` varchar(140),
|
|
`from_time` time(6),
|
|
`to_time` time(6),
|
|
`first_email` time(6),
|
|
`second_email` time(6),
|
|
`daily_time_to_send` time(6),
|
|
`day_to_send` varchar(140),
|
|
`weekly_time_to_send` time(6),
|
|
`message` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index `status`(`status`),
|
|
index `customer`(`customer`),
|
|
index `collect_progress`(`collect_progress`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:12,216 WARNING database DDL Query made to DB:
|
|
create table `tabProject Template Task` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`task` varchar(140),
|
|
`subject` 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-05-20 13:10:12,274 WARNING database DDL Query made to DB:
|
|
create table `tabProject 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',
|
|
`project_type` 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-05-20 13:10:12,338 WARNING database DDL Query made to DB:
|
|
create table `tabDependent Task` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`task` 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-05-20 13:10:12,405 WARNING database DDL Query made to DB:
|
|
create table `tabProject Update` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`project` varchar(140),
|
|
`sent` int(1) not null default 0,
|
|
`date` date,
|
|
`time` time(6),
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `date`(`date`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:12,469 WARNING database DDL Query made to DB:
|
|
create table `tabActivity 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',
|
|
`activity_type` varchar(140),
|
|
`costing_rate` decimal(21,9) not null default 0,
|
|
`billing_rate` decimal(21,9) not null default 0,
|
|
`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-05-20 13:10:12,538 WARNING database DDL Query made to DB:
|
|
create table `tabTask Depends On` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`task` varchar(140),
|
|
`subject` text,
|
|
`project` text,
|
|
parent varchar(140),
|
|
parentfield varchar(140),
|
|
parenttype varchar(140),
|
|
index parent(parent))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:12,605 WARNING database DDL Query made to DB:
|
|
create table `tabProject User` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`user` varchar(140),
|
|
`email` varchar(140),
|
|
`image` varchar(140),
|
|
`full_name` varchar(140),
|
|
`welcome_email_sent` int(1) not null default 0,
|
|
`view_attachments` int(1) not null default 0,
|
|
`hide_timesheets` int(1) not null default 0,
|
|
`project_status` text,
|
|
index `user`(`user`),
|
|
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-05-20 13:10:12,716 WARNING database DDL Query made to DB:
|
|
create table `tabTask` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`subject` varchar(140),
|
|
`project` varchar(140),
|
|
`issue` varchar(140),
|
|
`type` varchar(140),
|
|
`color` varchar(140),
|
|
`is_group` int(1) not null default 0,
|
|
`is_template` int(1) not null default 0,
|
|
`status` varchar(140),
|
|
`priority` varchar(140),
|
|
`task_weight` decimal(21,9) not null default 0,
|
|
`parent_task` varchar(140),
|
|
`completed_by` varchar(140),
|
|
`completed_on` date,
|
|
`exp_start_date` date,
|
|
`expected_time` decimal(21,9) not null default 0,
|
|
`start` int(11) not null default 0,
|
|
`exp_end_date` date,
|
|
`progress` decimal(21,9) not null default 0,
|
|
`duration` int(11) not null default 0,
|
|
`is_milestone` int(1) not null default 0,
|
|
`description` longtext,
|
|
`depends_on_tasks` longtext,
|
|
`act_start_date` date,
|
|
`actual_time` decimal(21,9) not null default 0,
|
|
`act_end_date` date,
|
|
`total_costing_amount` decimal(21,9) not null default 0,
|
|
`total_billing_amount` decimal(21,9) not null default 0,
|
|
`review_date` date,
|
|
`closing_date` date,
|
|
`department` varchar(140),
|
|
`company` varchar(140),
|
|
`lft` int(11) not null default 0,
|
|
`rgt` int(11) not null default 0,
|
|
`old_parent` varchar(140),
|
|
`template_task` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index `subject`(`subject`),
|
|
index `project`(`project`),
|
|
index `priority`(`priority`),
|
|
index `parent_task`(`parent_task`),
|
|
index `exp_end_date`(`exp_end_date`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:12,756 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabTask`
|
|
ADD INDEX IF NOT EXISTS `lft_rgt_index`(lft, rgt)
|
|
2025-05-20 13:10:12,799 WARNING database DDL Query made to DB:
|
|
create table `tabProject 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',
|
|
`project_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-05-20 13:10:12,934 WARNING database DDL Query made to DB:
|
|
create table `tabTimesheet 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',
|
|
`activity_type` varchar(140),
|
|
`from_time` datetime(6),
|
|
`description` text,
|
|
`expected_hours` decimal(21,9) not null default 0,
|
|
`to_time` datetime(6),
|
|
`hours` decimal(21,9) not null default 0,
|
|
`completed` int(1) not null default 0,
|
|
`project` varchar(140),
|
|
`project_name` varchar(140),
|
|
`task` varchar(140),
|
|
`is_billable` int(1) not null default 0,
|
|
`sales_invoice` varchar(140),
|
|
`billing_hours` decimal(21,9) not null default 0,
|
|
`base_billing_rate` decimal(21,9) not null default 0,
|
|
`base_billing_amount` decimal(21,9) not null default 0,
|
|
`base_costing_rate` decimal(21,9) not null default 0,
|
|
`base_costing_amount` decimal(21,9) not null default 0,
|
|
`billing_rate` decimal(21,9) not null default 0,
|
|
`billing_amount` decimal(21,9) not null default 0,
|
|
`costing_rate` decimal(21,9) not null default 0,
|
|
`costing_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-05-20 13:10:13,025 WARNING database DDL Query made to DB:
|
|
create table `tabTimesheet` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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 '{employee_name}',
|
|
`naming_series` varchar(140),
|
|
`company` varchar(140),
|
|
`customer` varchar(140),
|
|
`currency` varchar(140),
|
|
`exchange_rate` decimal(21,9) not null default 1.0,
|
|
`sales_invoice` varchar(140),
|
|
`status` varchar(140) default 'Draft',
|
|
`parent_project` varchar(140),
|
|
`employee` varchar(140),
|
|
`employee_name` varchar(140),
|
|
`department` varchar(140),
|
|
`user` varchar(140),
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`total_hours` decimal(21,9) not null default 0,
|
|
`total_billable_hours` decimal(21,9) not null default 0,
|
|
`base_total_billable_amount` decimal(21,9) not null default 0,
|
|
`base_total_billed_amount` decimal(21,9) not null default 0,
|
|
`base_total_costing_amount` decimal(21,9) not null default 0,
|
|
`total_billed_hours` decimal(21,9) not null default 0,
|
|
`total_billable_amount` decimal(21,9) not null default 0,
|
|
`total_billed_amount` decimal(21,9) not null default 0,
|
|
`total_costing_amount` decimal(21,9) not null default 0,
|
|
`per_billed` decimal(21,9) not null default 0,
|
|
`note` 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-05-20 13:10:13,125 WARNING database DDL Query made to DB:
|
|
create table `tabActivity Cost` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
modified datetime(6),
|
|
modified_by varchar(140),
|
|
owner varchar(140),
|
|
docstatus int(1) not null default '0',
|
|
idx int(8) not null default '0',
|
|
`activity_type` varchar(140),
|
|
`employee` varchar(140),
|
|
`employee_name` varchar(140),
|
|
`department` varchar(140),
|
|
`billing_rate` decimal(21,9) not null default 0,
|
|
`costing_rate` decimal(21,9) not null default 0,
|
|
`title` 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-05-20 13:10:13,194 WARNING database DDL Query made to DB:
|
|
create table `tabTask 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',
|
|
`weight` decimal(21,9) 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-05-20 13:10:13,499 WARNING database DDL Query made to DB:
|
|
create table `tabSales Order 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),
|
|
`customer_item_code` varchar(140),
|
|
`ensure_delivery_based_on_produced_serial_no` int(1) not null default 0,
|
|
`is_stock_item` int(1) not null default 0,
|
|
`reserve_stock` int(1) not null default 1,
|
|
`delivery_date` date,
|
|
`item_name` 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,
|
|
`stock_reserved_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,
|
|
`billed_amt` decimal(21,9) not null default 0,
|
|
`valuation_rate` decimal(21,9) not null default 0,
|
|
`gross_profit` decimal(21,9) not null default 0,
|
|
`delivered_by_supplier` int(1) not null default 0,
|
|
`supplier` 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),
|
|
`warehouse` varchar(140),
|
|
`target_warehouse` varchar(140),
|
|
`prevdoc_docname` varchar(140),
|
|
`quotation_item` varchar(140),
|
|
`against_blanket_order` int(1) not null default 0,
|
|
`blanket_order` varchar(140),
|
|
`blanket_order_rate` decimal(21,9) not null default 0,
|
|
`actual_qty` decimal(21,9) not null default 0,
|
|
`company_total_stock` decimal(21,9) not null default 0,
|
|
`bom_no` varchar(140),
|
|
`projected_qty` decimal(21,9) not null default 0,
|
|
`ordered_qty` decimal(21,9) not null default 0,
|
|
`planned_qty` decimal(21,9) not null default 0,
|
|
`production_plan_qty` decimal(21,9) not null default 0,
|
|
`work_order_qty` decimal(21,9) not null default 0,
|
|
`delivered_qty` decimal(21,9) not null default 0,
|
|
`produced_qty` decimal(21,9) not null default 0,
|
|
`returned_qty` decimal(21,9) not null default 0,
|
|
`picked_qty` decimal(21,9) not null default 0,
|
|
`additional_notes` text,
|
|
`page_break` int(1) not null default 0,
|
|
`item_tax_rate` longtext,
|
|
`transaction_date` date,
|
|
`material_request` varchar(140),
|
|
`purchase_order` varchar(140),
|
|
`material_request_item` varchar(140),
|
|
`purchase_order_item` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
index `prevdoc_docname`(`prevdoc_docname`),
|
|
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-05-20 13:10:13,565 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabSales Order Item`
|
|
ADD INDEX IF NOT EXISTS `item_code_warehouse_index`(item_code, warehouse)
|
|
2025-05-20 13:10:13,639 WARNING database DDL Query made to DB:
|
|
create table `tabInstallation Note` (
|
|
name varchar(140) primary key,
|
|
creation datetime(6),
|
|
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),
|
|
`customer` varchar(140),
|
|
`customer_address` varchar(140),
|
|
`contact_person` varchar(140),
|
|
`customer_name` varchar(140),
|
|
`address_display` text,
|
|
`contact_display` text,
|
|
`contact_mobile` text,
|
|
`contact_email` varchar(140),
|
|
`territory` varchar(140),
|
|
`customer_group` varchar(140),
|
|
`inst_date` date,
|
|
`inst_time` time(6),
|
|
`status` varchar(140) default 'Draft',
|
|
`company` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`remarks` text,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `customer`(`customer`),
|
|
index `territory`(`territory`),
|
|
index `inst_date`(`inst_date`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|