Docs

Log in to read the version of docs relevant to your site, or use the dropdown versions

Objects and fields mapped between Chargebee and NetSuite

This page helps you understand the objects and field mapping that is done between Chargebee and NetSuite.

Customer

Note:

Source Entity - Chargebee Customer

Supported Actions - Create, Update

Unsupported Actions - Delete, Void

The following table provides information on the customer object fields mapped between Chargebee and NetSuite:

NetSuite Target Field,Chargebee Source Field,Additional information,
entityIdidA prefix is added if this field is configured. For example, If the prefix is CB-Customer and the customer id in Chargebee is 100 then the prefix will be synced as CB-Customer-100. If you have checked the Allow Override option in NetSuite, then Chargebee's identifiers will be set as the primary ID for Invoices, Credit Memos, Customers, and so on. If Allow Override is not set in NetSuite, then the value we've set in Chargebee will be ignored.
external IdidA prefix is added if this field is configured.
companynamecompany or DefaultCompanyNameIf isperson is set false, this field is not applicable
customFieldListMapped as per the backend configuration made, else not applicable.
currencypreferredCurrencyCodeNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
entitystatusMapped as per the configuration, otherwise left blankNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
subsidiaryMapped as per the configurationNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
addressbookListbillingAddressRefer to the NetSuite CustomerAddressbook section below for more details.
firstnamefirstName or DefaultFirstNameThis field is applicable if isperson is set true.
lastnamelastName or DefaultLastNameThis field is applicable if isperson is set true.
ispersontruetrue if the customer company name is not present and has no contacts.
emailemail
phonephone
vatRegNumbervatRegNumber

NetSuite CustomerAddressbook

Customer Address Book in NetSuite is mapped as billing address in Chargebee. Chargebee creates or appends customer billing address to NetSuite's customer address book.

Note:

Source Entity - Chargebee Customer billing address

The following table provides information on the CustomerAddressbook object fields mapped between Chargebee and NetSuite:

NetSuite Target FieldChargebee Source FieldAdditional information
citycity
statestateCode
zipzip
countrycountry
addresseefullname or companyNameMapped based on the configurations made in the backend.Contact Chargebee Support for more help.
addr1line1
addr2line2
addr3line3

NetSuite Item Mapping

In NetSuite, Item is the object name for plans/add-ons in Chargebee.

Note:

Source Entity - Chargebee Plans, Add-ons, and Item Prices

Supported Actions - Create

Unsupported Actions - Delete, Void

The following table provides information on the NetSuite Item mapping done between Chargebee and NetSuite:

NetSuite Target FieldChargebee Source FieldAdditional information
externalIdsku or nameA prefix is added if this field is configured.If you have checked the Allow Override option in NetSuite, then Chargebee's identifiers will be set as the primary ID for Invoices, Credit Memos, Customers, and so on. If Allow Override is not set in NetSuite, then the value we've set in Chargebee will be ignored.
itemidsku or nameIf sku value is present, the source field is mapped as sku, else mapped as name. A prefix is added if this field is configured. If you have checked the Allow Override option in NetSuite, then Chargebee's identifiers will be set as the primary ID for Invoices, Credit Memos, Customers, and so on. If Allow Override is not set in NetSuite, then the value we've set in Chargebee will be ignored.
classaccountingCategory1Mapped based on Item level class or doc_level_tracking
locationaccountingCategory2Mapped based on Item level location or doc_level_tracking.
departmentaccountingCategory3Mapped based on Item level department or doc_level_tracking
revenueRecognitionRuleaccountingCategory4Mapped based on Item level Revenue Recognition Rule Id
revRecForecastRuleaccountingCategory4Mapped based on Item level Revenue Recognition Rule Id
taxSchedule Mapped as per the backend configuration made, otherwise left blank. NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
incomeAccountaccountingCodeWe will find matching account either by code or name.
salesDescriptiondescription
subsidiaryListas per configuration

NetSuite Invoice

Note:

Source Entity - Chargebee Invoice

Supported Actions - Create, Update

The following table provides information on the Invoice mapping done between Chargebee and NetSuite:

NetSuite Target FieldChargebee Source FieldComment
billingAddressbillingAddressMapping is done as shown in the above NetSuite Address Mapping section.
class doc_level_tracking or customer_level_tracking can be used (Done based on the backend configuration) Mapped as per the backend configuration made.
currencycurrencyCodeIf the invoice currency is different from customer currency, then we will add the currency to the NetSuite customer and then set the currency reference.
customFieldListMapped as per the configuration made, otherwise mapping is not applicable
department doc_level_tracking or customer_level_tracking can be used (Done based on the backend configuration) Mapped as per the backend configuration made.
dueDatedueDate
entityIdcustomerIdNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
exchangeRateexchangeRateIf use_tp_exchange_rate is configured, we will send a blank field and exchange rate will be handled in NetSuite. Chargebee's exchange rate will not be sent if this field is enabled.
externalIdidA prefix is added if this field is configured.
itemListlineItemsSee the Item List section section shown below for more details
location doc_level_tracking or customer_level_tracking can be used (Done based on the backend configuration) Mapped as per the backend configuration made.
otherRefNumpoNumber
shippingAddressshippingAddressMapping is done as shown in the above NetSuite Address Mapping section.
taxDetailsOverridetrue if override tax is configuredIf true, Chargebee maps the tax information, else, NetSuite default mapping is followed.
termsMapped as per the configuration made, otherwise left blankMapped based on the configurations made in the backend.
tranDatedateMapped as invoice date.
tranIdidA prefix is added if this field is configured.If you have checked the Allow Override option in NetSuite, then Chargebee's identifiers will be set as the primary ID for Invoices, Credit Memos, Customers, and so on. If Allow Override is not set in NetSuite, then the value we've set in Chargebee will be ignored.

NetSuite CreditMemo

In NetSuite, Credit Memo is the object name for Credit Notes in Chargebee.

Note:

Source Entity - Chargebee Credit Note

Supported Actions - Create, Update

NetSuite Target FieldChargebee Source FieldAdditional information
tranIdidA prefix is added if this field is configured. If you have checked the Allow Override option in NetSuite, then Chargebee's identifiers will be set as the primary ID for Invoices, Credit Memos, Customers, and so on. If Allow Override is not set in NetSuite, then the value we've set in Chargebee will be ignored.
externalIdidA prefix is added if this field is configured.
exchangeRateexchangeRateIf use_tp_exchange_rate is configured, we will send a blank field and the exchange rate will be handled in NetSuite.
classdoc_level_tracking or customer_level_tracking can be used.Mapped as per the backend configuration.
location doc_level_tracking or customer_level_tracking can be used. Mapped as per the backend configuration.
departmentdoc_level_tracking or customer_level_tracking can be used. Mapped as per the backend configuration.
itemListlineItemsMapping is shown in the Item List section below.
exchangeRateexchangeRateIf use_tp_exchange_rate is configured, we will send a blank field and exchange rate will be handled in NetSuite. Chargebee's exchange rate will not be sent if this field is enabled.
entityIdcustomerIdNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
currencycurrencyCodeNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
setCreatedFromreferenceInvoiceIdNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
dueDatedueDateNot applicable for Credit Note.
billingAddressbillingAddressNot applicable for Credit Note.Mapping is done as shown in the NetSuite Address Mapping section above.
shippingAddressshippingAddressNot applicable for Credit Note.Mapping is done as shown in the NetSuite Address Mapping section above.
applyListallocationsWe will create or append to the applyList.
taxDetailsOverridetrue if override tax is configuredtrue if override tax is configured, else, NetSuite's default is followed.
tranDatedate
otherRefNumpoNumber
autoApplyfalse
customFieldListMapped as per configuration, else mapping is not applicable.

NetSuite Line Item

Line item-level tracking categories are automatically fed from the items created in NetSuite.

Note:

Source entity - Chargebee Invoice / Credit Note Line Items

The following table provides information on the Line Item level mapping done between Chargebee and NetSuite:

NetSuite Target FieldChargebee Source FieldComment
ItemRefentityId based line item entityType and entityIdIf UseSalesAccount (as_per_sales) is not enabled, for ad-hoc cases, setup charges, bad_debts, discounts → default item that is created by Chargebee is used.We can also map to the existing item (For ad-hoc, setup charges, bad_debts, and discounts) in NetSuite.
DescriptiondescriptionThis field is referred to as External Name on the Chargebee UI.
AmountamountFor tax inclusive cases, the amount is adjusted.
Quantityquantity
IsTaxabletrue/falseMapped based on tax details.
TaxCodeMapped based on the tax mapping and tax line item details.
customFieldListUsed for setting Advanced Revenue Management (ARM) start and end date. dateFrom dateToIf Advanced Revenue Management (ARM) module is enabled, NetSuite supports start and end dates at line item level through custom fields of type date.

NetSuite Customer Payment and Customer Refund

Based on the transaction type, we will map the fields to either payment or refund to NetSuite.

Note:

Source Entity - Chargebee Transaction

The following table provides information on the payment/refund field mapping done between Chargebee and NetSuite:

NetSuite Target FieldChargebee Source FieldComment
customercustomerIdNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
tranIdidA prefix is added if this field is configured. If you have checked the Allow Override option in NetSuite, then Chargebee's identifiers will be set as the primary ID for Invoices, Credit Memos, Customers, and so on. If Allow Override is not set in NetSuite, then the value we've set in Chargebee will be ignored.
externalIdcurrencyCodeNetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)
autoApplyfalse
paymentamountConverted from cents to amount.
checkNumreferenceNumber
memoidAtGateway or referenceNumberif idAtGateway is present,idAtGateway is mapped, else referenceNumber is mapped.
accountMapped based on configurations, currency, and paymentMethod.Gateway + currency account mapping
undepFundsfalse
exchangeRateexchangeRateIf use_tp_exchange_rate is configured, we will send a blank field and exchange rate will be handled in NetSuite.
PaymentMethodMapped based on the payment method configuration.
TranDatedate
classdoc_level_tracking or customer_level_tracking can be used.Mapped based on the backend configuration.
locationdoc_level_tracking or customer_level_tracking can be used.Mapped based on the backend configuration.
departmentdoc_level_tracking or customer_level_tracking can be used.Mapped based on the backend configuration.
customFieldListMapped based on the backend configuration, else left blank.
applyListlinkedInvoices, linkedCreditNotes, referenceTransactionIdpayment uses linkedInvoices refund uses linkedCreditNotes and referenceTransactionId

Was this article helpful?