视图备份

视图备份

CREATE OR REPLACE VIEW V_GL_VOU_DETAIL AS
SELECT D."VOU_NO",D."CO_CODE",D."ACCOUNT_ID",D."FISCAL",D."VOU_SEQ",D."REF",D."DESCPT",D."ACC_CODE",D."DR_CR",D."STAD_AMT",D."FIS_PERD",D."VOU_DESC",D."STATUS",D."IS_PREPOSTED",D."OPPO_ACC_CODE",D."VOU_DATE",D."BILL_DATE",D."GUID",D."MODIFYTIME",D."VOU_KIND",D."PRE_CHECK",D."CHECK_NOTES",D."BILL_TYPE",D."BILL_NO",D."RELATION_FLAG",
A.ACC_ITEM1,
A.ACC_ITEM2,
A.ACC_ITEM3,
A.ACC_ITEM4,
A.ACC_ITEM5,
A.ACC_ITEM6,
A.ACC_ITEM7,
A.ACC_ITEM8,
A.ACC_ITEM9,
A.ACC_ITEM10,
A.ACC_ITEM11,
A.ACC_ITEM12,
A.ACC_ITEM13,
A.ACC_ITEM14,
A.ACC_ITEM15,
A.ACC_ITEM16, 
A.ACC_NAME,
A.ACC_NAME1,
A.ACC_TYPE,
A.IS_CASH_ACC,
A.UOM,
A.IS_QTY,
A.IS_CURR,
A.IS_COMP,
A.IS_BUDGET,
A.IS_ITEM,
A.IS_CASHFLOW,
A.IS_OUTLAYTYPE,
A.IS_FA_ACC,
A.DEFAULT_CURR,
A.GL_KJTX
FROM GL_VOU_DETAIL D, GL_COA_ACC A
WHERE A.CO_CODE(+) = D.CO_CODE
AND A.ACCOUNT_ID(+) = D.ACCOUNT_ID
AND A.FISCAL(+) = D.FISCAL
AND A.ACC_CODE(+) = D.ACC_CODE;

posted on 2016-11-21 15:56 沪深狙击手 阅读( ...) 评论( ...) 编辑 收藏