Epicor图层代码数据库中保存位置
图层查询实际执行的存储过程
SQL 全选
declare @p5 bit
set @p5=0
exec [Ice]._ZFW_GenXData_GetList @_UserID=N'manager',@whereClause=N'((( [XXXDefList].[Company] = N''901'' OR [XXXDefList].[Company] = N'''' ) AND [XXXDefList].[ProductID] = N''EP'' AND [XXXDefList].[TypeCode] = N''KNTCCustLayer'') AND ((CGCCode = '''' or CGCCode = ''CN''))) AND (Company = '''' or Company = ''901'' or Company = ''902'' or Company = ''903'' or Company = ''904'')',@pageSize=500,@absolutePage=1,@moreRows=@p5 output
select @p5图层相关的表
SQL 全选
select TypeCode, Key1, Key2, CGCCode,SystemFlag,* from ice.[XXXDef] where ProductID='EP' and TypeCode='KNTCCustLayer' AND key2 = 'Erp.UI.ARInvoiceEntry' AND (CGCCode = '' or CGCCode = 'CN')CGC Code:貌似是和语言相关
版权声明:本文为YES开发框架网发布内容,转载请附上原文出处连接
Epicor 张国生


