Warehouse Trade Charges Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Kinga Huszno
Element | Optional/ Required | Value Type | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|
objectType | Â | ObjectTypeEnum | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/objectType | ||
objectId | Â | objectId | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/objectId | ||
objectDescription | Â | FeedTypeEnum | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/objectDescription | ||
updateTimestamp | Required | dateTime | Â | TRADESDBO | TRADE_CHARGES | UPDATE_DATE | DATE | EagleML/warehouseTransaction/warehouseTradeCharges/updateTimestamp |
customElements | Not recommended | CustomElements | Â | reserved for customizations | Â | EagleML/warehouseTransaction/warehouseTradeCharges/customElements/ | ||
sourceName | Â | string | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/warehouseTransaction/warehouseTradeCharges/sourceName |
updateSource | Required | string | in_update_source | TRADESDBO | TRADE_CHARGES | UPDATE_SOURCE | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseTradeCharges/updateSource |
batchCollectErrorsFlag | Â | YesNoOptionEnum | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/batchCollectErrorsFlag | ||
singleRowCommitFlag | Â | YesNoOptionEnum | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/singleRowCommitFlag | ||
reportType | Â | string | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/reportType | ||
linkEventId | Â | TransactionId | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/linkEventId | ||
localCurrency | Â | CurrencyCode | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/localCurrency | ||
effectiveDate | Â | date | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/effectiveDate | ||
maturityDate | Â | date | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/maturityDate | ||
longShortIndicator | Â | LongShortIndicatorEnum | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseTradeCharges/longShortIndicator | ||
masterTicketNumber | Â | string | in_master_ticket_number | TRADESDBO | TRADE | MASTER_TICKET_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseTradeCharges/masterTicketNumber |
category | Required | string | in_category | TRADESDBO | TRADE_CHARGES | CATEGORY | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseTradeCharges/category |
amount | Â | decimal | in_amount | TRADESDBO | TRADE_CHARGES | AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTradeCharges/amount |
rate | Â | decimal | in_rate | TRADESDBO | TRADE_CHARGES | RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTradeCharges/rate |
rateType | Â | string | in_rate_type | TRADESDBO | TRADE_CHARGES | RATE_TYPE | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseTradeCharges/rateType |
calculationMethod | Â | string | in_calc_type | TRADESDBO | TRADE_CHARGES | CALC_TYPE | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseTradeCharges/calculationMethod |
trdExComission | Â | decimal | in_third_party_comission | TRADESDBO | TRADE_CHARGES | THIRD_PARTY_COMISSION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTradeCharges/trdExComission |
trdChargeScheduleId | Â | string | in_trade_charge_schedule_id | TRADESDBO | TRADE_CHARGES | TRADE_CHARGE_SCHEDULE_ID | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseTradeCharges/trdChargeScheduleId |
tradeId | Required | integer | Â | TRADESDBO | TRADE_CHARGES | TRADE_ID | NUMBER(38,0) | EagleML/warehouseTransaction/warehouseTradeCharges/tradeId |
Â