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