Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 4 Next »

 

ElementOptional/RequiredValue TypeEagle DBDB TableDB FieldStar TagDB Field TypeXPath
objectTypeOptionalobjectTypenot stored in DBEagleML/accountingTransaction/cashProjections/objectType
objectIdOptionalobjectIdnot stored in DBEagleML/accountingTransaction/cashProjections/objectId
objectDescriptionOptionalobjectDescriptionnot stored in DBEagleML/accountingTransaction/cashProjections/objectDescription
updateTimestampOptionaldateTime     EagleML/accountingTransaction/cashProjections/updateTimestamp
customElementsOptionalCustomElementsreserved for customizationsEagleML/accountingTransaction/cashProjections/customElements
updateSourceOptionalstringESTARESTAR_CASH_PROJECTIONUPDUSER944VARCHAR2(255)EagleML/accountingTransaction/cashProjections/updateSource
cashProjectionOptionalCashProjection Item - Complex type (see extra table below)EagleML/accountingTransaction/cashProjections/cashProjection/

CashProjection Item Data Map Table

ElementOptional/RequiredValue TypeEagle DBDB TableDB FieldStar TagDB Field TypeXPath
cashProjectionInstanceOptionalintegerESTARESTAR_CASH_PROJECTIONCP_INSTANCE NUMBER(10)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionInstance
cashProjectionTypeOptionalintegerESTARESTAR_CASH_PROJECTIONCP_TYPE NUMBER(1)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionType
Entity Common Id ModelEagleML/accountingTransaction/cashProjections/cashProjection/
Entity Properties ModelEagleML/accountingTransaction/cashProjections/cashProjection/
accountingBasisOptionalstringESTARESTAR_CASH_PROJECTIONACCOUNTING_BASIS21VARCHAR2(10)EagleML/accountingTransaction/cashProjections/cashProjection/accountingBasis
statusOptionalintegerESTARESTAR_CASH_PROJECTIONSTATUS54NUMBER(1)EagleML/accountingTransaction/cashProjections/cashProjection/status
startDateOptionaldateESTARESTAR_CASH_PROJECTIONSTART_DATE VARCHAR2(8)EagleML/accountingTransaction/cashProjections/cashProjection/startDate
endDateOptionaldateESTARESTAR_CASH_PROJECTIONEND_DATE73VARCHAR2(8)EagleML/accountingTransaction/cashProjections/cashProjection/endDate
balanceCountOptionalintegerESTARESTAR_CASH_PROJECTIONBALANCE_COUNT NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/balanceCount
currencyOptionalnormalizedStringESTARESTAR_CASH_PROJECTIONCUR CHAR(3)EagleML/accountingTransaction/cashProjections/cashProjection/currency
internalCounterOptionalintegerESTARESTAR_CASH_PROJECTIONINTERNAL_COUNTER NUMBER(38)EagleML/accountingTransaction/cashProjections/cashProjection/internalCounter
positionSwitchOptionalnormalizedStringESTARESTAR_CASH_PROJECTIONPOSITION_SWITCH VARCHAR2(5)EagleML/accountingTransaction/cashProjections/cashProjection/positionSwitch
rejectedCountOptionalintegerESTARESTAR_CASH_PROJECTIONREJECTED_COUNT NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/rejectedCount
reportNameOptionalstringESTARESTAR_CASH_PROJECTIONREPORT_NAME VARCHAR2(255)EagleML/accountingTransaction/cashProjections/cashProjection/reportName
reportTypeOptionalstringESTARESTAR_CASH_PROJECTIONREPORT_TYPE444VARCHAR2(25)EagleML/accountingTransaction/cashProjections/cashProjection/reportType
zeroSwitchOptionalstringESTARESTAR_CASH_PROJECTIONZERO_SWITCH CHAR(10)EagleML/accountingTransaction/cashProjections/cashProjection/zeroSwitch
cashProjectionDetailOptionalCashProjectionDetail Item - Complex type (see extra table below)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail

CashProjectionDetail Item Data Map Table

ElementOptional/RequiredValue TypeEagle DBDB TableDB FieldStar TagDB Field TypeXPath
entityNameOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSENTITY_NAME1164CHAR(30)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityName
entityTypeOptionalnormalizedStringESTARESTAR_CASH_PROJECTION_DETAILSENTITY_TYPE1105CHAR(4)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityType
accountingBasisOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSACCOUNTING_BASIS21VARCHAR2(10)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/accountingBasis
baseCurrencyOptionalnormalizedStringESTARESTAR_CASH_PROJECTION_DETAILSBASE_CURRENCY CHAR(3)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/baseCurrency
primaryAssetIdOptionalInstrumentIdESTARESTAR_CASH_PROJECTION_DETAILSPRIMARY_ASSET_ID14CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryAssetId
primaryAssetTypeOptionalInstrumentIdTypeESTARESTAR_CASH_PROJECTION_DETAILSPRIMARY_ASSET_ID_TYPE1432CHAR(30)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryAssetType
altAssetIdAndTypeOptionalAssetIdAndAssetIdType - Complex type (see extra table below)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/altAssetIdAndType/
issueNameOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSISSUE_NAME961VARCHAR2(255)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issueName
unicodeIssueNameOptionalstringnot stored in DBEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/unicodeIssueName
issueDescriptionOptionalDescriptionESTARESTAR_CASH_PROJECTION_DETAILSISSUE_DESCRIPTION VARCHAR2(255)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issueDescription
tickerOptionalInstrumentIdESTARESTAR_CASH_PROJECTION_DETAILSTICKER CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/ticker
cusipOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7052CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cusip
cusipPayOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cusipPay
cusipReceiveOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cusipReceive
isinOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7055CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/isin
sedolOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7058CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sedol
reutersOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7061CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/reuters
bloombergIdOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7064CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/bloombergId
sicovmIdOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7067CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sicovmId
valorenIdOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7070CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/valorenId
cedelOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7073CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cedel
internalIdOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7076CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/internalId
cinsIdOptionalInstrumentIdSECURITYDBOXREFERENCEXREF_SECURITY_ID7079CHAR(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cinsId
xrefIdentifiersOptionalXrefIdentifiers - Complex type (see extra table)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/xrefIdentifiers/
primaryExchangeOptionalstringSECURITYDBOEQUITY_DETAILPRIMARY_EXCHANGE VARCHAR2(30)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryExchange
primaryExchangeCodeOptionalExchangeCodeSECURITYDBOSECURITY_MASTEREXCHANGE17CHAR(8)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryExchangeCode
securityAliasOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSASSET_ID10NUMBER(28)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/securityAlias
assetCurrencyOptionalCurrencyCodeSECURITYDBOSECURITY_MASTERCURRENCY_CODE85CHAR(30)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/assetCurrency
assetResolutionOptionOptionalAssetResolutionEnumnot stored in DBEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/assetResolutionOption
battingOrderOptionalstringnot stored in DBEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/battingOrder
balanceTypeOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSBALANCE_TYPE VARCHAR2(30)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/balanceType
cashBalanceOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSCASH_BALANCE NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashBalance
cashDisbursementsOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSCASH_DISBURSEMENTS NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashDisbursements
cashProjectionInstanceOptionalintegerESTARESTAR_CASH_PROJECTION_DETAILSCP_INSTANCE NUMBER(10)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashProjectionInstance
projectionDateOptionaldateESTARESTAR_CASH_PROJECTION_DETAILSPROJECTION_DATE DATEEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/projectionDate
transTypeOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSTRANS_TYPE VARCHAR2(255)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/transType
activityInstanceOptionalintegerESTARESTAR_CASH_PROJECTION_DETAILSACTIVITY_INSTANCE NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/activityInstance
brokerCodeOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSBROKER_CODE88CHAR(20)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/brokerCode
brokerDescOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSBROKER_DESC CHAR(50)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/brokerDesc
cashRecieptsOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSCASH_RECIEPTS NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashReciepts
costMethodOptionalnormalizedStringESTARESTAR_CASH_PROJECTION_DETAILSCOST_METHOD22VARCHAR2(2)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/costMethod
couponOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSCOUPON70NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/coupon
couponFrequencyCodeOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSCOUPON_FREQ_CODE CHAR(30)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponFrequencyCode
couponTypeCodeOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSCOUPON_TYPE_CODE97CHAR(8)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponTypeCode
currencyOptionalnormalizedStringESTARESTAR_CASH_PROJECTION_DETAILSCURRENCY CHAR(3)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/currency
eventIdOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSEVENT_ID25VARCHAR2(100)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/eventId
issuerIdOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSISSUER_ID1144CHAR(20)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issuerId
matDateOptionaldateESTARESTAR_CASH_PROJECTION_DETAILSMAT_DATE DATEEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/matDate
nraTaxCountryOptionalstringESTARESTAR_CASH_PROJECTION_DETAILSNRA_TAX_COUNTRY CHAR(30)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/nraTaxCountry
positionFlagOptionalintegerESTARESTAR_CASH_PROJECTION_DETAILSPOSITION_FLAG NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/positionFlag
priceMultiplierOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSPRICE_MULTIPLIER18NUMBER(28,12)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/priceMultiplier
quantityOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSQTY NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/quantity
stateCodeOptionalnormalizedStringESTARESTAR_CASH_PROJECTION_DETAILSSTATE_CODE1343CHAR(2)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/stateCode
tradeDateOptionaldateESTARESTAR_CASH_PROJECTION_DETAILSTRADE_DATE DATEEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/tradeDate
tradingUnitOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSTRADING_UNIT NUMBER(28,12)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/tradingUnit
xRateLocalBaseOptionaldecimalESTARESTAR_CASH_PROJECTION_DETAILSXRATE_LOC_BASE NUMBER(38,8)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/xRateLocalBase
userGroupChar4OptionalstringESTARESTAR_CASH_PROJECTION_DETAILSUSER_GROUP_CHAR4 VARCHAR2(60)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar4
userGroupChar5OptionalstringESTARESTAR_CASH_PROJECTION_DETAILSUSER_GROUP_CHAR5 VARCHAR2(60)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar5
userGroupChar6OptionalstringESTARESTAR_CASH_PROJECTION_DETAILSUSER_GROUP_CHAR6 VARCHAR2(60)EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar6
userIndexOptionalintegerESTARESTAR_CASH_PROJECTION_DETAILSUSER_INDEX NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userIndex
sumCashDisbursementsOptionaldecimalESTARTEMP_CPDSUM_CASH_DISBURSEMENTS NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumCashDisbursements
sumCashRecieptsOptionaldecimalESTARTEMP_CPDSUM_CASH_RECIEPTS NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumCashReciepts
countMOptionalintegerESTARTEMP_CPDCOUNT_M NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/countM
maxUserIndexOptionalintegerESTARTEMP_CPDMAX_USER_INDEX NUMBEREagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/maxUserIndex
maxCashBalanceOptionaldecimalGenerated by QUERY_CP_RECORD_DETAILS procedureEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/maxCashBalance
sumQtyOptionaldecimalGenerated by QUERY_CP_RECORD_DETAILS procedureEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumQty
  • No labels