Kunden + Ansprechpartner

SELECT NVL(kdanspre.timestamp,kunden.kkundnr) as index, kunden.kundnr as kundennr,NVL(alltrim(kdanspre.vorname)+IIF(!EMPTY(alltrim(kdanspre.vorname))," ","")+alltrim(kdanspre.name),kunden.kurzbez) as AName,NVL(kdanspre.name,'') as Nachname,NVL(kdanspre.vorname,'') as vorname,NVL(kdanspre.position,'') as position,kunden.kurzbez,kunden.strasse,kunden.plz,kunden.ort,kunden.land_lang,NVL(kdanspre.abteilung,'') as abteilung,NVL(kdanspre.telefon,'') as telefon1,kunden.telefon1 as telefon2,NVL(kdanspre.ptelefon,'') as telefonPriv,NVL(kdanspre.handy,'') as handy,NVL(kdanspre.phandy,'') as handyPriv,NVL(kdanspre.email,'') as email,NVL(kunden.inet1,'') as inet1 from mksdata!kunden LEFT JOIN mksdata!kdanspre ON kunden.kundnr=kdanspre.kundnr

Lieferanten + Ansprechpartner

SELECT NVL(lfanspre.timestamp,liefer.kkundnr) as index, liefer.kundnr as liefernr,NVL(alltrim(lfanspre.vorname)+IIF(!EMPTY(alltrim(lfanspre.vorname))," ","")+alltrim(lfanspre.name),liefer.kurzbez) as AName,NVL(lfanspre.name,'') as Nachname,NVL(lfanspre.vorname,'') as vorname,NVL(lfanspre.position,'') as position,liefer.kurzbez,liefer.strasse,liefer.plz,liefer.ort,liefer.land_lang,NVL(lfanspre.abteilung,'') as abteilung,NVL(lfanspre.telefon,'') as telefon1,liefer.telefon1 as telefon2,NVL(lfanspre.ptelefon,'') as telefonPriv,NVL(lfanspre.handy,'') as handy,NVL(lfanspre.phandy,'') as handyPriv,NVL(lfanspre.email,'') as email,NVL(liefer.inet1,'') as inet1 from mksdata!liefer LEFT JOIN mksdata!lfanspre ON liefer.kundnr=lfanspre.kundnr

Interessenten + Ansprechpartner

SELECT NVL(inanspre.timestamp,inter.kkundnr) as index, inter.kundnr as kundennr,NVL(alltrim(inanspre.vorname)+IIF(!EMPTY(alltrim(inanspre.vorname))," ","")+alltrim(inanspre.name),inter.kurzbez) as AName,NVL(inanspre.name,'') as Nachname,NVL(inanspre.vorname,'') as vorname,NVL(inanspre.position,'') as position,inter.kurzbez,inter.strasse,inter.plz,inter.ort,inter.land_lang,NVL(inanspre.abteilung,'') as abteilung,NVL(inanspre.telefon,'') as telefon1,inter.telefon1 as telefon2,NVL(inanspre.ptelefon,'') as telefonPriv,NVL(inanspre.handy,'') as handy,NVL(inanspre.phandy,'') as handyPriv,NVL(inanspre.email,'') as email,NVL(inter.inet1,'') as inet1 from mksdata!inter LEFT JOIN mksdata!inanspre ON inter.kundnr=inanspre.kundnr

Feldzuordnung.fxm

• Codeblock
  language xml
  <Fieldmappings> <Mapping idn="5" ids="entryID"> <SourceField ids="index" idn="-1" /> </Mapping> <Mapping idn="6" ids="displayName"> <SourceField ids="aname" idn="-1" /> </Mapping> <Mapping idn="7" ids="givenName"> <SourceField ids="vorname" idn="-1" /> </Mapping> <Mapping idn="8" ids="sn"> <SourceField ids="nachname" idn="-1" /> </Mapping> <Mapping idn="9" ids="title"> <SourceField ids="position" idn="-1" /> </Mapping> <Mapping idn="10" ids="company"> <SourceField ids="kurzbez" idn="-1" /> </Mapping> <Mapping idn="11" ids="department"> <SourceField ids="abteilung" idn="-1" /> </Mapping> <Mapping idn="12" ids="physicalDeliveryOfficeName" /> <Mapping idn="13" ids="streetAddress"> <SourceField ids="strasse" idn="-1" /> </Mapping> <Mapping idn="14" ids="postalCode"> <SourceField ids="plz" idn="-1" /> </Mapping> <Mapping idn="15" ids="l"> <SourceField ids="ort" idn="-1" /> </Mapping> <Mapping idn="16" ids="st" /> <Mapping idn="17" ids="c"> <SourceField ids="land_lang" idn="-1" /> </Mapping> <Mapping idn="18" ids="privateAddressStreet" /> <Mapping idn="19" ids="privateAddressPostalCode" /> <Mapping idn="20" ids="privateAddressCity" /> <Mapping idn="21" ids="privateAddressState" /> <Mapping idn="22" ids="privateAddressCountry" /> <Mapping idn="23" ids="otherAddressStreet" /> <Mapping idn="24" ids="otherAddressPostalCode" /> <Mapping idn="25" ids="otherAddressCity" /> <Mapping idn="26" ids="otherAddressState" /> <Mapping idn="27" ids="otherAddressCountry" /> <Mapping idn="28" ids="mail"> <SourceField ids="email" idn="-1" /> </Mapping> <Mapping idn="29" ids="mail2" /> <Mapping idn="30" ids="mail3" /> <Mapping idn="31" ids="sipAddress" /> <Mapping idn="32" ids="url"> <SourceField ids="inet1" idn="-1" /> </Mapping> <Mapping idn="33" ids="telephoneNumber"> <SourceField ids="telefon1" idn="-1" /> </Mapping> <Mapping idn="34" ids="otherTelephone"> <SourceField ids="telefon2" idn="-1" /> </Mapping> <Mapping idn="35" ids="telephoneNumberCompanyMain" /> <Mapping idn="36" ids="telephoneAssistant" /> <Mapping idn="37" ids="homephone"> <SourceField ids="telefonpriv" idn="-1" /> </Mapping> <Mapping idn="38" ids="otherHomePhone" /> <Mapping idn="39" ids="telephonePrimary" /> <Mapping idn="40" ids="mobile"> <SourceField ids="handy" idn="-1" /> </Mapping> <Mapping idn="41" ids="telephoneCar"> <SourceField ids="handypriv" idn="-1" /> </Mapping> <Mapping idn="42" ids="telephoneRadio" /> <Mapping idn="43" ids="pager" /> <Mapping idn="44" ids="telephoneCallback" /> <Mapping idn="45" ids="telephoneISDN" /> <Mapping idn="46" ids="telephoneTTYTTD" /> <Mapping idn="47" ids="facsimileTelephoneNumber" /> <Mapping idn="48" ids="otherFacsimileTelephoneNumber" /> <Mapping idn="49" ids="customerid"> <SourceField ids="kundennr" idn="-1" /> </Mapping> <Mapping idn="51" ids="directOpenContact" /> <Mapping idn="52" ids="info" /> <Mapping idn="53" ids="custom0" /> <Mapping idn="54" ids="custom1" /> <Mapping idn="55" ids="custom2" /> <Mapping idn="56" ids="custom3" /> <Mapping idn="57" ids="custom4" /> <Mapping idn="58" ids="custom5" /> <Mapping idn="59" ids="custom6" /> <Mapping idn="60" ids="custom7" /> <Mapping idn="61" ids="custom8" /> <Mapping idn="62" ids="custom9" /> <Mapping idn="77" ids="jpegPhoto" /> <Mapping idn="78" ids="imagePath" /> <Mapping idn="80" ids="sourceModifyTimeStamp" /> <Mapping idn="81" ids="custom10" /> <Mapping idn="82" ids="custom11" /> <Mapping idn="83" ids="custom12" /> <Mapping idn="84" ids="custom13" /> <Mapping idn="85" ids="custom14" /> <Mapping idn="86" ids="custom15" /> <Mapping idn="87" ids="custom16" /> <Mapping idn="88" ids="custom17" /> <Mapping idn="89" ids="custom18" /> <Mapping idn="90" ids="custom19" /> <Mapping idn="91" ids="sAMAccountName" /> </Fieldmappings>