用友合并基础档案编码和名称的sql语句
----------------------------------------
1.客户
(convert(varchar(10),ltrim(rtrim( Customer.cCusCode ))) + '-' + convert(nvarchar(100),ltrim(rtrim(Customer.cCusName ))) )
----------------------------------------
2.部门
( convert(varchar(10),ltrim(rtrim(Department.cDepCode ))) + '-' + convert(nvarchar(100),ltrim(rtrim(Department.cDepName ))) )
----------------------------------------
3.职员
( convert(varchar(10),ltrim(rtrim(person.cPersonCode ))) + '-' + convert(nvarchar(100),ltrim(rtrim(person.cPersonName ))) )
----------------------------------------
4.存货
( convert(varchar(20),ltrim(rtrim(Inventory.cInvCode ))) + '-' + convert(varchar(100),ltrim(rtrim(Inventory.cInvName ))) + '-' + convert(varchar(100),ltrim(rtrim(isnull(Inventory.cInvStd , '无规格') ))) )
----------------------------------------
5.销售类型
( convert(varchar(10),ltrim(rtrim(SaleType.cSTCode ))) + '-' + convert(nvarchar(100),ltrim(rtrim(SaleType.cSTName ))) )
----------------------------------------
6.发运方式
( convert(varchar(10),ltrim(rtrim(ShippingChoice.cSCCode ))) + '-' + convert(nvarchar(100),ltrim(rtrim(ShippingChoice.cSCName ))) )
----------------------------------------
7.付款条件
( convert(varchar(10),ltrim(rtrim(PayCondition.cPayCode ))) + '-'+ convert(nvarchar(100),ltrim(rtrim(PayCondition.cPayName ))) )
----------------------------------------
----------------------------------------
60.1销售订单中: 根据订单日期,获取订单的 年月
( convert(varchar(4),year(SO_SOMain.dDate)) + '-' +REPLICATE('0',2-len(month(SO_SOMain.dDate))) + convert(varchar(2), month(SO_SOMain.dDate)))
----------------------------------------
60.2销售订单中: 根据订单日期,获取订单的 年度
convert(varchar(4),year(SO_SOMain.dDate))
----------------------------------------
60.3销售订单中: 根据订单日期,获取订单的 月份(期间)
( REPLICATE('0',2-len(month(SO_SOMain.dDate))) + convert(varchar(2), month(SO_SOMain.dDate)))
----------------------------------------
----------------------------------------
61.销售订单中: 订货待发货_数量
( isnull( ( SO_SODetails.iQuantity) , 0) - isnull( ( SO_SODetails.iFHQuantity ) ,0) )
----------------------------------------
62.销售订单中: 订货待开票_数量
( isnull( ( SO_SODetails.iQuantity) , 0) - isnull( ( SO_SODetails.iKPNum ) ,0) )
----------------------------------------
62.销售订单中: 发货待开票_数量
( isnull( (SO_SODetails.iFHQuantity ) , 0) - isnull( ( SO_SODetails.iKPNum ),0) )
----------------------------------------
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。