Report definitions
Report metadata from ZE_ENQ
2 matching rows out of 142 report definitions.
| Key | Description | Table | Selection | Join |
|---|---|---|---|---|
STOCK_BALANCES5 |
STOCK BALANCES BY SUPPLIER NO | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
STOCK_BALANCES5_NEW |
STOCK BALANCES BY SUPPLIER NO | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SM_DDATE = SD_DATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |