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 | 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 |
...