Previous Next JavaScript must be enabled to correctly display this content

## 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

Parent topic: Introduction