Generating data base keys

A UCCnetMessageReceive collaboration object generates keys to items in each of the stores.A key is guaranteed to be unique for each item and for each type of command. The key for the item store is saved in the Retail_Item business object internals.correlationID attribute. Do not modify the value of this attribute.

Generating data base keys

Data base table Key
item store
  • For systems with cascaded GLNs: messageHeader.messageIdentifier + notification.sequenceId + internals.cascadedGlns.gln
  • For systems without cascaded GLNs: messageHeader.messageIdentifier + notification.sequenceId
message store
  • For systems with cascaded GLNs: messageHeader.messageIdentifier + notification.sequenceId + internals.cascadedGlns.gln
  • For systems without cascaded GLNs: messageHeader.messageIdentifier + notification.sequenceId
identifier store
  • For systems supporting XSD XML definition: gtin, topic, dataRecipientGLN, dataSourceGLN, targetMarket, uniqueCreatorID attributes of UCCnetGBO_identifier business object
  • For systems supporting DTD XML definition: gtin, version, topic attributes of UCCnetGBO_identifier business object

Entries in the item store and message store can possess identical keys because the stores are different tables within the database.

Parent topic: Using identifier, message, and item stores