3.1.3 Account Arrears Details

Entity Name: ARRS

Description: This entity holds account arrears details related data from product processor.

Data Sequence:
ARRS|Account Number|Arrear Type|Arrear Amount|Paid Amount|Arrear Due|Last Payment Date|Days in Arrear|Reference Value|Installment Number|Arrears Due Date|Sub Arrear Type|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10|udf11|udf12|udf13|udf14|udf15|udf16|udf17|udf18|udf19|udf20|udf21|udf22|udf23|udf24|udf25|udf26|udf27|udf28|udf29|udf30|udf31|udf32|udf33|udf34|udf35|udf36|udf37|udf38|udf39|udf40|udf41|udf42|udf43|udf44|udf45|udf46|udf47|udf48|udf49|udf50

Table 3-3 Account Arrears Details

Field Name Description Possible Values / Examples Data Type Data Length Required/Optional
Account Number Account Number as stored in Host Customer Account Number VARCHAR2 30 Required
Arrear Type Arrear type. Example,interest and fee.

C- Principal

F - Fees

I - Interest

S- Legal Fees

VARCHAR2 30 Required
Arrear Amount Total arrear rose per arrear type. - NUMBER 36,18 Required
Paid Amount Amount paid so far. Zero if no payments are received - NUMBER 36,18 Required
Arrear Due Arrears Due Amount - NUMBER 36,18 Required
Last Payment Date Date when last payment was received - DATE - Optional
Days in Arrear Days this arrear is open - NUMBER 4,0 Required
Reference Value Sequence Number for arrear type - VARCHAR2 50 Required
Installment Number Installment Number - NUMBER 5 Required
Arrears Due Date Arrears Due Date - DATE - Optional
Sub Arrear Type Sub Arrear Type. Example, Fee Subtype Legal.

A - Adhoc

L - Adhoc Fee

N - Normal

P - Periodic Fee

VARCHAR2 30 Optional