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 |
Add Comment