Table 18008311 EOS Comm. Doc. Ledger Entry

Table 18008311 EOS Comm. Doc. Ledger Entry

Ledger table, contains all posted commission entries

Language	Caption
da-DK	Kommissionens indtræden
de-AT	Kommissionsdokument-Ledgereintrag
de-CH	Kommissionsdokument-Ledgereintrag
de-DE	Kommissionsdokument-Ledgereintrag
es-ES	Entrada de la Comisión
es-MX	Entrada de la Comisión
fi-FI	Komission tulo
fr-BE	Entrée à la Commission
fr-CA	Entrée à la Commission
fr-CH	Entrée à la Commission
fr-FR	Entrée à la Commission
en-US	Commission Entry
it-CH	Movimenti provvigione
it-IT	Movimenti provvigione
nb-NO	Provisjon oppføring
nl-BE	Binnenkomst van de Commissie
nl-NL	Binnenkomst van de Commissie
sv-SE	Kommissionens inträde

Fields

Entry No. (`1`)

Integer

Language	Caption
da-DK	Indgangsnr.
de-AT	Lfd. Nr.
de-CH	Lfd. Nr.
de-DE	Lfd. Nr.
es-ES	Entrada No.
es-MX	Entrada No.
fi-FI	Tapahtuman nro
fr-BE	Numéro d’entrée
fr-CA	Numéro d’entrée
fr-CH	Numéro d’entrée
fr-FR	Numéro d’entrée
en-US	Entry No.
it-CH	Nr. movimento
it-IT	Nr. movimento
nb-NO	Postnr.
nl-BE	Ingang nr.
nl-NL	Ingang nr.
sv-SE	Inmatningsnr

Table ID (`10`)

Integer

TableRelation: AllObj."Object ID" WHERE("Object Type" = CONST(Table))

Language	Caption
da-DK	Tabel-id
de-AT	Tabellen-ID
de-CH	Tabellen-ID
de-DE	Tabellen-ID
es-ES	ID de tabla
es-MX	ID de tabla
fi-FI	Taulun tunnus
fr-BE	Table ID
fr-CA	Table ID
fr-CH	Table ID
fr-FR	Table ID
en-US	Table ID
it-CH	ID tabella
it-IT	ID tabella
nb-NO	Tabell-ID
nl-BE	Tabel-id
nl-NL	Tabel-id
sv-SE	Tabell-ID

Sales Document Type (`15`)

Option

"0" (0) , "1" (1) , "2" (2) , "3" (3) , "4" (4) , "5" (5) , "6" (6) , "7" (7) , "8" (8) , "9" (9) , "10" (10) , "11" (11) , "12" (12) , "13" (13) , "14" (14) , "15" (15) , "16" (16) , "17" (17) , "18" (18) , "19" (19) , "20" (20)

Language	Caption
da-DK	Salgsdokumenttype
de-AT	Verkaufsbelegtyp
de-CH	Verkaufsbelegtyp
de-DE	Verkaufsbelegtyp
es-ES	Tipo de documento de ventas
es-MX	Tipo de documento de ventas
fi-FI	Myyntiasiakirjan tyyppi
fr-BE	Type de document de vente
fr-CA	Type de document de vente
fr-CH	Type de document de vente
fr-FR	Type de document de vente
en-US	Sales Document Type
it-CH	Tipo di documento di vendita
it-IT	Tipo di documento di vendita
nb-NO	Type salgsdokument
nl-BE	Type verkoopdocument
nl-NL	Type verkoopdocument
sv-SE	Typ av försäljningsdokument

Document No. (`20`)

Code[20]

Language	Caption
da-DK	Bilagsnr.
de-AT	Belegnr.
de-CH	Belegnr.
de-DE	Belegnr.
es-ES	Documento No.
es-MX	Documento No.
fi-FI	Asiakirjan nro
fr-BE	Numéro du document
fr-CA	Numéro du document
fr-CH	Numéro du document
fr-FR	Numéro du document
en-US	Document No.
it-CH	Nr. documento
it-IT	Nr. documento
nb-NO	Bilagsnr.
nl-BE	Document nr.
nl-NL	Document nr.
sv-SE	Dokumentnr

Document Line No. (`25`)

Integer

Language	Caption
da-DK	Bilagslinjenr.
de-AT	Belegnr.
de-CH	Belegnr.
de-DE	Belegnr.
es-ES	Línea de documento No.
es-MX	Línea de documento No.
fi-FI	Asiakirjan rivin nro
fr-BE	Numéro de la ligne de document
fr-CA	Numéro de la ligne de document
fr-CH	Numéro de la ligne de document
fr-FR	Numéro de la ligne de document
en-US	Document Line No.
it-CH	Nr. riga documento
it-IT	Nr. riga documento
nb-NO	Bilagslinjenr.
nl-BE	Documentregel nr.
nl-NL	Documentregel nr.
sv-SE	Dokumentradnr

Salesperson Role (`30`)

Code[10]

TableRelation: "EOS Salesperson Role"

Language	Caption
da-DK	Rollen Sælger
de-AT	Verkäuferrolle
de-CH	Verkäuferrolle
de-DE	Verkäuferrolle
es-ES	Rol de vendedor
es-MX	Rol de vendedor
fi-FI	Myyjän rooli
fr-BE	Rôle du vendeur
fr-CA	Rôle du vendeur
fr-CH	Rôle du vendeur
fr-FR	Rôle du vendeur
en-US	Salesperson Role
it-CH	Ruolo agente
it-IT	Ruolo agente
nb-NO	Selgerrolle
nl-BE	Rol verkoper
nl-NL	Rol verkoper
sv-SE	Rollen säljare

Salesperson (`35`)

Code[20]

TableRelation: "Salesperson/Purchaser"

Language	Caption
da-DK	Sælgerkode
de-AT	Verkäufer code
de-CH	Verkäufer code
de-DE	Verkäufer code
es-ES	Código de vendedor
es-MX	Código de vendedor
fi-FI	Myyjän koodi
fr-BE	Code vendeur
fr-CA	Code vendeur
fr-CH	Code vendeur
fr-FR	Code vendeur
en-US	Salesperson Code
it-CH	Codice agente
it-IT	Codice agente
nb-NO	Selgerkode
nl-BE	Code verkoper
nl-NL	Code verkoper
sv-SE	Säljarkod

Sell-to No. (`50`)

Code[20]

Language	Caption
da-DK	Sælg til nr.
de-AT	Sell-to-Nr.
de-CH	Sell-to-Nr.
de-DE	Sell-to-Nr.
es-ES	Vender a No.
es-MX	Vender a No.
fi-FI	Tilausasiakkaan nro
fr-BE	Vendre-à No.
fr-CA	Vendre-à No.
fr-CH	Vendre-à No.
fr-FR	Vendre-à No.
en-US	Sell-to No.
it-CH	Vendere a - nr.
it-IT	Vendere a - nr.
nb-NO	Salg til Nei.
nl-BE	Sell-to No.
nl-NL	Sell-to No.
sv-SE	Sälj-till-nr.

Sell-to Name (`51`)

Text[100]

Language	Caption
da-DK	Sælg-til-navn
de-AT	Sell-to-Name
de-CH	Sell-to-Name
de-DE	Sell-to-Name
es-ES	Nombre de venta
es-MX	Nombre de venta
fi-FI	Tilausasiakkaan nimi
fr-BE	Nom de vente
fr-CA	Nom de vente
fr-CH	Nom de vente
fr-FR	Nom de vente
en-US	Sell-to Name
it-CH	Vendere a - Nome
it-IT	Vendere a - Nome
nb-NO	Navn på salg til
nl-BE	Verkoop-aan-naam
nl-NL	Verkoop-aan-naam
sv-SE	Säljnamn

Bill-to No. (`52`)

Code[20]

Language	Caption
da-DK	Bill-til-nr.
de-AT	Bill-to-Nr.
de-CH	Bill-to-Nr.
de-DE	Bill-to-Nr.
es-ES	Bill-to No.
es-MX	Bill-to No.
fi-FI	Laskutusasiakkaan nro
fr-BE	Bill-to No.
fr-CA	Bill-to No.
fr-CH	Bill-to No.
fr-FR	Bill-to No.
en-US	Bill-to No.
it-CH	Fatturare a - nr.
it-IT	Fatturare a - nr.
nb-NO	Bill-til-nr.
nl-BE	Bill-to-No.
nl-NL	Bill-to-No.
sv-SE	Bill-till-nr.

Bill-to Name (`53`)

Text[100]

Language	Caption
da-DK	Faktureringsnavn
de-AT	Bill-to-Name
de-CH	Bill-to-Name
de-DE	Bill-to-Name
es-ES	Nombre de facturación
es-MX	Nombre de facturación
fi-FI	Laskutusasiakkaan nimi
fr-BE	Nom de la facture
fr-CA	Nom de la facture
fr-CH	Nom de la facture
fr-FR	Nom de la facture
en-US	Bill-to Name
it-CH	Fatturare a - Nome
it-IT	Fatturare a - Nome
nb-NO	Navn på faktura til
nl-BE	Bill-to-name
nl-NL	Bill-to-name
sv-SE	Faktureringsnamn

Commission Period Code (`60`)

Code[20]

TableRelation: "EOS Commission Period".Code

Language	Caption
da-DK	Kommissionens periodekode
de-AT	Fristkodex der Kommission
de-CH	Fristkodex der Kommission
de-DE	Fristkodex der Kommission
es-ES	Código de período de la Comisión
es-MX	Código de período de la Comisión
fi-FI	Komission kauden koodi
fr-BE	Code de période de la Commission
fr-CA	Code de période de la Commission
fr-CH	Code de période de la Commission
fr-FR	Code de période de la Commission
en-US	Commission Period Code
it-CH	Codice periodo provvigione
it-IT	Codice periodo provvigione
nb-NO	Kode for provisjonsperiode
nl-BE	Verordeningsperiodecode van de Commissie
nl-NL	Verordeningsperiodecode van de Commissie
sv-SE	Kod för kommissionens period

Document Date (`70`)

Date

Language	Caption
da-DK	Bilagsdato
de-AT	Belegdatum
de-CH	Belegdatum
de-DE	Belegdatum
es-ES	Fecha del documento
es-MX	Fecha del documento
fi-FI	Asiakirjan päivämäärä
fr-BE	Document Date
fr-CA	Document Date
fr-CH	Document Date
fr-FR	Document Date
en-US	Document Date
it-CH	Data documento
it-IT	Data documento
nb-NO	Dokumentdato
nl-BE	Documentdatum
nl-NL	Documentdatum
sv-SE	Datum för dokument

Posting Date (`71`)

Date

Language	Caption
da-DK	Bogføringsdato
de-AT	Buchungsdatum
de-CH	Buchungsdatum
de-DE	Buchungsdatum
es-ES	Fecha de contabilización
es-MX	Fecha de contabilización
fi-FI	Kirjauspäivämäärä
fr-BE	Date d’affichage
fr-CA	Date d’affichage
fr-CH	Date d’affichage
fr-FR	Date d’affichage
en-US	Posting Date
it-CH	Data di registrazione
it-IT	Data di registrazione
nb-NO	Bokføringsdato
nl-BE	Boekingsdatum
nl-NL	Boekingsdatum
sv-SE	Bokföringsdatum

Type (`80`)

Option

" " (0) , "G/L Account" (1) , Item (2) , Resource (3) , "Fixed Asset" (4) , "Charge (Item)" (5)

Language	Caption
da-DK	Type
de-AT	Art
de-CH	Art
de-DE	Art
es-ES	Tipo
es-MX	Tipo
fi-FI	Tyyppi
fr-BE	Type
fr-CA	Type
fr-CH	Type
fr-FR	Type
en-US	Type
it-CH	Tipo
it-IT	Tipo
nb-NO	Type
nl-BE	Type
nl-NL	Type
sv-SE	Typ

No. (`81`)

Code[20]

TableRelation: IF (Type = CONST("G/L Account")) "G/L Account" ELSE IF (Type = CONST(Item)) Item ELSE IF (Type = CONST(Resource)) Resource ELSE IF (Type = CONST("Fixed Asset")) "Fixed Asset" ELSE IF (Type = CONST("Charge (Item)")) "Item Charge"

Language	Caption
da-DK	Nej.
de-AT	Nr.
de-CH	Nr.
de-DE	Nr.
es-ES	No.
es-MX	No.
fi-FI	Ei.
fr-BE	non.
fr-CA	non.
fr-CH	non.
fr-FR	non.
en-US	No.
it-CH	Nr.
it-IT	Nr.
nb-NO	nei.
nl-BE	№.
nl-NL	№.
sv-SE	Nej.

Description (`82`)

Text[100]

Language	Caption
da-DK	Beskrivelse
de-AT	Beschreibung
de-CH	Beschreibung
de-DE	Beschreibung
es-ES	Descripción
es-MX	Descripción
fi-FI	Kuvaus
fr-BE	Description
fr-CA	Description
fr-CH	Description
fr-FR	Description
en-US	Description
it-CH	Descrizione
it-IT	Descrizione
nb-NO	Beskrivelse
nl-BE	Beschrijving
nl-NL	Beschrijving
sv-SE	Beskrivning

Quantity (`90`)

Decimal

Language	Caption
da-DK	Mængde
de-AT	Menge
de-CH	Menge
de-DE	Menge
es-ES	Cantidad
es-MX	Cantidad
fi-FI	Määrä
fr-BE	Quantité
fr-CA	Quantité
fr-CH	Quantité
fr-FR	Quantité
en-US	Quantity
it-CH	Quantità
it-IT	Quantità
nb-NO	Antall
nl-BE	Hoeveelheid
nl-NL	Hoeveelheid
sv-SE	Kvantitet

Unit of Measure Code (`91`)

Code[10]

TableRelation: "Unit of Measure"

Language	Caption
da-DK	Enhedskode
de-AT	Einheitencode
de-CH	Einheitencode
de-DE	Einheitencode
es-ES	Código de unidad de medida
es-MX	Código de unidad de medida
fi-FI	Mittayksikön koodi
fr-BE	Code de l’unité de mesure
fr-CA	Code de l’unité de mesure
fr-CH	Code de l’unité de mesure
fr-FR	Code de l’unité de mesure
en-US	Unit of Measure Code
it-CH	Cod. unità di misura
it-IT	Cod. unità di misura
nb-NO	Enhetskode
nl-BE	Eenheid van de meetcode
nl-NL	Eenheid van de meetcode
sv-SE	Kod för måttenhet

Currency Code (`92`)

Code[10]

TableRelation: Currency

Language	Caption
da-DK	Valutakode
de-AT	Währungscode
de-CH	Währungscode
de-DE	Währungscode
es-ES	Código de moneda
es-MX	Código de moneda
fi-FI	Valuutan koodi
fr-BE	Code de change
fr-CA	Code de change
fr-CH	Code de change
fr-FR	Code de change
en-US	Currency Code
it-CH	Cod. valuta
it-IT	Cod. valuta
nb-NO	Valutakoden
nl-BE	Valutacode
nl-NL	Valutacode
sv-SE	Valutakod

Currency Factor (`93`)

Decimal

Language	Caption
da-DK	Valutafaktor
de-AT	Währungsfaktor
de-CH	Währungsfaktor
de-DE	Währungsfaktor
es-ES	Factor de moneda
es-MX	Factor de moneda
fi-FI	Valuuttakerroin
fr-BE	Facteur de change
fr-CA	Facteur de change
fr-CH	Facteur de change
fr-FR	Facteur de change
en-US	Currency Factor
it-CH	Fattore valuta
it-IT	Fattore valuta
nb-NO	Valuta Faktor
nl-BE	Valutafactor
nl-NL	Valutafactor
sv-SE	Valutafaktor

Line Amount (`100`)

Decimal

Language	Caption
da-DK	Linjebeløb
de-AT	Positionsbetrag
de-CH	Positionsbetrag
de-DE	Positionsbetrag
es-ES	Importe de la línea
es-MX	Importe de la línea
fi-FI	Rivin summa
fr-BE	Montant de la ligne
fr-CA	Montant de la ligne
fr-CH	Montant de la ligne
fr-FR	Montant de la ligne
en-US	Line Amount
it-CH	Importo riga
it-IT	Importo riga
nb-NO	Linjebeløp
nl-BE	Regelbedrag
nl-NL	Regelbedrag
sv-SE	Radbelopp

Line Amount (LCY) (`101`)

Decimal

Language	Caption
da-DK	Linjebeløb (RV)
de-AT	Positionsmenge (LCY)
de-CH	Positionsmenge (LCY)
de-DE	Positionsmenge (LCY)
es-ES	Importe de línea (LCY)
es-MX	Importe de línea (LCY)
fi-FI	Rivin summa (PVA)
fr-BE	Montant de la ligne (LCY)
fr-CA	Montant de la ligne (LCY)
fr-CH	Montant de la ligne (LCY)
fr-FR	Montant de la ligne (LCY)
en-US	Line Amount (LCY)
it-CH	Importo riga (VL)
it-IT	Importo riga (VL)
nb-NO	Linjebeløp (NOK)
nl-BE	Regelbedrag (LCY)
nl-NL	Regelbedrag (LCY)
sv-SE	Radbelopp (BVA)

Commission Base Amount (LCY) (`110`)

Decimal

Language	Caption
da-DK	Beregning af basiskommissionen (RV)
de-AT	Berechnung der Basiskommission (LCY)
de-CH	Berechnung der Basiskommission (LCY)
de-DE	Berechnung der Basiskommission (LCY)
es-ES	Cálculo de la Comisión Base (LCY)
es-MX	Cálculo de la Comisión Base (LCY)
fi-FI	Komission peruslaskelma (PVA)
fr-BE	Calcul de la Commission de base (LCY)
fr-CA	Calcul de la Commission de base (LCY)
fr-CH	Calcul de la Commission de base (LCY)
fr-FR	Calcul de la Commission de base (LCY)
en-US	Base Commission Calculation (LCY)
it-CH	Base calcolo provvigione (VL)
it-IT	Base calcolo provvigione (VL)
nb-NO	Beregning av basisprovisjon (NOK)
nl-BE	Berekening van de basiscommissie (LCY)
nl-NL	Berekening van de basiscommissie (LCY)
sv-SE	Beräkning av basen kommissionen (BVA)

Orig. Comm. Base Amount (LCY) (`115`)

Decimal

Language	Caption
da-DK	Beregning af orig. basiskommune (RV)
de-AT	Orig. Basis-Comm.-Berechnung (LCY)
de-CH	Orig. Basis-Comm.-Berechnung (LCY)
de-DE	Orig. Basis-Comm.-Berechnung (LCY)
es-ES	Cálculo de la comunicación base (LCY)
es-MX	Cálculo de la comunicación base (LCY)
fi-FI	Orig. Perusviestinnän laskenta (PVA)
fr-BE	Orig. Base Comm. Calcul (LCY)
fr-CA	Orig. Base Comm. Calcul (LCY)
fr-CH	Orig. Base Comm. Calcul (LCY)
fr-FR	Orig. Base Comm. Calcul (LCY)
en-US	Orig. Base Comm. Calculation (LCY)
it-CH	Base calcolo provv. orig. (VL)
it-IT	Base calcolo provv. orig. (VL)
nb-NO	Orig. Base Comm. Beregning (NOK)
nl-BE	Orig. Basis Comm. Berekening (LCY)
nl-NL	Orig. Basis Comm. Berekening (LCY)
sv-SE	Orig. Bas Comm. Beräkning (BVA)

Reduction % (`117`)

Decimal

Language	Caption
da-DK	Reduktion %
de-AT	Reduktion %
de-CH	Reduktion %
de-DE	Reduktion %
es-ES	Reducción %
es-MX	Reducción %
fi-FI	Vähennys %
fr-BE	Réduction %
fr-CA	Réduction %
fr-CH	Réduction %
fr-FR	Réduction %
en-US	Reduction %
it-CH	Abbattimento %
it-IT	Abbattimento %
nb-NO	Reduksjon %
nl-BE	Verlaging %
nl-NL	Verlaging %
sv-SE	Minskning %

Commission % (`120`)

Decimal

Language	Caption
da-DK	Provision %
de-AT	% Provision für Verkäufer
de-CH	% Provision für Verkäufer
de-DE	% Provision für Verkäufer
es-ES	Comisión %
es-MX	Comisión %
fi-FI	Komissio %
fr-BE	Commission %
fr-CA	Commission %
fr-CH	Commission %
fr-FR	Commission %
en-US	Commission %
it-CH	Provvigione %
it-IT	Provvigione %
nb-NO	Provisjon %
nl-BE	Commissie %
nl-NL	Commissie %
sv-SE	Kommissionen %

Commission % (Amount) (`125`)

Decimal

Language	Caption
da-DK	Provision % (beløb) (RV)
de-AT	Kommission % (Betrag) (LCY)
de-CH	Kommission % (Betrag) (LCY)
de-DE	Kommission % (Betrag) (LCY)
es-ES	% de comisión (importe) (LCY)
es-MX	% de comisión (importe) (LCY)
fi-FI	Provisio % (määrä) (PVA)
fr-BE	Commission % (Montant) (LCY)
fr-CA	Commission % (Montant) (LCY)
fr-CH	Commission % (Montant) (LCY)
fr-FR	Commission % (Montant) (LCY)
en-US	Commission % (Amount) (LCY)
it-CH	% Provvigione (Importo) (VL)
it-IT	% Provvigione (Importo) (VL)
nb-NO	Provisjon % (beløp) (NOK)
nl-BE	Commissie % (bedrag) (LCY)
nl-NL	Commissie % (bedrag) (LCY)
sv-SE	Kommissionen % (belopp) (BVA)

Commission Amount (`130`)

Decimal

Language	Caption
da-DK	Provisionsbeløb (RV)
de-AT	Prov.- Betrag (MW)
de-CH	Prov.- Betrag (MW)
de-DE	Prov.- Betrag (MW)
es-ES	Importe de la comisión (LCY)
es-MX	Importe de la comisión (LCY)
fi-FI	Provisiomäärä (PVA)
fr-BE	Montant de la Commission (LCY)
fr-CA	Montant de la Commission (LCY)
fr-CH	Montant de la Commission (LCY)
fr-FR	Montant de la Commission (LCY)
en-US	Commission Amount (LCY)
it-CH	Importo provvigione (VL)
it-IT	Importo provvigione (VL)
nb-NO	Provisjonsbeløp (NOK)
nl-BE	Commissiebedrag (LCY)
nl-NL	Commissiebedrag (LCY)
sv-SE	Provisionsbelopp (BVA)

Total Commission Amount (`135`)

Decimal

Language	Caption
da-DK	Kommissionens samlede beløb (RV)
de-AT	Provisionsbetrag insgesamt (EL)
de-CH	Provisionsbetrag insgesamt (EL)
de-DE	Provisionsbetrag insgesamt (EL)
es-ES	Importe total de la comisión (LCY)
es-MX	Importe total de la comisión (LCY)
fi-FI	Komission kokonaissumma (PVA)
fr-BE	Montant total de la commission (LCY)
fr-CA	Montant total de la commission (LCY)
fr-CH	Montant total de la commission (LCY)
fr-FR	Montant total de la commission (LCY)
en-US	Total Commission Amount (LCY)
it-CH	Importo totale provvigione (VL)
it-IT	Importo totale provvigione (VL)
nb-NO	Totalt provisjonsbeløp (NOK)
nl-BE	Totaal bedrag van de Commissie (LCY)
nl-NL	Totaal bedrag van de Commissie (LCY)
sv-SE	Totalt provisionsbelopp (BVA)

Modified (`140`)

Boolean

Language	Caption
da-DK	Ændret
de-AT	Geändert
de-CH	Geändert
de-DE	Geändert
es-ES	Modificado
es-MX	Modificado
fi-FI	Muutettu
fr-BE	Modifié
fr-CA	Modifié
fr-CH	Modifié
fr-FR	Modifié
en-US	Modified
it-CH	Modificato
it-IT	Modificato
nb-NO	Endret
nl-BE	Bewerkt
nl-NL	Bewerkt
sv-SE	Ändrade

Cashed % (`145`)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Detail Comm. Ledger Entry"."Cashed %" where( "Document Ledger Entry No." = field("Entry No."), "Entry Type" = const(Payable), Exclude = const(false), "Posting Date" = FIELD("Date Filter") ))

Language	Caption
da-DK	Indløst %
de-AT	Eingelöste %
de-CH	Eingelöste %
de-DE	Eingelöste %
es-ES	% cobrado
es-MX	% cobrado
fi-FI	Lunastettu %
fr-BE	% encaissé
fr-CA	% encaissé
fr-CH	% encaissé
fr-FR	% encaissé
en-US	Cashed %
it-CH	% incassata
it-IT	% incassata
nb-NO	Innløst %
nl-BE	Geïnd %
nl-NL	Geïnd %
sv-SE	Inkasserad %

Payable (LCY) (`149`)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Detail Comm. Ledger Entry"."Commission Amount (LCY)" where( "Document Ledger Entry No." = field("Entry No."), "Entry Type" = const(Payable), Exclude = const(false), "Posting Date" = field("Date Filter") ))

Language	Caption
da-DK	Skal betales (RV)
de-AT	Zahlbar (LCY)
de-CH	Zahlbar (LCY)
de-DE	Zahlbar (LCY)
es-ES	A pagar (LCY)
es-MX	A pagar (LCY)
fi-FI	Maksettava (PVA)
fr-BE	Payable (LCY)
fr-CA	Payable (LCY)
fr-CH	Payable (LCY)
fr-FR	Payable (LCY)
en-US	Payable (LCY)
it-CH	Importo da liquidare (VL)
it-IT	Importo da liquidare (VL)
nb-NO	Betalbar (NOK)
nl-BE	Betaalbaar (LCY)
nl-NL	Betaalbaar (LCY)
sv-SE	Leverantörsskuld (BVA)

Settlement Amount (LCY) (`150`)

Decimal

FieldClass: FlowField

CalcFormula: - Sum("EOS Detail Comm. Ledger Entry"."Commission Amount (LCY)" where( "Document Ledger Entry No." = field("Entry No."), "Entry Type" = const(Settlement), Exclude = const(false), "Posting Date" = field("Date Filter"), "Prospect No." = field("Prospect No. Filter"), "Prospect Line No." = field("Prospect Line No. Filter")))

Language	Caption
da-DK	Udligningsbeløb (RV)
de-AT	Ausgleichsbetrag (LCY)
de-CH	Ausgleichsbetrag (LCY)
de-DE	Ausgleichsbetrag (LCY)
es-ES	Importe de liquidación (LCY)
es-MX	Importe de liquidación (LCY)
fi-FI	Tilityssumma (PVA)
fr-BE	Montant du règlement (LCY)
fr-CA	Montant du règlement (LCY)
fr-CH	Montant du règlement (LCY)
fr-FR	Montant du règlement (LCY)
en-US	Settlement Amount (LCY)
it-CH	Importo liquidazione (VL)
it-IT	Importo liquidazione (VL)
nb-NO	Utligningsbeløp (NOK)
nl-BE	Vereffeningsbedrag (LCY)
nl-NL	Vereffeningsbedrag (LCY)
sv-SE	Kvittningsbelopp (BVA)

Settled Amount (LCY) (`155`)

Decimal

FieldClass: FlowField

CalcFormula: - sum("EOS Detail Comm. Ledger Entry"."Commission Amount (LCY)" where( "Document Ledger Entry No." = field("Entry No."), Exclude = const(false), "Entry Type" = filter(Settled | "Exchange Rate Difference"), "Posting Date" = field("Date Filter") ))

Language	Caption
da-DK	Udlignet beløb (RV)
de-AT	Ausgeglichener Betrag (LCY)
de-CH	Ausgeglichener Betrag (LCY)
de-DE	Ausgeglichener Betrag (LCY)
es-ES	Importe liquidado (LCY)
es-MX	Importe liquidado (LCY)
fi-FI	Selvitetty summa (PVA)
fr-BE	Montant réglé (LCY)
fr-CA	Montant réglé (LCY)
fr-CH	Montant réglé (LCY)
fr-FR	Montant réglé (LCY)
en-US	Settled Amount (LCY)
it-CH	Importo liquidato (VL)
it-IT	Importo liquidato (VL)
nb-NO	Utlignet beløp (NOK)
nl-BE	Vereenigd bedrag (LCY)
nl-NL	Vereenigd bedrag (LCY)
sv-SE	Kvittade belopp (BVA)

Remaining Amount (LCY) (`160`)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS Detail Comm. Ledger Entry"."Commission Amount (LCY)" where( "Document Ledger Entry No." = field("Entry No."), Exclude = const(false), "Posting Date" = field("Date Filter") ))

Language	Caption
da-DK	Restbeløb (RV)
de-AT	Verbleibender Betrag (LCY)
de-CH	Verbleibender Betrag (LCY)
de-DE	Verbleibender Betrag (LCY)
es-ES	Importe restante (LCY)
es-MX	Importe restante (LCY)
fi-FI	Jäljellä oleva summa (PVA)
fr-BE	Montant restant (LCY)
fr-CA	Montant restant (LCY)
fr-CH	Montant restant (LCY)
fr-FR	Montant restant (LCY)
en-US	Remaining Amount (LCY)
it-CH	Importo residuo (VL)
it-IT	Importo residuo (VL)
nb-NO	Gjenstående beløp (NOK)
nl-BE	Resterende hoeveelheid (LCY)
nl-NL	Resterende hoeveelheid (LCY)
sv-SE	Återstående belopp (BVA)

Dimension Set ID (`170`)

Integer

TableRelation: "Dimension Set Entry"

Language	Caption
da-DK	Id for dimensionssæt
de-AT	Dimensionssatz-ID
de-CH	Dimensionssatz-ID
de-DE	Dimensionssatz-ID
es-ES	ID del conjunto de dimensiones
es-MX	ID del conjunto de dimensiones
fi-FI	Dimensioyhdistelmän tunnus
fr-BE	ID du jeu de dimensions
fr-CA	ID du jeu de dimensions
fr-CH	ID du jeu de dimensions
fr-FR	ID du jeu de dimensions
en-US	Dimension Set ID
it-CH	ID set di dimensioni
it-IT	ID set di dimensioni
nb-NO	Dimensjonssett-ID
nl-BE	Dimensieset-id
nl-NL	Dimensieset-id
sv-SE	Id för dimensionsuppsättning

Product Commission Group Code (`180`)

Code[20]

TableRelation: "EOS Commission Group".Code where("Group Type" = const(Product))

Language	Caption
da-DK	Produktkommissionen Group
de-AT	Produktkommissionsgruppe
de-CH	Produktkommissionsgruppe
de-DE	Produktkommissionsgruppe
es-ES	Grupo de la Comisión de Productos
es-MX	Grupo de la Comisión de Productos
fi-FI	Tuoteprovisioryhmä
fr-BE	Groupe commission produit
fr-CA	Groupe commission produit
fr-CH	Groupe commission produit
fr-FR	Groupe commission produit
en-US	Product Commission Group
it-CH	Gruppo provvigionale prodotti
it-IT	Gruppo provvigionale prodotti
nb-NO	Produktkommisjonsgruppe
nl-BE	Productcommissie groep
nl-NL	Productcommissie groep
sv-SE	Provisionsgruppen för produkt

Customer Commission Group Code (`185`)

Code[20]

TableRelation: "EOS Commission Group".Code where("Group Type" = const(Customer))

Language	Caption
da-DK	Kundekommissionsgruppe
de-AT	Customer Commission Group
de-CH	Customer Commission Group
de-DE	Customer Commission Group
es-ES	Grupo de Comisiones de Clientes
es-MX	Grupo de Comisiones de Clientes
fi-FI	Asiakasprovisioon ryhmä
fr-BE	Groupe de la Commission client
fr-CA	Groupe de la Commission client
fr-CH	Groupe de la Commission client
fr-FR	Groupe de la Commission client
en-US	Customer Commission Group
it-CH	Gruppo provvigionale clienti
it-IT	Gruppo provvigionale clienti
nb-NO	Kundekommisjonsgruppe
nl-BE	Groep klantencommissie
nl-NL	Groep klantencommissie
sv-SE	Kundprovisionsgruppen

Reason Code (`190`)

Code[10]

TableRelation: "EOS Commission Reason Code".Code

Language	Caption
da-DK	Årsagskode
de-AT	Ursachencode
de-CH	Ursachencode
de-DE	Ursachencode
es-ES	Código de razón
es-MX	Código de razón
fi-FI	Syy-koodi
fr-BE	Code de raison
fr-CA	Code de raison
fr-CH	Code de raison
fr-FR	Code de raison
en-US	Reason Code
it-CH	Codice causale
it-IT	Codice causale
nb-NO	Årsakskode
nl-BE	Redencode
nl-NL	Redencode
sv-SE	Orsakskod

Source Code (`200`)

Code[10]

TableRelation: "Source Code"

Language	Caption
da-DK	Kildekode
de-AT	Quellcode
de-CH	Quellcode
de-DE	Quellcode
es-ES	Código fuente
es-MX	Código fuente
fi-FI	Lähdekoodi
fr-BE	Source Code
fr-CA	Source Code
fr-CH	Source Code
fr-FR	Source Code
en-US	Source Code
it-CH	Codice origine
it-IT	Codice origine
nb-NO	Kildekoden
nl-BE	Broncode
nl-NL	Broncode
sv-SE	Källkod

Batch Name (`205`)

Code[10]

Language	Caption
da-DK	Batchnavn
de-AT	Batchname
de-CH	Batchname
de-DE	Batchname
es-ES	Nombre del lote
es-MX	Nombre del lote
fi-FI	Erän nimi
fr-BE	Nom du lot
fr-CA	Nom du lot
fr-CH	Nom du lot
fr-FR	Nom du lot
en-US	Batch Name
it-CH	Nome batch
it-IT	Nome batch
nb-NO	Bunkenavn
nl-BE	Batchnaam
nl-NL	Batchnaam
sv-SE	Batchnamn

Settlement Type (`210`)

Option

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Settlement Type" where(Code = field(Salesperson)))

" " (0) , Invoiced (1) , "Paid (Partially)" (2) , "Paid (Completely)" (3) , "Paid (Document)" (4)

Language	Caption
da-DK	Afregningstype
de-AT	Abrechnungstyp
de-CH	Abrechnungstyp
de-DE	Abrechnungstyp
es-ES	Tipo de liquidación
es-MX	Tipo de liquidación
fi-FI	Tilitystyyppi
fr-BE	Type de règlement
fr-CA	Type de règlement
fr-CH	Type de règlement
fr-FR	Type de règlement
en-US	Settlement Type
it-CH	Tipo di liquidazione
it-IT	Tipo di liquidazione
nb-NO	Utligningstype
nl-BE	Vereffeningstype
nl-NL	Vereffeningstype
sv-SE	Kvittningstyp

Commission On Invoice Disc. (`215`)

Boolean

Language	Caption
da-DK	Kommissionen på fakturadisk.
de-AT	Kommission auf Rechnungsscheibe.
de-CH	Kommission auf Rechnungsscheibe.
de-DE	Kommission auf Rechnungsscheibe.
es-ES	Comisión en el disco de factura.
es-MX	Comisión en el disco de factura.
fi-FI	Komissio laskualennuslaskussa
fr-BE	commission sur le disque de facture.
fr-CA	commission sur le disque de facture.
fr-CH	commission sur le disque de facture.
fr-FR	commission sur le disque de facture.
en-US	Commission On Invoice Disc.
it-CH	Importo base include sconto fattura
it-IT	Importo base include sconto fattura
nb-NO	Provisjon på fakturarabatt.
nl-BE	commissie op factuurschijf.
nl-NL	commissie op factuurschijf.
sv-SE	Provision på fakturaskiva.

Commission On Line Disc. (`220`)

Boolean

Language	Caption
da-DK	Kommissionen on line disc.
de-AT	Kommission on Line Disc.
de-CH	Kommission on Line Disc.
de-DE	Kommission on Line Disc.
es-ES	Comisión en el disco de línea.
es-MX	Comisión en el disco de línea.
fi-FI	Komissio on Line Disc.
fr-BE	Commission On Line Disc.
fr-CA	Commission On Line Disc.
fr-CH	Commission On Line Disc.
fr-FR	Commission On Line Disc.
en-US	Commission On Line Disc.
it-CH	Importo base include sconto riga
it-IT	Importo base include sconto riga
nb-NO	provisjon på linjedisk.
nl-BE	Commissie on-line schijf.
nl-NL	Commissie on-line schijf.
sv-SE	Provision on line skiva.

Exclude (`225`)

Boolean

Language	Caption
da-DK	Udelukke
de-AT	Ausschließen
de-CH	Ausschließen
de-DE	Ausschließen
es-ES	Excluir
es-MX	Excluir
fi-FI	Jättää
fr-BE	Exclure
fr-CA	Exclure
fr-CH	Exclure
fr-FR	Exclure
en-US	Exclude
it-CH	Escludi
it-IT	Escludi
nb-NO	Utelate
nl-BE	Uitsluiten
nl-NL	Uitsluiten
sv-SE	Utesluta

From Calc. Setup Line (`250`)

RecordID

Language	Caption
da-DK	Fra beregningslinje
de-AT	Von Calc. Setup-Zeile
de-CH	Von Calc. Setup-Zeile
de-DE	Von Calc. Setup-Zeile
es-ES	Desde la línea de configuración de Calc.
es-MX	Desde la línea de configuración de Calc.
fi-FI	Laske -asetusriviltä
fr-BE	À partir de Calc. Setup Line
fr-CA	À partir de Calc. Setup Line
fr-CH	À partir de Calc. Setup Line
fr-FR	À partir de Calc. Setup Line
en-US	From Calc. Setup Line
it-CH	Da riga di setup calcolo
it-IT	Da riga di setup calcolo
nb-NO	Fra beregn oppsettslinje
nl-BE	Van Calc. Setup Line
nl-NL	Van Calc. Setup Line
sv-SE	Från Calc. Setup Line

Orig. Commission % (`300`)

Decimal

Language	Caption
da-DK	Orig. Kommissionen %
de-AT	Orig. Kommission %
de-CH	Orig. Kommission %
de-DE	Orig. Kommission %
es-ES	Comisión Orig. %
es-MX	Comisión Orig. %
fi-FI	Orig. Komissio %
fr-BE	Orig. Commission %
fr-CA	Orig. Commission %
fr-CH	Orig. Commission %
fr-FR	Orig. Commission %
en-US	Orig. Commission %
it-CH	% Provvigione orig.
it-IT	% Provvigione orig.
nb-NO	Orig. Kommisjon %
nl-BE	Orig. Commissie %
nl-NL	Orig. Commissie %
sv-SE	Orig. Kommissionen %

Orig. Commission Amnt. (`310`)

Decimal

Language	Caption
da-DK	Orig. Provisionsbeløb
de-AT	Orig. Kommissionsbetrag
de-CH	Orig. Kommissionsbetrag
de-DE	Orig. Kommissionsbetrag
es-ES	Importe de la Comisión Orig.
es-MX	Importe de la Comisión Orig.
fi-FI	Orig. Komission määrä
fr-BE	Orig. Montant de la Commission
fr-CA	Orig. Montant de la Commission
fr-CH	Orig. Montant de la Commission
fr-FR	Orig. Montant de la Commission
en-US	Orig. Commission Amount
it-CH	Importo provvigione orig.
it-IT	Importo provvigione orig.
nb-NO	Orig. Provisjonsbeløp
nl-BE	Orig. Commissiebedrag
nl-NL	Orig. Commissiebedrag
sv-SE	Belopp för kommissionen

Open (`320`)

Boolean

Language	Caption
da-DK	Åbne
de-AT	Öffnen
de-CH	Öffnen
de-DE	Öffnen
es-ES	Abierto
es-MX	Abierto
fi-FI	Avaa
fr-BE	Ouvert
fr-CA	Ouvert
fr-CH	Ouvert
fr-FR	Ouvert
en-US	Open
it-CH	Aperto
it-IT	Aperto
nb-NO	Åpne
nl-BE	Open
nl-NL	Open
sv-SE	Öppna

Date Filter (`400`)

Date

FieldClass: FlowFilter

Language	Caption
da-DK	Datofilter
de-AT	Datumsfilter
de-CH	Datumsfilter
de-DE	Datumsfilter
es-ES	Filtro de fecha
es-MX	Filtro de fecha
fi-FI	Päivämäärä suodatin
fr-BE	Filtre de date
fr-CA	Filtre de date
fr-CH	Filtre de date
fr-FR	Filtre de date
en-US	Date Filter
it-CH	Filtro data
it-IT	Filtro data
nb-NO	Dato filter
nl-BE	Datumfilter
nl-NL	Datumfilter
sv-SE	Datumfilter

Prospect No. Filter (`401`)

code[20]

FieldClass: FlowFilter

Language	Caption
da-DK	Kundeemnenr. Filter
de-AT	Prospect No. Filter
de-CH	Prospect No. Filter
de-DE	Prospect No. Filter
es-ES	Prospecto No. Filtro
es-MX	Prospecto No. Filtro
fi-FI	Prospektin nro Suodatin
fr-BE	Perspective No. Filtre
fr-CA	Perspective No. Filtre
fr-CH	Perspective No. Filtre
fr-FR	Perspective No. Filtre
en-US	Prospect No. Filter
it-CH	Filtro Nr. prospetto
it-IT	Filtro Nr. prospetto
nb-NO	Prospekt nr. Filter
nl-BE	Prospectnr. Filter
nl-NL	Prospectnr. Filter
sv-SE	Prospekt nr. Filter

Prospect Line No. Filter (`402`)

Integer

FieldClass: FlowFilter

Language	Caption
da-DK	Linjen Kundeemnelinjenr. Filter
de-AT	Prospect Line Nr. Filter
de-CH	Prospect Line Nr. Filter
de-DE	Prospect Line Nr. Filter
es-ES	Línea prospectiva No. Filtro
es-MX	Línea prospectiva No. Filtro
fi-FI	Prospektirivin nro Suodatin
fr-BE	Ligne prospect no. Filtre
fr-CA	Ligne prospect no. Filtre
fr-CH	Ligne prospect no. Filtre
fr-FR	Ligne prospect no. Filtre
en-US	Prospect Line No. Filter
it-CH	Filtro Nr. riga prospetto
it-IT	Filtro Nr. riga prospetto
nb-NO	Linjenr. Filter
nl-BE	Prospect line nr. Filter
nl-NL	Prospect line nr. Filter
sv-SE	Radnr för potentiell kund Filter

Cost All. Register No. (`600`)

Integer

TableRelation: "EOS Comm. Cost All. Register"

Language	Caption
da-DK	Omkostningsfordelingsregisternr.
de-AT	Kostenzuordnungsregister-Nr.
de-CH	Kostenzuordnungsregister-Nr.
de-DE	Kostenzuordnungsregister-Nr.
es-ES	Registro de asignación de costos No.
es-MX	Registro de asignación de costos No.
fi-FI	Kustannusten kohdistusrekisterin nro
fr-BE	Numéro du registre d’allocation des coûts
fr-CA	Numéro du registre d’allocation des coûts
fr-CH	Numéro du registre d’allocation des coûts
fr-FR	Numéro du registre d’allocation des coûts
en-US	Cost Allocation Register No.
it-CH	Nr. registro stanziamento costi
it-IT	Nr. registro stanziamento costi
nb-NO	Kostnadsfordelingsregisternr.
nl-BE	Kostentoewijzingsregister nr.
nl-NL	Kostentoewijzingsregister nr.
sv-SE	Registerr för kostnadsallokering

Adv. Referred to Entry No. (`500`)

Integer

TableRelation: "EOS Commission Ledger Entry"

Language	Caption
da-DK	Adv. Henviste til postnr.
de-AT	Adv. Unter Angaben zu Eintrag Nr.
de-CH	Adv. Unter Angaben zu Eintrag Nr.
de-DE	Adv. Unter Angaben zu Eintrag Nr.
es-ES	Adv. Referido a la Entrada No.
es-MX	Adv. Referido a la Entrada No.
fi-FI	Adv. Viitattu tapahtuman nro
fr-BE	Adv. Fait référence à l’entrée no.
fr-CA	Adv. Fait référence à l’entrée no.
fr-CH	Adv. Fait référence à l’entrée no.
fr-FR	Adv. Fait référence à l’entrée no.
en-US	Adv. Referred to Entry No.
it-CH	Anticipo collegato a nr. mov.
it-IT	Anticipo collegato a nr. mov.
nb-NO	Adv. Henvist til oppføring nr.
nl-BE	Adv. Verwees naar Entry No.
nl-NL	Adv. Verwees naar Entry No.
sv-SE	Adv. Hänvisat till postnr

Imported (`800`)

Boolean

Language	Caption
da-DK	Importeret
de-AT	Importiert
de-CH	Importiert
de-DE	Importiert
es-ES	Importados
es-MX	Importados
fi-FI	Tuotu
fr-BE	Importés
fr-CA	Importés
fr-CH	Importés
fr-FR	Importés
en-US	Imported
it-CH	Importato
it-IT	Importato
nb-NO	Importert
nl-BE	Geïmporteerd
nl-NL	Geïmporteerd
sv-SE	Importerade

Methods

ShowDimensions

procedure ShowDimensions()

UpdateRelatedCommEntries

procedure UpdateRelatedCommEntries()

CheckDocOccurrenciesTotalsRounding

procedure CheckDocOccurrenciesTotalsRounding()

ShowAlocationReg

procedure ShowAlocationReg()

GetFormattedCashed

procedure GetFormattedCashed(): Decimal

Parameters / Return Value

Returns Decimal

DrillDownCashed

procedure DrillDownCashed()

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.

EOS Labs - 28.06.2024

Table 18008311 EOS Comm. Doc. Ledger Entry

Fields

Entry No. (1)

Table ID (10)

Sales Document Type (15)

Document No. (20)

Document Line No. (25)

Salesperson Role (30)

Salesperson (35)

Sell-to No. (50)

Sell-to Name (51)

Bill-to No. (52)

Bill-to Name (53)

Commission Period Code (60)

Document Date (70)

Posting Date (71)

Type (80)

No. (81)

Description (82)

Quantity (90)

Unit of Measure Code (91)

Currency Code (92)

Currency Factor (93)

Line Amount (100)

Line Amount (LCY) (101)

Commission Base Amount (LCY) (110)

Orig. Comm. Base Amount (LCY) (115)

Reduction % (117)

Commission % (120)

Commission % (Amount) (125)

Commission Amount (130)

Total Commission Amount (135)

Modified (140)

Cashed % (145)

Payable (LCY) (149)

Settlement Amount (LCY) (150)

Settled Amount (LCY) (155)

Remaining Amount (LCY) (160)

Dimension Set ID (170)

Product Commission Group Code (180)

Customer Commission Group Code (185)

Reason Code (190)

Source Code (200)

Batch Name (205)

Settlement Type (210)

Commission On Invoice Disc. (215)

Commission On Line Disc. (220)

Exclude (225)

From Calc. Setup Line (250)

Orig. Commission % (300)

Orig. Commission Amnt. (310)

Open (320)

Date Filter (400)

Prospect No. Filter (401)

Prospect Line No. Filter (402)

Cost All. Register No. (600)

Adv. Referred to Entry No. (500)

Imported (800)

Methods

ShowDimensions

UpdateRelatedCommEntries

CheckDocOccurrenciesTotalsRounding

ShowAlocationReg

GetFormattedCashed

Parameters / Return Value

DrillDownCashed

Feedback

Entry No. (`1`)

Table ID (`10`)

Sales Document Type (`15`)

Document No. (`20`)

Document Line No. (`25`)

Salesperson Role (`30`)

Salesperson (`35`)

Sell-to No. (`50`)

Sell-to Name (`51`)

Bill-to No. (`52`)

Bill-to Name (`53`)

Commission Period Code (`60`)

Document Date (`70`)

Posting Date (`71`)

Type (`80`)

No. (`81`)

Description (`82`)

Quantity (`90`)

Unit of Measure Code (`91`)

Currency Code (`92`)

Currency Factor (`93`)

Line Amount (`100`)

Line Amount (LCY) (`101`)

Commission Base Amount (LCY) (`110`)

Orig. Comm. Base Amount (LCY) (`115`)

Reduction % (`117`)

Commission % (`120`)

Commission % (Amount) (`125`)

Commission Amount (`130`)

Total Commission Amount (`135`)

Modified (`140`)

Cashed % (`145`)

Payable (LCY) (`149`)

Settlement Amount (LCY) (`150`)

Settled Amount (LCY) (`155`)

Remaining Amount (LCY) (`160`)

Dimension Set ID (`170`)

Product Commission Group Code (`180`)

Customer Commission Group Code (`185`)

Reason Code (`190`)

Source Code (`200`)

Batch Name (`205`)

Settlement Type (`210`)

Commission On Invoice Disc. (`215`)

Commission On Line Disc. (`220`)

Exclude (`225`)

From Calc. Setup Line (`250`)

Orig. Commission % (`300`)

Orig. Commission Amnt. (`310`)

Open (`320`)

Date Filter (`400`)

Prospect No. Filter (`401`)

Prospect Line No. Filter (`402`)

Cost All. Register No. (`600`)

Adv. Referred to Entry No. (`500`)

Imported (`800`)