Table 18004121 EOS Sim. G/L Entry

Table 18004121 EOS Sim. G/L Entry

LanguageCaption
de-ATSim. Sachposten
de-CHSim. Sachposten
de-DESim. Sachposten
en-USSim. G/L Entry
it-CHMov. C/G sim.
it-ITMov. C/G sim.

Fields

Entry No. (1)

Integer

LanguageCaption
de-ATLfd.-Nr.
de-CHLfd.-Nr.
de-DELfd.-Nr.
en-USEntry No.
it-CHNr. movimento
it-ITNr. movimento

G/L Account No. (3)

Code[20]

TableRelation: "G/L Account"

LanguageCaption
de-ATSachkontonr.
de-CHSachkontonr.
de-DESachkontonr.
en-USG/L Account No.
it-CHNr. conto C/G
it-ITNr. conto C/G

Posting Date (4)

Date

LanguageCaption
de-ATBuchungsdatum
de-CHBuchungsdatum
de-DEBuchungsdatum
en-USPosting Date
it-CHData di registrazione
it-ITData di registrazione

Document Type (5)

Enum "Gen. Journal Document Type"

LanguageCaption
de-ATBelegart
de-CHBelegart
de-DEBelegart
en-USDocument Type
it-CHTipo documento
it-ITTipo documento

Document No. (6)

Code[20]

LanguageCaption
de-ATBelegnr.
de-CHBelegnr.
de-DEBelegnr.
en-USDocument No.
it-CHNr. documento
it-ITNr. documento

Description (7)

Text[100]

LanguageCaption
de-ATBeschreibung
de-CHBeschreibung
de-DEBeschreibung
en-USDescription
it-CHDescrizione
it-ITDescrizione

Amount (17)

Decimal

LanguageCaption
de-ATBetrag
de-CHBetrag
de-DEBetrag
en-USAmount
it-CHImporto
it-ITImporto

Global Dimension 1 Code (23)

Code[20]

TableRelation: "Dimension Value".Code WHERE("Global Dimension No." = CONST(1))

LanguageCaption
de-ATGlobaler Dimensionscode 1
de-CHGlobaler Dimensionscode 1
de-DEGlobaler Dimensionscode 1
en-USGlobal Dimension 1 Code
it-CHCod. dimens. globale 1
it-ITCod. dimens. globale 1

Global Dimension 2 Code (24)

Code[20]

TableRelation: "Dimension Value".Code WHERE("Global Dimension No." = CONST(2))

LanguageCaption
de-ATGlobaler Dimensionscode 2
de-CHGlobaler Dimensionscode 2
de-DEGlobaler Dimensionscode 2
en-USGlobal Dimension 2 Code
it-CHCod. dimens. globale 2
it-ITCod. dimens. globale 2

User ID (27)

Code[50]

TableRelation: User."User Name"

LanguageCaption
de-ATBenutzer-ID
de-CHBenutzer-ID
de-DEBenutzer-ID
en-USUser ID
it-CHID utente
it-ITID utente

Source Code (28)

Code[10]

TableRelation: "Source Code"

LanguageCaption
de-ATHerkunftscode
de-CHHerkunftscode
de-DEHerkunftscode
en-USSource Code
it-CHCodice origine
it-ITCodice origine

System-Created Entry (29)

Boolean

LanguageCaption
de-ATSystembuchung
de-CHSystembuchung
de-DESystembuchung
en-USSystem-Created Entry
it-CHMov. aut. di sistema
it-ITMov. aut. di sistema

Journal Line No. (39)

Integer

LanguageCaption
de-ATBuch.-Blattzeilennr.
de-CHBuch.-Blattzeilennr.
de-DEBuch.-Blattzeilennr.
en-USJournal Line No.
it-CHNr. riga registrazioni
it-ITNr. riga registrazioni

Quantity (42)

Decimal

LanguageCaption
de-ATMenge
de-CHMenge
de-DEMenge
en-USQuantity
it-CHQuantità
it-ITQuantità

Journal Template Name (44)

Code[10]

TableRelation: "Gen. Journal Template"

LanguageCaption
de-ATBuch.-Blattvorlagenname
de-CHBuch.-Blattvorlagenname
de-DEBuch.-Blattvorlagenname
en-USJournal Template Name
it-CHNome def. registrazioni
it-ITNome def. registrazioni

Business Unit Code (45)

Code[20]

TableRelation: "Business Unit"

LanguageCaption
de-ATKonzernmandantencode
de-CHKonzernmandantencode
de-DEKonzernmandantencode
en-USBusiness Unit Code
it-CHCod. business unit
it-ITCod. business unit

Journal Batch Name (46)

Code[10]

LanguageCaption
de-ATBuch.-Blattname
de-CHBuch.-Blattname
de-DEBuch.-Blattname
en-USJournal Batch Name
it-CHNome batch contabile
it-ITNome batch contabile

Reason Code (47)

Code[10]

TableRelation: "Reason Code"

LanguageCaption
de-ATUrsachencode
de-CHUrsachencode
de-DEUrsachencode
en-USReason Code
it-CHCausale
it-ITCausale

Gen. Bus. Posting Group (49)

Code[20]

TableRelation: "Gen. Business Posting Group"

LanguageCaption
de-ATGeschäftsbuchungsgruppe
de-CHGeschäftsbuchungsgruppe
de-DEGeschäftsbuchungsgruppe
en-USGen. Bus. Posting Group
it-CHCat. reg. business
it-ITCat. reg. business

Gen. Prod. Posting Group (50)

Code[20]

TableRelation: "Gen. Product Posting Group"

LanguageCaption
de-ATProduktbuchungsgruppe
de-CHProduktbuchungsgruppe
de-DEProduktbuchungsgruppe
en-USGen. Prod. Posting Group
it-CHCat. reg. articolo/servizio
it-ITCat. reg. articolo/servizio

Debit Amount (53)

Decimal

LanguageCaption
de-ATSollbetrag
de-CHSollbetrag
de-DESollbetrag
en-USDebit Amount
it-CHDare
it-ITDare

Credit Amount (54)

Decimal

LanguageCaption
de-ATHabenbetrag
de-CHHabenbetrag
de-DEHabenbetrag
en-USCredit Amount
it-CHAvere
it-ITAvere

Document Date (55)

Date

LanguageCaption
de-ATBelegdatum
de-CHBelegdatum
de-DEBelegdatum
en-USDocument Date
it-CHData documento
it-ITData documento

External Document No. (56)

Code[35]

LanguageCaption
de-ATExterne Belegnummer
de-CHExterne Belegnummer
de-DEExterne Belegnummer
en-USExternal Document No.
it-CHNr. documento esterno
it-ITNr. documento esterno

Source Type (57)

Option

" " (0) , Customer (1) , Vendor (2) , "Bank Account" (3) , "Fixed Asset" (4) , Employee (5)

LanguageCaption

Source No. (58)

Code[20]

TableRelation: IF ("Source Type v2" = CONST(Customer)) Customer ELSE IF ("Source Type v2" = CONST(Vendor)) Vendor ELSE IF ("Source Type v2" = CONST("Bank Account")) "Bank Account" ELSE IF ("Source Type v2" = CONST("Fixed Asset")) "Fixed Asset" ELSE IF ("Source Type v2" = CONST(Employee)) Employee

LanguageCaption
de-ATHerkunftsnr.
de-CHHerkunftsnr.
de-DEHerkunftsnr.
en-USSource No.
it-CHNr. origine
it-ITNr. origine

Source Type v2 (59)

Enum "Gen. Journal Source Type"

LanguageCaption
de-ATHerkunftsart
de-CHHerkunftsart
de-DEHerkunftsart
en-USSource Type
it-CHTipo origine
it-ITTipo origine

Reversed (73)

Boolean

LanguageCaption
de-ATStorniert
de-CHStorniert
de-DEStorniert
en-USReversed
it-CHStornato
it-ITStornato

Reversed by Entry No. (74)

Integer

TableRelation: "EOS Sim. G/L Entry"

LanguageCaption
de-ATStorniert durch Lfd. Nr.
de-CHStorniert durch Lfd. Nr.
de-DEStorniert durch Lfd. Nr.
en-USReversed by Entry No.
it-CHStornato da nr. movimento
it-ITStornato da nr. movimento

Reversed Entry No. (75)

Integer

TableRelation: "EOS Sim. G/L Entry"

LanguageCaption
de-ATStornierter Posten Lfd. Nr.
de-CHStornierter Posten Lfd. Nr.
de-DEStornierter Posten Lfd. Nr.
en-USReversed Entry No.
it-CHNr. movimento stornato
it-ITNr. movimento stornato

G/L Account Name (76)

Text[100]

FieldClass: FlowField

CalcFormula: Lookup("G/L Account".Name WHERE("No." = FIELD("G/L Account No.")))

LanguageCaption
de-ATSachkontoname
de-CHSachkontoname
de-DESachkontoname
en-USG/L Account Name
it-CHNome conto C/G
it-ITNome conto C/G

Dimension Set ID (480)

Integer

LanguageCaption
de-ATDimensionssatz-ID
de-CHDimensionssatz-ID
de-DEDimensionssatz-ID
en-USDimension Set ID
it-CHID set di dimensioni
it-ITID set di dimensioni

Shortcut Dimension 3 Code (481)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(3)))

LanguageCaption
de-ATCode der Tastenkombination “Dimension 3”
de-CHCode der Tastenkombination “Dimension 3”
de-DECode der Tastenkombination “Dimension 3”
en-USShortcut Dimension 3 Code
it-CHCodice Collegamento Dimensione 3
it-ITCodice Collegamento Dimensione 3

Shortcut Dimension 4 Code (482)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(4)))

LanguageCaption
de-ATShortcut-Dimension 4-Code
de-CHShortcut-Dimension 4-Code
de-DEShortcut-Dimension 4-Code
en-USShortcut Dimension 4 Code
it-CHCodice Collegamento Dimensione 4
it-ITCodice Collegamento Dimensione 4

Shortcut Dimension 5 Code (483)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(5)))

LanguageCaption
de-ATCode der Tastenkombination “Dimension 5”
de-CHCode der Tastenkombination “Dimension 5”
de-DECode der Tastenkombination “Dimension 5”
en-USShortcut Dimension 5 Code
it-CHCodice Collegamento Dimensione 5
it-ITCodice Collegamento Dimensione 5

Shortcut Dimension 6 Code (484)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(6)))

LanguageCaption
de-ATCode der Tastenkombination “Dimension 6”
de-CHCode der Tastenkombination “Dimension 6”
de-DECode der Tastenkombination “Dimension 6”
en-USShortcut Dimension 6 Code
it-CHCodice Collegamento Dimensione 6
it-ITCodice Collegamento Dimensione 6

Shortcut Dimension 7 Code (485)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(7)))

LanguageCaption
de-ATCode der Tastenkombination “Dimension 7”
de-CHCode der Tastenkombination “Dimension 7”
de-DECode der Tastenkombination “Dimension 7”
en-USShortcut Dimension 7 Code
it-CHCodice Collegamento Dimensione 7
it-ITCodice Collegamento Dimensione 7

Shortcut Dimension 8 Code (486)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(8)))

LanguageCaption
de-ATCode für die Tastenkombination “Dimension 8”
de-CHCode für die Tastenkombination “Dimension 8”
de-DECode für die Tastenkombination “Dimension 8”
en-USShortcut Dimension 8 Code
it-CHCodice Collegamento Dimensione 8
it-ITCodice Collegamento Dimensione 8

EOS Entry Type (18004105)

Option

Opening (1) , Closure (2)

LanguageCaption
de-ATPostenart
de-CHPostenart
de-DEPostenart
en-USEntry Type
it-CHTipo movimento
it-ITTipo movimento

Creation Date/Time (18004121)

DateTime

LanguageCaption
de-ATErstellungsdatum/-uhrzeit
de-CHErstellungsdatum/-uhrzeit
de-DEErstellungsdatum/-uhrzeit
en-USCreation Date/Time
it-CHData/ora creazione
it-ITData/ora creazione

EOS Calc. G/L Accruals (18004122)

Boolean

LanguageCaption

Accrual Template (18004123)

Code[20]

TableRelation: "EOS G/L Accrual Template".Code

LanguageCaption
de-ATAbgrenzungstemplate
de-CHAbgrenzungstemplate
de-DEAbgrenzungstemplate
en-USAccrual Template
it-CHTemplate ratei/risconti
it-ITTemplate ratei/risconti

Accrued By Entry No. (18004124)

Integer

TableRelation: "EOS G/L Accrual Entry"."Entry No."

LanguageCaption
de-ATAbgegrenzt durch Lfd.-Nr.
de-CHAbgegrenzt durch Lfd.-Nr.
de-DEAbgegrenzt durch Lfd.-Nr.
en-USAccrued By Entry No.
it-CHRateizzato da nr. mov.
it-ITRateizzato da nr. mov.

Accrual Starting Date (18004125)

Date

LanguageCaption
de-ATAbgrenzungsstartdatum
de-CHAbgrenzungsstartdatum
de-DEAbgrenzungsstartdatum
en-USAccrual Starting Date
it-CHData inizio competenza
it-ITData inizio competenza

Accrual Ending Date (18004126)

Date

LanguageCaption
de-ATAbgrenzungsenddatum
de-CHAbgrenzungsenddatum
de-DEAbgrenzungsenddatum
en-USAccrual Ending Date
it-CHData fine competenza
it-ITData fine competenza

Accrual Period (18004127)

Enum "EOS Accrual Period Type"

LanguageCaption
de-ATAbgrenzungsperiode
de-CHAbgrenzungsperiode
de-DEAbgrenzungsperiode
en-USAccrual Period
it-CHPeriodo competenza
it-ITPeriodo competenza

Accrual Entry No. (18004128)

Integer

LanguageCaption
de-ATAbgrenzungspostennr.
de-CHAbgrenzungspostennr.
de-DEAbgrenzungspostennr.
en-USAccrual Entry No.
it-CHNr. mov. ratei/risconti
it-ITNr. mov. ratei/risconti

Accrual Period No. (18004129)

Integer

LanguageCaption
de-ATAbgrenzungsperiodennr.
de-CHAbgrenzungsperiodennr.
de-DEAbgrenzungsperiodennr.
en-USAccrual Period No.
it-CHNr. periodo competenza
it-ITNr. periodo competenza

Accrual Document Type (18004130)

Integer

LanguageCaption

Accrual Document No. (18004131)

Code[20]

LanguageCaption

Accrual Document Line No. (18004132)

Integer

LanguageCaption

Balance in Simulation (18004135)

Boolean

LanguageCaption
de-ATIn Simulation Ausgleichen
de-CHIn Simulation Ausgleichen
de-DEIn Simulation Ausgleichen
en-USBalance in Simulation
it-CHBilancia in simulazione
it-ITBilancia in simulazione

DTI Settlement ID (18004137)

Guid

LanguageCaption
de-ATZFB Abrechnungs-ID
de-CHZFB Abrechnungs-ID
de-DEZFB Abrechnungs-ID
en-USDTI Settlement ID
it-CHID liquidazione DDF
it-ITID liquidazione DDF

Methods

ShowDimensions

procedure ShowDimensions()

CopyFromGenJnlLine

procedure CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")

Parameters / Return Value

  • GenJnlLine Record "Gen. Journal Line"

CopyFromGlEntry

procedure CopyFromGlEntry(GlEntry: Record "G/L Entry")

Parameters / Return Value

  • GlEntry Record "G/L Entry"

CopyToGlEntry

procedure CopyToGlEntry(var GlEntry: Record "G/L Entry")

Parameters / Return Value

  • GlEntry Record "G/L Entry"

GetLastEntryNo

procedure GetLastEntryNo(): Integer

Parameters / Return Value

  • Returns Integer

GetSourceName

procedure GetSourceName(): Text

Retrieve the source name for the current record.

Parameters / Return Value

  • Returns Text[]

    The source name.

Events

OnAfterCopySimGLEntryFromGenJnlLine

local procedure OnAfterCopySimGLEntryFromGenJnlLine(var SimGLEntry: Record "EOS Sim. G/L Entry";var GenJournalLine: Record "Gen. Journal Line")

Parameters / Return Value

  • SimGLEntry Record "EOS Sim. G/L Entry"

  • GenJournalLine Record "Gen. Journal Line"

OnBeforeGetSourceName

local procedure OnBeforeGetSourceName(Rec: Record "EOS Sim. G/L Entry"; var SourceName: Text; var Handled: Boolean)

Raised before the source name for this entry is retrieved. Use this to override default behavior.

Parameters / Return Value

  • Rec Record "EOS Sim. G/L Entry"

    The source entry.

  • SourceName Text[]

    The source name to be returned.

  • Handled Boolean

    Gets or sets if this event has been completely handled.


EOS Labs -