ZZYDOP
/
AiDOPWarehouse


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576
							-- 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 未指派租户兜底为自有');