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.
Create or update a field in a custom EDI map table.
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.
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. |
Field or Button |
Description |
This field displays the selected table name. |
|
Enter a field name. |
|
Enter a field label or click the Lookup button to select a field label. |
|
Enter a description for the field. |
|
Select any one of the following predefined system values that you want to associate with the field name:
The system value field defaults to blank when creating a new field. |
|
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. |
|
Enter or click the Lookup button to select the data type such as Character, Date, Decimal, Integer, or Logical from the drop-down. |
|
Click the Lookup button to select any one of the following cross-reference types that you want to associate with the custom field:
This helps the system convert the partner code to Apprise code. |
|
Select this check box if you want to create an array for the field, that is, multiple similar fields. |
|
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. |