摘要: --1.发票创建时生成数据如下表--发票主表SELECT * FROM AP_INVOICES_ALL A WHERE A.INVOICE_NUM = '20111213001';--发票分配表SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL B WHERE B.INVOICE_ID = 697444;--发票付款计划表SELECT * FROM AP_PAYMENT_SCHEDULES_ALL C WHERE C.INVOICE_ID = 697444; --From ap_invoices_all.invoice_id--2.发票验证并创 阅读全文
posted @ 2012-02-22 16:36 我不卖豆腐 阅读(11047) 评论(0) 推荐(2) 编辑
摘要: 1. 这个是在EVENT里头的Code:if (event_name = 'WHEN-NEW-FORM-INSTANCE') then --普通菜单 APP_SPECIAL2.INSTANTIATE('SPECIAL30','供应商历史采购cust',NULL,TRUE); APP_SPECIAL2.ENABLE('SPECIAL30',PROPERTY_ON); --begin add by guozhenbin 2009-11-19 ... 阅读全文
posted @ 2012-02-22 10:36 我不卖豆腐 阅读(1732) 评论(0) 推荐(0) 编辑