Versions Compared

Old Version 6

changes.mady.by.user Dmitry Donosiyan

Saved on

compared with

New Version 7

changes.mady.by.user Dmitry Donosiyan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The new entity xreference identifiers could New entity xreference identifiers can be inserted into the RULESDBO.ENTITY_XREFERENCE DB table with Generic Entity interface.
For inserted the new newly added identifiers only the 'Find 1st Match' mode of Entity Resolution logic can be used.

New identifiers for adding do not define the value of another Entity Id in Entity Xreference DB table.

Insert New Entity XREF Record

...

Expand
titleFull example for insert (click to expand):


Code Block
languagexml
<entityId>ENT001</entityId>
<entityName>ENT001</entityName>
<entityType>PORT</entityType>
<entityXrefs>
	<entityXref>
		<xrefAccountId>TST_ADD01</xrefAccountId>
		<xrefAccountIdType>XREF_TYPE1</xrefAccountIdType>
		<xrefClassCode>TF1</xrefClassCode>
	</entityXref>
	<entityXref>
		<xrefAccountId>TST_ADD02</xrefAccountId>
		<xrefAccountIdType>XREF_TYPE2</xrefAccountIdType>
		<xrefClassCode>TF2</xrefClassCode>
	</entityXref>
</entityXrefs>

...

<EagleML xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" eaglemlVersion="2-0" eaglemlType="EntityTransactionMessage" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" xsi:type="EntityTransactionMessage">
	<header>
		<messageId messageIdScheme="http://www.eagleinvsys.com/coding-scheme/message-id-2-0">TEST</messageId>
	</header>
	<entityTransaction>
		<header>
			<objectType>GenericEntity</objectType>
		</header>
		<genericEntity>
			<objectType>GenericEntity</objectType>
			<objectId>GenericEntity</objectId>
			<objectDescription>ENTITY</objectDescription>
			<sourceName>EAGLE PACE</sourceName>
			<updateSource>MCADMIN</updateSource>
			<entityId>ASXR_E01</entityId>
			<entityName>ASXR_E01</entityName>
			<entityType>PORT</entityType>
			<entityXrefs>
				<entityXref>
					<xrefAccountId>ASXR_E01_XREF1</xrefAccountId>
					<xrefAccountIdType>XREF101</xrefAccountIdType>
					<classCode>TF1</classCode>
				</entityXref>
			</entityXrefs>
			<effectiveDate>2018-05-25</effectiveDate>	
			<accountingBasis>USTAX</accountingBasis>
			<accSysOpeningDate>2018-05-25</accSysOpeningDate>			
			<baseCurrency>USD</baseCurrency>			
			<costMethod>I</costMethod>			
			<countryOfTax>US</countryOfTax>
			<entityLongName>ASXR_E01</entityLongName>
			<fiscalEndDate>2018-05-25</fiscalEndDate>			
			<gainLossPydn>N</gainLossPydn>
			<inceptionDate>2018-05-25</inceptionDate>
			<legalName>ASXR_E01</legalName>
			<lotSelectionMethod>FIFO</lotSelectionMethod>
			<conversionDt>2018-05-25</conversionDt>
			<fxSource>EAGLE PACE</fxSource>
			<priceSource>EAGLE PACE</priceSource>
			<varRateSource>EAGLE PACE</varRateSource>
			<espShortPriceSource>EAGLE PACE</espShortPriceSource>
			<entityPartitionAssignment>1</entityPartitionAssignment>
			<cashSuspenseProc>N</cashSuspenseProc>
			<acctBasis>
				<acctBasis>USTAX</acctBasis>
				<costMethodCash>I</costMethodCash>
				<sinkFundGainLossFlag>Y</sinkFundGainLossFlag>				
				<primaryAmortizationAccreationRule>DEFAULTNONE</primaryAmortizationAccreationRule>				
				<contractualCashSettlementRule>DEFAULTNONE</contractualCashSettlementRule>				
				<mtmRateSource>EAGLE PACE</mtmRateSource>
				<xrateValSource>EAGLE PACE</xrateValSource>
				<valuePacePosAtCostFlag>N</valuePacePosAtCostFlag>
			</acctBasis>
		</genericEntity>
	</entityTransaction>
</EagleML>


You can use Generic Entity interface without Accounting Validation Flag. Entity batting order and entity resolution option can be null.

Code Block
languagexml
...
<entityId>ASXR_E01</entityId>
<entityName>ASXR_E01</entityName>
<entityType>PORT</entityType>
<entityXrefs>
   <entityXref>
      <xrefAccountId>ASXR_E01_XREF1</xrefAccountId>
      <xrefAccountIdType>XREF101</xrefAccountIdType>
      <classCode>TF1</classCode>
   </entityXref>
</entityXrefs>...

1 record will be added to ENTITY_XREFERENCE table with Xref Id = ASXR_E01_XREF1 and Type = XREF101

Update the Entity XREF Record

To add the entity identifiers for the existing Entity Id specify the new identifiers in incoming message together with Entity Id or entity identifiers which defined the Entity Id by entity resolution logic. For example, update the Entity record above (the part of incoming messageupdate Entity Xreference with type = XREF101 use the following construction:

Code Block
languagexml
<entityId>ASXR_E01</entityId>
<entityName>ASXR_E01</entityName>
<entityType>PORT</entityType>
<entityXrefs>
   <entityXref>
      <xrefAccountId>ASXR_E01_XREF2</xrefAccountId>
      <xrefAccountIdType>XREF101</xrefAccountIdType>
      <classCode>TF1</classCode>
   </entityXref>
</entityXrefs> 


Expand
titleFull example for update (click to expand):


Code Block
languagexml
<entityId>ENT001</entityId>
<entityName>ENT001</entityName>
<entityType>PORT</entityType>
<entityXrefs>
	<entityXref>
		<xrefAccountId>TST_ADD01</xrefAccountId>
		<xrefAccountIdType>XREF_TYPE1</xrefAccountIdType>
		<xrefClassCode>TF1</xrefClassCode>
	</entityXref>
	<entityXref>
		<xrefAccountId>TST_ADD02</xrefAccountId>
		<xrefAccountIdType>XREF_TYPE2</xrefAccountIdType>
		<xrefClassCode>TF2</xrefClassCode>
	</entityXref>
</entityXrefs>

...

<EagleML xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" eaglemlVersion="2-0" eaglemlType="EntityTransactionMessage" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" xsi:type="EntityTransactionMessage">
	<header>
		<messageId messageIdScheme="http://www.eagleinvsys.com/coding-scheme/message-id-2-0">TEST</messageId>
	</header>
	<entityTransaction>
		<header>
			<objectType>GenericEntity</objectType>
		</header>
		<genericEntity>
			<objectType>GenericEntity</objectType>
			<objectId>GenericEntity</objectId>
			<objectDescription>ENTITY</objectDescription>
			<sourceName>EAGLE PACE</sourceName>
			<updateSource>MCADMIN</updateSource>
			<entityId>ASXR_E01</entityId>
			<entityName>ASXR_E01</entityName>
			<entityType>PORT</entityType>
			<entityXrefs>
				<entityXref>
					<xrefAccountId>ASXR_E01_XREF2</xrefAccountId>
					<xrefAccountIdType>XREF101</xrefAccountIdType>
					<classCode>TF1</classCode>
				</entityXref>
			</entityXrefs>
			<effectiveDate>2018-05-25</effectiveDate>	
			<accountingBasis>USTAX</accountingBasis>
			<accSysOpeningDate>2018-05-25</accSysOpeningDate>			
			<baseCurrency>USD</baseCurrency>			
			<costMethod>I</costMethod>			
			<countryOfTax>US</countryOfTax>
			<entityLongName>ASXR_E01</entityLongName>
			<fiscalEndDate>2018-05-25</fiscalEndDate>			
			<gainLossPydn>N</gainLossPydn>
			<inceptionDate>2018-05-25</inceptionDate>
			<legalName>ASXR_E01</legalName>
			<lotSelectionMethod>FIFO</lotSelectionMethod>
			<conversionDt>2018-05-25</conversionDt>
			<fxSource>EAGLE PACE</fxSource>
			<priceSource>EAGLE PACE</priceSource>
			<varRateSource>EAGLE PACE</varRateSource>
			<espShortPriceSource>EAGLE PACE</espShortPriceSource>
			<entityPartitionAssignment>1</entityPartitionAssignment>
			<cashSuspenseProc>N</cashSuspenseProc>
			<acctBasis>
				<acctBasis>USTAX</acctBasis>
				<costMethodCash>I</costMethodCash>
				<sinkFundGainLossFlag>Y</sinkFundGainLossFlag>				
				<primaryAmortizationAccreationRule>DEFAULTNONE</primaryAmortizationAccreationRule>				
				<contractualCashSettlementRule>DEFAULTNONE</contractualCashSettlementRule>				
				<mtmRateSource>EAGLE PACE</mtmRateSource>
				<xrateValSource>EAGLE PACE</xrateValSource>
				<valuePacePosAtCostFlag>N</valuePacePosAtCostFlag>
			</acctBasis>
		</genericEntity>
	</entityTransaction>
</EagleML>


Xref Account Id will be updated from ASXR_E01_XREF1 to ASXR_E01_XREF2.

It is also possible to update Xrefs via Acounting Entity rule (with Accounting Validation Flag = Y), the logic is the same.