{"id":1582,"date":"2014-06-24T10:05:09","date_gmt":"2014-06-24T09:05:09","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1582&#038;lang=en"},"modified":"2015-12-02T10:45:41","modified_gmt":"2015-12-02T09:45:41","slug":"contract-detail","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1582","title":{"rendered":"Contract detail"},"content":{"rendered":"<h3><b><span style=\"text-decoration: underline;\">Contract detail:<\/span><\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<th width=\"350px\">Name<\/th>\n<th width=\"20px\">Type<\/th>\n<th width=\"15px\">Mandatory<\/th>\n<th width=\"250px\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">&lt;<span style=\"color: #993300;\">Record<\/span> <span style=\"color: #0000ff;\">Type<\/span> =&#8221;<span style=\"color: #ff0000;\">28<\/span>&#8220;&gt;<\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of object to import. 28 is for contract detail<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DBId&gt;&lt;\/DBId&gt;<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ContractRefSubRef&gt;&lt;\/ContractRefSubRef&gt;<\/span><\/td>\n<td valign=\"top\">Char(100)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Contract reference and sub-reference<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ContractTypeName&gt;&lt;\/ContractTypeName&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Contract type name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;StartDate&gt;&lt;\/StartDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Contract start date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;EndDate&gt;&lt;\/EndDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Contract end date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ContractCompanyName&gt;&lt;\/ContractCompanyName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Contract company name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CyNetPrime&gt;&lt;\/CyNetPrime&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Net prime in currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;NetPrime&gt;&lt;\/NetPrime&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Net prime<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CyFees&gt;&lt;\/CyFees&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Amount of fees in currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Fees&gt;&lt;\/Fees&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Amount of fees<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CyTax&gt;&lt;\/CyTax&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Amount of taxes in currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Tax&gt;&lt;\/ Tax&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Amount of taxes<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CyTotalPrime&gt;&lt;\/CyTotalPrime&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Total prime (net+fees+taxes) in currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;TotalPrime&gt;&lt;\/TotalPrime&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Total prime (net+fees+taxes)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CyReceivedCommission&gt;&lt;\/CyReceivedCommission&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Received commission in currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ReceivedCommission&gt;&lt;\/ReceivedCommission&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Received commission<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CyGivenCommission&gt;&lt;\/CyGivenCommission&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Given commission in currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;GivenCommission&gt;&lt;\/GivenCommission&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Given commission<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;GivenCommissionType&gt;&lt;\/GivenCommissionType&gt;<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of given commission:<br \/>\n1 = deducted on invoice<br \/>\n2 = received after prime payment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CurrencyName&gt;&lt;\/CurrencyName&gt;<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Currency name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;InvoiceType&gt;&lt;\/InvoiceType&gt;<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of invoice:<br \/>\n0 = no invoicing<br \/>\n1 = client invoicing<br \/>\n2 = agent invoicing<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;AcctgDate&gt;&lt;\/AcctgDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">\/<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ReceiptNumber&gt;&lt;\/ReceiptNumber&gt;<\/span><\/td>\n<td valign=\"top\">Char(25)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">Receipt number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Type&gt;&lt;\/Type&gt;<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;GivenCommissionPercentage&gt;&lt;\/GivenCommissionPercentage&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">Given commission percentage<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ReceivedCommissionPercentage&gt;&lt;\/ReceivedCommissionPercentage&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">Received commission percentage<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ReceivedCommissionType&gt;&lt;\/ReceivedCommissionType&gt;<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of received commission:<br \/>\n1 = deducted on invoice<br \/>\n2 = received after prime payment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;TaxCompanyName&gt;&lt;\/TaxCompanyName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">Tax company name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;TaxPersonName&gt;&lt;\/TaxPersonName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">Tax person name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BeneficiaryPercentage&gt;&lt;\/BeneficiaryPercentage&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">Beneficiary percentage<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BeneficiaryCyAmount&gt;&lt;\/BeneficiaryCyAmount&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">Beneficiary amount in currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BeneficiaryAmount&gt;&lt;\/BeneficiaryAmount&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\">Beneficiary amount<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;\/Record&gt;<\/span><\/td>\n<td valign=\"top\"><\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">End of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<a href=\"https:\/\/sdna.lu\/?media_dl=4769\">PDF version<\/a>\n","protected":false},"excerpt":{"rendered":"<p>Contract detail: Name Type Mandatory Description &lt;Record Type =&#8221;28&#8220;&gt; Long Y Type of object to import. 28 is for contract detail &lt;DBId&gt;&lt;\/DBId&gt; Long Y Database Id in DeMaSy. It is displayed in Utilities &lt;ContractRefSubRef&gt;&lt;\/ContractRefSubRef&gt; Char(100) Y Contract reference and sub-reference &lt;ContractTypeName&gt;&lt;\/ContractTypeName&gt; Char(50) Y Contract type name &lt;StartDate&gt;&lt;\/StartDate&gt; Date\/Time Y Contract start date &lt;EndDate&gt;&lt;\/EndDate&gt; Date\/Time Y [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[47,15,12],"class_list":["post-1582","post","type-post","status-publish","format-standard","hentry","category-utils","tag-contract-detail","tag-interface","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1582","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=1582"}],"version-history":[{"count":5,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1582\/revisions"}],"predecessor-version":[{"id":4770,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1582\/revisions\/4770"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}