Report definitions
Report metadata from ZE_ENQ
2 matching rows out of 142 report definitions.
| Key | Description | Table | Selection | Join |
|---|---|---|---|---|
STK_SHEET_SECT_ITEM |
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_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 SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHEET_SECT_ITEM2 |
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_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 SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |