Table 18059976 EOS Hierarchy Relation Detail
Table 18059976 EOS Hierarchy Relation Detail
| Language | Caption |
|---|---|
| da-DK | Detaljer i anmodning om hierarkirelation |
| de-DE | Detail der Hierarchiebeziehungsanforderung |
| es-ES | Detalle de la solicitud de relación de jerarquía |
| fi-FI | Hierarkian suhdepyynnön tiedot |
| fr-FR | Détail de demande de relation de hiérarchie |
| en-US | Hierarchy Relation Request Detail |
| it-IT | Dettaglio richiesta relazione gerarchia |
| 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-DE | Beziehungseintrag Nr. |
| es-ES | Entrada de relación No. |
| fi-FI | Suhdetapahtuman nro |
| fr-FR | Entrée relation no. |
| en-US | Relation Entry No. |
| it-IT | Nr. movimento relazione |
| nl-NL | Relatie invoer nr. |
| nn-NO | Relasjonspostnr. |
| sv-SE | Relationspostnr |
Line No. (2)
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 |
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-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 |
Reference Date (4)
Date
FieldClass: Normal
| 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 |
Status (5)
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 |
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-DE | Code |
| es-ES | Código |
| fi-FI | Koodi |
| fr-FR | Code |
| en-US | Code |
| it-IT | Codice |
| 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-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 (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-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 |
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-DE | Alter Code der oberen Ebene |
| es-ES | Antiguo código de nivel superior |
| fi-FI | Vanha ylätason koodi |
| fr-FR | Ancien code de niveau supérieur |
| en-US | Old Upper Level Code |
| it-IT | Vecchio livello superiore |
| 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]
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-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 |
Starting Date (11)
Date
| Language | Caption |
|---|---|
| da-DK | Startdato |
| de-DE | Startdatum |
| es-ES | Fecha de inicio |
| fi-FI | Aloituspvm |
| fr-FR | Date début |
| en-US | Starting Date |
| it-IT | Data inizio |
| 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
IntegerinCode
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.