Impairments Data Map Table


ElementOptional/RequiredValue TypeStar TagXpath
objectTypeOptionalObjectTypeEnumnot stored in DBEagleML/accountingTransaction/impairments/objectType
objectIdOptionalobjectIdnot stored in DBEagleML/accountingTransaction/impairments/objectId
objectDescriptionOptionalFeedTypeEnumnot stored in DBEagleML/accountingTransaction/impairments/objectDescription
updateTimestampOptionaldateTime1106EagleML/accountingTransaction/impairments/updateTimestamp
updateSource  Optionalstring944EagleML/accountingTransaction/impairments/updateSource
Entity Common Id ModelEagleML/accountingTransaction/impairments/
Asset Identifiers ModelEagleML/accountingTransaction/impairments/
impairmentsTypeRequiredimpairmentsTxnTypeEnum55EagleML/accountingTransaction/impairments/impairmentsType
calculateLocalAmountsFlagOptionalYesNoOptionEnum5013EagleML/accountingTransaction/impairments/calculateLocalAmountsFlag
calculateBaseAmountsFlagOptionalYesNoOptionEnum5014EagleML/accountingTransaction/impairments/calculateBaseAmountsFlag
calculateValuesBySTARIndicatorOptionalCalculateValuesBySTARIndicatorEnum7000EagleML/accountingTransaction/impairments/calculateValuesBySTARIndicator
futureExpenseCapitalizeIndicatorOptionalFutureExpenseCapitalizeEnum10705EagleML/accountingTransaction/impairments/futureExpenseCapitalizeIndicator
securityXrefLookupSwitch  OptionalnormalizedString991EagleML/accountingTransaction/impairments/securityXrefLookupSwitch
codeValueLookupSwitch  OptionalnormalizedString9152EagleML/accountingTransaction/impairments/codeValueLookupSwitch
cancelAccountingDateSwitchOptionalstring2283EagleML/accountingTransaction/impairments/cancelAccountingDateSwitch
longShortIndicator  OptionalLongShortIndicatorEnum15EagleML/accountingTransaction/impairments/longShortIndicator
cancelTradeByIndicatorOptionalCancelTradeByIndicatorEnum-EagleML/accountingTransaction/impairments/cancelTradeByIndicator
notionalResetIndicatorOptionalnotionalResetIndicatorEnum3599EagleML/accountingTransaction/impairments/notionalResetIndicator
impairmentProcessingSwitchOptionalimpairmentProcessingSwitchEnum16147EagleML/accountingTransaction/impairments/impairmentProcessingSwitch
entityGroupingSwitchOptionalnormalizedString7005EagleML/accountingTransaction/impairments/entityGroupingSwitch
baseCurrencyOptionalstring86EagleML/accountingTransaction/impairments/baseCurrency
accountingBasisOptionalstring21EagleML/accountingTransaction/impairments/accountingBasis
entityPartitionOptionaldecimal95EagleML/accountingTransaction/impairments/entityPartition
entityListNameOptionalstring1091EagleML/accountingTransaction/impairments/entityListName
conversionStatusOptionalstring3914EagleML/accountingTransaction/impairments/conversionStatus
impairByOptionSwitchOptionalimpairByOptionSwitchEnum16148EagleML/accountingTransaction/impairments/impairByOptionSwitch
impairmentReasonSwitchOptionalimpairmentReasonSwitchEnum2921EagleML/accountingTransaction/impairments/impairmentReasonSwitch
sTATReasonCodeOptionalSTATReasonCodeEnum7002EagleML/accountingTransaction/impairments/sTATReasonCode
writeupWritedownSwitchOptionalwriteupWritedownSwitchEnum7001EagleML/accountingTransaction/impairments/writeupWritedownSwitch
lotImpairmentProcessingSwitchOptionallotImpairmentProcessingSwitchEnum16149EagleML/accountingTransaction/impairments/lotImpairmentProcessingSwitch
creditNoncreditLossProcessingSwitchOptionalYesNoOptionStrictEnum16158EagleML/accountingTransaction/impairments/creditNoncreditLossProcessingSwitch
creditPriceOptionaldecimal16150EagleML/accountingTransaction/impairments/creditPrice
noncreditPriceOptionaldecimal7840EagleML/accountingTransaction/impairments/noncreditPrice
localCostAdjustmentOptionaldecimal7350EagleML/accountingTransaction/impairments/localCostAdjustment
creditLossLocalAdjustmentOptionaldecimal7358EagleML/accountingTransaction/impairments/creditLossLocalAdjustment
nonCreditLossLocalAdjustmentOptionaldecimal7359EagleML/accountingTransaction/impairments/nonCreditLossLocalAdjustment
accountingDateOptionaldate36EagleML/accountingTransaction/impairments/accountingDate
postDateOptionaldate30EagleML/accountingTransaction/impairments/postDate
tradeDateOptionaldate35EagleML/accountingTransaction/impairments/tradeDate
settlementDateOptionaldate37EagleML/accountingTransaction/impairments/settlementDate
effectiveDateOptionaldate2857EagleML/accountingTransaction/impairments/effectiveDate
lotSelectionMethod  OptionalLotSelectionCodeMethodEnum27EagleML/accountingTransaction/impairments/lotSelectionMethod
oidYield  Optionalstring39EagleML/accountingTransaction/impairments/oidYield
sharesParQuantityOptionaldecimal40EagleML/accountingTransaction/impairments/sharesParQuantity
originalFaceOptionaldecimal41EagleML/accountingTransaction/impairments/originalFace
priceOptionaldecimal45EagleML/accountingTransaction/impairments/price
taxAmountOptionaldecimal46EagleML/accountingTransaction/impairments/taxAmount
impliedCommissionIndicator  OptionalYesNoOptionEnum78EagleML/accountingTransaction/impairments/impliedCommissionIndicator
commissionOptionaldecimal47EagleML/accountingTransaction/impairments/commission
secFeeOptionaldecimal48EagleML/accountingTransaction/impairments/secFee
tradedInterestOptionaldecimal49EagleML/accountingTransaction/impairments/tradedInterest
localNetAmountOptionaldecimal50EagleML/accountingTransaction/impairments/localNetAmount
stampDutyTaxOptionaldecimal51EagleML/accountingTransaction/impairments/stampDutyTax
settlementCurrencyOptionalCurrencyCode63EagleML/accountingTransaction/impairments/settlementCurrency
settlementNetAmountOptionaldecimal64EagleML/accountingTransaction/impairments/settlementNetAmount
amortYieldOptionaldecimal75EagleML/accountingTransaction/impairments/amortYield
buytoBaseFXRateOptionaldecimal9EagleML/accountingTransaction/impairments/buytoBaseFXRate
localToBaseFXRateOptionaldecimal87EagleML/accountingTransaction/impairments/localToBaseFXRate
currentFactorOptionaldecimal91EagleML/accountingTransaction/impairments/currentFactor
discountRateOptionaldecimal1314EagleML/accountingTransaction/impairments/discountRate
principalOptionaldecimal165EagleML/accountingTransaction/impairments/principal
tradedInterestBaseOptionaldecimal475EagleML/accountingTransaction/impairments/tradedInterestBase
baseNetAmountOptionaldecimal478EagleML/accountingTransaction/impairments/baseNetAmount
termLoanFeeIncomeOptionaldecimal844EagleML/accountingTransaction/impairments/termLoanFeeIncome
termLoanFeeExpenseOptionaldecimal846EagleML/accountingTransaction/impairments/termLoanFeeExpense
targetPurchaseDate  Optionalstring914EagleML/accountingTransaction/impairments/targetPurchaseDate
targetPurchasePriceOptionaldecimal915EagleML/accountingTransaction/impairments/targetPurchasePrice
currentILBQuantityOptionaldecimal965EagleML/accountingTransaction/impairments/currentILBQuantity
commissionPerContractLocalOptionaldecimal971EagleML/accountingTransaction/impairments/commissionPerContractLocal
accrualMethod  Optionalstring1184EagleML/accountingTransaction/impairments/accrualMethod
accrualConventionOffsetOverride  Optionalstring1604EagleML/accountingTransaction/impairments/accrualConventionOffsetOverride
backupWithholdingLocalOptionaldecimal2712EagleML/accountingTransaction/impairments/backupWithholdingLocal
accruedInterestType  Optionalstring3715EagleML/accountingTransaction/impairments/accruedInterestType
originalCostBaseNoAmortizationOptionaldecimal3746EagleML/accountingTransaction/impairments/originalCostBaseNoAmortization
originalCostLocalNoAmortizationOptionaldecimal3747EagleML/accountingTransaction/impairments/originalCostLocalNoAmortization
otherFeeOptionaldecimal3752EagleML/accountingTransaction/impairments/otherFee
totalSettlementAmountLocalOptionaldecimal4404EagleML/accountingTransaction/impairments/totalSettlementAmountLocal
ilbIndexRatioOptionaldecimal4483EagleML/accountingTransaction/impairments/ilbIndexRatio
payableReceivableIndicator  Optionalstring4590EagleML/accountingTransaction/impairments/payableReceivableIndicator
pairoffAllocatnleIndicator  Optionalstring5671EagleML/accountingTransaction/impairments/pairoffAllocatnleIndicator
conversionPremiumOptionaldecimal5727EagleML/accountingTransaction/impairments/conversionPremium
totalTradedInterestLocalOptionaldecimal7351EagleML/accountingTransaction/impairments/totalTradedInterestLocal
notionalAmountLocalOptionaldecimal7429EagleML/accountingTransaction/impairments/notionalAmountLocal
notionalAmountBaseOptionaldecimal7509EagleML/accountingTransaction/impairments/notionalAmountBase
swapFeeLocalOptionaldecimal7510EagleML/accountingTransaction/impairments/swapFeeLocal
federalTaxWithholdingBaseOptionaldecimal8078EagleML/accountingTransaction/impairments/federalTaxWithholdingBase
stateTaxWithholdingBaseOptionaldecimal8079EagleML/accountingTransaction/impairments/stateTaxWithholdingBase
createTBACashflow  OptionalYesNoOptionEnum9406EagleML/accountingTransaction/impairments/createTBACashflow
dataEntryMethod  OptionalDataEntryMethodEnum10485EagleML/accountingTransaction/impairments/dataEntryMethod
autoSettleIndicatorOptionalYesNoOptionEnum58EagleML/accountingTransaction/impairments/autoSettleIndicator
custodianBankCodeOptionalstring1240EagleML/accountingTransaction/impairments/custodianBankCode
custodianBankNameOptionalstring1146EagleML/accountingTransaction/impairments/custodianBankName
custodyBankAccountOptionalstring1660EagleML/accountingTransaction/impairments/custodyBankAccount
custodyBankSubaccountOptionalstring1661EagleML/accountingTransaction/impairments/custodyBankSubaccount
batchIdentifierOptionalstring701EagleML/accountingTransaction/impairments/batchIdentifier
exchangeCodeOptionalstring17EagleML/accountingTransaction/impairments/exchangeCode
brokerCodeOptionalstring88EagleML/accountingTransaction/impairments/brokerCode
brokerNameOptionalstring1235EagleML/accountingTransaction/impairments/brokerName
clearingBrokerCodeOptionalstring1237EagleML/accountingTransaction/impairments/clearingBrokerCode
clearingBrokerNameOptionalstring1236EagleML/accountingTransaction/impairments/clearingBrokerName
settleLocationOptionalstring43EagleML/accountingTransaction/impairments/settleLocation
settleInstructions1Optionalstring1897EagleML/accountingTransaction/impairments/settleInstructions1
settleInstructions2Optionalstring1898EagleML/accountingTransaction/impairments/settleInstructions2
settleInstructions3Optionalstring1899EagleML/accountingTransaction/impairments/settleInstructions3
settleInstructions4Optionalstring1900EagleML/accountingTransaction/impairments/settleInstructions4
openTBATradeIdOptionalstring10503EagleML/accountingTransaction/impairments/openTBATradeId
userChar1Optionalstring1887EagleML/accountingTransaction/impairments/userChar1
userChar2Optionalstring1888EagleML/accountingTransaction/impairments/userChar2
userChar3Optionalstring1889EagleML/accountingTransaction/impairments/userChar3
userFloat1Optionaldecimal1890EagleML/accountingTransaction/impairments/userFloat1
userFloat2Optionaldecimal1891EagleML/accountingTransaction/impairments/userFloat2
userFloat3Optionaldecimal1892EagleML/accountingTransaction/impairments/userFloat3
transactionNotesOptionalstring56EagleML/accountingTransaction/impairments/transactionNotes
originalTradeTicketNumberOptionaldecimal761EagleML/accountingTransaction/impairments/originalTradeTicketNumber
payRecAccountOptionalstring1826EagleML/accountingTransaction/impairments/payRecAccount
offsettoCostAccountOptionalstring1825EagleML/accountingTransaction/impairments/offsettoCostAccount
managerOptionalstring3718EagleML/accountingTransaction/impairments/manager
strategyOptionalstring3722EagleML/accountingTransaction/impairments/strategy
clientSpecificOriginalTransactionId  Optionalstring457EagleML/accountingTransaction/impairments/clientSpecificOriginalTransactionId
targetTradeTicketNumber  Optionalstring762EagleML/accountingTransaction/impairments/targetTradeTicketNumber
orderNumberOptionaldecimal1092EagleML/accountingTransaction/impairments/orderNumber
counterPartyIdOptionalstring1144EagleML/accountingTransaction/impairments/counterPartyId
counterpartyName  Optionalstring1173EagleML/accountingTransaction/impairments/counterpartyName
targetTransactionId  Optionalstring26EagleML/accountingTransaction/impairments/targetTransactionId
costBasisCoveredLotFlag  OptionalYesNoOptionEnum2819EagleML/accountingTransaction/impairments/costBasisCoveredLotFlag
coveredLotOverrideFlag  Optionalinteger2820EagleML/accountingTransaction/impairments/coveredLotOverrideFlag
userDefinedPriority  OptionalYesNoOptionEnum2862EagleML/accountingTransaction/impairments/userDefinedPriority
pendingTradeFlag  Optionalstring3695EagleML/accountingTransaction/impairments/pendingTradeFlag
fas115Code  Optionalstring3728EagleML/accountingTransaction/impairments/fas115Code
targetOriginalEventId  OptionalRegulatoryIntentEnum5032EagleML/accountingTransaction/impairments/targetOriginalEventId
regulatoryIntent  OptionalHoldingTermEnum8915EagleML/accountingTransaction/impairments/regulatoryIntent
holdingTerm  Optionalstring9091EagleML/accountingTransaction/impairments/holdingTerm
retroIndicator  Optional 11018EagleML/accountingTransaction/impairments/retroIndicator