Table 5130131 M365 Job Structure Disposition

Table 5130131 M365 Job Structure Disposition

LanguageCaption
de-DEProjektstrukturzeile Disposition
es-ESDisposición de la línea de estructura del proyecto
en-USProject Structure Line Disposition
it-CHDisposizione riga struttura progetto
it-ITDisposizione riga struttura progetto

Fields

Job Structure No. (1)

Code[20]

TableRelation: "M365 Job Structure Header"."No."

LanguageCaption
de-DEProjektstrukturnr.
es-ESNo. de estructura del proyecto
en-USProject Structure No.
it-CHNr. struttura progetto
it-ITNr. struttura progetto

Entry No. (2)

Integer

LanguageCaption
de-DElfd. Nr.
es-ESNo. Movimiento
en-USEntry No.
it-CHNr. movimento
it-ITNr. movimento

Job No. (4)

Code[20]

TableRelation: Job

LanguageCaption
de-DEProjektnr.
es-ESNo. de proyecto
en-USProject No.
it-CHNr. progetto
it-ITNr. progetto

Sort No. (6)

Integer

LanguageCaption
de-DESortiernr.
es-ESNo. Ordenamiento
en-USSort No.
it-CHNr. ordinamento
it-ITNr. ordinamento

Type (7)

Option

" " (0) , Item (1) , "G/L Account" (4) , Resource (7)

LanguageCaption
de-DEArt
es-ESTipo
en-USType
it-CHTipo
it-ITTipo

No. (8)

Code[20]

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

LanguageCaption
de-DENr.
es-ESNo.
en-USNo.
it-CHNr.
it-ITNr.

Variant Code (9)

Code[10]

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

LanguageCaption
de-DEVariantencode
es-ESCódigo de variante
en-USVariant Code
it-CHCod. variante
it-ITCod. variante

Description (10)

Text[100]

LanguageCaption
de-DEBeschreibung
es-ESDescripción
en-USDescription
it-CHDescrizione
it-ITDescrizione

Description 2 (11)

Text[50]

LanguageCaption
de-DEBeschreibung 2
es-ESDescripción 2
en-USDescription 2
it-CHDescrizione 2
it-ITDescrizione 2

Location Code (20)

Code[10]

TableRelation: Location

LanguageCaption
de-DELagerortcode
es-ESCódigo de ubicación
en-USLocation Code
it-CHCod. ubicazione
it-ITCod. ubicazione

Job Structure Entry No. (30)

Integer

TableRelation: "M365 Job Structure Line"

LanguageCaption
de-DELfd. Nr. Projektstrukturzeile
es-ESNo. Movimiento de estructura del proyecto
en-USProject Structure Entry No.
it-CHNr. mov. struttura progetto
it-ITNr. mov. struttura progetto

Quantity (40)

Decimal

LanguageCaption
de-DEMenge
es-ESCantidad
en-USQuantity
it-CHQuantità
it-ITQuantità

Unit of Measure Code (42)

Code[10]

LanguageCaption
de-DEEinheitencode
es-ESCódigo de Unidad de Medida
en-USUnit of Measure Code
it-CHCod. unità di misura
it-ITCod. unità di misura

Vendor No. (50)

Code[20]

TableRelation: Vendor

LanguageCaption
de-DEKreditorennr.
es-ESNo. Proveedor
en-USVendor No.
it-CHNr. fornitore
it-ITNr. fornitore

Vendor Name (51)

Text[100]

FieldClass: FlowField

CalcFormula: lookup(Vendor.Name where("No." = field("Vendor No.")))

LanguageCaption
de-DEKreditorenname
es-ESNombre del proveedor
en-USVendor Name
it-CHNome fornitore
it-ITNome fornitore

Starting Date (90)

Date

LanguageCaption
de-DEStartdatum
es-ESFecha de inicio
en-USStarting Date
it-CHData inizio
it-ITData inizio

Ending Date (110)

Date

LanguageCaption
de-DEEnddatum
es-ESFecha de finalización
en-USEnding Date
it-CHData fine
it-ITData fine

Dimension Set ID (480)

Integer

TableRelation: "Dimension Set Entry"

LanguageCaption
de-DEDimensionssatz-ID
es-ESID del Set de Dimensiones
en-USDimension Set ID
it-CHID set di dimensioni
it-ITID set di dimensioni

Job Replenishment System (590)

Option

" " (0) , "Job Production" (1) , Resource (2) , "Job Purchase" (3)

LanguageCaption
de-DEProjektbeschaffungsmethode
es-ESSistema de reposición de proyecto
en-USProject Replenishment System
it-CHSistema rifornimento progetto
it-ITSistema rifornimento progetto

Direct Unit Cost (750)

Decimal

LanguageCaption
de-DEEK-Preis
es-ESCosto unitario directo
en-USDirect Unit Cost
it-CHCosto unitario diretto
it-ITCosto unitario diretto

Purch. Line Discount % (760)

Decimal

LanguageCaption
de-DEEK-Zeilenrabatt %
es-ESDescuento de línea de compras %
en-USPurch. Line Discount %
it-CH% sconto riga acq.
it-IT% sconto riga acq.

Purch. Currency Code (782)

Code[10]

TableRelation: Currency

LanguageCaption
de-DEWährungscode Einkauf
es-ESCódigo de divisa de compra
en-USPurch. Currency Code
it-CHCod. valuta acq.
it-ITCod. valuta acq.

Purch. Currency Factor (783)

Decimal

LanguageCaption
de-DEWährungsfaktor Einkauf
es-ESFactor de divisa de compra
en-USPurch. Currency Factor
it-CHFattore valuta acq.
it-ITFattore valuta acq.

Reordering Significant (940)

Option

" " (0) , Manually (1) , Planning (2) , Dispopreview (3)

LanguageCaption
de-DEBeschaffungsrelevant
es-ESReordenamiento significativo
en-USReordering Significant
it-CHRiordinamento significante
it-ITRiordinamento significante

Shortcut Dimension 1 Code (1020)

Code[20]

TableRelation: "Dimension Value".Code where("Global Dimension No." = const(1))

LanguageCaption
de-DEShortcutdimensionscode 1
es-ESCódigo de dimensión 1 de acceso directo
en-USShortcut Dimension 1 Code
it-CHCod. colleg. dimen. 1
it-ITCod. colleg. dimen. 1

Shortcut Dimension 2 Code (1030)

Code[20]

TableRelation: "Dimension Value".Code where("Global Dimension No." = const(2))

LanguageCaption
de-DEShortcutdimensionscode 2
es-ESAcceso directo a código de Dimensión 2
en-USShortcut Dimension 2 Code
it-CHCod. colleg. dimen. 2
it-ITCod. colleg. dimen. 2

Next Receipt Date (1031)

Date

LanguageCaption
de-DENächster Wareneingang
es-ESPróxima fecha de recepción
en-USNext Receipt Date
it-CHData di ricezione successiva
it-ITData di ricezione successiva

Availability (1050)

Option

green (0) , yellow (1) , red (2)

LanguageCaption
de-DEVerfügbarkeit
es-ESDisponibilidad
en-USAvailability
it-CHDisponibilità
it-ITDisponibilità

Termin (1051)

Option

green (0) , yellow (1) , red (2)

LanguageCaption
de-DEPlan
es-ESprogramación
en-USSchedule
it-CHProgrammazione
it-ITProgrammazione

Qty in Purch. Order (1060)

Decimal

FieldClass: FlowField

CalcFormula: sum("Purchase Line"."Quantity (Base)" where("M365 Job Structure Entry No." = field("Job Structure Entry No."), "Document Type" = const(Order)))

LanguageCaption
de-DEMenge in Bestellungen
es-ESCantidad en Pedido de compra
en-USQty in Purch. Order
it-CHQtà in Purch. Ordine
it-ITQtà in Purch. Ordine

Qty in Purch. Order Received (1062)

Decimal

FieldClass: FlowField

CalcFormula: sum("Purch. Rcpt. Line"."Quantity (Base)" where("M365 Job Structure Entry No." = field("Job Structure Entry No.")))

LanguageCaption
de-DEMenge in Bestellung (geliefert)
en-USQty in Purch. Order Received
it-CHQtà in Ordine Acq Ric
it-ITQtà in Ordine Acq Ric

Qty in Purch. Quote (1065)

Decimal

FieldClass: FlowField

CalcFormula: sum("Purchase Line"."Outstanding Qty. (Base)" where("M365 Job Structure Entry No." = field("Job Structure Entry No."), "Document Type" = const(Quote)))

LanguageCaption
de-DEMenge in Einkaufsanfragen
es-ESCantidad en Oferta de Compra
en-USQty in Purch. Quote
it-CHQtà in Purch. Citazione
it-ITQtà in Purch. Citazione

Qty in Req. Line (1070)

Decimal

FieldClass: FlowField

CalcFormula: sum("Requisition Line"."Quantity (Base)" where("M365 Job Struct. Entry No." = field("Job Structure Entry No.")))

LanguageCaption
de-DEMenge in Bestellvorschlägen
es-ESCantidad en la línea de solicitudes
en-USQty in Req. Line
it-CHQtà nella riga req.
it-ITQtà nella riga req.

Qty in Prod. Order (1080)

Decimal

FieldClass: FlowField

CalcFormula: sum("Prod. Order Line"."Quantity (Base)" where("M365 Job Structure Entry No." = field("Job Structure Entry No.")))

LanguageCaption
de-DEMenge in Fertigungsaufträgen
es-ESCantidad en Pedido de Prod.
en-USQty in Prod. Order
it-CHQtà in Ordine Prod.
it-ITQtà in Ordine Prod.

Qty in Inventory (1085)

Decimal

FieldClass: FlowField

CalcFormula: sum("Item Ledger Entry"."Remaining Quantity" where("M365 Job Structure Entry No." = field("Job Structure Entry No."), "Item No." = field("No.")))

LanguageCaption
de-DEMenge im Lager
es-ESCantidad en inventario
en-USQty in Inventory
it-CHQtà in magazzino
it-ITQtà in magazzino

Qty missing (1090)

Decimal

LanguageCaption
de-DEFehlmenge
es-ESFalta cantidad
en-USQty missing
it-CHQty mancante
it-ITQty mancante

Qty res. in inventory (1100)

Decimal

FieldClass: FlowField

CalcFormula: sum("Reservation Entry".Quantity where("M365 Job Structure Entry No." = field("Job Structure Entry No."), "Source Type" = const(32), "Reservation Status" = const(Reservation)))

LanguageCaption
de-DEMenge reserviert im Lager
es-ESCantidad reservada en Inventario
en-USQty reserved in Inventory
it-CHQtà impegnata in Magazzino
it-ITQtà impegnata in Magazzino

Free qty purchase order (1110)

Decimal

FieldClass: FlowField

CalcFormula: sum("Purchase Line"."Outstanding Qty. (Base)" where("M365 Job Structure Entry No." = const(0), "Document Type" = const(Order), Type = const(Item), "No." = field("No."), "Variant Code" = field("Variant Code"), "Location Code" = field("Location Code"), "Buy-from Vendor No." = field("Vendor No.")))

LanguageCaption
de-DEMenge ohne Zuordnung Bestellung
es-ESCantidad sin assgn. pedido de compras
en-USQty without assgn. purch. order
it-CHQtà senza assegnamenti in ordini acquisto
it-ITQtà senza assegnamenti in ordini acquisto

Res. qty purchase order (1112)

Decimal

FieldClass: FlowField

CalcFormula: sum("Purchase Line"."Reserved Qty. (Base)" where("M365 Job Structure Entry No." = const(0), "Document Type" = const(Order), Type = const(Item), "No." = field("No."), "Location Code" = field("Location Code")))

LanguageCaption
de-DERes. Menge Bestellungen
es-ESCantidad Res. de pedido de compra
en-USRes. Qty purchase order
it-CHOrdine fornitore Qtà res.
it-ITOrdine fornitore Qtà res.

Free qty inventory (1120)

Decimal

FieldClass: FlowField

CalcFormula: sum("Item Ledger Entry"."Remaining Quantity" where("M365 Job Structure Entry No." = const(0), "Item No." = field("No."), "Variant Code" = field("Variant Code"), "Location Code" = field("Location Code")))

LanguageCaption
de-DEFreie Menge Lager
es-ESInventario de cantidad Libre
en-USFree qty inventory
it-CHQuantità libera magazzino
it-ITQuantità libera magazzino

Total qty inventory (1130)

Decimal

FieldClass: FlowField

CalcFormula: sum("Item Ledger Entry"."Remaining Quantity" where("Item No." = field("No."), "Variant Code" = field("Variant Code")))

LanguageCaption
de-DEGesamtmenge Lager
es-ESInventario total de cantidad
en-USTotal qty inventory
it-CHTotale qtà inventario
it-ITTotale qtà inventario

Unit of Measure Job Struct (1140)

Code[10]

FieldClass: FlowField

CalcFormula: lookup("M365 Job Structure Line"."Unit of Measure Code" where("Entry No." = field("Job Structure Entry No.")))

LanguageCaption
de-DEEinheit Projektstrukturzeile
en-USUnit of Measure Project Structure
it-CHUnità di misura struttura progetto
it-ITUnità di misura struttura progetto

Methods

ShowDimensions

procedure ShowDimensions()

EOS Labs -