Relevé 1 XML and Audit File Build (P07770X)

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 and 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 behalf of other filers	This processing option relates to the XML Transmitter Record. Enter 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. You must identify the transmitter company submitting the XML file. 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. You must provide information concerning the employer along with the totals for the various boxes of the Relevé slips. This is the number the Registraire des entreprises (REQ) or the clerk of the Superior Court assigns each employer. This is 10 character numeric field. This is an optional field and the program only validates that you enter 10 numbers as JD Edwards World does not have a database of the valid values to verify. You must ensure that the data in this file is correct or Revenu Québec can reject it because it contains an invalid value.
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, Jon)	You must provide the name of the contact person for the transmitter. Name (Last followed by first and omitting title - Example: Smith Jon)
9. Area Code	You must provide the telephone numbers of the contact person for the transmitter. Area Code
10. Telephone Number - Example: 334-4000	Telephone Number - Example: 334-4000
11. 7 digit extension - Example: 41234	7 digit extension - Example: 41234
12. Preferred Language A = English F = French	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, Jon)	Name (Last followed by first and omitting title - Example: Smith Jon)
14. Area Code	Area Code
15. Telephone Number - Example: 334-4000	Telephone Number - Example: 334-4000
16. 7 digit extension - Example: 41234	7 digit extension - Example: 41234
17. Preferred Language A = English F = French	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 as well as 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/RL1XML/	Enter the Integrated File System (IFS) path where the system places the Relevé 1 XML Workfile (T07770X). 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)	Email address of the person responsible for the XML file 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. The allowed values are: A = English F = French
25. Enter the PPIP Employee Contribution (Premium) rate for the current year.	The PPIP Employee Premium rate for the current year. The amount in Box H should be equal to the calculated results of the PPIP Insurable Earnings reported in Box I multiplied by the PPIP Employee Contribution (Premium) rate for the current year. A variance of plus or minus $1.00 between the amount from payroll history and the amount calculated allows for rounding issues. This rate changes every year and should match the rate assigned to the DBA used to calculate the Employee portion of PPIP throughout the year.