Fields for the Yearly Clients List N° 725 XML File
This table describes the XML elements included in the file output for the Belgium yearly VAT report and information about how each field is populated in the JD Edwards EnterpriseOne system.
The ClientListingConsignment element includes these elements:
Representative
RepresentativeID
RepresentativeReference
ClientListing
Level and Occurrence |
Element Name |
Attribute |
Description and Source |
|---|---|---|---|
Level: 1 Occurrence: 1 |
ClientListingConsignment |
xmlns xmlns:ns2 ClientListingsNbr |
This element contains the group of yearly client lists declarations uploaded by a representative. The xmlns and xmlns:ns2 attributes are fixed values. The ClientListingNbr attribute contains the number of ClientListing elements in the XML file. |
1.1 |
Representative |
The process obtains information about the representative from the address book record. You complete a processing option in the R74B150 program to specify the address book number of the representative. This element includes these elements:
|
|
Level: 1.1.1 Occurrence: 0 or 1 |
RepresentativeID |
Issued by IdentificationType OtherQlf |
The process populates this element with data from the F0101 table. The Issued by attribute includes the country of the representative. You complete a processing option in the R74B250A program to specify the value for the IdentificationType attribute. The OtherQlf attribute is optional and is not supported by the R74B150 program. |
Level: 1.1.2 Occurrence: 1 |
Name |
None |
The process obtains the representative's name from the address book record of the representative. |
Level: 1.1.3 Occurrence: 1 |
Street |
None |
The process obtains the representative's street from the address book record of the representative. |
Level: 1.1.4 Occurrence: 1 |
PostCode |
None |
The process obtains the representative's postal code from the address book record of the representative. |
Level: 1.1.5 Occurrence: 1 |
City |
None |
The process obtains the representative's city from the address book record of the representative. |
Level: 1.1.6 Occurrence: 1 |
CountryCode |
None |
The process obtains the value from the address book record of the representative, and validates the value against the 74/EC UDC table. If the country is not present in UDC 74/EC, the system sends an error message to the Work Center. If the system generates this error message, the system does not generate the XML file. |
Level: 1.1.7 Occurrence: 1 |
EmailAddress |
None |
The process obtains the representative's email address from the address book record of the representative. |
Level: 1.1.8 Occurrence: 1 |
Phone |
None |
The process obtains the representative's phone number from the address book record of the representative. |
Level: 1.2 Occurrence: 0 or 1 |
RepresentativeReference |
None |
The process obtains the representative reference from a processing option in the R74B150 program. |
Level: 1.3 Occurrence: 0 or 1 |
Client Listing |
SequenceNumber ClientNbr Declarant/Reference TurnOverSum AmountSum |
The ClientListing element includes these elements: ReplacedClientListing Declarant Period TurnOver Farmer Client FileAttachment Comment The system increments the SequenceNumber attribute by 1 for each ClientListing element included in the file. The ClientNbr attribute contains the total number of Client elements in the ClientListing element. The program completes the DeclarantReference attribute with the value that you set up for the company in the Belgium Company Additional Information program (P74B010). The TurnOverSum attribute is filled with the total number of TurnOver elements in the ClientListing element. The VATAmountSum attribute is filled with sum of the amounts in the ClientListing element. |
Level: 1.3.1 Occurrence 0 or 1 |
ReplacedClientListing |
None |
The program completes this element with the value from a processing option. |
Level: 1.3.2 Occurrence: 1 |
Declarant |
None |
The Declarant element includes the following elements: VATNumber Name Street PostCode City CountryCode EmailAddress Phone |
Level: 1.3.2.1 Occurrence: 1 |
VATNumber |
None |
The system completes this element with the value from TAX.F0101, excluding the country code. |
Level: 1.3.2.2 Occurrence: 0 or 1 |
Name |
None |
The system obtains the value for this field from the company's address book record. |
Level: 1.3.2.3 Occurrence: 0 or 1 |
Street |
None |
The system obtains the value for this field from the company's address book record. |
Level: 1.3.2.4 Occurrence: 0 or 1 |
PostCode |
None |
The system obtains the value for this field from the company's address book record. |
Level: 1.3.2.5 Occurrence: 0 or 1 |
City |
None |
The system obtains the value for this field from the company's address book record. |
Level: 1.3.2.6 Occurrence: 0 or 1 |
CountryCode |
None |
The system obtains the value for this field from the company's address book record. |
Level: 1.3.2.7 Occurrence: 0 or 1 |
EmailAddress |
None |
The system obtains the value for this field from the company's address book record. |
Level: 1.3.2.8 Occurrence: 0 or 1 |
Phone |
None |
The system obtains the value for this field from the company's address book record. |
Level: 1.3.3 Occurrence: 1 |
Period |
None |
The value for the element is determined by the date range that you enter in the processing options. |
Level: 1.3.4 Occurrence: 0 or 1 |
TurnOver |
None |
The system includes the sum of total amount taxable of all transactions for the client. |
Level: 1.3.5 Occurrence: 0 or 1 |
Farmer |
None |
The system completes this field based on the value that you enter in a processing option. |
Level: 1.3.6 Occurrence: 1 to many |
Client |
SequenceNumber |
The XML file includes this element for each client reported. The Client element includes these elements: CompanyVATNumber TurnOver VATAmount The system increments the value in the SequenceNumber attribute for each client reported. |
Level: 1.3.6.1 Occurrence: 1 |
CompanyVATNumber |
issuedBy |
This element includes the VAT number of the client. The issuedBy attribute includes the country code of the authority who issued the VAT number. |
Level: 1.3.6.2 Occurrence: 1 |
TurnOver |
None |
The system includes the sum of total amount taxable of all transactions for the client. |
Level: 1.3.6.3 Occurrence: 1 |
VATAmount |
None |
This element includes the total VAT taxable amount of the transactions for the client. |
Level1.3.7 Occurrence: 0 to many |
FileAttachment |
None |
The FileAttachment element includes these elements: FileType FileName FileDescription |
Level: 1.3.7.1 Occurrence: 1 |
FileType |
None |
The program completes this element with the value that you set up for the company in the Belgium Company Additional Information program (P74B010). |
Level: 1.3.7.2 Occurrence: 1 |
FileName |
None |
The program completes this element with the value that you set up for the company in the Belgium Company Additional Information program (P74B010). |
Level: 1.3.7.3 Occurrence: 0 or 1 |
FileDescription |
None |
The program completes this element with the value that you set up for the company in the Belgium Company Additional Information program (P74B010). |
Level: 1.3.8 Occurrence: 0 or 1 |
Comment |
None |
The program completes this element with the value that you set up for the company in the Belgium Company Additional Information program (P74B010). |