[TV_SQL]
综合资料查询管理_销售情况明细表=select * from V_Yw_SaData_Detail where SaState=1 and Sa_Date between date()-1 and date() order by SaMain_Id desc
综合资料查询管理_进货情况明细表=select * from V_Yw_InData_Detail where InState=1 and In_Date between date()-1 and date() order by InMain_Id desc
综合资料查询管理_前台零售情况明细表=select * from V_Yw_PosData where SaState=1 and Sa_Date120 between date()-1 and date() order by PosMain_Id desc
综合资料查询管理_调拨情况明细表=select * from V_Yw_DbData_Detail where DbState=1 and Db_Date between date()-1 and date() order by DbMain_ID desc
综合资料查询管理_收(付)款流水账情况表=select * from V_Yw_PayLog where Yw_Date between date()-1 and date() order by YwMain_Id desc

[ZZ格式文件转换]
综合资料查询管理_今日销售情况明细表=综合资料查询管理_历史销售情况明细表

[显示查询栏]
综合资料查询管理_销售情况明细表=Y
综合资料查询管理_进货情况明细表=Y
综合资料查询管理_前台零售情况明细表=Y
综合资料查询管理_调拨情况明细表=Y
综合资料查询管理_收(付)款流水账情况表=Y

[TV_SQL22]

综合资料查询管理_今日销售情况明细表=select * from V_Yw_PosData where SaState=1 and Sa_Date120=date() order by PosMain_Id desc
综合资料查询管理_昨日销售情况明细表=select * from V_Yw_PosData where SaState=1 and Sa_Date120=date()-1 order by PosMain_Id desc
综合资料查询管理_历史销售情况明细表=select * from V_Yw_PosData where SaState=1 order by PosMain_Id desc
综合资料查询管理_修改单价情况明细表=select * from V_Yw_PosData where SaState=1 and SaPrice<>YsPrice order by PosMain_Id desc

综合资料查询管理_今日销售情况明细表=select * from V_Yw_PosData where SaState=1 and Sa_Date120 between getdate()-1 and getdate() order by PosMain_Id desc
综合资料查询管理_昨日销售情况明细表=select * from V_Yw_PosData where SaState=1 and Sa_Date120 between getdate()-2 and getdate()-1 order by PosMain_Id desc
综合资料查询管理_历史销售情况明细表=select * from V_Yw_PosData where 1=2 
综合资料查询管理_修改单价情况明细表=select * from V_Yw_PosData where SaState=1 and SaPrice<>YsPrice order by PosMain_Id desc
