Currency rate:
| Name | Type | Mandatory | Description |
|---|---|---|---|
| <Record Type =”51“> | Long | Y | Type of object to import. 51 is for currency rate |
| <DBId></DBId> | Long | Y | Database Id in DeMaSy. It is displayed in Utilities |
| <StartDate></StartDate> | Date/Time | Y | Date of exchange rate |
| <EndDate></EndDate> | Date/Time | N | Date at which the exchange rate is no longer valid. If no date is given, DeMaSy will fit it in automatically. |
| <OrgCurrency></OrgCurrency> | Char(10) | N | Reference currency – ISO code. Currency against which all the rates are expressed. Has to be the same for all the rates provided. |
| <DestCurrency></DestCurrency> | Char(10) | Y | Currency for which rate is provided – ISO code |
| <Value></Value> | Double | / | / |
| <BuyValue></BuyValue> | Double | N | Exchange rate – buy |
| <SellValue></SellValue> | Double | N | Exchange rate – sell |
| <InputValue></InputValue> | Double | Y | Exchange rate (average value between buy and sell values if provided) |
| <Invert></Invert> | Boolean | Y | Exchange rate is to be inverted. Give -1 as value. |
| <RoundPos></RoundPos> | Integer | N | Number of decimals |
| </Record> | Y | End of block |
Before the first <Record> tag you must insert the following tag: <Records>
At the end of the file you must add the following tag: </Records>