> ## Documentation Index
> Fetch the complete documentation index at: https://betterdatainc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# NetSuite Connector

> Set up NetSuite import integration and field mapping.

## Overview

Map NetSuite records into Better Data import payloads through your ETL layer.
Start with catalog and suppliers, then add inventory and purchase orders.

## Common Mapping

| NetSuite Field                       | Better Data Field                   | Notes                                  |
| ------------------------------------ | ----------------------------------- | -------------------------------------- |
| `items.itemid`                       | `externalId`                        | SKU key for catalog import             |
| `items.displayname`                  | `name`                              | Optional catalog display name          |
| `inventorybalance.item`              | `levels[].skuId`                    | Inventory SKU                          |
| `locations.name`                     | `levels[].locationId`               | External location code                 |
| `inventorybalance.quantityonhand`    | `levels[].quantityOnHand`           | Absolute stock                         |
| `inventorybalance.quantityavailable` | `levels[].quantityReserved`         | Usually derive as `onHand - available` |
| `vendors.entityid`                   | `suppliers[].externalId`            | Supplier key                           |
| `transaction.tranid`                 | `purchaseOrders[].externalPoNumber` | PO number                              |
| `transactionline.item`               | `purchaseOrders[].lines[].skuId`    | PO line SKU                            |
| `transactionline.quantity`           | `purchaseOrders[].lines[].quantity` | PO line quantity                       |
| `transactionline.rate`               | `purchaseOrders[].lines[].unitCost` | PO line cost                           |

## Example Transformation Output

```json theme={null}
{
  "purchaseOrders": [
    {
      "externalPoNumber": "PO-100245",
      "supplierId": "SUP-ACME",
      "destinationLocationId": "DC-WEST",
      "status": "PENDING",
      "lines": [
        { "skuId": "SKU-001", "quantity": 500, "unitCost": 4.25 }
      ]
    }
  ]
}
```