Table 18126001 EOS049 Sales Hdr. Disc. Line

Table 18126001 EOS049 Sales Hdr. Disc. Line

Language	Caption
de-AT	Verkauf Hdr. Disc. Linie
de-CH	Verkauf Hdr. Disc. Linie
de-DE	Verkauf Hdr. Disc. Linie
en-US	Sales Hdr. Disc. Line
it-CH	Riga testata sc. vend.
it-IT	Riga testata sc. vend.

Fields

Sales Disc. Code (`1`)

Code[20]

Language	Caption
de-AT	Sales Disc. Code
de-CH	Sales Disc. Code
de-DE	Sales Disc. Code
en-US	Sales Disc. Code
it-CH	Codice sconto vendite
it-IT	Codice sconto vendite

Description (`2`)

Text[100]

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

Line No. - Customer (`4`)

Integer

Language	Caption
de-AT	Linie Nr. - Kunde
de-CH	Linie Nr. - Kunde
de-DE	Linie Nr. - Kunde
en-US	Line No. - Customer
it-CH	Nr. riga - Cliente
it-IT	Nr. riga - Cliente

Line No. - Item Document (`5`)

Integer

Language	Caption
de-AT	Zeilen-Nr. - Artikelbeleg
de-CH	Zeilen-Nr. - Artikelbeleg
de-DE	Zeilen-Nr. - Artikelbeleg
en-US	Line No. - Item Document
it-CH	Nr. riga - Documento dell’articolo
it-IT	Nr. riga - Documento dell’articolo

Entry No. (`6`)

Integer

Language	Caption
de-AT	Lfd. Nr.
de-CH	Lfd. Nr.
de-DE	Lfd. Nr.
en-US	Entry No.
it-CH	Nr. movimento
it-IT	Nr. movimento

Document No. (`7`)

Code[20]

Language	Caption
de-AT	Belegnr.
de-CH	Belegnr.
de-DE	Belegnr.
en-US	Document No.
it-CH	Documento n.
it-IT	Documento n.

Document Line No. (`8`)

Integer

Language	Caption
de-AT	Belegzeilennr.
de-CH	Belegzeilennr.
de-DE	Belegzeilennr.
en-US	Document Line No.
it-CH	Nr. riga documento
it-IT	Nr. riga documento

To Apply (`9`)

Boolean

Language	Caption
de-AT	Anzuwenden
de-CH	Anzuwenden
de-DE	Anzuwenden
en-US	To Apply
it-CH	Da applicare
it-IT	Da applicare

Type - Customer (`10`)

Enum "EOS049 Sales Disc. Line Cust. Type"

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

Level - Customer (`11`)

Integer

TableRelation: "EOS Customer Hierarchy Level".Level

Language	Caption
de-AT	Ebene
de-CH	Ebene
de-DE	Ebene
en-US	Level
it-CH	Livello
it-IT	Livello

Code - Customer (`12`)

Code[20]

TableRelation: if ("Type - Customer" = const(" ")) "Standard Text" else if ("Type - Customer" = const(Customer)) Customer else if ("Type - Customer" = const("Customer Disc. Group")) "Customer Discount 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)) else if ("Type - Customer" = const("Customer Cluster")) "EOS Customer Cluster Header" where(Status = const(Certified))

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

Description - Customer (`13`)

Text[100]

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

Description 2 - Customer (`14`)

Text[100]

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

Discount Failed Motivation (`15`)

Text[250]

Language	Caption
de-AT	Grund für Nichtanwendung des Rabatts
de-CH	Grund für Nichtanwendung des Rabatts
de-DE	Grund für Nichtanwendung des Rabatts
en-US	Discount Failed Motivation
it-CH	Motivo sconto non applicato
it-IT	Motivo sconto non applicato

Type - Item (`20`)

Enum "EOS049 Discount Item Type"

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

Level - Item (`21`)

Integer

Language	Caption
de-AT	Ebene
de-CH	Ebene
de-DE	Ebene
en-US	Level
it-CH	Livello
it-IT	Livello

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" where(Status = const(Certified))

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

Item No. (`23`)

Code[20]

TableRelation: Item

Language	Caption
de-AT	Artikelnr.
de-CH	Artikelnr.
de-DE	Artikelnr.
en-US	Item No.
it-CH	Nr. articolo
it-IT	Nr. articolo

Description - Item (`24`)

Text[100]

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

Description 2 - Item (`25`)

Text[100]

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

Currency Code (`30`)

Code[10]

TableRelation: Currency

Language	Caption
de-AT	Währungscode
de-CH	Währungscode
de-DE	Währungscode
en-US	Currency Code
it-CH	Cod. valuta
it-IT	Cod. valuta

Starting Date (`34`)

Date

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

Ending Date (`35`)

Date

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

Last Date Modified (`54`)

Date

Language	Caption
de-AT	Korrigiert am
de-CH	Korrigiert am
de-DE	Korrigiert am
en-US	Last Date Modified
it-CH	Data ultima modifica
it-IT	Data ultima modifica

Last Time Modified (`55`)

Time

Language	Caption
de-AT	Korrigiert um
de-CH	Korrigiert um
de-DE	Korrigiert um
en-US	Last Time Modified
it-CH	Ora ultima modifica
it-IT	Ora ultima modifica

Status (`120`)

Enum "EOS049 Status"

Language	Caption
de-AT	Status
de-CH	Status
de-DE	Status
en-US	Status
it-CH	Stato
it-IT	Stato

Discount Type (`200`)

Enum "EOS037 Line Discount Type"

Language	Caption
de-AT	Rabattart
de-CH	Rabattart
de-DE	Rabattart
en-US	Discount Type
it-CH	Tipo Sconto
it-IT	Tipo Sconto

Value (`210`)

Decimal

Language	Caption
de-AT	Wert
de-CH	Wert
de-DE	Wert
en-US	Value
it-CH	Valore
it-IT	Valore

Use Once (`220`)

Boolean

Language	Caption
de-AT	Einmal verwenden
de-CH	Einmal verwenden
de-DE	Einmal verwenden
en-US	Use Once
it-CH	Usa una volta
it-IT	Usa una volta

Discount Used (`221`)

COde[20]

Language	Caption
de-AT	Rabatt Gebraucht
de-CH	Rabatt Gebraucht
de-DE	Rabatt Gebraucht
en-US	Discount Used
it-CH	Sconto usato
it-IT	Sconto usato

Type (`303`)

Enum "EOS049 Sales Disc. Header Type"

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

Promotion Information (`306`)

Code[10]

TableRelation: "EOS049 Promotion Information"

Language	Caption
de-AT	Aktionsinformation
de-CH	Aktionsinformation
de-DE	Aktionsinformation
en-US	Promotion Information
it-CH	Informazione sconto/promozioni
it-IT	Informazione sconto/promozioni

From Customer Cluster (`850`)

Boolean

Language	Caption
de-AT	Vom Kundencluster
de-CH	Vom Kundencluster
de-DE	Vom Kundencluster
en-US	From Customer Cluster
it-CH	Dal cluster di clienti
it-IT	Dal cluster di clienti

From Item Cluster (`860`)

Boolean

Language	Caption
de-AT	Aus Elementcluster
de-CH	Aus Elementcluster
de-DE	Aus Elementcluster
en-US	From Item Cluster
it-CH	Da cluster di articoli
it-IT	Da cluster di articoli

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
de-AT	Einheitencode
de-CH	Einheitencode
de-DE	Einheitencode
en-US	Unit of Measure Code
it-CH	Cod. unità di misura
it-IT	Cod. unità di misura

Tot. Order Threshold (`7007`)

Enum "EOS049 Discount Threshold"

Language	Caption
de-AT	Art des Gesamtauftragsschwellenwerts
de-CH	Art des Gesamtauftragsschwellenwerts
de-DE	Art des Gesamtauftragsschwellenwerts
en-US	Total Order Threshold Type
it-CH	Tipo di soglia totale dell’ordine
it-IT	Tipo di soglia totale dell’ordine

Tot. Order Thre. Value (`7008`)

Decimal

Language	Caption
de-AT	Schwellenwert für die Gesamtbestellung
de-CH	Schwellenwert für die Gesamtbestellung
de-DE	Schwellenwert für die Gesamtbestellung
en-US	Total Order Threshold Value
it-CH	Valore soglia totale dell’ordine
it-IT	Valore soglia totale dell’ordine

Single Ref. Threshold (`7009`)

Enum "EOS049 Discount Threshold"

Language	Caption
de-AT	Einzelner Referenzschwellenwerttyp
de-CH	Einzelner Referenzschwellenwerttyp
de-DE	Einzelner Referenzschwellenwerttyp
en-US	Single Reference Threshold Type
it-CH	Tipo di soglia di riferimento singolo
it-IT	Tipo di soglia di riferimento singolo

Sing. Ref. Thre. Value (`7010`)

Decimal

Language	Caption
de-AT	Einzelner Referenzschwellenwert
de-CH	Einzelner Referenzschwellenwert
de-DE	Einzelner Referenzschwellenwert
en-US	Single Reference Threshold Value
it-CH	Valore soglia di riferimento unico
it-IT	Valore soglia di riferimento unico

Gift Basket Code (`7011`)

Code[10]

TableRelation: "EOS049 Gift Basket Header".Code

Language	Caption
de-AT	Geschenkkorb-Code
de-CH	Geschenkkorb-Code
de-DE	Geschenkkorb-Code
en-US	Gift Basket Code
it-CH	Codice del cesto regalo
it-IT	Codice del cesto regalo

Tot. Order Thre. UoM (`7012`)

Code[10]

TableRelation: "Unit of Measure".Code

Language	Caption
de-AT	Gesamtbestellschwelle U.o.M.
de-CH	Gesamtbestellschwelle U.o.M.
de-DE	Gesamtbestellschwelle U.o.M.
en-US	Total Order Threshold U.o.M.
it-CH	Soglia totale ordini U.o.M.
it-IT	Soglia totale ordini U.o.M.

Sing. Ref. Thre. UoM (`7013`)

Code[10]

TableRelation: "Unit of Measure".Code

Language	Caption
de-AT	Einheitliche Referenzschwelle U.o.M.
de-CH	Einheitliche Referenzschwelle U.o.M.
de-DE	Einheitliche Referenzschwelle U.o.M.
en-US	Single Reference Threshold U.o.M.
it-CH	Soglia unica di riferimento U.o.M.
it-IT	Soglia unica di riferimento U.o.M.

Variant Code (`7700`)

Code[10]

TableRelation: "Item Variant".Code where("Item No." = field("Item No."))

Language	Caption
de-AT	Variantencode
de-CH	Variantencode
de-DE	Variantencode
en-US	Variant Code
it-CH	Cod. variante
it-IT	Cod. variante

Document Filters Code (`8000`)

Code[10]

TableRelation: "EOS049 Filter".Code where(Active = const(true))

Language	Caption
de-AT	Code für Dokumentfilter
de-CH	Code für Dokumentfilter
de-DE	Code für Dokumentfilter
en-US	Document Filters Code
it-CH	Codice dei filtri dei documenti
it-IT	Codice dei filtri dei documenti

Assortment Code (`8001`)

Code[10]

TableRelation: "EOS049 Assortment Header".Code where(Status = const(Certified))

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

Sorting Order (`10000`)

Integer

Language	Caption
de-AT	Sortierreihenfolge
de-CH	Sortierreihenfolge
de-DE	Sortierreihenfolge
en-US	Sorting Order
it-CH	Ordinamento
it-IT	Ordinamento

Selected (`10003`)

Boolean

Language	Caption
de-AT	Ausgewählt
de-CH	Ausgewählt
de-DE	Ausgewählt
en-US	Selected
it-CH	Selezionato
it-IT	Selezionato

Sell-Out Starting Date (`11000`)

Date

Language	Caption
de-AT	Sell-Out Startdatum
de-CH	Sell-Out Startdatum
de-DE	Sell-Out Startdatum
en-US	Sell-Out Starting Date
it-CH	Data inizio Sell-Out
it-IT	Data inizio Sell-Out

Sell-Out Ending Date (`11001`)

Date

Language	Caption
de-AT	Sell-Out Enddatum
de-CH	Sell-Out Enddatum
de-DE	Sell-Out Enddatum
en-US	Sell-Out Ending Date
it-CH	Data fine Sell-Out
it-IT	Data fine Sell-Out

Check On Promised Deliv. Date (`11002`)

Boolean

Language	Caption
de-AT	Überprüfen Sie auf Gelobte Deliv. Datum
de-CH	Überprüfen Sie auf Gelobte Deliv. Datum
de-DE	Überprüfen Sie auf Gelobte Deliv. Datum
en-US	Check on Promised Deliv. Date
it-CH	Controlla Deliv promesso. Data
it-IT	Controlla Deliv promesso. Data

Priority (`11005`)

Integer

Language	Caption
de-AT	Priorität
de-CH	Priorität
de-DE	Priorität
en-US	Priority
it-CH	Priorità
it-IT	Priorità

Rule Type (`11010`)

Enum "EOS049 Rule Type"

Language	Caption
de-AT	Regelart
de-CH	Regelart
de-DE	Regelart
en-US	Rule Type
it-CH	Tipo regola
it-IT	Tipo regola

Alternativity Group Code (`11011`)

Code[20]

Language	Caption
de-AT	Alternativitätsgruppencode
de-CH	Alternativitätsgruppencode
de-DE	Alternativitätsgruppencode
en-US	Alternativity Group Code
it-CH	Cod. gruppo alternatività
it-IT	Cod. gruppo alternatività

Exclusive (`11015`)

Enum "EOS049 Exclusive"

Language	Caption
de-AT	Exklusiv
de-CH	Exklusiv
de-DE	Exklusiv
en-US	Exclusive
it-CH	Esclusivo
it-IT	Esclusivo

Use Discount (`11020`)

Boolean

Language	Caption
de-AT	Verwenden Sie Rabatt
de-CH	Verwenden Sie Rabatt
de-DE	Verwenden Sie Rabatt
en-US	Use Discount
it-CH	Usa sconto
it-IT	Usa sconto

Document Discount Type (`20000`)

Enum "EOS049 Discount Type"

Language	Caption
de-AT	Rabattart
de-CH	Rabattart
de-DE	Rabattart
en-US	Discount Type
it-CH	Tipo Sconto
it-IT	Tipo Sconto

Coupon Code (`7000`)

Code[10]

TableRelation: "EOS049 Coupon Add. Charges".Code where(Type = const(Discount))

Language	Caption
de-AT	Gutscheincode
de-CH	Gutscheincode
de-DE	Gutscheincode
en-US	Coupon Code
it-CH	Codice coupon
it-IT	Codice coupon

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 18126001 EOS049 Sales Hdr. Disc. Line

Fields

Sales Disc. Code (1)

Description (2)

Line No. - Customer (4)

Line No. - Item Document (5)

Entry No. (6)

Document No. (7)

Document Line No. (8)

To Apply (9)

Type - Customer (10)

Level - Customer (11)

Code - Customer (12)

Description - Customer (13)

Description 2 - Customer (14)

Discount Failed Motivation (15)

Type - Item (20)

Level - Item (21)

Code - Item (22)

Item No. (23)

Description - Item (24)

Description 2 - Item (25)

Currency Code (30)

Starting Date (34)

Ending Date (35)

Last Date Modified (54)

Last Time Modified (55)

Status (120)

Discount Type (200)

Value (210)

Use Once (220)

Discount Used (221)

Type (303)

Promotion Information (306)

From Customer Cluster (850)

From Item Cluster (860)

Unit of Measure Code (5400)

Tot. Order Threshold (7007)

Tot. Order Thre. Value (7008)

Single Ref. Threshold (7009)

Sing. Ref. Thre. Value (7010)

Gift Basket Code (7011)

Tot. Order Thre. UoM (7012)

Sing. Ref. Thre. UoM (7013)

Variant Code (7700)

Document Filters Code (8000)

Assortment Code (8001)

Sorting Order (10000)

Selected (10003)

Sell-Out Starting Date (11000)

Sell-Out Ending Date (11001)

Check On Promised Deliv. Date (11002)

Priority (11005)

Rule Type (11010)

Alternativity Group Code (11011)

Exclusive (11015)

Use Discount (11020)

Document Discount Type (20000)

Coupon Code (7000)

Feedback

Sales Disc. Code (`1`)

Description (`2`)

Line No. - Customer (`4`)

Line No. - Item Document (`5`)

Entry No. (`6`)

Document No. (`7`)

Document Line No. (`8`)

To Apply (`9`)

Type - Customer (`10`)

Level - Customer (`11`)

Code - Customer (`12`)

Description - Customer (`13`)

Description 2 - Customer (`14`)

Discount Failed Motivation (`15`)

Type - Item (`20`)

Level - Item (`21`)

Code - Item (`22`)

Item No. (`23`)

Description - Item (`24`)

Description 2 - Item (`25`)

Currency Code (`30`)

Starting Date (`34`)

Ending Date (`35`)

Last Date Modified (`54`)

Last Time Modified (`55`)

Status (`120`)

Discount Type (`200`)

Value (`210`)

Use Once (`220`)

Discount Used (`221`)

Type (`303`)

Promotion Information (`306`)

From Customer Cluster (`850`)

From Item Cluster (`860`)

Unit of Measure Code (`5400`)

Tot. Order Threshold (`7007`)

Tot. Order Thre. Value (`7008`)

Single Ref. Threshold (`7009`)

Sing. Ref. Thre. Value (`7010`)

Gift Basket Code (`7011`)

Tot. Order Thre. UoM (`7012`)

Sing. Ref. Thre. UoM (`7013`)

Variant Code (`7700`)

Document Filters Code (`8000`)

Assortment Code (`8001`)

Sorting Order (`10000`)

Selected (`10003`)

Sell-Out Starting Date (`11000`)

Sell-Out Ending Date (`11001`)

Check On Promised Deliv. Date (`11002`)

Priority (`11005`)

Rule Type (`11010`)

Alternativity Group Code (`11011`)

Exclusive (`11015`)

Use Discount (`11020`)

Document Discount Type (`20000`)

Coupon Code (`7000`)