...
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 (extract-only) | 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 (extract-only) | 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 |
...