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) | |
7 | SecurityCode | Char(50) | Code of the security linked to the interest |
8 | DepositReference | Char(50) | |
9 | FromDate | Date/Time | Start date of the period |
10 | ToDate | Date/Time | End date of the period |
11 | CyInterest | Double | Interest value in transaction currency |
12 | Interest | Double | Interest value in capital currency |
13 | IntType |
Integer | Possible values: 0: None 1: Purchase or Initial Balance 2: Accrual 3: Sold 4: Update 5: Manual |
14 | DGLAccount | Char(50) | Debit General Ledger Account |
15 | CGLAccount | Char(50) | Credit General Ledger Account |
16 | SecurityGLAccount | Char(50) | Security General Ledger Account |
This table contains accrued interest for securities and deposits transactions.
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.
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.