...
Info | ||
---|---|---|
| ||
Please note that elements in the data map table below can be populated from different database tables depending on the <reportView> the <reportView> element set in the control message (either 'TRADED' or 'SETTLED'). |
...
Element | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | Xpath | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | ObjectTypeEnum | Hardcoded Value = AccountingCashJournal | EagleML/accountingTransaction/accountingCashJournal/objectType | ||||||||||||
objectId | ObjectId | Hardcoded Value = AccountingCashJournal | EagleML/accountingTransaction/accountingCashJournal/objectId | ||||||||||||
objectDescription | FeedTypeEnum | Hardcoded Value = ACCOUNTING | EagleML/accountingTransaction/accountingCashJournal/objectDescription | ||||||||||||
updateTimestamp | dateTime | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SYSTEM_DATE | DATE | EagleML/accountingTransaction/accountingCashJournal/updateTimestamp | |||||||||
updateSource | string | 944 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/accountingCashJournal/updateSource | ||||||||
Entity Common Id Model | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||||
Asset Identifiers Model | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||||
Asset Properties Model | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||||
maturityDate | date | 38 | SECURITYDBO | SECURITY_MASTER | MAT_DATE | DATE | EagleML/accountingTransaction/accountingCashJournal/maturityDate | ||||||||
effectiveDate | date | EagleML/accountingTransaction/accountingCashJournal/effectiveDate | |||||||||||||
instance | integer | 9388 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INSTANCE | EagleML/accountingTransaction/accountingCashJournal/instance | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
localCurrency | CurrencyCode | 85 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCAL_CURR | VARCHAR2(3) | EagleML/accountingTransaction/accountingCashJournal/localCurrency | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
baseCurrency | CurrencyCode | 86 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BASE_CURR | VARCHAR2(3) | EagleML/accountingTransaction/accountingCashJournal/baseCurrency | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
accountingBasis | string | 21 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCT_BASIS | VARCHAR2(5) | EagleML/accountingTransaction/accountingCashJournal/accountingBasis | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
longShortC | string | 15 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LNG_SHT_C | CHAR(1) | EagleML/accountingTransaction/accountingCashJournal/longShortC | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
backupSrcSysC | string | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUP_SRC_SYS_C | EagleML/accountingTransaction/accountingCashJournal/backupSrcSysC | ||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
starPositionId | integer | 830 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | POSN_ID | EagleML/accountingTransaction/accountingCashJournal/starPositionId | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
settleAsset | Asset Identifiers Model - see extra table | ESTAR_TRADED_CASH_ACTIVITY | EagleML/accountingTransaction/accountingCashJournal/settleAsset/ | ||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
shareClass | string | 34 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SHARE_CLASS | VARCHAR2(10) | EagleML/accountingTransaction/accountingCashJournal/shareClass | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
eventId | TransactionId | 25 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/eventId | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
starEventType | string | 2362 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_TYPE | VARCHAR2(25) | EagleML/accountingTransaction/accountingCashJournal/starEventType | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
eventType | string | 53 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_EVT_TYP | VARCHAR2(10) | EagleML/accountingTransaction/accountingCashJournal/eventType | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
eventSequence | integer | 126 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_SEQUENCE | EagleML/accountingTransaction/accountingCashJournal/ | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
processDate | date | 30 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PROCESS_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/processDate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
accountingDate | date | 36 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCOUNT_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/accountingDate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
monthEndAccountingDate | date | 4733 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MONTH_END_ACCT_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/monthEndAccountingDate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
units | decimal | 40 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UNITS | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/units | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
amount | decimal | 50 | Calculated Value - Tag 50 = ESTAR_TRADED_CASH_ACTIVITY.AMOUNT + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_OVER_B | EagleML/accountingTransaction/accountingCashJournal/amount | |||||||||||
Calculated Value - Tag 50 = SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE) | |||||||||||||||
principal* (supported in 2017R1) | decimal | 165 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPAL | EagleML/accountingTransaction/accountingCashJournal/principal | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
income | decimal | 1985 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/income | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
navId | integer | 3196 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | NAV_ID | EagleML/accountingTransaction/accountingCashJournal/navId | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
cashStatus | string | 54 | Hardcode Value - TRADED for payables and receivables, SETTLED - for disbursements and receipts | EagleML/accountingTransaction/accountingCashJournal/cashStatus | |||||||||||
cashCategory | string | 62 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_CATEGORY | VARCHAR2(50) | EagleML/accountingTransaction/accountingCashJournal/cashCategory | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
bankAlias | string | 16 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BANK_ALIAS | EagleML/accountingTransaction/accountingCashJournal/bankAlias | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
autoSettleIndicator | YesNoOptionEnum | 58 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | AUTO_SETTLE_INDICATOR | VARCHAR2(2) | EagleML/accountingTransaction/accountingCashJournal/autoSettleIndicator | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
corpActionId | integer | 60 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORP_ACTION_ID | EagleML/accountingTransaction/accountingCashJournal/corpActionId | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
ledgerBalanceEntitlement | string | 3970 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LDGR_BAL_ENTITLEMENT | EagleML/accountingTransaction/accountingCashJournal/ledgerBalanceEntitlement | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
accountingPlan | integer | 999 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCTG_PLAN | EagleML/accountingTransaction/accountingCashJournal/accountingPlan | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
positingPlan | integer | 913 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | POSTING_PLAN | EagleML/accountingTransaction/accountingCashJournal/positingPlan | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
recPayPlan | string | 1831 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_PLAN | VARCHAR2(15) | EagleML/accountingTransaction/accountingCashJournal/recPayPlan | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
withholdingLocal | decimal | 853 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | WITHHOLDING_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/withholdingLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
reclaimLocal | decimal | 852 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/reclaimLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
reclaimMethod | string | 3912 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_METHOD | CHAR(2) | EagleML/accountingTransaction/accountingCashJournal/reclaimMethod | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
batchEventId | string | 701 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BATCH_EVENT_ID | EagleML/accountingTransaction/accountingCashJournal/batchEventId | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
contSettleDate | date | 9968 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CONT_SETTLE_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/contSettleDate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
linkEventId | TransactionId | 28 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LINK_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/linkEventId | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
targetEventId | string | 26 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TARGET_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/targetEventId | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
eventReason | string | 56 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_REASON | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/eventReason | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
cancelEventId | |||||||||||||||
TransactionId | |||||||||||||||
501 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | |||||||||||||
CANCEL_ | |||||||||||||||
EVT_ | |||||||||||||||
ID | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||||
cancelEventId | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | otherFeeLocal|||||||||||||||
cancelSequence | decimalinteger | 3752226 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHERCANCEL_FEE_LOCAL | NUMBER(38,6) | SEQUENCE | EagleML/accountingTransaction/accountingCashJournal/otherFeeLocalcancelSequence | |||||||
ESTAR_SETTLED_CASH_ACTIVITY | stampDutyTaxLocal|||||||||||||||
recPayAccount2 | |||||||||||||||
string | |||||||||||||||
1826 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | |||||||||||||
REC_ | |||||||||||||||
PAY_ | NUMBER(38,6) | ||||||||||||||
ACCT2 | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||||
recPayAccount2 | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
principalBreakageUnder | decimal | ||||||||||||||
10134 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | |||||||||||||
PRINCIPAL_ | |||||||||||||||
BREAKAGE_UNDER | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||||
principalBreakageUnder | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
principalBreakageOver | decimal | ||||||||||||||
10135 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | |||||||||||||
PRINCIPAL_ | |||||||||||||||
BREAKAGE_ | NUMBER(38,6) | ||||||||||||||
OVER | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||||
principalBreakageOver | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
incomeBreakageUnder | decimal | ||||||||||||||
10136 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | |||||||||||||
INCOME_BREAKAGE_ | NUMBER(38,6) | EagleML||||||||||||||
UNDER | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||||
incomeBreakageUnder | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
incomeBreakageOver | decimal | 5363 | Hardcode Value - 0|||||||||||||
10137 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME_BREAKAGE_OVER | EagleML/accountingTransaction/accountingCashJournal/ | |||||||||||
incomeBreakageOver | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
AMOUNT | NUMBER(38,6) | brokerCode | string | 88 | otherFeeLocal | decimal | 3752 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BROKEROTHER_FEE_CODELOCAL | CHARNUMBER(2038,6) | EagleML/accountingTransaction/accountingCashJournal/brokerCodeotherFeeLocal | |||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
dividendRatestampDutyTaxLocal | decimal | 589751 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | DIVIDEND_RATESTAMP_DUTY_TAX_L | NUMBER(2838,126) | EagleML/accountingTransaction/accountingCashJournal/dividendRatestampDutyTaxLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITYcurrencyGain | |||||||||||||||
commAmountLocal | decimal | 198 | Calculated Value - Tag 198 = SUM(SETTLED47 | ESTAR | ESTAR_TRADED_CASH_ | DISP_LOTS.CURRENCY_GAINACTIVITY | COMM_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/ | currencyGaincurrencyLoss | decimal | 199 | Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSScommAmountLocal | ||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
taxAmountLocal | decimal | 46 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/taxAmountLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
secFee | decimal | 48 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SEC_FEE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/secFee | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
backupPrice | decimal | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUP_PRICE | EagleML/accountingTransaction/accountingCashJournal/backupPrice | ||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
settleAmountLocal | decimal | 5363 | Hardcode Value - 0 | EagleML/accountingTransaction/accountingCashJournal/settleAmountLocal | |||||||||||
ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | AMOUNT | NUMBER(38,6) | ||||||||||||
brokerCode | string | 88 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BROKER_CODE | CHAR(20) | EagleML/accountingTransaction/accountingCashJournal/brokerCode | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
dividendRate | decimal | 5897 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | DIVIDEND_RATE | NUMBER(28,12) | EagleML/accountingTransaction/accountingCashJournal/dividendRate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
currencyGain | decimal | 198 | Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN) | EagleML/accountingTransaction/accountingCashJournal/currencyGain | |||||||||||
currencyLoss | decimal | 199 | Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS) | EagleML/accountingTransaction/accountingCashJournal/currencyLoss | |||||||||||
localAssetCurrency | CurrencyCode | 9061 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCAL_ASSET_CURRENCY | VARCHAR2(3) | EagleML/accountingTransaction/accountingCashJournal/localAssetCurrency | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
masterTicketNumber | string | 761 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MASTER_TICKET_NUMBER | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/masterTicketNumber | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
tradeDateFxRate | decimal | 87 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TRADE_DT_FX_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/tradeDateFxRate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
corpActInstance | integer | 4268 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORP_ACT_INSTANCE | EagleML/accountingTransaction/accountingCashJournal/corpActInstance | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
netAmountBase | decimal | 478 | Calculated Value - Tag 478 = amount(Tag 50)/Current Fx Rate | EagleML/accountingTransaction/accountingCashJournal/netAmountBase | |||||||||||
SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE) | |||||||||||||||
principalAmountBase* (supported in 2017R1) | decimal | 169 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPAL_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/principalAmountBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
incomeAmountBase | decimal | 1986 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/incomeAmountBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
recPayAccount | string | 1825 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT | EagleML/accountingTransaction/accountingCashJournal/recPayAccount | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
recPayAccountDesc | string | 1651 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT_DESC | EagleML/accountingTransaction/accountingCashJournal/recPayAccountDesc | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
reclaimAmountBase | decimal | 851 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/reclaimAmountBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
taxExpenseBase | decimal | 854 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_EXPENSE_BASE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/taxExpenseBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
breakageAmountUnderBase | decimal | 1995 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGE_AMT_UNDER_B | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/breakageAmountUnderBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
breakageAmountOverBase | decimal | 1997 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_B | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/breakageAmountOverBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
recPayAmountLocal | decimal | 11781 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_AMT_L | EagleML/accountingTransaction/accountingCashJournal/recPayAmountLocal | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
recPayAmountBase | decimal | 11782 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_AMT_B | EagleML/accountingTransaction/accountingCashJournal/recPayAmountBase | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
clearingBroker | string | 1236 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CLEARING_BROKER | VARCHAR2(50) | EagleML/accountingTransaction/accountingCashJournal/clearingBroker | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
taxReclaimRate | decimal | 1296 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/taxReclaimRate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
taxWithholdingRate | decimal | 1295 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/ | currencyLosslocalAssetCurrency | CurrencyCode | 9061taxWithholdingRate | |||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
specialReclaimRate | decimal | 1298 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCALSPECIAL_ASSETRECLAIM_CURRENCYRATE | VARCHAR2NUMBER(338,12) | EagleML/accountingTransaction/accountingCashJournal/localAssetCurrencyspecialReclaimRate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
masterTicketNumberspecialWithholdingRate | stringdecimal | 7611297 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MASTERSPECIAL_TICKETWITHHOLDING_RATE | NUMBERVARCHAR2(5538,12) | EagleML/accountingTransaction/accountingCashJournal/masterTicketNumberspecialWithholdingRate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | tradeDateFxRate|||||||||||||||
sourceEventId | decimalTransactionId | 87 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TRADESOURCE_ | DT_FX_RATENUMBER(38,12)EVENT_ID | EagleML/accountingTransaction/accountingCashJournal/tradeDateFxRatesourceEventId | ||||||||
ESTAR_ | TRADEDSETTLED_CASH_ACTIVITY | \ESTARSOURCE_ | SETTLEDREFERENCE_ | CASH_ACTIVITYID | netAmountBase|||||||||||
targetAccountDate | decimaldate | 478 | Calculated Value - Tag 478 = amount(Tag 50)/Current Fx Rate | EagleML/accountingTransaction/accountingCashJournal/netAmountBase | SUM(119 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | .NETTARGET_ | AMOUNT_BASE)\SUM(ACCT_DATE | EagleML/accountingTransaction/accountingCashJournal/targetAccountDate | |||||
ESTAR_SETTLED_CASH_ACTIVITY | .NET_AMOUNT_BASE)principalAmountBase*|||||||||||||||
gainSwapLocal | decimal | 16911819 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALGAIN_AMOUNTSWAP_BASEL | NUMBER(38,612) | EagleML/accountingTransaction/accountingCashJournal/principalAmountBasegainSwapLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
incomeAmountBaselossSwapLocal | decimal | 198611821 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMELOSS_AMOUNTSWAP_BASEL | NUMBER(38,612) | EagleML/accountingTransaction/accountingCashJournal/incomeAmountBaselossSwapLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
gainSwapBase | |||||||||||||||
decimal | |||||||||||||||
11820 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | |||||||||||||
GAIN_ | |||||||||||||||
SWAP_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/ | |||||||||||||
gainSwapBase | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
reclaimAmountBaselossSwapBase | decimal | 85111822 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIMLOSS_AMOUNTSWAP_BASEB | NUMBER(38,612) | EagleML/accountingTransaction/accountingCashJournal/reclaimAmountBaselossSwapBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
taxExpenseBasetermLoanFeeIncLocal | decimal | 854844 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_EXPENSE_BASETERM_LOAN_FEE_INC_L | NUMBER(38,612) | EagleML/accountingTransaction/accountingCashJournal/taxExpenseBasetermLoanFeeIncLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | breakageAmountUnderBase|||||||||||||||
termLoanFeeIncBase | decimal | 1995845 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGETERM_LOAN_AMTFEE_UNDERINC_B | NUMBER(38,612) | EagleML/accountingTransaction/accountingCashJournal/breakageAmountUnderBasetermLoanFeeIncBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | breakageAmountOverBase|||||||||||||||
termLoanFeeExpLocal | decimal | 1997846 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGETERM_LOAN_AMTFEE_OVEREXP_BL | NUMBER(38,612) | EagleML/accountingTransaction/accountingCashJournal/breakageAmountOverBasetermLoanFeeExpLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
termLoanFeeExpBase | decimal | ||||||||||||||
847 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | |||||||||||||
TERM_LOAN_ | |||||||||||||||
FEE_ | |||||||||||||||
EXP_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/ | |||||||||||||
termLoanFeeExpBase | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
commAmountBase | decimal | ||||||||||||||
498 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | |||||||||||||
COMM_ | |||||||||||||||
AMT_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/ | |||||||||||||
commAmountBase | |||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
clearingBrokerotherFeeBase | stringdecimal | 12365708 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CLEARINGOTHER_FEE_BROKERB | VARCHAR2NUMBER(5038,12) | EagleML/accountingTransaction/accountingCashJournal/clearingBrokerotherFeeBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
taxReclaimRatesecFeeBase | decimal | 129610122 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXSEC_RECLAIMFEE_RATEB | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/taxReclaimRatesecFeeBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
taxWithholdingRatestampDutyTaxBase | decimal | 129510121 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMP_DUTY_TAX_WITHHOLDING_RATEB | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/taxWithholdingRatestampDutyTaxBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
specialReclaimRatefedTaxWithholdingBase | decimal | 12988078 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIALFED_TAX_RECLAIMWITHHOLD_RATEB | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/specialReclaimRatefedTaxWithholdingBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
specialWithholdingRatestTaxWithholdingBase | decimal | 12978079 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIALST_TAX_WITHHOLDINGWITHHOLD_RATEB | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/specialWithholdingRatestTaxWithholdingBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | gainSwapLocal|||||||||||||||
streamSecAlias | decimalinteger | 11819 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAINSTREAM_SWAPSEC_L | NUMBER(38,12) | ALIAS | EagleML/accountingTransaction/accountingCashJournal/gainSwapLocalstreamSecAlias | |||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
lossSwapLocaltaxAmountBase | decimal | 1182110759 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSSTAX_SWAPAMT_LB | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/lossSwapLocaltaxAmountBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
gainSwapBasebuWithholdingLocal | decimal | 118202712 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAINBU_SWAPWTHHLD_BL | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/gainSwapBasebuWithholdingLocal | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
lossSwapBasebuWithholdingBase | decimal | 118222713 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSSBU_SWAPWTHHLD_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/lossSwapBasebuWithholdingBase | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
termLoanFeeIncLocalbuWithholdingRate | decimal | 8442762 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERMBU_LOAN_FEE_INC_LWTHHLD_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncLocalbuWithholdingRate | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
termLoanFeeIncBaseprice | decimal | 84545 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_BPRICE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncBaseprice | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | termLoanFeeExpLocal|||||||||||||||
cancelType | decimalstring | 8462981 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_L | NUMBER(38,12)CANCEL_TYPE | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpLocalcancelType | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | termLoanFeeExpBase|||||||||||||||
cancelFlag | decimalYesNoOptionEnum | 84710045 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_B | NUMBER(38,12)CANCEL_FLAG | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpBasecancelFlag | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | commAmountBase|||||||||||||||
couponDate | decimaldate | 4983460 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COMMCOUPON_AMT_B | NUMBER(38,12) | DATE | EagleML/accountingTransaction/accountingCashJournal/commAmountBasecouponDate | |||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
otherFeeBasecashEventSpawned | decimalstring | 5708751 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHERCASH_FEEEVENT_BSPAWNED | NUMBERVARCHAR2(38,121) | EagleML/accountingTransaction/accountingCashJournal/otherFeeBasecashEventSpawned | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | secFeeBase|||||||||||||||
backupCouponEndDate | decimal | 10122date | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SECBKUP_COUPON_FEEEND_B | NUMBER(38,12) | DATE | EagleML/accountingTransaction/accountingCashJournal/secFeeBasebackupCouponEndDate | |||||||
ESTAR_SETTLED_CASH_ACTIVITY | stampDutyTaxBase|||||||||||||||
origContSettleDate | decimal | 10121date | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMPORIG_DUTYCONT_TAX_BNUMBER(38,12)SETTLE_DT | EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxBaseorigContSettleDate | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | fedTaxWithholdingBase|||||||||||||||
periodicDistType | decimalstring | 80781737 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | FEDPERIODIC_TAX_WITHHOLD_BNUMBER(38,12)DIST_TYPE | EagleML/accountingTransaction/accountingCashJournal/fedTaxWithholdingBaseperiodicDistType | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
stTaxWithholdingBase | decimalcostLotOpenEventId | 8079TransactionId | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STCOST_LOT_TAXOPEN_WITHHOLDEVT_B | NUMBER(38,12) | ID | EagleML/accountingTransaction/accountingCashJournal/stTaxWithholdingBasecostLotOpenEventId | |||||||
ESTAR_SETTLED_CASH_ACTIVITY | taxAmountBase|||||||||||||||
costLotCloseEventId | decimal | 10759TransactionId | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_AMT_B | NUMBER(38,12)COST_LOT_CLOSE_EVT_ID | EagleML/accountingTransaction/accountingCashJournal/taxAmountBasecostLotCloseEventId | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | buWithholdingLocal|||||||||||||||
corpActionType | decimalstring | 2712 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BUCORP_WTHHLD_LNUMBER(38,12)ACTION_TYPE | EagleML/accountingTransaction/accountingCashJournal/buWithholdingLocalcorpActionType | |||||||||
ESTAR_SETTLED_CASH_ACTIVITY | buWithholdingBase|||||||||||||||
cashAccountName | decimalstring | 271311696 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BUCASH_WTHHLDACCT_B | NUMBER(38,12) | NAME | EagleML/accountingTransaction/accountingCashJournal/buWithholdingBasecashAccountName | |||||||
ESTAR_SETTLED_CASH_ACTIVITY | buWithholdingRate|||||||||||||||
cashAccount | decimalstring | 276211697 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_RATE | NUMBER(38,12)CASH_ACCT | EagleML/accountingTransaction/accountingCashJournal/buWithholdingRatecashAccount | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | price|||||||||||||||
cashAccountAlias | decimalinteger | 4511698 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRICE | NUMBER(38,12) | CASH_ACCT_ALIAS | EagleML/accountingTransaction/accountingCashJournal/pricecashAccountAlias | |||||||
ESTAR_SETTLED_CASH_ACTIVITY | cashEventSpawned|||||||||||||||
srcSysC | string | 75198 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASHSRC_EVENTSYS_SPAWNEDC | VARCHAR2(1) | EagleML/accountingTransaction/accountingCashJournal/cashEventSpawnedsrcSysC | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
detailIndicator | string | 8468 | Hardcode Value - "TRADED ACTIVITY" | EagleML/accountingTransaction/accountingCashJournal/detailIndicator | |||||||||||
Hardcode Value - "SETTLED ACTIVITY" | |||||||||||||||
settlementDate | date | 37 | Hardcode Value - "" | EagleML/accountingTransaction/accountingCashJournal/settlementDate | |||||||||||
ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EFFECTIVE_DT | DATE | ||||||||||||
tradedDate | date | 35 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EFFECTIVE_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/tradedDate | ||||||||
ESTAR_TRADED_CASH_ACTIVITY\ ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||||
breakageUnderLocal | decimal | 1994 | Calculated Value - Tag 1994 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_UNDER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_UNDER | EagleML/accountingTransaction/accountingCashJournal/breakageUnderLocal | |||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_UNDER_L | NUMBER(38,12) | |||||||||||||
breakageOverLocal | decimal | 1996 | Calculated Value - Tag 1996 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_OVER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_OVER | EagleML/accountingTransaction/accountingCashJournal/breakageOverLocal | |||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_L | NUMBER(38,12) | |||||||||||||
recPayCategory | string | 1827 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT_DESC | VARCHAR2(100) | EagleML/accountingTransaction/accountingCashJournal/recPayCategory | ||||||||
ESTAR_SETTLED_CASH_ACTIVITY | REC_PAY_ACCT_DESC | VARCHAR2(100) | |||||||||||||
currentFxRate | decimal | 96 | Calculated Value(Default SP - get_spot_rate) - Current Fx Rate | EagleML/accountingTransaction/accountingCashJournal/currentFxRate | |||||||||||
fxRate | decimal | 484 | Calculated Value - Tag 484 = Fx Rate for Date (ESTAR_TRADED_CASH_ACTIVITY.EFFECTIVE_DT) | EagleML/accountingTransaction/accountingCashJournal/fxRate | |||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | TRADE_DT_FX_RATE | NUMBER(38,12) | |||||||||||||
totalRealizedGainLossBase | decimal | 5507 | Calculated Value - Tag 5507 = SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN - SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS | EagleML/accountingTransaction/accountingCashJournal/totalRealizedGainLossBase | |||||||||||
totalGainLossId | decimal | 178 | Calculated Value - Tag 178 = ESTAR_SETTLED_CASH_ACTIVITY.GAIN_CURRENCY - ESTAR_SETTLED_CASH_ACTIVITY.LOSS_CURRENCY | EagleML/accountingTransaction/accountingCashJournal/totalGainLossId | |||||||||||
settledUrglTotalBase | decimal | 11053 | Hardcode Value - 0 | EagleML/accountingTransaction/accountingCashJournal/settledUrglTotalBase | |||||||||||
settleAmountBase | decimal | 479 | Hardcode Value - 0 | EagleML/accountingTransaction/accountingCashJournal/settleAmountBase | |||||||||||
Calculated Value - Tag 479 = amount(Tag 5363)/Current Fx Rate | |||||||||||||||
tradedNetAmountLocal | decimal | 11779 | Calculated Value - Tag 11779 = amount + Tag 1997 - Tag 1995 | EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountLocal | |||||||||||
Hardcode Value - 0 | |||||||||||||||
tradedNetAmountBase | decimal | 11780 | Calculated Value - Tag 11780 = Tag 11779/Current Fx Rate | EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountBase | |||||||||||
Hardcode Value - 0 | |||||||||||||||
netAmountBaseNew | decimal | 4309 | Calculated Value - Tag 4309 = Tag 478 + Tag 5507 + Tag 178(for unsettled) + Tag 50/(End date Fx Rate)(for settled) | EagleML/accountingTransaction/accountingCashJournal/netAmountBaseNew | |||||||||||
Calculated Value - Tag 4309 = Tag 479 + Tag 5507 | |||||||||||||||
notionalResetType | decimal | 4409 | SECURITYDBO | SWAPS | NOTIONAL_RESET_TYPE | EagleML/accountingTransaction/accountingCashJournal/notionalResetType | |||||||||
reportType | decimal | 1257 | Calculated Value - ACCTGDT = Accounting Date; MONTHDT = Month End Date; POSTDT = Post Date; SETTLEDT = Settlement Date; TRADEDT = Trade Date; | EagleML/accountingTransaction/accountingCashJournal/reportType | |||||||||||
regulatoryCategory | decimal | 12387 | RULESDBO | ENTITY_ACCT_BASIS_HIST | REGULATORY_CATEGORY | VARCHAR2(30) | EagleML/accountingTransaction/accountingCashJournal/regulatoryCategory | ||||||||
regulatoryCategoryChanged | string | 891 | EagleML/accountingTransaction/accountingCashJournal/regulatoryCategoryChanged | ||||||||||||
coupon | decimal | 70 | SECURITYDBO | SECURITY_MASTER | COUPON | EagleML/accountingTransaction/accountingCashJournal/coupon | |||||||||
quantityScale | decimal | 19 | SECURITYDBO | SECURITY_MASTER | TRADING_UNIT | EagleML/accountingTransaction/accountingCashJournal/quantityScale | |||||||||
quantityType | StringWithCodeScheme | 12 | SECURITYDBO | SECURITY_MASTER | QUANTITY_TYPE | EagleML/accountingTransaction/accountingCashJournal/quantityType | |||||||||
priceMultiplier | decimal | 18 | SECURITYDBO | SECURITY_MASTER | PRICE_MULTIPLIER | EagleML/accountingTransaction/accountingCashJournal/priceMultiplier | |||||||||
dayCountBasis | DayCountFraction | 471 | SECURITYDBO | SECURITY_MASTER | DAY_CNT | EagleML/accountingTransaction/accountingCashJournal/dayCountBasis | |||||||||
paymentFrequencyCode | StringWithCodeScheme | 472 | SECURITYDBO | SECURITY_MASTER | COUPON_FREQ_CODE | EagleML/accountingTransaction/accountingCashJournal/paymentFrequencyCode | |||||||||
varRateFreqCode | string | 1788 | SECURITYDBO | FIXED_INCOME | VAR_RATE_FREQ_CODE | EagleML/accountingTransaction/accountingCashJournal/varRateFreqCode | |||||||||
payRecIndicator | string | 4590 | SECURITYDBO | SWAPS | PAY_RECEIVE_IND | EagleML/accountingTransaction/accountingCashJournal/payRecIndicator | |||||||||
optiondescr | string | 1364 | EagleML/accountingTransaction/accountingCashJournal/optiondescr | ||||||||||||
interestPaymentTiming | StringWithCodeScheme | 1523 | SECURITYDBO | FIXED_INCOME | ACCRUAL_METHOD | EagleML/accountingTransaction/accountingCashJournal/interestPaymentTiming | |||||||||
businessDayConvention | BusinessDayConventionEnum | 1536 | SECURITYDBO | FIXED_INCOME | INTEREST_METHOD_CODE | EagleML/accountingTransaction/accountingCashJournal/businessDayConvention | |||||||||
businessCalendarName | string | 1480 | EagleML/accountingTransaction/accountingCashJournal/businessCalendarName | ||||||||||||
premiumType | string | 3302 | SECURITYDBO | DERIVATIVES | PREMIUM_TYPE | EagleML/accountingTransaction/accountingCashJournal/premiumType | |||||||||
sectorName | string | 1156 | EagleML/accountingTransaction/accountingCashJournal/sectorName | ||||||||||||
reportView | string | 7009 | resolved by panel | EagleML/accountingTransaction/accountingCashJournal/reportView | |||||||||||
startDate | date | 220 | resolved by panel | EagleML/accountingTransaction/accountingCashJournal/startDate | |||||||||||
endDate | date | 221 | resolved by panel | EagleML/accountingTransaction/accountingCashJournal/endDate |