Skip to main content
Localizations

T5018ReportDetailsFilter

PX.Objects.Localizations.CARelease 2025.2

No summary is documented for this DAC in the release source.

Field NameTypeDisplay NameForeign 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.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated 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
datetimeFrom-
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
OrganizationIDDefault Navigation
intTransmitterOrganization
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.
RevisionDefault Navigation
nvarcharRevisionT5018MasterTable
Description:The revision number.
RevisionSubmitted
bitE-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
decimalThreshold Amount-
Description:The threshold amount that defines when to include the summarized row's total amount in the revision.
ToDate
datetimeTo-
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.
YearDefault Navigation
nvarcharT5018 Tax YearT5018MasterTable
Description:The year of the revision.