Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | XPath |
---|---|---|---|---|---|---|---|---|
objectType | Optional | objectType | not stored in DB | EagleML/accountingTransaction/cashProjections/objectType | ||||
objectId | Optional | objectId | not stored in DB | EagleML/accountingTransaction/cashProjections/objectId | ||||
objectDescription | Optional | objectDescription | not stored in DB | EagleML/accountingTransaction/cashProjections/objectDescription | ||||
updateTimestamp | Optional | dateTime | EagleML/accountingTransaction/cashProjections/updateTimestamp | |||||
customElements | Optional | CustomElements | reserved for customizations | EagleML/accountingTransaction/cashProjections/customElements | ||||
updateSource | Optional | string | ESTAR | ESTAR_CASH_PROJECTION | UPDUSER | 944 | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/updateSource |
cashProjection | Optional | CashProjection Item - Complex type (see extra table below) | EagleML/accountingTransaction/cashProjections/cashProjection/ | |||||
CashProjection Item Data Map Table | ||||||||
Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | XPath |
cashProjectionInstance | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION | CP_INSTANCE | NUMBER(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionInstance | |
cashProjectionType | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION | CP_TYPE | NUMBER(1) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionType | |
Entity Common Id Model | EagleML/accountingTransaction/cashProjections/cashProjection/ | |||||||
Entity Properties Model | EagleML/accountingTransaction/cashProjections/cashProjection/ | |||||||
accountingBasis | Optional | string | ESTAR | ESTAR_CASH_PROJECTION | ACCOUNTING_BASIS | 21 | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/accountingBasis |
status | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION | STATUS | 54 | NUMBER(1) | EagleML/accountingTransaction/cashProjections/cashProjection/status |
startDate | Optional | date | ESTAR | ESTAR_CASH_PROJECTION | START_DATE | VARCHAR2(8) | EagleML/accountingTransaction/cashProjections/cashProjection/startDate | |
endDate | Optional | date | ESTAR | ESTAR_CASH_PROJECTION | END_DATE | 73 | VARCHAR2(8) | EagleML/accountingTransaction/cashProjections/cashProjection/endDate |
balanceCount | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION | BALANCE_COUNT | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/balanceCount | |
currency | Optional | normalizedString | ESTAR | ESTAR_CASH_PROJECTION | CUR | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/currency | |
internalCounter | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION | INTERNAL_COUNTER | NUMBER(38) | EagleML/accountingTransaction/cashProjections/cashProjection/internalCounter | |
positionSwitch | Optional | normalizedString | ESTAR | ESTAR_CASH_PROJECTION | POSITION_SWITCH | VARCHAR2(5) | EagleML/accountingTransaction/cashProjections/cashProjection/positionSwitch | |
rejectedCount | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION | REJECTED_COUNT | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/rejectedCount | |
reportName | Optional | string | ESTAR | ESTAR_CASH_PROJECTION | REPORT_NAME | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/cashProjection/reportName | |
reportType | Optional | string | ESTAR | ESTAR_CASH_PROJECTION | REPORT_TYPE | 444 | VARCHAR2(25) | EagleML/accountingTransaction/cashProjections/cashProjection/reportType |
zeroSwitch | Optional | string | ESTAR | ESTAR_CASH_PROJECTION | ZERO_SWITCH | CHAR(10) | EagleML/accountingTransaction/cashProjections/cashProjection/zeroSwitch | |
cashProjectionDetail | Optional | CashProjectionDetail Item - Complex type (see extra table below) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail | |||||
CashProjectionDetail Item Data Map Table | ||||||||
Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | XPath |
entityName | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ENTITY_NAME | 1164 | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityName |
entityType | Optional | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ENTITY_TYPE | 1105 | CHAR(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityType |
accountingBasis | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ACCOUNTING_BASIS | 21 | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/accountingBasis |
baseCurrency | Optional | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | BASE_CURRENCY | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/baseCurrency | |
primaryAssetId | Optional | InstrumentId | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | PRIMARY_ASSET_ID | 14 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryAssetId |
primaryAssetType | Optional | InstrumentIdType | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | PRIMARY_ASSET_ID_TYPE | 1432 | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryAssetType |
altAssetIdAndType | Optional | AssetIdAndAssetIdType - Complex type (see extra table below) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/altAssetIdAndType/ | |||||
issueName | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ISSUE_NAME | 961 | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issueName |
unicodeIssueName | Optional | string | not stored in DB | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/unicodeIssueName | ||||
issueDescription | Optional | Description | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ISSUE_DESCRIPTION | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issueDescription | |
ticker | Optional | InstrumentId | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | TICKER | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/ticker | |
cusip | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7052 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cusip |
cusipPay | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cusipPay | |
cusipReceive | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cusipReceive | |
isin | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7055 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/isin |
sedol | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7058 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sedol |
reuters | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7061 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/reuters |
bloombergId | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7064 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/bloombergId |
sicovmId | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7067 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sicovmId |
valorenId | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7070 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/valorenId |
cedel | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7073 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cedel |
internalId | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7076 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/internalId |
cinsId | Optional | InstrumentId | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | 7079 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cinsId |
xrefIdentifiers | Optional | XrefIdentifiers - Complex type (see extra table) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/xrefIdentifiers/ | |||||
primaryExchange | Optional | string | SECURITYDBO | EQUITY_DETAIL | PRIMARY_EXCHANGE | VARCHAR2(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryExchange | |
primaryExchangeCode | Optional | ExchangeCode | SECURITYDBO | SECURITY_MASTER | EXCHANGE | 17 | CHAR(8) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryExchangeCode |
securityAlias | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ASSET_ID | 10 | NUMBER(28) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/securityAlias |
assetCurrency | Optional | CurrencyCode | SECURITYDBO | SECURITY_MASTER | CURRENCY_CODE | 85 | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/assetCurrency |
assetResolutionOption | Optional | AssetResolutionEnum | not stored in DB | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/assetResolutionOption | ||||
battingOrder | Optional | string | not stored in DB | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/battingOrder | ||||
balanceType | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | BALANCE_TYPE | VARCHAR2(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/balanceType | |
cashBalance | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CASH_BALANCE | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashBalance | |
cashDisbursements | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CASH_DISBURSEMENTS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashDisbursements | |
cashProjectionInstance | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CP_INSTANCE | NUMBER(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashProjectionInstance | |
projectionDate | Optional | date | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | PROJECTION_DATE | DATE | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/projectionDate | |
transType | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | TRANS_TYPE | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/transType | |
activityInstance | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ACTIVITY_INSTANCE | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/activityInstance | |
brokerCode | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | BROKER_CODE | 88 | CHAR(20) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/brokerCode |
brokerDesc | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | BROKER_DESC | CHAR(50) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/brokerDesc | |
cashReciepts | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CASH_RECIEPTS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashReciepts | |
costMethod | Optional | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COST_METHOD | 22 | VARCHAR2(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/costMethod |
coupon | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COUPON | 70 | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/coupon |
couponFrequencyCode | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COUPON_FREQ_CODE | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponFrequencyCode | |
couponTypeCode | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COUPON_TYPE_CODE | 97 | CHAR(8) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponTypeCode |
currency | Optional | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CURRENCY | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/currency | |
eventId | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | EVENT_ID | 25 | VARCHAR2(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/eventId |
issuerId | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ISSUER_ID | 1144 | CHAR(20) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issuerId |
matDate | Optional | date | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | MAT_DATE | DATE | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/matDate | |
nraTaxCountry | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | NRA_TAX_COUNTRY | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/nraTaxCountry | |
positionFlag | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | POSITION_FLAG | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/positionFlag | |
priceMultiplier | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | PRICE_MULTIPLIER | 18 | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/priceMultiplier |
quantity | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | QTY | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/quantity | |
stateCode | Optional | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | STATE_CODE | 1343 | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/stateCode |
tradeDate | Optional | date | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | TRADE_DATE | DATE | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/tradeDate | |
tradingUnit | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | TRADING_UNIT | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/tradingUnit | |
xRateLocalBase | Optional | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | XRATE_LOC_BASE | NUMBER(38,8) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/xRateLocalBase | |
userGroupChar4 | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | USER_GROUP_CHAR4 | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar4 | |
userGroupChar5 | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | USER_GROUP_CHAR5 | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar5 | |
userGroupChar6 | Optional | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | USER_GROUP_CHAR6 | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar6 | |
userIndex | Optional | integer | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | USER_INDEX | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userIndex | |
sumCashDisbursements | Optional | decimal | ESTAR | TEMP_CPD | SUM_CASH_DISBURSEMENTS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumCashDisbursements | |
sumCashReciepts | Optional | decimal | ESTAR | TEMP_CPD | SUM_CASH_RECIEPTS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumCashReciepts | |
countM | Optional | integer | ESTAR | TEMP_CPD | COUNT_M | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/countM | |
maxUserIndex | Optional | integer | ESTAR | TEMP_CPD | MAX_USER_INDEX | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/maxUserIndex | |
maxCashBalance | Optional | decimal | Generated by QUERY_CP_RECORD_DETAILS procedure | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/maxCashBalance | ||||
sumQty | Optional | decimal | Generated by QUERY_CP_RECORD_DETAILS procedure | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumQty |