| Anchor | ||||
|---|---|---|---|---|
|
| Info | ||
|---|---|---|
| ||
This stream supports all fields defined on the pan-csa_egl_gen_interface.htm panel, whether listed below or not. |
The following table describes several required and optional data fields for PACE Cash Upload message stream.
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 |