R25 Headings

FIRST TOPIC  BACK  PREVIOUS TOPIC  NEXT TOPIC

eForms Standard & Enterprise Only

 

Cell A1 (import from Excel) or the first data element (import from CSV) must contain "R25"

 

Heading

Description

Type, Size

Comments & Examples

NAME1

Beneficiary name line 1 (type 3, 4 & 5)

Text, 30

Required; type 3, 4 & 5

NAME1LINE2

Beneficiary name line 2 (type 3, 4 & 5)

Text, 30

 

LASTNAME1

First beneficiary last name (type 1, 2 & 6)

Text, 30

Required; type 1, 2 & 6

FIRSTNAME1

First beneficiary first name (type 1, 2 & 6)

Text, 30

 

INITIAL1

First beneficiary initial (type 1, 2 & 6)

Text, 1

 

LASTNAME2

Second beneficiary last name (type 2)

Text, 30

 

FIRSTNAME2

Second beneficiary first name (type 2)

Text, 30

 

INITIAL2

Second beneficiary initial (type 2)

Text, 1

 

ADDRESS1

Address line 1

Text, 30

 

ADDRESS2

Address line 2

Text, 30

 

CITY

City

Text, 28

 

PROV

Province code

Text, 2

 

POSTAL

Postal code (including space)

Text, 10

 

COUNTRY

Country, in address

Text, 3

CAN, USA, etc.

BENEFICIARYNUM

Employer assigned number

Text, 20

 

TRANSIT

Bank transit number

Text, 10

 

RECTYPE

Recipient type (23)

Text, 1

1 - Individual

2 - Joint account

3 - Corporation

4 - Association, trust, club or partnership

5 - Government or international org.

6 - Spouse of trust settlor or spouse

REPORTCODE

Status of slip

Text, 1

R - Original,

A - Amended or

D - Cancelled

SIN2

Second beneficiary SIN

Text, 9

 

ACTUALDIVIDENDS

Non-Eligible Dividend amount

Currency

 

ACTUALDIVIDENDS_E

Eligible Dividend amount

Currency

 

CAPGAINS

Total net Capital Gains

Currency

 

CAPGAINSEXEMPTION

Farm or small business capital gains

Currency

 

OTHER

QPP and other amounts

Currency

 

CANCELLED

Amounts cancelled

Currency

 

FOREIGNTAX

Income tax paid to a foreign government

Currency

 

QUEBECTAX

Québec income tax withheld

Currency

 

NAMESPRINCIPAL

Principal person who established trust deed

Text, 25

 

SIN

First beneficiary SIN

Text, 9

 

SERIAL

Relevé number of paper slip

Numeric, 9

 

SERIALORIGINAL

Relevé number of previously-filed paper slip (user-entered)

Numeric, 9

 

SERIALMM

Relevé number of XML slip

Numeric, 9

 

SERIALMMPREVIOUS

Relevé number of previously-filed XML slip

Numeric, 9

 

TEXTATTOP

Optional text to print at top of slip

Text, 15

 

EMAILADDRESS

Recipient email address

Text, 255

eForms Enterprise only

OKTOEMAILSLIP

Permission granted to email slip

Yes/No

eForms Enterprise only

COMPANY.NAME

Company associated with slip

Text, 35

eForms Enterprise only

COMPANY.COMPANYTAG

Tag associated with company name

Text, 10

eForms Enterprise only

SLIPTAG

Subset tag

Text, 10

eForms Enterprise only

Generic boxes where ## is two numerals (01 to 04):

XBOX##

Additional Information - Box ##: Box number

Text, 7

 

XAMT#

Additional information - Box ##: Currency data

Currency

 

XTXT##

Additional information - Box ##: Character data

Text, 20