customer_financial
The customer_financial table contains information that you can view during Customer Finance Master Maintenance - Financial Panel.
Notes:
For information about interpreting EDIFICE Tables, see Understanding EDIFICE Tables.
To view other EDIFICE Tables, see the EDIFICE Database Overview.
| customer_financial | 
| Field | 
| Customer_Service_ID | 
| Row_Index | 
| Times_Arrears | 
| YTD_Usage | 
| YTD_Charges | 
| YTD_Times_Billed | 
| YTD_Avg_Usage | 
| YTD_Num_Est_Bills | 
| LY_Usage | 
| LY_Charges | 
| Last_Pay_Date | 
| Last_Pay_Amount | 
| Last_Billing_Post_Date | 
| Disc_Allowed | 
| Disc_Date | 
| Deposit_Amount | 
| Deposit_Date | 
| Deposit_Interest | 
| Deposit_Int_Date | 
| I_Accrued | 
| I_Date_Last_Accrued | 
| I_Chargable_Bal | 
| I_Total_Bal | 
| Date_Last_Aging | 
| Date_LastYear_Aging | 
| Last_Smooth_Date | 
| Service_Code | 
| Creation_Date | 
| Account_Type | 
| Overpayment_Amount | 
| Customer_ID | 
| YTD_Deposit_Interest | 
| YTD_Arrears | 
| LY_Arrears | 
| Payments_Since_Last_Bill | 
| Last_Billing_Due_Date | 
| Bucket_1 | 
| Bucket_2 | 
| Bucket_3 | 
| Bucket_4 | 
| Bucket_5 | 
| Bucket_6 | 
| Bucket_7 | 
| Bucket_8 | 
| Bucket_9 | 
| Bucket_10 | 
| Bucket_11 | 
| Bucket_12 | 
| Bucket_13 | 
| Bucket_14 | 
| Bucket_15 | 
| Bucket_16 | 
| Bucket_17 | 
| Bucket_18 | 
| Bucket_19 | 
| Bucket_20 | 
| Bucket_21 | 
| Bucket_22 | 
| Bucket_23 | 
| Bucket_24 | 
| Bucket_25 | 
| Bucket_26 | 
| Bucket_27 | 
| Bucket_28 | 
| Bucket_29 | 
| Bucket_30 | 
| Bucket_31 | 
| Bucket_32 | 
| Bucket_33 | 
| Bucket_34 | 
| Bucket_35 | 
| Bucket_36 | 
| Bucket_37 | 
| Bucket_38 | 
| Bucket_39 | 
| Bucket_40 | 
| Bucket_41 | 
| Bucket_42 | 
| Bucket_43 | 
| Bucket_44 | 
| Bucket_45 | 
| Bucket_46 | 
| Bucket_47 | 
| Bucket_48 | 
| Bucket_49 | 
| Bucket_50 | 
| Bucket_51 | 
| Bucket_52 | 
| Bucket_53 | 
| Bucket_54 | 
| Bucket_55 | 
| Bucket_56 | 
| Bucket_57 | 
| Bucket_58 | 
| Bucket_59 | 
| Bucket_60 | 
| Bucket_61 | 
| Bucket_62 | 
| Bucket_63 | 
| Bucket_64 | 
| Bucket_65 | 
| Bucket_66 | 
| Bucket_67 | 
| Bucket_68 | 
| Bucket_69 | 
| Bucket_70 | 
| Bucket_71 | 
| Bucket_72 | 
| Bucket_73 | 
| Bucket_74 | 
| Bucket_75 | 
| Bucket_76 | 
| Bucket_77 | 
| Bucket_78 | 
| Bucket_79 | 
| Bucket_80 | 
| Bucket_81 | 
| Bucket_82 | 
| Bucket_83 | 
| Bucket_84 | 
| Last_Billing_Total_Charges | 
| Last_Billing_Total_Taxes |