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.