{"id":1904,"date":"2014-07-11T10:32:23","date_gmt":"2014-07-11T09:32:23","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1904&lang=en"},"modified":"2020-07-30T13:52:27","modified_gmt":"2020-07-30T12:52:27","slug":"deposit-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1904","title":{"rendered":"Deposit"},"content":{"rendered":"

Deposit:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;OrgDepositReference;CompanyName;TransDate;ValueDate;MaturityDate;Basis;DepositType;InterestRate;
\nFBankAccountNumber;FGLAccountNumber;FBankStatment;FCurrency;FCurrencyRate;FCyAmount;FAmount;
\nCyInterest;Interest;TBankAccountNumber;TGLAccountNumber;TBankStatment;TCurrency;TCurrencyRate;TCyAmount;TAmount;
\nBreakIncReference;IncDecReference;IncDecType;DepType;Status<\/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\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. 13 is for deposit<\/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<\/span><\/td>\nChar 255<\/td>\nInternal reference<\/td>\n<\/tr>\n
4<\/td>\nDesc<\/span><\/td>\nChar 255<\/td>\nInternal reference<\/td>\n<\/tr>\n
5<\/td>\nReference<\/span><\/td>\nChar 50<\/td>\nDeposit reference<\/td>\n<\/tr>\n
6<\/td>\nOrgDepositReference<\/span><\/td>\nChar 50<\/td>\nOriginal reference<\/td>\n<\/tr>\n
7<\/td>\nTransDate<\/span><\/td>\nDate\/Time<\/td>\nTransaction date<\/td>\n<\/tr>\n
8<\/td>\nValueDate<\/span><\/td>\nDate\/Time<\/td>\nValue date<\/td>\n<\/tr>\n
9<\/td>\nMaturityDate<\/span><\/td>\nDate\/Time<\/td>\nMaturity date<\/td>\n<\/tr>\n
10<\/td>\nBasis<\/span><\/td>\nInteger<\/td>\nBasis :
\n1 = 365\/366
\n2 = 365\/365
\n3 = 365\/360
\n4 = 360\/360 EU
\n5 = 365\/365 Quasi-coupon US Treasury
\n6 = 360\/360 US
\n7 = 360\/365
\n8 = 360\/366<\/td>\n<\/tr>\n
11<\/td>\nDepositType<\/span><\/td>\nInteger<\/td>\nDeposit type :
\n1 = Rolled over with interests
\n2 = Rolled over without interests
\n3 = Reimbursed
\n4 = Maturity of an existing deposit
\n5 = Reimbursed and Rollover without interests
\n6 = Reimbursed and Rollover with interests<\/td>\n<\/tr>\n
12<\/td>\nInterestRate<\/span><\/td>\nDouble<\/td>\nInterest rate<\/td>\n<\/tr>\n
13<\/td>\nFGLAccountNumber<\/span><\/td>\nChar 50<\/td>\nCurrent general ledger account<\/td>\n<\/tr>\n
14<\/td>\nFBankStatment<\/span><\/td>\nLong<\/td>\nCurrent bank statement number<\/td>\n<\/tr>\n
15<\/td>\nFCurrency<\/span><\/td>\nChar 10<\/td>\nCurrent currency ISO code<\/td>\n<\/tr>\n
16<\/td>\nFCurrencyRate<\/span><\/td>\nDouble<\/td>\nCurrent currency rate<\/td>\n<\/tr>\n
17<\/td>\nFCyAmount<\/span><\/td>\nDouble<\/td>\nAmount in capital currency<\/td>\n<\/tr>\n
18<\/td>\nFAmount<\/span><\/td>\nDouble<\/td>\nAmount<\/td>\n<\/tr>\n
19<\/td>\nTGLAccountNumber<\/span><\/td>\nChar 10<\/td>\nInterest general ledger account<\/td>\n<\/tr>\n
20<\/td>\nTBankStatment<\/span><\/td>\nLong<\/td>\nInterest bank statement<\/td>\n<\/tr>\n
21<\/td>\nTCurrency(1)<\/span><\/td>\nChar 10<\/td>\nInterest currency ISO code<\/td>\n<\/tr>\n
22<\/td>\nTCurrencyRate(1)<\/span><\/td>\nDouble<\/td>\nInterest currency rate<\/td>\n<\/tr>\n
23<\/td>\nTCyAmount(1)<\/span><\/td>\nDouble<\/td>\nInterest in capital currency<\/td>\n<\/tr>\n
24<\/td>\nTAmount(1)<\/span><\/td>\nDouble<\/td>\nInterest amount<\/td>\n<\/tr>\n
25<\/td>\nBreakIncReference<\/span><\/td>\nChar 50<\/td>\n\/<\/td>\n<\/tr>\n
26<\/td>\nIncDecReference<\/span><\/td>\nChar 50<\/td>\n\/<\/td>\n<\/tr>\n
27<\/td>\nIncDecType<\/span><\/td>\nInteger<\/td>\n\/<\/td>\n<\/tr>\n
28<\/td>\nDepType<\/span><\/td>\nInteger<\/td>\nDepType :
\n1 = Deposit
\n2 = Loan to affiliated company
\n3 = Borrowing
\n4 = Borrowing to affiliated company
\n5 = Load
\n6 = Bond issue<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This table contains deposits\/loans transactions.
\n(1) A deposit in a currency different from the currency of the current bank account where the money comes
\nfrom has to be split into two transactions: 1 Forex followed by 1 deposit.
\n(2) DeMaSy can handle non banking loans and borrowings. However these transactions require account information
\nthat are not available in banking software. In order to be able to use these transactions the accounts numbers
\nwill have to be provided, either by the program extracting the data from the bank database or by the user.<\/p>\n","protected":false},"excerpt":{"rendered":"

Deposit: RecordType;DBId;OrgDepositReference;CompanyName;TransDate;ValueDate;MaturityDate;Basis;DepositType;InterestRate; FBankAccountNumber;FGLAccountNumber;FBankStatment;FCurrency;FCurrencyRate;FCyAmount;FAmount; CyInterest;Interest;TBankAccountNumber;TGLAccountNumber;TBankStatment;TCurrency;TCurrencyRate;TCyAmount;TAmount; BreakIncReference;IncDecReference;IncDecType;DepType;Status Nr Name Type Description 1 RecordType Long Type of object to import. 13 is for deposit 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 Deposit reference 6 OrgDepositReference Char 50 […]<\/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-1904","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1904","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=1904"}],"version-history":[{"count":4,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1904\/revisions"}],"predecessor-version":[{"id":9318,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1904\/revisions\/9318"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}