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 | EagleML/accountingTransaction/unsettledTransactions/ |
Asset Identifiers Model | EagleML/accountingTransaction/unsettledTransactions/ |
Extended Asset Properties Model | 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 |