> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Account Field Mappings: Zuora to NetSuite Sync

> This section details the account information mappings for syncing from Zuora to NetSuite, including cases where Source and Destination fields are linked to different objects.

This section details the account information mappings for syncing from Zuora to NetSuite, including cases where Source and Destination fields are linked to different objects.

In some cases, the **Source** and **Destination** fields are associated with different objects.

## Account Field Mappings

The **Destination** column lists the default names for the fields in NetSuite. Your fields may have been modified from the default values.

<table>
  <tr>
    <th>
      Source Field
    </th>

    <th>
      Destination Field
    </th>

    <th>
      Notes
    </th>
  </tr>

  <tr>
    <td>
      Account.AccountNumber Account.Name
    </td>

    <td>
      Customer ID (entityId)
    </td>

    <td>
      * If Z-Suite preference **Customer Account Number Mapping** is **Use Number From Source Record**, the Zuora Account Number will be used.
      * If Z-Suite preference **Customer Account Number Mapping** is **Use Name from Source Record**, the Zuora Account Name will be used.
      * If Z-Suite preference **Customer Account Number Mapping** is **Let Destination Auto-Number**, no value will be mapped and NetSuite will assign the next available Customer ID (assuming Auto-Generated Numbers are enabled within NetSuite).

      Whether this field is updated for subsequent updates is determined by the Z-Suite preferences **Customer Account Sync Behavior** and **Customer Account Number Update Behavior**.

      > **Note**
      >
      > Avoid using double quotation mark ( `"` ) and comma ( `,` ) in Account.Name because it will cause data sync issues.
    </td>
  </tr>

  <tr>
    <td>
      Account.AccountNumber
    </td>

    <td>
      Zuora Account Number
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.AutoPay
    </td>

    <td>
      AutoPay custentityzuoraautopay
    </td>

    <td>
      boolean
    </td>
  </tr>

  <tr>
    <td>
      Account.Batch
    </td>

    <td>
      Batch custentityzuorabatch
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.BillCycleDay
    </td>

    <td>
      BillCycleDay custentityzuorabillcycleday
    </td>

    <td>
      Cross-reference to translate Zuora API value back to Zuora label
    </td>
  </tr>

  <tr>
    <td>
      Account.CreatedDate
    </td>

    <td>
      Zuora Created Date
    </td>

    <td>
      Text field
    </td>
  </tr>

  <tr>
    <td>
      Account.CrmId
    </td>

    <td>
      Zuora CRM ID
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.Currency
    </td>

    <td>
      Currency
    </td>

    <td>
      Lookup to match Zuora Alphabetic Code to the NetSuite Symbol
    </td>
  </tr>

  <tr>
    <td>
      Account.CustomerServiceRepName
    </td>

    <td>
      Zuora Customer Service Rep Name
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.Id
    </td>

    <td>
      Zuora ID
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.Mrr
    </td>

    <td>
      AccountMRR
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.Name
    </td>

    <td>
      companyname
    </td>

    <td>
      Avoid using commas (,) or double quotes (") in the **Account.Name** field. These characters can cause data sychronization issues when the account is synced to NetSuite.
    </td>
  </tr>

  <tr>
    <td>
      Account.Notes
    </td>

    <td>
      comments
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.PaymentTerm
    </td>

    <td>
      terms
    </td>

    <td>
      Standard field in NetSuite.
    </td>
  </tr>

  <tr>
    <td>
      Account.PaymentTerm
    </td>

    <td>
      Zuora Payment Term
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.PurchaseOrderNumber
    </td>

    <td>
      Zuora Purchase Order Number
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.SalesRepName
    </td>

    <td>
      Zuora Sales Rep
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.Status
    </td>

    <td>
      isInactive
    </td>

    <td>
      If the Status is "Canceled", set this to "true."
    </td>
  </tr>

  <tr>
    <td>
      Account.TaxExemptCertificateID
    </td>

    <td>
      Zuora Tax Exempt Certificate ID
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.TaxExemptCertificateID
    </td>

    <td>
      Tax Reg. Number (vatRegNumber)
    </td>

    <td>
      Only mapped if Z-Suite Advanced Setting **Use Standard Invoice Sync** is **No**. Otherwise no value is mapped.
    </td>
  </tr>

  <tr>
    <td>
      Account.VATID
    </td>

    <td>
      Tax Reg. Number (vatRegNumber)
    </td>

    <td>
      Ensure the accuracy of the `VATID` field in Zuora prior to syncing. Note that if the field is updated to **null** from a non-null value in Zuora, it cannot be updated due to limitations in the NetSuite API. This feature is available only for invoice settlement customers. To enable this feature in your tenant, submit a [support ticket](https://support.zuora.com/) .
    </td>
  </tr>

  <tr>
    <td>
      Account.TaxExemptStatus
    </td>

    <td>
      Zuora Tax Exempt Status
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.TaxExemptStatus
    </td>

    <td>
      Taxable (isTaxable)
    </td>

    <td>
      Only mapped if Z-Suite Advanced Setting **Use Standard Invoice Sync** is **No**. Otherwise no value is explicitly mapped.
    </td>
  </tr>

  <tr>
    <td>
      Account.UpdatedDate
    </td>

    <td>
      Zuora Updated Date
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Account.IntegrationId\_\_NS
    </td>

    <td>
      internalId
    </td>

    <td>
      Update Zuora with the NetSuite Internal ID after create/link only.
    </td>
  </tr>

  <tr>
    <td>
      Account.IntegrationStatus\_\_NS
    </td>

    <td>
      n/a
    </td>

    <td>
      Update Zuora with "Sync Complete" after create/link only. See [Integration Status and Error Recovery](/docs/platform/integration/integration-hub/advanced-connectors/billing-connector-for-netsuite-gl/integration-between-zuora-and-netsuite/netsuite-connector-sync-concepts/integration-status-and-error-recovery) for more information.
    </td>
  </tr>

  <tr>
    <td>
      Account.SyncDate\_\_NS
    </td>

    <td>
      n/a
    </td>

    <td>
      Update Zuora with current timestamp after create/link only.
    </td>
  </tr>

  <tr>
    <td>
      Account.CustomerType\_\_NS
    </td>

    <td>
      Type (isPerson)
    </td>

    <td />
  </tr>

  <tr>
    <td>
      BillToContact.Address1
    </td>

    <td>
      addressbookList.addr1
    </td>

    <td>
      Where `defaultBilling=true`
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.Address2
    </td>

    <td>
      addressbookList.addr2
    </td>

    <td>
      Where `defaultBilling=true`
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.City
    </td>

    <td>
      addressbookList.city
    </td>

    <td>
      Where `defaultBilling=true`
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.Country
    </td>

    <td>
      addressbookList.country
    </td>

    <td>
      Where `defaultBilling=true`

      static xref
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.Fax
    </td>

    <td>
      fax
    </td>

    <td />
  </tr>

  <tr>
    <td>
      BillToContact.FirstName BillToContact.LastName
    </td>

    <td>
      addressbookList.addressee
    </td>

    <td>
      If `defaultBilling=true` , concatenate the values.
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.FirstName BillToContact.LastName
    </td>

    <td>
      firstName lastName
    </td>

    <td>
      Only mapped if CustomerType\_\_NS is "individual."
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.Id
    </td>

    <td>
      Zuora Bill To ID
    </td>

    <td />
  </tr>

  <tr>
    <td>
      BillToContact.PostalCode
    </td>

    <td>
      addressbookList.zip
    </td>

    <td>
      Where `defaultBilling=true`
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.State
    </td>

    <td>
      addressbookList.state
    </td>

    <td>
      Where `defaultBilling=true`

      The **State** field cannot be populated in NetSuite from Zuora's **Bill To Contact** and **Sold To Contact** fields, except for the United States.
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.TaxRegion
    </td>

    <td>
      Zuora Bill To Tax Region
    </td>

    <td />
  </tr>

  <tr>
    <td>
      BillToContact.WorkEmail
    </td>

    <td>
      Zuora Bill To Work Email
    </td>

    <td>
      There is no field for email on the addressbook list, so this is added to the custom header.
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.WorkEmail
    </td>

    <td>
      Customer.email
    </td>

    <td>
      Standard field
    </td>
  </tr>

  <tr>
    <td>
      BillToContact.WorkPhone
    </td>

    <td>
      phone
    </td>

    <td />
  </tr>

  <tr>
    <td>
      BillToContact.WorkPhone
    </td>

    <td>
      addressbookList.phone
    </td>

    <td>
      Where `defaultBilling=true`
    </td>
  </tr>

  <tr>
    <td>
      DefaultPaymentMethod.Type
    </td>

    <td>
      Zuora Default Payment Method
    </td>

    <td />
  </tr>

  <tr>
    <td>
      SoldToContact.Address1
    </td>

    <td>
      addressbookList.addr1
    </td>

    <td>
      Where `defaultShipping=true`
    </td>
  </tr>

  <tr>
    <td>
      SoldToContact.Address2
    </td>

    <td>
      addressbookList.addr2
    </td>

    <td>
      Where `defaultShipping=true`
    </td>
  </tr>

  <tr>
    <td>
      SoldToContact.City
    </td>

    <td>
      addressbookList.city
    </td>

    <td>
      Where `defaultShipping=true`
    </td>
  </tr>

  <tr>
    <td>
      SoldToContact.Country
    </td>

    <td>
      addressbookList.country
    </td>

    <td>
      Where `defaultShipping=true`
    </td>
  </tr>

  <tr>
    <td>
      SoldToContact.FirstName SoldToContact.LastName
    </td>

    <td>
      addressbookList.addressee
    </td>

    <td>
      Where `defaultShipping=true`

      Concatenate the values
    </td>
  </tr>

  <tr>
    <td>
      SoldToContact.Id
    </td>

    <td>
      Zuora Sold To ID
    </td>

    <td />
  </tr>

  <tr>
    <td>
      SoldToContact.PostalCode
    </td>

    <td>
      addressbookList.zip
    </td>

    <td>
      Where `defaultShipping=true`
    </td>
  </tr>

  <tr>
    <td>
      SoldToContact.State
    </td>

    <td>
      addressbookList.state
    </td>

    <td>
      Where `defaultShipping=true`
    </td>
  </tr>

  <tr>
    <td>
      SoldToContact.WorkEmail
    </td>

    <td>
      Zuora Sold To Work Email
    </td>

    <td>
      There is no field for email on the addressbook list, so this is added to the custom header.
    </td>
  </tr>

  <tr>
    <td>
      SoldToContact.WorkPhone
    </td>

    <td>
      addressbookList.phone
    </td>

    <td>
      Where `defaultShipping=true`
    </td>
  </tr>

  <tr>
    <td>
      n/a
    </td>

    <td>
      Zuora Sync Date
    </td>

    <td>
      Current timestamp
    </td>
  </tr>

  <tr>
    <td>
      n/a
    </td>

    <td>
      entityStatus
    </td>

    <td>
      Defaulted by NetSuite. For example, "Customer Closed Won".
    </td>
  </tr>

  <tr>
    <td>
      n/a
    </td>

    <td>
      addressbookList.replaceAll
    </td>

    <td>
      If syncing an existing record and Z-Suite preference **Customer Sync Behavior** is **Sync New and Modified Record**, map "true". All existing NetSuite address entries will be removed and replaced with the address(es) from the Zuora Account Contact(s).
    </td>
  </tr>

  <tr>
    <td>
      Account.Subsidiary\_\_NS
    </td>

    <td>
      Subsidiary
    </td>

    <td>
      Lookup by Full Name to retrieve internalId. The Account.Subsidiary\_\_NS must be the fully-qualified hierarchy name. For example, `Parent Record : Child Record` . The colon and the spaces surrounding the colon are required.

      This is available only in NetSuite OneWorld edition
    </td>
  </tr>

  <tr>
    <td>
      n/a
    </td>

    <td>
      addressbookList.label
    </td>

    <td>
      "Zuora Bill To Address" or "Zuora Sold To Address"
    </td>
  </tr>

  <tr>
    <td>
      n/a
    </td>

    <td>
      Tax Item
    </td>

    <td>
      Mapped from Z-Suite preference **NetSuite Default Tax Code** if populated.
    </td>
  </tr>
</table>