Why Is There a Mismatch Between the ChargedThroughDate Values in the RATE_PLAN_CHARGE Table and My Source Data?

Question

Why is there a mismatch between the ChargedThroughDate column values in the RATE_PLAN_CHARGE table and my source data?

Environment

Connector: Zuora

Answer

We incrementally update the RATE_PLAN_CHARGE table based on the data we retrieve from Zuora API's RatePlanCharge endpoint. Specifically, we update the table when Zuora updates the UpdatedDate field.

However, Zuora doesn't update the UpdatedDate field when the ChargedThroughDate field is updated. See Zuora's RatePlanCharge field descriptions for more information. As a result, we don't incrementally update the RATE_PLAN_CHARGE table when the ChargedThroughDate field is updated.

To view up-to-date RATE_PLAN_CHARGE table data, you can do a full re-sync or wait until another field change causes Zuora to update the UpdatedDate field.