News

Dumb Things We Saw Today | Ref Field Constraint

Why the constraint?

We work with A LOT of different systems and run into all kinds of crazy stuff. Feel free to email us your Dumb Things We Saw Today.   Here is another gem:

We were working with a vendor energy trading system and inputting an exchange Order ID into an Order ID Ref field.  Kudos to the vendor for having an Order ID Ref field at all.  But there is a constraint on the field that the OID has to be unique.  If you’ve worked with the exchanges then you know that exchanges only guarantee these numbers are unique for a single trade date.