Menu access
Maintenance - Profile
After choosing the Partner, Version, and Transaction set
the appropriate map will be displayed as in the above screen sample. The File
Folders 
at the top
level in the tree represent segments, those at the next level are the elements.
The program icon 
underneath the element represents a mapped field. Clicking on a mapped field
will yield this screen:
The above screen illustrates a mapped incoming or inbound element to the database field tt-pedvenda.cod-estabel. The next screen illustrates a relationship for an outbound element.
This field, once created in the outbound file, will contain the character string "credit #". The tables below explain the contents of each field.
| Field | Description |
| Misc | Enter any miscellaneous information about this data element. |
| Line-no | Enter the line number to use when entering segment information. When EDI
data is generated, the system will process information by line number. If you are setting
up information in order to process the 850 transaction set (i.e. purchase orders) with the
Receive EDI Data function, the line number must be between 1 and 49 to process quote and
quote-line information, and between 50 and 99 to process order and order-line information. To delete a line number enter the line number followed by CTRL-D or the equivalent function key. |
| Incoming | |
| File name | Enter the file name to use to assign data to when data from an incoming transaction set is processed, or leave blank if the data element is not to be saved in the database. The file name entered is validated against the dictionary. |
| Field name | Enter the field name to use to assign data to when data from an incoming transaction set is processed, or leave blank if the data element is not to be saved in the database. The field name entered is validated against the dictionary. |
| Array element | Enter the array element to use when data from an incoming transaction set is processed. If the field name entered is an array field, then entering 0 in this field will cause the system to assign the data to the next array element available. If the field name entered is not an array field, then this field will automatically be set to 0. |
| Add/assign value | Enter "yes" if you want to add the value from the incoming transaction set to the database field specified, or "no" to set the database field to value specified in the incoming transaction set.This field is only used if the database field to assign the value to is either an integer, decimal or character field. Otherwise, the value is assigned to the database field specified. |
| Translation table | Enter the name of the translation table to use when incoming transaction sets are processed. If a translation table code is entered, the system will translate the data element to the value in the translation table. |
| Qualifier | Enter the qualifier to use to indicate to the system that the following data element is to be assigned to a particular data base field. The qualifier entered must exist in the EDI qualifier dictionary.If qualifier "*DE*" is entered, then the qualifier's description will be added to the following data element if that data element is assigned to a data base field. |
| Countries | Enter the countries that are allowed to use the element or "*" for all countries. If multiple countries are specified, then they must be separated by commas. |
| Outgoing | |
| Translation Table | Enter the name of the translation table to use when outgoing transaction sets are processed. If a translation table code is entered, the system will translate the data element to the value in the translation table. |
| Qualifier | Enter the qualifier to use when generating EDI data for this position in a segment. The qualifier entered must exist in the EDI qualifier dictionary. |
| Countries | Enter the countries that are allowed to use the element or "*" for all countries. If multiple countries are specified, then they must be separated by commas. |
| Field | Description | ||||||||||||||
| Incoming | |||||||||||||||
| Formula | Enter a formula to be used to extract information from a data element when inbound transaction sets are processed. Any PROGRESS function can be used. In addition, you can use any EDI keyword or function keyword, as well as the special keywords |CURRELEM|, implying the data element being processed, and |ELEMENT|[n] (where n = the element number on the current line [element numbers start at the segment identifier]), which refers to the data elements in a given segment line. The inbound formula must return a character value. | ||||||||||||||
| Outgoing | |||||||||||||||
| Return Value | Enter the value to return for an outbound formula. The following values
can be specified for an outbound formula: integer, decimal, recid, character, date, or logical You may type an abbreviated return value or the complete return value. Using abbreviated return values reduces typing when entering EDI formulas. When you type in an abbreviated value, and you have finished the "Segment Override Maintenance - Formulas" frame, the long form will replace the abbreviated value in the system. The table below indicates upper-case abbreviated values for clarity, but you may enter the abbreviated value in upper or lower case. Valid abbreviated return values are:
|
||||||||||||||
| Formula | Enter a formula to be used to assign a value to a data element when EDI
data is generated. Any PROGRESS function can be used. In addition, you can add or subtract
the values of database fields or constants. Any references to database files must be
specified by EDI keywords enclosed in EDI brackets (e.g. |PO-NO|). The special keyword, |LEVEL|, is used to generate specific values for a formula, based on which level a segment sequence number is processed. To use a calculated value in a formula (i.e. a variable), enter the variable name between EDI brackets, preceded by VC: for a character variable (e.g. |VC:CHAR-VAR|), VN: for a numeric variable (e.g. |VN:NUM-VAR|), VD: for a date variable (e.g. |VD:DATE-VAR|), or VL: for a logical variable (e.g. |VL:LOGICAL-VAR|). The PVN:, and QVN: prefixes allow you to perform price and quantity conversions on a numeric variable. The values of the variables must be defined by the program used to generate EDI data. The value that the formula returns must correspond to the "Return value" specified for the outgoing formula. |
Last update October 20, 2006