{"id":1618,"date":"2014-06-26T07:48:54","date_gmt":"2014-06-26T06:48:54","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1618&lang=en"},"modified":"2019-06-06T13:43:00","modified_gmt":"2019-06-06T12:43:00","slug":"forex","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1618","title":{"rendered":"Forex"},"content":{"rendered":"

Forex:<\/span><\/b><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nType<\/th>\nMandatory<\/th>\nDescription<\/th>\n<\/tr>\n
<Record<\/span> Type<\/span> =”12<\/span>“><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. 12 is for forex<\/td>\n<\/tr>\n
<DBId><\/DBId><\/span><\/td>\nLong<\/td>\nY<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
<Ref><\/ Ref><\/span><\/td>\nChar 255<\/td>\nN<\/td>\nInternal reference<\/td>\n<\/tr>\n
<Desc><\/ Desc><\/span><\/td>\nChar 255<\/td>\nN<\/td>\nInternal reference<\/td>\n<\/tr>\n
<Reference><\/ Reference><\/span><\/td>\nChar 50<\/td>\nY<\/td>\nTransaction reference<\/td>\n<\/tr>\n
<ForexType><\/ ForexType><\/span><\/td>\nInteger<\/td>\nY<\/td>\nTypes : 5 = Forex \/ 6 = Outright \/ 7 = Swap<\/td>\n<\/tr>\n
<OrgForexRef><\/OrgForexRef><\/span><\/td>\nChar 50<\/td>\nY<\/td>\nLink reference between forex and Outright part of Swap<\/td>\n<\/tr>\n
<TransDate><\/TransDate><\/span><\/td>\nDate\/Time<\/td>\nY<\/td>\nTransaction date<\/td>\n<\/tr>\n
<ValueDate><\/ValueDate><\/span><\/td>\nDate\/Time<\/td>\nY<\/td>\nValue date<\/td>\n<\/tr>\n
<CurrencyRate><\/CurrencyRate><\/span><\/td>\nDouble<\/td>\nN<\/td>\nTransaction currency rate<\/td>\n<\/tr>\n
<TGLAccount><\/TGLAccount><\/span><\/td>\nChar 50<\/td>\nY<\/td>\nAccounting account (for purchase)<\/td>\n<\/tr>\n
<TBankStatment><\/TBankStatment><\/span><\/td>\nLong<\/td>\nY<\/td>\nBank statment (for purchase)<\/td>\n<\/tr>\n
<TCurrency><\/TCurrency><\/span><\/td>\nChar 10<\/td>\nY<\/td>\nCurrency ISO code (for purchase)<\/td>\n<\/tr>\n
<TCurrencyRate><\/TCurrencyRate><\/span><\/td>\nDouble<\/td>\nN<\/td>\nCurrency rate (for purchase)<\/td>\n<\/tr>\n
<TCyAmount><\/TCyAmount><\/span><\/td>\nDouble<\/td>\nY<\/td>\nAmount in transaction currency (for purchase)<\/td>\n<\/tr>\n
<TAmount><\/TAmount><\/span><\/td>\nDouble<\/td>\nN<\/td>\nAmount in capital currency (for purchase)<\/td>\n<\/tr>\n
<FGLAccount><\/FGLAccount><\/span><\/td>\nChar 50<\/td>\nY<\/td>\nAccounting account (for sale)<\/td>\n<\/tr>\n
<FBankStatment><\/FBankStatment><\/span><\/td>\nLong<\/td>\nY<\/td>\nBank statment (for sale)<\/td>\n<\/tr>\n
<FCurrency><\/FCurrency><\/span><\/td>\nChar 10<\/td>\nY<\/td>\nCurrency ISO code (for sale)<\/td>\n<\/tr>\n
<FCurrencyRate><\/FCurrencyRate><\/span><\/td>\nDouble<\/td>\nN<\/td>\nCurrency rate (for sale)<\/td>\n<\/tr>\n
<FCyAmount><\/FCyAmount><\/span><\/td>\nDouble<\/td>\nY<\/td>\nAmount in transaction currency (for sale)<\/td>\n<\/tr>\n
<Amount><\/Amount><\/span><\/td>\nDouble<\/td>\nN<\/td>\nAmount in capital currency (for sale)<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This table contains the following transaction : FOREX \/ OUTRIGHTS AND SWAPS
\nSwaps transactions have to be split into two different records : One forex and one linked outright.<\/p>\n

PDF version<\/a>
\nExcel version<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[38,15,12],"class_list":["post-1618","post","type-post","status-publish","format-standard","hentry","category-utils","tag-forex","tag-interface","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1618","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1618"}],"version-history":[{"count":37,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1618\/revisions"}],"predecessor-version":[{"id":7167,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1618\/revisions\/7167"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}