Table 18059975 EOS Hierarchy Relation Request

Table 18059975 EOS Hierarchy Relation Request

LanguageCaption
da-DKAnmodning om hierarkirelation
de-DEHierarchie-Beziehungsanforderung
es-ESSolicitud de relación de jerarquía
fi-FIHierarkian suhdepyyntö
fr-FRDemande de relation de hiérarchie
en-USHierarchy Relation Request
it-ITRichiesta relazione gerarchia
nl-NLRelatieaanvraag hiërarchie
nn-NOForespørsel om hierarkirelasjon
sv-SEBegäran om hierarkirelation

Fields

Entry No. (1)

Integer

LanguageCaption
da-DKLøbenr.
de-DELfd. Nr.
es-ESEntrada Nº
fi-FITapahtumanro
fr-FRN° séquence
en-USEntry No.
it-ITNr. movimento
nl-NLVolgnummer
nn-NOPostnr.
sv-SELöpnr

Description (2)

Text[250]

LanguageCaption
da-DKBeskrivelse
de-DEBeschreibung
es-ESDescripción
fi-FIKuvaus
fr-FRDescription
en-USDescription
it-ITDescrizione
nl-NLOmschrijving
nn-NOBeskrivelse
sv-SEBeskrivning

Source Type (3)

Option

Customer (0) , Item (1) , Vendor (2)

LanguageCaption
da-DKKildetype
de-DEHerkunftsart
es-ESTipo de fuente
fi-FILähdetyyppi
fr-FRType origine
en-USSource Type
it-ITTipo origine
nl-NLBronsoort
nn-NOKildetype
sv-SEUrsprungstyp

User ID (4)

Code[35]

LanguageCaption
da-DKBruger-id
de-DEBenutzer-ID
es-ESID de usuario
fi-FIKäyttäjätunnus
fr-FRCode utilisateur
en-USUser ID
it-ITID utente
nl-NLGebruikers-id
nn-NOBruker-ID
sv-SEAnvändar-ID

Reference Date (5)

Date

LanguageCaption
da-DKReferencedato
de-DEReferenzdatum
es-ESFecha de referencia
fi-FIViitepäivämäärä
fr-FRDate de référence
en-USReference Date
it-ITData riferimento
nl-NLReferentiedatum
nn-NOReferansedato
sv-SEReferensdatum

DateTime Request (6)

DateTime

LanguageCaption
da-DKAnmodning om datotid
de-DEDateTime-Anforderung
es-ESSolicitud DateTime
fi-FIDateTime-pyyntö
fr-FRDemande dateTime
en-USDateTime Request
it-ITData ora richiesta
nl-NLDatumtijdaanvraag
nn-NOForespørsel om dato/klokkeslett
sv-SEDateTime-begäran

DateTime Execution (7)

DateTime

LanguageCaption
da-DKUdførelse af Dato-/klokkeslæt
de-DEDateTime-Ausführung
es-ESEjecución de DateTime
fi-FIDateTime-suoritus
fr-FRExécution dateTime
en-USDateTime Execution
it-ITData ora esecuzione
nl-NLDatumuitvoering
nn-NOKjøring av datetime
sv-SEKörning av DateTime

Status (8)

Enum "EOS Hier. Rel. Request Status"

LanguageCaption
da-DKStatus
de-DEStatus
es-ESEstado
fi-FITila
fr-FRStatut
en-USStatus
it-ITStato
nl-NLStatus
nn-NOStatus
sv-SEStatus

Error Message (9)

Text[250]

LanguageCaption
da-DKFejlmeddelelse
de-DEFehlermeldung
es-ESMensaje de error
fi-FIVirhesanoma
fr-FRMessage d’erreur
en-USError Message
it-ITMessaggio di errore
nl-NLfoutmelding
nn-NOFeilmelding
sv-SEFelmeddelande

No. of Details (10)

Integer

FieldClass: FlowField

CalcFormula: Count("EOS Hierarchy Relation Detail" WHERE("Relation Entry No." = FIELD("Entry No.")))

LanguageCaption
da-DKNej. af detaljer
de-DENein. der Details
es-ESNo. de los detalles
fi-FIEi. ja tiedot
fr-FRnon. de Détails
en-USNo. of Details
it-ITNr. di dettagli
nl-NL№. van details
nn-NOnei. av detaljer
sv-SENej. 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"))

LanguageCaption
da-DKNiveau
de-DEEbene
es-ESNivel
fi-FITaso
fr-FRNiveau
en-USLevel
it-ITLivello
nl-NLNiveau
nn-NONivå
sv-SENivå

Item Hierarchy Type (12)

Enum "EOS Item Hierarchy Type"

LanguageCaption
da-DKElementhierarkitype
de-DEArtikelhierarchietyp
es-ESTipo de jerarquía de artículos
fi-FINimikehierarkian tyyppi
fr-FRType de hiérarchie d’élément
en-USItem Hierarchy Type
it-ITTipo gerarchia articolo
nl-NLItemhiërarchietype
nn-NOType for elementhierarki
sv-SEArtikelhierarkityp

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))

LanguageCaption
da-DKNuværende øverste niveau
de-DEAktuelle Oberstufe
es-ESNivel superior actual
fi-FINykyinen ylempi taso
fr-FRNiveau supérieur actuel
en-USCurrent Upper Level
it-ITLivello superiore attuale
nl-NLHuidig hoger niveau
nn-NOGjeldende øvre nivå
sv-SENuvarande ö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))

LanguageCaption
da-DKNy kode på øverste niveau
de-DENeuer Code der oberen Ebene
es-ESNuevo código de nivel superior
fi-FIUusi ylätason koodi
fr-FRNouveau code de niveau supérieur
en-USNew Upper Level Code
it-ITNuovo livello superiore
nl-NLNieuwe code op hoger niveau
nn-NONy kode på øverste nivå
sv-SENy 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



EOS Labs -