FormattedAddressWithWhosWho

Formatted Address With Who's Who

Minor Business Rule

Object Name: B0100067

Parent DLL: CFIN

Location: Client/Server

Language: C

Business Function Specification

Source Name B0100067Programmer: Patrick Kimmitt
Data Structure D0100067
Function Name: Formatted Address with Who's Who
System Code: 01

1.Functional Description

1.1Purpose

This function takes an Address Book number, Who's Who number, and Type Code and returns the formatted address based on the company's country
code constants. The function enhances the B0100021 function which did not format addresses with attention name or a standard salutation based on
country.

1.2Setup Notes and Prerequisites

While Type Code is optional for the formating of certain elements of the address, it is required if the attention name, or salutation name are to be used
in the formatted address. It is recommended that the program calling this function use a processing option value of Type Code to determine which Who's
Who mailing record will be used in the mailing name. If Type Code is blank or null, none of the attention name, or salutation name placement will be
done.
Who's Who is optional, so if it is left blank or null, the default value will be .

1.3Special Logic

2.Technical Specifications

2.1Parameters:
Data Item I/ORequiredNotes
MLNMON
ALPHON
ADD1ON
ADD2ON
ADD3ON
ADD4ON
ADD5ON
ADD6ON
ADD7ON
AN8IY
CTY1ON
ADDSON
ADDZON
CTRON
COUNON
ATTLON
TYCINNeed to pass in if you want the Who's Who attention name returned.
EV01ON
SLNMON
IDLNINNeed to pass if referencing a specific Who's Who record, but don't want attention name returned
MLNMON

2.2Related Tables
Table Table Description
F0101Address Book
F0111Address Book - Who's Who
F0070Country Constants Table

2.3Related Business Functions
Source NameFunction Name
B0100019Get Address Effective Date
B0100031Retreive mailing name
B0100033Get Effective Address

2.4Processing

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szNameMailing	MLNM	char	OPT	NONE
The company or person to whom billing or correspondence is addressed.
szNameAlpha	ALPH	char	OPT	NONE
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.
szAddressLine1	ADD1	char	OPT	NONE
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	NONE
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	NONE
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.
szAddressLine4	ADD4	char	OPT	NONE
The fourth 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.
szAddressLine5	ADD5	char	OPT	NONE
The fifth line of the mailing address in the Address Book system.
szAddressLine6	ADD6	char	OPT	NONE
The sixth line of the mailing address in the Address Book system.
szAddressLine7	ADD7	char	OPT	NONE
The seventh mailing address line in an address.
mnAddressNumber	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szCity	CTY1	char	OPT	NONE
A name that indicates the city associated with the address.
szState	ADDS	char	OPT	NONE
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.
szZipCodePostal	ADDZ	char	OPT	NONE
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.
szCountry	CTR	char	OPT	NONE
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.
szCountyAddress	COUN	char	OPT	NONE
The name of a county, parish, or other political district that is necessary for the address or for tax purposes.
szContactTitle	ATTL	char	OPT	NONE
The professional title of a Who's Who person.
cTypeCode	TYC	char	OPT	NONE
A user defined code (01/W0) that identifies the Who's Who entry. Examples include: A Attention name B Billing C Contact name E Emergency Contact O Other T 1099 legal name
cWhosWhoInformation	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szSalutationName	SLNM	char	OPT	NONE
The name that you would use to address an individual in written correspondence. Examples include Ms. Green, Dr. Strasheim, Herr Obermeyer, Mr. Pitt. The software does not use the value in this field in any reports. It is informational only.
mnWhosWhoLineID	IDLN	MATH_NUMERIC	OPT	NONE
This field is used to identify the line ID number for a Who's Who record.
szConstMailingName	MLNM	char	OPT	NONE
The company or person to whom billing or correspondence is addressed.

B0100019 Get Address Effective Date
B0100031 Retrieve mailing name
B0100033 Get Effective Address

F0070 Country Constants Master File
F0111 Address Book - Who's Who

FormattedAddressWithWhosWho