| Info | ||
|---|---|---|
| ||
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.
|
| Element | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|
| accountType | string | 4056 | RULESDBO | ENTITY_EXTENSION | USER_CHAR3 | VARCHAR2(255) | ../accountType | |
| parentCompositeId | string | 4054 | RULESDBO | ENTITY_EXTENSION | USER_CHAR1 | VARCHAR2(20) | ../parentCompositeId | |
| counterpartyId | string | 4065 | 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 | RULESDBO | ENTITY | COST_METHOD | VARCHAR2 (10) | ../entityCostMethod | |
| 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 | RULESDBO | ENTITY | PRICE_METHOD | CHAR | ../entityPriceMethod | |
| entitySubType | string | 78 | RULESDBO | ENTITY | ENTITY_SUB_TYPE | VARCHAR2(20) | ../entitySubType | |
| entitySectorType | string | 3948 | 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 | RULESDBO | ENTITY | NAV_ROUNDING | VARCHAR2(2) | ../navRounding | |
| numberOfNavDigits | integer | 10065 | RULESDBO | ENTITY | NUMBER_OF_NAV_DIGITS | NUMBER(38,0) | ../numberOfNavDigits | |
| legalEntityIdentifier | string | RULESDBO | ENTITY | LEI | VARCHAR2 (20) | ../legalEntityIdentifier | ||
| bankAccountNumber | string | 9507 | RULESDBO | ENTITY | BANK_ACCOUNT_NUMBER | VARCHAR2 (12) | ../bankAccountNumber | |
| bankBranchCode | string | 2065 | RULESDBO | ENTITY | BANK_BRANCH_CODE | CHAR (20) | ../bankBranchCode | |
| countryOfTax | string | 1342 | RULESDBO | ENTITY | COUNTRY_OF_TAX | CHAR | ../countryOfTax | |
| varRateSource | string | 3301 | RULESDBO | ENTITY | VAR_RATE_SOURCE | CHAR | ../varRateSource | |
| eabCoaName | string | 1641 | RULESDBO | ENTITY_ACCT_BASIS | COA_NAME | CHAR | ../eabCoaName | |
| eabPriceSource | string | 1282 | RULESDBO | ENTITY_ACCT_BASIS | PRICE_SOURCE | CHAR | ../eabPriceSource | |
| eabRegulatoryCategory | string | 12387 | RULESDBO | ENTITY_ACCT_BASIS | REGULATORY_CATEGORY | CHAR | ../eabRegulatoryCategory | |
| taxExemptProcessingFlag | string | 4948 | RULESDBO | ENTITY_ACCT_BASIS | TAX_EXEMPT_FLAG | CHAR | ../taxExemptProcessingFlag | |
| entityBasisBaseCurrency | string | RULESDBO | ENTITY_ACCT_BASIS | BASE_CURRENCY | CHAR | ../entityBasisBaseCurrency | ||
| nonBusDayProcessing | string | 3907 | RULESDBO | ENTITY_STAR_PROCESSING | NON_BUS_DAY_PROCESSING | VARCHAR2 (10) | ../nonBusDayProcessing | |
| distributionMethod | string | 3904 | RULESDBO | ENTITY_STAR_PROCESSING | DISTRIBUTION_METHOD | CHAR | ../distributionMethod | |
| paydowmGlAccount | string | 4519 | RULESDBO | ENTITY_STAR_PROCESSING | PYDN_GL_ACCNT | CHAR | ../paydowmGlAccount | |
| taxWthldAccntMethod | string | 3912 | RULESDBO | ENTITY_STAR_PROCESSING | TAX_WTHLD_ACCNT_METHOD | CHAR | ../taxWthldAccntMethod | |
| starAcctField29 | string | 3928 | RULESDBO | ENTITY_STAR_PROCESSING | STAR_ACCT_FIELD_29 | CHAR | ../starAcctField29 | |
| entityUserDate1 | date | 1320 | RULESDBO | ENTITY | USER_DATE1 | DATE | ../entityUserDate1 | |
| entityUserDate4 | date | 1319 | RULESDBO | ENTITY | USER_DATE4 | DT | ../entityUserDate4 | |
| userField3 | string | 1858 | RULESDBO | ENTITY | USER_FIELD3 | VARCHAR2 (10) | ../userField3 | |
| userField13 | string | 1866 | RULESDBO | ENTITY | USER_FIELD13 | VARCHAR2 (10) | ../userField13 | |
| userField15 | string | 1867 | RULESDBO | ENTITY | USER_FIELD15 | VARCHAR2 (10) | ../userField15 | |
| userField16 | string | 1868 | RULESDBO | ENTITY | USER_FIELD16 | VARCHAR2 (10) | ../userField16 | |
| userField17 | string | 1642 | RULESDBO | ENTITY | USER_FIELD17 | VARCHAR2 (10) | ../userField17 | |
| userField18 | string | 1643 | RULESDBO | ENTITY | USER_FIELD18 | VARCHAR2 (10) | ../userField18 | |
| userField19 | string | 1644 | RULESDBO | ENTITY | USER_FIELD19 | VARCHAR2 (10) | ../userField19 | |
| userField20 | string | 1645 | RULESDBO | ENTITY | USER_FIELD20 | VARCHAR2 (10) | ../userField20 | |
| userField21 | string | 1646 | RULESDBO | ENTITY | USER_FIELD21 | VARCHAR2 (20) | ../userField21 | |
| userField22 | string | 1647 | RULESDBO | ENTITY | USER_FIELD22 | VARCHAR2 (20) | ../userField22 | |
| exUserChar1 | string | 4054 | RULESDBO | ENTITY_EXTENSION | USER_CHAR1 | VARCHAR2 (20) | ../exUserChar1 | |
| exUserChar3 | string | 4056 | RULESDBO | ENTITY_EXTENSION | USER_CHAR3 | VARCHAR2 (20) | ../exUserChar3 | |
| exUserChar9 | string | 4062 | RULESDBO | ENTITY_EXTENSION | USER_CHAR9 | VARCHAR2 (20) | ../exUserChar9 | |
| exUserChar12 | string | 4065 | RULESDBO | ENTITY_EXTENSION | USER_CHAR12 | VARCHAR2 (20) | ../exUserChar12 | |
| exUserChar30 | string | 4083 | RULESDBO | ENTITY_EXTENSION | USER_CHAR30 | VARCHAR2 (20) | ../exUserChar30 | |
| exUserChar31 | string | 4084 | RULESDBO | ENTITY_EXTENSION | USER_CHAR31 | VARCHAR2 (20) | ../exUserChar31 | |
| exUserChar32 | string | 4085 | RULESDBO | ENTITY_EXTENSION | USER_CHAR32 | VARCHAR2 (20) | ../exUserChar32 | |
| exUserChar33 | string | 4086 | RULESDBO | ENTITY_EXTENSION | USER_CHAR33 | VARCHAR2 (20) | ../exUserChar33 | |
| exUserChar45 | string | 4098 | RULESDBO | ENTITY_EXTENSION | USER_CHAR45 | VARCHAR2 (20) | ../exUserChar45 | |
| exUserInd47 | string | 4170 | RULESDBO | ENTITY_EXTENSION | USER_IND47 | VARCHAR2 (3) | ../exUserInd47 | |
| exUserInd48 | string | 4171 | RULESDBO | ENTITY_EXTENSION | USER_IND48 | VARCHAR2 (3) | ../exUserInd48 | |
| exUserInd49 | string | 4172 | RULESDBO | ENTITY_EXTENSION | USER_IND49 | VARCHAR2 (3) | ../exUserInd49 | |
| exUserDate10 | date | 4203 | RULESDBO | ENTITY_EXTENSION | USER_DATE10 | DATE | ../exUserDate10 | |
| mffEntity | string | 16618 | RULESDBO | ENTITY_STAR_PROCESSING | MFF_ENTITY | VARCHAR2(20) | ../mffEntity | |
...