Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 5 Current »

Accounting Rejection is designed to extract data from ESTAR.ESTAR_EVENT_REJECTION and ESTAR.ESTAR_REJECTED_MESSAGE tables.

 Section Tables for SQL Request (click to expand)
FROM ESTAR.ESTAR_EVENT_REJECTION 
 inner join ESTAR.ESTAR_REJECTED_MESSAGE on ESTAR.ESTAR_EVENT_REJECTION.REJECTION_INSTANCE = ESTAR.ESTAR_REJECTED_MESSAGE.REJECTION_INSTANCE 
 left outer join RULESDBO.ENTITY on ESTAR.ESTAR_EVENT_REJECTION.PORTFOLIO_ACCT = RULESDBO.ENTITY.ENTITY_ID 
 left outer join SECURITYDBO.SECURITY_MASTER  on ESTAR.ESTAR_EVENT_REJECTION.ASSET_ID = SECURITYDBO.SECURITY_MASTER.SECURITY_ALIAS 
 left outer  join PACE_MASTERDBO.INTERFACES on ESTAR.ESTAR_EVENT_REJECTION.SRC_INTFC_INST = PACE_MASTERDBO.INTERFACES.INSTANCE
 left outer join MSGCENTER_DBO.MSG_STREAMS MSG_STREAMS ON MSG_STREAMS.msg_stream_id = ESTAR.ESTAR_EVENT_REJECTION.STREAM_ID
 inner join ESTAR.DM_LEDGER_ACCT_BALANCES TMP_HELD_SECURITY on TMP_HELD_SECURITY.SECURITY_ALIAS = ESTAR.ESTAR_EVENT_REJECTION.ASSET_ID 
 inner join ESTAR.TEMP_RESOLVE_COMPOSITE part_ent  on part_ent.ENTITY_ID = ESTAR.ESTAR_EVENT_REJECTION.PORTFOLIO_ACCT

For Accounting Rejection object:

  • No labels