...
...
| Info | ||
|---|---|---|
| ||
Please take into account, that 251922387 elementthat 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 | |||||||
(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 | |||||||||
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 | ||||||||||