Freshmark replication server

freshmark-canonical

Report definitions

Report metadata from ZE_ENQ

3 matching rows out of 142 report definitions.

Key Description Table Selection Join
SALES_TRANS_CONS SALES TRANSACTION LISTING BY CONSIGNMENT STK_TRANS 
WHERE ST_TRTYPE <> 'RE' AND ST_TRTYPE <> 'R' AND ST_TRTYPE <> 'DS' AND (ST_DELIND <> 'Y' AND ST_PAID <> '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 LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND 
SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE
SALES_TRANS_CONS_KIM SALES TRANSACTION LISTING BY CONSIGNMENT KIM STK_TRANS 
WHERE ST_TRTYPE <> 'RE' AND ST_TRTYPE <> 'R' AND ST_TRTYPE <> 'DS' AND ST_PAID = 'Y'
 
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT 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 SUPPLIER_MAST ON SUM_SUPPL = SM_SUPP
SALES_TRANS_CONS_PR SALES TRANSACTION LISTING BY ITEM STK_TRANS 
WHERE ST_TRTYPE IN ('SA', 'DE', 'DT')
 
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