Specifications
This topic is provided for member and development reference and includes technical specifications for the file data provided by True Value Company. This (Help) documentation is not updated by True Value, so the latest changes by them may not necessarily be reflected here. Specifications are current as of the dates listed here or within the specification documents if provided.
Description |
Filename |
Schedule |
Time(s) |
Last Run |
Last Seq |
Spec |
EDI Function |
Notes |
Retail Fine Line Description |
CIIF001.ZIP |
FRI |
8:00 |
9/9/2016 8:00 |
0 |
DS009 |
Extras - Department Class Fineline Load + Nightly Automatic Routine |
Adds department, class, and fineline descriptions to Item Maintenance screen and Catalog screen. Stored in table DeptClassFineLine in the database. |
RDC Balance Files |
CIIFRnn1.ZIP |
DAILY |
5:00 |
9/14/2016 5:00 |
0 |
DS012 |
Extras - Warehouse Qty + Nightly Auto Routine |
Loads warehouse qty in catalog, also displays in special order dialog in orders and in catalog tab in folders |
Combo Stock Invoice/Relay |
MRIxxx.DAT |
HOURLY |
7:00-19:00 |
9/14/2016 14:00 |
0 |
DS013 |
PO Update |
Updates the PO from the True Value invoice. Updates quantities, costs, and adds new items to the system |
Vendor Direct Ship Terms |
WVDRTxxx.ZIP |
FRI |
8:00 |
9/9/2016 8:00 |
0 |
DS015W-DRT |
Not Used |
|
Vendor Location Files |
WVLOTxxx.ZIP |
FRI |
8:00 |
9/9/2016 8:00 |
0 |
DS015W-LOC |
Not Used |
|
Vendor Direct Ship Notes |
WVNOTxxx.ZIP |
FRI |
8:00 |
9/9/2016 8:00 |
0 |
DS015W-NOT |
Not Used |
|
Direct Ship Vendor EDI Invoice |
EDUxxx.DAT |
DAILY |
5:00 |
9/14/2016 5:00 |
0 |
DS024U |
Extras - PO Receive Direct Ship |
Works like PO Update. Can create and add to existing PO's. |
Item Images |
IMAGExxx.DAT |
OFF |
|
1/1/0001 12:00:00 AM |
0 |
DS057I |
Not Used |
New TV EDI uses images on demand, so this isn't used. |
Long Description and Image IDs |
LONGDxxx.ZIP |
FRI |
8:00 |
9/9/2016 8:00 |
0 |
DS057W |
Images Download |
Worked with TruStart 2 to set image id for images directory |
Multi UPC Maintenance |
CIIFUxxx.ZIP |
FRI |
8:00 |
9/9/2016 8:00 |
0 |
DS062,DS063 |
Extras - Bar code Load |
Adds additional barcodes to items - This will ask for the FTP server. This will only pull the all UPC file from the FTP server. If you wish to do maintenance of barcodes, run this without connecting to the FTP server and it will load the weekly file. |
Event Order and Pricing |
EVENTxxx.ZIP |
HOURLY |
07:00-19:00 |
9/14/2016 14:00 |
0 |
DS071 |
Extras - Promotional Item Update |
Loads Promotions into the Inventory - Utilities - EDI Promotions Screen |
Member Open Orders |
OPENORDR.DAT |
DAILY |
5:00 |
9/14/2016 5:00 |
0 |
DS072 |
Extras - PO Receive Open Orders |
Works like PO Update. Can create and add to existing PO's. |
Orders on Ship Later |
SHPLATER.DAT |
DAILY |
5:00 |
9/14/2016 5:00 |
0 |
DS073 |
Extras - Ship Later |
Allows displaying the current ship later file, or downloading a new one. Ship later can also be displayed through PO Entry - F5 - Ship Later. |
Tiered Item Maintenance File |
TIERMxxx.ZIP |
FRI |
8:00 |
9/9/2016 8:00 |
0 |
SPEC40 |
File Maintenance or Nightly Routine |
Updates fields in inventory and the catalog. Adds new items to the catalog that are missing. |
Tiered Price Maintenance File |
TIERPxxx.DAT |
FRI |
8:00 |
9/9/2016 8:00 |
0 |
SPEC41 |
File Maintenance or Nightly Routine |
This is the second file that is pulled for File Maintenance for True Value. It contains pricing information and other fields. |
Coupon Tiered Item Maintenance File |
COUPMxxx.DAT |
FRI |
7:00 |
9/9/2016 7:00 |
0 |
SPEC40C |
Extras - Coupon Maintenance or Nightly Auto Routine |
Adds or updates coupon SKUs in the system, much like File Maintenance does. |
Coupon Tiered Price Maintenance File |
COUPPxxx.DAT |
FRI |
7:00 |
9/9/2016 7:00 |
0 |
SPEC41C |
Extras - Coupon Maintenance or Nightly Auto Routine |
This is the second file that is pulled for File Maintenance for True Value. It contains pricing information and other fields. |
TVR Customer File |
TVRCxxx.DAT |
DAILY |
5:00 |
9/14/2016 5:00 |
0 |
SPEC95 |
Extras - Customer Enrollment Load and Nighty Auto Routine |
Loads records into the TV Rewards table, updates customer record, or Adds both if they do not exist. |
All Item Tiered Maintenance |
ALLTMnn1.ZIP |
OFF |
8:00 |
1/1/0001 12:00:00 AM |
0 |
SPEC45 |
Extras - Catalog Load |
Available upon Request from TV Retail Systems and Pulled from FTP, set to “ON” to pull manually from Extras and then return it to “OFF” when finished. |
All Item Tiered Price Maintenance |
ALLTPRCE.ZIP |
OFF |
8:00 |
1/1/0001 12:00:00 AM |
0 |
SPEC46 |
Extras - Catalog Load |
Available upon Request from TV Retail Systems and Pulled from FTP, set to “ON” to pull manually from Extras and then return it to “OFF” when finished. |
All Coupon Maintenance |
ALLMCOUP.ZIP |
OFF |
8:00 |
1/1/0001 12:00:00 AM |
0 |
SPEC45C |
Extras - Coupon Load |
Available upon Request from TV Retail Systems and Pulled from FTP, set to “ON” to pull manually from Extras and then return it to “OFF” when finished. |
All Coupon Price Maintenance |
ALLPCOUP.ZIP |
OFF |
8:00 |
1/1/0001 12:00:00 AM |
0 |
SPEC46C |
Extras - Coupon Load |
Available upon Request from TV Retail Systems and Pulled from FTP, set to “ON” to pull manually from Extras and then return it to “OFF” when finished. |
Member's Purchase History |
MmmmmmPH.DAT |
N/A |
N/A |
N/A |
DS064U |
Extras - Inventory Load |
Loads the inventory file from a purchase history data file. The Data File is retrieved from True Value's FTP server. (It has to be requested.) |
|
Files Sent to True Value |
||||||||
Order File |
SENDORDER |
|
|
|
|
DS020 |
Submit Purchase Orders |
|
RPE Upload File |
|
|
|
|
|
SPEC03 |
Extras - RPE Extract |
Sends the RPE Extract file to True Value. Notes from True Value: This file is used to setup member's Retails based on Level 1 or level 2 pricing. This file is used, as an input file, to create an Excel spreadsheet that the member will use to determine which method they will use. It contains all items from the member's retails system inventory file. This file will also be used for the AIM extracts.
|
TVR Customer Enrollment File |
|
|
|
|
|
SPEC96 |
Extras - Customer Enrollment Send and Nightly Auto Routine |
Sends data from the TVRewardsCard table to True Value. The data contains any new or changes to an existing True Value Rewards member. |
POS Data Extract - TV Workbench |
|
|
|
|
|
DS090 |
Extras - POS Data Send and Nightly Auto Routine |
Sends the POS data workbench file to True Value. |
Data Capture Inventory File |
|
|
|
|
|
SPEC97 |
Extras - Full Inventory Send and Weekly (through the hourly routine, but only sends on Saturdays 10pm.) |
Sends the full inventory to True Value for the workbench weekly. |