EDI Map Table Field

Menu Path: None

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

Purpose

Create or update a field in a custom EDI map table.

Overview

Use EDI Map Table Field to create or update a field in a custom EDI map table when creating or updating the custom EDI map table definition in the EDI Map Table Definition Maintenance window.

NOTE You can only update a field when an EDI map is not linked to the map table definition.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the EDI Map Table Field window.
OK	Click this button to close the EDI Map Table Field window and save edits to the EDI map table definition.

Main Tab Fields and Buttons

Field or Button	Description
Table Name	This field displays the selected table name.
Field Name	Enter a field name.
Field Label	Enter a field label or click the Lookup button to select a field label.
Description	Enter a description for the field.
System Value	Select any one of the following predefined system values that you want to associate with the field name: Trade ID - Trading partner's ID Trade ID Name - Trading partner's name Archive Date - Archive date of the EDI activity Archive ID - Archive ID of the EDI activity Archive Time - Archive time of the EDI activity Session ID - The session ID of the EDI processing session The system value field defaults to blank when creating a new field.
Disable on Map	Select this check box to make the field disabled on the EDI map in EDI Mapper. This field is only enabled if the System Value field is blank. If you select one of the predefined system values, this check box is disabled and selected by default.
Data Type	Enter or click the Lookup button to select the data type such as Character, Date, Decimal, Integer, or Logical from the drop-down.
Xref Type	Click the Lookup button to select any one of the following cross-reference types that you want to associate with the custom field: FOB Freight Term Order Entry Additional Charge Order Class Payment Term Return Code Sales Location Shipper Shipping Location Tax Code Unit of Measure This helps the system convert the partner code to Apprise code.
Extent	Select this check box if you want to create an array for the field, that is, multiple similar fields.
Extent Number	Enter a number to define the array, that is, the number of times similar fields must be created. For example, if the Store ID field in PO Detail SDQ table of 850 transaction is marked as Extent, and the Extent Number is 10, then the system creates 10 Store ID fields such as Store ID[1], Store ID[2], and so on until Store ID[10] on 850 EDI maps. This field is enabled only if you select the Extent check box.