Data Table for PACE Disposal Lots Upload

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: 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_DISPOSAL_LOT.

n/a

n/a

1102 – Source Name

Required

CHAR (15)

Used to resolve src_intfc_inst if tag 1168 is null

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

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

1981 – Xreference Exchange

Optional

CHAR (8)

Used by the Xref ID lookup to further qualify the security resolution.

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

38 – Maturity Date

Optional

DATE

Date on which the security matures. Used by the Xref ID lookup to qualify security resolution.

11043 – Inactive flag

Optional

VARCHAR2 (255)

Valid values are Y = Yes or N = No. Used by the Xref ID lookup to qualify security resolution.

85 – Asset Currency

Optional

CHAR (30)

3-character currency code – Code Value. Used by the Xref ID lookup to qualify security resolution.

DISPOSAL_LOTS

trade_currency/commission currency

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.

1168 – src_intfc_inst

Conditionally Required – tag 1102 is null

INTEGER

DISPOSAL_LOTS

src_intfc_inst

10 – security_alias

Conditionally Required if tag 7001 = 2 or 3 and tags 1952 – 1971 are null

NUMBER

DISPOSAL_LOTS

security_alias

1163 – Entity ID

Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE.

CHAR (8)

TRADESDISPOSAL_LOTS

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

TRADESDISPOSAL_LOTS

effective_date

15 – Long/Short Indicator

Optional

CHAR

TRADESDISPOSAL_LOTS

long_short_indicator

35 – Trade Date

Optional

DATE

TRADESDISPOSAL_LOTS

trade_date

36 – Accounting Date

Optional

DATE

TRADESDISPOSAL_LOTS

ledger_effective_date

37 – Settlement Date

Optional

DATE

TRADESDISPOSAL_LOTS

settlement_date

2283 – Event Type

Optional

CHAR

TRADESDISPOSAL_LOTS

trans_code

761 – Trade Ticket Number

Required

VARCHAR2 (55)

TRADESDISPOSAL_LOTS

master_ticket_number

944 – Update Source

Optional

VARCHAR2 (8)

TRADESDISPOSAL_LOTS

update_src

N/a

Optional

#VALUE!

Current system date time

TRADESDISPOSAL_LOTS

update_date

1085 – Number of Lots

Optional

CHAR

Defaulted to 1 in the panel.

TRADESDISPOSAL_LOTS

nbr_of_lots

17 – Exchange

Optional

CHAR (8)

Exchange code provided on the trade.

TRADESDISPOSAL_LOTS

exchange_code

24 – Cost Basis Type

Optional

CHAR

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

TRADESDISPOSAL_LOTS

post_type

26 – Target Event ID

Optional

VARCHAR2(55)

Event ID of the transaction closed by the closing transaction. Tag is primarily used in IDLOT sells.

TRADESDISPOSAL_LOTS

target_event_id

27 – Lot Selection Method

Optional

VARCHAR2 (5)

Reports the method used to pick the open lot to close (FIFO, LIFO, etc.)

TRADESDISPOSAL_LOTS

lot_selection_method

28 – Link Event ID

Optional

CHAR

Event ID that links all pieces of a transaction that was processed.

TRADESDISPOSAL_LOTS

link_event_id

30 – Post Date

Optional

DATE

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

TRADESDISPOSAL_LOTS

post_date

41 – Original Face

Optional

NUMBER(38,12)

Amount of original face closed by this disposal lot.

TRADESDISPOSAL_LOTS

original_face_value

43 – Settlement Location

Optional

CHAR

Settlement location on the trade.

TRADESDISPOSAL_LOTS

settlement_location

46 – Tax Amount Local

Optional

MONEYL

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

TRADESDISPOSAL_LOTS

taxes

47 – Commission Amount

Optional

MONEYL

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

TRADESDISPOSAL_LOTS

local_commission_amount

48 – SEC Fee Amount Local

Optional

MONEYL

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

TRADESDISPOSAL_LOTS

exchange_fee

49 – Accrued Interest

Optional

MONEYL

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

TRADESDISPOSAL_LOTS

accrued_interest

50 – Net Local Amount

Optional

MONEYL

Net amount on the trade in local currency terms.

TRADESDISPOSAL_LOTS

net_cash

51 – Stamp Duty Tax Local

Optional

MONEYL

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

TRADESDISPOSAL_LOTS

other_fee

54 – Trade Status

Optional

VARCHAR2 (2)

Status of the transaction. TRADED or SETTLED

TRADESDISPOSAL_LOTS

trade_status

56 – Transaction Notes

Optional

VARCHAR2(255)

Open text field for providing additional information about the trade.

TRADESDISPOSAL_LOTS

trade_memo2

63 – Settlement Currency

Optional

CHAR (3)

Currency of the settlement amount.

TRADESDISPOSAL_LOTS

settlement_currency

64 – Settlement Amount

Optional

MONEYS

Settlement amount provided on the transaction.

TRADESDISPOSAL_LOTS

settlement_amount

79 – FX Rates Settle to Base

Optional

DEC

FX Rates between the settlement amount and net amount base.

TRADESDISPOSAL_LOTS

settlement_exchange_rate

84 – Xrate Loc Base Open

Optional

DEC

Local-to-base FX Rates on the open lot that was closed by this disposal lot.

TRADESDISPOSAL_LOTS

fx_rate_open

85 – Local Currency

Optional

CHAR (30)

Security's issue currency. Value is returned by Security lookup. Can be overridden.

TRADESDISPOSAL_LOTS

trade_currency commission_currency

87 – FX Rates Local to Base

Optional

DEC

FX Rates between the local amount and net amount base.

TRADESDISPOSAL_LOTS

fx_rate

88 – Broker Code

Optional

CHAR (20)

Broker code on the trade.

TRADESDISPOSAL_LOTS

broker_code

4643 – Unit Cost Base

Optional

DEC

Unit cost base applied to the disposal lot shares.

TRADESDISPOSAL_LOTS

unit_cost_base

162 – Current Cost Local

Optional

MONEYL

Current cost local applied to the disposal lot shares.

TRADESDISPOSAL_LOTS

cost_local

166 – Current Cost Base

Optional

MONEYB

Current cost base applied to the disposal lot shares.

TRADESDISPOSAL_LOTS

cost_base

160 – Open Unit Price

Optional

DEC

Price on the open lot that was closed.

TRADESDISPOSAL_LOTS

unit_open_price

4642 – Unit Cost Local

Optional

DEC

Unit cost local applied to the disposal lot shares.

TRADESDISPOSAL_LOTS

unit_cost_local

181 – Cls Open Event ID

Optional

CHAR

Event ID of the open lot closed.

TRADESDISPOSAL_LOTS

cls_open_event_id

182 – Close Event ID

Optional

CHAR

Event ID assigned to the close transaction.

TRADESDISPOSAL_LOTS

transaction_id

189 – Close Unit Price

Optional

DEC

Close price on the trade.

TRADESDISPOSAL_LOTS

price

190 – Proceeds Local

Optional

MONEYL

Total proceeds local applied to the disposal lot.

TRADESDISPOSAL_LOTS

trade_amount

191 – Proceeds Base

Optional

MONEYB

Total proceeds base applied to the disposal lot.

TRADESDISPOSAL_LOTS

settleamt0

192 – Close Holding Period Date

Optional

DATE

Closing date used to calculate gain/loss term.

TRADESDISPOSAL_LOTS

cls_hld_period_date

200 – Close Quantity

Optional

DEC

Quantity amount of the close lot.

TRADESDISPOSAL_LOTS

par_or_shares

203 – Premium Amount Local

Optional

MONEYL

Amount of premium allocated in local currency terms.

TRADESDISPOSAL_LOTS

premium_allocated_local

204 – Premium Amount Base

Optional

MONEYB

Amount of premium allocated in base currency terms.

TRADESDISPOSAL_LOTS

premium_allocated

216 – Original Acquisition Date

Optional

DATE

Original date on which trade was acquired.

TRADESDISPOSAL_LOTS

orig_acq_date

238 – Gain Loss Term

Optional

CHAR(2)

Close lot is either a long term or short term gain/loss.

TRADESDISPOSAL_LOTS

gain_loss_term

281 – Open Cost Basis Type

Optional

CHAR

Cost basis type of the open lot closed by the close trade.

TRADESDISPOSAL_LOTS

open_cost_basis_type

282 – Close Cost Basis Type

Optional

CHAR

Cost basis type of the close trade.

TRADESDISPOSAL_LOTS

close_cost_basis_type

478 – Net Amount Base

Optional

MONEYB

Base equivalent of the net amount of the trade.

TRADESDISPOSAL_LOTS

trade_base_amount

521 – Close Amortization Local

Optional

MONEYL

Total local amort (no OID) from last earning dt to settle dt

TRADESDISPOSAL_LOTS

amort_local

522 – Close Amortization Base

Optional

MONEYB

Total base amort (no OID) from last earning dt to settle dt

TRADESDISPOSAL_LOTS

amort_base

1632 – ClientID

Optional

CHAR (20)

Client ID provided on the transaction.

TRADESDISPOSAL_LOTS

client_id

3752 – Other Charges

Optional

MONEYL

All other fees, expenses, taxes, and charges on the close trade.

TRADESDISPOSAL_LOTS

feeamt

4483 – Close Index Weight

Optional

DEC

Index weight at the time the trade was processed.

TRADESDISPOSAL_LOTS

principal_factor

4538 – Close TIPS Income LTD Local

Optional

MONEYL

TIPS income from last earn through date to settle date local

TRADESDISPOSAL_LOTS

tip_income_ltd_local

4539 – Close TIPS Income LTD Base

Optional

MONEYB

TIPS income from last earn through date to settle date base

TRADESDISPOSAL_LOTS

tip_income_ltd_base

4601 – Close Total Amortized Cost Local

Optional

MONEYL

Total cost applied to the close lot. The cost value used in the realized gain/loss calc.

TRADESDISPOSAL_LOTS

book_value_local

4602 – Close Total Amortized Cost Base

Optional

MONEYB

Total cost applied to the close lot. The cost value used in the realized gain/loss calc.

TRADESDISPOSAL_LOTS

book_value

4733 – Month End Accounting Date

Optional

DATE

TRADESDISPOSAL_LOTS

month_end_date

5502 – Close Total OID Local

Optional

MONEYL

Total OID from last earning dt to settle dt

TRADESDISPOSAL_LOTS

oid_local

5503 – Close Total OID Base

Optional

MONEYB

Total OID from last earning dt to settle dt

TRADESDISPOSAL_LOTS

oid_base

5685 – Close Total Amortization Local

Optional

MONEYL

Total local amort (OID +regular) from last earning dt to settle dt

TRADESDISPOSAL_LOTS

total_amort_local

5686 – Close Total Amortization Base

Optional

MONEYB

Total base amort (OID + regular) from last earning dt to settle dt

TRADESDISPOSAL_LOTS

total_amort_base

5819 – Gain Currency 988

Optional

MONEYB

Currency gain generated by the disposal lot.

TRADESDISPOSAL_LOTS

gain_currency_988

5820 – Loss Currency 988

Optional

MONEYB

Currency loss generated by the disposal lot.

TRADESDISPOSAL_LOTS

loss_currency_988

9143 – Original Source Code

Optional

CHAR

Event type of the open lot closed.

TRADESDISPOSAL_LOTS

original_source_code

9736 – Gain Currency on Interest

Optional

MONEYB

Realized currency gain on interest.

TRADESDISPOSAL_LOTS

currency_gain_int

9738 – Loss Currency on Interest

Optional

MONEYB

Realized currency loss on interest.

TRADESDISPOSAL_LOTS

currency_loss_int

10049 – Gain Currency

Optional

CHAR

Currency Gain generated by the disposal lot.

TRADESDISPOSAL_LOTS

gain_currency

10050 – Gain Sec Local

Optional

CHAR

Local security gain generated by the disposal lot.

TRADESDISPOSAL_LOTS

gain_security_local

10051 – Base Gain Security

Optional

CHAR

Security gain generated by the disposal lot.

TRADESDISPOSAL_LOTS

gain _security

10052 – Loss Currency

Optional

CHAR

Currency Loss generated by the disposal lot.

TRADESDISPOSAL_LOTS

loss_currency

10053 – Loss Sec Local

Optional

CHAR

Local security loss generated by the disposal lot.

TRADESDISPOSAL_LOTS

loss_security_local

10054 – Base Loss Security

Optional

CHAR

Security loss generated by the disposal lot.

TRADESDISPOSAL_LOTS

loss_security

10056 – Open ID Cost Local

Optional

CHAR

Cost local applied to the disposal lot.

TRADESDISPOSAL_LOTS

open_cost_local

10055 – Open ID Cost Base

Optional

CHAR

Cost base applied to the disposal lot.

TRADESDISPOSAL_LOTS

open_cost_base

10057 – Total Gain

Optional

CHAR

Total gain of the disposed lot.

TRADESDISPOSAL_LOTS

total_gain

10058 – Total Loss

Optional

CHAR

Total loss of the disposed lot.

TRADESDISPOSAL_LOTS

total_loss

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.

TRADESDISPOSAL_LOTS

curr_builtin_gl_sec

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.

TRADESDISPOSAL_LOTS

curr_builtin_gl_currency

10918 – Current Built-In Gain/Loss – Deferred

Optional

CHAR

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

TRADESDISPOSAL_LOTS

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.

TRADESDISPOSAL_LOTS

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.

TRADESDISPOSAL_LOTS

curr_builtin_gl_mkt_disc