进销存->销售管理子系统->打印客户订单
输入 订单单别
输入 订单单号
起 210520002
止 210520002
高级选项 选中全部
系统选项 选择单据模板
进销存->销售管理子系统->打印客户订单
输入 订单单别
输入 订单单号
起 210520002
止 210520002
高级选项 选中全部
系统选项 选择单据模板
料号
UPDATE b SET b.MB001=a.MB001,b.MB002=a.MB002,b.MB003=a.MB003,b.UDF51=a.UDF51,b.UDF52=a.UDF52,b.UDF53=a.UDF53,b.UDF01=a.UDF01,b.UDF54=a.UDF54,b.UDF02=a.UDF02,b.UDF03=a.UDF03,b.MB004=a.MB004 FROM wu a,INVMB b WHERE a.MB001 = b.MB001 and b.MB001 in('料号')
select a.MB001,a.UDF51 as 毛重,b.UDF51,a.UDF52 as 单重,b.UDF52,a.UDF53 as 水口,b.UDF53,a.UDF01 as 模号,b.UDF01,a.UDF54 as 穴口,b.UDF54,a.UDF02 as 机台,b.UDF02,a.UDF03 as 周期,b.UDF03,a.MB004 as 单位,b.MB004 from wu a,(select MB001,MB002,MB003,UDF51,UDF52,UDF53,UDF01,UDF54,UDF02,UDF03,MB004 from INVMB where MB001 in(select MB001 from wu)) b where replace(a.MB001,' ','')=replace(b.MB001,' ','') --系统料号 and ( --a.MB002!=b.MB002 --品名 a.MB003!=b.MB003 --规格 or a.UDF51!=b.UDF51 --毛重 or a.UDF52!=b.UDF52 --单重 or a.UDF53!=b.UDF53 --水口 or a.UDF01!=b.UDF01 --模号 or a.UDF54!=b.UDF54 --穴口 or a.UDF02!=b.UDF02 --机台 or a.UDF03!=b.UDF03 --周期 or a.MB004!=b.MB004 --单位 ) and a.MB001='366-001002-001' --group by a.MB001 having count(1) >1;
BOM select CB008 as 用量,CB009 as 底数,CB010*100 as "损耗率%" from BOMCB where CB005='402-003013-001' 系统料号 select MB001 as 系统料号,MB002 as 品名,MB003 as 规格,UDF51 as 毛重,UDF52 as 单重,UDF53 as 水口,UDF01 as 模号,UDF54 as 穴口,UDF02 as 机台,UDF03 as 周期,MB004 as 单位 from INVMB where MB001='374-001005-001' 客户料号 select MG003 as 客户品号 from COPMG where MG002='174-001005-001' bom调整单 select TA007,* from BOMTA where TA007 like '%N%'
select CB008 from BOMCB where CB001='339-003003-001' and CB005='403-001001-001' update BOMCB set CB008='1.5' where CB001='339-003003-001' and CB005='403-001001-001' select UDF52 from INVMB where MB001='339-003003-001';//单重 select UDF51 from INVMB where MB001='339-003003-001';//毛重 select UDF53 from INVMB where MB001='339-003003-001';//水口 select UDF54 from INVMB where MB001='339-003003-001';//穴口 select CB001 as BOM 料号,MB002 as 品名,MB003 as 规格,CB008 as BOM单重,(select UDF52 from INVMB where MB001=BOMCB.CB001) as 料号单重 from BOMCB where CB001='339-003003-001' and CB005='403-001001-001'