Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: CGY007
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| CGY007 | CGY007Action needed | MRC10907536 | AN PHANAction needed | 70550000002883356 | Inactive | 20 Mar 2025 | 06 Apr 2026 | $0.00 | 01 Nov 2026, 6: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
2 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_1O4FpEDokh9Yo4OYLLTlBTUQ | canceled | cus_Orzo4w9xwVDkI6 | — | 1148shmily@gmail.com | $100.00 | month | 2024-06-23T04:33:00.000Z | 23 Oct 2023, 3:33 pm AEDT | 28 May 2024, 11:14 am AEST | 1pm2ub | 1PM2UB | Rego | — | No | Cancelled | E7EQNA | — | — | No | 29 Oct 2026, 7:45 pm AEDT | 0 | — | Open in Stripe (MRC) |
| sub_1OswtVDokh9Yo4OYZ2UcjF4g | canceled | cus_PiNeg94tEp1OFl | —Action needed | 1148shmily@gmail.com | $110.00 | month | 2025-12-11T00:39:00.000Z | 11 Mar 2024, 11:39 am AEDT | 25 Nov 2025, 12:40 pm AEDT | CGY007Action needed | CGY007 | Rego | — | No | — | — | Inactive | MRC10907536 | 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
5 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22 Oct 2026, 1:47 am AEDT | mrc | 70550000002151044 | CGY007 | AN PHAN | status_change | stage | ACTIVE | INACTIVE | 22 Oct 2026, 1:29 am AEDT | 70550000002883356 | zoho_contact | No | — | Stage ACTIVE → INACTIVE | — |
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000002151044 | CGY007 | AN PHAN | removed | — | ACTIVE | REMOVED | 16 Apr 2026, 2:54 am AEST | 70550000002883356 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000002151044 | CGY007 | AN PHAN | removed | — | ACTIVE | REMOVED | 16 Apr 2026, 2:54 am AEST | 70550000002883356 | zoho_contact | No | — | MRC Policies record removed | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000002151044 | CGY007 | AN PHAN | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 16 Apr 2026, 2:54 am AEST | 70550000002883356 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000002151044 | CGY007 | AN PHAN | updated | cover_type | — | RIDE SHARE | 16 Apr 2026, 2:54 am AEST | 70550000002883356 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |