UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1534078 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1534078 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-07-15 12:34:14

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1533975 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1533975 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-07-15 12:08:27

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1536322 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1536322 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-07-15 17:47:46

x Hide

UPDATE product_warehouse_inventory SET qty_available = 62.0 WHERE product_id = 194198 AND warehouse_id = 35 AND company_id = 1;

Date: 2024-07-15 12:46:56

UPDATE product_warehouse_inventory SET qty_available = 1.0 WHERE product_id = 221785 AND warehouse_id = 43 AND company_id = 1;

Date: 2024-07-15 17:49:46

UPDATE product_warehouse_inventory SET qty_available = 2.0 WHERE product_id = 176362 AND warehouse_id = 46 AND company_id = 1;

Date: 2024-07-15 15:25:56

x Hide

UPDATE product_warehouse_inventory SET qty_reserve = 0 WHERE product_id = 220169 AND warehouse_id = 42;

Date: 2024-07-15 18:36:13

UPDATE product_warehouse_inventory SET qty_reserve = 0 WHERE product_id = 223222 AND warehouse_id = 43;

Date: 2024-07-15 12:48:50

UPDATE product_warehouse_inventory SET qty_reserve = 0 WHERE product_id = 194198 AND warehouse_id = 35;

Date: 2024-07-15 12:46:44

x Hide

UPDATE product_warehouse_inventory SET qty_reserve = 2.0 WHERE product_id = 209510 AND warehouse_id = 45;

Date: 2024-07-15 18:40:45

UPDATE product_warehouse_inventory SET qty_reserve = 1.0 WHERE product_id = 221785 AND warehouse_id = 43;

Date: 2024-07-15 17:49:40

UPDATE product_warehouse_inventory SET qty_reserve = 2.0 WHERE product_id = 209510 AND warehouse_id = 45;

Date: 2024-07-15 18:41:00

x Hide

UPDATE "account_move" SET "message_main_attachment_id" = 5563777, "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (1534021);

Date: 2024-07-15 12:19:04

UPDATE "account_move" SET "message_main_attachment_id" = 5564463, "write_uid" = 1045, "write_date" = (now() at time zone 'UTC') WHERE id IN (1534878);

Date: 2024-07-15 13:50:41

x Hide

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 0 WHERE product_id = 220169 AND warehouse_id = 42;

Date: 2024-07-15 18:36:36

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 0 WHERE product_id = 223222 AND warehouse_id = 43;

Date: 2024-07-15 12:49:15

UPDATE product_warehouse_inventory SET qty_mtd_sold = 0 - 0 WHERE product_id = 245149 AND warehouse_id = 45;

Date: 2024-07-15 19:08:58

x Hide

UPDATE "product_warehouse_inventory" SET "loc_check_qty" = 6.0, "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (37984);

Date: 2024-07-15 18:38:40

UPDATE "product_warehouse_inventory" SET "loc_check_qty" = 186.0, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (332050);

Date: 2024-07-15 12:31:12

UPDATE "product_warehouse_inventory" SET "loc_check_qty" = 6.0, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (366803, 366804);

Date: 2024-07-15 12:32:03

x Hide

UPDATE product_warehouse_inventory SET qty_on_order = 0 WHERE product_id = 247744 AND warehouse_id = 42;

Date: 2024-07-15 16:52:33

UPDATE product_warehouse_inventory SET qty_on_order = 0 WHERE product_id = 194970 AND warehouse_id = 35;

Date: 2024-07-15 12:46:59

UPDATE product_warehouse_inventory SET qty_on_order = 0 WHERE product_id = 195574 AND warehouse_id = 36;

Date: 2024-07-15 17:27:02

x Hide

UPDATE product_warehouse_inventory SET qty_on_order = 8.0 WHERE product_id = 203863 AND warehouse_id = 45;

Date: 2024-07-15 18:22:47

UPDATE product_warehouse_inventory SET qty_on_order = 3.0 WHERE product_id = 209168 AND warehouse_id = 35;

Date: 2024-07-15 18:38:29

UPDATE product_warehouse_inventory SET qty_on_order = 4.0 WHERE product_id = 207666 AND warehouse_id = 36;

Date: 2024-07-15 12:47:00

x Hide

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

Date: 2024-07-15 18:47:10

x Hide

UPDATE "edi_810_invoice" SET "write_uid" = 1213, "write_date" = (now() at time zone 'UTC') WHERE id IN (52783);

Date: 2024-07-15 17:07:15

x Hide

UPDATE product_warehouse_inventory SET qty_mtd_sold = 4.0 - 0 WHERE product_id = 213625 AND warehouse_id = 37;

Date: 2024-07-15 17:34:38

UPDATE product_warehouse_inventory SET qty_mtd_sold = 2.0 - 0 WHERE product_id = 173638 AND warehouse_id = 38;

Date: 2024-07-15 16:11:29

UPDATE product_warehouse_inventory SET qty_mtd_sold = 12.0 - 0 WHERE product_id = 187783 AND warehouse_id = 41;

Date: 2024-07-15 13:57:50

x Hide

SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";

Date: 2024-07-15 10:33:26

SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'psd_custom.inventory_vendor') ORDER BY "ir_model_fields"."name";

Date: 2024-07-15 10:33:26

SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'psd_custom.inventory_vendor') ORDER BY "ir_model_fields"."name";

Date: 2024-07-15 10:33:26

x Hide

UPDATE "account_move" SET "access_token" = '3bb1f9b8-4f64-424c-87ec-37895decaf2a', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (1535124);

Date: 2024-07-15 14:25:35

x Hide

UPDATE product_warehouse_inventory SET qty_ytd_sold = 8.0 WHERE product_id = 176362 AND warehouse_id = 46;

Date: 2024-07-15 15:25:55

UPDATE product_warehouse_inventory SET qty_ytd_sold = 12.0 WHERE product_id = 215612 AND warehouse_id = 46;

Date: 2024-07-15 20:03:42

UPDATE product_warehouse_inventory SET qty_ytd_sold = 5.0 WHERE product_id = 206606 AND warehouse_id = 36;

Date: 2024-07-15 17:17:50

x Hide

DELETE FROM stock_inventory_line WHERE id IN (3056673, 3056671, 3056672, 3056674, 3056675, 3056676, 3056670, 3056677, 3056678, 3056679, 3056680, 3056681);

Date: 2024-07-15 18:04:41

DELETE FROM stock_inventory_line WHERE id IN (3056682);

Date: 2024-07-15 18:05:59

DELETE FROM stock_inventory_line WHERE id IN (3056683);

Date: 2024-07-15 18:59:07

x Hide

UPDATE account_bank_statement_line SET is_processed = False where statement_id = 180;

Date: 2024-07-15 14:18:15

x Hide

SELECT f.name, d.json_value FROM ir_default d JOIN ir_model_fields f ON d.field_id = f.id WHERE f.model = 'website.visitor' AND (d.user_id IS NULL OR d.user_id = 4) AND (d.company_id IS NULL OR d.company_id = 1) AND d.condition IS NULL ORDER BY d.user_id, d.company_id, d.id;

Date: 2024-07-15 10:33:26

SELECT f.name, d.json_value FROM ir_default d JOIN ir_model_fields f ON d.field_id = f.id WHERE f.model = 'website.visitor' AND (d.user_id IS NULL OR d.user_id = 4) AND (d.company_id IS NULL OR d.company_id = 1) AND d.condition IS NULL ORDER BY d.user_id, d.company_id, d.id;

Date: 2024-07-15 10:33:26

x Hide

UPDATE "product_warehouse_inventory" SET "last_used_date" = '2024-07-15', "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (14720, 14372, 14375, 14376, 14667, 14353, 14737, 14709, 104889, 14686, 14463);

Date: 2024-07-15 14:35:12

x Hide

INSERT INTO "sale_order" ("id", "create_uid", "create_date", "write_uid", "write_date", "analytic_account_id", "branch_id", "campaign_id", "carrier_id", "cart_recovery_email_sent", "client_order_ref", "commitment_date", "company_id", "date_order", "delivery", "exception_sale", "expense_choice", "fiscal_position_id", "incoterm", "is_cash_sale_order", "is_core_sale", "is_order_unlock", "is_self_used", "marked_as_lost", "medium_id", "name", "note", "opportunity_id", "order_type", "origin", "override_return_rule", "partner_id", "partner_invoice_id", "partner_shipping_id", "payment_term_id", "payment_term_need_password", "picking_policy", "pricelist_id", "project_id", "recompute_delivery_price", "require_payment", "require_signature", "sale_action", "sale_order_template_id", "sale_part_id", "sale_product_qty", "show_update_pricelist", "signed_by", "signed_on", "source_id", "special_instructions", "state", "team_id", "user_id", "validity_date", "warehouse_id") VALUES (nextval('sale_order_id_seq'), 990, (now() at time zone 'UTC'), 990, (now() at time zone 'UTC'), NULL, 48, NULL, 78, false, NULL, NULL, 1, '2024-07-15 17:06:31', NULL, false, NULL, NULL, NULL, true, false, false, false, false, NULL, 'T-26678', '', NULL, 'sale', NULL, false, 46272, 46272, 46272, 112, false, 'direct', 35, NULL, false, false, false, 1, NULL, 203804, 1.0, false, NULL, NULL, NULL, NULL, 'draft', 1, 990, '2025-01-11', 45) RETURNING id;

Date: 2024-07-15 17:06:50

x Hide