EBS: AP应收发票的税分配

 

 

AP应收发票行的税分配明细 

-- AP 发票行税分配
SELECT AI.INVOICE_ID,
       AI.INVOICE_NUM,
       ZRND.TRX_NUMBER "事务处理编号", -- AP发票号
       ZRND.TRX_LINE_NUMBER AS "事务处理行号",
       ZRND.TAX_LINE_NUMBER AS "税行号",
       ZRND.TAX_REGIME_CODE AS "税收制度代码",
       ZRND.TAX AS "税",
       ZRND.ITEM_DIST_NUMBER AS "事务处理分配编号",
       ZRND.RECOVERABLE_FLAG AS "可退回",
       ZRND.FREEZE_FLAG AS "冻结",
       ZRND.RECOVERY_TYPE_CODE AS "退税类型代码",
       ZRND.RECOVERY_RATE_CODE AS "退税率代码",
       ZRND.REC_NREC_RATE AS "退税/不可退税率",
       ZRND.REC_NREC_TAX_AMT AS "退税/不可退税金额",
       ZRND.REVERSE_FLAG AS "冲销",
       ZRND.CREATION_DATE 
      -- ,ZRND.*
  FROM ZX_REC_NREC_DIST ZRND,  -- 税分配 
       AP_INVOICE_DISTRIBUTIONS_ALL AID,  -- AP发票分配
       --AP_INVOICE_LINES_ALL AIL
       AP_INVOICES_ALL AI 
 WHERE ZRND.APPLICATION_ID = 200  -- 200:SQLAP 
  -- AND ZRND.TRX_ID = 3750802 
   AND ZRND.TRX_ID = AID.INVOICE_ID
   AND ZRND.TRX_LINE_DIST_ID = AID.INVOICE_DISTRIBUTION_ID
   AND AID.INVOICE_ID = AI.INVOICE_ID 
   --AND ZRND.TRX_NUMBER = '108220107904-001'  --"事务处理编号", -- AP发票号
   AND AI.INVOICE_NUM =  '108220107904-001'  --"事务处理编号", -- AP发票号
-- INVOICE_DISTRIBUTION_ID= 50711587