example FinanceColim1

////////////////////////////////////////////////////////////////////////
// Financial Data Warehousing

typeside Ty = literal {
	java_types	
		Integer = "java.lang.Integer"
		String = "java.lang.String"
		Double = "java.lang.Double"
		Boolean = "java.lang.String" 
		Date = "java.lang.String"
	java_constants
		Integer = "return java.lang.Integer.parseInt(input[0]);"
		String = "return input[0]"
		Double = "return java.lang.Double.parseDouble(input[0])"
		Boolean = "return input[0]" 
		Date = "return input[0]"
	java_functions
		keygen : Integer,Integer,Integer -> Integer = "return (2^input[0] * 3^input[1] * 5^input[2])"
}

////////////////////////////////////////////////////////////////////////

schema Client = literal : Ty {
	entities
		client
	attributes
		id : client -> Integer
		name description : client -> String
} 

instance ClientInstance = literal : Client {
     generators 
     	cc1 cc2 cc3 : client   	
     multi_equations 
     	id -> {cc1 1, cc2 2, cc3 3}
     	name -> {cc1 Tom, cc2 Dick, cc3 Harry}
     	description -> {cc1 "Tom Client", cc2 "Dick Client", cc3 "Harry Client"}
} 

////////////////////////////////////////////////////////////////////////

schema Portfolio = literal : Ty {
	entities
		strategy 
		portfolio
	foreign_keys			
		strategy : portfolio -> strategy
		parent : portfolio -> portfolio 
	path_equations
		portfolio.parent.parent = portfolio.parent 
	attributes			
		id : strategy -> Integer
		name description : strategy -> String
		id : portfolio -> Integer
		name description : portfolio -> String
		client_id strategy_id parent_id : portfolio -> Integer
	observation_equations
		forall p. p.strategy.id = p.strategy_id
		forall p. p.parent.id = p.parent_id 
} 

instance PortfolioInstance = literal : Portfolio {
    generators 
     	ps1 ps2 ps3 : strategy 
     	pp1 pp2 pp3 : portfolio
	multi_equations
		parent_id -> {pp1 1, pp2 2, pp3 2}
		parent -> {pp1 pp1, pp2 pp2, pp3 pp2} 
		id -> {ps1 1, ps2 2, ps3 3, pp1 1, pp2 2, pp3 3}
		name -> {ps1 Strat1, ps2 Strat2, ps3 Strat3, pp1 Port1, pp2 Port2, pp3 Port3}
		description -> {ps1 Strategy1, ps2 Strategy2, ps3 Strategy3, pp1 Portfolio1, pp2 Portfolio2, pp3 Portfolio3}
		strategy_id -> {pp1 2, pp2 2, pp3 1}
		client_id -> {pp1 1, pp2 2, pp3 2}
		strategy -> {pp1 ps2, pp2 ps2, pp3 ps1}
} 

////////////////////////////////////////////////////////////////////////
		
schema Ref = literal : Ty {
	entities
		country 
		currency 
		asset 
		strategy
	foreign_keys
		country : currency -> country
		strategy : asset -> strategy
	attributes	
		id : country -> Integer
		code name : country -> String
		id strategy_id : asset -> Integer
		name description : asset -> String
		id : strategy -> Integer
		name description : strategy -> String
		id country_id : currency -> Integer
		code name : currency -> String
	observation_equations	
		forall c. c.country.id = c.country_id
		forall a. a.strategy.id = a.strategy_id
} 	

instance RefInstance = literal : Ref {
     generators 
     	rcty1 rcty2 rcty3 rcty4 rcty5 rcty6 : country 
		rcur1 rcur2 rcur3 : currency 
		ra1 ra2 ra3 ra4 ra5 ra6 ra7 ra8 ra9 ra10 : asset 
		rs1 rs2 rs3 rs4 rs5 : strategy
	multi_equations
		country -> {rcur1 rcty6, rcur2 rcty4, rcur3 rcty5}
		country_id  -> {rcur1 6, rcur2 4, rcur3 5}
		strategy -> {ra1 rs1, ra2 rs3, ra3 rs2, ra4 rs4, ra5 rs5, ra6 rs4, ra7 rs4, ra8 rs5, ra9 rs3, ra10 rs1}
		strategy_id  -> {ra1 1, ra2 3, ra3 2, ra4 4, ra5 5, ra6 4, ra7 4, ra8 5, ra9 3, ra10 1}
		id  -> {rcty1 1, rcty2 2, rcty3 3, rcty4 4, rcty5 5, rcty6 6, rcur1 1, rcur2 2, rcur3 3, ra1 1, ra2 2, ra3 3, ra4 4, ra5 5, ra6 6, ra7 7, ra8 8, ra9 9, ra10 10, rs1 1, rs2 2, rs3 3, rs4 4, rs5 5}
		code  -> {rcty1 AU, rcty2 CH, rcty3 CN, rcty4 EU, rcty5 JP, rcty6 US, rcur1 USD, rcur2 EUR, rcur3 JPY}
		name  -> {ra1 A1, ra2 A2, ra3 A3, ra4 A4, ra5 A5, ra6 A6, ra7 A7, ra8 A8, ra9 A9, ra10 A10, rs1 Strat1, rs2 Strat2, rs3 Strat3, rs4 Strat4, rs5 Strat5, rcty1 Australia, rcty2 Switzerland, rcty3 China, rcty4 "European Union", rcty5 Japan, rcty6 "United States of America", rcur1 "US Dollar", rcur2 "Euro", rcur3 "Japanese Yen" }
		description  -> {ra1 Asset1, ra2 Asset2, ra3 Asset3, ra4 Asset4, ra5 Asset5, ra6 Asset6, ra7 Asset7, ra8 Asset8, ra9 Asset9, ra10 Asset10, rs1 Strategy1, rs2 Strategy2, rs3 Strategy3, rs4 Strategy4, rs5 Strategy5}
} 

////////////////////////////////////////////////////////////////////////

schema Trans = literal : Ty {
	entities
		asset 
		currency 
		transaction
	foreign_keys
		asset : transaction -> asset
		currency : transaction -> currency
	attributes	
		id : asset -> Integer
		name description : asset -> String
		id : currency -> Integer
		code name : currency -> String
		id asset_id portfolio_id quantity currency_id : transaction -> Integer
		date  : transaction -> Date	// added as a new column
		buy_sell_ind : transaction -> Boolean
		price : transaction -> Double
	observation_equations	
		forall t. t.asset.id = t.asset_id
		forall t. t.currency.id = t.currency_id
} 

instance TransInstance = literal : Trans {
     generators 
		ta1 ta3 ta5 ta7 ta9 : asset 
		tc1 tc2 tc3 : currency 
		tt1 tt2 tt3 tt4 tt5 tt6 : transaction
	multi_equations
		id -> {ta1 1, ta3 3, ta5 5, ta7 7, ta9 9, tc1 1, tc2 2, tc3 3, tt1 1, tt2 2, tt3 3, tt4 4, tt5 5, tt6 6}
		name -> {ta1 A1, ta3 A3, ta5 A5, ta7 A7, ta9 A9, tc1 "US Dollar", tc2 Euro, tc3 "Japanese Yen"}
		description -> {ta1 Asset1, ta3 Asset3, ta5 Asset5, ta7 Asset7, ta9 Asset9}
		code -> {tc1 USD, tc2 EUR, tc3 JPY}
		asset -> {tt1 ta1, tt2 ta1, tt3 ta3, tt4 ta3, tt5 ta5, tt6 ta5}
		asset_id -> {tt1 1, tt2 1, tt3 3, tt4 3, tt5 5, tt6 5}
		portfolio_id -> {tt1 1, tt2 1, tt3 2, tt4 2, tt5 3, tt6 3}
		buy_sell_ind -> {tt1 buy, tt2 sell, tt3 buy, tt4 sell, tt5 buy, tt6 sell}
		quantity -> {tt1 200, tt2 100, tt3 150, tt4 150, tt5 200, tt6 100}
		price -> {tt1 "5.51", tt2 "5.5", tt3 "2.5", tt4 "3.5", tt5 "1.6", tt6 "1.5"}
		date -> {tt1 "1/1/2011", tt2 "6/1/2011", tt3 "9/1/2013", tt4 "3/1/2014", tt5 "2/1/2013", tt6 "7/1/2013"}
		currency -> {tt1 tc2, tt2 tc2, tt3 tc1, tt4 tc1, tt5 tc3, tt6 tc3}
		currency_id -> {tt1 2, tt2 2, tt3 1, tt4 1, tt5 3, tt6 3}
} 

////////////////////////////////////////////////////////////////////////

schema HoldPos = literal : Ty {
	entities
		client 
		holding 
		position
	foreign_keys	
		client : holding -> client
		client : position -> client
	attributes	
		no : client -> Integer	// new name
		nm desc : client -> String	// new name
		id client_no portfolio_id asset_id quantity : holding -> Integer
		purchase_date begin_date end_date : holding -> Date
		purchase_price : holding -> Double
		currency_code : holding -> String	// switched from _id to _code
		id client_no asset_id quantity current_value cost_basis : position -> Integer	// new name
		current_value_currency_code cost_basis_currency_code : position -> String	// switched from _id to _code
	observation_equations	
		forall h:holding. h.client.no = h.client_no
		forall p:position. p.client.no = p.client_no
} 

instance HoldPosInstance = literal : HoldPos {
    generators 
  		hpc1 hpc2 : client 
		hph1 hph2 hph3 hph4 hph5 : holding 
		hpp1 hpp2 : position
	multi_equations
		no -> {hpc1 1, hpc2 2} 		
		nm -> {hpc1 Tom, hpc2 Dick} 
		desc -> {hpc1 "Tom Client", hpc2 "Dick Client"}
		id -> {hph1 1, hph2 2, hph3 3, hph4 4, hph5 5, hpp1 1, hpp2 2} 
		client_no -> {hph1 1, hph2 1, hph3 2, hph4 2, hph5 2, hpp1 1, hpp2 2}
		client -> {hph1 hpc1, hph2 hpc1, hph3 hpc2, hph4 hpc2, hph5 hpc2, hpp1 hpc1, hpp2 hpc2}
		portfolio_id -> {hph1 1, hph2 1, hph3 3, hph4 3, hph5 3}
		asset_id -> {hph1 1, hph2 1, hph3 3, hph4 5, hph5 5}
		quantity -> {hph1 200, hph2 100, hph3 150, hph4 200, hph5 100, hpp1 100, hpp2 100}
		purchase_date -> {hph1 "1/1/2011", hph2 "1/1/2011", hph3 "9/1/2013", hph4 "2/1/2013", hph5 "2/1/2013"}
		begin_date -> {hph1 "1/1/2011", hph2 "6/1/2011", hph3 "9/1/2013", hph4 "2/1/2013", hph5 "7/1/2013"}
		end_date -> {hph1 "6/1/2011", hph3 "3/1/2014", hph4 "7/1/2013"}
		purchase_price -> {hph1 "5.51", hph2 "5.1", hph3 "2.5", hph4 "1.6", hph5 "1.6"}
		currency_code -> {hph1 EUR, hph2 EUR, hph3 JPY, hph4 USD, hph5 USD}
		asset_id -> {hpp1 1, hpp2 5}
		current_value -> {hpp1 550, hpp2 170}
		cost_basis -> {hpp1 551, hpp2 160}
		current_value_currency_code -> {hpp1 EUR, hpp2 JPY} 
		cost_basis_currency_code -> {hpp1 EUR, hpp2 JPY}	
} 

////////////////////////////////////////////////////////////////////////

schema_colimit Colimit = quotient Client + Ref + Trans + Portfolio + HoldPos : Ty {
	 entity_equations
		Client.client = HoldPos.client
		Ref.asset     = Trans.asset
		Ref.currency  = Trans.currency
		Ref.strategy  = Portfolio.strategy
	observation_equations
		forall x. x.Client_client_id          = x.HoldPos_client_no
		forall x. x.Client_client_name        = x.HoldPos_client_nm
		forall x. x.Client_client_description = x.HoldPos_client_desc

		forall x. x.Ref_strategy_id          = x.Portfolio_strategy_id
		forall x. x.Ref_strategy_name        = x.Portfolio_strategy_name
		forall x. x.Ref_strategy_description = x.Portfolio_strategy_description

		forall x. x.Ref_asset_id          = x.Trans_asset_id
		forall x. x.Ref_asset_name        = x.Trans_asset_name
		forall x. x.Ref_asset_description = x.Trans_asset_description

		forall x. x.Ref_currency_id   = x.Trans_currency_id
		forall x. x.Ref_currency_code = x.Trans_currency_code
		forall x. x.Ref_currency_name = x.Trans_currency_name
	options
		simplify_names=false	 
}

instance ClientFwd = sigma (getMapping Colimit Client) ClientInstance
instance PortfolioFwd = sigma (getMapping Colimit Portfolio) PortfolioInstance
instance RefFwd = sigma (getMapping Colimit Ref) RefInstance 
instance TransFwd = sigma (getMapping Colimit Trans) TransInstance
instance HoldPosFwd = sigma (getMapping Colimit HoldPos) HoldPosInstance

instance CoProd = coproduct ClientFwd + PortfolioFwd + RefFwd + TransFwd + HoldPosFwd : getSchema Colimit

////////////////////////////////////////////////////////////////////////

instance E = quotient_query CoProd {
	entity Client_client__HoldPos_client -> {
		from 
			a:Client_client__HoldPos_client b:Client_client__HoldPos_client 
		where 
			a.Client_client_id = b.HoldPos_client_no
	}
	entity Ref_asset__Trans_asset -> {
		from 
			a:Ref_asset__Trans_asset b:Ref_asset__Trans_asset 
		where 
			a.Ref_asset_id = b.Trans_asset_id
	}
	entity Ref_currency__Trans_currency -> {
		from 
			a:Ref_currency__Trans_currency b:Ref_currency__Trans_currency 
		where 
			a.Ref_currency_id = b.Trans_currency_id
	}
	entity Portfolio_strategy__Ref_strategy -> {
		from 
			a:Portfolio_strategy__Ref_strategy b:Portfolio_strategy__Ref_strategy 
		where 
			a.Portfolio_strategy_id = b.Ref_strategy_id
	}
	
	options
		quotient_use_chase = false
}

////////////////////////////////////////////////////////////////////////

schema Target = literal : Ty {
	entities
		currency //Trans Ref
		strategy //Portfolio Ref
		asset //Trans Ref
		transaction //Trans
		client //HoldPos
		position //HoldPos
		country //Ref
		portfolioholding //NEW
		portfolio //Portfolio 
		holding //HoldPos
	
	foreign_keys
		portfolio_strategy : portfolio -> strategy //Portfolio
		parent : portfolio -> portfolio 
		
		position_client : position -> client //HoldPos
		position_asset : position -> asset //NEW
		position_current_value_currency : position -> currency //NEW
		position_cost_basis_currency : position -> currency //NEW
		
		asset_strategy : asset -> strategy //Ref
		
		currency_country : currency -> country //Ref 
		
		transaction_currency : transaction -> currency //Trans 
		transaction_asset : transaction -> asset //Trans 
		transaction_portfolio : transaction -> portfolio //NEW

		holding_currency : holding -> currency //NEW
		holding_asset : holding -> asset

		portfolioholding_holding : portfolioholding -> holding //NEW
		portfolioholding_client : portfolioholding -> client //NEW 
		portfolioholding_portfolio : portfolioholding -> portfolio //NEW
	
	path_equations
		portfolio.parent.parent = portfolio.parent

	attributes
		code : currency -> String //Trans Ref
		name : currency -> String //Trans Ref
		id : currency -> Integer //Ref
		country_id : currency -> Integer //Ref

		code : country -> String //Ref
		name : country -> String //Ref
		id : country -> Integer //Ref		

		id : asset -> Integer //Trans Ref
		description : asset -> String //Trans Ref
		name : asset -> String //Trans Ref
		strategy_id : asset -> Integer //Ref
				
		name : strategy -> String //Ref Portfolio
		description : strategy -> String //Ref Portfolio
		id : strategy -> Integer //Ref Portfolio		

		name : portfolio -> String //Portfolio
		description : portfolio -> String //Portfolio
		id : portfolio -> Integer //Portfolio
		strategy_id : portfolio -> Integer //Portfolio
		parent_portfolio_id : portfolio -> Integer	//Portfolio ADDED
		
		quantity : position -> Integer //HoldPos
		current_value : position -> Integer //HoldPos
		cost_basis : position -> Integer //HoldPos
		id : position -> Integer //HoldPos
		client_id : position -> Integer //HoldPos
		asset_id : position -> Integer //HoldPos
		current_value_currency_id : position -> Integer // HoldPos 
		cost_basis_currency_id : position -> Integer // HoldPos		

		id : holding -> Integer //HoldPos				
		asset_id : holding -> Integer //HoldPos
		currency_id : holding -> Integer //HoldPos
		purchase_price : holding -> Double //HoldPos
		quantity : holding -> Integer //HoldPos //HoldPos
		purchase_date : holding -> Date //HoldPos		
		begin_date : holding -> Date //HoldPos new attribute
		end_date : holding -> Date //HoldPos new attribute

		description : client -> String //HoldPos
		name : client -> String //HoldPos
		id : client -> Integer //HoldPos		

		id : transaction -> Integer //Trans
		asset_id : transaction -> Integer //Trans
		buy_sell_ind : transaction -> Boolean //Trans
		quantity : transaction -> Integer //Trans
		price : transaction -> Double //Trans
		currency_id : transaction -> Integer //Trans			
		portfolio_id : transaction -> Integer //Trans
		date : transaction -> Date	//added as a new column

		id : portfolioholding -> Integer //NEW todo: talk to Jee about this
		holding_id : portfolioholding -> Integer //NEW
		client_id : portfolioholding -> Integer //NEW
		portfolio_id : portfolioholding -> Integer //NEW
	
	observation_equations
		forall p. p.parent.id = p.parent_portfolio_id //added
		forall p. p.portfolio_strategy.id = p.strategy_id
		forall a. a.asset_strategy.id = a.strategy_id	
		forall p. p.position_client.id = p.client_id
		forall c. c.currency_country.id = c.country_id
		forall t. t.transaction_currency.id = t.currency_id
		forall t. t.transaction_asset.id = t.asset_id
		forall p. p.portfolioholding_holding.id = p.holding_id
		forall p. p.portfolioholding_client.id = p.client_id	
		forall p. p.portfolioholding_portfolio.id = p.portfolio_id					
		forall p. p.position_asset.id = p.asset_id
		forall h. h.holding_currency.id = h.currency_id
		forall t. t.transaction_portfolio.id = t.portfolio_id
		forall p. p.position_current_value_currency.id = p.current_value_currency_id
		forall p. p.position_cost_basis_currency.id = p.cost_basis_currency_id	
}

////////////////////////////////////////////////////////////////////////

query ETL = literal : getSchema Colimit -> Target {
 entity currency -> {
 		from 
 			c:Ref_currency__Trans_currency
		attributes 
			code -> c.Ref_currency_code
			name -> c.Ref_currency_name
			id -> c.Ref_currency_id
			country_id -> c.Ref_currency_country_id
		foreign_keys
		 	currency_country -> {c -> c.Ref_currency_country} 		
} 

entity strategy -> {
		from 
			s:Portfolio_strategy__Ref_strategy
		attributes 
			name -> s.Ref_strategy_name
			description -> s.Ref_strategy_description
			id -> s.Ref_strategy_id
	}

entity	asset -> {
		from 
			a:Ref_asset__Trans_asset
		attributes 
			id -> a.Ref_asset_id
			description -> a.Ref_asset_description
			name -> a.Ref_asset_name
			strategy_id -> a.Ref_asset_strategy_id
		foreign_keys
		 	asset_strategy -> {s -> a.Ref_asset_strategy} 		
	} 

entity	client -> {
		from 
			c:Client_client__HoldPos_client 
		attributes 
			description -> c.Client_client_description 
			name -> c.Client_client_name
			id -> c.Client_client_id
	} 

entity	country -> {
		from 
			c:Ref_country
		attributes 
			code -> c.Ref_country_code
			name -> c.Ref_country_name
			id -> c.Ref_country_id
	} 

entity	transaction -> {
		from 
			t:Trans_transaction p:Portfolio_portfolio c:Client_client__HoldPos_client c1:Client_client__HoldPos_client
		where 
			t.Trans_transaction_portfolio_id = p.Portfolio_portfolio_id
		attributes 
			id -> t.Trans_transaction_id 
			asset_id -> t.Trans_transaction_asset_id 
			buy_sell_ind -> t.Trans_transaction_buy_sell_ind 
			quantity -> t.Trans_transaction_quantity
			price -> t.Trans_transaction_price 
			date -> t.Trans_transaction_date
			currency_id -> t.Trans_transaction_currency_id 			
			portfolio_id -> t.Trans_transaction_portfolio_id
		foreign_keys
			transaction_currency -> {c -> t.Trans_transaction_currency} 
			transaction_asset -> {a -> t.Trans_transaction_asset} 
			transaction_portfolio -> {p -> p} 	//NEW	
	}

entity	position -> {
		from 
			p:HoldPos_position a:Ref_asset__Trans_asset cv:Ref_currency__Trans_currency cb:Ref_currency__Trans_currency
		where 
			p.HoldPos_position_asset_id = a.Ref_asset_id
			p.HoldPos_position_current_value_currency_code = cv.Ref_currency_code
			p.HoldPos_position_cost_basis_currency_code = cb.Ref_currency_code
		attributes 
			quantity -> p.HoldPos_position_quantity
			current_value -> p.HoldPos_position_current_value
			cost_basis -> p.HoldPos_position_cost_basis
			id -> p.HoldPos_position_id 
			client_id -> p.HoldPos_position_client_no
			asset_id -> p.HoldPos_position_asset_id
			current_value_currency_id -> cv.Ref_currency_id
			cost_basis_currency_id -> cb.Ref_currency_id
 		foreign_keys
		 	position_client -> {c -> p.HoldPos_position_client} 
			position_asset -> {a -> a}  //NEW
			position_current_value_currency -> {c -> cv}  //NEW
			position_cost_basis_currency -> {c -> cb}  //NEW
	} 

	entity portfolio -> {
		from 
			p:Portfolio_portfolio
		attributes 
			parent_portfolio_id -> p.Portfolio_portfolio_parent_id //added
			name -> p.Portfolio_portfolio_name
			description -> p.Portfolio_portfolio_description
			id -> p.Portfolio_portfolio_id
			strategy_id -> p.Portfolio_portfolio_strategy_id
		foreign_keys
 			parent -> {p -> p.Portfolio_portfolio_parent}  //added
			portfolio_strategy -> {s -> p.Portfolio_portfolio_strategy} 
	} 

	entity holding -> {
		from 
			h:HoldPos_holding c:Ref_currency__Trans_currency a:Ref_asset__Trans_asset
		where 
			a.Ref_asset_id = h.HoldPos_holding_asset_id
			h.HoldPos_holding_currency_code = c.Ref_currency_code
		attributes 
			id -> h.HoldPos_holding_id			
			asset_id -> h.HoldPos_holding_asset_id
			currency_id -> c.Ref_currency_id 			
			purchase_price -> h.HoldPos_holding_purchase_price 
			quantity -> h.HoldPos_holding_quantity 
			purchase_date -> h.HoldPos_holding_purchase_date 
			begin_date -> h.HoldPos_holding_begin_date 
			end_date -> h.HoldPos_holding_end_date
		foreign_keys
 			holding_asset -> {a -> a} 
			holding_currency -> {c -> c}  
	} 
   
entity	portfolioholding -> {
		from 
			h:HoldPos_holding p:Portfolio_portfolio cur: Ref_currency__Trans_currency c1:Client_client__HoldPos_client a:Ref_asset__Trans_asset
		where 
			a.Ref_asset_id = h.HoldPos_holding_asset_id
			p.Portfolio_portfolio_parent.Portfolio_portfolio_client_id = c1.Client_client_id
			c1.Client_client_id = h.HoldPos_holding_client.Client_client_id
			h.HoldPos_holding_currency_code = cur.Ref_currency_code
			p.Portfolio_portfolio_client_id = h.HoldPos_holding_client.Client_client_id
			h.HoldPos_holding_portfolio_id = p.Portfolio_portfolio_id
		attributes 
			id -> keygen(h.HoldPos_holding_id, h.HoldPos_holding_client.Client_client_id, p.Portfolio_portfolio_id) //added by ryan
			holding_id -> h.HoldPos_holding_id
			client_id -> c1.Client_client_id
			portfolio_id -> p.Portfolio_portfolio_id
		foreign_keys
			portfolioholding_holding -> {h -> h c -> cur a -> a}
			portfolioholding_client -> {c -> h.HoldPos_holding_client}  
			portfolioholding_portfolio -> {p -> p} 	
	}
} 

instance Output = distinct eval ETL E
Keywords:

typeside_literal
sigma
quotient_query
schema_literal
quotient
query_literal
instance_literal
distinct
coproduct

Options:

quotient_use_chase
simplify_names



instance TransFwd

Client_client__HoldPos_client
IDClient_client_descriptionClient_client_idClient_client_nameHoldPos_client_descHoldPos_client_nmHoldPos_client_no
HoldPos_holding
IDHoldPos_holding_asset_idHoldPos_holding_begin_dateHoldPos_holding_client_noHoldPos_holding_currency_codeHoldPos_holding_end_dateHoldPos_holding_idHoldPos_holding_portfolio_idHoldPos_holding_purchase_dateHoldPos_holding_purchase_priceHoldPos_holding_quantityHoldPos_holding_client
HoldPos_position
IDHoldPos_position_asset_idHoldPos_position_client_noHoldPos_position_cost_basisHoldPos_position_cost_basis_currency_codeHoldPos_position_current_valueHoldPos_position_current_value_currency_codeHoldPos_position_idHoldPos_position_quantityHoldPos_position_client
Portfolio_portfolio
IDPortfolio_portfolio_client_idPortfolio_portfolio_descriptionPortfolio_portfolio_idPortfolio_portfolio_namePortfolio_portfolio_parent_idPortfolio_portfolio_strategy_idPortfolio_portfolio_parentPortfolio_portfolio_strategy
Portfolio_strategy__Ref_strategy
IDPortfolio_strategy_descriptionPortfolio_strategy_idPortfolio_strategy_nameRef_strategy_descriptionRef_strategy_idRef_strategy_name
0?0?1?2?0?1?2
1?3?4?5?3?4?5
2?6?7?8?6?7?8
3?9?10?11?9?10?11
4?12?13?14?12?13?14
Ref_asset__Trans_asset
IDRef_asset_descriptionRef_asset_idRef_asset_nameRef_asset_strategy_idTrans_asset_descriptionTrans_asset_idTrans_asset_nameRef_asset_strategy
5Asset55A5?1Asset55A50
6Asset99A9?4Asset99A91
7Asset33A3?7Asset33A32
8Asset11A1?10Asset11A13
9Asset77A7?13Asset77A74
Ref_country
IDRef_country_codeRef_country_idRef_country_name
10?15?16?17
11?18?19?20
12?21?22?23
Ref_currency__Trans_currency
IDRef_currency_codeRef_currency_country_idRef_currency_idRef_currency_nameTrans_currency_codeTrans_currency_idTrans_currency_nameRef_currency_country
13JPY?163Japanese YenJPY3Japanese Yen10
14USD?191US DollarUSD1US Dollar11
15EUR?222EuroEUR2Euro12
Trans_transaction
IDTrans_transaction_asset_idTrans_transaction_buy_sell_indTrans_transaction_currency_idTrans_transaction_dateTrans_transaction_idTrans_transaction_portfolio_idTrans_transaction_priceTrans_transaction_quantityTrans_transaction_assetTrans_transaction_currency
165buy32/1/2013531.6200513
175sell37/1/2013631.5100513
181sell26/1/2011215.5100815
191buy21/1/2011115.51200815
203sell13/1/2014423.5150714
213buy19/1/2013322.5150714


instance E

Client_client__HoldPos_client
IDClient_client_descriptionClient_client_idClient_client_nameHoldPos_client_descHoldPos_client_nmHoldPos_client_no
0Tom Client1TomTom ClientTom1
1Dick Client2DickDick ClientDick2
2Harry Client3HarryHarry ClientHarry3
HoldPos_holding
IDHoldPos_holding_asset_idHoldPos_holding_begin_dateHoldPos_holding_client_noHoldPos_holding_currency_codeHoldPos_holding_end_dateHoldPos_holding_idHoldPos_holding_portfolio_idHoldPos_holding_purchase_dateHoldPos_holding_purchase_priceHoldPos_holding_quantityHoldPos_holding_client
352/1/20132USD7/1/2013432/1/20131.62001
439/1/20132JPY3/1/2014339/1/20132.51501
511/1/20111EUR6/1/2011111/1/20115.512000
657/1/20132USD?0532/1/20131.61001
716/1/20111EUR?1211/1/20115.11000
HoldPos_position
IDHoldPos_position_asset_idHoldPos_position_client_noHoldPos_position_cost_basisHoldPos_position_cost_basis_currency_codeHoldPos_position_current_valueHoldPos_position_current_value_currency_codeHoldPos_position_idHoldPos_position_quantityHoldPos_position_client
811551EUR550EUR11000
952160JPY170JPY21001
Portfolio_portfolio
IDPortfolio_portfolio_client_idPortfolio_portfolio_descriptionPortfolio_portfolio_idPortfolio_portfolio_namePortfolio_portfolio_parent_idPortfolio_portfolio_strategy_idPortfolio_portfolio_parentPortfolio_portfolio_strategy
102Portfolio33Port3211114
112Portfolio22Port2221115
121Portfolio11Port1121215
Portfolio_strategy__Ref_strategy
IDPortfolio_strategy_descriptionPortfolio_strategy_idPortfolio_strategy_nameRef_strategy_descriptionRef_strategy_idRef_strategy_name
13Strategy33Strat3Strategy33Strat3
14Strategy11Strat1Strategy11Strat1
15Strategy22Strat2Strategy22Strat2
16Strategy55Strat5Strategy55Strat5
17Strategy44Strat4Strategy44Strat4
Ref_asset__Trans_asset
IDRef_asset_descriptionRef_asset_idRef_asset_nameRef_asset_strategy_idTrans_asset_descriptionTrans_asset_idTrans_asset_nameRef_asset_strategy
18Asset33A32Asset33A315
19Asset55A55Asset55A516
20Asset77A74Asset77A717
21Asset11A11Asset11A114
22Asset88A85Asset88A816
23Asset1010A101Asset1010A1014
24Asset99A93Asset99A913
25Asset22A23Asset22A213
26Asset66A64Asset66A617
27Asset44A44Asset44A417
Ref_country
IDRef_country_codeRef_country_idRef_country_name
28US6United States of America
29CH2Switzerland
30AU1Australia
31JP5Japan
32CN3China
33EU4European Union
Ref_currency__Trans_currency
IDRef_currency_codeRef_currency_country_idRef_currency_idRef_currency_nameTrans_currency_codeTrans_currency_idTrans_currency_nameRef_currency_country
34USD61US DollarUSD1US Dollar28
35JPY53Japanese YenJPY3Japanese Yen31
36EUR42EuroEUR2Euro33
Trans_transaction
IDTrans_transaction_asset_idTrans_transaction_buy_sell_indTrans_transaction_currency_idTrans_transaction_dateTrans_transaction_idTrans_transaction_portfolio_idTrans_transaction_priceTrans_transaction_quantityTrans_transaction_assetTrans_transaction_currency
373buy19/1/2013322.51501834
383sell13/1/2014423.51501834
395buy32/1/2013531.62001935
401sell26/1/2011215.51002136
415sell37/1/2013631.51001935
421buy21/1/2011115.512002136


instance RefInstance

asset
IDdescriptionidnamestrategy_idstrategy
0Asset66A6419
1Asset55A5520
2Asset44A4419
3Asset77A7419
4Asset33A3222
5Asset88A8520
6Asset11A1121
7Asset99A9323
8Asset1010A10121
9Asset22A2323
country
IDcodeidname
10US6United States of America
11JP5Japan
12EU4European Union
13AU1Australia
14CH2Switzerland
15CN3China
currency
IDcodecountry_ididnamecountry
16USD61US Dollar10
17JPY53Japanese Yen11
18EUR42Euro12
strategy
IDdescriptionidname
19Strategy44Strat4
20Strategy55Strat5
21Strategy11Strat1
22Strategy22Strat2
23Strategy33Strat3


instance HoldPosInstance

client
IDdescnmno
0Dick ClientDick2
1Tom ClientTom1
holding
IDasset_idbegin_dateclient_nocurrency_codeend_dateidportfolio_idpurchase_datepurchase_pricequantityclient
252/1/20132USD7/1/2013432/1/20131.62000
339/1/20132JPY3/1/2014339/1/20132.51500
411/1/20111EUR6/1/2011111/1/20115.512001
557/1/20132USD?0532/1/20131.61000
616/1/20111EUR?1211/1/20115.11001
position
IDasset_idclient_nocost_basiscost_basis_currency_codecurrent_valuecurrent_value_currency_codeidquantityclient
752160JPY170JPY21000
811551EUR550EUR11001


instance Output

asset
IDdescriptionidnamestrategy_idasset_strategy
0Asset33A3239
1Asset55A5540
2Asset77A7441
3Asset11A1138
4Asset88A8540
5Asset1010A10138
6Asset99A9337
7Asset22A2337
8Asset66A6441
9Asset44A4441
client
IDdescriptionidname
10Tom Client1Tom
11Dick Client2Dick
12Harry Client3Harry
country
IDcodeidname
13US6United States of America
14CH2Switzerland
15AU1Australia
16JP5Japan
17CN3China
18EU4European Union
currency
IDcodecountry_ididnamecurrency_country
19USD61US Dollar13
20JPY53Japanese Yen16
21EUR42Euro18
holding
IDasset_idbegin_datecurrency_idend_dateidpurchase_datepurchase_pricequantityholding_assetholding_currency
2239/1/201333/1/201439/1/20132.5150020
2352/1/201317/1/201342/1/20131.6200119
2457/1/20131?052/1/20131.6100119
2511/1/201126/1/201111/1/20115.51200321
2616/1/20112?121/1/20115.1100321
portfolio
IDdescriptionidnameparent_portfolio_idstrategy_idparentportfolio_strategy
27Portfolio33Port3212838
28Portfolio22Port2222839
29Portfolio11Port1122939
portfolioholding
IDclient_idholding_ididportfolio_idportfolioholding_clientportfolioholding_holdingportfolioholding_portfolio
302323112227
312473112327
322543112427
331151102529
341201102629
position
IDasset_idclient_idcost_basiscost_basis_currency_idcurrent_valuecurrent_value_currency_ididquantityposition_assetposition_clientposition_cost_basis_currencyposition_current_value_currency
35521603170321001112020
36115512550211003102121
strategy
IDdescriptionidname
37Strategy33Strat3
38Strategy11Strat1
39Strategy22Strat2
40Strategy55Strat5
41Strategy44Strat4
transaction
IDasset_idbuy_sell_indcurrency_iddateidportfolio_idpricequantitytransaction_assettransaction_currencytransaction_portfolio
425buy32/1/2013531.620012027
435sell37/1/2013631.510012027
443buy19/1/2013322.515001928
453sell13/1/2014423.515001928
461sell26/1/2011215.510032129
471buy21/1/2011115.5120032129


instance TransInstance

asset
IDdescriptionidname
0Asset55A5
1Asset99A9
2Asset33A3
3Asset11A1
4Asset77A7
currency
IDcodeidname
5JPY3Japanese Yen
6USD1US Dollar
7EUR2Euro
transaction
IDasset_idbuy_sell_indcurrency_iddateidportfolio_idpricequantityassetcurrency
85buy32/1/2013531.620005
95sell37/1/2013631.510005
101sell26/1/2011215.510037
111buy21/1/2011115.5120037
123sell13/1/2014423.515026
133buy19/1/2013322.515026


instance PortfolioFwd

Client_client__HoldPos_client
IDClient_client_descriptionClient_client_idClient_client_nameHoldPos_client_descHoldPos_client_nmHoldPos_client_no
HoldPos_holding
IDHoldPos_holding_asset_idHoldPos_holding_begin_dateHoldPos_holding_client_noHoldPos_holding_currency_codeHoldPos_holding_end_dateHoldPos_holding_idHoldPos_holding_portfolio_idHoldPos_holding_purchase_dateHoldPos_holding_purchase_priceHoldPos_holding_quantityHoldPos_holding_client
HoldPos_position
IDHoldPos_position_asset_idHoldPos_position_client_noHoldPos_position_cost_basisHoldPos_position_cost_basis_currency_codeHoldPos_position_current_valueHoldPos_position_current_value_currency_codeHoldPos_position_idHoldPos_position_quantityHoldPos_position_client
Portfolio_portfolio
IDPortfolio_portfolio_client_idPortfolio_portfolio_descriptionPortfolio_portfolio_idPortfolio_portfolio_namePortfolio_portfolio_parent_idPortfolio_portfolio_strategy_idPortfolio_portfolio_parentPortfolio_portfolio_strategy
01Portfolio11Port11203
12Portfolio33Port32124
22Portfolio22Port22223
Portfolio_strategy__Ref_strategy
IDPortfolio_strategy_descriptionPortfolio_strategy_idPortfolio_strategy_nameRef_strategy_descriptionRef_strategy_idRef_strategy_name
3Strategy22Strat2Strategy22Strat2
4Strategy11Strat1Strategy11Strat1
5Strategy33Strat3Strategy33Strat3
Ref_asset__Trans_asset
IDRef_asset_descriptionRef_asset_idRef_asset_nameRef_asset_strategy_idTrans_asset_descriptionTrans_asset_idTrans_asset_nameRef_asset_strategy
Ref_country
IDRef_country_codeRef_country_idRef_country_name
Ref_currency__Trans_currency
IDRef_currency_codeRef_currency_country_idRef_currency_idRef_currency_nameTrans_currency_codeTrans_currency_idTrans_currency_nameRef_currency_country
Trans_transaction
IDTrans_transaction_asset_idTrans_transaction_buy_sell_indTrans_transaction_currency_idTrans_transaction_dateTrans_transaction_idTrans_transaction_portfolio_idTrans_transaction_priceTrans_transaction_quantityTrans_transaction_assetTrans_transaction_currency


instance ClientInstance

client
IDdescriptionidname
0Dick Client2Dick
1Tom Client1Tom
2Harry Client3Harry


instance RefFwd

Client_client__HoldPos_client
IDClient_client_descriptionClient_client_idClient_client_nameHoldPos_client_descHoldPos_client_nmHoldPos_client_no
HoldPos_holding
IDHoldPos_holding_asset_idHoldPos_holding_begin_dateHoldPos_holding_client_noHoldPos_holding_currency_codeHoldPos_holding_end_dateHoldPos_holding_idHoldPos_holding_portfolio_idHoldPos_holding_purchase_dateHoldPos_holding_purchase_priceHoldPos_holding_quantityHoldPos_holding_client
HoldPos_position
IDHoldPos_position_asset_idHoldPos_position_client_noHoldPos_position_cost_basisHoldPos_position_cost_basis_currency_codeHoldPos_position_current_valueHoldPos_position_current_value_currency_codeHoldPos_position_idHoldPos_position_quantityHoldPos_position_client
Portfolio_portfolio
IDPortfolio_portfolio_client_idPortfolio_portfolio_descriptionPortfolio_portfolio_idPortfolio_portfolio_namePortfolio_portfolio_parent_idPortfolio_portfolio_strategy_idPortfolio_portfolio_parentPortfolio_portfolio_strategy
Portfolio_strategy__Ref_strategy
IDPortfolio_strategy_descriptionPortfolio_strategy_idPortfolio_strategy_nameRef_strategy_descriptionRef_strategy_idRef_strategy_name
0Strategy44Strat4Strategy44Strat4
1Strategy55Strat5Strategy55Strat5
2Strategy11Strat1Strategy11Strat1
3Strategy22Strat2Strategy22Strat2
4Strategy33Strat3Strategy33Strat3
Ref_asset__Trans_asset
IDRef_asset_descriptionRef_asset_idRef_asset_nameRef_asset_strategy_idTrans_asset_descriptionTrans_asset_idTrans_asset_nameRef_asset_strategy
5Asset66A64Asset66A60
6Asset55A55Asset55A51
7Asset44A44Asset44A40
8Asset77A74Asset77A70
9Asset33A32Asset33A33
10Asset88A85Asset88A81
11Asset11A11Asset11A12
12Asset99A93Asset99A94
13Asset1010A101Asset1010A102
14Asset22A23Asset22A24
Ref_country
IDRef_country_codeRef_country_idRef_country_name
15US6United States of America
16JP5Japan
17EU4European Union
18AU1Australia
19CH2Switzerland
20CN3China
Ref_currency__Trans_currency
IDRef_currency_codeRef_currency_country_idRef_currency_idRef_currency_nameTrans_currency_codeTrans_currency_idTrans_currency_nameRef_currency_country
21USD61US DollarUSD1US Dollar15
22JPY53Japanese YenJPY3Japanese Yen16
23EUR42EuroEUR2Euro17
Trans_transaction
IDTrans_transaction_asset_idTrans_transaction_buy_sell_indTrans_transaction_currency_idTrans_transaction_dateTrans_transaction_idTrans_transaction_portfolio_idTrans_transaction_priceTrans_transaction_quantityTrans_transaction_assetTrans_transaction_currency


instance PortfolioInstance

portfolio
IDclient_iddescriptionidnameparent_idstrategy_idparentstrategy
01Portfolio11Port11203
12Portfolio33Port32124
22Portfolio22Port22223
strategy
IDdescriptionidname
3Strategy22Strat2
4Strategy11Strat1
5Strategy33Strat3


instance CoProd

Client_client__HoldPos_client
IDClient_client_descriptionClient_client_idClient_client_nameHoldPos_client_descHoldPos_client_nmHoldPos_client_no
0Dick Client2DickDick ClientDick2
1Tom Client1TomTom ClientTom1
2Harry Client3HarryHarry ClientHarry3
3Dick Client2DickDick ClientDick2
4Tom Client1TomTom ClientTom1
HoldPos_holding
IDHoldPos_holding_asset_idHoldPos_holding_begin_dateHoldPos_holding_client_noHoldPos_holding_currency_codeHoldPos_holding_end_dateHoldPos_holding_idHoldPos_holding_portfolio_idHoldPos_holding_purchase_dateHoldPos_holding_purchase_priceHoldPos_holding_quantityHoldPos_holding_client
552/1/20132USD7/1/2013432/1/20131.62003
639/1/20132JPY3/1/2014339/1/20132.51503
711/1/20111EUR6/1/2011111/1/20115.512004
857/1/20132USD?0532/1/20131.61003
916/1/20111EUR?1211/1/20115.11004
HoldPos_position
IDHoldPos_position_asset_idHoldPos_position_client_noHoldPos_position_cost_basisHoldPos_position_cost_basis_currency_codeHoldPos_position_current_valueHoldPos_position_current_value_currency_codeHoldPos_position_idHoldPos_position_quantityHoldPos_position_client
1052160JPY170JPY21003
1111551EUR550EUR11004
Portfolio_portfolio
IDPortfolio_portfolio_client_idPortfolio_portfolio_descriptionPortfolio_portfolio_idPortfolio_portfolio_namePortfolio_portfolio_parent_idPortfolio_portfolio_strategy_idPortfolio_portfolio_parentPortfolio_portfolio_strategy
121Portfolio11Port1121215
132Portfolio33Port3211416
142Portfolio22Port2221415
Portfolio_strategy__Ref_strategy
IDPortfolio_strategy_descriptionPortfolio_strategy_idPortfolio_strategy_nameRef_strategy_descriptionRef_strategy_idRef_strategy_name
15Strategy22Strat2Strategy22Strat2
16Strategy11Strat1Strategy11Strat1
17Strategy33Strat3Strategy33Strat3
18Strategy44Strat4Strategy44Strat4
19Strategy55Strat5Strategy55Strat5
20Strategy11Strat1Strategy11Strat1
21Strategy22Strat2Strategy22Strat2
22Strategy33Strat3Strategy33Strat3
23?2?3?4?2?3?4
24?5?6?7?5?6?7
25?8?9?10?8?9?10
26?11?12?13?11?12?13
27?14?15?16?14?15?16
Ref_asset__Trans_asset
IDRef_asset_descriptionRef_asset_idRef_asset_nameRef_asset_strategy_idTrans_asset_descriptionTrans_asset_idTrans_asset_nameRef_asset_strategy
28Asset66A64Asset66A618
29Asset55A55Asset55A519
30Asset44A44Asset44A418
31Asset77A74Asset77A718
32Asset33A32Asset33A321
33Asset88A85Asset88A819
34Asset11A11Asset11A120
35Asset99A93Asset99A922
36Asset1010A101Asset1010A1020
37Asset22A23Asset22A222
38Asset55A5?3Asset55A523
39Asset99A9?6Asset99A924
40Asset33A3?9Asset33A325
41Asset11A1?12Asset11A126
42Asset77A7?15Asset77A727
Ref_country
IDRef_country_codeRef_country_idRef_country_name
43US6United States of America
44JP5Japan
45EU4European Union
46AU1Australia
47CH2Switzerland
48CN3China
49?17?18?19
50?20?21?22
51?23?24?25
Ref_currency__Trans_currency
IDRef_currency_codeRef_currency_country_idRef_currency_idRef_currency_nameTrans_currency_codeTrans_currency_idTrans_currency_nameRef_currency_country
52USD61US DollarUSD1US Dollar43
53JPY53Japanese YenJPY3Japanese Yen44
54EUR42EuroEUR2Euro45
55JPY?183Japanese YenJPY3Japanese Yen49
56USD?211US DollarUSD1US Dollar50
57EUR?242EuroEUR2Euro51
Trans_transaction
IDTrans_transaction_asset_idTrans_transaction_buy_sell_indTrans_transaction_currency_idTrans_transaction_dateTrans_transaction_idTrans_transaction_portfolio_idTrans_transaction_priceTrans_transaction_quantityTrans_transaction_assetTrans_transaction_currency
585buy32/1/2013531.62003855
595sell37/1/2013631.51003855
601sell26/1/2011215.51004157
611buy21/1/2011115.512004157
623sell13/1/2014423.51504056
633buy19/1/2013322.51504056


instance HoldPosFwd

Client_client__HoldPos_client
IDClient_client_descriptionClient_client_idClient_client_nameHoldPos_client_descHoldPos_client_nmHoldPos_client_no
0Dick Client2DickDick ClientDick2
1Tom Client1TomTom ClientTom1
HoldPos_holding
IDHoldPos_holding_asset_idHoldPos_holding_begin_dateHoldPos_holding_client_noHoldPos_holding_currency_codeHoldPos_holding_end_dateHoldPos_holding_idHoldPos_holding_portfolio_idHoldPos_holding_purchase_dateHoldPos_holding_purchase_priceHoldPos_holding_quantityHoldPos_holding_client
252/1/20132USD7/1/2013432/1/20131.62000
339/1/20132JPY3/1/2014339/1/20132.51500
411/1/20111EUR6/1/2011111/1/20115.512001
557/1/20132USD?0532/1/20131.61000
616/1/20111EUR?1211/1/20115.11001
HoldPos_position
IDHoldPos_position_asset_idHoldPos_position_client_noHoldPos_position_cost_basisHoldPos_position_cost_basis_currency_codeHoldPos_position_current_valueHoldPos_position_current_value_currency_codeHoldPos_position_idHoldPos_position_quantityHoldPos_position_client
752160JPY170JPY21000
811551EUR550EUR11001
Portfolio_portfolio
IDPortfolio_portfolio_client_idPortfolio_portfolio_descriptionPortfolio_portfolio_idPortfolio_portfolio_namePortfolio_portfolio_parent_idPortfolio_portfolio_strategy_idPortfolio_portfolio_parentPortfolio_portfolio_strategy
Portfolio_strategy__Ref_strategy
IDPortfolio_strategy_descriptionPortfolio_strategy_idPortfolio_strategy_nameRef_strategy_descriptionRef_strategy_idRef_strategy_name
Ref_asset__Trans_asset
IDRef_asset_descriptionRef_asset_idRef_asset_nameRef_asset_strategy_idTrans_asset_descriptionTrans_asset_idTrans_asset_nameRef_asset_strategy
Ref_country
IDRef_country_codeRef_country_idRef_country_name
Ref_currency__Trans_currency
IDRef_currency_codeRef_currency_country_idRef_currency_idRef_currency_nameTrans_currency_codeTrans_currency_idTrans_currency_nameRef_currency_country
Trans_transaction
IDTrans_transaction_asset_idTrans_transaction_buy_sell_indTrans_transaction_currency_idTrans_transaction_dateTrans_transaction_idTrans_transaction_portfolio_idTrans_transaction_priceTrans_transaction_quantityTrans_transaction_assetTrans_transaction_currency


instance ClientFwd

Client_client__HoldPos_client
IDClient_client_descriptionClient_client_idClient_client_nameHoldPos_client_descHoldPos_client_nmHoldPos_client_no
0Dick Client2DickDick ClientDick2
1Tom Client1TomTom ClientTom1
2Harry Client3HarryHarry ClientHarry3
HoldPos_holding
IDHoldPos_holding_asset_idHoldPos_holding_begin_dateHoldPos_holding_client_noHoldPos_holding_currency_codeHoldPos_holding_end_dateHoldPos_holding_idHoldPos_holding_portfolio_idHoldPos_holding_purchase_dateHoldPos_holding_purchase_priceHoldPos_holding_quantityHoldPos_holding_client
HoldPos_position
IDHoldPos_position_asset_idHoldPos_position_client_noHoldPos_position_cost_basisHoldPos_position_cost_basis_currency_codeHoldPos_position_current_valueHoldPos_position_current_value_currency_codeHoldPos_position_idHoldPos_position_quantityHoldPos_position_client
Portfolio_portfolio
IDPortfolio_portfolio_client_idPortfolio_portfolio_descriptionPortfolio_portfolio_idPortfolio_portfolio_namePortfolio_portfolio_parent_idPortfolio_portfolio_strategy_idPortfolio_portfolio_parentPortfolio_portfolio_strategy
Portfolio_strategy__Ref_strategy
IDPortfolio_strategy_descriptionPortfolio_strategy_idPortfolio_strategy_nameRef_strategy_descriptionRef_strategy_idRef_strategy_name
Ref_asset__Trans_asset
IDRef_asset_descriptionRef_asset_idRef_asset_nameRef_asset_strategy_idTrans_asset_descriptionTrans_asset_idTrans_asset_nameRef_asset_strategy
Ref_country
IDRef_country_codeRef_country_idRef_country_name
Ref_currency__Trans_currency
IDRef_currency_codeRef_currency_country_idRef_currency_idRef_currency_nameTrans_currency_codeTrans_currency_idTrans_currency_nameRef_currency_country
Trans_transaction
IDTrans_transaction_asset_idTrans_transaction_buy_sell_indTrans_transaction_currency_idTrans_transaction_dateTrans_transaction_idTrans_transaction_portfolio_idTrans_transaction_priceTrans_transaction_quantityTrans_transaction_assetTrans_transaction_currency