Table 18008255 EOS VAT Exemption

Table 18008255 EOS VAT Exemption

Language	Caption
de-DE	MwSt.-Befreiung
en-US	VAT Exemption
it-IT	Dich. d’intento

Fields

Type (`1`)

Option

Customer (0) , Vendor (1)

Language	Caption
de-DE	Art
en-US	Type
it-IT	Tipo

No. (`2`)

Code[20]

Language	Caption
de-DE	Nr.
en-US	No.
it-IT	Nr.

Source No. (`3`)

Code[20]

TableRelation: if (Type = const(Customer)) Customer."No." else if (Type = const(Vendor)) Vendor."No."

Language	Caption
de-DE	Herkunftsnr.
en-US	Source No.
it-IT	Nr. origine

Status (`5`)

Option

New (0) , Released (1) , Closed (2) , Revoked (3)

Language	Caption
de-DE	Status
en-US	Status
it-IT	Stato

Description (`6`)

Text[100]

Language	Caption
de-DE	Beschreibung
en-US	Description
it-IT	Descrizione

Starting Date (`10`)

Date

Language	Caption
de-DE	Startdatum
en-US	Starting Date
it-IT	Data inizio

Ending Date (`11`)

Date

Language	Caption
de-DE	Enddatum
en-US	Ending Date
it-IT	Data fine

Receipt Date (`12`)

Date

Language	Caption
de-DE	Eingangsdatum
en-US	Receipt Date
it-IT	Data ricevimento

Issue Date (`13`)

Date

Language	Caption
de-DE	Ausstellungsdatum
en-US	Issue Date
it-IT	Data emissione

Revoked Date (`14`)

Date

Language	Caption
de-DE	Widerrufsdatum
en-US	Revoked Date
it-IT	Data revoca

Reference (`18`)

Text[50]

Language	Caption
de-DE	Referenz
en-US	Reference
it-IT	Riferimento

VAT Bureau No. (`19`)

Text[50]

Language	Caption
de-DE	MwSt.-Zuständigkeitsnr.
en-US	VAT Bureau No.
it-IT	Nr. Ufficio IVA

Document No. (`50`)

Code[20]

Language	Caption
de-DE	Nr. MwSt.-Befreiung
en-US	VAT Exemption No.
it-IT	Nr. dich. d’intento

VAT Bus. Posting Group (`54`)

Code[20]

TableRelation: "VAT Business Posting Group".Code

Obsolete

Removed: Use ‘VAT Prod. Posting Group’ (20.0)

Language	Caption

VAT Prod. Posting Group (`55`)

Code[20]

TableRelation: "VAT Product Posting Group".Code

Language	Caption
de-DE	MwSt.-Produktbuchungsgruppe
en-US	VAT Prod. Posting Group
it-IT	Cat. reg. art./serv. IVA

Is Valid (`70`)

Boolean

Indicates if the VAT Exemption is valid. This field is only used internally.

Language	Caption
de-DE	Gültig
en-US	Is Valid
it-IT	Valida

Declaration Type (`109`)

Option

Period (0) , Transaction (1) , Amount (2)

Language	Caption
de-DE	Erklärungsart
en-US	Declaration Type
it-IT	Tipo dichiarazione

Amount (LCY) (`110`)

Decimal

Language	Caption
de-DE	Betrag (MW)
en-US	Amount (LCY)
it-IT	Importo (VL)

Used Amount (LCY) (`111`)

Decimal

Language	Caption
de-DE	Verbrauchter Betrag (MW)
en-US	Used Amount (LCY)
it-IT	Importo usato (VL)

Amount Curr. Document (LCY) (`112`)

Decimal

Internal use only. Holds the amount of the current document during amount verification.

Language	Caption
de-DE	Betrag Akt. Beleg (LCY)
en-US	Amount Curr. Document (LCY)
it-IT	Importo documento corr. (VL)

Purchasing/Importation (`200`)

Text[50]

Language	Caption
de-DE	Einkauf/Import
en-US	Purchasing/Importation
it-IT	Acquisto/importazione

Integr. Sending Protocol 1 (`205`)

Code[20]

Language	Caption
de-DE	Integr. Sendeprotokoll 1
en-US	Integr. Sending Protocol 1
it-IT	Protocollo invio integrativo 1

Integr. Sending Protocol 2 (`206`)

Code[10]

Language	Caption
de-DE	Integr. Sendeprotokoll 2
en-US	Integr. Sending Protocol 2
it-IT	Protocollo invio integrativo 2

Sending Protocol 1 (`207`)

Code[20]

Language	Caption
de-DE	Sendeprotokoll 1
en-US	Sending Protocol 1
it-IT	Protocollo invio 1

Sending Protocol 2 (`208`)

Code[10]

Language	Caption
de-DE	Sendeprotokoll 2
en-US	Sending Protocol 2
it-IT	Protocollo invio 2

Plafond Type (`210`)

Option

"Fixed" (0) , Mobile (1)

Language	Caption
de-DE	Plafond-Art
en-US	Plafond Type
it-IT	Tipo Plafond

Last Export Date (`211`)

Date

Language	Caption
de-DE	Letztes Export-Datum
en-US	Last Export Date
it-IT	Data ultima esportazione

Annual VAT Statement Submitted (`212`)

Boolean

Language	Caption
de-DE	MwSt.-Jahreserklärung übermittelt
en-US	Annual VAT Statement Submitted
it-IT	Dichiarazione annuale IVA presentata

Exports (`220`)

Boolean

Language	Caption
de-DE	Exporte
en-US	Exports
it-IT	Esportazioni

Intra-Community Services (`221`)

Boolean

Language	Caption
de-DE	Innergemeinschaftliche Leistungen
en-US	Intra-Community Services
it-IT	Cessioni Intracomunitarie

Services to San Marino (`222`)

Boolean

Language	Caption
de-DE	Leistungen nach San Marino
en-US	Services to San Marino
it-IT	Cessioni verso San Marino

Assimilated Operations (`223`)

Boolean

Language	Caption
de-DE	Ähnliche Vorgänge
en-US	Assimilated Operations
it-IT	Operazioni assimilate

Extra-ordinary Operations (`224`)

Boolean

Language	Caption
de-DE	Extraordinäre Operationen
en-US	Extra-ordinary Operations
it-IT	Operazioni straordinarie

Old Entry No. (`500`)

Integer

Language	Caption
de-DE	Alte Lfd.-Nr.
en-US	Old Entry No.
it-IT	Nr. mov. vecchio

Methods

FilterByDocument

procedure FilterByDocument(DocVariant: Variant)

Parameters / Return Value

DocVariant Variant

FilterByDocument

procedure FilterByDocument(DocVariant: Variant; ValidOnly: Boolean)

Parameters / Return Value

DocVariant Variant
ValidOnly Boolean

FilterByDocument

procedure FilterByDocument(DocVariant: Variant; ValidOnly: Boolean; UseSpecificReferenceDate: Date)

Parameters / Return Value

DocVariant Variant
ValidOnly Boolean
UseSpecificReferenceDate Date

ChangeStatus

procedure ChangeStatus(NewStatus: Integer)

Parameters / Return Value

NewStatus Integer

CalcUsedAmount

procedure CalcUsedAmount(): Decimal

Parameters / Return Value

Returns Decimal

IsValidFor

procedure IsValidFor(Document: Variant): Boolean

Determines if a VAT Exemption is valid for a given document.

Parameters / Return Value

Document Variant
The document to check the exemption against.
Returns Boolean
true if it is valid, false otherwise.

IsValidFor

procedure IsValidFor(Document: Variant; UseSpecificReferenceDate: Date): Boolean

Determines if a VAT Exemption is valid for a given document.

Parameters / Return Value

Document Variant
The document to check the exemption against.
UseSpecificReferenceDate Date
The date to use for the check. If 0D, the “Document” reference date is used.
Returns Boolean
true if it is valid, false otherwise.

GetCustVendorName

procedure GetCustVendorName(): Text

Parameters / Return Value

Returns Text[]

GetVATRegistrationNo

procedure GetVATRegistrationNo(): Text

Parameters / Return Value

Returns Text[]

AddToBuffer

procedure AddToBuffer(ExemptionType: Integer; ExemptionNo: Code[20]): Boolean

Add a VAT exemption to this buffer instance. This is only valid if the instance is temporary.

Parameters / Return Value

ExemptionType Integer
ExemptionNo Code[20]
The no. of the VAT exemption to be added.
Returns Boolean
Specifies whether the entry was added.

IsCustAuthVendor

procedure IsCustAuthVendor(): Boolean

Parameters / Return Value

Returns Boolean

GetVatIdentifier

procedure GetVatIdentifier(DocVATBusPostingGroup: Code[20]; DocVATProdPostingGroup: Code[20]): Code[20]

Parameters / Return Value

DocVATBusPostingGroup Code[20]
DocVATProdPostingGroup Code[20]
Returns Code[20]

VatEntryTypeToType

procedure VatEntryTypeToType(VatEntryType: Integer): Integer

Parameters / Return Value

VatEntryType Integer
Returns Integer

Events

OnAfterSetDocumentFilters

local procedure OnAfterSetDocumentFilters(DocVariant: Variant)

Is called whenever document-specific filters are applied that are used to find a VAT exemption for a given record.

Parameters / Return Value

DocVariant Variant
The record that is applying filters.

OnAfterCheckVATExemptionValid

local procedure OnAfterCheckVATExemptionValid(VATExemption: Record "EOS VAT Exemption"; var IsValid: Boolean)

Parameters / Return Value

VATExemption Record "EOS VAT Exemption"
IsValid Boolean

OnAfterChangeStatus

local procedure OnAfterChangeStatus(OldStatus: Integer; NewStatus: Integer)

Parameters / Return Value

OldStatus Integer
NewStatus Integer

OnBeforeChangeStatus

local procedure OnBeforeChangeStatus(OldStatus: Integer; NewStatus: Integer)

Parameters / Return Value

OldStatus Integer
NewStatus Integer

OnBeforeCalcUsedAmount

local procedure OnBeforeCalcUsedAmount(var Rec: Record "EOS VAT Exemption"; var UsedAmountLCY: Decimal; var isHandled: Boolean)

Raised before calculating the Used Amount LCY field for VAT Exemption

Parameters / Return Value

Rec Record "EOS VAT Exemption"
Vat Exemption being processed
UsedAmountLCY Decimal
Used Amount LCY value that will be assigned
isHandled Boolean
if set to true skips the VMI’s Used Amount LCY calculation and exits with the UsedAmountLCY paramter value

OnAfterCalcUsedAmount

local procedure OnAfterCalcUsedAmount(var Rec: Record "EOS VAT Exemption"; var UsedAmountLCY: Decimal; Sign: Integer; var VATEntry: Record "VAT Entry")

Raised after calculating the Used Amount LCY field for VAT Exemption

Parameters / Return Value

Rec Record "EOS VAT Exemption"
Vat Exemption being processed
UsedAmountLCY Decimal
Used Amount LCY value that will be assigned
Sign Integer
Sign that was used during the UsedAmountLCY calculation
VATEntry Record "VAT Entry"
VAT Entry that was used during the UsedAmountLCY calculation

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

Table 18008255 EOS VAT Exemption

Fields

Type (1)

No. (2)

Source No. (3)

Status (5)

Description (6)

Starting Date (10)

Ending Date (11)

Receipt Date (12)

Issue Date (13)

Revoked Date (14)

Reference (18)

VAT Bureau No. (19)

Document No. (50)

VAT Bus. Posting Group (54)

Obsolete

VAT Prod. Posting Group (55)

Is Valid (70)

Declaration Type (109)

Amount (LCY) (110)

Used Amount (LCY) (111)

Amount Curr. Document (LCY) (112)

Purchasing/Importation (200)

Integr. Sending Protocol 1 (205)

Integr. Sending Protocol 2 (206)

Sending Protocol 1 (207)

Sending Protocol 2 (208)

Plafond Type (210)

Last Export Date (211)

Annual VAT Statement Submitted (212)

Exports (220)

Intra-Community Services (221)

Services to San Marino (222)

Assimilated Operations (223)

Extra-ordinary Operations (224)

Old Entry No. (500)

Methods

FilterByDocument

Parameters / Return Value

FilterByDocument

Parameters / Return Value

FilterByDocument

Parameters / Return Value

ChangeStatus

Parameters / Return Value

CalcUsedAmount

Parameters / Return Value

IsValidFor

Parameters / Return Value

IsValidFor

Parameters / Return Value

GetCustVendorName

Parameters / Return Value

GetVATRegistrationNo

Parameters / Return Value

AddToBuffer

Parameters / Return Value

IsCustAuthVendor

Parameters / Return Value

GetVatIdentifier

Parameters / Return Value

VatEntryTypeToType

Parameters / Return Value

Events

OnAfterSetDocumentFilters

Parameters / Return Value

OnAfterCheckVATExemptionValid

Parameters / Return Value

OnAfterChangeStatus

Parameters / Return Value

OnBeforeChangeStatus

Parameters / Return Value

OnBeforeCalcUsedAmount

Parameters / Return Value

OnAfterCalcUsedAmount

Parameters / Return Value

Feedback

Type (`1`)

No. (`2`)

Source No. (`3`)

Status (`5`)

Description (`6`)

Starting Date (`10`)

Ending Date (`11`)

Receipt Date (`12`)

Issue Date (`13`)

Revoked Date (`14`)

Reference (`18`)

VAT Bureau No. (`19`)

Document No. (`50`)

VAT Bus. Posting Group (`54`)

VAT Prod. Posting Group (`55`)

Is Valid (`70`)

Declaration Type (`109`)

Amount (LCY) (`110`)

Used Amount (LCY) (`111`)

Amount Curr. Document (LCY) (`112`)

Purchasing/Importation (`200`)

Integr. Sending Protocol 1 (`205`)

Integr. Sending Protocol 2 (`206`)

Sending Protocol 1 (`207`)

Sending Protocol 2 (`208`)

Plafond Type (`210`)

Last Export Date (`211`)

Annual VAT Statement Submitted (`212`)

Exports (`220`)

Intra-Community Services (`221`)

Services to San Marino (`222`)

Assimilated Operations (`223`)

Extra-ordinary Operations (`224`)

Old Entry No. (`500`)