Item Table

Column Name Type Allow Nulls Notes
ItemID int No Unique ID
ItemCode varchar(40) No  
ItemDesc varchar(256) Yes  
OrganizationID int No  
CampID int No  
EventID int No  
EventYear varchar(128) Yes  
DepartmentID int Yes  
CourseID int Yes  
RegionID int Yes  
UnitID int Yes  
ItemType varchar(128) No  
PricingType varchar(128) Yes  
ActiveFlag varchar(1) No  
ListPrice decimal(18, 2) Yes  
Quantity int Yes  
Taxable bit No  
TaxAmount decimal(18, 2) Yes  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No