Table 18126147 EOS058 SCM Worksheet Line

Table 18126147 EOS058 SCM Worksheet Line

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

Fields

SCM Worksheet Template (1)

Code[10]

TableRelation: "EOS058 SCM Worksheet Template"

LanguageCaption
de-DESCM Vorschlagsvorlage
en-USSCM Worksheet Template
it-ITSCM def. worksheet

SCM Worksheet Name (2)

Code[10]

TableRelation: "EOS058 SCM Worksheet Name".Name WHERE("SCM Worksheet Template" = FIELD("SCM Worksheet Template"))

LanguageCaption
de-DESCM Vorschlagsname
en-USSCM Worksheet Name
it-ITSCM nome worksheet

Line No. (3)

Integer

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

Item No. (10)

Code[20]

TableRelation: Item

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

Variant Code (11)

Code[10]

TableRelation: "Item Variant".Code WHERE("Item No." = FIELD("Item No."))

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

Description (12)

Text[100]

LanguageCaption
de-DEBeschreibung
en-USDescription
it-ITDescrizione

Description 2 (13)

Text[50]

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

Starting Date (15)

Date

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

Ending Date (16)

Date

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

Date Filter (18)

Date

FieldClass: FlowFilter

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

Posting Date (19)

Date

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

Quantity (20)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS058 SCM 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
en-USQuantity
it-ITQuantità

Planning Quantity (21)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS058 SCM 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
en-USPlanning Quantity
it-ITQuantità pianificazione

Forecast Quantity (22)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS058 SCM 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
en-USForecast Quantity
it-ITQuantità previsione

Qty. to Distribute (23)

Decimal

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

Location Code (25)

Code[10]

TableRelation: Location WHERE("Use As In-Transit" = CONST(false))

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

Item Status Code (30)

Code[10]

TableRelation: "EOS058 SCM Item Status"

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

Planning Status Code (31)

Code[10]

TableRelation: "EOS058 SCM Item Status"

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

Trend % (32)

Decimal

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

Forecast Status (33)

Option

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

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

Formula Code (35)

Code[10]

TableRelation: "EOS058 SCM Formula"

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

Planning Formula Code (36)

Code[10]

TableRelation: "EOS058 SCM Formula"

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

Forecast Group Code (37)

Code[20]

TableRelation: "EOS058 SCM Forecast Group"

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

Analyzed Data (40)

Integer

FieldClass: FlowField

CalcFormula: Count("EOS058 SCM 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
en-USAnalyzed Data
it-ITDati analisi

Demand Classification (41)

Option

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

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

Average Demand Interval (42)

Decimal

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

CV2 (43)

Decimal

LanguageCaption
de-DECV2
en-USCV2
it-ITCV2

Safety Stock Quantity (50)

Decimal

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

Reorder Point (51)

Decimal

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

Lead Time Calculation (52)

DateFormula

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

Date below Zero (55)

Date

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

Date below Safety Stock (56)

Date

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

Date below Reorder Point (57)

Date

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

Lowest Inventory (58)

Decimal

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

Finally Inventory (59)

Decimal

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

Earliest Receipt Date (60)

Date

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

Inventory below Zero (61)

Decimal

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

Order Quantity (62)

Decimal

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

Due Date (63)

Date

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

Vendor No. (65)

Code[20]

TableRelation: Vendor

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

Comment (70)

Text[100]

LanguageCaption
de-DEBemerkung
en-USComment
it-ITCommento

Methods

EmptyLine

procedure EmptyLine(): Boolean

Parameters / Return Value

  • Returns Boolean

SetupNewLine

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

Parameters / Return Value

  • LastScmWkshLine Record "EOS058 SCM Worksheet Line"

UpdatePlanningData

procedure UpdatePlanningData()

CalcForecastPeriods

procedure CalcForecastPeriods() NoOfPeriods: Integer

Parameters / Return Value

  • Returns Integer

CalcDemandClassification

procedure CalcDemandClassification()

FindFormula

procedure FindFormula()

EOS Labs -