Table 18059976 EOS Hierarchy Relation Detail

Table 18059976 EOS Hierarchy Relation Detail

Language	Caption
da-DK	Detaljer i anmodning om hierarkirelation
de-AT	Detail der Hierarchiebeziehungsanforderung
de-CH	Detail der Hierarchiebeziehungsanforderung
de-DE	Detail der Hierarchiebeziehungsanforderung
es-ES	Detalle de la solicitud de relación de jerarquía
es-MX	Detalle de la solicitud de relación de jerarquía
fi-FI	Hierarkian suhdepyynnön tiedot
fr-BE	Détail de demande de relation de hiérarchie
fr-CA	Détail de demande de relation de hiérarchie
fr-CH	Détail de demande de relation de hiérarchie
fr-FR	Détail de demande de relation de hiérarchie
en-US	Hierarchy Relation Request Detail
it-CH	Dettaglio richiesta relazione gerarchia
it-IT	Dettaglio richiesta relazione gerarchia
nb-NO	Detaljer for hierarkirelasjonsforespørsel
nl-BE	Detail hiërarchierelatieaanvraag
nl-NL	Detail hiërarchierelatieaanvraag
nn-NO	Detaljer for hierarkirelasjonsforespørsel
sv-SE	Information om hierarkirelationsbegäran

Fields

Relation Entry No. (`1`)

Integer

Language	Caption
da-DK	Relationspostnr.
de-AT	Beziehungseintrag Nr.
de-CH	Beziehungseintrag Nr.
de-DE	Beziehungseintrag Nr.
es-ES	Entrada de relación No.
es-MX	Entrada de relación No.
fi-FI	Suhdetapahtuman nro
fr-BE	Entrée relation no.
fr-CA	Entrée relation no.
fr-CH	Entrée relation no.
fr-FR	Entrée relation no.
en-US	Relation Entry No.
it-CH	Nr. movimento relazione
it-IT	Nr. movimento relazione
nb-NO	Relasjonspostnr.
nl-BE	Relatie invoer nr.
nl-NL	Relatie invoer nr.
nn-NO	Relasjonspostnr.
sv-SE	Relationspostnr

Line No. (`2`)

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

Source Type (`3`)

Option

FieldClass: FlowField

CalcFormula: Lookup("EOS Hierarchy Relation Request"."Source Type" WHERE("Entry No." = FIELD("Relation Entry No.")))

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

Reference Date (`4`)

Date

FieldClass: Normal

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

Status (`5`)

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

Code (`6`)

Code[20]

TableRelation: if ("Source Type" = const(Customer), "Level" = const(1)) "EOS Customer Hierarchy".Code where("Level" = const(1)) else if ("Source Type" = const(Customer), "Level" = const(2)) "EOS Customer Hierarchy".Code where("Level" = const(2)) else if ("Source Type" = const(Customer), "Level" = const(3)) "EOS Customer Hierarchy".Code where("Level" = const(3)) else if ("Source Type" = const(Customer), "Level" = const(4)) "EOS Customer Hierarchy".Code where("Level" = const(4)) else if ("Source Type" = const(Customer), "Level" = const(5)) "EOS Customer Hierarchy".Code where("Level" = const(5)) else if ("Source Type" = const(Customer), "Level" = const(6)) "EOS Customer Hierarchy".Code where("Level" = const(6)) else if ("Source Type" = const(Customer), "Level" = const(7)) "EOS Customer Hierarchy".Code where("Level" = const(7)) else if ("Source Type" = const(Customer), "Level" = const(8)) "EOS Customer Hierarchy".Code where("Level" = const(8)) else if ("Source Type" = const(Customer), "Level" = const(9)) "EOS Customer Hierarchy".Code where("Level" = const(9)) else if ("Source Type" = const(Customer), "Level" = const(10)) "EOS Customer Hierarchy".Code where("Level" = const(10)) else if ("Source Type" = const(Customer), "Level" = const(11)) "EOS Customer Hierarchy".Code where("Level" = const(11)) else if ("Source Type" = const(Vendor), "Level" = const(1)) "EOS Vendor Hierarchy".Code where("Level" = const(1)) else if ("Source Type" = const(Vendor), "Level" = const(2)) "EOS Vendor Hierarchy".Code where("Level" = const(2)) else if ("Source Type" = const(Vendor), "Level" = const(3)) "EOS Vendor Hierarchy".Code where("Level" = const(3)) else if ("Source Type" = const(Vendor), "Level" = const(4)) "EOS Vendor Hierarchy".Code where("Level" = const(4)) else if ("Source Type" = const(Vendor), "Level" = const(5)) "EOS Vendor Hierarchy".Code where("Level" = const(5)) else if ("Source Type" = const(Vendor), "Level" = const(6)) "EOS Vendor Hierarchy".Code where("Level" = const(6)) else if ("Source Type" = const(Vendor), "Level" = const(7)) "EOS Vendor Hierarchy".Code where("Level" = const(7)) else if ("Source Type" = const(Vendor), "Level" = const(8)) "EOS Vendor Hierarchy".Code where("Level" = const(8)) else if ("Source Type" = const(Vendor), "Level" = const(9)) "EOS Vendor Hierarchy".Code where("Level" = const(9)) else if ("Source Type" = const(Vendor), "Level" = const(10)) "EOS Vendor Hierarchy".Code where("Level" = const(10)) else if ("Source Type" = const(Vendor), "Level" = const(11)) "EOS Vendor Hierarchy".Code where("Level" = const(11)) else if ("Source Type" = const(Item), "Level" = const(1)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(1)) else if ("Source Type" = const(Item), "Level" = const(2)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(2)) else if ("Source Type" = const(Item), "Level" = const(3)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(3)) else if ("Source Type" = const(Item), "Level" = const(4)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(4)) else if ("Source Type" = const(Item), "Level" = const(5)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(5)) else if ("Source Type" = const(Item), "Level" = const(6)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(6)) else if ("Source Type" = const(Item), "Level" = const(7)) "EOS Item Hierarchy".Code where("Type" = field("Item Hierarchy Type"), "Level" = const(7))

Language	Caption
da-DK	Kode
de-AT	Code
de-CH	Code
de-DE	Code
es-ES	Código
es-MX	Código
fi-FI	Koodi
fr-BE	Code
fr-CA	Code
fr-CH	Code
fr-FR	Code
en-US	Code
it-CH	Codice
it-IT	Codice
nb-NO	Kode
nl-BE	Code
nl-NL	Code
nn-NO	Koden
sv-SE	Kod

Level (`7`)

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 (`8`)

Enum "EOS Item Hierarchy Type"

FieldClass: FlowField

CalcFormula: Lookup("EOS Hierarchy Relation Request"."Item Hierarchy Type" WHERE("Entry No." = FIELD("Relation Entry No.")))

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

Old Upper Level Code (`9`)

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	Gammel kode på øverste niveau
de-AT	Alter Code der oberen Ebene
de-CH	Alter Code der oberen Ebene
de-DE	Alter Code der oberen Ebene
es-ES	Antiguo código de nivel superior
es-MX	Antiguo código de nivel superior
fi-FI	Vanha ylätason koodi
fr-BE	Ancien code de niveau supérieur
fr-CA	Ancien code de niveau supérieur
fr-CH	Ancien code de niveau supérieur
fr-FR	Ancien code de niveau supérieur
en-US	Old Upper Level Code
it-CH	Vecchio livello superiore
it-IT	Vecchio livello superiore
nb-NO	Gammel kode på øverste nivå
nl-BE	Oude code op hoger niveau
nl-NL	Oude code op hoger niveau
nn-NO	Gammel kode på øverste nivå
sv-SE	Gammal kod på övre nivå

New Upper Level Code (`10`)

Code[20]

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

Starting Date (`11`)

Date

Language	Caption
da-DK	Startdato
de-AT	Startdatum
de-CH	Startdatum
de-DE	Startdatum
es-ES	Fecha de inicio
es-MX	Fecha de inicio
fi-FI	Aloituspvm
fr-BE	Date début
fr-CA	Date début
fr-CH	Date début
fr-FR	Date début
en-US	Starting Date
it-CH	Data inizio
it-IT	Data inizio
nb-NO	Startdato
nl-BE	Begindatum
nl-NL	Begindatum
nn-NO	Startdato
sv-SE	Startdatum

Methods

GetLevelDescription

procedure GetLevelDescription(LevelP: Integer; inCode: Code[20]; ItemHierarchyType: Enum "EOS Item Hierarchy Type"): Text

Parameters / Return Value

LevelP Integer
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 - 28.06.2024

Table 18059976 EOS Hierarchy Relation Detail

Fields

Relation Entry No. (1)

Line No. (2)

Source Type (3)

Reference Date (4)

Status (5)

Code (6)

Level (7)

Item Hierarchy Type (8)

Old Upper Level Code (9)

New Upper Level Code (10)

Starting Date (11)

Methods

GetLevelDescription

Parameters / Return Value

Feedback

Relation Entry No. (`1`)

Line No. (`2`)

Source Type (`3`)

Reference Date (`4`)

Status (`5`)

Code (`6`)

Level (`7`)

Item Hierarchy Type (`8`)

Old Upper Level Code (`9`)

New Upper Level Code (`10`)

Starting Date (`11`)