Transaction Code Import

Settings > General Ledger > Transaction Codes Imports

Name: The name that will be displayed as the name of the import.

____________________________________________________________________________________________________________

General

Connector type: See import connections for help with setting up a connection to a file to import.

Connection string: See import connections for help with setting up a connection to a file to import.

Command text: See import connections.

Reference columns by: See import connections.

Use schema: In certain situations, the import setup may require a way to name the individual items being imported and/or the type of information (text, decimal, etc.) contained in each column.

____________________________________________________________________________________________________________

Setup

Relative Account: Select the method that the GL account will be identified. Valid choices are:

• Account 
• Alias
• Cross Reference

____________________________________________________________________________________________________________

Columns

From Column: Add lines for each external column you wish to import.  "From Column" is the column name or number on the external file; see “Reference columns by” above. 

To Column: Click on the drop down arrow to select the SGA item that matches what is listed in the From Column. The available columns will vary based on the object type.