StockTransfer

Stock transfer:

Name Type Mandatory Description
<Record Type =”14“> Long Y Type of object to import. 14 is for stock transfer
<DBId></DBId> Long Y Database Id in DeMaSy. It is displayed in Utilities
<Ref></Ref> Char 255 N Internal reference
<Desc></Desc> Char 255 N Internal description
<TransferType></TransferType> Integer Y Type of transfer values:
1: In
2: Out
3: Initial
4: Loss
5: Transfer
6: Reeval
<StockName></StockName> Long N Name of the stock
<SupplierName></SupplierName> Char 50 Y Name of the supplier
<ClientName></ClientName> Char 75 Y Name of the client
<DeliveryNote></DeliveryNote> Char 50 N Delivery note
<TransDate></TransDate> Date/Time Y Transaction date
<ValueDate></ValueDate> Date/Time Y Value date
<SettlementDate></SettlementDate> Date/Time Y Settlement date
<StockTransferCurrency></StockTransferCurrency> Char 10 Y Currency of the stock transfer
<CurrencyRate></CurrencyRate> Double N Currency rate
<SecurityCode></SecurityCode> Char 50 Y Security Code
<CyArticlePrice></CyArticlePrice> Double N Price in transaction currency
<ArticlePrice></ArticlePrice> Double Y Price in capital currency
<ArticleNumber></ArticleNumber> Double Y Number of article
<CyAmount></CyAmount> Double Y Amount of the stock transfer in transaction currency
<Amount></Amount> Double N Amount of the stock transfer in capital currency
<CyFees></CyFees> Double N Fees of the stock transfer in transaction currency
<Fees></Fees> Double Y Fees of the stock transfer in capital currency
<CyTaxFees></CyTaxFees> Double N Tax fees of the stock transfer in transaction currency
<TaxFees></TaxFees> Double Y Tax fees of the stock transfer in capital currency
<CyTotal></CyTotal> Double N Total of the stock transfer in transaction currency
<Total></Total> Double Y Total of the stock transfer in capital currency
<CyPurchaseInt></CyPurchaseInt> Double Y Purchase interest of the stock transfer in transaction currency
<PurchaseInt></PurchaseInt> Double N Purchase interest of the stock transfer in capital currency
<CySoldInt></CySoldInt> Double Y Sale interest of the stock transfer in transaction currency
<SoldInt></SoldInt> Double N Sale interest of the stock transfer in capital currency
</Record> Y End of block

This table contains all securities purchases and sales.
For the payments of purchases/sales, see table IMPORT_PAYMENT.
Each transaction (puchase/sale) has to be split into two different records.

PDF version
Excel version