Table 18059975 EOS Hierarchy Relation Request
Table 18059975 EOS Hierarchy Relation Request
| Language | Caption |
|---|---|
| da-DK | Anmodning om hierarkirelation |
| de-AT | Hierarchie-Beziehungsanforderung |
| de-CH | Hierarchie-Beziehungsanforderung |
| de-DE | Hierarchie-Beziehungsanforderung |
| es-ES | Solicitud de relación de jerarquía |
| es-MX | Solicitud de relación de jerarquía |
| fi-FI | Hierarkian suhdepyyntö |
| fr-BE | Demande de relation de hiérarchie |
| fr-CA | Demande de relation de hiérarchie |
| fr-CH | Demande de relation de hiérarchie |
| fr-FR | Demande de relation de hiérarchie |
| en-US | Hierarchy Relation Request |
| it-CH | Richiesta relazione gerarchia |
| it-IT | Richiesta relazione gerarchia |
| nb-NO | Forespørsel om hierarkirelasjon |
| nl-BE | Relatieaanvraag hiërarchie |
| nl-NL | Relatieaanvraag hiërarchie |
| nn-NO | Forespørsel om hierarkirelasjon |
| sv-SE | Begäran om hierarkirelation |
Fields
Entry No. (1)
Integer
| Language | Caption |
|---|---|
| da-DK | Løbenr. |
| de-AT | Lfd. Nr. |
| de-CH | Lfd. Nr. |
| de-DE | Lfd. Nr. |
| es-ES | Entrada Nº |
| es-MX | Entrada Nº |
| fi-FI | Tapahtumanro |
| fr-BE | N° séquence |
| fr-CA | N° séquence |
| fr-CH | N° séquence |
| fr-FR | N° séquence |
| en-US | Entry No. |
| it-CH | Nr. movimento |
| it-IT | Nr. movimento |
| nb-NO | Løpenr. |
| nl-BE | Volgnummer |
| nl-NL | Volgnummer |
| nn-NO | Postnr. |
| sv-SE | Löpnr |
Description (2)
Text[250]
| Language | Caption |
|---|---|
| da-DK | Beskrivelse |
| de-AT | Beschreibung |
| de-CH | Beschreibung |
| de-DE | Beschreibung |
| es-ES | Descripción |
| es-MX | Descripción |
| fi-FI | Kuvaus |
| fr-BE | Description |
| fr-CA | Description |
| fr-CH | Description |
| fr-FR | Description |
| en-US | Description |
| it-CH | Descrizione |
| it-IT | Descrizione |
| nb-NO | Beskrivelse |
| nl-BE | Omschrijving |
| nl-NL | Omschrijving |
| nn-NO | Beskrivelse |
| sv-SE | Beskrivning |
Source Type (3)
Option
Customer (0) , Item (1) , Vendor (2)
| Language | Caption |
|---|---|
| da-DK | Kildetype |
| de-AT | Herkunftsart |
| de-CH | Herkunftsart |
| de-DE | Herkunftsart |
| es-ES | Tipo de fuente |
| es-MX | Tipo de fuente |
| fi-FI | Lähdetyyppi |
| fr-BE | Type origine |
| fr-CA | Type origine |
| fr-CH | Type origine |
| fr-FR | Type origine |
| en-US | Source Type |
| it-CH | Tipo origine |
| it-IT | Tipo origine |
| nb-NO | Kildetype |
| nl-BE | Bronsoort |
| nl-NL | Bronsoort |
| nn-NO | Kildetype |
| sv-SE | Ursprungstyp |
User ID (4)
Code[35]
| Language | Caption |
|---|---|
| da-DK | Bruger-id |
| de-AT | Benutzer-ID |
| de-CH | Benutzer-ID |
| de-DE | Benutzer-ID |
| es-ES | ID de usuario |
| es-MX | ID de usuario |
| fi-FI | Käyttäjätunnus |
| fr-BE | Code utilisateur |
| fr-CA | Code utilisateur |
| fr-CH | Code utilisateur |
| fr-FR | Code utilisateur |
| en-US | User ID |
| it-CH | ID utente |
| it-IT | ID utente |
| nb-NO | Bruker-ID |
| nl-BE | Gebruikers-id |
| nl-NL | Gebruikers-id |
| nn-NO | Bruker-ID |
| sv-SE | Användar-ID |
Reference Date (5)
Date
| Language | Caption |
|---|---|
| da-DK | Referencedato |
| de-AT | Referenzdatum |
| de-CH | Referenzdatum |
| de-DE | Referenzdatum |
| es-ES | Fecha de referencia |
| es-MX | Fecha de referencia |
| fi-FI | Viitepäivämäärä |
| fr-BE | Date de référence |
| fr-CA | Date de référence |
| fr-CH | Date de référence |
| fr-FR | Date de référence |
| en-US | Reference Date |
| it-CH | Data riferimento |
| it-IT | Data riferimento |
| nb-NO | Referansedato |
| nl-BE | Referentiedatum |
| nl-NL | Referentiedatum |
| nn-NO | Referansedato |
| sv-SE | Referensdatum |
DateTime Request (6)
DateTime
| Language | Caption |
|---|---|
| da-DK | Anmodning om datotid |
| de-AT | DateTime-Anforderung |
| de-CH | DateTime-Anforderung |
| de-DE | DateTime-Anforderung |
| es-ES | Solicitud DateTime |
| es-MX | Solicitud DateTime |
| fi-FI | DateTime-pyyntö |
| fr-BE | Demande dateTime |
| fr-CA | Demande dateTime |
| fr-CH | Demande dateTime |
| fr-FR | Demande dateTime |
| en-US | DateTime Request |
| it-CH | Data ora richiesta |
| it-IT | Data ora richiesta |
| nb-NO | Forespørsel om dato/klokkeslett |
| nl-BE | Datumtijdaanvraag |
| nl-NL | Datumtijdaanvraag |
| nn-NO | Forespørsel om dato/klokkeslett |
| sv-SE | DateTime-begäran |
DateTime Execution (7)
DateTime
| Language | Caption |
|---|---|
| da-DK | Udførelse af Dato-/klokkeslæt |
| de-AT | DateTime-Ausführung |
| de-CH | DateTime-Ausführung |
| de-DE | DateTime-Ausführung |
| es-ES | Ejecución de DateTime |
| es-MX | Ejecución de DateTime |
| fi-FI | DateTime-suoritus |
| fr-BE | Exécution dateTime |
| fr-CA | Exécution dateTime |
| fr-CH | Exécution dateTime |
| fr-FR | Exécution dateTime |
| en-US | DateTime Execution |
| it-CH | Data ora esecuzione |
| it-IT | Data ora esecuzione |
| nb-NO | Kjøring av datetime |
| nl-BE | Datumuitvoering |
| nl-NL | Datumuitvoering |
| nn-NO | Kjøring av datetime |
| sv-SE | Körning av DateTime |
Status (8)
Enum "EOS Hier. Rel. Request Status"
| Language | Caption |
|---|---|
| da-DK | Status |
| de-AT | Status |
| de-CH | Status |
| de-DE | Status |
| es-ES | Estado |
| es-MX | Estado |
| fi-FI | Tila |
| fr-BE | Statut |
| fr-CA | Statut |
| fr-CH | Statut |
| fr-FR | Statut |
| en-US | Status |
| it-CH | Stato |
| it-IT | Stato |
| nb-NO | Status |
| nl-BE | Status |
| nl-NL | Status |
| nn-NO | Status |
| sv-SE | Status |
Error Message (9)
Text[250]
| Language | Caption |
|---|---|
| da-DK | Fejlmeddelelse |
| de-AT | Fehlermeldung |
| de-CH | Fehlermeldung |
| de-DE | Fehlermeldung |
| es-ES | Mensaje de error |
| es-MX | Mensaje de error |
| fi-FI | Virhesanoma |
| fr-BE | Message d’erreur |
| fr-CA | Message d’erreur |
| fr-CH | Message d’erreur |
| fr-FR | Message d’erreur |
| en-US | Error Message |
| it-CH | Messaggio di errore |
| it-IT | Messaggio di errore |
| nb-NO | Feilmelding |
| nl-BE | foutmelding |
| nl-NL | foutmelding |
| nn-NO | Feilmelding |
| sv-SE | Felmeddelande |
No. of Details (10)
Integer
FieldClass: FlowField
CalcFormula: Count("EOS Hierarchy Relation Detail" WHERE("Relation Entry No." = FIELD("Entry No.")))
| Language | Caption |
|---|---|
| da-DK | Nej. af detaljer |
| de-AT | Nein. der Details |
| de-CH | Nein. der Details |
| de-DE | Nein. der Details |
| es-ES | No. de los detalles |
| es-MX | No. de los detalles |
| fi-FI | Ei. ja tiedot |
| fr-BE | non. de Détails |
| fr-CA | non. de Détails |
| fr-CH | non. de Détails |
| fr-FR | non. de Détails |
| en-US | No. of Details |
| it-CH | Nr. di dettagli |
| it-IT | Nr. di dettagli |
| nb-NO | nei. av detaljer |
| nl-BE | №. van details |
| nl-NL | №. van details |
| nn-NO | nei. av detaljer |
| sv-SE | Nej. av detaljer |
Level (11)
Integer
TableRelation: if ("Source Type" = const(Customer)) "EOS Customer Hierarchy Level".Level else if ("Source Type" = const(Vendor)) "EOS Vendor Hierarchy Level".Level else if ("Source Type" = const(Item)) "EOS Item Hierarchy Level".Level where(Type = field("Item Hierarchy Type"))
| Language | Caption |
|---|---|
| da-DK | Niveau |
| de-AT | Ebene |
| de-CH | Ebene |
| de-DE | Ebene |
| es-ES | Nivel |
| es-MX | Nivel |
| fi-FI | Taso |
| fr-BE | Niveau |
| fr-CA | Niveau |
| fr-CH | Niveau |
| fr-FR | Niveau |
| en-US | Level |
| it-CH | Livello |
| it-IT | Livello |
| nb-NO | Nivå |
| nl-BE | Niveau |
| nl-NL | Niveau |
| nn-NO | Nivå |
| sv-SE | Nivå |
Item Hierarchy Type (12)
Enum "EOS Item Hierarchy Type"
| Language | Caption |
|---|---|
| da-DK | Elementhierarkitype |
| de-AT | Artikelhierarchietyp |
| de-CH | Artikelhierarchietyp |
| de-DE | Artikelhierarchietyp |
| es-ES | Tipo de jerarquía de artículos |
| es-MX | Tipo de jerarquía de artículos |
| fi-FI | Nimikehierarkian tyyppi |
| fr-BE | Type de hiérarchie d’élément |
| fr-CA | Type de hiérarchie d’élément |
| fr-CH | Type de hiérarchie d’élément |
| fr-FR | Type de hiérarchie d’élément |
| en-US | Item Hierarchy Type |
| it-CH | Tipo gerarchia articolo |
| it-IT | Tipo gerarchia articolo |
| nb-NO | Type for elementhierarki |
| nl-BE | Itemhiërarchietype |
| nl-NL | Itemhiërarchietype |
| nn-NO | Type for elementhierarki |
| sv-SE | Artikelhierarkityp |
Curr. Upper Level Code (13)
Code[20]
TableRelation: if ("Source Type" = const(Customer), "Level" = const(1)) "EOS Customer Hierarchy".Code where("Level" = const(2), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(2)) "EOS Customer Hierarchy".Code where("Level" = const(3), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(3)) "EOS Customer Hierarchy".Code where("Level" = const(4), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(4)) "EOS Customer Hierarchy".Code where("Level" = const(5), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(5)) "EOS Customer Hierarchy".Code where("Level" = const(6), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(6)) "EOS Customer Hierarchy".Code where("Level" = const(7), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(7)) "EOS Customer Hierarchy".Code where("Level" = const(8), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(8)) "EOS Customer Hierarchy".Code where("Level" = const(9), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(9)) "EOS Customer Hierarchy".Code where("Level" = const(10), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(10)) "EOS Customer Hierarchy".Code where("Level" = const(11), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(1)) "EOS Vendor Hierarchy".Code where("Level" = const(2), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(2)) "EOS Vendor Hierarchy".Code where("Level" = const(3), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(3)) "EOS Vendor Hierarchy".Code where("Level" = const(4), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(4)) "EOS Vendor Hierarchy".Code where("Level" = const(5), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(5)) "EOS Vendor Hierarchy".Code where("Level" = const(6), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(6)) "EOS Vendor Hierarchy".Code where("Level" = const(7), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(7)) "EOS Vendor Hierarchy".Code where("Level" = const(8), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(8)) "EOS Vendor Hierarchy".Code where("Level" = const(9), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(9)) "EOS Vendor Hierarchy".Code where("Level" = const(10), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(10)) "EOS Vendor Hierarchy".Code where("Level" = const(11), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(1)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(2), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(2)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(3), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(3)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(4), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(4)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(5), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(5)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(6), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(6)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(7), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(7)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(8), "Ending Date" = filter(0D))
| Language | Caption |
|---|---|
| da-DK | Nuværende øverste niveau |
| de-AT | Aktuelle Oberstufe |
| de-CH | Aktuelle Oberstufe |
| de-DE | Aktuelle Oberstufe |
| es-ES | Nivel superior actual |
| es-MX | Nivel superior actual |
| fi-FI | Nykyinen ylempi taso |
| fr-BE | Niveau supérieur actuel |
| fr-CA | Niveau supérieur actuel |
| fr-CH | Niveau supérieur actuel |
| fr-FR | Niveau supérieur actuel |
| en-US | Current Upper Level |
| it-CH | Livello superiore attuale |
| it-IT | Livello superiore attuale |
| nb-NO | Gjeldende øvre nivå |
| nl-BE | Huidig hoger niveau |
| nl-NL | Huidig hoger niveau |
| nn-NO | Gjeldende øvre nivå |
| sv-SE | Nuvarande övre nivå |
New Upper Level Code (14)
Code[20]
TableRelation: if ("Source Type" = const(Customer), "Level" = const(1)) "EOS Customer Hierarchy".Code where("Level" = const(2), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(2)) "EOS Customer Hierarchy".Code where("Level" = const(3), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(3)) "EOS Customer Hierarchy".Code where("Level" = const(4), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(4)) "EOS Customer Hierarchy".Code where("Level" = const(5), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(5)) "EOS Customer Hierarchy".Code where("Level" = const(6), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(6)) "EOS Customer Hierarchy".Code where("Level" = const(7), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(7)) "EOS Customer Hierarchy".Code where("Level" = const(8), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(8)) "EOS Customer Hierarchy".Code where("Level" = const(9), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(9)) "EOS Customer Hierarchy".Code where("Level" = const(10), "Ending Date" = filter(0D)) else if ("Source Type" = const(Customer), "Level" = const(10)) "EOS Customer Hierarchy".Code where("Level" = const(11), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(1)) "EOS Vendor Hierarchy".Code where("Level" = const(2), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(2)) "EOS Vendor Hierarchy".Code where("Level" = const(3), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(3)) "EOS Vendor Hierarchy".Code where("Level" = const(4), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(4)) "EOS Vendor Hierarchy".Code where("Level" = const(5), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(5)) "EOS Vendor Hierarchy".Code where("Level" = const(6), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(6)) "EOS Vendor Hierarchy".Code where("Level" = const(7), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(7)) "EOS Vendor Hierarchy".Code where("Level" = const(8), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(8)) "EOS Vendor Hierarchy".Code where("Level" = const(9), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(9)) "EOS Vendor Hierarchy".Code where("Level" = const(10), "Ending Date" = filter(0D)) else if ("Source Type" = const(Vendor), "Level" = const(10)) "EOS Vendor Hierarchy".Code where("Level" = const(11), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(1)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(2), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(2)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(3), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(3)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(4), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(4)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(5), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(5)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(6), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(6)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(7), "Ending Date" = filter(0D)) else if ("Source Type" = const(Item), "Level" = const(7)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(8), "Ending Date" = filter(0D))
| Language | Caption |
|---|---|
| da-DK | Ny kode på øverste niveau |
| de-AT | Neuer Code der oberen Ebene |
| de-CH | Neuer Code der oberen Ebene |
| de-DE | Neuer Code der oberen Ebene |
| es-ES | Nuevo código de nivel superior |
| es-MX | Nuevo código de nivel superior |
| fi-FI | Uusi ylätason koodi |
| fr-BE | Nouveau code de niveau supérieur |
| fr-CA | Nouveau code de niveau supérieur |
| fr-CH | Nouveau code de niveau supérieur |
| fr-FR | Nouveau code de niveau supérieur |
| en-US | New Upper Level Code |
| it-CH | Nuovo livello superiore |
| it-IT | Nuovo livello superiore |
| nb-NO | Ny kode på øverste nivå |
| nl-BE | Nieuwe code op hoger niveau |
| nl-NL | Nieuwe code op hoger niveau |
| nn-NO | Ny kode på øverste nivå |
| sv-SE | Ny kod på den övre nivån |
Methods
GetLevelDescription
procedure GetLevelDescription(inCode: Code[20]; ItemHierarchyType: Enum "EOS Item Hierarchy Type"): Text
Parameters / Return Value
inCode
Code[20]ItemHierarchyType
Enum "EOS Item Hierarchy Type"Returns
Text
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.