SmartFusion Modules > Utility Billing > Utility Billing System Settings > Handheld Setup > Handheld Types > Type Z

Recent Changes:  
6.169 
- Modifications to include demand indicator "D" to account number if system setting is turned on. 
- Modifications to default settings for determining demand types if Demand indicator and/or Extra line read type is not set in the system file.
- Correction to extra row for demand to ensure demand readings and number of decimals are appearing on the second row.

Transfer to Handheld (Export) - .IMP file

  • H1 Header Record - includes billing cycle, route number
  • D1 Detail Record - includes detail info on each meter
  • T1 Trailer Record - includes billing cycle, route number and count (total detail in route)
  • required fields are in bold
Field Length Start End Format
H1 2 1 2 alphanumeric; left; pad " "
Cycle Number 2 3 4 numeric; right; pad "0"
Route Number 6 5 10 alphanumeric; left; pad " "
Survey1 Text 40 11 50 alphanumeric; left; pad " "
Survey2 Text 40 51 90 alphanumeric; left; pad " "
Survey1 Response Type 1 91 91 alphanumeric; left; pad " "
Survey2 Response Type 1 92 92 alphanumeric; left; pad " "
Survey1 Response Length 2 93 94 numeric; right; pad "0"
Survey2 Response Length 2 95 96 numeric; right; pad "0"
Field Length Start End Format
D1 2 1 2 alphanumeric; left; pad " "
Account Number 20 3 22 alphanumeric; left; pad " "
"D" will be added to end if option is selected in HH system file
Meter Number 10 23 32 alphanumeric; left; pad " "
Read Type Code 4 33 36 alphanumeric; left; pad " "
Read Sequence Number 6 37 42 numeric; right; pad "0"
Constant 6 43 48 alphanumeric; left; pad " "
Number of Dials 2 49 50 numeric; right; pad "0"
Number of Decimals 1 51 51 numeric; right; pad "0"
High Audit Value 10 52 61 numeric; right; pad "0"
Low Audit Value 10 62 71 numeric; right; pad "0"
Location Code 4 72 75 alphanumeric; left; pad " "
Instruction Code1 4 76 79 alphanumeric; left; pad " "
Instruction Code2 4 80 83 alphanumeric; left; pad " "
Account Status Code 4 84 87 alphanumeric; left; pad " "
Address 40 88 127 alphanumeric; left; pad " "
Name 20 128 147 alphanumeric; left; pad " "
Survey Flag 1 148 148 alphanumeric; left; pad " "
Number of Prev Estimates 2 149 150 numeric; right; pad "0"
Previous Reading 10 151 160 numeric; right; pad "0"
Previous Read Date 4 161 164 MMDD
Old Seal ID 10 165 174 alphanumeric; left; pad " "
Field Length Start End Format
T1 2 1 2 alphanumeric; left; pad " "
Cycle Number 2 3 4 numeric; right; pad "0"
Route Number 6 5 10 alphanumeric; left; pad " "
Total Devices from Host 6 11 16 numeric; right; pad "0"
Total Usage Devices from Host 6 17 22 numeric; right; pad "0"
Total Demand Devices from Host 6 23 28 numeric; right; pad "0"
Total Reading Devices from Host 6 29 34 numeric; right; pad "0"

Upload from Handheld (Import) - .EXP file

  • H1 Header Record
  • D1 Detail Record - includes detail info on each meter
  • D3 New Meter Record
Field Length Start End Format
H1 2 1 2 alphanumeric; left; pad " "
Cycle Number 2 3 4 numeric; right; pad "0"
Route Number 6 5 10 alphanumeric; left; pad " "
Start Date 8 11 18 YYYYMMDD
Start Time 6 19 24 HHMMSS
Stop Date 8 25 32 YYYYMMDD
Stop Time 6 33 38 HHMMSS
Meter Reader Id 10 39 48 alphanumeric; left; pad " "
Resequence Flag 1 49 49 alphanumeric; left; pad " "
Estimate Flag 1 50 50 alphanumeric; left; pad " "
Start Mileage 6 51 56 numeric; right; pad "0"
End Mileage 6 57 62 numeric; right; pad "0"
Vehicle Id 10 63 72 alphanumeric; left; pad " "
Total Devices Downloaded 6 73 78 numeric; right; pad "0"
Total Devices Uploaded 6 79 84 numeric; right; pad "0"
Total Read 6 85 90 numeric; right; pad "0"
Total Skipped 6 91 96 numeric; right; pad "0"
Total Blank 6 97 102 numeric; right; pad "0"
Total Trouble 6 103 108 numeric; right; pad "0"
Total Fail Audit 6 109 114 numeric; right; pad "0"
Survey1 Text 40 115 154 alphanumeric; left; pad " "
Survey2 Text 40 155 194 alphanumeric; left; pad " "
Field Length Start End Format
D1 2 1 2 alphanumeric; left; pad " "
Account Number 20 3 22 alphanumeric; left; pad " "
Meter Number 10 23 32 alphanumeric; left; pad " "
Read Type Code 4 33 36 alphanumeric; left; pad " "
Read Sequence Number 6 37 42 numeric; right; pad "0"
Location Code 4 43 46 alphanumeric; left; pad " "
Instruction Code1 4 47 50 alphanumeric; left; pad " "
Instruction Code2 4 51 54 alphanumeric; left; pad " "
Meter Reading/Skip Code 10 55 64 alphanumeric; left; pad " "
Read Date 8 65 72 YYYYMMDD
Read Time 6 73 78 HHMMSS
Trouble Code 4 79 82 alphanumeric; left; pad " "
Survey1 Response 10 83 92 alphanumeric; left; pad " "
Survey2 Response 10 93 102 alphanumeric; left; pad " "
Failed Audit Code 1 103 103 numeric; right; pad "0"
Changed Sequence Number 6 104 109 numeric; right; pad "0"
Changed Location Code 4 110 113 alphanumeric; left; pad " "
Changed Instruction Code1 4 114 117 alphanumeric; left; pad " "
Changed Instruction Code2 4 118 121 alphanumeric; left; pad " "
New Seal ID 10 122 131 alphanumeric; left; pad " "
Field Length Start End Format
D3 2 1 2 alphanumeric; left; pad " "
Account Number 20 3 22 alphanumeric; left; pad " "
Meter Number 10 23 32 alphanumeric; left; pad " "
Read Type Code 4 33 36 alphanumeric; left; pad " "
Read Sequence Number 6 37 42 numeric; right; pad "0"
Number of Dials 2 43 44 numeric; right; pad "0"
Number of Decimals 1 45 45 numeric; right; pad "0"
Constant 6 46 51 alphanumeric; left; pad " "
Address 40 52 91 alphanumeric; left; pad " "
Name 20 92 111 alphanumeric; left; pad " "