Table 18122604 EOS060 Spare Part

Table 18122604 EOS060 Spare Part

LanguageCaption
de-ATMaschine Ersatzteil
de-CHMaschine Ersatzteil
de-DEMaschine Ersatzteil
en-USMachine Spare Part
it-CHRicambio macchina
it-ITRicambio macchina

Fields

Source Type (1)

Integer

LanguageCaption
de-ATHerkunftsart
de-CHHerkunftsart
de-DEHerkunftsart
en-USSource Type
it-CHTipo origine
it-ITTipo origine

Source No. (2)

Code[20]

TableRelation: if ("Source Type" = const(Database::"EOS060 Work Request")) "EOS060 Work Request"."No."

LanguageCaption
de-ATHerkunftsnr.
de-CHHerkunftsnr.
de-DEHerkunftsnr.
en-USSource No.
it-CHNr. origine
it-ITNr. origine

Line No. (3)

Integer

LanguageCaption
de-ATZeilennr.
de-CHZeilennr.
de-DEZeilennr.
en-USLine No.
it-CHNr. riga
it-ITNr. riga

Type (4)

enum "EOS060 Type Reduced"

LanguageCaption
de-ATArt
de-CHArt
de-DEArt
en-USType
it-CHTipo
it-ITTipo

No. (5)

Code[20]

TableRelation: if (Type = const(Resource)) Resource else if (Type = const(Item)) Item

LanguageCaption
de-ATNr.
de-CHNr.
de-DENr.
en-USNo.
it-CHNr.
it-ITNr.

Description (6)

Text[100]

LanguageCaption
de-ATBeschreibung
de-CHBeschreibung
de-DEBeschreibung
en-USDescription
it-CHDescrizione
it-ITDescrizione

Description 2 (7)

Text[50]

LanguageCaption
de-ATBeschreibung 2
de-CHBeschreibung 2
de-DEBeschreibung 2
en-USDescription 2
it-CHDescrizione 2
it-ITDescrizione 2

Quantity (8)

Decimal

LanguageCaption
de-ATMenge
de-CHMenge
de-DEMenge
en-USQuantity
it-CHQuantità
it-ITQuantità

Quantity (Base) (13)

Decimal

LanguageCaption
de-ATMenge (Basis)
de-CHMenge (Basis)
de-DEMenge (Basis)
en-USQuantity (Base)
it-CHQuantità (base)
it-ITQuantità (base)

Qty per Base Unit of Measure (9)

Decimal

LanguageCaption
de-ATQty pro Basiseinheit
de-CHQty pro Basiseinheit
de-DEQty pro Basiseinheit
en-USQty per Base Unit of Measure
it-CHQtà per unità di misura di base
it-ITQtà per unità di misura di base

Unit of Measure Code (10)

Code[10]

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

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

Variant Code (11)

Code[10]

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

LanguageCaption
de-ATVariantencode
de-CHVariantencode
de-DEVariantencode
en-USVariant Code
it-CHCod. variante
it-ITCod. variante

Location Code (20)

Code[20]

TableRelation: Location where("Use As In-Transit" = const(false))

LanguageCaption
de-ATLagerortcode
de-CHLagerortcode
de-DELagerortcode
en-USLocation Code
it-CHCod. ubicazione
it-ITCod. ubicazione

Bin Code (21)

Code[20]

TableRelation: Bin.Code where("Location Code" = field("Location Code"))

LanguageCaption
de-ATLagerplatzcode
de-CHLagerplatzcode
de-DELagerplatzcode
en-USBin Code
it-CHCod. collocazione
it-ITCod. collocazione

Inventory (22)

Decimal

FieldClass: FlowField

CalcFormula: sum("Item Ledger Entry".Quantity where("Item No." = field("No."), "Location Code" = field("Location Code"), "Variant Code" = field("Variant Code"), "Unit of Measure Code" = field("Unit of Measure Code")))

LanguageCaption
de-ATLagerbestand
de-CHLagerbestand
de-DELagerbestand
en-USInventory
it-CHMagazzino
it-ITMagazzino

Job No. (51)

Code[20]

TableRelation: Job

LanguageCaption
de-ATProjekt-Nr.
de-CHProjekt-Nr.
de-DEProjekt-Nr.
en-USProject No.
it-CHNr. progetto
it-ITNr. progetto

Job Task No. (52)

Code[20]

TableRelation: "Job Task"."Job Task No." where("Job No." = field("Job No."))

LanguageCaption
de-ATAnzahl der Projektaktivitäten
de-CHAnzahl der Projektaktivitäten
de-DEAnzahl der Projektaktivitäten
en-USProject Task No.
it-CHNr. attività progetto
it-ITNr. attività progetto

Work Request No. Filter (100)

Code[20]

FieldClass: FlowFilter

LanguageCaption
de-ATRessourcen-Nr. Filter
de-CHRessourcen-Nr. Filter
de-DERessourcen-Nr. Filter
en-USResource No. Filter
it-CHFiltro nr. risorsa
it-ITFiltro nr. risorsa

EOS Labs -