Report definitions
Report metadata from ZE_ENQ
1 matching rows out of 142 report definitions.
| Key | Description | Table | Selection | Join |
|---|---|---|---|---|
LATE_SALES_TRANS |
LATE SALES TRANSACTIONS LISTING | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_PAID = 'Y' AND ST_DELIND <> 'Y' AND (ST_TRTIME > ST_UPD_TIME AND ST_TRTIME <= '23:59:59') |
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 |