/// <summary> ///功能說明:查詢進項憑證折讓 ///傳入值: ///〔@折讓日期起、迄〕 ///〔@供應商代號起、迄〕 ///〔@課稅別〕 ///〔@入帳/折讓日期起、迄〕 ///回傳值: ///請參考WEB UI SPEC說明 ///TABLE: ///A=VDS_VAM_DISCOUNT_MAIN(進項折讓主檔) ///B=VDS_VAM_DISCOUNT_DETL(進項折讓明細檔) ///C= VDS_VAM_DIFF_INVOICE(物料差主檔) ///D=VDS_VAM_DISCOUNT_INV(進項折讓發票檔) /////供應商主檔 ///G= VDS_VDM_VENDOR ///關聯: ///A.DISC_NO = B.DISC_NO=D.DISC_NO ///A.VENDOR=C=VENDOR=G.VENDOR ///查詢原始單據金額金額 ///IF D.SOURCE_TYPE=1 THEN /////廠商驗收 for 查出原進貨單金額 ///B.SOURCE_NO=D.ACCEPT_NO ///查詢欄位:NVL(TAX_REMAIN_AMT, UTAX_REMAIN_AMT) ///ELSE IF B.SOURCE_TYPE=2 /////廠商退貨 for 查出原退貨單金額 ///B.SOURCE_NO=E.RETURN_NO ///查詢欄位:NVL(TAX_REMAIN_AMT, UTAX_REMAIN_AMT) ///ELSE B.SOURCE_TYPE=3 /////物料差單據金額 ///B.SOURCE_NO=C.DIFF_INV_NO ///查詢欄位:C.DIFF_INV_UAMT ///END IF /////查詢條件 ///AND A.KEYIN_DATE BETWEEN NVL(〔@入帳日期起日〕 ///,TO_DATE('19000101','YYYYMMDD')) AND NVL(〔@入帳日期迄日〕 ///,TO_DATE('29991231','YYYYMMDD')) ///AND A.DISC_DATE BETWEEN NVL(〔@折讓日期起日〕,TO_DATE('19000101','YYYYMMDD')) ///AND NVL(〔@折讓日期迄日〕,TO_DATE('29991231','YYYYMMDD')) ///AND A.TAX_TYPE = NVL(〔@課稅別〕,A.TAX_TYPE) ///AND A.VENDOR BETWEEN NVL(〔@供應商代號起,' ') ///AND NVL(〔@供應商代號迄〕,'zzzzzzzzzz') ///GROUP BY A.VENDOR,G.VENDOR_NAME,A.KEYIN_DATE, ///A.DISC_DATE,A.DISC_NO,NVL(A.DISC_UAMT,0) , ///NVL(A.DISC_TAX,0) ,D.INV_NO ///ORDER BY A.VENDOR,A.KEYIN_DATE,A.DISC_DATE,A.DISC_NO; ///說明: ///1.ENABLE 欄為=1才可以被撈出,依照查詢條件回傳資料清單 ///2.建議可以寫一隻DB function查詢進/退貨單原始單據金額。 /// </summary> public DataTable QueryDiscountInvoice(ArrayList ParameterList) { try { DBO.VAM121_DBO dbo = new VAM121_DBO(ref USEDB); return dbo.doQueryDiscountInvoice(ParameterList); } catch (Exception ex) { throw ex; } }