DBS Level 2 Tables and Fields

custmast

Customer/account master: identity, addresses, stored account balances and delivery settings.

custmast.CCUSTNO

Customer/account number stored as text; preserve leading zeros.

custmast.CNAME

Primary customer name.

custmast.CNAME2

Secondary customer name.

custmast.CADDRESS1

Mailing address, line 1.

custmast.CADDRESS2

Mailing address, line 2.

custmast.CSRVADDR

Service address, line 1; distinct from mailing address.

custmast.CSRVCITY

Service-location city.

custmast.CEMAIL

Customer email address.

custmast.NBALDUE

Stored account balance due; inspect history to explain it.

custmast.NUNAPPCR

Stored account unapplied-credit amount.

custmast.CMUNICODE

District code in the inspected local dictionary; verify client mapping.

custmast.CMUNI2

Municipality code in the inspected local dictionary; verify client mapping.

custmast.LEMAILBILL

Email-bill flag; active delivery rules may use other settings.

custmast.LNOBILPRT

Do Not Print Bill flag; inspect the active print workflow.

custmast.CBILLPRINTTYPE

Bill-output type in the supplied SQL review; blank has no proven universal meaning.

custserv

A customer's service setup: bill/rate codes, status, cycle, dates, overrides and service balances.

custserv.CCUSTNO

Customer/account number for this service record.

custserv.CBILLTYPE

Bill type assigned to this customer service.

custserv.CSERVTYPE

Service/rate variant; combine with CBILLTYPE when joining rates.

custserv.CACCTSTS

Service account-status code; inspect matching statcode settings.

custserv.CCYCLE

Billing cycle assigned to the service.

custserv.DACTDT

Service activation date.

custserv.DENDDT

Service end date.

custserv.LINACTIVE

Inactive flag for this service record.

custserv.LTMPNOBILL

Temporary No Bill flag.

custserv.NDFTBILL

Default bill amount.

custserv.NOVRBILAMT

Override bill amount.

custserv.NBILLUNITS

Billing units, labeled EDU's in local metadata.

custserv.NCURRBAL

Stored current service balance; not necessarily the whole account balance.

custserv.NPSTDUEBAL

Stored past-due service balance.

custserv.NCURRPEN

Stored current service penalty amount.

custserv.NCURRINT

Stored current service interest amount.

custserv.NUNAPPCRED

Stored unapplied credit for this service.

custserv.LCALCPEN

Calculate Penalties flag.

custserv.LCALCINT

Calculate Interest flag.

custserv.CTAXCODE

Tax code assigned to the service.

custhist

Posted customer financial history and application details: bills, payments, adjustments and remaining row balances.

custhist.CCUSTNO

Customer/account number on the history row.

custhist.CBILLTYPE

Bill type recorded on the transaction.

custhist.CSERVTYPE

Service type recorded on the transaction.

custhist.CTRANTYPE

Transaction category; reviewed receipt notes identify B = billing and C = payment.

custhist.CTRANCODE

Transaction code; look up trancode for its configured description.

custhist.DTRANDATE

Transaction date.

custhist.DDUEDATE

Due date recorded on the history row.

custhist.DPDBEGIN

Billing/service-period begin date recorded on the row.

custhist.DPDEND

Billing/service-period end date recorded on the row.

custhist.NTRANAMT

Original transaction amount; for a bill row, the original bill amount.

custhist.NBALDUE

Remaining balance on this history row; not the account total.

custhist.NIDNO

DBS ledger/application identity, separate from SQL ID; verify uniqueness within account.

custhist.NORIGIDNO

Original ledger reference used by posting/application logic; mapping depends on transaction type.

custhist.NREFNUM

Processing reference number; multiple rows may share it.

custhist.LVOIDED

Voided marker; keep visible when investigating history.

custhist.LREVISED

Revised marker; inspect related history and posting behavior.

custhist.LUNAPPCASH

Unapplied-cash marker on the history row.

custhist.LFINALBILL

Final-bill marker on the history row.

custhist.NPENALTY

Penalty amount recorded on the history row.

custhist.NINTEREST

Interest amount recorded on the history row.

custhist.CCHECKNO

Check/reference text recorded on the transaction.

custmtr

Association between a customer/bill-type service and a meter.

custmtr.CCUSTNO

Customer/account number on the meter assignment.

custmtr.CBILLTYPE

Bill type on the customer-meter assignment.

custmtr.CMETERID

Assigned meter's text identifier; links to meter.CMETERID.

custmtr.LSUBTRACT

Subtract-meter flag on this assignment.

custmtr.LINACTIVE

Inactive flag on this customer-meter assignment.

meter

Physical meter master and current/previous reading state.

meter.CMETERID

Text meter business identifier; separate from numeric meter.ID.

meter.CSERIALNO

Meter serial number; separate from CMETERID.

meter.NROUTE

Meter route number.

meter.NSEQUENCE

Meter's sequence within its route.

meter.NCURRREAD

Current reading.

meter.NPASTREAD

Previous reading.

meter.DCURRRDDT

Current reading date.

meter.DPREVRDDT

Previous reading date.

meter.CCURRRDCD

Current reading code; meanings depend on the reading interface.

meter.CPASTRDCD

Previous reading code.

meter.NREADMULT

Reading multiplier; not a complete consumption formula.

meter.NMTRDIGIT

Meter digit count.

meter.LROLLOVER

Rollover flag.

meter.LINACTIVE

Inactive flag on the meter record.

meter.CUNTOFMEAS

Unit-of-measure code.

meter.CMXUID

MXU ID, as labeled by the local field dictionary.

mtrhist

Historical meter readings and consumption; compare with the current meter record.

mtrhist.CCUSTNO

Customer/account number recorded in meter history.

mtrhist.CMETERID

Meter identifier on the history record.

mtrhist.DCURRRDDT

Current-reading date saved in this historical record.

mtrhist.DPREVRDDT

Previous-reading date saved in this historical record.

mtrhist.NCURRREAD

Current reading saved in this historical record.

mtrhist.NPASTREAD

Previous reading saved in this historical record.

mtrhist.NMETERCONS

Meter consumption recorded for this history event.

mtrhist.DPOSTDATE

Posting date stored in meter history.

mtrhist.NREFNUM

Processing reference associated with the meter-history row.

mtrhist.LROLLOVER

Rollover flag saved in this historical record.

billtype

Rate header and billing rules for a bill-type/service-type combination.

billtype.CBILLTYPE

Bill-type code; combine with CSERVTYPE to select a rate variant.

billtype.CSERVTYPE

Service-type code for this rate variant.

billtype.CBILLDESC

Description on the rate header.

billtype.NFLATCHG

Configured flat charge.

billtype.NMINCHG

Configured minimum charge.

billtype.LINACTIVE

Inactive flag on the rate record.