# NetSuite Integration Field Mapping Worksheet > Source: https://netray.co/tools/netsuite-integration-field-mapping-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Map source system fields to NetSuite fields with transforms, defaults and validation notes, and export the table to Excel for the build team. ## Category netsuite ## Erp NetSuite ## Audience - Integration developer - NetSuite consultant - Data migration lead ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Source field **Key:** src_field **Type:** text #### Source type **Key:** src_type **Type:** select **Options:** - String - Number - Date - Boolean - Code #### NetSuite record **Key:** ns_record **Type:** text #### NetSuite field ID **Key:** ns_field **Type:** text #### Transform **Key:** transform **Type:** select **Options:** - Direct - Lookup to internal ID - Date format change - Default value - Concatenate - Split - Derived by script #### Required **Key:** required **Type:** select **Options:** - Yes - No #### Rule or default **Key:** rule **Type:** text #### Tested **Key:** tested **Type:** select **Options:** - Not started - Passed - Failed **Rows:** **Src field:** CUST_CODE **Src type:** Code **Ns record:** Customer **Ns field:** externalid **Transform:** Direct **Required:** Yes **Rule:** Unique, used for upsert **Tested:** Passed **Src field:** CUST_NAME **Src type:** String **Ns record:** Customer **Ns field:** companyname **Transform:** Direct **Required:** Yes **Rule:** Trim to field length **Tested:** Passed **Src field:** PAY_TERMS **Src type:** Code **Ns record:** Customer **Ns field:** terms **Transform:** Lookup to internal ID **Required:** No **Rule:** Map NET30 to the Net 30 term internal ID **Tested:** Not started **Src field:** ORDER_DATE **Src type:** Date **Ns record:** Sales Order **Ns field:** trandate **Transform:** Date format change **Required:** Yes **Rule:** Source YYYY-MM-DD to account date format **Tested:** Failed **Src field:** CURRENCY **Src type:** Code **Ns record:** Sales Order **Ns field:** currency **Transform:** Lookup to internal ID **Required:** Yes **Rule:** ISO code to currency internal ID **Tested:** Not started **Totals:** #### Mapped fields **Key:** src_field **Agg:** count **Notes:** Map to internal IDs, not display names, wherever a field is a list or record. Internal IDs differ between sandbox and production, so keep a separate lookup table per account. Use an external ID on every record you upsert so reruns do not create duplicates. ## Content **Intro:** Integrations fail at the field level: a date in the wrong format, a status code with no internal ID, a mandatory field nobody mapped. This worksheet puts every mapping in one table so the integration developer, the consultant and the data owner agree before anything is loaded. **Sections:** #### How to use the worksheet **Body:** List every source field that has to reach NetSuite, one row each, and name the NetSuite record and field ID. Choose the transform that describes what has to happen to the value, then write the exact rule in the last column. Update the Tested column as you move through sandbox cycles. Export to Excel and share it with the source system owner for review. The count at the bottom helps you see how much remains. **Bullets:** - Map one source field per row, even if it feeds several NetSuite fields - Use external IDs for upsert and for cross-system lookups - Flag every lookup transform so someone builds the ID table - Record the default when the source value is blank #### Lookups, dates and required fields **Body:** Three things cause most mapping defects. Lookups need the NetSuite internal ID of the list value, and that ID differs per account. Dates must match the format and time zone expected by the interface you use, and the account preferences affect imports. Required fields can be mandatory in NetSuite because of a form, a role or a custom field setting, so test with the real form and role that the integration will use. #### Common mistakes **Body:** Teams map by display name and then break when someone renames a list value. They also forget subsidiaries, currencies and tax settings that sit behind a transaction, and they test only the happy path. Include edge rows in your sample data: blanks, very long text, zero quantities and closed periods. Keep the worksheet under version control, since it becomes the reference for support after go-live. **Bullets:** - Mapping to display names instead of internal or external IDs - Ignoring subsidiary, currency and tax behavior - Testing only with clean data - No owner for lookup table maintenance **Cta:** If your mappings feed an AI or reporting layer as well, Netray can help build the read-only access to the same NetSuite data using the mapping you have already agreed. **Faq:** #### Why use external IDs? **Answer:** An external ID lets you upsert, which means create the record if it does not exist and update it if it does, using the key from your source system. It also makes reruns safe and gives you a reliable key for reconciliation. #### Are internal IDs the same in sandbox and production? **Answer:** Not generally. Internal IDs for lists, custom records and some setup records are assigned per account. Keep a lookup table per environment, or look values up by name or script ID at runtime. #### Does this work for CSV import mapping? **Answer:** Yes. The structure is the same: a source column, a target field and a rule. Use it as your documented mapping, then recreate it in the import assistant or save the mapping there. #### How detailed should the rule column be? **Answer:** Detailed enough that someone else could implement it without asking you. Include formats, defaults, trimming, case rules and what to do with blank values. ## Search terms netsuite field mapping template, netsuite integration mapping excel, netsuite data mapping worksheet, netsuite import field mapping, netsuite migration mapping template, source to netsuite mapping --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json