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

# Customer Field Mappings: NetSuite to Zuora Sync

> This section provides a reference for the mappings of Customer information during the sync process from NetSuite to Zuora.

This section provides a reference for the mappings of Customer information during the sync process from NetSuite to Zuora.

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

## Customer 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 (Invoice Payment)
    </th>

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

  <tr>
    <td>
      Internal ID
    </td>

    <td>
      IntegrationId\_\_NS
    </td>

    <td />
  </tr>

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

    <td>
      SyncDate\_\_NS
    </td>

    <td>
      The current timestamp.
    </td>
  </tr>

  <tr>
    <td>
      Customer ID (entityId) Company Name OR First Name + Last Name
    </td>

    <td>
      AccountNumber
    </td>

    <td>
      * If Z-Suite preference **Customer Account Number Mapping** is **Use Number from Source Record**, the NetSuite Customer ID will be used.
      * If Z-Suite preference **Customer Account Number Mapping** is **Use Name from Source Record**, the NetSuite Company Name or First Name + Last Name (depending on Type) will be used.
      * If Z-Suite preference **Customer Account Number Mapping** is **Let Destination Auto-Number**, no value will be mapped and Zuora will assign the next available Account Number.
      * 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**.
    </td>
  </tr>

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

    <td>
      CustomerId\_\_NS
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Child Of (parent.InternalId)
    </td>

    <td>
      ParentId
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraBatch
    </td>

    <td>
      BillCycleDay
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraBillCycleDay
    </td>

    <td>
      n/a
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Comments
    </td>

    <td>
      Notes
    </td>

    <td />
  </tr>

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

    <td>
      Status
    </td>

    <td>
      "Draft" initially. "Active" when completed.
    </td>
  </tr>

  <tr>
    <td>
      ZuoraID
    </td>

    <td>
      Id
    </td>

    <td>
      For updates only.
    </td>
  </tr>

  <tr>
    <td>
      ZuoraBillToID
    </td>

    <td>
      Contact.Id
    </td>

    <td>
      For updates only.
    </td>
  </tr>

  <tr>
    <td>
      ZuoraSoldToID
    </td>

    <td>
      Contact.Id
    </td>

    <td>
      For updates only.
    </td>
  </tr>

  <tr>
    <td>
      Currency
    </td>

    <td>
      Currency
    </td>

    <td>
      If not populated, the Z-Suite preference **Zuora Default Currency** will be used.
    </td>
  </tr>

  <tr>
    <td>
      Type (IsPerson) Company Name First Name Last Name
    </td>

    <td>
      Name
    </td>

    <td>
      If `Type` is `Individual` , `First Name` and `Last Name` will be combined, otherwise `Company Name` will be used.
    </td>
  </tr>

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

    <td>
      AllowInvoiceEdit
    </td>

    <td>
      "true"
    </td>
  </tr>

  <tr>
    <td>
      ZuoraID
    </td>

    <td>
      Contact.AccountId
    </td>

    <td />
  </tr>

  <tr>
    <td>
      phone
    </td>

    <td>
      Contact.WorkPhone
    </td>

    <td />
  </tr>

  <tr>
    <td>
      fax
    </td>

    <td>
      Contact.Fax
    </td>

    <td />
  </tr>

  <tr>
    <td>
      Addresslist.Addressee
    </td>

    <td>
      Contact.FirstName Contact.LastName
    </td>

    <td>
      These value are combined if both are populated. If `FirstName` is empty, `LastName` is repeated. If `LastName` is empty, the integration manager will return a warning.

      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.Addr1
    </td>

    <td>
      Contact.Address1
    </td>

    <td>
      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.Addr2
    </td>

    <td>
      Contact.Address2
    </td>

    <td>
      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.city
    </td>

    <td>
      Contact.City
    </td>

    <td>
      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.state
    </td>

    <td>
      Contact.State
    </td>

    <td>
      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.zip
    </td>

    <td>
      Contact.Zip
    </td>

    <td>
      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.country
    </td>

    <td>
      Contact.Country
    </td>

    <td>
      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

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

    <td>
      Contact.Description
    </td>

    <td>
      "Bill To Contact"
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.Addressee
    </td>

    <td>
      Contact.FirstName Contact.LastName
    </td>

    <td>
      These value are combined if both are populated. If `FirstName` is empty, `LastName` is repeated.

      This is mapped if `defaultShipping` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.Addr1
    </td>

    <td>
      Contact.Address1
    </td>

    <td>
      This is mapped if `defaultShipping` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.Addr2
    </td>

    <td>
      Contact.Address2
    </td>

    <td>
      This is mapped if `defaultShipping` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.city
    </td>

    <td>
      Contact.City
    </td>

    <td>
      This is mapped if `defaultShipping` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.state
    </td>

    <td>
      Contact.State
    </td>

    <td>
      This is mapped if `defaultShipping` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.zip
    </td>

    <td>
      Contact.Zip
    </td>

    <td>
      This is mapped if `defaultShipping` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      Addresslist.country
    </td>

    <td>
      Contact.Country
    </td>

    <td>
      This is mapped if `defaultShipping` is `true` .
    </td>
  </tr>

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

    <td>
      Contact.Description
    </td>

    <td>
      "Sold To Contract"
    </td>
  </tr>

  <tr>
    <td>
      ZuoraPaymentTerm
    </td>

    <td>
      PaymentTerm
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraAutoPay
    </td>

    <td>
      AutoPay
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraCRMID
    </td>

    <td>
      CRM ID
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraCustomerServiceRepName
    </td>

    <td>
      Customer Service Rep Name
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraPurchaseOrderNumber
    </td>

    <td>
      Purchase Order Number
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraSalesRep
    </td>

    <td>
      Sales Rep
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraDefaultPaymentMethod
    </td>

    <td>
      Default Payment Method
    </td>

    <td />
  </tr>

  <tr>
    <td>
      ZuoraBillToWorkEmail
    </td>

    <td>
      Contact.WorkEmail
    </td>

    <td>
      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      ZuoraSoldToWorkEmail
    </td>

    <td>
      Contact.WorkEmail
    </td>

    <td>
      This is mapped if `defaultShipping` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      ZuoraBillToTaxRegion
    </td>

    <td>
      Contact.TaxRegion
    </td>

    <td>
      This is mapped if `defaultBilling` is `true` .
    </td>
  </tr>

  <tr>
    <td>
      ZuoraTaxExemptStatus
    </td>

    <td>
      Tax Exempt Status
    </td>

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

  <tr>
    <td>
      ZuoraTaxExemptCertificateID
    </td>

    <td>
      Tax Exempt Certificate ID
    </td>

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