Table 18059919 EOS Bonus Document Matching

Table 18059919 EOS Bonus Document Matching

Language	Caption
da-DK	Matchende bonusdokument
de-DE	Bonus-Dokumentenabgleich
es-ES	Coincidencia de documentos de bonificación
fi-FI	Bonusasiakirjan täsmäytys
fr-FR	Correspondance de documents bonus
en-US	Bonus Document Matching
it-IT	Abbina documenti bonus
nb-NO	Bonusdokument matching
nl-NL	Bonusdocument matching
sv-SE	Matchning av bonusdokument

Fields

Document Source Type (`1`)

Integer

Language	Caption
da-DK	Kildetype
de-DE	Herkunftsart
es-ES	Tipo de fuente
fi-FI	Lähdetyyppi
fr-FR	Type origine
en-US	Source Type
it-IT	Tipo origine
nb-NO	Kildetype
nl-NL	Bronsoort
sv-SE	Ursprungstyp

Document Source Subtype (`2`)

Integer

Language	Caption
da-DK	Kildeundertype
de-DE	Herkunftsunterart
es-ES	Subtipo fuente
fi-FI	Alatyypin lähde
fr-FR	Sous-type origine
en-US	Source Subtype
it-IT	Sottotipo origine
nb-NO	Kildeundertype
nl-NL	Bronsubsoort
sv-SE	Ursprungssubtyp

Document Source ID (`3`)

Code[20]

Language	Caption
da-DK	Kilde-id
de-DE	Herkunfts-ID
es-ES	ID de origen
fi-FI	Lähdetunnus
fr-FR	ID origine
en-US	Source ID
it-IT	ID origine
nb-NO	Kilde-ID
nl-NL	Voor id
sv-SE	Ursprungs-ID

Document Source Ref. No. (`4`)

Integer

Language	Caption
da-DK	Kildereferencenr.
de-DE	Herkunftsref.-Nr.
es-ES	Ref fuente. No.
fi-FI	Lähdeviitenro
fr-FR	N° réf. origine
en-US	Source Ref. No.
it-IT	Nr. rif. origine
nb-NO	Kilderef.nr.
nl-NL	Bronreferentienr.
sv-SE	Ursprungsref.nr

Original Amount (`5`)

Decimal

Language	Caption
da-DK	Oprindeligt beløb
de-DE	Ursprünglicher Betrag
es-ES	Cantidad original
fi-FI	Alkuperäinen summa
fr-FR	Montant d’origine
en-US	Original Amount
it-IT	Importo originale
nb-NO	Opprinnelig beløp
nl-NL	Origineel bedrag
sv-SE	Ursprungligt belopp

Amount to Match (`6`)

Decimal

Language	Caption
da-DK	Beløb, der skal matches
de-DE	Abgleichsbetrag
es-ES	Cantidad a igualar
fi-FI	Summa, joka täsmää
fr-FR	Montant à match
en-US	Amount to Match
it-IT	Importo da abbinare
nb-NO	Beløp som skal samsvare
nl-NL	Bedrag dat overeenkomt
sv-SE	Belopp till Match

Matching Amount (`13`)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Bonus Journal Line"."Amount (LCY)" WHERE("Source Type" = FIELD("Document Source Type"), "Source Subtype" = FIELD("Document Source Subtype"), "Source No." = FIELD("Document Source ID"), "Source Ref. No." = FIELD("Document Source Ref. No.")))

Language	Caption
da-DK	Tilsvarende beløb
de-DE	Abgleichsbetrag
es-ES	Cantidad de coincidencia
fi-FI	Vastaava summa
fr-FR	Montant correspondant
en-US	Matching Amount
it-IT	Importo in associazione
nb-NO	Samsvarende beløp
nl-NL	Overeenkomend bedrag
sv-SE	Matchande belopp

Matched Amount (`14`)

Decimal

FieldClass: FlowField

CalcFormula: - Sum("EOS Bonus Ledger Entry"."Amount (LCY)" WHERE("Source Type" = FIELD("Document Source Type"), "Source Subtype" = FIELD("Document Source Subtype"), "Source No." = FIELD("Document Source ID"), "Source Ref. No." = FIELD("Document Source Ref. No.")))

Language	Caption
da-DK	Matchet beløb
de-DE	Abgleichsbetrag
es-ES	Importe igualado
fi-FI	Täsmäytetty summa
fr-FR	Montant correspondant
en-US	Matched Amount
it-IT	Importo abbinato
nb-NO	Matchet beløp
nl-NL	Overeenkomend bedrag
sv-SE	Matchade belopp

Sett. Amount To Be Accr. (`17`)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Bonus Settlement Entry"."Amount (LCY)" WHERE("Source Type" = FIELD("Document Source Type"), "Source Subtype" = FIELD("Document Source Subtype"), "Source ID" = FIELD("Document Source ID"), "Source Ref. No." = FIELD("Document Source Ref. No."), "To Be Accrued" = const(true)))

Language	Caption
da-DK	Udlignet beløb, der skal periodiseres
de-DE	Abzugerechneter Betrag, der aufgelaufen werden soll
es-ES	Cantidad liquidada que se acumula
fi-FI	Jaksotettava selvitetty summa
fr-FR	Montant réglé à accumuler
en-US	Settled Amount To Be Accrued
it-IT	Importo liquidato da maturare
nb-NO	Utlignet beløp som skal avsettes
nl-NL	Vereffend toe te rekenen bedrag
sv-SE	Kvittat belopp som ska uppfallas

Remaining Amount to Match (`15`)

Decimal

Language	Caption
da-DK	Resterende beløb, der skal matches
de-DE	Verbleibender Betrag, der abgeglichen werden soll
es-ES	Cantidad restante para coincidir
fi-FI	Jäljellä oleva täsmäävä summa
fr-FR	Montant restant à correspondre
en-US	Remaining Amount to Match
it-IT	Importo rimanente da abbinare
nb-NO	Gjenstående beløp som skal samsvare
nl-NL	Resterende hoeveelheid die overeenkomt
sv-SE	Återstående belopp att matcha

Original Amount Including VAT (`16`)

Decimal

Language	Caption
da-DK	Oprindeligt beløb inklusive moms
de-DE	Ursprünglicher Betrag einschließlich MwSt.
es-ES	Importe original con IVA incluido
fi-FI	Alkuperäinen summa sisältäen ALV:n
fr-FR	Montant d’origine incluant la TVA
en-US	Original Amount Including VAT
it-IT	Importo originale IVA inclusa
nb-NO	Opprinnelig beløp inkludert mva.
nl-NL	Origineel bedrag inclusief BTW
sv-SE	Ursprungligt belopp inklusive moms

Document Type (`20`)

Option

" " (0) , "Sales Invoice" (1) , "Sales Credit Memo" (2) , "Purchase Invoice" (3) , "Purchase Credit Memo" (4) , "Posted Sales Invoice" (5) , "Posted Sales Credit Memo" (6) , "Posted Purchase Invoice" (7) , "Posted Purchase Credit Memo" (8)

Language	Caption
da-DK	Bilagstype
de-DE	Belegart
es-ES	Tipo de documento
fi-FI	Asiakirjatyyppi
fr-FR	Type document
en-US	Document Type
it-IT	Tipo di documento
nb-NO	Bilagstype
nl-NL	Documenttype
sv-SE	Dokumenttyp

Posting Date (`21`)

Date

Language	Caption
da-DK	Bogføringsdato
de-DE	Buchungsdatum
es-ES	Fecha de contabilización
fi-FI	Kirjauspvm.
fr-FR	Date comptabilisation
en-US	Posting Date
it-IT	Data di registrazione
nb-NO	Bokføringsdato
nl-NL	Boekingsdatum
sv-SE	Bokföringsdatum

Document Date (`22`)

Date

Language	Caption
da-DK	Bilagsdato
de-DE	Belegdatum
es-ES	Fecha del documento
fi-FI	Asiakirjan pvm
fr-FR	Date document
en-US	Document Date
it-IT	Data documento
nb-NO	Bilagsdato
nl-NL	Documentdatum
sv-SE	Dokumentdatum

External Document No. (`23`)

Code[35]

Language	Caption
da-DK	Eksternt bilagsnr.
de-DE	Externe Belegnummer
es-ES	Documento externo No.
fi-FI	Ulkoisen asiakirjan nro
fr-FR	N° doc. externe
en-US	External Document No.
it-IT	Nr. documento esterno
nb-NO	Eksterndokumentnr.
nl-NL	Extern documentnr.
sv-SE	Externt dokumentnr

Sell-to/Buy-from No. (`30`)

Code[20]

TableRelation: IF ("Document Type" = FILTER("Sales Invoice" | "Sales Credit Memo")) Customer."No." ELSE IF ("Document Type" = FILTER("Purchase Invoice" | "Purchase Credit Memo")) Vendor."No."

Language	Caption
da-DK	Kundenr./leverandørnr.
de-DE	Verk. an/Eink. von Nr.
es-ES	Venta a/Comprar desde No.
fi-FI	Tilausasiakkaan/tavarantoimittajan nro
fr-FR	N° donneur d’ordre/fournisseur
en-US	Sell-to/Buy-from No.
it-IT	Vendere a/Acq. da - Nr.
nb-NO	Salg til-/kjøp fra-nr.
nl-NL	Sell-to/Buy-from No.
sv-SE	Kund-/Leverantörsnr

Sell-to/Buy-from Name (`31`)

Text[100]

Language	Caption
da-DK	Kundenr./leverandørnavn
de-DE	Verk. an/Eink. von Name
es-ES	Venta a/Comprar desde Nombre
fi-FI	Tilausasiakkaan/tavarantoimittajan nimi
fr-FR	Nom donneur d’ordre/fournisseur
en-US	Sell-to/Buy-from Name
it-IT	Vendere a/Acq. da - Nome
nb-NO	Salg til-/kjøp fra-navn
nl-NL	Orderklant/-leveranciersnaam
sv-SE	Kund-/leverantörsnamn

Bill-to/Pay-to No. (`32`)

Code[20]

Language	Caption
da-DK	Faktureres til/leverandørnr.
de-DE	Rech. an/Zahlung an-Nr.
es-ES	Facturaaaa/Pago-a No.
fi-FI	Lask.asiakkaan/Tav. lask. nro
fr-FR	N° client facturé/personne à payer
en-US	Bill-to/Pay-to No.
it-IT	Nr. fatturare a/pagare a
nb-NO	Fakt. til/bet. til-nr.
nl-NL	Factureren/Betalen aan
sv-SE	Faktureras/Betalas nr

Bill-to/Pay-to Name (`33`)

Text[100]

Language	Caption
da-DK	Navn på fakturering/betaling til
de-DE	Rech. an/Zahlung an-Name
es-ES	Nombre de facturación/pago
fi-FI	Laskutusasiakkaan/maksun laskuttan nimi
fr-FR	Facture/Nom de paiement
en-US	Bill-to/Pay-to Name
it-IT	Fatturare a/Pagare a Nome
nb-NO	Navn på faktura til/betaling
nl-NL	Naam van bill-to/pay-to-
sv-SE	Fakturerings-/betalningsnamn

Hide Line (`40`)

Boolean

Language	Caption
da-DK	Skjul streg
de-DE	Zeile ausblenden
es-ES	Ocultar línea
fi-FI	Piilota rivi
fr-FR	Masquer la ligne
en-US	Hide Line
it-IT	Nascondi riga
nb-NO	Skjul linje
nl-NL	Regel verbergen
sv-SE	Dölj linje

Methods

CalcRemainingAmountToMatch

procedure CalcRemainingAmountToMatch()

GetBonusDocumentType

procedure GetBonusDocumentType(): Enum "EOS Bonus Document Type"

Parameters / Return Value

Returns Enum "EOS Bonus Document Type"

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

Table 18059919 EOS Bonus Document Matching

Fields

Document Source Type (1)

Document Source Subtype (2)

Document Source ID (3)

Document Source Ref. No. (4)

Original Amount (5)

Amount to Match (6)

Matching Amount (13)

Matched Amount (14)

Sett. Amount To Be Accr. (17)

Remaining Amount to Match (15)

Original Amount Including VAT (16)

Document Type (20)

Posting Date (21)

Document Date (22)

External Document No. (23)

Sell-to/Buy-from No. (30)

Sell-to/Buy-from Name (31)

Bill-to/Pay-to No. (32)

Bill-to/Pay-to Name (33)

Hide Line (40)

Methods

CalcRemainingAmountToMatch

GetBonusDocumentType

Parameters / Return Value

Feedback

Document Source Type (`1`)

Document Source Subtype (`2`)

Document Source ID (`3`)

Document Source Ref. No. (`4`)

Original Amount (`5`)

Amount to Match (`6`)

Matching Amount (`13`)

Matched Amount (`14`)

Sett. Amount To Be Accr. (`17`)

Remaining Amount to Match (`15`)

Original Amount Including VAT (`16`)

Document Type (`20`)

Posting Date (`21`)

Document Date (`22`)

External Document No. (`23`)

Sell-to/Buy-from No. (`30`)

Sell-to/Buy-from Name (`31`)

Bill-to/Pay-to No. (`32`)

Bill-to/Pay-to Name (`33`)

Hide Line (`40`)