[{"branch":"0","branchmc":"standard","button":"[]","catalog":"medicalCard","chart":"[]","code":"ComprehensiveSettlementDetailsTwo","column":"[{\"filter_name\":\"GJBM00\",\"hidden\":false,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"国家编码\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":0,\"ora_name\":\"GJBM00\",\"field\":\"GJBM00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_132\",\"render\":\"\",\"key\":\"GJBM00\"},{\"filter_name\":\"XMMC00\",\"hidden\":false,\"LAY_TABLE_INDEX\":1,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"项目名称\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":1,\"ora_name\":\"XMMC00\",\"field\":\"XMMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_133\",\"render\":\"\",\"key\":\"XMMC00\"},{\"filter_name\":\"XMGG00\",\"hidden\":false,\"LAY_TABLE_INDEX\":2,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"规格\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":2,\"ora_name\":\"XMGG00\",\"field\":\"XMGG00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_134\",\"render\":\"\",\"key\":\"XMGG00\"},{\"filter_name\":\"XMSL00\",\"hidden\":false,\"LAY_TABLE_INDEX\":3,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"数量\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":3,\"ora_name\":\"XMSL00\",\"field\":\"XMSL00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_135\",\"render\":\"\",\"key\":\"XMSL00\"},{\"filter_name\":\"XMDJ00\",\"hidden\":false,\"LAY_TABLE_INDEX\":4,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"单价\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":4,\"ora_name\":\"XMDJ00\",\"field\":\"XMDJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_136\",\"render\":\"\",\"key\":\"XMDJ00\"},{\"filter_name\":\"HJJE00\",\"hidden\":false,\"LAY_TABLE_INDEX\":5,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"金额\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":5,\"ora_name\":\"HJJE00\",\"field\":\"HJJE00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_137\",\"render\":\"\",\"key\":\"HJJE00\"},{\"filter_name\":\"XMDW00\",\"hidden\":false,\"LAY_TABLE_INDEX\":6,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"单位\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":6,\"ora_name\":\"XMDW00\",\"field\":\"XMDW00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_138\",\"render\":\"\",\"key\":\"XMDW00\"},{\"filter_name\":\"ZFBL00\",\"hidden\":false,\"LAY_TABLE_INDEX\":7,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"自付比例\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":7,\"ora_name\":\"ZFBL00\",\"field\":\"ZFBL00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_139\",\"render\":\"\",\"key\":\"ZFBL00\"},{\"filter_name\":\"FYRQSJ\",\"hidden\":false,\"LAY_TABLE_INDEX\":8,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"费用发生时间\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":8,\"ora_name\":\"FYRQSJ\",\"field\":\"FYRQSJ\",\"sortType\":\"asc\",\"width\":\"120\",\"fixed\":\"\",\"_VCUID\":\"row_140\",\"render\":\"\",\"key\":\"FYRQSJ\"},{\"filter_name\":\"KFYXM0\",\"hidden\":false,\"LAY_TABLE_INDEX\":9,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"扣费员\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":9,\"ora_name\":\"KFYXM0\",\"field\":\"KFYXM0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_141\",\"render\":\"\",\"key\":\"KFYXM0\"},{\"filter_name\":\"KDKSMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":10,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"开单科室\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":10,\"ora_name\":\"KDKSMC\",\"field\":\"KDKSMC\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_142\",\"render\":\"\",\"key\":\"KDKSMC\"},{\"filter_name\":\"KFKSMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"扣费科室\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":11,\"ora_name\":\"KFKSMC\",\"field\":\"KFKSMC\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_143\",\"render\":\"\",\"key\":\"KFKSMC\"},{\"filter_name\":\"ZXKSMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":12,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"执行科室\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":12,\"ora_name\":\"ZXKSMC\",\"field\":\"ZXKSMC\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_144\",\"render\":\"\",\"key\":\"ZXKSMC\"},{\"filter_name\":\"FPXMMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":13,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"发票项目\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":13,\"ora_name\":\"FPXMMC\",\"field\":\"FPXMMC\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_145\",\"render\":\"\",\"key\":\"FPXMMC\"}]","condition":"[]","countSql":"select count(1) as total,count(C.XMMC00) GJBM00,sum(C.HJJE00*b.bz0000) HJJE00\n  from SF_JZB000 A, SF_JZMXXM B, SF_FYMX00 C, BM_FPXM00 d\n where A.JZDH00 = B.JZDH00\n   and B.MXID00 = C.MXID00\n   and c.MZFPID = d.FPXMID\n   and A.JZDH00 = '${JZDH00}'","createTime":1592819002000,"entityVersion":0,"id":"ComprehensiveSettlementDetailsTwo","isLaypage":"0","module":"mzsf","name":"ComprehensiveSettlementDetailsTwo","pageSql":"select C.GJBM00, C.XMMC00, C.XMGG00, C.XMSL00*b.bz0000, C.XMDJ00, C.HJJE00*b.bz0000, C.XMDW00, C.ZFBL00,\n       TO_CHAR(TO_DATE(C.CZRQ00 || C.CZSJ00, 'YYYYMMDDHH24:MI:SS'),'YYYY-MM-DD HH24:MI') as FYRQSJ, \n       C.CZYXM0 as KFYXM0,\n       (select BMMC00 from BM_BMBM00 where BMBH00 = C.KDKS00 and ROWNUM = 1) as KDKSMC,\n       (select BMMC00 from BM_BMBM00 where BMBH00 = C.CZYKS0 and ROWNUM = 1) as KFKSMC,\n       (select BMMC00 from BM_BMBM00 where BMBH00 = C.ZXKS00 and ROWNUM = 1) as ZXKSMC,\n       d.XMMC00 as FPXMMC,C.xmdj00,C.xmsl00,C.hjje00\n  from SF_JZB000 A, SF_JZMXXM B, SF_FYMX00 C, BM_FPXM00 d\n where A.JZDH00 = B.JZDH00\n   and B.MXID00 = C.MXID00\n   and c.MZFPID = d.FPXMID\n   and A.JZDH00 = '${JZDH00}'\n   order by d.bh0000,c.gjbm00","procedureCommit":0,"procedureParameter":"[]","remark":"门诊病人综合查询-结算明细二","system":"his","updateTime":1726194825000,"version":1}]