Inbound W-9 Updates (API016)
  • 07 Jun 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Inbound W-9 Updates (API016)

  • Dark
    Light
  • PDF

Article summary

Interface Description

The API016 Inbound interface reads new and updated supplier information from the file inbound from the W-9 System. The W-9 system provides additional data to be associated with the supplier record in Florida PALM. This data is used for the purpose of updating W-9 details on the supplier record for 1099 Reporting.

The custom API016 process consists of the following functions:

  • Process inbound “Inbound W-9 Updates file” from W-9 system.
  • Update the Supplier record with W-9 data if the supplier exists in Florida PALM.
  • Supplier is matched based on “Tax Identification Type Code” and “Tax Identifier Number”; If there is a Supplier match between Inbound W-9 file and Florida PALM, then the W9 details from the W9 file is updated in Florida PALM Supplier profile.
  • The W9 application will send a full data file of all verified additions and all updates including inactivation.

Click below to view the interface file layout and sample data file.

Business Process Model

This interface can be found in the following business processes:

Selection Criteria

The interface data selection criteria includes the following:

Data Field

Data Field Details

N/A


File Layout

Field names and descriptions from the interface layout are provided below. 

Data Field Name

Record Type

Data Field Description

Record Code

Details

Record Code identifying the information on the record.

Tax Identification Type Code

Details

Used to characterize the tax identification number as either the social security number or the federal employer identification number.

Tax Identifier Number

Details

Tax identification number

IRS/Legal Name

Details

Supplier name in the W-9 system. This name is used on the Form 1099 and also populated as the Withholding name in the Supplier record of Florida PALM.

TIN Match Status

Details

Identifies whether the supplier's W-9 form has been verified or made inactive.

TIN Match Date

Details

Identifies the date when the TIN Matching occurred.

Business Designation

Details

Identifies the supplier's W-9 business designation.

1099 Address Line 1

Details

Designates the 1099 Address.

1099 Address Line 2

Details

Additional 1099 Address information

1099 Address Line 3

Details

Additional 1099 Address information

1099 City

Details

Designates the 1099 City.

1099 State

Details

Designates the 1099 State/Province.

1099 Zip

Details

Designates the 1099 Postal Code.

1099 Country

Details

Designates the 1099 Country.

Filler 1

Details

This field is reserved for future use in Florida PALM.

Filler 2

Details

This field is reserved for future use in Florida PALM.

Filler 3

Details

This field is reserved for future use in Florida PALM.

Filler 4

Details

This field is reserved for future use in Florida PALM.

Filler 5

Details

This field is reserved for future use in Florida PALM.

Version History

Date

Revision Description

03/12/2024

Original Version


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.