{"id":1877,"date":"2014-07-11T10:23:29","date_gmt":"2014-07-11T09:23:29","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1877&lang=en"},"modified":"2022-07-28T12:16:43","modified_gmt":"2022-07-28T11:16:43","slug":"client-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1877","title":{"rendered":"Client"},"content":{"rendered":"

CLIENT:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;CompanyName;PersonName;Prospect;StartDate;EndDate;FileNumber;DivisionName;RiskValue;DefGLAccountNumber;
\nDefCurrencyName;DefReminderMaturity;DefEndOfMonth;DefVATCode;DefVATRate;Status;ClientTypeName;InvoiceType;
\nReceivedCommissionType;GivenCommissionType<\/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
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 44 is for client<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase ID in DeMaSy.<\/td>\n<\/tr>\n
3<\/td>\nCompanyName<\/span><\/td>\nChar(75)<\/td>\nCompany Name is client is a company.<\/td>\n<\/tr>\n
4<\/td>\nPersonName<\/span><\/td>\nChar(75)<\/td>\nPerson Name is client is a person.<\/td>\n<\/tr>\n
5<\/td>\nProspect<\/span><\/td>\nBoolean<\/td>\n0 = client \/ -1 = prospect<\/td>\n<\/tr>\n
6<\/td>\nStartDate<\/span><\/td>\nDate\/Time<\/td>\nStart date (YYYYMMDD)<\/td>\n<\/tr>\n
7<\/td>\nEndDate<\/span><\/td>\nDate\/Time<\/td>\nEnd date (YYYYMMDD)<\/td>\n<\/tr>\n
8<\/td>\nFileNumber<\/span><\/td>\nLong<\/td>\nUnique Client number<\/td>\n<\/tr>\n
9<\/td>\nDivisionName<\/span><\/td>\nChar(50)<\/td>\nDivision name<\/td>\n<\/tr>\n
10<\/td>\nRiskValue<\/span><\/td>\nInteger<\/td>\nClient risk value<\/td>\n<\/tr>\n
11<\/td>\nDefGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nDefault General Ledger Account number for postings<\/td>\n<\/tr>\n
12<\/td>\nDefCurrencyName<\/span><\/td>\nChar(10)<\/td>\nDefault invoices currency (ISO code)<\/td>\n<\/tr>\n
13<\/td>\nDefReminderMaturity<\/span><\/td>\nInteger<\/td>\nPayment terms (number of days)<\/td>\n<\/tr>\n
14<\/td>\nDefEndOfMonth<\/span><\/td>\nBoolean<\/td>\nPayment terms:
\n0 = number of days \/ -1 = end of month<\/td>\n<\/tr>\n
15<\/td>\nDefVATCode<\/span><\/td>\nChar(20)<\/td>\nDefault VAT Code<\/td>\n<\/tr>\n
16<\/td>\nDefVATRate<\/span><\/td>\nDouble<\/td>\nDefault VAT Rate<\/td>\n<\/tr>\n
17<\/td>\nStatus<\/span><\/td>\nChar(255)<\/td>\nClient status<\/td>\n<\/tr>\n
18<\/td>\nClientTypeName<\/span><\/td>\nChar(50)<\/td>\nClient type<\/td>\n<\/tr>\n
19<\/td>\nInvoiceType<\/span><\/td>\nInteger<\/td>\nN\/A (for reinsurance)<\/td>\n<\/tr>\n
20<\/td>\nReceivedCommissionType<\/span><\/td>\nInteger<\/td>\nN\/A (for reinsurance)<\/td>\n<\/tr>\n
21<\/td>\nGivenCommissionType<\/span><\/td>\nInteger<\/td>\nN\/A (for reinsurance)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

CLIENT: RecordType;DBId;CompanyName;PersonName;Prospect;StartDate;EndDate;FileNumber;DivisionName;RiskValue;DefGLAccountNumber; DefCurrencyName;DefReminderMaturity;DefEndOfMonth;DefVATCode;DefVATRate;Status;ClientTypeName;InvoiceType; ReceivedCommissionType;GivenCommissionType Nr Name Type Description 1 RecordType Long Type of object to import. 44 is for client 2 DBId Long Database ID in DeMaSy. 3 CompanyName Char(75) Company Name is client is a company. 4 PersonName Char(75) Person Name is client is a person. 5 Prospect Boolean 0 = client \/ -1 […]<\/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-1877","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1877","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=1877"}],"version-history":[{"count":4,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1877\/revisions"}],"predecessor-version":[{"id":11814,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1877\/revisions\/11814"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}