Realized Gain Loss Data Map Table
Please note, that some fields * are supported for extract only starting from DB version >= v17R2.27.
Element | Optional/Required | Value Type | Star Tag | Xpath |
---|---|---|---|---|
objectType |
| ObjectTypeEnum |
| EagleML/accountingTransaction/realizedGainLoss/objectType |
objectId |
| ObjectId |
| EagleML/accountingTransaction/realizedGainLoss/objectId |
objectDescription |
| FeedTypeEnum |
| EagleML/accountingTransaction/realizedGainLoss/objectDescription |
updateTimestamp |
| dateTime |
| EagleML/accountingTransaction/realizedGainLoss/updateTimestamp |
customElements |
| CustomElements |
| EagleML/accountingTransaction/realizedGainLoss/customElements |
updateSource |
| string |
| EagleML/accountingTransaction/realizedGainLoss/updateSource |
tagNochangecase |
| string |
| EagleML/accountingTransaction/realizedGainLoss/tagNochangecase |
EagleML/accountingTransaction/realizedGainLoss/ | ||||
EagleML/accountingTransaction/realizedGainLoss/ | ||||
accountingBasis |
| string |
| EagleML/accountingTransaction/realizedGainLoss/accountingBasis |
regulatoryCategory |
| string | 12387 | EagleML/accountingTransaction/realizedGainLoss/regulatoryCategory |
regulatoryCategoryChanged |
| string | 891 | EagleML/accountingTransaction/realizedGainLoss/regulatoryCategoryChanged |
startDate |
| date |
| EagleML/accountingTransaction/realizedGainLoss/startDate |
endDate |
| date |
| EagleML/accountingTransaction/realizedGainLoss/endDate |
weight |
| decimal | 4232 | EagleML/accountingTransaction/realizedGainLoss/weight |
sourceName |
| string | 1102 | EagleML/accountingTransaction/realizedGainLoss/sourceName |
startComments |
| string | 12075 | EagleML/accountingTransaction/realizedGainLoss/startComments |
endComments |
| string | 2520 | EagleML/accountingTransaction/realizedGainLoss/endComments |
entityDetailId |
| string | 5 | EagleML/accountingTransaction/realizedGainLoss/entityDetailId |
EagleML/accountingTransaction/realizedGainLoss/ | ||||
EagleML/accountingTransaction/realizedGainLoss/ | ||||
userGroup19 |
| string | 10000 | EagleML/accountingTransaction/realizedGainLoss/userGroup19 |
quantityScale |
| decimal | 19 | EagleML/accountingTransaction/realizedGainLoss/quantityScale |
maturityDate |
| date | 38 | EagleML/accountingTransaction/realizedGainLoss/maturityDate |
effectiveDate |
| date | 1109 | EagleML/accountingTransaction/realizedGainLoss/effectiveDate |
updateSwitch |
| string | 1076 | EagleML/accountingTransaction/realizedGainLoss/updateSwitch |
closeOpenEventId |
| TransactionId | 181 | EagleML/accountingTransaction/realizedGainLoss/closeOpenEventId |
closeEventId |
| TransactionId | 182 | EagleML/accountingTransaction/realizedGainLoss/closeEventId |
longShortIndicator |
| LongShortIndicatorEnum | 15 | EagleML/accountingTransaction/realizedGainLoss/longShortIndicator |
lotSelectionMethod |
| string | 27 | EagleML/accountingTransaction/realizedGainLoss/lotSelectionMethod |
xrefExchange |
| ExchangeCode | 1981 | EagleML/accountingTransaction/realizedGainLoss/xrefExchange |
smInactiveFlag |
| YesNoOptionEnum | 11043 | EagleML/accountingTransaction/realizedGainLoss/smInactiveFlag |
localCurrency |
| CurrencyCode |
| EagleML/accountingTransaction/realizedGainLoss/localCurrency |
tradeDate |
| date | 35 | EagleML/accountingTransaction/realizedGainLoss/tradeDate |
ledgerEffectiveDate |
| date | 36 | EagleML/accountingTransaction/realizedGainLoss/ledgerEffectiveDate |
settlementDate |
| date |
| EagleML/accountingTransaction/realizedGainLoss/settlementDate |
transactionCode |
| string | 2283 | EagleML/accountingTransaction/realizedGainLoss/transactionCode |
masterTicketNumber |
| string | 761 | EagleML/accountingTransaction/realizedGainLoss/masterTicketNumber |
numberofLots |
| integer | 192 | EagleML/accountingTransaction/realizedGainLoss/numberofLots |
exchangeCode |
| in_exchange_code | 17 | EagleML/accountingTransaction/realizedGainLoss/exchangeCode |
postType |
| string | 24 | EagleML/accountingTransaction/realizedGainLoss/postType |
targetEventId |
| TransactionId | 26 | EagleML/accountingTransaction/realizedGainLoss/targetEventId |
linkEventId |
| TransactionId | 28 | EagleML/accountingTransaction/realizedGainLoss/linkEventId |
postDate |
| date | 30 | EagleML/accountingTransaction/realizedGainLoss/postDate |
originalFaceValue |
| decimal | 41 | EagleML/accountingTransaction/realizedGainLoss/originalFaceValue |
settlementLocation |
| string | 43 | EagleML/accountingTransaction/realizedGainLoss/settlementLocation |
taxes |
| decimal | 46 | EagleML/accountingTransaction/realizedGainLoss/taxes |
localCommissionAmount |
| decimal | 47 | EagleML/accountingTransaction/realizedGainLoss/localCommissionAmount |
exchangeFee |
| decimal | 48 | EagleML/accountingTransaction/realizedGainLoss/exchangeFee |
accruedInterest |
| decimal | 49 | EagleML/accountingTransaction/realizedGainLoss/accruedInterest |
netCash |
| decimal | 50 | EagleML/accountingTransaction/realizedGainLoss/netCash |
otherFee |
| decimal | 51 | EagleML/accountingTransaction/realizedGainLoss/otherFee |
tradeStatus |
| string | 54 | EagleML/accountingTransaction/realizedGainLoss/tradeStatus |
trade_memo2 |
| string | 56 | EagleML/accountingTransaction/realizedGainLoss/trade_memo2 |
settlementCurrency |
| CurrencyCode | 63 | EagleML/accountingTransaction/realizedGainLoss/settlementCurrency |
settlementAmount |
| decimal | 64 | EagleML/accountingTransaction/realizedGainLoss/settlementAmount |
settlement_exchange_rate |
| decimal | 79 | EagleML/accountingTransaction/realizedGainLoss/settlement_exchange_rate |
fxRateOpen |
| decimal | 84 | EagleML/accountingTransaction/realizedGainLoss/fxRateOpen |
fxRate |
| decimal | 87 | EagleML/accountingTransaction/realizedGainLoss/fxRate |
brokerCode |
| BrokerCode | 88 | EagleML/accountingTransaction/realizedGainLoss/brokerCode |
unitCostBase |
| decimal | 4643 | EagleML/accountingTransaction/realizedGainLoss/unitCostBase |
costLocal |
| decimal | 162 | EagleML/accountingTransaction/realizedGainLoss/costLocal |
costBase |
| decimal | 166 | EagleML/accountingTransaction/realizedGainLoss/costBase |
unitOpenPrice |
| decimal | 160 | EagleML/accountingTransaction/realizedGainLoss/unitOpenPrice |
unitCostLocal |
| decimal | 4642 | EagleML/accountingTransaction/realizedGainLoss/unitCostLocal |
price |
| decimal | 45 | EagleML/accountingTransaction/realizedGainLoss/price |
tradeAmount |
| decimal | 190 | EagleML/accountingTransaction/realizedGainLoss/tradeAmount |
settleAmount0 |
| decimal | 191 | EagleML/accountingTransaction/realizedGainLoss/settleAmount0 |
closeHoldingPeriodDate |
| date | 192 | EagleML/accountingTransaction/realizedGainLoss/closeHoldingPeriodDate |
parOrShares |
| decimal |
| EagleML/accountingTransaction/realizedGainLoss/parOrShares |
premiumAllocatedLocal |
| decimal | 203 | EagleML/accountingTransaction/realizedGainLoss/premiumAllocatedLocal |
premiumAllocated |
| decimal |
| EagleML/accountingTransaction/realizedGainLoss/premiumAllocated |
origAcqDate |
| date | 216 | EagleML/accountingTransaction/realizedGainLoss/origAcqDate |
gainLossTerm |
| string | 238 | EagleML/accountingTransaction/realizedGainLoss/gainLossTerm |
openCostBasisType |
| string | 281 | EagleML/accountingTransaction/realizedGainLoss/openCostBasisType |
closeCostBasisType |
| string | 282 | EagleML/accountingTransaction/realizedGainLoss/closeCostBasisType |
tradeBaseAmount |
| decimal | 478 | EagleML/accountingTransaction/realizedGainLoss/tradeBaseAmount |
amortLocal |
| decimal | 521 | EagleML/accountingTransaction/realizedGainLoss/amortLocal |
amortBase |
| decimal | 522 | EagleML/accountingTransaction/realizedGainLoss/amortBase |
clientId |
| string | 1632 | EagleML/accountingTransaction/realizedGainLoss/clientId |
feeAmt |
| decimal | 3752 | EagleML/accountingTransaction/realizedGainLoss/feeAmt |
principalFactor |
| decimal | 4483 | EagleML/accountingTransaction/realizedGainLoss/principalFactor |
tipIncomeLtdLocal |
| decimal | 4538 | EagleML/accountingTransaction/realizedGainLoss/tipIncomeLtdLocal |
tipIncomeLtdBase |
| decimal | 4539 | EagleML/accountingTransaction/realizedGainLoss/tipIncomeLtdBase |
bookValueLocal |
| decimal | 4601 | EagleML/accountingTransaction/realizedGainLoss/bookValueLocal |
bookValue |
| decimal | 3767 | EagleML/accountingTransaction/realizedGainLoss/bookValue |
monthEndDate |
| date | 4733 | EagleML/accountingTransaction/realizedGainLoss/monthEndDate |
oidLocal |
| decimal | 5502 | EagleML/accountingTransaction/realizedGainLoss/oidLocal |
oidBase |
| decimal | 5503 | EagleML/accountingTransaction/realizedGainLoss/oidBase |
totalAmortLocal |
| decimal | 5685 | EagleML/accountingTransaction/realizedGainLoss/totalAmortLocal |
totalAmortBase |
| decimal | 5686 | EagleML/accountingTransaction/realizedGainLoss/totalAmortBase |
gainCurrency988 |
| decimal | 5819 | EagleML/accountingTransaction/realizedGainLoss/gainCurrency988 |
lossCurrency988 |
| decimal | 5820 | EagleML/accountingTransaction/realizedGainLoss/lossCurrency988 |
originalSourceCode |
| string | 9143 | EagleML/accountingTransaction/realizedGainLoss/originalSourceCode |
currencyGainInt |
| decimal | 9736 | EagleML/accountingTransaction/realizedGainLoss/currencyGainInt |
currencyLossInt |
| decimal | 9738 | EagleML/accountingTransaction/realizedGainLoss/currencyLossInt |
gainCurrency |
| decimal | 10049 | EagleML/accountingTransaction/realizedGainLoss/gainCurrency |
gainSecurityLocal |
| decimal | 10050 | EagleML/accountingTransaction/realizedGainLoss/gainSecurityLocal |
gainSecurity |
| decimal | 10051 | EagleML/accountingTransaction/realizedGainLoss/gainSecurity |
lossCurrency |
| decimal | 10052 | EagleML/accountingTransaction/realizedGainLoss/lossCurrency |
lossSecurityLocal |
| decimal | 10053 | EagleML/accountingTransaction/realizedGainLoss/lossSecurityLocal |
lossSecurity |
| decimal | 10054 | EagleML/accountingTransaction/realizedGainLoss/lossSecurity |
openCostLocal |
| decimal | 10056 | EagleML/accountingTransaction/realizedGainLoss/openCostLocal |
openCostBase |
| decimal | 10055 | EagleML/accountingTransaction/realizedGainLoss/openCostBase |
totalGain |
| decimal | 10057 | EagleML/accountingTransaction/realizedGainLoss/totalGain |
totalLoss |
| decimal | 10058 | EagleML/accountingTransaction/realizedGainLoss/totalLoss |
currBuiltinGlSec |
| decimal | 9761 | EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlSec |
currBuiltinGlCurrency |
| decimal | 10917 | EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlCurrency |
currBuiltinGlDeferred |
| decimal | 10918 | EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlDeferred |
currBuiltinGlOid |
| decimal | 10919 | EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlOid |
currBuiltinGlMktDisc |
| decimal | 10920 | EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlMktDisc |
acquisitionType |
| string | 2425,7001 | EagleML/accountingTransaction/realizedGainLoss/acquisitionType |
allocProceedsBase |
| decimal | 7660 | EagleML/accountingTransaction/realizedGainLoss/allocProceedsBase |
allocProceedsLocal |
| decimal | 7661 | EagleML/accountingTransaction/realizedGainLoss/allocProceedsLocal |
allUpRate |
| decimal | 7662 | EagleML/accountingTransaction/realizedGainLoss/allUpRate |
amortizationBase |
| decimal | 7663 | EagleML/accountingTransaction/realizedGainLoss/amortizationBase |
amortizationLocal |
| decimal | 7664 | EagleML/accountingTransaction/realizedGainLoss/amortizationLocal |
balance |
| decimal | 7665 | EagleML/accountingTransaction/realizedGainLoss/balance |
baseCommissionAmount |
| decimal | 7666 | EagleML/accountingTransaction/realizedGainLoss/baseCommissionAmount |
baseCostLot |
| decimal | 7667 | EagleML/accountingTransaction/realizedGainLoss/baseCostLot |
baseRealizedGlCurr |
| decimal | 7668 | EagleML/accountingTransaction/realizedGainLoss/baseRealizedGlCurr |
baseRealizedGlMkt |
| decimal | 7669 | EagleML/accountingTransaction/realizedGainLoss/baseRealizedGlMkt |
baseInterestAdj |
| decimal | 7670 | EagleML/accountingTransaction/realizedGainLoss/baseInterestAdj |
bnchYld1 |
| decimal | 7671 | EagleML/accountingTransaction/realizedGainLoss/bnchYld1 |
bnchYld2 |
| decimal | 7672 | EagleML/accountingTransaction/realizedGainLoss/bnchYld2 |
buyLotNbr |
| string | 7002 | EagleML/accountingTransaction/realizedGainLoss/buyLotNbr |
cancelDueToCorrection |
| string | 7003 | EagleML/accountingTransaction/realizedGainLoss/cancelDueToCorrection |
closeOutPl0 |
| decimal | 7673 | EagleML/accountingTransaction/realizedGainLoss/closeOutPl0 |
closeoutpl1 |
| decimal | 7674 | EagleML/accountingTransaction/realizedGainLoss/closeoutpl1 |
clsOpenCumExInd |
| string | 7004 | EagleML/accountingTransaction/realizedGainLoss/clsOpenCumExInd |
compared |
| string | 7005 | EagleML/accountingTransaction/realizedGainLoss/compared |
covFlag |
| string | 2819 | EagleML/accountingTransaction/realizedGainLoss/covFlag |
creditLossB |
| decimal | 2705 | EagleML/accountingTransaction/realizedGainLoss/creditLossB |
creditLossL |
| decimal | 2704 | EagleML/accountingTransaction/realizedGainLoss/creditLossL |
disallowGainB |
| decimal | 2434 | EagleML/accountingTransaction/realizedGainLoss/disallowGainB |
disallowGainL |
| decimal | 2433 | EagleML/accountingTransaction/realizedGainLoss/disallowGainL |
disallowLossB |
| decimal | 2431 | EagleML/accountingTransaction/realizedGainLoss/disallowLossB |
disallowLossL |
| decimal | 2430 | EagleML/accountingTransaction/realizedGainLoss/disallowLossL |
discountRate |
| decimal | 1314,7681 | EagleML/accountingTransaction/realizedGainLoss/discountRate |
dispBookValueGaap |
| decimal | 7682 | EagleML/accountingTransaction/realizedGainLoss/dispBookValueGaap |
dispBookValueStat |
| decimal | 7683 | EagleML/accountingTransaction/realizedGainLoss/dispBookValueStat |
eventSubPriority |
| integer | 2862,7684 | EagleML/accountingTransaction/realizedGainLoss/eventSubPriority |
exchangeFeeBase |
| decimal | 7685 | EagleML/accountingTransaction/realizedGainLoss/exchangeFeeBase |
fairMarketValueBase |
| decimal | 2429,7686 | EagleML/accountingTransaction/realizedGainLoss/fairMarketValueBase |
fairMarketValueFlag |
| string | 2427,7007 | EagleML/accountingTransaction/realizedGainLoss/fairMarketValueFlag |
fairMarketValueLocal |
| decimal | 2428,7687 | EagleML/accountingTransaction/realizedGainLoss/fairMarketValueLocal |
fairMarketValuePrice |
| decimal | 2452,7688 | EagleML/accountingTransaction/realizedGainLoss/fairMarketValuePrice |
federalTaxWithholdBase |
| decimal | 7689 | EagleML/accountingTransaction/realizedGainLoss/federalTaxWithholdBase |
feeamtBase |
| decimal | 7690 | EagleML/accountingTransaction/realizedGainLoss/feeamtBase |
gaapCostValue |
| decimal | 7691 | EagleML/accountingTransaction/realizedGainLoss/gaapCostValue |
gaapSecType |
| string | 7008 | EagleML/accountingTransaction/realizedGainLoss/gaapSecType |
gaapUnitCost |
| decimal | 7692 | EagleML/accountingTransaction/realizedGainLoss/gaapUnitCost |
gainCurrencyAvg |
| decimal | 7693 | EagleML/accountingTransaction/realizedGainLoss/gainCurrencyAvg |
gainCurrencyId |
| decimal | 7694 | EagleML/accountingTransaction/realizedGainLoss/gainCurrencyId |
gainSecurityAvg |
| decimal | 7695 | EagleML/accountingTransaction/realizedGainLoss/gainSecurityAvg |
gainSecurityAvgLocal |
| decimal | 7696 | EagleML/accountingTransaction/realizedGainLoss/gainSecurityAvgLocal |
gainSecurityId |
| decimal | 7697 | EagleML/accountingTransaction/realizedGainLoss/gainSecurityId |
gainSecurityIdLocal |
| decimal | 7698 | EagleML/accountingTransaction/realizedGainLoss/gainSecurityIdLocal |
interestSold |
| decimal |
| EagleML/accountingTransaction/realizedGainLoss/interestSold |
invertFlag |
| string | 7009 | EagleML/accountingTransaction/realizedGainLoss/invertFlag |
letterConfirm |
| string | 7010 | EagleML/accountingTransaction/realizedGainLoss/letterConfirm |
lettered |
| string | 7011 | EagleML/accountingTransaction/realizedGainLoss/lettered |
localCostLot |
| decimal | 7700 | EagleML/accountingTransaction/realizedGainLoss/localCostLot |
localGaapCostValue |
| decimal | 7701 | EagleML/accountingTransaction/realizedGainLoss/localGaapCostValue |
localGaapUnitCost |
| decimal | 7702 | EagleML/accountingTransaction/realizedGainLoss/localGaapUnitCost |
localRealizedGl |
| decimal | 7703 | EagleML/accountingTransaction/realizedGainLoss/localRealizedGl |
lossCurrencyAvg |
| decimal | 7704 | EagleML/accountingTransaction/realizedGainLoss/lossCurrencyAvg |
lossCurrencyId |
| decimal | 7705 | EagleML/accountingTransaction/realizedGainLoss/lossCurrencyId |
lossSecurityAvg |
| decimal | 7706 | EagleML/accountingTransaction/realizedGainLoss/lossSecurityAvg |
lossSecurityAvgLocal |
| decimal | 7707 | EagleML/accountingTransaction/realizedGainLoss/lossSecurityAvgLocal |
lossSecurityId |
| decimal | 7708 | EagleML/accountingTransaction/realizedGainLoss/lossSecurityId |
lossSecurityIdLocal |
| decimal | 7709 | EagleML/accountingTransaction/realizedGainLoss/lossSecurityIdLocal |
margin |
| decimal | 1483,7710 | EagleML/accountingTransaction/realizedGainLoss/margin |
marginPoints |
| decimal | 7711 | EagleML/accountingTransaction/realizedGainLoss/marginPoints |
monthlyAccountingDate |
| date | 7560 | EagleML/accountingTransaction/realizedGainLoss/monthlyAccountingDate |
mtType |
| string | 7012 | EagleML/accountingTransaction/realizedGainLoss/mtType |
nonCreditLossB |
| decimal | 7712 | EagleML/accountingTransaction/realizedGainLoss/nonCreditLossB |
nonCreditLossL |
| decimal | 7713 | EagleML/accountingTransaction/realizedGainLoss/nonCreditLossL |
notionalAmt |
| decimal | 7714 | EagleML/accountingTransaction/realizedGainLoss/notionalAmt |
openAcctDate |
| date | 7561 | EagleML/accountingTransaction/realizedGainLoss/openAcctDate |
openEventId |
| TransactionId | 7013 | EagleML/accountingTransaction/realizedGainLoss/openEventId |
openMonthlyAcctDate |
| date | 7562 | EagleML/accountingTransaction/realizedGainLoss/openMonthlyAcctDate |
originalAcctDate |
| date | 7563 | EagleML/accountingTransaction/realizedGainLoss/originalAcctDate |
originalEventId |
| TransactionId | 7249 | EagleML/accountingTransaction/realizedGainLoss/originalEventId |
originalmonthlyAcctDate |
| date | 7564 | EagleML/accountingTransaction/realizedGainLoss/originalmonthlyAcctDate |
otherFeeBase |
| decimal | 7715 | EagleML/accountingTransaction/realizedGainLoss/otherFeeBase |
ownershipTransferDate |
| data | 7565 | EagleML/accountingTransaction/realizedGainLoss/ownershipTransferDate |
paceTradeEventId |
| TransactionId | 7014 | EagleML/accountingTransaction/realizedGainLoss/paceTradeEventId |
poolNumber |
| string | 107,7015 | EagleML/accountingTransaction/realizedGainLoss/poolNumber |
positionId |
| integer | 7716 | EagleML/accountingTransaction/realizedGainLoss/positionId |
priceCurrency |
| string | 7016 | EagleML/accountingTransaction/realizedGainLoss/priceCurrency |
qtyWashSaleEligible |
| decimal | 7717 | EagleML/accountingTransaction/realizedGainLoss/qtyWashSaleEligible |
quantity |
| decimal | 163 | EagleML/accountingTransaction/realizedGainLoss/quantity |
realizedGlBase |
| decimal | 7719 | EagleML/accountingTransaction/realizedGainLoss/realizedGlBase |
realizedGlCrB |
| decimal | 7720 | EagleML/accountingTransaction/realizedGainLoss/realizedGlCrB |
realizedGlCrL |
| decimal | 7721 | EagleML/accountingTransaction/realizedGainLoss/realizedGlCrL |
realizedGlLocal |
| decimal | 7722 | EagleML/accountingTransaction/realizedGainLoss/realizedGlLocal |
realizedGlNcrB |
| decimal | 7723 | EagleML/accountingTransaction/realizedGainLoss/realizedGlNcrB |
realizedGlNcrL |
| decimal | 7724 | EagleML/accountingTransaction/realizedGainLoss/realizedGlNcrL |
recordType |
| string | 9800,7017 | EagleML/accountingTransaction/realizedGainLoss/recordType |
settleAmt1 |
| decimal | 7725 | EagleML/accountingTransaction/realizedGainLoss/settleAmt1 |
shortTermId |
| integer | 7726 | EagleML/accountingTransaction/realizedGainLoss/shortTermId |
stateTaxWithholdBase |
| decimal | 7727 | EagleML/accountingTransaction/realizedGainLoss/stateTaxWithholdBase |
targetPurchaseDate |
| date | 914,7566 | EagleML/accountingTransaction/realizedGainLoss/targetPurchaseDate |
targetPurchasePrice |
| decimal | 915,7728 | EagleML/accountingTransaction/realizedGainLoss/targetPurchasePrice |
taxesBase |
| decimal | 7729 | EagleML/accountingTransaction/realizedGainLoss/taxesBase |
termLength |
| string | 7018 | EagleML/accountingTransaction/realizedGainLoss/termLength |
totalCurrentLoss |
| decimal | 7730 | EagleML/accountingTransaction/realizedGainLoss/totalCurrentLoss |
totalGainAvg |
| decimal | 7731 | EagleML/accountingTransaction/realizedGainLoss/totalGainAvg |
totalGainId |
| decimal | 7732 | EagleML/accountingTransaction/realizedGainLoss/totalGainId |
totalLossAvg |
| decimal | 7733 | EagleML/accountingTransaction/realizedGainLoss/totalLossAvg |
totalLossId |
| decimal | 7734 | EagleML/accountingTransaction/realizedGainLoss/totalLossId |
tradeFlat |
| string | 7019 | EagleML/accountingTransaction/realizedGainLoss/tradeFlat |
tradersLogin |
| string | 7020 | EagleML/accountingTransaction/realizedGainLoss/tradersLogin |
unitPriceOpen |
| decimal | 7735 | EagleML/accountingTransaction/realizedGainLoss/unitPriceOpen |
updateUserId |
| string | 7021 | EagleML/accountingTransaction/realizedGainLoss/updateUserId |
userDate1 |
| date | 7567 | EagleML/accountingTransaction/realizedGainLoss/userDate1 |
userFloat1 |
| decimal | 7736 | EagleML/accountingTransaction/realizedGainLoss/userFloat1 |
userFloat10 |
| decimal | 7737 | EagleML/accountingTransaction/realizedGainLoss/userFloat10 |
userFloat11 |
| decimal | 7738 | EagleML/accountingTransaction/realizedGainLoss/userFloat11 |
userFloat12 |
| decimal | 7739 | EagleML/accountingTransaction/realizedGainLoss/userFloat12 |
userFloat13 |
| decimal | 7740 | EagleML/accountingTransaction/realizedGainLoss/userFloat13 |
userFloat14 |
| decimal | 7741 | EagleML/accountingTransaction/realizedGainLoss/userFloat14 |
userFloat15 |
| decimal | 7742 | EagleML/accountingTransaction/realizedGainLoss/userFloat15 |
userFloat2 |
| decimal | 7743 | EagleML/accountingTransaction/realizedGainLoss/userFloat2 |
userFloat3 |
| decimal | 7744 | EagleML/accountingTransaction/realizedGainLoss/userFloat3 |
userFloat4 |
| decimal | 7745 | EagleML/accountingTransaction/realizedGainLoss/userFloat4 |
userFloat5 |
| decimal | 7746 | EagleML/accountingTransaction/realizedGainLoss/userFloat5 |
userFloat6 |
| decimal | 7747 | EagleML/accountingTransaction/realizedGainLoss/userFloat6 |
userFloat7 |
| decimal | 7748 | EagleML/accountingTransaction/realizedGainLoss/userFloat7 |
userFloat8 |
| decimal | 7749 | EagleML/accountingTransaction/realizedGainLoss/userFloat8 |
userFloat9 |
| decimal | 7750 | EagleML/accountingTransaction/realizedGainLoss/userFloat9 |
tradeId |
| integer | 8353 | EagleML/accountingTransaction/realizedGainLoss/tradeId |
commissionCurrency |
| CurrencyCode |
| EagleML/accountingTransaction/realizedGainLoss/commissionCurrency |
closeLotId |
| integer | 14065 | EagleML/accountingTransaction/realizedGainLoss/closeLotId |
targetOriginalEventId |
| string | 5032 | EagleML/accountingTransaction/realizedGainLoss/targetOriginalEventId |
tradeCurrency |
| CurrencyCode | 85 | EagleML/accountingTransaction/realizedGainLoss/tradeCurrency |
closeOpenOrderNumber |
| string | 4529 | EagleML/accountingTransaction/realizedGainLoss/closeOpenOrderNumber |
orderNumber |
| string | 1092 | EagleML/accountingTransaction/realizedGainLoss/orderNumber |
calcMasterTransactionId |
| string | 2984 | EagleML/accountingTransaction/realizedGainLoss/calcMasterTransactionId |
calcMasterCloseTransactionId |
| string | 2985 | EagleML/accountingTransaction/realizedGainLoss/calcMasterCloseTransactionId |
gainSwapB |
| decimal | 11820 | EagleML/accountingTransaction/realizedGainLoss/gainSwapB |
gainSwapL |
| decimal | 11819 | EagleML/accountingTransaction/realizedGainLoss/gainSwapL |
gainLoss |
| decimal | 1870,9152 | EagleML/accountingTransaction/realizedGainLoss/gainLoss |
lossSwapB |
| decimal | 11822 | EagleML/accountingTransaction/realizedGainLoss/lossSwapB |
lossSwapL |
| decimal | 11821 | EagleML/accountingTransaction/realizedGainLoss/lossSwapL |
baseCurrency |
| CurrencyCode | 86 | EagleML/accountingTransaction/realizedGainLoss/baseCurrency |
srcIntfcInst |
| decimal | 1168 | EagleML/accountingTransaction/realizedGainLoss/srcIntfcInst |
transactionType |
| normalizedString | 2283 | EagleML/accountingTransaction/realizedGainLoss/transactionType |
ioIssuerAlias |
| string | 1147 | EagleML/accountingTransaction/realizedGainLoss/ioIssuerAlias |
ioIssuerId |
| string | 1144 | EagleML/accountingTransaction/realizedGainLoss/ioIssuerId |
lmtGlElg |
| string | 2487 | EagleML/accountingTransaction/realizedGainLoss/lmtGlElg |
lmtGlInd |
| string | 8553 | EagleML/accountingTransaction/realizedGainLoss/lmtGlInd |
impairmentLtdBase |
| decimal | 2700 | EagleML/accountingTransaction/realizedGainLoss/impairmentLtdBase |
impairmentLtdLocal |
| decimal | 2701 | EagleML/accountingTransaction/realizedGainLoss/impairmentLtdLocal |
impairmentGainBase* |
| decimal | 2701 | EagleML/accountingTransaction/realizedGainLoss/impairmentGainBase |
impairmentGainLocal* |
| decimal | 2700 | EagleML/accountingTransaction/realizedGainLoss/impairmentGainLocal |
impairmentLossBase* |
| decimal | 9679 | EagleML/accountingTransaction/realizedGainLoss/impairmentLossBase |
impairmentLossLocal* |
| decimal | 9678 | EagleML/accountingTransaction/realizedGainLoss/impairmentLossLocal |
amortizedCostPrevBase |
| decimal | 2695 | EagleML/accountingTransaction/realizedGainLoss/amortizedCostPrevBase |
amortizedCostPrevLocal |
| decimal | 2694 | EagleML/accountingTransaction/realizedGainLoss/amortizedCostPrevLocal |
granularityCategory |
| string | 11476 | EagleML/accountingTransaction/realizedGainLoss/granularityCategory |
impairmentAmortOffsetB |
| decimal | 2711 | EagleML/accountingTransaction/realizedGainLoss/impairmentAmortOffsetB |
impairmentAmortOffsetL |
| decimal | 2710 | EagleML/accountingTransaction/realizedGainLoss/impairmentAmortOffsetL |
impairmentCostOffsetB |
| decimal | 2707 | EagleML/accountingTransaction/realizedGainLoss/impairmentCostOffsetB |
impairmentCostOffsetL |
| decimal | 2706 | EagleML/accountingTransaction/realizedGainLoss/impairmentCostOffsetL |
impairmentCostPrevB |
| decimal | 2699 | EagleML/accountingTransaction/realizedGainLoss/impairmentCostPrevB |
impairmentCostPrevL |
| decimal | 2698 | EagleML/accountingTransaction/realizedGainLoss/impairmentCostPrevL |
totalGainLocal |
| decimal | 10050 | EagleML/accountingTransaction/realizedGainLoss/totalGainLocal |
totalLossLocal |
| decimal | 10053 | EagleML/accountingTransaction/realizedGainLoss/totalLossLocal |
costMethod |
| string | 22 | EagleML/accountingTransaction/realizedGainLoss/costMethod |
splitRatio |
| decimal | 128 | EagleML/accountingTransaction/realizedGainLoss/splitRatio |
divAmt |
| decimal | 190 | EagleML/accountingTransaction/realizedGainLoss/divAmt |
cpAddedAmt |
| decimal | 189 | EagleML/accountingTransaction/realizedGainLoss/cpAddedAmt |
cpAmt |
| decimal | 1686 | EagleML/accountingTransaction/realizedGainLoss/cpAmt |
cpCallAmt |
| decimal | 4642 | EagleML/accountingTransaction/realizedGainLoss/cpCallAmt |
cpCallPx |
| decimal | 191 | EagleML/accountingTransaction/realizedGainLoss/cpCallPx |
cpCash |
| decimal | 129 | EagleML/accountingTransaction/realizedGainLoss/cpCash |
cpMsinkAmt |
| decimal | 84 | EagleML/accountingTransaction/realizedGainLoss/cpMsinkAmt |
cpNewCpnRt |
| decimal | 196 | EagleML/accountingTransaction/realizedGainLoss/cpNewCpnRt |
cpNname |
| string | 1728 | EagleML/accountingTransaction/realizedGainLoss/cpNname |
cpNxtResetDt |
| date | 505 | EagleML/accountingTransaction/realizedGainLoss/cpNxtResetDt |
cpPrevMdt |
| date | 503 | EagleML/accountingTransaction/realizedGainLoss/cpPrevMdt |
cpSettleDt |
| date | 37 | EagleML/accountingTransaction/realizedGainLoss/cpSettleDt |
userGroup2 |
| string | 182 | EagleML/accountingTransaction/realizedGainLoss/userGroup2 |
fromFmvPrice |
| decimal | 194 | EagleML/accountingTransaction/realizedGainLoss/fromFmvPrice |
toFmvPrice |
| decimal | 195 | EagleML/accountingTransaction/realizedGainLoss/toFmvPrice |
cpAdjDt |
| date | 216 | EagleML/accountingTransaction/realizedGainLoss/cpAdjDt |
batchEventId |
| string | 2362 | EagleML/accountingTransaction/realizedGainLoss/batchEventId |
costAmtMethod |
| string | 2425 | EagleML/accountingTransaction/realizedGainLoss/costAmtMethod |
consentRt |
| date | 7708 | EagleML/accountingTransaction/realizedGainLoss/consentRt |
consentDt |
| date | 8011 | EagleML/accountingTransaction/realizedGainLoss/consentDt |
cpCrncy1 |
| string | 63 | EagleML/accountingTransaction/realizedGainLoss/cpCrncy1 |
limitGlIndicator |
| string | 2427 | EagleML/accountingTransaction/realizedGainLoss/limitGlIndicator |
CxlMonthEndDate |
| date | 8378 | EagleML/accountingTransaction/realizedGainLoss/CxlMonthEndDate |
cxlActFlag |
| string | 985 | EagleML/accountingTransaction/realizedGainLoss/cxlActFlag |
reportType |
| string | 1257 | EagleML/accountingTransaction/realizedGainLoss/reportType |
accountBasis |
| string | 21 | EagleML/accountingTransaction/realizedGainLoss/accountBasis |
regCategoryChanged |
| string | 891 | EagleML/accountingTransaction/realizedGainLoss/regCategoryChanged |
creditLossLocal |
| decimal | 2783 | EagleML/accountingTransaction/realizedGainLoss/creditLossLocal |
creditLossBase |
| decimal | 2784 | EagleML/accountingTransaction/realizedGainLoss/creditLossBase |
pydnGlAccnt |
| string | 4519 | EagleML/accountingTransaction/realizedGainLoss/pydnGlAccnt |
priceMultiplier |
| decimal | 18 | EagleML/accountingTransaction/realizedGainLoss/priceMultiplier |
coupon |
| decimal | 70 | EagleML/accountingTransaction/realizedGainLoss/coupon |
subSecurityType |
| string | 1464 | EagleML/accountingTransaction/realizedGainLoss/subSecurityType |
country |
| string | 1418 | EagleML/accountingTransaction/realizedGainLoss/country |
riskClassificationType |
| string | 11584 | EagleML/accountingTransaction/realizedGainLoss/riskClassificationType |
topEntityName |
| string | 1159 | EagleML/accountingTransaction/realizedGainLoss/topEntityName |
bookValueBase |
| decimal | 5839 | EagleML/accountingTransaction/realizedGainLoss/bookValueBase |
gainLossLocal |
| decimal | 171 | EagleML/accountingTransaction/realizedGainLoss/gainLossLocal |
gainLossBase |
| decimal | 175 | EagleML/accountingTransaction/realizedGainLoss/gainLossBase |
currGainLoss |
| decimal | 5506 | EagleML/accountingTransaction/realizedGainLoss/currGainLoss |
currGainLossInt |
| decimal | 429 | EagleML/accountingTransaction/realizedGainLoss/currGainLossInt |
currGainLoss988 |
| decimal | 5817 | EagleML/accountingTransaction/realizedGainLoss/currGainLoss988 |
sectorName |
| string | 1156 | EagleML/accountingTransaction/realizedGainLoss/sectorName |
settledFlag |
| string | 7120 | EagleML/accountingTransaction/realizedGainLoss/settledFlag |
fxImpairment |
| decimal | 16231 | EagleML/accountingTransaction/realizedGainLoss/fxImpairment |
longTermGainBase |
| decimal | 3290 | EagleML/accountingTransaction/realizedGainLoss/longTermGainBase |
longTermGainLocal |
| decimal | 3291 | EagleML/accountingTransaction/realizedGainLoss/longTermGainLocal |
longTermLossBase |
| decimal | 3292 | EagleML/accountingTransaction/realizedGainLoss/longTermLossBase |
longTermLossLocal |
| decimal | 3293 | EagleML/accountingTransaction/realizedGainLoss/longTermLossLocal |
shortTermGainBase |
| decimal | 3279 | EagleML/accountingTransaction/realizedGainLoss/shortTermGainBase |
shortTermGainLocal |
| decimal | 3280 | EagleML/accountingTransaction/realizedGainLoss/shortTermGainLocal |
shortTermLossBase |
| decimal | 3288 | EagleML/accountingTransaction/realizedGainLoss/shortTermLossBase |
shortTermLossLocal |
| decimal | 3289 | EagleML/accountingTransaction/realizedGainLoss/shortTermLossLocal |
currencyGainBase |
| decimal | 3296 | EagleML/accountingTransaction/realizedGainLoss/currencyGainBase |
currencyGainLocal |
| decimal | 3297 | EagleML/accountingTransaction/realizedGainLoss/currencyGainLocal |
currencyLossBase |
| decimal | 3298 | EagleML/accountingTransaction/realizedGainLoss/currencyLossBase |
currencyLossLocal |
| decimal | 3299 | EagleML/accountingTransaction/realizedGainLoss/currencyLossLocal |
amortizedPrice |
| decimal | 9483 | EagleML/accountingTransaction/realizedGainLoss/amortizedPrice |
netGainLossBase |
| decimal | 3294 | EagleML/accountingTransaction/realizedGainLoss/netGainLossBase |
netGainLossLocal |
| decimal | 3295 | EagleML/accountingTransaction/realizedGainLoss/netGainLossLocal |
nonCreditLossLocal |
| decimal | 2704 | EagleML/accountingTransaction/realizedGainLoss/nonCreditLossLocal |
nonCreditLossBase |
| decimal | 2705 | EagleML/accountingTransaction/realizedGainLoss/nonCreditLossBase |
reportAmount |
| decimal | 10054 | EagleML/accountingTransaction/realizedGainLoss/reportAmount |
reportAmount2 |
| decimal | 178 | EagleML/accountingTransaction/realizedGainLoss/reportAmount2 |
reportAmount3 |
| decimal | 4602 | EagleML/accountingTransaction/realizedGainLoss/reportAmount3 |
reportAmount4 |
| decimal | 8852 | EagleML/accountingTransaction/realizedGainLoss/reportAmount4 |
reportUpdateSource |
| string | 5525 | EagleML/accountingTransaction/realizedGainLoss/reportUpdateSource |
reportIssueName |
| string | 25 | EagleML/accountingTransaction/realizedGainLoss/reportIssueName |
newMonthDate |
| date | 4733 | EagleML/accountingTransaction/realizedGainLoss/newMonthDate |
naicMarketCode |
| string | 5856 | EagleML/accountingTransaction/realizedGainLoss/naicMarketCode |
groupCode |
| string | 5858 | EagleML/accountingTransaction/realizedGainLoss/groupCode |