Skip to main content
Localizations

T4AMasterTable

PX.Objects.Localizations.CARelease 2025.2

The master record of an organization's T4A revision for a given year.

Field NameTypeDisplay NameForeign Key
AcctNameNonexistent in DB
stringCompany Name-
Description:The name of the organization account.
AddressLine1Nonexistent in DB
stringAddress Line 1-
Description:Address line 1 of the organization.
AddressLine2Nonexistent in DB
stringAddress Line 2-
Description:Address line 2 of the organization.
AreaCodeNonexistent in DB
stringContact Area Code-
Description:The area code of the phone number of the organization's primary contact.
BranchID
intBranch
Description:The branch ID of associated payments.
CityNonexistent in DB
stringCity-
Description:The city of the organization.
CountryNonexistent in DB
stringCountry-
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
EmailNonexistent in DB
stringEmail-
Description:The email of the organization's primary contact.
ExtensionNbrNonexistent in DB
stringExtension Number-
Description:The extension number for the organization's primary contact.
FilingTypeNonexistent in DB
stringFiling Type-
Description:The filing type of the revision.
FromDateNonexistent in DB
DateTime?From-
Description:The date of the year start.
LanguageNonexistent in DB
stringLanguage-
Description:The primary language of the organization.
NameNonexistent in DB
stringName-
Description:The name of the organization's primary contact.
NoteID
uniqueidentifier-
Description:No description available
OrgBAccountID
int-
Description:The business account ID of the organization referenced in T4AMasterTable.OrganizationID or of the branch referenced in T4AMasterTable.BranchID.
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.
PhoneNonexistent in DB
stringPhone-
Description:The phone number of the organization's primary contact.
PostalCodeNonexistent in DB
stringPostal Code-
Description:The postal code of the organization.
ProgramNumberNonexistent in DB
stringProgram Number-
Description:The program number for the organization. The value of this field corresponds to the value of the CanadianOrganizationSettings.ProgramNumber field.
ProvinceNonexistent in DB
stringProvince-
Description:The province or state of the organization.
RevisionDefault Navigation
nvarchar(6)-
Description:The revision number.
RevisionSubmitted
bitE-File Submitted to CRA-
Description:A Boolean value that indicates whether the revision has been submitted to the CRA.
SecondEmailNonexistent in DB
stringSecond 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-
Description:The threshold amount that defines when to include the summarized row's total amount in the revision.
ToDateNonexistent in DB
DateTime?To-
Description:The date of the year end.
TransmitterNumberNonexistent in DB
stringTransmitter Number-
Description:The transmitter number for the organization. The value of this field corresponds to the value of the T5018OrganizationSettings.TransmitterNumber field.
XmlCanceled
nvarchar(8000)-
Description:The canceled report data.
XmlData
nvarchar(8000)-
Description:The report data.
XmlVersion
nvarchar(8)-
Description:The XML version.
Year
nvarchar(4)Year-
Description:The year of the revision.