Freshmark replication server

freshmark-canonical

Report definitions

Report metadata from ZE_ENQ

9 matching rows out of 142 report definitions.

Key Description Table Selection Join
STOCK_BALANCES CONSIGNMENT STOCK BALANCES BY CONSIGNMENT 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
STOCK_BALANCES2 STOCK BALANCES BY SECTION AND DELIVERY 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_BALANCES2_NEW STOCK BALANCES BY SECTION AND DELIVERY 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 AND SD_DATE=SM_DDATE
STOCK_BALANCES3 STOCK BALANCES BY DELIVERY NUMBER 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_BALANCES4 STOCK BALANCES BY ITEM 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_BALANCES4_NEW STOCK BALANCES BY ITEM 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 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
STOCK_BALANCES6 STOCK BALANCES BY SUPPLIER NAME 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 LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL