Utility Billing Support Document
Open as: PDF or Word Document
Data Dictionary
Table of Contents
UBACCT : CUSTOMER ACCOUNT FILE
UBCRSS : CROSS LINK FILE FOR GANGED METERS
UBDIST : GENERAL LEDGER DISTRIBUTION FILE
UBHMTR : VERTICAL HISTORY METER READING FILE
UBSYST : UTILITY BILLING SYSTEM 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
