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