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 |