Versions Compared

Old Version 11

changes.mady.by.user Dmitry Donosiyan (Unlicensed)

Saved on

compared with

New Version 12

changes.mady.by.user Dmitry Donosiyan (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
titleNote
This model is is extract-only and it is not extracted by default. To add it to your extract, you should have the IncludeExtendedDetails task parameter on your RTR. 
  • ​IncludeExtendedDetails=Y adds this model partially, only elements before the delimiter included.
  • ​IncludeExtendedDetails=ALL adds full model, including elements after the delimiter.

Entity Properties Model Data Map Table

ElementValue TypeStar TagSP ParameterEagle DBDB TableDB FieldDB Field TypeXpath
accountTypestring4056
RULESDBOENTITY_EXTENSIONUSER_CHAR3VARCHAR2(255)../accountType
parentCompositeIdstring4054
RULESDBOENTITY_EXTENSIONUSER_CHAR1VARCHAR2(20)../parentCompositeId
counterpartyIdstring4065
RULESDBOENTITY_EXTENSIONUSER_CHAR12VARCHAR2 (20)../counterpartyId
closedDatedateTime933in_closed_dateESTARESTAR_ACCOUNTING_PERIODSCLOSED_DTDATE../closedDate
closedFlagstring2072in_closed_flagRULESDBOENTITYCLOSED_FLAGCHAR(20)../closedFlag
fxSourcestring1344in_fx_sourceRULESDBOENTITYFX_SOURCECHAR(15)../fxSource
terminationDatedate1161in_termination_dateRULESDBOENTITYTERMINATION_DATEDATE../terminationDate
inceptionDatedate1138in_inception_dateRULESDBOENTITYINCEPTION_DATEDATE../inceptionDate
fiscalEndDatedate1162in_fiscal_end_dateRULESDBOENTITYFISCAL_END_DATEDATE../fiscalEndDate
entityBaseCurrencyCurrencyCode86in_base_currencyRULESDBOENTITYBASE_CURRENCYCHAR(3)../entityBaseCurrency
entityCostMethodstring22
RULESDBOENTITYCOST_METHODVARCHAR2 (10)../entityCostMethod

Extended Entity Properties:

To add the elements below, please set IncludeExtendedDetails=ALL in the RTR
entityAccountingBasisstring21
RULESDBOENTITYACCOUNTING_BASISVARCHAR2 (10)../entityAccountingBasis
entityPriceMethodstring1872
RULESDBOENTITYPRICE_METHODCHAR../entityPriceMethod
entitySubTypestring78
RULESDBOENTITYENTITY_SUB_TYPEVARCHAR2(20)../entitySubType
entitySectorTypestring3948
RULESDBOENTITY_STAR_PROCESSINGSECTOR_TYPECHAR../entitySectorType
entityMasterNamestring1164
RULESDBOENTITYENTITY_NAMECHAR (30)../entityMasterName
entityMasterIdstring1163
RULESDBOENTITYENTITY_IDCHAR (8)../entityMasterId
entitySectorNamestring1164
RULESDBOENTITYENTITY_NAMECHAR (30)../entitySectorName
entitySectorIdstring1163
RULESDBOENTITYENTITY_IDCHAR (8)../entitySectorId
entitySectorCountinteger

Count of Underlying Sectors for Master Entity
../entitySectorCount
navRoundingstring10064
RULESDBOENTITYNAV_ROUNDINGVARCHAR2(2)../navRounding
numberOfNavDigitsinteger10065
RULESDBOENTITYNUMBER_OF_NAV_DIGITSNUMBER(38,0)../numberOfNavDigits
legalEntityIdentifierstring

RULESDBOENTITYLEIVARCHAR2 (20)../legalEntityIdentifier
bankAccountNumberstring9507
RULESDBOENTITYBANK_ACCOUNT_NUMBERVARCHAR2 (12)../bankAccountNumber
bankBranchCodestring2065
RULESDBOENTITYBANK_BRANCH_CODECHAR (20)../bankBranchCode
countryOfTaxstring1342
RULESDBOENTITYCOUNTRY_OF_TAXCHAR../countryOfTax
varRateSourcestring3301
RULESDBOENTITYVAR_RATE_SOURCECHAR../varRateSource
eabCoaNamestring1641
RULESDBOENTITY_ACCT_BASISCOA_NAMECHAR../eabCoaName
eabPriceSourcestring1282
RULESDBOENTITY_ACCT_BASISPRICE_SOURCE CHAR../eabPriceSource
eabRegulatoryCategorystring12387
RULESDBOENTITY_ACCT_BASISREGULATORY_CATEGORY CHAR../eabRegulatoryCategory
taxExemptProcessingFlagstring4948
RULESDBOENTITY_ACCT_BASIS TAX_EXEMPT_FLAGCHAR../taxExemptProcessingFlag
entityBasisBaseCurrencystring

RULESDBOENTITY_ACCT_BASIS BASE_CURRENCYCHAR../entityBasisBaseCurrency
nonBusDayProcessingstring3907
RULESDBOENTITY_STAR_PROCESSINGNON_BUS_DAY_PROCESSINGVARCHAR2 (10)../nonBusDayProcessing
distributionMethodstring3904
RULESDBOENTITY_STAR_PROCESSINGDISTRIBUTION_METHODCHAR../distributionMethod
paydowmGlAccountstring4519
RULESDBOENTITY_STAR_PROCESSINGPYDN_GL_ACCNTCHAR../paydowmGlAccount
taxWthldAccntMethodstring3912
RULESDBOENTITY_STAR_PROCESSINGTAX_WTHLD_ACCNT_METHODCHAR../taxWthldAccntMethod
starAcctField29string3928
RULESDBOENTITY_STAR_PROCESSINGSTAR_ACCT_FIELD_29CHAR../starAcctField29
entityUserDate1date1320
RULESDBOENTITYUSER_DATE1DATE../entityUserDate1
entityUserDate4date1319
RULESDBOENTITYUSER_DATE4DT../entityUserDate4
userField3string1858
RULESDBOENTITYUSER_FIELD3VARCHAR2 (10)../userField3
userField13string1866
RULESDBOENTITYUSER_FIELD13VARCHAR2 (10)../userField13
userField15string1867
RULESDBOENTITYUSER_FIELD15VARCHAR2 (10)../userField15
userField16string1868
RULESDBOENTITYUSER_FIELD16VARCHAR2 (10)../userField16
userField17string1642
RULESDBOENTITYUSER_FIELD17VARCHAR2 (10)../userField17
userField18string1643
RULESDBOENTITYUSER_FIELD18VARCHAR2 (10)../userField18
userField19string1644
RULESDBOENTITYUSER_FIELD19VARCHAR2 (10)../userField19
userField20string1645
RULESDBOENTITYUSER_FIELD20VARCHAR2 (10)../userField20
userField21string1646
RULESDBOENTITYUSER_FIELD21VARCHAR2 (20)../userField21
userField22string1647
RULESDBOENTITYUSER_FIELD22VARCHAR2 (20)../userField22
exUserChar1string4054
RULESDBOENTITY_EXTENSIONUSER_CHAR1VARCHAR2 (20)../exUserChar1
exUserChar3string4056
RULESDBOENTITY_EXTENSIONUSER_CHAR3VARCHAR2 (20)../exUserChar3
exUserChar9string4062
RULESDBOENTITY_EXTENSIONUSER_CHAR9VARCHAR2 (20)../exUserChar9
exUserChar12string4065
RULESDBOENTITY_EXTENSIONUSER_CHAR12VARCHAR2 (20)../exUserChar12
exUserChar30string4083
RULESDBOENTITY_EXTENSIONUSER_CHAR30VARCHAR2 (20)../exUserChar30
exUserChar31string4084
RULESDBOENTITY_EXTENSIONUSER_CHAR31VARCHAR2 (20)../exUserChar31
exUserChar32string4085
RULESDBOENTITY_EXTENSIONUSER_CHAR32VARCHAR2 (20)../exUserChar32
exUserChar33string4086
RULESDBOENTITY_EXTENSIONUSER_CHAR33VARCHAR2 (20)../exUserChar33
exUserChar45string4098
RULESDBOENTITY_EXTENSIONUSER_CHAR45VARCHAR2 (20)../exUserChar45
exUserInd47string4170
RULESDBOENTITY_EXTENSIONUSER_IND47VARCHAR2 (3)../exUserInd47
exUserInd48string4171
RULESDBOENTITY_EXTENSIONUSER_IND48VARCHAR2 (3)../exUserInd48
exUserInd49string4172
RULESDBOENTITY_EXTENSIONUSER_IND49VARCHAR2 (3)../exUserInd49
exUserDate10date4203
RULESDBOENTITY_EXTENSIONUSER_DATE10DATE../exUserDate10
mffEntitystring16618
RULESDBOENTITY_STAR_PROCESSINGMFF_ENTITYVARCHAR2(20)../mffEntity
acctPeriodFreqstring624
RULESDBOENTITY_ACCT_BASISACCT_PERIOD_FREQ
../acctPeriodFreq
processCenterstring4896
RULESDBOENTITY_STAR_PROCESSINGPROCESS_CENTER
../processCenter
ccProcessCtrstring11407
RULESDBOENTITY_STAR_PROCESSINGCC_PROCESS_CTR
../ccProcessCtr
ccEntitystring10462
RULESDBOENTITY_STAR_PROCESSINGCC_ENTITY
../ccEntity
portCompTypestring3953
RULESDBOENTITYPORT_COMP_TYPE
../portCompType