EDI Map Table Definition Maintenance

Menu Path: Electronic Data Interchange $Images\bluerarw.gif$ Module Setup $Images\bluerarw.gif$ EDI Map Table Definition Maintenance

Purpose

View, create, update, copy, delete, import, and export map table definitions for EDI inbound transactions.

Overview

Map table definition is a group of map tables used for a particular combination of EDI standard and transaction. Map tables are the table and field definitions used as the basis for EDI mapping. In Apprise, map table definitions are of the following types:

Standard map table definitions - For EDI transactions such as 850 and 875 that have standard import process, Apprise has standard map table definitions associated with them. In this window, you cannot update any existing map tables or fields or create any custom map table definitions for them. You can only update Description and Custom Report Form Name for standard map table definitions.
Custom map table definitions - For each of the EDI transactions such as 812, 824, 860, and 864 that do not have standard import process, Apprise has a predefined map table definition. You can either create maps based on these predefined map table definitions or create custom map table definitions.

NOTE For a specific EDI transaction, only one map table definition can be marked as active. Also, an EDI map must be created for an active map table definition.

NOTE For detailed information on how to use EDI Map to Crystal Report, see Using EDI Map to Crystal Report.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the EDI Map Table Definition Maintenance window.
New	Click this button to create a new EDI map table definition.
Update	Click this button to update the selected EDI map table definition.
Copy	Click this button to create a new EDI map table definition from an existing one, and then make changes to it.
Delete	Click this button to delete the selected EDI map table definition. NOTE You can not delete the EDI map table definition if it: is a standard EDI map table definition. is a predefined custom EDI map table definition. has an EDI map linked to it.
Import	Click this button to import a .xml file to create a map table definition. Note Only custom map table definitions can be imported.
Export	Click this button to export the selected EDI map table definition to a .xml file.
Output Access Database File	Click this button to output a blank .mdb file to the output directory specified on the Print Options tab. NOTE The value specified in the Output Directory field defaults to the value defined in the Report Working Directory field in User Profile Maintenance.
First	Click this button to display the first EDI map table definition.
Prev	Click this button to display the previous EDI map table definition.
Next	Click this button to display the next EDI map table definition.
Last	Click this button to display the last EDI map table definition.
OK	Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
Cancel	Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
New Table	Click this button to display EDI Map Table, which allows you to create a new table for the selected transaction. This button is only available when you click the New, Update, or Copy ribbon button. NOTE You can create new tables only for custom map table definitions.
New Field	Select an EDI map table and then click this button to display EDI Map Table Field which allows you to create a new field for the selected EDI map table. This button is only available when you click the New, Update, or Copy ribbon button. NOTE You can create new fields only for custom map table definitions.
Remove Table	Select one or more EDI map tables that you want to remove, and then click this button to remove the tables and their fields. This button is only available when you click the New, Update, or Copy ribbon button and only when the EDI map table definition is not linked to any EDI map. NOTE You can remove tables only for custom map table definitions.
Remove Field	Select one or more EDI map table fields that you want to remove, and then click this button to remove the table fields. This button is only available when you click the New, Update, or Copy ribbon button and only when the EDI map table definition is not linked to any EDI map. NOTE You can remove fields only for custom map table definitions.

Fields and Buttons

Field or Button

Description

Map Table Definition

Enter a name for the map table definition that you want to create or click the Lookup button to select a map table definition that you want to update, copy, delete, or export.

NOTE The map table definition name must be unique.

Active

Select this check box if you want to make the map active in the system. This check box is selected by default. Only if the map table definition is active, you can create an EDI map in EDI Mapper.

NOTE You can only have one active EDI map table definition for a transaction.

Main Tab Fields and Buttons

Field or Button	Description
Standard	Enter an EDI map standard, or click the Lookup button to select a standard.
Transaction	Enter an EDI transaction, or click the Lookup button to select an EDI transaction.
Description	Enter a description for the EDI map table definition.
Custom Report Form Name	Enter a name for the custom report form or click the Lookup button to select a custom report form name.
EDI Map Table	This grid displays the EDI map table details. For more information about these fields, see EDI Map Table.
EDI Map Table Field	This grid displays the EDI map table field details. For more information about these fields, see EDI Map Table Field.

Print Options Tab Fields and Buttons

Field or Button	Description
Output Option	The output option is selected as File by default; rest of the options are disabled in this window.
Output File Type	The output file type is selected as Access by default; rest of the options are disabled in this window.
Specify File Name	Select this check box to specify the file name of the output report. This check box is only available if you select the File radio button.
Output Directory	Enter the location for the output report, or click the Lookup button to navigate to and select a location. This field is only available if the Specify File Name check box is cleared.
Output File Name	Enter a location and file name for the output report, or click the Lookup button to navigate to and select a location and file name. The file extension of the file name should match the selected output file type. This field is only available if you select the Specify File Name check box.
Print Full Heading on All Pages	Select this check box to include the entire heading from the first page of the report on all pages of the report. This check box is cleared by default, and only enabled if you select the Screen, File, Printer, or Email radio button.
Print Title Line on All Pages	Select this check box to include the report title, page number, and printed date/time on all pages of the report. This check box is selected by default and only enabled if you select the Screen, File, Printer, or Email radio button, and if the Print Full Heading on All Pages check box is cleared.
Report Language 1	Enter the first language for the report, or click the Lookup button to select a language.
Report Language 2	Enter the second language for the report, or click the Lookup button to select a language. If you enter a language in this field, the report is printed in this language and the language entered in the Report Language 1 field.
Horizontal Shading	Select this check box to include horizontal shading on alternate lines of the report to make it easier to read report data. This check box is cleared by default, and is only enabled if you select the Screen, File, Printer, or Email radio button.
Collate	Select this check box to collate the printed copies of the report (if you are printing multiple copies of the report). This check box is cleared by default, and is only enabled if you select the Printer radio button and enter a value greater than 1 in the Number of Copies field. Example You are printing five copies of a 20 page report to distribute to five different people. Leave this check box selected, so that pages 1-20 of the first copy prints, then pages 1-20 of the second copy, etc. If you clear this check box, five copies of page 1 prints, then five copies of page 2, etc.
Horizontal Shading Color	Click the Lookup button to select the color of horizontal shading on the report. This Lookup button is only enabled if you select the Horizontal Shading check box.
Number of Copies	This field is disabled in this window.
Process	These radio buttons are disabled in this window.
Task Occurs	These radio buttons are disabled in this window.
Time	These fields and radio buttons are disabled in this window.
Date	This field is disabled in this window.
Task Description	This field is disabled in this window.
Scheduling Assistant Queue	This field is disabled in this window.
External Email	This check box is disabled in this window.
Screen Alert	This check box is disabled in this window.
Internal Email	This check box is disabled in this window.