AccountMate 7 for SQL/Express System Manager Database Reference Guide

About this manual

This document serves as a reference guide for the AccountMate 7 for SQL/Express System Manager module. It is organized into chapters that detail the E-R diagram, back-end tables, front-end tables, remote views, data integrity rules, and stored procedures used by the system.

The guide provides specific information on database structures, including table names (e.g., Amcfg, Amusr), field types, sizes, and default values. It also lists stored procedures such as vsp_am_addday and explains their parameters and usage examples.

What's inside

• Introduction
• E-R Diagram
• System Manager Back End Tables
• System Manager Front End Tables
• Remote Views
• Data Integrity
• Stored Procedures

Frequently asked questions

What is the purpose of this manual?

This manual helps readers understand the AccountMate 7 for SQL/Express System Manager module Database Design.

What does the Bank Positive Pay File Format Table contain?

The table contains information regarding the format of a Positive Pay file and the function called to generate it.

What do the character codes "AM" and "PR" represent in the SM Add-On Procedures Table?

"AM" represents non-Payroll records, while "PR" represents Payroll records for AccountMate.