BPM Country Reports

Belgium

This section describes the Belgium reports appendix.

Customer Listing Report — XML Schema

The purpose of the XML data export is to produce the statutory XML file for submitting customer listing data to authorities. The following table illustrates the XML file that is produced.

Tags Description
<?xml version="1.0" encoding="ISO-8859-1"?>
<ClientListingConsignment
xmlns="http:// www.minfin.fgov.be/ ClientListingConsignment"
xmlns:iso="http://www.minfin.fgov.be/ IsoTypes"
xmlns:common="http://www.minfin.fgov.be/InputCommon"
targetNamespace= "http://www.minfin.fgov.be/ClientListingConsignment"
ClientListingNbr = "5"> The number of customers in this declaration.
<Representative> The data about the company filling the declaration.
<RepresentativeID> The ID of the representative.
issuedBy = "BE" The ISO country code of member state, which has signed the identifier.
identificationType = "TIN" The type of identification: NVAT, TIN or other.

We shall only use the type TIN.

<Name> The name of the company.
<Street> The street in the address of the company.
<PostCode> Postal code in the address of the company.
<City> City of the company.
<CountryCode> ISO country code of the company.
<EmailAddress> Email address of the company.
<Phone> Phone number of the company.
</Representative>
<ClientListing>
SequenceNumber = "1" The sequence number in the list of customers (starting with 1).
ClientsNbr = "5" The number of customers listed.
TurnOverSum = The sum of turnover (excluding VAT) for all customers.

Signed amount expressed in EUR at the nearest Eurocent.

VATAmountSum = The Sum of VAT amounts for all customers.

Signed amount expressed in EUR at the nearest Eurocent.

<Declarant> Information about the customer for which the declaration is about.
<VATNumber> Tax number of the customer.
<Name> Name of the customer.
<Street> Street in address of the customer.
<PostCode> Postal code of the customer's address.
<City> City of the customer.
<CountryCode> The ISO country code of the member state of the customer.
<EmailAddress> Email address of the customer.
<Phone> Phone number of the customer.
</Declarant>
<Period> Period covered by listing - always full year in format YYYY.
<TurnOver> Signed amount expressed in EUR to the nearest Eurocent.
<Client>
SequenceNumber = 1 The sequence number of customers in the list of customers.
<CompanyVATNumber> Tax number of the customer.
issuedBy = ISO country code of the member state of the customer.
<TurnOver> Turnover (excluding VAT).

Signed amount expressed in EUR to the nearest Eurocent.

<VATAmount> VAT amount.

Signed amount expressed in EUR to the nearest Eurocent.

</Client>
</ClientListing>
<ClientListingConsignment>

Intra Community Listing Report — XML Schema

XML Export

The XML report is based on the XSD version 09.

Tags (attributes indented) Description
<?xml version="1.0" encoding="ISO-8859-1"?>
<IntraConsignment
xmlns="http://www.minfin.fgov.be/IntraConsignment"
xmlns:iso="http://www.minfin.fgov.be/IsoTypes"
xmlns:common="http://www.minfin.fgov.be/InputCommon"
targetNamespace="http://www.minfin.fgov.be/IntraConsignment"
IntraListingNbr = "5"> The number of intra listing <IntraListing> in this declaration.
<Representative> The data about the company filling the declaration.
<RepresentativeID> The ID of the representative.
issuedBy = "BE" The ISO country code of member state, which has signed the identifier.
identificationType = "TIN" The type of identification: NVAT, TIN or other.
<Name> The name of the company.
<Street> The street in address of the company.
<PostCode> The postal code in the address of the company.
<City> The city of the company.
<CountryCode> The ISO country code of the company.
<EmailAddress> The email address of the company.
<Phone> The phone number of the company.
</Representative>
<IntraListing>
SequenceNumber = "1" The sequence number of this intra listing starting with 1, and increments by 1.
ClientsNbr = "5" The number of intra customers <IntraClient> listed.
AmountSum = The sum of amounts for all customers.

Signed amount expressed in EUR to the nearest Eurocent.

<Declarant> The information about the customer for which the declaration is about.
<VATNumber> The tax number of the customer.
<Name> The name of the customer.
<Street> The street in the address of the customer.
<PostCode> The postal code of the customer's address.
<City> The city of the customer.
<CountryCode> The ISO country code of the member state of the customer.
<EmailAddress> The email address of the customer.
<Phone> The phone number of the customer.
</Declarant>
<Period> The period covered by listing.

Depending on whether the user answers quarter and month prompts in addition to the year prompt, the quarter and month tags may appear and filled out.

<Year> If the Year prompt is answered, this tag should be included and contain the value.

The format is YYYY.

<Quarter> If the Quarter prompt is answered, this tag should be included and contain the value.

The format is Q followed by the quarter number, for example, Q2.

Note: From the XSD, it is actually unclear what the format is. All we know is that it is four characters. We will use the above-mentioned format and have BDO validate it in the end.
<Month> If the Month prompt is answered, this tag should be included and contain the value.

The format is the name of the month up to 12 characters.
Note: It is actually not clear from the XSD whether we state the name of the months or something else. All we know is that it is up to 12 characters. We shall for now assume that it is the name of the months, for example, January and then, have BDO to validate. However, our month names are always in English, which could be a problem. Then, we need to hard code translation in the report.
<TurnOver> The signed amount expressed in EUR to the nearest Eurocent.
<IntraClient>
SequenceNumber = 1 The sequence number of this intra client starting with 1, and increments by 1.
<CompanyVATNumber> The tax number of the customer.
issuedBy = The ISO country code of the member state of the customer.
<TurnOver> The turnover (excluding VAT).

Signed amount expressed in EUR to the nearest Eurocent.

<VATAmount> The VAT amount.

Signed amount expressed in EUR to the nearest Eurocent.

</IntraClient>
</IntraListing>
<IntraConsignment>

XML Report Definitions

Tags Definition
<?xml version="1.0" encoding="ISO-8859-1"?>
<IntraConsignment
xmlns="http://www.minfin.fgov.be/IntraConsignment"
xmlns:iso="http://www.minfin.fgov.be/IsoTypes"
xmlns:common="http://www.minfin.fgov.be/InputCommon"
targetNamespace="http://www.minfin.fgov.be/IntraConsignment"
IntraListingNbr = "5"> Count the number of companies for which we list customers.

This should match the number of <IntraListing> tags below.

<Representative>
<RepresentativeID> Company / [Company No.]
issuedBy = "BE" Company / Contact Information / [Country ISO]
identificationType = "TIN" Hardcode to "TIN".
<Name> Company / [Company Name]
<Street> Company / Contact Information / [Name 2], [Name 2], Name 3], [Name 4], and [Name 5] concatenated with a space between.
<PostCode> Company / Contact Information / [ZIP-Code]
<City> Company / Contact Information / [Postal District]
<CountryCode> Company / Contact Information / [Country ISO]
<EmailAddress> Answers the value of the Representative E-mail Address prompt.
<Phone> Company / Contact Information / [Telephone]
</Representative>
<IntraListing>
SequenceNumber = "1" The sequence number of this intra listing starting with 1, and increments by 1.
ClientsNbr = "5" The total number of intra customers denoted by the <IntraClient> tag.
AmountSum = Summarizes all amounts of all declarants below.
<Declarant>
<VATNumber> Customer / [Customer Tax No.]
<Name> Customer / [Customer Name]
<Street> Customer / Contact Information / [Name 2], [Name 3], [Name 4] and [Name 5] concatenated with space between.
<PostCode> Customer / Contact Information / [ZIP Code]
<City> Customer / Contact Information / [Postal District]
<CountryCode> Customer / Contact Information / [Country ISO]
<EmailAddress> Customer / Contact Information / [E-mail]
<Phone> Customer / Contact Information / [Telephone]
</Declarant>
<Period>
<Year> Answers the value of the Year prompt.
<Quarter> Answers the value of the Quarter prompt, if answered.

If not answered, the tag should not appear.

<Month> Answers the value of the Month prompt, if answered.

If not answered, the tag should not appear.

<Amount> Sum of Settlement / Basis Amounts / Tax Basis / Tax Basis - Company of all customers below.
<IntraClient>
SequenceNumber = 1 The sequence number of this intra customer denoted by the <IntraClient> tag.

Starts with 1 and increments by 1.

<CompanyVATNumber> Customer / Customer Tax No.
issuedBy = Customer / Contact Information / Country ISO
<Amount> Settlement / Basis Amounts / Tax Basis / Tax Basis - Company summarized for the present customer.
</IntraClient>
</IntraListing>
<IntraConsignment>

Tax Declaration Report — XML Schema

XML Data Export

You can export the report in an XML format. The XML report is based on XSD version 09. The purpose of the XML data export is to produce the statutory XML file for submitting tax information to authorities.

Tags Description
<?xml version="1.0" encoding="ISO-8859-1"?>
<VATConsignment
xmlns="http:// www.minfin.fgov.be/VatConsignment"
xmlns:common="http://www.minfin.fgov.be/InputCommon"
targetNamespace=http://www.minfin.fgov.be/VatConsignment>
<VATDeclarationsNbr = "5"> Number of VAT declarations records in this declaration.
<Representative> Data about the company filling the declaration.
<RepresentativeID> ID of representative.
issuedBy = "BE" ISO country code of member state which has signed the identifier.
identificationType = "TIN" Type of identification: NVAT, TIN or other.
<Name> Name of the company.
<Street> Street in address of the company.
<PostCode> Postal code in address of the company.
<City> City of the company.
<CountryCode> ISO country code of the company.
<EmailAddress> Email address of the company.
<Phone> Phone number of the company.
</Representative>
<VATDeclaration>
SequenceNumber = "1" Sequence number in the list of declarations (starting with 1).
<Declarant> Information about the company for which the declaration is about.

This is usually the same company information as the <Representative>.

<VATNumber> Tax number of the company.
<Name> Name of the company.
<Street> Street in address of the company.
<PostCode> Postal code of the company's address.
<City> City of the company.
<CountryCode> ISO country code of the member state of the company.
<EmailAddress> Email address of the company (User input).
<Phone> Phone number of the company.
</Declarant>
<Period> Period covered by listing.

You have the ability to answer Year, Quarter and Month prompts.

<Year> If the Year prompt is answered, this tag is included and contain the value.

The format is YYYY.

<Quarter> If the Quarter prompt is answered, this tag should be included and contain the value.

The format is Q followed by the quarter number; e.g. "Q2".

<Month> If the Month prompt is answered, this tag should be included and contain the value.

The format is the name of the month up to 12 characters.

<Deduction>
<AdjustedPeriod> Period to which the pro rata relates (format is full year YYYY).
<AdjustedValue> Final deduction percentage for this period (format is integer between 1 and 100).
<Data>
<Amount The tax amount in EUR.
GridNumber = "00" The name of the field in which the value is to be entered in the tax declaration form.

The names are "00", "01", "02", "03", "44", "45", "46", "47", "48", 49", "54", "55", "56", "57", "59", "61", "62", "63", "64", "71", 72", "81", "82", "83", "84", "85", "86", "88", "91".

<ClientListingNihil> States the value "Yes" or "No" and concerns only the last civil declaration or that relating to the cessation of activity: no customers to take back on the list of the customers.
<Ask Claims related to the return (refund and payment forms).
Restitution="Yes" States the value "Yes" if requesting a refund; otherwise "No".
Payment="Yes"> States the value "Yes" if requesting a payment form; otherwise "No".

Troubleshooting

Background Task Timeout

Reports with large volumes of records take longer to process and the background task may timeout. To prevent timeout errors, you must change the character stream size to 2000 or higher (on the BO server console), and set the background task duration to more than 24 hours (on Maconomy).

Set Character Stream Size

To prevent timeouts while running the report, you must change the character stream size on the Business Objects (BO) Central Management Console (CMC) prior to running the report.

To change the character stream size:

  1. On the BO CMC, log in as an Administrator.
  2. Click Servers and select Server List.
  3. From the list of server names, click WebIntelligenceProcessingServer.
  4. Select Properties then edit the Maximum Character Stream Size (MB) field value, from 15 to at least 2000 or your preferred value up to 4095.
    Note: The recommended value when running the report is 2000.
  5. Click Save then close the dialog box.
  6. Right-click WebIntelligenceProcessingServer then select Restart Server.

Set Background Task Maximum Duration

Note: This section applies to the Workspace Client.

If the default maximum duration time (1440 minutes) is not enough to generate the report, you can change the maximum duration for the background task.

To change the maximum duration:

  1. Generate a report to start a background task.

    Click OK in the prompt.

  2. Go to Setup » Background Tasks » Status and locate your task. It should be at the top of the list.
    1. Select the task and click the Abort action button.
    2. Click OK in the prompt.
    3. Right-click the task (the status displays as Failed) and click Copy as Template.

      A new task should display at the top of the list (the status displays as Pending.)

  3. Go to the Editing tab then locate and double-click the pending task.
    Note: You may need to filter the list and show Inactive Pending Tasks.
    1. Edit the Max. Duration field to a higher value, such as 2880 for 48 hours.
    2. Click the Save » Activate action.
    3. Click OK in the prompt.
  4. Go to the Status tab and click the Refresh action button.

    The task should run and generate a report.

    Note: If the background task still fails, you need to adjust the maximum duration time to accommodate the amount of records.