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