Warehouse Close Lot Data Map Table
- Natalie Gesin (Deactivated)
- Nazarii Kabyn
- Kinga Huszno
Please take into account, that Warehouse Close Lot Data Map Table#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 | ||
EagleML/warehouseTransaction/warehouseCloseLot/ | |||||||||||
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 | ||
EagleML/warehouseTransaction/warehouseCloseLot/ | |||||||||||
EagleML/warehouseTransaction/warehouseCloseLot/ | |||||||||||
Extended CA 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 |
tradeMemo2 | Â | 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 |
 | decimal | 160 | in_unit_open_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 |
calcMasterTransactionId | Extract only | string | 2984 | Â | Â S | CALC_MASTER_TRANSACTION_IDÂ - concatenated value | N | EagleML/warehouseTransaction/warehouseCloseLot/calcMasterTransactionId | |||
calcMasterCloseTransactionId | Extract only | string | 2985 | Â | Â S | CALC_MASTER_CLOSE_TRAN_IDÂ - concatenated value | N | EagleML/warehouseTransaction/warehouseCloseLot/calcMasterCloseTransactionId | |||
Â