{"id":1888,"date":"2014-07-11T10:26:58","date_gmt":"2014-07-11T09:26:58","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1888&lang=en"},"modified":"2020-07-30T13:50:15","modified_gmt":"2020-07-30T12:50:15","slug":"contract-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1888","title":{"rendered":"Contract"},"content":{"rendered":"

Contract:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;CompanyGroupName;CurrencyName;ContractDate;Period;NoticeTime;Immatriculation;Description;
\nInvoiceFrequency;ContractTypeName;ContractRiskName;ContractCompanyName;ContractPersonName;AgentCompanyName;
\nAgentPersonName;ClientCompanyName;ClientPersonName;InsuredCompanyName;InsuredPersonName;MaturityDate;StartDate;
\nEndDate;ExternalReference;RiskCountryName;RiskParticipation;CyInsuredValue;MaxClaimAmount;MaxClaimYearlyAmount;
\nExcessAmount;ExcessYearlyAmount<\/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. 27 is for contract<\/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>\nCompanyGroupName<\/span><\/td>\nChar(50)<\/td>\nCode of the company group\/branch<\/td>\n<\/tr>\n
4<\/td>\nCurrencyName<\/span><\/td>\nChar(10)<\/td>\nName of the currency<\/td>\n<\/tr>\n
5<\/td>\nContractDate<\/span><\/td>\nDate\/Time<\/td>\nContract date<\/td>\n<\/tr>\n
6<\/td>\nPeriod<\/span><\/td>\nInteger<\/td>\nFrequency\/duration:
\n0 = No frequency
\n13 = Weekly
\n1 = Monthly
\n3 = Quaterly
\n6 = Half-yearly
\n12 = Yearly<\/td>\n<\/tr>\n
7<\/td>\nImmatriculation<\/span><\/td>\nChar(50)<\/td>\nNot used<\/td>\n<\/tr>\n
8<\/td>\nDescription<\/span><\/td>\nMemo<\/td>\nNot used<\/td>\n<\/tr>\n
9<\/td>\nInvoiceFrequency<\/span><\/td>\nInteger<\/td>\nInvoice frequency:
\n0 = No frequency
\n13 = Weekly
\n1 = Monthly
\n3 = Quaterly
\n6 = Half-yearly
\n12 = Yearly<\/td>\n<\/tr>\n
10<\/td>\nContractTypeName<\/span><\/td>\nChar(50)<\/td>\nName of the Contract type<\/td>\n<\/tr>\n
11<\/td>\nContractRiskName<\/span><\/td>\nChar(50)<\/td>\nName of the Contract risk<\/td>\n<\/tr>\n
12<\/td>\nContractCompanyName<\/span><\/td>\nChar(75)<\/td>\nName of the Contract company<\/td>\n<\/tr>\n
13<\/td>\nContractPersonName<\/span><\/td>\nChar(75)<\/td>\nName of the Contract person<\/td>\n<\/tr>\n
14<\/td>\nAgentCompanyName<\/span><\/td>\nChar(75)<\/td>\nName of the agent for the Company<\/td>\n<\/tr>\n
15<\/td>\nAgentPersonName<\/span><\/td>\nChar(75)<\/td>\nName of the agent person<\/td>\n<\/tr>\n
16<\/td>\nClientCompanyName<\/span><\/td>\nChar(75)<\/td>\nName of the client company<\/td>\n<\/tr>\n
17<\/td>\nClientPersonName<\/span><\/td>\nChar(75)<\/td>\nName of the client person<\/td>\n<\/tr>\n
18<\/td>\nInsuredCompanyName<\/span><\/td>\nChar(75)<\/td>\nName of the insured company<\/td>\n<\/tr>\n
19<\/td>\nInsuredPersonName<\/span><\/td>\nChar(75)<\/td>\nName of the insured person<\/td>\n<\/tr>\n
20<\/td>\nMaturityDate<\/span><\/td>\nDate\/Time<\/td>\nMaturity date<\/td>\n<\/tr>\n
21<\/td>\nStartDate<\/span><\/td>\nDate\/Time<\/td>\nStart date<\/td>\n<\/tr>\n
22<\/td>\nEndDate<\/span><\/td>\nDate\/Time<\/td>\nStart date<\/td>\n<\/tr>\n
23<\/td>\nExternalReference<\/span><\/td>\nChar(50)<\/td>\nExternal reference<\/td>\n<\/tr>\n
24<\/td>\nRiskCountryName<\/span><\/td>\nChar(50)<\/td>\nName of risk country<\/td>\n<\/tr>\n
25<\/td>\nRiskParticipation<\/span><\/td>\nDouble<\/td>\n\/<\/td>\n<\/tr>\n
26<\/td>\nCyInsuredValue<\/span><\/td>\nDouble<\/td>\nInsured value in currency<\/td>\n<\/tr>\n
27<\/td>\nMaxClaimAmount<\/span><\/td>\nDouble<\/td>\nMaximum claim amount<\/td>\n<\/tr>\n
28<\/td>\nMaxClaimYearlyAmount<\/span><\/td>\nDouble<\/td>\nMaximum yearly claim amount<\/td>\n<\/tr>\n
29<\/td>\nExcessAmount<\/span><\/td>\nDouble<\/td>\nExcess amount<\/td>\n<\/tr>\n
30<\/td>\nExcessYearlyAmount<\/span><\/td>\nDouble<\/td>\nYearly excess amount<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Contract: RecordType;DBId;CompanyGroupName;CurrencyName;ContractDate;Period;NoticeTime;Immatriculation;Description; InvoiceFrequency;ContractTypeName;ContractRiskName;ContractCompanyName;ContractPersonName;AgentCompanyName; AgentPersonName;ClientCompanyName;ClientPersonName;InsuredCompanyName;InsuredPersonName;MaturityDate;StartDate; EndDate;ExternalReference;RiskCountryName;RiskParticipation;CyInsuredValue;MaxClaimAmount;MaxClaimYearlyAmount; ExcessAmount;ExcessYearlyAmount Nr Name Type Description 1 RecordType Long Type of object to import. 27 is for contract 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 CompanyGroupName Char(50) Code of the company group\/branch 4 CurrencyName Char(10) Name of the currency 5 ContractDate Date\/Time Contract date 6 […]<\/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-1888","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1888","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=1888"}],"version-history":[{"count":7,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1888\/revisions"}],"predecessor-version":[{"id":9310,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1888\/revisions\/9310"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}