Create Table Portfolio_FundAcctgShares(
                                  	PFS_Sequence integer Identity(1,1) NOT NULL,
                                  	PFS_PortfolioId Varchar(20) NOT NULL,
					PFS_Date datetime NOT NULL,
					PFS_FAccountNum Varchar(20) NOT NULL, 					
					PFS_AcctShares float Null,
					PFS_PercentOfFund float Null,
					PFS_NAV float Null,
					PFS_ValueAtNAV Money Null,
					PFS_CostBasis  Money Null,
					PFS_ProfitSinceInception Money Null,
					PFS_CurrentIncentBase Money Null,
					PFS_CurrentIncentHurdle Money Null,
					PFS_CurrentProfit Money Null,
					PFS_AccruedIncentFee Money Null,
					PFS_AccruedMgmtFee Money Null,
					PFS_AccruedExpenses Money Null,
					PFS_ValueAfterAccruals Money Null,
					PFS_PriorIncentFeeDate datetime Null,
					PFS_PriorMgmtFeeDate datetime Null,
					PFS_IncentFeesToPrior Money Null,
					PFS_MgmtFeesToPrior Money Null,
					PFS_Perturbed bit null, 					
					PFS_ProgCtrlBits integer null,
					PFS_TempRecord bit null  default 0,
 					PFS_IsFrozen bit null  default 0,
	                                CONSTRAINT PK_FundAcctgShares PRIMARY KEY CLUSTERED (PFS_Sequence)
                                  );

ALTER TABLE [dbo].[Portfolio_FundAcctgShares] ADD
	CONSTRAINT [FK_Portfolio_FundAcctgShares_Account_Details] FOREIGN KEY
	(
		[PFS_PortfolioId]
	) REFERENCES [dbo].[Account_Details] (
		[ADT_ClientAccountNumber]
	) ON DELETE CASCADE  ON UPDATE CASCADE
