Diese Exportschnittstellen extrahieren grundlegende Informationen wie Anrede, Rechtsformen, Länder und andere Referenzdaten, die in verschiedene Sprachen übersetzt wurden. Die exportierten Daten können anschließend in die Umgebung von CAPENCY oder DQE SOFTWARE importiert werden, sodass Informationen entsprechend dem kulturellen Profil des Benutzers angezeigt werden können.
Menüoption im Mode Place: Data Exchange > Data export > User-defined export > Request templates
1. Titles - Liste der Anreden, übersetzt nach kulturellen Profilen
Fügen Sie die folgende Anfrage hinzu, indem Sie auf die untenstehende Schaltfläche klicken:
SELECT TYPINF,LANG,RTRIM(CODE) AS CODE,DESCRIPTION FROM
(SELECT "CIV" AS TYPINF,
CO_CODE AS LANG,
CAST(TDT_CODE AS VARCHAR(3)) AS CODE,
TDT_LIBELLE AS DESCRIPTION
FROM COMMUN
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="CIV" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA"
UNION
(
SELECT DISTINCT "CIV",
CO_CODE,
CAST(CC_CODE AS VARCHAR(3)),
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="CIV"
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="CIV" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA" AND CC_CODE NOT IN (SELECT DISTINCT TDT_CODE FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="CIV" AND TDT_LANG=CO_CODE)
)
UNION
(
SELECT "CIV",
CO_CODE,
CAST(CC_CODE AS VARCHAR(3)),
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="CIV"
WHERE CO_TYPE="TRA" AND CO_CODE NOT IN (SELECT DISTINCT TDT_LANG FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="CIV")
)) R
Gehen Sie anschließend zu Settings.
Dateiformat
2. Legal Form - Liste der Rechtsformen, übersetzt nach kulturellen Profilen
Fügen Sie die folgende Anfrage hinzu, indem Sie auf die untenstehende Schaltfläche klicken:
SELECT TYPINF,LANG,RTRIM(CODE) AS CODE,DESCRIPTION FROM
(SELECT "JUR" AS TYPINF,
CO_CODE AS LANG,
TDT_CODE AS CODE,
TDT_LIBELLE AS DESCRIPTION
FROM COMMUN
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="JUR" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA"
UNION
(
SELECT DISTINCT "JUR",
CO_CODE,
CC_CODE,
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="JUR"
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="JUR" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA" AND CC_CODE NOT IN (SELECT DISTINCT TDT_CODE FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="JUR" AND TDT_LANG=CO_CODE)
)
UNION
(
SELECT "JUR",
CO_CODE,
CC_CODE,
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="JUR"
WHERE CO_TYPE="TRA" AND CO_CODE NOT IN (SELECT DISTINCT TDT_LANG FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="JUR")
)) R
Gehen Sie anschließend zu Settings.
Dateiformat
3. Labels - Liste der Feldbezeichnungen, übersetzt nach kulturellen Profilen
Fügen Sie die folgende Anfrage hinzu, indem Sie auf die untenstehende Schaltfläche klicken:
SELECT "LBL" AS TYPINF, CO_CODE AS LANG, ZY2_FLDY2 AS CODE,
ISNULL(TDT_LIBELLE, CASE WHEN LEN(TDA_VAL) = 0 OR TDA_VAL IS NULL THEN ISNULL(CC_LIBELLE, ZY2_FLDESC) ELSE TDA_VAL END) AS DESCR
FROM COMMUN
LEFT JOIN ZRELCHAMPY2 ON ZY2_DOMY2 in ("T", "C", "YTC") AND ZY2_VISIBLE = "X"
LEFT JOIN CHOIXCOD ON CC_TYPE = "ZLI" AND CC_CODE = CASE
WHEN ZY2_FLDY2 like "YTC_BOOLLIBRE%" THEN "CB" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "YTC_TEXTELIBRE%" THEN "CC" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "YTC_DATELIBRE%" THEN "CD" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "YTC_VALLIBRE%" THEN "CM" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "YTC_TABLELIBRE%" THEN "CT" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "C_BOOLLIBRE%" THEN "BB" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "C_TEXTELIBRE%" THEN "BC" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "C_DATELIBRE%" THEN "BD" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "C_VALLIBRE%" THEN "BM" + RIGHT(ZY2_FLDY2, 1)
WHEN ZY2_FLDY2 like "C_LIBRECONTACT%" THEN "BT" + RIGHT(ZY2_FLDY2, 1)
END
LEFT JOIN TRADDATA ON TDA_CHAMP = "DH_LIBELLE" AND TDA_LANG = CO_CODE AND TDA_CLE = ZY2_FLDY2
LEFT JOIN TRADTT ON CC_TYPE IS NOT NULL AND TDT_PREFIXE = "CC" AND TDT_TYPE = "ZLI" AND TDT_CODE = CC_CODE AND TDT_LANG = CO_CODE
WHERE CO_TYPE = "TRA"
ORDER BY 2, 3
Gehen Sie anschließend zu Settings.
Dateiformat
4. Languages - Liste der Sprachen, übersetzt nach kulturellen Profilen
Fügen Sie die folgende Anfrage hinzu, indem Sie auf die untenstehende Schaltfläche klicken:
SELECT TYPINF, RTRIM(LANG) AS LANG, RTRIM(CODE) AS CODE, DESCRIPTION FROM (
SELECT "LGU" AS TYPINF,
CO_CODE AS LANG,
TDT_CODE AS CODE,
TDT_LIBELLE AS DESCRIPTION
FROM COMMUN
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="LGU" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA"
UNION
(
SELECT DISTINCT "LGU",
CO_CODE,
CC_CODE,
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="LGU"
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="LGU" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA" AND CC_CODE NOT IN (SELECT DISTINCT TDT_CODE FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="LGU" AND TDT_LANG=CO_CODE)
)
UNION
(
SELECT "LGU",
CO_CODE,
CC_CODE,
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="LGU"
WHERE CO_TYPE="TRA" AND CO_CODE NOT IN (SELECT DISTINCT TDT_LANG FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="LGU")
)) R
Gehen Sie anschließend zu Settings.
Dateiformat
5. Nationalities - Liste der Staatsangehörigkeiten, übersetzt nach kulturellen Profilen
Fügen Sie die folgende Anfrage hinzu, indem Sie auf die untenstehende Schaltfläche klicken:
SELECT TYPINF,RTRIM(LANG) AS LANG,RTRIM(CODE) AS CODE,DESCRIPTION FROM (
SELECT
"NAT" AS TYPINF,
CO_CODE AS LANG,
TDA_CLE AS CODE,
TDA_VAL AS DESCRIPTION
FROM COMMUN
JOIN TRADDATA
ON TDA_CHAMP = "PY_NATIONALITE" AND TDA_LANG = CO_CODE
WHERE CO_TYPE = "TRA"
UNION
(SELECT DISTINCT
"NAT",
CO_CODE,
PY_PAYS,
PY_NATIONALITE
FROM COMMUN
JOIN TRADDATA
ON TDA_CHAMP = "PY_NATIONALITE" AND TDA_LANG = CO_CODE
JOIN PAYS
ON CO_TYPE = "TRA" AND NOT EXISTS(SELECT DISTINCT TDA_CLE FROM TRADDATA WHERE TDA_CHAMP = "PY_NATIONALITE" AND TDA_LANG = CO_CODE AND TDA_CLE = PY_PAYS) AND LEN(PY_NATIONALITE)<>0 )
UNION
(SELECT
"NAT",
CO_CODE,
PY_PAYS,
PY_NATIONALITE
FROM COMMUN
JOIN PAYS
ON CO_TYPE = "TRA" AND NOT EXISTS (SELECT DISTINCT TDA_LANG FROM TRADDATA WHERE TDA_CHAMP = "PY_NATIONALITE" AND TDA_LANG = CO_CODE) AND LEN(PY_NATIONALITE)<>0)
) R
Gehen Sie anschließend zu Settings.
Dateiformat
6. Countries - Liste der Länder, übersetzt nach kulturellen Profilen
Fügen Sie die folgende Anfrage hinzu, indem Sie auf die untenstehende Schaltfläche klicken:
SELECT TYPINF,RTRIM(LANG) AS LANG,RTRIM(CODE) AS CODE,DESCRIPTION FROM (
SELECT "PYS" AS TYPINF,
CO_CODE AS LANG,
TDA_CLE AS CODE,
TDA_VAL AS DESCRIPTION
FROM COMMUN
INNER JOIN TRADDATA ON TDA_CHAMP="PY_LIBELLE" AND TDA_LANG=CO_CODE
WHERE CO_TYPE="TRA"
UNION
(SELECT DISTINCT "PYS",
CO_CODE,
PY_PAYS,
PY_LIBELLE
FROM COMMUN
INNER JOIN TRADDATA ON TDA_CHAMP = "PY_LIBELLE" AND TDA_LANG = CO_CODE
INNER JOIN PAYS
ON CO_TYPE="TRA" AND NOT EXISTS (SELECT DISTINCT TDA_CLE FROM TRADDATA WHERE TDA_CHAMP="PY_LIBELLE" AND TDA_LANG=CO_CODE AND TDA_CLE=PY_PAYS)
)
UNION
(
SELECT "PYS",
CO_CODE,
PY_PAYS,
PY_LIBELLE
FROM COMMUN
INNER JOIN PAYS ON CO_TYPE="TRA" AND NOT EXISTS (SELECT DISTINCT TDA_LANG FROM TRADDATA WHERE TDA_CHAMP="PY_LIBELLE" AND TDA_LANG=CO_CODE)
)) R
Gehen Sie anschließend zu Settings.
Dateiformat
7. Regions - Liste der Regionen nach Land
Fügen Sie die folgende Anfrage hinzu, indem Sie auf die untenstehende Schaltfläche klicken:
SELECT "REG" AS TYPINF,
RG_PAYS AS COUNTRY,
RG_REGION AS "REGION CODE" ,
RG_LIBELLE AS DESCRIPTION
FROM REGION
Gehen Sie anschließend zu Settings.
Dateiformat
8. Translation Languages - Liste der kulturellen Profile
Fügen Sie die folgende Anfrage hinzu, indem Sie auf die untenstehende Schaltfläche klicken:
SELECT CO_TYPE AS TYPINF,
CO_CODE AS CODE,
CO_LIBELLE AS DESCRIPTION
FROM COMMUN WHERE CO_TYPE="TRA"
Gehen Sie anschließend zu Settings.
Dateiformat
9. Free Contact Tables (Contact)
C_LIBRECONTACTx: YYLIBRECONx (CHOIXEXT
mit YX_TYPE = "LBx") entspricht dem Export der freien Tabellenwerte
der Drittpartei in Abschnitt 6, wobei LT% durch
LB% ersetzt werden muss.
SELECT TYPINF,LANG,RTRIM(CODE) AS CODE,DESCRIPTION FROM
(
SELECT TDT_TYPE AS TYPINF, CO_CODE AS LANG, CAST(TDT_CODE AS VARCHAR(3)) AS CODE, TDT_LIBELLE AS DESCRIPTION
FROM COMMUN
INNER JOIN TRADTT ON TDT_PREFIXE="YX" AND TDT_TYPE=TDT_TYPE AND TDT_LANG=CO_CODE
WHERE TDT_TYPE like "LB%" AND CO_TYPE="TRA"
UNION
(
SELECT DISTINCT YX_TYPE, CO_CODE, CAST(YX_CODE AS VARCHAR(3)), YX_LIBELLE
FROM COMMUN
INNER JOIN CHOIXEXT ON YX_TYPE like "LB%"
INNER JOIN TRADTT ON TDT_PREFIXE="YX" AND TDT_TYPE=YX_TYPE AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA" AND YX_CODE NOT IN (SELECT DISTINCT TDT_CODE FROM TRADTT WHERE TDT_PREFIXE="YX" AND TDT_TYPE=YX_TYPE AND TDT_LANG=CO_CODE)
)
UNION
(
SELECT YX_TYPE, CO_CODE, CAST(YX_CODE AS VARCHAR(3)), YX_LIBELLE
FROM COMMUN
INNER JOIN CHOIXEXT ON YX_TYPE like "LB%"
WHERE CO_TYPE="TRA" AND CO_CODE NOT IN (SELECT DISTINCT TDT_LANG FROM TRADTT WHERE TDT_PREFIXE="YX" AND TDT_TYPE=YX_TYPE)
)
) TABLETMP10. Coded Function (Contact)
C_FONCTIONCODEE: TTFONCTION (CHOIXCOD
mit CC_TYPE = "FON") entspricht dem Export der Anredewerte
in Abschnitt 1, wobei CIV durch FON ersetzt werden muss.
SELECT TYPINF,LANG,RTRIM(CODE) AS CODE,DESCRIPTION FROM
(SELECT "FON" AS TYPINF,
CO_CODE AS LANG,
CAST(TDT_CODE AS VARCHAR(3)) AS CODE,
TDT_LIBELLE AS DESCRIPTION
FROM COMMUN
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="FON" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA"
UNION
(
SELECT DISTINCT "FON",
CO_CODE,
CAST(CC_CODE AS VARCHAR(3)),
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="FON"
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="FON" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA" AND CC_CODE NOT IN (SELECT DISTINCT TDT_CODE FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="FON" AND TDT_LANG=CO_CODE)
)
UNION
(
SELECT "FON",
CO_CODE,
CAST(CC_CODE AS VARCHAR(3)),
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="FON"
WHERE CO_TYPE="TRA" AND CO_CODE NOT IN (SELECT DISTINCT TDT_LANG FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="FON")
)) R11. Service Code (Contact)
C_SERVICECODE: YYSERVICE (CHOIXCOD mit
CC_TYPE = "SRV") entspricht dem Export der Anredewerte in
Abschnitt 1, wobei CIV durch SRV ersetzt werden muss.
SELECT TYPINF,LANG,RTRIM(CODE) AS CODE,DESCRIPTION FROM
(SELECT "SRV" AS TYPINF,
CO_CODE AS LANG,
CAST(TDT_CODE AS VARCHAR(3)) AS CODE,
TDT_LIBELLE AS DESCRIPTION
FROM COMMUN
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="SRV" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA"
UNION
(
SELECT DISTINCT "SRV",
CO_CODE,
CAST(CC_CODE AS VARCHAR(3)),
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="SRV"
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="SRV" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA" AND CC_CODE NOT IN (SELECT DISTINCT TDT_CODE FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="SRV" AND TDT_LANG=CO_CODE)
)
UNION
(
SELECT "SRV",
CO_CODE,
CAST(CC_CODE AS VARCHAR(3)),
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="SRV"
WHERE CO_TYPE="TRA" AND CO_CODE NOT IN (SELECT DISTINCT TDT_LANG FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="SRV")
)) R12. Relationship (Contact)
C_LIPARENT: TTLIENPARENT (CHOIXCOD mit
CC_TYPE = "LIP") entspricht dem Export der Anredewerte in
Abschnitt 1, wobei CIV durch LIP ersetzt werden muss.
SELECT TYPINF,LANG,RTRIM(CODE) AS CODE,DESCRIPTION FROM
(SELECT "LIP" AS TYPINF,
CO_CODE AS LANG,
CAST(TDT_CODE AS VARCHAR(3)) AS CODE,
TDT_LIBELLE AS DESCRIPTION
FROM COMMUN
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="LIP" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA"
UNION
(
SELECT DISTINCT "LIP",
CO_CODE,
CAST(CC_CODE AS VARCHAR(3)),
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="LIP"
INNER JOIN TRADTT ON TDT_PREFIXE="CC" AND TDT_TYPE="LIP" AND TDT_LANG=CO_CODE
WHERE CO_TYPE="TRA" AND CC_CODE NOT IN (SELECT DISTINCT TDT_CODE FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="LIP" AND TDT_LANG=CO_CODE)
)
UNION
(
SELECT "LIP",
CO_CODE,
CAST(CC_CODE AS VARCHAR(3)),
CC_LIBELLE
FROM COMMUN
INNER JOIN CHOIXCOD ON CC_TYPE="LIP"
WHERE CO_TYPE="TRA" AND CO_CODE NOT IN (SELECT DISTINCT TDT_LANG FROM TRADTT WHERE TDT_PREFIXE="CC" AND TDT_TYPE="LIP")
)) RVerknüpfung mit