-- 1.0.578 —— F-1 差额:三个未指派租户的标准对象一律登记为 AIDOP_NATIVE。 -- 只补缺失行。已有登记不改写(INSERT IGNORE)。不删中立层。 -- 租户:AIDOPB 824585161322565、838257212780613、838257237606469。 -- 对象清单与 MdpStdObjectCatalog.All 一致(21 个)。 -- 体检(只报不删,人工看过再重算;本脚本不执行这段): -- SELECT t.tenant_id, s.std_object, s.source_system, -- (SELECT COUNT(*) FROM mdp_std_inv_trans x -- WHERE x.tenant_id=t.tenant_id AND s.std_object='INV_TRANS' AND x.source_system<>s.source_system) AS inv_trans_other -- FROM (SELECT 824585161322565 AS tenant_id UNION ALL SELECT 838257212780613 UNION ALL SELECT 838257237606469) t -- JOIN mdp_tenant_std_source s ON s.tenant_id=t.tenant_id -- ORDER BY t.tenant_id, s.std_object; INSERT IGNORE INTO mdp_tenant_std_source (tenant_id, std_object, source_system, source_scope, remark) VALUES (824585161322565,'INV_TRANS','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'WO_LINE_PROD','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'WO_LINE_SALES','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'WO_BOM','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'EMPLOYEE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'INV_BAL_MONTHLY','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'S6_REPORT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'FQC_TASK','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'SO','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'WO_SCHEDULE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'SUPPLY_DEMAND','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'PURCHASE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'SUPPLIER_DELIVERY','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'MASTER_ITEM','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'SUPPLIER','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'ACTION_EVENT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'INV_SNAPSHOT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'IQC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'IPQC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'PROD_DOC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (824585161322565,'OUTSOURCE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'INV_TRANS','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'WO_LINE_PROD','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'WO_LINE_SALES','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'WO_BOM','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'EMPLOYEE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'INV_BAL_MONTHLY','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'S6_REPORT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'FQC_TASK','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'SO','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'WO_SCHEDULE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'SUPPLY_DEMAND','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'PURCHASE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'SUPPLIER_DELIVERY','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'MASTER_ITEM','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'SUPPLIER','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'ACTION_EVENT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'INV_SNAPSHOT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'IQC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'IPQC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'PROD_DOC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257212780613,'OUTSOURCE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'INV_TRANS','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'WO_LINE_PROD','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'WO_LINE_SALES','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'WO_BOM','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'EMPLOYEE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'INV_BAL_MONTHLY','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'S6_REPORT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'FQC_TASK','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'SO','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'WO_SCHEDULE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'SUPPLY_DEMAND','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'PURCHASE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'SUPPLIER_DELIVERY','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'MASTER_ITEM','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'SUPPLIER','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'ACTION_EVENT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'INV_SNAPSHOT','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'IQC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'IPQC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'PROD_DOC','AIDOP_NATIVE','','Q15 未指派租户兜底为自有'), (838257237606469,'OUTSOURCE','AIDOP_NATIVE','','Q15 未指派租户兜底为自有');