Freshmark replication server

freshmark-canonical

Report definitions

Report metadata from ZE_ENQ

10 matching rows out of 142 report definitions.

Key Description Table Selection Join
DAILY_STATS DAILY STATS STK_TRANS 
WHERE ST_TRTYPE = 'SA' AND ST_DELIND <> 'Y'
 
INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE
DAILY_STATS_COMBO DAILY STATISTICS FOR COMBINED POTS, TOMS OR ONIONS STK_DETS 
WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA'
 
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE
DAILY_STATS_GRADE DAILY STATISTICS BY GRADE STK_DETS 
WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' AND ST_DELIND = 'N'
 
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE INNER JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE
DAILY_STATS_NEW DAILY STATISTICS BY ITEM NEW STK_TRANS 
WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' AND ST_DELIND = 'N'
 
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE
DAILY_STATS_REPORT DAILY STATISTICS BY ITEM STK_DETS 
WHERE ST_TRTYPE ='SA' AND ST_DELIND <> 'Y' AND ST_PAID = 'Y'
 
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE INNER JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE
DAIL_STATS_CONT DAILY STATISTICS BY ITEM AND CONTAINER STK_DETS 
WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA'
 
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE
DAIL_STATS_SECTION DAILY STATISTICS BY SECTION STK_DETS 
WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA'
 
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE
MONTHLY_STATS DAILY STATISTICS BY ITEM STK_DETS 
WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' AND ST_DELIND = 'N'
 
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE
STATS STATS STK_TRANS 
WHERE ST_TRTYPE = 'SA' AND ST_DELIND <> 'Y'
 
INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE
TOMATOE_STATS TOMATO LISTINGS STK_DETS 
WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' AND SD_ITEM LIKE 'TO%'

LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE