generate promotion by syscat id