Data Table for PACE Cash Activity 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. Options include:
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

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.
When Y, do not populate Tag 10170

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

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