Utility Billing Support Document

Open as: PDF or Word Document

Data Dictionary

Table of Contents


UBACCT : CUSTOMER ACCOUNT FILE

UBBOOK : KEEPS TRACK OF BOOKS

UBCODE : BILLING CODE FILE

UBCOMM : COMMENT FILE

UBCRSS : CROSS LINK FILE FOR GANGED METERS

UBDIST : GENERAL LEDGER DISTRIBUTION FILE

UBHMTR : VERTICAL HISTORY METER READING FILE

UBMAST : BILLING MASTER FILE

UBMETR : METER READINGS

UBRATE : BILLING RATES

UBSYST : UTILITY BILLING SYSTEM FILE

UBTRAX : TRANSACTION FILE

UBX2GL : UTILITY BILLING TRANSFER TO G/L FILE


								
UBACCT : CUSTOMER ACCOUNT FILE                   

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    AC_ACCT        C     10     0   ACCOUNT NUMBER (RIGHT JUSTIFIED)      
   2    AC_SUBACCT     C     10     0   SUBACCOUNT     (LEFT JUSTIFIED)       
   3    AC_STAT        C      1     0   ACTIVE,INACTIVE,FINALBILL,TERMINATED  
   4    AC_LNAME       C     40     0   CUSTOMER LAST NAME                    
   5    AC_FNAME       C     20     0   CUSTOMER FIRST NAME                   
   6    AC_EXTNAME     C      3     0   EXTENSION NAME (JR/SR/III)            
   7    AC_BOOK        N      4     0   BOOK NUMBER - USED FOR METER READING  
   8    AC_SEQNO       N      5     0   READING SEQUENCE NUMBER WITHIN BOOK   
   9    AC_ADDRNO      C     10     0   STREET NUMBER                         
  10    AC_ADDR1       C     30     0   STREET NAME                           
  11    AC_ADDR2       C     30     0   SECOND ADDRESS LINE                   
  12    AC_CITY        C     25     0   TOWN                                  
  13    AC_STATE       C     10     0   STATE                                 
  14    AC_ZIP         C     10     0   ZIP CODE                              
  15    AC_CARCODE     C      4     0   CARRIER CODE                          
  16    AC_PHONE       C     12     0   PHONE                                 
  17    AC_MADD1       C     30     0   MAILING ADDRESS (IF BLANK USE 
REGULAR)                            
  18    AC_MADD2       C     30     0   MAILING ADDRESS2                      
  19    AC_MCITY       C     25     0   MAILING CITY                          
  20    AC_MSTATE      C     10     0   MAILING STATE                         
  21    AC_MZIP        C     10     0   MAILING ZIP                           
  22    AC_MCARCOD     C      4     0   MAILING ADDRESS CARRIER CODE          
  23    AC_LOCA        C     30     0   LOCATION OF SERVICE                   
  24    AC_BEGIN       D      8     0   BEGINNING DATE OF SERVICE             
  25    AC_END         D      8     0   ENDING DATE OF SERVICE                
  26    AC_MISC        C     14     0   USER DEFINED MISCELLANEOUS FIELD      
  27    AC_DISCPCT     N      6     3   DISCOUNT %                            
  28    AC_DISCDAY     N      2     0   DISCOUNT DAYS                         
  29    AC_NETDAY      N      2     0   NET DAYS                              
  30    AC_BILMIN      C      4     0   MINIMUM CHARGE FOR ENTIRE BILL        
  31    AC_BILCOM      C      6     0   COMBINED BILL COMMENT ID              
  32    AC_MINCHG1     C      4     0   MINIMUM CHARGES CODE FROM UBCODE      
  33    AC_SURCDE1     C      4     0   SURCHARGES CODE FROM UBCODE           
  34    AC_COMMID1     C      6     0   COMMENT ID                            
  35    AC_TAXPCT1     N      6     3   TAX PERCENT FOR SERVICE 1             
  36    AC_BLDATE1     D      8     0   DATE OF LAST BILLING                  
  37    AC_LSBILL1     N     12     2   AMOUNT OF LAST BILLING                
  38    AC_PYDATE1     D      8     0   DATE OF LAST PAYMENT                  
  39    AC_LSPYMT1     N     12     2   AMOUNT OF LAST PAYMENT                
  40    AC_BALDUE1     N     12     2   CURRENT ACCOUNT BALANCE               
  41    AC_OPENCR1     N     12     2   OPEN CREDIT AMOUNT                    
  42    AC_OPENDP1     N     12     2   OPEN DEPOSIT AMOUNT                   
  43    AC_AGECUR1     N     12     2   CURRENT AMOUNT DUE                    
  44    AC_AGE0301     N     12     2    30 DAYS OVERDUE                      
  45    AC_AGE0601     N     12     2    60 DAYS OVERDUE                      
  46    AC_AGE0901     N     12     2    90 DAYS OVERDUE                      
  47    AC_AGE1201     N     12     2   120 DAYS OVERDUE                      
  48    AC_MINCHG2     C      4     0   MINIMUM CHARGES CODE FROM UBCODE      
  49    AC_SURCDE2     C      4     0   SURCHARGES CODE FROM UBCODE           
  50    AC_COMMID2     C      6     0   COMMENT ID                            
  51    AC_TAXPCT2     N      6     3   TAX PERCENT FOR SERVICE 2             
  52    AC_BLDATE2     D      8     0   DATE OF LAST BILLING                  
  53    AC_LSBILL2     N     12     2   AMOUNT OF LAST BILLING                
  54    AC_PYDATE2     D      8     0   DATE OF LAST PAYMENT                  
  55    AC_LSPYMT2     N     12     2   AMOUNT OF LAST PAYMENT                
  56    AC_BALDUE2     N     12     2   CURRENT ACCOUNT BALANCE               
  57    AC_OPENCR2     N     12     2   OPEN CREDIT AMOUNT                    
  58    AC_OPENDP2     N     12     2   OPEN DEPOSIT AMOUNT                   
  59    AC_AGECUR2     N     12     2   CURRENT AMOUNT DUE                    
  60    AC_AGE0302     N     12     2    30 DAYS OVERDUE                      
  61    AC_AGE0602     N     12     2    60 DAYS OVERDUE                      
  62    AC_AGE0902     N     12     2    90 DAYS OVERDUE                      
  63    AC_AGE1202     N     12     2   120 DAYS OVERDUE                      
  64    AC_MINCHG3     C      4     0   MINIMUM CHARGES CODE FROM UBCODE      
  65    AC_SURCDE3     C      4     0   SURCHARGES CODE FROM UBCODE           
  66    AC_COMMID3     C      6     0   COMMENT ID                            
  67    AC_TAXPCT3     N      6     3   TAX PERCENT FOR SERVICE 3             
  68    AC_BLDATE3     D      8     0   DATE OF LAST BILLING                  
  69    AC_LSBILL3     N     12     2   AMOUNT OF LAST BILLING                
  70    AC_PYDATE3     D      8     0   DATE OF LAST PAYMENT                  
  71    AC_LSPYMT3     N     12     2   AMOUNT OF LAST PAYMENT                
  72    AC_BALDUE3     N     12     2   CURRENT ACCOUNT BALANCE               
  73    AC_OPENCR3     N     12     2   OPEN CREDIT AMOUNT                    
  74    AC_OPENDP3     N     12     2   OPEN DEPOSIT AMOUNT                   
  75    AC_AGECUR3     N     12     2   CURRENT AMOUNT DUE                    
  76    AC_AGE0303     N     12     2    30 DAYS OVERDUE                      
  77    AC_AGE0603     N     12     2    60 DAYS OVERDUE                      
  78    AC_AGE0903     N     12     2    90 DAYS OVERDUE                      
  79    AC_AGE1203     N     12     2   120 DAYS OVERDUE                      
  80    AC_MINCHG4     C      4     0   MINIMUM CHARGES CODE FROM UBCODE      
  81    AC_SURCDE4     C      4     0   SURCHARGES CODE FROM UBCODE           
  82    AC_COMMID4     C      6     0   COMMENT ID                            
  83    AC_TAXPCT4     N      6     3   TAX PERCENT FOR SERVICE 4             
  84    AC_BLDATE4     D      8     0   DATE OF LAST BILLING                  
  85    AC_LSBILL4     N     12     2   AMOUNT OF LAST BILLING                
  86    AC_PYDATE4     D      8     0   DATE OF LAST PAYMENT                  
  87    AC_LSPYMT4     N     12     2   AMOUNT OF LAST PAYMENT                
  88    AC_BALDUE4     N     12     2   CURRENT ACCOUNT BALANCE               
  89    AC_OPENCR4     N     12     2   OPEN CREDIT AMOUNT                    
  90    AC_OPENDP4     N     12     2   OPEN DEPOSIT AMOUNT                   
  91    AC_AGECUR4     N     12     2   CURRENT AMOUNT DUE                    
  92    AC_AGE0304     N     12     2    30 DAYS OVERDUE                      
  93    AC_AGE0604     N     12     2    60 DAYS OVERDUE                      
  94    AC_AGE0904     N     12     2    90 DAYS OVERDUE                      
  95    AC_AGE1204     N     12     2   120 DAYS OVERDUE                      
  96    AC_AGREE       M      0     0   MEMO FIELD FOR NOTES                  
  97    AC_NOTES1      C     60     0   NOTES FIELD 1                         
  98    AC_NOTES2      C     60     0   NOTES FIELD 2                         
  99    AC_NOTES3      C     60     0   NOTES FIELD 3                         
 100    AC_NOTES4      C     60     0   NOTES FIELD 4                         
 101    AC_NOTES5      C     60     0   NOTES FIELD 5                         
 102    AC_NOTES6      C     60     0   NOTES FIELD 6                         
 103    AC_NOTES7      C     60     0   NOTES FIELD 7                         
 104    AC_NOTES8      C     60     0   NOTES FIELD 8                         
 105    AC_NEW         C      1     0   NEW CUSTOMER FLAG                     
 106    AC_PENEXMP     C      1     0   ACCOUNT EXEMPT FROM PENALTY (Y/N)     
 107    AC_OLDACCT     C     10     0   ACCOUNT NUMBER BEFORE 5.5V CONVERSION 
 108    AC_OLDSUB      C     10     0   SUB NUMBER BEFORE 5.5V CONVERSION     
 109    AC_DEL         C      1     0   DELETION FLAG ("*"=REUSABLE)          
 110    AC_NETSTAM     N      2     0   NETWORK STAMP                         
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 110 FIELDS = 1542

                                Related Indexes                                

UBACCT : AC_DEL+AC_ACCT+AC_SUBACCT                                             
UBACNM : UPPE(AC_LNAME+AC_FNAME)                                               
UBACBK : STR(AC_BOOK,4,0)+STR(AC_SEQNO,5,0)                                    
UBACAD : UPPER(LEFT(AC_ADDR1,15)+AC_ADDRNO)                                    
UBACLO : UPPE(AC_LOCA)+UPPE(AC_LNAME+AC_FNAME)                                 

                             Additional Information                             

Related files: UBRATE contains one Record per Rate Charge for this account      
               UBMETR contains one record per meter for this account            



 
UBBOOK : KEEPS TRACK OF BOOKS                     

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    B_BOOK         N      4     0   BOOK NUMBER                          
   2    B_DESC         C     40     0   USERS DESCRIPTION OF BOOK            
   3    B_BILLS        N      1     0   NUMBER OF BILLS FOR THIS BOOK        
   4    B_NETSTAMP     N      2     0   NETWORK STAMP                        
   5    B_DELFLAG      C      1     0   '*' IF REUSABLE                      
   6    B_CALCFLAG     C      1     0   '*' IF SOMEONE IS CALCULATING BILLS  
   7    B_PRINTFLG     C      1     0   '*' IF SOMEONE IS PRINTING BILLS     
   8    B_LASTROLL     D      8     0   DATE OF LAST METER ROLL              
   9    B_READFLAG     C      1     0   '*' IF SOMEONE IS DOING READINGS     
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  9 FIELDS = 59

                                Related Indexes                                

UBBOOK : B_DELFLAG+STR(B_BOOK,4,0)                                             



 
UBCODE : BILLING CODE FILE                     

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    RC_CODE        C      4     0   RATE CODE                            
   2    RC_TYPE        C      1     0   FIXED, ONETIME, METER, VARIMETER, 
STEPMETER                        
   3    RC_METHOD      C      1     0   STANDARD, AVERAGED OR CUSTOM       
   4    RC_SERVICE     C      1     0   SERVICE  <1-4>                     
   5    RC_UNIT        C      1     0   GALLONS,HUNDRED,CUFEET,CUMETER,LITER  
   6    RC_CUSTCD      C      2     0   CUSTOM CALCULATION CODE      
   7    RC_DESC        C     40     0   RATE DESCRIPTION             
   8    RC_OFFPEAK     N     11     6   NORMAL CHARGE                
   9    RC_PEAK        N     11     6   PEAK SEASON CHARGE           
  10    RC_DATE1       C      5     0   BEGINNING OF PEAK SEASON (MM/DD) 
  11    RC_DATE2       C      5     0   ENDING    OF PEAK SEASON (MM/DD) 
  12    RC_VLOWER      N     12     2   VARIABLE RATE LOWER BOUND (>=)   
  13    RC_MINCHG      N      9     2   MINIMUM CHARGE FOR THIS RATE     
  14    RC_MINUSE      N      9     0   MINIMUM USAGE ON METERED RATES   
  15    RC_BASE        N      9     2   BASE CHARGE FOR VARI & STEPPED RATES  
  16    RC_BCUSTCD     C      2     0   CUSTOM BASE CALCULATION CODE          
  17    RC_DEL         C      1     0   DELETION FLAG ("*"=REUSABLE)          
  18    RC_NETSTAM     N      2     0   NETWORK STAMP                         
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 18 FIELDS = 126

                                Related Indexes                                

UBCODE : RC_DEL+RC_CODE+UBDESC(STR(RC_VLOWER,12,2))                            
UBCDLK : RC_DEL+RC_CODE                                                        

                             Additional Information                             

Seasonal rates indicated by presence of dates in Rc_date1 & Rc_date2            
One record must exist for each range within a variable rate. Range >= Vlower    



 
UBCOMM : COMMENT FILE                     

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    C_ID           C      6     0   COMMENT ID                            
   2    C_SEQ          C      1     0   LINE NUMBER '0' - '9'                 
   3    C_COMMENT      C     60     0   COMMENT LINE                          
   4    C_DELFLAG      C      1     0   DELETE FLAG ("*"=REUSABLE)            
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 4 FIELDS = 68

                                Related Indexes                                

UBCOMM : C_DELFLAG+C_ID+C_SEQ                                                  



 
UBCRSS : CROSS LINK FILE FOR GANGED METERS              

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    X_TOACCT       C     10     0   ACCOUNT (RIGHT JUSTIFIED)            
   2    X_TOSUB        C     10     0   SUBACCOUNT (RIGHT JUSTIFIED)         
   3    X_TOMETER      C     12     0   THE METER NUMBER WE ARE GANGING TO   
   4    X_FRMACCT      C     10     0   ACCOUNT (RIGHT JUSTIFED)  FROM 
ACCOUNT                       
   5    X_FRMSUB       C     10     0   SUBACCOUNT (RIGHT JUSTIFIED) FROM 
ACCT                          
   6    X_FRMMETER     C     12     0   METER THAT HAS THE READING WE WANT   
   7    X_ADDSUB       C      1     0   +,- HOW THIS METER WILL AFFECT GANG  
   8    X_DEL          C      1     0   "*" IF REUSEABLE                     
   9    X_NETSTAMP     N      2     0   NETWORK STAMP                        
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 9 FIELDS = 68

                                Related Indexes                                

UBCRSS : X_DEL+X_TOACCT+X_TOSUB+X_TOMETER                                      

                             Additional Information                             

This file maintains the account and subaccounts and meter numbers of cross
links between GANGED meters. This file allows us to GANG meters across 
different accounts. This cross link can either affect the GANG positively 
or negatively based upon the X_ADDSUB field.                                                  

 
 
 
UBDIST : GENERAL LEDGER DISTRIBUTION FILE           

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    D_ACCT         C     25     0   G/L ACCOUNT                          
   2    D_DATE         D      8     0   TRANSACTION DATE (CHECK DATE)        
   3    D_BATCH        C      3     0   BATCH NUMBER                         
   4    D_AMT          N     11     2   ACTUAL AMOUNT                        
   5    D_POSTED       C      1     0   POSTED TO G/L ? (YN)                 
   6    D_DELFLAG      C      1     0   DELETE FLAG (*)                      
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 6 FIELDS = 49

                                Related Indexes                                

UBDBAT : D_DELFLAG+D_BATCH+D_ACCT+DTOS(D_DATE)                                 
UBDIST : D_DELFLAG+D_ACCT+DTOS(D_DATE)+D_POSTED                                



 
UBHMTR : VERTICAL HISTORY METER READING FILE           

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    ME_ACCT        C     10     0   ACCOUNT                              
   2    ME_SUBACCT     C     10     0   SUB-ACCOUNT                          
   3    ME_NUMBER      C     12     0   METER NUMBER                         
   4    ME_R01         N      9     0   READING OF THE METER                 
   5    ME_D01         D      8     0   DATE OF THE METER READING            
   6    ME_M01         C     30     0   METER READING COMMENT                
   7    ME_DEL         C      1     0   "*" IF REUSEABLE                     
   8    ME_S01         C      6     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING                           
   9    ME_UNIT        C      1     0   GALLONS, HUNDRED, CUFEET, CUMETER, 
LITER                             
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 9 FIELDS = 87

                                Related Indexes                                

UBHMTR : ME_DEL+ME_ACCT+ME_SUBACCT+ME_S01                                      



 
UBMAST : BILLING MASTER FILE                   

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    M_ACCT         C     10     0   ACCOUNT    (RIGHT JUSTIFIED)         
   2    M_SUBACCT      C     10     0   SUBACCOUNT (RIGHT JUSTIFIED)         
   3    M_SEQNO        C      7     0   BILLING SEQUENCE NUMBER (SYSTEM 
ASSIGNED)                          
   4    M_BSTART       D      8     0   START OF BILLING PERIOD              
   5    M_BEND         D      8     0   END   OF BILLING PERIOD              
   6    M_DUEDATE      D      8     0   DUE DATE                             
   7    M_SERVICE      C      1     0   SERVICE FOR THIS BILL ("*"=MIXED)    
   8    M_BOOK         N      4     0   BOOK THIS BILL BELONGS TO            
   9    M_REFNO        C      8     0   PAYMENT REFERENCE (CHECK NUMBER)     
  10    M_BSVC1        N     12     2   BILLING FOR SERVICE 1(INCLUDES TAX)  
  11    M_BSVC2        N     12     2   BILLING FOR SERVICE 2(INCLUDES TAX)  
  12    M_BSVC3        N     12     2   BILLING FOR SERVICE 3(INCLUDES TAX)  
  13    M_BSVC4        N     12     2   BILLING FOR SERVICE 4(INCLUDES TAX)  
  14    M_BTAX1        N      9     2   TAX FOR SERVICE 1                    
  15    M_BTAX2        N      9     2   TAX FOR SERVICE 2                    
  16    M_BTAX3        N      9     2   TAX FOR SERVICE 3                    
  17    M_BTAX4        N      9     2   TAX FOR SERVICE 4                    
  18    M_PSVC1        N     12     2   PAID FOR SERVICE 1                   
  19    M_PSVC2        N     12     2   PAID FOR SERVICE 2                   
  20    M_PSVC3        N     12     2   PAID FOR SERVICE 3                   
  21    M_PSVC4        N     12     2   PAID FOR SERVICE 4                   
  22    M_PTAX1        N      9     2   PAID TAX FOR SERVICE 1               
  23    M_PTAX2        N      9     2   PAID TAX FOR SERVICE 2               
  24    M_PTAX3        N      9     2   PAID TAX FOR SERVICE 3               
  25    M_PTAX4        N      9     2   PAID TAX FOR SERVICE 4               
  26    M_PRTID        C      1     0   BLANK = NOT PRINTED, 'P' = PRINTED   
  27    M_STATUS       C      1     0   BLANK = OPEN, VOIDED, CLOSED         
  28    M_INTCALC      C      4     0   INTEREST CALCULATED?                 
  29    M_PENCALC      C      4     0   PENALTY CALCULATED?                  
  30    M_DELFLAG      C      1     0   DELETE FLAG ("*"=REUSABLE)           
  31    M_NETSTAMP     N      2     0   NETWORK STAMP                        
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 31 FIELDS = 245

                                Related Indexes                                

UBMLKP : M_SEQNO                                                               
UBMWRK : M_PRTID+M_SERVICE+STR(M_BOOK,4,0)+M_ACCT+M_SUBACCT                    
UBMAST : M_DELFLAG+M_ACCT+M_SUBACCT+M_SEQNO                                    

                             Additional Information                             

The UBTRAX file contains detail lines for this bill                             
Calculated Bills: if EMPTY(M_Prtid) this bill is NOT part of the Account Bal    
Interest,Penalty,Misc Bills update the Account Bal when posted.                 
The bill printing procedure marks as printed (M_prtid='P') and updates the      
    Account bal for Calculated Bills.                                           
Balance = (M_bsvc1+M_bsvc2+M_bsvc3+M_bsvc4) - (M_psvc1+M_psvc2+M_Psvc3+M_psvc4) 
M_seqno: First char:  M = Misc bill  C = CreditMemo  D = DebitMemo  I = Interest
             P = Penalty   T = Deposit    Any digit = Calculated bill           
M_seqno: Last char for calculated bill indicates payment number(1-4)            
M_intcalc & M_pencalc : positions filled with "Y" based on service calculated   
M_cycle: 1,1 = Cycle ("M"onth, "Q"uarter, "S"emiAnnual, "A"nnual)               
         2,1 = sub-cycle any char                                               
Tax Field Amounts are NOT in addition to the amounts in M_bsvc# or M_psvc#      
    Tax Amounts are contained within the M_bsvc# and M_psvc#.                   



 
UBMETR : METER READINGS                

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    ME_ACCT        C     10     0   ACCOUNT      (RIGHT JUSTIFIED)       
   2    ME_SUBACCT     C     10     0   SUBACCOUNT   (RIGHT JUSTIFIED)       
   3    ME_NUMBER      C     12     0   METER NUMBER (RIGHT JUSTIFIED)       
   4    ME_LOCA        C     30     0   PHYSICAL LOCATION OF THE METER       
   5    ME_TOUCH       C      1     0   "Y" = TEST                           
   6    ME_MXU         C     15     0   MXU NUMBER                           
   7    ME_LAT         N     11     1   LOCATION LATITUDE                    
   8    ME_LONG        N     11     1   LOCATION LONGITUDE                   
   9    ME_DIALS       N      1     0   NUMBER OF DIALS                      
  10    ME_SIZE        C     10     0   SIZE OF METER                        
  11    ME_MANU        C     10     0   MANUFACTURER                         
  12    ME_GANGED      C     12     0   GANGED TO METER NUMBER "GANGED123456" 
  13    ME_ADDSUB      C      1     0   +,- HOW THIS METER WILL AFFECT THE 
GANG                               
  14    ME_SERIAL      C     16     0   METER SERIAL NUMBER                  
  15    ME_TYPE        C      4     0   METER TYPE - USER DEFINED            
  16    ME_UNIT        C      1     0   GALLONS,HUNDRED,CUFEET,CUMETER,LITER 
  17    ME_INSTAL      D      8     0   DATE OF INSTALLATION                 
  18    ME_ON          D      8     0   DATE TURNED ON                       
  19    ME_OFF         D      8     0   DATE TURNED OFF                      
  20    ME_MISC1       C      5     0   MISC. FIELD ADDED FOR FUTURE USE     
  21    ME_MISC2       C      5     0   MISC. FIELD ADDED FOR FUTURE USE     
  22    ME_R01         N      9     0   CURRENT READING / PREVIOUS READING 01 
  23    ME_R02         N      9     0   PREVIOUS READING 02                   
  24    ME_R03         N      9     0   PREVIOUS READING 03                   
  25    ME_R04         N      9     0   PREVIOUS READING 04                   
  26    ME_R05         N      9     0   PREVIOUS READING 05                   
  27    ME_R06         N      9     0   PREVIOUS READING 06                   
  28    ME_R07         N      9     0   PREVIOUS READING 07                   
  29    ME_R08         N      9     0   PREVIOUS READING 08                   
  30    ME_R09         N      9     0   PREVIOUS READING 09                   
  31    ME_R10         N      9     0   PREVIOUS READING 10                   
  32    ME_R11         N      9     0   PREVIOUS READING 11                   
  33    ME_R12         N      9     0   PREVIOUS READING 12                   
  34    ME_R13         N      9     0   PREVIOUS READING 13                   
  35    ME_R14         N      9     0   PREVIOUS READING 14                   
  36    ME_AVE1_12     N      9     0   AVERAGE OF METER READINGS 1-12        
  37    ME_D01         D      8     0   DATE OF CURRENT READING/PREVIOUS 
READING                             
  38    ME_D02         D      8     0   DATE OF PREVIOUS READING 02           
  39    ME_D03         D      8     0   DATE OF PREVIOUS READING 03           
  40    ME_D04         D      8     0   DATE OF PREVIOUS READING 04           
  41    ME_D05         D      8     0   DATE OF PREVIOUS READING 05           
  42    ME_D06         D      8     0   DATE OF PREVIOUS READING 06           
  43    ME_D07         D      8     0   DATE OF PREVIOUS READING 07           
  44    ME_D08         D      8     0   DATE OF PREVIOUS READING 08           
  45    ME_D09         D      8     0   DATE OF PREVIOUS READING 09           
  46    ME_D10         D      8     0   DATE OF PREVIOUS READING 10           
  47    ME_D11         D      8     0   DATE OF PREVIOUS READING 11           
  48    ME_D12         D      8     0   DATE OF PREVIOUS READING 12           
  49    ME_D13         D      8     0   DATE OF PREVIOUS READING 13           
  50    ME_D14         D      8     0   DATE OF PREVIOUS READING 14           
  51    ME_M01         C     30     0   COMMENTS FOR READING 01               
  52    ME_M02         C     30     0   COMMENTS FOR READING 02               
  53    ME_M03         C     30     0   COMMENTS FOR READING 03               
  54    ME_M04         C     30     0   COMMENTS FOR READING 04               
  55    ME_M05         C     30     0   COMMENTS FOR READING 05               
  56    ME_M06         C     30     0   COMMENTS FOR READING 06               
  57    ME_M07         C     30     0   COMMENTS FOR READING 07               
  58    ME_M08         C     30     0   COMMENTS FOR READING 08               
  59    ME_M09         C     30     0   COMMENTS FOR READING 09               
  60    ME_M10         C     30     0   COMMENTS FOR READING 10               
  61    ME_M11         C     30     0   COMMENTS FOR READING 11               
  62    ME_M12         C     30     0   COMMENTS FOR READING 12               
  63    ME_M13         C     30     0   COMMENTS FOR READING 13                
  64    ME_M14         C     30     0   COMMENTS FOR READING 14                
  65    ME_S01         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 01                        
  66    ME_S02         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 02                        
  67    ME_S03         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 03                        
  68    ME_S04         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 04                        
  69    ME_S05         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 05                        
  70    ME_S06         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 06                        
  71    ME_S07         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 07                        
  72    ME_S08         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 08                        
  73    ME_S09         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 09                        
  74    ME_S10         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 10                        
  75    ME_S11         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 11                        
  76    ME_S12         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 12                        
  77    ME_S13         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 13                        
  78    ME_S14         C      7     0   MASTER SEQUENCE # FOR BACKWARDS 
TRACKING 14                        
  79    ME_DEL         C      1     0   DELETION FLAG ("*"=REUSABLE)         
  80    ME_NETSTAM     N      2     0   NETWORK STAMP                        
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 80 FIELDS = 957

                                Related Indexes                                

UBMETR : ME_DEL+ME_ACCT+ME_SUBACCT+ME_NUMBER                                   

                             Additional Information                             

Consumption is calculated as follows:                                           
consumption = CurrentReading - PreviousReading                                  

IF consumption <= 0.00 .AND. CurrentReading > 0.00   &&Rollover occured         
Consumption = 
consumption+VAL(REPL("9", LEN(LTRIM(STR(PreviousReading)))))+1 
ENDIF                                                                           

Consumption in Gallons = consumption * multiplier                               
multipliers: Gallons = 1, teNg = 10, Hunds = 100, Tgals = 1000, CuFt = 7.841    
             hcFt = 784.10, 4 = 1.4, others                                     



 
UBRATE : BILLING RATES                 

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    RA_ACCT        C     10     0   ACCOUNT(RIGHT JUSTIFIED)              
   2    RA_SUBACCT     C     10     0   SUBACCOUNT (RIGHT JUSTIFIED)          
   3    RA_STAT        C      1     0   ACTIVE,INACTIVE,FINALBILL,TERMINATED  
   4    RA_CLCSTAT     C      1     0   CALCULATED STATUS "N"EEDS ROLL   
"C"ALCULATED    " " = READY TO CALCULATE AND/OR ENTER READINGS     
   5    RA_SERVICE     C      1     0   SERVICE (WATER,SEWER,...)             
   6    RA_CODE        C      4     0   UBCODE->RATE CODE                     
   7    RA_UNITS       N     10     2   UNITS                                 
   8    RA_METERNO     C     12     0   METER NUMBER FOR SIMPLE&VARIABLE 
CHARGES                             
   9    RA_DEL         C      1     0   DELETION FLAG ("*"=REUSABLE)          
  10    RA_NETSTAM     N      2     0   NETWORK STAMP                         
  11    RA_BOOK        N      4     0   BOOK ASSOCIATED WITH THIS ACCOUNT 
RATE                                
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 11 FIELDS = 56

                                Related Indexes                                

UBRTCY : RA_CLCSTAT+STR(RA_BOOK,4,0)+RA_ACCT+RA_SUBACCT+RA_SERVICE             
UBRATE : RA_DEL+RA_ACCT+RA_SUBACCT+RA_CODE+RA_SERVICE                          



 
UBSYST : UTILITY BILLING SYSTEM FILE            

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    DACCTLEN       N      2     0   LENGTH OF ACCOUNT NUMBER    (1-8)     
   2    DSUBLEN        N      2     0   LENGTH OF SUBACCOUNT NUMBER (1-5)     
   3    SERVICES       C      4     0   SERVICE CODES (WATER,SEWER,...)       
   4    SVCDESC        C     60     0   SERVICE CODE DESCRIPTION (15 CHARS)   
   5    S_BLFORM       C      2     0   BILL FORM SELECT                      
   6    S_COMMID       C      6     0   SYSTEM-WIDE BILLING COMMENT ID        
   7    S_GLLINK       C      1     0   LINK TO G/L? (Y/N)                    
   8    S_GLCOMP       C      2     0   G/L COMPANY TO LINK TO                
   9    S_GLNXTBAT     N      3     0   NEXT G/L BATCH NUMBER FOR POSTING     
  10    S_NEXTBILL     N      8     0   NEXT BILL NUMBER                      
  11    S_GLMETHOD     C      1     0   "A"CCRUAL / "C"ASH                    
  12    S_ASKXFER      C      1     0   "A"CCRUAL / "C"ASH                    
  13    S_NXTSEQN      N      6     0   NEXT MAST/TRAX SEQUENCE NUMBER        
  14    S_MEMOSEQN     N      4     0   NEXT CREDIT MEMO SEQUENCE NUMBER      
  15    S_CASHSEQN     N      5     0   NEXT CASH SEQUENCE NUMBER             
  16    S_LSTREMIT     C      5     0   LAST REMITTANCE NUMBER USED           
  17    S_ADD2RMT      C      1     0   AUTOMATICALLY ADVANCE REMITTANCET 
NUMBER AFTER GL TRANSFER?  (Y/N)    
  18    S_INTPCT       N      6     3   INTEREST PERCENT                      
  19    S_PENPCT       N      6     3   PENALTY PERCENT                       
  20    S_USEDISC      C      1     0   USE DISCOUNTS (Y/N)                   
  21    S_DFLTPAID     C      1     0   DEFAULT THE AMOUNT PAID IN CASH 
RECEIPTS                       
  22    S_CHKDEF       C      8     0   CHECK NUMBER DEFAULT FOR CASH SCREEN  
  23    S_CASHORD      C      5     0   PENALTY, INTEREST, BILL, DEBITMEMO, 
CREDITM                              
  24    S_MOVECRED     C      1     0   MOVE CREDITS AROUND SERVICES AUTO      
  25    S_DEPOSITS     C      1     0   USE DEPOSITS? (Y/N)                    
  26    S_PERIOD       N      2     0   CURRENT PERIOD                         
  27    S_AGEDATE      D      8     0   DATE TO BASE ALL AGING ON              
  28    S_METRUNIT     C      1     0   DEFAULT METERED UNIT                   
  29    S_VARI         N      2     0   PERCENT VARIANCE ALLOWED IN READINGS   
  30    S_DIALS        N      1     0   DEFAULT NUMBER OF DIALS ON A METER     
  31    S_YEAR         N      4     0   CURRENT YEAR                           
  32    S_GLCASH       C     25     0   G/L CASH ACCOUNT                       
  33    S_GLAR         C     25     0   G/L ACCOUNTS RECEIVABLE NUMBER         
  34    S_GLAR1        C     25     0   G/L ACCOUNTS RECEIVABLE NUMBER SVC 1   
  35    S_GLAR2        C     25     0   G/L ACCOUNTS RECEIVABLE NUMBER SVC 2   
  36    S_GLAR3        C     25     0   G/L ACCOUNTS RECEIVABLE NUMBER SVC 3   
  37    S_GLAR4        C     25     0   G/L ACCOUNTS RECEIVABLE NUMBER SVC 4   
  38    S_DUETO        C     25     0   G/L DUE TO FUNDS                       
  39    S_DUEFROM      C     25     0   G/L DUE FROM FUNDS                     
  40    S_GLCREDIT     C     25     0   G/L CREDIT ACCOUNT                     
  41    S_GLCRED1      C     25     0   G/L CREDIT ACCOUNT SVC 1               
  42    S_GLCRED2      C     25     0   G/L CREDIT ACCOUNT SVC 2               
  43    S_GLCRED3      C     25     0   G/L CREDIT ACCOUNT SVC 3               
  44    S_GLCRED4      C     25     0   G/L CREDIT ACCOUNT SVC 4               
  45    S_GLDEPO       C     25     0   G/L DEPOSIT ACOOUNT 0                  
  46    S_GLDEPO1      C     25     0   G/L DEPOSIT ACOOUNT SVC 01             
  47    S_GLDEPO2      C     25     0   G/L DEPOSIT ACOOUNT SVC 02             
  48    S_GLDEPO3      C     25     0   G/L DEPOSIT ACOOUNT SVC 03             
  49    S_GLDEPO4      C     25     0   G/L DEPOSIT ACOOUNT SVC 04             
  50    S_GLDISC       C     25     0   G/L DISCOUNT ACCOUNT                   
  51    S_GLREV1       C     25     0   G/L REVENUE ACCOUNT FOR SERVICE 1      
  52    S_GLREV2       C     25     0   G/L REVENUE ACCOUNT FOR SERVICE 2      
  53    S_GLREV3       C     25     0   G/L REVENUE ACCOUNT FOR SERVICE 3      
  54    S_GLREV4       C     25     0   G/L REVENUE ACCOUNT FOR SERVICE 4      
  55    S_GLINT1       C     25     0   G/L INTEREST ACCOUNT FOR SERVICE 1     
  56    S_GLINT2       C     25     0   G/L INTEREST ACCOUNT FOR SERVICE 2     
  57    S_GLINT3       C     25     0   G/L INTEREST ACCOUNT FOR SERVICE 3     
  58    S_GLINT4       C     25     0   G/L INTEREST ACCOUNT FOR SERVICE 4     
  59    S_GLPEN1       C     25     0   G/L PENALTY ACCOUNT FOR SERVICE 1      
  60    S_GLPEN2       C     25     0   G/L PENALTY ACCOUNT FOR SERVICE 2      
  61    S_GLPEN3       C     25     0   G/L PENALTY ACCOUNT FOR SERVICE 3      
  62    S_GLPEN4       C     25     0   G/L PENALTY ACCOUNT FOR SERVICE 4      
  63    S_GLTAX1       C     25     0   TAX ACCOUNT FOR SERVICE 1              
  64    S_GLTAX2       C     25     0   TAX ACCOUNT FOR SERVICE 2              
  65    S_GLTAX3       C     25     0   TAX ACCOUNT FOR SERVICE 3              
  66    S_GLTAX4       C     25     0   TAX ACCOUNT FOR SERVICE 4              
  67    S_F05          C     30     0   FUNCTION KEY F5                        
  68    S_F06          C     30     0   FUNCTION KEY F6                        
  69    S_F07          C     30     0   FUNCTION KEY F7                        
  70    S_F08          C     30     0   FUNCTION KEY F8                        
  71    S_F09          C     30     0   FUNCTION KEY F9                        
  72    S_F10          C     30     0   FUNCTION KEY F10                       
  73    S_F11          C     30     0   FUNCTION KEY F11                       
  74    S_F12          C     30     0   FUNCTION KEY F12                       
  75    S_JANUARY      N      2     0   JAN IS WHAT PERIOD FOR UPPER LEFT 
CORNER                               
  76    S_INTDATE      D      8     0   DATE OF LAST INTEREST CALCULATION      
  77    S_CLODATE      D      8     0   DATE OF LAST PERIOD CLOSE              
  78    S_SYSTEM       C      8     0   HOLDS VERSION UPGRADE PROBLEM CODE     
  79    S_NETSTAMP     N      2     0                                          
  80    S_DELFLAG      C      1     0   '*' IF REUSEABLE                       
  81    S_VERSION      C      4     0   NEMRC EXECUTABLE THAT MATCHES DATA     
  82    S_OLDVER       C      4     0   PREVIOUS INSTALLED VERSION OF THE 
MODULE                          
  83    S_UPVER        D      8     0   DATE THE NEW VERSION WAS INSTALLED 
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 83 FIELDS = 1320

 
UBTRAX : TRANSACTION FILE                     

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    TR_ACCT        C     10     0   ACCOUNT NUMBER (RIGHT JUSTIFIED)     
   2    TR_SUBACCT     C     10     0   SUBACCOUNT     (RIGHT JUSTIFIED)     
   3    TR_SEQNO       C      7     0   BILLING SEQUENCE NUMBER (SYSTEM 
ASSIGNED)                      
   4    TR_TYPE        C      2     0   TRANSACTION TYPE*                
   5    TR_SERVICE     C      1     0   SERVICE                          
   6    TR_DATE        D      8     0   TRANSACTION DATE*                
   7    TR_UNITS       N     12     2   UNITS                            
   8    TR_RATE        N     12     7   RATE                             
   9    TR_AMOUNT      N     12     2   AMOUNT                           
  10    TR_MISC        C     30     0   MISCELLANEOUS INFORMATION*       
  11    TR_PRTID       C      1     0   BLANK = NOT PRINTED, 'P' = PRINTED  
  12    TR_BATCH       C      3     0   GL BATCH NUMBER                     
  13    TR_DEBIT       C     25     0   ACCOUNT DEBITED                     
  14    TR_CREDIT      C     25     0   ACCOUNT CREDITED                    
  15    TR_TRSDES      C     25     0   DESCRIPTION GIVEN DURING TRANSFER   
  16    TR_DEL         C      1     0   DELETION FLAG ("*"=REUSABLE)        
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 16 FIELDS = 184

                                Related Indexes                                

UBTRAX : TR_DEL+TR_ACCT+TR_SUBACCT+TR_SEQNO+DTOS(TR_DATE)                      
UBTRDT : TR_ACCT+TR_SUBACCT+DTOS(TR_DATE)+TR_SEQNO                             
UBTRDA : DTOS(TR_DATE)                                                         

                             Additional Information                             

Tr_type:
RF:Flat,RO:Onetime,RM:Meter,RV:VariMeter,RS:StepMeter,MC:MinCharge     
IN:Interest,PN:Penalty,CA:CashRcpt,AC:ApplCred,DT:DiscTaken,CM:CredMemo
CU:CredUsed,DM:DebitMemo,DA:DbApplied,MI:MiscChrg,AD:Adjustment
        
Tr_type      Tr_misc                                           Tr_date          
RF,RO        1,4=Rate/5,2=Cycle                                Billdate         
RM,RV,RS     1,4=Rate/5,2=Cycle/7,1=UofM/8,12=Meter/20,6=Units Billdate         
MC: MinCharg 1,4=Rate                                          Billdate         
CA,CM,DM,DA  1,5=UBCASH->Ca_seqno/6,8=Check#/14,5=Remit#       Checkdate        
AC,CU,DT                                                       Date applied     
IN,PN        1,8=UBMAST->M_duedate/9,6=UBMAST->M_seqno         Date Calc'd      
MI,AD        Description of charge                             Billdate         

Tr_units: IN&PN:Basis for Calculation, RM,RV,RS:Consuption in GALLONS!          
Additional Tr_type: DP:Deposit, DR:Deposit Refund, DU:Deposit Used, TX:Tax      
CX:Cash Applied to Tax AX:Applied Credit to Tax DX:Debit Applied to Tax         
RX:Deposit applied to Tax                                                       



 
UBX2GL : UTILITY BILLING TRANSFER TO G/L FILE       

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    TRSACT         C     25     0   ACCOUNT NUMBER                    
   2    TRSDES         C     25     0   TRANSACTION DESCRIPTION           
   3    TRSREF         C     12     0   REFERENCE NUMBER                  
   4    TRSDATE        D      8     0   TRANSACTION DATE                  
   5    TRSAMT         N     15     2   AMOUNT                            
   6    TRSID          C      1     0   0=SPECIAL,1=POSTING,2=REFERENCE   
   7    TRSMODU        C      2     0   MODULE THAT GENERATED THIS POSTING 
   8    TRSCOMPID      C      2     0   COMPANY ID THAT GENERATED THIS 
POSTING                          
   9    TRSTYPE        C      1     0   TRANSACTION TYPE (SEE BELOW)       
  10    TRSPD          C      2     0   G/L PERIOD OF POSTING              
  11    TRSDELFLAG     C      1     0                                      
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 11 FIELDS = 94
								
								

© NEMRC 2010-2022 | Privacy Policy