易飞ERP 数据库新增销售单

摘要

--新增销售单
INSERT INTO [TLLL].[dbo].[COPTH]
           ([COMPANY]
           ,[CREATOR]
           ,[USR_GROUP]
           ,[CREATE_DATE]
           ,[MODIFIER]
           ,[MODI_DATE]
          ...

--新增销售单
INSERT INTO [TLLL].[dbo].[COPTH]
           ([COMPANY]
           ,[CREATOR]
           ,[USR_GROUP]
           ,[CREATE_DATE]
           ,[MODIFIER]
           ,[MODI_DATE]
           ,[FLAG]
           ,[TH001]
           ,[TH002]
           ,[TH003]
           ,[TH004]
           ,[TH005]
           ,[TH006]
           ,[TH007]
           ,[TH008]
           ,[TH009]
           ,[TH010]
           ,[TH011]
           ,[TH012]
           ,[TH013]
           ,[TH014]
           ,[TH015]
           ,[TH016]
           ,[TH017]
           ,[TH018]
           ,[TH019]
           ,[TH020]
           ,[TH021]
           ,[TH022]
           ,[TH023]
           ,[TH024]
           ,[TH025]
           ,[TH026]
           ,[TH027]
           ,[TH028]
           ,[TH029]
           ,[TH030]
           ,[TH031]
           ,[TH032]
           ,[TH033]
           ,[TH034]
           ,[TH035]
           ,[TH036]
           ,[TH037]
           ,[TH038]
           ,[TH039]
           ,[TH040]
           ,[TH041]
           ,[TH042]
           ,[TH043]
           ,[TH044]
           ,[TH045]
           ,[TH046]
           ,[TH047]
           ,[TH048]
           ,[TH049]
           ,[TH050]
           ,[TH051]
           ,[TH052]
           ,[TH053]
           ,[TH054]
           ,[TH055]
,[TH056]
           ,[TH057]
           ,[TH058]
           ,[TH059]
           ,[TH060]
           ,[TH061]
           ,[TH062]
           ,[UDF01]
           ,[UDF02]
           ,[UDF03]
           ,[UDF04]
           ,[UDF05]
           ,[UDF06]
           ,[UDF51]
           ,[UDF52]
           ,[UDF53]
           ,[UDF54]
           ,[UDF55]
           ,[UDF56])
     VALUES
          ( 'TLLL','xstj','1006','20130117112015483','','',1,'2302','20130117006','0001','273136501MB ','铝合金车(MB)','273&13*6.5&73.1&-10&4*114.3','103','79.000000','','0.000000','','25.50000000',2014.50,'2202',
'TLS12220','0001','TLS12220',NULL,'','N','N','','',0,1.0000,'N','','','','',1,'','','',2014.50,
0.00,12672.82,0.00,464.520000,0.000000,'KG',0.000000,0.000000,0.000000,'','','',0.0000,0.00000000,0.00000000,'','','','','XP',
'##########','','',NULL,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000)

📱 扫码关注公众号

扫描二维码关注我们，获取更多精彩内容
实时更新 · 干货满满