Event Pricing Table

Column Name Type Allow Nulls Notes
EventPricingID int No Unique ID
EventPricingName varchar(256) Yes  
EventPricingDesc varchar(256) Yes  
OrganizationID int No  
CampID int    
EventID int No  
EventYear varchar(128) Yes  
DepartmentID int Yes  
CourseID int Yes  
RegionID int Yes  
UnitID int Yes  
ItemID int Yes  
PricingType varchar(128) Yes  
Price decimal(18, 2) No  
Quantity int No  
DiscountPercentage decimal(18, 2) Yes  
DiscountAmount decimal(18, 2) Yes  
TaxPercentage decimal(18, 2) Yes  
TaxAmount decimal(18, 2) Yes  
TotalAmount decimal(18, 2) Yes  
ActiveFlag varchar(1) No  
StartDate datetime Yes  
EndDate datetime Yes  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No