...
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 | |||||||||||||
entityId | string | 5 | RULESDBO | ENTITY | ENTITY_ID | CHAR(8) | EagleML/accountingTransaction/accountingCashJournal/entityId | |||||||||||||
entityName | string | 1159 | RULESDBO | ENTITY | ENTITY_NAME | CHAR(30) | EagleML/accountingTransaction/accountingCashJournal/entityName | |||||||||||||
primaryAssetId | InstrumentId | 14 | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID | CHAR(100) | EagleML/accountingTransaction/accountingCashJournal/primaryAssetId | |||||||||||||
primaryAssetType | InstrumentId | 1432 | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID_TYPE | CHAR(30) | EagleML/accountingTransaction/accountingCashJournal/primaryAssetType | |||||||||||||
altAssetIdAndType Model | 1795, 5501 | EagleML/accountingTransaction/accountingCashJournal/altAssetIdAndType/ | ||||||||||||||||||
issueName | string | 961 | SECURITYDBO | SECURITY_MASTER | ISSUE_NAME | VARCHAR2(255) | EagleML/accountingTransaction/accountingCashJournal/issueName | |||||||||||||
issueDescription | Description | 962 | SECURITYDBO | SECURITY_MASTER | ISSUE_DESCRIPTION | VARCHAR2(255) | EagleML/accountingTransaction/accountingCashJournal/issueDescription | |||||||||||||
ticker | InstrumentId | 13 | SECURITYDBO | SECURITY_MASTER | TICKER | CHAR(100) | EagleML/accountingTransaction/accountingCashJournal/ticker | |||||||||||||
securityAlias | integer | 10 | SECURITYDBO | SECURITY_MASTER | SECURITY_ALIAS | NUMBER | EagleML/accountingTransaction/accountingCashJournal/securityAlias | |||||||||||||
assetCurrency | CurrencyCode | 85 | SECURITYDBO | SECURITY_MASTER | CURRENCY_CODE | CHAR(30) | EagleML/accountingTransaction/accountingCashJournal/assetCurrency | |||||||||||||
investmentType | StringWithCodeScheme | 11 | SECURITYDBO | SECURITY_MASTER | INVESTMENT_TYPE | CHAR(4) | EagleML/accountingTransaction/accountingCashJournal/investmentType | |||||||||||||
processingSecurityType | StringWithCodeScheme | 3931 | SECURITYDBO | SECURITY_MASTER | PROCESS_SEC_TYPE | VARCHAR2(15) | EagleML/accountingTransaction/accountingCashJournal/processingSecurityType | |||||||||||||
securityType | string | 82 | SECURITYDBO | SECURITY_MASTER | SECURITY_TYPE | CHAR(15) | EagleML/accountingTransaction/accountingCashJournal/securityType | |||||||||||||
issueCountryCode | CountryCode | 1418 | SECURITYDBO | SECURITY_MASTER | NRA_TAX_COUNTRY | CHAR(30) | EagleML/accountingTransaction/accountingCashJournal/issueCountryCode | |||||||||||||
couponTypeCode | StringWithCodeScheme | 97 | SECURITYDBO | SECURITY_MASTER | COUPON_TYPE_CODE | CHAR(8)Entity Common Id Model | EagleML/accountingTransaction/accountingCashJournal/ | couponTypeCodesecuritySubType | string | 1464 | SECURITYDBO | SECURITY_MASTER_DETAIL | ALT_SECURITY_TYPE | CHAR(15)|||||||
Asset Identifiers Model | EagleML/accountingTransaction/accountingCashJournal/ | |||||||||||||||||||
Asset Properties Model | EagleML/accountingTransaction/accountingCashJournal/ | securitySubType|||||||||||||||||||
maturityDate | date | 38 | SECURITYDBO | SECURITY_MASTER | MAT_DATE | DATE | EagleML/accountingTransaction/accountingCashJournal/maturityDate | |||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||||||
cashStatus | string | 54 | Hardcode Value - "" | EagleML/accountingTransaction/accountingCashJournal/cashStatus | ||||||||||||||||
cashCategory | string | 62 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_CATEGORY | VARCHAR2(50) | EagleML/accountingTransaction/accountingCashJournal/cashCategory | |||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||||||
recPayAccount2 | string | 1826 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT2 | EagleML/accountingTransaction/accountingCashJournal/recPayAccount2 | ||||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
otherFeeLocal | decimal | 3752 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHER_FEE_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/otherFeeLocal | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
stampDutyTaxLocal | decimal | 51 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMP_DUTY_TAX_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxLocal | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
commAmountLocal | decimal | 47 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COMM_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/commAmountLocal | |||||||||||||
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 | ||||||||||||||||||||
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_TRADED_CASH_ACTIVITY\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 | ||||||||||||||||||||
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/taxWithholdingRate | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
specialReclaimRate | decimal | 1298 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIAL_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/specialReclaimRate | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
specialWithholdingRate | decimal | 1297 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIAL_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/specialWithholdingRate | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
gainSwapLocal | decimal | 11819 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAIN_SWAP_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/gainSwapLocal | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
lossSwapLocal | decimal | 11821 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAP_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/lossSwapLocal | |||||||||||||
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 | ||||||||||||||||||||
lossSwapBase | decimal | 11822 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAP_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/lossSwapBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
termLoanFeeIncLocal | decimal | 844 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncLocal | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
termLoanFeeIncBase | decimal | 845 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
termLoanFeeExpLocal | decimal | 846 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpLocal | |||||||||||||
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 | ||||||||||||||||||||
otherFeeBase | decimal | 5708 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHER_FEE_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/otherFeeBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
secFeeBase | decimal | 10122 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SEC_FEE_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/secFeeBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
stampDutyTaxBase | decimal | 10121 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMP_DUTY_TAX_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
fedTaxWithholdingBase | decimal | 8078 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | FED_TAX_WITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/fedTaxWithholdingBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
stTaxWithholdingBase | decimal | 8079 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ST_TAX_WITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/stTaxWithholdingBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
taxAmountBase | decimal | 10759 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_AMT_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/taxAmountBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
buWithholdingLocal | decimal | 2712 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/buWithholdingLocal | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
buWithholdingBase | decimal | 2713 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/buWithholdingBase | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
buWithholdingRate | decimal | 2762 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/buWithholdingRate | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
price | decimal | 45 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRICE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/price | |||||||||||||
ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||||
cashEventSpawned | string | 751 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_EVENT_SPAWNED | VARCHAR2(1) | EagleML/accountingTransaction/accountingCashJournal/cashEventSpawned | |||||||||||||
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 | 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 |