金蝶K3 采购入库单

Select * From ( Select v1.FInterID AS [FInterID],  
u1.FEntryID AS [FEntryID],  
t3.FName AS [FSupplyID],  
v1.Fdate AS [Fdate],  
v1.FBillNo AS [FBillNo],  
case when v1.FCheckerID>0 then '※' when v1.FCheckerID<0 then '※' else '' end AS [FCheckFlag],  
case when v1.FStatus=3 then '※' else '' end AS [FStatusEx],  
u1.FMapNumber AS [FMapNumber],  
u1.FMapName AS [FMapName],  
t14.FShortNumber AS [FShortNumber],  
t14.Fname AS [FItemID],  
t14.Fmodel AS [Fmodel],  
t17.FName AS [FUnitID],  
t8.FName AS [FCurrencyID],  
v1.FExchangeRate AS [FExchangeRate],  

t9.FName AS [FMangerID],  
t10.FName AS [FDeptID],  
t11.FName AS [FEmpID],  
t12.FName AS [FBillerID],  
u1.FSourceTranType AS [FSourceTranType],  
u1.FSourceBillNo AS [FSourceBillNo],  
u1.FAuxQty AS [FAuxQty],  
u1.Fdate AS [FCommitdate],  
u1.Fauxprice AS [Fauxprice],  
u1.FTaxRate AS [FTaxRate],  
u1.FCess AS [FCess],  
u1.FAmount AS [FAmount],  
u1.FNote AS [FNote],  
t13.FName AS [FCheckerID],  
t18.FName AS [FUnitGroupID],  
u1.FQty AS [FQty],  
case when v1.FCancellation=1 then '※' else '' end AS [FCancellation],  
t20.FName AS [FRelateBrID],  
t14.FNumber AS [FNumber],  
t5.FName AS [FPOStyle],  
u1.FCommitQty AS [FCommitQty],  
u1.FAuxCommitQty AS [FAuxCommitQty],  
u1.FStockQty AS [FStockQty],  
u1.FAuxStockQty AS [FAuxStockQty],  
Case WHEN t14.FCUUnitID=0 THEN '' Else t500.FName end AS [FCUUnitID],  
Case WHEN t14.FCUUnitID=0 THEN 0 Else u1.FQty/t500.FCoefficient end AS [FcuQty],
v1.FBrNo as 公司内码ID,
v1.FBillerID as 制单人ID,
v1.FTranType as 单据类型ID,
v1.FDeptID as 部门ID,
v1.FMangerID as  主管ID,
v1.FEmpID as 业务员ID,
v1.FSupplyID as 供应商ID,
v1.FCheckerID as 审核人ID,
v1.FPOStyle as 采购方式ID,
u1.FItemID as 货名ID,
u1.FUnitID as 单位ID,
v1.FStatus as 状态,
round(u1.FAuxQty-u1.FCommitQty,3) as 剩余量

 from POOrder v1 (NOLOCK) Left Join POOrderEntry u1 (NOLOCK) on v1.FInterID=u1.FInterID  
 left outer join t_Supplier t3 (NOLOCK) on v1.FSupplyID=t3.FItemID  
 left outer join t_SubMessage t5 (NOLOCK) on v1.FPOStyle=t5.FInterID  
 Left Join t_Currency t8 (NOLOCK) on v1.FCurrencyID=t8.FCurrencyID  
 left outer join t_Emp t9 (NOLOCK) on v1.FMangerID=t9.FItemID  
 left outer join t_Department t10 (NOLOCK) on v1.FDeptID=t10.FItemID  
 left outer join t_Emp t11 (NOLOCK) on v1.FEmpID=t11.FItemID  
 left outer join t_User t12 (NOLOCK) on v1.FBillerID=t12.FUserID  
 left outer join t_User t13 (NOLOCK) on v1.FCheckerID=t13.FUserID  
 Left Join t_ICItem t14 (NOLOCK) on u1.FItemID=t14.FItemID  
 Left Join t_MeasureUnit t17 (NOLOCK) on u1.FUnitID=t17.FItemID  
 Left Join t_MeasureUnit t18 (NOLOCK) on t14.FUnitGroupID=t18.FUnitGroupID  
 left outer join t_SonCompany t20 (NOLOCK) on v1.FRelateBrID=t20.FItemID  
 left outer join t_MeasureUnit t500 (NOLOCK) on t14.FCUUnitID=t500.FItemID  
 left outer join t_Currency t503 (NOLOCK) on v1.FCurrencyID=t503.FCurrencyID  

 where t18.FStandard=1  
   
) As [TicketViewBuy]