解决方案: |
执行以下脚本改正: drop view ap_closecust_v go CREATE VIEW Ap_CloseCust_V AS SELECT Customer.cCCCode AS cDWCCode,Customer.cDCCode AS cDWDCode, CASE WHEN Customer.cCusName<>'' THEN Customer.cCusName ELSE Customer.cCusAbbName END AS cDWName, Customer.cCusPPerson AS cHPsnCode,Customer.cCusDepart AS cHDptCode, Customer.cCusHeadCode AS cHDWCode,Customer.iCusCreLine AS iCreLine, Ap_VouchType.cTypeName,Customer.iid as cAuthID, 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_CloseBill.cVouchType,AP_CloseBill.cVouchID,AP_CloseBill.dVouchDate,AP_CloseBill.iPeriod, AP_CloseBill.iID,AP_CloseBills.ID, AP_CloseBills.cCusVen as cDwCode,cDepCode as cDeptCode,cPersonCode as cPerson,Ap_CloseBills.cXmClass as cItem_Class,cXm as cItemCode,ap_CloseBills.cItemName as cItemName, AP_CloseBill.cSSCode,AP_CloseBill.cNoteNo,AP_CloseBill.cDigest,AP_CloseBill.cBankAccount,AP_CloseBill.cBank, AP_CloseBill.cexch_name,AP_CloseBill.iExchRate,AP_CloseBills.iAmt as iAmount,AP_CloseBills.iAmt_f as iAmount_f, AP_CloseBills.iRAmt_f as iRAmount_f,AP_CloseBills.iRAmt as iRAmount, AP_CloseBill.cOperator,AP_CloseBill.cCancelMan,AP_CloseBills.cKm as cCode,AP_CloseBill.cPzID,AP_CloseBill.cFlag, AP_CloseBill.cCheckMan,AP_CloseBill.cDefine1,AP_CloseBill.cDefine2,AP_CloseBill.cDefine3,AP_CloseBill.cDefine4,AP_CloseBill.cDefine5,AP_CloseBill.cDefine6,AP_CloseBill.cDefine7, AP_CloseBill.cDefine8,AP_CloseBill.cDefine9,AP_CloseBill.cDefine10,AP_CloseBill.cDefine11,AP_CloseBill.cDefine12,AP_CloseBill.cDefine13,AP_CloseBill.cDefine14, AP_CloseBill.cDefine15,AP_CloseBill.cDefine16,AP_CloseBills.bPrePay,'' as cInvCode,Null as cInvName,Null as cInvCCode,Ap_CloseBill.cCancelNo, ap_closebills.cConType as cContractType,ap_closebills.cConID as cContractID FROM AP_CloseBill inner join Ap_CloseBills on Ap_closebill.iid=Ap_CloseBills.iid LEFT JOIN Ap_VouchType ON AP_CloseBill.cVouchType = Ap_VouchType.cTypeCode LEFT JOIN Customer ON AP_CloseBills.cCusVen = Customer.cCusCode WHERE AP_CloseBill.cFlag = 'AR' and iType |