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

Contract detail:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;ContractRefSubRef;ContractTypeName;StartDate;EndDate;ContractCompanyName;ContractPersonName;
\nCyNetPrime;NetPrime;CyFees;Fees;CyTax;Tax;CyTotalPrime;TotalPrime;CyReceivedCommission;ReceivedCommission;
\nCyGivenCommission;GivenCommission;GivenCommissionType;CurrencyName;InvoiceType;AcctgDate;ReceiptNumber;Type;
\nGivenCommissionPercentage;ReceivedCommissionPercentage;ReceivedCommissionType;TaxCompanyName;TaxPersonName;
\nBeneficiaryPercentage;BeneficiaryCyAmount;BeneficiaryAmount<\/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\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. 28 is for contract detail<\/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>\nContractRefSubRef<\/span><\/td>\nChar(100)<\/td>\nContract reference and sub-reference<\/td>\n<\/tr>\n
4<\/td>\nContractTypeName<\/span><\/td>\nChar(50)<\/td>\nContract type name<\/td>\n<\/tr>\n
5<\/td>\nStartDate<\/span><\/td>\nDate\/Time<\/td>\nContract start date<\/td>\n<\/tr>\n
6<\/td>\nEndDate<\/span><\/td>\nDate\/Time<\/td>\nContract end date<\/td>\n<\/tr>\n
7<\/td>\nContractCompanyName<\/span><\/td>\nChar(75)<\/td>\nContract company name<\/td>\n<\/tr>\n
8<\/td>\nCyNetPrime<\/span><\/td>\nDouble<\/td>\nNet prime in currency<\/td>\n<\/tr>\n
9<\/td>\nNetPrime<\/span><\/td>\nDouble<\/td>\nNet prime<\/td>\n<\/tr>\n
10<\/td>\nCyFees<\/span><\/td>\nDouble<\/td>\nAmount of fees in currency<\/td>\n<\/tr>\n
11<\/td>\nFees<\/span><\/td>\nDouble<\/td>\nAmount of fees<\/td>\n<\/tr>\n
12<\/td>\nCyTax<\/span><\/td>\nDouble<\/td>\nAmount of taxes in currency<\/td>\n<\/tr>\n
13<\/td>\nTax<\/span><\/td>\nDouble<\/td>\nAmount of taxes<\/td>\n<\/tr>\n
14<\/td>\nCyTotalPrime<\/span><\/td>\nDouble<\/td>\nTotal prime (net+fees+taxes) in currency<\/td>\n<\/tr>\n
15<\/td>\nTotalPrime<\/span><\/td>\nDouble<\/td>\nTotal prime (net+fees+taxes)<\/td>\n<\/tr>\n
16<\/td>\nCyReceivedCommission<\/span><\/td>\nDouble<\/td>\nReceived commission in currency<\/td>\n<\/tr>\n
17<\/td>\nReceivedCommission<\/span><\/td>\nDouble<\/td>\nReceived commission<\/td>\n<\/tr>\n
18<\/td>\nCyGivenCommission<\/span><\/td>\nDouble<\/td>\nGiven commission in currency<\/td>\n<\/tr>\n
19<\/td>\nGivenCommission<\/span><\/td>\nDouble<\/td>\nGiven commission<\/td>\n<\/tr>\n
20<\/td>\nGivenCommissionType<\/span><\/td>\nInteger<\/td>\nType of given commission:
\n1 = deducted on invoice
\n2 = received after prime payment<\/td>\n<\/tr>\n
21<\/td>\nCurrencyName<\/span><\/td>\nChar(10)<\/td>\nCurrency name<\/td>\n<\/tr>\n
22<\/td>\nInvoiceType<\/span><\/td>\nInteger<\/td>\nType of invoice:
\n0 = no invoicing
\n1 = client invoicing
\n2 = agent invoicing<\/td>\n<\/tr>\n
23<\/td>\nAcctgDate<\/span><\/td>\nDate\/Time<\/td>\n\/<\/td>\n<\/tr>\n
24<\/td>\nReceiptNumber<\/span><\/td>\nChar(25)<\/td>\nReceipt number<\/td>\n<\/tr>\n
25<\/td>\nType<\/span><\/td>\nInteger<\/td>\n\/<\/td>\n<\/tr>\n
26<\/td>\nGivenCommissionPercentage<\/span><\/td>\nDouble<\/td>\nGiven commission percentage<\/td>\n<\/tr>\n
27<\/td>\nReceivedCommissionPercentage<\/span><\/td>\nDouble<\/td>\nReceived commission percentage<\/td>\n<\/tr>\n
28<\/td>\nReceivedCommissionType<\/span><\/td>\nInteger<\/td>\nType of received commission:
\n1 = deducted on invoice
\n2 = received after prime payment<\/td>\n<\/tr>\n
29<\/td>\nTaxCompanyName<\/span><\/td>\nChar(75)<\/td>\nTax company name<\/td>\n<\/tr>\n
30<\/td>\nTaxPersonName<\/span><\/td>\nChar(75)<\/td>\nTax person name<\/td>\n<\/tr>\n
31<\/td>\nBeneficiaryPercentage<\/span><\/td>\nDouble<\/td>\nBeneficiary percentage<\/td>\n<\/tr>\n
32<\/td>\nBeneficiaryCyAmount<\/span><\/td>\nDouble<\/td>\nBeneficiary amount in currency<\/td>\n<\/tr>\n
33<\/td>\nBeneficiaryAmount<\/span><\/td>\nDouble<\/td>\nBeneficiary amount<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Contract detail: RecordType;DBId;ContractRefSubRef;ContractTypeName;StartDate;EndDate;ContractCompanyName;ContractPersonName; CyNetPrime;NetPrime;CyFees;Fees;CyTax;Tax;CyTotalPrime;TotalPrime;CyReceivedCommission;ReceivedCommission; CyGivenCommission;GivenCommission;GivenCommissionType;CurrencyName;InvoiceType;AcctgDate;ReceiptNumber;Type; GivenCommissionPercentage;ReceivedCommissionPercentage;ReceivedCommissionType;TaxCompanyName;TaxPersonName; BeneficiaryPercentage;BeneficiaryCyAmount;BeneficiaryAmount Nr Name Type Description 1 RecordType Long Type of object to import. 28 is for contract detail 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 StartDate Date\/Time Contract start date […]<\/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-1894","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1894","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=1894"}],"version-history":[{"count":6,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1894\/revisions"}],"predecessor-version":[{"id":9313,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1894\/revisions\/9313"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}