Data Table for PACE Ledger Balances Upload
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Former user (Deleted)
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 |
Â