...
| 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/custodyRestrictionActivity/objectType | ||||||||||
| objectId | Optional | objectId | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionActivity/objectId | ||||||||||
| objectDescription | Optional | objectDescription | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionActivity/objectDescription | ||||||||||
| updateTimestamp | Optional | dateTime | HOLDINGDBO | CUSTODY_ACTIVITY | UPDATE_DATE | DATE(7) | EagleML/warehouseTransaction/custodyRestrictionActivity/updateTimestamp | |||||||
| customElements | Not recommended | CustomElements | reserved for customizations | EagleML/warehouseTransaction/custodyRestrictionActivity/customElements | ||||||||||
| sourceName | Optional | string | 1102 | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/warehouseTransaction/custodyRestrictionActivity/sourceName | ||||||
| updateSource | Optional | string | HOLDINGDBO | CUSTODY_ACTIVITY | UPDATE_SOURCE | VARCHAR(50) | EagleML/warehouseTransaction/custodyRestrictionActivity/updateSource | |||||||
| batchCollectErrorsFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionActivity/batchCollectErrorsFlag | ||||||||||
| singleRowCommitFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionActivity/singleRowCommitFlag | ||||||||||
| Entity Common Id Model | EagleML/warehouseTransaction/custodyRestrictionActivity/ | |||||||||||||
| Entity Properties Model (extract only) | EagleML/warehouseTransaction/custodyRestrictionActivity/ | |||||||||||||
| Asset Identifiers Model | EagleML/warehouseTransaction/custodyRestrictionActivity/ | |||||||||||||
| Extended Asset Properties Model (extract only) | EagleML/warehouseTransaction/custodyRestrictionActivity/ | |||||||||||||
| maturityDate | Optional | date | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionActivity/maturityDate | ||||||||||
| pledgeDetail | Pledge Detail - Complex type (see extra table below) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/ | ||||||||||||
| effectiveDate | Required | date | 1109 | HOLDINGDBO | CUSTODY_ACTIVITY | EFFECTIVE_DATE | DATE(7) | EagleML/warehouseTransaction/custodyRestrictionActivity/effectiveDate | ||||||
| action | Required | string | 153 | HOLDINGDBO | CUSTODY_ACTIVITY | ACTION | VARCHAR(10) | EagleML/warehouseTransaction/custodyRestrictionActivity/action | ||||||
| units | Required | decimal | 903 | HOLDINGDBO | CUSTODY_ACTIVITY | UNITS | NUMBER(28,12) | EagleML/warehouseTransaction/custodyRestrictionActivity/units | ||||||
| userNotes | Optional | string | HOLDINGDBO | CUSTODY_ACTIVITY | USER_NOTES | VARCHAR(30) | EagleML/warehouseTransaction/custodyRestrictionActivity/userNotes | |||||||
| balanceInstance | Required | integer | HOLDINGDBO | CUSTODY_ACTIVITY | BAL_INSTANCE | NUMBER | EagleML/warehouseTransaction/custodyRestrictionActivity/balanceInstance | |||||||
| instance | Required | integer | HOLDINGDBO | CUSTODY_ACTIVITY | INSTANCE | NUMBER | EagleML/warehouseTransaction/custodyRestrictionActivity/instance | |||||||
The pledge asset group is related via security alias elements HOLDINGDBO.CUSTODY_BALANCE.PL_SECURITY_ALIAS | ||||||||||||||
| Element | Optional/Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | XPath | ||||||
| pledgeId | Optional | normalizedString | 14 | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID | CHAR(100) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeId | ||||||
| pledgeName | Optional | normalizedString | 961 | SECURITYDBO | SECURITY_MASTER | ISSUE_NAME | VARCHAR2(255) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeName | ||||||
| pledgeType | Optional | normalizedString | 82 | SECURITYDBO | SECURITY_MASTER | SECURITY_TYPE | CHAR(15) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeType | ||||||
| pledgeAmount | Optional | decimal | 1485 | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_FLOAT1 | NUMBER | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeAmount | ||||||
| marginTolerance | Optional | decimal | 1487 | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_FLOAT3 | NUMBER | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/marginTolerance | ||||||
| pledgeDate | Optional | date | 1495 | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_DATE1 | DATE(7) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeDate | ||||||
| releaseDate | Optional | date | 1496 | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_DATE2 | DATE(7) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/releaseDate | ||||||
| counterParty | Optional | normalizedString | 1413 | not stored in DB | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/counterParty | |||||||||
| notes | Optional | string | 962 | SECURITYDBO | SECURITY_MASTER | ISSUE_DESC | CHAR(15) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/notes | ||||||
| pledgeSecurityAlias | Optional | integer | 14 | SECURITYDBO | SECURITY_MASTER | SECURITY_ALIAS | NUMBER | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeSecurityAlias | ||||||
| accountId | Optional | AccountId | RULESDBO | CUST_CHART | CUST_ACCOUNT | CHAR(55) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/accountId | |||||||
| accountName | Optional | accountName | RULESDBO | CUST_CHART | CUST_ACCOUNT_DESC | VARCHAR2(100) | EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/accountName | |||||||
...