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.