PR
PRTaxCode
Stores different tax codes associated with the work addresses and home addresses of the employees. The tax codes are sent to the system by a third-party provider and will be displayed on the Tax Maintenance (PR208000) form.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BAccountID | int | Vendor | Vendor | |
Description:No description available | ||||
CountryID | char(2) | Country | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Description | nvarchar(100) | Name | - | |
Description:No description available | ||||
ErrorLevelNonexistent in DB | int? | - | ||
Description:No description available | ||||
ExpenseAcctID | int | Expense Account | Account | |
Description:No description available | ||||
ExpenseSubID | int | Expense Sub. | Sub | |
Description:No description available | ||||
GovtRefNbr | nvarchar(30) | Employer Govt. Tax ID | - | |
Description:No description available | ||||
IsDeleted | bit | - | ||
Description:Indicates (if set to true) that the tax code was soft deleted. | ||||
JurisdictionLevel | char(3) | Jurisdiction Level | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LiabilityAcctID | int | Liability Account | Account | |
Description:No description available | ||||
LiabilitySubID | int | Liability Sub. | Sub | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
TaxCD | nvarchar(60) | Code | - | |
Description:No description available | ||||
TaxCategory | char(3) | Tax Category | - | |
Description:No description available | ||||
TaxID | int | - | ||
Description:No description available | ||||
TaxInvDescrType | varchar(3) | Invoice Description Source | - | |
Description:No description available | ||||
TaxState | char(2) | Tax State | State | |
Description:No description available | ||||
TaxTypeDescription | nvarchar(100) | Type | - | |
Description:No description available | ||||
TaxUniqueCode | nvarchar(30) | Tax Unique ID | - | |
Description:No description available | ||||
TypeName | nvarchar(50) | Type | PRTaxType | |
Description:No description available | ||||
VndInvDescr | nvarchar(60) | Vendor Invoice Description | - | |
Description:No description available | ||||