New entity xreference identifiers can be inserted into the RULESDBO.ENTITY_XREFERENCE DB table with Generic Entity interface.
For the newly added identifiers only 'Find 1st Match' mode of Entity Resolution logic can be used.
...
Expand |
---|
title | Full example for insert (click to expand): |
---|
|
Code Block |
---|
| <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 are not required and can be nullomitted in the incoming message.
Code Block |
---|
|
...
<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 update Entity Xreference with type = XREF101 use the following construction:
Code Block |
---|
|
...
<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 |
---|
title | Full example for update (click to expand): |
---|
|
Code Block |
---|
| <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 Acсounting Entity rule (with Accounting Validation Flag = Y), the logic is the same.