Table 18125986 EOS049 Sales D. Line Item Sel

Table 18125986 EOS049 Sales D. Line Item Sel

LanguageCaption
de-DEVerkaufspreiszeile
en-USSales Price Line
it-ITRiga prezzo di vendita

Fields

Sales Price Code (1)

Code[20]

LanguageCaption
de-DEVK-Preiscode
en-USSales Price Code
it-ITCod. prezzo vendita

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

Integer

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

Type - Customer (10)

enum "EOS049 Sales Pr. Line Customer Type"

LanguageCaption
de-DEArt
en-USType
it-ITTipo

Level (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" = const(1)) "EOS Customer Hierarchy".Code where(Level = const(1)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(2)) "EOS Customer Hierarchy".Code where(Level = const(2)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(3)) "EOS Customer Hierarchy".Code where(Level = const(3)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(4)) "EOS Customer Hierarchy".Code where(Level = const(4)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(5)) "EOS Customer Hierarchy".Code where(Level = const(5)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(6)) "EOS Customer Hierarchy".Code where(Level = const(6)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(7)) "EOS Customer Hierarchy".Code where(Level = const(7)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(8)) "EOS Customer Hierarchy".Code where(Level = const(8)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(9)) "EOS Customer Hierarchy".Code where(Level = const(9)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(10)) "EOS Customer Hierarchy".Code where(Level = const(10)) else if ("Type - Customer" = const("Hierarchy Level"), "Level" = const(11)) "EOS Customer Hierarchy".Code where(Level = const(11))

LanguageCaption
de-DECode
en-USCode
it-ITCodice

Description - Customer (13)

Text[50]

LanguageCaption
de-DEBeschreibung
en-USDescription
it-ITDescrizione

Description 2 - Customer (14)

Text[50]

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

Type - Item (20)

enum "EOS049 Sales Pr. Line Item Type"

LanguageCaption
de-DEArt
en-USType
it-ITTipo

Code - Item (21)

Code[20]

TableRelation: if ("Type - Item" = const(" ")) "Standard Text" else if ("Type - Item" = const(Item)) Item

LanguageCaption
de-DECode
en-USCode
it-ITCodice

Item No. (22)

Code[20]

TableRelation: Item

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

Description - Item (23)

Text[50]

LanguageCaption
de-DEBeschreibung
en-USDescription
it-ITDescrizione

Description 2 - Item (24)

Text[50]

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

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

Unit of Measure Code (5400)

Code[10]

TableRelation: "Item Unit of Measure".Code where("Item No." = field("Item No."))

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

Allow Line Disc. (7001)

Boolean

LanguageCaption
de-DEZeilenrabatt zulassen
en-USAllow Line Disc.
it-ITSconto riga

Price Includes VAT (7007)

Boolean

LanguageCaption
de-DEVK-Preis inkl. MwSt.
en-USPrice Includes VAT
it-ITPrezzo IVA inclusa

Allow Invoice Disc. (7010)

Boolean

LanguageCaption
de-DERech.-Rabatt zulassen
en-USAllow Invoice Disc.
it-ITSconto fattura

VAT Bus. Posting Gr. (Price) (7011)

Code[10]

TableRelation: "VAT Business Posting Group"

LanguageCaption
de-DEMwSt.-Geschäftsbuch.-G.(Preis)
en-USVAT Bus. Posting Gr. (Price)
it-ITCat. reg. business IVA(prezzo)

Minimum Quantity (7014)

Decimal

LanguageCaption
de-DEMindestmenge
en-USMinimum Quantity
it-ITQuantità minima

Variant Code (7700)

Code[10]

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

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

Sorting Order (10000)

Integer

LanguageCaption
de-DESortierreihenfolge
en-USSorting Order
it-ITOrdinamento

Selected (11000)

Boolean

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

Quantity (11002)

Decimal

LanguageCaption
de-DEMenge
en-USQuantity
it-ITQuantità

Discount % (11003)

Decimal

LanguageCaption
de-DEWert
en-USValue
it-ITValore

Discount Type (11004)

Code[10]

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

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

Expected Promo Qty (11005)

Decimal

LanguageCaption
de-DEErwartete Promo Qty
en-USExpected Promo Qty
it-ITQtà promo prevista

Manual Discount (11006)

Decimal

LanguageCaption
de-DEManueller Rabatt %
en-USManual Discount %
it-IT% sconto manuale

EOS Labs -