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 |