Understanding When to Use itemkey, itemname, and sitemname Fields in NetSuite Item Fulfillment Records

[anekporwal]

When creating an Item Fulfillment record in NetSuite, there are multiple fields available to reference items:

1. Items : Item (Field ID: itemkey )
2. Items : Item (Field ID: itemname )
3. Items : Item (Field ID: sitemname )

Could you please clarify the differences between these fields and provide guidance on when each should be used?

[nuriensing]

Hi,

When creating an Item Fulfillment record, you only need to provide the internal ID of the item in the item field on the Items sublist.

Fields such as itemname and sitemname on the Item Fulfillment record object are read-only or derived fields that NetSuite populates automatically for display purposes. These should not be set manually during record creation or update.

Regarding the fields you asked about:

The field labeled itemkey on the item line usually refers to a unique identifier used within the context of an integration or transformation, such as in Celigo. It is not a standard NetSuite field and may be used internally to map or group line items during processing.

The itemname field represents the name of the item, typically drawn from the item record in NetSuite. This is a display-only field and reflects the configured item name associated with the internal ID.

The sitemname field is not a standard NetSuite field and may be a custom field specific to your environment. If it exists, its purpose may vary, such as representing a shorthand or secondary name for the item, depending on how your NetSuite account has been customized.

Please note that the visibility or accessibility of these fields can vary based on your role permissions, form customizations, and account configuration. If you are unable to see or modify certain fields, it may be due to those factors.

[tylerlamparter]

Also, we often use this field that isn't available in the dropdown: item[*].item.internalid. This lets you map to the item's internal ID, which would be the typical way most other records you work with operate.