DTR Transaction Demo

Transaction Demo data

Back Office Transaction Demo data - simulated data that analyses Various Interest Rates applied to Totals and Fines for late payment

This is rather difficult to work out since the rates for compound are complex depending on the number of "compound Intervals" and if the "Interest is calculated Anually or Monthly"

Invoice ID*

26062026_[1545]_023813_0
Customer Supplied i.e. Dynamic from DTR Wizard

Date

26062026_[1545]_023813_187654322

Organisation Name*

Customer Supplied i.e. Dynamic from DTR Wizard

Organisation ID*

Customer Supplied i.e. Dynamic from DTR Wizard

Product Name*

Customer Supplied i.e. Dynamic from DTR Wizard

Product ID*

Customer Supplied i.e. Dynamic from DTR Wizard

Date Received GGB)*

Date Clear Funds Payment was received by GGB Bank

Date Due (GGB)*

Date GGB Expected Payment

Payment*

Payment made and sent by Organisation

Payment Due (GGB)*

Payment Expected by (GGB)

Balance Due (P)*

Payment amount not received - i.e resulting in balance due

Detext drop down values

[1514] : 1+ ([1517]/100/[1516]) : ( [1516] * [1519] * [1522] ) : [1520] : [1513]

Interest Rate Monthly/Yearly (n)Interest Rate Monthly/Yearly (n)

Fine Compound daily Interest Rate (r)

Set for example 10% this is references the number of days late

Fine Caluclation Period Spread Interest Rate(t)Fine Caluclation Period Spread Interest Rate(t)

Set for example 5% this is references the number of days late 1 Month= 365/12= 30.4167 (days)

Number Of Months / Years

If above this = Months or Years multiple it by this field: Default is 12 for 12 months

Fine Compound Interval (n)Fine Compound Interval (n)

Set for example 5% this is references the number of days late 1 Month= 365/12= 30.4167 (days)

Fine Amount (A)*

Calculated as the amount of (Days Late) * (Fine Compound Calculator)old - ( [1514] * Math.pow( (1 + [1517]/100/[1516]), [1516] * [1519]*[1522] ) ) - [1514]

Total Payment Due (GGB)*

If you are human, leave this field blank.

Invoice ID	Date	Organisation Name	Organisation ID	Product Name	Product ID	Date Received GGB)	Date Due (GGB)	Payment	Payment Due (GGB)	Edit	Delete
	187654321	Pimicro GY Ltd		Gold	123456GD	22/10/2019	15/10/2019	91,000	91,500
Invoice ID	Date	Organisation Name	Organisation ID	Product Name	Product ID	Date Received GGB)	Date Due (GGB)	Payment	Payment Due (GGB)	Edit	Delete

DTR Transaction Demo – Add

Transaction Demo data

DTR Summary - Add

Equipment Category

Equipment Category

Claim Operation Type