Localizations

T5018MasterTable

PX.Objects.Localizations.CARelease 2025.2

The master record of an organization's T5018 revision for a given year. The record is comprised of one or multiple records.

Select a row for its description 29 of 29 fields

	Field Name	Type	Display Name	Foreign Key
	`AcctName`	`nvarchar(60)`	Company Name	-
Description:The name of the organization account.
	`AddressLine1`	`nvarchar(30)`	Address Line 1	-
Description:Address line 1 of the organization.
	`AddressLine2`	`nvarchar(30)`	Address Line 2	-
Description:Address line 2 of the organization.
	`AreaCode`	`nvarchar(3)`	Contact Area Code	-
Description:The area code of the phone number of the organization's primary contact.
	`City`	`nvarchar(28)`	City	-
Description:The city of the organization.
	`Country`	`nvarchar(3)`	Country	-
Description:The country of the organization.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`Email`	`nvarchar(50)`	Email	-
Description:The email of the organization's primary contact.
	`ExtensionNbr`	`nvarchar(5)`	Extension Number	-
Description:The extension number for the organization's primary contact.
	`FilingType`	`nvarchar(50)`	Filing Type	-
Description:The filing type of the revision.
	`FromDate`	`datetime`	From	-
Description:The date of the year start.
	`Language`	`nvarchar(50)`	Language	-
Description:The primary language of the organization.
	`Name`	`nvarchar(22)`	Name	-
Description:The name of the organization's primary contact.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OrganizationID`Default Navigation	`int`	Transmitter	Organization
Description:The organization ID of the associated organization. The value of this field corresponds to the value of the Organization.OrganizationID field.
	`Phone`	`nvarchar(8)`	Phone	-
Description:The phone number of the organization's primary contact.
	`PostalCode`	`nvarchar(10)`	Postal Code	-
Description:The postal code of the organization.
	`ProgramNumber`	`nvarchar(15)`	Program Number	-
Description:The program number for the organization. The value of this field corresponds to the value of the T5018OrganizationSettings.ProgramNumber field.
	`Province`	`nvarchar(2)`	Province	-
Description:The province or state of the organization.
	`Revision`Default Navigation	`nvarchar(6)`	Revision	-
Description:The revision number.
	`RevisionSubmitted`	`bit`	E-File Submitted to CRA	-
Description:A Boolean value that indicates whether the revision has been submit to the CRA.
	`SecondEmail`	`nvarchar(50)`	Second Email	-
Description:The second email of the organization's primary contact.
	`SubmissionNo`	`nvarchar(8)`	Submission Number	-
Description:The submission number of the T5018 filing.
	`ThresholdAmount`	`decimal`	Threshold Amount	-
Description:The threshold amount that defines when to include the summarized row's total amount in the revision.
	`ToDate`	`datetime`	To	-
Description:The date of the year end.
	`TransmitterNumber`	`nvarchar(8)`	Transmitter Number	-
Description:The transmitter number for the organization. The value of this field corresponds to the value of the T5018OrganizationSettings.TransmitterNumber field.
	`Year`	`nvarchar(4)`	T5018 Tax Year	-
Description:The year of the revision.