More information

Importing Vendors

Importing Vendors Check Address

Table 2: 1099 Box Numbers

Data Import/Export Checklists

Data Import/Export FAQs

Importing Detail Lines or 1099 Adjustments

The following table defines field references used in the Accounts Payable Detail Lines or 1099 Adjustments section of the MasterAP.DEF file:

Table: tbl1099Adjustment
Context Section: CONTEXT,VENDOR,DETAIL,DVEND
Field ID Req'd Field Length Default Value Notes

VENDOR_YEAR

Y

4

  

1099 Year Format: xxxx

VENDOR_1099TYPEID

Y

4

  

1099 Type ID, such as MISC, DIV, INT, R, or W2G

VENDOR_BOXNUMID

Y

8

N/A

1099 Box Number. See Table 2.

VENDOR_AMOUNT

Y

Currency

0.00

1099 Amount
  • Vendor 1099 adjustments can only be imported with a full vendor record. Also note that 1099 fields are only required for adjustments being imported.
  • When importing header records for 1099 Adjustments, use the UPDATEITEM statement. However, when importing detail field data, delete the master record and import the correct information, instead of updating the existing records using the UPDATEITEM statement.