| 1234567891011121314151617181920212223242526 |
- 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
|
