Localizations
T4AMasterTable
The master record of an organization's T4A revision for a given year.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctNameNonexistent in DB | string | Company Name | - | |
Description:The name of the organization account. | ||||
AddressLine1Nonexistent in DB | string | Address Line 1 | - | |
Description:Address line 1 of the organization. | ||||
AddressLine2Nonexistent in DB | string | Address Line 2 | - | |
Description:Address line 2 of the organization. | ||||
AreaCodeNonexistent in DB | string | Contact Area Code | - | |
Description:The area code of the phone number of the organization's primary contact. | ||||
BranchID | int | Branch | ||
Description:The branch ID of associated payments. | ||||
CityNonexistent in DB | string | City | - | |
Description:The city of the organization. | ||||
CountryNonexistent in DB | string | Country | - | |
Description:The country of the organization. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
EmailNonexistent in DB | string | - | ||
Description:The email of the organization's primary contact. | ||||
ExtensionNbrNonexistent in DB | string | Extension Number | - | |
Description:The extension number for the organization's primary contact. | ||||
FilingTypeNonexistent in DB | string | Filing Type | - | |
Description:The filing type of the revision. | ||||
FromDateNonexistent in DB | DateTime? | From | - | |
Description:The date of the year start. | ||||
LanguageNonexistent in DB | string | Language | - | |
Description:The primary language of the organization. | ||||
NameNonexistent in DB | string | Name | - | |
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. | ||||
OrganizationID | 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. | ||||
PhoneNonexistent in DB | string | Phone | - | |
Description:The phone number of the organization's primary contact. | ||||
PostalCodeNonexistent in DB | string | Postal Code | - | |
Description:The postal code of the organization. | ||||
ProgramNumberNonexistent in DB | string | Program 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 | string | Province | - | |
Description:The province or state of the organization. | ||||
Revision | nvarchar(6) | - | ||
Description:The revision number. | ||||
RevisionSubmitted | bit | E-File Submitted to CRA | - | |
Description:A Boolean value that indicates whether the revision has been submitted to the CRA. | ||||
SecondEmailNonexistent in DB | string | 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 | - | ||
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 | string | Transmitter 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. | ||||