1.2 Data Model Used

Column	Type
Reference Number	CHARACTER
Corporate ID	CHARACTER
Account Number	CHARACTER
Virtual Account Number	CHARACTER
Source Application	CHARACTER
External Reference Number	CHARACTER
Customer Reference Number	CHARACTER
Counterparty ID	CHARACTER
Cashflow Code	CHARACTER
Cashflow Type	CHARACTER
Start Day	NUMBER
Start Month	CHARACTER
Start Year	CHARACTER
Expected Amount	NUMBER
Currency	CHARACTER
Channel	CHARACTER
Payment Due in Days	NUMBER
Disputed	CHARACTER
Due Month End	CHARACTER
Due_ Month_ 1Half	CHARACTER
Due_ Month_ 2Half	CHARACTER
Due Month	NUMBER
Total Settlement Tranche Count	NUMBER
First Tranche Delay Days	NUMBER
Average Tranche gap Days	NUMBER
Total Amount paid	NUMBER
Total Amount paid	NUMBER
Over due Amount	NUMBER
Historic Average gaps between payments	NUMBER
Historic delay ratio	NUMBER
Historic Cashflow code delay ratio	NUMBER
Historic First pay Delay ratio	NUMBER
Historic average prepaid First Tranche Delay	NUMBER
Total prepaid First Tranche Count	NUMBER
Last Paid Status	CHARACTER
Total Paid Count	NUMBER
Total Paid Amount	NUMBER
Total Paid Late Count	NUMBER
Total Paid Late Amount	NUMBER
Total Overdue count	NUMBER