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 3 Next »

ElementValue Type Star TagEagle DBDB TableDB FieldData TypeXpath
objectTypeObjectTypeEnum not stored in DB EagleML/accountingTransaction/unsettledTransactions/objectType
objectIdObjectId not stored in DB EagleML/accountingTransaction/unsettledTransactions/objectId
objectDescriptionFeedTypeEnum not stored in DB EagleML/accountingTransaction/unsettledTransactions/objectDescription
updateTimestampdateTime1106ESTARESTAR_TRADED_CASH_ACTIVITYSYSTEM_DATEDATEEagleML/accountingTransaction/unsettledTransactions/updateTimestamp
updateSourcestring944calculated value EagleML/accountingTransaction/unsettledTransactions/updateSource
entityIdstring5RULESDBOENTITYENTITY_ID EagleML/accountingTransaction/unsettledTransactions/entityId
entityNamestring1617RULESDBOENTITYENTITY_NAME EagleML/accountingTransaction/unsettledTransactions/entityName
entityTypenormalizedString1105RULESDBOENTITYENTITY_TYPE EagleML/accountingTransaction/unsettledTransactions/entityType
fxSourcestring1102RULESDBOENTITYFX_SOURCE EagleML/accountingTransaction/unsettledTransactions/fxSource
entityPriceMethodstring1872RULESDBOENTITYPRICE_METHOD EagleML/accountingTransaction/unsettledTransactions/entityPriceMethod
countryOfTaxstring1342RULESDBOENTITYCOUNTRY_OF_TAX EagleML/accountingTransaction/unsettledTransactions/countryOfTax
eabRegulatoryCategorystring12387RULESDBOENTITY_ACCT_BASISREGULATORY_CATEGORY EagleML/accountingTransaction/unsettledTransactions/eabRegulatoryCategory
starAcctField29string3928RULESDBOENTITY_STAR_PROCESSINGSTAR_ACCT_FIELD_29 EagleML/accountingTransaction/unsettledTransactions/starAcctField29
userField17string1642RULESDBOENTITYUSER_FIELD17 EagleML/accountingTransaction/unsettledTransactions/userField17
userField18string1643RULESDBOENTITYUSER_FIELD18 EagleML/accountingTransaction/unsettledTransactions/userField18
primaryAssetIdInstrumentId14SECURITYDBOSECURITY_MASTERPRIMARY_ASSET_ID EagleML/accountingTransaction/unsettledTransactions/primaryAssetId
primaryAssetTypeInstrumentId1432SECURITYDBOSECURITY_MASTERPRIMARY_ASSET_ID_TYPE EagleML/accountingTransaction/unsettledTransactions/primaryAssetType
altAssetIdAndType Model 1795, 5501    EagleML/accountingTransaction/unsettledTransactions/altAssetIdAndType/
issueNamestring961SECURITYDBOSECURITY_MASTERISSUE_NAME EagleML/accountingTransaction/unsettledTransactions/issueName
issueDescriptionDescription962SECURITYDBOSECURITY_MASTERISSUE_DESCRIPTION EagleML/accountingTransaction/unsettledTransactions/issueDescription
tickerInstrumentId13SECURITYDBOSECURITY_MASTERTICKER EagleML/accountingTransaction/unsettledTransactions/ticker
securityAliasinteger10SECURITYDBOSECURITY_MASTERSECURITY_ALIAS EagleML/accountingTransaction/unsettledTransactions/securityAlias
investmentTypeStringWithCodeScheme11SECURITYDBOSECURITY_MASTERINVESTMENT_TYPE EagleML/accountingTransaction/unsettledTransactions/investmentType
processingSecurityTypeStringWithCodeScheme3831SECURITYDBOSECURITY_MASTERPROCESS_SEC_TYPE EagleML/accountingTransaction/unsettledTransactions/processingSecurityType
securityTypestring82SECURITYDBOSECURITY_MASTERSECURITY_TYPE EagleML/accountingTransaction/unsettledTransactions/securityType
issueCountryCodeCountryCode1418SECURITYDBOSECURITY_MASTERNRA_TAX_COUNTRY EagleML/accountingTransaction/unsettledTransactions/issueCountryCode
couponTypeCodeStringWithCodeScheme97SECURITYDBOSECURITY_MASTERCOUPON_TYPE_CODE EagleML/accountingTransaction/unsettledTransactions/couponTypeCode
smSecurityTypestring10175SECURITYDBOSECMASTER_DETAIL_EXTSECURITY_TYPE EagleML/accountingTransaction/unsettledTransactions/smSecurityType
securityType2string10103SECURITYDBOSECMASTER_DETAIL_EXTSECURITY_TYPE2 EagleML/accountingTransaction/unsettledTransactions/securityType2
securitySubTypestring1464SECURITYDBOSECURITY_MASTER_DETAILALT_SECURITY_TYPE EagleML/accountingTransaction/unsettledTransactions/securitySubType
issuerIdstring1141    EagleML/accountingTransaction/unsettledTransactions/issuerId
priceMultiplierdecimal18SECURITYDBOSECURITY_MASTERPRICE_MULTIPLIER EagleML/accountingTransaction/unsettledTransactions/priceMultiplier
quantityScaledecimal19SECURITYDBOSECURITY_MASTERTRADING_UNIT EagleML/accountingTransaction/unsettledTransactions/quantityScale
optiondescrstring1364    EagleML/accountingTransaction/unsettledTransactions/optiondescr
premiumTypestring3302SECURITYDBODERIVATIVESPREMIUM_TYPE EagleML/accountingTransaction/unsettledTransactions/premiumType
interestPaymentTimingstring1523SECURITYDBOFIXED_INCOMEACCRUAL_METHOD EagleML/accountingTransaction/unsettledTransactions/interestPaymentTiming
businessDayConventionstring1536SECURITYDBOFIXED_INCOMEINTEREST_METHOD_CODE EagleML/accountingTransaction/unsettledTransactions/businessDayConvention
varRateFreqCodestring1788SECURITYDBOFIXED_INCOMEVAR_RATE_FREQ_CODE EagleML/accountingTransaction/unsettledTransactions/varRateFreqCode
paymentFrequencyCodestring472SECURITYDBOSECURITY_MASTERDAY_CNT EagleML/accountingTransaction/unsettledTransactions/paymentFrequencyCode
dayCountBasisstring471SECURITYDBOSECURITY_MASTERCOUPON_FREQ_CODE EagleML/accountingTransaction/unsettledTransactions/dayCountBasis
quantityTypestring12    EagleML/accountingTransaction/unsettledTransactions/quantityType
businessCalendarNamestring1480SECURITYDBOSECURITY_MASTER_DETAILBUSINESSDAY EagleML/accountingTransaction/unsettledTransactions/businessCalendarName
notionalResetTypestring4409SECURITYDBOSWAPSNOTIONAL_RESET_TYPE EagleML/accountingTransaction/unsettledTransactions/notionalResetType
payRecIndicatorstring4590SECURITYDBOSWAPSPAY_RECIEVE_IND EagleML/accountingTransaction/unsettledTransactions/payRecIndicator
smPoolNumberstring107SECURITYDBOSECURITY_MASTERPOOL_NUMBER EagleML/accountingTransaction/unsettledTransactions/smPoolNumber
maturityDatedate38SECURITYDBOSECURITY_MASTERMAT_DATE EagleML/accountingTransaction/unsettledTransactions/maturityDate
effectiveDatedate1109calculated value EagleML/accountingTransaction/unsettledTransactions/effectiveDate
instanceinteger9388calculated value EagleML/accountingTransaction/unsettledTransactions/instance
localCurrencyCurrencyCode63calculated value EagleML/accountingTransaction/unsettledTransactions/localCurrency
baseCurrencyCurrencyCode86calculated value EagleML/accountingTransaction/unsettledTransactions/baseCurrency
accountingBasisstring21calculated value EagleML/accountingTransaction/unsettledTransactions/accountingBasis
longShortCstring15calculated value EagleML/accountingTransaction/unsettledTransactions/longShortC
backupSrcSysCstring not stored in DB EagleML/accountingTransaction/unsettledTransactions/backupSrcSysC
starPositionIdinteger830ESTARESTAR_TRADED_CASH_ACTIVITYPOSN_IDNUMBER(28)EagleML/accountingTransaction/unsettledTransactions/starPositionId
settleAssetAsset Identifiers Model80    EagleML/accountingTransaction/unsettledTransactions/settleAsset/
shareClassstring34calculated value EagleML/accountingTransaction/unsettledTransactions/shareClass
eventIdTransactionId25calculated value EagleML/accountingTransaction/unsettledTransactions/eventId
starEventTypestring2362ESTARESTAR_TRADED_CASH_ACTIVITYEVENT_TYPEVARCHAR2(25)EagleML/accountingTransaction/unsettledTransactions/starEventType
eventTypestring53ESTARESTAR_TRADED_CASH_ACTIVITYCASH_EVT_TYPVARCHAR2(10)EagleML/accountingTransaction/unsettledTransactions/eventType
eventSequenceinteger126calculated value EagleML/accountingTransaction/unsettledTransactions/eventSequence
processDatedate30not stored in DB EagleML/accountingTransaction/unsettledTransactions/processDate
accountingDatedate36calculated value EagleML/accountingTransaction/unsettledTransactions/accountingDate
monthEndAccountingDatedate4733calculated value EagleML/accountingTransaction/unsettledTransactions/monthEndAccountingDate
unitsdecimal40calculated value EagleML/accountingTransaction/unsettledTransactions/units
amountdecimal50calculated value EagleML/accountingTransaction/unsettledTransactions/amount
principaldecimal165calculated value EagleML/accountingTransaction/unsettledTransactions/principal
incomedecimal1985calculated value EagleML/accountingTransaction/unsettledTransactions/income
navIdinteger3196calculated value EagleML/accountingTransaction/unsettledTransactions/navId
cashStatusstring54calculated value EagleML/accountingTransaction/unsettledTransactions/cashStatus
cashCategorystring62calculated value EagleML/accountingTransaction/unsettledTransactions/cashCategory
bankAliasstring16calculated value EagleML/accountingTransaction/unsettledTransactions/bankAlias
autoSettleIndicatorYesNoOptionEnum58calculated value EagleML/accountingTransaction/unsettledTransactions/autoSettleIndicator
corpActionIdinteger60calculated value EagleML/accountingTransaction/unsettledTransactions/corpActionId
ledgerBalanceEntitlementstring3970calculated value EagleML/accountingTransaction/unsettledTransactions/ledgerBalanceEntitlement
accountingPlaninteger999calculated value EagleML/accountingTransaction/unsettledTransactions/accountingPlan
positingPlaninteger913calculated value EagleML/accountingTransaction/unsettledTransactions/positingPlan
recPayPlanstring1831calculated value EagleML/accountingTransaction/unsettledTransactions/recPayPlan
withholdingLocaldecimal853calculated value EagleML/accountingTransaction/unsettledTransactions/withholdingLocal
reclaimLocaldecimal852calculated value EagleML/accountingTransaction/unsettledTransactions/reclaimLocal
reclaimMethodstring3912calculated value EagleML/accountingTransaction/unsettledTransactions/reclaimMethod
batchEventIdTransactionId701calculated value EagleML/accountingTransaction/unsettledTransactions/batchEventId
contSettleDatedate9968calculated value EagleML/accountingTransaction/unsettledTransactions/contSettleDate
linkEventIdTransactionId28ESTARESTAR_TRADED_CASH_ACTIVITYLINK_EVENT_IDVARCHAR2(55)EagleML/accountingTransaction/unsettledTransactions/linkEventId
targetEventIdstring26calculated value EagleML/accountingTransaction/unsettledTransactions/targetEventId
eventReasonstring56calculated value EagleML/accountingTransaction/unsettledTransactions/eventReason
cancelEventIdTransactionId501calculated value EagleML/accountingTransaction/unsettledTransactions/cancelEventId
cancelSequenceinteger226calculated value EagleML/accountingTransaction/unsettledTransactions/cancelSequence
recPayAccount2string1826calculated value EagleML/accountingTransaction/unsettledTransactions/recPayAccount2
principalBreakageUnderdecimal10134calculated value EagleML/accountingTransaction/unsettledTransactions/principalBreakageUnder
principalBreakageOverdecimal10135calculated value EagleML/accountingTransaction/unsettledTransactions/principalBreakageOver
incomeBreakageUnderdecimal10136calculated value EagleML/accountingTransaction/unsettledTransactions/incomeBreakageUnder
incomeBreakageOverdecimal10137calculated value EagleML/accountingTransaction/unsettledTransactions/incomeBreakageOver
otherFeeLocaldecimal3752calculated value EagleML/accountingTransaction/unsettledTransactions/otherFeeLocal
stampDutyTaxLocaldecimal51calculated value EagleML/accountingTransaction/unsettledTransactions/stampDutyTaxLocal
commAmountLocaldecimal47calculated value EagleML/accountingTransaction/unsettledTransactions/commAmountLocal
taxAmountLocaldecimal46calculated value EagleML/accountingTransaction/unsettledTransactions/taxAmountLocal
secFeedecimal48calculated value EagleML/accountingTransaction/unsettledTransactions/secFee
backupPricedecimal not stored in DB EagleML/accountingTransaction/unsettledTransactions/backupPrice
settleAmountLocaldecimal5363calculated value EagleML/accountingTransaction/unsettledTransactions/settleAmountLocal
brokerCodestring88calculated value EagleML/accountingTransaction/unsettledTransactions/brokerCode
dividendRatedecimal368calculated value EagleML/accountingTransaction/unsettledTransactions/dividendRate
currencyGaindecimal198calculated value EagleML/accountingTransaction/unsettledTransactions/currencyGain
currencyLossdecimal199calculated value EagleML/accountingTransaction/unsettledTransactions/currencyLoss
localAssetCurrencyCurrencyCode9061calculated value EagleML/accountingTransaction/unsettledTransactions/localAssetCurrency
masterTicketNumberstring761calculated value EagleML/accountingTransaction/unsettledTransactions/masterTicketNumber
tradeDateFxRatedecimal87calculated value EagleML/accountingTransaction/unsettledTransactions/tradeDateFxRate
corpActInstanceinteger4268ESTARESTAR_TRADED_CASH_ACTIVITYCORP_ACT_INSTANCENUMBEREagleML/accountingTransaction/unsettledTransactions/corpActInstance
netAmountBasedecimal478calculated value EagleML/accountingTransaction/unsettledTransactions/netAmountBase
principalAmountBasedecimal169calculated value EagleML/accountingTransaction/unsettledTransactions/principalAmountBase
incomeAmountBasedecimal1986calculated value EagleML/accountingTransaction/unsettledTransactions/incomeAmountBase
recPayAccountstring1825calculated value EagleML/accountingTransaction/unsettledTransactions/recPayAccount
recPayAccountDescstring1651calculated value EagleML/accountingTransaction/unsettledTransactions/recPayAccountDesc
reclaimAmountBasedecimal851calculated value EagleML/accountingTransaction/unsettledTransactions/reclaimAmountBase
taxExpenseBasedecimal854calculated value EagleML/accountingTransaction/unsettledTransactions/taxExpenseBase
breakageAmountUnderBasedecimal1995calculated value EagleML/accountingTransaction/unsettledTransactions/breakageAmountUnderBase
breakageAmountOverBasedecimal1997calculated value EagleML/accountingTransaction/unsettledTransactions/breakageAmountOverBase
recPayAmountLocaldecimal1998calculated value EagleML/accountingTransaction/unsettledTransactions/recPayAmountLocal
recPayAmountBasedecimal1999calculated value EagleML/accountingTransaction/unsettledTransactions/recPayAmountBase
clearingBrokerstring1236calculated value EagleML/accountingTransaction/unsettledTransactions/clearingBroker
taxReclaimRatedecimal1296calculated value EagleML/accountingTransaction/unsettledTransactions/taxReclaimRate
taxWithholdingRatedecimal1295calculated value EagleML/accountingTransaction/unsettledTransactions/taxWithholdingRate
specialReclaimRatedecimal1298calculated value EagleML/accountingTransaction/unsettledTransactions/specialReclaimRate
specialWithholdingRatedecimal1297calculated value EagleML/accountingTransaction/unsettledTransactions/specialWithholdingRate
sourceEventIdTransactionId23calculated value EagleML/accountingTransaction/unsettledTransactions/sourceEventId
targetAccountDatedate119calculated value EagleML/accountingTransaction/unsettledTransactions/targetAccountDate
gainSwapLocaldecimal11819calculated value EagleML/accountingTransaction/unsettledTransactions/gainSwapLocal
lossSwapLocaldecimal11821calculated value EagleML/accountingTransaction/unsettledTransactions/lossSwapLocal
gainSwapBasedecimal11820calculated value EagleML/accountingTransaction/unsettledTransactions/gainSwapBase
lossSwapBasedecimal11822calculated value EagleML/accountingTransaction/unsettledTransactions/lossSwapBase
termLoanFeeIncLocaldecimal844calculated value EagleML/accountingTransaction/unsettledTransactions/termLoanFeeIncLocal
termLoanFeeIncBasedecimal845calculated value EagleML/accountingTransaction/unsettledTransactions/termLoanFeeIncBase
termLoanFeeExpLocaldecimal846calculated value EagleML/accountingTransaction/unsettledTransactions/termLoanFeeExpLocal
termLoanFeeExpBasedecimal847calculated value EagleML/accountingTransaction/unsettledTransactions/termLoanFeeExpBase
commAmountBasedecimal498calculated value EagleML/accountingTransaction/unsettledTransactions/commAmountBase
otherFeeBasedecimal5708calculated value EagleML/accountingTransaction/unsettledTransactions/otherFeeBase
secFeeBasedecimal10122calculated value EagleML/accountingTransaction/unsettledTransactions/secFeeBase
stampDutyTaxBasedecimal10121calculated value EagleML/accountingTransaction/unsettledTransactions/stampDutyTaxBase
fedTaxWithholdingBasedecimal8078calculated value EagleML/accountingTransaction/unsettledTransactions/fedTaxWithholdingBase
stTaxWithholdingBasedecimal8079calculated value EagleML/accountingTransaction/unsettledTransactions/stTaxWithholdingBase
streamSecAliasinteger not stored in DB EagleML/accountingTransaction/unsettledTransactions/streamSecAlias
taxAmountBasedecimal10759calculated value EagleML/accountingTransaction/unsettledTransactions/taxAmountBase
buWithholdingLocaldecimal2712calculated value EagleML/accountingTransaction/unsettledTransactions/buWithholdingLocal
buWithholdingBasedecimal2713calculated value EagleML/accountingTransaction/unsettledTransactions/buWithholdingBase
buWithholdingRatedecimal2762calculated value EagleML/accountingTransaction/unsettledTransactions/buWithholdingRate
pricedecimal45calculated value EagleML/accountingTransaction/unsettledTransactions/price
cancelTypestring not stored in DB EagleML/accountingTransaction/unsettledTransactions/cancelType
cancelFlagstring not stored in DB EagleML/accountingTransaction/unsettledTransactions/cancelFlag
couponDatedate not stored in DB EagleML/accountingTransaction/unsettledTransactions/couponDate
cashEventSpawnedstring not stored in DB EagleML/accountingTransaction/unsettledTransactions/cashEventSpawned
backupCouponEndDatedate not stored in DB EagleML/accountingTransaction/unsettledTransactions/backupCouponEndDate
origContSettleDatedate not stored in DB EagleML/accountingTransaction/unsettledTransactions/origContSettleDate
periodicDistTypestring1737calculated value EagleML/accountingTransaction/unsettledTransactions/periodicDistType
costLotOpenEventIdTransactionId not stored in DB EagleML/accountingTransaction/unsettledTransactions/costLotOpenEventId
costLotCloseEventIdTransactionId not stored in DB EagleML/accountingTransaction/unsettledTransactions/costLotCloseEventId
corpActionTypestring not stored in DB EagleML/accountingTransaction/unsettledTransactions/corpActionType
cashAccountNamestring11696calculated value EagleML/accountingTransaction/unsettledTransactions/cashAccountName
cashAccountstring11697calculated value EagleML/accountingTransaction/unsettledTransactions/cashAccount
cashAccountAliasinteger11698calculated value EagleML/accountingTransaction/unsettledTransactions/cashAccountAlias
srcSysCstring98calculated value EagleML/accountingTransaction/unsettledTransactions/srcSysC
withholdingTaxLocaldecimal703calculated value EagleML/accountingTransaction/unsettledTransactions/withholdingTaxLocal
withholdingTaxBasedecimal704calculated value EagleML/accountingTransaction/unsettledTransactions/withholdingTaxBase
unsettleBalanceBasedecimal9644calculated value EagleML/accountingTransaction/unsettledTransactions/unsettleBalanceBase
unsettleBalanceLocaldecimal9643calculated value EagleML/accountingTransaction/unsettledTransactions/unsettleBalanceLocal
grossAmountBasedecimal330calculated value EagleML/accountingTransaction/unsettledTransactions/grossAmountBase
grossAmountLocaldecimal325calculated value EagleML/accountingTransaction/unsettledTransactions/grossAmountLocal
currentFxRatedecimal96calculated value EagleML/accountingTransaction/unsettledTransactions/currentFxRate
marketValuedecimal488calculated value EagleML/accountingTransaction/unsettledTransactions/marketValue
uRGLCurrentBasedecimal493calculated value EagleML/accountingTransaction/unsettledTransactions/uRGLCurrentBase
backupWithholdingLocaldecimal2314calculated value EagleML/accountingTransaction/unsettledTransactions/backupWithholdingLocal
backupWithholdingBasedecimal2319calculated value EagleML/accountingTransaction/unsettledTransactions/backupWithholdingBase
daysPastDuedecimal4610calculated value EagleML/accountingTransaction/unsettledTransactions/daysPastDue
endDatedate221calculated value EagleML/accountingTransaction/unsettledTransactions/endDate
dateTypeUnsettledTxnDateTypeEnum1257calculated value EagleML/accountingTransaction/unsettledTransactions/dateType
topEntityNamestring1159RULESDBOENTITYENTITY_NAME EagleML/accountingTransaction/unsettledTransactions/topEntityName
couponstring70SECURITYDBOSECURITY_MASTERCOUPON EagleML/accountingTransaction/unsettledTransactions/coupon
cusipChangestring1348SECURITYDBOSECURITY_MASTERCUSIP_CHANGE EagleML/accountingTransaction/unsettledTransactions/cusipChange
minorIndstring1417SECURITYDBOSECURITY_MASTERMINOR_IND EagleML/accountingTransaction/unsettledTransactions/minorInd
sectorNamestring1156    EagleML/accountingTransaction/unsettledTransactions/sectorName
regulatoryCategoryChangedstring891    EagleML/accountingTransaction/unsettledTransactions/regulatoryCategoryChanged
granularityCategorystring11476    EagleML/accountingTransaction/unsettledTransactions/granularityCategory
userGroup19string10000    EagleML/accountingTransaction/unsettledTransactions/userGroup19
custodyBankAccountNumberstring1660    EagleML/accountingTransaction/unsettledTransactions/custodyBankAccountNumber
custodyBankCodestring1240    EagleML/accountingTransaction/unsettledTransactions/custodyBankCode
custodyBankDescstring1146    EagleML/accountingTransaction/unsettledTransactions/custodyBankDesc

 

 

  • No labels