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