{"id":1913,"date":"2014-07-11T10:34:49","date_gmt":"2014-07-11T09:34:49","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1913&lang=en"},"modified":"2020-07-30T13:54:15","modified_gmt":"2020-07-30T12:54:15","slug":"forex-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1913","title":{"rendered":"Forex"},"content":{"rendered":"

Forex:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;ForexType;CompanyName;OrgForexRef;TransDate;ValueDate;CurrencyRate;FBankAccount;FGLAccount
\n;FBankStatment;FDebited;FCurrency;FCurrencyRate;FCyAmount;FAmount;TBankAccount;TGLAccount;TBankStatment;
\nTDebited;TCurrency;TCurrencyRate;TCyAmount;TAmount<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\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
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 12 is for forex<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
3<\/td>\nRef
\n<\/span><\/td>\n		Char 255<\/td>\nInternal reference<\/td>\n<\/tr>\n
4<\/td>\nDesc
\n<\/span><\/td>\n		Char 255<\/td>\nInternal reference<\/td>\n<\/tr>\n
5<\/td>\nReference
\n<\/span><\/td>\n		Char 50<\/td>\nTransaction reference<\/td>\n<\/tr>\n
6<\/td>\nForexType
\n<\/span><\/td>\n		Integer<\/td>\nTypes : 5 = Forex \/ 6 = Outright \/ 7 = Swap<\/td>\n<\/tr>\n
7<\/td>\nOrgForexRef<\/span><\/td>\nChar 50<\/td>\nLink reference between forex and Outright part of Swap<\/td>\n<\/tr>\n
8<\/td>\nTransDate<\/span><\/td>\nDate\/Time<\/td>\nTransaction date<\/td>\n<\/tr>\n
9<\/td>\nValueDate<\/span><\/td>\nDate\/Time<\/td>\nValue date<\/td>\n<\/tr>\n
10<\/td>\nCurrencyRate<\/span><\/td>\nDouble<\/td>\nTransaction currency rate<\/td>\n<\/tr>\n
11<\/td>\nTGLAccount<\/span><\/td>\nChar 50<\/td>\nAccounting account (for purchase)<\/td>\n<\/tr>\n
12<\/td>\nTBankStatment<\/span><\/td>\nLong<\/td>\nBank statment (for purchase)<\/td>\n<\/tr>\n
13<\/td>\nTCurrency<\/span><\/td>\nChar 10<\/td>\nCurrency ISO code (for purchase)<\/td>\n<\/tr>\n
14<\/td>\nTCurrencyRate<\/span><\/td>\nDouble<\/td>\nCurrency rate (for purchase)<\/td>\n<\/tr>\n
15<\/td>\nTCyAmount<\/span><\/td>\nDouble<\/td>\nAmount in transaction currency (for purchase)<\/td>\n<\/tr>\n
16<\/td>\nTAmount<\/span><\/td>\nDouble<\/td>\nAmount in capital currency (for purchase)<\/td>\n<\/tr>\n
17<\/td>\nFGLAccount<\/span><\/td>\nChar 50<\/td>\nAccounting account (for sale)<\/td>\n<\/tr>\n
18<\/td>\nFBankStatment<\/span><\/td>\nLong<\/td>\nBank statment (for sale)<\/td>\n<\/tr>\n
19<\/td>\nFCurrency<\/span><\/td>\nChar 10<\/td>\nCurrency ISO code (for sale)<\/td>\n<\/tr>\n
20<\/td>\nFCurrencyRate<\/span><\/td>\nDouble<\/td>\nCurrency rate (for sale)<\/td>\n<\/tr>\n
21<\/td>\nFCyAmount<\/span><\/td>\nDouble<\/td>\nAmount in transaction currency (for sale)<\/td>\n<\/tr>\n
22<\/td>\nAmount<\/span><\/td>\nDouble<\/td>\nAmount in capital currency (for sale)<\/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","protected":false},"excerpt":{"rendered":"

Forex: RecordType;DBId;ForexType;CompanyName;OrgForexRef;TransDate;ValueDate;CurrencyRate;FBankAccount;FGLAccount ;FBankStatment;FDebited;FCurrency;FCurrencyRate;FCyAmount;FAmount;TBankAccount;TGLAccount;TBankStatment; TDebited;TCurrency;TCurrencyRate;TCyAmount;TAmount Nr Name Type Description 1 RecordType Long Type of object to import. 12 is for forex 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 Ref Char 255 Internal reference 4 Desc Char 255 Internal reference 5 Reference Char 50 Transaction reference 6 ForexType Integer Types : […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1913","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1913","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=1913"}],"version-history":[{"count":8,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1913\/revisions"}],"predecessor-version":[{"id":9322,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1913\/revisions\/9322"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}