Table 18008309 EOS Commission Prospect Header

Table 18008309 EOS Commission Prospect Header

Contains a record for settlement prospect

Language	Caption
da-DK	Overskrift i Kommissionens kundeemne
de-DE	Commission Prospect Header
es-ES	Encabezado de prospecto de la comisión
fi-FI	Komission prospektin otsikko
fr-FR	En-tête prospect de la Commission
en-US	Commission Prospect Header
it-IT	Testata prospetti liquidazione
nb-NO	Topptekst for provisjonsprospekt
nl-NL	Prospect header van de Commissie
sv-SE	Kommissionen Prospect Header

Fields

No. (`1`)

Code[20]

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

Commission Period Code (`2`)

Code[20]

TableRelation: "EOS Commission Period"

Language	Caption
da-DK	Kompetenceperiodekode
de-DE	Kompetenzzeitraum-Code
es-ES	Código de período de competencia
fi-FI	Osaamiskauden koodi
fr-FR	Code de période de compétence
en-US	Competence Period Code
it-IT	Codice periodo competenza
nb-NO	Kompetanse Periode Kode
nl-NL	CompetentieperiodeCode
sv-SE	Kod för kompetensperiod

Salesperson Code (`3`)

Code[20]

TableRelation: "Salesperson/Purchaser"

Language	Caption
da-DK	Sælger nr.
de-DE	Agent-Nr.
es-ES	Vendedor No.
fi-FI	Myyjän nro
fr-FR	Vendeur No.
en-US	Salesperson No.
it-IT	Codice agente
nb-NO	Selger nr.
nl-NL	Verkoper Nr.
sv-SE	Säljare Nr

Salesperson Name (`4`)

Text[50]

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser".Name where(Code = field("Salesperson Code")))

Language	Caption
da-DK	Sælgers navn
de-DE	Agentname
es-ES	Nombre del vendedor
fi-FI	Myyjän nimi
fr-FR	Nom du vendeur
en-US	Salesperson Name
it-IT	Nome agente
nb-NO	Navn på selger
nl-NL	Naam verkoper
sv-SE	Säljare Namn

Vendor No. (`5`)

Code[20]

TableRelation: Vendor

Language	Caption
da-DK	Kreditornr.
de-DE	Kreditor-Nr.
es-ES	Proveedor No.
fi-FI	Toimittajan nro
fr-FR	Numéro du vendeur
en-US	Vendor No.
it-IT	Nr. fornitore
nb-NO	Leverandørnr.
nl-NL	Leverancier nr.
sv-SE	Leverantörsnr

Pay-to Name (`6`)

Text[100]

Language	Caption
da-DK	Pay-to-navn
de-DE	Zahlung an Name
es-ES	Nombre de pago
fi-FI	Maksu-nimi
fr-FR	Nom de pay-to
en-US	Pay-to Name
it-IT	Pagare a - Nome
nb-NO	Navn på betaling til
nl-NL	Naam betalen
sv-SE	Pay-to-namn

Pay-to Name 2 (`7`)

Text[50]

Language	Caption
da-DK	Pay-to Navn 2
de-DE	Zahlung an Name 2
es-ES	Nombre de pago 2
fi-FI	Maksu-tunnus 2
fr-FR	Pay-to Name 2
en-US	Pay-to Name 2
it-IT	Pagare a - Nome 2
nb-NO	Navn 2
nl-NL	Pay-to Naam 2
sv-SE	Namn 2 för betalning

Pay-to Address (`8`)

Text[100]

Language	Caption
da-DK	Betal-til-adresse
de-DE	Zahlung an Adresse
es-ES	Dirección de pago
fi-FI	Maksu-osoite
fr-FR	Adresse payante
en-US	Pay-to Address
it-IT	Pagare a - Indirizzo
nb-NO	Betal til-adresse
nl-NL	Betalen naar adres
sv-SE	Betalningsadress

Pay-to Address 2 (`9`)

Text[50]

Language	Caption
da-DK	Pay-to-adresse 2
de-DE	Zahlung an Adresse 2
es-ES	Dirección de pago 2
fi-FI	Maksu-osoite 2
fr-FR	Adresse payante 2
en-US	Pay-to Address 2
it-IT	Pagare a - Indirizzo 2
nb-NO	Betal til-adresse 2
nl-NL	Betalen naar adres 2
sv-SE	Adress 2

Pay-to City (`10`)

Text[30]

Language	Caption
da-DK	Pay-to By
de-DE	Zahlung an Ort
es-ES	Ciudad de pago
fi-FI	Maksu-to-kaupunki
fr-FR	Pay-to City
en-US	Pay-to City
it-IT	Pagare a - Città
nb-NO	Betal til by
nl-NL	Betalen naar stad
sv-SE	Betala till stad

Pay-to Post Code (`11`)

Code[20]

TableRelation: "Post Code"

Language	Caption
da-DK	Postnummer til betaling
de-DE	Zahlung an PLZ-Code
es-ES	Código de pago a correo
fi-FI	Maksu-ihin-postinumero
fr-FR	Code postal payant
en-US	Pay-to Post Code
it-IT	Pagare a - CAP
nb-NO	Betal til-postnummer
nl-NL	Betalen naar postcode
sv-SE	Betalningsföringsnummer

Pay-to County (`12`)

Text[30]

Language	Caption
da-DK	Betal til amt
de-DE	Zahlung an Bundesregion
es-ES	Condado de Pago a
fi-FI	Maksu-to-piirikunta
fr-FR	Pay-to County
en-US	Pay-to County
it-IT	Pagare a - Provincia
nb-NO	Betal til fylke
nl-NL	Betalen aan county
sv-SE	Betala till länet

Pay-to Country Code (`13`)

Code[10]

TableRelation: "Country/Region"

Language	Caption
da-DK	Faktureringslandkode
de-DE	Pay-to-Country-Code
es-ES	Código de pago al país
fi-FI	Tavaran palkka-maakoodi
fr-FR	Code de pay-to-country
en-US	Pay-to Country Code
it-IT	Pagare a - Cod. paese
nb-NO	Landskode for betaling til
nl-NL	Pay-to-country code
sv-SE	Landskod för betalning

Status (`20`)

Option

Open (0) , Released (1)

Language	Caption
da-DK	Status
de-DE	Status
es-ES	Estado
fi-FI	Tila
fr-FR	Statut
en-US	Status
it-IT	Stato
nb-NO	Status
nl-NL	Status
sv-SE	Status

Posting Date (`30`)

Date

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

Document Date (`31`)

Date

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

Posting Description (`35`)

Text[100]

Language	Caption
da-DK	Beskrivelse af bogføring
de-DE	Buchungsbeschreibung
es-ES	Descripción de la publicación
fi-FI	Kirjauksen kuvaus
fr-FR	Description de la publication
en-US	Posting Description
it-IT	Descrizione registrazione
nb-NO	Bokføring Beskrivelse
nl-NL	Beschrijving plaatsen
sv-SE	Beskrivning av bokföring

Payment Terms Code (`40`)

Code[10]

TableRelation: "Payment Terms"

Language	Caption
da-DK	Betalingsvilkårskode
de-DE	Zahlungsbedingungen-Code
es-ES	Código de Términos de Pago
fi-FI	Maksuehtojen koodi
fr-FR	Code des modalités de paiement
en-US	Payment Terms Code
it-IT	Codice dei termini di pagamento
nb-NO	Kode for betalingsbetingelser
nl-NL	Betalingsvoorwaardencode
sv-SE	Kod för betalningsvillkor

Payment Method Code (`45`)

Code[10]

TableRelation: "Payment Method"

Language	Caption
da-DK	Betalingsmetodekode
de-DE	Zahlungsformcode
es-ES	Código de método de pago
fi-FI	Maksutavan koodi
fr-FR	Code de méthode de paiement
en-US	Payment Method Code
it-IT	Cod. metodo di pagamento
nb-NO	Kode for betalingsmåte
nl-NL	Code betalingsmethode
sv-SE	Betalningsmetodskod

Purchase Invoice Emission Date (`50`)

Date

Language	Caption
da-DK	Bogført købsdokumentbogførsdato
de-DE	Kaufrechnungs-Emissionsdatum
es-ES	Fecha de contabilización del documento de compra registrado
fi-FI	Kirjatun ostoasiakirjon kirjauspäivämäärä
fr-FR	Date d’affichage de l’achat publié
en-US	Posted Purchase Doc. Posting Date
it-IT	Data registrazione documento acquisto
nb-NO	Bokført bokføringsdato for kjøpsdokument
nl-NL	Blog voor aankoop geplaatst.
sv-SE	Bokfört inköpsdokument. bokföringsdatum

Purchase Doc. Type Linked (`54`)

Option

Quote (0) , Order (1) , Invoice (2) , "Credit Memo" (3) , "Blanket Order" (4) , "Return Order" (5) , " " (6)

Language	Caption
da-DK	Bogført købsdokumenttype
de-DE	Posted Purchase Doc. Typ
es-ES	Tipo de documento de compra registrado
fi-FI	Kirjatun ostoasiakirjatyypin tyyppi
fr-FR	Type d’achat publié Type
en-US	Posted Purchase Doc. Type
it-IT	Tipo documento acquisto registrato
nb-NO	Postert kjøpsdokumenttype
nl-NL	Geboekt aankoopdoc. Type
sv-SE	Bokförd inköpsdokument.

Purchase Invoice No. Linked (`55`)

Code[20]

TableRelation: if ("Purchase Doc. Type Linked" = const(Invoice)) "Purch. Inv. Header"."No." else if ("Purchase Doc. Type Linked" = const("Credit Memo")) "Purch. Cr. Memo Hdr."."No."

Language	Caption
da-DK	Bogført købsnr.
de-DE	Einkaufsrechnung Nr. Verknüpft
es-ES	No de compra registrado.
fi-FI	Kirjattu ostoasiakirja nro
fr-FR	Achat affiché Doc. No.
en-US	Posted Purchase Doc. No.
it-IT	Nr. documento acquisto registrato
nb-NO	Bokført kjøpsdokument nr.
nl-NL	Aankoop doc. Nee.
sv-SE	Bokförd inköpsdokument nr

Pre-Assigned Document Type (`59`)

Option

Quote (0) , Order (1) , Invoice (2) , "Credit Memo" (3) , "Blanket Order" (4) , "Return Order" (5) , " " (6)

Language	Caption
da-DK	Midlertidigt købsdokument
de-DE	Temporärer Kauf Doc. Typ
es-ES	Tipo de documento de compra temporal
fi-FI	Tilapäisen ostoasiakirjatyypin tyyppi
fr-FR	Type d’achat temporaire Doc.
en-US	Temporary Purchase Doc. Type
it-IT	Tipo documento acquisto temporaneo
nb-NO	Midlertidig kjøpsdokumenttype
nl-NL	Tijdelijke aankoop doc. Type
sv-SE	Dokument för tillfälligt inköp.

Pre-Assigned Invoice No. (`60`)

Code[20]

TableRelation: "Purchase Header"."No." where("Document Type" = field("Pre-Assigned Document Type"))

Language	Caption
da-DK	Midlertidigt købsnr.
de-DE	Vorab zugewiesene Rechnung Nr.
es-ES	Documento de Compra Temporal No.
fi-FI	Tilapäisen oston nro
fr-FR	Achat temporaire Doc. No.
en-US	Temporary Purchase Doc. No.
it-IT	Nr. documento acquisto temporaneo
nb-NO	Midlertidig kjøpsdokument nr.
nl-NL	Tijdelijke aankoop Doc. Nee.
sv-SE	Dokument för tillfälligt inköp

Period Starting Date (`70`)

Date

Language	Caption
da-DK	Dato for periodes start
de-DE	Periodenstartdatum
es-ES	Fecha de inicio del período
fi-FI	Kauden aloituspvm
fr-FR	Date de début de la période
en-US	Period Starting Date
it-IT	Data inizio periodo
nb-NO	Startdato for periode
nl-NL	Begindatum van de periode
sv-SE	Periodens startdatum

Period Ending Date (`75`)

Date

Language	Caption
da-DK	Slutdato for periode
de-DE	Periodenenddatum
es-ES	Fecha de finalización del período
fi-FI	Kauden lopetuspvm
fr-FR	Date de fin de la période
en-US	Period Ending Date
it-IT	Data fine periodo
nb-NO	Sluttdato for periode
nl-NL	Einddatum van de periode
sv-SE	Slutdatum för period

Currency Code (`80`)

Code[10]

TableRelation: Currency.Code

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

Line Total (LCY) (`100`)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS Commission Prospect Line"."Amount (LCY)" where("Commission Period Code" = field("Commission Period Code"), "Salesperson Code" = field("Salesperson Code")))

Language	Caption
da-DK	Linjetotal (RV)
de-DE	Liniensumme (LCY)
es-ES	Total de línea (LCY)
fi-FI	Rivin summa (PVA)
fr-FR	Total de la ligne (LCY)
en-US	Line Total (LCY)
it-IT	Totale Importo (VL)
nb-NO	Linje sum (NOK)
nl-NL	Line Totaal (LCY)
sv-SE	Radsumma (BVA)

Line Total (`101`)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS Commission Prospect Line".Amount where("Commission Period Code" = field("Commission Period Code"), "Salesperson Code" = field("Salesperson Code")))

Language	Caption
de-DE	Liniensumme
es-ES	Total de línea
fr-FR	Total de la ligne
en-US	Line Total
it-IT	Totale Importo

Currency Factor (`102`)

Decimal

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

Methods

Release

procedure Release()

Reopen

procedure Reopen()

OpenPurchDocument

procedure OpenPurchDocument()

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 18008309 EOS Commission Prospect Header

Fields

No. (1)

Commission Period Code (2)

Salesperson Code (3)

Salesperson Name (4)

Vendor No. (5)

Pay-to Name (6)

Pay-to Name 2 (7)

Pay-to Address (8)

Pay-to Address 2 (9)

Pay-to City (10)

Pay-to Post Code (11)

Pay-to County (12)

Pay-to Country Code (13)

Status (20)

Posting Date (30)

Document Date (31)

Posting Description (35)

Payment Terms Code (40)

Payment Method Code (45)

Purchase Invoice Emission Date (50)

Purchase Doc. Type Linked (54)

Purchase Invoice No. Linked (55)

Pre-Assigned Document Type (59)

Pre-Assigned Invoice No. (60)

Period Starting Date (70)

Period Ending Date (75)

Currency Code (80)

Line Total (LCY) (100)

Line Total (101)

Currency Factor (102)

Methods

Release

Reopen

OpenPurchDocument

Feedback

No. (`1`)

Commission Period Code (`2`)

Salesperson Code (`3`)

Salesperson Name (`4`)

Vendor No. (`5`)

Pay-to Name (`6`)

Pay-to Name 2 (`7`)

Pay-to Address (`8`)

Pay-to Address 2 (`9`)

Pay-to City (`10`)

Pay-to Post Code (`11`)

Pay-to County (`12`)

Pay-to Country Code (`13`)

Status (`20`)

Posting Date (`30`)

Document Date (`31`)

Posting Description (`35`)

Payment Terms Code (`40`)

Payment Method Code (`45`)

Purchase Invoice Emission Date (`50`)

Purchase Doc. Type Linked (`54`)

Purchase Invoice No. Linked (`55`)

Pre-Assigned Document Type (`59`)

Pre-Assigned Invoice No. (`60`)

Period Starting Date (`70`)

Period Ending Date (`75`)

Currency Code (`80`)

Line Total (LCY) (`100`)

Line Total (`101`)

Currency Factor (`102`)