Invoices file from Water Supply Inventory
Number of Records In File: 16986
Number of Data Fields In File: 23
Data That Is Stored Within This File
Notes  =  general note   
WSID  =  Water Supply Identification Number   
InvoiceNbr  =  Invoice Number   
InvoiceType  =  Invoice Type   
InvoiceFrom  =  Invoice From Date   
InvoiceTo  =  Invoice To Date   
InvoiceDate  =  Date Invoice Generated   
AmountDue  =  Amount Due   
Status  =  Status (O=Open, C=Closed)   
GallonsUsed  =  Gallons of Water Used   
Multplier  =  Multiplier   
CalcType  =  Calculation Type Code   
BillCycle  =  Billing Cycle Code   
WarningFlag  =  Warning Flag (internal usage)   
ErrorFlag  =  Error Flag (internal usage)   
FixedFlag  =  Fixed Flag (internal Usage)   
AcceptAsIs  =  Accept as Is (internal flag)   
ActlDataStat  =  Actual Data Status   
AutoGeneratd  =  Automatically Generated Invoice (internal usage)   
DOE  =  Date of Entry Of Record   
UOE  =  User Who Entered The Record   
DOC  =  Date of Change of The Record   
UOC  =  User Who Changed The Record   
Related Files and Return To Hyperlinks
BillCycl To Relate information between files, find records where BillCycle here = BillCycle there
CalcType To Relate information between files, find records where CalcType here = CalcType there
INVENTRY To Relate information between files, find records where WSID here = WSID there
InvoiceType To Relate information between files, find records where InvoiceType here = InvoiceType there
Return To Index
Return To Compact List of All Files/All Variables