1.14.1 Segment Identification Number
This topic provides detailed information on exchange rate upload format of segment identification number.
Table 1-83 Segment Identification Number
| Field Name | Data type | Field Length | Mandatory? | Characteristics/rules | Values |
|---|---|---|---|---|---|
| SOURCEID | VARCHAR2 | 6 | YES | - | Source maintained in the system |
| REFCURRENCY | VARCHAR2 | 3 | YES | - | Base Currency of the Source |
| PAIRCURRENCY | VARCHAR2 | 3 | YES | - | Pair Currency for the exchange rate would be made available |
| FXDEALDATE | DATE | 10 | YES | Should be application date | Effective date for the Exchange rate |
| FXVALUEDATE | DATE | 10 | YES | Should be greater than or equal to FXDEA LDATE | Value date for Forward Rates |
| BUYRATE | NUMBER | 15 | YES | - | Buy Rate for the mentioned currencies |
| SELLRATE | NUMBER | 15 | YES | - | Sell Rate for the mentioned currencies |
| EXCHRATEFORREPORT | NUMBER | 1 | NO | - | Flag to set whether the maintained FX Rate is used for Reporting |
| USERID | VARCHAR2 | 15 | YES | - | Maker ID of the Exchange Rate |
| IMPORTSTATUS | VARCHAR2 | 1 | NO | - | Status of the Import |
| ERRORDESC | VARCHAR2 | 255 | NO | - | Error description |
| AUTH_STAT | VARCHAR2 | 1 | NO | - |
Authorization Status:
|
| PROCESSID | VARCHAR2 | 50 | NO | - | Process ID |
| BULKCLIENTCODE | VARCHAR2 | 12 | NO | - | Bulk Client Code |
| IMPORTFILENAME | VARCHAR2 | 255 | NO | - | Import File Name |
| AMCID | VARCHAR2 | 12 | NO | - | AMC ID |
| SERIALNUMBER | VARCHAR2 | 16 | NO | - | Serial Number |
| USERID | VARCHAR2 | 15 | YES | - | Represents the user ID who has entered the latest record |
| SEQUENCENUMBER | VARCHAR2 | 10 | NO | - | Sequence Number |
| UPLOADMODE | VARCHAR2 | 1 | NO | - |
Operation mode which will be performed on the Upload records. It can have:
|
Parent topic: Exchange Rate Upload Format