vr_Vendor

Updated November 28, 2025 14:34

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
AccountTypeId	Account Type Id	int	vr_accountType
Active	Indicates if the Record is Active or Not	bit
AllowChangePersonalInfo	Allow Change Personal Info	bit
AlternateIdentity	Alternate Identity	nvarchar
AverageLeadTime	Average Lead Time	decimal
AverageVendorLeadTime	Average Vendor Lead Time	decimal
BlockPCard	Indicates if this Vendor blocks PCard transactions	bit
Code	Vendor Code	nvarchar
Comment	Comments	nvarchar
CompanySize	Company Size	int
Contact	Contact	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CreditLimit	Credit Limit	decimal
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
CustomerNumber	Customer Number	nvarchar
DiscountDay	Discount Day	int
DiscountPercentage	Discount Percentage	decimal
ECRICode	ECRI Code	int
Email	Email	nvarchar
HourlyRate	Hourly Rate	decimal
Id	Vendor Id	int
InsuranceAmount	Insurance Amount	decimal
InsuranceExpiration	Insurance Expiration	datetime
isBroker	Indicates if this Vendor is a Broker	bit
IsContractor	Indicates if this Vendor Is a Contractor	bit
IsManufacturer	Indicates if this Vendor Is a Manufacturer	bit
IsVendor	Indicates if this Vendor Is a Vendor	bit
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerName	Manufacturer Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Vendor Name	nvarchar
OrganizationUnit	Organization Unit	nvarchar
OTPTaxable	Indicates if this Vendor's one time purchases are taxable	bit
PurchaseOrderDate	Purchase Order Date	datetime
PurchaseOrderNumber	Purchase Order Number	nvarchar
Rating	Vendor Rating	nvarchar
SICCode	Standard Industrial Classification Code	nvarchar
TaxCode	Tax Code	nvarchar
TaxNumber	Tax Number	nvarchar
Term	Term	nvarchar
URL	URL	nvarchar
UserId	User Id	int	vr_users
VendorSubTypeCode	Vendor SubType Code	nvarchar
VendorSubTypeDescription	Vendor SubType Description	nvarchar
VendorSubTypeId	Vendor SubType Id	int
VendorTypeCode	Vendor Type Code	nvarchar
VendorTypeDescription	Vendor Type Description	nvarchar
VendorTypeId	Vendor Type Id	int	vr_VendorType

Articles in this section