In a previous tip, we detailed how to view the TRADING_PARTNER table from the internal Postgre database to your EBI / Cleo Clarify Server. This data displayed can be very helpful when researching fully-qualified resource names, and their values, which contain every deployed and installed Trading Partner.
For FREE OF CHARGE, we will show users how to configure DB Visualizer, SQL Explorer, to access this database. Contact us to set-up a time to review the process.
The next table we’ll discuss is the NEXT_NUMBER table. Using this table, you can quickly identify last numbers that were generated for Order Numbers, Invoice Numbers, or any other use reasons on why you may be using the Next Number in your integration. This table contains five columns. And they are:
- NN_KEY –
This value will contain the fully-qualified name of the Next Number object. It will display the Project, Package, Next
Number object name, and then the Key
listed inside of the Next Number (in that order). The Key is shown below as it’s listed in our
Next Number used for Amazon.
- NN_VALUE –
This value will be the last value that was populated when used from a Ruleset,
Business Process, or Adapter. This is
the value that is also populated in the Next Number object.
– This value contains the incremented number that will be added to the value
once the Next Number is used. A value of
100 will increment the value by 100 each time.
– This value, if different than 1, can multiple by the NN_BLOCKSIZE to
increment the NN_VALUE. A value of 2 for
the NN_BLOCKNUMBER, and a value of 100 in the NN_BLOCKSIZE will increment the
NN_VALUE by 200.
- NN_DESCRIPTION – This value is the free-form description that can be populated on the Next Number.
Having access to this table allows you quick and easy access to view Next Number names, and their values.
Two different Next Numbers are provided and used internally for processing (1000 and LOG_OF_CONNECTION).
Although the NN_DESCRIPTION is designed to contain the description of the value populated in the Next Number object, it is not obtained during deployment, as shown below..
By: Sean Hoppe on