APL |
APL Account Master Database Fields |
APL Account Master Database Fields
Tip: An Adobe AcrobatTM formatted version of this document (PDF) materials are available for sharing with your customer.
| ADM | Account administrator. Use the account administrators initials to uniquely identify him or her. |
| AMTMTH |
Controls the amortization method to be used for the specific tax lot:
|
| AUDIT | Date of last audit. |
| BANK | Short name of bank or custodian. |
| BASEAC | Base account (used in COMBONYC). Also used to block dividends and splits. |
| BEGDTE | Billing beginning date (MM/DD/ YY). This date must coincide with the quarter on which the client is billed. |
| BRKPCT | Broker percent. Automated commissions can be coded in this field. |
| BWNUM | Account number. The maximum number of characters is nine (Numeric only). |
| CHARAC | User-defined free field. |
| CLODT | Date account was closed. |
| COMBON | Group account identifier for combined account billing. |
| CUST1 | User-defined free field. |
| CUST2 | User-defined free field. |
| CUST3 | User-defined free field. |
| CUST4 | User-defined free field. Also used to code minimum commissions. |
| CUST5 | User-defined free field. |
| CUST6 | User-defined free field. |
| CUST7 | User-defined free field. |
| CUSTOD | Indicates the number of copies of the client report to be printed. |
| DESBRK | Designated broker. |
| DESFIX | Designated Fixed Income Target. |
| DESPCT | Designated Equity Target. |
| DISCRT | User-defined free field. |
| DISVOT |
Discretion/voting field for SEC 13F filings:
For example, YN means sole discretion, no voting authority. |
DTCBRK |
DTC broker firm identification number. |
DTCNO |
Complete 12 digit DTC account number at the custodian bank (comprised of DTCNO1, first 6 characters, and DTCNO2, last six characters). |
FAMILY |
User defined free field. This can be used to code family relationships. |
FDTYPE |
Type of funds / investment strategy:
|
FEEAGR |
Fee agreement for billing reports. |
FISCAL |
Ending date for account's fiscal year. |
FIXED |
Field that will lock in a price or that will allow you to code a fixed dollar amount for billing. |
FOFO |
Methodology for selling assets:
|
FREQCY |
Frequency of reporting. |
GAIN |
Account Gain. |
INVGRP |
Investment group. |
MGR |
Manager code (usually initials of the manager). |
MINMUM |
Minimum dollar amount of bill per billing period. |
MMFUND |
Money market fund linked to the account. |
NAMES |
Number of securities in a portfolio. |
NDATE |
Date the account was added to the APL system. This field cannot be changed. |
OBJECT |
Objective (ex: growth or income) of account. |
OLDAC |
Alternate account number field. |
OPEDT |
Beginning date the portfolio manager is responsible for the account. |
QRTFEE |
Fee for accounts billed on a quarterly basis. |
| RECEPT | Who pays the fees for the account. |
| REPFQY |
Report frequency:
|
| RESID | Residence identification (two-letter state code). |
| RR |
Account status code. RR numbers are:
Note: For new accounts not authorized to trade, status codes are used at client’s discretion. |
| SNAM | Short name for an account. It is a six character alphanumeric field. |
| SOCIND | User defined free field. |
| SOCSEC | Social Security Number for the owner of the account. |
| SOURCE | Source of funds. This field is used in ADV reports. |
| STKUNV | Stock universe or model portfolio reference. |
| SWEEP | Indicator for income sweep out of an account (DLVINC) or for income transferred to principal (TFRINC). |
| TXSTAT |
Tax status of an account:
|
| TYPCMB | Type of fee allocation for combined accounts. |
| VALUE | Portfolio value as of the last posting date from the performance file (from EVALPMSECT). This is used in ADV reports. |
| VEHICL | Investment vehicle, often used to indicate ESOP or MSP. |
| W13321* | Cash value of an account as of prior day's processing - actual cash represented by security SACUS = 13321. |
| WCASH* | Cash value of an account as prior day's trades - includes actual cash and securities with ISSTY = 1. |
| WCOST* | Total cost of an account as of prior day's trades - original cost, not amortized cost. |
| WEQUTY* | Equity value of an account as of prior day's trades and prices. |
| WFIXED* | Fixed Income value of an account as of prior day's trades and prices - does not include accrued interest. |
| WINCME* | Total Account Income. |
| WTIME* | Windows Update Time. |
| WTOTAL* | Total Value of an account as of prior day's trades and prices - does not include accrued interest. |
| XRSTAT* | Native currency of account / Foreign Currency Codes. This field can not be edited. |