...
| 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 | entityId | string | 5 | RULESDBO | ENTITY | ENTITY_ID | ||||||||||||
| Entity Common Id Model | EagleML/accountingTransaction/unsettledTransactions/ | entityIdentityName | string | 1617 | RULESDBO | ENTITY | ENTITY_NAME | |||||||||||||||
| Entity Properties Model | EagleML/accountingTransaction/unsettledTransactions/ | entityName|||||||||||||||||||||
| entityType | normalizedString | 1105 | RULESDBO | ENTITY | ENTITY_TYPE | EagleML/accountingTransaction/unsettledTransactions/entityType | ||||||||||||||||
| fxSource | string | 1102 | RULESDBO | ENTITY | FX_SOURCE | EagleML/accountingTransaction/unsettledTransactions/fxSource | ||||||||||||||||
| entityPriceMethod | string | 1872 | RULESDBO | ENTITY | PRICE_METHOD | EagleML/accountingTransaction/unsettledTransactions/entityPriceMethod | ||||||||||||||||
| countryOfTax | string | 1342 | RULESDBO | ENTITY | COUNTRY_OF_TAX | EagleML/accountingTransaction/unsettledTransactions/countryOfTax | ||||||||||||||||
| eabRegulatoryCategory | string | 12387 | RULESDBO | ENTITY_ACCT_BASIS | REGULATORY_CATEGORY | EagleML/accountingTransaction/unsettledTransactions/eabRegulatoryCategory | ||||||||||||||||
| starAcctField29 | string | 3928 | RULESDBO | ENTITY_STAR_PROCESSING | STAR_ACCT_FIELD_29 | EagleML/accountingTransaction/unsettledTransactions/starAcctField29 | ||||||||||||||||
| userField17 | string | 1642 | RULESDBO | ENTITY | USER_FIELD17 | EagleML/accountingTransaction/unsettledTransactions/userField17 | ||||||||||||||||
| userField18 | string | 1643 | RULESDBO | ENTITY | USER_FIELD18 | EagleML/accountingTransaction/unsettledTransactions/userField18 | ||||||||||||||||
| primaryAssetId | InstrumentId | 14 | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID | EagleML/accountingTransaction/unsettledTransactions/primaryAssetId | ||||||||||||||||
| primaryAssetType | InstrumentId | 1432 | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID_TYPE | EagleML/accountingTransaction/unsettledTransactions/primaryAssetType | ||||||||||||||||
| altAssetIdAndType Model | 1795, 5501 | EagleML/accountingTransaction/unsettledTransactions/altAssetIdAndType/ | ||||||||||||||||||||
| issueName | string | 961 | SECURITYDBO | SECURITY_MASTER | ISSUE_NAME | EagleML/accountingTransaction/unsettledTransactions/issueName | ||||||||||||||||
| issueDescription | Description | 962 | SECURITYDBO | SECURITY_MASTER | ISSUE_DESCRIPTION | EagleML/accountingTransaction/unsettledTransactions/issueDescription | ||||||||||||||||
| ticker | InstrumentId | 13 | SECURITYDBO | SECURITY_MASTER | TICKER | EagleML/accountingTransaction/unsettledTransactions/ticker | ||||||||||||||||
| securityAlias | integer | 10 | SECURITYDBO | SECURITY_MASTER | SECURITY_ALIAS | EagleML/accountingTransaction/unsettledTransactions/securityAlias | ||||||||||||||||
| investmentType | StringWithCodeScheme | 11 | SECURITYDBO | SECURITY_MASTER | INVESTMENT_TYPE | EagleML/accountingTransaction/unsettledTransactions/investmentType | ||||||||||||||||
| processingSecurityType | StringWithCodeScheme | 3831 | SECURITYDBO | SECURITY_MASTER | PROCESS_SEC_TYPE | EagleML/accountingTransaction/unsettledTransactions/processingSecurityType | ||||||||||||||||
| securityType | string | 82 | SECURITYDBO | SECURITY_MASTER | SECURITY_TYPE | EagleML/accountingTransaction/unsettledTransactions/securityType | ||||||||||||||||
| issueCountryCode | CountryCode | 1418 | SECURITYDBO | SECURITY_MASTER | NRA_TAX_COUNTRY | EagleML/accountingTransaction/unsettledTransactions/issueCountryCode | ||||||||||||||||
| couponTypeCode | StringWithCodeScheme | 97 | SECURITYDBO | SECURITY_MASTER | COUPON_TYPE_CODE | EagleML/accountingTransaction/unsettledTransactions/couponTypeCode | ||||||||||||||||
| smSecurityType | string | 10175 | SECURITYDBO | SECMASTER_DETAIL_EXT | SECURITY_TYPE | EagleML/accountingTransaction/unsettledTransactions/smSecurityType | ||||||||||||||||
| securityType2 | string | 10103 | SECURITYDBO | SECMASTER_DETAIL_EXT | SECURITY_TYPE2 | EagleML/accountingTransaction/unsettledTransactions/securityType2 | ||||||||||||||||
| securitySubType | string | 1464 | SECURITYDBO | SECURITY_MASTER_DETAIL | ALT_SECURITY_TYPE | EagleML/accountingTransaction/unsettledTransactions/securitySubType | ||||||||||||||||
| issuerId | string | 1141 | EagleML/accountingTransaction/unsettledTransactions/issuerId | |||||||||||||||||||
| priceMultiplier | decimal | 18 | SECURITYDBO | SECURITY_MASTER | PRICE_MULTIPLIER | EagleML/accountingTransaction/unsettledTransactions/priceMultiplier | ||||||||||||||||
| quantityScale | decimal | 19 | SECURITYDBO | SECURITY_MASTER | TRADING_UNIT | EagleML/accountingTransaction/unsettledTransactions/quantityScale | ||||||||||||||||
| optiondescr | string | 1364 | EagleML/accountingTransaction/unsettledTransactions/optiondescr | |||||||||||||||||||
| premiumType | string | 3302 | SECURITYDBO | DERIVATIVES | PREMIUM_TYPE | EagleML/accountingTransaction/unsettledTransactions/premiumType | ||||||||||||||||
| interestPaymentTiming | string | 1523 | SECURITYDBO | FIXED_INCOME | ACCRUAL_METHOD | EagleML/accountingTransaction/unsettledTransactions/interestPaymentTiming | ||||||||||||||||
| businessDayConvention | string | 1536 | SECURITYDBO | FIXED_INCOME | INTEREST_METHOD_CODE | EagleML/accountingTransaction/unsettledTransactions/businessDayConvention | ||||||||||||||||
| varRateFreqCode | string | 1788 | SECURITYDBO | FIXED_INCOME | VAR_RATE_FREQ_CODE | EagleML/accountingTransaction/unsettledTransactions/varRateFreqCode | ||||||||||||||||
| paymentFrequencyCode | string | 472 | SECURITYDBO | SECURITY_MASTER | DAY_CNT | EagleML/accountingTransaction/unsettledTransactions/paymentFrequencyCode | ||||||||||||||||
| dayCountBasis | string | 471 | SECURITYDBO | SECURITY_MASTER | COUPON_FREQ_CODE | EagleML/accountingTransaction/unsettledTransactions/dayCountBasis | ||||||||||||||||
| quantityType | string | 12 | EagleML/accountingTransaction/unsettledTransactions/quantityType | |||||||||||||||||||
| businessCalendarName | string | 1480 | SECURITYDBO | SECURITY_MASTER_DETAIL | BUSINESSDAY | EagleML/accountingTransaction/unsettledTransactions/businessCalendarName | ||||||||||||||||
| notionalResetType | string | 4409 | SECURITYDBO | SWAPS | NOTIONAL_RESET_TYPE | EagleML/accountingTransaction/unsettledTransactions/notionalResetType | ||||||||||||||||
| payRecIndicator | string | 4590 | SECURITYDBO | SWAPS | PAY_RECIEVE_IND | Asset Identifiers Model | EagleML/accountingTransaction/unsettledTransactions/ | payRecIndicatorsmPoolNumber | string | 107 | SECURITYDBO | SECURITY_MASTER | POOL_NUMBER | |||||||||
| Extended Asset Properties Model | EagleML/accountingTransaction/unsettledTransactions/ | smPoolNumber|||||||||||||||||||||
| 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 | 80 | - 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 | 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 | |||||||||||||||||||
...