Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top
The following table describes the available data fields for PACE Ledger Balances Upload message stream.

Tag #

Req/Opt'l

Data Type

PACE Table

PACE Field

55

Required

CHAR.  Value must be UPLOAD_BALANCES.

n/a

n/a

5

 


VARCHAR2(5)

GL_DETAIL_POSTING

entity_id

1164

 


CHAR (30)

GL_DETAIL_POSTING

entity_name

1102

 


CHAR (15)

GL_DETAIL_POSTING

source

1168

 


INTEGER

GL_DETAIL_POSTING

src_intfc_inst

10

 


NUMBER

GL_DETAIL_POSTING

security_alias

34

 


VARCHAR2(10)

GL_DETAIL_POSTING

gldp_share_class

21

 


VARCHAR2(5)

GL_DETAIL_POSTING

gldp_acct_basis

15

 


CHAR

GL_DETAIL_POSTING

gldp_long_short_ind

12068

 


NUMBER (28,12)

GL_DETAIL_POSTING

gldp_from_fund_class

85

 


CHAR (30)

GL_DETAIL_POSTING

gldp_currency_code

86

 


CHAR (3)

GL_DETAIL_POSTING

gldp_base_currency

1288

 


CHAR

GL_DETAIL_POSTING

gldp_ledger_acct

1290

 


CHAR

GL_DETAIL_POSTING

gldp_ledger_acct_desc

12057

 


CHAR (30)

GL_DETAIL_POSTING

gldp_asset_liab_code

12058

 


CHAR (30)

GL_DETAIL_POSTING

gldp_asset_liab_desc

1291

 


CHAR

GL_DETAIL_POSTING

gldp_stmt_cat

903

 


DEC

GL_DETAIL_POSTING

gldp_balance

1109

 


DATE

GL_DETAIL_POSTING

gldp_effective_dt

36

 


DATE

GL_DETAIL_POSTING

gldp_accounting_dt

944

 


VARCHAR2 (8)

GL_DETAIL_POSTING

update_source

1106

 


DATE

GL_DETAIL_POSTING

update_date

946

 


CHAR

GL_DETAIL_POSTING

closeldgr_acct_offset

931

 


CHAR

GL_DETAIL_POSTING

closeldgr_acct_target

70

 


NUMBER (28,12)

GL_DETAIL_POSTING

coupon

471

 


CHAR (20)

GL_DETAIL_POSTING

day_cnt

11

 


CHAR (4)

GL_DETAIL_POSTING

investment_type

961

 


VARCHAR2 (255)

GL_DETAIL_POSTING

issnm

962

 


VARCHAR2 (255)

GL_DETAIL_POSTING

issdsc

1417

 


CHAR (60)

GL_DETAIL_POSTING

issuer_ind

38

 


DATE

GL_DETAIL_POSTING

mat_dt

1418

 


CHAR (30)

GL_DETAIL_POSTING

nra_tax_country

107

 


CHAR (12)

GL_DETAIL_POSTING

pool_num

18

 


NUMBER (28,12)

GL_DETAIL_POSTING

price_multiplier

14

 


CHAR (100)

GL_DETAIL_POSTING

cusip

3931

 


VARCHAR2 (15)

GL_DETAIL_POSTING

process_sec_type

1440

 


CHAR (4)

GL_DETAIL_POSTING

security_minor_type

82

 


CHAR (15)

GL_DETAIL_POSTING

security_type

13

 


CHAR (100)

GL_DETAIL_POSTING

symbol

19

 


NUMBER (28,12)

GL_DETAIL_POSTING

trading_unit

29

 


CHAR (60)

GL_DETAIL_POSTING

entity_long_name

1105

 


CHAR (4)

GL_DETAIL_POSTING

entity_type

...