https://pranke.com/hilfe/ 2026-04-08T23:23:40+00:00 https://pranke.com/hilfe/ https://pranke.com/hilfe/lib/exe/fetch.php?media=favicon.ico text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:addlookupkeyvalue&rev=1708413318&do=diff AddLookupKeyValue The function AddLookupKeyValue () creates the value, if it does not yet exist, as Value-Provider and assigns it to the LookupTableKey, or changes the value if LookupTableKey exists. Note: Existing lookup key-value pairs are updated with the new value. Note: text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookupglobalkey&rev=1708413318&do=diff LookupGlobalKey This function basically corresponds to the mapping function LookupGlobalValue. However, the key is queried for the value and LookupGlobalKey gets an additional Key and the Key-Description, as parameters which are used to create new table fields when the key is not found. text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookupglobalkeynoauto&rev=1708413318&do=diff LookupGlobalKeyNoAuto This function basically corresponds to the mapping function LookupGlobalKey. However, a missing key value is not automatically created in LookupGlobalKeyNoAuto. Syntax: LookupGlobalKeyNoAuto('LookupTabellenNamen','Value') Sample: LookupGlobalKeyNoAuto('Währungen','SFr') text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookupglobalvalue&rev=1708413318&do=diff LookupGlobalValue This function accepts Lookup table names (Translation table for sizes or color codes), article number (Keys) and a Description (Key Descriptions) as arguments and returns the associated Lookup values (Translation values) from the Lookup table. The table fields are recreated if they do not exist in the lookup table. text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookupglobalvaluenoauto&rev=1708413318&do=diff LookupGlobalValueNoAuto This function basically corresponds to the mapping function LookupGlobalValue. However, in LookupGlobalValueNoAuto the table fields are not created automatically if they are not found during the query. Syntax: LookupGlobalValueNoAuto('LookupTabellenNamen','Key') text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookupownlocationvalue&rev=1708413318&do=diff LookupOwnLocationValue This function takes a Lookup table type name (for translation tables, sizes or color codes), the LookupKey (Key) and a Description (Key-Description) as arguments and returns the associated Lookup values (translation values) from a partner's lookuptable, if any. This function searches for the associated text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookuppartnerlocationaddlookupvalue&rev=1708413318&do=diff LookupPartnerLocationAddLookupValue This function adds the value with a description to the partner's lookup table of the specified 'LookupTabelleType' or overwrites it if it already exists. This mapping function can be used with LookupPartnerLocationValue to check duplicated documents/messages. For this you switch of the flag AutoAddNewTables of the lookup table type and call text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookuppartnerlocationvalue&rev=1708413318&do=diff LookupPartnerLocationValue This function takes a lookup table type name (for translation tables, sizes or color codes), the LookupKey and a description (key description) as arguments, and returns the corresponding lookup values from a partner's main lookup table, if any. This function searches for the corresponding partner location (location). If a link of this lookuptable is not entered for the trading or system partner, it is created automatically if the AutoAddNewTables property has been set… text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookuppartnerlocationvaluedescription&rev=1708413318&do=diff LookupPartnerLocationValueDescription This function returns the LookupTableTypeName and the LookupKey as parameters and returns the ValueDescription of the respective LocationLookup (trading partner side). Syntax: LookupPartnerLocationValueDescription('LookupTableTypeName','Key') text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookuppartnertablevalues&rev=1708413318&do=diff LookupPartnerTableValues This function returns all values from the specified lookup table. The lookup table is searched at the main location of the trading partner. Syntax: LookupPartnerTableValues ('LookupTabellenNamen') Examples: LookupPartnerTableValues ('GLN')/Entries[@Key = '8888']/@Value text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookuptablevalues&rev=1708413318&do=diff LookupTableValues This function returns all values from the specified lookup table. Syntax: LookupTableValues('LookupTabellenNamen') Examples: LookupTableValues('GLN')/Entries[@Key = '8888']/@Value text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookuptpvalue&rev=1708413318&do=diff LookupTPValue This function basically corresponds to the mapping function LookupGlobalValue. However, LookupTPValue specifies a table (LookupTable) and not just a global table type. Syntax: LookupTPValue('Tabelle','Key','Description') LookupTPValue('Tabelle','Key') text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookuptpvaluenoauto&rev=1708413318&do=diff LookupTPValueNoAuto This function basically corresponds to the mapping function LookupTPValue. However, in LookupGlobalValueNoAuto the table fields are not created automatically if they are not found during the query. Syntax: LookupTPValueNoAuto('Table', 'Key') text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookupvaluedescription&rev=1708413318&do=diff LookupValueDescription The function LookupValueDescription() gets a table name and LookupKey passed as a parameter and returns the result ValueDescription. Syntax: LookupValueDescription('Tablename', 'Key') Sample: LookupValueDescription('Sizes',@Ean) text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:ownlocationbackendreference&rev=1708413318&do=diff OwnLocationBackendReference This function returns the stored ILN of the SystemPartner to the transferred GLN. The second argument can be an Auto-Add-Value (True, False). If True is specified, the ILN is created if it does not exist. Syntax: OwnLocationBackendReference('GLN') text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:ownlocationgln&rev=1708413318&do=diff OwnLocationGLN This function returns the stored GLN of the system partner to the transferred ILN. The second argument can be an Auto-Add-Value (True, False). If True is specified, the GLN is created if it does not exist. Syntax: OwnLocationGLN('ILN') text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:start&rev=1708413318&do=diff Lookup functions All functions that read values from the eBiss database. Note: Depending on the settings of the lookup table types, the lookup functions can create non-existing keys. However, existing lookup entries are not overwritten and also not enriched with descriptions!lookup index text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:systempartnergln&rev=1708413318&do=diff SystemPartnerGLN This function returns the SystemPartner's stored GLN to the transferred ILN. \ The second argument can be an Auto-Add-Value (True, False). If True is specified, the GLN is created again if it does not exist. Syntax: SystemPartnerGLN('ILN') text/html 2026-02-24T14:13:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:systempartnerlocationbackendreference&rev=1771938787&do=diff SystemPartnerLocationBackendReference This function returns the SystemPartner's stored ILN to the transferred GLN. \ The second argument can be an Auto-Add-Value (True, False). If True is specified, the ILN is created again if it does not exist. text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:tpbackendid&rev=1708413318&do=diff TPBackendId This mapping function serves the same purpose as the mapping function 'TradingPartnerBackendReference'. The function call has been retained for compatibility with older eBiss versions. See: TradingPartnerBackendReference Syntax: TPBackenId('ILN') TPBackenId('ILN', 'AutoAdd') text/html 2025-11-12T11:25:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:tradingpartnerbackendreference&rev=1762943157&do=diff TradingPartnerBackendReference Hinweis: This function changes the currently used location, which is relevant when calling lookup functions, among other things. This function returns the GLN of a location of the trading partner in question as an argument and returns the stored BackendReference-ID of this trading partner location. The BackendReference-ID links the text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:tradingpartnergln&rev=1708413318&do=diff TradingPartnerGLN This function gets the location backend reference as the first argument and returns the stored GLN of the respective trading partner location. \ Syntax: TradingPartnerGLN('BackendReference') Sample: TradingPartnerGLN('7001419') text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:abfragefunktionen:lookup:tradingpartnerlocationbackendreference&rev=1708413318&do=diff TradingPartnerLocationBackendReference This mapping function serves the same purpose as the mapping function ' TradingPartnerBackendReference' . The function call has been retained for compatibility with older eBiss versions. See also: TradingPartnerBackendReference Syntax: TradingPartnerLocationBackendReference('GLN')