Sales order data mapping
Zuora provides predefined field mappings between Billing and Revenue Staging sales order lines, which should not be modified.
Some standard fields of subscriptions or amendments in Zuora Billing are mapped to Zuora Revenue Staging fields for sales order lines. The following table describes the pre-defined sales order field mappings between Zuora Billing and Zuora Revenue Staging tables. Zuora recommends not to change the field mapping values and order.
For information on Standard field mapping, see here.
To know about defining your own field mappings, see here.
Sales order date mapping
The sales order date for each SO line is used to determine in which accounting period an SO line is collected or processed in Zuora Revenue.
The SO date for a booking transaction is equals to the RatePlanCharge.OriginalOrderDate. You must ensure the same is mapped to the booking transaction template. RatePlanCharge.OriginalOrderDate is the same as the initial booking date in the subscribed environment or the order date in the Orders environment when the charge is created or modified.
-
SUBSCRP_LAST_BOOK_DATE: The last change date of a subscription. Zuora Revenue takes
Subscription.lastBookingDateas the value.-
For a new subscription created by the Subscribe and Amend APIs , this field has the value of the subscription creation date.
-
For a subscription changed by an amendment, this field has the value of the amendment booking date (
Amendment.CreatedDate). -
For a subscription created or changed by an order, this field has the value of the order date (
Order.orderDate).
-
-
Any other standard or custom Zuora date in the format of Object.Field.
For more information, see Order, subscription and amendment dates .
The following fields are currently deprecated:
-
ORIG_TERM_START_DATE (default)
-
ORIG_CHG_CRT_DATE
-
ORIG_CHG_SEG_CRT_DATE
-
AMENDMENT_CRT_DATE
-
Any other standard or custom Zuora date in the format of Object.Field