随笔分类 -  ERP-AR AP FIN

摘要:--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-29 10:06 江南一陈风 阅读(838) 评论(0) 推荐(0)