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

« Previous Version 16 Next »

Note

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
accountTypestring4056in_ex_user_char3RULESDBOENTITY_EXTENSIONUSER_CHAR3VARCHAR2(255)../accountType
parentCompositeIdstring4054in_ex_user_char1RULESDBOENTITY_EXTENSIONUSER_CHAR1VARCHAR2(20)../parentCompositeId
parentCompositeNamestring

RULESDBOENTITYENTITY_NAMECHAR (30)../parentCompositeName
counterpartyIdstring4065in_ex_user_char12RULESDBOENTITY_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
entityCostMethodstring22in_cost_methodRULESDBOENTITYCOST_METHODVARCHAR2 (10)../entityCostMethod

Extended Entity Properties:

To add the elements below, please set IncludeExtendedDetails=ALL in the RTR
entityAccountingBasisstring21
RULESDBOENTITYACCOUNTING_BASISVARCHAR2 (10)../entityAccountingBasis
entityPriceMethodstring1872in_price_methodRULESDBOENTITYPRICE_METHODCHAR../entityPriceMethod
entitySubTypestring78in_entity_sub_typeRULESDBOENTITYENTITY_SUB_TYPEVARCHAR2(20)../entitySubType
entitySectorTypestring3948in_sector_typeRULESDBOENTITY_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
navRoundingstring10064in_nav_roundingRULESDBOENTITYNAV_ROUNDINGVARCHAR2(2)../navRounding
numberOfNavDigitsinteger10065in_number_of_nav_digitsRULESDBOENTITYNUMBER_OF_NAV_DIGITSNUMBER(38,0)../numberOfNavDigits
legalEntityIdentifierstring

RULESDBOENTITYLEIVARCHAR2 (20)../legalEntityIdentifier
bankAccountNumberstring9507in_bank_account_numberRULESDBOENTITYBANK_ACCOUNT_NUMBERVARCHAR2 (12)../bankAccountNumber
bankBranchCodestring2065in_bank_branch_codeRULESDBOENTITYBANK_BRANCH_CODECHAR (20)../bankBranchCode
countryOfTaxstring1342in_country_of_taxRULESDBOENTITYCOUNTRY_OF_TAXCHAR../countryOfTax
varRateSourcestring3301in_var_rate_sourceRULESDBOENTITYVAR_RATE_SOURCECHAR../varRateSource
eabCoaNamestring1641in_coa_nameRULESDBOENTITY_ACCT_BASISCOA_NAMECHAR../eabCoaName
eabPriceSourcestring1282in_price_sourceRULESDBOENTITY_ACCT_BASISPRICE_SOURCE CHAR../eabPriceSource
eabRegulatoryCategorystring12387in_regulatory_categoryRULESDBOENTITY_ACCT_BASISREGULATORY_CATEGORY CHAR../eabRegulatoryCategory
taxExemptProcessingFlagstring4948
RULESDBOENTITY_ACCT_BASIS TAX_EXEMPT_FLAGCHAR../taxExemptProcessingFlag
entityBasisBaseCurrencystring86in_base_currencyRULESDBOENTITY_ACCT_BASIS BASE_CURRENCYCHAR../entityBasisBaseCurrency
nonBusDayProcessingstring3907in_non_bus_day_processingRULESDBOENTITY_STAR_PROCESSINGNON_BUS_DAY_PROCESSINGVARCHAR2 (10)../nonBusDayProcessing
distributionMethodstring3904in_distribution_methodRULESDBOENTITY_STAR_PROCESSINGDISTRIBUTION_METHODCHAR../distributionMethod
paydowmGlAccountstring4519in_pydn_gl_accntRULESDBOENTITY_STAR_PROCESSINGPYDN_GL_ACCNTCHAR../paydowmGlAccount
taxWthldAccntMethodstring3912in_tax_wthld_accnt_methodRULESDBOENTITY_STAR_PROCESSINGTAX_WTHLD_ACCNT_METHODCHAR../taxWthldAccntMethod
starAcctField29string3928in_star_acct_field_29RULESDBOENTITY_STAR_PROCESSINGSTAR_ACCT_FIELD_29CHAR../starAcctField29
entityUserDate1date1320in_user_date1RULESDBOENTITYUSER_DATE1DATE../entityUserDate1
entityUserDate4date1319in_user_date4RULESDBOENTITYUSER_DATE4DT../entityUserDate4
userField3string1858in_user_field3RULESDBOENTITYUSER_FIELD3VARCHAR2 (10)../userField3
userField13string1866in_user_field13RULESDBOENTITYUSER_FIELD13VARCHAR2 (10)../userField13
userField15string1867in_user_field15RULESDBOENTITYUSER_FIELD15VARCHAR2 (10)../userField15
userField16string1868in_user_field16RULESDBOENTITYUSER_FIELD16VARCHAR2 (10)../userField16
userField17string1642in_user_field17RULESDBOENTITYUSER_FIELD17VARCHAR2 (10)../userField17
userField18string1643in_user_field18RULESDBOENTITYUSER_FIELD18VARCHAR2 (10)../userField18
userField19string1644in_user_field19RULESDBOENTITYUSER_FIELD19VARCHAR2 (10)../userField19
userField20string1645in_user_field20RULESDBOENTITYUSER_FIELD20VARCHAR2 (10)../userField20
userField21string1646in_user_field21RULESDBOENTITYUSER_FIELD21VARCHAR2 (20)../userField21
userField22string1647in_user_field22RULESDBOENTITYUSER_FIELD22VARCHAR2 (20)../userField22
exUserChar1string4054in_ex_user_char1RULESDBOENTITY_EXTENSIONUSER_CHAR1VARCHAR2 (20)../exUserChar1
exUserChar3string4056in_ex_user_char3RULESDBOENTITY_EXTENSIONUSER_CHAR3VARCHAR2 (20)../exUserChar3
exUserChar9string4062in_ex_user_char9RULESDBOENTITY_EXTENSIONUSER_CHAR9VARCHAR2 (20)../exUserChar9
exUserChar12string4065in_ex_user_char12RULESDBOENTITY_EXTENSIONUSER_CHAR12VARCHAR2 (20)../exUserChar12
exUserChar30string4083in_ex_user_char30RULESDBOENTITY_EXTENSIONUSER_CHAR30VARCHAR2 (20)../exUserChar30
exUserChar31string4084in_ex_user_char31RULESDBOENTITY_EXTENSIONUSER_CHAR31VARCHAR2 (20)../exUserChar31
exUserChar32string4085in_ex_user_char32RULESDBOENTITY_EXTENSIONUSER_CHAR32VARCHAR2 (20)../exUserChar32
exUserChar33string4086in_ex_user_char33RULESDBOENTITY_EXTENSIONUSER_CHAR33VARCHAR2 (20)../exUserChar33
exUserChar45string4098in_ex_user_char45RULESDBOENTITY_EXTENSIONUSER_CHAR45VARCHAR2 (20)../exUserChar45
exUserInd47string4170in_ex_user_ind47RULESDBOENTITY_EXTENSIONUSER_IND47VARCHAR2 (3)../exUserInd47
exUserInd48string4171in_ex_user_ind48RULESDBOENTITY_EXTENSIONUSER_IND48VARCHAR2 (3)../exUserInd48
exUserInd49string4172in_ex_user_ind49RULESDBOENTITY_EXTENSIONUSER_IND49VARCHAR2 (3)../exUserInd49
exUserDate10date4203in_ex_user_date10RULESDBOENTITY_EXTENSIONUSER_DATE10DATE../exUserDate10
mffEntitystring16618in_mff_entityRULESDBOENTITY_STAR_PROCESSINGMFF_ENTITYVARCHAR2(20)../mffEntity
acctPeriodFreqstring624in_acct_period_freqRULESDBOENTITY_ACCT_BASISACCT_PERIOD_FREQ
../acctPeriodFreq
processCenterstring4896in_process_centerRULESDBOENTITY_STAR_PROCESSINGPROCESS_CENTER
../processCenter
ccProcessCtrstring11407in_cc_process_ctrRULESDBOENTITY_STAR_PROCESSINGCC_PROCESS_CTR
../ccProcessCtr
ccEntitystring10462in_cc_entityRULESDBOENTITY_STAR_PROCESSINGCC_ENTITY
../ccEntity
portCompTypestring3953in_port_comp_typeRULESDBOENTITYPORT_COMP_TYPE
../portCompType
  • No labels