Excel Add-In for NetSuite

Build 25.0.9434

CustomFields

Lists NetSuite custom fields with details. Supports filtering by CustomFieldType or InternalId for targeted searches.

Columns

Name Type Description
InternalId String A unique internal identifier assigned by NetSuite to track this custom field within the system.
ScriptId String The script identifier used to reference this custom field in scripts, workflows, and SuiteScript automation.
Label String The user-friendly display name of this custom field as seen on NetSuite forms and records.
CustomFieldType String The classification of this custom field, such as text, list, checkbox, or numeric, defining its data input type.
AccessLevel String The level of user permission required to view or edit this custom field, such as 'View Only,' 'Edit,' or 'Full Access.'
AvailableExternally Boolean Indicates whether this custom field can be accessed by external integrations, APIs, or web services.
CheckSpelling Boolean Determines whether spell-checking is enabled when users enter text into this custom field.
DefaultChecked Boolean Specifies whether this custom field is automatically checked by default in forms and records.
DefaultSelection_InternalId String The internal NetSuite identifier of the default record selected for this custom field.
DefaultSelection_Name String The display name of the default record preselected for this custom field.
DefaultValue String The initial default value populated in this custom field unless manually overridden by the user.
Description String A detailed explanation of the purpose and function of this custom field within the NetSuite system.
DynamicDefault String Specifies whether this custom field’s default value is dynamically generated based on contextual factors like date or user role.
DisplayType String Defines how this field appears on NetSuite forms, such as 'Normal,' 'Hidden,' or 'Inline Text.'
FieldType String The specific data type that this custom field stores, such as text, date, boolean, or currency.
Help String The help text or tooltip displayed when users hover over this custom field in NetSuite forms.
IsFormula Boolean Indicates whether this custom field is calculated dynamically using a formula instead of a manually entered value.
IsMandatory Boolean Determines whether this field is required when saving a record to ensure data completeness.
IsParent Boolean Specifies whether this custom field serves as a parent field in a hierarchy of related fields.
ItemSubType String Defines the item subtypes to which this field applies, such as 'Sale Item,' 'Purchase Item,' or 'Both.'
MaxLength Long The maximum number of characters allowed in this field when accepting text input.
MaxValue Double The highest numeric value that can be entered into this field if it stores numerical data.
MinValue Double The lowest numeric value that can be entered into this field if it stores numerical data.
Owner_Name String The name of the user, role, or department that owns and manages this custom field.
Owner_InternalId String The internal NetSuite identifier of the owner of this custom field, often linked to a specific administrator or role.
SelectRecordType_InternalId String The internal identifier of the record type that can be selected as a value for this custom field.
SelectRecordType_Name String The display name of the record type that can be selected in this custom field, such as 'Customer' or 'Vendor.'
ShowInList Boolean Indicates whether this field should be displayed in search results, saved searches, and list views.
ShowIssuesChanges Boolean Specifies whether changes to this field should be displayed in issue tracking records for auditing purposes.
StoreValue Boolean Determines whether the value entered in this field is stored persistently in the database or only used temporarily.
Subtab_Name String The name of the subtab where this field appears within NetSuite forms for better organization.
Subtab_InternalId String The internal identifier of the subtab where this custom field is displayed in NetSuite records.
RecType_Name String The name of the record type to which this custom field applies, such as 'Customer,' 'Transaction,' or 'Item.'
RecType_InternalId String The internal identifier of the record type associated with this custom field, applicable to 'OtherCustomFields.'
AppliesToAllItems Boolean Indicates whether this custom field is applicable to all item types within NetSuite.
AppliesToCase Boolean Specifies whether this custom field is available for use in customer support case records.
AppliesToCampaign Boolean Determines whether this field is enabled for marketing campaign records, helping track campaign-specific data.
AppliesToContact Boolean Indicates whether this custom field is available for contact records, such as customers, vendors, and partners.
AppliesToCustomer Boolean Specifies whether this field is available for customer records to store additional customer-related information.
AppliesToEmployee Boolean Indicates whether this field applies to employee records, enabling tracking of custom employee attributes.
AppliesToEvent Boolean Determines whether this field is used in event records for tracking details about meetings, calls, or appointments.
AppliesToGiftCerts Boolean Indicates whether this field applies to gift certificate records, allowing for custom attributes on gift cards.
AppliesToGroup Boolean Specifies whether this custom field is available for use in group records, such as customer groups or employee groups.
AppliesToInventory Boolean Indicates whether this field applies to inventory item records for tracking custom inventory attributes.
AppliesToIssue Boolean Determines whether this custom field is applicable to issue tracking records, used for managing reported problems or bugs.
AppliesToItemAssembly Boolean Specifies whether this field applies to item assembly records, used for manufacturing and assembly processes.
AppliesPerKeyword Boolean Indicates whether this field applies based on specific keywords used in searches or classifications.
AppliesToKit Boolean Determines whether this field applies to kit item records, which represent grouped product offerings.
AppliesToLots Boolean Specifies whether this custom field is relevant for lot-numbered inventory items to track batch-specific data.
AppliesToMfgProjectTask Boolean Indicates whether this custom field is used in manufacturing project task records for production tracking.
AppliesToNonInventory Boolean Determines whether this field applies to non-inventory items, such as service or expense items.
AppliesToProject Boolean Indicates whether this field is applicable to project records, enabling custom data for project tracking.
AppliesToOtherCharge Boolean Determines whether this field applies to 'Other Charge' item records, which track non-inventory costs.
AppliesToOtherName Boolean Indicates whether this custom field applies to 'Other Name' records, which can include payees or miscellaneous contacts.
AppliesToPartner Boolean Specifies whether this field is available for partner records, useful in managing reseller or affiliate relationships.
AppliesToPhoneCall Boolean Determines whether this custom field is relevant for phone call records, aiding in Customer Relationship Management (CRM) tracking.
AppliesToProjectTask Boolean Indicates whether this field is applied to project task records, enhancing task management capabilities.
AppliesToPriceList Boolean Specifies whether this custom field is displayed on price list records, used in pricing and discount management.
AppliesToSerialized Boolean Indicates whether this custom field applies to serialized inventory items, tracking individual units with unique serial numbers.
AppliesToService Boolean Determines whether this custom field is relevant for service item records, which track non-physical goods.
AppliesToSolution Boolean Specifies whether this field is used in solution records, typically related to knowledge base or support documentation.
AppliesToStatement Boolean Indicates whether this custom field is included in statement records for financial reporting purposes.
AppliesToTask Boolean Indicates whether this custom field is applicable to task records, used for tracking to-dos and assignments.
AppliesToWebSite Boolean Determines whether this field is used on website-related records, such as e-commerce product listings or customer interactions.
AppliesToVendor Boolean Specifies whether this custom field is relevant for vendor records, allowing for custom supplier attributes.
BodyAssemblyBuild Boolean Indicates whether this custom field appears in the body section of assembly build transactions.
BodyBom Boolean Determines whether this custom field is included in the body of bill of materials (BOM) records.
BodyCustomerPayment Boolean Specifies whether this field appears on the body of customer payment records, tracking additional payment details.
BodyDeposit Boolean Indicates whether this field is displayed in the body section of deposit transactions for financial tracking.
BodyExpenseReport Boolean Determines whether this custom field is visible in the body of expense reports, used for employee reimbursements.
BodyInventoryAdjustment Boolean Specifies whether this custom field appears in the body of inventory adjustment transactions, used for stock corrections.
BodyItemFulfillment Boolean Indicates whether this custom field is available in the body of item fulfillment records, tracking order shipments.
BodyItemFulfillmentOrder Boolean Determines whether this field is displayed in the body of item fulfillment order transactions, tracking logistical details.
BodyItemReceipt Boolean Specifies whether this custom field appears in the body section of item receipt records, tracking goods received.
BodyItemReceiptOrder Boolean Indicates whether this field is displayed in the body of item receipt order transactions, tracking vendor shipments.
BodyJournal Boolean Determines whether this custom field is included in the body of journal entry records, used in financial accounting.
BodyOpportunity Boolean Indicates whether this field is available in the body of opportunity records, tracking potential sales deals.
BodyPickingTicket Boolean Specifies whether this custom field is included in the body of picking tickets, used for warehouse order picking.
BodyPrintFlag Boolean Determines whether this custom field is included in the body of standard printed forms.
BodyPrintPackingSlip Boolean Indicates whether this custom field appears in the body of printed packing slips for shipping documentation.
BodyPrintStatement Boolean Specifies whether this custom field is printed on the body of customer statements for billing purposes.
BodyPurchase Boolean Determines whether this custom field is displayed in the body of purchase transactions, tracking procurement details.
BodySale Boolean Indicates whether this field is available in the body of sales transactions, tracking customer purchases.
BodyStore Boolean Specifies whether this custom field is included in the body of store transactions, often related to retail sales.
BodyTransferOrder Boolean Determines whether this custom field is visible in the body of transfer order transactions, tracking inter-location stock transfers.
BodyVendorPayment Boolean Indicates whether this field appears in the body of vendor payment records, tracking supplier payments.
ColAllItems Boolean Specifies whether this custom field appears in the item list for all item types within NetSuite.
ColBuild Boolean Determines whether this field is displayed in the item list for work order transactions, tracking assembled products.
ColExpense Boolean Indicates whether this custom field is shown in the item list for expense transactions, used for cost tracking.
ColExpenseReport Boolean Specifies whether this field appears in the item list for expense report transactions, tracking reimbursement details.
ColGroupOnInvoices Boolean Indicates whether this field is grouped on invoices, useful for consolidating similar charges or items.
ColItemFulfillment Boolean Determines whether this custom field is included in the item list for item fulfillment transactions.
ColItemFulfillmentOrder Boolean Indicates whether this custom field appears in the item list for item fulfillment order transactions, helping track order fulfillment details.
ColItemReceipt Boolean Determines whether this custom field is displayed in the item list for item receipt transactions, tracking received inventory.
ColItemReceiptOrder Boolean Specifies whether this custom field is included in the item list for item receipt order transactions, used for vendor shipment tracking.
ColJournal Boolean Indicates whether this custom field is shown in the item list for journal transactions, helping track financial entries.
ColKitItem Boolean Determines whether this custom field is displayed in the item list for kit or assembly component records, tracking grouped products.
ColOpportunity Boolean Specifies whether this field appears in the item list for opportunity transactions, tracking potential sales.
ColPackingSlip Boolean Indicates whether this custom field is printed on the item list for packing slips, used for shipment documentation.
ColPickingTicket Boolean Determines whether this field should appear on picking ticket item lists, helping warehouse staff prepare orders.
ColPrintFlag Boolean Specifies whether this custom field appears on item lists for standard printed forms, such as invoices and purchase orders.
ColPurchase Boolean Indicates whether this custom field is visible in item lists for purchase transactions, tracking procurement details.
ColReturnForm Boolean Specifies whether this field appears on return form item lists, used for tracking returned goods.
ColSale Boolean Determines whether this custom field is shown in item lists for sales transactions, tracking customer purchases.
ColStore Boolean Specifies whether this custom field applies to web store items, determining its visibility in e-commerce records.
ColStoreHidden Boolean Indicates whether this custom field should be hidden in web store transactions, keeping internal data confidential.
ColStoreWithGroups Boolean Specifies whether this custom field applies to item groups in the web store, used for categorized product listings.
ColTime Boolean Indicates whether this custom field is shown in item lists for time-based transactions, such as billable hours or timesheets.
ColTimeGroup Boolean Specifies whether this field applies to time group entries, used for grouping time-based records in NetSuite.
ColTransferOrder Boolean Indicates whether this custom field is displayed in item lists for transfer orders, tracking inter-location stock movements.
ItemsListAggregate String A list of individual items to which this custom field applies, helping define field applicability in item management.
DeptAccessListAggregate String A list of departments with access to this custom field, ensuring role-based data visibility.
RoleAccessListAggregate String A list of roles permitted to access this custom field, ensuring data security and governance.
SubAccessListAggregate String A list of subsidiaries granted access to this custom field, used for multi-entity businesses.
TranslationsListAggregate String A collection of translations for the custom field labels and help text, supporting multilingual NetSuite implementations.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434