|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
从U861升级到U811.1 有一个年度报错,求高人帮指点一下,谢谢!
数据库名: UFDATA_025_2013
C:\U8SOFT\Admin\SQLFILE8700\Main\Ufdata\Structure\Data_PRV_AP_mix_NL.sql
错误信息:
-2147217900列名 'iyear' 不明确。
执行如下语句时出错:
Create VIEW Ap_DetailCust
AS
SELECT
Customer.cCCCode AS cDWCCode,CustomerClass.cCCName as cDWCName, Customer.cDCCode AS cDWDCode,
Customer.cCusCreditcompany,CASE WHEN Customer_2.cCusName<>'' THEN Customer_2.cCusName ELSE Customer_2.cCusAbbName END as cCusCreditname,
DistrictClass.cDCName,Case When Customer.cCusName<>'' Then Customer.cCusName Else
Customer.cCusAbbName End AS cDWName, Customer.cCusPPerson AS cHPsnCode,
Person_1.cPersonName as cHPersonName,Customer.cCusDepart AS cHDptCode,
Department_1.cDepName as cHDepName,Customer.cCusHeadCode AS cHDWCode,
CASE WHEN Customer_1.cCusName<>'' THEN Customer_1.cCusName ELSE Customer_1.cCusAbbName END AS cHDwName,
Customer.iCusCreLine AS iCreLine,Department.cDepName, Person.cPersonName, Inventory.cInvName,Inventory.cInvStd,
Inventory.cInvCCode,InventoryClass.cInvCName,Ap_VouchType.cTypeName,Ap_VouchType_2.cTypeName AS cProcName,
customer.cCusAddress as cDwAddress,customer.cCusPostCode as cDwPostCode,customer.cCusEmail as cDwEmail,customer.cCusPerson as cDwPerson,customer.cCusPhone as cDwPhone,customer.cCusFax as cDwFax,
Ap_VouchType_1.cTypeName AS cCoTypeName,SettleStyle.cSSName,
dVouchDate+isnull(PayCondition.iPayCreDays,0) AS dExpireDate,
dVouchDate+isnull(PayCondition_1.iPayCreDays,0)AS dExpireDate_DW,
dVouchDate+IsNull(PayCondition.iPayFaDays,0)AS dFaDate,PayCondition.cPayName,
Customer.iid as cAuthID,Customer.cCusEmail As Email,Customer.cCusHand As HandPhone,
Ap_Detail.*,fitem.cItem_Name,code.cCode_Name,cm_type.ctypename as cContractTypeName,cm.strContractName as cContractName,AA_enum.enumname as cOrderType,
p.iyear as accountyear,p.iid as accountmonth, DATEDIFF(day,p.dbegin,dCreditStart)+1 as accountday,
convert(datetime,cast(p.iyear as varchar)+'-'+cast(p.iid as varchar)+'-'+cast(DATEDIFF(day,p.dbegin,dCreditStart)+1 as varchar)) as dCreditDate
FROM
Ap_Detail LEFT JOIN Ap_VouchType ON Ap_Detail.cVouchType = Ap_VouchType.cTypeCode
LEFT JOIN Ap_VouchType Ap_VouchType_2 ON Ap_Detail.cProcstyle = Ap_VouchType_2.cTypeCode
LEFT JOIN Customer
ON Ap_Detail.cDwCode = Customer.cCusCode LEFT JOIN Department
ON Ap_Detail.cDeptCode = Department.cDepCode LEFT JOIN SettleStyle
ON Ap_Detail.cSSCode = SettleStyle.cSSCode LEFT JOIN Person
ON Ap_Detail.cPerson = Person.cPersonCode LEFT JOIN PayCondition
ON Ap_Detail.cPayCode = PayCondition.cPayCode LEFT JOIN Inventory
ON Ap_Detail.cInvCode = Inventory.cInvCode LEFT JOIN PayCondition AS PayCondition_1
ON Customer.cCusPayCond = PayCondition_1.cPayCode LEFT JOIN CustomerClass
ON Customer.cCCCode=CustomerClass.cCCCode LEFT JOIN Customer as Customer_1
ON Customer.cCusHeadCode=Customer_1.cCusCode LEFT JOIN DistrictClass
ON Customer.cDCCode=DistrictClass.cDCCode LEFT JOIN Department as Department_1
ON Customer.cCusDepart=Department_1.cDepCode LEFT JOIN Person as Person_1
ON Customer.cCusPPerson=Person_1.cPersonCode LEFT JOIN InventoryClass
ON Inventory.cInvCCode=InventoryClass.cInvCCode LEFT JOIN Ap_VouchType as Ap_VouchType_1
ON Ap_Detail.cCoVouchType=Ap_VouchType_1.cTypeCode LEFT JOIN fitem
ON Ap_Detail.cItem_Class=fitem.cItem_Class LEFT JOIN code
ON Ap_Detail.cCode=code.cCode
LEFT join cm_type on Ap_detail.cContractType=cm_type.ctypecode
Left Join v_CM_ContractForAPAR cm on ap_detail.cContractID=cm.strContractID
Left Join V_AA_enum AA_enum on AA_enum.EnumType='AR.OrderType' And ap_detail.iOrderType=AA_enum.EnumIndex
LEFT JOIN Customer as Customer_2
ON Customer.cCusCreditcompany=Customer_2.cCusCode
left join ufsystem..ua_period p
on cAcc_Id=substring(db_name(),8,3) and iyear=substring(db_name(),12,4) and dCreditStart between p.dbegin and p.dend
WHERE
Ap_Detail.cFlag='AR'
|
|