Headings for R17

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 "R17"

 

Heading

Description

Type, Size

Comments & Examples

LASTNAME1

First recipient last name

Text, 30

Required

FIRSTNAME1

First recipient first name

Text, 12

 

INITIAL1

First recipient initial

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.

YEAR

Year

Text, 1

2012

SIN

Social insurance number

Text, 9

 

REFERENCENUMBER

Employer reference number

Text, 15

 

DEDUCTION

Total deductions (A)

Currency

 

INCOMEYEAR

Total employment revenue (B)

Currency

 

INCOMESTAY

Total income for stay (C)

Currency

 

ALLOWANCEYEAR

Allowance in year (D)

Currency

 

ALLOWANCESTAY

Allowance for stay (E)

Currency

 

DAYSOUTSIDE

Days outside Canada (F)

Numeric, 5

No decimals

PERIODSOUTSIDE

Number of 30 day periods (G)

Numeric, 5

No decimals

DATEDEPARTURE

Departure date from Canada (H)

Date

Mmm. dd, yyyy (Apr. 1, 2012)

DATERETURN

Return date to Canada (I)

Date

Mmm. dd, yyyy (Apr. 1, 2012)

FOREIGNCOUNTRY

Name of foreign country (J)

Text, 20

 

SLIPSTATUS

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

OKTOEMAILSLIP

Permission granted to email slip

Yes/No

eForms Enterprise only

COMPANY.NAME1

Company associated with slip

Text, 30

eForms Enterprise only