Table 18008298 EOS Commissions Calc. Setup

Table 18008298 EOS Commissions Calc. Setup

Setup table, specifies how to calculate commission values for every setup combination

Language	Caption
da-DK	Opsætning af provision
de-DE	Kommission Calc. Einrichtung
es-ES	Configuración de Commission Calc.
fi-FI	Provisiolaskennan asetukset
fr-FR	Mise en place de la Commission Calc.
en-US	Commission Calc. Setup
it-IT	Setup calcolo provvigione
nb-NO	Oppsett av provisjonsberegning
nl-NL	Commissie Calc. Setup
sv-SE	Inställningar för kommissionen Calc.

Fields

Salesp. Role (`1`)

Code[50]

Language	Caption
da-DK	Rollefilter
de-DE	Verkäuferrolle
es-ES	Filtro de roles
fi-FI	Roolin suodatus
fr-FR	Filtre de rôles
en-US	Role Filter
it-IT	Filtro ruolo
nb-NO	Rollefilter
nl-NL	Rolfilter
sv-SE	Rollfilter

Salesperson (`2`)

Code[50]

Language	Caption
da-DK	Filter for sælger
de-DE	Verkäufer
es-ES	Filtro de vendedor
fi-FI	Myyjän suodatin
fr-FR	Filtre vendeur
en-US	Salesperson Filter
it-IT	Filtro agente
nb-NO	Selgerfilter
nl-NL	Filter verkoper
sv-SE	Filter för säljare

Sales Network (`5`)

Code[50]

TableRelation: "EOS Sales Network".Code

Language	Caption
da-DK	Salgsnetværksfilter
de-DE	Vertriebsnetzfilter
es-ES	Filtro de red de ventas
fi-FI	Myyntiverkostosuodatin
fr-FR	Filtre du réseau de vente
en-US	Sales Network Filter
it-IT	Filtro rete vendita
nb-NO	Salgsnettverksfilter
nl-NL	Verkoopnetwerkfilter
sv-SE	Försäljningsnätverksfilter

Customer No. (`10`)

Code[50]

TableRelation: Customer."No."

Language	Caption
da-DK	Kundefilter
de-DE	Kundenfilter
es-ES	Filtro de clientes
fi-FI	Asiakkaan suodatin
fr-FR	Filtre client
en-US	Customer Filter
it-IT	Filtro cliente
nb-NO	Kundefilter
nl-NL	Klantfilter
sv-SE	Kundfilter

Customer Commission Group Code (`11`)

Code[20]

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

Language	Caption
da-DK	Filter for kundeprovisionsgruppe
de-DE	Kundenkommissionsgruppenfilter
es-ES	Filtro de grupo de comisiones de clientes
fi-FI	Asiakasprovisioryhmän suodatin
fr-FR	Filtre de groupe de commission client
en-US	Customer Commission Group Filter
it-IT	Filtro gruppo di provvigioni clienti
nb-NO	Filter for kundeprovisjonsgruppe
nl-NL	Filter van de groep van de commissie van klanten
sv-SE	Gruppfilter för kundprovision

Product Type (`20`)

Option

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

Language	Caption
da-DK	Produkttype
de-DE	Produkttyp
es-ES	Tipo de producto
fi-FI	Tuotteen tyyppi
fr-FR	Type de produit
en-US	Product Type
it-IT	Tipo riga
nb-NO	Produkttype
nl-NL	Producttype
sv-SE	Produkttyp

Product No. (`21`)

Code[50]

TableRelation: if ("Product Type" = const(Item)) Item else if ("Product Type" = const("Fixed Asset")) "Fixed Asset" else if ("Product Type" = const("G/L Account")) "G/L Account" else if ("Product Type" = const(Resource)) Resource else if ("Product Type" = const("Charge (Item)")) "Item Charge"

Language	Caption
da-DK	Produktfilter
de-DE	Produktfilter
es-ES	Filtro de producto
fi-FI	Tuotteen suodatin
fr-FR	Filtre produit
en-US	Product Filter
it-IT	Filtro prodotto
nb-NO	Produktfilter
nl-NL	Productfilter
sv-SE	Produktfilter

Product Commission Group Code (`22`)

Code[20]

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

Language	Caption
da-DK	Filter for produktkommissionsgruppe
de-DE	Produktkommissiongruppenfilter
es-ES	Filtro de grupo de la Comisión de Productos
fi-FI	Tuoteprovisioryhmän suodatin
fr-FR	Filtre de groupe de la Commission des produits
en-US	Product Commission Group Filter
it-IT	Filtro gruppo provvigione prodotto
nb-NO	Filter for produktkommisjonsgruppe
nl-NL	Filter van de groep productcommissie
sv-SE	Gruppfilter för produktprovision

Starting Date (`30`)

Date

Language	Caption
da-DK	Startdato
de-DE	Startdatum
es-ES	Fecha de inicio
fi-FI	Aloituspvm
fr-FR	Date de début
en-US	Starting Date
it-IT	Data inizio
nb-NO	Startdato
nl-NL	Begindatum
sv-SE	Startdatum

Commission On Invoice Disc. (`40`)

Boolean

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

Commission On Line Disc. (`41`)

Boolean

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

Commission % (`50`)

Decimal

Language	Caption
da-DK	Kommissionen (%)
de-DE	Verkäufer Kommission (%)
es-ES	Comisión (%)
fi-FI	Komissio (%)
fr-FR	Commission (%)
en-US	Commission (%)
it-IT	Provvigione (%)
nb-NO	Kommisjon (%)
nl-NL	Commissie (%)
sv-SE	Kommissionen (%)

Commission Amount (LCY) (`51`)

Decimal

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

Priority (`60`)

Integer

Language	Caption
da-DK	Prioritet
de-DE	Priorität
es-ES	Prioridad
fi-FI	Ensisijainen
fr-FR	Priorité
en-US	Priority
it-IT	Priorità
nb-NO	Prioritet
nl-NL	Prioriteit
sv-SE	Prioritet

Disabled (`70`)

Boolean

Language	Caption
da-DK	Deaktiveret
de-DE	Deaktiviert
es-ES	Deshabilitado
fi-FI	Poistettu käytöstä
fr-FR	Handicapés
en-US	Disabled
it-IT	Disabilitato
nb-NO	Deaktivert
nl-NL	Handicap
sv-SE	Inaktiverad

Line No. (`80`)

Integer

Language	Caption
da-DK	Linje nr.
de-DE	Zeilennr.
es-ES	Línea No.
fi-FI	Rivin nro
fr-FR	Ligne No.
en-US	Line No.
it-IT	Nr. riga
nb-NO	Linjenr.
nl-NL	Regel nr.
sv-SE	Radnr

Description (`90`)

Text[100]

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

Threshold Type (`100`)

Enum "EOS Commission Threshold Type"

Language	Caption
da-DK	Tærskeltype
de-DE	Schwellenwerttyp
es-ES	Tipo de umbral
fi-FI	Kynnyksen tyyppi
fr-FR	Type de seuil
en-US	Threshold Type
it-IT	Tipo soglia
nb-NO	Terskeltype
nl-NL	Drempeltype
sv-SE	Tröskeltyp

Threshold Code (`101`)

Code[20]

Language	Caption
da-DK	Tærskelkode
de-DE	Schwellenwertcode
es-ES	Código de umbral
fi-FI	Kynnysarvon koodi
fr-FR	Code de seuil
en-US	Threshold Code
it-IT	Codice soglia
nb-NO	Terskel kode
nl-NL	Drempelcode
sv-SE	Tröskelkod

Custom Key (`1000`)

Code[10]

Language	Caption
da-DK	Brugerdefineret nøgle
de-DE	Benutzerdefinierter Schlüssel
es-ES	Clave personalizada
fi-FI	Mukautettu avain
fr-FR	Clé personnalisée
en-US	Custom Key
it-IT	Chiave personalizzata
nb-NO	Egendefinert nøkkel
nl-NL	Aangepaste sleutel
sv-SE	Anpassad nyckel

Methods

CalculatePriority

procedure CalculatePriority()

InitializeRecord

procedure InitializeRecord(BelowXrec: Boolean)

Parameters / Return Value

BelowXrec Boolean

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 - 30.05.2025

Table 18008298 EOS Commissions Calc. Setup

Fields

Salesp. Role (1)

Salesperson (2)

Sales Network (5)

Customer No. (10)

Customer Commission Group Code (11)

Product Type (20)

Product No. (21)

Product Commission Group Code (22)

Starting Date (30)

Commission On Invoice Disc. (40)

Commission On Line Disc. (41)

Commission % (50)

Commission Amount (LCY) (51)

Priority (60)

Disabled (70)

Line No. (80)

Description (90)

Threshold Type (100)

Threshold Code (101)

Custom Key (1000)

Methods

CalculatePriority

InitializeRecord

Parameters / Return Value

Feedback

Salesp. Role (`1`)

Salesperson (`2`)

Sales Network (`5`)

Customer No. (`10`)

Customer Commission Group Code (`11`)

Product Type (`20`)

Product No. (`21`)

Product Commission Group Code (`22`)

Starting Date (`30`)

Commission On Invoice Disc. (`40`)

Commission On Line Disc. (`41`)

Commission % (`50`)

Commission Amount (LCY) (`51`)

Priority (`60`)

Disabled (`70`)

Line No. (`80`)

Description (`90`)

Threshold Type (`100`)

Threshold Code (`101`)

Custom Key (`1000`)