SELECT
	A.DOC_NO AS 单号,
	A.DOC_DATE AS 单据日期,
	e.USER_NAME AS 制单人,
	c.ITEM_CODE AS 品号,
	B.ITEM_DESCRIPTION AS 品名,
	B.ITEM_SPECIFICATION AS 规格,
	--c.ITEM_NAME as 新品名,
	--c.ITEM_SPECIFICATION as 新规格,
	--c.ITEM_DESC as 品号描述,
	d.PROJECT_CODE AS 项目号,
	SUPPLIER_FULL_NAME AS 采购供应商,

ROUND(A.AMOUNT_UNINCLUDE_TAX_BC + A.TAX_BC,2) AS [本币合计],
ROUND(A.AMOUNT_UNINCLUDE_TAX_OC+A.TAX_OC,2) AS [原币合计],
ROUND(A.UNSETTLE_ARR_AMT_UN_TAX_OC + A.UNSETTLE_ARR_TAX_OC ,2) as 未结算已到货原币,
ROUND(A.RECEIPTED_AMT_UN_TAX_OC+A.RECEIPTED_TAX_OC,2) as 需结算已入库原币,
ROUND(A.SETTLEMENT_AMT_UN_TAX_OC+A.SETTLEMENT_TAX_OC,2) as 已结算原币,

CASE 
WHEN A.RECEIPTED_AMT_UN_TAX_OC+A.RECEIPTED_TAX_OC = 0   THEN '还未入库'
WHEN CAST( A.RECEIPTED_AMT_UN_TAX_OC+A.RECEIPTED_TAX_OC  AS INT) - CAST (A.SETTLEMENT_AMT_UN_TAX_OC+A.SETTLEMENT_TAX_OC AS INT) = 0 THEN '已结算完' ELSE '未结算完' 
END AS 结算状态

FROM
	PURCHASE_ORDER A
	LEFT JOIN PURCHASE_ORDER_D B ON A.PURCHASE_ORDER_ID= B.PURCHASE_ORDER_ID
	LEFT JOIN ITEM c ON B.ITEM_ID= c.ITEM_BUSINESS_ID
	LEFT JOIN PROJECT d ON B.PROJECT_ID = d.PROJECT_ID
	LEFT JOIN [USER] e ON A.CreateBy  = e.USER_ID
	LEFT JOIN PURCHASE_ORDER_SD  F on B.PURCHASE_ORDER_D_ID= F.PURCHASE_ORDER_D_ID
where c.ITEM_CODE in (select Code from ITEMUP1) 
--where A.DOC_NO = '3500-202403130008'---and c.ITEM_DESC <> ''
order by A.DOC_DATE desc