Data Table for PACE Position Upload
- Natalie Gesin (Deactivated)
- Pamela Totas (Deactivated)
- Kinga Huszno
The PACE Position Upload message stream allows you to directly load third party positions to the HOLDINGS database in the Eagle data warehouse.
This stream supports all fields defined on the pan-pos_egl_gen_interface.htm panel, whether listed below or not.
The following table describes several required and optional data fields for PACE Position Upload message stream.
Tag Number/Name | Required/Optional | Data Type | Value/Description of Field | PACE Table | PACE Field |
|---|---|---|---|---|---|
55 – Event Type | Required | CHAR | Required – defaults on panel. Used by message stream for identification of the event. Must be UPLOAD_POSITION. | n/a | n/a |
1102 – Source Name | Conditional Required – if tag 1168 is null. | CHAR (15) | Used to resolve src_intfc_inst if tag 1168 is null. | n/a | n/a |
1168 – Src_Intfc_inst | Conditionally Required – tag 1102 is null | INTEGER | HOLDING.POSITION | Src_Intfc_Inst | |
7001 – Resolve in Panel Flag | Optional | CHAR | Used by message stream to determine if entity ID and security alias should be resolved in the panel or the procedure. Valid Values: 1 – Resolve All, 2 – Resolve Entity Only, 3 – Resolve None (resolve using the procedure). | n/a | n/a |
1081 – Entity Translation Type | Optional | CHAR | Used to indicate that the entity cross reference or entity bank relationship is used to generate the entity identifier. Options include:
| n/a | n/a |
7233 – Entity Xref ID | Conditionally Required – used when tag 1081 is set to XREFERENCE and tag 1163 is NULL. | CHAR | Used for entity ID resolution. The value corresponds to the tag 1233 value used for entity cross reference lookup. | n/a | n/a |
7234 – Entity Xref ID Type | Conditionally Required – used when tag 1081 is set to XREFERENCE and tag 1163 is NULL. | CHAR | Used for entity ID resolution. The value corresponds to the tag 1234 value used for entity cross reference lookup. | n/a | n/a |
1233/14 – Security ID | Conditionally Required – tag 7001 = 1 or 2 | CHAR (100) | Xreference lookup to resolve security alias. | n/a | n/a |
1234 – Security ID Type | Conditionally Required – tag 7001 = 1 or 2 | CHAR (30) | Xreference lookup to resolve security alias. | n/a | n/a |
1952 – XID 1 | Conditionally Required – tag 7001 = 3 | CHAR (100) | Used to resolve security_alias. | n/a | n/a |
1953 – XID Type 1 | Optional | CHAR (30) | Used to resolve security_alias. | n/a | n/a |
1955 – XID 2 | Conditionally Required – tag 7001 = 3 | CHAR (100) | Used to resolve security_alias. | n/a | n/a |
1956 – XID Type 2 | Optional | CHAR (30) | Used to resolve security_alias. | n/a | n/a |
1958 – XID 3 | Conditionally Required – tag 7001 = 3 | CHAR (100) | Used to resolve security_alias. | n/a | n/a |
1959 – XID Type 3 | Optional | CHAR (30) | Used to resolve security_alias. | n/a | n/a |
1961 – XID 4 | Conditionally Required – tag 7001 = 3 | CHAR (100) | Used to resolve security_alias. | n/a | n/a |
1962 – XID Type 4 | Optional | CHAR (30) | Used to resolve security_alias. | n/a | n/a |
1964 – XID 5 | Conditionally Required – tag 7001 = 3 | CHAR | Used to resolve security_alias. | n/a | n/a |
1965 – XID Type 5 | Optional | CHAR | Used to resolve security_alias. | n/a | n/a |
1967 – XID 6 | Conditionally Required – tag 7001 = 3 | CHAR | Used to resolve security_alias. | n/a | n/a |
1968 – XID Type 6 | Optional | CHAR | Used to resolve security_alias. | n/a | n/a |
1970 – XID 7 | Conditionally Required – tag 7001 = 3 | CHAR | Used to resolve security_alias. | n/a | n/a |
1971 – XID Type 7 | Optional | CHAR | Used to resolve security_alias. | n/a | n/a |
7052 – CUSIP Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7053 – Xref – ID Type for 7052 | Optional | CHAR | Xref ID type associated with tag 7052; defaults to CUSIP. | n/a | n/a |
7055 – ISIN Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7056 – Xref – ID Type for 7055 | Optional | CHAR | Xref ID type associated with tag 7055; defaults to ISIN. | n/a | n/a |
7058 – SEDOL Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7059 – Xref – ID Type for 7058 | Optional | CHAR | Xref ID type associated with tag 7058; defaults to SEDOL. | n/a | n/a |
7061 – REUTERS Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7062 – Xref – ID Type for 7061 | Optional | CHAR | Xref ID type associated with tag 7061; defaults to RIC. | n/a | n/a |
7064 – BLOOMBERG Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7065 – Xref – ID Type for 7064 | Optional | CHAR | Xref ID type associated with tag 7064; defaults to BBID. | n/a | n/a |
7067 – SICOVM Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7068 – Xref – ID Type for 7067 | Optional | CHAR | Xref ID type associated with tag 7067; defaults to SICOVM. | n/a | n/a |
7070 – VALOREN Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7071 – Xref – ID Type for 7070 | Optional | CHAR | Xref ID type associated with tag 7070; defaults to VALOREN. | n/a | n/a |
7073 – CEDEL Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7074 – Xref – ID Type for 7073 | Optional | CHAR | Xref ID type associated with tag 7073; defaults to CEDEL. | n/a | n/a |
7076 – INTERNAL Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7077 – Xref – ID Type for 7076 | Optional | CHAR | Xref ID type associated with tag 7076; defaults to INTERNAL. | n/a | n/a |
7079 – CINS Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7080 – Xref – ID Type for 7079 | Optional | CHAR | Xref ID type associated with tag 7079; defaults to CINS. | n/a | n/a |
1981 – Xreference Exchange | Optional | CHAR (8) | Used by the Xref ID lookup to further qualify the security resolution. | n/a | n/a |
38 – Maturity Date | Optional | DATE | Date on which the security matures. Used by the Xref ID lookup to qualify security resolution. | n/a | n/a |
11043 – Inactive flag | Optional | VARCHAR2 (255) | Valid values are Y = Yes or N = No. Used by the Xref ID lookup to qualify security resolution. | n/a | n/a |
85 – Asset Currency | Optional | CHAR (30) | 3-character currency code – Code Value. Used by the Xref ID lookup to qualify security resolution. | n/a | n/a |
1981 – Xref Exchange | Optional | CHAR (8) | Used by the Xref ID lookup to further qualify the security resolution. | n/a | n/a |
17 – Primary Exchange Code | Optional | CHAR (8) | Exchange on which the security is listed – Code Value. | n/a | n/a |
21– acct basis | VARCHAR2(5) | The accounting basis used for position. USTAX, USGAAP, IASGAAP | HOLDING.POSITION | Acct_basis | |
1105 – entity_type | Optional | CHAR (4) | The type of entity, portfolio, composite, aggregate. | HOLDING.POSITION | Entity_flag_type |
86 – base_currency | Optional | CHAR (3) | Account Currency. The base currency the account is valued in. | HOLDING.POSITION/POSITION_DETAIL | Base_Currency |
10 – security_alias | Optional | NUMBER | Asset identifier - internal number assigned to each asset. | HOLDING.POSITION_DETAIL | Security_Alias |
85 – local_currency | Optional | CHAR (30) | Asset Currency. The local currency the asset is denominated in. | HOLDING.POSITION_DETAIL | Local_Currency |
1163 – Entity ID | Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE. | CHAR (8) | The entity identification code. | POSITION | Entity_ID |
1164 – Entity Name | Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE. | CHAR (30) | The name of the portfolio/composite. | n/a | n/a |
221 – Effective Date | Required | DATE | Ending of period date for statements. | POSITION/POSITION_DETAIL/POSITION_COST_DETAIL | effective_date |
15 – Long/Short Indicator | Required | CHAR | Account position intent. Positions are established as a long position or a short positions. | POSITION_DETAIL | long_short_ind |
24 – Cost Basis Type | Optional | CHAR | This value contains a value defining the cost basis type provided on the transaction. | HOLDING.POSITION_COST_DETAIL | Cost_basis_type |
41 – Original Face | Optional | NUMBER(38,12) | Original face of the MBS position | HOLDING.POSITION_DETAIL | Orig_Face |
49 – Accrued Interest TRD Local | Optional | MONEYL | This value is a rollup of the open lot total purchased accrued interest (Tag 49). This value reflects the accrual provided at the time of the opening trade. | HOLDING.POSITION_DETAIL | Interest_purchased |
124 – Unit Avg Cost Local | Optional | DEC | Position average unit cost local | HOLDING.POSITION_COST_DETAIL | Local_gaap_unit_cost |
125 – Unit Avg Cost Base | Optional | DEC | Position average unit cost base | HOLDING.POSITION_COST_DETAIL | Gaap_unit_cost |
9278 – Cost Local (Current Cost) | Optional | MONEYL | The current position cost local | HOLDING.POSITION_COST_DETAIL | Local_gaap_cost_value |
9277 – Cost Base (Current Cost). | Optional | MONEYB | The current position base | HOLDING.POSITION_COST_DETAIL | Gaap_cost_value |
163 – Current Quantity | Optional | DEC | The current position quantity | HOLDING.POSITION_DETAIL | Share_par_value |
274 – Settled Quantity | Optional | DEC | Total position contractually settled quantity as of the requested effective date | HOLDING.POSITION_DETAIL | Settle_quantity |
465 – Accrued Income PTD Local | Optional | MONEYL | A rollup of the open lot total purchased accrued interest. This value reflects the accrual provided at the time of the opening trade. | HOLDING.POSITION_DETAIL | Interest_earned |
475 – Accrued Interest TRD Base | Optional | MONEYB | A rollup of the open lot total purchased accrued interest. This value reflects the accrual provided at the time of the opening trade. | HOLDING.POSITION_DETAIL | Security_income |
479 – Settle Amount Base | Optional | MONEYB | Base cost of the settled cash balance for a given cash position. This is populated only for cash balance records. | HOLDING.POSITION_DETAIL | Settlement_date_position_cost |
481 – Market Price | Optional | NUMBER (28,12) | Market price of the asset | HOLDING.POSITION_DETAIL | Price |
482 – Effective Date of Price | Optional | DATE | Effective date of the market price of the asset | HOLDING.POSITION_DETAIL | Price_date |
484 – FX Rates from FX Rates table | Optional | DEC | FX Rates between the asset and the entity base currency. | HOLDING.POSITION_DETAIL | Mkt_exchange_rate |
485 – Effective Date of FX Rates | Optional | DATE | Effective date of the FX Rates between the asset and entity base currency | HOLDING.POSITION_DETAIL | Exchange_rate_date |
575 – OID Income LTD Local | Optional | MONEYL | Calculated life-to-date OID income in local currency | HOLDING.POSITION_COST_DETAIL | Oid_ltd_income_local |
580 – Amortization Ltd Local | Optional | MONEYL | Total amortization life-to-date for the position. This is the calculated amortization in local currency. | HOLDING.POSITION_COST_DETAIL | Amort_ltd_local |
588 – Accrued Income PTD Base | Optional | MONEYB | Total period-to-date accrual base. This value reflects the calculated accrual from either the settlement date of all the open lots rolled up or the base cost of the total accrual from the last coupon date. | HOLDING.POSITION_DETAIL | Interest_earned_base |
590 – LTD OID Income Base | Optional | MONEYB | Calculated life-to-date OID income in base currency. | HOLDING.POSITION_COST_DETAIL | Oid_ltd_income |
595 – Amortization Ltd Base | Optional | MONEYB | Total amortization life-to-date for the position. This is the calculated amortization in base currency. | HOLDING.POSITION_COST_DETAIL | Amort_ltd_base |
4440 – LTD TIPS Income Local | Optional | MONEYL | STAR calculated life-to-date TIPS income in local currency | HOLDING.POSITION_DETAIL | Tip_ltd_income_local |
4445 – LTD TIPS Income Base | Optional | MONEYB | Life-to-date TIPS income in base currency | HOLDING.POSITION_DETAIL | Tip_ltd_income |
4483 – TIPS Current Index | Optional | DEC | Current index of the TIPS security | HOLDING.POSITION_DETAIL | Indx_weight |
10044 – Settle Amount Local | Optional | CHAR | Settled cash balance local for a given cash position. This is populated only for cash balance records. | HOLDING.POSITION_DETAIL | Settlement_date_position_local |
8952 – Sold Interest Local | Optional | MONEYL | Aggregate sold interest from all the close trades | HOLDING.POSITION_DETAIL | Interest_sold |
8953 – Sold Interest Base | Optional | MONEYB | Base equivalent of the sold interest local | HOLDING.POSITION_DETAIL | Interest_sold_base |
718 – Total Accrued Income PTD Local | Optional | MONEYL | Total period-to-date accrued income local of the position for the given effective date | HOLDING.POSITION_DETAIL | Accrued_income_local |
487 – Local Market Value | Optional | MONEYL | Local market value of the position for the given effective date | HOLDING.POSITION_DETAIL | Local_market_value |
488 – Base Market Value | Optional | MONEYB | Base market value of the position for the given effective date | HOLDING.POSITION_DETAIL | Market_value |
489 – Total Unrealized Gain Loss Local | Optional | MONEYL | Unrealized gain/loss security local – the local market value less book cost local (cost and amortization (including TIPS income)). | HOLDING.POSITION_DETAIL | Local_unrealized_gl |
491 – Unrealized Security Gain Loss Base | Optional | MONEYB | Security unrealized gain/loss base of the position | HOLDING.POSITION_DETAIL | Unrealized_sec_gl |
492 – Total Unrealized Gain Loss Base | Optional | MONEYB | Unrealized gain/loss security base – the base market value less base book cost (cost and amortization (including TIPS income)). | HOLDING.POSITION_DETAIL | Base_unrealized_gl |
493 – Unrealized Currency Gain Loss Base | Optional | MONEYB | Currency unrealized gain/loss base of the position. | HOLDING.POSITION_DETAIL | Unrealized_curr_gl |
726 – Total Accrued Income PTD base | Optional | MONEYB | Total period-to-date accrued income base of the position for the given effective date. (Interest_earned + Interest_purchased – Interest_sold) / mkt_exchange_rate | HOLDING.POSITION_DETAIL | Accrued_income |
1106 – Update Date | Optional | DATE | This field is populated with the time stamp for when the record was inserted into the PACE table. | HOLDING.POSITION HOLDING.POSITION_DETAIL | Update_date |
4601 – Amortized Cost Local | Optional | MONEYL | Book cost local – the total of the current local cost + ltd amortization local + ltd TIPS income local and ltd OID income local. | HOLDING.POSITION_DETAIL | Book_value_local |
4602 – Amortized Cost Base | Optional | MONEYB | Book cost base – the total of the current base cost + ltd amortization base + ltd TIPS income base and ltd OID income. | HOLDING.POSITION_DETAIL | Book_value |
9424 – Market Value Income Local | Optional | MONEYL | Local market value + the total period-to-date accrued income local + all local income receivables for the position. | HOLDING.POSITION_DETAIL | Market_value_income_local |
9426 – Market Value Income Base | Optional | MONEYB | Base market value + the total period-to-date accrued income base + all base income receivables for the position. | HOLDING.POSITION_DETAIL | Market_value_income |
9498 – Dividend Receivable Local | Optional | MONEYL | Traded cash attributed to dividend income for a given security | HOLDING.POSITION_DETAIL | Dividend_receivable_local |
9499 – Dividend Receivable | Optional | MONEYB | Traded cash attributed to dividend income for a given security | HOLDING.POSITION_DETAIL | Dividend_receivable |
9500 – Coupon Receivable Local | Optional | MONEYL | Traded cash attributed to coupon income for a given security | HOLDING.POSITION_DETAIL | Coupon_receivable_local |
9501 – Coupon Receivable | Optional | MONEYB | Traded cash attributed to coupon income for a given security | HOLDING.POSITION_DETAIL | Coupon_receivable |
9502 – Reclaim Receivable Local | Optional | MONEYL | Traded cash attributed to reclaim income for a given security | HOLDING.POSITION_DETAIL | Reclaim_receivable_local |
9503 – Reclaim Receivable | Optional | MONEYB | Traded cash attributed to reclaim income for a given security | HOLDING.POSITION_DETAIL | Reclaim_receivable |
10767 – Misc Income Receivable Local | Optional | CHAR | Traded cash attributed to any income not captured in the other income fields for a given security | HOLDING.POSITION_DETAIL | Misc_inc_receivable_local |
10768 – Misc Income Receivable | Optional | CHAR | Traded cash attributed to any income not captured in the other income fields for a given security | HOLDING.POSITION_DETAIL | Misc_inc_receivable |
10043 – Settled date position base | Optional | CHAR | Field with the settled cash balance (base market value) for a given cash position accounting date | HOLDING.POSITION_DETAIL | Settlement_date_position |
10791 – Notional Cost Local | Optional | CHAR | Notional cost local of the future position for the given effective date | HOLDING.POSITION_DETAIL | Notional_cost_local |
10792 – Notional Cost Base | Optional | CHAR | Notional cost base of the future position for the given effective date | HOLDING.POSITION_DETAIL | Notional_cost |
10793 – Notional Market Value Local | Optional | CHAR | Notional market value local of the future position for the given effective date | HOLDING.POSITION_DETAIL | Notional_market_value_local |
10794 – Notional Market Value Base | Optional | CHAR | Notional market value base of the future position for the given effective date | HOLDING.POSITION_DETAIL | Notional_market_value |
10795 – Notional Unrealized Gain/Loss Local | Optional | CHAR | Notional_market_value_local – Notional_cost_local | HOLDING.POSITION_DETAIL | Notional_local_unrealized_gl |
10796 – Notional Unrealized Gain/Loss Base – Total | Optional | CHAR | Notional_market_value – Notional_cost | HOLDING.POSITION_DETAIL | Notional_unrealized_gl |
10797 – Notional Unrealized Gain/Loss Base – Currency | Optional | CHAR | Notional_unrealized_gl – Notional_Unrealized_security_gl | HOLDING.POSITION_DETAIL | Notional_unrealized_curr_gl |
10798 – Notional Unrealized Gain/Loss Base – Security | Optional | CHAR | Notional_local_unrealized_gl / Mkt_exchange_rate | HOLDING.POSITION_DETAIL | Notional_unrealized_sec_gl |
11044 – Settled Unit Cost Local | Optional | VARCHAR2 (255) | Settled Unit Cost Local. | HOLDING.POSITION_COST_DETAIL | settled_local_gaap_unit_cost |
11045 – Settled Unit Cost Base | Optional | VARCHAR2 (255) | Settled Unit Cost Base. | HOLDING.POSITION_COST_DETAIL | settled_gaap_unit_cost |
11046 – Settled Cost Local | Optional | VARCHAR2 (255) | Settled Cost Local. | HOLDING.POSITION_COST_DETAIL | settled_local_gaap_cost_value |
11047 – Settled Cost Base | Optional | VARCHAR2 (255) | Settled Cost Base. | HOLDING.POSITION_COST_DETAIL | settled_gaap_cost_value |
11048 – Settled Market Value Local | Optional | VARCHAR2 (255) | Settled Market Value Local. | HOLDING.POSITION_DETAIL | settled_local_market_value |
11049 – Settled Market Value Base | Optional | VARCHAR2 (255) | Settled Market Value Base. | HOLDING.POSITION_DETAIL | settled_market_value |
11050 – Settled Urgl Sec Local | Optional | CHAR (4) | Settled Urgl Sec Local. | HOLDING.POSITION_DETAIL | settled_local_sec_urgl |
11051 – Settled Urgl Sec Base | Optional | CHAR (4) | Settled Urgl Sec Base. | HOLDING.POSITION_DETAIL | settled_base_sec_urgl |
11052 – Settled Urgl Currency Base | Optional | CHAR (4) | Settled Urgl Currency Base. | HOLDING.POSITION_DETAIL | settled_base_currency_urgl |
11053 – Settled Urgl Total Base | Optional | CHAR (4) | Settled Urgl Total Base. | HOLDING.POSITION_DETAIL | settled_base_total_urgl |
944 – Update Source | Optional | VARCHAR2 (8) | The source or userid of the entity that last updated the table. | HOLDING.POSITION/POSITION_DETAIL | update_source |
9985 – Perform Flag | Optional | CHAR | Perform Flag. | HOLDING.POSITION | perform_flag |
11668 – User_Group1 | Optional | CHAR (50) | This tag is binded to the holdingdbo position_detail.user_group1. | HOLDING.POSITION_DETAIL | user_group1 |
11669 – User_Group2 | Optional | CHAR (50) | This tag is binded to the holdingdbo position_detail.user_group2. | HOLDING.POSITION_DETAIL | user_group2 |
11728 – System Currency | Optional | VARCHAR2 (30) | The system currency the local performance values are translated into. | HOLDING.POSITION_DETAIL | sys_currency |
11729 – System Currency Exchange Rate | Optional | VARCHAR2 (30) | The exchange rate between the local currency and the system currency. | HOLDING.POSITION_DETAIL | sys_curr_fx_rate |
11730 – System Currency Exchange Rate Date | Optional | VARCHAR2 (255) | The date of the exchange rate between the local currency and the system currency. | HOLDING.POSITION_DETAIL | sys_curr_fx_rate_date |
11731 – System Currency Accrued Income | Optional | VARCHAR2 (255) | The system currency equivalent of the local accrued income. | HOLDING.POSITION_DETAIL | accrued_income_sys |
11732 – System Currency Market Value | Optional | VARCHAR2 (255) | The system currency equivalent of the local market value. | HOLDING.POSITION_DETAIL | market_value_sys |
11733 – System Currency Dividend Receivable | Optional | VARCHAR2 (255) | The system currency equivalent of the local dividend receivable. | HOLDING.POSITION_DETAIL | dividend_receivable_sys |
11734 – System Currency Coupon Receivable | Optional | VARCHAR2 (255) | The system currency equivalent of the local coupon receivable value. | HOLDING.POSITION_DETAIL | coupon_receivable_sys |
11735 – System Currency Reclaim Receiavble | Optional | VARCHAR2 (255) | The system currency equivalent of the local reclaim receivable value. | HOLDING.POSITION_DETAIL | reclaim_receivable_sys |
11737 – System Currency Market Value income | Optional | VARCHAR2 (255) | The system currency equivalent of the local market income value. | HOLDING.POSITION_DETAIL | market_value_income_sys |
11736 – System Currency Misc Income Receivable | Optional | VARCHAR2 (255) | The system currency equivalent of the local misc income value. | HOLDING.POSITION_DETAIL | misc_income_receivable_sys |
869 – Orig Dividend Receivable | Optional | MONEYB | Original dividend receivable. | HOLDING.POSITION_DETAIL | orig_dividend_receivable |
875 – Orig Coupon Receivable | Optional | MONEYB | Original coupon receivable. | HOLDING.POSITION_DETAIL | orig_coupon_receivable |
876 – Orig Reclaim Receivable | Optional | MONEYB | Original reclaim receivable. | HOLDING.POSITION_DETAIL | orig_reclaim_receivable |
877 – Orig Misc Inc Receivable | Optional | MONEYB | Original miscellaneous income receivable. | HOLDING.POSITION_DETAIL | orig_misc_inc_receivable |
9828 – User_Defined_Float1 | Optional | DEC | User defined field | HOLDING.POSITION_DETAIL | user_float1 |
9829 – User_Defined_Float2 | Optional | DEC | User defined field | HOLDING.POSITION_DETAIL | user_float2 |
1320 – User Defined Date1 | Optional | DATE | User defined field | HOLDING.POSITION_DETAIL | user_date1 |
1321 – User Defined Date2 | Optional | DATE | User defined field | HOLDING.POSITION_DETAIL | user_date2 |
11668 – User Defined Group1 | Optional | CHAR (50) | User defined field | POSITION_DETAIL | user_group1 |
11669 – User Defined Group2 | Optional | CHAR (50) | User defined field | POSITION_DETAIL | user_group2 |
16436 – User PDA Character 1 | CHAR | User defined field | |||
16437 – User PDA Character 10 | CHAR  | User defined field  | |||
16438 – User PDA Character 11 | CHAR  | User defined field  | |||
16439 – User PDA Character 12 | CHAR  | User defined field  | |||
16440 – User PDA Character 13 | CHAR  | User defined field  | |||
16441 – User PDA Character 14 | CHAR  | User defined field  | |||
16442 – User PDA Character 15 | CHAR  | User defined field  | |||
16443 – User PDA Character 16 | CHAR | User defined field  | |||
16444 – User PDA Character 17 | CHAR  | User defined field  | |||
16445 – User PDA Character 18 | CHAR  | User defined field  | |||
16446 – User PDA Character 19 | CHAR  | User defined field  | |||
16447 – User PDA Character 20 | CHAR  | User defined field  | |||
16448 – User PDA Character 21 | CHAR  | User defined field  | |||
16449 – User PDA Character 22 | CHAR  | User defined field  | |||
16450 – User PDA Character 23 | CHAR  | User defined field  | |||
16451 – User PDA Character 24 | CHAR  | User defined field  | |||
16452 – User PDA Character 25 | CHAR  | User defined field  | |||
16453 – User PDA Character 2 | CHAR  | User defined field  | |||
16454 – User PDA Character 3 | CHAR  | User defined field  | |||
16455 – User PDA Character 4 | CHAR  | User defined field  | |||
16456 – User PDA Character 5 | CHAR  | User defined field  | |||
16457 – User PDA Character 6 | CHAR  | User defined field  | |||
16458 – User PDA Character 7 | CHAR  | User defined field  | |||
16459 - User PDA Character 8 |  CHAR | User defined field  | |||
16460 – User PDA Character 9 | CHAR  | User defined field  | |||
16461 – User PDA Date 1 | DATE | User defined field   | |||
16462 – User PDA Date 10 | DATE | User defined field   | |||
16463 – User PDA Date 2 | DATE | User defined field   | |||
16464 – User PDA Date 3 | DATE | User defined field   | |||
16465 – User PDA Date 4 | DATE | User defined field   | |||
16466 – User PDA Date 5 | DATE | User defined field   | |||
16467 – User PDA Date 6 | DATE | User defined field   | |||
16468 – User PDA Date 7 | DATE | User defined field   | |||
16469 – User PDA Date 8 | DATE | User defined field   | |||
16470 – User PDA Date 9 | DATE | User defined field   | |||
16471 – User PDA Date 11 | DATE | User defined field   | |||
16472 – User PDA Date 12 | DATE | User defined field   | |||
16473 – User PDA Date 13 | DATE | User defined field   | |||
16474 – User PDA Date 14 | DATE | User defined field   | |||
16475 – User PDA Date 15 | DATE | User defined field   | |||
16476 – User PDA Date 16 | DATE | User defined field   | |||
16477 – User PDA Date 17 | DATE | User defined field   | |||
16478 – User PDA Date 18 | DATE | User defined field   | |||
16479 – User PDA Date 19 | DATE | User defined field   | |||
16480 – User PDA Date 20 | DATE | User defined field   | |||
16481 – User PDA Date 21 | DATE | User defined field   | |||
16482 – User PDA Date 22 | DATE | User defined field   | |||
16483 – User PDA Date 23 | DATE | User defined field   | |||
16484 – User PDA Date 24 | DATE | User defined field   | |||
16485 – User PDA Date 25 | DATE | User defined field   | |||
16486 – User PDA Float 1 | DEC (12) | User defined field    | |||
16487 - User PDA Float 10 | DEC (12) | User defined field    | |||
16488 – User PDA Float 11 | DEC (12) | User defined field    | |||
16489 – User PDA Float 12 | DEC (12)  | User defined field    | |||
16490 – User PDA Float 13 | DEC (12)  | User defined field    | |||
16491 – User PDA Float 14 | DEC (12)  | User defined field    | |||
16492 – User PDA Float 15 | DEC (12)  | User defined field    | |||
16493 – User PDA Float 16 | DEC (12)  | User defined field    | |||
16494 – User PDA Float 17 | DEC (12)  | User defined field    | |||
16495 – User PDA Float 18 | DEC (12)  | User defined field    | |||
16496 – User PDA Float 19 | DEC (12)  | User defined field    | |||
16497 – User PDA Float 2 | DEC (12)  | User defined field    | |||
16498 – User PDA Float 20 | DEC (12)  | User defined field    | |||
16499 – User PDA Float 21 | DEC (12)  | User defined field    | |||
16500 – User PDA Float 22 | DEC (12)  | User defined field    | |||
16501 – User PDA Float 23 | DEC (12)  | User defined field    | |||
16502 – User PDA Float 24 | DEC (12)  | User defined field    | |||
16503 – User PDA Float 25 | DEC (12)  | User defined field    | |||
16504 – User PDA Float 26 | DEC (12)  | User defined field    | |||
16505 – User PDA Float 27 | DEC (12)  | User defined field    | |||
16506 – User PDA Float 28 | DEC (12)  | User defined field    | |||
16507 – User PDA Float 29 | DEC (12)  | User defined field    | |||
16508 – User PDA Float 3 | DEC (12)  | User defined field    | |||
16509 – User PDA Float 30 | DEC (12)  | User defined field    | |||
16510 – User PDA Float 31 | DEC (12)  | User defined field    | |||
16511 – User PDA Float 32 | DEC (12)  | User defined field    | |||
16512 – User PDA Float 33 | DEC (12)  | User defined field    | |||
16513 – User PDA Float 34 | DEC (12)  | User defined field    | |||
16514 – User PDA Float 35 | DEC (12)  | User defined field    | |||
16515 – User PDA Float 36 | DEC (12)  | User defined field    | |||
16516 – User PDA Float 37 | DEC (12)  | User defined field    | |||
16517 –User PDA Float 38 | DEC (12)  | User defined field    | |||
16518 – User PDA Float 39 | DEC (12)  | User defined field    | |||
16519 – User PDA Float 4 | DEC (12)  | User defined field    | |||
16520 – User PDA Float 40 | DEC (12)  | User defined field    | |||
16521 – User PDA Float 41 | DEC (12)  | User defined field    | |||
16522 – User PDA Float 42 | DEC (12)  | User defined field    | |||
16523 – User PDA Float 43 | DEC (12)  | User defined field    | |||
16524 – User PDA Float 44 | DEC (12)  | User defined field    | |||
16525 – User PDA Float 45 | DEC (12)  | User defined field    | |||
16526 – User PDA Float 46 | DEC (12)  | User defined field    | |||
16527 – User PDA Float 47 | DEC (12)  | User defined field    | |||
16528 – user PDA Float 48 | DEC (12)  | User defined field    | |||
16529 – User PDA Float 49 | DEC (12)  | User defined field    | |||
16530 – User PDA Float 5 | DEC (12)  | User defined field    | |||
16531 – User PDA Float 50 | DEC (12)  | User defined field    | |||
16532 – User PDA Float 51 | DEC (12)  | User defined field    | |||
16533 – User PDA Float 52 | DEC (12)  | User defined field    | |||
16534 – User PDA Float 53 | DEC (12)  | User defined field    | |||
16535 – User PDA Float 54 | DEC (12)  | User defined field    | |||
16536 – User PDA Float 55 | DEC (12)  | User defined field    | |||
16537 – User PDA Float 56 | DEC (12)  | User defined field    | |||
16538 – User PDA Float 57 | DEC (12)  | User defined field    | |||
16539 – User PDA Float 58 | DEC (12)  | User defined field    | |||
16540 – User PDA Float 59 | DEC (12)  | User defined field    | |||
16541 – User PDA Float 6 | DEC (12)  | User defined field    | |||
16542 – User PDA Float 60 | DEC (12)  | User defined field    | |||
16543 – User PDA Float 61 | DEC (12)  | User defined field    | |||
16544 – User PDA Float 62 | DEC (12)  | User defined field    | |||
16545 – User PDA Float 63 | DEC (12)  | User defined field    | |||
16546 – User PDA Float 64 | DEC (12)  | User defined field    | |||
16547 – User PDA Float 65 | DEC (12)  | User defined field    | |||
16548 – User PDA Float 66 | DEC (12)  | User defined field    | |||
16549 – User PDA Float 67 | DEC (12)  | User defined field    | |||
16550 – User PDA Float 68 | DEC (12)  | User defined field    | |||
16551 – User PDA Float 69 | DEC (12)  | User defined field    | |||
16552 – User PDA Float 7 | DEC (12)  | User defined field    | |||
16553 – User PDA Float 70 | DEC (12)  | User defined field    | |||
16554 – User PDA Float 8 | DEC (12)  | User defined field    | |||
16555 – User PDA Float 9 | DEC (12) | User defined field    |
Â