Cash Account Relationship Data Map Table
- Vitali Kostyrenko
- Kinga Huszno
Element | Required Inbound Acct Validation | Required  Inbound Data | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | Required | Required | Â | not stored in DB | EagleML/entityTransaction/cashAccountRelationship/objectType | ||||||
objectId | Â | Â | Â | not stored in DB | EagleML/entityTransaction/cashAccountRelationship/objectId | ||||||
objectDescription | Â | Â | Â | not stored in DB | EagleML/entityTransaction/cashAccountRelationship/objectDescription | ||||||
customElements | not recommended | CustomElements |  |  |  | reserved for customizations | EagleML/entityTransaction/cashAccountRelationship/customElements | ||||
updateSource | Â | Â | string | 944 | in_update_source | S | RULESDBO | CASH_ACCOUNT_RELATIONSHIP | UPDATE_SOURCE | VARCHAR2(255) | EagleML/entityTransaction/cashAccountRelationship/updateSource |
EagleML/entityTransaction/cashAccountRelationship/ | |||||||||||
custodyBankAccountName | Required | Required | string | 1146 | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/custodyBankAccountName |
custodyBankCode | Required | Required | string | 1240 | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/custodyBankCode |
custodyBankAccountNumber | Required | Required | string | 1660 | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/custodyBankAccountNumber |
entityBankAlias | Â | Â | Â | 16 | in_entity_bank_alias | S | RULESDBO | CASH_ACCOUNT_RELATIONSHIP | ENTITY_BANK_ALIAS | VARCHAR2(25) | EagleML/entityTransaction/cashAccountRelationship/entityBankAlias |
cashAccountBankCode | Required | Required | string | 1176 | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountBankCode |
cashAccountBankName | Required | Required | string | 1177 | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountBankName |
cashAccountName | Required | Required | string | 11696 | in_cash_acct_name | S | RULESDBO | CASH_ACCOUNT | CASH_ACCT_NAME | VARCHAR2(50) | EagleML/entityTransaction/cashAccountRelationship/cashAccountName |
cashAccountNumber | Required | Required | string | 11697 | in_cash_acct | S | RULESDBO | CASH_ACCOUNT | CASH_ACCT | VARCHAR2(20) | EagleML/entityTransaction/cashAccountRelationship/cashAccountNumber |
cashAccountAlias | Â | Â | integer | 11698 | in_cash_acct_alias | I | RULESDBO | CASH_ACCOUNT | CASH_ACCT_ALIAS | NUMBER(38) | EagleML/entityTransaction/cashAccountRelationship/cashAccountAlias |
longShortIndicator | Required | Required | string | 15 | in_lng_sht_c | S | RULESDBO | CASH_ACCOUNT_RELATIONSHIP | LNG_SHT_C | VARCHAR2(1) | EagleML/entityTransaction/cashAccountRelationship/longShortIndicator |
securityType | Â | Â | string | 82 | in_security_type | S | RULESDBO | CASH_ACCOUNT_RELATIONSHIP | SECURITY_TYPE | VARCHAR2(15) | EagleML/entityTransaction/cashAccountRelationship/securityType |
eventType | Â | Â | string | 53 | in_cash_event_type | S | RULESDBO | CASH_ACCOUNT_RELATIONSHIP | CASH_EVT_TYP | VARCHAR2(10) | EagleML/entityTransaction/cashAccountRelationship/eventType |
cashAccountType | Â | Â | string | 62 | in_cash_acct_type | S | RULESDBO | CASH_ACCOUNT_RELATIONSHIP | CASH_ACCT_TYPE | VARCHAR2(30) | EagleML/entityTransaction/cashAccountRelationship/cashAccountType |
cashBalance | Required | Required | YesNoOptionEnum | 12868 | in_cash_balance_indicator | S | RULESDBO | CASH_ACCOUNT_RELATIONSHIP | CASH_BALANCE | VARCHAR2(1) | EagleML/entityTransaction/cashAccountRelationship/cashBalance |
settlementCurrency | Required | Required | string | 63 | in_settle_currency | S | RULESDBO | CASH_ACCOUNT_RELATIONSHIP | SETTLE_CURRENCY | VARCHAR2(3) | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/settlementCurrency |
settleToleranceTrade | Â | Â | decimal | 528 | in_settle_tolerance_trade | F | RULESDBO | CASH_ACCOUNT | SETTLE_TOLERANCE_TRADE | NUMBER(38,12) | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/settleToleranceTrade |
settleToleranceIncome | Â | Â | decimal | 527 | in_settle_tolerance_income | F | RULESDBO | CASH_ACCOUNT | SETTLE_TOLERANCE_INCOME | NUMBER(38,12) | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/settleToleranceIncome |
settlePercentToleranceTrd | Â | Â | decimal | 770 | in_settle_percent_tolerance_trd | F | RULESDBO | CASH_ACCOUNT | SETL_PRCNT_TOLERANCE_TRD | NUMBER(38,12) | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/settlePercentToleranceTrd |
settlePercentToleranceInc | Â | Â | decimal | 769 | in_settle_percent_tolerance_inc | F | RULESDBO | CASH_ACCOUNT | SETL_PRCNT_TOLERANCE_INC | NUMBER(38,12) | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/settlePercentToleranceInc |
settleDateTolerance | Â | Â | decimal | 9699 | in_settle_date_tolerance | I | RULESDBO | CASH_ACCOUNT | SETTLE_DATE_TOLERANCE | NUMBER(38) | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/settleDateTolerance |
Next elements are used for resolution of Cash Accounts Default Entity | |||||||||||
entityId | Â | Â | string | 5 | in_defualt_entity_id | S | RULESDBO | CASH_ACCOUNT | DEFAULT_ENTITY_ID | CHAR(8) | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/entityId |
entityName | Â | Â | string | 1149 | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/entityName |
entityType | Â | Â | string | Â | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/entityType |
entityResolutionOption | Â | Â | string | Â | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/entityResolutionOption |
entityBattingOrder | Â | Â | string | Â | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/entityBattingOrder |
xrefAccountId | Â | Â | string | Â | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/entityXrefs/entityXref/xrefAccountId |
xrefAccountIdType | Â | Â | string | Â | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/entityXrefs/entityXref/xrefAccountIdType |
xrefClassCode | Â | Â | string | Â | Â | Â | Â | Â | Â | Â | EagleML/entityTransaction/cashAccountRelationship/cashAccountDetails/entityXrefs/entityXref/xrefClassCode |
Â