Relevé 2 XML and Audit File Build (P07775X)

Processing Option	Processing Options Requiring Further Description
1. Enter the Workfile ID for the Relevé Processing cycle (Mandatory)	Enter the workfile ID you use to create the Relevé workfile on Canadian Year End Processing (G77247).
2. Enter the Type of Package (Mandatory) 1-Original file 4-Amended file 6-Cancelled file	This processing option relates to the XML Transmitter Record. The type of package that you send to Revenu Québec. The valid values are set by Revenu Québec. 1 - Original Data 4 - Amended file 6 - Cancelled file
3. Enter the Source of Relevé Slips used (Mandatory) A - Revenu Québec B - Facsimiles from a third party C - Facsimiles produced by the transmitter D - Any combination of the above	This processing option relates to the XML Transmitter Record. Indicate the source from which you obtained the slips to print the physical Relevé slips. A - Revenu Québec B - Facsimiles from a third party C - Facsimiles produced by the transmitter D - Any combination of the above
4. Enter the Transmitter Number (Mandatory) Pos 1-2 = NP Pos 3-8 = 999999 (6-digit number) You must ask Revenu Québec to assign you this number.	This processing option relates to the XML Transmitter Record. This number identifies the person who prepares and sends the data files. The first two characters are always NP followed by six digits. Revenu Québec assigns this number. Pos 1-2 = NP Pos 3-8 = 999999 (6-digit number)
5. Enter the Type of Transmitter (Optional) 1 - Filing for yourself 2 - Filing on behalf of other filers 3 - Filing for yourself and on and on behalf of other filers	This processing option relates to the XML Transmitter Record. The type of transmitter that is preparing and submitting the data files. The valid values are set by Revenu Québec. 1 - Filing for yourself 2 - Filing on behalf of other filers 3 - Filing for yourself and on behalf of other filers
6. Enter the Transmitter Company Number (Mandatory)	This processing option relates to the XML Transmitter Record. The company Address Book number is the transmitter's company number in the Address Book tables and the system uses it to retrieve the name and address information for the Transmitter Record. The system uses the company number to retrieve the company name from the Address Book Who's Who file (F0111). The system also uses the company number to retrieve the most current address from the Address by Date file (F0116). The value you enter must be a valid record in the Address Book.
7. Enter the Québec Enterprise Number (NEQ) as assigned by the Registraire des enterprises (REQ) or clerk of the Superior Court (10 Numeric-Optional)	This number relates to the XML Total Record for the Employer for each group of Relevé slips.
COMPUTER CONTACT (All Optional)	The contact information for the transmitter's Computer resource person. Revenu Québec uses this information to contact the transmitter concerning any issues or information regarding the data in the XML file.
8. Name (Last followed by first and omitting title-Example: Smith, John)	This processing option relates to the XML Transmitter Record. Name (Last followed by first and omitting title - Example: Smith Jon)
9. Area Code	This processing option relates to the XML Transmitter Record. Area Code
10. Telephone Number - Example: 334-4000	This processing option relates to the XML Transmitter Record. Telephone Number - Example: 334-4000
11. 7 digit extension - Example: 41234	This processing option relates to the XML Transmitter Record. 7 digit extension - Example: 41234
12. Preferred Language A = English F = French	This processing option relates to the XML Transmitter Record. Preferred Language A = English F = French
ACCOUNTING CONTACT (All Optional)	The contact information for the transmitter's Accounting resource person. Revenu Québec uses this information to contact the transmitter concerning any issues or information regarding the data in the XML file, for example, the amounts in the file.
13. Name (Last followed by first and omitting title-Example: Smith, John)	This processing option relates to the XML Transmitter Record. Name (Last followed by first and omitting title - Example: Smith Jon)
14. Area Code	This processing option relates to the XML Transmitter Record. Area Code
15. Telephone Number - Example: 334-4000	This processing option relates to the XML Transmitter Record. Telephone Number - Example: 334-4000
16. 7 digit extension - Example: 41234	This processing option relates to the XML Transmitter Record. 7 digit extension - Example: 41234
17. Preferred Language A = English F = French	This processing option relates to the XML Transmitter Record. Preferred Language A = English F = French
18. Software company certification number. Assigned by Revenu Québec. 12 alphanumeric and formatted as follows: RQ-00-99-999 where RQ = Revenu Québec 00 = Taxation year for which software was certified 99 = Relevé form ('01' or '02') 999 = Software Developer identification number. Oracle is assigned a new # each year so check Oracle World Support Website or contact GSC for the value to enter.	You must enter this number as RQ-00-99-999 (12 alphanumeric). RQ = Revenu Québec 00 = Taxation year for which software was approved 99 = Type of Relevé slip 999 = Software Developer identification number This is the number Revenu Québec issues to the developer of the XML file, for example Oracle, when they certify the software. Oracle receives a new number every year in late December or January, after the release of the year-end update and you must check the My Oracle Support website or contact GCS for the value you must enter.
19. What country does the blank value stand for in UDC 00/CN? 1 = Canada (Default) 2 = United States 3 = Other	In the Address Book Revisions program, you can leave the Country field blank and the system determines the value based a blank value in UDC 00/CN. If a company is based in Canada, most likely the default value of blank represents Canada. If a company is based in the United States, most likely the default value of blank represents the US. JD Edwards World examines the province, state, and country values according to Revenu Québec's schema information, therefore, it is necessary to determine what the blank value represents in UDC 00/CN for the Address Book records.
20. Enter the type of character set to use to save your XML file: 1 = Windows-1252 (Default) 2 = ISO-8859-1	This processing option relates to the very first line in the XML file known as the Declaration. Example: <?xml version="1.0" encoding="ISO-8859-1" ?> The XML Declaration indicates the version of XML you use in the XML document and the character set. The value system inserts the value you enter in the XML Declaration of the XML document you create. The only two values that you should use are: Windows-1252 and ISO-8859-1.
XML FILE INFORMATION
21. Enter the IFS path to where the XML file to be extracted. If blank, the user will need to use FTP to extract the file. Example: /HOME/RL2XML/	Enter the Integrated File System (IFS) path where the system places the Relevé 2 XML Workfile (T07775X). This is the file the system extracts into the true XML document which you transmit to the CRA. For example: /home/userid/OR /home/rl2xml/ Using IFS requires additional setup. See Work with Import/Export in the Technical Foundation Guide. If you leave this processing option blank, you use the File Transfer Protocol (FTP) method for extracting the file. Access the XML Processing menu (G772475), choose Transfer XML Files(s) to PC, and review the instructions.
22. Enter the file name for the XML file to be extracted. Do not use spaces or special characters, except an underscore. Example: yy999999sss where yy = Tax Year, 999999 = Transmitter Number, and sss = a unique sequence number.	IFS File Name: Enter the file name for the XML file you want to extract. Do not use spaces or special characters, except an underscore. For example: 10NP999999001 where: 10 stands for the taxation year NP999999 stands for your transmitter number 001 stands for a unique sequence number. If you leave this processing option blank and enter a value in the IFS Path processing option, the system derives the XML file name as follows: 10NP9999001 where: 10 is the taxation year NP999999 is the transmitter number you enter in the Transmitter Number processing option 001 is the sequence number. For example: 10NP123456001
23. Enter the email address of the person responsible for the XML file. The email is limited to 60 characters. Anything after 60 will be truncated. (Optional)	Enter the email address of the person who is responsible for creating the XML file. This allows Revenu Québec to expedite the processing of your file. In the majority of cases, this is the email address for the name of person you enter in the Name processing options under Computer/Accounting Resource. This information allows Revenu Québec to contact the person by email.
24. Enter the desired language of communication by email. (Optional) A = English F = French	Enter the language preference of the person in the email address that is responsible for creating the XML file. Valid values are: A = English F = French

Processing Option

Processing Options Requiring Further Description

1. Enter the Workfile ID for the Relevé Processing cycle (Mandatory)

Enter the workfile ID you use to create the Relevé workfile on Canadian Year End Processing (G77247).

2. Enter the Type of Package (Mandatory)

1-Original file

4-Amended file

6-Cancelled file

This processing option relates to the XML Transmitter Record.

The type of package that you send to Revenu Québec. The valid values are set by Revenu Québec.

1 - Original Data

4 - Amended file

6 - Cancelled file

3. Enter the Source of Relevé Slips used (Mandatory)

A - Revenu Québec

B - Facsimiles from a third party

C - Facsimiles produced by the transmitter

D - Any combination of the above

This processing option relates to the XML Transmitter Record.

Indicate the source from which you obtained the slips to print the physical Relevé slips.

A - Revenu Québec

B - Facsimiles from a third party

C - Facsimiles produced by the transmitter

D - Any combination of the above

4. Enter the Transmitter Number (Mandatory) Pos 1-2 = NP Pos 3-8 = 999999 (6-digit number) You must ask Revenu Québec to assign you this number.

This processing option relates to the XML Transmitter Record.

This number identifies the person who prepares and sends the data files. The first two characters are always NP followed by six digits. Revenu Québec assigns this number.

Pos 1-2 = NP

Pos 3-8 = 999999 (6-digit number)

5. Enter the Type of Transmitter (Optional)

1 - Filing for yourself

2 - Filing on behalf of other filers

3 - Filing for yourself and on and on behalf of other filers

This processing option relates to the XML Transmitter Record.

The type of transmitter that is preparing and submitting the data files. The valid values are set by Revenu Québec.

1 - Filing for yourself

2 - Filing on behalf of other filers

3 - Filing for yourself and on behalf of other filers

6. Enter the Transmitter Company Number (Mandatory)

This processing option relates to the XML Transmitter Record.

The company Address Book number is the transmitter's company number in the Address Book tables and the system uses it to retrieve the name and address information for the Transmitter Record.

The system uses the company number to retrieve the company name from the Address Book Who's Who file (F0111).

The system also uses the company number to retrieve the most current address from the Address by Date file (F0116).

The value you enter must be a valid record in the Address Book.

7. Enter the Québec Enterprise Number (NEQ) as assigned by the Registraire des enterprises (REQ) or clerk of the Superior Court (10 Numeric-Optional)

This number relates to the XML Total Record for the Employer for each group of Relevé slips.

COMPUTER CONTACT (All Optional)

The contact information for the transmitter's Computer resource person.

Revenu Québec uses this information to contact the transmitter concerning any issues or information regarding the data in the XML file.

8. Name (Last followed by first and omitting title-Example: Smith, John)

This processing option relates to the XML Transmitter Record.

Name (Last followed by first and omitting title - Example: Smith Jon)

9. Area Code

This processing option relates to the XML Transmitter Record.

Area Code

10. Telephone Number - Example: 334-4000

This processing option relates to the XML Transmitter Record.

Telephone Number - Example: 334-4000

11. 7 digit extension - Example: 41234

This processing option relates to the XML Transmitter Record.

7 digit extension - Example: 41234

12. Preferred Language

A = English

F = French

This processing option relates to the XML Transmitter Record.

Preferred Language

A = English

F = French

ACCOUNTING CONTACT (All Optional)

The contact information for the transmitter's Accounting resource person.

Revenu Québec uses this information to contact the transmitter concerning any issues or information regarding the data in the XML file, for example, the amounts in the file.

13. Name (Last followed by first and omitting title-Example: Smith, John)

This processing option relates to the XML Transmitter Record.

Name (Last followed by first and omitting title - Example: Smith Jon)

14. Area Code

This processing option relates to the XML Transmitter Record.

Area Code

15. Telephone Number - Example: 334-4000

This processing option relates to the XML Transmitter Record.

Telephone Number - Example: 334-4000

16. 7 digit extension - Example: 41234

This processing option relates to the XML Transmitter Record.

7 digit extension - Example: 41234

17. Preferred Language

A = English

F = French

This processing option relates to the XML Transmitter Record.

Preferred Language

A = English

F = French

18. Software company certification number. Assigned by Revenu Québec.

12 alphanumeric and formatted as follows: RQ-00-99-999 where

RQ = Revenu Québec

00 = Taxation year for which software was certified

99 = Relevé form ('01' or '02')

999 = Software Developer identification number. Oracle is assigned a new # each year so check Oracle World Support Website or contact GSC for the value to enter.

You must enter this number as RQ-00-99-999 (12 alphanumeric).

RQ = Revenu Québec

00 = Taxation year for which software was approved

99 = Type of Relevé slip

999 = Software Developer identification number

This is the number Revenu Québec issues to the developer of the XML file, for example Oracle, when they certify the software.

Oracle receives a new number every year in late December or January, after the release of the year-end update and you must check the My Oracle Support website or contact GCS for the value you must enter.

19. What country does the blank value stand for in UDC 00/CN?

1 = Canada (Default)

2 = United States

3 = Other

In the Address Book Revisions program, you can leave the Country field blank and the system determines the value based a blank value in UDC 00/CN.

If a company is based in Canada, most likely the default value of blank represents Canada.

If a company is based in the United States, most likely the default value of blank represents the US.

JD Edwards World examines the province, state, and country values according to Revenu Québec's schema information, therefore, it is necessary to determine what the blank value represents in UDC 00/CN for the Address Book records.

20. Enter the type of character set to use to save your XML file:

1 = Windows-1252 (Default)

2 = ISO-8859-1

This processing option relates to the very first line in the XML file known as the Declaration. Example: <?xml version="1.0" encoding="ISO-8859-1" ?>

The XML Declaration indicates the version of XML you use in the XML document and the character set.

The value system inserts the value you enter in the XML Declaration of the XML document you create.

The only two values that you should use are: Windows-1252 and ISO-8859-1.

XML FILE INFORMATION

21. Enter the IFS path to where the XML file to be extracted. If blank, the user will need to use FTP to extract the file. Example: /HOME/RL2XML/

Enter the Integrated File System (IFS) path where the system places the Relevé 2 XML Workfile (T07775X). This is the file the system extracts into the true XML document which you transmit to the CRA. For example: /home/userid/OR /home/rl2xml/

Using IFS requires additional setup. See Work with Import/Export in the Technical Foundation Guide.

If you leave this processing option blank, you use the File Transfer Protocol (FTP) method for extracting the file. Access the XML Processing menu (G772475), choose Transfer XML Files(s) to PC, and review the instructions.

22. Enter the file name for the XML file to be extracted. Do not use spaces or special characters, except an underscore. Example: yy999999sss where yy = Tax Year, 999999 = Transmitter Number, and sss = a unique sequence number.

IFS File Name:

Enter the file name for the XML file you want to extract. Do not use spaces or special characters, except an underscore.

For example: 10NP999999001 where: 10 stands for the taxation year NP999999 stands for your transmitter number 001 stands for a unique sequence number.

If you leave this processing option blank and enter a value in the IFS Path processing option, the system derives the XML file name as follows:

10NP9999001 where: 10 is the taxation year NP999999 is the transmitter number you enter in the Transmitter Number processing option 001 is the sequence number. For example: 10NP123456001

23. Enter the email address of the person responsible for the XML file. The email is limited to 60 characters. Anything after 60 will be truncated. (Optional)

Enter the email address of the person who is responsible for creating the XML file. This allows Revenu Québec to expedite the processing of your file.

In the majority of cases, this is the email address for the name of person you enter in the Name processing options under Computer/Accounting Resource. This information allows Revenu Québec to contact the person by email.

24. Enter the desired language of communication by email. (Optional)

A = English

F = French

Enter the language preference of the person in the email address that is responsible for creating the XML file.

Valid values are:

A = English

F = French