vr_Warehouse

Updated November 28, 2025 14:39

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
AccountNumber	Account Number	nvarchar
Active	Indicates if the Record is Active or Not	bit
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
ApplyToManualPO	Apply To Manual PO	bit
ApplyToVirtualTransfer	Apply To Virtual Transfer	bit
AutoAccountCode	Auto Account Code	nvarchar
AutoAccountId	Auto Account Id	int	vr_account
AutoAccountName	Account Name	nvarchar
BarCoded	Indicates if this Warehouse is bar coded	bit
BillToAddress1	Bill To Address 1	nvarchar
BillToAddress2	Bill To Address 2	nvarchar
BillToCity	Bill To City	nvarchar
BillToCode	Bill To Code	nvarchar
BillToId	Bill To Id	int
BillToName	Bill To Name	nvarchar
BillToState	Bill To State	nvarchar
BillToTypeId	Bill To Type Id	int
BillToZip	Bill To Zip	nvarchar
City	City	nvarchar
Code	Warehouse Code	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DefaultPOEmail	Default PO Email	bit
DeliveryInstruction	Delivery Instruction	nvarchar
Email	Email	nvarchar
Fax	Fax	nvarchar
Id	Warehouse Id	int
LastTransferNumber	Last Transer Number	int
ManagerName	Manager Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
MostItemTaxable	Indicates if most item's are taxable	bit
Name	Warehouse Name	nvarchar
ParentCode	Parent Code	nvarchar
ParentId	Parent Id	int	vr_warehouse
ParentName	Parent Name	nvarchar
Phone	Phone	nvarchar
PhoneExtension	Phone Extenstion	nvarchar
PurgeDate	Purge Date	datetime
ShipToAddress1	Ship To Address 1	nvarchar
ShipToAddress2	Ship To Address 2	nvarchar
ShipToCity	Ship To City	nvarchar
ShipToCode	Ship To Code	nvarchar
ShipToId	Ship To Id	int
ShipToName	Ship To Name	nvarchar
ShipToState	Ship To State	nvarchar
ShipToTypeId	Ship To Type Id	int
ShipToZip	Ship To Zip	nvarchar
SquareFootage	Square Footage	decimal
State	State	nvarchar
TaxRateId	Tax Rate Id	int	vr_TaxRate
TaxRateName	Tax Rate Name	nvarchar
TransferInYTD	Transfer In Year To Date	decimal
TransferOutYTD	Transfer Out Year To Date	decimal
UsedMTD	Used Month to Date	decimal
UsedYTD	Used Year to Date	decimal
Virtual	Virtual	bit
Zip	Zip Code	nvarchar

Articles in this section