...
| Info | ||
|---|---|---|
| ||
Please take into account, that unitOpenPriceunitOpenPrice 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 | OptionalObjectTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/objectType | |||||||||||||||||||||
| objectId | OptionalObjectId | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/objectId | |||||||||||||||||||||
| objectDescription | Optional | FeedTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/objectDescription | ||||||||||||||||||||
| updateTimestamp | OptionaldateTime | TRADESDBO | DISPOSAL_LOTS | UPDATE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/updateTimestamp | |||||||||||||||||
| customElements | Not recommended | CustomElements | CustomElements reserved for customizations | EagleML/warehouseTransaction/warehouseCloseLot/customElements | ||||||||||||||||||||
| sourceName | Optional | string | 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 | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/batchCollectErrorsFlag | ||||||||||||||||||||
| singleRowCommitFlag | OptionalYesNoOptionEnum | 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 | OptionalLookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/entityIDLookupSwitch | entityNameLookupSwitch | Optional | LookupSwitchEnum | ||||||||||||||||||
| entityNameLookupSwitch | LookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/entityNameLookupSwitch | |||||||||||||||||||||
| securityQueryFlag | OptionalYesNoOptionEnum | 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 | Optionaldate | 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 | OptionalTransactionId | 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 | Optionalstring | 27 | in_lot_selection_method | S | TRADESDBO | DISPOSAL_LOTS | LOT_SELECTION_METHOD | VARCHAR2(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/lotSelectionMethod | ||||||||||||||
| xrefExchange | OptionalExchangeCode | not stored in DB | EagleML/warehouseTransaction/warehouseCloseLot/xrefExchange | |||||||||||||||||||||
| smInactiveFlag | Optional | YesNoOptionEnum | 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 | |||||||||||||||
| Optional | CurrencyCode | IN_LOCAL_CURRENCY | S | TRADESDBO | 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 | Optional | string | 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 | Optional | ExchangeCode | 17 | in_exchange_code | S | TRADESDBO | DISPOSAL_LOTS | EXCHANGE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/exchangeCode | |||||||||||||
| postType | Optional | string | 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 | OptionalTransactionId | 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 | Optional | decimal | 41 | in_original_face_value | F | TRADESDBO | DISPOSAL_LOTS | ORIGINAL_FACE_VALUE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/originalFaceValue | |||||||||||||
| settlementLocation | Optionalstring | 43 | in_settlement_location | S | TRADESDBO | DISPOSAL_LOTS | SETTLEMENT_LOCATION | CHAR(12) | N | EagleML/warehouseTransaction/warehouseCloseLot/settlementLocation | ||||||||||||||
| taxes | Optionaldecimal | 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 | Optional | decimal | 49 | in_accrued_interest | F | TRADESDBO | DISPOSAL_LOTS | ACCRUED_INTEREST | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/accruedInterest | |||||||||||||
| netCash | Optional | decimal | 50 | in_net_cash | F | TRADESDBO | DISPOSAL_LOTS | NET_CASH | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/netCash | |||||||||||||
| otherFee | Optionaldecimal | 51 | in_other_fee | F | TRADESDBO | DISPOSAL_LOTS | OTHER_FEE | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/otherFee | ||||||||||||||
| tradeStatus | Optionalstring | 54 | in_trade_status | S | TRADESDBO | DISPOSAL_LOTS | TRADE_STATUS | CHAR(8) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeStatus | ||||||||||||||
| trade_memo2 | Optionalstring | 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 | Optionaldecimal | 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 | Optionaldecimal | 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 | Optional | decimal | 4642 | in_unit_cost_local | F | TRADESDBO | DISPOSAL_LOTS | UNIT_COST_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/unitCostLocal | |||||||||||||
| price | Optional | decimal | 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 | Optional | date | 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 | Optionalstring | 281 | in_open_cost_basis_type | S | TRADESDBO | DISPOSAL_LOTS | OPEN_COST_BASIS_TYPE | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseCloseLot/openCostBasisType | ||||||||||||||
| closeCostBasisType | Optionalstring | 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 | Optional | decimal | 522 | in_amort_base | F | TRADESDBO | DISPOSAL_LOTS | AMORT_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/amortBase | |||||||||||||
| clientId | Optionalstring | 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 | Optional | decimal | 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 | Optional | date | 4733 | in_month_end_date | S | TRADESDBO | DISPOSAL_LOTS | MONTH_END_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/monthEndDate | |||||||||||||
| oidLocal | Optional | decimal | 5502 | in_oid_local | F | TRADESDBO | DISPOSAL_LOTS | OID_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/oidLocal | |||||||||||||
| oidBase | Optionaldecimal | 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 | Optional | decimal | 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 | Optionaldecimal | 5820 | in_loss_currency_988 | F | TRADESDBO | DISPOSAL_LOTS | LOSS_CURRENCY_988 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossCurrency988 | ||||||||||||||
| originalSourceCode | Optional | string | 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 | Optionaldecimal | 10051 | in_gain_security | F | TRADESDBO | DISPOSAL_LOTS | GAIN_SECURITY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gainSecurity | ||||||||||||||
| lossCurrency | Optional | decimal | 10052 | in_loss_currency | F | TRADESDBO | DISPOSAL_LOTS | LOSS_CURRENCY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossCurrency | |||||||||||||
| lossSecurityLocal | Optionaldecimal | 10053 | in_loss_security_local | F | TRADESDBO | DISPOSAL_LOTS | LOSS_SECURITY_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossSecurityLocal | ||||||||||||||
| lossSecurity | Optionaldecimal | 10054 | in_loss_security | F | TRADESDBO | DISPOSAL_LOTS | LOSS_SECURITY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/lossSecurity | ||||||||||||||
| openCostLocal | Optionaldecimal | 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 | Optionaldecimal | 10057 | in_total_gain | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_GAIN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalGain | ||||||||||||||
| totalLoss | Optionaldecimal | 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 | Optionaldecimal | 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 | Optionalstring | 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 | Optional | decimal | 7661 | in_alloc_proceeds_local | F | TRADESDBO | DISPOSAL_LOTS | ALLOC_PROCEEDS_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/allocProceedsLocal | |||||||||||||
| allUpRate | Optional | decimal | 7662 | in_alluprate | F | TRADESDBO | DISPOSAL_LOTS | ALLUPRATE | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/allUpRate | |||||||||||||
| amortizationBase | Optional | decimal | 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 | Optional | decimal | 7665 | in_balance | F | TRADESDBO | DISPOSAL_LOTS | BALANCE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/balance | |||||||||||||
| baseCommissionAmount | Optional | decimal | 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 | Optionaldecimal | 7670 | in_baseinterestadj | F | TRADESDBO | DISPOSAL_LOTS | BASEINTERESTADJ | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/baseInterestAdj | ||||||||||||||
| bnchYld1 | Optionaldecimal | 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 | Optionalstring | 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 | Optional | decimal | 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 | Optionalstring | 7004 | in_cls_open_cum_ex_ind | S | TRADESDBO | DISPOSAL_LOTS | CLS_OPEN_CUM_EX_IND | VARCHAR2(3) | N | EagleML/warehouseTransaction/warehouseCloseLot/clsOpenCumExInd | ||||||||||||||
| compared | Optional | string | 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 | Optional | decimal | 7679 | in_disallow_loss_b | F | TRADESDBO | DISPOSAL_LOTS | DISALLOW_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/disallowLossB | |||||||||||||
| disallowLossL | Optionaldecimal | 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 | Optional | decimal | 7683 | in_disp_book_value_stat | F | TRADESDBO | DISPOSAL_LOTS | DISP_BOOK_VALUE_STAT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/dispBookValueStat | |||||||||||||
| eventSubPriority | Optionalinteger | 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 | Optional | decimal | 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 | Optionaldecimal | 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 | Optional | decimal | 7691 | in_gaap_cost_value | F | TRADESDBO | DISPOSAL_LOTS | GAAP_COST_VALUE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/gaapCostValue | |||||||||||||
| gaapSecType | Optionalstring | 7008 | in_gaap_sec_type | S | TRADESDBO | DISPOSAL_LOTS | GAAP_SEC_TYPE | CHAR(4) | N | EagleML/warehouseTransaction/warehouseCloseLot/gaapSecType | ||||||||||||||
| gaapUnitCost | Optionaldecimal | 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 | Optionaldecimal | 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 | Optionalstring | 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 | Optional | decimal | 7701 | in_local_gaap_cost_value | F | TRADESDBO | DISPOSAL_LOTS | LOCAL_GAAP_COST_VALUE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/localGaapCostValue | |||||||||||||
| localGaapUnitCost | Optional | decimal | 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 | Optional | decimal | 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 | Optionaldecimal | 7710 | in_margin | F | TRADESDBO | DISPOSAL_LOTS | MARGIN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/margin | ||||||||||||||
| marginPoints | Optionaldecimal | 7711 | in_marginpoints | F | TRADESDBO | DISPOSAL_LOTS | MARGINPOINTS | NUMBER | N | EagleML/warehouseTransaction/warehouseCloseLot/marginPoints | ||||||||||||||
| monthlyAccountingDate | Optionaldate | 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 | Optional | decimal | 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 | Optionaldecimal | 7714 | in_notionalamt | F | TRADESDBO | DISPOSAL_LOTS | NOTIONALAMT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/notionalAmt | ||||||||||||||
| openAcctDate | Optional | date | 7561 | in_open_acct_date | S | TRADESDBO | DISPOSAL_LOTS | OPEN_ACCT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/openAcctDate | |||||||||||||
| openEventId | Optional | TransactionId | 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 | Optional | decimal | 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 | OptionalTransactionId | 7014 | in_pace_trade_event_id | S | TRADESDBO | DISPOSAL_LOTS | PACE_TRADE_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/paceTradeEventId | ||||||||||||||
| poolNumber | Optional | string | 7015 | in_pool_number | S | TRADESDBO | DISPOSAL_LOTS | POOL_NUMBER | CHAR(12) | N | EagleML/warehouseTransaction/warehouseCloseLot/poolNumber | |||||||||||||
| positionId | Optional | integer | 7716 | in_position_id | F | TRADESDBO | DISPOSAL_LOTS | POSITION_ID | NUMBER(38) | N | EagleML/warehouseTransaction/warehouseCloseLot/positionId | |||||||||||||
| priceCurrency | Optionalstring | 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 | Optional | decimal | 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 | Optionaldecimal | 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 | Optionalstring | 7017 | in_record_type | S | TRADESDBO | DISPOSAL_LOTS | RECORD_TYPE | CHAR(4) | N | EagleML/warehouseTransaction/warehouseCloseLot/recordType | ||||||||||||||
| settleAmt1 | Optionaldecimal | 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 | Optionaldecimal | 7727 | in_state_tax_withhold_base | F | TRADESDBO | DISPOSAL_LOTS | STATE_TAX_WITHHOLD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/stateTaxWithholdBase | ||||||||||||||
| targetPurchaseDate | Optionaldate | 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 | Optionaldecimal | 7731 | in_total_gain_avg | F | TRADESDBO | DISPOSAL_LOTS | TOTAL_GAIN_AVG | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/totalGainAvg | ||||||||||||||
| totalGainId | Optionaldecimal | 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 | Optional | string | 7019 | in_trade_flat | S | TRADESDBO | DISPOSAL_LOTS | TRADE_FLAT | CHAR(2) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeFlat | |||||||||||||
| tradersLogin | Optional | string | 7020 | in_traders_login | S | TRADESDBO | DISPOSAL_LOTS | TRADERS_LOGIN | CHAR(12) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradersLogin | |||||||||||||
| unitPriceOpen | Optional | decimal | 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 | Optional | date | 7567 | in_user_date1 | S | TRADESDBO | DISPOSAL_LOTS | USER_DATE1 | DATE | N | EagleML/warehouseTransaction/warehouseCloseLot/userDate1 | |||||||||||||
| userFloat1 | Optional | decimal | 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 | Optionaldecimal | 7739 | in_user_float12 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT12 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat12 | ||||||||||||||
| userFloat13 | Optionaldecimal | 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 | Optional | decimal | 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 | Optionaldecimal | 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 | Optionaldecimal | 7749 | in_user_float8 | F | TRADESDBO | DISPOSAL_LOTS | USER_FLOAT8 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseCloseLot/userFloat8 | ||||||||||||||
| userFloat9 | Optionaldecimal | 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 | Optionalstring | S | TRADESDBO | DISPOSAL_LOTS | TARGET_ORIG_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseCloseLot/targetOriginalEventId | ||||||||||||||||
| tradeCurrency | Optional | CurrencyCode | S | TRADESDBO | DISPOSAL_LOTS | TRADE_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseCloseLot/tradeCurrency | |||||||||||||||
| closeOpenOrderNumber | Optionalstring | 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 | ||||||||||||||||
...