Entity Bank Relationship Data Map Table
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | Data Type | Xpath |
---|---|---|---|---|---|---|---|---|---|---|
objectType | Required | Required | objectType | not stored in DB | EagleML/entityTransaction/entityBankRelationship/objectType | |||||
objectId | objectId | not stored in DB | EagleML/entityTransaction/entityBankRelationship/objectId | |||||||
objectDescription | objectDescription | not stored in DB | EagleML/entityTransaction/entityBankRelationship/objectDescription | |||||||
updateTimestamp | dateTime | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | UPDATE_DATE | DATE | EagleML/entityTransaction/entityBankRelationship/updateTimestamp | ||||
customElements | not recommended | CustomElements | reserved for customizations | EagleML/entityTransaction/entityBankRelationship/customElements | ||||||
updateSource | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | UPDATE_SOURCE | CHAR(30) | EagleML/entityTransaction/entityBankRelationship/updateSource | ||||
entityId | Required | Required | string | 1163 | RULESDBO | ENTITY | ENTITY_ID | CHAR(8) | EagleML/entityTransaction/entityBankRelationship/entityId | |
entityName | string | 1164 | RULESDBO | ENTITY | ENTITY_NAME | CHAR(30) | EagleML/entityTransaction/entityBankRelationship/entityName | |||
bankAccountStatus | Required | Required | string | 1662 | in_status | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | STATUS | VARCHAR2(10) | EagleML/entityTransaction/entityBankRelationship/bankAccountStatus |
custodyBankAccountName | string | 1617 | in_custody_bank_acct_name | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCOUNT_NAME | VARCHAR2(50) | EagleML/entityTransaction/entityBankRelationship/custodyBankAccountName | ||
custodyBankAccountNumber | Required | Required | string | 1660 | in_custody_bank_acct_num | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(50) | EagleML/entityTransaction/entityBankRelationship/custodyBankAccountNumber |
custodyBankCode | Required | Required | string | 1176 | in_custody_bank_code | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/entityTransaction/entityBankRelationship/custodyBankCode |
custodyBankDesc | string | 1177 | Â in_custody_bank_desc | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC | CHAR(50) | EagleML/entityTransaction/entityBankRelationship/custodyBankDesc | ||
custodyBankSubAcct | Required | Required | string | 1661 | in_custody_bank_sub_acct | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_SUB_ACCT | VARCHAR2(30) | EagleML/entityTransaction/entityBankRelationship/custodyBankSubAcct |
custodyBankSubAccountType | string | not stored in DB | EagleML/entityTransaction/entityBankRelationship/custodyBankSubAccountType | |||||||
dtcBankId | string | 10671 | in_dtc_bank_id | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | DTC_BANK_ID | VARCHAR2(30) | EagleML/entityTransaction/entityBankRelationship/dtcBankId | ||
entityBankAlias | Required | string | 16 | in_entity_bank_alias | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | ENTITY_BANK_ALIAS | VARCHAR2(25) | EagleML/entityTransaction/entityBankRelationship/entityBankAlias | |
interestedPartyId | string | 10672 | in_interested_party_id | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | INTERESTED_PARTY_ID | VARCHAR2(30) | EagleML/entityTransaction/entityBankRelationship/interestedPartyId | ||
interestedPartyAcct | string | 10673 | in_interested_party_acct | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | INTERESTED_PARTY_ACCT | VARCHAR2(30) | EagleML/entityTransaction/entityBankRelationship/interestedPartyAcct | ||
interestedPartyId2 | string | 11791 | in_interested_party_id2 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | INTERESTED_PARTY_ID2 | VARCHAR2(30) | EagleML/entityTransaction/entityBankRelationship/interestedPartyId2 | ||
interestedPartyAcct2 | string | 11792 | in_interested_party_acct2 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | INTERESTED_PARTY_ACCT2 | VARCHAR2(30) | EagleML/entityTransaction/entityBankRelationship/interestedPartyAcct2 | ||
originalCustodyBankCode | string | not stored in DB | EagleML/entityTransaction/entityBankRelationship/originalCustodyBankCode | |||||||
originalCustodyBankStatus | string | not stored in DB | EagleML/entityTransaction/entityBankRelationship/originalCustodyBankStatus | |||||||
primaryContact | string | 9962 | in_primary_contact | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | PRIMARY_CONTACT | VARCHAR2(50) | EagleML/entityTransaction/entityBankRelationship/primaryContact | ||
phone | string | 9963 | in_phone | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | PHONE | VARCHAR2(20) | EagleML/entityTransaction/entityBankRelationship/phone | ||
fax | string | 9965 | in_fax | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | FAX | VARCHAR2(20) | EagleML/entityTransaction/entityBankRelationship/fax | ||
settlementMethod | string | 680 | in_settlement_method | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | SETTLEMENT_METHOD | VARCHAR2(30) | EagleML/entityTransaction/entityBankRelationship/settlementMethod | ||
userDate1 | date | 1663 | in_user_date1 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_DATE1 | DATE | EagleML/entityTransaction/entityBankRelationship/userDate1 | ||
userDate2 | date | 1664 | in_user_date2 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_DATE2 | DATE | EagleML/entityTransaction/entityBankRelationship/userDate2 | ||
userField1 | string | 1665 | in_user_field1 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_FIELD1 | VARCHAR2(10) | EagleML/entityTransaction/entityBankRelationship/userField1 | ||
userField2 | string | 1666 | in_user_field2 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_FIELD2 | VARCHAR2(10) | EagleML/entityTransaction/entityBankRelationship/userField2 | ||
userFloat1 | decimal | 1667 | in_user_float1 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_FLOAT1 | NUMBER(28,12) | EagleML/entityTransaction/entityBankRelationship/userFloat1 | ||
userFloat2 | decimal | 1668 | in_user_float2 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_FLOAT2 | NUMBER(28,12) | EagleML/entityTransaction/entityBankRelationship/userFloat2 | ||
restricted | YesNoOptionEnum | 12861 | in_restricted | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | RESTRICTED | VARCHAR2(1) | EagleML/entityTransaction/entityBankRelationship/restricted |