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 | Original reference |
| 7 | TransDate | Date/Time | Transaction date |
| 8 | ValueDate | Date/Time | Value date |
| 9 | MaturityDate | Date/Time | Maturity date |
| 10 | Basis | Integer | Basis : 1 = 365/366 2 = 365/365 3 = 365/360 4 = 360/360 EU 5 = 365/365 Quasi-coupon US Treasury 6 = 360/360 US 7 = 360/365 8 = 360/366 |
| 11 | DepositType | Integer | Deposit type : 1 = Rolled over with interests 2 = Rolled over without interests 3 = Reimbursed 4 = Maturity of an existing deposit 5 = Reimbursed and Rollover without interests 6 = Reimbursed and Rollover with interests |
| 12 | InterestRate | Double | Interest rate |
| 13 | FGLAccountNumber | Char 50 | Current general ledger account |
| 14 | FBankStatment | Long | Current bank statement number |
| 15 | FCurrency | Char 10 | Current currency ISO code |
| 16 | FCurrencyRate | Double | Current currency rate |
| 17 | FCyAmount | Double | Amount in capital currency |
| 18 | FAmount | Double | Amount |
| 19 | TGLAccountNumber | Char 10 | Interest general ledger account |
| 20 | TBankStatment | Long | Interest bank statement |
| 21 | TCurrency(1) | Char 10 | Interest currency ISO code |
| 22 | TCurrencyRate(1) | Double | Interest currency rate |
| 23 | TCyAmount(1) | Double | Interest in capital currency |
| 24 | TAmount(1) | Double | Interest amount |
| 25 | BreakIncReference | Char 50 | / |
| 26 | IncDecReference | Char 50 | / |
| 27 | IncDecType | Integer | / |
| 28 | DepType | Integer | DepType : 1 = Deposit 2 = Loan to affiliated company 3 = Borrowing 4 = Borrowing to affiliated company 5 = Load 6 = Bond issue |
This table contains deposits/loans transactions.
(1) A deposit in a currency different from the currency of the current bank account where the money comes
from has to be split into two transactions: 1 Forex followed by 1 deposit.
(2) DeMaSy can handle non banking loans and borrowings. However these transactions require account information
that are not available in banking software. In order to be able to use these transactions the accounts numbers
will have to be provided, either by the program extracting the data from the bank database or by the user.