Skip to main content
In Out
Search
Search ONESOURCE Global Trade LatAm Help and Support.

This article applies to:

  • Product: ONESOURCE Global Trade
  • Sub-Product: in-out

How to add and manage systems in In Out?

In order for In Out to allow the communication of ONESOURCE™ Global Trade products with other systems, the data from these systems must be registered in In Out.

Adding a system

  1. Access the menu
    Registration > Systems
    .
  2. Click
    Add
    .
  3. According to the definitions, complete the fields on the
    Create Systems to Use
     screen:
    * Required fields
    • ID
      *: Alphanumeric system identification code.
      • Example
        : IS
    • Description
      *: brief definition of the system that will be used.
      • Example
        : Import
    • Oracle User:
       User name of the system database to be used.
      • Example
        : TRISNEXTUSER1
    • Macro Key Replacement
      : Macro that replaces the
      Oracle User
      .
      • Example
        : #IMPORT_USER#
    • Password
      :
      Oracle User
       password to access the database.
    • Macro Key Repl.
      : Macro that replaces
      Password
      .
      • Example
        : #IMPORT_PASS#
    • Procedure
      : Set of commands that are executed in the database with the function of validating data imports, regardless of how the interface is processed (automatic or manual).
    • Procedure Update
      : Set of commands that are executed in the database each time a user modifies the content of an interface line manually (via the
      Data Import Errors
       screen). Thus, whenever a user changes the line of an interface, the update procedures of all registered systems are executed, generating a record with the line ID, table name and user ID that made the change.
  4. Click
    Save
    .

Editing a system's data

  1. Access the menu
    Registration > Systems
    .
  2. On the
    Filter Systems to Use
     screen, click the
    Edit
     button for the
    system
    whose data you want to change.
    To view or delete a system record, click the
    View
     and
    Delete
     buttons, respectively. In case of deletion, all data import and export references related to this system will also be deleted.
  3. On the edit screen, make the necessary changes.
  4. Click
    Save
    .

Exporting a system description

  1. Access the menu
    Registration > Systems
    .
  2. On the
    Filter Systems to Use
     screen, select the systems whose
    descriptions
    you want to export.
    To export data from all rows in the table, this marking is not required.
  3. Click
    Export
    .
  4. An Excel file will be generated with the
    descriptions
    of the desired systems, for example:

Related Content