Vendor Letter Format

Contents ShowHide

The Vendor Letter Format is that of standard business letters. Each letter contains a tracking number in the footer of the first page which prints on all letters generated by the system. Using this tracking number, changes that need to be made to the letters or problems associated with a particular letter can be traced to the proper letter and file in the system.

Merged Fields

Merged Fields within the letter text are represented by descriptive text within double brackets (<< >>). Merged Fields preceded by text in italics indicate that all of the subsequent Merged Fields belong together in place of the italicized table. For example, this:

Recipient <<Salutation>> <<First Name>> <<Last Name>>, <<Title>>
indicates that the Salutation, First Name, Last Name and Title Merged Fields are all part of the Recipient for the letter. A comma will print between the Last Name and Title Merged Fields. The common Merged Fields that exist in many of the vendor letters are described below. The additional Merged Fields are described with each letter. Each of the Merged Fields will print as its literal value, except where noted.

Common Merged Fields

Date / LetterDate - Letter Date

This value is the date the letter was generated. The source for this value is the present system date. The value will print in MM/DD/CCYY format.

Salutation

This value is the salutation for the recipient. The following table describes the source for this value depending on the store type of the Vendor and the Recipient selection on the Send Letter screen.

Recipient	Source for Value
Authorized Agent	The AuthorizedAgentSalutation column of the v_Vendor view.
Store Contact	The WicContactSalutation column v_Vendor view.
All Owners	For Vendors with Corporate Parents, the Salutation column of the v_CorporateParent_Owner view. For Vendors without Corporate Parents, the Salutation column of the v_Vendor_Owner view.

FirstName - First Name

This value is the first name of the recipient. The following table describes the source for this value depending on the store type of the Vendor and the Recipient selection on the Send Letter screen.

Recipient	Source for Value
Authorized Agent	The AuthorizedAgentFirstName column of the v_Vendor view.
Store Contact	The WicContactFirstName column of the v_Vendor view.
All Owners	For Vendors with Corporate Parents, the FirstName column of the v_CorporateParent_Owner view. For Vendors without Corporate Parents, the FirstName column of the v_Vendor_Owner view.

LastName - Last Name

This value is the last name of the recipient. The following table describes the source for this value depending on the store type of the Vendor and the Recipient selection on the Send Letter screen.

Recipient	Source for Value
Authorized Agent	The AuthorizedAgentLastName column of the v_Vendor view.
Store Contact	The WicContactLastName column of the v_Vendor view.
All Owners	For Vendors with Corporate Parents, the LastName column of the v_CorporateParent_Owner view. For Vendors without Corporate Parents, the LastName column of the v_Vendor_Owner view.

Title

This value is the title of the recipient. The following table describes the source for this value depending on the store type of the Vendor and the Recipient selection on the Send Letter screen.

Recipient	Source for Value
Authorized Agent	The AuthorizedAgentTitle column of the v_Vendor view.
Store Contact	The WicContactTitle column of the v_Vendor view.
All Owners	For Vendors with Corporate Parents, the Title column of the v_CorporateParent_Owner view. For Vendors without Corporate Parents, the Title column of the v_Vendor_Owner view.

Person

This value identifies the recipient of the letter and is a concatenation of the fields <<Salutation>> <<FirstName>> <<LastName>>, <<Title>>.

Vendor

This value is the vendor name from the TRADENAME column of the VENDOR table.

AddressLine1 - Address Line 1

This value is the first line of the address that will receive a copy of the letter. The following table describes the source for this value depending on the store type of the Vendor and the Address selection on the Send Letter screen.

Recipient	Address Type	Source for Value
Authorized Agent	Mailing	The MailingAddress1 column of the v_Vendor view.
Authorized Agent	Physical	The PhysicalAddress1 column of the v_Vendor view.
Store Contact	Mailing	The MailingAddress1 column of the v_Vendor view.
Store Contact	Physical	The PhysicalAddress1 column of the v_Vendor view.
All Owners	Mailing	For Vendors with Corporate Parents, the Address1 column of the v_CorporateParent_Owner_Address_Mailing view. For Vendors without Corporate Parents, the Address1 column of the v_Vendor_Owner_Address_Mailing view.
All Owners	Physical	For Vendors with Corporate Parents, the Address1 column of the v_CorporateParent_Owner_Address_Physical view. For Vendors without Corporate Parents, the Address1 column of the v_Vendor_Owner_Address_Physical view.

AddressLine2 - Address Line 2

This value is the second line of the address that will receive a copy of the letter. The following table describes the source for this value depending on the store type of the Vendor and the Address selection on the Send Letter screen.

Recipient	Address Type	Source for Value
Authorized Agent	Mailing	The MailingAddress2 column of the v_Vendor view.
Authorized Agent	Physical	The PhysicalAddress2 column of the v_Vendor view.
Store Contact	Mailing	The MailingAddress2 column of the v_Vendor view.
Store Contact	Physical	The PhysicalAddress2 column of the v_Vendor view.
All Owners	Mailing	For Vendors with Corporate Parents, the Address2 column of the v_CorporateParent_Owner_Address_Mailing view. For Vendors without Corporate Parents, the Address2 column of the v_Vendor_Owner_Address_Mailing view.
All Owners	Physical	For Vendors with Corporate Parents, the Address2 column of the v_CorporateParent_Owner_Address_Physical view. For Vendors without Corporate Parents, the Address2 column of the v_Vendor_Owner_Address_Physical view.

City

This value is the city the address is located in that will receive a copy of the letter. The following table describes the source for this value depending on the store type of the Vendor and the Address selection on the Send Letter screen.

Recipient	Address Type	Source for Value
Authorized Agent	Mailing	The MailingCity column of the v_Vendor view.
Authorized Agent	Physical	The PhysicalCity column of the v_Vendor view.
Store Contact	Mailing	The MailingCity column of the v_Vendor view.
Store Contact	Physical	The PhysicalCity column of the v_Vendor view.
All Owners	Mailing	For Vendors with Corporate Parents, the City column of the v_CorporateParent_Owner_Address_Mailing view. For Vendors without Corporate Parents, the City column of the v_Vendor_Owner_Address_Mailing view.
All Owners	Physical	For Vendors with Corporate Parents, the City column of the v_CorporateParent_Owner_Address_Physical view. For Vendors without Corporate Parents, the City column of the v_Vendor_Owner_Address_Physical view.

ST - State

This value is the state the address is located in that will receive a copy of the letter. The following table describes the source for this value depending on the store type of the Vendor and the Address selection on the Send Letter screen.

Recipient	Address Type	Source for Value
Authorized Agent	Mailing	The MailingStateCd column of the v_Vendor view.
Authorized Agent	Physical	The PhysicalStateCd column of the v_Vendor view.
Store Contact	Mailing	The MailingStateCd column of the v_Vendor view.
Store Contact	Physical	The PhysicalStateCd column of the v_Vendor view.
All Owners	Mailing	For Vendors with Corporate Parents, the StateCd column of the v_CorporateParent_Owner_Address_Mailing view. For Vendors without Corporate Parents, the StateCd column of the v_Vendor_Owner_Address_Mailing view.
All Owners	Physical	For Vendors with Corporate Parents, the StateCd column of the v_CorporateParent_Owner_Address_Physical view. For Vendors without Corporate Parents, the StateCd column of the v_Vendor_Owner_Address_Physical view.

ZIPCode - ZIP Code

This value is the ZIP code for the address that will receive a copy of the letter. The following table describes the source for this value depending on the store type of the Vendor and the Address selection on the Send Letter screen.

Recipient	Address Type	Source for Value
Authorized Agent	Mailing	The MailingZipCode column of the v_Vendor view.
Authorized Agent	Physical	The PhysicalZipCode column of the v_Vendor view.
Store Contact	Mailing	The MailingZipCode column of the v_Vendor view.
Store Contact	Physical	The PhysicalZipCode column of the v_Vendor view.
All Owners	Mailing	For Vendors with Corporate Parents, the ZipCode column of the v_CorporateParent_Owner_Address_Mailing view. For Vendors without Corporate Parents, the ZipCode column of the v_Vendor_Owner_Address_Mailing view.
All Owners	Physical	For Vendors with Corporate Parents, the ZipCode column of the v_CorporateParent_Owner_Address_Physical view. For Vendors without Corporate Parents, the ZipCode column of the v_Vendor_Owner_Address_Physical view.

USERID - User ID

This value is the login name of the user who was logged in the system and took the actions that generated this letter. These initials are recorded as part of the user profile.

Software Version: 2.40.00