4.1 FCIS Interface Maintenance Detail

This topic provides infromation on FCIS interface maintenance details.

The FCIS Interface Maintenance Detail screen helps you locate and retrieve the messages you want to manually generate, from the database.

  1. On Home screen, type UTDIFAC in the text box, and click Next.
    The FCIS Interface Maintenance Detail screen is displayed.

    Figure 4-1 FCIS Interface Maintenance Detail


    Description of Figure 4-1 follows
    Description of "Figure 4-1 FCIS Interface Maintenance Detail"

  2. Specify any or all of the details corresponding to the message you want to retrieve.
    The system uses your specifications to as search criteria to query the database and retrieve the record as specified.
  3. On FCIS Interface Maintenance Detail screen, click New and specify the details.
    For more information on fields, refer to the field description table.

    Table 4-1 FCIS Interface Maintenance Detail - Field Description

    Field Description Attributes
    Interface ID

    Every interface that you define is assigned a unique identification by the system, known as the Interface ID. This ID is generated by the system when you save a new definition, after you have specified all the information that is mandatory for the interface, in this screen.

    When you retrieve an existing interface definition using the Find Screen, the ID of the retrieved interface is displayed in this field.

    		 NA
    Description

    Specify the description of the interface ID.

    Alphanumeric; 255 Characters; Optional
    Import/ Export Type
    Select the type from the drop-down list. The available options are:
    • Import
    • Export

    Mandatory
    Import/ Export Basis
    Select the basis from the drop-down list. The available options are:
    • You can export data from any of the following database object types:
      • Table: You can export the data in all fields from a table, or part of the fields
      • Procedure: You can execute a procedure that will return the data that must be exported. This procedure will populate a table or multiple tables with the data results. You can also execute a procedure on the basis of data populated into the tables.
      • SQL: You can execute a SQL string with an SQL statement that is associated with manipulation of data.
    • You can import data into any of the following database object types:
      • Table: You can import data from an external specified file into an internal table.
      • Procedure: You can import the data from an external file to a temporary internal table, and run a procedure to validate the imported data and populate it into the required internal table.

    You can choose the required option from the drop-down list, according to the type of interface.

    Mandatory
    Interface Code

    Click the Search icon and select the interface code that identifies the sending and receiving systems for the interface from the list.

    The interface code identifies the two components or applications that are on either end of any interface definition. Any interface has a sending system that exports data and a receiving system that receives the exported data as an import.

    For more information on interface codes, refer Table 4-2.

    Alphanumeric; 3 Characters; Mandatory
    Number of Files (Import-Export)

    Specify the number of files that must be imported or exported. For procedure based or table based interfaces, if the number of files is greater than zero, then the names of all the tables that will be impacted by the procedure or SQL string are displayed in the File Specifications Tab.

    Numeric, 2 Characters; Mandatory
    Split Column

    This field captures details of multiple files that are created for unique set of information and can uniquely identify the files.

    This option is available only, if the Segmentation toggle is disbabled.

    Alphanumeric; 50 Characters; Optional
    Subroutine Name

    Specify the name of the back-end procedure to be called by the system during interface execution. It is applicable only if import / export basis is procedure.

    Alphanumeric; 50 Characters; Optional
    Enabled
    Select the option from the drop-down list. The available options are:
    • Yes
    • No

    Select Yes to enable the interface from the drop-down list. An interface that is not enabled cannot be processed, and all jobs and tasks that are associated with the interface are not executed.

    By default, when you define a new interface and save the definition in this screen, the interface is created as an enabled interface.

    When you are editing the record of an interface in this screen, the only editing that is possible is enabling or disabling it, by checking or un-checking this box. All other fields in the screen are locked in Edit Mode.

    Mandatory
    Process per File?

    Select the option to indicate whether the bulk upload file needs to be processed in a sequential manner. The available options are:

    • Yes
    • No

    Optional
    Auto Number? Select the option to indicate whether the system should automatically generate sequence number for bulk import. The sequence number is automatically generated if you select YES.
    The available options are:
    • Yes
    • No

    Optional
    Export Data First?

    Select the option to indicate whether the data needs to be exported.

    The available options are:
    • Yes
    • No

    Optional
    Segmentation?

    In cases where the information is spread over several files, select Yes from the drop-down list to upload all the files.

    The available options are:
    • Yes
    • No

    Optional
    Auto Import Keystring?
    Select if keystring has to be auto imported or not from the drop-down list. The available options are:
    • Yes
    • No

    All import and export tables have a key string column. The interface system imports the files into these tables with a specific key string. The import wrapper will pick up the records with the same key string and process them. This improves the multi user capability of interface system and also allows us to reuse the same header and trailer tables for most of the imports and exports.

    Optional
    File Specification Required?

    Select if you wish to indicate that file specifications are required.

    The available options are:
    • Yes
    • No

    Optional
    Generate Empty File

    Select if empty file has to be generated or not from the drop-down list.

    The available options are:
    • Yes
    • No

    Optional
    Interface Parameters Procedure-based interfaces will need certain parameters that you must specify for their execution. NA
    Parameter Name

    Select the name of the parameter that is required for the procedure, from the drop-down list. You can specify as many parameters as are necessary.

    Alphanumeric, 50 Characters; Mandatory
    Parameter Value

    Specify the value for the same in this field, If you have selected a non-standard parameter.

    Alphanumeric, 50 Characters; Optional
    Standard

    Specify the standard specific to the FCIS application. You need not specify a value for standard parameters.

    Numeric, 1 Character; Mandatory

    Table 4-2 Interface Codes

    Interface Code Sending System Receiving System
    I2F FLEXCUBE-Investor Services Operating System
    C2I FLEXCUBE-Securities FLEXCUBE-Investor Services
    I2C FLEXCUBE-Investor Services FLEXCUBE-Securities
    F2I Operating System FLEXCUBE-Investor Services
    I2I FLEXCUBE-Investor Services FLEXCUBE-Investor Services
  4. Click on File Specification button and specify the fields.
    The File Specification screen screen displays.
    Every interface involves a data exchange that could be of any of the following types:
    • One which involves file exports or imports
    • One which does not involve file exports or imports (i.e from an external table to an internal table)

    For a data exchange that involves no file exports or imports, the Number of Files will be zero, and the file specification tab is not applicable for such exchanges. For exchanges that are procedure-based or SQL-based, and involve file exports or imports, the Number of Files is more than zero, and all tables in the FCIS system that are associated with the specified procedure or SQL string are displayed in the File Specifications screen, with each file having a serial File Number. You can edit any details (except the File Number) or add new tables.

    Figure 4-2 File Specification
    Description of fcis-interface-maitenance-detail_1.png follows
    Description of the illustration fcis-interface-maitenance-detail_1.png

    For more information on fields, refer to the field description table.

    Table 4-3 File Specification - Field Description

    Field Description Attributes
    File Number

    Specify the serial number for the file that is involved in the data exchange. When you add a new file or table name, it is given a new sequential file number.

    Numeric; 3 Characters; Mandatory
    No of Segments

    Specify the number of segments to be uploaded.

    Numeric; 2 Characters; Optional
    Segment Identifier
    Select the value associated with the segment identifier to be uploaded from the drop-down list. The available options are:
    • Field Value
    • Delimited

    Optional
    Field Occurrence
    elect the field corresponding to the segment identifier to be uploaded from the drop-down list. The available options are:
    • First Field
    • Last Field

    Optional
    Field Length

    Specify the length of the field to be uploaded.

    Numeric; 2 Characters; Optional
    Field Type
    Select the type of the field from the drop-down list. The available options are:
    • String
    • Number

    Optional
    Segment Delimiter
    Segment delimiter is used only for interface with segments. Select the delimiter to be used for the different segments from the drop-down list. The available options are:
    • Comma
    • Colon
    • Semi Colon
    • Space
    • Tab
    • Null String

    Optional
    Delimited Occurrence

    Specify the delimited occurrences.

    Alphanumeric, 255 Characters; Optional
    Table Name

    Specify the name of the table associated with the specified procedure that will receive imported data or contain the data that is to be exported

    The value mentioned here must correspond to a valid database table. You can use the option list to specify a new table name.

    Alphanumeric, 30 Characters; Mandatory
    Criteria

    Specify a clause that filters the data that is being exported or imported. For example, you can specify an SQL statement such as a Where clause here. The clause will look for and pick up all data that satisfies the Where clause, in the data that is being exported or imported.

    Alphanumeric, 255 Characters; Optional
    File Name

    The system displays the name of the file for the selected file ID.

    Specify the name of the file that will be involved in the data exchange.
    • Import - For example, if the specified file name is nav.xls, and unique file name is Yes, only the file nav.xls will be picked up. If not, all files that bear the name nav*.* will be picked up.
    • Export - File name generation will be based on the mask value given in the File name of the interface definition.

    This field is enabled if you have selected Unique File Name field is selected as No.

    For more information on mask values, refer Table 4-4.

    Maximum length of the file name will be limited to 100 characters without the extension. If file name length exceeds more than 100, then the system will consider the first 100 characters of file name from the left.

    Alphanumeric, 255 Characters; Mandatory
    File Path

    Specify the path in which the specified file will be found. Click the button alongside this field to browse to the desired location.

    Alphanumeric, 255 Characters; Mandatory
    Archive Directory

    Specify a location where the specified file may be stored or archived for future reference, after the data is either exported or imported. If you do not specify an archive directory, the file is deleted from the specified File Path once the interface is processed and the data exchange is done.

    Alphanumeric, 255 Characters; Mandatory
    Unique File Name?

    Select Yes to indicate that, only files that exactly correspond with the specified file name will be imported/exported. If you choose 'No', all the files that resemble the specified file name will be picked up for import. And for export, the file name generation will be based on the mask value given in the file name of the interface definition.

    Optional
    File Type

    Select the type of file that is being exported or imported.

    Alphanumeric, 1 Character; Mandatory
    ASCII File Format

    Select the format for ASCII files, either Fixed or Delimited from the drop-down list.

    Mandatory for ASCII file types
    Field Delimiter
    Field delimiter is used only for interface without segments. Select the delimiter to be used for the different fields from the drop-down list. The available options are:
    • Comma
    • Colon
    • Semi Colon
    • Space
    • Tab
    • Null String

    Optional
    Column Header

    Select Yes from the drop-down list if column headings must be picked up in the export or import file, typically in an MS Excel Worksheet.

    Optional
    String Delimiter
    Select the delimiter to be used for the different strings from the drop-down list. The available options are:
    • Double Quotes
    • Single Quotes

    Optional
    Date Format

    Select the date format from the option list.

    Alphanumeric; 12 Characters; Optional
    Decimal Symbol
    Select the decimal symbol from the drop-down list. The available options are:
    • Comma
    • Space
    • Dot
    • Fixed Length

    Optional
    Time Delimiter

    Select the time delimiter from the drop-down list. The available options are:

    • Colon
    • Semi Colon
    • Space

    Optional
    Digit Grouping

    Select the digit grouping from the drop-down list. The available options are:

    • Comma
    • Space
    • Dot

    Optional
    Date Time Option?

    Select the date-time format that is applicable in the data that is being imported or exported.

    Optional
    Populate Click this button to view the column specification details as follows: NA
    Column Specification Specify the fields under this section. NA
    Field

    The system displays the field number. However, you can amend this value.

    You can specify the actual columns or fields in the file that will be exported or imported or in the specified table, in the Column Specifications Maintenance screen. You can also define a sequence in which the data must be ordered.

    Alphanumeric; 50 Characters; Mandatory
    File Number

    The sequential number for the selected file from the File Specifications Tab grid in the Interface Maintenance screen is displayed here. It represents the file for which you are specifying the column details in this screen. All the columns that are found in the specified table are displayed in the grid in this screen, with their details. Making changes to any of these details will result in a corresponding change in the output data. If you delete a particular row in the grid, then that column will not appear in the output data.

    Numeric; 3 Characters; Mandatory
    Field Type

    The system displays the field type. However, you can amend this value.

    Alphanumeric; 30 Characters; Mandatory
    Field Length

    The system displays the field type. However, you can amend this value.

    Note: For all exports, the field length value will be same as the value mentioned in Upload format PDF

    Numeric; 22 Characters; Mandatory
    Column Heading

    The heading of the column or field in the table is displayed here. You can alter the heading.

    Alphanumeric; 50 Characters; Mandatory
    File Col Sequence

    The system displays the field type. However, you can amend this value.

    The Interface system allows you to maintain the sequence of fields in the export and import tables. This lets you reuse common tables for header and trailers. The import or export file need not be in the same sequence as the fields of the tables created for them.

    Numeric; 3 Characters; Mandatory
    Select
    Select the option from the drop-down list. The available options are:
    • Yes
    • No
    You can also indicate any or all of the following format specifications for the file in the File Specifications grid:
    • Field and String Delimiters
    • Date Format
    • Decimal Symbol
    • Digit Grouping Symbol
    • Date and Time Delimiters

    For more information on Default values, refer Table 4-5.

    Optional
    Segment Specifications Specify the fields under this section. NA
    File Number

    The system displays the file number.

    Display
    Table Name

    Specify the table name.

    Alphanumeric; 30 Characters; Mandatory
    Segment Number '

    Specify the segment number.

    Alphanumeric; 3 Characters; Mandatory
    Identifier Field Name

    Specify the identifier field name.

    Alphanumeric; 30 Characters; Optional
    Identifier Field Value

    Specify the identifier field value.

    Alphanumeric; 30 Characters; Optional
    First Row/Last Row
    Select if the segment is first row or last row from the drop-down list. The available options are:
    • First Row
    • Last Row

    Optional
    Populate Click this button to populate the following details. NA
    Column Specification Specify the fields under this section. NA
    Field

    The system displays the field number. However, you can amend this value.

    You can specify the actual columns or fields in the file that will be exported or imported or in the specified table, in the Column Specifications Maintenance screen. You can also define a sequence in which the data must be ordered.

    Alphanumeric; 50 Characters; Mandatory
    File Number

    The sequential number for the selected file from the File Specifications Tab grid in the Interface Maintenance screen is displayed here. It represents the file for which you are specifying the column details in this screen. All the columns that are found in the specified table are displayed in the grid in this screen, with their details. Making changes to any of these details will result in a corresponding change in the output data. If you delete a particular row in the grid, then that column will not appear in the output data.

    Numeric; 3 Characters; Mandatory
    Field Type

    The system displays the field type. However, you can amend this value.

    Alphanumeric; 30 Characters; Mandatory
    Field Length

    The system displays the field type. However, you can amend this value.

    Note: For all exports, the field length value will be same as the value mentioned in Upload format PDF.

    Numeric; 22 Characters; Mandatory
    Column Heading

    The heading of the column or field in the table is displayed here. You can alter the heading.

    Alphanumeric; 50 Characters; Mandatory
    File Col Sequence

    The system displays the field type. However, you can amend this value.

    The Interface system allows you to maintain the sequence of fields in the export and import tables. This lets you reuse common tables for header and trailers. The import or export file need not be in the same sequence as the fields of the tables created for them.

    Numeric; 3 Characters; Mandatory
    Select
    Select the option from the drop-down list. The available options are:
    • Yes
    • No

    Optional

    Table 4-4 Mask Values

    Mask Definition (.txt represents sample file extension) Value that will be replaced
    $m$_filename.txt moduleid_filename.txt
    $u$_filename.txt userid_filename.txt
    $a$_filename.txt agentcode_filename.txt
    $b$_filename.txt branchcode_filename.txt
    $t$_filename.txt <datetime>_filename.txt (date will be the Application date)
    $d$_filename.txt <date>_filename.txt (date will be the Application date)
    $c$_filename.txt <Customvalue>_filename.txt .

    Kernel will generate filename and custom should be able to override the file name only if $c$ mask is maintained.
    $v$_filename.txt <SplitColumnValue>_filename.txt

    SplitColumn mentioned in the maintenance will be used.

    Table 4-5 Default Values

    Format Specification Allowable Default
    Field Delimiter Comma, colon, semi-colon, space, tab, null Space
    String Delimiter Single and double quotation marks; null Null
    Date Format DMONY; DMY; MDY; YMD; Registry Setting Registry Setting
    Date Delimiter Hyphen, comma, space, forward slash, Registry Setting Registry Setting
    Decimal Symbol Comma, space, null, period, Registry Setting Registry Setting
    Digit Grouping Symbol Comma, period, space, null, Registry Setting Registry Setting
    Time Delimiter Colon, semi-colon, space, null, Registry Setting Registry Setting
  5. Click Save to save the record.

Parent topic: Interfaces with External Systems