【泛微E9】查询哪些表单使用了客户浏览框

当workflow_billfield表中的fieldhtmltype = 3，type=7时，浏览框为客户

SELECT * FROM workflow_billfield WHERE ID = 7884

-- 查询系统内置浏览框的类型
SELECT * FROM WORKFLOW_BROWSERURL;

-- 查询浏览框的名称
SELECT * FROM HTMLLABELINDEX WHERE ID = 136;

WORKFLOW_BROWSERURL的labelid = HTMLLABELINDEX的id

-- 查询存在客户浏览框的表
SELECT * FROM workflow_billfield
WHERE fieldhtmltype = 3 AND type = 7 and FIELDDBTYPE = 'int' and VIEWTYPE = 0

VIEWTYPE = 0 表示是主表字段
VIEWTYPE = 1 表示是从表字段

-- 已知单据id查询该单据在数据库中的表名
SELECT * FROM WORKFLOW_BILL WHERE ID = '-65'

-- 查询存在客户浏览框的主表数据
SELECT
    wf.id as field_id,
    wf.fieldname AS field_name, 
    wf.BILLID AS billid,
    wb.tablename AS table_name   
FROM
    workflow_billfield wf
INNER JOIN
    WORKFLOW_BILL wb ON wf.billid = wb.ID  
WHERE
    wf.fieldhtmltype = 3  
    AND wf.type = 7          
    AND wf.FIELDDBTYPE = 'int' 
    AND wf.VIEWTYPE = 0;