Manage Country NOTC
Explanation
Use this activity to add, modify and delete country NOTC details. It is possible for the users to update the
NOTC description from different languages by changing the default language from the application settings.
The country NOTC records can be imported/ exported through the Migration Job page. However,
following details are required for import/export processes.
Add the new Migration Job with; Exporting
- Procedure Name = CREATE_OUTPUT_FILE
- View Name = COUNTRY_NOTC_LOV
- File Location = On Client
- A column separator
- If the user needs to export the NOTC details for a specific country use the Where Clause in the Database
Information tab (ex. COUNTRY_CODE=’DE’)
- Add the POS in File Mapping tab (ex. 1 for COUNTRY_CODE,2 for NOTC,3 for COUNTRY_NOTC,4 for DESCRIPTION)
- Enable the FILEHEAD in Rules tab
Add the new Migration Job with; Importing
- Procedure Name = INSERT_OR_UPDATE
- View Name = COUNTRY_NOTC
- File Location = On Client
- A column separator
- Add the POS in File Mapping tab (ex. 1 for COUNTRY_CODE,2 for NOTC,3 for COUNTRY_NOTC,4 for DESCRIPTION)
- Enable the SYNCDETAILS in Rules tab
Prerequisites
The Manage Country NOTC window table should retrieve current NOTC details for each country from the basic data
set-up for system events (transactions).
System Effects
As a result of this activity:
- New country NOTC details can be added for a respective country.
- Delete unnecessary country NOTC detail records.
- Update NOTC description based on the language of the application.
- The option "Export/Import Country NOTC" will lead to the migration job window. From there, users
can export the updated records from the country_notc table to a file and also import the up-to-date file to
replace the records in the list.