B 1099 Files

This appendix contains the following topic:

• Appendix B, "1099 Processing Files"

• Appendix B, "Workfiles Generated During 1099 Processing"

B.1 1099 Processing Files

The system uses the transaction data from the following files to calculate 1099 amounts and print 1099 returns. For this reason, you should not purge them until after you print 1099 returns:

File	Description
Address Book Master (F0101)	Mailing, tax, and category code 07 information.
Address Book - Who's Who (F0111)	Type codes, mailing names, legal names, and contact names.
Address Book - Contact Phone Numbers (F0115)	Phone numbers.
Address Book - Addresses (F0116)	Mailing addresses by date.
Address Book - Related Addresses (F01017)	Related Addresses for combining suppliers and companies.
Supplier Master (F0401)	Vouchered amounts for year-to-date and for prior year-to-date.
Accounts Payable Ledger (F0411)	Voucher information including gross amounts, open amounts, document number, and company.
One Time Payment (F0411AB)	Address book and voucher information for one-time suppliers, including document number, document type, and document company.
Accounts Payable - Matching Document (F0413)	Summarized payment information by payment number.
Accounts Payable Matching Document Detail (F0414)	Detailed payment information by voucher number (the amount of the payment that was applied to the voucher).
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.

B.2 Workfiles Generated During 1099 Processing

The system generates or the user updates the following workfiles during 1099 processing:

Workfile	Description
One Time Payment - 1099 Information (F0411AB9)	Address book information for one-time payment suppliers, as well as the required 1099 information, such as the legal name and payables type.
1099Audit File (F045144)	Account ledger information for expenses such as G/L account numbers, dates, document numbers, voucher company, and G/L distribution companies. This file also includes payment numbers and payment dates.
1099 Adjustment File (F045145)	Company, type of return, address number, and amount.
1099 A/P Workfile (F045143)	Company, supplier number, supplier tax ID, type of return, payment amount, and company tax ID. Based on the F0411, F0413, and F0414 tables.
1099 G/L Workfile (F045141)	Company, supplier number, supplier tax ID, type of return, payment amount, and company tax ID. Based on the F045144 file and AAI ranges for PXxxxx.
1099 Securities Identification (F04510)	CUSIP information.
1099 Combined Workfile (F04514)	Company, supplier number, supplier tax ID, type of return, payment amount, and company tax ID. Based on a combination of the F045141, F045143, and F045145 workfiles.
1099 Transmittal File (F1099T)	1099 data generated in the format required by the IRS 1220 Publication that you submit to the IRS. Based on the F04514 workfile.