Table 18090659 EOS049 Sales Price Line

Table 18090659 EOS049 Sales Price Line

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("All Customers")) "Standard Text" else if ("Type - Customer" = const(Customer)) Customer 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)) 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

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[100]

LanguageCaption
de-DEBeschreibung
en-USDescription
it-ITDescrizione

Description 2 - Item (24)

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

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

Priority (11005)

Integer

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

Exclusive (11500)

Boolean

LanguageCaption
de-DEExklusiv
en-USExclusive
it-ITEsclusivo

Customer Trade Attribute 1 (12000)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 1
en-USCustomer Trade Attribute 1
it-ITAttributo commerciale cliente 1

Customer Trade Attribute 2 (12001)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 2
en-USCustomer Trade Attribute 2
it-ITAttributo commerciale cliente 2

Customer Trade Attribute 3 (12002)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 3
en-USCustomer Trade Attribute 3
it-ITAttributo commerciale cliente 3

Customer Trade Attribute 4 (12003)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 4
en-USCustomer Trade Attribute 4
it-ITAttributo commerciale cliente 4

Customer Trade Attribute 5 (12004)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 5
en-USCustomer Trade Attribute 5
it-ITAttributo commerciale cliente 5

Customer Trade Attribute 6 (12005)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 6
en-USCustomer Trade Attribute 6
it-ITAttributo commerciale cliente 6

Customer Trade Attribute 7 (12006)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 7
en-USCustomer Trade Attribute 7
it-ITAttributo commerciale cliente 7

Customer Trade Attribute 8 (12007)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 8
en-USCustomer Trade Attribute 8
it-ITAttributo commerciale cliente 8

Customer Trade Attribute 9 (12008)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 9
en-USCustomer Trade Attribute 9
it-ITAttributo commerciale cliente 9

Customer Trade Attribute 10 (12009)

Text[250]

LanguageCaption
de-DEDebitoren-Handelsattribut 10
en-USCustomer Trade Attribute 10
it-ITAttributo commerciale cliente 10

Sales Header Trade Attribute 1 (12050)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 1
en-USSales Header Trade Attribute 1
it-ITAttributo commerciale testata vendita 1

Sales Header Trade Attribute 2 (12051)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 2
en-USSales Header Trade Attribute 2
it-ITAttributo commerciale testata vendita 2

Sales Header Trade Attribute 3 (12052)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 3
en-USSales Header Trade Attribute 3
it-ITAttributo commerciale testata vendita 3

Sales Header Trade Attribute 4 (12053)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 4
en-USSales Header Trade Attribute 4
it-ITAttributo commerciale testata vendita 4

Sales Header Trade Attribute 5 (12054)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 5
en-USSales Header Trade Attribute 5
it-ITAttributo commerciale testata vendita 5

Sales Header Trade Attribute 6 (12055)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 6
en-USSales Header Trade Attribute 6
it-ITAttributo commerciale testata vendita 6

Sales Header Trade Attribute 7 (12056)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 7
en-USSales Header Trade Attribute 7
it-ITAttributo commerciale testata vendita 7

Sales Header Trade Attribute 8 (12057)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 8
en-USSales Header Trade Attribute 8
it-ITAttributo commerciale testata vendita 8

Sales Header Trade Attribute 9 (12058)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 9
en-USSales Header Trade Attribute 9
it-ITAttributo commerciale testata vendita 9

Sales Header Trade Attr. 10 (12059)

Text[250]

LanguageCaption
de-DEVK-Kopf Handelsattribut 10
en-USSales Header Trade Attr. 10
it-ITAttributo commerciale testata vendita 10

Sales Line Trade Attribute 1 (12100)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 1
en-USSales Line Trade Attribute 1
it-ITAttributo commerciale riga vendita 1

Sales Line Trade Attribute 2 (12101)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 2
en-USSales Line Trade Attribute 2
it-ITAttributo commerciale riga vendita 2

Sales Line Trade Attribute 3 (12102)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 3
en-USSales Line Trade Attribute 3
it-ITAttributo commerciale riga vendita 3

Sales Line Trade Attribute 4 (12103)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 4
en-USSales Line Trade Attribute 4
it-ITAttributo commerciale riga vendita 4

Sales Line Trade Attribute 5 (12104)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 5
en-USSales Line Trade Attribute 5
it-ITAttributo commerciale riga vendita 5

Sales Line Trade Attribute 6 (12105)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 6
en-USSales Line Trade Attribute 6
it-ITAttributo commerciale riga vendita 6

Sales Line Trade Attribute 7 (12106)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 7
en-USSales Line Trade Attribute 7
it-ITAttributo commerciale riga vendita 7

Sales Line Trade Attribute 8 (12107)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 8
en-USSales Line Trade Attribute 8
it-ITAttributo commerciale riga vendita 8

Sales Line Trade Attribute 9 (12108)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 9
en-USSales Line Trade Attribute 9
it-ITAttributo commerciale riga vendita 9

Sales Line Trade Attr. 10 (12109)

Text[250]

LanguageCaption
de-DEVK-Zeile Handelsattribut 10
en-USSales Line Trade Attr. 10
it-ITAttributo commerciale riga vendita 10

Item Trade Attribute 1 (12150)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 1
en-USItem Trade Attribute 1
it-ITAttributo commerciale articolo 1

Item Trade Attribute 2 (12151)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 2
en-USItem Trade Attribute 2
it-ITAttributo commerciale articolo 2

Item Trade Attribute 3 (12152)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 3
en-USItem Trade Attribute 3
it-ITAttributo commerciale articolo 3

Item Trade Attribute 4 (12153)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 4
en-USItem Trade Attribute 4
it-ITAttributo commerciale articolo 4

Item Trade Attribute 5 (12154)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 5
en-USItem Trade Attribute 5
it-ITAttributo commerciale articolo 5

Item Trade Attribute 6 (12155)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 6
en-USItem Trade Attribute 6
it-ITAttributo commerciale articolo 6

Item Trade Attribute 7 (12156)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 7
en-USItem Trade Attribute 7
it-ITAttributo commerciale articolo 7

Item Trade Attribute 8 (12157)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 8
en-USItem Trade Attribute 8
it-ITAttributo commerciale articolo 8

Item Trade Attribute 9 (12158)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 9
en-USItem Trade Attribute 9
it-ITAttributo commerciale articolo 9

Item Trade Attribute 10 (12159)

Text[250]

LanguageCaption
de-DEArtikel-Handelsattribut 10
en-USItem Trade Attribute 10
it-ITAttributo commerciale articolo 10

Trade Attribute Weight (13000)

Integer

LanguageCaption
de-DEGewichtung Handelsattribute
en-USTrade Attribute Weight
it-ITPeso attributi commerciali

EOS Labs -