Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Current »

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).
Default is 1.

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:

  • NONE/NULL (default). No translation, the entity ID/Name value provided is used.

  • BANK. The entity bank relationship lookup LENTBANKREL is performed using tag 16.

  • XREFERENCE. The entity cross reference table lookup is performed using tags 7233 and 7234.

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    



  • No labels