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