| Element | Optional/Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | XPath | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectType | Optional | objectType | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/objectType | ||||||||||
| objectId | Optional | objectId | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/objectId | ||||||||||
| objectDescription | Optional | objectDescription | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/objectDescription | ||||||||||
| updateTimestamp | Optional | dateTime | HOLDINGDBO | CUSTODY_BALANCE | UPDATE_DATE | DATE(7) | EagleML/warehouseTransactioncustodyRestrictionBalance/updateTimestamp | |||||||
| customElements | Not recommended | CustomElements | reserved for customizations | EagleML/warehouseTransaction/custodyRestrictionBalance/customElements | ||||||||||
| sourceName | Optional | string | 1102 | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/warehouseTransaction/custodyRestrictionBalance/sourceName | ||||||
| updateSource | Optional | string | HOLDINGDBO | CUSTODY_BALANCE | UPDATE_SOURCE | VARCHAR2(50) | EagleML/warehouseTransaction/custodyRestrictionBalance/updateSource | |||||||
| batchCollectErrorsFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/batchCollectErrorsFlag | ||||||||||
| singleRowCommitFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/singleRowCommitFlag | ||||||||||
| Entity Common Id Model | EagleML/warehouseTransaction/custodyRestrictionBalance/ | |||||||||||||
| Entity Properties Model (extract only) | EagleML/warehouseTransaction/custodyRestrictionBalance/ | |||||||||||||
| Asset Identifiers Model | EagleML/warehouseTransaction/custodyRestrictionBalance/ | |||||||||||||
| Extended Asset Properties Model (extract only) | EagleML/warehouseTransaction/custodyRestrictionBalance/ | |||||||||||||
| maturityDate | Optional | date | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/maturityDate | ||||||||||
| pledgeDetail | Required | PledgeDetail - Complex type (see extra table below) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/ | |||||||||||
| accountingBasis | Required | normalizedString | HOLDINGDBO | CUSTODY_BALANCE | ACCT_BASIS | VARCHAR2(5) | EagleML/warehouseTransaction/custodyRestrictionBalance/accountingBasis | |||||||
| longShortIndicator | Required | normalizedString | HOLDINGDBO | CUSTODY_BALANCE | LONG_SHORT_IND | CHAR(2) | EagleML/warehouseTransaction/custodyRestrictionBalance/longShortIndicator | |||||||
| quantity | Required | decimal | HOLDINGDBO | CUSTODY_BALANCE | UNITS | NUMBER(28,12) | EagleML/warehouseTransaction/custodyRestrictionBalance/quantity | |||||||
| custodyBank | Optional | EntityBankRelationshipModel - Complex type (see extra table below) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/ | |||||||||||
| batchEventId | Optional | string | HOLDINGDBO | CUSTODY_BALANCE | BATCH_EVENT_ID | VARCHAR2(55) | EagleML/warehouseTransaction/custodyRestrictionBalance/batchEventId | |||||||
| instance | Required | integer | HOLDINGDBO | CUSTODY_BALANCE | INSTANCE | NUMBER | EagleML/warehouseTransaction/custodyRestrictionBalance/instance | |||||||
Pledge Detail Data MapThe pledge asset group is related via security alias elements HOLDINGDBO.CUSTODY_BALANCE.PL_SECURITY_ALIAS | ||||||||||||||
| pledgeId | Optional | normalizedString | 14 | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID | CHAR(100) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeId | ||||||
| pledgeName | Optional | normalizedString | 961 | SECURITYDBO | SECURITY_MASTER | ISSUE_NAME | VARCHAR2(255) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeName | ||||||
| pledgeType | Optional | normalizedString | 82 | SECURITYDBO | SECURITY_MASTER | SECURITY_TYPE | CHAR(15) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeType | ||||||
| pledgeAmount | Optional | decimal | 1485 | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_FLOAT1 | NUMBER(28,12) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeAmount | ||||||
| marginTolerance | Optional | decimal | 1487 | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_FLOAT3 | NUMBER(28,12) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/marginTolerance | ||||||
| pledgeDate | Optional | date | 1495 | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_DATE1 | DATE(7) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeDate | ||||||
| releaseDate | Optional | date | 1496 | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_DATE2 | DATE(7) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/releaseDate | ||||||
| counterParty | Optional | normalizedString | 1413 | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/counterParty | |||||||||
| notes | Optional | string | 962 | SECURITYDBO | SECURITY_MASTER | ISSUE_DESC | CHAR(15) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/notes | ||||||
| pledgeSecurityAlias | Optional | integer | 14 | SECURITYDBO | SECURITY_MASTER | SECURITY_ALIAS | CHAR(100) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeSecurityAlias | ||||||
| accountId | Optional | AccountId | RULESDBO | CUST_CHART | CUST_ACCOUNT | CHAR(55) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/accountId | |||||||
| accountName | Optional | accountName | RULESDBO | CUST_CHART | CUST_ACCOUNT_DESC | VARCHAR2(100) | EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/accountName | |||||||
The custody bank group is related via HOLDINGDBO.CUSTODY_BALANCE.ENTITY_CUSTODY_ALIAS and CUST_BANK_ALIAS fields | ||||||||||||||
| bankAccountStatus | Required | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | STATUS | VARCHAR2(10) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/bankAccountStatus | |||||||
| custodyBankAccountName | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCOUNT_NAME | VARCHAR2(50) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankAccountName | |||||||
| custodyBankAccountNumber | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(30) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankAccountNumber | |||||||
| custodyBankCode | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankCode | |||||||
| custodyBankDesc | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC | CHAR(50) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankDesc | |||||||
| custodyBankSubAcct | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_SUB_ACCT | VARCHAR2(30) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankSubAcct | |||||||
| custodyBankSubAccountType | Required | string | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankSubAccountType | ||||||||||
| dtcBankId | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | DTC_BANK_ID | VARCHAR2(30) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/dtcBankId | |||||||
| entityBankAlias | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | ENTITY_BANK_ALIAS | VARCHAR2(25) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/entityBankAlias | |||||||
| interestedPartyId | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | INTERESTED_PARTY_ID | VARCHAR2(30) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/interestedPartyId | |||||||
| interestedPartyAcct | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | INTERESTED_PARTY_ACCT | VARCHAR2(30) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/interestedPartyAcct | |||||||
| interestedPartyId2 | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | INTERESTED_PARTY_ID2 | VARCHAR2(30) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/interestedPartyId2 | |||||||
| interestedPartyAcct2 | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | INTERESTED_PARTY_ACCT2 | VARCHAR2(30) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/interestedPartyAcct2 | |||||||
| originalCustodyBankCode | Optinal | string | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/originalCustodyBankCode | ||||||||||
| originalCustodyBankStatus | Optinal | string | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/originalCustodyBankStatus | ||||||||||
| primaryContact | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | PRIMARY_CONTACT | VARCHAR2(50) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/primaryContact | |||||||
| phone | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | PHONE | VARCHAR2(20) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/phone | |||||||
| fax | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | FAX | VARCHAR2(20) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/fax | |||||||
| settlementMethod | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | SETTLEMENT_METHOD | VARCHAR2(30) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/settlementMethod | |||||||
| userDate1 | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_DATE1 | DATE | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userDate1 | |||||||
| userDate2 | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_DATE2 | DATE | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userDate2 | |||||||
| userField1 | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_FIELD1 | VARCHAR2(10) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userField1 | |||||||
| userField2 | Optinal | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_FIELD2 | VARCHAR2(10) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userField2 | |||||||
| userFloat1 | Optinal | decimal | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_FLOAT1 | NUMBER(28,12) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userFloat1 | |||||||
| userFloat2 | Optinal | decimal | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | USER_FLOAT2 | NUMBER(28,12) | EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userFloat2 | |||||||
...