{"id":1960,"date":"2014-07-11T10:50:49","date_gmt":"2014-07-11T09:50:49","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1960&lang=en"},"modified":"2020-07-30T13:59:22","modified_gmt":"2020-07-30T12:59:22","slug":"stock-transfer","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1960","title":{"rendered":"Stock transfer"},"content":{"rendered":"

Stock transfer:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;TransferType;StockName;SupplierName;ClientName;JobNumber;GLAccountNumber;POrderNumber;
\nPOrderDetailNumber;DeliveryNote;TransDate;StockTransferCurrency;CurrencyRate;SerialNumber;CyArticlePrice;ArticlePrice;
\nArticleNumber;CyAmount;Amount<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 14 is for stock transfer<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
3<\/td>\nRef<\/span><\/td>\nChar(255)<\/td>\nInternal reference<\/td>\n<\/tr>\n
4<\/td>\nDesc<\/span><\/td>\nChar(255)<\/td>\nInternal description<\/td>\n<\/tr>\n
5<\/td>\nTransferType<\/span><\/td>\nInteger<\/td>\nType of transfer values:
\n1: In
\n2: Out
\n3: Initial
\n4: Loss
\n5: Transfer
\n6: Reeval<\/td>\n<\/tr>\n
6<\/td>\nStockName<\/span><\/td>\nLong<\/td>\nName of the stock<\/td>\n<\/tr>\n
7<\/td>\nSupplierName<\/span><\/td>\nChar(50)<\/td>\nName of the supplier<\/td>\n<\/tr>\n
8<\/td>\nClientName<\/span><\/td>\nChar(75)<\/td>\nName of the client<\/td>\n<\/tr>\n
9<\/td>\nDeliveryNote<\/span><\/td>\nChar(50)<\/td>\nDelivery note<\/td>\n<\/tr>\n
10<\/td>\nTransDate<\/span><\/td>\nDate\/Time<\/td>\nTransaction date<\/td>\n<\/tr>\n
11<\/td>\nValueDate<\/span><\/td>\nDate\/Time<\/td>\nValue date<\/td>\n<\/tr>\n
12<\/td>\nSettlementDate<\/span><\/td>\nDate\/Time<\/td>\nSettlement date<\/td>\n<\/tr>\n
13<\/td>\nStockTransferCurrency<\/span><\/td>\nChar(10)<\/td>\nCurrency of the stock transfer<\/td>\n<\/tr>\n
14<\/td>\nCurrencyRate<\/span><\/td>\nDouble<\/td>\nCurrency rate<\/td>\n<\/tr>\n
15<\/td>\nSecurityCode<\/span><\/td>\nChar(50)<\/td>\nSecurity Code<\/td>\n<\/tr>\n
16<\/td>\nCyArticlePrice<\/span><\/td>\nDouble<\/td>\nPrice in transaction currency<\/td>\n<\/tr>\n
17<\/td>\nArticlePrice<\/span><\/td>\nDouble<\/td>\nPrice in capital currency<\/td>\n<\/tr>\n
18<\/td>\nArticleNumber<\/span><\/td>\nDouble<\/td>\nNumber of article<\/td>\n<\/tr>\n
19<\/td>\nCyAmount<\/span><\/td>\nDouble<\/td>\nAmount of the stock transfer in transaction currency<\/td>\n<\/tr>\n
20<\/td>\nAmount<\/span><\/td>\nDouble<\/td>\nAmount of the stock transfer in capital currency<\/td>\n<\/tr>\n
21<\/td>\nCyFees<\/span><\/td>\nDouble<\/td>\nFees of the stock transfer in transaction currency<\/td>\n<\/tr>\n
22<\/td>\nFees<\/span><\/td>\nDouble<\/td>\nFees of the stock transfer in capital currency<\/td>\n<\/tr>\n
23<\/td>\nCyTaxFees<\/span><\/td>\nDouble<\/td>\nTax fees of the stock transfer in transaction currency<\/td>\n<\/tr>\n
24<\/td>\nTaxFees<\/span><\/td>\nDouble<\/td>\nTax fees of the stock transfer in capital currency<\/td>\n<\/tr>\n
25<\/td>\nCyTotal<\/span><\/td>\nDouble<\/td>\nTotal of the stock transfer in transaction currency<\/td>\n<\/tr>\n
26<\/td>\nTotal<\/span><\/td>\nDouble<\/td>\nTotal of the stock transfer in capital currency<\/td>\n<\/tr>\n
27<\/td>\nCyPurchaseInt<\/span><\/td>\nDouble<\/td>\nPurchase interest of the stock transfer in transaction currency<\/td>\n<\/tr>\n
28<\/td>\nPurchaseInt<\/span><\/td>\nDouble<\/td>\nPurchase interest of the stock transfer in capital currency<\/td>\n<\/tr>\n
29<\/td>\nCySoldInt<\/span><\/td>\nDouble<\/td>\nSale interest of the stock transfer in transaction currency<\/td>\n<\/tr>\n
30<\/td>\nSoldInt<\/span><\/td>\nDouble<\/td>\nSale interest of the stock transfer in capital currency<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This table contains all securities purchases and sales.
\nFor the payments of purchases\/sales, see table IMPORT_PAYMENT.
\nEach transaction (puchase\/sale) has to be split into two different records.<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1960","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1960"}],"version-history":[{"count":5,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1960\/revisions"}],"predecessor-version":[{"id":9339,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1960\/revisions\/9339"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}