Report definitions
Report metadata from ZE_ENQ
1 matching rows out of 142 report definitions.
| Key | Description | Table | Selection | Join |
|---|---|---|---|---|
AGN_STK_SECT_SUP2 |
AGENT STOCK SHEET BY SECTION AND SUPPLIER | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
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_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |