Stock transfer:
RecordType;DBId;TransferType;StockName;SupplierName;ClientName;JobNumber;GLAccountNumber;POrderNumber; POrderDetailNumber;DeliveryNote;TransDate;StockTransferCurrency;CurrencyRate;SerialNumber;CyArticlePrice;ArticlePrice; ArticleNumber;CyAmount;Amount |
Nr | Name | Type | Description |
---|---|---|---|
1 | RecordType | Long | Type of object to import. 14 is for stock transfer |
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 | TransferType | Integer | Type of transfer values: 1: In 2: Out 3: Initial 4: Loss 5: Transfer 6: Reeval |
6 | StockName | Long | Name of the stock |
7 | SupplierName | Char(50) | Name of the supplier |
8 | ClientName | Char(75) | Name of the client |
9 | DeliveryNote | Char(50) | Delivery note |
10 | TransDate | Date/Time | Transaction date |
11 | ValueDate | Date/Time | Value date |
12 | SettlementDate | Date/Time | Settlement date |
13 | StockTransferCurrency | Char(10) | Currency of the stock transfer |
14 | CurrencyRate | Double | Currency rate |
15 | SecurityCode | Char(50) | Security Code |
16 | CyArticlePrice | Double | Price in transaction currency |
17 | ArticlePrice | Double | Price in capital currency |
18 | ArticleNumber | Double | Number of article |
19 | CyAmount | Double | Amount of the stock transfer in transaction currency |
20 | Amount | Double | Amount of the stock transfer in capital currency |
21 | CyFees | Double | Fees of the stock transfer in transaction currency |
22 | Fees | Double | Fees of the stock transfer in capital currency |
23 | CyTaxFees | Double | Tax fees of the stock transfer in transaction currency |
24 | TaxFees | Double | Tax fees of the stock transfer in capital currency |
25 | CyTotal | Double | Total of the stock transfer in transaction currency |
26 | Total | Double | Total of the stock transfer in capital currency |
27 | CyPurchaseInt | Double | Purchase interest of the stock transfer in transaction currency |
28 | PurchaseInt | Double | Purchase interest of the stock transfer in capital currency |
29 | CySoldInt | Double | Sale interest of the stock transfer in transaction currency |
30 | SoldInt | Double | Sale interest of the stock transfer in capital currency |
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.