2025-06-23 23:36:12,603 WARNING database DDL Query made to DB: create table `tabSales Person` ( name varchar(140) primary key, creation datetime(6), 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_person_name` varchar(140) unique, `parent_sales_person` varchar(140), `commission_rate` varchar(140), `is_group` int(1) not null default 0, `enabled` int(1) not null default 1, `employee` varchar(140), `department` varchar(140), `lft` int(11) not null default 0, `rgt` int(11) not null default 0, `old_parent` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `lft`(`lft`), index `rgt`(`rgt`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:12,666 WARNING database DDL Query made to DB: ALTER TABLE `tabSales Person` ADD INDEX IF NOT EXISTS `lft_rgt_index`(lft, rgt) 2025-06-23 23:36:12,728 WARNING database DDL Query made to DB: create table `tabDriver` ( name varchar(140) primary key, creation datetime(6), 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), `full_name` varchar(140), `status` varchar(140), `transporter` varchar(140), `employee` varchar(140), `cell_number` varchar(140), `address` varchar(140), `license_number` varchar(140), `issuing_date` date, `expiry_date` date, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:12,815 WARNING database DDL Query made to DB: create table `tabEmail Digest Recipient` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `recipient` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:12,890 WARNING database DDL Query made to DB: create table `tabHoliday` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `holiday_date` date, `weekly_off` int(1) not null default 0, `description` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:12,961 WARNING database DDL Query made to DB: create table `tabEmployee External Work History` ( name varchar(140) primary key, creation datetime(6), 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), `designation` varchar(140), `salary` decimal(21,9) not null default 0, `address` text, `contact` varchar(140), `total_experience` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,042 WARNING database DDL Query made to DB: create table `tabIncoterm` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `code` varchar(3) unique, `title` varchar(140), `description` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,135 WARNING database DDL Query made to DB: create table `tabQuotation Lost Reason Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `lost_reason` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,201 WARNING database DDL Query made to DB: create table `tabParty 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', `party_type` varchar(140), `account_type` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,340 WARNING database DDL Query made to DB: create table `tabUOM` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `enabled` int(1) not null default 1, `uom_name` varchar(140) unique, `must_be_whole_number` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,454 WARNING database DDL Query made to DB: create table `tabSales Partner` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `partner_name` varchar(140) unique, `partner_type` varchar(140), `territory` varchar(140), `commission_rate` decimal(21,9) not null default 0, `show_in_website` int(1) not null default 0, `referral_code` varchar(8) unique, `route` varchar(140) unique, `logo` text, `partner_website` varchar(140), `introduction` text, `description` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,568 WARNING database DDL Query made to DB: create table `tabEmail Digest` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `enabled` int(1) not null default 0, `company` varchar(140), `frequency` varchar(140), `next_send` varchar(140), `income` int(1) not null default 0, `expenses_booked` int(1) not null default 0, `income_year_to_date` int(1) not null default 0, `expense_year_to_date` int(1) not null default 0, `bank_balance` int(1) not null default 0, `credit_balance` int(1) not null default 0, `invoiced_amount` int(1) not null default 0, `payables` int(1) not null default 0, `sales_orders_to_bill` int(1) not null default 0, `purchase_orders_to_bill` int(1) not null default 0, `sales_order` int(1) not null default 0, `purchase_order` int(1) not null default 0, `sales_orders_to_deliver` int(1) not null default 0, `purchase_orders_to_receive` int(1) not null default 0, `sales_invoice` int(1) not null default 0, `purchase_invoice` int(1) not null default 0, `new_quotations` int(1) not null default 0, `pending_quotations` int(1) not null default 0, `issue` int(1) not null default 0, `project` int(1) not null default 0, `purchase_orders_items_overdue` int(1) not null default 0, `calendar_events` int(1) not null default 0, `todo_list` int(1) not null default 0, `notifications` int(1) not null default 0, `add_quote` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,645 WARNING database DDL Query made to DB: create table `tabDepartment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `department_name` varchar(140), `parent_department` varchar(140), `company` varchar(140), `is_group` int(1) not null default 0, `disabled` int(1) not null default 0, `lft` int(11) not null default 0, `rgt` int(11) not null default 0, `old_parent` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,711 WARNING database DDL Query made to DB: ALTER TABLE `tabDepartment` ADD INDEX IF NOT EXISTS `lft_rgt_index`(lft, rgt) 2025-06-23 23:36:13,762 WARNING database DDL Query made to DB: create table `tabTarget 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', `item_group` varchar(140), `fiscal_year` varchar(140), `target_qty` decimal(21,9) not null default 0, `target_amount` decimal(21,9) not null default 0, `distribution_id` varchar(140), index `item_group`(`item_group`), index `fiscal_year`(`fiscal_year`), index `target_amount`(`target_amount`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:13,858 WARNING database DDL Query made to DB: ALTER TABLE `tabPrint Heading` ADD UNIQUE INDEX IF NOT EXISTS print_heading (`print_heading`) 2025-06-23 23:36:13,927 WARNING database DDL Query made to DB: create table `tabQuotation 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', `order_lost_reason` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,164 WARNING database DDL Query made to DB: create table `tabProduction Plan Material 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', `material_request` varchar(140), `material_request_date` date, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,231 WARNING database DDL Query made to DB: create table `tabBOM Website Operation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `operation` varchar(140), `workstation` varchar(140), `time_in_mins` decimal(21,9) not null default 0, `website_image` text, `thumbnail` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,326 WARNING database DDL Query made to DB: create table `tabProduction Plan Sub Assembly 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', `production_item` varchar(140), `item_name` varchar(140), `fg_warehouse` varchar(140), `parent_item_code` varchar(140), `schedule_date` datetime(6), `qty` decimal(21,9) not null default 0, `bom_no` varchar(140), `bom_level` int(11) not null default 0, `type_of_manufacturing` varchar(140) default 'In House', `supplier` varchar(140), `wo_produced_qty` decimal(21,9) not null default 0, `purchase_order` varchar(140), `production_plan_item` varchar(140), `received_qty` decimal(21,9) not null default 0, `indent` int(11) not null default 0, `uom` varchar(140), `stock_uom` varchar(140), `description` text, `actual_qty` decimal(21,9) not null default 0, `projected_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-06-23 23:36:14,393 WARNING database DDL Query made to DB: create table `tabBOM Update Batch` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `level` int(11) not null default 0, `batch_no` int(11) not null default 0, `boms_updated` longtext, `status` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,466 WARNING database DDL Query made to DB: create table `tabWorkstation Working Hour` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `start_time` time(6), `hours` decimal(21,9) not null default 0, `end_time` time(6), `enabled` int(1) not null default 1, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,534 WARNING database DDL Query made to DB: create table `tabSub Operation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `operation` varchar(140), `time_in_mins` decimal(21,9) not null default 0, `description` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,613 WARNING database DDL Query made to DB: create table `tabBOM Update Log` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `update_type` varchar(140), `status` varchar(140), `current_bom` varchar(140), `new_bom` varchar(140), `error_log` varchar(140), `current_level` int(11) not null default 0, `processed_boms` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,716 WARNING database DDL Query made to DB: create table `tabMaterial Request Plan 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), `from_warehouse` varchar(140), `warehouse` varchar(140), `item_name` varchar(140), `material_request_type` varchar(140), `quantity` decimal(21,9) not null default 0, `required_bom_qty` decimal(21,9) not null default 0, `schedule_date` date, `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `description` longtext, `min_order_qty` decimal(21,9) not null default 0, `sales_order` varchar(140), `actual_qty` decimal(21,9) not null default 0, `requested_qty` decimal(21,9) not null default 0, `reserved_qty_for_production` decimal(21,9) not null default 0, `ordered_qty` decimal(21,9) not null default 0, `projected_qty` decimal(21,9) not null default 0, `safety_stock` decimal(21,9) not null default 0, index `item_code`(`item_code`), index `from_warehouse`(`from_warehouse`), index `warehouse`(`warehouse`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,781 WARNING database DDL Query made to DB: create table `tabProduction Plan Material Request Warehouse` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `warehouse` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,852 WARNING database DDL Query made to DB: create table `tabJob Card Scrap 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), `description` text, `stock_qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:14,918 WARNING database DDL Query made to DB: create table `tabJob Card Scheduled Time` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `from_time` datetime(6), `to_time` datetime(6), `time_in_mins` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,057 WARNING database DDL Query made to DB: create table `tabWork Order` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `status` varchar(140) default 'Draft', `production_item` varchar(140), `item_name` varchar(140), `image` text, `bom_no` varchar(140), `sales_order` varchar(140), `company` varchar(140), `qty` decimal(21,9) not null default 1.0, `material_transferred_for_manufacturing` decimal(21,9) not null default 0, `produced_qty` decimal(21,9) not null default 0, `process_loss_qty` decimal(21,9) not null default 0, `project` varchar(140), `allow_alternative_item` int(1) not null default 0, `use_multi_level_bom` int(1) not null default 1, `skip_transfer` int(1) not null default 0, `from_wip_warehouse` int(1) not null default 0, `update_consumed_material_cost_in_project` int(1) not null default 1, `source_warehouse` varchar(140), `wip_warehouse` varchar(140), `fg_warehouse` varchar(140), `scrap_warehouse` varchar(140), `has_serial_no` int(1) not null default 0, `has_batch_no` int(1) not null default 0, `batch_size` decimal(21,9) not null default 0, `transfer_material_against` varchar(140), `planned_start_date` datetime(6), `planned_end_date` datetime(6), `expected_delivery_date` date, `actual_start_date` datetime(6), `actual_end_date` datetime(6), `lead_time` decimal(21,9) not null default 0, `planned_operating_cost` decimal(21,9) not null default 0, `actual_operating_cost` decimal(21,9) not null default 0, `additional_operating_cost` decimal(21,9) not null default 0, `corrective_operation_cost` decimal(21,9) not null default 0, `total_operating_cost` decimal(21,9) not null default 0, `description` text, `stock_uom` varchar(140), `material_request` varchar(140), `material_request_item` varchar(140), `sales_order_item` varchar(140), `production_plan` varchar(140), `production_plan_item` varchar(140), `production_plan_sub_assembly_item` varchar(140), `product_bundle_item` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index `status`(`status`), index `production_plan`(`production_plan`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,134 WARNING database DDL Query made to DB: create table `tabJob Card Operation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `sub_operation` varchar(140), `completed_time` varchar(140), `status` varchar(140) default 'Pending', `completed_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-06-23 23:36:15,209 WARNING database DDL Query made to DB: create table `tabBlanket 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), `item_name` varchar(140), `party_item_code` varchar(140), `qty` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `ordered_qty` decimal(21,9) not null default 0, `terms_and_conditions` text, index `item_code`(`item_code`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,308 WARNING database DDL Query made to DB: create table `tabBOM 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), `operation` varchar(140), `do_not_explode` int(1) not null default 0, `bom_no` varchar(140), `source_warehouse` varchar(140), `allow_alternative_item` int(1) not null default 0, `is_stock_item` int(1) not null default 0, `description` longtext, `image` text, `qty` decimal(21,9) not null default 0, `uom` varchar(140), `stock_qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `base_rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, `qty_consumed_per_unit` decimal(21,9) not null default 0, `has_variants` int(1) not null default 0, `include_item_in_manufacturing` int(1) not null default 0, `original_item` varchar(140), `sourced_by_supplier` int(1) not null default 0, index `item_code`(`item_code`), index `bom_no`(`bom_no`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,385 WARNING database DDL Query made to DB: create table `tabJob Card Time Log` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `from_time` datetime(6), `to_time` datetime(6), `time_in_mins` decimal(21,9) not null default 0, `completed_qty` decimal(21,9) not null default 0, `operation` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,455 WARNING database DDL Query made to DB: create table `tabRouting` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `routing_name` varchar(140) unique, `disabled` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,539 WARNING database DDL Query made to DB: create table `tabBOM Scrap 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), `stock_qty` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `stock_uom` varchar(140), `base_rate` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,667 WARNING database DDL Query made to DB: create table `tabJob Card` ( name varchar(140) primary key, creation datetime(6), 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 'PO-JOB.#####', `work_order` varchar(140), `bom_no` varchar(140), `production_item` varchar(140), `posting_date` date, `company` varchar(140), `for_quantity` decimal(21,9) not null default 0, `total_completed_qty` decimal(21,9) not null default 0, `process_loss_qty` decimal(21,9) not null default 0, `expected_start_date` datetime(6), `time_required` decimal(21,9) not null default 0, `expected_end_date` datetime(6), `actual_start_date` datetime(6), `total_time_in_mins` decimal(21,9) not null default 0, `actual_end_date` datetime(6), `operation` varchar(140), `wip_warehouse` varchar(140), `workstation_type` varchar(140), `workstation` varchar(140), `quality_inspection_template` varchar(140), `quality_inspection` varchar(140), `for_job_card` varchar(140), `is_corrective_job_card` int(1) not null default 0, `hour_rate` decimal(21,9) not null default 0, `for_operation` varchar(140), `project` varchar(140), `item_name` varchar(140), `transferred_qty` decimal(21,9) not null default 0, `requested_qty` decimal(21,9) not null default 0, `status` varchar(140) default 'Open', `operation_row_number` varchar(140), `operation_id` varchar(140), `sequence_id` int(11) not null default 0, `remarks` text, `serial_and_batch_bundle` varchar(140), `batch_no` varchar(140), `serial_no` text, `barcode` longtext, `job_started` int(1) not null default 0, `started_time` datetime(6), `current_time` int(11) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `work_order`(`work_order`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,768 WARNING database DDL Query made to DB: create table `tabWork 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', `operation` varchar(140), `item_code` varchar(140), `source_warehouse` varchar(140), `item_name` varchar(140), `description` text, `allow_alternative_item` int(1) not null default 0, `include_item_in_manufacturing` int(1) not null default 0, `required_qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `transferred_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, `available_qty_at_source_warehouse` decimal(21,9) not null default 0, `available_qty_at_wip_warehouse` decimal(21,9) not null default 0, index `item_code`(`item_code`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,813 WARNING database DDL Query made to DB: ALTER TABLE `tabWork Order Item` ADD INDEX IF NOT EXISTS `item_code_source_warehouse_index`(item_code, source_warehouse) 2025-06-23 23:36:15,866 WARNING database DDL Query made to DB: create table `tabPlant Floor` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `floor_name` varchar(140) unique, `company` varchar(140), `warehouse` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:15,962 WARNING database DDL Query made to DB: create table `tabWork Order Operation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `operation` varchar(140), `status` varchar(140) default 'Pending', `completed_qty` decimal(21,9) not null default 0, `process_loss_qty` decimal(21,9) not null default 0, `bom` varchar(140), `workstation_type` varchar(140), `workstation` varchar(140), `sequence_id` int(11) not null default 0, `description` longtext, `planned_start_time` datetime(6), `hour_rate` decimal(21,9) not null default 0, `time_in_mins` decimal(21,9) not null default 0, `planned_end_time` datetime(6), `batch_size` decimal(21,9) not null default 0, `planned_operating_cost` decimal(21,9) not null default 0, `actual_start_time` datetime(6), `actual_operation_time` decimal(21,9) not null default 0, `actual_end_time` datetime(6), `actual_operating_cost` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:16,039 WARNING database DDL Query made to DB: create table `tabJob Card 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), `source_warehouse` varchar(140), `uom` varchar(140), `item_group` varchar(140), `stock_uom` varchar(140), `item_name` varchar(140), `description` text, `required_qty` decimal(21,9) not null default 0, `transferred_qty` decimal(21,9) not null default 0, `allow_alternative_item` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:16,200 WARNING database DDL Query made to DB: create table `tabDowntime 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), `workstation` varchar(140), `operator` varchar(140), `from_time` datetime(6), `to_time` datetime(6), `downtime` decimal(21,9) not null default 0, `stop_reason` varchar(140), `remarks` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:16,284 WARNING database DDL Query made to DB: create table `tabBOM Website 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), `description` longtext, `qty` decimal(21,9) not null default 0, `website_image` text, index `item_code`(`item_code`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:16,373 WARNING database DDL Query made to DB: create table `tabProduction Plan 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', `include_exploded_items` int(1) not null default 1, `item_code` varchar(140), `bom_no` varchar(140), `planned_qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `warehouse` varchar(140), `planned_start_date` datetime(6), `pending_qty` decimal(21,9) not null default 0, `ordered_qty` decimal(21,9) not null default 0, `description` longtext, `produced_qty` decimal(21,9) not null default 0, `sales_order` varchar(140), `sales_order_item` varchar(140), `material_request` varchar(140), `material_request_item` varchar(140), `product_bundle_item` varchar(140), `item_reference` varchar(140), `temporary_name` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:16,451 WARNING database DDL Query made to DB: create table `tabWorkstation 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', `workstation_type` varchar(140) unique, `hour_rate_electricity` decimal(21,9) not null default 0, `hour_rate_consumable` decimal(21,9) not null default 0, `hour_rate_rent` decimal(21,9) not null default 0, `hour_rate_labour` decimal(21,9) not null default 0, `hour_rate` 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-06-23 23:36:16,521 WARNING database DDL Query made to DB: create table `tabProduction Plan Sales 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', `sales_order` varchar(140), `sales_order_date` date, `customer` varchar(140), `grand_total` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:16,669 WARNING database DDL Query made to DB: create table `tabBOM` ( name varchar(140) primary key, creation datetime(6), 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` varchar(140), `company` varchar(140), `uom` varchar(140), `quantity` decimal(21,9) not null default 1.0, `is_active` int(1) not null default 1, `is_default` int(1) not null default 1, `allow_alternative_item` int(1) not null default 0, `set_rate_of_sub_assembly_item_based_on_bom` int(1) not null default 1, `project` varchar(140), `image` text, `rm_cost_as_per` varchar(140) default 'Valuation Rate', `buying_price_list` varchar(140), `price_list_currency` varchar(140), `plc_conversion_rate` decimal(21,9) not null default 0, `currency` varchar(140), `conversion_rate` decimal(21,9) not null default 1.0, `with_operations` int(1) not null default 0, `transfer_material_against` varchar(140) default 'Work Order', `routing` varchar(140), `fg_based_operating_cost` int(1) not null default 0, `operating_cost_per_bom_quantity` decimal(21,9) not null default 0, `process_loss_percentage` decimal(21,9) not null default 0, `process_loss_qty` decimal(21,9) not null default 0, `operating_cost` decimal(21,9) not null default 0, `raw_material_cost` decimal(21,9) not null default 0, `scrap_material_cost` decimal(21,9) not null default 0, `base_operating_cost` decimal(21,9) not null default 0, `base_raw_material_cost` decimal(21,9) not null default 0, `base_scrap_material_cost` decimal(21,9) not null default 0, `total_cost` decimal(21,9) not null default 0, `base_total_cost` decimal(21,9) not null default 0, `item_name` varchar(140), `description` text, `has_variants` int(1) not null default 0, `inspection_required` int(1) not null default 0, `quality_inspection_template` varchar(140), `show_in_website` int(1) not null default 0, `route` text, `website_image` text, `thumbnail` varchar(140), `show_items` int(1) not null default 0, `show_operations` int(1) not null default 0, `web_long_description` longtext, `bom_creator` varchar(140), `bom_creator_item` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `item`(`item`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:16,763 WARNING database DDL Query made to DB: create table `tabBlanket Order` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `blanket_order_type` varchar(140), `customer` varchar(140), `customer_name` varchar(140), `supplier` varchar(140), `supplier_name` varchar(140), `order_no` varchar(140), `order_date` date, `from_date` date, `to_date` date, `company` varchar(140), `amended_from` varchar(140), `tc_name` varchar(140), `terms` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `company`(`company`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:16,842 WARNING database DDL Query made to DB: create table `tabOperation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `workstation` varchar(140), `is_corrective_operation` int(1) not null default 0, `create_job_card_based_on_batch_size` int(1) not null default 0, `quality_inspection_template` varchar(140), `batch_size` int(11) not null default 1, `total_operation_time` 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-06-23 23:36:16,921 WARNING database DDL Query made to DB: create table `tabProduction Plan Item Reference` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_reference` varchar(140), `sales_order` varchar(140), `sales_order_item` varchar(140), `qty` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:17,070 WARNING database DDL Query made to DB: create table `tabBOM Creator 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), `item_group` varchar(140), `fg_item` varchar(140), `source_warehouse` varchar(140), `is_expandable` int(1) not null default 0, `sourced_by_supplier` int(1) not null default 0, `bom_created` int(1) not null default 0, `allow_alternative_item` int(1) not null default 1, `description` text, `qty` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `uom` varchar(140), `stock_qty` decimal(21,9) not null default 0, `conversion_factor` decimal(21,9) not null default 0, `stock_uom` varchar(140), `amount` decimal(21,9) not null default 0, `base_rate` decimal(21,9) not null default 0, `base_amount` decimal(21,9) not null default 0, `do_not_explode` int(1) not null default 1, `parent_row_no` varchar(140), `fg_reference_id` varchar(140), `instruction` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:17,197 WARNING database DDL Query made to DB: create table `tabProduction Plan` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `company` varchar(140), `get_items_from` varchar(140), `posting_date` date, `item_code` varchar(140), `customer` varchar(140), `warehouse` varchar(140), `project` varchar(140), `sales_order_status` varchar(140), `from_date` date, `to_date` date, `from_delivery_date` date, `to_delivery_date` date, `combine_items` int(1) not null default 0, `combine_sub_items` int(1) not null default 0, `sub_assembly_warehouse` varchar(140), `skip_available_sub_assembly_item` int(1) not null default 0, `include_non_stock_items` int(1) not null default 1, `include_subcontracted_items` int(1) not null default 1, `consider_minimum_order_qty` int(1) not null default 0, `include_safety_stock` int(1) not null default 0, `ignore_existing_ordered_qty` int(1) not null default 0, `for_warehouse` varchar(140), `total_planned_qty` decimal(21,9) not null default 0, `total_produced_qty` decimal(21,9) not null default 0, `status` varchar(140) default 'Draft', `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:17,287 WARNING database DDL Query made to DB: create table `tabBOM Explosion 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), `source_warehouse` varchar(140), `operation` varchar(140), `description` longtext, `image` text, `stock_qty` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `qty_consumed_per_unit` decimal(21,9) not null default 0, `stock_uom` varchar(140), `amount` decimal(21,9) not null default 0, `include_item_in_manufacturing` int(1) not null default 0, `sourced_by_supplier` int(1) not null default 0, index `item_code`(`item_code`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:17,377 WARNING database DDL Query made to DB: create table `tabBOM Operation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `sequence_id` int(11) not null default 0, `operation` varchar(140), `workstation_type` varchar(140), `workstation` varchar(140), `time_in_mins` decimal(21,9) not null default 0, `fixed_time` int(1) not null default 0, `hour_rate` decimal(21,9) not null default 0, `base_hour_rate` decimal(21,9) not null default 0, `operating_cost` decimal(21,9) not null default 0, `base_operating_cost` decimal(21,9) not null default 0, `batch_size` int(11) not null default 0, `set_cost_based_on_bom_qty` int(1) not null default 0, `cost_per_unit` decimal(21,9) not null default 0, `base_cost_per_unit` decimal(21,9) not null default 0, `description` longtext, `image` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:17,484 WARNING database DDL Query made to DB: create table `tabWorkstation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `workstation_name` varchar(140) unique, `workstation_type` varchar(140), `plant_floor` varchar(140), `production_capacity` int(11) not null default 1, `warehouse` varchar(140), `status` varchar(140), `on_status_image` text, `off_status_image` text, `hour_rate_electricity` decimal(21,9) not null default 0, `hour_rate_consumable` decimal(21,9) not null default 0, `hour_rate_rent` decimal(21,9) not null default 0, `hour_rate_labour` decimal(21,9) not null default 0, `hour_rate` decimal(21,9) not null default 0, `description` text, `holiday_list` varchar(140), `total_working_hours` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:17,595 WARNING database DDL Query made to DB: create table `tabBOM Creator` ( name varchar(140) primary key, creation datetime(6), 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), `item_group` varchar(140), `qty` decimal(21,9) not null default 0, `project` varchar(140), `uom` varchar(140), `rm_cost_as_per` varchar(140) default 'Valuation Rate', `set_rate_based_on_warehouse` 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, `currency` varchar(140), `conversion_rate` decimal(21,9) not null default 1.0, `default_warehouse` varchar(140), `company` varchar(140), `raw_material_cost` decimal(21,9) not null default 0, `remarks` longtext, `status` varchar(140) default 'Draft', `error_log` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:18,033 WARNING database DDL Query made to DB: create table `tabStock Ledger Entry` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_code` varchar(140), `warehouse` varchar(140), `posting_date` date, `posting_time` time(6), `posting_datetime` datetime(6), `is_adjustment_entry` int(1) not null default 0, `auto_created_serial_and_batch_bundle` int(1) not null default 0, `voucher_type` varchar(140), `voucher_no` varchar(140), `voucher_detail_no` varchar(140), `serial_and_batch_bundle` varchar(140), `dependant_sle_voucher_detail_no` varchar(140), `recalculate_rate` int(1) not null default 0, `actual_qty` decimal(21,9) not null default 0, `qty_after_transaction` decimal(21,9) not null default 0, `incoming_rate` decimal(21,9) not null default 0, `outgoing_rate` decimal(21,9) not null default 0, `valuation_rate` decimal(21,9) not null default 0, `stock_value` decimal(21,9) not null default 0, `stock_value_difference` decimal(21,9) not null default 0, `stock_queue` longtext, `company` varchar(140), `stock_uom` varchar(140), `project` varchar(140), `fiscal_year` varchar(140), `has_batch_no` int(1) not null default 0, `has_serial_no` int(1) not null default 0, `is_cancelled` int(1) not null default 0, `to_rename` int(1) not null default 1, `serial_no` longtext, `batch_no` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `item_code`(`item_code`), index `warehouse`(`warehouse`), index `posting_date`(`posting_date`), index `posting_datetime`(`posting_datetime`), index `voucher_type`(`voucher_type`), index `voucher_detail_no`(`voucher_detail_no`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `to_rename`(`to_rename`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:18,104 WARNING database DDL Query made to DB: ALTER TABLE `tabStock Ledger Entry` ADD INDEX IF NOT EXISTS `voucher_no_voucher_type_index`(voucher_no, voucher_type) 2025-06-23 23:36:18,127 WARNING database DDL Query made to DB: ALTER TABLE `tabStock Ledger Entry` ADD INDEX IF NOT EXISTS `batch_no_item_code_warehouse_index`(batch_no, item_code, warehouse) 2025-06-23 23:36:18,149 WARNING database DDL Query made to DB: ALTER TABLE `tabStock Ledger Entry` ADD INDEX IF NOT EXISTS `item_warehouse`(warehouse, item_code) 2025-06-23 23:36:18,172 WARNING database DDL Query made to DB: ALTER TABLE `tabStock Ledger Entry` ADD INDEX IF NOT EXISTS `posting_datetime_creation_index`(posting_datetime, creation) 2025-06-23 23:36:18,235 WARNING database DDL Query made to DB: create table `tabDelivery Stop` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `customer` varchar(140), `address` varchar(140), `locked` int(1) not null default 0, `customer_address` text, `visited` int(1) not null default 0, `delivery_note` varchar(140), `grand_total` decimal(21,9) not null default 0, `contact` varchar(140), `email_sent_to` varchar(140), `customer_contact` text, `distance` decimal(21,9) not null default 0, `estimated_arrival` datetime(6), `lat` decimal(21,9) not null default 0, `uom` varchar(140), `lng` decimal(21,9) not null default 0, `details` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:18,323 WARNING database DDL Query made to DB: create table `tabClosing Stock 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', `naming_series` varchar(140), `company` varchar(140), `status` varchar(140) default 'Draft', `from_date` date, `to_date` date, `item_code` varchar(140), `item_group` varchar(140), `include_uom` varchar(140), `warehouse` varchar(140), `warehouse_type` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:18,439 WARNING database DDL Query made to DB: create table `tabDelivery Trip` ( name varchar(140) primary key, creation datetime(6), 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), `email_notification_sent` int(1) not null default 0, `driver` varchar(140), `driver_name` varchar(140), `driver_email` varchar(140), `driver_address` varchar(140), `total_distance` decimal(21,9) not null default 0, `uom` varchar(140), `vehicle` varchar(140), `departure_time` datetime(6), `employee` varchar(140), `status` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:18,539 WARNING database DDL Query made to DB: create table `tabShipment Parcel 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', `parcel_template_name` varchar(140) unique, `length` int(11) not null default 0, `width` int(11) not null default 0, `height` int(11) not null default 0, `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-06-23 23:36:18,625 WARNING database DDL Query made to DB: create table `tabManufacturer` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `short_name` varchar(140) unique, `full_name` varchar(140), `website` varchar(140), `country` varchar(140), `logo` text, `notes` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:18,823 WARNING database DDL Query made to DB: create table `tabItem` ( name varchar(140) primary key, creation datetime(6), 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), `item_code` varchar(140) unique, `item_name` varchar(140), `item_group` varchar(140), `stock_uom` varchar(140), `disabled` int(1) not null default 0, `allow_alternative_item` int(1) not null default 0, `is_stock_item` int(1) not null default 1, `has_variants` int(1) not null default 0, `opening_stock` decimal(21,9) not null default 0, `valuation_rate` decimal(21,9) not null default 0, `standard_rate` decimal(21,9) not null default 0, `is_fixed_asset` int(1) not null default 0, `auto_create_assets` int(1) not null default 0, `is_grouped_asset` int(1) not null default 0, `asset_category` varchar(140), `asset_naming_series` varchar(140), `over_delivery_receipt_allowance` decimal(21,9) not null default 0, `over_billing_allowance` decimal(21,9) not null default 0, `image` text, `description` longtext, `brand` varchar(140), `shelf_life_in_days` int(11) not null default 0, `end_of_life` date default '2099-12-31', `default_material_request_type` varchar(140) default 'Purchase', `valuation_method` varchar(140), `warranty_period` varchar(140), `weight_per_unit` decimal(21,9) not null default 0, `weight_uom` varchar(140), `allow_negative_stock` int(1) not null default 0, `has_batch_no` int(1) not null default 0, `create_new_batch` int(1) not null default 0, `batch_number_series` varchar(140), `has_expiry_date` int(1) not null default 0, `retain_sample` int(1) not null default 0, `sample_quantity` int(11) not null default 0, `has_serial_no` int(1) not null default 0, `serial_no_series` varchar(140), `variant_of` varchar(140), `variant_based_on` varchar(140) default 'Item Attribute', `enable_deferred_expense` int(1) not null default 0, `no_of_months_exp` int(11) not null default 0, `enable_deferred_revenue` int(1) not null default 0, `no_of_months` int(11) not null default 0, `purchase_uom` varchar(140), `min_order_qty` decimal(21,9) not null default 0, `safety_stock` decimal(21,9) not null default 0, `is_purchase_item` int(1) not null default 1, `lead_time_days` int(11) not null default 0, `last_purchase_rate` decimal(21,9) not null default 0, `is_customer_provided_item` int(1) not null default 0, `customer` varchar(140), `delivered_by_supplier` int(1) not null default 0, `country_of_origin` varchar(140), `customs_tariff_number` varchar(140), `sales_uom` varchar(140), `grant_commission` int(1) not null default 1, `is_sales_item` int(1) not null default 1, `max_discount` decimal(21,9) not null default 0, `inspection_required_before_purchase` int(1) not null default 0, `quality_inspection_template` varchar(140), `inspection_required_before_delivery` int(1) not null default 0, `include_item_in_manufacturing` int(1) not null default 1, `is_sub_contracted_item` int(1) not null default 0, `default_bom` varchar(140), `customer_code` text, `default_item_manufacturer` varchar(140), `default_manufacturer_part_no` varchar(140), `total_projected_qty` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `item_name`(`item_name`), index `item_group`(`item_group`), index `disabled`(`disabled`), index `variant_of`(`variant_of`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:19,049 WARNING database DDL Query made to DB: create table `tabDelivery Note 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, `brand` varchar(140), `item_group` 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, `returned_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, `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, `item_tax_template` varchar(140), `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, `incoming_rate` 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), `target_warehouse` varchar(140), `quality_inspection` varchar(140), `allow_zero_valuation_rate` int(1) not null default 0, `against_sales_order` varchar(140), `so_detail` varchar(140), `against_sales_invoice` varchar(140), `si_detail` varchar(140), `dn_detail` varchar(140), `pick_list_item` varchar(140), `serial_and_batch_bundle` varchar(140), `use_serial_batch_fields` int(1) not null default 0, `serial_no` text, `batch_no` varchar(140), `actual_qty` decimal(21,9) not null default 0, `actual_batch_qty` decimal(21,9) not null default 0, `company_total_stock` decimal(21,9) not null default 0, `installed_qty` decimal(21,9) not null default 0, `packed_qty` decimal(21,9) not null default 0, `received_qty` decimal(21,9) not null default 0, `expense_account` varchar(140), `item_tax_rate` text, `material_request` varchar(140), `purchase_order` varchar(140), `purchase_order_item` varchar(140), `material_request_item` varchar(140), `cost_center` varchar(140), `project` varchar(140), `page_break` int(1) not null default 0, index `item_code`(`item_code`), index `against_sales_order`(`against_sales_order`), index `so_detail`(`so_detail`), index `against_sales_invoice`(`against_sales_invoice`), index `si_detail`(`si_detail`), index `dn_detail`(`dn_detail`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `batch_no`(`batch_no`), index `purchase_order`(`purchase_order`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:19,148 WARNING database DDL Query made to DB: create table `tabBatch` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `disabled` int(1) not null default 0, `use_batchwise_valuation` int(1) not null default 0, `batch_id` varchar(140) unique, `item` varchar(140), `item_name` varchar(140), `image` text, `parent_batch` varchar(140), `manufacturing_date` date, `batch_qty` decimal(21,9) not null default 0, `stock_uom` varchar(140), `expiry_date` date, `supplier` varchar(140), `reference_doctype` varchar(140), `reference_name` varchar(140), `description` text, `qty_to_produce` decimal(21,9) not null default 0, `produced_qty` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:19,224 WARNING database DDL Query made to DB: create table `tabQuality Inspection 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', `quality_inspection_template_name` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:19,323 WARNING database DDL Query made to DB: create table `tabStock Entry 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', `purpose` varchar(140) default 'Material Issue', `add_to_transit` int(1) not null default 0, `is_standard` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:19,572 WARNING database DDL Query made to DB: create table `tabDelivery 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', `title` varchar(140) default '{customer_name}', `naming_series` varchar(140), `customer` varchar(140), `tax_id` varchar(140), `customer_name` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `company` varchar(140), `amended_from` varchar(140), `is_return` int(1) not null default 0, `issue_credit_note` int(1) not null default 0, `return_against` varchar(140), `cost_center` varchar(140), `project` varchar(140), `currency` varchar(140), `conversion_rate` decimal(21,9) not null default 0, `selling_price_list` varchar(140), `price_list_currency` varchar(140), `plc_conversion_rate` decimal(21,9) not null default 0, `ignore_pricing_rule` int(1) not null default 0, `scan_barcode` varchar(140), `pick_list` varchar(140), `set_warehouse` varchar(140), `set_target_warehouse` varchar(140), `total_qty` decimal(21,9) not null default 0, `total_net_weight` decimal(21,9) not null default 0, `base_total` decimal(21,9) not null default 0, `base_net_total` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `net_total` decimal(21,9) not null default 0, `tax_category` varchar(140), `taxes_and_charges` varchar(140), `shipping_rule` varchar(140), `incoterm` varchar(140), `named_place` varchar(140), `base_total_taxes_and_charges` decimal(21,9) not null default 0, `total_taxes_and_charges` decimal(21,9) not null default 0, `base_grand_total` decimal(21,9) not null default 0, `base_rounding_adjustment` decimal(21,9) not null default 0, `base_rounded_total` decimal(21,9) not null default 0, `base_in_words` 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, `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, `customer_address` varchar(140), `address_display` text, `contact_person` varchar(140), `contact_display` text, `contact_mobile` text, `contact_email` varchar(140), `shipping_address_name` varchar(140), `shipping_address` text, `dispatch_address_name` varchar(140), `dispatch_address` text, `company_address` varchar(140), `company_address_display` text, `company_contact_person` varchar(140), `tc_name` varchar(140), `terms` longtext, `per_billed` decimal(21,9) not null default 0, `status` varchar(140) default 'Draft', `per_installed` decimal(21,9) not null default 0, `installation_status` varchar(140), `per_returned` decimal(21,9) not null default 0, `transporter` varchar(140), `driver` varchar(140), `lr_no` varchar(140), `vehicle_no` varchar(140), `transporter_name` varchar(140), `driver_name` varchar(140), `lr_date` date, `po_no` text, `po_date` date, `sales_partner` varchar(140), `amount_eligible_for_commission` decimal(21,9) not null default 0, `commission_rate` decimal(21,9) not null default 0, `total_commission` decimal(21,9) not null default 0, `auto_repeat` varchar(140), `letter_head` varchar(140), `print_without_amount` int(1) not null default 0, `group_same_items` int(1) not null default 0, `select_print_heading` varchar(140), `language` varchar(140), `is_internal_customer` int(1) not null default 0, `represents_company` varchar(140), `inter_company_reference` varchar(140), `customer_group` varchar(140), `territory` varchar(140), `source` varchar(140), `campaign` varchar(140), `excise_page` varchar(140), `instructions` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, `_seen` text, index `customer`(`customer`), index `posting_date`(`posting_date`), index `return_against`(`return_against`), index `pick_list`(`pick_list`), index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:19,687 WARNING database DDL Query made to DB: create table `tabSerial and Batch 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', `serial_no` varchar(140), `batch_no` varchar(140), `qty` decimal(21,9) not null default 1.0, `warehouse` varchar(140), `delivered_qty` decimal(21,9) not null default 0, `incoming_rate` decimal(21,9) not null default 0, `outgoing_rate` decimal(21,9) not null default 0, `stock_value_difference` decimal(21,9) not null default 0, `is_outward` int(1) not null default 0, `stock_queue` text, index `serial_no`(`serial_no`), index `batch_no`(`batch_no`), index `warehouse`(`warehouse`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:19,758 WARNING database DDL Query made to DB: create table `tabItem Tax` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_tax_template` varchar(140), `tax_category` varchar(140), `valid_from` date, `minimum_net_rate` decimal(21,9) not null default 0, `maximum_net_rate` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:19,883 WARNING database DDL Query made to DB: create table `tabShipment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `pickup_from_type` varchar(140) default 'Company', `pickup_company` varchar(140), `pickup_customer` varchar(140), `pickup_supplier` varchar(140), `pickup` varchar(140), `pickup_address_name` varchar(140), `pickup_address` text, `pickup_contact_person` varchar(140), `pickup_contact_name` varchar(140), `pickup_contact_email` varchar(140), `pickup_contact` text, `delivery_to_type` varchar(140) default 'Customer', `delivery_company` varchar(140), `delivery_customer` varchar(140), `delivery_supplier` varchar(140), `delivery_to` varchar(140), `delivery_address_name` varchar(140), `delivery_address` text, `delivery_contact_name` varchar(140), `delivery_contact_email` varchar(140), `delivery_contact` text, `parcel_template` varchar(140), `total_weight` decimal(21,9) not null default 0, `pallets` varchar(140) default 'No', `value_of_goods` decimal(21,9) not null default 0, `pickup_date` date, `pickup_from` time(6) default '09:00', `pickup_to` time(6) default '17:00', `shipment_type` varchar(140) default 'Goods', `pickup_type` varchar(140) default 'Pickup', `incoterm` varchar(140), `description_of_content` text, `service_provider` varchar(140), `shipment_id` varchar(140), `shipment_amount` decimal(21,9) not null default 0, `status` varchar(140), `tracking_url` text, `carrier` varchar(140), `carrier_service` varchar(140), `awb_number` varchar(140), `tracking_status` varchar(140), `tracking_status_info` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:20,175 WARNING database DDL Query made to DB: create table `tabPurchase Receipt` ( name varchar(140) primary key, creation datetime(6), 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), `supplier_delivery_note` varchar(140), `subcontracting_receipt` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `company` varchar(140), `apply_putaway_rule` int(1) not null default 0, `is_return` int(1) not null default 0, `return_against` 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_warehouse` varchar(140), `set_from_warehouse` varchar(140), `rejected_warehouse` varchar(140), `is_subcontracted` int(1) not null default 0, `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, `rounded_total` decimal(21,9) not null default 0, `in_words` varchar(240), `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, `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, `tc_name` varchar(140), `terms` longtext, `status` varchar(140) default 'Draft', `per_billed` decimal(21,9) not null default 0, `per_returned` decimal(21,9) not null default 0, `auto_repeat` varchar(140), `letter_head` varchar(140), `group_same_items` int(1) not null default 0, `select_print_heading` varchar(140), `language` varchar(140), `transporter_name` varchar(140), `lr_no` varchar(140), `lr_date` date, `instructions` text, `is_internal_supplier` int(1) not null default 0, `represents_company` varchar(140), `inter_company_reference` varchar(140), `remarks` text, `range` varchar(140), `amended_from` 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 `subcontracting_receipt`(`subcontracting_receipt`), index `posting_date`(`posting_date`), index `return_against`(`return_against`), index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:20,260 WARNING database DDL Query made to DB: create table `tabItem Website Specification` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `label` varchar(140), `description` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:20,403 WARNING database DDL Query made to DB: create table `tabStock Entry Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `barcode` varchar(140), `has_item_scanned` int(1) not null default 0, `s_warehouse` varchar(140), `t_warehouse` varchar(140), `item_code` varchar(140), `item_name` varchar(140), `is_finished_item` int(1) not null default 0, `is_scrap_item` int(1) not null default 0, `quality_inspection` varchar(140), `subcontracted_item` varchar(140), `description` longtext, `item_group` varchar(140), `image` text, `qty` decimal(21,9) not null default 0, `transfer_qty` decimal(21,9) not null default 0, `retain_sample` int(1) not null default 0, `uom` varchar(140), `stock_uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, `sample_quantity` int(11) not null default 0, `basic_rate` decimal(21,9) not null default 0, `additional_cost` decimal(21,9) not null default 0, `valuation_rate` decimal(21,9) not null default 0, `allow_zero_valuation_rate` int(1) not null default 0, `set_basic_rate_manually` int(1) not null default 0, `basic_amount` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `use_serial_batch_fields` int(1) not null default 0, `serial_and_batch_bundle` varchar(140), `serial_no` text, `batch_no` varchar(140), `expense_account` varchar(140), `cost_center` varchar(140), `project` varchar(140), `actual_qty` decimal(21,9) not null default 0, `transferred_qty` decimal(21,9) not null default 0, `bom_no` varchar(140), `allow_alternative_item` int(1) not null default 0, `material_request` varchar(140), `material_request_item` varchar(140), `original_item` varchar(140), `against_stock_entry` varchar(140), `ste_detail` varchar(140), `po_detail` varchar(140), `sco_rm_detail` varchar(140), `putaway_rule` varchar(140), `reference_purchase_receipt` varchar(140), `job_card_item` varchar(140), index `item_code`(`item_code`), index `serial_and_batch_bundle`(`serial_and_batch_bundle`), index `actual_qty`(`actual_qty`), index `material_request`(`material_request`), index `job_card_item`(`job_card_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-06-23 23:36:20,474 WARNING database DDL Query made to DB: create table `tabShipment Parcel` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `length` int(11) not null default 0, `width` int(11) not null default 0, `height` int(11) not null default 0, `weight` decimal(21,9) not null default 0, `count` int(11) not null default 1, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:20,550 WARNING database DDL Query made to DB: create table `tabItem Quality Inspection Parameter` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `specification` varchar(140), `parameter_group` varchar(140), `value` varchar(140), `numeric` int(1) not null default 1, `min_value` decimal(21,9) not null default 0, `max_value` decimal(21,9) not null default 0, `formula_based_criteria` int(1) not null default 0, `acceptance_formula` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:20,622 WARNING database DDL Query made to DB: create table `tabItem 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), `supplier_part_no` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:20,695 WARNING database DDL Query made to DB: create table `tabItem Customer 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', `customer_name` varchar(140), `customer_group` varchar(140), `ref_code` varchar(140), index `customer_name`(`customer_name`), index `ref_code`(`ref_code`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:20,859 WARNING database DDL Query made to DB: create table `tabStock 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), `stock_entry_type` varchar(140), `outgoing_stock_entry` varchar(140), `purpose` varchar(140), `add_to_transit` int(1) not null default 0, `work_order` varchar(140), `purchase_order` varchar(140), `subcontracting_order` varchar(140), `delivery_note_no` varchar(140), `sales_invoice_no` varchar(140), `pick_list` varchar(140), `purchase_receipt_no` varchar(140), `asset_repair` varchar(140), `company` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `inspection_required` int(1) not null default 0, `apply_putaway_rule` int(1) not null default 0, `from_bom` int(1) not null default 0, `use_multi_level_bom` int(1) not null default 1, `bom_no` varchar(140), `fg_completed_qty` decimal(21,9) not null default 0, `process_loss_percentage` decimal(21,9) not null default 0, `process_loss_qty` decimal(21,9) not null default 0, `from_warehouse` varchar(140), `source_warehouse_address` varchar(140), `source_address_display` text, `to_warehouse` varchar(140), `target_warehouse_address` varchar(140), `target_address_display` text, `scan_barcode` varchar(140), `total_outgoing_value` decimal(21,9) not null default 0, `total_incoming_value` decimal(21,9) not null default 0, `value_difference` decimal(21,9) not null default 0, `total_additional_costs` decimal(21,9) not null default 0, `supplier` varchar(140), `supplier_name` varchar(140), `supplier_address` varchar(140), `address_display` text, `project` varchar(140), `select_print_heading` varchar(140), `letter_head` varchar(140), `is_opening` varchar(140), `remarks` text, `per_transferred` decimal(21,9) not null default 0, `total_amount` decimal(21,9) not null default 0, `job_card` varchar(140), `amended_from` varchar(140), `credit_note` varchar(140), `is_return` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `stock_entry_type`(`stock_entry_type`), index `purpose`(`purpose`), index `work_order`(`work_order`), index `delivery_note_no`(`delivery_note_no`), index `pick_list`(`pick_list`), index `purchase_receipt_no`(`purchase_receipt_no`), index `posting_date`(`posting_date`), index `job_card`(`job_card`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:20,966 WARNING database DDL Query made to DB: create table `tabPrice List` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `enabled` int(1) not null default 1, `price_list_name` varchar(140) unique, `currency` varchar(140), `buying` int(1) not null default 0, `selling` int(1) not null default 0, `price_not_uom_dependent` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,077 WARNING database DDL Query made to DB: create table `tabItem Variant Attribute` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `variant_of` varchar(140), `attribute` varchar(140), `attribute_value` varchar(140), `numeric_values` int(1) not null default 0, `disabled` int(1) not null default 0, `from_range` decimal(21,9) not null default 0, `increment` decimal(21,9) not null default 0, `to_range` decimal(21,9) not null default 0, index `variant_of`(`variant_of`), index `attribute`(`attribute`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,161 WARNING database DDL Query made to DB: create table `tabItem Attribute` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `attribute_name` varchar(140) unique, `numeric_values` int(1) not null default 0, `disabled` int(1) not null default 0, `from_range` decimal(21,9) not null default 0, `increment` decimal(21,9) not null default 0, `to_range` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,279 WARNING database DDL Query made to DB: create table `tabStock Reservation 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', `item_code` varchar(140), `warehouse` varchar(140), `has_serial_no` int(1) not null default 0, `has_batch_no` int(1) not null default 0, `voucher_type` varchar(140), `voucher_no` varchar(140), `voucher_detail_no` varchar(140), `from_voucher_type` varchar(140), `from_voucher_no` varchar(140), `from_voucher_detail_no` varchar(140), `stock_uom` varchar(140), `available_qty` decimal(21,9) not null default 0, `voucher_qty` decimal(21,9) not null default 0, `reserved_qty` decimal(21,9) not null default 0, `delivered_qty` decimal(21,9) not null default 0, `reservation_based_on` varchar(140) default 'Qty', `company` varchar(140), `project` varchar(140), `status` varchar(140) default 'Draft', `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `item_code`(`item_code`), index `warehouse`(`warehouse`), index `voucher_no`(`voucher_no`), index `voucher_detail_no`(`voucher_detail_no`), index `from_voucher_no`(`from_voucher_no`), index `company`(`company`), index `project`(`project`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,400 WARNING database DDL Query made to DB: create table `tabItem Default` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `default_warehouse` varchar(140), `default_price_list` varchar(140), `default_discount_account` varchar(140), `buying_cost_center` varchar(140), `default_supplier` varchar(140), `expense_account` varchar(140), `default_provisional_account` varchar(140), `selling_cost_center` varchar(140), `income_account` varchar(140), `deferred_expense_account` varchar(140), `deferred_revenue_account` varchar(140), index `default_warehouse`(`default_warehouse`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,495 WARNING database DDL Query made to DB: create table `tabPick List` ( name varchar(140) primary key, creation datetime(6), 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), `purpose` varchar(140) default 'Material Transfer for Manufacture', `customer` varchar(140), `customer_name` varchar(140), `work_order` varchar(140), `material_request` varchar(140), `for_qty` decimal(21,9) not null default 0, `parent_warehouse` varchar(140), `consider_rejected_warehouses` int(1) not null default 0, `pick_manually` int(1) not null default 0, `ignore_pricing_rule` int(1) not null default 0, `scan_barcode` varchar(140), `scan_mode` int(1) not null default 0, `prompt_qty` int(1) not null default 0, `amended_from` varchar(140), `group_same_items` int(1) not null default 0, `status` varchar(140) default 'Draft', `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,598 WARNING database DDL Query made to DB: create table `tabPacking Slip 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), `batch_no` varchar(140), `description` longtext, `qty` decimal(21,9) not null default 0, `net_weight` decimal(21,9) not null default 0, `stock_uom` varchar(140), `weight_uom` varchar(140), `page_break` int(1) not null default 0, `dn_detail` varchar(140), `pi_detail` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,667 WARNING database DDL Query made to DB: create table `tabWarehouse Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,816 WARNING database DDL Query made to DB: create table `tabSerial and Batch Bundle` ( name varchar(140) primary key, creation datetime(6), 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 'SABB-.########', `company` varchar(140), `item_name` varchar(140), `has_serial_no` int(1) not null default 0, `has_batch_no` int(1) not null default 0, `item_code` varchar(140), `warehouse` varchar(140), `type_of_transaction` varchar(140), `total_qty` decimal(21,9) not null default 0, `item_group` varchar(140), `avg_rate` decimal(21,9) not null default 0, `total_amount` decimal(21,9) not null default 0, `voucher_type` varchar(140), `voucher_no` varchar(140), `voucher_detail_no` varchar(140), `posting_date` date, `posting_time` time(6), `returned_against` varchar(140), `is_cancelled` int(1) not null default 0, `is_rejected` int(1) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `company`(`company`), index `item_code`(`item_code`), index `warehouse`(`warehouse`), index `type_of_transaction`(`type_of_transaction`), index `voucher_no`(`voucher_no`), index `voucher_detail_no`(`voucher_detail_no`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:21,926 WARNING database DDL Query made to DB: create table `tabItem Reorder` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `warehouse_group` varchar(140), `warehouse` varchar(140), `warehouse_reorder_level` decimal(21,9) not null default 0, `warehouse_reorder_qty` decimal(21,9) not null default 0, `material_request_type` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:22,018 WARNING database DDL Query made to DB: create table `tabStock Reconciliation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `company` varchar(140), `purpose` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `set_warehouse` varchar(140), `scan_barcode` varchar(140), `scan_mode` int(1) not null default 0, `expense_account` varchar(140), `difference_amount` decimal(21,9) not null default 0, `amended_from` varchar(140), `cost_center` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:22,121 WARNING database DDL Query made to DB: create table `tabQuality Inspection` ( name varchar(140) primary key, creation datetime(6), 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), `report_date` date, `status` varchar(140) default 'Accepted', `child_row_reference` varchar(140), `inspection_type` varchar(140), `reference_type` varchar(140), `reference_name` varchar(140), `item_code` varchar(140), `item_serial_no` varchar(140), `batch_no` varchar(140), `sample_size` decimal(21,9) not null default 0, `item_name` varchar(140), `description` text, `bom_no` varchar(140), `quality_inspection_template` varchar(140), `manual_inspection` int(1) not null default 0, `inspected_by` varchar(140) default 'user', `verified_by` varchar(140), `remarks` text, `amended_from` varchar(140), `letter_head` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `report_date`(`report_date`), index `item_code`(`item_code`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:22,220 WARNING database DDL Query made to DB: create table `tabBin` ( name varchar(140) primary key, creation datetime(6), 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), `warehouse` varchar(140), `actual_qty` decimal(21,9) not null default 0, `planned_qty` decimal(21,9) not null default 0, `indented_qty` decimal(21,9) not null default 0, `ordered_qty` decimal(21,9) not null default 0, `projected_qty` decimal(21,9) not null default 0, `reserved_qty` decimal(21,9) not null default 0, `reserved_qty_for_production` decimal(21,9) not null default 0, `reserved_qty_for_sub_contract` decimal(21,9) not null default 0, `reserved_qty_for_production_plan` decimal(21,9) not null default 0, `reserved_stock` decimal(21,9) not null default 0, `stock_uom` varchar(140), `valuation_rate` decimal(21,9) not null default 0, `stock_value` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `warehouse`(`warehouse`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:22,296 WARNING database DDL Query made to DB: alter table `tabBin` add unique `unique_item_warehouse`(item_code, warehouse) 2025-06-23 23:36:22,338 WARNING database DDL Query made to DB: create table `tabUOM Conversion 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', `uom` varchar(140), `conversion_factor` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci