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
`SALES_DELETIONS`	SALES DELETIONS	STK_TRANS	WHERE (ST_TRTYPE = 'DE' OR ST_TRTYPE = 'DT') AND ST_PAID = 'Y' AND ISNULL(ST_CHANGED_PRICE)	INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE

SALES_DELETIONS

SALES DELETIONS

STK_TRANS

WHERE (ST_TRTYPE = 'DE' OR ST_TRTYPE = 'DT') AND ST_PAID = 'Y'  AND ISNULL(ST_CHANGED_PRICE)

INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE

Report metadata from ZE_ENQ

Report metadata from `ZE_ENQ`