DSS Blog Creating a document number in GERS

GERS document numbers follow the format MMDDYSSXXXX where MMDDY is the date, SS is a two-digit store code, and XXXX is a four-character alpha sequence. The four-character alpha sequence is derived from the Oracle sequence MISC.SEQ_DOC_NUM. Oracle sequences return integers, ... Continue reading →