Create Table Portfolio_Positions(
                                  PPO_Sequence integer Identity(1,1) NOT NULL,
                                  PPO_ClientAccountNumber Varchar(20) NOT NULL,
                                  PPO_Date datetime NOT NULL, 
                                  PPO_Symbol Varchar(15) NOT NULL,
              		          PPO_SortType VarChar(8) Null,
                                  PPO_RType SmallInt NOT Null,
                                  PPO_AcctID Varchar(10) Null,
                                  PPO_CashMargin Varchar(1) NOT Null,
                                  PPO_ShortLong Varchar(1) NOT Null,
                                  PPO_Strategy Varchar(1) Null,
                                  PPO_OptionExpDate datetime Null,
                                  PPO_ContractPrice float Null,
                                  PPO_Position float Null,
                                  PPO_MktPrice float Null,
                                  PPO_PriceFactor real Null,
              		          PPO_LocalAccrued money Null,
                                  PPO_LocValue money Null,
                                  PPO_XRate float Null,
                                  PPO_Accrued money Null,
                                  PPO_Value money Null,
                                  PPO_LocCost money Null,
                                  PPO_Cost money Null,
                                  PPO_CumAdditions money Null,
                                  PPO_CumRemovals money Null,
                                  PPO_UnSettledQty money Null,  
                                  PPO_UnSettledAmt money Null,
                                  PPO_PriceSource varchar(20),
                                  PPO_PriorPrice real Null,
                                  PPO_AftTaxPrdROI real Null,
                   		  PPO_StalePriceDays smallint Null,
                                  PPO_MarginFactor real Null,
                                  PPO_ProgCtrlBits integer null default 0,
                                  PPO_TempRecord bit null default 0,
                                  PPO_IsFrozen bit null default 0,
                                  PPO_Poolfactor float null,
                                  CONSTRAINT PK_Portfolio_Positions PRIMARY KEY NONCLUSTERED (PPO_Sequence)
                                  );

ALTER TABLE [dbo].[Portfolio_Positions] ADD
	CONSTRAINT [FK_Portfolio_Positions_Account_Details] FOREIGN KEY
	(
		[PPO_ClientAccountNumber]
	) REFERENCES [dbo].[Account_Details] (
		[ADT_ClientAccountNumber]
	) ON DELETE CASCADE  ON UPDATE CASCADE

