{"id":1890,"date":"2014-07-11T10:27:25","date_gmt":"2014-07-11T09:27:25","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1890&#038;lang=en"},"modified":"2020-07-30T13:50:29","modified_gmt":"2020-07-30T12:50:29","slug":"contract-claim-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1890","title":{"rendered":"Contract claim"},"content":{"rendered":"<h3><span style=\"color: #ff0000;\"><b><span style=\"text-decoration: underline;\">Contract claim:<\/span><\/b><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td valign=\"center\">RecordType;DBId;ContractRefSubRef;ContractTypeName;ContractCompanyName;ContractPersonName;ClaimNumber;ClaimDate;<br \/>\nPaymentDate;CurrencyName;CyAmount;Amount;CancelDate;Description;InvoiceType;ExpertCompanyName;ExpertPersonName;<br \/>\nInspectorCompanyName;InspectorPersonName;Location;ContractCauseName;ContractCauseCode<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Nr<\/th>\n<th width=\"250\">Name<\/th>\n<th width=\"20\">Type<\/th>\n<th width=\"350\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">1<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RecordType<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Type of object to import. 29 is for contract claim<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">2<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DBId<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">3<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ContractRefSubRef<\/span><\/td>\n<td valign=\"top\">Char(100)<\/td>\n<td valign=\"top\">Contract reference and sub-reference<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">4<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ContractTypeName<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Contract type name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">5<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ContractCompanyName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Contract company name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">6<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ContractPersonName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Contract person name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">7<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ClaimNumber<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Claim number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">8<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ClaimDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Claim date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">9<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PaymentDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Payment date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">10<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CurrencyName<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Currency name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">11<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CyAmount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Amount in currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">12<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Amount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Amount<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">13<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CancelDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Not used<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">14<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Description<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td valign=\"top\">Not used<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">15<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">InvoiceType<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td valign=\"top\">Invoice type<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">16<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ExpertCompanyName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Expert company name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">17<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ExpertPersonName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Not used<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">18<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">InspectorCompanyName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Inspector company name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">19<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">InspectorPersonName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Not used<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">20<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Location<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Location<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">21<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ContractCauseName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Contract cause name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">22<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ContractCauseCode<\/span><\/td>\n<td valign=\"top\">Char(12)<\/td>\n<td valign=\"top\">Contract cause code<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Contract claim: RecordType;DBId;ContractRefSubRef;ContractTypeName;ContractCompanyName;ContractPersonName;ClaimNumber;ClaimDate; PaymentDate;CurrencyName;CyAmount;Amount;CancelDate;Description;InvoiceType;ExpertCompanyName;ExpertPersonName; InspectorCompanyName;InspectorPersonName;Location;ContractCauseName;ContractCauseCode Nr Name Type Description 1 RecordType Long Type of object to import. 29 is for contract claim 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 ContractRefSubRef Char(100) Contract reference and sub-reference 4 ContractTypeName Char(50) Contract type name 5 ContractCompanyName Char(75) Contract company name 6 ContractPersonName [&hellip;]<\/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-1890","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1890","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=1890"}],"version-history":[{"count":6,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1890\/revisions"}],"predecessor-version":[{"id":9311,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1890\/revisions\/9311"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}