CREATE OR REPLACE FORCE EDITIONABLE VIEW "OUTLINK"."TB_JC_SFXM" ("YLJGDM", "XMDM", "XMMC", "QGYLFWXMBM", "QGYLFWXMMC", "SFXZXM", "XMGG", "SFDW", "SFDJ", "SYBZ", "TBSM", "XMNH", "CWNR", "BZSM", "YN_FL_CODE", "SJ_FL_CODE", "SY_FL_CODE", "KJ_FL_CODE", "HS_FL_CODE", "TBRQ", "XGBZ", "YLYL1", "YLYL2") AS 
  select 
BRANCH_CODE YLJGDM,
ID XMDM,
NAME XMMC,
ID QGYLFWXMBM,
NAME QGYLFWXMMC,
0 SFXZXM,
UNIT XMGG,
UNIT SFDW,
PRICE SFDJ,
state SYBZ,
'' TBSM,
'' XMNH,
'' CWNR,
remark BZSM,
CLASSIFY_ID YN_FL_CODE,
CLASSIFY_ID SJ_FL_CODE,
CLASSIFY_ID SY_FL_CODE,
CLASSIFY_ID KJ_FL_CODE,
CLASSIFY_ID HS_FL_CODE,
MODIFY_TIME TBRQ,
0 XGBZ,
'' YLYL1,
'' YLYL2
 from wdhis.acc_dic_fee_item