vr_HazardousMaterial

Updated November 25, 2025 16:01

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
AnnualUsage	Annual Usage	decimal
BillLading	Obsolete Column (No Longer Used)	nvarchar
CasNumber	CAS #	nvarchar
Category	Category	nvarchar
Characteristics	Hazard	nvarchar
CharacteristicsComments	User Precautions	nvarchar
ChemicalName	Chemical Name	nvarchar
ContainerCount	Container Count	decimal
ContainerType	Conatiner Type	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrentQuantity	Current Quantity	decimal
DateReceived	Date Received	datetime
DisposalReview	Review For Disposition	nvarchar
EmergencyNumber	Emergency Phone	nvarchar
ExpirationDate	Expiration Date	datetime
HazardousMaterialSubTypeCode	Hazardous Material SubType Code	nvarchar
HazardousMaterialSubTypeDescription	Hazardous Material SubType Description	nvarchar
HazardousMaterialSubTypeId	Hazardous Material SubType Id	int
HazardousMaterialTypeCode	Hazardous Material Type Code	nvarchar
HazardousMaterialTypeDescription	Hazardous Material Type Description	nvarchar
HazardousMaterialTypeId	Hazardous Material Type Id	int	vr_HazardousMaterialType
Id	Hazardous Material Id	int
IsDilute	Indicates if the Dilute Classification Radio Button is Selected or Not	bit
IsMixture	Indicates if the Mixture Classification Radio Button is Selected or Not	bit
IsMSDSOnFile	Indicates if the MSDS on File Checkbox is Checked or Not	bit
IsPure	Indicates if the Pure Classification Radio Button is Selected or Not	bit
IsToxic	Indicates if the Toxic Checkbox is Checked or Not	bit
Label	Label	nvarchar
LocationOfMSDS	MSDS Location	nvarchar
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
MaterialForm	Material Form	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Hazardous Material Name	nvarchar
QuantityOnHand	Quantity On Hand	decimal
ROWBINCOL	Obsolete Column (No Longer Used)	nvarchar
SiteCode	Site Code	nvarchar
SpillProcedure	Spill Precautions	nvarchar
TagNumber	Tag Number	nvarchar
TRANSPCOMP	Obsolete Column (No Longer Used)	nvarchar
TransporatationDate	Obsolete Column (No Longer Used)	datetime
UnitOfMeasure	Unit of Measure	nvarchar
Vendor	Vendor	nvarchar
VolumeOrWeight	Volume/Weight	nvarchar

Articles in this section