易飞ERP 数据库销售单查错与客户订单删

Jack·高峰 • 2013-04-27 15:03 • 3580 阅读

--销货单查询 --销货单查单头档 select * from COPTG where TG002='20130117005' --COPTG=销货单单头--TG002=销货单 --销货单查身 select * from COPTH where TH017='TLS12219'and TH004 = '273136501MB'and TH003='0002' --...

当前字体大小 15px

12px 50px

--销货单查询
--销货单查单头档
select * from COPTG where  TG002='20130117005'  --COPTG=销货单单头--TG002=销货单
--销货单查身
select * from COPTH where TH017='TLS12219'and TH004 = '273136501MB'and TH003='0002' --TH017=订单单号--TH004=产品品号--TH003=序号
--删除销货单
delete from COPTH where TH017='TLS12220' AND TH004 = '273136501MB'
--客户订单查询
--客户订单查单头信息档
select * from COPTC where TC002='TLS12220'--COPTC=客户订单单头信息
select * from COPTD where TD002='TLS12220' AND TD004 = 'TL1238199510CB3IS'--COPTD=客户订单单身信息
select * from COPTD where TD002='TLS12220' AND TD004 = '273136501MB' AND CREATOR='tztj'
--删除客户订单
delete from COPTD where TD002='TLS12220' AND TD003='0002' AND TD004 = 'TL5067177502MG'
delete from COPTD where TD002='TLS12220' AND TD004 = '273136501MB' AND TD003='0002'