select top 1 cdr_recordid from tbl_cdr_distributors with (nolock) where fsl_dstid = and ownerid = and fsl_tablecode = 'mfr' and crmactive = 'y' order by fsl_mappriority

View: checked /> SKU checked /> Category checked /> Voids

Scope: checked /> Direct checked /> #_rdaDistName# checked /> Both

Order: checked /> Volume Hi-Lo checked /> Volume Lo-Hi

Go