Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: 1QT1FJ
View customer →Pay Advantage Direct Debits
0 rows
| code | rego_raw | status | customer_name | customer_code | recurring_amount | frequency | next_payment_date | live_checked_at | synced_at | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No rows found | ||||||||||||
MRC Policies
1 rows
| Name | Rego | Policy Number | Customer Name | Customer ID | Stage | Start Date | Cancel Date | Premium | Synced At | Open |
|---|---|---|---|---|---|---|---|---|---|---|
| 1QT1FJ | 1QT1FJ | MRC10914654 | Oscar Majano | 70550000007394627 | Cancel | 04 Mar 2026 | 14 Sep 2026 | $135.00 | 01 Nov 2026, 5:10 pm AEDT | Open in Zoho (MRC Policies) |
AssureUs Policies
0 rows
| Rego | Status | Customer Name | Customer ID | Stripe Payment ID | Stripe Customer ID | Payment Method | Payment Status | Next Payment Date | Final Premium | Amount | Premium Period | Start Date | Cancel Date | Cancel Type | Created Time | Synced At | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No rows found | |||||||||||||||||||
MRC Stripe Subscriptions
1 rows
| Subscription ID | Status | Customer ID | Customer Name | Customer Email | Amount | Interval | Next Bill | Created | Canceled/Ended At | Rego Raw | Rego | Match Type | AssureUs Status | AssureUs Stripe | Pay Advantage DD Status | Pay Advantage DD Code(s) | MRC Stage | MRC Policy Number | Double Paying | Imported At | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| sub_1O9DgHDokh9Yo4OYLHUz69nQ | canceled | cus_Ox7wHVyoKVCGRu | — | oscar.majano64@yahoo.com | $135.00 | month | 2026-10-05T21:16:00.000Z | 06 Nov 2023, 8:16 am AEDT | 14 Sep 2026, 1:00 pm AEST | 1QT1FJ | 1QT1FJ | Rego | — | No | — | — | Cancel | MRC10914654 | No | 29 Oct 2026, 7:45 pm AEDT | 0 | — | Open in Stripe (MRC) |
Past Actions
0 rows
| Timestamp | Action | DD Code | Rego | Customer Name | Status Before | Status After | Reason | Result | Error | Batch ID | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|
| No rows found | |||||||||||
Timeline
4 rows
| Detected At | Source | Record ID | Rego | Customer | Event | Field | Old Value | New Value | Source Modified At | Customer Key | Customer Source | Noise | Noise Reason | Change | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000010436626 | 1QT1FJ | Oscar Majano | removed | — | CANCEL | REMOVED | 14 Sep 2026, 12:59 pm AEST | 70550000007394627 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000010436626 | 1QT1FJ | Oscar Majano | removed | — | CANCEL | REMOVED | 14 Sep 2026, 12:59 pm AEST | 70550000007394627 | zoho_contact | No | — | MRC Policies record removed | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000010436626 | 1QT1FJ | Oscar Majano | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 14 Sep 2026, 12:59 pm AEST | 70550000007394627 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000010436626 | 1QT1FJ | Oscar Majano | updated | cover_type | — | RIDE SHARE | 14 Sep 2026, 12:59 pm AEST | 70550000007394627 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |