Table 18090662 EOS049 Assortment Items

Table 18090662 EOS049 Assortment Items

Language	Caption
da-DK	Udvalgsvarer
de-AT	Sortimentsartikel
de-CH	Sortimentsartikel
de-DE	Sortimentsartikel
es-ES	Productos de surtido
es-MX	Productos de surtido
fi-FI	Valikoima kohteet
fr-BE	Articles d’assortiment
fr-CA	Articles d’assortiment
fr-CH	Articles d’assortiment
fr-FR	Articles d’assortiment
en-US	Assortment Items
it-CH	Articoli assortimento
it-IT	Articoli assortimento
nb-NO	Sortiment Elementer
nl-BE	Assortiment artikelen
nl-NL	Assortiment artikelen
sv-SE	Sortimentsartiklar

Fields

Assortment Code (`1`)

Code[20]

TableRelation: "EOS049 Assortment Header"

Language	Caption
da-DK	Udvalgskode
de-AT	Sortimentscode
de-CH	Sortimentscode
de-DE	Sortimentscode
es-ES	Cód. surtido
es-MX	Cód. surtido
fi-FI	Valikoimakoodi
fr-BE	Code d’assortiment
fr-CA	Code d’assortiment
fr-CH	Code d’assortiment
fr-FR	Code d’assortiment
en-US	Assortment Code
it-CH	Codice assortimento
it-IT	Codice assortimento
nb-NO	Utvalgskode
nl-BE	Assortimentscode
nl-NL	Assortimentscode
sv-SE	Kod för sortiment

Line No. (`2`)

Integer

Language	Caption
da-DK	Linjenr.
de-AT	Zeilennr.
de-CH	Zeilennr.
de-DE	Zeilennr.
es-ES	N.º línea
es-MX	N.º línea
fi-FI	Rivinro
fr-BE	N° ligne
fr-CA	N° ligne
fr-CH	N° ligne
fr-FR	N° ligne
en-US	Line No.
it-CH	Nr. riga
it-IT	Nr. riga
nb-NO	Linjenr.
nl-BE	Regelnr.
nl-NL	Regelnr.
sv-SE	Radnr

Item No. (`3`)

Code[20]

TableRelation: Item

Language	Caption
da-DK	Varenr.
de-AT	Artikelnr.
de-CH	Artikelnr.
de-DE	Artikelnr.
es-ES	N.º artículo
es-MX	N.º artículo
fi-FI	Nimikkeen nro
fr-BE	N° article
fr-CA	N° article
fr-CH	N° article
fr-FR	N° article
en-US	Item No.
it-CH	Nr. articolo
it-IT	Nr. articolo
nb-NO	Varenr.
nl-BE	Artikelnr.
nl-NL	Artikelnr.
sv-SE	Artikelnr

Item Description (`4`)

Text[100]

FieldClass: FlowField

CalcFormula: Lookup(Item.Description WHERE("No." = FIELD("Item No.")))

Language	Caption
da-DK	Varebeskrivelse
de-AT	Artikelbeschreibung
de-CH	Artikelbeschreibung
de-DE	Artikelbeschreibung
es-ES	Descripción producto
es-MX	Descripción producto
fi-FI	Nimikkeen kuvaus
fr-BE	Description article
fr-CA	Description article
fr-CH	Description article
fr-FR	Description article
en-US	Item Description
it-CH	Descrizione articolo
it-IT	Descrizione articolo
nb-NO	Varebeskrivelse
nl-BE	Artikelomschrijving
nl-NL	Artikelomschrijving
sv-SE	Artikelbeskrivning

Assortment Description (`5`)

Text[100]

FieldClass: FlowField

CalcFormula: Lookup("EOS049 Assortment Header".Description WHERE(Code = FIELD("Assortment Code")))

Language	Caption
da-DK	Beskrivelse af udvalg
de-AT	Sortimentsbeschreibung
de-CH	Sortimentsbeschreibung
de-DE	Sortimentsbeschreibung
es-ES	Descripción surtido
es-MX	Descripción surtido
fi-FI	Valikoiman kuvaus
fr-BE	Description de l’assortiment
fr-CA	Description de l’assortiment
fr-CH	Description de l’assortiment
fr-FR	Description de l’assortiment
en-US	Assortment Description
it-CH	Assortimento Descrizione
it-IT	Assortimento Descrizione
nb-NO	Beskrivelse av sortiment
nl-BE	Beschrijving van het assortiment
nl-NL	Beschrijving van het assortiment
sv-SE	Sortiment Beskrivning

Alternativity Group Code (`9`)

Code[20]

Language	Caption
da-DK	Gruppekode for alternativitet
de-AT	Alternativitätsgruppencode
de-CH	Alternativitätsgruppencode
de-DE	Alternativitätsgruppencode
es-ES	Cód. grupo alternatividad
es-MX	Cód. grupo alternatividad
fi-FI	Alternativity-ryhmän koodi
fr-BE	Code de groupe alternativité
fr-CA	Code de groupe alternativité
fr-CH	Code de groupe alternativité
fr-FR	Code de groupe alternativité
en-US	Alternativity Group Code
it-CH	Cod. gruppo alternatività
it-IT	Cod. gruppo alternatività
nb-NO	Alternativity Gruppe Kode
nl-BE	Alternativity Group Code
nl-NL	Alternativity Group Code
sv-SE	Kod för Alternativity-grupp

Code (`23`)

Code[50]

TableRelation: IF (Type = CONST("Item")) Item ELSE IF (Type = CONST(EAN)) Item."EOS049 EAN Code"

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
sv-SE	Kod

Description (`24`)

Text[100]

Language	Caption
da-DK	Beskrivelse
de-AT	Beschreibung
de-CH	Beschreibung
de-DE	Beschreibung
es-ES	Descripción
es-MX	Descripción
fi-FI	Kuvaus
fr-BE	Description
fr-CA	Description
fr-CH	Description
fr-FR	Description
en-US	Description
it-CH	Descrizione
it-IT	Descrizione
nb-NO	Beskrivelse
nl-BE	Omschrijving
nl-NL	Omschrijving
sv-SE	Beskrivning

Type (`25`)

enum "EOS049 Assortment Line Type"

Language	Caption
da-DK	Type
de-AT	Art
de-CH	Art
de-DE	Art
es-ES	Tipo
es-MX	Tipo
fi-FI	Tyyppi
fr-BE	Type
fr-CA	Type
fr-CH	Type
fr-FR	Type
en-US	Type
it-CH	Tipo
it-IT	Tipo
nb-NO	Type
nl-BE	Soort
nl-NL	Soort
sv-SE	Typ

EAN Code (`26`)

Code[20]

Language	Caption
da-DK	EAN-kode
de-AT	EAN-Code
de-CH	EAN-Code
de-DE	EAN-Code
es-ES	Código EAN
es-MX	Código EAN
fi-FI	EAN-koodi
fr-BE	EAN Code
fr-CA	EAN Code
fr-CH	EAN Code
fr-FR	EAN Code
en-US	EAN Code
it-CH	Cod. EAN
it-IT	Cod. EAN
nb-NO	EAN-kode
nl-BE	EAN-code
nl-NL	EAN-code
sv-SE	EAN-kod

Item Filter (`30`)

Blob

Language	Caption
da-DK	Varefilter
de-AT	Artikelfilter
de-CH	Artikelfilter
de-DE	Artikelfilter
es-ES	Filtro producto
es-MX	Filtro producto
fi-FI	Nimikesuodatus
fr-BE	Filtre article
fr-CA	Filtre article
fr-CH	Filtre article
fr-FR	Filtre article
en-US	Item Filter
it-CH	Filtro articolo
it-IT	Filtro articolo
nb-NO	Varefilter
nl-BE	Artikelfilter
nl-NL	Artikelfilter
sv-SE	Artikelfilter

Methods

SuspendStatusCheck

procedure SuspendStatusCheck(Suspend: Boolean)

Parameters / Return Value

Suspend Boolean

GetTableCaption

procedure GetTableCaption(ID: Integer): Text

Parameters / Return Value

ID Integer
Returns Text

GetViewItemFilter

procedure GetViewItemFilter() Result: Text

Parameters / Return Value

Returns Text

OpenItemFilter

procedure OpenItemFilter(Editable: Boolean): Boolean

Parameters / Return Value

Editable Boolean
Returns Boolean

SetItemTableFilter

procedure SetItemTableFilter("Filter": Text)

Parameters / Return Value

Filter 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 18090662 EOS049 Assortment Items

Fields

Assortment Code (1)

Line No. (2)

Item No. (3)

Item Description (4)

Assortment Description (5)

Alternativity Group Code (9)

Code (23)

Description (24)

Type (25)

EAN Code (26)

Item Filter (30)

Methods

SuspendStatusCheck

Parameters / Return Value

GetTableCaption

Parameters / Return Value

GetViewItemFilter

Parameters / Return Value

OpenItemFilter

Parameters / Return Value

SetItemTableFilter

Parameters / Return Value

Feedback

Assortment Code (`1`)

Line No. (`2`)

Item No. (`3`)

Item Description (`4`)

Assortment Description (`5`)

Alternativity Group Code (`9`)

Code (`23`)

Description (`24`)

Type (`25`)

EAN Code (`26`)

Item Filter (`30`)