Data Table for PACE Disposal Lots Upload
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Former user (Deleted)
The following table describes the available required and optional data fields for PACE Disposal Lots Upload message stream.
Tag Number/Name | Required/Optional | Data Type | Notes | PACE Table | PACE Field |
|---|---|---|---|---|---|
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:
| 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). | 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 |