Table 18126147 EOS058 Worksheet Line

Table 18126147 EOS058 Worksheet Line

LanguageCaption
de-DESCM Vorschlagszeile
it-ITSCM riga worksheet
en-USSCM Worksheet Line

Fields

SCM Worksheet Template (1)

Code[10]

TableRelation: "EOS058 Worksheet Template"

LanguageCaption
de-DESCM Vorschlagsvorlage
it-ITDefault Worksheet (SCM)
en-USSCM Worksheet Template

SCM Worksheet Name (2)

Code[10]

TableRelation: "EOS058 Worksheet Name".Name where("SCM Worksheet Template" = field("SCM Worksheet Template"))

LanguageCaption
de-DESCM Vorschlagsname
it-ITNome Worksheet (SCM)
en-USSCM Worksheet Name

Line No. (3)

Integer

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

Item No. (10)

Code[20]

TableRelation: Item

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

Variant Code (11)

Code[10]

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

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

Description (12)

Text[100]

LanguageCaption
de-DEBeschreibung
it-ITDescrizione
en-USDescription

Description 2 (13)

Text[50]

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

Starting Date (15)

Date

LanguageCaption
de-DEStartdatum
it-ITData inizio
en-USStarting Date

Ending Date (16)

Date

LanguageCaption
de-DEEnddatum
it-ITData fine
en-USEnding Date

Date Filter (18)

Date

FieldClass: FlowFilter

LanguageCaption
de-DEDatumsfilter
it-ITFiltro data
en-USDate Filter

Posting Date (19)

Date

LanguageCaption
de-DEBuchungsdatum
it-ITData di registrazione
en-USPosting Date

Quantity (20)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS058 Data Entry".Quantity where("SCM Worksheet Template" = field("SCM Worksheet Template"), "SCM Worksheet Name" = field("SCM Worksheet Name"), "Line No." = field("Line No."), "Entry Type" = const(History), "Planning Date" = field("Date Filter")))

LanguageCaption
de-DEMenge
it-ITQuantità
en-USQuantity

Planning Quantity (21)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS058 Data Entry"."Planning Quantity" where("SCM Worksheet Template" = field("SCM Worksheet Template"), "SCM Worksheet Name" = field("SCM Worksheet Name"), "Line No." = field("Line No."), "Entry Type" = const(History), "Planning Date" = field("Date Filter")))

LanguageCaption
de-DEPlanungsmenge
it-ITQuantità pianificazione
en-USPlanning Quantity

Forecast Quantity (22)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS058 Data Entry"."Planning Quantity" where("SCM Worksheet Template" = field("SCM Worksheet Template"), "SCM Worksheet Name" = field("SCM Worksheet Name"), "Line No." = field("Line No."), "Entry Type" = const(Forecast), "Planning Date" = field("Date Filter")))

LanguageCaption
de-DEMenge Prognose
it-ITQuantità previsione
en-USForecast Quantity

Qty. to Distribute (23)

Decimal

LanguageCaption
de-DEMenge zum Verteilen
it-ITQtà. da distribuire
en-USQty. to Distribute

Location Code (25)

Code[10]

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

LanguageCaption
de-DELagerortcode
it-ITCod. ubicazione
en-USLocation Code

Item Status Code (30)

Code[10]

TableRelation: "EOS058 Item Status"

LanguageCaption
de-DEArtikelstatuscode
it-ITCod. status articolo
en-USItem Status Code

Planning Status Code (31)

Code[10]

TableRelation: "EOS058 Item Status"

LanguageCaption
de-DEPlanung Statuscode
it-ITCod. status pianif.
en-USPlanning Status Code

Trend % (32)

Decimal

LanguageCaption
de-DETrend %
it-ITTendenza %
en-USTrend %

Forecast Status (33)

Option

" " (0) , "Historical Data" (1) , Analysis (2) , Forecast (3) , Posted (4)

LanguageCaption
de-DEStatus Prognose
it-ITStato previsione
en-USForecast Status

Formula Code (35)

Code[10]

TableRelation: "EOS058 Formula"

LanguageCaption
de-DEFormelcode
it-ITCod. formula
en-USFormula Code

Planning Formula Code (36)

Code[10]

TableRelation: "EOS058 Formula"

LanguageCaption
de-DEPlanungs Formelcode
it-ITCod. formula pianif.
en-USPlanning Formula Code

Forecast Group Code (37)

Code[20]

TableRelation: "EOS058 Forecast Group"

LanguageCaption
de-DEGruppencode Prognose
it-ITCodice gruppo previsioni
en-USForecast Group Code

Analyzed Data (40)

Integer

FieldClass: FlowField

CalcFormula: count("EOS058 Data Result" where("SCM Worksheet Template" = field("SCM Worksheet Template"), "SCM Worksheet Name" = field("SCM Worksheet Name"), "Line No." = field("Line No.")))

LanguageCaption
de-DEAnalysierte Daten
it-ITDati analisi
en-USAnalyzed Data

Demand Classification (41)

Option

" " (0) , Smooth (1) , Intermittent (2) , Erratic (3) , Lumpy (4)

LanguageCaption
de-DEBedarfsklassifizierung
it-ITClassificazione richiesta
en-USDemand Classification

Average Demand Interval (42)

Decimal

LanguageCaption
de-DEDurchschnittliches Bedarfsintervall
it-ITIntervallo medio della domanda
en-USAverage Demand Interval

CV2 (43)

Decimal

LanguageCaption
de-DECV2
it-ITCV2
en-USCV2

Safety Stock Quantity (50)

Decimal

LanguageCaption
de-DESicherheitsbestand
it-ITScorta di sicurezza
en-USSafety Stock Quantity

Reorder Point (51)

Decimal

LanguageCaption
de-DEMinimalbestand
it-ITPunto riordino
en-USReorder Point

Lead Time Calculation (52)

DateFormula

LanguageCaption
de-DEBeschaffungszeit
it-ITCalcolo lead time
en-USLead Time Calculation

Date below Zero (55)

Date

LanguageCaption
de-DEDatum unter Null
it-ITData sotto zero
en-USDate below Zero

Date below Safety Stock (56)

Date

LanguageCaption
de-DEDatum unter Sicherheitsbestand
it-ITData sotto scorta di sicurezza
en-USDate below Safety Stock

Date below Reorder Point (57)

Date

LanguageCaption
de-DEDatum unter Wiederbeschaffungspunkt
it-ITData sotto punto di riordino
en-USDate below Reorder Point

Lowest Inventory (58)

Decimal

LanguageCaption
de-DEKleinster Bestand
it-ITGiacenza minore
en-USLowest Inventory

Finally Inventory (59)

Decimal

LanguageCaption
de-DEEndbestand
it-ITGiacenza finale
en-USFinally Inventory

Earliest Receipt Date (60)

Date

LanguageCaption
de-DEFrühestes Zugangsdatum
it-ITPrima data ricezione
en-USEarliest Receipt Date

Inventory below Zero (61)

Decimal

LanguageCaption
de-DEBestand unter Null
it-ITGiacenza sotto zero
en-USInventory below Zero

Order Quantity (62)

Decimal

LanguageCaption
de-DEAuftragsmenge
it-ITQuantità Ordine
en-USOrder Quantity

Due Date (63)

Date

LanguageCaption
de-DEFälligkeitsdatum
it-ITData scadenza
en-USDue Date

Vendor No. (65)

Code[20]

TableRelation: Vendor

LanguageCaption
de-DEKreditorennr.
it-ITNr. fornitore
en-USVendor No.

Comment (70)

Text[100]

LanguageCaption
de-DEBemerkung
it-ITCommento
en-USComment

Methods

EmptyLine

procedure EmptyLine(): Boolean

Parameters / Return Value

  • Returns Boolean

SetupNewLine

procedure SetupNewLine(LastScmWkshLine: Record "EOS058 Worksheet Line")

Parameters / Return Value

  • LastScmWkshLine Record "EOS058 Worksheet Line"

UpdatePlanningData

procedure UpdatePlanningData()

CalcForecastPeriods

procedure CalcForecastPeriods() NoOfPeriods: Integer

Parameters / Return Value

  • Returns Integer

CalcDemandClassification

procedure CalcDemandClassification()

FindFormula

procedure FindFormula()

EOS Labs -