Other related iMIS tables

Although not considered key accounting tables, the following tables are updated by the procedures/modules that generate the main accounting data.

Subscription Module

The Subscription Module contains primary summary information on the status of each dues/subscription line item billed and/or paid for each customer. For cash-basis dues billing operations, this table also serves as a memo AR type of file with no accounting impact. The Subscription Module is used in these input/output operations to perform the following tasks:

• Generate initial and reminder dues notices
• Record billing payment receipts
• Display in the Billing tab of the Manage customers window

Orders and Order_Lines

The Orders and Order_Lines table serves as the master table for both the event registration function and the simple order entry subsystem function. Orders and Order_Lines are also the main tables for Order Processing. This table is used in the following output operations:

• Events Reports - badges, confirmation letters, labels, tickets, invoices, and rosters
• Simple Order Entry System - Order status report (used for validation purposes) and Invoices

Activity tables

The modules that generate accounting transactions also post monetary long-term history details into the general purpose Activity table. The long-term history details can be used later for inquiry and analysis. The activity updates are the by-product of the following operations:

• Billing Payments - Generates activity records for each line item paid
• Event Close - Generates a single activity record for each (uncanceled) registrant, reflecting the total amount of the registration
• Simple Order Entry & Advanced Order Entry - One product history record is generated for each line item in an invoice order
• AR Transactions - Includes sales transactions, credit memos, and debit adjustments, and generates one product history record for each line item