Table 18125995 EOS049 Duplicated Sales Line

Table 18125995 EOS049 Duplicated Sales Line

Language	Caption
da-DK	Salgsprislinjer - dubletter
de-AT	Verkaufspreiszeilen - Duplikate
de-CH	Verkaufspreiszeilen - Duplikate
de-DE	Verkaufspreiszeilen - Duplikate
es-ES	Líneas precio de venta - Duplicados
es-MX	Líneas precio de venta - Duplicados
fi-FI	Myyntihintarivit - Kaksoiskappaleet
fr-BE	Lignes de prix de vente - Doublons
fr-CA	Lignes de prix de vente - Doublons
fr-CH	Lignes de prix de vente - Doublons
fr-FR	Lignes de prix de vente - Doublons
en-US	Sales Price Lines - Duplicates
it-CH	Righe prezzo di vendita - Duplicati
it-IT	Righe prezzo di vendita - Duplicati
nb-NO	Salgsprislinjer - Duplikater
nl-BE	Verkoopprijsregels - Duplicaat
nl-NL	Verkoopprijsregels - Duplicaat
sv-SE	Försäljningsprisrader - dubbletter

Fields

Sales Type (`1`)

enum "EOS049 Sales Price Type"

Language	Caption
da-DK	Salgstype
de-AT	Verkaufsart
de-CH	Verkaufsart
de-DE	Verkaufsart
es-ES	Tipo de venta
es-MX	Tipo de venta
fi-FI	Myynnin tyyppi
fr-BE	Type vente
fr-CA	Type vente
fr-CH	Type vente
fr-FR	Type vente
en-US	Sales Type
it-CH	Tipo vendita
it-IT	Tipo vendita
nb-NO	Salgstype
nl-BE	Verkoopsoort
nl-NL	Verkoopsoort
sv-SE	Förs.typ

Code (`2`)

Code[20]

TableRelation: if ("Sales Type" = const(Price)) "EOS049 Sales Price Header".Code else if ("Sales Type" = const(Discount)) "EOS049 Sales Disc. Header".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 (`3`)

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

Line No. - Customer (`4`)

Integer

Language	Caption
da-DK	Linjenr. - Debitor
de-AT	Linie Nr. - Kunde
de-CH	Linie Nr. - Kunde
de-DE	Linie Nr. - Kunde
es-ES	N.º línea - Cliente
es-MX	N.º línea - Cliente
fi-FI	Rivinro - Asiakas
fr-BE	Numéro de ligne - Client
fr-CA	Numéro de ligne - Client
fr-CH	Numéro de ligne - Client
fr-FR	Numéro de ligne - Client
en-US	Line No. - Customer
it-CH	Nr. riga - Cliente
it-IT	Nr. riga - Cliente
nb-NO	Linjenr. - Kunde
nl-BE	Regel nr. - Klant
nl-NL	Regel nr. - Klant
sv-SE	Linje nr - Kund

Line No. - Item (`5`)

Integer

Language	Caption
da-DK	Linjenr. - Vare
de-AT	Zeile Nr. - Artikel
de-CH	Zeile Nr. - Artikel
de-DE	Zeile Nr. - Artikel
es-ES	N.º línea - Producto
es-MX	N.º línea - Producto
fi-FI	Rivinro - Nimike
fr-BE	Ligne no - Article
fr-CA	Ligne no - Article
fr-CH	Ligne no - Article
fr-FR	Ligne no - Article
en-US	Line No. - Item
it-CH	Nr. Riga - Articolo
it-IT	Nr. Riga - Articolo
nb-NO	Linjenr. - vare
nl-BE	Regel nr. - Object
nl-NL	Regel nr. - Object
sv-SE	Radnr - artikel

Type - Customer (`10`)

enum "EOS049 Sales Price Customer 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

Level - Customer (`11`)

Integer

TableRelation: "EOS Customer Hierarchy Level".Level

Language	Caption
da-DK	Niveau
de-AT	Ebene
de-CH	Ebene
de-DE	Ebene
es-ES	Nivel
es-MX	Nivel
fi-FI	Taso
fr-BE	Niveau
fr-CA	Niveau
fr-CH	Niveau
fr-FR	Niveau
en-US	Level
it-CH	Livello
it-IT	Livello
nb-NO	Nivå
nl-BE	Niveau
nl-NL	Niveau
sv-SE	Nivå

Code - Customer (`12`)

Code[20]

TableRelation: if ("Type - Customer" = const(" ")) "Standard Text" else if ("Type - Customer" = const("Customer Price Group")) "Customer Price Group" else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(1)) "EOS Customer Hierarchy".Code where(Level = const(1)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(2)) "EOS Customer Hierarchy".Code where(Level = const(2)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(3)) "EOS Customer Hierarchy".Code where(Level = const(3)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(4)) "EOS Customer Hierarchy".Code where(Level = const(4)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(5)) "EOS Customer Hierarchy".Code where(Level = const(5)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(6)) "EOS Customer Hierarchy".Code where(Level = const(6)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(7)) "EOS Customer Hierarchy".Code where(Level = const(7)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(8)) "EOS Customer Hierarchy".Code where(Level = const(8)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(9)) "EOS Customer Hierarchy".Code where(Level = const(9)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(10)) "EOS Customer Hierarchy".Code where(Level = const(10)) else if ("Type - Customer" = const("Hierarchy Level"), "Level - Customer" = const(11)) "EOS Customer Hierarchy".Code where(Level = const(11))

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 - Customer (`13`)

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

Description 2 - Customer (`14`)

Text[100]

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

Type - Item (`20`)

enum "EOS049 Discount Item 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

Level - Item (`21`)

Integer

Language	Caption
da-DK	Niveau
de-AT	Ebene
de-CH	Ebene
de-DE	Ebene
es-ES	Nivel
es-MX	Nivel
fi-FI	Taso
fr-BE	Niveau
fr-CA	Niveau
fr-CH	Niveau
fr-FR	Niveau
en-US	Level
it-CH	Livello
it-IT	Livello
nb-NO	Nivå
nl-BE	Niveau
nl-NL	Niveau
sv-SE	Nivå

Code - Item (`22`)

Code[20]

TableRelation: if ("Type - Item" = const(" ")) "Standard Text" else if ("Type - Item" = const(Item)) Item else if ("Type - Item" = const("Hierarchy Level"), "Level - Item" = const(1)) "EOS Item Hierarchy".Code where(Type = const(General), Level = const(1)) else if ("Type - Item" = const("Hierarchy Level"), "Level - Item" = const(2)) "EOS Item Hierarchy".Code where(Type = const(General), Level = const(2)) else if ("Type - Item" = const("Hierarchy Level"), "Level - Item" = const(3)) "EOS Item Hierarchy".Code where(Type = const(General), Level = const(3)) else if ("Type - Item" = const("Hierarchy Level"), "Level - Item" = const(4)) "EOS Item Hierarchy".Code where(Type = const(General), Level = const(4)) else if ("Type - Item" = const("Hierarchy Level"), "Level - Item" = const(5)) "EOS Item Hierarchy".Code where(Type = const(General), Level = const(5)) else if ("Type - Item" = const("Hierarchy Level"), "Level - Item" = const(6)) "EOS Item Hierarchy".Code where(Type = const(General), Level = const(6)) else if ("Type - Item" = const("Hierarchy Level"), "Level - Item" = const(7)) "EOS Item Hierarchy".Code where(Type = const(General), Level = const(7)) else if ("Type - Item" = const("Item Discount Group")) "Item Discount Group".Code else if ("Type - Item" = const("Item Promotion Group")) "EOS049 Promotion Group".Code where(Type = const(Item)) else if ("Type - Item" = const("Item Category Code")) "Item Category".Code else if ("Type - Item" = const("Item Cluster")) "EOS Item Cluster Header".Code where(Status = const(Certified))

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

Item No. (`23`)

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

Description - Item (`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

Description 2 - Item (`25`)

Text[100]

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

Currency Code (`30`)

Code[10]

TableRelation: Currency

Language	Caption
da-DK	Valutakode
de-AT	Währungscode
de-CH	Währungscode
de-DE	Währungscode
es-ES	Cód. divisa
es-MX	Cód. divisa
fi-FI	Valuutan koodi
fr-BE	Code devise
fr-CA	Code devise
fr-CH	Code devise
fr-FR	Code devise
en-US	Currency Code
it-CH	Cod. valuta
it-IT	Cod. valuta
nb-NO	Valutakode
nl-BE	Valutacode
nl-NL	Valutacode
sv-SE	Valutakod

Unit Price (`31`)

Decimal

Language	Caption
da-DK	Enhedspris
de-AT	VK-Preis
de-CH	VK-Preis
de-DE	VK-Preis
es-ES	Precio unitario
es-MX	Precio unitario
fi-FI	Yksikköhinta
fr-BE	Prix unitaire
fr-CA	Prix unitaire
fr-CH	Prix unitaire
fr-FR	Prix unitaire
en-US	Unit Price
it-CH	Prezzo unitario
it-IT	Prezzo unitario
nb-NO	Salgspris
nl-BE	Eenheidsprijs
nl-NL	Eenheidsprijs
sv-SE	A-pris

Starting Date (`34`)

Date

Language	Caption
da-DK	Startdato
de-AT	Startdatum
de-CH	Startdatum
de-DE	Startdatum
es-ES	Fecha inicial
es-MX	Fecha inicial
fi-FI	Aloituspvm
fr-BE	Date début
fr-CA	Date début
fr-CH	Date début
fr-FR	Date début
en-US	Starting Date
it-CH	Data inizio
it-IT	Data inizio
nb-NO	Startdato
nl-BE	Begindatum
nl-NL	Begindatum
sv-SE	Startdatum

Ending Date (`35`)

Date

Language	Caption
da-DK	Slutdato
de-AT	Enddatum
de-CH	Enddatum
de-DE	Enddatum
es-ES	Fecha final
es-MX	Fecha final
fi-FI	Lopetuspvm
fr-BE	Date fin
fr-CA	Date fin
fr-CH	Date fin
fr-FR	Date fin
en-US	Ending Date
it-CH	Data fine
it-IT	Data fine
nb-NO	Sluttdato
nl-BE	Einddatum
nl-NL	Einddatum
sv-SE	Slutdatum

From Customer Cluster (`90`)

Boolean

Language	Caption
da-DK	Fra kundeklynge
de-AT	Vom Kundencluster
de-CH	Vom Kundencluster
de-DE	Vom Kundencluster
es-ES	Desde grupo clientes
es-MX	Desde grupo clientes
fi-FI	Asiakasklusterista
fr-BE	À partir du cluster client
fr-CA	À partir du cluster client
fr-CH	À partir du cluster client
fr-FR	À partir du cluster client
en-US	From Customer Cluster
it-CH	Dal cluster di clienti
it-IT	Dal cluster di clienti
nb-NO	Fra kundeklynge
nl-BE	Van klantcluster
nl-NL	Van klantcluster
sv-SE	Från Kundkluster

From Item Cluster (`91`)

Boolean

Language	Caption
da-DK	Fra elementklynge
de-AT	Aus Elementcluster
de-CH	Aus Elementcluster
de-DE	Aus Elementcluster
es-ES	Desde grupo productos
es-MX	Desde grupo productos
fi-FI	Nimikeklusterista
fr-BE	À partir du cluster d’éléments
fr-CA	À partir du cluster d’éléments
fr-CH	À partir du cluster d’éléments
fr-FR	À partir du cluster d’éléments
en-US	From Item Cluster
it-CH	Da cluster di articoli
it-IT	Da cluster di articoli
nb-NO	Fra elementklynge
nl-BE	Vanuit objectcluster
nl-NL	Vanuit objectcluster
sv-SE	Från artikelkluster

Status (`120`)

enum "EOS049 Status"

Language	Caption
da-DK	Status
de-AT	Status
de-CH	Status
de-DE	Status
es-ES	Estado
es-MX	Estado
fi-FI	Tila
fr-BE	Statut
fr-CA	Statut
fr-CH	Statut
fr-FR	Statut
en-US	Status
it-CH	Stato
it-IT	Stato
nb-NO	Status
nl-BE	Status
nl-NL	Status
sv-SE	Status

Discount Type (`200`)

Enum "EOS037 Line Discount Type"

Language	Caption
da-DK	Rabattype
de-AT	Rabattart
de-CH	Rabattart
de-DE	Rabattart
es-ES	Tipo de descuento
es-MX	Tipo de descuento
fi-FI	Alennuksen tyyppi
fr-BE	Type de remise
fr-CA	Type de remise
fr-CH	Type de remise
fr-FR	Type de remise
en-US	Discount Type
it-CH	Tipo Sconto
it-IT	Tipo Sconto
nb-NO	Rabattype
nl-BE	Kortingsoort
nl-NL	Kortingsoort
sv-SE	Typ av rabatt

Value (`210`)

Decimal

Language	Caption
da-DK	Værdi
de-AT	Wert
de-CH	Wert
de-DE	Wert
es-ES	Valor
es-MX	Valor
fi-FI	Arvo
fr-BE	Valeur
fr-CA	Valeur
fr-CH	Valeur
fr-FR	Valeur
en-US	Value
it-CH	Valore
it-IT	Valore
nb-NO	Verdi
nl-BE	Waarde
nl-NL	Waarde
sv-SE	Värde

Promotion Information (`305`)

Code[10]

TableRelation: "EOS049 Promotion Information"

Language	Caption
da-DK	Oplysninger om promovering
de-AT	Aktionsinformation
de-CH	Aktionsinformation
de-DE	Aktionsinformation
es-ES	Información de promoción
es-MX	Información de promoción
fi-FI	Kampanjan tiedot
fr-BE	Informations sur la promotion
fr-CA	Informations sur la promotion
fr-CH	Informations sur la promotion
fr-FR	Informations sur la promotion
en-US	Promotion Information
it-CH	Informazione sconto/promozioni
it-IT	Informazione sconto/promozioni
nb-NO	Informasjon om promotering
nl-BE	Promotie-informatie
nl-NL	Promotie-informatie
sv-SE	Information om befordran

Unit of Measure Code (`5400`)

Code[10]

TableRelation: if ("Type - Item" = const(Item)) "Item Unit of Measure".Code where("Item No." = field("Item No.")) else "Unit of Measure".Code

Language	Caption
da-DK	Enhedskode
de-AT	Einheitencode
de-CH	Einheitencode
de-DE	Einheitencode
es-ES	Cód. unidad de medida
es-MX	Cód. unidad de medida
fi-FI	Mittayksikön koodi
fr-BE	Code unité
fr-CA	Code unité
fr-CH	Code unité
fr-FR	Code unité
en-US	Unit of Measure Code
it-CH	Cod. unità di misura
it-IT	Cod. unità di misura
nb-NO	Enhetskode
nl-BE	Eenheidscode
nl-NL	Eenheidscode
sv-SE	Enhetskod

Line No. (`10000`)

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

Line Type (`10001`)

enum "EOS049 Sales Prices Line Type"

Language	Caption
da-DK	Linjetype
de-AT	Zeilenart
de-CH	Zeilenart
de-DE	Zeilenart
es-ES	Tipo línea
es-MX	Tipo línea
fi-FI	Rivityyppi
fr-BE	Type ligne
fr-CA	Type ligne
fr-CH	Type ligne
fr-FR	Type ligne
en-US	Line Type
it-CH	Tipo riga
it-IT	Tipo riga
nb-NO	Linjetype
nl-BE	Regelsoort
nl-NL	Regelsoort
sv-SE	Radtyp

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 18125995 EOS049 Duplicated Sales Line

Fields

Sales Type (1)

Code (2)

Description (3)

Line No. - Customer (4)

Line No. - Item (5)

Type - Customer (10)

Level - Customer (11)

Code - Customer (12)

Description - Customer (13)

Description 2 - Customer (14)

Type - Item (20)

Level - Item (21)

Code - Item (22)

Item No. (23)

Description - Item (24)

Description 2 - Item (25)

Currency Code (30)

Unit Price (31)

Starting Date (34)

Ending Date (35)

From Customer Cluster (90)

From Item Cluster (91)

Status (120)

Discount Type (200)

Value (210)

Promotion Information (305)

Unit of Measure Code (5400)

Line No. (10000)

Line Type (10001)

Feedback

Sales Type (`1`)

Code (`2`)

Description (`3`)

Line No. - Customer (`4`)

Line No. - Item (`5`)

Type - Customer (`10`)

Level - Customer (`11`)

Code - Customer (`12`)

Description - Customer (`13`)

Description 2 - Customer (`14`)

Type - Item (`20`)

Level - Item (`21`)

Code - Item (`22`)

Item No. (`23`)

Description - Item (`24`)

Description 2 - Item (`25`)

Currency Code (`30`)

Unit Price (`31`)

Starting Date (`34`)

Ending Date (`35`)

From Customer Cluster (`90`)

From Item Cluster (`91`)

Status (`120`)

Discount Type (`200`)

Value (`210`)

Promotion Information (`305`)

Unit of Measure Code (`5400`)

Line No. (`10000`)

Line Type (`10001`)