Relevé 27 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 "R27"

 

Heading

Description

Type, Size

Comments & Examples

LASTNAME1

First recipient last name (type 1 & 4)

Text, 30

Required; type 1

FIRSTNAME1

First recipient first name (type 1 & 4)

Text, 30

 

INITIAL1

First recipient initial (type 1 & 4)

Text, 1

 

FIRSTINDIVIDUAL

Indicate first entity is individual (type 4)

Yes/No

 

LASTNAME2

Second recipient last name (type 4)

Text, 30

 

FIRSTNAME2

Second recipient first name (type 4)

Text, 30

 

INITIAL2

Second recipient initial (type 4)

Text, 1

 

SECONDINDIVIDUAL

Indicate second entity is individual (type 4)

Yes/No

 

NAME1

Recipient name, line 1 (type 2, 3, 4 & 5)

Text, 50

Required; type 2, 3, 4 & 5

NAME2

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

Text, 50

 

ADDRESS1

Address line 1

Text, 50

 

ADDRESS2

Address line 2

Text, 50

 

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.

TAXYEAR

Year

Text, 1

2023

SIN

Social insurance number

Text, 15

 

SIN2

Second recipient's social insurance number

Text, 15

 

RECTYPER27

Recipient type

Text, 1

1 - Individual

2 - Corporation

3 - Partnership

4 - Holder of a joint account or co-recipient of payments

5 - Consortium

 

NEQR27

Recipient's NEQ

Numeric, 10

 

NEQ2R27

Second recipient's NEQ

Numeric, 10

 

REFNO

Recipient's ID number

Numeric, 10

 

REFNO2

Second recipient's ID number

Numeric, 10

 

PAYMENTS

Contractual payments

Currency

 

SUBSIDIES

Subsidies

Currency

 

REPORTCODER27

Status of slip

Text, 1

R - Original,

A - Amended or

D - Cancelled

SERIAL

Relevé No. of paper slip

Numeric, 9

 

SERIALORIGINAL

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

Numeric, 9

 

SERIALMM

Relevé No. of XML slip

Numeric, 9

 

SERIALMMPREVIOUS

Relevé No. 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

One email address, or two separated by a semi-colon

OKTOEMAILSLIP

Permission granted to email slip

Yes/No

eForms Enterprise only

COMPANY.NAME1

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

CUSTOMFIELD

GUID or other unique identifier

Text, 50

eForms Enterprise only

CUSTOMPASSWORD

Password for recipient PDF slip

Text, 20

eForms Enterprise only