Info | ||
---|---|---|
| ||
Please take into account, that unitOpenPriceunitOpenPrice251922387 element is available only in 2017R1 environments or newer |
...
Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Tupe | DB Required | Xpath | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/objectType | |||||||||||||||
objectId | Optional | ObjectId | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/objectId | |||||||||||||||
objectDescription | Optional | FeedTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/objectDescription | |||||||||||||||
updateTimestamp | Optional | dateTime | TRADESDBO | DISPOSAL_LOTS | UPDATE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/updateTimestamp | |||||||||||
customElements | Not recommended | CustomElements | CustomElements reserved for customizations | EagleML/warehouseTransaction/warehouseCloseLot/customElements | |||||||||||||||
sourceName | Optionalstring | 1102 | in_source | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | N | EagleML/warehouseTransaction/warehouseCloseLot/sourceName | |||||||||
updateSource | Optionalstring | 944 | in_update_source | S | TRADESDBO | DISPOSAL_LOTS | UPDATE_SRC | CHAR(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/updateSource | |||||||||
batchCollectErrorsFlag | OptionalYesNoOptionEnum | not not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/batchCollectErrorsFlag | ||||||||||||||||
singleRowCommitFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/singleRowCommitFlag | |||||||||||||||
Entity Common Id Model | EagleML/warehouseTransaction/warehouseCloseLot/ | ||||||||||||||||||
Entity Properties Model (extract only) | EagleML/warehouseTransaction/warehouseCloseLot/ | ||||||||||||||||||
accountingBasis | Optionalstring | RULESDBO | ENTITY | ACCOUNTING_BASIS | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseCloseLot/accountingBasis | ||||||||||||
entityIDLookupSwitch | Optional | LookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/entityIDLookupSwitch | |||||||||||||||
entityNameLookupSwitch | OptionalLookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/entityNameLookupSwitch | ||||||||||||||||
securityQueryFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/securityQueryFlag | |||||||||||||||
sourceLookupSwitch | OptionalLookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/sourceLookupSwitch | ||||||||||||||||
procedureMode | OptionalProcedureFlagTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/procedureMode | ||||||||||||||||
procedureFlag | OptionalProcedureFlagTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/procedureFlag | ||||||||||||||||
Asset Identifiers Model | EagleML/warehouseTransaction/warehouseCloseLot/ | ||||||||||||||||||
Extended Asset Properties Model (extract only) | EagleML/warehouseTransaction/warehouseCloseLot/ | ||||||||||||||||||
maturityDate | Optional | date | Extended CA Properties Model (extract only) | EagleML/warehouseTransaction/warehouseCloseLot/ | |||||||||||||||
maturityDate | date | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/maturityDate | ||||||||||||||||
effectiveDate | Optionaldate | 221 | in_effective_date | S | TRADESDBO | DISPOSAL_LOTS | EFFECTIVE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/effectiveDate | |||||||||
updateSwitch | Optionalstring | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/updateSwitch | ||||||||||||||||
closeOpenEventId | OptionalTransactionId | 181 | in_cls_open_event_id | S | TRADESDBO | DISPOSAL_LOTS | CLS_OPEN_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/closeOpenEventId | |||||||||
closeEventId | Optional | TransactionId | 182 | in_transaction_id | S | TRADESDBO | DISPOSAL_LOTS | TRANSACTION_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/closeEventId | ||||||||
longShortIndicator | OptionalLongShortIndicatorEnum | 15 | in_star_ls_ind | S | TRADESDBO | DISPOSAL_LOTS | LONG_SHORT_INDICATOR | CHAR(2) | N | EagleML/warehouseTransaction/warehouseCloseLot/longShortIndicator | |||||||||
lotSelectionMethod | Optional | string | 27 | in_lot_selection_method | S | TRADESDBO | DISPOSAL_LOTS | LOT_SELECTION_METHOD | VARCHAR2(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/lotSelectionMethod | ||||||||
xrefExchange | Optional | ExchangeCode | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/xrefExchange | |||||||||||||||
smInactiveFlag | OptionalYesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/smInactiveFlag | ||||||||||||||||
localCurrency | CurrencyCode | IN_LOCAL_CURRENCY | S | TRADESDBO | DISPOSAL_LOTS | TRADE_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseCloseLot/localCurrency | ||||||||||
OptionalTRADESDBO | CurrencyCode | IN_LOCAL_CURRENCY | S | TRADESDBO | DISPOSAL_LOTS | DISPOSAL_LOTS | COMMISSION_CURRENCY | CHAR(3) | N | ||||||||||
tradeDate | Optionaldate | 35 | in_trade_date | S | TRADESDBO | DISPOSAL_LOTS | TRADE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeDate | |||||||||
ledgerEffectiveDate | Optionaldate | 36 | in_ledger_effective_date | S | TRADESDBO | DISPOSAL_LOTS | LEDGER_EFFECTIVE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/ledgerEffectiveDate | |||||||||
settlementDate | Optionaldate | 37 | in_settlement_date | S | TRADESDBO | DISPOSAL_LOTS | SETTLEMENT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/settlementDate | |||||||||
transactionCode | Optionalstring | 2283 | in_trans_code | S | TRADESDBO | DISPOSAL_LOTS | TRANS_CODE | VARCHAR2(55) | N | EagleML/warehouseTransaction/warehouseCloseLot/transactionCode | |||||||||
masterTicketNumber | Required | string | 761 | in_master_ticket_number | S | TRADESDBO | DISPOSAL_LOTS | MASTER_TICKET_NUMBER | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/masterTicketNumber | ||||||||
numberofLots | Optionalinteger | 2674 | in_nbr_of_lots | F | TRADESDBO | DISPOSAL_LOTS | NBR_OF_LOTS | NUMBER | Y | EagleML/warehouseTransaction/warehouseCloseLot/numberofLots | |||||||||
exchangeCode | OptionalExchangeCode | 17 | in_exchange_code | S | TRADESDBO | DISPOSAL_LOTS | EXCHANGE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/exchangeCode | |||||||||
postType | Optionalstring | 24 | in_post_type | S | TRADESDBO | DISPOSAL_LOTS | POST_TYPE | VARCHAR2(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/postType | |||||||||
targetEventId | Optional | TransactionId | 26 | in_target_event_id | S | TRADESDBO | DISPOSAL_LOTS | TARGET_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/targetEventId | ||||||||
linkEventId | Optional | TransactionId | 28 | in_link_event_id | S | TRADESDBO | DISPOSAL_LOTS | LINK_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/linkEventId | ||||||||
postDate | Optional | date | 30 | in_post_date | S | TRADESDBO | DISPOSAL_LOTS | POST_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/postDate | ||||||||
originalFaceValue | Optionaldecimal | 41 | in_original_face_value | F | TRADESDBO | DISPOSAL_LOTS | ORIGINAL_FACE_VALUE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/originalFaceValue | |||||||||
settlementLocation | Optional | string | 43 | in_settlement_location | S | TRADESDBO | DISPOSAL_LOTS | SETTLEMENT_LOCATION | CHAR(12) | N | EagleML/warehouseTransaction/warehouseCloseLot/settlementLocation | ||||||||
taxes | Optional | decimal | 46 | in_taxes | F | TRADESDBO | DISPOSAL_LOTS | TAXES | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/taxes | ||||||||
localCommissionAmount | Optionaldecimal | 47 | in_local_commission_amount | F | TRADESDBO | DISPOSAL_LOTS | LOCAL_COMMISSION_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/localCommissionAmount | |||||||||
exchangeFee | Optionaldecimal | 48 | in_exchange_fee | F | TRADESDBO | DISPOSAL_LOTS | EXCHANGE_FEE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/exchangeFee | |||||||||
accruedInterest | Optionaldecimal | 49 | in_accrued_interest | F | TRADESDBO | DISPOSAL_LOTS | ACCRUED_INTEREST | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/accruedInterest | |||||||||
netCash | Optionaldecimal | 50 | in_net_cash | F | TRADESDBO | DISPOSAL_LOTS | NET_CASH | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/netCash | |||||||||
otherFee | Optional | decimal | 51 | in_other_fee | F | TRADESDBO | DISPOSAL_LOTS | OTHER_FEE | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/otherFee | ||||||||
tradeStatus | Optional | string | 54 | in_trade_status | S | TRADESDBO | DISPOSAL_LOTS | TRADE_STATUS | CHAR(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeStatus | ||||||||
trade_memo2tradeMemo2 | Optional | string | 56 | in_trade_memo2 | S | TRADESDBO | DISPOSAL_LOTS | TRADE_MEMO2 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/trade_memo2 | ||||||||
settlementCurrency | OptionalCurrencyCode | 63 | in_settlement_currency | S | TRADESDBO | DISPOSAL_LOTS | SETTLEMENT_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseCloseLot/settlementCurrency | |||||||||
settlementAmount | Optionaldecimal | 64 | in_settlement_amount | F | TRADESDBO | DISPOSAL_LOTS | SETTLEMENT_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/settlementAmount | |||||||||
settlement_exchange_rate | Optional | decimal | 79 | in_settlement_exchange_rate | F | TRADESDBO | DISPOSAL_LOTS | SETTLEMENT_EXCHANGE_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/settlement_exchange_rate | ||||||||
fxRateOpen | Optionaldecimal | 84 | in_fx_rate_open | F | TRADESDBO | DISPOSAL_LOTS | FX_RATE_OPEN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/fxRateOpen | |||||||||
fxRate | Optionaldecimal | 87 | in_fx_rate | F | TRADESDBO | DISPOSAL_LOTS | FX_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/fxRate | |||||||||
brokerCode | OptionalBrokerCode | 88 | in_broker_code | S | TRADESDBO | DISPOSAL_LOTS | BROKER_CODE | CHAR(12) | N | EagleML/warehouseTransaction/warehouseCloseLot/brokerCode | |||||||||
unitCostBase | Optionaldecimal | 4643 | in_unit_cost_base | F | TRADESDBO | DISPOSAL_LOTS | UNIT_COST_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/unitCostBase | |||||||||
costLocal | Optionaldecimal | 162 | in_cost_local | F | TRADESDBO | DISPOSAL_LOTS | COST_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/costLocal | |||||||||
costBase | Optional | decimal | 166 | in_cost_base | F | TRADESDBO | DISPOSAL_LOTS | COST_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/costBase | ||||||||
(supported in 2017R1) | Optionaldecimal | 160 | in_price | F | TRADESDBO | DISPOSAL_LOTS | UNIT_OPEN_PRICE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/unitOpenPrice | |||||||||
unitCostLocal | Optionaldecimal | 4642 | in_unit_cost_local | F | TRADESDBO | DISPOSAL_LOTS | UNIT_COST_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/unitCostLocal | |||||||||
price | Optionaldecimal | 189 | in_price | F | TRADESDBO | DISPOSAL_LOTS | PRICE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/price | |||||||||
tradeAmount | Optionaldecimal | 190 | in_trade_amount | F | TRADESDBO | DISPOSAL_LOTS | TRADE_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeAmount | |||||||||
settleAmount0 | Optionaldecimal | 191 | in_settleamt0 | F | TRADESDBO | DISPOSAL_LOTS | SETTLEAMT0 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/settleAmount0 | |||||||||
closeHoldingPeriodDate | Optionaldate | 192 | in_cls_hld_period_date | F | TRADESDBO | DISPOSAL_LOTS | CLS_HLD_PERIOD_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/closeHoldingPeriodDate | |||||||||
parOrShares | Optionaldecimal | 200 | in_par_or_shares | F | TRADESDBO | DISPOSAL_LOTS | PAR_OR_SHARES | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/parOrShares | |||||||||
premiumAllocatedLocal | Optionaldecimal | 203 | in_premium_allocated_local | F | TRADESDBO | DISPOSAL_LOTS | PREMIUM_ALLOCATED_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/premiumAllocatedLocal | |||||||||
premiumAllocated | Optionaldecimal | 204 | in_premium_allocated | F | TRADESDBO | DISPOSAL_LOTS | PREMIUM_ALLOCATED | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/premiumAllocated | |||||||||
origAcqDate | Optionaldate | 216 | in_orig_acq_date | S | TRADESDBO | DISPOSAL_LOTS | ORIG_ACQ_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/origAcqDate | |||||||||
gainLossTerm | Optionalstring | 238 | in_gain_loss_term | S | TRADESDBO | DISPOSAL_LOTS | GAIN_LOSS_TERM | CHAR(2) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainLossTerm | |||||||||
openCostBasisType | Optional | stringstring | 281 | in_open_cost_basis_type | S | TRADESDBO | DISPOSAL_LOTS | OPEN_COST_BASIS_TYPE | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseCloseLot/openCostBasisType | ||||||||
closeCostBasisType | Optional | string | 282 | in_close_cost_basis_type | S | TRADESDBO | DISPOSAL_LOTS | CLOSE_COST_BASIS_TYPE | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseCloseLot/closeCostBasisType | ||||||||
tradeBaseAmount | Optional | decimal | 478 | in_trade_base_amount | F | TRADESDBO | DISPOSAL_LOTS | TRADE_BASE_AMOUNT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeBaseAmount | ||||||||
amortLocal | Optional | decimal | 521 | in_amort_local | F | TRADESDBO | DISPOSAL_LOTS | AMORT_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/amortLocal | ||||||||
amortBase | Optionaldecimal | 522 | in_amort_base | F | TRADESDBO | DISPOSAL_LOTS | AMORT_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/amortBase | |||||||||
clientId | Optional | string | 1632 | in_client_id | S | TRADESDBO | DISPOSAL_LOTS | CLIENT_ID | VARCHAR2(20) | N | EagleML/warehouseTransaction/warehouseCloseLot/clientId | ||||||||
feeAmt | Optional | decimal | 3752 | in_feeamt | F | TRADESDBO | DISPOSAL_LOTS | FEEAMT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/feeAmt | ||||||||
principalFactor | Optionaldecimal | 4483 | in_principal_factor | F | TRADESDBO | DISPOSAL_LOTS | PRINCIPAL_FACTOR | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/principalFactor | |||||||||
tipIncomeLtdLocal | Optionaldecimal | 4538 | in_tip_income_ltd_local | F | TRADESDBO | DISPOSAL_LOTS | TIP_INCOME_LTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/tipIncomeLtdLocal | |||||||||
tipIncomeLtdBase | Optionaldecimal | 4539 | in_tip_income_ltd_base | F | TRADESDBO | DISPOSAL_LOTS | TIP_INCOME_LTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/tipIncomeLtdBase | |||||||||
bookValueLocal | Optionaldecimal | 4601 | in_book_value_local | F | TRADESDBO | DISPOSAL_LOTS | BOOK_VALUE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/bookValueLocal | |||||||||
bookValue | Optionaldecimal | 4602 | in_book_value | F | TRADESDBO | DISPOSAL_LOTS | BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/bookValue | |||||||||
monthEndDate | Optionaldate | 4733 | in_month_end_date | S | TRADESDBO | DISPOSAL_LOTS | MONTH_END_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/monthEndDate | |||||||||
oidLocal | Optionaldecimal | 5502 | in_oid_local | F | TRADESDBO | DISPOSAL_LOTS | OID_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/oidLocal | |||||||||
oidBase | Optional | decimal | 5503 | in_oid_base | F | TRADESDBO | DISPOSAL_LOTS | OID_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/oidBase | ||||||||
totalAmortLocal | Optional | decimal | 5685 | in_total_amort_local | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_AMORT_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalAmortLocal | ||||||||
totalAmortBase | Optionaldecimal | 5686 | in_total_amort_base | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_AMORT_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalAmortBase | |||||||||
gainCurrency988 | Optionaldecimal | 5819 | in_gain_currency_988 | F | TRADESDBO | DISPOSAL_LOTS | GAIN_CURRENCY_988 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainCurrency988 | |||||||||
lossCurrency988 | Optional | decimal | 5820 | in_loss_currency_988 | F | TRADESDBO | DISPOSAL_LOTS | LOSS_CURRENCY_988 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossCurrency988 | ||||||||
originalSourceCode | Optionalstring | 9143 | in_original_source_code | S | TRADESDBO | DISPOSAL_LOTS | ORIGINAL_SOURCE_CODE | VARCHAR2(25) | N | EagleML/warehouseTransaction/warehouseCloseLot/originalSourceCode | |||||||||
currencyGainInt | Optionaldecimal | 9736 | in_currency_gain_int | F | TRADESDBO | DISPOSAL_LOTS | CURRENCY_GAIN_INT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/currencyGainInt | |||||||||
currencyLossInt | Optionaldecimal | 9738 | in_currency_loss_int | F | TRADESDBO | DISPOSAL_LOTS | CURRENCY_LOSS_INT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/currencyLossInt | |||||||||
gainCurrency | Optionaldecimal | 10049 | in_gain_currency | F | TRADESDBO | DISPOSAL_LOTS | GAIN_CURRENCY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainCurrency | |||||||||
gainSecurityLocal | Optionaldecimal | 10050 | in_gain_security_local | F | TRADESDBO | DISPOSAL_LOTS | GAIN_SECURITY_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainSecurityLocal | |||||||||
gainSecurity | Optional | decimal | 10051 | in_gain_security | F | TRADESDBO | DISPOSAL_LOTS | GAIN_SECURITY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainSecurity | ||||||||
lossCurrency | Optionaldecimal | 10052 | in_loss_currency | F | TRADESDBO | DISPOSAL_LOTS | LOSS_CURRENCY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossCurrency | |||||||||
lossSecurityLocal | Optional | decimal | 10053 | in_loss_security_local | F | TRADESDBO | DISPOSAL_LOTS | LOSS_SECURITY_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossSecurityLocal | ||||||||
lossSecurity | Optional | decimal | 10054 | in_loss_security | F | TRADESDBO | DISPOSAL_LOTS | LOSS_SECURITY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossSecurity | ||||||||
openCostLocal | Optional | decimal | 10056 | in_open_cost_local | F | TRADESDBO | DISPOSAL_LOTS | OPEN_COST_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/openCostLocal | ||||||||
openCostBase | Optionaldecimal | 10055 | in_open_cost_base | F | TRADESDBO | DISPOSAL_LOTS | OPEN_COST_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/openCostBase | |||||||||
totalGain | Optional | decimal | 10057 | in_total_gain | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_GAIN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalGain | ||||||||
totalLoss | Optional | decimal | 10058 | in_total_loss | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_LOSS | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalLoss | ||||||||
currBuiltinGlSec | Optionaldecimal | 9761 | in_curr_builtin_gl_sec | F | TRADESDBO | DISPOSAL_LOTS | CURR_BUILTIN_GL_SEC | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/currBuiltinGlSec | |||||||||
currBuiltinGlCurrency | Optionaldecimal | 10917 | in_curr_builtin_gl_currency | F | TRADESDBO | DISPOSAL_LOTS | CURR_BUILTIN_GL_CURRENCY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/currBuiltinGlCurrency | |||||||||
currBuiltinGlDeferred | Optionaldecimal | 10918 | in_curr_builtin_gl_deferred | F | TRADESDBO | DISPOSAL_LOTS | CURR_BUILTIN_GL_DEFERRED | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/currBuiltinGlDeferred | |||||||||
currBuiltinGlOid | Optionaldecimal | 10919 | in_curr_builtin_gl_oid | F | TRADESDBO | DISPOSAL_LOTS | CURR_BUILTIN_GL_OID | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/currBuiltinGlOid | |||||||||
currBuiltinGlMktDisc | Optional | decimal | 10920 | in_curr_builtin_gl_mkt_disc | F | TRADESDBO | DISPOSAL_LOTS | CURR_BUILTIN_GL_MKT_DISC | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/currBuiltinGlMktDisc | ||||||||
acquisitionType | Optional | string | 7001 | in_acquisition_type | S | TRADESDBO | DISPOSAL_LOTS | ACQUISITION_TYPE | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseCloseLot/acquisitionType | ||||||||
allocProceedsBase | Optionaldecimal | 7660 | in_alloc_proceeds_base | F | TRADESDBO | DISPOSAL_LOTS | ALLOC_PROCEEDS_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/allocProceedsBase | |||||||||
allocProceedsLocal | Optionaldecimal | 7661 | in_alloc_proceeds_local | F | TRADESDBO | DISPOSAL_LOTS | ALLOC_PROCEEDS_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/allocProceedsLocal | |||||||||
allUpRate | Optionaldecimal | 7662 | in_alluprate | F | TRADESDBO | DISPOSAL_LOTS | ALLUPRATE | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/allUpRate | |||||||||
amortizationBase | Optionaldecimal | 7663 | in_amortization_base | F | TRADESDBO | DISPOSAL_LOTS | AMORTIZATION_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/amortizationBase | |||||||||
amortizationLocal | Optionaldecimal | 7664 | in_amortization_local | F | TRADESDBO | DISPOSAL_LOTS | AMORTIZATION_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/amortizationLocal | |||||||||
balance | Optionaldecimal | 7665 | in_balance | F | TRADESDBO | DISPOSAL_LOTS | BALANCE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/balance | |||||||||
baseCommissionAmount | Optionaldecimal | 7666 | in_base_commission_amount | F | TRADESDBO | DISPOSAL_LOTS | BASE_COMMISSION_AMOUNT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/baseCommissionAmount | |||||||||
baseCostLot | Optionaldecimal | 7667 | in_base_cost_lot | F | TRADESDBO | DISPOSAL_LOTS | BASE_COST_LOT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/baseCostLot | |||||||||
baseRealizedGlCurr | Optionaldecimal | 7668 | in_base_realized_gl_curr | F | TRADESDBO | DISPOSAL_LOTS | BASE_REALIZED_GL_CURR | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/baseRealizedGlCurr | |||||||||
baseRealizedGlMkt | Optionaldecimal | 7669 | in_base_realized_gl_mkt | F | TRADESDBO | DISPOSAL_LOTS | BASE_REALIZED_GL_MKT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/baseRealizedGlMkt | |||||||||
baseInterestAdj | Optional | decimal | 7670 | in_baseinterestadj | F | TRADESDBO | DISPOSAL_LOTS | BASEINTERESTADJ | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/baseInterestAdj | ||||||||
bnchYld1 | Optional | decimal | 7671 | in_bnch_yld1 | F | TRADESDBO | DISPOSAL_LOTS | BNCH_YLD1 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/bnchYld1 | ||||||||
bnchYld2 | Optionaldecimal | 7672 | in_bnch_yld2 | F | TRADESDBO | DISPOSAL_LOTS | BNCH_YLD2 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/bnchYld2 | |||||||||
buyLotNbr | Optional | string | 7002 | in_buy_lot_nbr | S | TRADESDBO | DISPOSAL_LOTS | BUY_LOT_NBR | CHAR(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/buyLotNbr | ||||||||
cancelDueToCorrection | Optional | string | 7003 | in_cancel_due_to_correction | S | TRADESDBO | DISPOSAL_LOTS | CANCEL_DUE_TO_CORRECTION | CHAR(4) | N | EagleML/warehouseTransaction/warehouseCloseLot/cancelDueToCorrection | ||||||||
closeOutPl0 | Optionaldecimal | 7673 | in_closeoutpl0 | F | TRADESDBO | DISPOSAL_LOTS | CLOSEOUTPL0 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/closeOutPl0 | |||||||||
closeoutpl1 | Optionaldecimal | 7674 | in_closeoutpl1 | F | TRADESDBO | DISPOSAL_LOTS | CLOSEOUTPL1 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/closeoutpl1 | |||||||||
clsOpenCumExInd | Optional | string | 7004 | in_cls_open_cum_ex_ind | S | TRADESDBO | DISPOSAL_LOTS | CLS_OPEN_CUM_EX_IND | VARCHAR2(3) | N | EagleML/warehouseTransaction/warehouseCloseLot/clsOpenCumExInd | ||||||||
compared | Optionalstring | 7005 | in_compared | S | TRADESDBO | DISPOSAL_LOTS | COMPARED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseCloseLot/compared | |||||||||
covFlag | Optionalstring | 7006 | in_cov_flag | S | TRADESDBO | DISPOSAL_LOTS | COV_FLAG | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseCloseLot/covFlag | |||||||||
creditLossB | Optionaldecimal | 7675 | in_credit_loss_b | F | TRADESDBO | DISPOSAL_LOTS | CREDIT_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/creditLossB | |||||||||
creditLossL | Optionaldecimal | 7676 | in_credit_loss_l | F | TRADESDBO | DISPOSAL_LOTS | CREDIT_LOSS_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/creditLossL | |||||||||
disallowGainB | Optionaldecimal | 7677 | in_disallow_gain_b | F | TRADESDBO | DISPOSAL_LOTS | DISALLOW_GAIN_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/disallowGainB | |||||||||
disallowGainL | Optionaldecimal | 7678 | in_disallow_gain_l | F | TRADESDBO | DISPOSAL_LOTS | DISALLOW_GAIN_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/disallowGainL | |||||||||
disallowLossB | Optionaldecimal | 7679 | in_disallow_loss_b | F | TRADESDBO | DISPOSAL_LOTS | DISALLOW_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/disallowLossB | |||||||||
disallowLossL | Optional | decimal | 7680 | in_disallow_loss_l | F | TRADESDBO | DISPOSAL_LOTS | DISALLOW_LOSS_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/disallowLossL | ||||||||
discountRate | Optional | decimal | 7681 | in_discount_rate | F | TRADESDBO | DISPOSAL_LOTS | DISCOUNT_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/discountRate | ||||||||
dispBookValueGaap | Optional | decimal | 7682 | in_disp_book_value_gaap | F | TRADESDBO | DISPOSAL_LOTS | DISP_BOOK_VALUE_GAAP | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/dispBookValueGaap | ||||||||
dispBookValueStat | Optionaldecimal | 7683 | in_disp_book_value_stat | F | TRADESDBO | DISPOSAL_LOTS | DISP_BOOK_VALUE_STAT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/dispBookValueStat | |||||||||
eventSubPriority | Optional | integer | 7684 | in_event_sub_priority | F | TRADESDBO | DISPOSAL_LOTS | EVENT_SUB_PRIORITY | NUMBER(38) | N | EagleML/warehouseTransaction/warehouseCloseLot/eventSubPriority | ||||||||
exchangeFeeBase | Optional | decimal | 7685 | in_exchange_fee_base | F | TRADESDBO | DISPOSAL_LOTS | EXCHANGE_FEE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/exchangeFeeBase | ||||||||
fairMarketValueBase | Optionaldecimal | 7686 | in_fair_market_value_base | F | TRADESDBO | DISPOSAL_LOTS | FAIR_MARKET_VALUE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/fairMarketValueBase | |||||||||
fairMarketValueFlag | Optionalstring | 7007 | in_fair_market_value_flag | S | TRADESDBO | DISPOSAL_LOTS | FAIR_MARKET_VALUE_FLAG | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseCloseLot/fairMarketValueFlag | |||||||||
fairMarketValueLocal | Optionaldecimal | 7687 | in_fair_market_value_local | F | TRADESDBO | DISPOSAL_LOTS | FAIR_MARKET_VALUE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/fairMarketValueLocal | |||||||||
fairMarketValuePrice | Optionaldecimal | 7688 | in_fair_market_value_price | F | TRADESDBO | DISPOSAL_LOTS | FAIR_MARKET_VALUE_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/fairMarketValuePrice | |||||||||
federalTaxWithholdBase | Optional | decimal | 7689 | in_federal_tax_withhold_base | F | TRADESDBO | DISPOSAL_LOTS | FEDERAL_TAX_WITHHOLD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/federalTaxWithholdBase | ||||||||
feeamtBase | Optional | decimal | 7690 | in_feeamt_base | F | TRADESDBO | DISPOSAL_LOTS | FEEAMT_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/feeamtBase | ||||||||
gaapCostValue | Optionaldecimal | 7691 | in_gaap_cost_value | F | TRADESDBO | DISPOSAL_LOTS | GAAP_COST_VALUE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gaapCostValue | |||||||||
gaapSecType | Optional | string | 7008 | in_gaap_sec_type | S | TRADESDBO | DISPOSAL_LOTS | GAAP_SEC_TYPE | CHAR(4) | N | EagleML/warehouseTransaction/warehouseCloseLot/gaapSecType | ||||||||
gaapUnitCost | Optional | decimal | 7692 | in_gaap_unit_cost | F | TRADESDBO | DISPOSAL_LOTS | GAAP_UNIT_COST | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gaapUnitCost | ||||||||
gainCurrencyAvg | Optionaldecimal | 7693 | in_gain_currency_avg | F | TRADESDBO | DISPOSAL_LOTS | GAIN_CURRENCY_AVG | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainCurrencyAvg | |||||||||
gainCurrencyId | Optionaldecimal | 7694 | in_gain_currency_id | F | TRADESDBO | DISPOSAL_LOTS | GAIN_CURRENCY_ID | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainCurrencyId | |||||||||
gainSecurityAvg | Optional | decimal | 7695 | in_gain_security_avg | F | TRADESDBO | DISPOSAL_LOTS | GAIN_SECURITY_AVG | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainSecurityAvg | ||||||||
gainSecurityAvgLocal | Optionaldecimal | 7696 | in_gain_security_avg_local | F | TRADESDBO | DISPOSAL_LOTS | GAIN_SECURITY_AVG_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainSecurityAvgLocal | |||||||||
gainSecurityId | Optionaldecimal | 7697 | in_gain_security_id | F | TRADESDBO | DISPOSAL_LOTS | GAIN_SECURITY_ID | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainSecurityId | |||||||||
gainSecurityIdLocal | Optionaldecimal | 7698 | in_gain_security_id_local | F | TRADESDBO | DISPOSAL_LOTS | GAIN_SECURITY_ID_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainSecurityIdLocal | |||||||||
interestSold | Optionaldecimal | 7699 | in_interest_sold | F | TRADESDBO | DISPOSAL_LOTS | INTEREST_SOLD | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/interestSold | |||||||||
invertFlag | Optionalstring | 7009 | in_invert_flag | S | TRADESDBO | DISPOSAL_LOTS | INVERT_FLAG | CHAR(4) | N | EagleML/warehouseTransaction/warehouseCloseLot/invertFlag | |||||||||
letterConfirm | Optional | string | 7010 | in_letterconfirm | S | TRADESDBO | DISPOSAL_LOTS | LETTERCONFIRM | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseCloseLot/letterConfirm | ||||||||
lettered | Optionalstring | 7011 | in_lettered | S | TRADESDBO | DISPOSAL_LOTS | LETTERED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseCloseLot/lettered | |||||||||
localCostLot | Optionaldecimal | 7700 | in_local_cost_lot | F | TRADESDBO | DISPOSAL_LOTS | LOCAL_COST_LOT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/localCostLot | |||||||||
localGaapCostValue | Optionaldecimal | 7701 | in_local_gaap_cost_value | F | TRADESDBO | DISPOSAL_LOTS | LOCAL_GAAP_COST_VALUE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/localGaapCostValue | |||||||||
localGaapUnitCost | Optionaldecimal | 7702 | in_local_gaap_unit_cost | F | TRADESDBO | DISPOSAL_LOTS | LOCAL_GAAP_UNIT_COST | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/localGaapUnitCost | |||||||||
localRealizedGl | Optionaldecimal | 7703 | in_local_realized_gl | F | TRADESDBO | DISPOSAL_LOTS | LOCAL_REALIZED_GL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/localRealizedGl | |||||||||
lossCurrencyAvg | Optionaldecimal | 7704 | in_loss_currency_avg | F | TRADESDBO | DISPOSAL_LOTS | LOSS_CURRENCY_AVG | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossCurrencyAvg | |||||||||
lossCurrencyId | Optionaldecimal | 7705 | in_loss_currency_id | F | TRADESDBO | DISPOSAL_LOTS | LOSS_CURRENCY_ID | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossCurrencyId | |||||||||
lossSecurityAvg | Optionaldecimal | 7706 | in_loss_security_avg | F | TRADESDBO | DISPOSAL_LOTS | LOSS_SECURITY_AVG | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossSecurityAvg | |||||||||
lossSecurityAvgLocal | Optionaldecimal | 7707 | in_loss_security_avg_local | F | TRADESDBO | DISPOSAL_LOTS | LOSS_SECURITY_AVG_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossSecurityAvgLocal | |||||||||
lossSecurityId | Optionaldecimal | 7708 | in_loss_security_id | F | TRADESDBO | DISPOSAL_LOTS | LOSS_SECURITY_ID | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossSecurityId | |||||||||
lossSecurityIdLocal | Optionaldecimal | 7709 | in_loss_security_id_local | F | TRADESDBO | DISPOSAL_LOTS | LOSS_SECURITY_ID_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossSecurityIdLocal | |||||||||
margin | Optional | decimaldecimal | 7710 | in_margin | F | TRADESDBO | DISPOSAL_LOTS | MARGIN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/margin | ||||||||
marginPoints | Optional | decimal | 7711 | in_marginpoints | F | TRADESDBO | DISPOSAL_LOTS | MARGINPOINTS | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/marginPoints | ||||||||
monthlyAccountingDate | Optional | date | 7560 | in_monthly_accounting_date | S | TRADESDBO | DISPOSAL_LOTS | MONTHLY_ACCOUNTING_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/monthlyAccountingDate | ||||||||
mtType | Optional | string | 7012 | in_mttype | S | TRADESDBO | DISPOSAL_LOTS | MTTYPE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/mtType | ||||||||
nonCreditLossB | Optionaldecimal | 7712 | in_non_credit_loss_b | F | TRADESDBO | DISPOSAL_LOTS | NON_CREDIT_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/nonCreditLossB | |||||||||
nonCreditLossL | Optional | decimal | 7713 | in_non_credit_loss_l | F | TRADESDBO | DISPOSAL_LOTS | NON_CREDIT_LOSS_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/nonCreditLossL | ||||||||
notionalAmt | Optional | decimal | 7714 | in_notionalamt | F | TRADESDBO | DISPOSAL_LOTS | NOTIONALAMT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/notionalAmt | ||||||||
openAcctDate | Optionaldate | 7561 | in_open_acct_date | S | TRADESDBO | DISPOSAL_LOTS | OPEN_ACCT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/openAcctDate | |||||||||
openEventId | OptionalTransactionId | 7013 | in_open_event_id | S | TRADESDBO | DISPOSAL_LOTS | OPEN_EVENT_ID | VARCHAR2(55) | N | EagleML/warehouseTransaction/warehouseCloseLot/openEventId | |||||||||
openMonthlyAcctDate | Optionaldate | 7562 | in_open_monthly_acct_date | S | TRADESDBO | DISPOSAL_LOTS | OPEN_MONTHLY_ACCT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/openMonthlyAcctDate | |||||||||
originalAcctDate | Optionaldate | 7563 | in_orig_acct_date | S | TRADESDBO | DISPOSAL_LOTS | ORIG_ACCT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/originalAcctDate | |||||||||
originalEventId | OptionalTransactionId | 7249 | in_orig_event_id | S | TRADESDBO | DISPOSAL_LOTS | ORIG_EVENT_ID | VARCHAR2(55) | N | EagleML/warehouseTransaction/warehouseCloseLot/originalEventId | |||||||||
originalmonthlyAcctDate | Optionaldate | 7564 | in_orig_monthly_acct_date | S | TRADESDBO | DISPOSAL_LOTS | ORIG_MONTHLY_ACCT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/originalmonthlyAcctDate | |||||||||
otherFeeBase | Optionaldecimal | 7715 | in_other_fee_base | F | TRADESDBO | DISPOSAL_LOTS | OTHER_FEE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/otherFeeBase | |||||||||
ownershipTransferDate | Optional | date | 7565 | in_ownership_transfer_date | S | TRADESDBO | DISPOSAL_LOTS | OWNERSHIP_TRANSFER_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/ownershipTransferDate | ||||||||
paceTradeEventId | Optional | TransactionId | 7014 | in_pace_trade_event_id | S | TRADESDBO | DISPOSAL_LOTS | PACE_TRADE_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/paceTradeEventId | ||||||||
poolNumber | Optionalstring | 7015 | in_pool_number | S | TRADESDBO | DISPOSAL_LOTS | POOL_NUMBER | CHAR(12) | N | EagleML/warehouseTransaction/warehouseCloseLot/poolNumber | |||||||||
positionId | Optionalinteger | 7716 | in_position_id | F | TRADESDBO | DISPOSAL_LOTS | POSITION_ID | NUMBER(38) | N | EagleML/warehouseTransaction/warehouseCloseLot/positionId | |||||||||
priceCurrency | Optional | string | 7016 | in_price_currency | S | TRADESDBO | DISPOSAL_LOTS | PRICE_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseCloseLot/priceCurrency | ||||||||
qtyWashSaleEligible | Optionaldecimal | 7717 | in_qty_wash_sale_eligible | F | TRADESDBO | DISPOSAL_LOTS | QTY_WASH_SALE_ELIGIBLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/qtyWashSaleEligible | |||||||||
quantity | Optionaldecimal | 7718 | in_quantity | F | TRADESDBO | DISPOSAL_LOTS | QUANTITY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/quantity | |||||||||
realizedGlBase | Optionaldecimal | 7719 | in_realized_gl_base | F | TRADESDBO | DISPOSAL_LOTS | REALIZED_GL_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/realizedGlBase | |||||||||
realizedGlCrB | Optionaldecimal | 7720 | in_realized_gl_cr_b | F | TRADESDBO | DISPOSAL_LOTS | REALIZED_GL_CR_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/realizedGlCrB | |||||||||
realizedGlCrL | Optionaldecimal | 7721 | in_realized_gl_cr_l | F | TRADESDBO | DISPOSAL_LOTS | REALIZED_GL_CR_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/realizedGlCrL | |||||||||
realizedGlLocal | Optional | decimal | 7722 | in_realized_gl_local | F | TRADESDBO | DISPOSAL_LOTS | REALIZED_GL_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/realizedGlLocal | ||||||||
realizedGlNcrB | Optionaldecimal | 7723 | in_realized_gl_ncr_b | F | TRADESDBO | DISPOSAL_LOTS | REALIZED_GL_NCR_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/realizedGlNcrB | |||||||||
realizedGlNcrL | Optional | decimal | 7724 | in_realized_gl_ncr_l | F | TRADESDBO | DISPOSAL_LOTS | REALIZED_GL_NCR_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/realizedGlNcrL | ||||||||
recordType | Optional | string | 7017 | in_record_type | S | TRADESDBO | DISPOSAL_LOTS | RECORD_TYPE | CHAR(4) | N | EagleML/warehouseTransaction/warehouseCloseLot/recordType | ||||||||
settleAmt1 | Optional | decimal | 7725 | in_settleamt1 | F | TRADESDBO | DISPOSAL_LOTS | SETTLEAMT1 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/settleAmt1 | ||||||||
shortTermId | Optionalinteger | 7726 | in_short_term_id | F | TRADESDBO | DISPOSAL_LOTS | SHORT_TERM_ID | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/shortTermId | |||||||||
stateTaxWithholdBase | Optional | decimal | 7727 | in_state_tax_withhold_base | F | TRADESDBO | DISPOSAL_LOTS | STATE_TAX_WITHHOLD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/stateTaxWithholdBase | ||||||||
targetPurchaseDate | Optional | date | 7566 | in_target_purchase_date | S | TRADESDBO | DISPOSAL_LOTS | TARGET_PURCHASE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/targetPurchaseDate | ||||||||
targetPurchasePrice | Optionaldecimal | 7728 | in_target_purchase_price | F | TRADESDBO | DISPOSAL_LOTS | TARGET_PURCHASE_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/targetPurchasePrice | |||||||||
taxesBase | Optionaldecimal | 7729 | in_taxes_base | F | TRADESDBO | DISPOSAL_LOTS | TAXES_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/taxesBase | |||||||||
termLength | Optionalstring | 7018 | in_term_length | S | TRADESDBO | DISPOSAL_LOTS | TERM_LENGTH | CHAR(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/termLength | |||||||||
totalCurrentLoss | Optionaldecimal | 7730 | in_total_current_loss | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_CURRENT_LOSS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalCurrentLoss | |||||||||
totalGainAvg | Optional | decimal | 7731 | in_total_gain_avg | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_GAIN_AVG | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalGainAvg | ||||||||
totalGainId | Optional | decimal | 7732 | in_total_gain_id | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_GAIN_ID | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalGainId | ||||||||
totalLossAvg | Optionaldecimal | 7733 | in_total_loss_avg | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_LOSS_AVG | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalLossAvg | |||||||||
totalLossId | Optionaldecimal | 7734 | in_total_loss_id | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_LOSS_ID | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalLossId | |||||||||
tradeFlat | Optionalstring | 7019 | in_trade_flat | S | TRADESDBO | DISPOSAL_LOTS | TRADE_FLAT | CHAR(2) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeFlat | |||||||||
tradersLogin | Optionalstring | 7020 | in_traders_login | S | TRADESDBO | DISPOSAL_LOTS | TRADERS_LOGIN | CHAR(12) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradersLogin | |||||||||
unitPriceOpen | Optionaldecimal | 7735 | in_unit_price_open | F | TRADESDBO | DISPOSAL_LOTS | UNIT_PRICE_OPEN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/unitPriceOpen | |||||||||
updateUserId | Optionalstring | 7021 | in_update_user_id | S | TRADESDBO | DISPOSAL_LOTS | UPDATE_USER_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/updateUserId | |||||||||
userDate1 | Optionaldate | 7567 | in_user_date1 | S | TRADESDBO | DISPOSAL_LOTS | USER_DATE1 | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/userDate1 | |||||||||
userFloat1 | Optionaldecimal | 7736 | in_user_float1 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT1 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat1 | |||||||||
userFloat10 | Optionaldecimal | 7737 | in_user_float10 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT10 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat10 | |||||||||
userFloat11 | Optionaldecimal | 7738 | in_user_float11 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT11 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat11 | |||||||||
userFloat12 | Optional | decimal | 7739 | in_user_float12 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT12 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat12 | ||||||||
userFloat13 | Optional | decimal | 7740 | in_user_float13 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT13 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat13 | ||||||||
userFloat14 | Optionaldecimal | 7741 | in_user_float14 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT14 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat14 | |||||||||
userFloat15 | Optionaldecimal | 7742 | in_user_float15 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT15 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat15 | |||||||||
userFloat2 | Optionaldecimal | 7743 | in_user_float2 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT2 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat2 | |||||||||
userFloat3 | Optionaldecimal | 7744 | in_user_float3 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT3 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat3 | |||||||||
userFloat4 | Optional | decimal | 7745 | in_user_float4 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT4 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat4 | ||||||||
userFloat5 | Optional | decimal | 7746 | in_user_float5 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT5 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat5 | ||||||||
userFloat6 | Optionaldecimal | 7747 | in_user_float6 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT6 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat6 | |||||||||
userFloat7 | Optional | decimal | 7748 | in_user_float7 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT7 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat7 | ||||||||
userFloat8 | Optional | decimal | 7749 | in_user_float8 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT8 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat8 | ||||||||
userFloat9 | Optional | decimal | 7750 | in_user_float9 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT9 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat9 | ||||||||
tradeId | Optionalinteger | F | TRADESDBO | DISPOSAL_LOTS | TRADE_ID | NUMBER | Y | EagleML/warehouseTransaction/warehouseCloseLot/tradeId | |||||||||||
commissionCurrency | OptionalCurrencyCode | S | TRADESDBO | DISPOSAL_LOTS | COMMISSION_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseCloseLot/commissionCurrency | |||||||||||
closeLotId | Optionalinteger | 14065 | F | TRADESDBO | DISPOSAL_LOTS | DISPOSAL_LOT_ID | NUMBER | Y | EagleML/warehouseTransaction/warehouseCloseLot/closeLotId | ||||||||||
targetOriginalEventId | Optional | string | S | TRADESDBO | DISPOSAL_LOTS | TARGET_ORIG_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/targetOriginalEventId | ||||||||||
tradeCurrency | OptionalCurrencyCode | S | TRADESDBO | DISPOSAL_LOTS | TRADE_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeCurrency | |||||||||||
closeOpenOrderNumber | Optional | string | S | TRADESDBO | DISPOSAL_LOTS | CLS_OPEN_ORDER_NUMBER | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/closeOpenOrderNumber | ||||||||||
orderNumber | Optionalstring | S | TRADESDBO | DISPOSAL_LOTS | ORDER_NUMBER | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/orderNumber | |||||||||||
calcMasterTransactionId | Extract only (see more details) | string | 2984 | S | CALC_MASTER_TRANSACTION_ID - concatenated value ACCT_BASIS#ENTITY_ID#SECURITY_ALIAS#LONG_SHORT_IND#ORIG_LOT_NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/calcMasterTransactionId | ||||||||||||
calcMasterCloseTransactionId | Extract only | string | 2985 | S | CALC_MASTER_CLOSE_TRAN_ID - concatenated value ACCT_BASIS#ENTITY_ID#SECURITY_ALIAS#LONG_SHORT_INDICATOR#STAR_TAG25 | N | EagleML/warehouseTransaction/warehouseCloseLot/calcMasterCloseTransactionId |