...
Tag Number/Name | Required/Optional | Data Type | Value/Description of Field | 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. Options include: |
| n/a | ||
55 – Event Type | Required | CHAR | Required – defaults on panel. Used by message stream for identification of the event. Must be UPLOAD_CASH. |
|
| ||
1102 – Source Name | Required | CHAR (15) | Used to resolve src_intfc_inst if tag 1168 is null | n/a | n/a | ||
1077 – Calculate Reflexive rows | Optional | CHAR | Calculate Reflexive Flows Switch – Y = Yes, N = No. | 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 | ||
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 | ||
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 | ||
1981 – Xref Exchange | Optional | CHAR (8) | Used by the Xref ID lookup to further qualify the security resolution. | n/a | n/a | ||
10 – security_alias | Conditionally Required | NUMBER | Conditionally Required if tag 7001 = 2 or 3 and tags 1952 – 1971 are null. | CASHCASH_ACTIVITY | security_alias | ||
21– acct basis | Optional | VARCHAR2(5) | CASHCASH_ACTIVITY | account | |||
85 – local_currency | Optional | CHAR (30) | 3-character currency code – Code Value. Used by the Xref ID lookup to further qualify the security resolution. | CASHCASH_ACTIVITY | local_currency | ||
86 – base_currency | Optional | CHAR (3) |
| CASHCASH_ACTIVITY | base_currency | ||
1168 – src_intfc_inst | Conditionally Required | INTEGER | Conditionally Required – tag 1102 is null | CASHCASH_ACTIVITY | src_intfc_inst | ||
1163 – Entity ID | Conditionally Required | CHAR (8) | Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE. | CASHCASH_ACTIVITY | entity_id | ||
1164 – Entity Name | Conditionally Required | CHAR (30) | Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE. | N/A | n/a | ||
221 – Effective Date | Required | DATE | CASHCASH_ACTIVITY | effective_date | |||
15 – Long/Short Indicator | Optional | CHAR | CASHCASH_ACTIVITY | long_short_indicator | |||
2283 – Event type | Optional | CHAR | Event type of the cash_activity record | CASHCASH_ACTIVITY | trans_type | ||
16 – Bank Alias | Optional | VARCHAR2 (25) | Bank alias assigned to the custodian bank. | CASHCASH_ACTIVITY | bank_alias | ||
17 – Exchange Code | Optional | CHAR (8) | Exchange code. |
|
| ||
25 – Event ID | Optional | VARCHAR2(55) | Event ID of the transaction. | CASHCASH_ACTIVITY | star_tag25 | ||
26 – Target Event ID | Optional | VARCHAR2(55) | Event ID of the transaction to be canceled, closed, or adjusted. | CASHCASH_ACTIVITY | star_tag26 | ||
28 – Link Event ID | Optional | CHAR | Assigned Event ID that groups multiple lots together; for keeping track of activity related to originating transaction. | CASHCASH_ACTIVITY | linked_event_id | ||
30 – Post Date | Optional | DATE | System processing date of the transaction. | CASHCASH_ACTIVITY | post_date | ||
35 – Trade Date | Optional | DATE | Date on which the transaction is executed. | CASHCASH_ACTIVITY | trade_date | ||
36 – Accounting Date | Optional | DATE | Accounting date. | CASHCASH_ACTIVITY | accounting_date | ||
37 – Settlement Date | Optional | DATE | Contractual settlement date of the trade. | CASHCASH_ACTIVITY | settlement_date | ||
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 | ||
45 – Price | Optional | DEC | Price for the given transaction | CASHCASH_ACTIVITY | price | ||
46 – Tax Amount Local | Optional | MONEYL | Taxes applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | trade_taxes | ||
47 – Commission Amount Local | Optional | MONEYL | Commission applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | local_commission | ||
48 – Fee Amount Local | Optional | MONEYL | Fees applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | trade_fee | ||
50 – Net Amount Local | Optional | MONEYL | Net amount of the transaction. | CASHCASH_ACTIVITY | local_amount | ||
51 – Stamp Duty Tax Local | Optional | MONEYL | Stamp duty taxes applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | local_stamp_duty_tax | ||
53 – Cash Event Type | Optional | CHAR | Must be RECPT or DISB | CASHCASH_ACTIVITY | cash_event_type | ||
54 – Trade Status | Optional | VARCHAR2 (2) | Transaction is either SETTLED or TRADED | CASHCASH_ACTIVITY | transaction_status | ||
56 – Reason Code | Optional | VARCHAR2(255) | Reason code stored on the transaction | CASHCASH_ACTIVITY | comments1 | ||
62 – Cash Category | Optional | CHAR |
| CASHCASH_ACTIVITY | cash_category | ||
63 – Settlement Currency | Optional | CHAR (3) | Currency in which the trade is to be settled | CASHCASH_ACTIVITY | settlement_currency | ||
79 – Settle to Base FX Rates | Optional | DEC | FX Rates on the transaction between the settlement amount and the base currency of the entity. | CASHCASH_ACTIVITY | curr_fx_rate | ||
87 – FX Rates Local to Base | Optional | DEC | FX Rates on the transaction between the asset currency and base currency of the entity. | CASHCASH_ACTIVITY | local_fx_rate | ||
88 – Broker Code | Optional | CHAR (20) | Broker code assigned to the transaction. | CASHCASH_ACTIVITY | broker_code | ||
126 – Event Sequence | Optional | NUMBER(38) | Position sequence number assigned to the transaction. | CASHCASH_ACTIVITY | cash_bal_inst | ||
151 – Event ID | Optional | CHAR | Event ID assigned to the transaction that generated an open lot in STAR. | CASHCASH_ACTIVITY | source_event_id | ||
159 – Quantity | Optional | DEC | Unit amount of the transaction. | CASHCASH_ACTIVITY | trans_quantity | ||
164 – Holding Period Date | Optional | DATE | Date on which the transaction was originally held. | CASHCASH_ACTIVITY | holding_period_date | ||
198 – Security Currency Gain | Optional | MONEYB | Currency gain on events such as MARGIN due to FX Rates changes on the approval date. | CASHCASH_ACTIVITY | security_currency_gain | ||
199 – Security Currency Loss | Optional | MONEYB | Currency loss on events such as MARGIN due to FX Rates changes on the approval date. | CASHCASH_ACTIVITY | security_currency_loss | ||
216 – Original Acquisition Date | Optional | DATE | Original acquisition date of the trade. | CASHCASH_ACTIVITY | orig_acq_date | ||
221 – Effective Date | Optional | DATE | Effective date of the transaction | CASHCASH_ACTIVITY | effective_date | ||
325 – Gross Amount Local | Optional | MONEYL | Gross amount local on any coupon or cash div | CASHCASH_ACTIVITY | gross_amount_local | ||
330 – Gross Amount Base | Optional | MONEYB | Gross amount base on any coupon or cash div | CASHCASH_ACTIVITY | gross_amount | ||
362 – From Event ID | Optional | CHAR |
| CASHCASH_ACTIVITY | trans_num | ||
368 – Dividend Rate | Optional | DEC | Rate applied due to a Corporate Action entitlement | CASHCASH_ACTIVITY | dividend_rate | ||
457 – Trade ID | Required | CHAR | Trade ID of the transaction. If a match is found, the record is updated. If no match is found, the record is inserted | CASHCASH_ACTIVITY | master_trans_num | ||
9418 – orig_tran_num | Optional | VARCHAR2 (50) |
| CASHCASH_ACTIVITY | orig_trans_num | ||
478 – Net Amount Base | Optional | MONEYB | Base equivalent amount of the settlement amount in which the transaction contractually settles. The base currency of the entity (Tag 86) is the currency of this amount. | CASHCASH_ACTIVITY | base_amount | ||
701 – Batch Event ID | Optional | VARCHAR2 (55) | Unique ID used to link multiple individual transactions together for reporting and cancellation | CASHCASH_ACTIVITY | batch_event_id | ||
761 – Trade Ticket Number | Optional | VARCHAR2 (55) | Source system transaction number stored on the transaction record. | CASHCASH_ACTIVITY | master_ticket_number | ||
851 – Reclaim Base | Optional | MONEYB | Reclaim base amount on any coupon or cash div. | CASHCASH_ACTIVITY | reclaim | ||
852 – Reclaim Local | Optional | MONEYL | Reclaim local on any coupon or cash div. | CASHCASH_ACTIVITY | reclaim_local | ||
853 – Withholding Local | Optional | MONEYL | Tax withholding local on any coupon or cash div. | CASHCASH_ACTIVITY | withholding_local | ||
854 – Withholding Base | Optional | MONEYB | Withholding base on any coupon or cash div. | CASHCASH_ACTIVITY | withholding | ||
860 – Lot Number | Optional | MONEYB | Lot number affected by the transaction | CASHCASH_ACTIVITY | lot_number | ||
1236 – Clearing Broker Code | Optional | CHAR | Clearing broker code assigned to the transaction. | CASHCASH_ACTIVITY | clearing_broker_code | ||
1240 – Custodian Bank Code | Optional | CHAR | Bank code assigned by the user to the custodian bank. | CASHCASH_ACTIVITY | bank_code | ||
1661 – Sub account | Optional | VARCHAR2 (30) | General ledger cash sub–account number | CASHCASH_ACTIVITY | sub_account | ||
1728 – Corporate Action Type | Optional | VARCHAR2 (50) | CASHCASH_ACTIVITY | comments4 | |||
1827 – Rec Pay Event Type | Optional | CHAR |
| CASHCASH_ACTIVITY | gl_account | ||
1981 –Exchange Code | Optional | CHAR (8) | Exchange code. Used by the Xref ID lookup to further qualify the security resolution. |
|
| ||
3746 – Original Acquisition Base | Optional | MONEYB | Original cost associated with the trade. | CASHCASH_ACTIVITY | orig_acq_cost_base | ||
3747 – Original Acquisition Local | Optional | MONEYL | Original cost associated with the trade. | CASHCASH_ACTIVITY | orig_acq_cost_local | ||
3752 – Other Fees | Optional | MONEYL | Any other fee applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | sec_fees | ||
4268 – Corporate Action Instance | Optional | INTEGER | Instance assigned to the corporate action record. Stored on each record created for the Corporate Action. | CASHCASH_ACTIVITY | corporate_action_inst | ||
4597 – Performance Flow Value | Optional | MONEYL | Eagle Performance requires this value for events that have no cash movements (ex. REC, DEL, SPINOFF). Initial value assigned to the security. | CASHCASH_ACTIVITY | performance_flow_value | ||
4598 – Performance_Price | Optional | DEC | Eagle Performance requires this value for events that have no cash movements (ex. REC, DEL, SPINOFF). Initial price assigned to the security. | CASHCASH_ACTIVITY | performance_price | ||
4599 – Performance Code | Optional | CHAR | Eagle Performance requires this value for events that have no cash movements (ex. REC, DEL, SPINOFF). Code used by PACE to determine what price is used. | CASHCASH_ACTIVITY | performance_code | ||
4733 – Month End Accounting Date | Optional | DATE | Assigned monthly accounting date. | CASHCASH_ACTIVITY | month_end_acct_date | ||
1870 – Gain Loss | Optional | DEC | Gain/loss for the given transaction. | CASHCASH_ACTIVITY | gain_loss | ||
10170 – Performance Flow Description | Optional | VARCHAR2 (4) | Translation updated for both the Security and the Currency Cash Activity records. | CASHCASH_ACTIVITY | performance_flow_descr | ||
5363 – Local Total Flow | Optional | MONEYL | Total amount of the trade in asset currency | CASHCASH_ACTIVITY | local_total_flow | ||
10716 – Local Principal Flow | Optional | VARCHAR2 (4) | Amount of the trade (not including the purchased/sold interest) in terms of the asset currency. | CASHCASH_ACTIVITY | local_principal_flow | ||
10717 – Local Income Flow | Optional | VARCHAR2 (4) | Purchased/sold interest on the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | local_income_flow | ||
10718 – Base Total Flow | Optional | VARCHAR2 (4) | Total amount of trade in terms of Base Currency | CASHCASH_ACTIVITY | base_total_flow | ||
169 – Base Principal Flow | Optional | MONEYB | Amount of the trade (not including the purchased/sold interest) in terms of the base currency. | CASHCASH_ACTIVITY | base_principal_flow | ||
1986 – Base Income Flow | Optional | MONEYB | Purchased/sold interest on the transaction in terms of the entity base currency. | CASHCASH_ACTIVITY | base_income_flow | ||
10721 – Settle to Local FX Rates | Optional | VARCHAR2 (4) | FX Rates used to convert the cash settlement amount back into the asset currency equivalent for Eagle Performance calculations. | CASHCASH_ACTIVITY | fx_rate_settle_to_asset | ||
11415 – Activity Source | Optional | VARCHAR2 (255) | Must be either CASH or COST | CASHCASH_ACTIVITY | activity_source | ||
10045 – Cancel Flag | Optional | CHAR | Used to flag a cancel record | CASHCASH_ACTIVITY | cancel_flag | ||
10046 – Cancel Status | Optional | CHAR | Used to flag that a record has been cancelled | CASHCASH_ACTIVITY | cancel_status | ||
5398 – Reflexive Flow Flag | Optional | VARCHAR2 (1) | Indicates whether or not a record is a reflexive flow | CASHCASH_ACTIVITY | reflexive_flow | ||
49 – Traded Interest | Optional | MONEYL | The amount of interest on the trade | CASHCASH_ACTIVITY | local_int_pur_sold | ||
475 – Traded Interest Base | Optional | MONEYB | CASHCASH_ACTIVITY | int_pur_sold | |||
505 – Cancel Accounting Date | Optional | DATE | CASHCASH_ACTIVITY | cancel_acctg_date | |||
8378 – Cancel Month End Accounting Date | Optional | DATE |
| CASHCASH_ACTIVITY | cancel_me_acctg_date | ||
10674 – Replay Indicator | Optional | VARCHAR2 (4) |
| CASHCASH_ACTIVITY | replay_ind | ||
11416 – Source Long Short Ind | Optional | VARCHAR2 (255) | CASHCASH_ACTIVITY | source_long_short_ind | |||
11417 – Source Security Alias | Optional | VARCHAR2 (255) |
| CASHCASH_ACTIVITY | source_security_alias | ||
9201 – Position ID | Optional | INTEGER | CASHCASH_ACTIVITY | position_id | |||
9418 – Orig Trans Num | Optional | VARCHAR2 (50) | CASHCASH_ACTIVITY | orig_trans_num | |||
11728 – Sys Currency | Optional | VARCHAR2 (30) | CASHCASH_ACTIVITY | sys_currency | |||
11738 – Sys Total Flow | Optional | VARCHAR2 (255) | CASHCASH_ACTIVITY | sys_total_flow | |||
11729 – Sys Currency FX Rates | Optional | VARCHAR2 (30) |
| CASHCASH_ACTIVITY | sys_curr_fx_rate | ||
11730 – Sys Currency FX Rates Date | Optional | VARCHAR2 (255) |
| CASHCASH_ACTIVITY | sys_curr_fx_rate_date | ||
11739 – Sys Principal Flow | Optional | VARCHAR2 (255) |
| CASHCASH_ACTIVITY | sys_principal_flow | ||
11740 – Sys Income Flow | Optional | VARCHAR2 (30) | CASHCASH_ACTIVITY | sys_income_flow | |||
11819 – Gain Swap L | Optional | DEC |
| CASHCASH_ACTIVITY | gain_swap_l | ||
11820 – Gain Swap B | Optional | CHAR (2) | CASHCASH_ACTIVITY | gain_swap_b | |||
11821– Loss Swap L | Optional | CHAR (2) | CASHCASH_ACTIVITY | loss_swap_l | |||
11822 – Loss Swap B | Optional | CHAR (2) | CASHCASH_ACTIVITY | loss swap_b |
...