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.