Implement subscription status cache for offline lookups

Context

Part of the Data Caching and Offline Capabilities epic (#20322). This issue focuses on implementing the caching layer for subscription status data.

Objective

Replicate subscription status data from Zuora to CustomersDot to enable offline lookups and maintain operational continuity during Zuora outages.

Requirements

• Implement data replication mechanism for subscription status
• Create local subscription status schema
• Support real-time or near-real-time status updates
• Implement cache invalidation for status changes
• Handle subscription lifecycle events (creation, renewal, cancellation)

Success Criteria

• Subscription status data successfully replicated to local cache
• Offline lookups return accurate subscription status
• Cache hit rate >95% for subscription status queries
• Status updates propagate within acceptable latency