Table 18125995 EOS049 Duplicated Sales Line

Table 18125995 EOS049 Duplicated Sales Line

LanguageCaption
de-DEVerkaufspreiszeilen - Duplikate
en-USSales Price Lines - Duplicates
it-ITRighe prezzo di vendita - Duplicati

Fields

Sales Type (1)

enum "EOS049 Sales Price Type"

LanguageCaption
de-DEVerkaufsart
en-USSales Type
it-ITTipo vendita

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

LanguageCaption
de-DECode
en-USCode
it-ITCodice

Description (3)

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

Integer

LanguageCaption
de-DEZeile Nr. - Artikel
en-USLine No. - Item
it-ITNr. Riga - Articolo

Type - Customer (10)

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

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

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".Code 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

Unit Price (31)

Decimal

LanguageCaption
de-DEVK-Preis
en-USUnit Price
it-ITPrezzo unitario

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

From Customer Cluster (90)

Boolean

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

From Item Cluster (91)

Boolean

LanguageCaption
de-DEAus Elementcluster
en-USFrom Item Cluster
it-ITDa cluster di articoli

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

Promotion Information (305)

Code[10]

TableRelation: "EOS049 Promotion Information"

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

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

Line No. (10000)

Integer

LanguageCaption
de-DEZeilennr.
en-USLine No.
it-ITNr. riga

Line Type (10001)

enum "EOS049 Sales Prices Line Type"

LanguageCaption
de-DEZeilenart
en-USLine Type
it-ITTipo riga

EOS Labs -