Create Table Portfolio_FundClasses(
                                    PFC_Sequence integer Identity(1,1) NOT NULL,
                                    PFC_PortfolioId Varchar(20) NOT NULL,
                                    PFC_EffectiveDate datetime NOT NULL,
                                    PFC_FundClass Varchar(1) NOT NULL,
                                    PFC_ClassDescription varchar(50) NULL,
                                    PFC_FundSymbol VarChar(15) Null,
                                    PFC_MaxLeverageFactor real NULL,
                                    PFC_MgmtExpensePct real NULL,
                                    PFC_MgmtExpSweepFreq tinyint default 0 NULL,
                                    PFC_AdminExpenseFactor real NULL,
                                    PFC_AdminExpSweepFreq tinyint default 0 NULL,
                                    PFC_PerAcctCharge real NULL,
                                    PFC_PerAcctChargeFreq tinyint default 0 NULL,
                                    PFC_AcctChargeWaiverLevel Money default 0 NULL,
                                    PFC_EntryLoadPct real NULL,
                                    PFC_ExitLoadPct real NULL,
                                    PFC_FreeExitHoldDays real NULL,
                                    PFC_FundAcctgNAVdecimal tinyint null default 3,
                                    PFC_FundAcctgQtydecimal tinyint null default 3,
                                    PFC_FundAcctgParticipant integer null  default 0,
                                    PFC_DistribIncomeFreq tinyint null default 0,
                                    PFC_DistribRealizedGainsFreq tinyint null default 0,
                                    PFC_DistribShareBasis tinyint null default 0,
                                    PFC_UseFundIncomeRecords bit null default 0,
                                    PFC_AllocIncomeOnBydSlw bit null default 0,
                                    PFC_AllocURGainsOnBydSlw bit null default 0,
                                    PFC_IncentFeeMethod tinyint null default 0,
                                    PFC_IncentFeeBasePct Real null default 0,
                                    PFC_IncentFeePct Real null default 0,
                                    PFC_IncentFeeFreq tinyint null  default 0,
                                    PFC_IncentFeeTac VarChar(3) Null,
                                    PFC_IncentFeeDateOffset tinyint null default 0,
                                    PFC_MgmtFeeMethod tinyint null default 0,
                                    PFC_MgmtFeePct Real null default 0,
                                    PFC_MgmtFeeFreq tinyint null default 0,
                                    PFC_MgmtFeeTAC VarChar(3) Null,
                                    PFC_MgmtFeeDateOffset tinyint null default 0,
                                    PFC_RepPctOfConcession Real null default 0,
                                    PFC_RepPctOfFees Real null default 0,
                                    PFC_RepPctOfCommis Real null default 0,
                                    PFC_UseTrustfundAcctg bit null default 0,
                                    PFC_TrustExpensePctofPrincip bit null default 0,
                                    PFC_TrustMFeePctOfPrincip bit null default 0,
                                    PFC_TrustAdmFeePctofPrincip bit null default 0,
                                    PFC_CustomCodes VarChar(50) Null,
                                    PFC_TempRecord bit null default 0,
                                    PFC_IsFrozen bit null default 0,
					PFC_PostFeesEtcSameDay bit null default 0,
					PFC_EqualizeMonths bit null default 0,
					PFC_UseAssignedFees bit null default 0,
					PFC_IProfitNetofFees bit null default 0,
					PFC_MaxSidePocketPct float null,
					PFC_GateDates VarChar(30) null,
					PFC_GatePercent float null,
					PFC_LockupMonths integer null,
                                    CONSTRAINT PK_Portfolio_FundClasses PRIMARY KEY NONCLUSTERED (PFC_Sequence)
                                  );

ALTER TABLE [dbo].[Portfolio_FundClasses] ADD
	CONSTRAINT [FK_Portfolio_FundClasses_Account_Details] FOREIGN KEY
	(
		[PFC_PortfolioId]
	) REFERENCES [dbo].[Account_Details] (
		[ADT_ClientAccountNumber]
	) ON DELETE CASCADE  ON UPDATE CASCADE

