Table 18090665 EOS049 Sales Disc. Line - Item

Table 18090665 EOS049 Sales Disc. Line - Item

Language	Caption
de-DE	Verkaufsrabattposition - Artikel
en-US	Sales Discount Line - Item
it-IT	Riga sconto vendita - Articolo

Fields

Sales Disc. Code (`1`)

Code[20]

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

Line No. (`4`)

Integer

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

Type (`5`)

Enum "EOS049 Discount Item Type"

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

Level (`6`)

Integer

TableRelation: "EOS Item Hierarchy Level".Level

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

Code (`7`)

Code[20]

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

Item No. (`8`)

Code[20]

TableRelation: Item

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

Description (`11`)

Text[100]

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

Description 2 (`12`)

Text[100]

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

Variant Description (`13`)

Text[100]

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

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

Currency Code (`20`)

Code[10]

TableRelation: Currency

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

Promotion Information (`25`)

Code[10]

TableRelation: "EOS049 Promotion Information" where("Enable in SFA Discount" = const(true), Promotion = field(Promotion))

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

Last Date Modified (`54`)

Date

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

User ID (`55`)

Code[50]

TableRelation: User."User Name"

Language	Caption
de-DE	Benutzer-ID
en-US	User ID
it-IT	ID utente

From Item Cluster (`140`)

Boolean

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

Discount Type (`200`)

Enum "EOS037 Line Discount Type"

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

Value (`210`)

Decimal

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

Expected Promo Qty (`300`)

Decimal

Language	Caption
de-DE	Erwartete Promo Qty
en-US	Expected Promo Qty
it-IT	Qtà promo prevista

Trade Filter Type (`700`)

Enum "EOS Filter Type"

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

Unit of Measure Code (`5400`)

Code[10]

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

Language	Caption
de-DE	Einheitencode
en-US	Unit of Measure Code
it-IT	Cod. unità di misura

Threshold Type (`7000`)

enum "EOS049 Sales Disc. Threshold Type"

Language	Caption
de-DE	Schwellenwerttyp
en-US	Threshold Type
it-IT	Tipo soglia

Threshold Unit of Measure (`7001`)

Code[10]

TableRelation: "Unit of Measure"

Language	Caption
de-DE	Schwellenwert-Maßeinheit
en-US	Threshold Unit of Measure
it-IT	Unità di misura soglia

Minimum Quantity (`7014`)

Decimal

Language	Caption
de-DE	Mindestmenge
en-US	Minimum Quantity
it-IT	Quantità minima

Maximum Quantity (`7015`)

Decimal

Language	Caption
de-DE	Maximale Menge
en-US	Maximum Quantity
it-IT	Quantità massima

Promo Scenery Code (`8000`)

Code[10]

TableRelation: "EOS049 Promo Header"."Scenery Code"

Language	Caption
de-DE	Promo-Landschaftscode
en-US	Promo Scenery Code
it-IT	Codice scena promozionale

Promo Entry No. (`8001`)

Integer

TableRelation: "EOS049 Promo Header"."Entry No." where("Scenery Code" = field("Promo Scenery Code"))

Language	Caption
de-DE	Promo-Eintrag Nr.
en-US	Promo Entry No.
it-IT	Nr. voce promo

Promo Item No. (`8002`)

Code[20]

TableRelation: "EOS049 Promo Line"."Item No." where("Scenery Code" = field("Promo Scenery Code"), "Entry No." = field("Promo Entry No."))

Language	Caption
de-DE	Promo-Artikel-Nr.
en-US	Promo Item No.
it-IT	Nr. articolo promozionale

Promo Chk on Prom. Deliv. Date (`8003`)

Boolean

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

Sell-Out Starting Date (`11000`)

Date

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

Sell-Out Ending Date (`11001`)

Date

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

Rule Type (`11010`)

Enum "EOS049 Rule Type"

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

Alternativity Group Code (`11011`)

Code[20]

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

Exclusive (`11015`)

Enum "EOS049 Exclusive"

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

Based on Original Amount (`1110`)

Boolean

Language	Caption
de-DE	Basierend auf Ursprungsbetrag
en-US	Based on Original Amount
it-IT	In base a importo originario

Ignore Scalar Breakdown (`1111`)

Boolean

Language	Caption
de-DE	Scalar-Aufschlüsselung ignorieren
en-US	Ignore Scalar Breakdown
it-IT	Escludi scalare

Priority (`1112`)

Integer

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

Calculation Level (`2000`)

Enum "EOS049 Calculation Level"

Language	Caption
de-DE	Berechnungsebene
en-US	Calculation Level
it-IT	Livello di calcolo

Doc. Filt. Code (`2001`)

Code[10]

TableRelation: "EOS049 Filter".Code

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

Tot. Order Threshold (`2002`)

Enum "EOS049 Discount Threshold"

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

Tot. Order Thre. Value (`2003`)

Decimal

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

Single Ref. Threshold (`2004`)

Enum "EOS049 Discount Threshold"

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

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

Decimal

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

Gift Basket Code (`2007`)

Code[10]

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

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

Tot. Order Thre. UoM (`2008`)

Code[10]

TableRelation: "Unit of Measure".Code

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

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

Code[10]

TableRelation: "Unit of Measure".Code

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

Calculation Type (`2010`)

Enum "EOS049 Calculation Type"

Language	Caption
de-DE	Art der Berechnung
en-US	Calculation Type
it-IT	Tipo di calcolo

Use Once (`2011`)

Boolean

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

Discount Used (`2012`)

Code[20]

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

Assortment Code (`2013`)

Code[10]

TableRelation: "EOS049 Assortment Header".Code

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

Max Tot. Order Thre. Value (`2014`)

Decimal

Language	Caption
de-DE	Maximaler Schwellenwert für den Gesamtauftrag
en-US	Maximum Total Order Threshold Value
it-IT	Valore massimo della soglia totale dell’ordine

Max Sing. Ref. Thre. Value (`2015`)

Decimal

Language	Caption
de-DE	Maximaler Schwellenwert für eine einzelne Referenz
en-US	Maximum Single Reference Threshold Value
it-IT	Valore massimo di soglia di riferimento unico

Coupon Code (`3000`)

Code[10]

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

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

gift in deduction (`3101`)

Boolean

Language	Caption
de-DE	Geschenk im Abzug
en-US	Gift in deduction
it-IT	Regalo in detrazione

Promotion (`6700`)

Boolean

Language	Caption
de-DE	Sonderaktion
en-US	Promotion
it-IT	Promozione

Variant Code (`7700`)

Code[10]

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

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

Item Trade Attribute 1 (`7800`)

Text[250]

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

Item Trade Attribute 2 (`7801`)

Text[250]

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

Item Trade Attribute 3 (`7802`)

Text[250]

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

Item Trade Attribute 4 (`7803`)

Text[250]

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

Item Trade Attribute 5 (`7804`)

Text[250]

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

Item Trade Attribute 6 (`7805`)

Text[250]

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

Item Trade Attribute 7 (`7806`)

Text[250]

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

Item Trade Attribute 8 (`7807`)

Text[250]

Language	Caption
de-DE	Artikel-Handelsattribut 8
en-US	Item Trade Attribute 8
it-IT	Attributo commerciale articolo 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 articolo 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 riga 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 riga 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 riga 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 riga 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 commerciale riga vendita 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 commerciale riga vendita 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 riga 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 riga 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 riga 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 riga vendita 10

Methods

InitType

procedure InitType()

InitSellOut

procedure InitSellOut()

InitDiscountType

procedure InitDiscountType()

HasTypeToFillMandatotyFields

procedure HasTypeToFillMandatotyFields(): Boolean

Parameters / Return Value

Returns Boolean

SetSalesHeader

procedure SetSalesHeader(NewSalesDiscHeader: Record "EOS049 Sales Disc. Header")

Parameters / Return Value

NewSalesDiscHeader Record "EOS049 Sales Disc. Header"

TryTestStatusOpen

procedure TryTestStatusOpen()

SuspendStatusCheck

procedure SuspendStatusCheck(Suspend: Boolean)

Parameters / Return Value

Suspend Boolean

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 18090665 EOS049 Sales Disc. Line - Item

Fields

Sales Disc. Code (1)

Line No. (4)

Type (5)

Level (6)

Code (7)

Item No. (8)

Description (11)

Description 2 (12)

Variant Description (13)

Starting Date (14)

Ending Date (15)

Currency Code (20)

Promotion Information (25)

Last Date Modified (54)

User ID (55)

From Item Cluster (140)

Discount Type (200)

Value (210)

Expected Promo Qty (300)

Trade Filter Type (700)

Unit of Measure Code (5400)

Threshold Type (7000)

Threshold Unit of Measure (7001)

Minimum Quantity (7014)

Maximum Quantity (7015)

Promo Scenery Code (8000)

Promo Entry No. (8001)

Promo Item No. (8002)

Promo Chk on Prom. Deliv. Date (8003)

Sell-Out Starting Date (11000)

Sell-Out Ending Date (11001)

Rule Type (11010)

Alternativity Group Code (11011)

Exclusive (11015)

Based on Original Amount (1110)

Ignore Scalar Breakdown (1111)

Priority (1112)

Calculation Level (2000)

Doc. Filt. Code (2001)

Tot. Order Threshold (2002)

Tot. Order Thre. Value (2003)

Single Ref. Threshold (2004)

Sing. Ref. Thre. Value (2005)

Gift Basket Code (2007)

Tot. Order Thre. UoM (2008)

Sing. Ref. Thre. UoM (2009)

Calculation Type (2010)

Use Once (2011)

Discount Used (2012)

Assortment Code (2013)

Max Tot. Order Thre. Value (2014)

Max Sing. Ref. Thre. Value (2015)

Coupon Code (3000)

gift in deduction (3101)

Promotion (6700)

Variant Code (7700)

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

InitType

Sales Disc. Code (`1`)

Line No. (`4`)

Type (`5`)

Level (`6`)

Code (`7`)

Item No. (`8`)

Description (`11`)

Description 2 (`12`)

Variant Description (`13`)

Starting Date (`14`)

Ending Date (`15`)

Currency Code (`20`)

Promotion Information (`25`)

Last Date Modified (`54`)

User ID (`55`)

From Item Cluster (`140`)

Discount Type (`200`)

Value (`210`)

Expected Promo Qty (`300`)

Trade Filter Type (`700`)

Unit of Measure Code (`5400`)

Threshold Type (`7000`)

Threshold Unit of Measure (`7001`)

Minimum Quantity (`7014`)

Maximum Quantity (`7015`)

Promo Scenery Code (`8000`)

Promo Entry No. (`8001`)

Promo Item No. (`8002`)

Promo Chk on Prom. Deliv. Date (`8003`)

Sell-Out Starting Date (`11000`)

Sell-Out Ending Date (`11001`)

Rule Type (`11010`)

Alternativity Group Code (`11011`)

Exclusive (`11015`)

Based on Original Amount (`1110`)

Ignore Scalar Breakdown (`1111`)

Priority (`1112`)

Calculation Level (`2000`)

Doc. Filt. Code (`2001`)

Tot. Order Threshold (`2002`)

Tot. Order Thre. Value (`2003`)

Single Ref. Threshold (`2004`)

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

Gift Basket Code (`2007`)

Tot. Order Thre. UoM (`2008`)

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

Calculation Type (`2010`)

Use Once (`2011`)

Discount Used (`2012`)

Assortment Code (`2013`)

Max Tot. Order Thre. Value (`2014`)

Max Sing. Ref. Thre. Value (`2015`)

Coupon Code (`3000`)

gift in deduction (`3101`)

Promotion (`6700`)

Variant Code (`7700`)

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