ＫＩＳ专业版销售订单执行情况明细表，目前没有订单单价、订单金额、销售单价、销售金额、未出库单价、未出库金额．
由于我sql语句刚学，目前只能写出订单单价、订单金额．请高手指点！！！！
Set NoCount On Set ANSI_Warnings Off
Create Table #T138_1
(FInterID Int Null,
FStockInterID Int Null,
FStockTranType SmallInt Null,
FDate DateTime Null,
FBillNo Varchar(355) Null,
FItemID Int Null,
FCommitQty Float Null,
FAmount Float Null, ----- 金额
FPrice Float Null, ----- 单价
FUnCommitQty Float Null,

FSendUnitName Varchar(355) Null,
FOutSrcEntryID Int Null,
FStockSrcEntryID Int Null,FDelay Int Null )

Insert Into #T138_1
(FStockInterID,FStockTranType, FInterID,FDate,FBillNo, FItemID, FCommitQty,
FSendUnitName,FOutSrcEntryID,FStockSrcEntryID,FDelay)
Select t1.FInterID,t1.FTranType,t3.FInterid,t1.FDate,t1.FBillNo,t4.FItemID,
T4.FQty,t5.FName,t4.FOrderEntryID FOutSrcEntryID,
t4.FOrderEntryID FStockSrcEntryID,
Case When t1.FDate>t8.FAdviceCOnSignDate And t1.FROB=1 Then 1 Else 0 End
From SEOrder t3
Inner Join SEOrderEntry t8 On t8.FInterID = t3.FInterID
Inner Join ICStockBillEntry t4 On t3.FInterId=t4.FOrderInterID And t4.FOrderEntryID = t8.FEntryID
Inner Join ICStockBill t1 On t4.FInterID = t1.FInterID And t1.FTrantype =21 And t4.FDCStockID=t1.FDCStockID
Inner Join t_MeasureUnit t5 On t5.FMeasureUnitID=t4.FUnitID
Inner Join t_ICItem t10 On t4.Fitemid =t10.Fitemid
left Join t_OrganizatiOn t11 On t3.FCustID = t11.FItemID
Left Join t_SOnCompany t12 On t3.FRelateBrID = t12.FItemID
left Join T_Department TD On t3.FDeptID=TD.FItemID
left Join T_Emp TE On t3.FEmpID=TE.FItemID
Where 1=1 And (t1.FStatus > 0 or (t1.FUpStockWhenSave > 0 And t1.FCancellatiOn ='2007-04-01' And t3.FDate='2007-04-01' And t3.FDate
Insert Into #T138_1
(FStockInterID,FStockTranType, FInterID,FDate,FBillNo, FItemID, FCommitQty,
FSendUnitName,FOutSrcEntryID,FStockSrcEntryID,FDelay)
Select t1.FInterID,t1.FTranType,t3.FInterid,t1.FDate,t1.FBillNo,t4.FItemID,
T4.FQty,t5.FName,t4.FOrderEntryID FOutSrcEntryID,
t4.FOrderEntryID FStockSrcEntryID,
Case When t1.FDate>t8.FAdviceCOnSignDate And t1.FROB=1 Then 1 Else 0 End
From SEOrder t3
Inner Join SEOrderEntry t8 On t8.FInterID = t3.FInterID
Inner Join ICSaleEntry t4 On t3.FInterId=t4.FOrderInterID And t4.FOrderEntryID = t8.FEntryID
Inner Join ICSale t1 On t4.FInterID = t1.FInterID
Inner Join t_MeasureUnit t5 On t5.FMeasureUnitID=t4.FUnitID
Inner Join t_ICItem t10 On t4.Fitemid =t10.Fitemid
Left Join t_OrganizatiOn t11 On t3.FCustID = t11.FItemID
Left Join t_SOnCompany t12 On t3.FRelateBrID = t12.FItemID
Left Join T_Department TD On t3.FDeptID=TD.FItemID
Left Join T_Emp TE On t3.FEmpID=TE.FItemID
Where t3.FSaleStyle=20296 And t3.FDate>='2007-04-01' And t3.FDate
Select * From #T138_1

Create Table #T138
(FCompanyName Varchar(355),
FInterID Int Null,
FTranType SmallInt Null,
FItemID Int Null,
FEntryID Int Null,
FOrderBillNo Varchar(355) Null,
FDate DateTime Null,
FSendDate DateTime Null,
FShortCustNumber Varchar(355) Null,
FCustName Varchar(355) Null,
FCustNumber Varchar(355) Null,
FNumber Varchar(355) Null,
FShortNumber Varchar(355) Null,
FName Varchar(355) Null,
FQtyDecimal SmallInt Null,
FPriceDecimal SmallInt Null,
FModel Varchar(355) Null,
FUnitName Varchar(355) Null,
FCUUnitName Varchar(355) Null,
FCoefficient Float Null,
FSaleQty Float Null,
FAmount Float Null, ----- 金额
FPrice Float Null, ----- 单价
FDeptName Varchar(355) Null,
FEmpName Varchar(355) Null,
FSumSort SmallInt not Null default 0,
FNote Varchar(255) Null,FAuxPropName Varchar(255))
Insert Into #T138
(FCompanyName,FInterID,FTranType,FDate,FSendDate,FOrderBillNo,FItemID,FEntryID,
FCustName,FShortCustNumber,FCustNumber,FNumber,FShortNumber,FName,FQtyDecimal,
FPriceDecimal, FModel,FUnitName,FCUUnitName,FCoefficient,FSaleQty,FAmount,FPrice,FDeptName,FEmpName,FNote,FAuxPropName)
Select t12.FName,u1.FInterID,u1.FTranType,u1.FDate,v1.FDate,u1.FBillNo,v1.FItemID,
v1.FEntryID,t2.FName,t2.FShortNumber,t2.FNumber,t1.FNumber,t1.FShortNumber,t1.FName,
t1.FQtyDecimal,t1.FPriceDecimal,t1.FModel, (Select FName From T_MeasureUnit Where T_MeasureUnit.FMeasureUnitid In (Select T_MeasureUnit.FMeasureUnitID From T_MeasureUnit Where T_MeasureUnit.FUnitGroupId In ( Select T_MeasureUnit.FUnitGroupID From T_MeasureUnit Where T_MeasureUnit.FMeasureUnitID In (Select v1.FUnitID )) And FStandard =1)) As FUnitName ,t5.FName,t5.FCoefficient,
v1.FQty, v1.FAmount,v1.FPrice, t3.FName, t4.FName, v1.FNote,tt.FName
From SEOrder u1
Inner Join SEOrderEntry v1 On u1.FBrNo=v1.FBrNo And u1.FInterID=v1.FInterID
Inner Join t_ICItem t1 On v1.FItemID=t1.FItemID
Left Join t_OrganizatiOn t2 On u1.FCustID=t2.FItemID
Left Join t_Department t3 On u1.FDeptID=t3.FItemID
Left Join t_Emp t4 On u1.FEmpID=t4.FItemID
Left Join t_MeasureUnit t5 On t1.FSaleUnitID = t5.FMeasureUnitID
Left Join t_AuxItem tt On v1.FAuxPropID = tt.FItemID
Left Join t_SOnCompany t12 On u1.FRelateBrID =t12.FItemID
Where 1=1 And u1.FDate>='2007-04-01' And u1.FDate0 And u1.FCancelLatiOn=0

Order By u1.FDate,u1.FInterID,v1.FItemID,tt.FName
Select * From #T138 t1
Drop Table #T138_1
Drop Table #T138
Set ANSI_Warnings On