Difference between SECURITY.POSITION and SC.POS.ASSET

  • karthickgme
  • Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 2 months ago #23060 by karthickgme
Dear all,

I would like to know about the difference between SECURITY.POSITION and SC.POS.ASSET. Am having bit confusion between these two tables as it have the information about holdings only. Can anyone clarify this??

Thanks in advance.

Please Log in or Create an account to join the conversation.

More
3 years 3 months ago #23429 by MarkTaylor
SECURITY.POSITION holds the current security holdings for a Portfolio.

SC.POS.ASSET also holds the current security holdings and valuations for a Portfolio. Additionally stores the valuation/balances of the following applications/modules (if the contract is linked to a Portfolio)
AC, DX, FD, FX, LD, MD, MM etc..
SC.POS.ASSET records are deleted and rebuilt everyday

Please Log in or Create an account to join the conversation.

Time to create page: 0.074 seconds