1. User Guide
  2. Managing Administration
  3. Managing Card Rate Definition
  4. Adding a Card Rate Definition

5.4.1 Adding a Card Rate Definition

You can navigate to the Card Rate screen by clicking the Upload icon on the Card Rate Definition summary screen.

Figure 5-12 Card Rate Definition Screen


Card Rate Definition Screen

The Card Rate Definition screen displays the following tables:
  • FSI_M_OBJECT_DEFINITION_B
  • FSI_M_OBJECT_DEFINITION_TL
  • FSI_M_CARD_INT_RATE_DETAILS
  • FSI_M_CARD_RATE_INPUT
  • FSI_M_CARD_RATE_DIM_MEMBERS
  • FSI_M_CAR_RATE_DEFN
When you want to upload the Card Rate Definitions, you need to upload the data from an excel sheet in the same order as displayed in the Card Rate Definition screen. After you upload the last excel sheet without any errors, then you can see the updated Card Rate Definition in the Summary screen.

Note:

The current implementation of Price Creation and Discovery application supports only the Comma Separated Values (.CSV) file to upload the product parameters.

Also, note that the uploading order must be same as displayed in the Card Rate Definition screen.

To upload new card rate definition, follow these steps:
  1. Click FSI_M_OBJECT_DEFINITION_B to display the Upload Product Parameters File (CSV or XLXS) screen.

    Figure 5-13 Upload Product Parameters


    Upload Product Parameters

  2. Click Choose File to open the Open window. Select the FSI_M_OBJECT_DEFINITION_B.csv file from your local machine. The screen displays the data from the selected file on the screen. This data is temporary in nature and is not yet uploaded to the FSI_M_OBJECT_DEFINITION_B table.

    Figure 5-14 Upload Product Parameters


    Upload Product Parameters

  3. Click Load Data to upload the data to the FSI_M_OBJECT_DEFINITION_B table. Alternatively, click Cancel to cancel the upload.
  4. Repeat the steps 2 and 3 to upload the data from the CSV files to the following tables:
    • FSI_M_OBJECT_DEFINITION_TL
    • FSI_M_CARD_INT_RATE_DETAILS
    • FSI_M_CARD_RATE_INPUT
    • FSI_M_CARD_RATE_DIM_MEMBERS
    • FSI_M_CAR_RATE_DEFN

    Note:

    The application does not allow you to upload a wrong file for any of the above tables and displays an error message.
  5. Click Close to close the Card Rate Definition screen and go back to the Price Creation and Discovery main screen.