Worktables Generated During 1099 Processing

The system generates these worktables during 1099 processing:

Table

Description

1099 A/P Worktable (F045143)

Company, supplier number, supplier tax ID, type of return, payment amount, company tax ID, and 2nd TIN indicator (optional).

Based on the F0411, F0413, and F0414 tables.

1099 G/L Worktable (F045141)

Company, supplier number, supplier tax ID, type of return, payment amount, payment date, document number, and company tax ID.

Based on the F0911 table and AAI ranges for PXxxxx.

1099 Merged Worktables (F04514)

Company, supplier number, supplier tax ID, type of return, payment amount, and company tax ID. Also payment number and payment date for G/L method.

Based on a combination of the F045141 and F045143 tables.

1099 Securities Identification File (F045145)

CUSIP number for 1099-INT return.

1099 Electronic Media (F04515OW)

1099 reporting information.

K Record Workfile (F04514WF)

State code and control totals for state total reporting.

Based on the F045150W and the electronic filing options.

This table should be empty after Write Media (P04515) completes successfully.