Report definitions

Report metadata from `ZE_ENQ`

1 matching rows out of 142 report definitions.

Key Description Table Selection Join

Key	Description	Table	Selection	Join
`STK_BAL_SUP_IT_CONT`	Stock Balance By Supplier Item Cont	STK_DETS	WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' AND ISNULL(SD_CDATE) AND ISNULL(SM_FINPDTE)	LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL

STK_BAL_SUP_IT_CONT

Stock Balance By Supplier Item Cont

STK_DETS

WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y'  AND ISNULL(SD_CDATE) AND ISNULL(SM_FINPDTE)

LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL

Report metadata from ZE_ENQ