Unsettled Transactions Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | Xpath |
|---|---|---|---|---|---|---|---|
objectType | ObjectTypeEnum | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/objectType | ||
objectId | ObjectId | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/objectId | ||
objectDescription | FeedTypeEnum | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/objectDescription | ||
updateTimestamp | dateTime | 1106 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SYSTEM_DATE | DATE | EagleML/accountingTransaction/unsettledTransactions/updateTimestamp |
updateSource | string | 944 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/updateSource | ||
EagleML/accountingTransaction/unsettledTransactions/ | |||||||
EagleML/accountingTransaction/unsettledTransactions/ | |||||||
EagleML/accountingTransaction/unsettledTransactions/ | |||||||
EagleML/accountingTransaction/unsettledTransactions/ | |||||||
maturityDate | date | 38 | SECURITYDBO | SECURITY_MASTER | MAT_DATE | Â | EagleML/accountingTransaction/unsettledTransactions/maturityDate |
effectiveDate | date | 1109 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/effectiveDate | ||
instance | integer | 9388 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/instance | ||
localCurrency | CurrencyCode | 63 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/localCurrency | ||
baseCurrency | CurrencyCode | 86 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/baseCurrency | ||
accountingBasis | string | 21 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/accountingBasis | ||
longShortC | string | 15 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/longShortC | ||
backupSrcSysC | string | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/backupSrcSysC | ||
starPositionId | integer | 830 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | POSN_ID | NUMBER(28) | EagleML/accountingTransaction/unsettledTransactions/starPositionId |
settleAsset | Asset Identifiers Model  - see extra table | EagleML/accountingTransaction/unsettledTransactions/settleAsset/ | |||||
shareClass | string | 34 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/shareClass | ||
eventId | TransactionId | 25 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/eventId | ||
starEventType | string | 2362 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_TYPE | VARCHAR2(25) | EagleML/accountingTransaction/unsettledTransactions/starEventType |
eventType | string | 53 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_EVT_TYP | VARCHAR2(10) | EagleML/accountingTransaction/unsettledTransactions/eventType |
eventSequence | integer | 126 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/eventSequence | ||
processDate | date | 30 | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/processDate | ||
accountingDate | date | 36 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/accountingDate | ||
monthEndAccountingDate | date | 4733 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/monthEndAccountingDate | ||
units | decimal | 40 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/units | ||
amount | decimal | 50 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/amount | ||
principal | decimal | 165 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/principal | ||
income | decimal | 1985 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/income | ||
navId | integer | 3196 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/navId | ||
cashStatus | string | 54 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/cashStatus | ||
cashCategory | string | 62 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/cashCategory | ||
bankAlias | string | 16 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/bankAlias | ||
autoSettleIndicator | YesNoOptionEnum | 58 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/autoSettleIndicator | ||
corpActionId | integer | 60 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/corpActionId | ||
ledgerBalanceEntitlement | string | 3970 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/ledgerBalanceEntitlement | ||
accountingPlan | integer | 999 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/accountingPlan | ||
positingPlan | integer | 913 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/positingPlan | ||
recPayPlan | string | 1831 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/recPayPlan | ||
withholdingLocal | decimal | 853 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/withholdingLocal | ||
reclaimLocal | decimal | 852 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/reclaimLocal | ||
reclaimMethod | string | 3912 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/reclaimMethod | ||
batchEventId | TransactionId | 701 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/batchEventId | ||
contSettleDate | date | 9968 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/contSettleDate | ||
linkEventId | TransactionId | 28 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LINK_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/unsettledTransactions/linkEventId |
targetEventId | string | 26 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/targetEventId | ||
eventReason | string | 56 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/eventReason | ||
cancelEventId | TransactionId | 501 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/cancelEventId | ||
cancelSequence | integer | 226 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/cancelSequence | ||
recPayAccount2 | string | 1826 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/recPayAccount2 | ||
principalBreakageUnder | decimal | 10134 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/principalBreakageUnder | ||
principalBreakageOver | decimal | 10135 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/principalBreakageOver | ||
incomeBreakageUnder | decimal | 10136 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/incomeBreakageUnder | ||
incomeBreakageOver | decimal | 10137 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/incomeBreakageOver | ||
otherFeeLocal | decimal | 3752 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/otherFeeLocal | ||
stampDutyTaxLocal | decimal | 51 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/stampDutyTaxLocal | ||
commAmountLocal | decimal | 47 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/commAmountLocal | ||
taxAmountLocal | decimal | 46 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/taxAmountLocal | ||
secFee | decimal | 48 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/secFee | ||
backupPrice | decimal | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/backupPrice | ||
settleAmountLocal | decimal | 5363 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/settleAmountLocal | ||
brokerCode | string | 88 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/brokerCode | ||
dividendRate | decimal | 368 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/dividendRate | ||
currencyGain | decimal | 198 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/currencyGain | ||
currencyLoss | decimal | 199 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/currencyLoss | ||
localAssetCurrency | CurrencyCode | 9061 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/localAssetCurrency | ||
masterTicketNumber | string | 761 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/masterTicketNumber | ||
tradeDateFxRate | decimal | 87 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/tradeDateFxRate | ||
corpActInstance | integer | 4268 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORP_ACT_INSTANCE | NUMBER | EagleML/accountingTransaction/unsettledTransactions/corpActInstance |
netAmountBase | decimal | 478 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/netAmountBase | ||
principalAmountBase | decimal | 169 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/principalAmountBase | ||
incomeAmountBase | decimal | 1986 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/incomeAmountBase | ||
recPayAccount | string | 1825 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/recPayAccount | ||
recPayAccountDesc | string | 1651 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/recPayAccountDesc | ||
reclaimAmountBase | decimal | 851 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/reclaimAmountBase | ||
taxExpenseBase | decimal | 854 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/taxExpenseBase | ||
breakageAmountUnderBase | decimal | 1995 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/breakageAmountUnderBase | ||
breakageAmountOverBase | decimal | 1997 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/breakageAmountOverBase | ||
recPayAmountLocal | decimal | 1998 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/recPayAmountLocal | ||
recPayAmountBase | decimal | 1999 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/recPayAmountBase | ||
clearingBroker | string | 1236 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/clearingBroker | ||
taxReclaimRate | decimal | 1296 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/taxReclaimRate | ||
taxWithholdingRate | decimal | 1295 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/taxWithholdingRate | ||
specialReclaimRate | decimal | 1298 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/specialReclaimRate | ||
specialWithholdingRate | decimal | 1297 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/specialWithholdingRate | ||
sourceEventId | TransactionId | 23 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/sourceEventId | ||
targetAccountDate | date | 119 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/targetAccountDate | ||
gainSwapLocal | decimal | 11819 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/gainSwapLocal | ||
lossSwapLocal | decimal | 11821 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/lossSwapLocal | ||
gainSwapBase | decimal | 11820 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/gainSwapBase | ||
lossSwapBase | decimal | 11822 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/lossSwapBase | ||
termLoanFeeIncLocal | decimal | 844 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/termLoanFeeIncLocal | ||
termLoanFeeIncBase | decimal | 845 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/termLoanFeeIncBase | ||
termLoanFeeExpLocal | decimal | 846 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/termLoanFeeExpLocal | ||
termLoanFeeExpBase | decimal | 847 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/termLoanFeeExpBase | ||
commAmountBase | decimal | 498 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/commAmountBase | ||
otherFeeBase | decimal | 5708 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/otherFeeBase | ||
secFeeBase | decimal | 10122 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/secFeeBase | ||
stampDutyTaxBase | decimal | 10121 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/stampDutyTaxBase | ||
fedTaxWithholdingBase | decimal | 8078 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/fedTaxWithholdingBase | ||
stTaxWithholdingBase | decimal | 8079 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/stTaxWithholdingBase | ||
streamSecAlias | integer | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/streamSecAlias | ||
taxAmountBase | decimal | 10759 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/taxAmountBase | ||
buWithholdingLocal | decimal | 2712 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/buWithholdingLocal | ||
buWithholdingBase | decimal | 2713 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/buWithholdingBase | ||
buWithholdingRate | decimal | 2762 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/buWithholdingRate | ||
price | decimal | 45 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/price | ||
cancelType | string | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/cancelType | ||
cancelFlag | string | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/cancelFlag | ||
couponDate | date | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/couponDate | ||
cashEventSpawned | string | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/cashEventSpawned | ||
backupCouponEndDate | date | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/backupCouponEndDate | ||
origContSettleDate | date | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/origContSettleDate | ||
periodicDistType | string | 1737 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/periodicDistType | ||
costLotOpenEventId | TransactionId | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/costLotOpenEventId | ||
costLotCloseEventId | TransactionId | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/costLotCloseEventId | ||
corpActionType | string | Â | not stored in DB | Â | EagleML/accountingTransaction/unsettledTransactions/corpActionType | ||
cashAccountName | string | 11696 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/cashAccountName | ||
cashAccount | string | 11697 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/cashAccount | ||
cashAccountAlias | integer | 11698 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/cashAccountAlias | ||
srcSysC | string | 98 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/srcSysC | ||
withholdingTaxLocal | decimal | 703 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/withholdingTaxLocal | ||
withholdingTaxBase | decimal | 704 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/withholdingTaxBase | ||
unsettleBalanceBase | decimal | 9644 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/unsettleBalanceBase | ||
unsettleBalanceLocal | decimal | 9643 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/unsettleBalanceLocal | ||
grossAmountBase | decimal | 330 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/grossAmountBase | ||
grossAmountLocal | decimal | 325 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/grossAmountLocal | ||
currentFxRate | decimal | 96 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/currentFxRate | ||
marketValue | decimal | 488 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/marketValue | ||
uRGLCurrentBase | decimal | 493 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/uRGLCurrentBase | ||
backupWithholdingLocal | decimal | 2314 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/backupWithholdingLocal | ||
backupWithholdingBase | decimal | 2319 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/backupWithholdingBase | ||
daysPastDue | decimal | 4610 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/daysPastDue | ||
endDate | date | 221 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/endDate | ||
dateType | UnsettledTxnDateTypeEnum | 1257 | calculated value | Â | EagleML/accountingTransaction/unsettledTransactions/dateType | ||
topEntityName | string | 1159 | RULESDBO | ENTITY | ENTITY_NAME | Â | EagleML/accountingTransaction/unsettledTransactions/topEntityName |
coupon | string | 70 | SECURITYDBO | SECURITY_MASTER | COUPON | Â | EagleML/accountingTransaction/unsettledTransactions/coupon |
cusipChange | string | 1348 | SECURITYDBO | SECURITY_MASTER | CUSIP_CHANGE | Â | EagleML/accountingTransaction/unsettledTransactions/cusipChange |
minorInd | string | 1417 | SECURITYDBO | SECURITY_MASTER | MINOR_IND | Â | EagleML/accountingTransaction/unsettledTransactions/minorInd |
sectorName | string | 1156 | Â | Â | Â | Â | EagleML/accountingTransaction/unsettledTransactions/sectorName |
regulatoryCategoryChanged | string | 891 | Â | Â | Â | Â | EagleML/accountingTransaction/unsettledTransactions/regulatoryCategoryChanged |
granularityCategory | string | 11476 | Â | Â | Â | Â | EagleML/accountingTransaction/unsettledTransactions/granularityCategory |
userGroup19 | string | 10000 | Â | Â | Â | Â | EagleML/accountingTransaction/unsettledTransactions/userGroup19 |
custodyBankAccountNumber | string | 1660 | Â | Â | Â | Â | EagleML/accountingTransaction/unsettledTransactions/custodyBankAccountNumber |
custodyBankCode | string | 1240 | Â | Â | Â | Â | EagleML/accountingTransaction/unsettledTransactions/custodyBankCode |
custodyBankDesc | string | 1146 | Â | Â | Â | Â | EagleML/accountingTransaction/unsettledTransactions/custodyBankDesc |
Â
Â