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.

Overview

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.

Ribbon Home Tab Buttons

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.

Main Tab Fields and Buttons

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.