Entity Properties Model Data Map Table
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
Element | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|---|---|---|---|---|---|---|---|
accountType | string | 4056 | in_ex_user_char3 | RULESDBO | ENTITY_EXTENSION | USER_CHAR3 | VARCHAR2(255) | ../accountType |
parentCompositeId | string | 4054 | in_ex_user_char1 | RULESDBO | ENTITY_EXTENSION | USER_CHAR1 | VARCHAR2(20) | ../parentCompositeId |
parentCompositeName | string |
|
| RULESDBO | ENTITY | ENTITY_NAME | CHAR (30) | ../parentCompositeName |
counterpartyId | string | 4065 | in_ex_user_char12 | RULESDBO | ENTITY_EXTENSION | USER_CHAR12 | VARCHAR2 (20) | ../counterpartyId |
closedDate | dateTime | 933 | in_closed_date | ESTAR | ESTAR_ACCOUNTING_PERIODS | CLOSED_DT | DATE | ../closedDate |
closedFlag | string | 2072 | in_closed_flag | RULESDBO | ENTITY | CLOSED_FLAG | CHAR(20) | ../closedFlag |
fxSource | string | 1344 | in_fx_source | RULESDBO | ENTITY | FX_SOURCE | CHAR(15) | ../fxSource |
terminationDate | date | 1161 | in_termination_date | RULESDBO | ENTITY | TERMINATION_DATE | DATE | ../terminationDate |
inceptionDate | date | 1138 | in_inception_date | RULESDBO | ENTITY | INCEPTION_DATE | DATE | ../inceptionDate |
fiscalEndDate | date | 1162 | in_fiscal_end_date | RULESDBO | ENTITY | FISCAL_END_DATE | DATE | ../fiscalEndDate |
entityBaseCurrency | CurrencyCode | 86 | in_base_currency | RULESDBO | ENTITY | BASE_CURRENCY | CHAR(3) | ../entityBaseCurrency |
entityCostMethod | string | 22 | in_cost_method | RULESDBO | ENTITY | COST_METHOD | VARCHAR2 (10) | ../entityCostMethod |
Extended Entity Properties: | ||||||||
To add the elements below, please set IncludeExtendedDetails=ALL in the RTR | ||||||||
entityAccountingBasis | string | 21 |
| RULESDBO | ENTITY | ACCOUNTING_BASIS | VARCHAR2 (10) | ../entityAccountingBasis |
entityPriceMethod | string | 1872 | in_price_method | RULESDBO | ENTITY | PRICE_METHOD | CHAR | ../entityPriceMethod |
entitySubType | string | 78 | in_entity_sub_type | RULESDBO | ENTITY | ENTITY_SUB_TYPE | VARCHAR2(20) | ../entitySubType |
entitySectorType | string | 3948 | in_sector_type | RULESDBO | ENTITY_STAR_PROCESSING | SECTOR_TYPE | CHAR | ../entitySectorType |
entityMasterName | string | 1164 |
| RULESDBO | ENTITY | ENTITY_NAME | CHAR (30) | ../entityMasterName |
entityMasterId | string | 1163 |
| RULESDBO | ENTITY | ENTITY_ID | CHAR (8) | ../entityMasterId |
entitySectorName | string | 1164 |
| RULESDBO | ENTITY | ENTITY_NAME | CHAR (30) | ../entitySectorName |
entitySectorId | string | 1163 |
| RULESDBO | ENTITY | ENTITY_ID | CHAR (8) | ../entitySectorId |
entitySectorCount | integer |
|
| Count of Underlying Sectors for Master Entity |
| ../entitySectorCount | ||
navRounding | string | 10064 | in_nav_rounding | RULESDBO | ENTITY | NAV_ROUNDING | VARCHAR2(2) | ../navRounding |
numberOfNavDigits | integer | 10065 | in_number_of_nav_digits | RULESDBO | ENTITY | NUMBER_OF_NAV_DIGITS | NUMBER(38,0) | ../numberOfNavDigits |
legalEntityIdentifier | string |
|
| RULESDBO | ENTITY | LEI | VARCHAR2 (20) | ../legalEntityIdentifier |
bankAccountNumber | string | 9507 | in_bank_account_number | RULESDBO | ENTITY | BANK_ACCOUNT_NUMBER | VARCHAR2 (12) | ../bankAccountNumber |
bankBranchCode | string | 2065 | in_bank_branch_code | RULESDBO | ENTITY | BANK_BRANCH_CODE | CHAR (20) | ../bankBranchCode |
countryOfTax | string | 1342 | in_country_of_tax | RULESDBO | ENTITY | COUNTRY_OF_TAX | CHAR | ../countryOfTax |
varRateSource | string | 3301 | in_var_rate_source | RULESDBO | ENTITY | VAR_RATE_SOURCE | CHAR | ../varRateSource |
eabCoaName | string | 1641 | in_coa_name | RULESDBO | ENTITY_ACCT_BASIS | COA_NAME | CHAR | ../eabCoaName |
eabPriceSource | string | 1282 | in_price_source | RULESDBO | ENTITY_ACCT_BASIS | PRICE_SOURCE | CHAR | ../eabPriceSource |
eabRegulatoryCategory | string | 12387 | in_regulatory_category | RULESDBO | ENTITY_ACCT_BASIS | REGULATORY_CATEGORY | CHAR | ../eabRegulatoryCategory |
taxExemptProcessingFlag | string | 4948 |
| RULESDBO | ENTITY_ACCT_BASIS | TAX_EXEMPT_FLAG | CHAR | ../taxExemptProcessingFlag |
entityBasisBaseCurrency | string | 86 | in_base_currency | RULESDBO | ENTITY_ACCT_BASIS | BASE_CURRENCY | CHAR | ../entityBasisBaseCurrency |
nonBusDayProcessing | string | 3907 | in_non_bus_day_processing | RULESDBO | ENTITY_STAR_PROCESSING | NON_BUS_DAY_PROCESSING | VARCHAR2 (10) | ../nonBusDayProcessing |
distributionMethod | string | 3904 | in_distribution_method | RULESDBO | ENTITY_STAR_PROCESSING | DISTRIBUTION_METHOD | CHAR | ../distributionMethod |
paydowmGlAccount | string | 4519 | in_pydn_gl_accnt | RULESDBO | ENTITY_STAR_PROCESSING | PYDN_GL_ACCNT | CHAR | ../paydowmGlAccount |
taxWthldAccntMethod | string | 3912 | in_tax_wthld_accnt_method | RULESDBO | ENTITY_STAR_PROCESSING | TAX_WTHLD_ACCNT_METHOD | CHAR | ../taxWthldAccntMethod |
starAcctField29 | string | 3928 | in_star_acct_field_29 | RULESDBO | ENTITY_STAR_PROCESSING | STAR_ACCT_FIELD_29 | CHAR | ../starAcctField29 |
entityUserDate1 | date | 1320 | in_user_date1 | RULESDBO | ENTITY | USER_DATE1 | DATE | ../entityUserDate1 |
entityUserDate4 | date | 1319 | in_user_date4 | RULESDBO | ENTITY | USER_DATE4 | DT | ../entityUserDate4 |
userField3 | string | 1858 | in_user_field3 | RULESDBO | ENTITY | USER_FIELD3 | VARCHAR2 (10) | ../userField3 |
userField13 | string | 1866 | in_user_field13 | RULESDBO | ENTITY | USER_FIELD13 | VARCHAR2 (10) | ../userField13 |
userField15 | string | 1867 | in_user_field15 | RULESDBO | ENTITY | USER_FIELD15 | VARCHAR2 (10) | ../userField15 |
userField16 | string | 1868 | in_user_field16 | RULESDBO | ENTITY | USER_FIELD16 | VARCHAR2 (10) | ../userField16 |
userField17 | string | 1642 | in_user_field17 | RULESDBO | ENTITY | USER_FIELD17 | VARCHAR2 (10) | ../userField17 |
userField18 | string | 1643 | in_user_field18 | RULESDBO | ENTITY | USER_FIELD18 | VARCHAR2 (10) | ../userField18 |
userField19 | string | 1644 | in_user_field19 | RULESDBO | ENTITY | USER_FIELD19 | VARCHAR2 (10) | ../userField19 |
userField20 | string | 1645 | in_user_field20 | RULESDBO | ENTITY | USER_FIELD20 | VARCHAR2 (10) | ../userField20 |
userField21 | string | 1646 | in_user_field21 | RULESDBO | ENTITY | USER_FIELD21 | VARCHAR2 (20) | ../userField21 |
userField22 | string | 1647 | in_user_field22 | RULESDBO | ENTITY | USER_FIELD22 | VARCHAR2 (20) | ../userField22 |
exUserChar1 | string | 4054 | in_ex_user_char1 | RULESDBO | ENTITY_EXTENSION | USER_CHAR1 | VARCHAR2 (20) | ../exUserChar1 |
exUserChar3 | string | 4056 | in_ex_user_char3 | RULESDBO | ENTITY_EXTENSION | USER_CHAR3 | VARCHAR2 (20) | ../exUserChar3 |
exUserChar9 | string | 4062 | in_ex_user_char9 | RULESDBO | ENTITY_EXTENSION | USER_CHAR9 | VARCHAR2 (20) | ../exUserChar9 |
exUserChar12 | string | 4065 | in_ex_user_char12 | RULESDBO | ENTITY_EXTENSION | USER_CHAR12 | VARCHAR2 (20) | ../exUserChar12 |
exUserChar30 | string | 4083 | in_ex_user_char30 | RULESDBO | ENTITY_EXTENSION | USER_CHAR30 | VARCHAR2 (20) | ../exUserChar30 |
exUserChar31 | string | 4084 | in_ex_user_char31 | RULESDBO | ENTITY_EXTENSION | USER_CHAR31 | VARCHAR2 (20) | ../exUserChar31 |
exUserChar32 | string | 4085 | in_ex_user_char32 | RULESDBO | ENTITY_EXTENSION | USER_CHAR32 | VARCHAR2 (20) | ../exUserChar32 |
exUserChar33 | string | 4086 | in_ex_user_char33 | RULESDBO | ENTITY_EXTENSION | USER_CHAR33 | VARCHAR2 (20) | ../exUserChar33 |
exUserChar45 | string | 4098 | in_ex_user_char45 | RULESDBO | ENTITY_EXTENSION | USER_CHAR45 | VARCHAR2 (20) | ../exUserChar45 |
exUserInd47 | string | 4170 | in_ex_user_ind47 | RULESDBO | ENTITY_EXTENSION | USER_IND47 | VARCHAR2 (3) | ../exUserInd47 |
exUserInd48 | string | 4171 | in_ex_user_ind48 | RULESDBO | ENTITY_EXTENSION | USER_IND48 | VARCHAR2 (3) | ../exUserInd48 |
exUserInd49 | string | 4172 | in_ex_user_ind49 | RULESDBO | ENTITY_EXTENSION | USER_IND49 | VARCHAR2 (3) | ../exUserInd49 |
exUserDate10 | date | 4203 | in_ex_user_date10 | RULESDBO | ENTITY_EXTENSION | USER_DATE10 | DATE | ../exUserDate10 |
mffEntity | string | 16618 | in_mff_entity | RULESDBO | ENTITY_STAR_PROCESSING | MFF_ENTITY | VARCHAR2(20) | ../mffEntity |
acctPeriodFreq | string | 624 | in_acct_period_freq | RULESDBO | ENTITY_ACCT_BASIS | ACCT_PERIOD_FREQ |
| ../acctPeriodFreq |
processCenter | string | 4896 | in_process_center | RULESDBO | ENTITY_STAR_PROCESSING | PROCESS_CENTER |
| ../processCenter |
ccProcessCtr | string | 11407 | in_cc_process_ctr | RULESDBO | ENTITY_STAR_PROCESSING | CC_PROCESS_CTR |
| ../ccProcessCtr |
ccEntity | string | 10462 | in_cc_entity | RULESDBO | ENTITY_STAR_PROCESSING | CC_ENTITY |
| ../ccEntity |
portCompType | string | 3953 | in_port_comp_type | RULESDBO | ENTITY | PORT_COMP_TYPE |
| ../portCompType |