Forex:
| Name | Type | Mandatory | Description |
|---|---|---|---|
| <Record Type =”12“> | Long | Y | Type of object to import. 12 is for forex |
| <DBId></DBId> | Long | Y | Database Id in DeMaSy. It is displayed in Utilities |
| <Ref></ Ref> | Char 255 | N | Internal reference |
| <Desc></ Desc> | Char 255 | N | Internal reference |
| <Reference></ Reference> | Char 50 | Y | Transaction reference |
| <ForexType></ ForexType> | Integer | Y | Types : 5 = Forex / 6 = Outright / 7 = Swap |
| <OrgForexRef></OrgForexRef> | Char 50 | Y | Link reference between forex and Outright part of Swap |
| <TransDate></TransDate> | Date/Time | Y | Transaction date |
| <ValueDate></ValueDate> | Date/Time | Y | Value date |
| <CurrencyRate></CurrencyRate> | Double | N | Transaction currency rate |
| <TGLAccount></TGLAccount> | Char 50 | Y | Accounting account (for purchase) |
| <TBankStatment></TBankStatment> | Long | Y | Bank statment (for purchase) |
| <TCurrency></TCurrency> | Char 10 | Y | Currency ISO code (for purchase) |
| <TCurrencyRate></TCurrencyRate> | Double | N | Currency rate (for purchase) |
| <TCyAmount></TCyAmount> | Double | Y | Amount in transaction currency (for purchase) |
| <TAmount></TAmount> | Double | N | Amount in capital currency (for purchase) |
| <FGLAccount></FGLAccount> | Char 50 | Y | Accounting account (for sale) |
| <FBankStatment></FBankStatment> | Long | Y | Bank statment (for sale) |
| <FCurrency></FCurrency> | Char 10 | Y | Currency ISO code (for sale) |
| <FCurrencyRate></FCurrencyRate> | Double | N | Currency rate (for sale) |
| <FCyAmount></FCyAmount> | Double | Y | Amount in transaction currency (for sale) |
| <Amount></Amount> | Double | N | Amount in capital currency (for sale) |
| </Record> | Y | End of block |
This table contains the following transaction : FOREX / OUTRIGHTS AND SWAPS
Swaps transactions have to be split into two different records : One forex and one linked outright.