The Sequence_Number table contains the sequence number that the Data Integration Service applies to each customer order. The Sequence_Number table is in an Oracle database. The sequence number becomes the company order number in the logical data object.

Configure the following properties in the SQL transformation views:

Advanced Properties. Configure the database type. The column datatypes depend on what database type you choose.
Ports. Define the pass-through ports and the output port that receives the order number from the Sequence_Number table.
SQL. Define the SQL query to retrieve the sequence number and to increment the number in the database table.
Runtime. Choose a connection to the database that contains the sequence numbers.