EDI Map Table

Menu Path: None

To use EDI Map Table, click the New Table button or double-click a line in the EDI map table grid in the EDI Map Table Definition Maintenance window.

Purpose

Create or update an EDI map table.

Use EDI Map Table to create or update EDI map tables for transactions such as 812, 824, 860, and 864 that do not have a standard import process.

Button	Description
Exit	Click this button to close the EDI Map Table window.
OK	Click this button to close the EDI Map Table window and save edits to the EDI Map Table Definition.

Field or Button	Description
Table Name	Enter a table name for the new table that you want to create. NOTE The name must begin with an alphabet, and all the characters used in the name must be either alphanumeric or have special characters such as an underscore (_) or a hyphen (-), as space is not allowed in table names.
Table Label	Enter a label or click the Lookup button to select a label for the table. For example, PO Header, PO Details, and so on.
Description	Enter a description for the table.
Default Area	Select any one of the following options to either link the table to the appropriate EDI raw data level: Blank - Select this option if you want to link the table with an EDI document section manually. This option is selected by default. Header - Select this option to link the table to the EDI document header section. Detail - Select this option to link the table to the EDI document detail section. Summary - Select this option to link the table to the EDI document summary section. For example, if you select Header as the Default Area, the table is mapped to the Header section available in Apprise in EDI Mapper. NOTE The default area can be updated only when the EDI map table definition is not linked to an EDI map.
Can Update Relations	Select this check box to enable the system to update relations between related database fields on EDI map.