打开领料单提示列名无效。
1,122次浏览
编辑于2017年08月31日 15:53:41
打开领料单的时候提示,在后台跟踪到这个语句,实际表中没有这个字段。
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT ICStockBill.FInterID, ICStockBill.Fdate, ICStockBill.FDeptID, t001.FNumber as FDeptIDNumber, t001.FName as FDeptIDName, ICStockBill.Fuse, ICStockBill.FBillNo, ICStockBill.FSCStockID, t004.FNumber as FSCStockIDNumber, t004.FName as FSCStockIDName, ICStockBill.FCheckerID, t005.FDescription as FCheckerIDNumber, t005.FName as FCheckerIDName, ICStockBill.FCheckDate, ICStockBill.FPosterID, t007.FDescription as FPosterIDNumber, t007.FName as FPosterIDName, ICStockBill.FSManagerID, t008.FNumber as FSManagerIDNumber, t008.FName as FSManagerIDName, ICStockBill.FFManagerID, t009.FNumber as FFManagerIDNumber, t009.FName as FFManagerIDName, ICStockBill.FBillerID, t010.FDescription as FBillerIDNumber, t010.FName as FBillerIDName, ICStockBill.FAcctID, t011.FNumber as FAcctIDNumber, t011.FFullName as FAcctIDName, ICStockBill.FMultiCheckDate1, ICStockBill.FMultiCheckDate2, ICStockBill.FMultiCheckDate3, ICStockBill.FMultiCheckDate4, ICStockBill.FMultiCheckDate5, ICStockBill.FMultiCheckDate6, ICStockBill.FPurposeID, t018.FID as FPurposeIDNumber, t018.FName as FPurposeIDName, ICStockBill.FPrintCount, ICStockBill.FWBINTERID, ICStockBill.FSelTranType, t021.FName as FSelTranTypeNumber, t021.FName as FSelTranTypeName, ICStockBill.FBackFlushed, ICStockBill.FManageType, ICStockBill.FExplanation_KIS12, ICStockBill.FBrNo, ICStockBill.FTranType, ICStockBill.FCancellation, ICStockBill.FStatus, ICStockBill.FDiscountType, ICStockBill.FUpStockWhenSave, ICStockBill.FVchInterID, ICStockBill.FROB, ICStockBill.FHookStatus
FROM ICStockBill left join t_Department t001 on ICStockBill.FDeptID= t001.FItemID AND t001.FItemID<>0 left join t_Stock t004 on ICStockBill.FSCStockID= t004.FItemID AND t004.FItemID<>0 left join t_User t005 on ICStockBill.FCheckerID= t005.FUserID AND t005.FUserID<>0 left join t_User t007 on ICStockBill.FPosterID= t007.FUserID AND t007.FUserID<>0 left join t_Emp t008 on ICStockBill.FSManagerID= t008.FItemID AND t008.FItemID<>0 left join t_Emp t009 on ICStockBill.FFManagerID= t009.FItemID AND t009.FItemID<>0 left join t_User t010 on ICStockBill.FBillerID= t010.FUserID AND t010.FUserID<>0 left join t_Account t011 on ICStockBill.FAcctID= t011.FAccountID AND t011.FAccountID<>0 left join t_SubMessage t018 on ICStockBill.FPurposeID= t018.FInterID AND t018.FInterID<>0 left join v_ICTransType t021 on ICStockBill.FSelTranType= t021.FInterID AND t021.FInterID<>0
WHERE ICStockBill.FInterID IN (40582)
QQ截图20170831154912.png(41.08KB)
推荐阅读