Create Table Portfolio_LocalSecurityList(
                                      PLS_Sequence integer Identity(1,1) NOT NULL,
                                      PLS_ClientAccountNumber Varchar(20) NOT NULL,
                                      PLS_Symbol Varchar(15) NOT NULL,
                                      PLS_AcctId Varchar(10) NULL,
                                      PLS_LoPrice real Null,
                                      PLS_HiPrice real Null,
                                      PLS_Distributions tinyint Null,
                                      PLS_MMFSymbol Varchar(15) Null,
                                      PLS_Allocation real Null,
                                      PLS_Description Varchar(80) Null,
                                      PLS_PeriodicWDFDates Varchar(8) Null,
                                      PLS_PeriodicWDFAmounts money Null,
				      PLS_FeeExclusionFactor real Null,
  				      PLS_ShrsExcludedFromFee real Null,
  				      PLS_TaxWithHoldPct real Null,
                                      PLS_LocalTaxFactor real Null,
                                      PLS_IsMarketIndex bit null default 0,
                                      PLS_IsPrimaryMarketIndex bit null default 0,
                                      PLS_NoROI bit null default 0,
                                      PLS_NoFee bit null default 0,
                                      PLS_NoTrade bit null default 0,
                                      PLS_LiquidFund bit null default 0,
                                      PLS_TempRecord bit null default 0,
                                      PLS_IsFrozen bit null default 0,
                                      PLS_FedTaxFactor real null,
                                      CONSTRAINT PK_Portfolio_LocalSecurityList PRIMARY KEY
                                      NONCLUSTERED (PLS_Sequence)
                                      );

ALTER TABLE [dbo].[Portfolio_LocalSecurityList] ADD
	CONSTRAINT [FK_Portfolio_LocalSecurityList_Account_Details] FOREIGN KEY
	(
		[PLS_ClientAccountNumber]
	) REFERENCES [dbo].[Account_Details] (
		[ADT_ClientAccountNumber]
	) ON DELETE CASCADE  ON UPDATE CASCADE

