[ts-gen] cross session orders, client ids
mail at ngebhardt.de
Wed Dec 31 03:04:21 EST 2008
On Tue, 2008-12-30 at 13:41 -0500, pippin at owlriver.net wrote:
> Part way through answering your question, I realized that it probably
> didn't have anything to do with the new mark aka label aka brand aka
> order_ref attribute. The key point was probably the phrase:
> > ... what might be the right candidate for a common key [?]
> In brief, you need to match using (acc, client_id, order_tag)
> triples. Such triples occur in the tables CreateEvent,
> OrderStatus, ActiveOrder, and OrderReport. Records of the first
> reflect commands to, and the other three, messages from, the api.
> These three attributes --- the account code, connection id, and
> order id --- together work to identify a unique order line item.
> Although there are other unique keys for order line items, no
> other unique key tuple is as widely available across the various
> journal tables.
Yes, that helps.
More information about the ts-general