Table 18126001 EOS049 Sales Hdr. Disc. Line

Table 18126001 EOS049 Sales Hdr. Disc. Line

LanguageCaption
de-DEVerkauf Hdr. Disc. Linie
en-USSales Hdr. Disc. Line
it-ITRiga testata sc. vend.

Fields

Sales Disc. Code (1)

Code[20]

LanguageCaption
de-DESales Disc. Code
en-USSales Disc. Code
it-ITCodice sconto vendite

Description (2)

Text[100]

LanguageCaption
de-DEBeschreibung
en-USDescription
it-ITDescrizione

Line No. - Customer (4)

Integer

LanguageCaption
de-DELinie Nr. - Kunde
en-USLine No. - Customer
it-ITNr. riga - Cliente

Line No. - Item Document (5)

Integer

LanguageCaption
de-DEZeilen-Nr. - Artikelbeleg
en-USLine No. - Item Document
it-ITNr. riga - Documento dell’articolo

Entry No. (6)

Integer

LanguageCaption
de-DELfd. Nr.
en-USEntry No.
it-ITNr. movimento

Document No. (7)

Code[20]

LanguageCaption
de-DEBelegnr.
en-USDocument No.
it-ITDocumento n.

Document Line No. (8)

Integer

LanguageCaption
de-DEBelegzeilennr.
en-USDocument Line No.
it-ITNr. riga documento

To Apply (9)

Boolean

LanguageCaption
de-DEAnzuwenden
en-USTo Apply
it-ITDa applicare

Type - Customer (10)

Enum "EOS049 Sales Disc. Line Cust. Type"

LanguageCaption
de-DEArt
en-USType
it-ITTipo

Level - Customer (11)

Integer

TableRelation: "EOS Customer Hierarchy Level".Level

LanguageCaption
de-DEEbene
en-USLevel
it-ITLivello

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

LanguageCaption
de-DECode
en-USCode
it-ITCodice

Description - Customer (13)

Text[100]

LanguageCaption
de-DEBeschreibung
en-USDescription
it-ITDescrizione

Description 2 - Customer (14)

Text[100]

LanguageCaption
de-DEBeschreibung 2
en-USDescription 2
it-ITDescrizione 2

Discount Failed Motivation (15)

Text[250]

LanguageCaption
de-DEGrund für Nichtanwendung des Rabatts
en-USDiscount Failed Motivation
it-ITMotivo sconto non applicato

Type - Item (20)

Enum "EOS049 Discount Item Type"

LanguageCaption
de-DEArt
en-USType
it-ITTipo

Level - Item (21)

Integer

LanguageCaption
de-DEEbene
en-USLevel
it-ITLivello

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

LanguageCaption
de-DECode
en-USCode
it-ITCodice

Item No. (23)

Code[20]

TableRelation: Item

LanguageCaption
de-DEArtikelnr.
en-USItem No.
it-ITNr. articolo

Description - Item (24)

Text[100]

LanguageCaption
de-DEBeschreibung
en-USDescription
it-ITDescrizione

Description 2 - Item (25)

Text[100]

LanguageCaption
de-DEBeschreibung 2
en-USDescription 2
it-ITDescrizione 2

Currency Code (30)

Code[10]

TableRelation: Currency

LanguageCaption
de-DEWährungscode
en-USCurrency Code
it-ITCod. valuta

Starting Date (34)

Date

LanguageCaption
de-DEStartdatum
en-USStarting Date
it-ITData inizio

Ending Date (35)

Date

LanguageCaption
de-DEEnddatum
en-USEnding Date
it-ITData fine

Last Date Modified (54)

Date

LanguageCaption
de-DEKorrigiert am
en-USLast Date Modified
it-ITData ultima modifica

Last Time Modified (55)

Time

LanguageCaption
de-DEKorrigiert um
en-USLast Time Modified
it-ITOra ultima modifica

Status (120)

Enum "EOS049 Status"

LanguageCaption
de-DEStatus
en-USStatus
it-ITStato

Discount Type (200)

Enum "EOS037 Line Discount Type"

LanguageCaption
de-DERabattart
en-USDiscount Type
it-ITTipo Sconto

Value (210)

Decimal

LanguageCaption
de-DEWert
en-USValue
it-ITValore

Use Once (220)

Boolean

LanguageCaption
de-DEEinmal verwenden
en-USUse Once
it-ITUsa una volta

Discount Used (221)

COde[20]

LanguageCaption
de-DERabatt Gebraucht
en-USDiscount Used
it-ITSconto usato

Type (303)

Enum "EOS049 Sales Disc. Header Type"

LanguageCaption
de-DEArt
en-USType
it-ITTipo

Promotion Information (306)

Code[10]

TableRelation: "EOS049 Promotion Information"

LanguageCaption
de-DEAktionsinformation
en-USPromotion Information
it-ITInformazione sconto/promozioni

From Customer Cluster (850)

Boolean

LanguageCaption
de-DEVom Kundencluster
en-USFrom Customer Cluster
it-ITDal cluster di clienti

From Item Cluster (860)

Boolean

LanguageCaption
de-DEAus Elementcluster
en-USFrom Item Cluster
it-ITDa 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

LanguageCaption
de-DEEinheitencode
en-USUnit of Measure Code
it-ITCod. unità di misura

Tot. Order Threshold (7007)

Enum "EOS049 Discount Threshold"

LanguageCaption
de-DEArt des Gesamtauftragsschwellenwerts
en-USTotal Order Threshold Type
it-ITTipo di soglia totale dell’ordine

Tot. Order Thre. Value (7008)

Decimal

LanguageCaption
de-DESchwellenwert für die Gesamtbestellung
en-USTotal Order Threshold Value
it-ITValore soglia totale dell’ordine

Single Ref. Threshold (7009)

Enum "EOS049 Discount Threshold"

LanguageCaption
de-DEEinzelner Referenzschwellenwerttyp
en-USSingle Reference Threshold Type
it-ITTipo di soglia di riferimento singolo

Sing. Ref. Thre. Value (7010)

Decimal

LanguageCaption
de-DEEinzelner Referenzschwellenwert
en-USSingle Reference Threshold Value
it-ITValore soglia di riferimento unico

Gift Basket Code (7011)

Code[10]

TableRelation: "EOS049 Gift Basket Header".Code

LanguageCaption
de-DEGeschenkkorb-Code
en-USGift Basket Code
it-ITCodice del cesto regalo

Tot. Order Thre. UoM (7012)

Code[10]

TableRelation: "Unit of Measure".Code

LanguageCaption
de-DEGesamtbestellschwelle U.o.M.
en-USTotal Order Threshold U.o.M.
it-ITSoglia totale ordini U.o.M.

Sing. Ref. Thre. UoM (7013)

Code[10]

TableRelation: "Unit of Measure".Code

LanguageCaption
de-DEEinheitliche Referenzschwelle U.o.M.
en-USSingle Reference Threshold U.o.M.
it-ITSoglia unica di riferimento U.o.M.

Max Tot. Order Thre. Value (7014)

Decimal

LanguageCaption
de-DEMaximaler Schwellenwert für den Gesamtauftrag
en-USMaximum Total Order Threshold Value
it-ITValore massimo della soglia totale dell’ordine

Max Sing. Ref. Thre. Value (7015)

Decimal

LanguageCaption
de-DEMaximaler Schwellenwert für eine einzelne Referenz
en-USMaximum Single Reference Threshold Value
it-ITValore massimo di soglia di riferimento unico

Variant Code (7700)

Code[10]

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

LanguageCaption
de-DEVariantencode
en-USVariant Code
it-ITCod. variante

Document Filters Code (8000)

Code[10]

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

LanguageCaption
de-DECode für Dokumentfilter
en-USDocument Filters Code
it-ITCodice dei filtri dei documenti

Assortment Code (8001)

Code[10]

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

LanguageCaption
de-DESortimentscode
en-USAssortment Code
it-ITCodice assortimento

Sorting Order (10000)

Integer

LanguageCaption
de-DESortierreihenfolge
en-USSorting Order
it-ITOrdinamento

Selected (10003)

Boolean

LanguageCaption
de-DEAusgewählt
en-USSelected
it-ITSelezionato

Sell-Out Starting Date (11000)

Date

LanguageCaption
de-DESell-Out Startdatum
en-USSell-Out Starting Date
it-ITData inizio Sell-Out

Sell-Out Ending Date (11001)

Date

LanguageCaption
de-DESell-Out Enddatum
en-USSell-Out Ending Date
it-ITData fine Sell-Out

Check On Promised Deliv. Date (11002)

Boolean

LanguageCaption
de-DEÜberprüfen Sie auf Gelobte Deliv. Datum
en-USCheck on Promised Deliv. Date
it-ITControlla Deliv promesso. Data

Priority (11005)

Integer

LanguageCaption
de-DEPriorität
en-USPriority
it-ITPriorità

Rule Type (11010)

Enum "EOS049 Rule Type"

LanguageCaption
de-DERegelart
en-USRule Type
it-ITTipo regola

Alternativity Group Code (11011)

Code[20]

LanguageCaption
de-DEAlternativitätsgruppencode
en-USAlternativity Group Code
it-ITCod. gruppo alternatività

Exclusive (11015)

Enum "EOS049 Exclusive"

LanguageCaption
de-DEExklusiv
en-USExclusive
it-ITEsclusivo

Use Discount (11020)

Boolean

LanguageCaption
de-DEVerwenden Sie Rabatt
en-USUse Discount
it-ITUsa sconto

Document Discount Type (20000)

Enum "EOS049 Discount Type"

LanguageCaption
de-DERabattart
en-USDiscount Type
it-ITTipo Sconto

Coupon Code (7000)

Code[10]

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

LanguageCaption
de-DEGutscheincode
en-USCoupon Code
it-ITCodice coupon

EOS Labs -