| RecordType;DBId;Ref;Desc;SecurityCode;DepositReference;ArtDepPaymentType;CurrencyRate; CyAmount;Amount;Description;BankStatmentNumber;BankAccountNumber;SecurityGLAccount |
| Nr | Name | Type | Description |
|---|---|---|---|
| 1 | RecordType | Long | Type of object to import. 20 is for ArtDepPaymeny |
| 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 | SecurityCode | Char(50) | Security code |
| 6 | DepositReference | Char(50) | Deposit reference |
| 7 | ArtDepPaymentType | Integer | Security/Deposit payment type : 0 = NORMALPAY 1 = EXCHDIFFPAY 2 = DISCOUNTPAY 3 = DISCOUNTPRORATA 4 = FEESPAY |
| 8 | ForexReference | Char(50) | Forex reference |
| 9 | PayDate | Date/Time | Payment date |
| 10 | PCurrency | Char(10) | Payment currency ISO code |
| 11 | PCyAmount | Double | Payment Amount in transaction currency |
| 12 | ArtDepPaymentAmount | Double | Security/Deposit Payment Amount |
| 13 | CurrencyRate | Double | Currency rate |
| 14 | CyAmount | Double | Amount in transaction currency |
| 15 | Amount | Double | Amount in capital currency |
| 16 | Description | Char(255) | Description |
| 17 | BankStatmentNumber | Char(255) | Description |
| 18 | BankAccountNumber | Integer | Bank Account number |
| 19 | SecurityGLAccount | Integer | Security GLAccount number (Default, if it is no entered, is the GLAccount on DeMaSy Security screen) |