True Value® - Schedule

This form is used for setting processing times for various True Value operations which retrieve data (data is placed in the designated "download" folder for your company's access). To access these settings, you select "True Value Schedule" from the menu marker Menu_Marker_Icon context menu found on the EDI folder tab of the Branch Setup form (Maintenance, Database, and Branches).

As a secondary function, this dialog also allows a company to reset the date or sequence number to retrieve prior data files. Clear the last run date to re-run the most recent date-only process or change the sequence number to the desired file sequence (the processes are assigned a sequence to distinguish each occurrence). Click OK to save changes made to the form (you should also choose Process (F12) from the Branch Setup form in this case), or select Cancel to not commit any changes made. Changes to sequence numbers and dates won't immediately retrieve files. You can check this dialog again to see if dates or sequence numbers have been updated which will indicate processing.

Main Menu > Maintenance > Database > Branches > Branch Setup, EDI, True Value Schedule (Context Menu)

Before using EDI in a "live" (green) state, the "Last Seq" column should be updated to indicate the most recent starting sequence sent by True Value Company. This is provided by their "weekly file maintenance sequence" report. Below you will find an example of this report. The numbers change each week, so make sure you have the latest report. Usually, you would only need to do this once unless you want to retrieve past files again (past files are kept in an "archive" folder, so this should not be necessary).

66File Maintenance Sequence V2 Report As Of Monday, October 17, 2016

Sequence Number Range Available on the Server

 

Starting Ending Folder  File Name  Description

Range         Range

 

530  139  \MRI_UPDATE MRInnn.DAT  MRI Invoices

219  258  \EDU_UPDATE EDUnnn.DAT  Direct Ship Vendor Invoices (EDU)

550  564  \TIER_MAINT TIERMnnn.ZIP Weekly Tier Maintenance

550  564  \TIER_PRICE TIERPnnn.DAT Weekly Tier Pricing Maintenance

550  564  \LONGUPDATE LONGDnnn.ZIP Weekly Long Desc and Picture Id

550  564  \IMAGUPDATE IMAGEnnn.ZIP Weekly Image Maintenance

550  564  \COUP_MAINT COUPMnnn.ZIP Weekly Coupon Maintenance

550  564  \COUP_PRICE COUPPnnn.DAT Weekly Coupon Pricing Maintenance

648  662  \UPC_UPDATE CIIFUnnn.ZIP Weekly UPC Maintenance

651  736  \EVENTUPDAT EVENTnnn.ZIP Events

510  524  \VDRTUPDATE WVDRTnnn.ZIP Weekly Vendor Direct Information

510  524  \VLOTUPDATE WVLOTnnn.ZIP Weekly Vendor Location Files

510  524  \VNOTUPDATE WVNOTnnn.ZIP Weekly Vendor Direct Ship Notes Files

881  972  \TVRCUPDATE TVRCnnn.DAT  True Value Rewards

 

DATE ONLY FILES

 

10/14/2016  \FINEUPDAT2 CIIFF001.ZIP Fine Line File

10/17/2016  \OPENUPDATE OPENORDR.DAT Member Open Order File

10/17/2016  \SHIPUPDATE SHPLATER.DAT Member Ship Later File

10/17/2016  \RDC_UPDATE RDCBAL01.ZIP Harvard RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL02.ZIP Cleveland RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL03.ZIP Manchester RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL04.ZIP Atlanta RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL06.ZIP Allentown RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL07.ZIP Kansas City RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL08.ZIP Kingman RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL09.ZIP Corsicana RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL10.ZIP Mankato RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL12.ZIP Denver RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL13.ZIP Woodland RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL26.ZIP Springfield RDC Balance File

10/17/2016  \RDC_UPDATE RDCBAL41.ZIP Central Ship RDC Balance File 

Description

Provides a text explanation of the type of process.

File Name

The file name used for the data transmitted or received by the process. The file names sometimes include the store number or a sequence number.

Schedule

The frequency that the process runs. Valid options are days of the week (MON, TUE, WED, THU, FRI, SAT, SUN), every day (DAILY), every hour (HOURLY), or disabled (OFF).

Time(s)

For daily and day of the week schedule types, a specific time of the day is indicated. For an hourly schedule, a range of times is used. Times are entered in military time (a 24 hour period) ranging from 00:00 to 23:59 (HH:mm).

Last Run

The date that the process last run. This can be cleared to reset the schedule and reprocess the most recent item (as indicated by the sequence).

Last Sequence

Sequence numbers are used to keep track of each process instance and are assigned by True Value. The sequence will change each time the process completes. When setting up EDI and the customer is ready to go "live" with EDI processing (changing from "yellow" to "green" mode), these should be set to match the latest starting values from the most recent weekly file maintenance report. The maximum sequence number is 999. When a rollover occurs, the next sequence after 999 is 001.