Return1099FormattedAddress

Return 1099 Formatted Address

Minor Business Rule

Object Name: N0400496

Parent DLL: CFIN

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
The purpose of this business function is to return a formatted mailing address for a given address number (payee, payer or transmitter company).  The
business function will also return the primary phone number if requested  (cGetPhoneNumber = '1').  The mailing address is returned as three lines,
uppercase.  The first line will be the legal name (F0111 Type Code = 'T') if requested (cGetLegalName = '1') and found, otherwise it will be the mailing
name (F0111 Line Number = '0').  The second line will be the last non-blank street address.  The third line will be formatted as CITY ST ZIPCODE.
Separate values for city, state and zip code can be returned for the magnetic media.  The legal name (F0111 Type Code = 'T') or contact name (F0111 Type
Code = 'C') will be returned if requested (cGetOtherName = 'T' or 'C') and found.  The country description and a free-form 3rd line (formatted as CITY ST
ZIPCODE COUNTRYNAME) can be returned for foreign addresses.

1.2Setup Notes and Prerequisites
• Before calling N0400496 to return a formatted address for a payer (company) or transmitter company,
you will need to call B0000047 (F0010 Get Company Address) to get the company's address.  This
function will return the Address Number (AN8) if one is defined in the Company Master (F0010); otherwise, the
company's own number will be returned in address number format.

1.3Special Logic

Data Structure

D0400496 - Return 1099 Formatted Address

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnAddressNumber AN8 MATH_NUMERIC REQ INPUT

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

cGetOtherName EV01 char OPT INPUT

An option that specifies the type of processing for an event.

cGetPhoneNumber EV02 char OPT INPUT

An option that specifies the type of processing for an event.

szAddressLine1 ADD1 char OPT OUTPUT

The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service
(IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the
following restrictions:   o  On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code.   o  On
1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code.   o  On other U.S. federal magnetic
media, the system prints only the last nonblank address line plus the city, state, and postal code.

szAddressLine2 ADD2 char OPT OUTPUT

The second line of the mailing address for an employee, customer, or supplier in the Address Book system. Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state,
and postal code.

szAddressLine3 ADD3 char OPT OUTPUT

The third line of the mailing address for an employee, customer, or supplier in the Address Book system. Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints
on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code.

szAreaCode AR1 char OPT OUTPUT

The first segment of a telephone number. In the United States, the prefix is the three-digit area code.

szPhoneNumber PH1 char OPT OUTPUT

A number without the prefix or special characters, such as hyphens or periods, that makes up the telephone number for an entity. You can
use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first
segment of the telephone number, which is called the area code in the United States. When you search for an address using a phone
number, you must enter the number exactly as it is set up in the Address Book system, including any special characters.

szCity CTY1 char OPT OUTPUT

A name that indicates the city associated with the address.

szState ADDS char OPT OUTPUT

A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.

szZipCode ADDZ char OPT OUTPUT

The United States ZIP code or the postal code that specifies where a letter is to be routed.  Attach this code to the address for delivery in
other countries. This code is used as the low end value when doing Postal Code Transaction range processing.

szOtherName MLNM char OPT OUTPUT

The company or person to whom billing or correspondence is addressed.

szScrubbedPhoneNumber PH1 char OPT OUTPUT

A number without the prefix or special characters, such as hyphens or periods, that makes up the telephone number for an entity. You can
use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first
segment of the telephone number, which is called the area code in the United States. When you search for an address using a phone
number, you must enter the number exactly as it is set up in the Address Book system, including any special characters.

szCountry CTR char OPT OUTPUT

A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion. The Address Book system
uses the country code for data selection and address formatting.

cAddressTypePayables ATP char OPT INPUT

A code that identifies the address as a supplier. Valid values are: Y Yes, this is a supplier. A processing option specifies whether the
supplier master record appears automatically after you add an address. N No, this is not a supplier. This code does not prevent you from entering
a voucher for the address. M This is a miscellaneous, one-time supplier. This code does not prevent you from entering multiple vouchers for
the address. F This is a supplier with a foreign address. The IRS requires U.S. companies to identify suppliers with foreign addresses for
1099 reporting. You should assign tax authorities as suppliers. This allows tax payments to be made to tax authorities. Code N is informational
only unless you set a processing option. In this case, a warning message appears if both the Payables and Receivables fields are N.

szCountryDescription DL01 char OPT OUTPUT

A user defined name or remark.

szFreeFormLine3 KSTR char OPT OUTPUT

A concatenated string of keys to any table. (For example, Sales Order Detail -F4211 Keys: Sales order number, Sales order type, and Key
Company Line Number).

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
cGetOtherName	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
cGetPhoneNumber	EV02	char	OPT	INPUT
An option that specifies the type of processing for an event.
szAddressLine1	ADD1	char	OPT	OUTPUT
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service (IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the following restrictions: o On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code. o On 1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code. o On other U.S. federal magnetic media, the system prints only the last nonblank address line plus the city, state, and postal code.
szAddressLine2	ADD2	char	OPT	OUTPUT
The second line of the mailing address for an employee, customer, or supplier in the Address Book system. Attention Payroll users: The Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and postal code.
szAddressLine3	ADD3	char	OPT	OUTPUT
The third line of the mailing address for an employee, customer, or supplier in the Address Book system. Attention Payroll users: The Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and postal code.
szAreaCode	AR1	char	OPT	OUTPUT
The first segment of a telephone number. In the United States, the prefix is the three-digit area code.
szPhoneNumber	PH1	char	OPT	OUTPUT
A number without the prefix or special characters, such as hyphens or periods, that makes up the telephone number for an entity. You can use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first segment of the telephone number, which is called the area code in the United States. When you search for an address using a phone number, you must enter the number exactly as it is set up in the Address Book system, including any special characters.
szCity	CTY1	char	OPT	OUTPUT
A name that indicates the city associated with the address.
szState	ADDS	char	OPT	OUTPUT
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.
szZipCode	ADDZ	char	OPT	OUTPUT
The United States ZIP code or the postal code that specifies where a letter is to be routed. Attach this code to the address for delivery in other countries. This code is used as the low end value when doing Postal Code Transaction range processing.
szOtherName	MLNM	char	OPT	OUTPUT
The company or person to whom billing or correspondence is addressed.
szScrubbedPhoneNumber	PH1	char	OPT	OUTPUT
A number without the prefix or special characters, such as hyphens or periods, that makes up the telephone number for an entity. You can use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first segment of the telephone number, which is called the area code in the United States. When you search for an address using a phone number, you must enter the number exactly as it is set up in the Address Book system, including any special characters.
szCountry	CTR	char	OPT	OUTPUT
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion. The Address Book system uses the country code for data selection and address formatting.
cAddressTypePayables	ATP	char	OPT	INPUT
A code that identifies the address as a supplier. Valid values are: Y Yes, this is a supplier. A processing option specifies whether the supplier master record appears automatically after you add an address. N No, this is not a supplier. This code does not prevent you from entering a voucher for the address. M This is a miscellaneous, one-time supplier. This code does not prevent you from entering multiple vouchers for the address. F This is a supplier with a foreign address. The IRS requires U.S. companies to identify suppliers with foreign addresses for 1099 reporting. You should assign tax authorities as suppliers. This allows tax payments to be made to tax authorities. Code N is informational only unless you set a processing option. In this case, a warning message appears if both the Payables and Receivables fields are N.
szCountryDescription	DL01	char	OPT	OUTPUT
A user defined name or remark.
szFreeFormLine3	KSTR	char	OPT	OUTPUT
A concatenated string of keys to any table. (For example, Sales Order Detail -F4211 Keys: Sales order number, Sales order type, and Key Company Line Number).