RL-32 Data Import Headings

Columns and rows containing “NULL” in their first cell will not be imported.

Column Heading	Description	Type & Size	Comments & Examples
LASTNAME	Recipient last name	Text, 30	Required
FIRSTNAME	Recipient first name	Text, 30
INITIAL	Recipient initial	Text, 1
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
TAXYEAR	Tax Year	Numeric, 4
TAXABLE	Taxable Amount	Currency
PAYMENTSAFTERDEATH	Payment to beneficiary after death of holder	Currency
LOANGUARANTEE	Loan guarantee	Currency
TAX	Québec income tax withheld at source	Currency
DEDUCTION	Amount giving entitlement to a deduction	Currency
SIN	Social insurance number	Text, 9
COUNTRY	Country, in address	Text, 3
SLIPSTATUS	Status of slip	Text, 1	O-Original A-Amended C-Cancelled
SERIAL	Sequential (Relevé) number of paper slip	Numeric, 9
SERIALMM	Sequential (Relevé) number of XML slip	Numeric, 9
SERIALMMPREVIOUS	Sequential (Relevé) number of previously-filed XML slip	Numeric, 9
SERIALORIGINAL	Sequential (Relevé) number of previously-filed paper slip (user-entered)	Numeric, 9
TEXTATTOP	Optional text to print at top of slip	Text, 15
EMAILADDRESS	Recipient email address; one email address, or two separated by a semi-colon	Text, 255
OKTOEMAILSLIP	Permission granted to email slip	Yes/No
COMPANY.NAME1	Company associated with slip	Text, 35
COMPANY.COMPANYTAG	Tag associated with company name	Text, 10
SLIPTAG	Subset tag	Text, 10
CUSTOMFIELD	GUID or other unique identifier	Text, 50
CUSTOMPASSWORD	Password for recipient PDF slip	Text, 20