3.1.3 Account Arrears Details
This topic provides the systematic instructions to 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 |
Parent topic: Account Data