--采购订单“管理税”--税分类
select ZLDF.INPUT_TAX_CLASSIFICATION_CODE--ZL.TAX_RATE_CODE,ZL.TAX_RATE
from po_lines_all POL,
po_line_locations_all PLL,
zx_lines_det_factors ZLDF--zx.zx_lines ZL --R12的税记录在zx_lines
WHERE POL.PO_HEADER_ID = PLL.PO_HEADER_ID
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND ZL.trx_id = POL.po_header_id
AND ZL.TAX_LINE_ID = PLL.line_location_id
采购订单“管理税”--税分类
最新推荐文章于 2023-07-04 20:15:54 发布