Jump to:

Lorillard

Rjrt Third Line Discounting Program Rjrt Wholesalers Guide Keeping Control of Discount Dollars

Date: 13 Nov 2000
Length: 83 pages
99200798-99200880
Jump To Images
spider_lor 99200798_0880

Fields

Author
Butler, L.
Elliott, T.
Type
MANU, MANUAL/CATALOG
CHAR, CHART/GRAPH/MAPS
DISK, COMPUTER DISK
FORM, FORM
Document File
99200500/99200915/R. J. Reynolds 20010000 1st Quarter
Area
WILLIAMS,JIM/OFFICE
Date Loaded
10 Apr 2002
Characteristic
BLAN, BLANK
DRFT, DRAFT
ILLE, ILLEGIBLE
MARG, MARGINALIA
Named Organization
Al
Ansi
At+T
Bbs
Best Buy
Booth Country Mart
Bp Food Mart
Compus
Compuserv
Daily Dash
Egghead Discount Software
Electronic Commerce Support Team
Hotwis
Ht Hackney
Ht Hackney Hunts
Ht Hackney Knox
Ht Hackney Paducah
Ibm
Kenny Pioneer
Lake Side Market
Natl Automated Clearing House Assn
NC
Parkway Market
Pioneer Trading Post
Rj Reynolds Holdings
Rj Reynolds Intl
RJR, R.J.Reynolds
Sesser Sun Mart
Sevirville Conoco
Sports Marketing Enterprises
Sterling Commerce
Tgeon Forge Conoco
Tn
US
Washburn Market
Site
N140
Request
R1-079
Named Person
Allen, R.
Hassler, T.
Sheets, S.
Recipient
Elliott, T.
Author (Organization)
Lor, Lorillard
Reidsville Grocery
RJR, R.J.Reynolds
Recipient (Organization)
Lor, Lorillard
Litigation
Feda/Produced
Brand
Best Value
Camel
Doral
Monarch
Red Kamel
Salem
Vantage
Winston
UCSF Legacy ID
bni94c00

Document Images

Text Control

Highlight Text:

OCR Text Alignment:

Image Control

Image Rotation:

Image Size:

Page 1: bni94c00
This document details how to: • Open the third line wholesaler program. • Record cartons sold to retailers. • Determine discounts and promotions. • Complete the billing summary and e-mail to RJRT for payment. • Upload files to the RJRT system. ~ ~ N O CD. Co O Cy:i Third Line Discounting-RJRT Wholesalers Guide lntmduction • 5 Issued November 2000 . . P~~ / D/1 Q3
Page 2: bni94c00
RJRT Third Line Discounting Program RJRT Wholesalers Guide THE FOLLOWING INFORMATION WAS GIVEN TO: z~ ~c-uGZ~ LORILLARD //:~/, ON 11'_,20 ' (J6) BY: Rj1~ 2,,~rjK AND FORWARDED BY: LORILLARD ~)/i! /~~n..7~ TO THE CORPORATE OFFICE ON: /~yE .L e /' e3 Keeping Control of Discount Dollars © R. J. Reynolds.Tobacco Co. 2000 DRAFT - 11/13/00 05200798
Page 3: bni94c00
Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) Introduction Software Needs Wholesalers who use the third line wholesaler application will need to have access to the following software: • E-mail • Microsoft Excel 97 or later Third Line Process The new Third Line Wholesaler spreadsheet follows this process: • The plan cycles on a monthly basis. The spreadsheet is e-mailed to you from RJRT two weeks prior to the new plan month. • R7RT also sends the spreadsheet to the ROUs for review. • Throughout the month, the wholesaler records the number of cartons sold by brand style, invoice number, and irivoice date; - -_ -- • At the end of the month, the wholesaler e-mails the spreadsheet to RJRT for reimbursement. . . NOTE: If the wholesaler prefers, they can send the spreadsheet to RJRT on a - weekly basis for payment. Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) • 7 IssuetlNovember2000 ' ' py _ Je C 70 ~fJ~
Page 4: bni94c00
File Transfer Direct Communications (Large Wholesaler) 31 Introduction .................................................................................................... .......................... 31 Technical Setup and Support............................................................................................. ......32 Contacting the Electronic Commerce Support Team ................................................32 File Transfer Network Operating Hours .............................................................--.... 32 Software Utilized by RJRT ............................................................... ...... ................... 32 Procomm Plus ...............................:..:..............:.................................................. ........32 HyperTerininal .................................................................................................... ......41 File Configuration .................................................................................................... .46 File Transfer Process .................................................................................................... ............56 Procomm .................................................................................................... ...............56 HyperTerm ina l .................................................................................................... ...... 63 . Accessing Downloaded Files ...............................................................................:...................7 0 Opening a.zip File .................................................................................................... ...............71 Electronic File Transfer (EFT) Payments 75 What is Electronic File Transfer (EFT)? ..................................................................................75 Banking Requirements ..............................................................................................76 EFT Bank Charges .................................................................................................... .76 -' Enrolling in the RJR EFT Payment Program ........ :......................... ........................... 76 EFT Enrollment Form ........................... :........................... ...................... .................. 76 Processing the EFT Enrollment Form .......................................................................76 Changes to EFT Enrollment Information ........................................................---.......77 EFT Questions and Support .......................................................................................77 Contact List 78 Frequently Asked Questions Error! Bookmark not defined. Common Questions and Answers ....... ............... ::.................... Error! Bookmark not defined. Forms 81 EFT Enrol lment Form .................................................................................................... .......... 81 2• Introduction © R. J. Reynolds Tobacco Company 2000 IssuetlNovember2000 %~ 3®~~3
Page 5: bni94c00
3. The wholesaler enters each retail account's off-invoice purchases for the period into the spreadsheet by brand style. 4. The wholesaler e-mails the spreadsheet to WIS for payment. This can be done as often as weekly; it must be done at least quarterly. File Transfer This method will primarily be used by larger wholesalers. Requirements to use this process include: • Communications software (Procomm or HyperTerminal). • PKZip or Winzip software. • Programming expertise to set up the process. With the file transfer process, some initial setup work is required to establish file transfer capability between RJRT and you, the wholesaler. You will also have to setup a process at your site that utilizes RJRT's brand code table and account template files to capture third line sales information and generate invoices. Here's how the process works when using the file transfer method: I. At the mid-month, RJRT transmits the account template and brand code files for the next month. 2. The wholesaler takes whatever action is needed to utilize these files for capturing retail third line sales and processing invoices. 3. Using RJRT's file format, the wholesaler creates an invoice file for third line sales. 4. The wholesaler transmits the invoice file to WIS for payment. This can be done weekly; it must be done at least quarterly. ~ Wholesaler Options Summary Following is a summary of the pros/cons of each method: Excel Spreadsheet Method File Transfer Method • Easy to setup; requires no • More complex to set up; requires programming expertise. some programming expertise. • Inexpensive to set up; requires Excel • Ihexpensive to setup; requires and e-mail. communications software (Procomm or HyperTerminal). • Invoice information must be recorded • Invoicecapmre process can be manually in the spreadsheet. automated by wholesaler. • Spreadsheet file returned via e-mail. • Invoice file returned via file transfer process. 4• lntroduction - © R, J. Reynolds Tobacco Company 2000 . IssuedNovemher2000
Page 6: bni94c00
_ . _ ~_ .. -_Select the bption button beside Open an Existing Third_Line Invoice File Click OK. The RJR Third Line Instruction screen appears: Navigating the Third Line Wholesaler Forms You may navigate to or find any of the Third Line Wholesaler forms by using the Navigation (Goto) button. NOTE: You cannot navigate directly to the Retail Invoice Tracking Worksheef. You must access this screen from the Retail Account List To navigate the Third Line Wholesaler forms: . 1. From any screen, click the Navigation (Goto) button. 2. Select the form you wish to open. The selected form appears on the screen. Instruction Screen The Instruction screen provides a brief overview of the basic steps in using the Wholesaler program. 10 • Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 - - ' ' Issued November 2000 P~~/~?o~d~.3
Page 7: bni94c00
Introduction Third Line Wholesaler Overview RJRT's sales organization recently conducted an extensive evaluation of its retail programs to determine what has value for its retailers. It should come as no surprise that the discounting of full-price and Doral brands are a big part of the value brought to the retail trade. However, retailers consistently communicated that the "lag time" between purchase and reimbursement creates a financial burden. The ability to receive RJRT brands "off-invoice" from wholesalers would be of significant value to retailers. In response, we've detennined that the best course of action is to offer a wholesale- to-retail "off-invoice" program. This program will be offered equally to ALL qualified bonus retail accounts-independents and chains. RJRT plans to leverage this value in return for bonus-level merchandising space and advertising. Wholesalers will be compensated for related costs. There are two methods by which you, the wholesaler, can submit invoices for reimbursement from RJRT. • Excel spreadsheet • File Transfer Excel Spreadsheet - This method is primarily used by smaller wholesalers who may not have the programming staff available to implement the file transfer process. Requirements to ~ usethexpreadsheetprocessinclude: . . ~ • E-mail capability. - N CO. - • Microsoft Excel 97 or later. O. Here's how the process works when using the Excel spreadsheet. method: 1. At;mid-month, RJRT e-mails the spreadsheet for the next month to the wholesaler. 2. The wholesaler uses the information in the spreadsheet to apply the appropriate discounts during the next month. cc O I Third Line Discounting-RJRT Wholesalers Guide . ~ Introduction • 3 Issued November 2000 ,.,. ~ ~ . ~'9 7 b 7
Page 8: bni94c00
Opening the Third Line Wholesaler Spreadsheet To open the spreadsheet: ~'^l 1. On your desktop, double-click on the Microsoft Excel icon. E-a9i If you do not have an icon on your desktop for Excel, do the following: a) Click Start, Programs on the task bar. b) Select the Microsoft Office folder. . c) Select Microsoft Excel from the list. Microsoft Excel opens. , - 2. From the Microsoft Excel menu bar, click File, Open. 3. Click the drop-down arrow beside the Look In field. Lookin: ;} My Documents ~ 4. Find the directory where the spreadsheet is saved. 5. Select the spreadsheet file. 6. Click Open. The Create a New or Open an Existing Third Line Invoice File widow appears. ;o>sk<t ai Option: i~hnre the fhrtv~ Poioter avar ,,ne aF l3'.- Optkm 6 Wlnns ~d CGdc :- . cv~_~ ?1t+NFzr6eztr.bYavcrp-essW+Ef,r4pcnExis!L-Ig 7hirutirm W r, tlphcn -- jC.y]z_ap:_~F_.,vi}rrdirwtr:vci_rFile; Cf.=r,=r,E_x.=trqltiedLirieYrn•1ixF2e ` Select one of the two options: 7. • Create a New Third Line Invoice File - Creates a new third line invoice file. . - - Select the option button beside Create a New Third Line fnvoice File. \,D The RJR Invoice Data File Dates window appears. Enter the starting and ending dates. Click OK. N O O . CC) O The RJR Third Line Instruction screen appears. 01\ • Open an Existing Third Line Invoice File - Opens an existing third line invoice fde. Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) • 9. Issued November 2000
Page 9: bni94c00
Table of Contents Introduction 2 Third Line Wholesaler Overview ........................... .............. .................................... ................. 2 Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) 5 Introduction .................................................................................................... ............................5 Software Needs .............................................. ............... ................................ :.............. 5 Third Line Process .......................... .......... .................................. ................................. 5 Third Line Forms .................................................................................................... .....6 Receiving the Third Line Wholesaler Spreadsheet .......................... ..._................... ....6 Opening the Third Line Wholesaler Spreadsheet........................................................7 Navigating the Third Line Wholesaler Forms ........................................... .............. 8 Instruction Screen .......................................................................................--.---....... ....8 Retail Account List Screen .....................................:....................................................9 Retail Invoice Tracking Worksheet .................................. ................ _........... ~............ I I - RJRT Billing. Summary Screen ................................................................................. 13 RJRT UPC Table .............. ..................................................... :................................... 13 Working with the Retail Account List .....................................................................................14 Introduction .................................................................................................... ...........14 Working with the Account List .................................................................................15 Selecting an Account to Invoice ................................................................................17 Working with the Retail Invoice Tracking Worksheet ............................................................ 18 Introduction .................................................................................................... ........:..18 Entering Invoice Tracking Information .....................................................................18 Editing a Saved Worksheet ........................................................................................22 Using Retail Invoice Tracking Worksheet Functions ................................................ 22 Printing the Invoice Worksheet .................................. :.............................................. 23 Saving the Invoice Worksheet ...................................................................................24 - Exiting the Retail Invoice Tracking Worksheet .....................................................•••24 Working with the RJRT Billing Summary ............................................... :............................... 25 _ Introduction ................................ '............................................................................... ...............25 Updating the RJRT Billing Summary ......................................................... ............... 26 . _ Printing the Billing Summary Worksheet ............................................. ~.................... 27 Finalizing the RJRT Billing Summary ......................................................................27 Working with the RJR Brands/ UPC Table .................................... :.................................... ....28 Introduction .................................................................................................... ...........2 8 Printing the RJR Brands/UPC Table ............................................:............................28 E-Mailing the Billing Summary to RJRT _ ...... ........................................................................ .......28 Introduction .................................................................................................... ...........28 Printing Third Line Wholesaler Reports ..................................................................................29 Introduction .................................................................................................... ...........29 Printing Reports ...............................................................:............:....................... .....29 Third Line Discounting-RJRT Wholesalers Guide Introduction • 1 Issued November 2000 ~~~02 ~ ~~~
Page 10: bni94c00
Third Line Forms The Third Line Wholesaler program has several forms that allow you to track invoices and enter data for reimbursement. Following is a brief explanation of each form. Instructions The Instructions page displays a brief overview of the basic steps in using the Third Line Wholesaler program. Retail Account List The RetaiLAccount List displays the list of retail accounts serviced by the wholesaler. This list will vary from wholesaler to wholesaler. Items displayed on the list include the RJRT SIS #, Chain ID#, brand families, wholesaler numbers, discounts per carton, and promotion start and end dates. RJRT Billing Summary The RJRT Billing Summary displays the total discount for the wholesaler and the amount that should be billed to RJRT. This form automatically populates invoice data as the wholesaler enters discounted items into the spreadsheet. Retail Invoice Tracking Worksheet The Retail Invoice Tracking Worksheet is used to enter invoice numbers and ship dates, cartons sold, and calculate brand totals. RJRT UPC Table The RJRT UPC Table displays brand names, brand codes, UPC codes, and UPC descriptions for all RJRT cigarette brands. Receiving the Third Line Wholesaler Spreadsheet E-mail is the easiest way to communicate with RJRT. Every month, RJRT will e- mail a spreadsheet to you two weeks prior to the new month plan. You are - responsible for saving the spreadsheet to their computer. Since there are several types of e-mail software packages available (such as Microsoft Outlook, Microsoft Outlook Express, AOL, Eudora, etc.) the process for saving e-mail attachments can vary. Refer to the instructions that came with your e- ~ mail program or contact your Internet Service Provider (ISP) on how to save e-mail .. Ur attachments. - • \_0 IMPORTANTI Remember where you save the spreadsheet on your computer. CD You will need to open the spreadsheet from the saved location CD to enter discount data. co O 8• Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 Issued November2ooa
Page 11: bni94c00
® RJRT Brands-Displays cigarette brand families that are eligible for the Third Line Wholesaler program. • Rates-Displays the discounted rate per carton by brand. • Promotion Periods - Displays the promotion start and end date for cigarette brands participating in the third line wholesaler program for the current plan. Promotion periods are established by RJRT, and discounts will only be honored during the specified time period. Working with the Account List Find Account Button The Find Account button is located on the Retail Account List screen. It is used to search for retail accounts by either the account number or account name/address. To use the Find Account button: 1. On the Retail.4ccozint List screen, click the Find Account button. The Find Account dialog box appears. 04 i 2. Select one of the options; Customer Number or Account Name/Address. Customer Number Use this option to search for accounts located in the Wholesaler's Customer Number column. AJhen using the Customer Number option, the system will find only those accounts that contain the numbers you search for. a) Click the option button beside Customer Number. b) Enter data in the Find What field. For example, if you enter 10, the system will find each account containing the number 10. NOTE: You may enter up to six cha_racters when using the Customer Nuinber function. c) Click the Find Next button. d) Continue to click the Find Next button until you reach the bottom of the list or until you find the desired account. e) At the end of the file, the Fsnd window appears. Click OK to return to the FindAccount dialog box. To narrow your search, use one of the following options: ~ Find As Whole Text Only - Not Part of Larger Text. ~~ L0081"t Use this option to find the exact data entered in the FiND WHAT f eld. For example, if you enter 10154, the cursor will only stop at account 10154, Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) • 17 Issued November 2000
Page 12: bni94c00
ffyou are unsure of the approved promotion date, click the Exet & Return button to view approved discountpenod ranges from the Retail Account List screen. 1t a}ni! o L[ t~, ia i i n[ ~?'. 3. Enter the number of cartons sold in the Net Cartons field. a) 22 . Third Line Wholesaler Spreadsheet (Smafl/Mid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 Issued November2000 /~t ~~a2 ® f P3
Page 13: bni94c00
rintin g Third Line holesaler Reports I rotrcductlcsn You may print reports from any screen in the Third Line Wholesaler program. The following repoits may be printed: • Instructions-Prints a high-level overview of how to use the Third Line Wholesaler program. • Retail Account List Prints a list of the retailer accounts you service. • RJR Billing Summary-Prints the billing summary of retail accounts that have completed invoice worksheets. • UPC Table-Prints the RJR Brands/UPC Table. Prifltirag Reports To print a report: . 1. From any screen, click the Print Reports button. 2. Select the desired report from the list. The print preview screen for selected report appears. 3. Click the Print button. The selected report is printed to the default printer. Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (Sma1lM]id-Size Wholesaler) 31 Issued November 2000 ' At'7A '3/b yFgq f2
Page 14: bni94c00
7. Use the vertical scroll bar to review the following information for each account: • Wholesater s Customer number. • Retail account name and address. • RJRT SIS number. • RJRT chain ID number. • RJRT brand family. • Discount per carton. • Promotion start date. • Promotion end date. Following is a description of each button on this screen. Application The Application button is used to create or open existing third line data files. You may also save your work in progress by selecting Save My Work from the drop- down list or export files to your hard drive for use in other applications or databases. Select Account to Invoice The Select Account to Invoice button is used to select the retail account for which you wish to enter cigarette sales (invoice) information. Print Retail Account List The Print Retail Account List button is used to print the list of retail accounts you service. Find Account The Find Account button is used to search for a particular retail account on the retail account list. You may search by the customer number or account name/address. Sort Function The Sort button is used to soi i the retail account list by customer number, account name, state and city, or RTR SIS account number. Print Reports The Print Reports button is used to print reports and tables generated in the Third Line Wholesaler program. ~10 \0 VO O C? C`= O 12 ® Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 p~ Issued,NIovembzpr +2000 _ ~'~~~ F~ 6 9- z~~..3
Page 15: bni94c00
2. Click urn the New Entry icon. The.', '1'' tairectory Entry window appears. L 1~0 3. Enter RJR Tobacco Company in the Name field. Lo 4. Enter RJR Tobacco Company in the Company field. fJ 5. Select the checkbox beside Only Dial Data Number. C=) CD :7: 6 Enter the access number used to transfer files in the Data Number field. . NOTE: You do not have to include hyphens in the phone numbee U~! Ut • If you do not have to dial 9 to get an outside line, enter 18005371939. • If you must dial 9 to get an outside line, enter 9,18005371939. Third Line Discounting-RJRT VVhoiesalers Guide File Transferdirect Communications (Large bVholesaler) • 37 Issued Navember20aa
Page 16: bni94c00
Find AII Occurrences Starting With What Is Specified in Find What Box Use this option to find accounts that begin with data entered in the FIND WHAT field. For example, if you enter 10, the cursor will only stop at accounts that begin with 10. . Account Name/Address Use this option to search for accounts that contain information from the RETAIL ACCOUNTADDRESS column. When using this option, you can search for account names, the city, state, zip, contract, or plan. a) Click the option button beside Account Name/Address. b) Enter search data in the Find What field. This field is not case-sensitive. For example, if you enter shop, the cursor stops at each account with the word "shop" in its title. c) Clickk the Find Next button. d) Continue to click the Find Next button until you reach the bottom of the list or until the desired account is found. . e) At the end oPthe file, the Find window appears. Click OK to return to the Find Account dialog box. Sort Account Button The Sort Account button is located on the Retail.4ccount List screen. It is used to sort various columns on this screen. To use the Sort Account button: 1. Click on the Sort button. The Sort Retail Account List window appears. 2e Select one of the four options: . - • Customer Number - Sorts the list by customer number. account name list b S rt th A N i • • . e ame - o s ccount y State and City - Sorts the list by state and city. 912 '~0~1~, ® RZRT SIS Account Number - Sorts the list by RJRT SIS account number. 3. Click OK. 18 • Third Line Wholesaler Spreadsheet (SmalUMid-Size Wholesaler) G R. J. Reynolds Tobacco Compary 2000 Issued November 2000 fff .,~~ ./~- sa/' R-3
Page 17: bni94c00
Working the J T illin um a Introtiuction After all data has been entered on the Retail Invoice Tracking 6Yorksheet, you are ready to open the RJRT Rilling Samnnary screen. This screen provides a summary of all data entered on the invoice tracking worksheet. Review information in the following fields: • Wholesaler's Customer Number-The wholesaler's assigned customer nuniber. • Retail Account Name-The retail account number. • R.TRT SIS Numbe'-RJRT's assigned 515 number. • RJRT Chain ID (where applicable)-RJRT's assigned Chain ID number. • Invoice Date-The date the product was shipped. • Invoice Number-The assigned wholesaler', invoice number. • RJRT Brand-The RJB.T brand name. • Carton Rate-The rate of discount per carton. • Net Cartons-The number of cartons shipped and discounted. • Retailer Billed Amount-The amount of rebate money. • D/A Fees-Direct account fees (or bonus dollars) paid by RJRT to wholesalers. • Total RJRT Billing Amount-Total retail billed amount plus the D/A fees equal the total RJRT billing amount. A check will be cut and sent to the wholesaler for this amount. Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (Small/Mid-Size~Wyholesaler) • 27 IssuedNovember2000 s..~„v,~ ~'9~, ®¢ a%~ d ^d°/` 9 ~l
Page 18: bni94c00
The list is sorted according to the option selected. Printing the Retail Accocrrrt List To print the retail account list: 1. On the Retail Account List screen, click the Print Retail Account List button. A print preview of the RetailAccozrntList appears. J~.fedesw~n .IF!{~;rFS11':Ufde i Jot.r.r_.5 s „v~ 1x-e:~ . 9338d6iM11 nUE1rn CEPLYdTRY MART 195$ HIGHrVJAY 82Vtl PStA'eNl LLE, Ay860B7.7927 6D6251 CAML S4.Cq ad3J WNSrRN $3.75 SS.Ca G4NAL $3.51 $s.R] XU 3i.fA 2. Click the Print button. The Print dialog box appears. 3. Click OK. The list is printed to the default printer. SeIecting an Account to Invoice In order to receive discounts for participating third line cigarette brands, you must enter invoice numbers, ship dates, and select brand information for each retail account. Retailers are selected from the Retail Account List and information is entered on the RetailGrvolce Tracking Worksheet. ' To select an account to invoice: 1. On the Retail Account List screen, position the cursor anywhere in the shaded area of the retail account for which you want to apply the discount. ~x-17t91R tT.KESFEtE MA1E9tE9'._. .. . 375076 4949 Hlt~ria'#rWY33S . . 2. Click the Select Account to Invoice button. The Retail lnvoice Tracking Worksheet appears. 99200816 Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (SmallMPid-Siz/e3Wholesaler) = 19 IssuedNovemGer2000 ~~~q~C',
Page 19: bni94c00
+P' Y.:, - .-.•.~. .,reaJTn+scxeon~a..n;qre..urv To obtain a quick overview of using the third line wholesaler program: 9. Use the vertical scroll bar to review the following sections: • Copy Retail Account Extract File to Processing Sub-Directory. • Using the RJRT Third Line Discounting Program. 2. To view more in-depth instructions, click Help on the menu bar for the screen in which you need to obtain additional help. Retail Account List Screen The Retail Account List screen lists the retail accounts serviced by each wholesaler. Depending on the size of the wholesaler, this list may contain several accounts or a few. This screen is used to select the retail account for which you wish to enter cigarette sales. 1. Click the Navigation (Goto) button, and select Goto Retail Account List. The Retrail rlccomn List screen appears. - -~ . . _„, Lc-'~ , ~" eM„ir ~ .- ,al l-i:Lrr] E;JR'r P.nus C' r r v.r , aet_ml AL~ounf L!q • Der a~7F% - _ Frriia::fnifCYJ'71iF5.. .. E ,c;.B i.JFt'.tiudylF no.:12`Jl'?7.=-/_'Jr5 r,"~a lhr.~ Es °sal rn:alf/:,crn+:RwSU< ~}:,i; [ IifFl'?I:m~htll _ ~ hw.~~ .: F . . 6 asACt~,u Jnd~c 1 h-. IJa'-~ Fi .~f'onelu ~_r v 1~ ~i I' _ 10.<330+ot CYTN[pYpBdTkYIddBT . i 173 VMHdJAY 2..'X ~ ~. ~. . - . , , _-'TI'; o I E,,".L.SGE67-7B: ~. $. pp 12':.a d t7 17i1 € 0 ~I.;uJ 9?l #3.75 a.JSd67 131a $4.09 12flaM ..12r ..ye.sfi 12aSAU3~ 12j" db.5~ i2,±:4,Lq 12i1 127181C1 t?% .g5.01 ~ _ 1 93.75 s2,L'-1~'117 -1:5 .. St.@0 12tILLffiJ . 1?k Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) • i 7 Issued November2006
Page 20: bni94c00
2. Click the Print Worksheet button. A print preview of the Retail Invoice Tracking Worksheet appears. T_7::D< ,i, - 3. Click the Print button. The Print dialog box appears. 4. Click 0K The list is printed to the default printer. Saving the Invoice Worksheet To save entries on the invoice worksheet: 1. Enter data on the invoice worksheet. 2. Click the Save Invoice Worksheet button. The worksheet is saved, and the Retail Account List screen appears. Exiting the Retail Invoice Tracking Worksheet You may exit the Retaillnvoice Tracking Worksheet at any time when entering invoice data information. To exit the Retail Invoice Tracking Worksheet and return to the Retail Account List: 7. Click the Exit and Return button. The Exit Invoice Worksheet message box appears. 2. Tf you wish to save your invoice changes, click Yes. If not, click No. ' The worksheet is closed, and the Retail Account List screen appears. 26 • Third Line Wholesaler Spreadsheet (SmallfMid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 - p/1ry Issued ~Njo~vembe~r'!200(~0~ d •~7s6 /3'fi'
Page 21: bni94c00
Brinting the Bllling Summary Worksheet To print the billing summary worksheet: 1. Click the Print Billing Summary button. A print preview of the RfRT Billing Sumnaary appears. 3. Click the Print button. The Print dialog box appears. 4. Click OK. The summary is printed to the default printer. Finalizing the RJRT Billing Summary There are two entry fields on the RJRT BiUing Szcnnnary screen: ® RJRT Invoice Number. ® RJRT Invoice Date. Data must be entered on this screen before the billing summary screen is complete. To complete the RJRT Billing Summary screen: 1. Enter the RJRT invoice number in the RJRT Invoice Number field. 2. Press the Tab key. 3. Enter the RJRT invoice date in the RJRT Invoice Date field. 4. Click the Save My Work button. The billing summary is saved. Third Line Discountrng-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (SmalllMid-Size~- qWholesaler) • 29 Issued November 2000 ,¢s. / . e .3~
Page 22: bni94c00
3. Enter RJR Tobacco Company in the Name field. NOTE: If you want to change the icon to something other than the one selected, choose one from the Icon field. 4. Click OK. The Connect To window appears. , :~leqyA~~`T .:~ .......-„ I 5. Delete the area code that appears in the Area Code field. 6. Enter the access number used to transmit data files in the Data Number field. NOTE: You do not have to include hyphens in the phone number. • If you do not have to dial 9 to get an outside line, enter 18005371939 • If you must dial 9 to get an outside line, enter 9,18005371939. 7. Your modem should display in the Connect Using field. If it does not, select it from the drop-down list. . . 8. Click OK. 44 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 Issued November 2000 e ~~ a-? ¢~~
Page 23: bni94c00
Retail invoice Tracking Worksheet IMPORTANT! This screen can only be accessed from the Retail Account List screen. The Retail Invoice Tracking Worksheet is used to invoice information for cigarette brands that are eligible for discounts and track the number of cartons sold. This screen works in conjunction with the RetaiZAccount List screen. To access the Retail Invoice Tracking Worksheet: 1. On the Retai! Account List screen, position the cursor anywhere in the shaded area of the retail account you want to apply the discount. X-i111YY ~ LAKE c[t11:1+Gk9EKET. .. . ~ 323076 .. . . . . . . Y S 4940 HI61aWA 33 . .. 6+lt<VJTA.i'E1N'"cL'e„ Yls. -'1 ... . ,. 2. Click the Select Account to Invoice button. The Retail Invoice Tracking Worksheet appears. ~ t :19[tv.,tca. 7rach ing vYotks: set : f'efa' aunt`'vm ]'~4i:,:7E~ Izt t~}eT ,JnfS9Sr_ d't4t .i rRr.rr~;7.'.:rz=al:i<D~ ._nvornm3icmbrr iaPF~A~J1 .-ee3~R: R.lR~4.~.plsrr~~i ImGiSeKeps tr~icet5nriner:oRelailer.:' lrMmicebxte: .Imm2K?1s IrrroiceWurulrertoRetai 1 0rand Hanre CAalSL F,Si: FTt7: ~ Fb': F11: ~ F7: 1 ' ... _ Ft2: C Code nPC Desc. I lovaise 0 12aJUtG173 97S1btCu13 12?11O20393 9T31a5nA13 13Y}UtGy13 t?iJO,G'+19 G+MEL PVF 70 CnRiELFESSP CAMEL F ES HP CA69EL LT F 86 SP CFtAELtTF7Q0 e. MEL LT Fas HP Ca€1nn Cannn U[scountd Irovolce®ate 6]tsef8ate quontiYy pietezGtn. Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (SmalilMid-Size Wholesaler) • 13 Issued November2tl00 ' #'' k*3~y /6' PT~ ~' ~ l..r,` ~
Page 24: bni94c00
The Connect window appears. 9. Click the Modify button. The RJR Tobacco Company Properties window appears. . ... ; ;~ ,. u-T . ... ... .. ... .... .. ......... _.. .. ... .~W..i 10. Deselect the checkbox beside the Use Country Code And Area Code field. 11. Click OK. 12. Click Cance;. The RIR Tobacco Company Properties window closes. 13. On Lie iool bar, choose File, Exit. The FlyperTerminal window appears asking you to save the changes. Third Line Discounting-RJRT Wholesalers Guide Issued November 2000 File Transfer Direcf Communications (Large Wholesaler) . 45 ~ Ja
Page 25: bni94c00
YitOt&I/P C8+c.6 ift- . Bllled Pmn. RrandN-m. UF.-. .. . dOrtsx.t 8mm%ceM 1mwkm Pats Ra"s Hnm;.ir l!~tXY:crs.-5 CAH _ ~ j~iU!U313 n 1EL` "'fiP~ ~ ~ {7ml~mn I:+uFi,t ~ ' 7 4l NOTE: For more information on the Retail Invoice Tracking Worksheet, see page 18. ----orkin with the Retail invaice Tracking arksheet Introducti®n Ih7PORTAPdT! This screen can only be accessed from the Retail Account List screen. For instructions, see page 14. The Retail Invoice Tracking Worksheet is used to record invoice information for the currently selected account. This includes: • Carton quantity by brand. • Invoice number of the invoice sent to the retailer. • Invoice date of the invoice sent to the retailer. This screen works in conjunction with the Retail Account List screen. Up to ten (10) invoices can be entered on the Retail Itivoice Tracking Worksheet. In order for you to receive reimbursement for cigarette discounts, you must fill_ out the Retail Invoice Tracking worksheet. Required data entries include invoice numbers, ship dates, and selected cigarette brands shipped to retailers. When entering invoice numbers and dates, you will also use the function keys located at the top of your keyboard. Entering It'voice Tracking Inforrrration When entering invoice tracking information, follow this basirc process: Step 1: Enter the retailer's invoice number and date for the products that were shipped to the retailer. Step,2: Select the cigarette brand that was discounted from the RIRT BraancUUPC Table, and enter the number of cartons discounted. Repeat for other brands. Step 3: Save the worlcsheet. 20 ® Third Line Wholesaler Spreadsheet (SmalUMid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 ~ Issued November 12a~ao
Page 26: bni94c00
There are four meta key sets, which each contain ten buttons. Meta key sets can be accessed using the following key sequences: • ALT key • ALT + SHIFT keys • ALT+CTItLkeys • ALT + SHIFT + CTRL keys You may view pre-set buttons i7 the four key sets by clickina on the ALT key located on the button bar at the bottom of your screen or use the key sequences listed above. Pre-set buttons for each key set are displayed on the button bar at the bottom of your screen. : 11 Creating a Meta Key To create a meta key: 1. Press ALT + M on your keyboard. The Procomm Phis Meta Key Editor screen appears. , .,.~,........~.,c.. .~ : a .`m." ._I Key sets are displayed beside the Action group. You may create keys in any of the four lcey set groups. " Third Line Discounting-RJRT Wholesalers Guide Issued November 2000 . '.. ...._ N_....u...t; ...._,;n .._ ..................._} ~.m ~ __:_~ i File Transfer Direct Communications (Large Wholesaler) • 39 - :_?e 6 1',?3
Page 27: bni94c00
RJRT Billing Summary Screen The RJRT Billing S arunary screen is used to display invoiced discounts for each retail account by cigarette brand. The only entries that are required on this screen are the invoice number and the current date. NOTF_: lnitially,-this screen will not have any invoice entries. Af7 invoices entered on the Retail Invoice Tracking Wod<sheet are automatically calculated and posted on the billing summary screen. Once entries have been calculated, they cannot be changed on this screen. Any changes to entries on the billing screen must be completed on the Retail Invoice Tracking Worksheet. 1. Click the Navigation (Goto) button and select Goto RJRT Billing Summary. The RJRT Bflling Szmmnafy screen appea s. rz.,- ,-j-,,...._._.... . . . :;,e1r„1-.a~.e.on... tz^s~m-r~ .r.. ~ ~,. ..._~...~ apA .a .. [x,.. . .t.-t~. '. ..s , F 4i ~ 4 I 1 1 6.m?I ~ nm. I L.a 2. Use the vertical scroll bar to review the following fields: • Wholesaler's Customer number. • Retail account name and address. ® RIRT SIS number. • RJRT chain ID number. ® RJRT brand family. • Discount per carton. • Promotion start date. • Promotion end date. RJRT UPC Teatsie The RJRT UPC Table displays the UPC codes and descriptions for RJRT cigarette brands that participate in the third line wholesaler program. Not all RJRT cigarettes are discounted in this program. Participating brands include varieties of: • Camel • Doral • Salem • Vai'ttaee• Winston • Monarch • Best Value 99.000812 Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) » 15 Issued NovembEr 2000
Page 28: bni94c00
orkin ith the J rands! UPC 1"able Introduction The RJR Brands/UPC Table is a view-only screen and cannot be changed. You may view the following information from this screen: ® UPC Codes. • UPC Descriptions. • Brand Codes. • Brand Code Descriptions. The only function available on this screen is the print function. Printing the RJR Brands/UPC Table To print the UPC table: 1. Click the Print UPC Table button. - A print preview of the RJR BrandslUPC Table appears. 2. Click the Print button. The Print dialog box appears. 3. Click OK. The table is printed to the default printer. .- ailing the illin um ary to RJRT Introduction ~ 0 After entering invoices on the Retail Invoice Tracking b6'w•lcshee; you must e-mail ~ the discount file to the Third LineHelpdesk at thirdline(a?rG'i.com. You will receive a confirmation via e-mail that your file has been received. ~ 30 a Third Line Wholesaler Spreadsheet (SmalllMid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 . Issued November2000 ~le _?O m -.P 0f'3
Page 29: bni94c00
3. The screen is divided into three parts. Use the vertical scroll bar to review the following information: • Retail account information-The following fields are automatically populated with information imported from the Retaf! Aecount List screen. - Retail account name - Wholesaler's customer nnmber - R.TRT SIS number - RJRT Chain ID (if applicable) • Invoice data entry fields-Use these fields to enter retailer invoice numbers and ship dates. • Cigarette brand style selection area-Use this field to select cigarette brand products shipped to retailers. Following is a description of each button on this screen. Functions The Functions button is used to clear the worksheet, delete rows, and calculate brand totals for the current worksheet. - Save invoice Worksheet The Save invoice Worksheet button is used to save the current worksheet. Exit & Return The Exit & Return button is used to exit the spreadsheet and return to the Retail Account List screen. Print Invoice Worksheet The Print Invoice Worksheet button is used to print the current worksheet. to your default printer. Retail account [--~ -____ g y:,_.- .-..,J T r s.zr.-R,'uiAuF Rdf ._E.,+ r,'[.i;s F3:I-~_.. . Invoice data I--[~ Fn. I-._.._._....._.__...__m_m___._l_..._~ . . flo: an4nificlds I I Fb: I p I .. rn: ! 6rand Name Cigarette brand style selaction area I3i Ca18an 1nv.atcetlate ®FseRzte L319aa1 n13COIJntAA15@. La9f309{ly ({fdeXCVa.L[y.) CJadd£L 17SO.C173 GahIEL. PJF 79 Ixat9tI7J7Z C6+PdEL F 4.9 sP 123MSCt393 C4R9EL F E5 HP 12e?34N4177~I CAOdEl.1.TFin$P 12at0SC513 C++MELLT F 100 ~ 1211010713 :',a69EL t.T F 85 HP 1 1 9 14 . Third Line Wholesaler Spreadsheet (SmalUMid-Size Wholesafer) © R. J. Reynolds Tobacco Company 2000 Issued November 2000 AJe 1~'®r",?- 3.
Page 30: bni94c00
- Number of records in the file. - Filler information. • Invoice Detail Record-The invoice detail record displays the following items. - Record ID. RJR SISS wholesaler name and number. - RJR SIS retail account number. - Wholesaler Supplier number. - Filler information. - Wholesaler Invoice Number to RJR*. - Wholesaler Invoice to RJR Date*. - RJR Account Chain ID. - Account name, address, city, state, zip. - Brand family code. - RJRdisplay code. . - UPC Code*. - Discount rate. - Quantity shipped in cartons*. - Quantity shipped sign*. - Discount amount". - Discount amount sign*. . - Allowance amount*. - Billed amount*. - Billed amount sign*. - Start and end date. - Retail account invoice number*. - Retail account invoice date*. 54 • File TransferDirect Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 . Issued November 2000 /)r
Page 31: bni94c00
7. Ensure that the following information has been selected: • DATA GONNEC71®N-(Your modem type) For example, ThinkPad Modem. • TERMINAL-ANSI BBS • PROTOCOL-Zmodem Your completed screen should look similar to the following example. 8. Click OK. The Connection Directowy window reappears. 9. Click OK. The Procomm Plus Terminal screen appears. Meta Keys Meta keys are buttons which are displayed by default at the bottom of the terminal window. You can configure meta keys to: • Run programs, including Windows applications. • Execute a command from the Procomm Plus rnenu. - • Generate special terminal emulation key sequences. For example, if you want to set a meta key to perform a sequence of keystrokes, you `-0 can automate this taslc by configuring a meta key to perform this action. `0 i'Q Meta keys are stored in files with a.key extension. Each meta key file contains four d sets of buttons and each set contains ten buttons. You can easily toggle between each =) set of buttons by pressing ALT or by clicking an the button located in the button bar Cc at the bottom of the screen. .~ 35 • File Transfer Direct Communications (Large 'vVholesaler) © R. J. Reynolds Tobacco Company 2000 Issued November 2000 ~~s~ 3 7 a -,r ?3
Page 32: bni94c00
- RJR display code. - Start and end date. - Discount rate. • File Trailer Record - The file trailer record displays the following items: RecordIp. File name. Number of records in the file. Filler information. Account Template File Definitions It is recommended that a technical person in your organization define field requirements for each template file. The list of field defmitions for the Account Template File are listed below: File Specifications - • Record is fixed length of 192 characters • File contains 3 record types: I-header, 2-detail, 3-trailer Account Template File # Data Element Format Length Position Notes *` File Header Record* One Header Record Per File . . rr 2 FiteName A 20 3 value'ACCOUNT TEMPLATE' 3 Data File was created N 8 . 23 yyyynrmdd - 4 Time File was created N 7 31 hhmmsst hh=hour. mm=minutes, ss=seconds, t=tenths of second 5 Filler Record Length A 155 192 *" Detail Record** 6 Record ID A 2 7 RJR SIS Wholesaler Number N 6 8 RJRSIS Wholesaler Name N 6 38 1 3 3 9 RJR SIS RETAIL Account N 6 34 Number value'01' 10 WholesalerSttpplier.Number A 10 40 11 Filler A 10 50 12 RJR Account Chain ID . A - 8 60 13 Account Name A 25 68 14 Account Address Line I A 20 93 15 Account Address Line I A 20 113 16 Account City . A. 15 133 Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 51 Issued November 2000 ' . . - P ~99200 R7
Page 33: bni94c00
Invoice Detail File •. After downloading the UPC Code Table and Account Template files, discount payment data from accounts that have participated in the third line program is ready to be uploaded to RJRT. RJRT requires that discount payment data be compiled into the Invoice Detail file format. Some of the information contained in the Invoice Detail file is also contained in the original template file. This data must be transferred to the Invoice Detail file for processing at RJRT. You can identify these fields by field names that appear in the Account Template file which are identical to the field names in the Invoice Detail file. Additionally, you are responsible for inserting your wholesaler billing data for the following fields: • Wholesaler Invoice Number to RJR. . - RecordID. - File Name. - Number of records in file. - Filler information. - Record ID.. - File name. - Date and time the file was created: . Filler informatiou. ~ • File Trailer Record - The file trailer record displays the following items: • Wholesaler Invoice to RJR Date. • UPC Code. • Quantity shipped in cartons. • Quantity shipped sign. • Discount amount. • Discount amount sign. • Allowance amount. • Billed amount. _ • Billed amount sign. • Retail account invoice number. • Retail account invoice date. There are four record types in the Invoice Detail file: NOTE: Items with an asterisk (*) represent fields that you are responsible for entering into your template. • File Header Record - The file header record displays the following items: Invoice Totals Record- The invoice totals record displays the following items: - Record ID. - File name. Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 53 . . Issued November2000 , - 1~~£ 9 -Z ®.P e-3
Page 34: bni94c00
The Receive File window reappears displaying the selected directory. 6. Click Close. The Receive File window closes. 7. Choose File, Exit from the menu bar. The HyperTerminal application closes. File Contiguration UPC Code Table On a monthly basis, you are responsible for downloading two files from the RJRT system: the UPC Code Table and the Account Template file. The UPC Code Tablc- file defines the participating cigarette brand styles that should receive the discounts for the month. Brand styles not contained in this listt must not be discounted. Prior to viewing the UPC Code Table, you must configure a spreadsheet or data file according to the definitions outlined in the template. There are three record types in the UPC Code Table file: ® File Header Record-The file header record displays the following items: - Record ID. - File name. - Date and time the file was created. - Filler information. • UPC Table Record-The UPC table record displays the following items: - Record ID. - Brand family code and name. - UPC code and description. . ~ Ln •, File Trailer Record-The file trailer record displays the following items: 1~7 Record ID. C ~ - File name. ~ 41- - Number of records in the file. - Filler information. 4~1 48 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 . Issued Tlovem6er 200q
Page 35: bni94c00
Introduction File transfer is a process that allows wholesalers to send billing summaries to RJRT electronically. Wholesalers find tttis process less cumbersome than having to manually enter data onto a spreadsheet and e-mail the file to RJRT. Also, by electronically transferring data files to RJRT, the process expedites payment to you, the wholesaler. Checks can be dispersed quickly, or if you choose, a payment can be made via (Electronic Funds Transfer. also called Direct Deposit). Wholesalers also have the option of billing RJRT weekly or monthly. The file transfer process is as follows: a) Two files (UPC Code Table and Account Template) are electronically transferred to you from RJR.T once a month. b) You load the files into your Order Entry system or comparable program for ordertrackingr c) Orders are automatically posted to the account template data file as they are entered. ~ d) On a weekly or monthly basis; you take discounted file data and compile it intcti ,,D an Invoice Detail file. This file is electronically transferred back to RJRT for C-) payment. (73 C^ e) The data from the Invoice Detail file is verified and submitted for payment ~J processing. ~j Wholesalers that currently use the spreadsheet format may elect to change to the file transfer function. Sales representatives from RJRT will set you up to file transfer payments to RJRT. The following section, Technical Setup and Support, provides technical setup and support information, which prepares you for uploading and downloading files. We Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 33 Issued November2000 - 90~6 ?Q cf ~''~
Page 36: bni94c00
UPC Code Table File Definitions It is recommended that a technical person in your organization define field requirements for each template file. The list of field definitions for the UPC Code Table are listed below. File Specif:cations ' . • Record is fixed length of 56 characters • File contains 3 record types: 1-header, 2-detail, 3-trailer UPC Code Table File # Data Element Format Length Position Notes ' File Header Record'"' One Header Record Per File D r0 2 File Name 3 Data File was created A 20 N 8 4 Time File was created N 5 Filler Record Length "UPC Table Record'' 6 Record ID 7 Brand Family Code 8 Brand Family Name 9 UPC Code 10 UPC Description Record Length "File Trailer Record** I 1 Record ID A 19 56 A N 2 4 A 20 3 value'UPC TABLE' 23 yyyymmdd 31 hhmmsst hh=hour, mm-ninutes, ss=seconds,t=tenths of second 38 3 7 value'01' N 10 27 Multiple UPC codes per Brand Code A A 20 56 2 37 12 FileName 20 3 13 # of records in file 7 23 14 Filler 27 . 30 Record Length , 56 One Trailer Record per file value'99' value'UPC TABLE' Count includes header and trailer records (all records) Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 49 Issued November2aoo
Page 37: bni94c00
recommend that you select a technical person to review and complete the setup process of file transfer on your network. Technica9 Setup Support Contacting the Electronic Commerce Support Team The Electronic Commerce Support Team is available to assist you if you should have problems or questions implementing the communications process. To contact the Electronic Support Team, call or e-mail: Team Member Phone Number E-mail Address Richard Allen (336) 741-3537 al lenrOrlrt.com Tim Hassler (336) 741-3732 hassletrr,rjrt.com Hours of Operation Support personnel are available from 7:30.4M to 4:30PM (EST). Monday - Friday. For after-hours assistance, call the Hotline at (800) 822-2011. You may access the Hotline 24 hours, 7 days a week. When you call the Hotline, please supply your assigned Remote ID and the communioatons number you are dialing. File Transfer Network Operating Hours The RJRT file transfer network is available between 2AM to I 1pNt (EST), Monday- Fri-day. So are Utilized by RJRT R3RT uses the software listed below for file transfer processing: Software Vendor Package Usage Sterling Commerce GENTRAN File Transfer Translator Sterling Commerce CONNECT Mailbox Communications `~ .~r} N C -D Procomm Plus C-) co Purchasing ~ Procomm Plus is an ofE the-shelf communications package, which may be purchased via mail order or through a retailer such as Best Buy", EggHead Discount Software',, or CompUSAk. Procomm Plus costs approximately $150. You should purchase Procomm Plus 32 for Windows 95 or Windows NT. 34 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 IssuetlN~ovembe~r2J000 ~p,,~~ d' °gi~ '-2-~y a~° C943
Page 38: bni94c00
7. Click OK. The IvSeta Key Editor window closes, and the edited button appears on the button bar at the bottom of your screen. 8. Repeat steps 1-6 to edit additional meta keys. Deleting a Meta Key To delete a meta key: 1. Press ALT + M on your keyboard. The Frocomm Plus Aleta Key Editor screen appears. 2. Determine the key set you wish to edit. Ir~: li..i'lCa L~9~.1 ~,dInIF,7Ple0 3. Select thc h-_ ~c~ wnn~ :o cr'iL i7"m the Meta Key Saler,t group. SeYciu_,'., i11r rh.: L'urt''a.Nhear in ih 6 ~- ~.;ur u --._--_ _ P.: Ac;iurI ~ "~ ~ !'t§ lf '0_j{1}rl' [gT ~`rJ11iC1€ 4. Select Unmapped from the drop-down list in the Action field beside the key set you are editing. ;:er ~TeHl:dEct:a Run~, jRunProgrsn .,~ 5. Click OK. Ail key mappings for the selected key are removed, and the button appears blank in theb_ttton bar. 42 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 Issued November 2000 q
Page 39: bni94c00
2. Choose View on the toolbar. The View drop-down menu appears. 3. Ensure that a checkmark appears beside Quick Select Line. If it does not, select it from the list. 4. At the bottom of the Procomm Plazs screen, verify that the following items are correct: • The first box (from the left) displays ANSI 9SS. If it does not, click on the box, and select it from the list. • The second box displays ZMODEM. If it does not, click on the box, and select it from the list. • The third box displays your modem type. If it does not, click on the box, and select your modem from the list. Creating a Phone Book Entry To eliminate having to manually anter the phone number to dial RJRT, you can create a phone book entry to quickly access and dial the phone number for you. To create a phone book entry: 1. Click on the Connection Directory icon in the toolbar. The Connection Drrectoq window appears. 36 • File TransferlJirectCommunications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 I^sued Navember 2000 - fYu
Page 40: bni94c00
Buttons that have already been mapped to a function appear in the Action field beside the specified key set, along with the description of the function and the button label name. 2. Working with the ALT key set, select an unmapped meta key from the Meta Key Select group. The Meta Key Select group displays a key for each button in the key set. nra.pp ~d bi .nui dirpl il`,e LALE~ iicic `p I €I Ir ..pp:-: .' I t , l-:n i?1~ ic iae r., iEA:TS and 3. Select an action from the drop-down list that you want to associate with the unmapped button. Available actions are: • Send Text-Automatically transmits the characters you have entered in the Contents field. • Text wlEcho-Works similar to the "Send Text" action. This action echoes text to the terminal display as it is sent to the host if your port setting is set at hal£ duplex. • Run Script-Executes a script that is entered in the Contents field. • Run Program-Executes an external Windows application or DOS program. If the program you want to run is a.exe file, do not specify the extension. Enter a file extension for all other file types. If the program is not in your DOS path, specify a drive and path name. • Menu Command-Executes any action from a Procomm Plus menu. When the key is pressed, the associated menu item executes as if it were selected from the menu bar in Procomm Plus. • Terminal Command-Creates "special keys" for certain terminal emulations. When you select "Terminal Command" as an action, you must select an emulation and special command from the Contents drop-down menu. 4. Enter or select the script, program file name, menu command, or terminal command in the Contents field. For example, if you want to have the syntax entered at the command line to upload a file, enter $$ADD ID=(your user ID) BID=(third line vaho!esaler file name). Your screen should look similar to the following: cn~'exP-_._:..~_ :~Hi~.k J~1-~€Vll r i I1L IV(l4":-. ~ ` --~-~ . ..~. „ ._: ...... --e. .. . . 5. Enter _, n,~ine for the buttoh in the LABEL field. 40 • File Transfer Direct Communications (Large W'holesaler) .© R. J. Reynolds 7 obacco Company 2000 ~ Issued November 2000 ~ d~E-s3;7 a ~ rE?
Page 41: bni94c00
NOTE: You may enter up to ten (10) invoices on one tracking sheet. Following are detailed instructions for each step. Step 1: Enter invoice tracking information. 1. Position the cursor in the F3 Invoice Number To Retailer field. 2. Type the retailer's invoice number from the invoice sent to the retailer. Keys: Invoice Number to Retailer: F3: 1489183577 3. Press the Tab key. 4. Enter the date in the Invoice Date (Shipped) field using the MM/DDIYY format. The date should represent the date the products were shipped to the retailer and must be a valid promotion date approved by RJRT for the selected cigarette brand family. NOTE: Approved promotion dates are displayed on the Retail Account List screen. Invoice Date: (Shi ed 091-27.C0 Step 2: Select the cigarette brands. 1. Click on the cigarette brand from the RJRT Brand/UPC table and press the corresponding funetion key. Brand Nanee Ui3C Code Brand Desc. I Invoice g GA1Y9EL 11230010113 CAPv1EL NF 70 ~ '1230010213 CANIEL F 85 SP 1230010313 CAMCL F 85 HP __ 12 10413 CAhAELLTF85SP 2. Press F3 to select. IMPORTANT! When entering invoices, select the corresponding function key to select the brand product. For example, if you are entering an invoice for the F4 field, press Fa to select cigarette brands from the RJRT Brand/UPC table. If you are entering an invoice for the P5 field, press F5, etc. You can . have only one invoice for each function key. An invoice row is inserted under the selected brand. and the Invoice Carton Rate, Net Cartons, and Billed Amount fields are automatically populated with RJRT discount data. Invoice row Net Cano~es €a~taie i.:hwavi- HSOadMa_ RaFS R~lurar 4'•~P3taHtlml 1'331e~' ` O-vJtits= 0 NOTE: If the ship date is outside the discount period, the No Discount Available error message will appear. Click OK to close the window. Correct the invoice date, and repeat Steps 5 and 6 again. Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (SmalllMid-Size Wholesaler) e21 Issued November20D0 /~~f ~7df L, /' ~`~
Page 42: bni94c00
HyperTerminal opens and displays the Connect window. 2. Click Cancel. 3. Select the Receive button on the toolbar. The Receive File window appears. 4. Click [rr 'L,~"i•'=-,i-~'l! . - Y^.-rp3_P ~ ,--~-- _ ~ ~ ~ ~TF --j :-.~H I I 5. Browse to the folder you want to designate as your default download folder. - Click OK. Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large~Waholesaler} ® 47 IssuetlNovember2000 y,®4~~ 4 fe.l'! or' f?
Page 43: bni94c00
3. Select Calculate Brand Totals. Totals are calculated for each invoice by brand, and the summary is displayed at the bottom of the worksheet. _. . . 5umrn,r oS FiwlrEse t 1 F31 - . lnvanCC DFrpg denapiap tlunrbee srand Rnlz CxrtoRr 4. 5%ICIed Aep4 .. DB~D1o7 -d777$ CJLOFL $a.SJ 75$ 347.Fri D6RAi S SALEEA _ ¢ wIN3T,7P3 5 lmnine Tr;ala 7615 337.4J SUmm m a! .. ~~ .. ... ~ .. le R :4tiG141bCR B1tYika. I ~ °.!f . ~ ~ 4utfanFYnt~ Blli¢,~Y'~Ik9i • •' >' VVH,w 78073J CRMEL . . -' I I I ~ . ._ T. DCRab... . . $4 i?'J . ~ ~ . . . . 279.4J '. & .~aLFn,4 c, wlrl=~rt~ra s IrtRoiceT¢Sals G2 5 279.06 To delete invoice rows: IMPORTANT! Be very sure that you want to delete invoice rows when using this function. Once an invoice has been deleted, it CANNOT be reversed! 1. Position your cursor on the invoice row(s) that you wish to delete. NOTE: To select more than one row, position your cursor on the first ;ow, and click and drag to highlight multiple rows. MY~$6 ftZ'f. 1 hiC.~^ .5•1'/4R UA•0-•~ 2. Click the Functions button. 3. Select Delete Invoice/Row(s). The selected invoice(s) are deleted. To clear/reset the worksheet: IMPORTANT! Be very sure that you vaant to clearireset the warksheet when using this function. Once the worksheet is clearedtreset, it CANNOT be reversed! 1. Click the Functions button. 2. Select Clear/Reset Worksheet. The worksheet is cleared/reset to a blank worksheet. ~ Printing the lnvoice Worksheet N 0 To print the invoice worksheet: ~ 00 1. Open the invoice worksheet that you want to print. d`J N Third Line Discoun6ng-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (SmalUMid-Si?e Wholesaler) • 25 Issued November 2000 ~~~ ,^gs- ~ -,e re:.~a
Page 44: bni94c00
Editing a Saved Worksheet To edit a saved worksheet: 1. Open the Retail Account List screen. The retail account number for accounts that have saved worksheets are displayed in red . :r o-~~€, ~.. ,~.rif<3 Ilrr (p_7 i ii iGI:.4 =~~,71 Pl1RKlh"AY MAR1:5T HYdY.25~ . . THORBd HICE, 'ST1 37&33 XXX.333333 NJASHBiARiI MARKET FlrJ.BOX? HSW. 1si V}ASHB117PI.TN 87P168 2. Position your cursor in the shaded area of the account you want to edit. 3. Click the Select Account to Invoice button. The Retail Invoice Tracking Worksheet for the selected account appears. 4. Make changes as needed on the worksheet. 5. Click the Save Invoice Worksheet button. The invoice is saved and the Retai[ Account List screen appears. Using Retail Invoice Tracking Worksheet Functions The Retail Invoice Tracking Worksheet contains three additional functions to assist ~ you in completing the form. The functions are: -~ + Calculate brand totals-Calculates totals for each invoice by brand and provides ~ a summary at the end of the worksheet before the worksheet is saved. ~ NOTE: Brand totals are automatically calculated when the worksheet is saved. c^w • Delete invoice row(s)-Deletes an invoice row or several selected rows. ~ •- Clear/Reset worksheet-Clears or resets the entire worksheet. To calculate brand totals: 1. Enter invoice data on the Retaillnvoice Tracking Worksheet. 2. Click the Functions button. 24 • Third Line Wholesaler Spreadsheet (Small/IVlid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 - Issued Novem6er 2000 -1) Y ~~~~ j VA ;2
Page 45: bni94c00
Procomm Plus connects to the system.and displays a logon successful message. After the message is displayed, the system attempts to make an outbound connection and displays the command prompt. Frocomm Plus fleady! Procamm Plus Ready! Procomm Plus Ready! Enter logon id: nuwtest Enter password: . ..flttempting logan... *` Lq60N SUCCESSFIl4, " Making outbound wnnectign..,CONNECTEU The current File Transfer Pratacat is ZEit7CEEt9. [C, \SPC3UISEfl\N!1!1TE5T]cmd> 6. Enter the following syntax at the command prompt: $$REQ ]D=(your user ID) BID='(third line wholesaler file name)' IMPORTANTI Remember to include the single quotes (") around the file name (batch ID). Command line entries for the UPC Code and Account template files are as follows: $$REQ ID=(your user ID) BID='UPC' $$REQ ID=(your user ID) BID=ACCOUNT' The command line entry should look similar to the following example. [C.\5PC3tU5ER\NUWTEST]cmd>!S$REQ ID=NUWTEST BID='UPG' 64 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 . . P IssuetlNovember2000
Page 46: bni94c00
14. Click Yes. The FlyperTerminal connection is created. Creating a HyperTerminal Icon on your Desktop To create a HyperTerminal icon on your desktop: 1. Choose Start, Programs, Accessories, Communications, HyperTermina€. The HyperTerminal window appears. ,1;.-:.hl Ean..-.w._ ! -31 IxF-rvM~a.ea nYFSPr^n_ ML7rA1'1?. A'Jliic.;:-~:• C~ 11 uh, . ..___.. . ..a~ .. . .. __..... _. 2. Click and drag the RJR Tobacco Company icon to your deskop. . The RJR Tobacco Company HyperTerminal icon is moved to your desktop. Setting the Default Download Directory The first time you download using HyperTerminal, you will have to specify the default download directory. Files downloaded after that time wilt always be stored in the specified directory. To set the default download directory: NOTE: You will only need to set the default directory once unless you want to change it later. To change the default directory, repeat the steps in this section to select another directory. 1. Double-click on the RJR Tobacco Company icon on your desktop. 46 • File Transfer Direct Communications (Large Wholesaler) GR. J. Reynolds Tobacco Company 2000 ° ~4isy•3 PAeT'ee+_5
Page 47: bni94c00
6. Press Enter. HyperTerminal displays a message indicating that it is ready to receive the file. (2MODEM ready to receive file(s) Plaase start file transfer within 45 seconds xxB60000002f7fde 1 7. Click the Send button on the toolbar. The Send File window appears. mn F;re ; Fc',des_ C 1W1N©OV15tDP~-k_i,~ ' .F;Erojind: 8. Click the Browse button. The Select File to Send window appears. IsjR P .. 3Y, Flo~{ty(A) ~BtA_PRELGSD (G) -~EPRCroove44e Di3N (D:) (e) ~_i%ERS.on Vs50AfA3' (H:) , ~~3Py~LIGmV.6htAIN1'(~) F2aesnr_ F7c:c?~~.+-I 1F3es("{ ~ l7pc+i ~ . I 9. Find the directory where the third line wholesaler file is saved. IMPORTANT! You only have 45-seconds to browse for the file and attach it . in Procomm Plus. If you exceed the 45 second limit,-you wiIl be logged out of the system. You Will have to repeat steps \-D 1-8 in order to try again. ND 4 J cn V,6DATA3(i_) • 68 • File Transfer Direct Communications (Large-Wholesaler). © R. J. Reynolds Tobacco Company 2000 - n Issu,erdNovem~bjer20_00
Page 48: bni94c00
Hardware Requirements . Processor and Mouse Use one of the following processors to run the Procorr.m Plus software. The processor must be able to run Windows 95 and use a Microsoft compatible mouse. Disk Drive The disk drive must have at least 35 megabytes of available space. RAM (Random Access Memory) The computer must have at least 16 megabytes of RAM. Modem Hayes Optima 28.8, 33.6, or 56K internal or external modem (or compatible). Preferred Hardware Configuration The recommended hardware configuration consists of the following components: • IBM Compatible with a Pentium Processor • Windows 95 • 32 megabytes of RAM • 100 megabytes of free disk space • Hayes Optima Modem (external) Installing Pracomm Plus See your Procomm user guide for instructions on installing Procomm Plus. Customizing Procamm Plus Modem Settings NOTE: See your Procomm user guide for instrucrions on setting up your modem. Once Procomm is properly installed and configured for your modem, you will need to customize the settings for file transfer transmissions to RJRT. 1-0 ~To customize your modem settings: ~10 rI.> 1. Double-click on the Procornm Plus icon located on your desktop. ,.r"j CD ~ OD Pi,:ecmM . 6vai¢mie~l ~~ ~ NOTE: If the Pror,omm Plus icon was not installed on yourdesktop, choose Start, Programs, Procomm Pfus, Data Termina7 to open the application. Procomm Plus opens and the main screen appears. Third Line Discounfing--RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) •35 Issued Navember 2000 a`!)~,~ 3 a,Ao ~~~
Page 49: bni94c00
Contact List I am having a problem with... You should... Third line spreadsheet entries Call: Third Line Hotline @ 800-887-8102 8:O0FlM to 5:00PM (EST) M-F E-mailing my third line spreadsheet Call: Third Line Hotline @ 800-887-8102 8:00.4M to 5:O0PM (EST) M-F Procomm Plus Call technical support for the software provider. HyperTerminal Call technical support for the software provider. Uploading or downloading files E-mail or call: Richard Allen: allenrOmrjrt.com (336)741-3537 Tim Hassler: hassletO.rirt.com (336)741-3732 Setting up file templates E-mail or call: Richard Allen: allenrac,rjrt.corn (336) 741-3537 Tim Hassler: hassletamrirt.com (336) 741-3732 EFT Enrollment I Call Sandra Sheets at (336) 741-0351. EFT Bank Qualification Call your banking representative for assistance. dt 80 • Contact List ' © R. J. Reynolds Tobacco Company 2000 , _ IssuedNOVem6er2000 /~i~7,r 7l w (f3
Page 50: bni94c00
4. Enter your login ID. Press the Enter key. °.AnleMRwlaMia `Procamm Plus Readq! Procomm Plus R®edq! iEnter lasan id: N€lSdiEST lEnter password: I 5. Enter your password. Press the Enter key. Procomm Plus logs on to the system and displays a logon successful message. After the message is displayed, the system attempts to make an outbound connection and displays a command prompt. _ ~pl alA1P i~~ ~ h {Ch9~trx~~.ca" A Procomm Plus Readu! Proeamm Plus Rezdyl Procomm Plus Ready! Enter logan id: nuwtest Enter password; ...Rttempting logon... " LU6UN 5UCCES5FUL " Making outbound cannection.•.C9NNECTEII The current Fi le Tranafer ProtocoE is ZiiWcDi. [Ce\5PC3\U5ERlNUNTE5T]emd> 6. Enter the following syntax at the command prompt: $$ADD ID=(your user ID) BID=(third line wholesaler file name) The command line entry should look similar to the following example: [C: \5Pc3rusE9\NuwtEST cmd>$$HnU ]U=NUwTESr S>:n=1NuOYCEs 7. Press Enter. Procomm Plus displays a message indicating that it is ready to receive the file. ' ZhIDDEM ready tn receive file(s) Please start file transfer uithin 45 seconds '"'60 t 0000002f7fdc 4 8. Click the Upload button in the toolbar. 60 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 - Issued Novem6ner2000 3 ' . . ~~K S~tlY J
Page 51: bni94c00
action within the program. You will need to know the following before beginning the upload process: • The name of the third line wholesaler file. The file name also acts as a batch ID (or BID) to identify files once they are uploaded to the RJRT system. • The directory that the third line wholesaler file is stored. The file must be zipped and saved in'.zip format. The command line format for entering a syntax is as follows and should be entered in all capital letters: [C:SSPG3IUSER1FtUWTESTj *d4Ml71C>=NU4Y7EST BfD=UdV4ICES.TIP I I Yourusm"D 9°dnewhW~Ydetilersme Zomma-id trte tunetion . "ch ID) CorromarW prompt I I $~WrQCtoN usisg yoir uaeiID Oireeto+isswttdc yaT tl&kl I5s4oYed The most common command line functions are: • $$ADD-Uploads files to the R7RT system • $$REQ-Downloads files from the RJRT system Uploading Files Using HyperTerminal To upload files using HyperTerminal: 1. Double-click on the RJR Tobacco Company icon on your desktop. a.n rcuecon. HyperTerminal opens and displays the Connect window. ur)za49' 1 Lr,y:c.~ _ _. ~ . ~. Canpc,i3 ! r Orr.:;96p 66 • File Transfer Direct Communications (Large Wholesaler) © R. J_ Reynolds Tobacco Company 2000 ^ Issued Novembrer2~DT00 Y J~¢ rO.SOT O3
Page 52: bni94c00
This process should be completed within two weeks or less from the receipt of a fully executed EFT Enrollment Form. . Changes to EFT Enrollment Information Changes to EFT enrollment information should be forwarded in writing to the RJRT Disbursements Accounting department. EFT Questions and Support Support for EFT Enrollment and questions is provided by RJRT. If you should have additional questions regarding EFT after reading this document, contact: • Your RJRT Representative. • Sandra Sheets at (336) 741-0351 Third Line Discounting-RJRT Wholesalers Guide ' Electronic Funds Transfer (EFT) • 79 Issued November2000 o-L+ jl
Page 53: bni94c00
Forms EFT Enrollment Form The EFT Enrollment Form is used to enroll in the R7RT EFT Payment program. See _ your banking representative for help in completing the form_ \~D - Third Line Discounting-RJRT Wholesalers Guide - /~ Forms • 83 IssuetlNOVember2000 ~3 ,
Page 54: bni94c00
# Data Element Format Length Position Notes 47 Billed Amount N 10 242 9999999.99 -Discount amt. (#44) + Allowance amt (#46) 48 Billed Amount Sign A 252 =' negative, space is positive. 49 Start Date N 8 253 YYYYMMDD 50 End Date N 8 261 YYYYMMDD 51 Retail Acccount Invoice Number A 20 269 52 Retail Account Invoice Date A 8 289 YYYYMMDD Record Length 296 After the file has been created according the defmitions listed above, you are able to view the Invoice Detail file. A sample an Invoice Detail file is shown below. 0 0 File Header ( 07CE B:TAI7. 20001019152b250 0125536DH T HSCIO[EY_HAO;: 92020001019 20002019 aLEULESBJRO F.OY 322987509917-801 YICv'rE'.R TRADI1rG 605T 12-03 D1255360H T HAMEC NHOR 9365065D0715-J06 A2020001019 2000I01926000000c02AX0 I'HA: QkIZY DAff{ X 2015 InvoiceTotals l ?hFY.Uh9 U'G020001s119 Recor d il2RIVQICE TOTAL l 20001019 015986$0H T Hi,e[IXEY LAKE CT3 749030180120-L01 17020001019 20001019 B? Fd7D aAP.T 1-75 e E{IT II29 RT 92 HQX 97 Detail Record l 01898800A T ELCB7iEP LiiHE CTY 7390301801<'0-001 1702Gd01019 20001019 H P FOOD 2DSLPT 1-75 P ECIT A39 @T A2 HJY. 97 02IHV9?CE YOT7.I. 17020001J19 20001019 016905#373 T Ht.LUEJ HiRrrr 6962511i3{40-091 93020001019 20001019 Do3TB WGtiTRS' MART 19:8 EIX'I 92 A. 922q4(IICE TlTr3L Q3020o01019 20001019 File Trailer ~ 99InVOICE DETAI3. OOO9o10 Third Line Discounfrng-RJRT Wholesalers Guide File Transfer Direct Communications (Largle~ Wholesaler) • 57 Issued November 2000 '~,,.,,_ 1 5-/ ®,70 003 ,
Page 55: bni94c00
lJpdating the RJRT BIlling Summary All entries are automatically calculated and posted on the billing summary screen. Once entries have been calculated, they cannot be changed on this screen. Any changes to entries on the billing screen must be completed on the Retail Invoice Tracking 6Yorksheet. To update the billing summary screen: 1. Click the Navigation (Goto) button, and select Goto Retail Account List. The Retail Account List screen appears. 9rrt;iyi-~rt.~r.,_ ira~Jln_cr,r~tiittL ~~as~er ~Gr~~a ,n'A'~~RP`, r . . . . . ft:-- ,-. l XX%-9STni LSKESInEMARi(Ea' 3T30id .~mol I 4L.AS 4~ll~~ O] . 4940 filGhR°FA"a ^ Cqrd7 S? c fkLn1 I_' i:yiA c..r...,, a rr+n I-iv+st.m 2. Use the Find function or vertical scroll bar to locate the retail account you want to change. 3. Click anywhere in the shaded area to select the account. 4. Click the Select Account to Invoice button. The completed Retarllnvoice Tracking Worksheet appears for the selected retail account. 5. Make changes to the worksheet as needed. 6. Click the Save Invoice Worksheet button. The Retail Account List screen appears. 7. Click the Navigation (Goto) button, and select Goto RJRT Billing Summary. 8. Ensure that changes are reflected on the billing summary screen. ~ 9. Repeat steps 1-S to make additional changes to the RJRT Billing Summaty screen. ~ C~ hJ Cs"l 28 • Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 Issued November p2o~ea ~ ~ tl :$ +`A-~
Page 56: bni94c00
# Data Element Format Length Position 19 Invoice Amount to be PAID Sign A 1 260 20 # of detail records for Invoice N 7 261 21 Filler A 29 268 Record Length *'lnvoice Detail Record** 22 Record ID A 296 2 I 23 RIR SI5 Wholesaler Number N 6 3 24 RJR 5I5 Wholesaler Name N 25 9 25 RJR SI5 RETAIL Account Number 6 34 26 Wholesaler Supplier Number A 10 40 27 Filler A 10 50 28 Wholesaler Invoice Number to RJR A 20 60 29 Wholesaler Invoice to RJR Date N 8 80 30 RJR Account Chain ID A 8 88 31 Account Name A 25 96 32 Account Address Line 1 A 20 121 33 Account Address Line I A 20 141 34 Account City A 15 161 35 Account State A 2 176 36 Account Zip N 5 178 37 AccountZip+4 N 4 183 38 Brand Family Code N 4 .1 187 39 RJRDisplayCode . A 9 191 40 UPC Code N 10 200 41 Discount Rate ' N 5 210 42 Quantity Shipped in ° cartons N 6 215 43 Quantity Shipped Sign - - ' A 1 221 44 Discount Amount . . N - -9 , - 222 45 Discount Amount Sign A 1 231 46 AllowanceAmount - N 10 232 Notes rounded#16) ' ' negative, space is positive Count includes Invoice Total record value'01' YYYYMMDD Wholesaler has the option of using their name and address or the RJR name and address. The name and address consists of data elements #30 thru #37. 999.999 Whole cartons only '-' negative, space is positive 9999999.99 - Qty shipped . (#42) *Discount Rate (#41) =' negative, space is positive 9999999.99-Qtyshipped 99200852 (~2)*•025(Always Positive) 56 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 . ' Issued November 2000 12Vg 5,5-o{'X3
Page 57: bni94c00
HyperTerminal opens and displays the Connect window. ~ fttRr.asen~nvJ,j . Tcs od:rl tc L~,Jir_.~ ('dn~R,Mr:_ Ca4T_c,_ii ilsrefL:i~IPa~I ~ L Utl 2. Click Dial. HyperTerminal attempts to d'ial RJRT. ~'~(~~y~fJIJR Tph~GUCPrPVy V '~4TJ]?i1 41 9 inisai Y,E'sr/4's n Ir W aJ Fuy'b F HyperTenninal dials the number and connects to the RJRT system. The Connect window closes, and the logon prompt appears. 3. Enter your logon ID. Press the Enter key. kg.1UR Tatlae6a C9mpaay-HqpcrTermio-4] Enter logon ld: _ p 4. Enter your password. Press the Enter key. 70 • File Transfer Direct Communications (Large Wholesaler) U R. J. Reynolds Tobacco Company 2000 . . , „ Issued November 2D0
Page 58: bni94c00
Invoice Detail File Definitions It is recommended that a technical person in your organization define field requirements for each template file. The list of field definitions for the Invoice Detail File are listed below: Invoice Detail Template File File Specifrcations Record is fixed length of 296 characters File contains 4 record types: 1-header, 2-detail, 3-invoice total 4-trailer NOTE: Bold data elements are wholesaler billing data fields. # Data Element Format Length Position Notes ** File Header Record** One Header Record Per File . d D 0 2 File Name A 20 N 8 23 yyyymmdd 3 Data File was created 4 Time File was created N 7 31 hhmmsst hh=hour, mm=minutes. - . ss=seconds, t=tenths of second 5 Filler Record Length "File Trailer Record"` 6 Record ID 7 File Name 8 ti of records in file 9 Filler Record Length '*Invoice Totals Record** 10 Record ID 11 Record Description 12 Filler A A 259 3 38 value '1N VOICE DETAIL' 296 2 3 value'99' value'INVOICE DETAIL' 1 One-Trailer Record per file 20 N 7 A A A 267 296 2 20 23 Count includes header and - - trailer records (all records) 30 1 3 A 27 23 i 13 Wholesaler Invoice Number to A 20 50 R]R One Totals Record per Invoice file . value'02' ~ Value "INVOICE TOTAL' 99200851 14 Wholesaler Invoice to RJR N 8 70 . YYYYMMDD Date 15 Filler A 162 78 - 16 Invoice Total Amouht N 10 240 _ 17 Invoice Total Amount Sign A 1 250 18 Invoice Amount to be PAID N 9 251 - 9999999.999 - accumulation of detail Billed Amount for Invoice (t}46) '-' negative, space is positive 9999999.99 actual amount owed to wholesaler (Invoice Total Amt Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 55 Issued November 2000 . ' . , P- _E ~z ,t d /t F3
Page 59: bni94c00
2. Click Dial. HyperTenninal attempts to dial RJRT. ~k F.F T~~L> :aAwiqm~ . ~ .~; r.o~r<~v,ewner;~o-rrh~7~sar~~: ~ . s~,~_ _ ...._ _.._. .. HyperTerminal dials the number and connects to the RJRT system. The Connect window closes, and the logon prompt appears. 3. Enter your logon ID. Press the Enter key. 4. Enter your password. Press the Enter key. HyperTerminal logs on to the system and displays a logon successful message. After the message is displayed, the system attempts to make an outbound connection and displays a command prompt. ' LIVGY 1_ i1 f(tllr-Y a,W . . . AW-J 21_v7J !1L5.-1i Entar logon.id: nuwtaet Enter pna^.uard: ...Attempting ingon... Nw L9GtiH SUCCESSFULxK ~naking outbaund connacFion...CDNNETED 1 . i]H+ CVrrent Filo Transfer PrntoCol is 2NDDEN. '( [C:1SPC37USER\NULTEST]cmdJ . 5. Enter the following syntax at the command prompt: - $$ADD ID=(your user ID) BID=(third line wholesaler file name) The command line entry should look similar to the following example: I[C:\SPC3\USER\NUWTEST]emd>$SEaDD ID=NUNTEST 6TD=2NUOICES Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 67 (~ Issued Novem6er 2000 /~~ ~Gr a~a3
Page 60: bni94c00
Frequently Asked Questions Common Questions and Answers The questions listed in this section are some of the most common questions asked about the Third Line program. As the program grows, more questions will be added to this section. Refer to this section before placing calls to technical support or to the HotWIS representative. - How do I setup my template files? RJRT recommends that you have your computer support person create a spreadsheet or database to collect your discount data. File template settings have been provided in this document, which should be adhered to in order to process your discounts in a timely manner. - How do I switch from the spreadsheet discount reporting method to the file transfer method? Contact the HotWIS representative. They will send you an enrollment form and starter pack. Third Line Discounting-RJRT Wholesalers Guide . Frequently Asked Questions • 81 IssuetlNovember2000 _ P„e Oa
Page 61: bni94c00
3. Find the directory where the renamed zip file is stored. n,enlLChnre FTd 4. Select the file you want to open, and click the Open button. The selected file appears in the WinZip window. I jrr- ' .j Ca S~ ~~~ -t~a j~n t: ~11 . . Nctt . ~ bactl Pi7a ' LlmckP~7 W"ecid. ~ `}6trs . a LtadL~d _ 1. - -E~ .Ro1.l :Pa:iwdl Pdhl '~AccwR; 1071QrW7:51PM 73SC5 84:d 1A51 Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) 75 Issued November 2000 ''I/ o/9' "r7-3
Page 62: bni94c00
6. Click OK. The Meta ICcry Editor window closes and the button appears on the button bar at the bottom of your screen. -[J 7. Repeat steps.l-6 to create additional meta keys. Editing a Meta Key To edit a meta key: 1. Press ALT + M on your keyboard. The Procomm Fdas Meta Key Editor screen appears. 2. Determine the ke,r °,.i ~,ou wish to edit. 3. Select ilic k,v :.,u •,::~.ni to e-Inii=~in the Meta Key Select group. set you are editing. 9ettit~i~ri'h~f~nm,n inin, intiiF I s::iyou rrnn3- . ~~- ~~,io .. .___ . ~...,., . ' i 1 3ei,aTeat _,_. '~i~,f~~f,ILI 111=!i'[II hf 6iIJ i~+l'i}I i'a ~tatodd~_~ 4. Select a new aetion from the drop-down list in the Action field beside the key `ihkei-,, iF_'onw, and ~• IF ~Ci `1D 5. 6. Enter or select the script, program file name, menu command, or terminal 1`:) command in the Contents field. For example, if you want to open the Meta I{eyc:D Editor window by clicking a meta key button, select Options-Meta Key Editor CD from the Contents drop-down list. Your screen should look similar to the `w': following: t'"4 v_l !, flnNnevr.ii Kan 6 r.~ Ente, : ~rL me for the button in the Label field. j Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) ® 41 IssuedNovember2eoa A,1tqir 0 a -l"J03
Page 63: bni94c00
10. Select the file and click Open. The Send File window appears. fok'~r. CPn1lDO~:fSlUaktm~ " F_3earn~ . Ca6s~litDGb~S'~L~e.r:opllnmar ~ 5n>3- ix 11. Click Send. The Zmodem file sendfor RJR Tobacco Company window appears, and the file begins uploading to RJRT. This process may take a while depending on the size of the file. Please be patient as it uploads. (Zmadcmfilc ssndfnr RJRTobscua Compnty ..~>;~lVlIF.L1t9N5~D~}:[m,U'n•m~,.p S'crld'®a . SEalua: Sening dK . Et~ed IXJ,r~rO" . Remsirvng ClIl7G:G7 ThrouSf~ni'-~35A~]~~; I 12. After the file has been 100% uploaded, HyperTerminal will return to the command line. .13. Click the Disconnect button on the toolbar. ~ Youf session is closed, and the line is disconnected. Downloading Files from RJRT Using HyperTerminal ~ File Transfer Administrators will place the UPC Codes and Account Template files N into-your subdirectory on the RJRT system. These files contain the current third linc-D wholesaler data. You will be responsible for downloading these files to your hard CD drive every month. - a" (7\ To download files using HyperTenninal: . - (}'I 1. Double-click on the RJR Tobacco Company icoa on your desktop. Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • ~679 Issued November 2000
Page 64: bni94c00
Electronic Funds Transfer (EFT) Enrollment Form Please complete this form and return to R.J. Reynolds Tobacco Company, Disbursements Operations, P.O. Box 2955, Winston-Salem NC 27102-2955 Phone: 336-741-0351 Fax: 336-741-0353 or 336-728-7712. Contact Person: Sandra Sheets. Your Company Company Name: Address: EFT Contact Name: EFT Contact Telephone: ( )- Your EFT Financial Institution Bank Name: Address: Bank Calling Office: Bank Contact Telephone: ( )- EFT Payments to be extended by: Days Bank Transit Routing Number: EFT payment days will be added to existing payment due dates to neutralize check float. Remittance Method (P/ease check one of the following): Your EFT Bank Account Number to Receive Payments: 0 ED! ANSI 820 sent to your bank with payment 0 ED! ANSI 820 sent to your company's ED! mailbox O Fax Remittance sent to ( )- - O Email address Bank Account Name: The above EFT payment instructions are authorized, and the terms and C~~,onditions for ElectronicFunds Transfer payments printed on the reverse ACH Format Your Bank Accepts: (CTX or CCD +) 4~ side of this form are accepted by: Signature ; Date/ / 0 ~ Printed Name Company Title Combine EFT Remittance with ACH: (Yes I No) Your Financial Institution should be consulted since EFT transmission formats are influenced by your bank's capability to receive electronic payments. I~ 84 . Forms © R. J. Reynolds Tobacco Company 2000 W . G BOO Z( [ Issued November 2000
Page 65: bni94c00
Electronic Funds Transfer (EFT) What is Electronic Funds Transfer (EFT)? IMPORTANT! This EFT process is a different process from the EFT payment . process for product. The file transfer process documented in this section is accounts payable for the third line program. - Electronic Funds Transfer, or EFT, is the electronic delivery of collected funds to your bank account on a specific date using the Automatic Clearing House (ACH) bank transaction format. The ACH is a banking network facility that accepts EFT transactions, sorts, and forwards them to the appropriate destination. Before you enroll in the EFT program, consider the following: - • Discuss the program with your RJRT buying representative. How will this plan benefit me? What are the costs for EFT banking? • Discuss your bank's EFT capabilities. Are they able to accept ACH credit transactions? Can they help me complete the EFT Enrollment Form? EFT is used within RJRT to quickly pay wholesalers for using the third line discounting program. You will find that EFT payments are quickly deposited into your account within one week, which eliminates the old paper check method of payment. Once you have enrolled into the EFT program, the process is as follows: • The wholesaler submits third line wholesale discounts to RJRT via e-mail or file transfer. • RJRT verifies that the wholesaler'sdata is correct. • R7RT Disbursements Accounting department processes an ACH credit through ,p the clearing house. - V'J • Payment is processed and deposited into the wholesaler's bank account. Note, N ® once EFT is selected as the payment option, all RJRT payments will be O . made via EFT. - Go • You can receive a fax within one to two days before money is deposited into --I your account. Uj - Third Line Drscounting-RJRT Wholesalers Guide Electronic Funds Transfer (EFT) • 77 ? Issued November 2000 . Ave 7/O71',F
Page 66: bni94c00
8. After the file has been 100% downloaded, HyperTerminal will return to the command line. To download another file, repeat steps 1-7 again. 9. Click the Disconnect button. Your session is closed, and the line is disconnected. Accessing Downloaded Files When RJRT files are downloaded using Procomm Plus or HyperTerminal, they are stored in a directory on your hard drive. The default directory for Procomm Plus is C:\Program Files\Procomm Plus\Download directory. The default directory for HyperTerminal is C:\ however, you may change this at any time. See Setting the Download Default Directory on page 44 for instructions. All downloaded files have a.mbx extension and must be renamed to zip extension before they can be opened. To rename.mbx files: 1. Double-click the Windows Explorer icon on your desktop. ~ nr~rrrs NOTE: If you do not have the Windows Explorer icon on your desktop, right- mouse click on Start, and choose Explore from the menu list to open Windows Explorer. Windows Explorer opens, and the Exploring screen appears. 2. Find the directory where the downloaded file is stored. 3. Right-mouse click on the first file##Mtt.mbx file (where ###kk is the assigned Procomm or HyperTenninal number). ,. I . Fy _dt ! 0 cY. ~. ir C+e' *_arade: i`nu... N ip - - ~~. - . .... . _-°-- C.7 ~ rv y PD, - . .~,~ • 6p IAe~Gi e G.rn .I . Cu1 fs',~ p~~l• Un1~ .[ .... . .- .__. .-_. , . GIIFoijRS HTMLHePWuik:hcp InGeinM'cx[Vcrer . p-f„] fama}a O% 72 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 ~ Issued November 2000 !/r/~ £ 71
Page 67: bni94c00
12. Click the Disconnect button. Your session is closed, and the line is disconnected. Downloading Files from RJRT Using Procomm Plus File Transfer Administrators will place the UPC Codes and Account Template files into your subdirectory on the RJRT system. These files contain the current third line wholesaler data. You are responsible for downloading these files to your hard drive every month. To download files using Procomm Plus: - 1. Click on the Connection Directory icon on the toolbar. 0`1J The Connection Directory window appears. 2. Select RJR Tobacco Company in the Entries list.. KO elwn ~n.xtay • [ PN`4_Irf 1 o" 1~:s, w'~.~ lad^'p.. ,,e ky 1.~1,,: ` i ism rm JI IF f~ m~.~e.=. ~~$<mr.. .ov a~a~ '.- iw~'su ~: : :.. . __ ._ .. . ... .. 3: Click Dial. (V Dial : O O cc CSi 00 62 • File Transfer Direct Communicatio ns (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 Is uetl November200a P'YF 61, O'e3
Page 68: bni94c00
HyperTerminal HyperTerminal may be used as an alternative for transmitting data files instead of using Procomm Plus. HyperTerminal is a Windows application that is normally installed with yoqr Windows operating system. No additional software is needed to run HyperTenninal on your computer. NOTE: If you do not have HyperTemrinal installed an your machine, contact your technical support center or the PC manufacturer for instructions ~=li-LJ ~:~ar,xFdet~eee~staleiJ~ r_e 2. l will only need to perform the steps in this section once. To create a HyperTerrninal dial-up connection: 1. Choose Start, Programs, Accessories, Communications, HyperTerminal. The X,iperTerminal window aopears. Creating a HyperTerr»inai Connection Before you can transmit data files, you will need to setup a dial-up connection. You :,TalhtsiitA Carr,auSee... hfremns.tlp hypertrtn.dll c-,l;. . ~ _.. r_ ~. ~. .. _ .. Double-click on the Hyperfrm.exe icon. It M+Pgrp.s.t. E~E HyperTerminal opens, and the Connection Description window appears. Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 43 IssuedNovemher2000 ~~~~ ~~s Vd
Page 69: bni94c00
WinZip opens and the main WinZip screen appears. . t7a:e DaL- TGn Sca R.~qR.F cn~d Y~.i:. 2. Click the Open button on the tool bar. t.~. The Open Archive window appears. A cXA1PPLe.ZP : yv7fATStXh/.iXT CYIZF0M WLTUi9R;_ "P.CNT WZ koWAMZAR' ~ (({ REACfif_.TXT M9 P 32EkEP32EkE WZSEP~i2.EkE `N VBVDOR7RT ~]W1N21PFM19.CLL ~]VNLCHLEXT.t/LL ,=I UCEFSE.TMT ~tMNI1PkiP w VY232.CtL aRbFR_iMTT YWN9P.TXT a. WZPFA32.OLL ~- ~ F~h~tir ~~ j ._.,. _ . .. i 74 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 Issued Novem6er 2000 i~~/~~ 'J3 o,z?OR
Page 70: bni94c00
The Send File Using window appears. Sf Flnppy (A) " 6fl5F m r{CKOYGldT' (D.) ~ (E:] _jjIrEiared Elesi>xent 9. Find the directory in which the third line wholesaler file is located. IMPORTANT! You only have 45 seconds to find the file and attach it in Procomm Plus. If you exceed the 45-second limit, you will be logged out of the system. You will have to repeat steps _,. 1-S in order to try again. 10. Select the file, and click Open. The Zmodem window appears, and the file begins uploading to RJRT. This process may take a while depending on the size of the file. Please be patient as it uploads. _ Be~rsj: - 'Imca>A_ - 1 ___ ~~.. _~ :......»..~. ~ , fteR~4e:: Gs!rhRC-m~e . RoNurbec161 F2eLen3tm 65fCau^.+.153f8 .1-0700 cu ey„r ~. T:.v:w:rsai~az . I OY~ -:'s.c ,h34p9. , i n ~cm1 eqt~Rl1 ~~ 'CsJ:.I'~lea.j~~nrtaR6t:;.a - ', ]-IFli~onmd1ia14.~'.:I6<nsfs~m~ '.D 11. After the file has been 100% uploaded,~Procomm will return to the command ~~ line. Verify in the status bar, located at the bottom of the screen, that the file has CD been uploaded successfully. ,.. . . __ _., .;.;cn~_ .......~. -=r 4.ter complehe Third Line Discounting-RJRT Wholesalers Guide File TransferDirecf Communications (Large ^Wholesaler) • /611p IssuedNovember2e00 . /./~E ~ OC-Q 3
Page 71: bni94c00
File Transfer Process Procomm Introduction to Uploading and Downloading Files Using Procomm Plus Files that contain third line wholesaler data must be "zipped" or "compressed." This data is compressed so it can easily be uploaded to RJRT in a short period of time. NOTE: lMnzip~, a popular file compression package, can be downloaded from the . Internet free of charge. Access http://www.winzin.com to obtain a free evaluation copy. When you are ready to send your zipped third line wholesaler file to RJRT for payment, you must upload it using Procomm Plus or a similar File Transfer Protocol (FTP) program such as HyperTerminal. Uploading sends the files electronically to RJRT and stores the file on their server to be processed for payment. When uploading files using Procomm Plus or HyperTerminal, you will use a command line syntax. A syntax is a combination of entries that executes a particular action within the program. You will need to know the following before beginning " the upload process: • The name of the third line wholesaler file. The file name also acts as a batch ID (or BID) to identify files once they are uploaded to the RJRT system. • The directory that the third line wholesaler file is stored. The file must be zipped and saved in zip format. The command line format for entering a syntax is as follows and should be entered in all capital letters: [C:SSPC3IUSIERSNUWTEST] cmds3S.AOD ID=h1UVYTEST BID=INYOICES.ZIP I YauruselD Comrnsnd Inetunctlon ildrd5ne vArnt`selerlilb ~e (ba'ch ID) . . I cercana - ;Lqalrectc:y erang you'vzrct7 Dirtctoriests8lac " ycz.r Oata IssFOreH nd dromo . - t . Dii4elme? - The most common command line fu nctions are: ~ 1 0 : $$ADD-Uploads files to the RJ RT syst em ~ N e $$REQ-Downloads files from t he RJR T system O O Uploading Files Using Pro com m Plus CO To upload files using Procomm Plus: 1. Click the Connection Directory icon on the toolbar. 58 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 . Issued November 2000 Pl6 S7&-,-,-~
Page 72: bni94c00
Banking Requirements You must discuss EFT and ACH capabilities with your bank. Your bank must be capable of accepting ACH credits. If your bank meets these requirements, and you decide to join the EFT program, have your banking representative assist you in filling out R.IRT's EFT Enrollment Form. EFT Bank Charges There is no charge to you, the wholesaler, for using EFT. RJRT bears the initial cost of originating each EFT transaction. On the receiving end, a bank processing fee is incurred. This may be equivalent to a normal check-clearing fee; however, normal manual lockbox charges may be reduced, due to the electronic nature of the transaction. Actual charges will depend on the policy established between you and your bank. Enrolling in the RJRT EFT Payment Program The first step to enrolling in the program is to discuss the program with your RJRT representative. They can answer any additional questions you may have regarding the program. Secondly, discuss the EFT program with your banking representative to see if they are capable of receiving EFT payments and ACH credits. If the bank is capable of processing EFT payments, obtain a copy of the RJRT EFT Enrollment Form, and have the representative assist you in completing the form. EFT Enrollment Form . The EFT Enrollment Form is a communications document from you, the wholesaler, to RJRT. The document provides EFT payment instructions for each of the payee's vendor numbers assigned by RJRT to the payee. The enrollment form must be signed and returned to RJRT Disbursements Accounting prior to activation ofEFT payments. You should discuss the EFT Enrollment Form with your bank for clarification of the bank's EFT capabilities. See Forms on page 81 to obtain a sample form. Processing the EFT Enrollment Form After the EFT Enrollment Form has been completed, you should sign and mail the original form to: . - R.J. Reynolds Tobacco Company Attn: Sandra Sheets PO Box 2955 Winston-Salem, NC 27102'-2955 (336) 741-0353 - Fax - Once the form is received, RJRT will establish an EFT payment record for your ~ company. A test ACH credit pre-note in the amount of $.01 will be issued to verify '~ and confirm the accuracy of your bank transit routing and bank account number. At ~ the end of this process, your EFT payment record will be activated for all future payments associated with your vendor number. 78 • Electronic Funds Transfer (EFT) © R. J. Reynolds Tobacco Company 2000 IssuedNovember20e0 ,,~e _77o-1',?3
Page 73: bni94c00
The Dial Using - (Your Modem) windows appears. QiaRng uaing ThinkPad Mudem A DLfn3 P.!R Rb:cco Cunsag 9.30U4i71535 ~ ~ ~~~ Liiaaay5t~ hos ~~.._ ~_ Catl51al21cs - . ~ . . Sejctj NaneJ ~ Par.;:l ~Tatdaah:G 5tedoithrsCa7:7:17F9 .. ./,aJCmnet3:n" eNry.. Tnremir.ini?y . , ~ a:_n~-,venhy ~ ' [~i'~ Alt; TG~- l Dia r ~'I Ccl!raacssdio~... Procomm dials the number, connects to the RJRT system, and displays the logon prompt in the window. T~a..Teaw:oe=~~ ~ ~ ! t ~Procomrn Plus Readyl Preeemftrt Ptus Raady! jEnter !agrm id: 4. Enter your logon ID. Press the Enter key. Procomm Ptus Raady! Procomnt Plus Raady! Enter !agon id: N[J6CTE5T Enter password: I 5. Enter your password. Press the Enter key. Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 63 Issued November 2000
Page 74: bni94c00
4. Press the Tab key. The program automatically multiplies the rate times the net cartons and populates the total in the Billed Amount field. To enter additional invoices, pos;tion the cursor in the next available Invoice Number To Retailer field, and repeat steps I and 2 again. A completed worksheet may look similar to the example below: .. ~. ~ . ~ ?et>~11Su.ai:;cYracki:a'i9'iuik[=S1tat' . . . ,.~ Ftr:Gtri rr;4y ~ _ r:Nl:"lLM11dH[Vr9f i ucA.d} F3: zifLroid ]Lffil fd~ T~diM IS.AI F$: 7`dydC@"i2 13.Ti1 F6: eJi6A] D7 F' 97]~Lfl C41A7tp7_ ,o-z- ~ r k i i bRGle? Y7WiC~i 1 4 I87=._ ca [anvm CmFOn PilledAnN. randN.xma UPCCndu fkmdQaxx. J Imiokak._ Ir RnAa aANr.rS) tFbin~+ielXne] fJllci13 Ec IJ 'U31= ;PNEiF65~P I :4.R{[4 F-155 HP 733.1P3i 0_'.fY.'SA I #S.JfI 213 A 952;3! 1,EiLp,~6i SP re 5 E3577 OEs41iA _/ Se E0 ! . 193 I 9 B7 O1£Fx13 3xa1E713 L:aME': 4Y F 1CU E1LTF'c5HP dR zw s~~L s s 7ata 6213 C: n1E? F'N03F 1T6] 7713 .Eb :v~idEL LT 33 aX ~' - ~ ~ 3'5c.r Saa ,t 505 ;E13 RFO KA1dEL 1,02 6X W FPT33 CL~'tIFlhU 's%.SLI' '1$i' i R Step 3: Save the worksheet. 1, Click the Save Invoice Worksheet button. The invoice is saved, and the Retail Account List screen appears. Third Line Discounting-RJRT Wholesalers Guide Third Line Wholesaler Spreadsheet (Small/Mid-Size Wholesaler) ® 23 IssuedNov=_mber2o00 'i 4 z -?,? e1e2
Page 75: bni94c00
7. Press Enter. The Zmodem window appears, and the download process begins. This may take a while depending on the size of the file. Please be patient as it downloads to your computer. NOTE: Rememberthe name of the file you are downloading and the location. The BtD for the UPC and Account template files are UPC and ACCOUNT however, Procomm Plus does not assign the same name to these fites. Files are given a number with a.mbx extension. Files with a.mbx extension will have to be renamed with a.zip extension once they are downloaded to your hard drive. f1--,iri fi4._b4`,n~t:; . FB, ~ B:I.AF~]i~':_ . qn fitdi rJm¢~Sn•i FZ~'JuA=.i ~ FieLenalh~. ~ ~ Bstsca.x'rE1 ~ 0 Caixi~n'inp _ 3v~n T;.inacrstahr.c ' I ~ 6.Y<hmauJing. ~~ ~ ~ f-,[,;~mrndaliarfia{al:haml•-;rc.d . 8. After the file has been 100% downloaded, Procomm will return to thecommand line. To download another file, repeat steps 1-7. . 9. Click the Disconnect button. Your session is closed, and the line is disconnected. HyperTerminal Introduction to Uploading and Downloading Files Using HyperTerminal Files that contain third line wholesaler data must be "zipped" or "compressed."This ~ data is.comp'ressed so it can easily be uploaded to RJRT in a short period of time. ~ NOTE: Winzip°, a popular file compression package, can be downloaded off the i~] Intemet free of charge. Access http.//www.winzip.com to obtain a free evaluation p copy. . O When you are ready to send your zipped third line wholesaler file to RJRT for cc payment, you must upload it using Procomm Plus or a similar File Transfer Protocol 01V (FTP) program such as HyperTenninal. Uploading sends the files electronically to RJRT and stores the file on their server to be processed for payment. When uploading files using Procomm Plus or HyperTerminal, you will use a ' command line syntax. A syntax is a combination of entries that execute a particular Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 65 IssuedNovember20o0 - P~q /,~y0 /1 92
Page 76: bni94c00
This UPC table is view-only and cannot be changed. 1. Click the Navigation (Goto) button and select Goto RJRT UPG Table. The 12JRT Brands/UPC Table appears. ~ . __........ CAt~Y'J_ SStQ 32A]'t>133IC 1~.i1Fi6 15ta 72S]t0:13 ~ F85S7 ... 12'Olt[I793 U:AEL F F 5 hP $i6 ~~ ^.iI- -LT F e58P ii;Lr:i11:.i_TP lp7 3 LTFaSHP R~D 1<P7dEL~P&9 BY 1ELF 1-Q 5P fiEl1 !FhiELLT93 61; 2. U Y:+-AIELd@@2 Fx t) VAlnIELLftfr2+5 n:mau- z;i tri':c~ .e es cv Use the vertical scroll bar to review the followin,~ information: • Brand names. • Brand codes. • UPC codes. • UPC descriptions. Working the Retail Account List Introduction The Retail Account List displays the retail accounts you service. 7mr?'.' ._....777= ~6a 'uttk~~^ ~d.ib..adle:'Crv~ :<CccllZFl. LP+1n 1:.1eC a{!QfJ I,.i. F7. t., .:azi'?3ltfs?:~ f RT[n.p7e .:d1ePvF~a i :LTtJ-92:'i~~.9 1JT+S4 I;i~fl!i~tus 1'rJ3.r~1.1?3tS8 . ~ FJFI ~.._I i ~C ur~Friv_,~v netr~r<.f:a~ M1 di_° I ... BOOTH GnI171TBiY NART 1!dM I-THWAY 62 W ~ ~~ PP.;Tf41LLE.ALxx'G7-79:_, ~ GA.lJEL . k'rin6PQN U.Qq t26A4'- iJi70M .€:53 T'1Bm 12/3LC9 $3.75 12l3CJfFJ 12t17a . $e.0;7 1:716ArJ 12E1 .fA VlsNTAGE . .5&M 1dt3AAYJ _ 1?I31tCl7 6pAAL €A.60 12iH€A7] 12i17&fl SS.f~i 92:'1&7k7 1231.tv] ..".eee.ee...:.. .~~~_ SALEA9 . . i7.75 32~flIX7 17117k® $4.03 1J1[LC47 1?131.Cll Other items displayed on the list include:- • Retail Account Information-Displays your wholesaler customer number, contact information for the retail account, F TRT SIS number, and chain ID. 9q%J0 .$1 3 ~ ._-tLSI.. 16 • Third Line Wholesaler Spreadsheet (SmalllMid-Size Wholesaler) © R. J. Reynolds Tobacco Company 2000 - Issued November2000 ~~e, le" ar~ ~
Page 77: bni94c00
Terms and Conditions for Electronic Funds Transfer Payments By submitting the completed and signed Electronic Payment Enrollment Form on the reverse side of these terms and conditions, your company agrees (a) to accept payments from RJR through Electronic Funds Transfer (EFT). (b) to these Terms and Conditions for Electronic Funds Transfer Payments and (c) that we can rely on the Information you supplied on your Enrollment Form. For purposes of the Enrollment Form and these Terms and Conditions, 'RJR' refers to the following business entities: (1) R.J. Reynolds Tobacco Company (2) R.J. Reynolds Tobacco, Avoca Division (3) R.J. Reynolds Tobacco International (4) Sports Marketing Enterprises, Inc. (5) R.J. Reynolds Tobacco Holdings Co. The following Terms and Conditions are hereby incorporated into all existing commercial - agreements between your company and RJR: RJR will initiate Electronic Funds Transfer (EFT) payments as follows: 1. The electronic funds transfer will be made to the financial institution and bank account number shown on your enrollment form. 2. We will make payments in accordance with and governed by the National Automated Clearing House Association's (NACHA) Corporation Trade Rules. Our process is governed by and in accordance with Article 4A of the Uniform Commercial Code. 3. The information you provided on your enrollment form is important. You understand that any changes in that information must be communicated to R.J. Reynolds Tobacco Company by an authorized representative of your company in writing (within 14 days of the effective date), to allow us to respond to your changes. RJR will not be responsible for any loss which may arise solely by reason of error, mistake or fraud regarding this EFT Enrollment Form information. Payment will be initiated within the time specified in our commercial agreements with you. These EFT terms and conditions neither enlarge nor diminish our respective rights and obligations contained in applicable commercial agreements. The existing payment due date (previously used for checks) will be extended, as agreed upon in your EFT Enrollment Form, for all EFT payments. We will consider payment made when your financial institution has received or has control of the payment transaction. If we initiate payment on a non-banking day at RJR's originating bank, the funds transfer will occur on the following banking day. In all cases, Banking day is defined as the day on which both trading partners' banks will be available to transmit and receive these electronic funds transfers. You should notify RJR immediately if payment is not received as described above. 5. RJR has the right to adjust future payments if payments previously made are found to be duplicate, in excess of requirements, fraudulent or in error. 6. RJR will make electronic payments in accordance with these Terms and Conditions. RJR is responsible up to the point where your financial institution receives or has control of the transaction. RJR will be responsible for loss of data only when it is due to the sole negligence of RJRT or its originating bank. 7. Electronic Funds Transfers can be terminated by either party, providing that notification is in writing and that both parties agree on the termination date. RJR will initiate and confirm the banking ACH pre-note process prior to activation of this enrollment agreement. Written notice of the EFT activation date will be sent to the address provided on this enrollment form. ~ a28ooz6b -)Third Line Discounting-RJRT Wholesalers Guide Forms • 85 W ssued November 2000
Page 78: bni94c00
The Connection Directory window appears. 2. Select RJR Tobacco Company in the Entries list. ._. ... . ._._.._.._ _~.___ _____. .. __:.._...._. 1116: , R„GI2 I ~0112 ~ E.R9 I HiY i ~ o FJNT+ma 4~~ . ~ - 'lle linte~. ~ 4J^ i i ~o1+~.k1` w) lmr,al zam~ FDdi•tJONli!+Ah °_.:0$ cnd ~ ]iJ .. 3. Click Dial. The Dial Using - (Your Modem) windows appears. e ; r~JflTct~«ol~crcp~+i 9.JCC~?1T9 Giialuy Slah Imi ~ - Call$f~j;l~ ~ Sn¢t [N~m] I I Posa7 ~ Totdc.~ts:0 SLcihNk-sw9:117FAf , L~.-:~xnccC.n~~en@y 'i Tniem:r~iio} xnwienkp C4ner`d C3CFiqWrcf5 Di&tincn,cl 1 Didtme. Ulding cdl C-,)I poceedir.a _ ~ Procomm dials the number, connects to the RTRT system, and displays the N logon prompt in the window. ~ O !x [Y'f•.._Lnv.. CH l n Jec x .. __.. edp i;+ nli .]=G IIOmnC_ .°-W 'Proeamne Plus Raadyl '.,Prnenmrrt Ptus Rautdy! Enter fcgvn id: Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (1,prge Wholesaler) 59 Issued November2oe0 ///~E' J~u' O7C
Page 79: bni94c00
After the file has been created according the definitions listed above, you are able to view the UPC Code Table file. A sample of the UPC Code Table file is shown below. . File Header UPC Table Record File Trailer 071510CAHEL OOPC TNBLE 0115'f DCAHEL 011518CAHEL 011518CANEL 811518CANEL 0115'lDOAHEL 011514CAHEL 011510GAHEL 01154091HSTDH 111154000STrdN NST9N STAH THSTflH 40HIHSTnM 15401fINSillH A115LOllINSTDN 0115r;OHIHSTDN '011540VIHSTBN '.011540BIHSTIDN ',011540HIHSTDH 011548VIHSTDt{ 01T540VIHSTDH 071540#riH5T0H B40PC THBLE - Record ID. - File name. - Date and time the file was created. - Filler information. . Detail Record-The detail record displays the following items: 200 e 0 5 .' 1230010118CANEL NF 70 1230010219CANEL F 85 SP 1230010818CANEL F 85 HP 1230010Ii19CANEL LT F 85 SP 1230810518CANEL LT F 100 1230010713CANEL LT F 85 HP 1238015418RE0 KBHEL FF 83 BR 1230016213G0NEL.F 109 SP 12300704369dIH OLT YOBB $4BFF 123D070912HIITSEL F 85 123UP704S6HXt! SEL F 85 $48Ff 1296A704431tIN SEL F 05 BSBSF 123D0710138IH SEL E 92 68 128007103fiVIN SEL 83 8 $bBFF i29007iBb3HIH SEL 83 0 B5C5F 1230071118UIN SEL LT F 85 1280071143HIH SEL L 85 BSGSF 1230071213HIH SEL LT F 83 01{ 1230071243HIH SEL LT B B56SF 5038670313VI1#STOH OLT F 82 B 803D07B413HIHSTOH OLT F 10®B 5030070913HIN SEL F 85 60a00Ti01afIH SEL F 83 DX DBOma Account Template After downloading the UPC Code Table file, you must download the Account Template file. This file contains the retail accounts, brand family, discount dates that the direct account should apply the third line discount for the month. The Account Template provides file definitions that format your data to RJRT standards. Prior to viewing the Account Template file, you must configure a spreadsheet or data file according to the definitions outlined in the template. There are three record types in the Account Template file: • File Header Record-The file header record displays the following items: Record ID. RJR SIS wholesaler number, name, and account number. Wholesaler supplier number. Filler information. RJR account chain ID. Account name, address, city, state, zip. Brand family code. . 50 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 . . _ -- . ~ Issued November 20oq~ ~£ y~ ~' ~i'.
Page 80: bni94c00
4. Select Rename from the menu list. . t]Ptn reth. ~ . . . . . ~tan wlJr Ncdcn Ar~ifiras ~ Q,ickW~i+wP!us .. ~_ t;uck F;'r~t ~ L; 4[dlto'sY+ . ~ ~. V2 ,&~j tald_U'S0.3p . ~4o 7p anAF6injlfle(F_F'1ap ~ ~ Faltnniex 5. Rename the file extension to zip or, to better track your files, you may choose to rename the entire file to "account.zip" or "upc.zip". 6. Press Enter. an. G~ Fw~ c: la[l; &ip ~ ~....._ , .... Cl .....-~ .'~~. _ ~ dy .. . t~l ..Y4''.. . ~ MauDmre C[. Pa9u L: ry, Dek G, F,ddmss JJk mi i'I(g9JoYMIpCd p~`~~„` H1hILHepY1c ki!»p - ?7~C~ Irtainet Exdnor ' - G1~0 Iame9a The file is renamed and given a.zip extension. Opening a zip File To open a zip file: 1. Double-click the WinZip icon on your-desktop. NOTE: If you do not have the W1nZip icon on your desktop, Choose Start, . Programs, WinZip, WinZip 6.3 32-bit to open WinZip. - \0 '.6 ND CO O CA ~ Third Line Discounting-RJRT Wholesalers Guide File Transfer. Direct Communications (Large Wholesaler) • 73 Issued November2000 A~~ ' o7-44?
Page 81: bni94c00
Data Element Format Length Position 17 Account State A 2 148 18 Account Zip N 5 150 19 Account Zip+4 N 4 155 20 Brand Family Code N 4 159 21 , RJR Display Code - A 9 163 22 Start Date N 8 172 23 End Date N 8 180 24 Discount Rate N 5 188 Record Length **File Trailer Record** 11 Record ID 192 2 1 12 File Name A 20 3 13 4 of records in file N 7 23 14 Filler A . 163 30 Record Length - 192 File Header Notes yyyymmdd yyyymmdd 3v2 - 999.99 One Trailer Record per file value'99' value'ACCOUNT TEMPLATE' Count includes header and trailer records (all records) After the file has been created according the definitions listed above, you are able to view the Account Template file. A sample of the Account Template file is shown below. .4eccicu~d 6LY '~" - u _0 ,: _~ ~. _ ~_ _ - - ~ 00ACGOUHT •CEHFSATE 200010040833150 B1fi50643U T F41C7ntHY lititrf5 6962511C3440-001 BOOTH COIIHCRY 1fBRT 1958 HIGBYAY 82 V NSiA77VYlYY hL3Gdb770271510Y006Q366220001205200012.1700400 01690643H T HACIBET BUHTS 696251143440-001 BOOTH COLRiTRY nART 1956 HIGR#AT QZ V FRAITUIBLE AL360b77827151QP00B4386220001.2182000123100450 01690643H T HAC3TEY ifU11S 6962511;3440-001 BOOTH [OUNCBY niRT 1959 lt1GHEkAY 82 11 PRATT7ILt.E A13606778271540%00803854200012042000121700375 Detail Record 0169064311 T HAG:'U7EY HUNTS 696251143440-001 HOOTH COZINI'RY NABT 1958 HIGH~tAY 82 V PRATTVILIE AL360677B271S40L90BR38542000123820001233004A0 01690643H T HLC7Ui6Y H[RT3^a 6962511S341Q-DO1 HOOTH C001tlRY HART 1958 HIQIttAY 82 II PRATTVILIE iS3606778271535PQOBk36632000120d2000123Y00d50 0169064311 T HACAfiE3' HURTS 69625L14344Q-001 BOOTH COUIIfRY liART 1958 BIGAVAY 82 V `10 FRATi'VILLE 1tL360577827i5tfiA008R39832000120•1200012i700450 ` File Trailer ATE 000000@ - 99AQW71HT TkHF1 10 , !v CJ a C0 52 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 ~.~ IssuedNovem6er200a F Sl 07`'J0 2
Page 82: bni94c00
HyperTerminal logs on to the system and displays a logon successful message. After the message is displayed, the system atietnpts to make an outbound connection and displays a command prompt. :. c Y..; w LraV~~ Ld ~- I -- '£ntar logon id: nuwtrt ',jEnter passward: . Rttamptin9 lagnn.. . ~~ xx LGGON SUCCE55FUL ww - Directory where file is stored (downloaded) _ . Neking autbaund cnnncction...CONNECTE6 . . ,~Tne current File Tranafler Protocol is ZNOaEM. i [Gc\SPC3\USER\NUNTEST7cwd> 5. Enter the following syntax at the command prompt: $$REQ ID=(your user ID) BID=(third line wholesaler file name) The command line entry should look similar to the following example: [C:ySPC3\USER\NUIdTEST]cmd?$$REQ ID=NU1dTEST BID-'flCCOUNT' 6. Press Enter. HyperTerminal displays a message indicating that it is ready to send the file. 2MDDEM ready to send file(s) Please start file transfer within JF5 seconds x~eek76n0i70ee4D 7. The Zmodem window appears, and the download process begins. This may take a while depending on the size of the file. Please be patient as it downloads to your computer. NOTE: Remember the name and location of the file you are downloading. The BID for the UPC and Account Template files are UPC and ACCOUNT however, HyperTerminal does not assign the same name to these files. Files are given a number with a.mbx extension. Files with a.mbx extension will have to be renamed with a.zip extension once they are downloaded to yourhand drive. . ' ? Rc:er,i,,3~~ ~ F1L"cCq4t!t,V~ . ~---5'.aii[j5s. F +TILDP:TSDr.YlcyrFILE07d759f^f '~ F7eg.~1 . East+v~a~EnddGle ' ~ ~4etiiez . chlu: ~Finohcvi ; Fl,,b°zd ~ OJO'c07 ~. Pem,rinq F 171bcps Thvvc}ptx ~+~7 Third Line Discounting-RJRT Wholesalers Guide File Transfer Direct Communications (Large Wholesaler) • 71 lssuedNovember2000 ~ ~ ~ - ~~ 7dp7~~
Page 83: bni94c00
5. Double-click on the file you want to open. The file opens as an ASCII text file. You will be responsible for inputting the file information into your customer database. 9PqCCViRMT TEW467E 2?!~~u1Hf818B1gD3 Of69064311 T HACKNEY HUI , BF644G4@H I HRCKNEY AHHT# 69625tt4S468-00i 69425it43kaP-®Ri 01b9064311 T HACKNEY 1HINTS 396251143440-601 S{L90648H T HACKNEY H9N:Y3 896251143440-0A1 016904423 T HACKNEY HUNTS 696251142440-8A1 Si.d996s8H T HACKNEY HUNTS 69625TS43$RO-OSi DId9U6k3N T RACRNEY HUNTS 69d251142k40-001 8#6996b3B T HACKNEY NUNTS 696251VIS9h11-001 01690663H T HACKNEY HUNTS 69625t1424A9-8A7 812553bON T HACKNEY RN9R 322987509917-001 A125S340N T kA6KH[Y kHOX R229E75AU917-OAi 912553604 T HACKNEY KNOS 322907509917^ODi 852558kON T HACKNEY HNX 922937509917-081 0125'i95011 T RACKHEY KNOX 322987504917-BUt Hf2558b0H T HACKNEY HN9% 822987509917-9H1 012553b011 T NACNNEY KNOX 3229R7509917-001 Ui2559LOH T HRCKNEY KNO& Y8dY06599N5-®97 01255260H T HACKNEY KNOX 9364A6503]15-007 Rt2559bCH T HACKNEY RH9'6 93b486590715-007 01255526OH T HACNNEY HNOX 936AA6500715-007 02553603 T HACKNEY RNOS 93648b590715-887 0t255260N T HqCNNEY NNDX 9365A650A7i5-006 6124724311 T NACKHEY PADU[RN 337142591812 CO1 012472434 I HACKNEY PADUCAH 327142591812 40 0124724311 T HACKNEY PAOUCCN 337142591812 ORi 9t2472§3H T HACNNAY PRD9CAH 337t42591312 081 0124724311 T HACKNEY PADUCEN 337142591812 80/ H521i72-03N T HACKNEY PADUCAR 887142591812 001 0124724811 T HACKNEY PADUCAN 237142591812 801 0124724311 F HACKNEY PODUCqH 337142591812 01N 012472L3H T NACNFU_Y PADtlLkF' 337142591812 011 UDOTN COUNTRY NART HP9rH CHUNTHY HPRT U00IN COUNT8Y HART 8UHYN cUUNTHY NAHY RODTH COUNTRY HRRT $UOIH COUNiHY HNRT ROOTH_COUNTRY HART BOOTH CUUHTBY HART AA9TH COUNTRY HART BENNY PIUiH'.fR RENNV PJONEFR HENNV PiOHEER KEHHY PLONE£H NENNY PIONEIIt HtHHti P59N££R NENNY FIONEER 2b999999SEVIRVILLE CPNOC9 260000005EU1RUILLE C9NOC0 2b9999905EV1R4ILLE.C9H940 26000A005EUIRUILLE C8NAC0 2b999099SEVYRUILLE COHOC9 2600000®PTCEON FORCE CONOCO SESSER SON HSRT SESSER SUN HART SESSER SUN NHRT SESSER SON 11RHT SESSER SUN 1fART SESSER SUN NAHT SESSER SUN NART SESSEN SUN NART SESSER SUN HART N 76 • File Transfer Direct Communications (Large Wholesaler) © R. J. Reynolds Tobacco Company 2000 : Issued Novenlber2000 ~it~8 7s- o•>('d'-3

Text Control

Highlight Text:

OCR Text Alignment:

Image Control

Image Rotation:

Image Size: