<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[sumeing的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/sumeing</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sumeing]]></copyright><item><title><![CDATA[常用SQL系统表]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/6028727</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/6028727</guid><author>sumeing</author><pubDate>Tue, 23 Nov 2010 09:01:00 +0800</pubDate><description><![CDATA[<br />常用SQL系统表  1、系统表 t_tabledescription
<br />2、字段表 t_fielddescription<br />3、基础资料表（版本：10.3） t_item 其中fitemclassid值表示<br />      1-客户；2-部门；3-职员；4-商品；5-仓位；7-单位；8-供应商。<br />部门 t_department;职员 t_emp;商品 t_icitem;仓库 t_stock;单位 t_measureunit<br />4、客户资料表 t_org]]></description><category></category></item><item><title><![CDATA[常用金蝶表单查询]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/6019764</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/6019764</guid><author>sumeing</author><pubDate>Thu, 18 Nov 2010 19:13:00 +0800</pubDate><description><![CDATA[BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC]]></description><category></category></item><item><title><![CDATA[常用金蝶表单查询]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/6019762</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/6019762</guid><author>sumeing</author><pubDate>Thu, 18 Nov 2010 19:13:00 +0800</pubDate><description><![CDATA[BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC]]></description><category></category></item><item><title><![CDATA[常用金蝶表单查询]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/6019761</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/6019761</guid><author>sumeing</author><pubDate>Thu, 18 Nov 2010 19:13:00 +0800</pubDate><description><![CDATA[BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC]]></description><category></category></item><item><title><![CDATA[采购限价触发器（K310.3）]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/6019759</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/6019759</guid><author>sumeing</author><pubDate>Thu, 18 Nov 2010 19:11:00 +0800</pubDate><description><![CDATA[create trigger [poorder_insert_01] on [dbo].[poorder]<br />for insert<br />as <br />declare @poorder_interid int <br />select @poorder_interid=finterid from inserted<br />if IF EXISTS ( SELECT 1 FROM poorder p1 inner join poorderentry p2 on <br />p1.finter]]></description><category></category></item><item><title><![CDATA[VB连接SQL2000数据库代码]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964685</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964685</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 17:25:00 +0800</pubDate><description><![CDATA[<br /> <br />Option Explicit<br />Dim Conn As New ADODB.Connection<br />Dim rs As New ADODB.Recordset<br />Private Sub Form_Load()<br />    Show<br />    Conn.Open "Provider=SQLOLEDB;Data Source=服务器IP（或本地机器名）;UID=用户名（sa）;PWD=密码（sa）;initial catalog=数据库名称"<b]]></description><category></category></item><item><title><![CDATA[向八张出入库老单据体中插入同一个字段k3]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964645</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964645</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 17:13:00 +0800</pubDate><description><![CDATA[<br /> <br />/* 向八张出入库老单据体中插入/"销售合约'/"这个字段FEntryCode, 销售合约是核算项目，类别是３００３ */ <br />Insert Into ICTemplateEntry(FID,FCtlIndex,FCtlOrder,FHeadCaption,FHeadCaption_CHT,FHeadCaption_EN,FCtlType,FLookUpCls,FNeedSave,FValueType,FSaveValue,FFieldName,FWidth,FEnable]]></description><category></category></item><item><title><![CDATA[金蝶K3 10.3sp1应收款管理反结账代码]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964639</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964639</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 17:11:00 +0800</pubDate><description><![CDATA[<br /><br />Update t_subsys set  Fused = -1 ,  FPeriodSynch = 0 ,  FCheckout = 0 where Fsubsysid = 5 and Fyear= 2009 and Fperiod = 12;<br />Update t_RP_SystemProfile Set FValue = '12' Where FCategory = 'ARP' And FKey = 'FARCurPeriod';<br />Update t_RP_Syst]]></description><category></category></item><item><title><![CDATA[存储过程_采购入库购货发票、费用发票跟踪表]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964621</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964621</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 17:06:00 +0800</pubDate><description><![CDATA[<br /> <br /><br />CREATE PROCEDURE [FuRuiBuy]<br />@Bdate as datetime,<br />@Edate as datetime,<br />@SuppName as nvarchar(100), --客户名称<br />@EmpName as nvarchar(100), --业务员<br />@ItemName as nvarchar(100), -- 商品名称<br />@ZhangTao as nvarchar(100), --帐套0<b]]></description><category></category></item><item><title><![CDATA[金蝶K3付款单代码]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964417</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964417</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 16:17:00 +0800</pubDate><description><![CDATA[<br /> <br /><br />SELECT t_Currency3.FScale AS FCurrencyID_Decimal,t_currency4.FScale AS FReceiveCyID_Decimal,t_currency5.FScale AS FSettleCyID_Decimal,t_RP_NewReceiveBill.FMulCy,t_RP_NewReceiveBill.FNumber,t_RP_NewReceiveBill.FDate,<br />t_RP_NewReceiveB]]></description><category></category></item><item><title><![CDATA[销售合同执行一览表-存储过程版]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964344</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964344</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 16:01:00 +0800</pubDate><description><![CDATA[<br />转自：救火论坛<br /><br />CREATE PROCEDURE [MyContractSale] <br />@Bdate as datetime,<br />@Edate as datetime,<br />@CustName as nvarchar(100)<br />AS<br />功能:销售合同执行汇总表,一览方式查询<br />制作:救火<br />日期:2009-07-23<br />修改:<br />版本:0.0<br />set nocount off<br />sele]]></description><category></category></item><item><title><![CDATA[采购合同执行跟踪表]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964336</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964336</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 16:00:00 +0800</pubDate><description><![CDATA[<br /> <br /> <br />CREATE PROCEDURE [MyContractReport2] AS<br />/**合同跟踪表**/<br />set nocount on<br />Create Table #t_Phase(<br />   FPhaseName varchar(355), <br />   FTypeID int not null default(0)) <br />Insert into #t_Phase values('采购订单',1) <br />Insert]]></description><category></category></item><item><title><![CDATA[金蝶K3其他应收单]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964328</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964328</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 15:58:00 +0800</pubDate><description><![CDATA[

select t.* from 
  t_RP_ARPBill  t
INNER JOIN t_rp_arpbillEntry u ON t.FBillID=u.FBillID 
]]></description><category></category></item><item><title><![CDATA[科目余额表代码]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964321</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964321</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 15:56:00 +0800</pubDate><description><![CDATA[<br />科目余额表代码<br /><br />/**公司名称代码开始**/<br />Select t.* Into #AcctBal2569457n <br />From (<br />    Select 0 FBalanceTotal,a.FAccountID,a.FNumber ,<br />    convert(varchar(800),a.FName) FName,a.FLevel,a.FDC,a.FDetail,<br />    a.FParentID,a.FRootID,Isnull]]></description><category></category></item><item><title><![CDATA[K3自定义sql报表字段显示标题]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964319</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964319</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 15:55:00 +0800</pubDate><description><![CDATA[<br /> <br /><br />DELETE FROM ICListTemplate WHERE FID=70001;<br />DELETE FROM ICChatBillTitle WHERE FTypeID = 70001;<br />DELETE FROM t_ObjectAccessType WHERE FObjectType=4100 AND FObjectID =70001;<br />DELETE FROM t_ObjectType WHERE FObjectType=4100 AND]]></description><category></category></item><item><title><![CDATA[K3 12.1wise 应收款转销后无法做应收冲应付款结算原因分析及解决方法]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964312</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964312</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 15:53:00 +0800</pubDate><description><![CDATA[<br /> <br />原因为K3结算查询代码多了个<br /> <br />select a.FExchangeRateType,b.FID,a.FClassTypeID,a.FCurrencyID,a.FCustomer,a.FDepartment ,a.FEmployee,a.FItemClassID,a.FBillID FInterID,0 FPre,<br />0 FIsInit,b.FK3Import,b.FStatus,b.FCheckType, 0 FInvoiceID,a.FBillID]]></description><category></category></item><item><title><![CDATA[总账系统参数]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964310</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964310</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 15:52:00 +0800</pubDate><description><![CDATA[<br />SELECT *<br />FROM t_SystemProfile<br />WHERE (FCategory = 'GL') ]]></description><category></category></item><item><title><![CDATA[K3固定资产类别及存放地点储存表]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964303</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964303</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 15:51:00 +0800</pubDate><description><![CDATA[<br /> <br /><br />SELECT  distinct * from t_fagroup where fid<>0  order by fnumber <br />SELECT  *   FROM t_FALocation WHERE FID <> 0  ORDER BY FNumber]]></description><category></category></item><item><title><![CDATA[K3应收应付结账检查处理代码]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5964299</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5964299</guid><author>sumeing</author><pubDate>Mon, 25 Oct 2010 15:50:00 +0800</pubDate><description><![CDATA[<br /> <br />查科目IT内码<br />select * from t_account <br />where fname like '%客户%'<br /> <br /><br />单据科目与凭证科目不一致<br />SELECT *<br />FROM t_RP_ARPBill<br />WHERE (FNumber LIKE 'QTYs%')<br />修改FAcountID<br /> <br /><br />收款单列表<br />select * from t_RP_NewReceiv]]></description><category></category></item><item><title><![CDATA[删除数据库中重复数据的几个方法 ]]></title><link>https://blog.youkuaiyun.com/sumeing/article/details/5956165</link><guid>https://blog.youkuaiyun.com/sumeing/article/details/5956165</guid><author>sumeing</author><pubDate>Thu, 21 Oct 2010 11:26:00 +0800</pubDate><description><![CDATA[<br /><br />方法一<br />declare @max integer,@id integer<br />declare cur_rows cursor local for select 主字段,count(*) from 表名 group by 主字段 having count(*) > 1<br />open cur_rows<br />fetch cur_rows into @id,@max<br />while @@fetch_status=0<br />begin<br />selec]]></description><category></category></item></channel></rss>