RightRev Connector – Fields Mapping

effective field mapping is critical to the rightrev integration, ensuring accurate data ingestion from nue into rightrev for revenue recognition and downstream accounting this doc outlines the standard field mappings between nue and rightrev for orders, invoices, and credit memos, along with key behaviors and implementation notes scope this guide covers mappings for the following objects flowing from nue to rightrev orders (order and order product) invoices (invoice and invoice item detail) credit memos (credit memo and credit memo item detail) standard fields mapping orders rightrev order field nue order product field additional description source system nue transaction orders valid values are order, orders order number orderproduct name (orderitem orderitemnumber) order financial id orderproduct id unique identifier of the order item order date orderproduct activateddate confirming with rightrev customer name orderproduct order customer name customer id orderproduct order customerid product name orderproduct sku product name is mapped to product sku order quantity orderproduct quantity po number n/a unit list price orderproduct listprice unit sell price orderproduct netsalesprice total list price orderproduct listtotalprice total sell price orderproduct totalprice discount percent orderproduct discount discount amount orderproduct discountamount revenue start date orderproduct subscriptionstartdate revenue end date orderproduct subscriptionenddate transaction currency if multi currency is enabled currencyisocode otherwise, use the company's default currency code (e g , usd) functional currency if multi currency is enabled currencyisocode otherwise, use the company's default currency code (e g , usd) global currency if multi currency is enabled currencyisocode otherwise, use the company's default currency code (e g , usd) amendment reason orderprdouct changetype if 'cancel', then 'cancel' otherwise, 'new system will set value required as true or false for this field based on enable carves allocation flag in tenant configuration if set as true, then this field needs to have one of the valid value in contract amendment policy parent order reference reference the order product when a cancellation (or a quantity reduction, term reduction) occurs ssp date n/a populate date value if system need to consider this date instead of order date to pick the ssp for this order line carves eligible orderproduct carveseligible this flag is to determine the order line is eligible to include in carves allocation or not valid values are true / false (case in sensitive) contract liability segment orderproduct contractliabilitysegment contract revenue segment orderproduct contractrevenuesegment carves liability segment orderproduct carvesliabilitysegment carves revenue segment orderproduct carvesrevenuesegment legal entity the legal entity id usage bookings true if revenue model in (overage usage, pay as you go) false otherwise this flag is to determine the order line is usage based booking or not valid values are true / false (case in sensitive) billing revenue accrual true if revenue model in (overage usage, pay as you go) false otherwise this flag is to determine the billing for this order line is accrual basis or not valid values are true / false (case in sensitive) product id orderproduct productid revenue model product pricemodel this is our custom field invoices rightrev invoice field nue invoice item field additional description source system nue transaction type invoices type of the transaction data valid values are invoice / invoices (case in sensitive) bill number invoice item name bill date invoice item transactiondate bill financial id invoiceitemdetail id bill quantity invoice item detail transaction quantity bill amount invoice item detail transaction amount without tax revenue start date invoice item detail start date revenue end date invoice item detail end date transaction currency if multi currency is enabled currencyisocode otherwise, use the company's default currency code (e g , usd) functional currency if multi currency is enabled currencyisocode otherwise, use the company's default currency code (e g , usd) when multi entity is enabled, the currency of the entity is the functional currency global currency if multi currency is enabled currencyisocode otherwise, use the company's default currency code (e g , usd) when multi entity is enabled, the corporate currency functional exchange rate 1 global exchange rate 1 reference financial id invoice item detail order product id this field needs to have valid corresponding order line financial id of this invoice line identifiers and relationships order lines use order financial id (orderproduct id) as the unique line level identifier used across subsequent invoices and credit memos invoice and credit memo lines must reference the originating order line via reference financial id = order product id to ensure proper linkage for revenue processing example querying order line data the following example graphql query shows how order product fields (including customer context) can be retrieved for building the rightrev payload for product sourced fields, use the product catalog mirror (cached) as noted query { orderproduct(where {linetype { in \["lineitem", "rampitem"]}}) { id name quantity listprice listtotalprice netsalesprice totalprice discount discountamount subscriptionstartdate subscriptionenddate changetype linetype order { customerid customer { id name } id name } } }