customer_financial

The customer_financial table contains information that you can view during Customer Finance Master Maintenance - Financial Panel.

Notes:

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