Event Charges Table

Column Name Type Allow Nulls Notes
EventChargeID int No Unique ID
EventPricingID int No  
EventChargesName varchar(256) Yes  
EventChargesDesc varchar(256) Yes  
OrganizationID int No  
CampID int No  
EventID int No  
EventYear EventYear Yes  
DepartmentID int Yes  
CourseID int Yes  
RegionID int Yes  
UnitID int Yes  
PersonID int Yes  
PricingType varchar(128) Yes  
ItemID int Yes  
Price decimal(18, 2) Yes  
Quantity int Yes  
DiscountPercentage decimal(18, 2) Yes  
DiscountAmount decimal(18, 2) Yes  
TaxPercentage decimal(18, 2) Yes  
TaxAmount decimal(18, 2) Yes  
SurchargeAmount decimal(18, 2) Yes  
TotalAmount decimal(18, 2) Yes  
EventChargeType varchar(128) No  
OrderNumber varchar(128) Yes  
PaymentMethod varchar(128) Yes  
CreditCardAuthorizationNumber varchar(128) Yes  
CheckNumber varchar(128) Yes  
ElectronicPaymentAuthorizationNumber varchar(128) Yes  
Status varchar(128) Yes  
ActiveFlag varchar(1) No  
TransactionDate datetime No  
AssociatedEventChargeID int Yes  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No