Table 18091287 EOS028 CFG Excel Template

Table 18091287 EOS028 CFG Excel Template

LanguageCaption
da-DKExcel-skabeloner
de-ATExcel-Vorlagen
de-CHExcel-Vorlagen
de-DEExcel-Vorlagen
es-ESPlantillas de Excel
es-MXPlantillas de Excel
fi-FIExcel-mallit
fr-BEModèles Excel
fr-CAModèles Excel
fr-CHModèles Excel
fr-FRModèles Excel
en-USExcel Templates
it-CHTemplate Excel
it-ITTemplate Excel
nb-NOExcel-maler
nl-BEExcel-sjablonen
nl-NLExcel-sjablonen
sv-SEExcel-mallar

Fields

Entry No. (1)

Integer

Numerical sequence that identifies the record.

LanguageCaption
da-DKIndgangsnr.
de-ATEintrag Nr.
de-CHEintrag Nr.
de-DEEintrag Nr.
es-ESEntrada No.
es-MXEntrada No.
fi-FITapahtuman nro
fr-BENuméro d’entrée
fr-CANuméro d’entrée
fr-CHNuméro d’entrée
fr-FRNuméro d’entrée
en-USEntry No.
it-CHNr. movimento
it-ITNr. movimento
nb-NOPostnr.
nl-BEIngang nr.
nl-NLIngang nr.
sv-SEInmatningsnr

Name (10)

Text[80]

Name contains a name that can be applied to the current record to identify it

LanguageCaption
da-DKNavn
de-ATNamen
de-CHNamen
de-DENamen
es-ESNombre
es-MXNombre
fi-FINimi
fr-BENom
fr-CANom
fr-CHNom
fr-FRNom
en-USName
it-CHNome
it-ITNome
nb-NOnavn
nl-BENaam
nl-NLNaam
sv-SENamn

Description (11)

Text[250]

Description contains a description that can be applied to the current record to identify it

LanguageCaption
da-DKBeskrivelse
de-ATBeschreibung
de-CHBeschreibung
de-DEBeschreibung
es-ESDescripción
es-MXDescripción
fi-FIKuvaus
fr-BEDescription
fr-CADescription
fr-CHDescription
fr-FRDescription
en-USDescription
it-CHDescrizione
it-ITDescrizione
nb-NOBeskrivelse
nl-BEBeschrijving
nl-NLBeschrijving
sv-SEBeskrivning

File Name (12)

Text[80]

Contains the name of the loaded Excel file.

LanguageCaption
da-DKFilnavn
de-ATDateiname
de-CHDateiname
de-DEDateiname
es-ESNombre de archivo
es-MXNombre de archivo
fi-FITiedoston nimi
fr-BENom du fichier
fr-CANom du fichier
fr-CHNom du fichier
fr-FRNom du fichier
en-USFile Name
it-CHNome file
it-ITNome file
nb-NOFilnavn
nl-BEBestandsnaam
nl-NLBestandsnaam
sv-SEFilnamn

Blob Key (13)

BigInteger

“Blob Key” contains the key of the blob where the Excel file is stored.

LanguageCaption
da-DKBlob-tast
de-ATBlob-Schlüssel
de-CHBlob-Schlüssel
de-DEBlob-Schlüssel
es-ESClave de blob
es-MXClave de blob
fi-FIBlob-avain
fr-BEClé Blob
fr-CAClé Blob
fr-CHClé Blob
fr-FRClé Blob
en-USBlob Key
it-CHChiave BLOB
it-ITChiave BLOB
nb-NOBlob-nøkkel
nl-BEBlob-toets
nl-NLBlob-toets
sv-SEBlob-nyckel

Last Modified Date Time (14)

DateTime

“Last Modified Date Time” contains the date and time of the last change made to this record.

LanguageCaption
da-DKDato for seneste ændring
de-ATDatumsänderung der letzten Änderung
de-CHDatumsänderung der letzten Änderung
de-DEDatumsänderung der letzten Änderung
es-ESFecha de la última modificación
es-MXFecha de la última modificación
fi-FIViimeksi muokattu päivämääräaika
fr-BEHeure de date dernière modification
fr-CAHeure de date dernière modification
fr-CHHeure de date dernière modification
fr-FRHeure de date dernière modification
en-USLast Modified Date Time
it-CHData ora ultima modifica
it-ITData ora ultima modifica
nb-NOSist endret dato klokkeslett
nl-BELaatst gewijzigde datumtijd
nl-NLLaatst gewijzigde datumtijd
sv-SESenast ändrad datumtid

User ID (15)

Code[50]

TableRelation: User."User Name"

“User ID” contains the name of the user who created the current record.

LanguageCaption
da-DKBruger-id
de-ATBenutzer-ID
de-CHBenutzer-ID
de-DEBenutzer-ID
es-ESID de usuario
es-MXID de usuario
fi-FIKäyttäjätunnus
fr-BEID utilisateur
fr-CAID utilisateur
fr-CHID utilisateur
fr-FRID utilisateur
en-USUser ID
it-CHID utente
it-ITID utente
nb-NOBruker-ID
nl-BEGebruikersnaam
nl-NLGebruikersnaam
sv-SEAnvändar-ID

Rule Code (16)

Code[10]

TableRelation: "EOS028 CFG Rule"

“Rule Code” contains the rule code.

LanguageCaption
da-DKRegelkode
de-ATRegelcode
de-CHRegelcode
de-DERegelcode
es-ESCódigo de reglas
es-MXCódigo de reglas
fi-FISäännön koodi
fr-BECode de règles
fr-CACode de règles
fr-CHCode de règles
fr-FRCode de règles
en-USRule Code
it-CHCodice regola
it-ITCodice regola
nb-NORegelkode
nl-BERegelcode
nl-NLRegelcode
sv-SERegelkod

Methods

HasContent

procedure HasContent(BlobKey: BigInteger): Boolean

This procedure returns if the Persistent Blob is present.

Parameters / Return Value

  • BlobKey BigInteger

    “BlobKey” contains the primary key of the blob

  • Returns Boolean

    If true the Persistent Blob is present. If False the Persistent Blob isn’t present

ImportTemplateFile

procedure ImportTemplateFile(RuleCode: Code[10])

This procedure imports file in “EOS028 CFG Excel Template”.

Parameters / Return Value

  • RuleCode Code[10]

    “RuleCode” contains the Rule Code if present

ImportTemplateFileFromRule

procedure ImportTemplateFileFromRule(var Rule: Record "EOS028 CFG Rule")

This procedure imports the file as default file in the rule and contextually archives it.

Parameters / Return Value

  • Rule Record "EOS028 CFG Rule"

    “Rule” where to import the file

SetAsDefaultInRule

procedure SetAsDefaultInRule()

This procedure allows you to apply the archived file as the default rule file.

ArchiveTemplateExcel

procedure ArchiveTemplateExcel(FileName: Text[80]; NewName: text[80]; NewDescription: Text[250]; BlobKey: BigInteger; RuleCode: Code[10])

This procedure archives Persistent Blob.

Parameters / Return Value

  • FileName Text[80]

    “FileName” of the Persistent Blob

  • NewName text[80]

    “NewName” contains the name of the arichive

  • NewDescription Text[250]

    “NewDescription” contains the description of the arichive

  • BlobKey BigInteger

    “BlobKey” contains the key of the Persistent Blob

  • RuleCode Code[10]

    “RuleCode” contains the Rule Code

GetTemplateFileAsTempBlob

procedure GetTemplateFileAsTempBlob(var TempBlob: Codeunit "Temp Blob"; BlobKey: BigInteger): Boolean

This procedure gets Persistent Blob specified in the parameters.

Parameters / Return Value

  • TempBlob Codeunit "Temp Blob"

    “TempBlob” contains the Persistent Blob

  • BlobKey BigInteger

    “BlobKey” contains the key of the Persistent Blob

  • Returns Boolean

    If true the Persistent Blob has been loaded correctly. If false was not loaded correctly

DeletePersistentBlob

procedure DeletePersistentBlob(var BlobKey: BigInteger)

This procedure deletes Persistent Blob.

Parameters / Return Value

  • BlobKey BigInteger

    “BlobKey” contains the key of the Persistent Blob

DownloadTemplateFileFromRule

procedure DownloadTemplateFileFromRule(var Rule: Record "EOS028 CFG Rule")

This procedure downloads the Persistent Blob in File System from “EOS028 CFG Rule”.

Parameters / Return Value

  • Rule Record "EOS028 CFG Rule"

DownloadTemplateFile

procedure DownloadTemplateFile(BlobKey: BigInteger; FileName: Text): Boolean

This procedure downloads the Persistent Blob in File System.

Parameters / Return Value

  • BlobKey BigInteger

    “BlobKey” contains the key of the Persistent Blob

  • FileName Text

    “FileName” contains the name of the file

  • Returns Boolean


EOS Labs -