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.