T4 XML and Audit File Build (P07760X)

Processing Option	Processing Options Requiring Further Description
1. Enter the Workfile Id for the T4 Processing cycle.	Enter the workfile ID you use to create the T4 workfile on Canadian Year End Processing (G77247).
2. Enter the Transmitter Number Pos 1-2 = MM Pos 3-8 = 999999 (6-digit number) Your number is assigned by the CRA.	This processing option relates to the XML Transmitter Record. This value identifies the company that prepares and sends the data files. The first two characters are always MM; followed by six digits. The CRA assigns this number. Pos 1-2 = MM Pos 3-8 = 999999 (6-digit number)
3. Transmitter Company Address Number	This processing option relates to the XML Transmitter Record. You must identify the transmitter company sending 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.
4. Transmitter Language Preference E = English F = French	This processing option relates to the XML Transmitter Record. The primary language the transmitter uses for communication purposes. The values are either English (E) or French (F).
5. Enter the Social Insurance Number for Proprietor #1. (9 digits)	This processing option relates to the XML Employer Summary Record. In the summary records, you must provide information about the employer name and address as well as some total amounts and the SIN numbers of the proprietors/owners, if applicable. NOTE: If you are creating a submission that contains multiple employers, they all use these values. If you need to specify different values for each employer, you must run separate builds to create a separate submission for each. If the Employer is a Canadian-controlled private corporation or an unincorporated employer, then you must provide the Social Insurance Number (SIN) of any proprietors or principal owners. This is the SIN for the primary proprietor/owner. Use this SIN on all summary records for all employers in the XML build.
6. Enter the Social Insurance Number for Proprietor #2. (9 digits)	This processing option relates to the XML Employer Summary Record. In the summary records, you must provide information about the employer name and address as well as some total amounts and the SIN numbers of the proprietors/owners, if applicable. NOTE: If you are creating a submission that contains multiple employers, they all use these values. If you need to specify different values for each employer, you must run separate builds to create a separate submission for each. If the Employer is a Canadian-controlled private corporation or an unincorporated employer, then you must provide the Social Insurance Number (SIN) of any proprietors or principal owners. This is the SIN for the secondary proprietor/owner. Use this SIN on all summary records for all employers in the XML build.
7. Enter the T4 Report Type Code O = Original (Default) A = Amended	This processing option relates to the XML Transmitter Record. You must provide this information. The type of submission that you send to CRA. O = Original (Default) A = Amended
8. Submission Reference ID (unique 8 alphanumeric field created by transmitter for each submission)	This processing option relates to the XML Transmitter Record. You must provide this information. This is a unique value that the transmitter creates to identify each submission filed. Enter 8 alphanumeric characters.
9. Enter the Transmitter Type Indicator 1 = Filing for yourself 2 = Filing on behalf of other filers 3 = Filing for yourself using a purchased software package (Default) 4 = You are a software vendor	This processing option relates to the XML Transmitter Record. You must identify the type of package being sent. The type of transmitter that is preparing and sending the submission. The valid values are set by CRA. 1 – Filing for yourself. 2 – Filing on behalf of other filers. 3 – Filing for yourself using purchased software package (Default). 4 – You are a software vendor.
10. 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 retrieves the value based on a blank value in UDC 00/CN. If a company is based in Canada, most likely the blank default value represents Canada. If a company is based in the United States, most likely the blank default value represents the U.S. JD Edwards World examines the province, state, and country values according to CRA's schema information, therefore, it is necessary to determine what the blank value represents in UDC 00/CN for the Address Book records. 1 = Canada (Default) 2 = United States 3 = Other
CONTACT INFORMATION: NOTE: This information is used for the Transmitter and all Summary records.	The contact information for the transmitter. The CRA uses this information to contact the transmitter concerning any issues or information regarding the submission. The Transmitter and all Summary records use this information.
11. Name (First followed by surname and omit titles Example: John Smith)	This processing option relates to the XML Transmitter Record. You must provide the name of the contact person for the transmitter. Name (First followed by surname and omit titles Example: John Smith)
12. Area Code (3 digit number - 999)	This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter. Area code (3 digit number - 999)
13. Telephone Number Example: 334-4000	This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter. Telephone Number Example 334-4000
14. Extension (5 digit number - 99999)	This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter. Extension (5 digit number - 99999)
15. E-mail Address Example: jsmith@oracle.com	This processing option relates to the XML Transmitter Record. E-mail Address Example: jsmith@oracle.com
16. Enter the Detail Record Type A = Amended O = Original (Default) C = Canceled	This processing option relates to information that you report at the employee level. In most cases, this value will be the same as the value you enter in the Report Type Code processing option. CRA only allows for Report Type Codes of O (Original) and A (Amended). The Report Type Code is at the Employer level. If you want to cancel employee slips, you must use a Report Type Code of A but a Detail Record Type of C. An Amended return cannot contain an original slip. The allowed values are set by CRA as follows: Originals = O Amendments = A Cancel = C
17. 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 that you use in the XML document as well as the character set you use. The system inserts the value you enter here 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
18. 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/T4XML/	Enter the Integrated File System (IFS) path where the system places the T4 XML Workfile (T07760X). 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.
19. 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

Processing Option

Processing Options Requiring Further Description

1. Enter the Workfile Id for the T4 Processing cycle.

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

2. Enter the Transmitter Number Pos 1-2 = MM Pos 3-8 = 999999 (6-digit number) Your number is assigned by the CRA.

This processing option relates to the XML Transmitter Record.

This value identifies the company that prepares and sends the data files. The first two characters are always MM; followed by six digits. The CRA assigns this number.

Pos 1-2 = MM
Pos 3-8 = 999999 (6-digit number)

3. Transmitter Company Address Number

This processing option relates to the XML Transmitter Record. You must identify the transmitter company sending 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.

4. Transmitter Language Preference

E = English

F = French

This processing option relates to the XML Transmitter Record.

The primary language the transmitter uses for communication purposes.

The values are either English (E) or French (F).

5. Enter the Social Insurance Number for Proprietor #1. (9 digits)

This processing option relates to the XML Employer Summary Record. In the summary records, you must provide information about the employer name and address as well as some total amounts and the SIN numbers of the proprietors/owners, if applicable.

NOTE: If you are creating a submission that contains multiple employers, they all use these values. If you need to specify different values for each employer, you must run separate builds to create a separate submission for each.

If the Employer is a Canadian-controlled private corporation or an unincorporated employer, then you must provide the Social Insurance Number (SIN) of any proprietors or principal owners.

This is the SIN for the primary proprietor/owner.

Use this SIN on all summary records for all employers in the XML build.

6. Enter the Social Insurance Number for Proprietor #2. (9 digits)

If the Employer is a Canadian-controlled private corporation or an unincorporated employer, then you must provide the Social Insurance Number (SIN) of any proprietors or principal owners.

This is the SIN for the secondary proprietor/owner.

Use this SIN on all summary records for all employers in the XML build.

7. Enter the T4 Report Type Code

O = Original (Default)

A = Amended

This processing option relates to the XML Transmitter Record. You must provide this information.

The type of submission that you send to CRA.

O = Original (Default)
A = Amended

8. Submission Reference ID (unique 8 alphanumeric field created by transmitter for each submission)

This processing option relates to the XML Transmitter Record. You must provide this information.

This is a unique value that the transmitter creates to identify each submission filed.

Enter 8 alphanumeric characters.

9. Enter the Transmitter Type Indicator

1 = Filing for yourself

2 = Filing on behalf of other filers

3 = Filing for yourself using a purchased software package (Default)

4 = You are a software vendor

This processing option relates to the XML Transmitter Record. You must identify the type of package being sent.

The type of transmitter that is preparing and sending the submission.

The valid values are set by CRA.

1 – Filing for yourself.

2 – Filing on behalf of other filers.

3 – Filing for yourself using purchased software package (Default).

4 – You are a software vendor.

10. 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 retrieves the value based on a blank value in UDC 00/CN.

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

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

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

1 = Canada (Default)

2 = United States

3 = Other

CONTACT INFORMATION:

NOTE: This information is used for the Transmitter and all Summary records.

The contact information for the transmitter. The CRA uses this information to contact the transmitter concerning any issues or information regarding the submission.

The Transmitter and all Summary records use this information.

11. Name (First followed by surname and omit titles Example: John Smith)

This processing option relates to the XML Transmitter Record. You must provide the name of the contact person for the transmitter.

Name (First followed by surname and omit titles Example: John Smith)

12. Area Code (3 digit number - 999)

This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Area code (3 digit number - 999)

13. Telephone Number Example: 334-4000

This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Telephone Number Example 334-4000

14. Extension (5 digit number - 99999)

This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Extension (5 digit number - 99999)

15. E-mail Address

Example: jsmith@oracle.com

This processing option relates to the XML Transmitter Record.

E-mail Address Example: jsmith@oracle.com

16. Enter the Detail Record Type

A = Amended

O = Original (Default)

C = Canceled

This processing option relates to information that you report at the employee level.

In most cases, this value will be the same as the value you enter in the Report Type Code processing option.

CRA only allows for Report Type Codes of O (Original) and A (Amended). The Report Type Code is at the Employer level.

If you want to cancel employee slips, you must use a Report Type Code of A but a Detail Record Type of C.

An Amended return cannot contain an original slip.

The allowed values are set by CRA as follows:

Originals = O
Amendments = A
Cancel = C

17. 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 that you use in the XML document as well as the character set you use.

The system inserts the value you enter here 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

18. 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/T4XML/

Enter the Integrated File System (IFS) path where the system places the T4 XML Workfile (T07760X). 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.

19. 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