Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NetSuite Target Field

Chargebee Source Field

Additional information

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

...

NetSuite Target Field

Chargebee Source Field

Comment

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

...

NetSuite Target Field

Chargebee Source Field

Comment

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

See also: