Table 18059975 EOS Hierarchy Relation Request

Table 18059975 EOS Hierarchy Relation Request

Language	Caption
da-DK	Anmodning om hierarkirelation
de-DE	Hierarchie-Beziehungsanforderung
es-ES	Solicitud de relación de jerarquía
fi-FI	Hierarkian suhdepyyntö
fr-FR	Demande de relation de hiérarchie
en-US	Hierarchy Relation Request
it-IT	Richiesta relazione gerarchia
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-DE	Lfd. Nr.
es-ES	Entrada Nº
fi-FI	Tapahtumanro
fr-FR	N° séquence
en-US	Entry No.
it-IT	Nr. movimento
nl-NL	Volgnummer
nn-NO	Postnr.
sv-SE	Löpnr

Description (`2`)

Text[250]

Language	Caption
da-DK	Beskrivelse
de-DE	Beschreibung
es-ES	Descripción
fi-FI	Kuvaus
fr-FR	Description
en-US	Description
it-IT	Descrizione
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-DE	Herkunftsart
es-ES	Tipo de fuente
fi-FI	Lähdetyyppi
fr-FR	Type origine
en-US	Source Type
it-IT	Tipo origine
nl-NL	Bronsoort
nn-NO	Kildetype
sv-SE	Ursprungstyp

User ID (`4`)

Code[35]

Language	Caption
da-DK	Bruger-id
de-DE	Benutzer-ID
es-ES	ID de usuario
fi-FI	Käyttäjätunnus
fr-FR	Code utilisateur
en-US	User ID
it-IT	ID utente
nl-NL	Gebruikers-id
nn-NO	Bruker-ID
sv-SE	Användar-ID

Reference Date (`5`)

Date

Language	Caption
da-DK	Referencedato
de-DE	Referenzdatum
es-ES	Fecha de referencia
fi-FI	Viitepäivämäärä
fr-FR	Date de référence
en-US	Reference Date
it-IT	Data riferimento
nl-NL	Referentiedatum
nn-NO	Referansedato
sv-SE	Referensdatum

DateTime Request (`6`)

DateTime

Language	Caption
da-DK	Anmodning om datotid
de-DE	DateTime-Anforderung
es-ES	Solicitud DateTime
fi-FI	DateTime-pyyntö
fr-FR	Demande dateTime
en-US	DateTime Request
it-IT	Data ora richiesta
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-DE	DateTime-Ausführung
es-ES	Ejecución de DateTime
fi-FI	DateTime-suoritus
fr-FR	Exécution dateTime
en-US	DateTime Execution
it-IT	Data ora esecuzione
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-DE	Status
es-ES	Estado
fi-FI	Tila
fr-FR	Statut
en-US	Status
it-IT	Stato
nl-NL	Status
nn-NO	Status
sv-SE	Status

Error Message (`9`)

Text[250]

Language	Caption
da-DK	Fejlmeddelelse
de-DE	Fehlermeldung
es-ES	Mensaje de error
fi-FI	Virhesanoma
fr-FR	Message d’erreur
en-US	Error Message
it-IT	Messaggio di errore
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-DE	Nein. der Details
es-ES	No. de los detalles
fi-FI	Ei. ja tiedot
fr-FR	non. de Détails
en-US	No. of Details
it-IT	Nr. di dettagli
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-DE	Ebene
es-ES	Nivel
fi-FI	Taso
fr-FR	Niveau
en-US	Level
it-IT	Livello
nl-NL	Niveau
nn-NO	Nivå
sv-SE	Nivå

Item Hierarchy Type (`12`)

Enum "EOS Item Hierarchy Type"

Language	Caption
da-DK	Elementhierarkitype
de-DE	Artikelhierarchietyp
es-ES	Tipo de jerarquía de artículos
fi-FI	Nimikehierarkian tyyppi
fr-FR	Type de hiérarchie d’élément
en-US	Item Hierarchy Type
it-IT	Tipo gerarchia articolo
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-DE	Aktuelle Oberstufe
es-ES	Nivel superior actual
fi-FI	Nykyinen ylempi taso
fr-FR	Niveau supérieur actuel
en-US	Current Upper Level
it-IT	Livello superiore attuale
nl-NL	Huidig hoger niveau
nn-NO	Gjeldende øvre nivå
sv-SE	Nuvarande övre nivå

New Upper Level Code (`14`)

Code[20]

Language	Caption
da-DK	Ny kode på øverste niveau
de-DE	Neuer Code der oberen Ebene
es-ES	Nuevo código de nivel superior
fi-FI	Uusi ylätason koodi
fr-FR	Nouveau code de niveau supérieur
en-US	New Upper Level Code
it-IT	Nuovo livello superiore
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.

EOS Labs - 20.12.2024

Table 18059975 EOS Hierarchy Relation Request

Fields

Entry No. (1)

Description (2)

Source Type (3)

User ID (4)

Reference Date (5)

DateTime Request (6)

DateTime Execution (7)

Status (8)

Error Message (9)

No. of Details (10)

Level (11)

Item Hierarchy Type (12)

Curr. Upper Level Code (13)

New Upper Level Code (14)

Methods

GetLevelDescription

Parameters / Return Value

Feedback

Entry No. (`1`)

Description (`2`)

Source Type (`3`)

User ID (`4`)

Reference Date (`5`)

DateTime Request (`6`)

DateTime Execution (`7`)

Status (`8`)

Error Message (`9`)

No. of Details (`10`)

Level (`11`)

Item Hierarchy Type (`12`)

Curr. Upper Level Code (`13`)

New Upper Level Code (`14`)