3234813 - CMT : How to retrieve the "ship to" and "bill to" information when writing a report in the report module.

Applies To:
CPQ

Summary:
This article shows how to retrieve the "ship to" and "bill to" information when writing a report in the report module of CPQ.

Details:
Information of the quote can be found in Cart table but  more detail information for "bill to" and "ship to" of the quote can be found on different tables.

Solution/Workaround:
In the database table CART, there are 2 columns that reference the "SHIP TO" and "BILL TO" data.

Column "CUSTOMER_ID" is for "Bill To" customer and is referenced in db table "CUSTOMER_INFO" by column "column ID"

Column "SHIP_TO" is for "Ship To" customer role and is referenced in db table "SHIP_TO" by column "SHIP_ID"

Comments:

References:
Netsuite Case ID: SC30186096