{"id":1849,"date":"2014-07-11T10:01:49","date_gmt":"2014-07-11T09:01:49","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1849&lang=en"},"modified":"2021-02-18T16:35:08","modified_gmt":"2021-02-18T15:35:08","slug":"accrual-interest-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1849","title":{"rendered":"Accrual Interest"},"content":{"rendered":"

Accrual Interest:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;Ref;Desc;BatchDate;StockTransferDeliveryNote;SecurityCode;DepositReference;FromDate;
ToDate;CyInterest;Interest;IntType;DGLAccount;CGLAccount;SecurityGLAccount<\/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
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 17 is for accrual interest<\/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 description<\/td>\n<\/tr>\n
5<\/td>\nBatchDate<\/span><\/td>\nDate\/Time<\/td>\nDate of the interest<\/td>\n<\/tr>\n
6<\/td>\nStockTransferDeliveryNote<\/span><\/td>\nChar(50)<\/td>\n\u00a0<\/td>\n<\/tr>\n
7<\/td>\nSecurityCode<\/span><\/td>\nChar(50)<\/td>\nCode of the security linked to the interest<\/td>\n<\/tr>\n
8<\/td>\nDepositReference<\/span><\/td>\nChar(50)<\/td>\n\u00a0<\/td>\n<\/tr>\n
9<\/td>\nFromDate<\/span><\/td>\nDate\/Time<\/td>\nStart date of the period<\/td>\n<\/tr>\n
10<\/td>\nToDate<\/span><\/td>\nDate\/Time<\/td>\nEnd date of the period<\/td>\n<\/tr>\n
11<\/td>\nCyInterest<\/span><\/td>\nDouble<\/td>\nInterest value in transaction currency<\/td>\n<\/tr>\n
12<\/td>\nInterest<\/span><\/td>\nDouble<\/td>\nInterest value in capital currency<\/td>\n<\/tr>\n
13<\/td>\nIntType
<\/span><\/td>\n		Integer<\/td>\nPossible values:
0: None\u00a0
1: Purchase or Initial Balance
2: Accrual
3: Sold
4: Update
5: Manual<\/td>\n<\/tr>\n
14<\/td>\nDGLAccount<\/span><\/td>\nChar(50)<\/td>\nDebit General Ledger Account<\/td>\n<\/tr>\n
15<\/td>\nCGLAccount<\/span><\/td>\nChar(50)<\/td>\nCredit General Ledger Account<\/td>\n<\/tr>\n
16<\/td>\nSecurityGLAccount<\/span><\/td>\nChar(50)<\/td>\nSecurity General Ledger Account<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This table contains accrued interest for securities and deposits transactions.<\/p>\n

This table should normally be used for deposits maturities. When a deposit matures there is record in the table Import_Deposit and a record in Import_Accinterest. This will give DeMaSy the total amount of interest paid by the bank at maturity. This amount of interest will be finally processed by difference with the existing accruals in DeMaSy a maturity date.<\/p>\n

All other accruals on deposits and securities are computed and booked by DeMaSy except otherwise decided which would then justify the use of this table to provide DeMaSy with the accruals computed by the bank system.<\/p>\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Accrual Interest: RecordType;DBId;Ref;Desc;BatchDate;StockTransferDeliveryNote;SecurityCode;DepositReference;FromDate;ToDate;CyInterest;Interest;IntType;DGLAccount;CGLAccount;SecurityGLAccount Nr Name Type Description 1 RecordType Long Type of object to import. 17 is for accrual interest 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 Ref Char(255) Internal reference 4 Desc Char(255) Internal description 5 BatchDate Date\/Time Date of the interest 6 StockTransferDeliveryNote Char(50) \u00a0 7 SecurityCode […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[59,15,485],"class_list":["post-1849","post","type-post","status-publish","format-standard","hentry","category-interface-utils","tag-accrual-interest","tag-interface","tag-text-interface"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1849","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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1849"}],"version-history":[{"count":13,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1849\/revisions"}],"predecessor-version":[{"id":11365,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1849\/revisions\/11365"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}