Data Table for PACE Trades Upload Stream

1076 – Update Mode Flag

Optional

CHAR

Used by the procedure to determine if it should check for an existing record or simply insert the record. Valid Values:
I – Insert
U – Update
D – Delete
If null, it will default to Update mode, where it checks to see if the record exists and if it does it will update it, if it does not it will insert.

n/a

n/a

55 – Event Type

Required

CHAR

Required – defaults on panel. Used by message stream for identification of the event. Must be UPLOAD_TRADE.

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

1102 – Source Name

Conditionally Required – tag 1168 is null

CHAR (15)

Used to resolve src_intfc_inst if tag 1168 is null

n/a

n/a

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

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 = 1

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.

7077 – Xref – ID Type for 7076

Optional

CHAR

Xref ID type associated with tag 7076; defaults to INTERNAL.

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.

7080 – Xref – ID Type for 7079

Optional

CHAR

Xref ID type associated with tag 7079; defaults to CINS.

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.

TRADES TRADE

trade_currency/commission currency

1981 – Xreference 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

1168 – src_intfc_inst

Conditionally Required – if tag 1102 is null

INTEGER

TRADES TRADE

src_intfc_inst

10 – security_alias

Conditionally Required – if tag 1102 is null

NUMBER

TRADES TRADE/TRADE_DETAIL

security_alias

21– acct basis

Optional

VARCHAR2(5)

TRADES TRADE

acct_basis

22 – cost method

Optional

VARCHAR2 (2)

TRADES TRADE

cost_method

27 – lot_selection _method

Optional

VARCHAR2 (5)

TRADES TRADE

lot_selection_method

86 – base_currency

Optional

CHAR (3)

TRADES TRADE

base_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)

TRADES TRADE

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)

n/a

n/a

221 – Effective Date

Required

DATE

TRADES TRADE

effective_date

15 – Long/Short Indicator

Optional

CHAR

TRADES TRADE

star_ls_ind

15 – Long/Short Indicator

Optional

CHAR

TRADES TRADE_DETAIL

long_short_indicator

35 – Trade Date

Optional

DATE

TRADES TRADE

trade_date

36 – Accounting Date

Optional

DATE

TRADES TRADE

ledger_effective_date

37 – Settlement Date

Optional

DATE

TRADES TRADE

settlement_date

2283 – Event Type

Optional

CHAR

TRADES TRADE

trans_code

761 – Trade Ticket Number

Conditionally Required – Updates to existing records or Deletes

VARCHAR2 (55)

TRADES TRADE

master_ticket_number

944 – Update Source

Optional

VARCHAR2 (8)

TRADES TRADE

update_source

N/a

Optional

#VALUE!

Current system date time

TRADES TRADE

update_date

7 – Sell to Buy FX Rates

Optional

DEC

FX Rates between sell currency and purchase currency on a forward contract.

TRADES TRADE

sell_to_buy_fx_rate

16 – Bank Alias

Optional

VARCHAR2 (25)

Instance assigned to a custodian bank relationship.

TRADES TRADE

bank_alias

17 – Exchange Code

Optional

CHAR (8)

Code assigned to the exchange on which the transaction was processed.

TRADES TRADE

exchange_code

24 – Cost Basis Type

Optional

CHAR

Contains a value defining the cost basis type provided on the transaction.

TRADES TRADE

cost_basis_type

26 – Target Event ID

Optional

VARCHAR2(55)

Event ID of the open lot adjusted by the open adjustment.

TRADES TRADE

star_tag26/target_event_id

28 – Link Event ID

Optional

CHAR

Links multiple open and close lots together.

TRADES TRADE

link_event_id

30 – Post Date

Optional

DATE

Post date provided on the transaction.

TRADES TRADE

post_date

43 – Settlement Location

Optional

CHAR

Settlement location for the trade.

TRADES TRADE

settlement_location

46 – Tax Amount Local

Optional

MONEYL

Amount of taxes paid on the trade in local currency terms.

TRADES TRADE

taxes

47 – Commission Amount Local

Optional

MONEYL

Amount of commission paid on the trade in local currency terms.

TRADES TRADE

local_commission_amount

48 – Fee Amount Local

Optional

MONEYL

Amount of fees paid on the trade in local currency terms.

TRADES TRADE

exchange_fee

49 – Accrued Interest

Optional

MONEYL

Amount of interest paid on the trade in local currency terms.

TRADES TRADE

accrued_interest

50 – Net Amount Local

Optional

MONEYL

Net amount on the trade in local currency terms.

TRADES TRADE

net_cash

51 – Stamp Duty Tax Local

Optional

MONEYL

Amount of stamp duty tax paid on the trade in local currency terms.

TRADES TRADE

other_fee

53 – Cash Event Type

Optional

CHAR

Cash movement of the transaction. RECPT or DISB

TRADES TRADE_DETAIL

cash_type

54 – Trade Status

Optional

VARCHAR2 (2)

Status of the transaction. TRADED or SETTLED

TRADES TRADE

trade_status

56 – Transaction Notes

Optional

VARCHAR2(255)

Open text field where user can provide additional information about the trade.

TRADES TRADE_DETAIL

transaction_notes

63 – Settlement Currency

Optional

CHAR (3)

Settlement currency of settlement amount on the trade.

TRADES TRADE

settlement_currency

64 – Settlement Amount

Optional

MONEYS

Settlement amount provided on the transaction.

TRADES TRADE

settlement_amount

75 – Amort Yield

Optional

DEC

Calculated amortization yield used to calculate daily amortization.

TRADES TRADE

yield

78 – Implied Commission

Optional

CHAR (15)

Some transactions have implied commissions. The price on the trade reflects the price and the commission on the trade.

TRADES TRADE

commission_type_code

79 – FX Rates Settle to Base

Optional

DEC

FX Rates between the settlement amount and the net amount base.

TRADES TRADE

settlement_exchange_rate

87 – FX Rates Local to Base

Optional

DEC

FX Rates between local net amount and net amount base.

TRADES TRADE

fx_rate

88 – Broker Code

Optional

CHAR (20)

Broker code on the trade.

TRADES TRADE

broker_code

91 – Factor

Optional

NUMBER (28,12)

Factor at the time the trade was processed.

TRADES TRADE

factor

109 – Original Face Value

Optional

DEC

Original face of the MBS purchased.

TRADES TRADE

original_face_value

126 – Sequence Event

Optional

NUMBER(38)

TRADES TRADE

batch_instance/ event_sequence

151 – Open Event ID

Optional

CHAR

TRADES TRADE

star_tag151

154 – Original Settlement Date

Optional

DATE

Original settlement date of the transaction.

TRADES TRADE

orig_settlement_date

159 – Original Quantity

Optional

DEC

Quantity provided on the trade.

TRADES TRADE

par_or_shares

160 – Unit Price Local

Optional

DEC

Price provided on the trade.

TRADES TRADE

price

162 – Cost Local

Optional

MONEYL

Local cost for the transaction.

TRADES TRADE

cost_local

164 – Open Holding Period Date

Optional

DATE

Holding period date of the transaction.

TRADES TRADE

holding_period_date

165 – Principal Amount Local

Optional

MONEYL

Local principal value of the trade.

TRADES TRADE

principal

166 – Cost Base

Optional

MONEYB

Base cost determined for the transaction.

TRADES TRADE

cost_base

169 – Principal Amount Base

Optional

MONEYB

Base equivalent of the principal value of the trade.

TRADES TRADE

principal_base

182 – Close Event ID

Optional

CHAR

Close Event ID assigned to the close trade.

TRADES TRADE

star_tag182

190 – Proceeds Local

Optional

MONEYL

Total proceeds on the trade.

TRADES TRADE

trade_amount

191 – Proceeds Base

Optional

MONEYB

Proceeds base applied to the close trade.

TRADES TRADE_DETAIL

netsettleamt

203 – Premium Amount Local

Optional

MONEYL

Amount of premium allocated in local currency terms.

TRADES TRADE

premium_allocated_local

204 – Premium Amount

Optional

MONEYB

Amount of premium allocated in base currency terms.

TRADES TRADE

premium_allocated

216 – Original Acquisition Date

Optional

DATE

Date on which transaction was originally acquired. This date may originate from another entity and carried forward for reporting purposes.

TRADES TRADE

orig_acq_date

301 – To Account

Optional

CHAR

Receiving account of a two-sided transaction.

TRADES TRADE

to_account

302 – To Asset ID

Optional

NUMBER

Receiving account asset ID of a two-sided transaction.

TRADES TRADE

to_security_alias

305 – To Long Short

Optional

CHAR

Receiving account long/short indicator of a two-sided transaction.

TRADES TRADE

to_long_short_indicator

311 – To Source System

Optional

CHAR

Receiving account source system of a two-sided transaction.

TRADES TRADE

to_source_system

316 – To Transfer Quantity

Optional

NUMBER (28,12)

Receiving account quantity of a two-sided transaction.

TRADES TRADE

to_quantity

317 – To Cost Basis Type

Optional

CHAR

Receiving account cost basis type of a two-sided transaction.

TRADES TRADE

to_cost_basis_type

327 – To Transfer Amount Local

Optional

MONEYLC

Receiving account local amount of a two-sided transaction.

TRADES TRADE

to_amount_local

328 – To Cash Event Type

Optional

CHAR

Receiving account cash event type of a two-sided transaction.

TRADES TRADE

to_cash_type

334 – To Wash Sale Eligible

Optional

CHAR

Receiving account wash sale eligible of a two-sided transaction.

TRADES TRADE

to_wash_sale_elgbl_ind

351 – From Account

Optional

CHAR

Source account of a two-sided transaction.

TRADES TRADE

from_account

352 – From Asset ID

Optional

NUMBER

Source account asset ID of a two-sided transaction.

TRADES TRADE

from_security_alias

355 – From Long Short

Optional

CHAR

Source account long/short indicator of a two-sided transaction.

TRADES TRADE

from_long_short_indicator

361 – From Source System

Optional

CHAR

Source account source system of a two-sided transaction.

TRADES TRADE

from_source_system

366 – From Transfer Quantity

Optional

DEC

Source account quantity of a two-sided transaction.

TRADES TRADE

from_quantity

367 – From Cost Basis Type

Optional

CHAR

Source account cost basis type of a two-sided transaction.

TRADES TRADE

from_cost_basis_type

377 – From Transfer Amount Local

Optional

MONEYLC

Source account local amount of a two-sided transaction.

TRADES TRADE

from_amount_local

378 – From Cash Event Type

Optional

CHAR

Source account cash event type of a two-sided transaction.

TRADES TRADE

from_cash_type

384 – From Wash Sale Eligible

Optional

CHAR

Source account wash sale eligible indicator of a two-sided transaction.

TRADES TRADE

from_wash_sale_elgbl_ind

410 – To Quantity

Optional

DEC

Receiving account quantity of a two-sided transaction. The to_quantity is also stored on the adjustment rows in STAR. This value is required in PACE so the client can view the shares effected by the cost adjustment.

TRADES TRADE

target_quantity

475 – Trade Interest Base

Optional

MONEYB

Amount of interest paid on the trade in base currency terms.

TRADES TRADE_DETAIL

baseinterestadj

478 – Net Amount Base

Optional

MONEYB

Net amount on the trade in base currency terms.

TRADES TRADE

trade_base_amount

501 – Cancel Event ID

Optional

VARCHAR2(55)

Event ID of the cancel transaction.

TRADES TRADE

cancel_event_id

502 – Cancel Event Type

Optional

VARCHAR2(30)

Event type of the transaction that was canceled (BUY, SELL, etc.).

TRADES TRADE_DETAIL

trade_memo5

504 – Cancel Effective Date

Optional

DATE

Post date provided on the transaction. Map only if this record is a cancel transaction.

TRADES TRADE_DETAIL

cancel_effective_date

506 – Cancel Linked Event ID

Optional

CHAR

Link event ID for the transaction.

TRADES TRADE

cancel_linked_event_id

701 – Batch ID

Optional

VARCHAR2 (55)

STAR provides the ability to link transactions together for reporting and cancellation purposes. The user provides this value on the originating transaction. Can also be used when 1076 = D, to identify a batch of records to be deleted.

TRADES TRADE_DETAIL

batch_event_id

751 – Cash Event Spawned

Optional

CHAR

Indicator to flag an event as having a cash event spawned from it.

TRADES TRADE

cash_event_spawned

768 – Estimated vs. Actual

Optional

CHAR

Flag provided on the trade message for mutual fund processing. The flag defines the trade as having a final price or an estimated price.

TRADES TRADE

est_vs_act

1146 – Custody Bank Name

Optional

CHAR

Name of the custodian bank.

TRADES TRADE

custody_bank_desc

1237 – Clearing Broker Code

Optional

VARCHAR2 (12)

Code of the clearing broker.

TRADES TRADE_DETAIL

clearing_broker_code

1240 – Custody Bank Code

Optional

CHAR

Code assigned to the custodian bank.

TRADES TRADE

custody_bank_code

1632 – ClientID

Optional

CHAR (20)

Client ID for the given transaction.

TRADES TRADE

client_id

1660 – Custody Bank Account Number

Optional

VARCHAR2 (30)

Custodian bank account number provided on the trade.

TRADES TRADE

custody_bank_acct_num

1661 – Custody Bank Sub Account Number

Optional

VARCHAR2 (30)

Custodian bank sub-account number provided on the trade.

TRADES TRADE

custody_bank_sub_acct

1728 – Corporate Action Type

Optional

VARCHAR2 (50)

Type of corporate action for which the event was processed.

TRADES TRADE

corp_action_type

1887 – User_char1

Optional

VARCHAR2(255)

User defined field

TRADES TRADE

user_char1

1888 – User_char2

Optional

VARCHAR2(255)

User defined field

TRADES TRADE

user_char2

1889 – User_char3

Optional

VARCHAR2(255)

User defined field

TRADES TRADE

user_char3

1890 – User_float1

Optional

NUMBER(28,12)

User defined field

TRADES TRADE

user_float1

1891 – User_float2

Optional

NUMBER(28,12)

User defined field

TRADES TRADE

user_float2

1892 – User_float3

Optional

NUMBER(28,12)

User defined field

TRADES TRADE

user_float3

1897 – Settlement Instructions 1

Optional

CHAR

User defined field

TRADES TRADE_DETAIL

settlement_instructions1

3710 – Trade Instructions Line 4

Optional

CHAR

Will be defaulted to 1 in the panel.

TRADES TRADE

lot_number

3715 – Accrued Interest Type

Optional

CHAR

Type of interest on the trade [ex or cum].

TRADES TRADE

accrued_interest_type

3717 – Scrub Type

Optional

CHAR

Scrub type for the given transaction.

TRADES TRADE

scrub_type

3746 – Original Acquisition Cost Base

Optional

MONEYB

Base original cost.

TRADES TRADE

orig_acq_cost_base

3747 – Original Acquisition Cost Local

Optional

MONEYL

Local original cost.

TRADES TRADE

orig_acq_cost_local

3752 – Other Fees

Optional

MONEYL

Amount of other fees paid on the trade in local currency terms.

TRADES TRADE

sec_fees

3766 – Close Cost Base

Optional

DEC

Base value of the original cost of the underlying trade.

TRADES TRADE_DETAIL

disp_book_value_gaap

3767 – Close Cost Local

Optional

DEC

Local value of the original cost of the underlying trade.

TRADES TRADE_DETAIL

disp_book_value_stat

3924 – Forward Close Eligible

Optional

VARCHAR2 (3)

TRADES TRADE_DETAIL

partflag

4268 – Corporate Action Instance

Optional

INTEGER

STAR assigns a corporate action instance to all STAR corporate actions. This value is unique to each corporate action stored in the corporate action table in STAR.

TRADES TRADE_DETAIL

corporate_action_inst

4483 – Index Weight

Optional

DEC

Index weight at the time the trade was processed.

TRADES TRADE

principal_factor

4519 – Paydown Gain Loss Account

Optional

VARCHAR2 (15)

Paydown can be treated as CAPITAL, INCOME, or nothing.

TRADES TRADE_DETAIL

general_ledger_acct

4597 – Performance Value

Optional

MONEYL

Specific events processed by STAR do not have a cost associated with them. Eagle Performance requires a value to accurately calculate the security's performance.

TRADES TRADE_DETAIL

performance_value

4598 – Performance Price

Optional

DEC

Specific events processed by STAR do not have a cost associated with them. Eagle Performance requires a value to accurately calculate the security's performance.

TRADES TRADE_DETAIL

performance_price

4601 – Book Value Local

Optional

MONEYL

Total amortized cost local for the open lot. Includes original cost, amortization, TIPS income, and OID income local.

TRADES TRADE_DETAIL

book_value_local

4602 – Book Value

Optional

MONEYB

Total amortized cost local for the open lot. Includes original cost, amortization, TIPS income, and OID income local.

TRADES TRADE_DETAIL

book_value

4733 – Month End Accounting Date

Optional

DATE

Month end accounting date provided on the transaction.

TRADES TRADE

month_end_date

5685 – Total Amortization Local

Optional

MONEYL

Total Local Amortization Sold

TRADES TRADE_DETAIL

total_amort_local

5686 – Total Amortization Base

Optional

MONEYB

Total Base Amortization Sold

TRADES TRADE_DETAIL

total_amort_base

9430 – Trade Yield

Optional

DEC

Trade yield provided on the trade.

TRADES TRADE

trade_yield

9761 – Current Built-In Gain/Loss – Security

Optional

DEC

Stores the portion of the built-in gain/loss solely attributed to fluctuations in market price. Contributed property may or may not have this kind of gain/loss.

TRADES TRADE

curr_builtin_gl_sec

9762 – Current Built-In Gain/Loss – Security

Optional

DEC

Stores the portion of the built-in gain/loss solely attributed to fluctuations in market price. Contributed property may or may not have this kind of gain/loss.

TRADES TRADE

orig_builtin_gl_sec

10049 – Currency Gain

Optional

CHAR

Currency gain on the trade.

TRADES TRADE_DETAIL

currency_gain

10050 – Total Gain Local

Optional

CHAR

Total local gain on the trade.

TRADES TRADE_DETAIL

total_gain_local

10051 – Security Gain

Optional

CHAR

Base security gain on the trade.

TRADES TRADE_DETAIL

security_gain

10052 – Currency Loss

Optional

CHAR

Currency loss on the trade.

TRADES TRADE_DETAIL

currency_loss

10053 – Total Loss Local

Optional

CHAR

Total local loss on the trade.

TRADES TRADE_DETAIL

total_loss_local

10054 – Security Loss

Optional

CHAR

Base security loss on the trade.

TRADES TRADE_DETAIL

security_loss

10057 – Total Gain

Optional

CHAR

Total base gain on the trade.

TRADES TRADE_DETAIL

total_gain

10058 – Total Loss

Optional

CHAR

Total base loss on the trade.

TRADES TRADE_DETAIL

total_loss

10674 – Reporting Replay Indicator

Optional

VARCHAR2 (4)

Flags the trade row as an accounting generated trade versus a true trade.

TRADES TRADE

replay_ind

10705 – Future expense cost flag

Optional

VARCHAR2 (4)

Used to set the expense/capitalization option for futures trade commissions.

TRADES TRADE_DETAIL

changedflag

10758 – Calculated Accrued Interest Local

Optional

VARCHAR2 (4)

Amount of interest paid on the trade in local currency terms.

TRADES TRADE

accrued_income_local

10781 – Dirty Principal Local

Optional

CHAR

Local principal value of the trade plus any commission, fee, and tax. This value does not include accrued interest.

TRADES TRADE

dirty_principal

10782 – Dirty Principal Base

Optional

CHAR

Principal value of the trade plus any commission, fee, and tax. This value does not include accrued interest.

TRADES TRADE

dirty_principal_base

10906 – Original Trade Price

Optional

MONEYL

TRADES TRADE

orig_trade_price

10912 – Original Built-In Gain/Loss – Currency

Optional

CHAR

TRADES TRADE

orig_builtin_gl_currency

10913 – Original Built-In Gain/Loss – Deferred

Optional

CHAR

TRADES TRADE

orig_builtin_gl_deferred

10914 – Original Built-In Gain/Loss – Original Issue Discount

Optional

CHAR

TRADES TRADE

orig_builtin_gl_oid

10915 – Original Built-In Gain/Loss – Market Discount

Optional

CHAR

TRADES TRADE

orig_builtin_gl_mkt_disc

10917 – Current Built-In Gain/Loss – Currency

Optional

CHAR

Stores the portion of the built-in gain/loss solely attributed to fluctuations in exchange rates. Contributed property may or may not have this kind of gain/loss. If issue currency (Tag 85) and base currency (Tag 86) are equal, this type of gain/loss does not exist.

TRADES TRADE

curr_builtin_gl_currency

10918 – Current Built-In Gain/Loss – Deferred

Optional

CHAR

Stores the deferred gain/loss from a wash sale transaction.

TRADES TRADE

curr_builtin_gl_deferred

10919 – Current Built-In Gain/Loss – Original Issue Discount

Optional

CHAR

Stores the portion of the built-in gain/loss originating from original issue discount on a fixed income security. Contributed property may or may not have this kind of gain/loss. If the security is not a fixed income security, this type of gain/loss does not exist.

TRADES TRADE

curr_builtin_gl_oid

10920 – Current Built-In Gain/Loss – Market Discount

Optional

CHAR

Stores the portion of the built-in gain/loss originating from market discount on a fixed income security. Contributed property may or may not have this kind of gain/loss. If the security is not a fixed income security, this type of gain/loss does not exist.

TRADES TRADE

curr_builtin_gl_mkt_disc

10045 – Cancel Flag

Optional

CHAR

TRADES TRADE_DETAIL

cancel_flag

10046 – Cancel Status

Optional

CHAR

TRADES TRADE_DETAIL

cancel_status