APL Extract System (Contents, Download)

The APL-as-vendor EXTRACT tool was created in order to provide a standard method for pulling data stored in the APL system. Data downloads for the APL system, can be generated daily, weekly,monthly or quarterly. Files are generated via templates that are APL client-maintained. After the templates run on APL, the Client moves the download files from the APL directory, to the PC using FTP package or whatever transfer protocol package that the Client subscribes to.

Tip: An Adobe Acrobat^TM formatted version of the complete User Guide (PDF) materials are available for sharing with your customer.

Table of Contents

• Chapter 1: Overview
  • 1.1 Select Vendor
  • 1.2 Select Desired Option
  • 1.3 Edit Custom Account Field Table
  • 1.4 Edit Custom Security Field Table
  • 1.5 Copy a Template
  • 1.6 Delete a Template
  • 1.7 Rename a template
  • 1.8 Add a Client to a New Vendor

• Chapter 2: APL (Vendor)
  • 2.1 Specific Reports
    • Account
    • Position
    • Performance
    • Transactions
    • Port Changes (Applies to MSP Extracts only)
    • Gain/Loss
  • 2.2 Field Formatting
  • 2.3 Shared Settings
    • How “Updates Only” works

• Chapter 3: UMASLV
  • 3.1 Creating a new UMA template
  • 3.2 Selecting accounts by manager and submodel code
    • F7 Submanager
    • F8 Submodel Selection
  • 3.3 Select Accounts by Strategy
  • 3.4 Specify Type of Extract to Produce
  • 3.5 Change or Remove an Extract
  • 3.6 Choose how to collate an extract
  • 3.7 Select Files to Collate
  • 3.8 Modify Report Settings
    • MSP Transactions
    • MSP Positions
  • 3.9 Shared Settings
  • 3.10 List Date Variable
  • 3.11 File Naming Conventions
  • 3.12 Viewing Report Files
  • 3.13 Usage of the UMA and MSP acronyms

• Appendix A: Layouts
  • A.1 Standard Layouts
    • Data Extracts
    • Reference Tables
  • A.2 MSP Extracts
    • Data Extracts
    • Reference Tables