reports

最新推荐文章于 2025-05-09 15:50:55 发布

原创最新推荐文章于 2025-05-09 15:50:55 发布 · 92 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #Office #performance #JDBC

本文介绍了一个用于创建或替换名为 CASH_COUNTER_SUMMARY_REPORT 的强制视图的 SQL 语句。该视图包括多个支付方式的数据汇总，如现金、NETS 或 CDA、现金卡等，并且指定了特定的公司代码和诊所代码。

CREATE OR REPLACE FORCE VIEW "CASH_COUNTER_SUMMARY_REPORT" ("P_DATE", "CASH", "NETS_OR_CDA", "CASHCARD", "CHEQUE", "CREDIT_CARD", "VOUCHER", "IB", "COMPANY_CODE", "CLINIC_CODE", "PAYMENT_MODE", "TOTAL") AS
SELECT To_date('2010-8-8', 'yyyy-mm-dd') as p_Date,'CASH1' as CASH, 'NETS1' as NETS_or_CDA, 'CASHCARD1' as CASHCARD
, 'CHEQUE1' as CHEQUE
, 'CREDIT1' as CREDIT_CARD
, 'VOUCHER1' as VOUCHER
, 'IB1' as IB
, 'A' as company_code
, '5' as clinic_code
, 'CHECK' as payment_mode
,10 as Total
FROM eposdba.ADDRESS_MS