NetSuite Customer Company From iPaaS.com Mapping Documentation

An organization (company) customer can be created and updated in NetSuite from an iPaaS.com company. The integration maps the company name, email, category, subsidiary, and a range of optional contact attributes, and through its child collection the company's billing/shipping address. Individual (person) customers are handled separately by Add/Update NetSuite Customer FROM iPaaS.com. Companies transfer on demand from the Manual Sync page or automatically when outbound company triggers are enabled.

ID Format

Manual Sync ID Format

Enter the iPaaS.com record ID of the company on the Manual Sync page.

External ID Format

On a successful transfer, iPaaS.com records the NetSuite customer's internal ID as the external-ID link, so subsequent transfers update the existing company. Before that link exists, the integration also recognizes an already-existing NetSuite company by email address (see System Caveats).

Deleted Record Support

Outbound delete is driven by the external-ID link where a customer delete collection is enabled in Outbound Data Flows — a deletion in iPaaS.com removes the matching NetSuite record (no field mappings). Company deletions follow the same mechanism as individual customers.

Custom Field Support

Many optional NetSuite attributes are populated from iPaaS.com custom fields named NetSuite … — NetSuite Phone, NetSuite Mobile Phone, NetSuite Home Phone, NetSuite Alt Phone, NetSuite Alt Email, NetSuite Title, NetSuite Account Number, NetSuite URL, NetSuite Ship Complete, NetSuite Is Inactive, and the NetSuite Subsidiary override. Add the matching iPaaS.com custom field to pass an attribute through; when empty, the attribute is left unset in NetSuite. These same custom fields are populated on the Add/Update NetSuite Customer Company TO iPaaS.com side, so values round-trip between the two directions.

Mapping Collection Status

Status: Enabled (a single Add/Update collection). This collection has no mapping filter — every company routed to it is processed.
Trigger Events: Create and Update, on the iPaaS.com company outbound triggers subscribed in Outbound Data Flows. Manual Sync is always available.

Duplicate or Conflicting Mappings

Add/Update NetSuite Customer FROM iPaaS.com — individual (person) customers.
Add/Update NetSuite Customer Company TO iPaaS.com — captures companies from NetSuite (the reverse direction).

Collision handling

The integration prevents duplicates through the external-ID link plus the email address matching key. Changing or un-mapping email after companies exist can cause duplicates — keep it stable once live.

Supported Child Collections

Add/Update NetSuite Customer Company Address FROM iPaaS.com — the company's billing/shipping address.

System Caveats

NetSuite Caveats

Subsidiary is required on OneWorld accounts. Subsidiary_Id defaults to the root subsidiary (commonly Parent Company); confirm it matches your account and override per company via the NetSuite Subsidiary custom field.
Category must already exist in NetSuite. Category_Id resolves from the company's first category; transfer categories first through Add/Update NetSuite Customer Category FROM iPaaS.com.

iPaaS.com Caveats

Email is the company matching key. The integration recognizes an existing NetSuite company by email. Keep the mapping stable once live — see Collision handling.

Integration-Specific Caveats

"NetSuite …" custom-field convention. Optional attributes are carried through iPaaS.com custom fields named "NetSuite X" and round-trip with the TO direction (see Custom Field Support).

Setup Requirements

Control Fields and Required Configuration

Mapping	Enables	Action	Required?
IsPerson	Company-customer creation	Static `false` — routes the record to a NetSuite company (organization) customer. Individuals use the Customer collection.	Control — required
Subsidiary_Id	OneWorld subsidiary assignment	Defaults to the root subsidiary. Placeholder — replace: confirm the default (Parent Company) matches your account; override per company via the NetSuite Subsidiary custom field.	Required on OneWorld
Email	Duplicate matching	Keep stable once live — it is the company matching key.	Recommended (matching key)

Custom fields: create the NetSuite … custom fields you need in iPaaS.com (the round-trip attributes). Subscription settings: enable the iPaaS.com company create/update/delete triggers in Outbound Data Flows for automatic transfers.

Authentication

The integration authenticates to NetSuite using the connection configured for the integration; see NetSuite Connections and Settings.

Integration Flow

An iPaaS.com company transfers — on demand from the Manual Sync page, or automatically when the company outbound triggers are enabled in Outbound Data Flows.
The integration resolves the NetSuite subsidiary and category, creates or updates the company customer (matched by external ID, then by email), and transfers the address child.
Optional attributes are populated from the NetSuite … custom fields present on the iPaaS.com company.
The NetSuite customer internal ID is stored back on the iPaaS.com company as its external ID.

Mappings

This collection and its address child have no mapping filter — every routed record is processed.

Add/Update NetSuite Customer Company FROM iPaaS.com

iPaaS.com data type: Customer Company

Creates or updates a company (organization) customer in NetSuite from an iPaaS.com customer company, with optional attributes drawn from "NetSuite X" custom fields.

Mapping Type	Source Field (iPaaS.com)	Destination Field (NetSuite)	Description
Static	`false`	IsPerson	Control — required. Marks the record as a company (organization) customer rather than an individual. This collection creates company-type customers; individuals use the Customer collections.
Field	Name	CompanyName	Required. The company name; NetSuite identifies the organization by this name.
Field	EmailAddress	Email	Recommended (matching key). The company's email and the primary key for recognizing an existing company. Changing or un-mapping it after companies exist can create duplicates — keep stable once live.
Dynamic Formula	`await GetCategoryIdByCategoryObj(Categories)`	Category_Id	Optional. Sets the NetSuite customer category from the company's first category. The category must already exist in NetSuite.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Subsidiary")`	Subsidiary_Id	Required on OneWorld accounts. Sets the subsidiary; defaults to the root subsidiary (Parent Company — Placeholder value, confirm/replace), overridable via the NetSuite Subsidiary custom field.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Phone")`	Phone	Optional. Populated from the iPaaS.com NetSuite Phone custom field; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Mobile Phone")`	MobilePhone	Optional. Populated from NetSuite Mobile Phone; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Home Phone")`	HomePhone	Optional. Populated from NetSuite Home Phone; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Alt Phone")`	AltPhone	Optional. Populated from NetSuite Alt Phone; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Alt Email")`	AltEmail	Optional. Populated from NetSuite Alt Email; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Title")`	Title	Optional. Populated from NetSuite Title; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Account Number")`	AccountNumber	Optional. Populated from NetSuite Account Number; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite URL")`	Url	Optional. Populated from NetSuite URL; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Ship Complete")`	ShipComplete	Optional. Populated from NetSuite Ship Complete; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Is Inactive")`	IsInactive	Optional. Whether the company is inactive; populated from NetSuite Is Inactive; left unset when empty.

Add/Update NetSuite Customer Company Address FROM iPaaS.com

iPaaS.com data type: Customer Company Address

Maps the company customer's address into NetSuite, with optional attributes drawn from "NetSuite X" custom fields.

Mapping Type	Source Field (iPaaS.com)	Destination Field (NetSuite)	Description
Field	Address1	Addr1	Recommended. The first address line.
Field	Address2	Addr2	Optional. The second address line.
Field	Address3	Addr3	Optional. The third address line.
Field	City	City	Recommended. The address city.
Field	Region	State	Recommended. The state or region.
Field	PostalCode	Zip	Recommended. The postal/ZIP code.
Field	Country	Country_RefName	Recommended. The country for the address.
Field	IsPrimaryBilling	IsPrimaryBilling	Recommended. Whether this is the company's primary billing address.
Field	IsPrimaryShipping	IsPrimaryShipping	Recommended. Whether this is the company's primary shipping address.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Addressee")`	Addressee	Recommended. The name shown on the address; uses NetSuite Addressee when present, otherwise built from the company name.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Address Attention")`	Attention	Optional. Populated from NetSuite Address Attention; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Address Text")`	AddrText	Optional. The full formatted address text, from NetSuite Address Text; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Override")`	Override	Optional. NetSuite's address override flag, from NetSuite Override; left unset when empty.
Dynamic Formula	`GetCustomFieldValue(CustomFields, "NetSuite Address ExternalId")`	ExternalId	Optional. An external identifier for the address, from NetSuite Address ExternalId; left unset when empty.
Dynamic Formula	`PhoneNumber != null && PhoneNumber.Length >= 7 ? PhoneNumber : null`	AddrPhone	Optional. The address phone; set only when the source phone has at least seven characters.

Error Handling

Duplicate companies — if the email matching key is changed or stops being populated after companies exist, duplicates can be created. Resolution: keep the email mapping stable; reconcile in NetSuite.
Category not found — Category_Id resolves only to a category that already exists in NetSuite. Resolution: transfer the category first through Add/Update NetSuite Customer Category FROM iPaaS.com.
Subsidiary rejection (OneWorld) — NetSuite rejects the company when the subsidiary does not match. Resolution: confirm the subsidiary (replace the Parent Company default) or set the NetSuite Subsidiary custom field.

Testing & Validation

Test Scenarios

Create a company. Manually sync an iPaaS.com company and confirm a NetSuite company customer (IsPerson false) is created with name, email, subsidiary, and address.
Update. Re-sync and confirm the existing company is updated (matched by email when no external-ID link exists).
Custom-field attributes. Populate a NetSuite … custom field and confirm it appears in NetSuite; leave it empty and confirm it is unset.
Category. Confirm an existing category applies and a non-existent one is not created.
Address child. Confirm the address transfers with primary billing/shipping flags.

Validation Checklist

The subsidiary default (Parent Company) matches your account or is overridden per company.
The email mapping is populated and stable (the matching key).
Categories exist in NetSuite before companies reference them.
Only the NetSuite … custom fields you need are added.

Additional Notes

Round-trip with the TO direction. The NetSuite … custom fields are populated on Add/Update NetSuite Customer Company TO iPaaS.com, so NetSuite-specific attributes captured from NetSuite can be written back without loss.
Individual (person) customers are documented separately under Add/Update NetSuite Customer FROM iPaaS.com.
Known limitations affecting customers will be collected in NetSuite Known Limitations.