Content Comparison

entityId

id

A 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.

externalId

id

A prefix is added if this field is configured.

isperson

true

true if the company is present and contacts (First name and last name) is empty.

firstname

firstName or DefaultFirstName

This field is applicable if isperson is set true.

lastname

lastName or DefaultLastName

This field is applicable if isperson is set true.

companyname

company or DefaultCompanyName

If isperson is set false, this field is not applicable

currency

preferredCurrencyCode

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

entitystatus

Mapped as per the configuration, otherwise left blank

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

subsidiary

Mapped as per the configuration

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

email

email

phone

phone

addressbookList

billingAddress

Refer to the NetSuite CustomerAddressbook section below for more details.

customFieldList

Mapped as per the backend configuration made, else not applicable.

vatRegNumber

vatNumber

city

city

state

stateCode

zip

zip

country

country

addressee

fullname or companyName

Mapped based on the configurations made in the backend. Contact Chargebee Support for more help.

addr1

line1

addr2

line2

addr3

line3

itemid

sku or name

If 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.

externalId

sku or 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.

salesDescription

description

subsidiaryList

as per configuration

incomeAccount

accountingCode

We will find matching account either by code or name.

class

accountingCategory1

Mapped based on Item level class or doc_level_tracking

location

accountingCategory2

Mapped based on Item level location or doc_level_tracking

department

accountingCategory3

Mapped based on Item level department or doc_level_tracking

taxSchedule

Mapped as per the backend configuration made, otherwise left blank.

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

revenueRecognitionRule

accountingCategory4

Mapped based on Item level Revenue Recognition Rule Id

revRecForecastRule

accountingCategory4

Mapped based on Item level Revenue Recognition Rule Id

entityId

customerId

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

tranId

id

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.

externalId

id

A prefix is added if this field is configured.

tranDate

date

Mapped as invoice date.

terms

Mapped as per the configuration made, otherwise left blank

Mapped based on the configurations made in the backend.

currency

currencyCode

If the invoice currency is different from customer currency, then we will add the currency to the NetSuite customer and then set the currency reference.

exchangeRate

exchangeRate

If 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.

dueDate

dueDate

otherRefNum

poNumber

billingAddress

billingAddress

Mapping is done as shown in the above NetSuite Address Mappingsection.

shippingAddress

shippingAddress

Mapping is done as shown in the above NetSuite Address Mappingsection.

class

doc_level_tracking or customer_level_tracking can be used (Done based on the backend configuration)

Mapped as per the backend configuration made.

location

doc_level_tracking or customer_level_tracking can be used (Done based on the backend configuration)

Mapped as per the backend configuration made.

department

doc_level_tracking or customer_level_tracking can be used (Done based on the backend configuration)

Mapped as per the backend configuration made.

taxDetailsOverride

true if override tax is configured

If true, Chargebee maps the tax information, else, NetSuite default mapping is followed.

itemList

lineItems

See the Item List section section shown below for more details.

customFieldList

Mapped as per the configuration made, otherwise mapping is not applicable

entityId

customerId

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

tranId

id

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.

externalId

id

A prefix is added if this field is configured.

tranDate

date

currency

currencyCode

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

exchangeRate

exchangeRate

If use_tp_exchange_rate is configured, we will send a blank field and the exchange rate will be handled in NetSuite.

dueDate

dueDate

Not applicable for Credit Note.

otherRefNum

poNumber

billingAddress

billingAddress

Not applicable for Credit Note.

Mapping is done as shown in the NetSuite Address Mapping section above.

shippingAddress

shippingAddress

Not applicable for Credit Note.

Mapping is done as shown in the NetSuite Address Mapping section above.

class

doc_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.

department

doc_level_tracking or customer_level_tracking can be used.

Mapped as per the backend configuration.

taxDetailsOverride

true if override tax is configured

true if override tax is configured, else, NetSuite’s default is followed.

itemList

lineItems

Mapping is shown in the Item List section below.

setCreatedFrom

referenceInvoiceId

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

autoApply

false

applyList

allocations

We will create or append to the applyList.

customFieldList

Mapped as per configuration, else mapping is not applicable.

ItemRef

entityId based line item entityType and entityId

If 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.

Description

description

Amount

amount

For tax inclusive cases, the amount is adjusted.

Quantity

quantity

IsTaxable

true/false

Mapped based on tax details.

TaxCode

Mapped based on the tax mapping and tax line item details.

customFieldList

Used for setting Accounts Receivable Management (ARM) start and end date.

dateFrom

dateTo

If Accounts Receivable Management (ARM) module is enabled, NetSuite supports start and end dates at line item level through custom fields of type date.

customer

customerId

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

tranId

id

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.

externalId

id

A prefix is added if this field is configured.

currency

currencyCode

NetSuite Reference (The reference value from NetSuite is mapped to Chargebee here.)

autoApply

false

payment

amount

Converted from cents to amount.

checkNum

referenceNumber

memo

idAtGateway or referenceNumber

if idAtGateway is present,idAtGateway is mapped, else referenceNumber is mapped.

account

Mapped based on configurations, currency, and paymentMethod.

Gateway + currency account mapping

undepFunds

false

exchangeRate

exchangeRate

If use_tp_exchange_rate is configured, we will send a blank field and exchange rate will be handled in NetSuite.

PaymentMethod

Mapped based on the payment method configuration.

TranDate

date

class

doc_level_tracking or customer_level_tracking can be used.

Mapped based on the backend configuration.

location

doc_level_tracking or customer_level_tracking can be used

Mapped based on the backend configuration.

department

doc_level_tracking or customer_level_tracking can be used.

Mapped based on the backend configuration.

customFieldList

Mapped based on the backend configuration, else left blank.

applyList

linkedInvoices, linkedCreditNotes, referenceTransactionId

payment uses linkedInvoices

refund uses linkedCreditNotes and referenceTransactionId