Table 18090661 EOS049 Assortment Line

Table 18090661 EOS049 Assortment Line

Language	Caption
de-DE	Sortimentslinie
en-US	Assortment Line
it-IT	Linea assortimento

Fields

Assortment Code (`1`)

Code[20]

TableRelation: "EOS049 Assortment Header"

Language	Caption
de-DE	Sortimentscode
en-US	Assortment Code
it-IT	Codice assortimento

Line No. (`2`)

Integer

Language	Caption
de-DE	Zeilennr.
en-US	Line No.
it-IT	Nr. riga

Code (`3`)

Code[20]

TableRelation: if (Type = const("Item")) Item else if (Type = const("EAN")) Item."EOS049 EAN Code" where("EOS049 EAN Code" = filter(<> '')) else if (type = const("Item Hierarchy")) "EOS Item Hierarchy".Code where(Level = field("Hierarchy Level")) else if (type = const("Item Cluster")) "EOS Item Cluster Header".Code where(Status = const(Certified))

Language	Caption
de-DE	Code
en-US	Code
it-IT	Codice

Description (`4`)

Text[100]

Language	Caption
de-DE	Beschreibung
en-US	Description
it-IT	Descrizione

Minimum Number (`5`)

Integer

Obsolete

Pending: Moved to lines (22.0)

Language	Caption
de-DE	Mindestanzahl
en-US	Minimum Number
it-IT	Numero minimo

Minimum Reference No. (`6`)

Integer

Language	Caption
de-DE	Mindestanzahl Referenzen
en-US	Minimum Reference No.
it-IT	Numero minimo di referenze

Type (`7`)

Enum "EOS049 Assortment Line Type"

Language	Caption
de-DE	Art
en-US	Type
it-IT	Tipo

Item Filter (`8`)

Blob

Language	Caption
de-DE	Artikelfilter
en-US	Item Filter
it-IT	Filtro articolo

Alternativity Group Code (`9`)

Code[20]

Language	Caption
de-DE	Alternativitätsgruppencode
en-US	Line Group
it-IT	Cod. gruppo alternatività

Filter Type (`11`)

Enum "EOS Assortment Filter Type"

Language	Caption
de-DE	Filterart
en-US	Filter Type
it-IT	Tipo di filtro

Hierarchy Level (`12`)

Integer

TableRelation: "EOS Item Hierarchy Level".Level

Language	Caption
de-DE	Hierarchieebene
en-US	Hierarchy Level
it-IT	Livello gerarchia

Hierarchy Type (`13`)

Enum "EOS Item Hierarchy Type"

Language	Caption
de-DE	Hierarchieebene
en-US	Hierarchy Level
it-IT	Livello gerarchia

Starting Date (`14`)

Date

Language	Caption
de-DE	Startdatum
en-US	Starting Date
it-IT	Data inizio

Ending Date (`15`)

Date

Language	Caption
de-DE	Enddatum
en-US	Ending Date
it-IT	Data fine

Unit of Measure (`16`)

Code[10]

TableRelation: "Unit of Measure"

Language	Caption
de-DE	Einheit
en-US	Unit of Measure
it-IT	Unità di misura

Binding Unit of Measure (`17`)

Boolean

Language	Caption
de-DE	Verbindliche Maßeinheit
en-US	Binding Unit of Measure
it-IT	Unità di misura vincolante

Minimum Total Quantity (`18`)

Integer

Language	Caption
de-DE	Mindest-Gesamtmenge
en-US	Minimum Total Quantity
it-IT	Quantità totale minima

Minimum Reference Quantity (`19`)

Integer

Language	Caption
de-DE	Mindestmenge pro Referenz
en-US	Minimum Reference Quantity
it-IT	Quantità minima per referenza

Minimum Total Amount (`20`)

Decimal

Language	Caption
de-DE	Mindest-Gesamtbetrag
en-US	Minimum Total Amount
it-IT	Importo totale minimo

Minimum Reference Amount (`21`)

Decimal

Language	Caption
de-DE	Mindestbetrag pro Referenz
en-US	Minimum Reference Amount
it-IT	Importo minimo per referenza

Maximum Reference No. (`30`)

Integer

Language	Caption
de-DE	Maximale Referenz-Nr.
en-US	Maximum Reference No.
it-IT	Numero massimo di referenze

Maximum Total Quantity (`31`)

Integer

Language	Caption
de-DE	Maximale Gesamtmenge
en-US	Maximum Total Quantity
it-IT	Quantità totale massima

Maximum Reference Quantity (`32`)

Integer

Language	Caption
de-DE	Maximale Referenzmenge
en-US	Maximum Reference Quantity
it-IT	Quantità massima per referenza

Maximum Total Amount (`33`)

Decimal

Language	Caption
de-DE	Maximaler Gesamtbetrag
en-US	Maximum Total Amount
it-IT	Importo totale massimo

Maximum Reference Amount (`34`)

Decimal

Language	Caption
de-DE	Maximaler Gesamtbetrag
en-US	Maximum Total Amount
it-IT	Importo totale massimo

Pallet Minimum Number (`500`)

Decimal

Language	Caption
de-DE	Mindestanzahl an Paletten
en-US	Pallet Minimum Number
it-IT	Numero minimo pallet

Item Trade Attribute 1 (`7800`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 1
en-US	Item Trade Attribute 1
it-IT	Attributo di scambio di oggetti 1

Item Trade Attribute 2 (`7801`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 2
en-US	Item Trade Attribute 2
it-IT	Attributo di scambio di oggetti 2

Item Trade Attribute 3 (`7802`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 3
en-US	Item Trade Attribute 3
it-IT	Attributo di scambio di oggetti 3

Item Trade Attribute 4 (`7803`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 4
en-US	Item Trade Attribute 4
it-IT	Attributo di scambio dell’oggetto 4

Item Trade Attribute 5 (`7804`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 5
en-US	Item Trade Attribute 5
it-IT	Attributo di scambio di oggetti 5

Item Trade Attribute 6 (`7805`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 6
en-US	Item Trade Attribute 6
it-IT	Attributo di scambio di oggetti 6

Item Trade Attribute 7 (`7806`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 7
en-US	Item Trade Attribute 7
it-IT	Attributo di scambio di oggetti 7

Item Trade Attribute 8 (`7807`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 8
en-US	Item Trade Attribute 8
it-IT	Attributo di scambio di oggetti 8

Item Trade Attribute 9 (`7808`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 9
en-US	Item Trade Attribute 9
it-IT	Attributo commerciale articolo 9

Item Trade Attribute 10 (`7809`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 10
en-US	Item Trade Attribute 10
it-IT	Attributo commerciale oggetto 10

Sales Line Trade Attribute 1 (`7850`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 1
en-US	Sales Line Trade Attribute 1
it-IT	Attributo commerciale della linea di vendita 1

Sales Line Trade Attribute 2 (`7851`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 2
en-US	Sales Line Trade Attribute 2
it-IT	Attributo commerciale della linea di vendita 2

Sales Line Trade Attribute 3 (`7852`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 3
en-US	Sales Line Trade Attribute 3
it-IT	Attributo commerciale della linea di vendita 3

Sales Line Trade Attribute 4 (`7853`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 4
en-US	Sales Line Trade Attribute 4
it-IT	Attributo commerciale della linea di vendita 4

Sales Line Trade Attribute 5 (`7854`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 5
en-US	Sales Line Trade Attribute 5
it-IT	Attributo Sales Line Trade 5

Sales Line Trade Attribute 6 (`7855`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 6
en-US	Sales Line Trade Attribute 6
it-IT	Attributo Sales Line Trade 6

Sales Line Trade Attribute 7 (`7856`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 7
en-US	Sales Line Trade Attribute 7
it-IT	Attributo commerciale della linea di vendita 7

Sales Line Trade Attribute 8 (`7857`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 8
en-US	Sales Line Trade Attribute 8
it-IT	Attributo commerciale della linea di vendita 8

Sales Line Trade Attribute 9 (`7858`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 9
en-US	Sales Line Trade Attribute 9
it-IT	Attributo commerciale della linea di vendita 9

Sales Line Trade Attribute 10 (`7859`)

Text[250]

Language	Caption
de-DE	VK-Zeile Handelsattribut 10
en-US	Sales Line Trade Attribute 10
it-IT	Attributo commerciale della linea di vendita 10

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

Table 18090661 EOS049 Assortment Line

Fields

Assortment Code (1)

Line No. (2)

Code (3)

Description (4)

Minimum Number (5)

Obsolete

Minimum Reference No. (6)

Type (7)

Item Filter (8)

Alternativity Group Code (9)

Filter Type (11)

Hierarchy Level (12)

Hierarchy Type (13)

Starting Date (14)

Ending Date (15)

Unit of Measure (16)

Binding Unit of Measure (17)

Minimum Total Quantity (18)

Minimum Reference Quantity (19)

Minimum Total Amount (20)

Minimum Reference Amount (21)

Maximum Reference No. (30)

Maximum Total Quantity (31)

Maximum Reference Quantity (32)

Maximum Total Amount (33)

Maximum Reference Amount (34)

Pallet Minimum Number (500)

Item Trade Attribute 1 (7800)

Item Trade Attribute 2 (7801)

Item Trade Attribute 3 (7802)

Item Trade Attribute 4 (7803)

Item Trade Attribute 5 (7804)

Item Trade Attribute 6 (7805)

Item Trade Attribute 7 (7806)

Item Trade Attribute 8 (7807)

Item Trade Attribute 9 (7808)

Item Trade Attribute 10 (7809)

Sales Line Trade Attribute 1 (7850)

Sales Line Trade Attribute 2 (7851)

Sales Line Trade Attribute 3 (7852)

Sales Line Trade Attribute 4 (7853)

Sales Line Trade Attribute 5 (7854)

Sales Line Trade Attribute 6 (7855)

Sales Line Trade Attribute 7 (7856)

Sales Line Trade Attribute 8 (7857)

Sales Line Trade Attribute 9 (7858)

Sales Line Trade Attribute 10 (7859)

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

Code (`3`)

Description (`4`)

Minimum Number (`5`)

Minimum Reference No. (`6`)

Type (`7`)

Item Filter (`8`)

Alternativity Group Code (`9`)

Filter Type (`11`)

Hierarchy Level (`12`)

Hierarchy Type (`13`)

Starting Date (`14`)

Ending Date (`15`)

Unit of Measure (`16`)

Binding Unit of Measure (`17`)

Minimum Total Quantity (`18`)

Minimum Reference Quantity (`19`)

Minimum Total Amount (`20`)

Minimum Reference Amount (`21`)

Maximum Reference No. (`30`)

Maximum Total Quantity (`31`)

Maximum Reference Quantity (`32`)

Maximum Total Amount (`33`)

Maximum Reference Amount (`34`)

Pallet Minimum Number (`500`)

Item Trade Attribute 1 (`7800`)

Item Trade Attribute 2 (`7801`)

Item Trade Attribute 3 (`7802`)

Item Trade Attribute 4 (`7803`)

Item Trade Attribute 5 (`7804`)

Item Trade Attribute 6 (`7805`)

Item Trade Attribute 7 (`7806`)

Item Trade Attribute 8 (`7807`)

Item Trade Attribute 9 (`7808`)

Item Trade Attribute 10 (`7809`)

Sales Line Trade Attribute 1 (`7850`)

Sales Line Trade Attribute 2 (`7851`)

Sales Line Trade Attribute 3 (`7852`)

Sales Line Trade Attribute 4 (`7853`)

Sales Line Trade Attribute 5 (`7854`)

Sales Line Trade Attribute 6 (`7855`)

Sales Line Trade Attribute 7 (`7856`)

Sales Line Trade Attribute 8 (`7857`)

Sales Line Trade Attribute 9 (`7858`)

Sales Line Trade Attribute 10 (`7859`)