Table 18123300 EOS047 Setup Line

Table 18123300 EOS047 Setup Line

LanguageCaption
da-DKOver-/Underlevering opsætning linjer
de-ATÜber-/Unterlieferung Setup Zeile
de-CHÜber-/Unterlieferung Setup Zeile
de-DEÜber-/Unterlieferung Setup Zeile
es-ESSobre/Configuración lineas publicación deficiente
es-MXSobre/Configuración lineas publicación deficiente
fr-BESur-/Sous-Diffusion Setup Lignes
fr-CASur-/Sous-Diffusion Setup Lignes
fr-CHSur-/Sous-Diffusion Setup Lignes
fr-FRSur-/Sous-Diffusion Setup Lignes
en-USOver-/Underdelivery Setup Line
it-CHRiga setup consegne per eccesso/difetto
it-ITRiga setup consegne per eccesso/difetto
nl-BEOver-/Onderweergave Setup Lijnen
nl-NLOver-/Onderweergave Setup Lijnen

Fields

Entry No. (1)

Integer

LanguageCaption
da-DKLøbenr.
de-ATLfd.-Nr.
de-CHLfd.-Nr.
de-DELfd.-Nr.
es-ESNº mov.
es-MXNº mov.
fr-BEN° séquence
fr-CAN° séquence
fr-CHN° séquence
fr-FRN° séquence
en-USEntry No.
it-CHNr. movimento
it-ITNr. movimento
nl-BEVolgnummer
nl-NLVolgnummer

Direction (2)

Option

"Both" (0) , "Inbound" (1) , "Outbound" (2)

LanguageCaption
da-DKRetning
de-ATRichtung
de-CHRichtung
de-DERichtung
es-ESDirección
es-MXDirección
fr-BEAdresse
fr-CAAdresse
fr-CHAdresse
fr-FRAdresse
en-USDirection
it-CHDirezione
it-ITDirezione
nl-BEAdres
nl-NLAdres

Source Type (3)

Option

" " (0) , Customer (1) , Vendor (2) , Location (3)

LanguageCaption
da-DKKildetype
de-ATHerkunftsart
de-CHHerkunftsart
de-DEHerkunftsart
es-ESTipo procedencia mov.
es-MXTipo procedencia mov.
fr-BEType origine
fr-CAType origine
fr-CHType origine
fr-FRType origine
en-USSource Type
it-CHTipo origine
it-ITTipo origine
nl-BEBronsoort
nl-NLBronsoort

Source No. (4)

Code[20]

TableRelation: if ("Source Type" = const(Customer)) Customer."No." else if ("Source Type" = const(Vendor)) Vendor."No." else if ("Source Type" = const(Location)) Location.Code

LanguageCaption
da-DKKildenr.
de-ATHerkunfts-Nr.
de-CHHerkunfts-Nr.
de-DEHerkunfts-Nr.
es-ESCód. procedencia mov.
es-MXCód. procedencia mov.
fr-BEN° origine
fr-CAN° origine
fr-CHN° origine
fr-FRN° origine
en-USSource No.
it-CHNr. origine
it-ITNr. origine
nl-BEBronnr.
nl-NLBronnr.

Item Category Code (5)

Code[20]

TableRelation: "Item Category".Code

LanguageCaption
da-DKVarekategorikode
de-ATArtikelkategoriecode
de-CHArtikelkategoriecode
de-DEArtikelkategoriecode
es-ESCód. categoría producto
es-MXCód. categoría producto
fr-BECode catégorie article
fr-CACode catégorie article
fr-CHCode catégorie article
fr-FRCode catégorie article
en-USItem Category Code
it-CHCod. categoria articolo
it-ITCod. categoria articolo
nl-BEArtikelcategoriecode
nl-NLArtikelcategoriecode

Item No. (7)

Code[20]

TableRelation: Item

LanguageCaption
da-DKVarenr.
de-ATArtikelnr.
de-CHArtikelnr.
de-DEArtikelnr.
es-ESNº producto
es-MXNº producto
fr-BEN° article
fr-CAN° article
fr-CHN° article
fr-FRN° article
en-USItem No.
it-CHNr. articolo
it-ITNr. articolo
nl-BEArtikelnr.
nl-NLArtikelnr.

Variant Code (8)

Code[10]

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

LanguageCaption
da-DKVariantkode
de-ATVariantencode
de-CHVariantencode
de-DEVariantencode
es-ESCód. variante
es-MXCód. variante
fr-BECode variante
fr-CACode variante
fr-CHCode variante
fr-FRCode variante
en-USVariant Code
it-CHCod. variante
it-ITCod. variante
nl-BEVariantcode
nl-NLVariantcode

Type (9)

Option

"Overdelivery" (0) , "Underdelivery" (1)

LanguageCaption
da-DKType
de-ATArt
de-CHArt
de-DEArt
es-ESTipo
es-MXTipo
fr-BEType
fr-CAType
fr-CHType
fr-FRType
en-USType
it-CHTipo
it-ITTipo
nl-BESoort
nl-NLSoort

Tolerance Type (10)

Option

"Not Allowed" (0) , Unlimited (1) , "Quantity (Base)" (2) , Percentage (3)

LanguageCaption
da-DKTolerance type
de-ATToleranzart
de-CHToleranzart
de-DEToleranzart
es-ESTipo de tolerancia
es-MXTipo de tolerancia
fr-BEType de tolérance
fr-CAType de tolérance
fr-CHType de tolérance
fr-FRType de tolérance
en-USTolerance Type
it-CHTipo tolleranza
it-ITTipo tolleranza
nl-BETolerantie Type
nl-NLTolerantie Type

Tolerance Value (12)

Decimal

LanguageCaption
da-DKTolerance Værdi
de-ATToleranzwert
de-CHToleranzwert
de-DEToleranzwert
es-ESValor de tolerancia
es-MXValor de tolerancia
fr-BETolérance Valeur
fr-CATolérance Valeur
fr-CHTolérance Valeur
fr-FRTolérance Valeur
en-USTolerance Value
it-CHValore tolleranza
it-ITValore tolleranza
nl-BETolerantie Value
nl-NLTolerantie Value

Show Warning (15)

Boolean

LanguageCaption
da-DKVis advarsel
de-ATWarnung anzeigen
de-CHWarnung anzeigen
de-DEWarnung anzeigen
es-ESMostrar advertencia
es-MXMostrar advertencia
fr-BEAfficher avertissement
fr-CAAfficher avertissement
fr-CHAfficher avertissement
fr-FRAfficher avertissement
en-USShow Warning
it-CHMostra avviso
it-ITMostra avviso
nl-BEWaarschuwing weergeven
nl-NLWaarschuwing weergeven

Location Code (18)

Code[10]

TableRelation: Location."Code"

LanguageCaption
da-DKLokationskode
de-ATLagerortcode
de-CHLagerortcode
de-DELagerortcode
es-ESCódigo de almacén
es-MXCódigo de almacén
fr-BECode de localisation
fr-CACode de localisation
fr-CHCode de localisation
fr-FRCode de localisation
en-USLocation Code
it-CHCod. ubicazione
it-ITCod. ubicazione
nl-BEMagazijncode
nl-NLMagazijncode

Priority (30)

Integer

LanguageCaption
da-DKPrioritet
de-ATPriorität
de-CHPriorität
de-DEPriorität
es-ESPrioridad
es-MXPrioridad
fr-BEPriorité
fr-CAPriorité
fr-CHPriorité
fr-FRPriorité
en-USPriority
it-CHPriorità
it-ITPriorità
nl-BEPrioriteit
nl-NLPrioriteit

Blocked (31)

Boolean

LanguageCaption
da-DKSpærret
de-ATGesperrt
de-CHGesperrt
de-DEGesperrt
es-ESBloqueado
es-MXBloqueado
fr-BEBloqué
fr-CABloqué
fr-CHBloqué
fr-FRBloqué
en-USBlocked
it-CHBloccato
it-ITBloccato
nl-BEGeblokkeerd
nl-NLGeblokkeerd

Methods

FindEligibleSetups

procedure FindEligibleSetups(var TmpSetup: Record "EOS047 Setup Line"; TypeFilter: Integer): Boolean

Retrieves all eligible setup lines using the values set on the current instance as filter values.

Parameters / Return Value

  • TmpSetup Record "EOS047 Setup Line"

    A temporary buffer that will contain all found eligible setups lines

  • TypeFilter Integer

    The type filter. 0 = Overdelivery, 1 = Underdelivery.

  • Returns Boolean

FindEligibleSetups

procedure FindEligibleSetups(SourceDocument: Variant; var TmpSetup: Record "EOS047 Setup Line"; TypeFilter: Integer): Boolean

Retrieves all eligible setup lines using the values set on the current instance as filter values and (optionally) a reference source document.

Parameters / Return Value

  • SourceDocument Variant

    The source document for which to retrieve the setup lines.

  • TmpSetup Record "EOS047 Setup Line"

    A temporary buffer that will contain all found eligible setups lines

  • TypeFilter Integer

    The type filter. 0 = Overdelivery, 1 = Underdelivery.

  • Returns Boolean

FindSetup

procedure FindSetup(TypeFilter: Integer): Boolean

Parameters / Return Value

  • TypeFilter Integer

  • Returns Boolean

FindSetupByVariant

procedure FindSetupByVariant(SourceDocumentLine: Variant; TypeFilter: Integer): Boolean

Try to find the first applicable setup for a given source document line.

Parameters / Return Value

  • SourceDocumentLine Variant

    The source document line.

  • TypeFilter Integer

    The overdelivery type. See the field Type on the setup line for possible values.

  • Returns Boolean

    true if a setup has been found.

CopyFromSalesLine

procedure CopyFromSalesLine(SalesLine: Record "Sales Line")

Copy filter-related values from the source document to the setup line. These copied values are then used to filter the setup lines.

Parameters / Return Value

  • SalesLine Record "Sales Line"

    The sales line.

CopyFromPurchLine

procedure CopyFromPurchLine(PurchLine: Record "Purchase Line")

Copy filter-related values from the source document to the setup line. These copied values are then used to filter the setup lines.

Parameters / Return Value

  • PurchLine Record "Purchase Line"

    The purchase line.

CopyFromTransLine

procedure CopyFromTransLine(TransLine: Record "Transfer Line")

Copy filter-related values from the source document to the setup line. These copied values are then used to filter the setup lines.

Parameters / Return Value

  • TransLine Record "Transfer Line"

    The purchase line.

CopyFromSourceDocument

procedure CopyFromSourceDocument(SourceDocumentLine: Variant)

Copy filter-related values from the source document to the setup line. Theese copied values are then used to filter the setup lines.

Parameters / Return Value

  • SourceDocumentLine Variant

    The source document line.

Events

OnFindSetupAfterSetFilters

local procedure OnFindSetupAfterSetFilters(Values: Record "EOS047 Setup Line"; SourceDocument: Variant; var Setup: Record "EOS047 Setup Line")

Raised after filters have been set on the setup line to find a valid setup line.

Parameters / Return Value

  • Values Record "EOS047 Setup Line"

    An instance of the setup line where all relevant filter fields have been correctly set.

  • SourceDocument Variant

    The source document for which this event was fired for. This value is optional and may be empty/uninitialized, depending on how the parent function was called.

  • Setup Record "EOS047 Setup Line"

    The instance of the setup lines where filters should be applied to.

OnAfterCopyFromPurchLine

local procedure OnAfterCopyFromPurchLine(var Setup: Record "EOS047 Setup Line"; PurchLine: Record "Purchase Line")

Raised after filter-related fields have been copied from a purchase line to the setup line. Use this to copy custom filter fields.

Parameters / Return Value

  • Setup Record "EOS047 Setup Line"

    The setup line where filter-values should be written to.

  • PurchLine Record "Purchase Line"

    The purchase line.

OnAfterCopyFromTransferLine

local procedure OnAfterCopyFromTransferLine(var Setup: Record "EOS047 Setup Line"; TransferLine: Record "Transfer Line")

Raised after filter-related fields have been copied from a transfer line to the setup line. Use this to copy custom filter fields.

Parameters / Return Value

  • Setup Record "EOS047 Setup Line"

    The setup line where filter-values should be written to.

  • TransferLine Record "Transfer Line"

OnAfterCopyFromSalesLine

local procedure OnAfterCopyFromSalesLine(var Setup: Record "EOS047 Setup Line"; SalesLine: Record "Sales Line")

Raised after filter-related fields have been copied from a sales line to the setup line. Use this to copy custom filter fields.

Parameters / Return Value

  • Setup Record "EOS047 Setup Line"

    The setup line where filter-values should be written to.

  • SalesLine Record "Sales Line"

    The sales line.

OnBeforeCopyFromSourceDocument

local procedure OnBeforeCopyFromSourceDocument(var SetupLine: Record "EOS047 Setup Line"; SourceDocumentLine: Variant; var Handled: Boolean)

Raised before filter-related fields are copied from a source document line to the setup line. Use this to handle custom tables.

Parameters / Return Value

  • SetupLine Record "EOS047 Setup Line"

  • SourceDocumentLine Variant

    The source document line.

  • Handled Boolean

    Set this to true to disable default behaviour.

OnAfterCopyFromSourceDocument

local procedure OnAfterCopyFromSourceDocument(var SetupLine: Record "EOS047 Setup Line"; SourceDocumentLine: Variant)

Raised after filter-related fields have been copied from a source document line to the setup line. Use this to copy custom fields.

Parameters / Return Value

  • SetupLine Record "EOS047 Setup Line"

  • SourceDocumentLine Variant

    The source document line.

OnBeforeFindEligibleSetups

local procedure OnBeforeFindEligibleSetups(TempFilterValues: Record "EOS047 Setup Line"; SourceDocument: Variant; var TempFoundSetupLine: Record "EOS047 Setup Line"; var Handled: Boolean)

Raised before eligible setups are retrieved for a given filter values set. If this event returns as handled, the default setup retrieval will be bypassed and only the setups you return in TempFoundSetupLine will be considered.

Parameters / Return Value

  • TempFilterValues Record "EOS047 Setup Line"

    The filter values to use when retrieving eligible setups.

  • SourceDocument Variant

    The source document for which this event was fired for. This value is optional and may be empty/uninitialized, depending on how the parent function was called.

  • TempFoundSetupLine Record "EOS047 Setup Line"

    A temporary buffer containing all eligible setup lines.

  • Handled Boolean

    Gets or sets if this event has been completely handled.

OnAfterFindEligibleSetups

local procedure OnAfterFindEligibleSetups(TempFilterValues: Record "EOS047 Setup Line"; SourceDocument: Variant; var TempFoundSetupLine: Record "EOS047 Setup Line"; TypeFilter: Integer)

Raised after eligible setups have been retrieved for a given filter values set. The calling function FindEligibleSetups will return true (a setup has been found) only if TempFoundSetupLine contains records. This event will fire, even if OnBeforeFindEligibleSetups previously returned as handled.

Parameters / Return Value

  • TempFilterValues Record "EOS047 Setup Line"

    The filter values used when retrieving eligible setups.

  • SourceDocument Variant

    The source document for which this event was fired for. This value is optional and may be empty/uninitialized, depending on how the parent function was called.

  • TempFoundSetupLine Record "EOS047 Setup Line"

    A temporary buffer containing all eligible setup lines that were found.

  • TypeFilter Integer

    The type filter. 0 = Overdelivery, 1 = Underdelivery.


EOS Labs -