Tables Used for 1099 Processing

The system uses information from various tables to calculate 1099 amounts and print 1099 returns. Do not purge the following tables until you print 1099 returns:

Table

Description

Addresses (F0116)

Mailing information

Address Book Master (F0101)

Tax information and category code information

Address Book - Who's Who (F0111)

Type codes, mailing names, legal names, and contact names

Address Book - Contact Phone Numbers (F0115)

Phone numbers

Supplier Master (F0401)

Vouchered amounts for year-to-date and for prior year-to-date

Accounts Payable Ledger (F0411)

Voucher information, including voucher amounts, gross amounts, open amounts, document number, and company

Accounts Payable - Matching Document (F0413)

Payment information, including payment ID, which is used to connect records from the F0414 table to the F0413 table

Accounts Payable Matching Document Detail (F0414)

Voucher payment detail and payment ID

Account Ledger (F0911)

Account ledger information, including account numbers, dates, document numbers, and companies

Purchase Order Receiver File (F43121)

Account number, document number, and match type