Placed Machine ASCII Download is a new program in Rev 15 that allows you to download all placed machines into an ASCII Tab-Delimited file. This can be found in 17 System Manager> 1 System Manager Submenu> 3 Serial> 21 Placed Machine ASCII Download. This file can then imported into Excel, Access, etc. When accessing this program, the operator should choose a disk printer from the printer selection menu. Since there are more than 132 characters on each line of the download, it will not be able to be printed to an actual printer.
Location: 17 System Manager> 1 System Manager Submenu> 3 Serial> 21 Placed Machine ASCII Download
Filename: LMSY321
Screen Sample:
Fields:
Beginning Ship-To Customer Number, A’ll Or E’nd
Ending Ship-To Customer Number
Enter the range of Ship-To Customer Numbers that should be included on the download. Enter “A” at the Beginning prompt to download all customers. The download will only choose machines placed at Customer Numbers that are within the range entered.
Beginning Item Number Or A’ll
Ending Item Number
Enter the range of Item Numbers that should be included on the download. Enter “A” at the Beginning prompt to download all items. The Item Number from the Serial File will be used to determine if the machine is within the Item Number range entered.
Beginning Product Class Or A’ll
Ending Product Class
Enter the range of Product Classes that should be included on the download. Enter “A” at the Beginning prompt to download all Product Classes. The Product Class from the Item File will be used to determine if the machine is within the Product Class range entered.
M’etered Machines, N’on-Metered Machines, Or A’ll Machines
If the operator answers this question with M for metered machines, the download will check to see if the machine is on a contract, and that the Enter Meter field for the machine is set to Y for yes. If so, the machine will be included. If the machine has Enter Meter field set to N for no or if the machine is not on a valid contract, it will be skipped. If the operator answers this question with N for non-metered machines, the download will check to see if the machine is on a contract and that the Enter Meter field for the machine is set to N for no. If so, the machine will be included on the report. If the machine has Enter Meter field set to Y for yes, it will be skipped. The download will not skip the machine if it is not on a contract. If the operator answers this question with A for all machines, the download will not check the above criteria.
Include Machines On Custody To A Customer (Y/N)
Enter Y for yes if machines that are on custody to a customer should be downloaded. Enter N for no, if custody machines should not be included in the download.
Download Description From I’tem Or S’erial File
Enter I for Item if the Description field from the Item File should be used for the download. Enter S for Serial if the Description field from the Serial File should be used for the download.
Download Phone/Fax/Branch From C’ustomer Or S’erial File
Enter C for Customer if the Phone Number, Fax Number and Branch Number from the Customer File should be used for the download. Enter S for Serial if those fields from the Serial File should be used for the download.
Use I’tem Type Field Or A’ccessory Field To Determine Accessories
There is a Machine or Accessory field in the download program. The program needs to know how it should determine if a Serial Number is actually a Machine or an Accessory. Dealers can either set up an item as being an Accessory by setting the Accessory Y/N field in the Item File to a Y, or the item may have a certain Item Type (in the Item File) that signifies an accessory. Enter an A at this prompt to use the Accessory Y/N field. Enter an I at this prompt to use the Item Type field.
Enter Up To 10 Item Types For Accessories
This prompt is asked only if the “Use I’tem Type Field Or A’ccessory Field To Determine Accessories” is answered with I (Item Type Field). The program will check each item before it downloads it to the ASCII file. If the item has an Item Type (in the Item File) that is equal to one of the Item Types entered at this prompt, it is assumed to be an Accessory.
Information in ASCII File:
Note the file is Tab-Delimited. The file is sorted by Item Number and Serial Number. Only machines that are placed at a customer site will be included on the report. Machines placed on custody to a customer will also be included if the operator answers the “Include Machines On Custody To A Customer (Y/N)” with a Y for yes.
Ship-To Customer Number: This is the Customer Number machine is placed at, or on custody to and is from the Serial File.
Ship-To Customer Name: This is from Customer File
Ship-To Address Line 1: This is from Customer File
Ship-To Address Line 2: This is from Customer File
Ship-To City: This is from Customer File
Ship-To State: This is from Customer File
Ship-To Zip Code: This is from Customer File
Phone Number: This is from either Customer File or Serial File based on operator input
Fax Number: This is from either Customer File or Serial File based on operator input
Branch Number: This is from either Customer File or Serial File based on operator input
Model Number: This is from Item File
Item Number: This is from Serial File
Description: This is from either Item File or Serial File based on operator input
Serial Number: This is from Serial File
Machine ID: This is from Serial File
Contract Number: This is from Serial File
Active or Inactive Contract: This equals 1 if contract is active and 0 if the contract is inactive, if the machine is not on a contract, or if the Contract Number the Serial File is set to, is invalid.
Machine or Accessory: This equals 1 if the Serial Number is a Machine or 0 if the Serial Number is an Accessory. An Accessory is determined by either the Accessory Y/N field in the Item File, or the Item Type in the Item File and is based on operator input.
Metered or Non-Metered: This equals 1 if machine is metered or 0 if it is non-metered. The program determines a machine is metered, if the machine is on a valid contract, and if the “Enter Meter Readings” field on the Serial Line on the Contract is set to a Y. This indicates that meters are being requested for this machine.
Last Meter Reading Date: This is the last meter reading date entered from contracts stored in the Serial File. If there is no date in this field, the field will be null. It is in YYYY-MM-DD 12:00:00 format.
Last Meter Reading: This is the last meter reading entered from contracts stored in the Serial File.
Meter Due Date: This is the Meter Due Date from the Contract Header File. If machine is not on a contract, or this field is blank, the field will be null. It is in YYYY-MM-DD 12:00:00 format.
Meter Billing Period: This is the Meter Billing Period in the Contract Header File. If the machine is not on a contract, it will be set to 0.
Contract Expiration Date: This is the Contract Expiration Date from the Contract Header File. If machine is not on a contract, or this field is blank, the field will be null. It is in YYYY-MM-DD 12:00:00 format.
Customer Warranty Expiration Date: This is the Customer Warranty Expiration Date from the Serial File. If this field is blank, the field will be null. It is in YYYY-MM-DD 12:00:00 format.
Service Plan: This is the Service Plan of the machine from the Serial File.
Contract Bill-To Customer Number: This is from the Contract Header File.
Contract Company Number: This is from the Contract Header File.