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

« Previous Version 4 Current »

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
Entity Common Id ModelEagleML/accountingTransaction/unsettledTransactions/
Entity Properties Model (extract-only) EagleML/accountingTransaction/unsettledTransactions/
Asset Identifiers ModelEagleML/accountingTransaction/unsettledTransactions/
Extended Asset Properties Model (extract-only)EagleML/accountingTransaction/unsettledTransactions/
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 Model  - see extra tableEagleML/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