vr_Shop

Updated November 27, 2025 15:05

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
City	City	nvarchar
Code	Shop Code	nvarchar
Country	Country	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Email	Email	nvarchar
FaxNumber	Fax Number	nvarchar
Id	Shop Id	int
LaborAccountCode	Labor Account Code	nvarchar
LaborAccountId	Labor Account Id	int	vr_account
LaborAccountName	LaborAccount Name	nvarchar
ManagerName	Manager Name	nvarchar
MaterialAccountCode	Material Account Code	nvarchar
MaterialAccountId	Material Account Id	int	vr_account
MaterialAccountName	Material Account Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Shop Name	nvarchar
OtherAccountCode	Other Account Code	nvarchar
OtherAccountId	Other Account Id	int	vr_account
OtherAccountName	Other Account Name	nvarchar
PhoneNumber	Phone Number	nvarchar
PurgeDate	Purge Date	datetime
RemotePrinterId	Remote Printer Id	int
RemotePrinterPrinter	Remote Printer	nvarchar
State	State	nvarchar
Zip	Zip Code	nvarchar