Kontaktid XML: erinevus redaktsioonide vahel
Mine navigeerimisribale
Mine otsikasti
Resümee puudub |
Resümee puudub |
||
| 187. rida: | 187. rida: | ||
| | | | ||
|- | |- | ||
|'''RemndrFlag''' | |'''RemndrFlag''' | ||
|Kas saadetakse märgukirju või ei. 0=ei, 1=jah | |Kas saadetakse märgukirju või ei. 0=ei, 1=jah | ||
|Reminders (flag) | |Reminders (flag) | ||
| 326. rida: | 326. rida: | ||
|- | |- | ||
|'''Sorting''' | |'''Sorting''' | ||
|Teekond. Määratakse kontakti kaardil, kantakse uutele tootmise ja logistika kaartidele. | |Teekond. Määratakse kontakti kaardil, kantakse uutele tootmise ja logistika kaartidele. | ||
|Sorting | |Sorting | ||
|''20, string'' | |''20, string'' | ||
| 368. rida: | 368. rida: | ||
|- | |- | ||
|'''EDIFlag''' | |'''EDIFlag''' | ||
|EDI Klient linnuke. 0 = ei ole, 1 = on. | |EDI Klient linnuke. 0 = ei ole, 1 = on. | ||
|EDI customer (flag) | |EDI customer (flag) | ||
|''0, flag'' | |''0, flag'' | ||
| 446. rida: | 446. rida: | ||
|- | |- | ||
|'''EGOFlag''' | |'''EGOFlag''' | ||
|EGO Klient. 0 = ei ole. 1 = on. | |EGO Klient. 0 = ei ole. 1 = on. | ||
|EGO customer | |EGO customer | ||
|''0, flag'' | |''0, flag'' | ||
| 512. rida: | 512. rida: | ||
|- | |- | ||
|'''WebDisplays''' | |'''WebDisplays''' | ||
|Näita Veebis kood. Veebi esituse kood. | |Näita Veebis kood. Veebi esituse kood. | ||
|Web Display code | |Web Display code | ||
|''5, code'' | |''5, code'' | ||
| 519. rida: | 519. rida: | ||
|'''Mobile''' | |'''Mobile''' | ||
|Mobiiltelefoni number | |Mobiiltelefoni number | ||
|Mobile | |Mobile | ||
|''20, string'' | |''20, string'' | ||
| | | | ||
| 685. rida: | 685. rida: | ||
| | | | ||
|- | |- | ||
|'''VEShipMode''' | |'''VEShipMode''' | ||
|Ostu lähetusviis | |Ostu lähetusviis | ||
|Purch. Ship Mode | |Purch. Ship Mode | ||
| 878. rida: | 878. rida: | ||
|- | |- | ||
|'''SIPCode''' | |'''SIPCode''' | ||
|SIP | |SIP | ||
|SIP | |SIP | ||
|''60, string'' | |''60, string'' | ||
| 1422. rida: | 1422. rida: | ||
<WarnText1/> | <WarnText1/> | ||
<InvAddr0/> | <InvAddr0/> | ||
<InvAddr1/> | <InvAddr1/> | ||
<InvAddr2/> | <InvAddr2/> | ||
<InvoiceToCode/> | <InvoiceToCode/> | ||
Redaktsioon: 5. juuni 2020, kell 09:01
| Kood | Kirjeldus | Description in ENG | Pikkus, tüüp | Kohustuslik / Mandatory |
|---|---|---|---|---|
| Code | Kontakti kood HansaWorldi tarkvaras. Unikaalne per kontakt | Contact code | 20, code | Yes (Auto = last code +1) |
| Name | Kontakti nimi | Contact name | 200, string | Yes (Manual, at least 1 character) |
| Person | Peamine kontaktisik | Primary contact | 60, string | |
| WarnText1 | Hoiatus müügil. Kuvatakse ekraanile Arve või tellimuse tegemisel | Waring on Sales | 255, string | |
| InvAddr0 | Arve aadressi esimene rida (NB: jälgida numeratsiooni!). | Invoice address line 1 | 60, string | Highly recommended |
| InvAddr1 | Arve aadressi teine rida | Invoice address line 2 | 60, string | |
| InvAddr2 | Arve aadressi kolmas rida | Invoice address line 3 | 60, string | |
| InvAddr3 | Arve aadressi neljas rida | Invoice address line 4 | 60, string | |
| InvAddr4 | Arve aadressi viies rida | Invoice address line 5 | 60, string | |
| InvoiceToCode | Arve saaja kontakti kood. Peab andmebaasis eksisteerima, mõni muu klient | Invoce to | 20, code | |
| DelAddr0 | Lähetusaadressi esimene rida. (NB: jälgida numeratsiooni!) | Delivery address line 1 | 60, string | |
| DelAddr1 | Lähetusaadressi teine rida | Delivery address line 2 | 60, string | |
| DelAddr2 | Lähetusaadressi kolmas rida | Delivery address line 3 | 60, string | |
| DelAddr3 | Lähetusaadressi neljas rida | Delivery address line 4 | 60, string | |
| DelAddr4 | Lähetusaadressi viies rida | Delivery address line 5 | 60, string | |
| Phone | Kontakti telefoninumber | Telephone number | 20, string | |
| Fax | Kontakti faksi number | Fax number | 20, string | |
| CustCat | Kliendiklass. Vastava koodiga kaart peab eksisteerima | Customer category | 5, code | |
| Comment | kommentaar. Informatiivse sisuga väli, mida saab täita kliendi kaardil. EI kuvata arvetel ega muudel dokumentidel | Comment | 60, string | |
| PayDeal | Vaikimisi müügi tasumistingimus. Kasutatakse vaikimisi väärtusena näiteks arvetel ja tellimustel. Kood peab eksisteerima. (Näiteks: 1, 7, 14 jne) | Sales ppay terms | 2, code | |
| ExportFlag | Käibemaksutsoon
0 = „Eesti“ 1 = „EL“, 2 = „EL (konteeri KM)“, 3 = „Mitte EL“ 4 = „Mitte EL (konteeri KM) |
VAT zone
0 = „Domestic“ 1 = „Inside EU“, 2 = „Inside EU (Post VAT)“, 3 = „Outside EU“ 4 = „Outside EU (Post VAT) |
1, code | Highly recommended, default = 0 |
| AccFlag | N/A | N/A | 0, flag | |
| Objects | Kontakti objektid. Kantakse ka arvete, ostuarvete ja muude dokumentide päisesse | Objects | 60, Capital Characters Only | |
| InterestFlag | Viivis. Kas arvutatakse või ei. 0=ei, 1=jah | Interest flag | 0, flag | |
| VATNr | Käibemaksukohuslase number (KMKR) | VAT Reg no | 20, string | |
| CountryCode | Kahekohaline riigi kood (EE, LV, LT, RU, FI jne) | Country code (2 letter format) | 2, code | Highly recommended |
| SearchKey | Lühikood kontakti otsimise kergendamiseks. | Short (code) | 10, Capital Characters Only | |
| RemndrFlag | Kas saadetakse märgukirju või ei. 0=ei, 1=jah | Reminders (flag) | 0, flag | |
| LangCode | Keele kood. Keele kood kantakse edasi dokumentidele (EST, ENG, RUS jne) | Language (code) | 5, code | |
| CurrncyCode | Müügivaluuta kood. Kantakse edasi dokumentidele. EUR, RUB, USD jne | Currency (code) | 5, code | |
| OnAccount | Ettemaks. Kas lubatakse koostada ettemakse või ei. 0=ei, 1=jah | On account (flag) | 0, flag | |
| SalesMan | Müügimehe kood. HansaWorldi tarkvara kasutajanimi | Salesman (person code) | 10, code | |
| CreditLimit | Krediidilimiit müügil. Mis summa eest tohib Klient korraga võlgu olla. (Näiteks „10000,00“) | Sales credit limit | 0, Value 2 or 3 Decimals | |
| ShipDeal | Lähetustingimus (Näiteks CFR, CIF, DDU, DDP jne). | Sales Del. terms | 5, code | |
| ShipMode | Lähetusiviis (Näiteks 16 - Mootorsõiduk merelaeval, 23 – Sõiduk raudteevagunil jne) | Sales Del. modes | 5, code | |
| VATCode | Käibemaksukood. (Näiteks 1 – 20% müügil, 2 – käibemaksuta jne) | Sales VAT code | 10, code | |
| Department | Osakond. Kasutatakse enamasti kontaktisiku staatuse täpsustuseks | Department | 60, string | |
| OrderComment | Tellimuse kommentaar. Kantakse sellele kontaktile loodud tellimusele | Order comment | 60, string | |
| FreightNr | Transpordi number | Freight No. | 20, string | |
| PLCode | Hinnakirja kood | Price List (code) | 5, code | |
| RebCode | Hinnaalandusmaatriksi kood | Discount matrix (code) | 5, code | |
| Classification | Klassifikaatorid kontaktil | Classification | 200, Comma separated List | |
| blockedFlag | Suletud linnuke. 0 = ei ole. 1 = kontakt on suletud | Closed (flag) | 0, flag | |
| DateChanged | Kontaktikaardi muutmise kuupäev. Näiteks „12.09.2014“ | Last changed date | 0, In Dataformat Order | |
| AccOperator | Pangakood | Bank code | 60, string | |
| SecAccount | N/A | N/A | 20, code | |
| BankAccount | Pangaarve number lahtrist „A/a | IBAN“ | Bank account (IBAN) | 60, string | |
| JobDesc | Ametinimetus. Kasutatakse enamasti kontaktisiku staatuse täpsustuseks | Job description | 60, string | |
| CustType | Kontakti tüüp. 0 = Ettevõte. 1 = Eraisik | Contact type. 0=Company; 1=Person) | 0, flag | |
| ComCode | N/A | N/A | 5, code | |
| Sorting | Teekond. Määratakse kontakti kaardil, kantakse uutele tootmise ja logistika kaartidele. | Sorting | 20, string | |
| RegNr1 | Registreerimisnumber 1. Eestis Äriregistri kood | Reg no. 1 | 20, string | |
| RegNr2 | Registreerimisnumber 2 | Reg no. 2 | 20, string | |
| CPRNr | N/A | N/A | 20, string | |
| wwwAddr | Veebileht | Web Site | 60, string | |
| CompItemCode | Vaikimis artikkel | Default Items | 10, string | |
| ANACode | N/A | N/A | 60, string | |
| EDIFlag | EDI Klient linnuke. 0 = ei ole, 1 = on. | EDI customer (flag) | 0, flag | |
| e-maili aadress | 100, string | |||
| IntRate | Viivise protsent | Interest rate | 0, Value 2 or 3 Decimals | |
| TheirCode | Nende Tarnija Kood | Their Customer Code | 60, string | |
| PriceBasedOn | Hind Põhineb: 0 = Tellimuse kp; 1= Planeeritud lähetuse kp; 2 = Saatmise kp | Price based on
(0=order date; 1=Planned del. date; 2= Dispatch date) |
0, flag | |
| DeliveryBasedOn | Lähetuse kp Põhineb: 0 = hetke kp; 1 = Planeeritud lähetuse kp | Delivery Date Based On
(0=Current date; 1= Planned Delivert Date) |
0, flag | |
| SalesGroup | Müügigrupp | Sales Group | 5, code | |
| SortCode | Sorting | Sorting | 10, string | |
| AllowLogin | Sisenemine lubatud (HansaWorldi veebikeskkonda). 0 = ei; 1= jah | Allow Login (Standard Books Web-page) | 0, flag | |
| Password | Kasutab salasõna. 0 = ei, 1 = jah | Customer password (for Standard Books Web-page | 0, flag | |
| FTPLogin | FTP sisenemine lubatud. 0 = ei, 1 = jah | FTP login allowed | 0, flag | |
| DateCreated | Kontakti loomis kuupäev | Contact card creation date | 0, In Dataformat Order | |
| EGOFlag | EGO Klient. 0 = ei ole. 1 = on. | EGO customer | 0, flag | |
| xArea | N/A | N/A | 20, string | |
| xAreaName | N/A | N/A | 60, string | |
| WebConf | Veebikonverents | Web Conference code | 20, code | |
| WebStartPage | Veebi alglehekülg | Web front page | 60, string | |
| FreightCode | Transpordi kood | Freight code | 5, code | |
| MainDispGroup | Peaklassifikaator | Parent Product Category | 5, code | |
| AutoGiro | N/A | N/A | 0, flag | |
| OnHoldFlag | Ootel linnuke. 0 = ei ole Ootel. 1 = on ootel | On hold | 0, flag | |
| ColectionFlag | Kogumisega linnuke. Eestis ei kasutata | Collection flag (N/A) | 0, flag | |
| LocationCode | N/A | N/A | 10, string | |
| WebDisplays | Näita Veebis kood. Veebi esituse kood. | Web Display code | 5, code | |
| Mobile | Mobiiltelefoni number | Mobile | 20, string | |
| NoLetterPosting | Ära Koosta Masskirju linnuke | No Mass Letters | 0, flag | |
| FiscalFlag | Ainult Fiskaalarved linnuke | Fiscal Invoices Only | 0, flag | |
| UserStr1 | Omakirjeldatud tekst 1 | Text 1 | 255, string | |
| UserStr2 | Omakirjeldatud tekst 2 | Text 2 | 255, string | |
| UserStr3 | Omakirjeldatud tekst 3 | Text 3 | 255, string | |
| UserStr4 | Omakirjeldatud tekst 4 | Text 4 | 255, string | |
| UserStr5 | Omakirjeldatud tekst 5 | Text 5 | 255, string | |
| UserVal1 | Omakirjeldatud väärtus 1 | Value 1 | Value with minimum Decimals | |
| UserVal2 | Omakirjeldatud väärtus 2 | Value 2 | Value with minimum Decimals | |
| UserVal3 | Omakirjeldatud väärtus 3 | Value 3 | Value with minimum Decimals | |
| UserDate1 | Omakirjeldatud kuupäev 1 | Date 1 | In Dataformat Order | |
| UserDate2 | Omakirjeldatud kuupäev 2 | Date 2 | In Dataformat Order | |
| UserDate3 | Omakirjeldatud kuupäev 3 | Date 3 | In Dataformat Order | |
| AccAP | Ostuvõlakonto. Finantskonto | Creditor AC | 10, code | |
| AccCost | Kulukonto. Finantskonto | Cost AC | 10, code | |
| Bank | Pangaarve number lahtrist „A/a | IBAN 2“ | Bank Account 2 | 60, string | |
| OnAccAccAP | Ostu ettemaksukonto | Cred. On Acc. AC | 10, code | |
| MinOrdSum | Min. tell. summa | Min order sum | 0, Value 2 or 3 Decimals | |
| PurchAcc | N/A | N/A | 10, code | |
| RefStr | Ostu viide | (Purchase) Reference | 60, string | |
| WithPayMode | N/A | N/A | 20, Capital Characters Only | |
| RetainPrc | N/A | N/A | 20, string | |
| NoMailPosting | Ära koosta massmaile linnuke | No Mass Emailing | 0, flag | |
| VEType | Hankija linnuke. 0 = ei ole; 1 = on | Supplier flag | 0, flag | |
| CUType | Kliendi linnuke. 0 = ei ole; 1 = on | Customer flag | 0, flag | |
| VEPayDeal | Ostu tasumistingimus | Purch. Pay. Terms | 2, code | |
| VEShipDeal | Ostu lähetustingimus | Purch. Ship Term | 5, code | |
| VEShipMode | Ostu lähetusviis | Purch. Ship Mode | 5, code | |
| VECreditLimit | Ostu krediidilimiit | Purch. credit limit | Value 2 or 3 Decimals | |
| VEObjects | Ostu objektid | Purch. Objects | 60, Capital Characters Only | |
| VEWarnText1 | Hoiatus ostul | Purch. Warning | 255, string | |
| VEFactoring | Faktooring (hankija kood, kellele arve makstakse) | Purch. Factoring | 20, code | |
| VECurrncyCode | Ostu valuuta | Purch. Currency | 5, code | |
| VECustID | Nende kliendikood | Their customer code | 20, string | |
| VEVATCode | Ostu KM kood | Purch. VAT code | 10, code | |
| NoFactoringFlag | Faktooringuta linnuke | No Factoring | 0, flag | |
| NoRepa | N/A | N/A | 0, flag | |
| VECat | Tarnijaklass | Supplier Category | 5, code | |
| IBANCode | Pangaarve number lahtrist „IBAN Kood“ | IBAN code | 60, Capital Characters Only | |
| EInvAddr | N/A | N/A | 60, Capital Characters Only | |
| EInvFunc | N/A | N/A | 0, flag | |
| xAcceptanceGroup | N/A | N/A | 20, string | |
| WebServiceChannel | N/A | N/A | 120, Int represented by a Set of String | |
| SkypeName | Skype kasutajanimi | Skype username | 60, string | |
| Region | Regioon | Region | 20, code | |
| NoTax1 | Lisamaksuta linnuke | No extra tax | 0, flag | |
| NoTax2 | Region. lisamaksudeta linnuke | No region Preceptions | 0, flag | |
| GuestType | N/A | N/A | 0, flag | |
| PassportNr | ID (dokumendi) | ID (Document) | 20, string | |
| Profesion | Amet | Profession | 60, string | |
| Nationality | Rahvus | Nationality | 20, string | |
| BirthDate | Sünnipäev | Birthday | 0, In Dataformat Order | |
| Gender | Sugu | gender | 0, flag | |
| Newspaper | Ajaleht | Newspaper | 10, code | |
| Smoking | Suitsetaja | Smoker | 0, flag | |
| DocType | Dok tüüp | Doc Type | 20, string | |
| Blacklist | Blacklisted | Mustas nimekirjas | 0, flag | |
| MarStatus | Perekonnaseis | Marital Status | 0, flag | |
| Passphrase | Salasõna | Passphrase | 20, string | |
| SIPCode | SIP | SIP | 60, string | |
| AltPhone | Muu telefon | Alt Phone | 20, string | |
| Comment0 | Kommentaari rida 1 vahelehelt Komm. | Comment line 1 | 60, string | |
| Comment1 | Kommentaari rida 2 vahelehelt Komm. | Comment line 2 | 60, string | |
| Comment2 | Kommentaari rida 3 vahelehelt Komm. | Comment line 3 | 60, string | |
| Title | Viisakustiitel | Courtesy Title | 60, string | |
| Salutation1 | Tervitus 1 | Salutation 1 | 60, string | |
| Salutation2 | Tervitus 2 | Salutation 2 | 60, string | |
| Salutation3 | Tervitus 3 | Salutation 3 | 60, string | |
| xUserCode | N/A | N/A | Empty Field | |
| DealerType | N/A | N/A | 0, flag | |
| GroupInv | N/A | N/A | 0, flag | |
| AddressBooks | Aadressiraamatud | Address Books | 255, Capital Characters Only | |
| Extension | Lühikood vahelehelt Kontakt, mitte päisest | Extension | 20, string | |
| TourOperator | N/A | N/A | 20, string | |
| Agent | Agent | Agent | 20, string | |
| DietRemarks | Toitlustus | Diet remarks | 60, string | |
| RequirementRemarks | Nõudmised | Req remarks | 60, string | |
| AgeStatus | N/A | 0, flag | ||
| Age | N/A | 0, Value with No Decimals | ||
| DefGuestPayMode | Vaikimisi tasumisviis | Def Pay Mode | 2, Capital Characters Only | |
| BookOrigin | Vaikimisi Res. päritolu | Def Booking Org | 20, code | |
| TaxTemplateCode | N/A | N/A | 10, code | |
| VETaxTemplateCode | N/A | N/A | 10, code | |
| EmployeeType | N/A | N/A | 0, flag | |
| Ethnicity | Sünniriik | Country of Birth | 100, string | |
| BirthPlace | Sünnikoht | Place of Birth | 100, string | |
| IDNr | N/A | N/A | 60, string | |
| VisaType | N/A | N/A | 30, string | |
| VisaNr | N/A | N/A | 100, string | |
| VisaExpiry | N/A | N/A | 0, In Dataformat Order | |
| MilitaryDocNr | N/A | N/A | 60, string | |
| SocialSecurityNr | N/A | N/A | 100, string | |
| DisabledStatus | N/A | N/A | 0, flag | |
| Disability | N/A | N/A | 60, string | |
| HealthStatus | N/A | N/A | 60, string | |
| HealthIssues | N/A | N/A | 200, string | |
| DriverLicenceCategory | N/A | N/A | 100, string | |
| SchoolName | N/A | N/A | 100, string | |
| EducationalDegree | N/A | N/A | 60, string | |
| EducationalMajor | N/A | N/A | 60, string | |
| EducationStatus | N/A | N/A | 0, flag | |
| PreviousEmployer | N/A | N/A | 60, string | |
| PreviousJobTitle | N/A | N/A | 60, string | |
| Birthday | N/A | N/A | 5, string | |
| VERebCode | Hankija hinnaalandusmaatriks | Supp Disc. Matrix | 5, code | |
| SelfBilling | Isearveldamine linnuke | Self Billing Customer | 0, flag | |
| DelCountry | Riik (2-kohaline kood, EE, LV, FI jne) | Country (Delivery) | 5, code | |
| VEInvoiceToCode | Arve saaja | Purch invoice from | 20, string | |
| MainPartner | Peamine partner | Main Partner | 20, string | |
| CreditLimitDays | Müügi krediidilimiit, päevade arv | Sales credit limit, days | 0, Value with No Decimals | |
| VECreditLimitDays | Ostu krediidilimiit, päevade arv | Purchase credit limit, days | 0, Value with No Decimals | |
| FTax | N/A | N/A | 0, Small Value with No Decimals | |
| SuframaRegNr | N/A | N/A | 9, string | |
| DefMarkup | N/A | N/A | 10, dummy | |
| InvCountryName | Arve riigi nimi (võetakse Ettevõtte andmetest) | Shipment Country Code | 100, string | |
| DelCountryName | Lähetusriigi nimi (võetakse Ettevõtte andmetest) | Shipment Country Name | 100, string | |
| PaymentCode | Tasumise kood | Payment code | 5, code | |
| MarketUserName | N/A | N/A | 60, string | |
| RemoteBackupsPassword | N/A | N/A | 40, string | |
| RemoteBackupsAddress | N/A | N/A | 255, string | |
| RemoteBackupsPort | N/A | N/A | 0, Small Value with No Decimals | |
| BirthCountry | N/A | N/A | 100, string | |
| LegalForm | N/A | N/A | 10, code | |
| VATNrCheckDate | KMKR kontrolli kp. | N/A | 0, In Dataformat Order | |
| QQName | N/A | N/A | 20, string | |
| WeiboName | N/A | N/A | 20, string | |
| RecipientGLN | GLN väärtus | GLN | 20, string | |
| IPBookVAT | N/A | N/A | 0, flag | |
| OPBookVAT | N/A | N/A | 0, flag | |
| BillingTypePreference | N/A | N/A | 578, Int represented by a Set of String | |
| TaxCondition | N/A | N/A | 0, flag | |
| RecBillCustID | N/A | N/A | 200, string | |
| NameinDocument | N/A | N/A | 200, string | |
| LeadType | Vihje linnuke | Lead | 0, flag | |
| Rating | N/A | N/A | 0, Small Value with No Decimals | |
| Partner | N/A | N/A | 20, code | |
| PartnerName | N/A | N/A | 200, string | |
| Source | N/A | N/A | 10, code | |
| SourceComment | N/A | N/A | 60, string | |
| Industry | N/A | N/A | 10, code | |
| IndustryComment | N/A | N/A | 60, string | |
| Status | N/A | N/A | 10, code | |
| StatusComment | N/A | N/A | 60, string | |
| Value | N/A | N/A | 0, Value 2 or 3 Decimals | |
| ItemClassification | N/A | N/A | 10, code | |
| ItemClassificationName | N/A | N/A | 60, string | |
| Sign | N/A | N/A | 10, code | |
| ModifiedSign | Viimati kontaktikaarti muutnud kasutaja | Last user, who changed this contact record | 10, code |
XML näidis
<data register="CUVc" sequence="271742" systemversion="8.4.20.1204">
<CUVc>
<UUID>EB62BDDB-166D1436-771C5803-96D9E8CF-3D9B4352</UUID>
<ServerSequence>0</ServerSequence>
<SyncFlags>1</SyncFlags>
<Code>1</Code>
<Name>Annika Ainus</Name>
<Person/>
<WarnText1/>
<InvAddr0/>
<InvAddr1/>
<InvAddr2/>
<InvoiceToCode/>
<DelAddr0/>
<DelAddr1/>
<DelAddr2/>
<Phone/>
<Fax/>
<CustCat/>
<Comment/>
<PayDeal/>
<ExportFlag>0</ExportFlag>
<AccFlag>0</AccFlag>
<Objects/>
<InterestFlag>1</InterestFlag>
<VATNr/>
<CountryCode/>
<SearchKey/>
<RemndrFlag>1</RemndrFlag>
<LangCode/>
<CurncyCode/>
<OnAccount>0</OnAccount>
<SalesMan/>
<CreditLimit>0.00</CreditLimit>
<ShipDeal/>
<ShipMode/>
<VATCode/>
<Department/>
<OrderComment/>
<FreightNr/>
<PLCode/>
<RebCode/>
<Classification/>
<blockedFlag>0</blockedFlag>
<DateChanged>2017-12-19</DateChanged>
<AccOperator/>
<SecAccount/>
<BankAccount/>
<JobDesc/>
<CustType>0</CustType>
<ComCode/>
<Sorting/>
<RegNr1/>
<RegNr2/>
<CPRNr/>
<wwwAddr/>
<CompItemCode/>
<ANACode/>
<EDIFlag>0</EDIFlag>
<eMail>sven@excellent.ee</eMail>
<IntRate/>
<TheirCode/>
<PriceBasedOn>0</PriceBasedOn>
<DeliveryBasedOn>0</DeliveryBasedOn>
<SalesGroup/>
<SortCode/>
<AllowLogin>0</AllowLogin>
<Password>0</Password>
<FTPLogin>0</FTPLogin>
<DateCreated>2015-02-02</DateCreated>
<EGOFlag>0</EGOFlag>
<InvAddr3/>
<DelAddr3/>
<xArea/>
<xAreaName/>
<InvAddr4/>
<DelAddr4/>
<WebConf/>
<WebStartPage/>
<FreightCode/>
<MainDispGroup/>
<AutoGiro>0</AutoGiro>
<OnHoldFlag>0</OnHoldFlag>
<ColectionFlag>0</ColectionFlag>
<LocationCode/>
<WebDisplays/>
<Mobile/>
<NoLetterPosting>0</NoLetterPosting>
<FiscalFlag>0</FiscalFlag>
<UserStr1/>
<UserStr2/>
<UserStr3/>
<UserStr4/>
<UserStr5/>
<UserVal1/>
<UserVal2/>
<UserVal3/>
<UserDate1/>
<UserDate2/>
<UserDate3/>
<AccAP/>
<AccCost/>
<Bank/>
<OnAccAccAP/>
<MinOrdSum/>
<PurchAcc/>
<RefStr/>
<WithPayMode/>
<RetainPrc/>
<NoMailPosting>0</NoMailPosting>
<VEType>0</VEType>
<CUType>0</CUType>
<VEPayDeal/>
<VEShipDeal/>
<VEShipMode/>
<VECreditLimit/>
<VEObjects/>
<VEWarnText1/>
<VEFactoring/>
<VECurncyCode/>
<VECustID/>
<VEVATCode/>
<NoFactoringFlag>0</NoFactoringFlag>
<NoRepa>0</NoRepa>
<VECat/>
<IBANCode/>
<xEInvAddr/>
<xEInvFunc>0</xEInvFunc>
<xAcceptanceGroup/>
<WebServiceChannel>-</WebServiceChannel>
<SkypeName/>
<Region/>
<NoTax1>0</NoTax1>
<NoTax2>0</NoTax2>
<GuestType>0</GuestType>
<PassportNr/>
<Profesion/>
<Nationality/>
<BirthDate/>
<Gender>0</Gender>
<Newspaper/>
<Smoking>0</Smoking>
<DocType/>
<Blacklist>0</Blacklist>
<MarStatus>0</MarStatus>
<Passphrase/>
<SIPCode/>
<AltPhone/>
<Comment0/>
<Comment1/>
<Comment2/>
<Title/>
<Salutation1/>
<Salutation2/>
<Salutation3/>
<xUserCode/>
<DealerType>0</DealerType>
<GroupInv>0</GroupInv>
<AddressBooks/>
<Extension/>
<TourOperator/>
<Agent/>
<DietRemarks/>
<RequirementRemarks/>
<AgeStatus>0</AgeStatus>
<Age/>
<DefGuestPayMode/>
<BookOrigin/>
<TaxTemplateCode/>
<VETaxTemplateCode/>
<EmployeeType>0</EmployeeType>
<Ethnicity/>
<BirthPlace/>
<IDNr/>
<VisaType/>
<VisaNr/>
<VisaExpiry/>
<MilitaryDocNr/>
<SocialSecurityNr/>
<DisabledStatus>0</DisabledStatus>
<Disability/>
<HealthStatus/>
<HealthIssues/>
<DriverLicenceCategory/>
<SchoolName/>
<EducationalDegree/>
<EducationalMajor/>
<EducationStatus>0</EducationStatus>
<PreviousEmployer/>
<PreviousJobTitle/>
<Birthday/>
<VERebCode/>
<SelfBilling>0</SelfBilling>
<DelCountry/>
<VEInvoiceToCode/>
<MainPartner/>
<CreditLimitDays/>
<VECreditLimitDays/>
<BusinessEntity>0</BusinessEntity>
<SuframaRegNr/>
<DefMarkup/>
<InvCountryName/>
<DelCountryName/>
<PaymentCode/>
<MarketUserName/>
<RemoteBackupsPassword/>
<RemoteBackupsAddress/>
<RemoteBackupsPort>0</RemoteBackupsPort>
<BirthCountry/>
<LegalForm/>
<VATNrCheckDate/>
<QQName/>
<WeiboName/>
<RecipientGLN/>
<IPBookVAT>0</IPBookVAT>
<OPBookVAT>0</OPBookVAT>
<BillingTypePreference>Not Decided</BillingTypePreference>
<Math2/>
<TaxCondition>0</TaxCondition>
<RecBillCustID/>
<NameinDocument/>
<LeadType>0</LeadType>
<Rating>0</Rating>
<Partner/>
<PartnerName/>
<Source/>
<SourceComment/>
<Industry/>
<IndustryComment/>
<Status/>
<StatusComment/>
<Value/>
<ItemClassification/>
<ItemClassificationName/>
<Sign/>
<ModifiedSign>KAUPO</ModifiedSign>
<CountryVATNr/>
<WebOTCode/>
<eInvAlternativeAccount/>
<eInvRcvPref>0</eInvRcvPref>
<eInvAltRcvPref>0</eInvAltRcvPref>
<eInvStop>0</eInvStop>
<eInvPostage>0</eInvPostage>
<eInvAttachPDF>0</eInvAttachPDF>
<eInvShortNote>0</eInvShortNote>
<eInvRcvToCompanyCode/>
<ePORcvPref>0</ePORcvPref>
<ePORcvToCompanyCode/>
<BranchType>0</BranchType>
<RvrsVAT>0</RvrsVAT>
<BusinessNature/>
<TaxExemption/>
<ChemicalStorageApproved>0</ChemicalStorageApproved>
</CUVc>