Oracle NetSuite Connector Objects (SuiteTalk Schema)

Objects Supported

Name	Description
BudgetExchangeRate	Retrieves the budget expense rate from NetSuite.
CustomFields	Returns information about the custom fields in NetSuite. CustomFields may be retrieved by CustomFieldType, or by a combination of CustomFieldType and InternalId. If no CustomFieldType is specified, all custom fields will be returned.
CustomRecords	Returns information about the custom records in NetSuite.
CustomSegments	Returns information about the custom segments in NetSuite.
CustomTransactions	Returns information about the custom fields in NetSuite. CustomFields may be retrieved by CustomFieldType, or by a combination of CustomFieldType and InternalId. If no CustomFieldType is specified, all custom fields will be returned.
EnumerationValues	Retrieves enumeration values for a given table. Will only return values if the TableName is specified. Only available for native tables within NetSuite and not Custom tables.
MyRoles	Returns the roles available for the authenticated user. This may include information for additional accounts the user is authorized to access.
PostingTransactionSummary	Retrieves a posting transaction summary from NetSuite. This is the reporting mechanism available from NetSuite. All record reference columns may be used in filter using either either the = or IN operator. Other operator types are not available. For NetSuite OneWorld customers, ConvertToSubsidiary may also be specified as the subsidiary all response values should be converted to.
SavedSearches	Returns the saved searches in NetSuite. A SearchType must be specified in order to retrieve saved searches.
SavedSearchRawXML	Returns the raw XML from a saved search.
Transactions	A view for transactions on NetSuite. The transactions view is designed to provide a simple listing of commonly available values for transactions. Many fields may be null depending on the specific transaction type retrieved. It is recommended to use individual transaction tables such as JournalEntry, PurchaseOrder, or Invoice for more granular details.

BudgetExchangeRate

Name	Type	ReadOnly	FilterOnly
Period_InternalId	String	False	No
FromSubsidiary_InternalId	String	False	No
ToSubsidiary_InternalId	String	False	No
CurrentRate	Double	False	No
AverageRate	Double	False	No
HistoricalRate	Double	False	No

Return to Top

CustomFields

Name	Type	ReadOnly	FilterOnly	Description
InternalId [KEY]	String	False	No	The InternalId of the custom field.
ScriptId	String	False	No	The ScriptId of the custom field.
Label	String	False	No	The name of the custom field.
CustomFieldType	String	False	No	The type of custom field being requested.
AccessLevel	String	False	No	The level of access granted to interact with this custom field.
AvailableExternally	Boolean	False	No	A boolean indicating if this custom field is available externally.
CheckSpelling	Boolean	False	No	A boolean indicating if spell check is enabled for this custom field.
DefaultChecked	Boolean	False	No	A boolean indicating if this field is checked by default.
DefaultSelection_InternalId	String	False	No	The internalid of the default record for this custom field.
DefaultSelection_Name	String	False	No	The name of the default record for this custom field.
DefaultValue	String	False	No	The default value for this custom field.
Description	String	False	No	A description for the custom field.
DynamicDefault	String	False	No	The dynamic default value determined when an entity is created.
DisplayType	String	False	No	The way the column is displayed to a user on NetSuite.
FieldType	String	False	No	A boolean describing what type of data is stored in the custom field.
Help	String	False	No	Help information that comes up when you mouse over the custom field in NetSuite.
IsFormula	Boolean	False	No	A boolean indicating if the custom field is a formula.
IsMandatory	Boolean	False	No	A boolean indicating if the custom field is mandatory.
IsParent	Boolean	False	No	A boolean indicating if the custom field is a parent.
ItemSubType	String	False	No	What type of items this custom field is available for (purchase, sale, or both).
MaxLength	Long	False	No	The maximum length for the custom field if it is an integer or long.
MaxValue	Double	False	No	The maximum value for the custom field if it is a double.
MinValue	Double	False	No	The minimum value for the custom field if it is a double.
Owner_Name	String	False	No	The name of the owner of the custom field.
Owner_InternalId	String	False	No	The internalid of the owner of the custom field.
SelectRecordType_InternalId	String	False	No	The internalId of the type of record that may be selected for this custom field.
SelectRecordType_Name	String	False	No	The name of the type of record that may be selected for this custom field.
ShowInList	Boolean	False	No	A boolean indicating if this field should be shown in a listing.
ShowIssuesChanges	Boolean	False	No	A boolean indicating if NetSuite shows changes to this field on the Issue record.
StoreValue	Boolean	False	No	A boolean indicating if this field stores a value.
Subtab_Name	String	False	No	The name of the subtab this custom field may be found on.
Subtab_InternalId	String	False	No	The internal id of the subtab this custom field may be found on.
RecType_Name	String	False	No	The name of the record type this custom field is applicable for. Only valid for OtherCustomFields.
RecType_InternalId	String	False	No	The internalid of the record type this custom field is applicable for. Only valid for OtherCustomFields.
AppliesToAllItems	Boolean	False	No	A boolean indicating if this custom field applies to all items.
AppliesToCase	Boolean	False	No	A boolean indicating if this custom field applies to the support case record.
AppliesToCampaign	Boolean	False	No	A boolean indicating if this custom field applies to the campaign record.
AppliesToContact	Boolean	False	No	A boolean indicating if this custom field applies to the contact record.
AppliesToCustomer	Boolean	False	No	A boolean indicating if this custom field applies to the customer record.
AppliesToEmployee	Boolean	False	No	A boolean indicating if this custom field applies to the employee record.
AppliesToEvent	Boolean	False	No	A boolean indicating if this custom field applies to the event record.
AppliesToGiftCerts	Boolean	False	No	A boolean indicating if this custom field applies to gift certificates.
AppliesToGroup	Boolean	False	No	A boolean indicating if this custom field applies to groups.
AppliesToInventory	Boolean	False	No	A boolean indicating if this custom field applies to the inventory items.
AppliesToIssue	Boolean	False	No	A boolean indicating if this custom field applies to the issue record.
AppliesToItemAssembly	Boolean	False	No	A boolean indicating if this custom field applies to the item assemblies.
AppliesPerKeyword	Boolean	False	No	A boolean indicating if this custom field applies per keyword.
AppliesToKit	Boolean	False	No	A boolean indicating if this custom field applies to kit items.
AppliesToLots	Boolean	False	No	A boolean indicating if this custom field applies to all items lots.
AppliesToMfgProjectTask	Boolean	False	No	A boolean indicating if this custom field applies to manufacturing operation tasks.
AppliesToNonInventory	Boolean	False	No	A boolean indicating if this custom field applies to non inventory items.
AppliesToProject	Boolean	False	No	A boolean indicating if this custom field applies to the job record.
AppliesToOtherCharge	Boolean	False	No	A boolean indicating if this custom field applies to other charges.
AppliesToOtherName	Boolean	False	No	A boolean indicating if this custom field applies to other names records.
AppliesToPartner	Boolean	False	No	A boolean indicating if this custom field applies to the partner record.
AppliesToPhoneCall	Boolean	False	No	A boolean indicating if this custom field applies to the phone call record.
AppliesToProjectTask	Boolean	False	No	A boolean indicating if this custom field applies to the project task record.
AppliesToPriceList	Boolean	False	No	A boolean indicating if this custom field applies to the price list.
AppliesToSerialized	Boolean	False	No	A boolean indicating if this custom field applies to all serialized items
AppliesToService	Boolean	False	No	A boolean indicating if this custom field applies to service items.
AppliesToSolution	Boolean	False	No	A boolean indicating if this custom field applies to the solution record.
AppliesToStatement	Boolean	False	No	A boolean indicating if this custom field applies to the statement record.
AppliesToTask	Boolean	False	No	A boolean indicating if this custom field applies to the task record.
AppliesToWebSite	Boolean	False	No	A boolean indicating if this custom field applies to the website record.
AppliesToVendor	Boolean	False	No	A boolean indicating if this custom field applies to the vendor record.
BodyAssemblyBuild	Boolean	False	No	A boolean indicating if this custom field appears on the body of assembly build transactions.
BodyBom	Boolean	False	No	A boolean indicating if this custom field should be printed on on the body of a BOM.
BodyCustomerPayment	Boolean	False	No	A boolean indicating if this custom field appears on the body of customer payment transactions.
BodyDeposit	Boolean	False	No	A boolean indicating if this custom field appears on the body of deposit transactions.
BodyExpenseReport	Boolean	False	No	A boolean indicating if this custom field appears on the body of expense report transactions.
BodyInventoryAdjustment	Boolean	False	No	A boolean indicating if this custom field appears on the body of inventory adjustment transactions.
BodyItemFulfillment	Boolean	False	No	A boolean indicating if this custom field appears on the body of item fulfillment transactions.
BodyItemFulfillmentOrder	Boolean	False	No	A boolean indicating if this custom field appears on the body of item fulfillment order transactions.
BodyItemReceipt	Boolean	False	No	A boolean indicating if this custom field appears on the body of item receipt transactions.
BodyItemReceiptOrder	Boolean	False	No	A boolean indicating if this custom field appears on the body of item receipt order transactions.
BodyJournal	Boolean	False	No	A boolean indicating if this custom field appears on the body of journal transactions.
BodyOpportunity	Boolean	False	No	A boolean indicating if this custom field appears on the body of opportunity transactions.
BodyPickingTicket	Boolean	False	No	A boolean indicating if this custom field should be printed on the body of picking tickets.
BodyPrintFlag	Boolean	False	No	A boolean indicating if this custom field should be printed on the body of standard forms.
BodyPrintPackingSlip	Boolean	False	No	A boolean indicating if this custom field should be printed on the body of packing slips.
BodyPrintStatement	Boolean	False	No	A boolean indicating if this custom field should be printed on the body of statements.
BodyPurchase	Boolean	False	No	A boolean indicating if this custom field appears on the body of purchase transactions.
BodySale	Boolean	False	No	A boolean indicating if this custom field appears on the body of sale transactions.
BodyStore	Boolean	False	No	A boolean indicating if this custom field appears on the body of store transactions.
BodyTransferOrder	Boolean	False	No	A boolean indicating if this custom field appears on the body of transfer order transactions.
BodyVendorPayment	Boolean	False	No	A boolean indicating if this custom field appears on the body of vendor payment transactions.
ColAllItems	Boolean	False	No	A boolean indicating if this custom field appears in the item list for all items.
ColBuild	Boolean	False	No	A boolean indicating if this custom field appears in the item list for work order transactions.
ColExpense	Boolean	False	No	A boolean indicating if this custom field appears in the item list for expense transactions.
ColExpenseReport	Boolean	False	No	A boolean indicating if this custom field appears in the item list for expense report transactions.
ColGroupOnInvoices	Boolean	False	No	A boolean indicating if this custom field is grouped on invoices.
ColItemFulfillment	Boolean	False	No	A boolean indicating if this custom field appears in the item list for item fulfillment transactions.
ColItemFulfillmentOrder	Boolean	False	No	A boolean indicating if this custom field appears in the item list for item fulfillment order transactions.
ColItemReceipt	Boolean	False	No	A boolean indicating if this custom field appears in the item list for item receipt transactions.
ColItemReceiptOrder	Boolean	False	No	A boolean indicating if this custom field appears in the item list for item receipt order transactions.
ColJournal	Boolean	False	No	A boolean indicating if this custom field appears in the item list for journal transactions.
ColKitItem	Boolean	False	No	A boolean indicating if this custom field appears in the item list for kit / assembly components.
ColOpportunity	Boolean	False	No	A boolean indicating if this custom field appears in the item list for opportunity transactions.
ColPackingSlip	Boolean	False	No	A boolean indicating if this custom field should be printed on the item list for packing slips.
ColPickingTicket	Boolean	False	No	A boolean indicating if this custom field should be printed on the item list for picking tickets.
ColPrintFlag	Boolean	False	No	A boolean indicating if this custom field should be printed on the item list for standard forms.
ColPurchase	Boolean	False	No	A boolean indicating if this custom field appears in the item list for purchase transactions.
ColReturnForm	Boolean	False	No	A boolean indicating if this custom field should be printed on the item list for return forms.
ColSale	Boolean	False	No	A boolean indicating if this custom field appears in the item list for sale transactions.
ColStore	Boolean	False	No	A boolean indicating if this custom field applies to your web store items .
ColStoreHidden	Boolean	False	No	A boolean indicating if this custom field should be hidden on your web store transactions.
ColStoreWithGroups	Boolean	False	No	A boolean indicating if this custom field should apply to item groups.
ColTime	Boolean	False	No	A boolean indicating if this custom field appears in the item list for time transactions.
ColTimeGroup	Boolean	False	No	A boolean indicating if this custom field appears apply to time groups.
ColTransferOrder	Boolean	False	No	A boolean indicating if this custom field appears in the item list for transfer order transactions.
ItemsListAggregate	String	False	No	An aggregate of individual items this custom field applies to.
DeptAccessListAggregate	String	False	No	An aggregate of the departments that have access to the custom field.
RoleAccessListAggregate	String	False	No	An aggregate of roles that have access this custom field.
SubAccessListAggregate	String	False	No	An aggregate of the subsidiaries that have access to this custom field.
TranslationsListAggregate	String	False	No	An aggregage of translations for the custom field label and help.

Return to Top

CustomRecords

Name	Type	ReadOnly	FilterOnly	Description
InternalId [KEY]	String	False	No	The InternalId of the custom record.
ScriptId	String	False	No	The ScriptId of the custom record.
Name	String	False	No	The name of the custom record.
AccessType	String	False	No	The access type for the custom record.
AllowAttachments	Boolean	False	No	A boolean indicating if the custom record allows attachments.
AllowNumberingOverride	Boolean	False	No	A boolean for the allow override property fo the custom record.
AllowQuickSearch	Boolean	False	No	A boolean indiating if quick searches are enabled for the custom record.
Description	String	False	No	A description of the custom record.
Disclaimer	String	False	No	A disclaimer for the custom record.
EnableInlineEditing	Boolean	False	No	A boolean indicating if inline editing is enabled.
EnableMailMerge	Boolean	False	No	A boolean indicating if mail merge is enabled.
EnableNameTranslation	Boolean	False	No	A boolean indicating if name translations are enabled.
EnableNumbering	Boolean	False	No	A boolean indicating if numbering is enabled.
IncludeName	Boolean	False	No	A boolean idicating if the name field is included.
IsAvailableOffline	Boolean	False	No	A boolean indicating if the custom record is available offline.
IsInactive	Boolean	False	No	A boolean indicating if the record is inactive.
IsNumberingUpdateable	Boolean	False	No	A boolean indicating if the numbering number is updatable.
IsOrdered	Boolean	False	No	A boolean indicating if records are ordered.
NumberingCurrentNumber	Long	False	No	The current numbering number.
NumberingInit	Long	False	No	The initial numbering number.
NumberingMinDigits	Long	False	No	A minimum number of digits for the numbering number.
NumberingPrefix	String	False	No	A prefix for the numbering number.
NumberingSuffix	String	False	No	A suffix added to the numbering number.
Owner_internalid	String	False	No	The internalid of the owner of the custom record.
Owner_name	String	False	No	The name of the owner of the custom record.
ShowCreationDate	Boolean	False	No	A boolean indicating if the custom record should show the creation date.
ShowCreationDateOnList	Boolean	False	No	A boolean indicating if the custom record should show the creation date when listed.
ShowId	Boolean	False	No	A boolean indicating if the custom record should show the id.
ShowLastModified	Boolean	False	No	A boolean indicating if the custom record should show the last modified date.
ShowLastModifiedOnList	Boolean	False	No	A boolean indicating if the custom record should show the creation date when listed.
ShowNotes	Boolean	False	No	A boolean indicating if the custom record should show notes.
ShowOwner	Boolean	False	No	A boolean indicating if the custom record should show the owner.
ShowOwnerAllowChange	Boolean	False	No	A boolean indicating if the custom record should show if the owner allows changes.
ChildrenListAggregate	String	False	No	An aggregate of the children collection for the custom record.
FormsListAggregate	String	False	No	An aggregate of the forms collection for the custom record.
LinksListAggregate	String	False	No	An aggregate of the links collection for the custom record.
ManagersListAggregate	String	False	No	An aggregate of the managers collection for the custom record.
OnlineFormsListAggregate	String	False	No	An aggregate of the online forms collection for the custom record.
ParentsListAggregate	String	False	No	An aggregate of the parents collection for the custom record.
PermissionsListAggregate	String	False	No	An aggregate of the permissions collection for the custom record.
SublistsListAggregate	String	False	No	An aggregate of the sublists collection for the custom record.
TabsListAggregate	String	False	No	An aggregate of the tabs collection for the custom record.
TranslationsListAggregate	String	False	No	An aggregate of the translations collection for the custom record.

Return to Top

CustomSegments

Name	Type	ReadOnly	FilterOnly	Description
InternalId [KEY]	String	False	No	The InternalId of the custom segment.
ScriptId	String	False	No	The ScriptId of the custom segment.
Label	String	False	No	The name of the custom segment.
RecordType_InternalId	String	False	No	The internalid of the record type for the custom segment.
RecordType_Name	String	False	No	The name of the record type for the custom segment.
RecordScriptId	String	False	No	ScriptId for the record type of the custom segment.
FieldType	String	False	No	The type of field for this custom segment.
IsInactive	Boolean	False	No	Boolean indicating if the custom segment is inactive.
ShowInList	Boolean	False	No	Boolean indicating if the custom segment is shown in list.
HasGLImpact	Boolean	False	No	Boolean indicating if the custom segment has a GL impact.
IsMandatory	Boolean	False	No	Boolean indicating if the custom segment is mandatory.

Return to Top

CustomTransactions

Name	Type	ReadOnly	FilterOnly	Description
InternalId [KEY]	String	False	No	The InternalId of the custom transaction.
ScriptId	String	False	No	The ScriptId of the custom transaction.
Name	String	False	No	The name of the custom transaction.

Return to Top

EnumerationValues

Name	Type	ReadOnly	FilterOnly	Description
ColumnName	String	False	No	The name of the column.
TableName	String	False	No	The name of the table to retrieve enumeration value information from.
Values	String	False	No	The available values for the enumeration column.

Return to Top

MyRoles

Name	Type	ReadOnly	FilterOnly	Description
AccountId [KEY]	String	False	No	The account the role is associated with.
RoleId [KEY]	String	False	No	The InternalId of the role.
AccountName	String	False	No	The name of the account.
RoleName	String	False	No	The name of the role.

Return to Top

PostingTransactionSummary

Name	Type	ReadOnly	FilterOnly	Description
Period_InternalId	String	False	No
Account_InternalId	String	False	No
ParentItem_InternalId	String	False	No
Item_InternalId	String	False	No
Entity_InternalId	String	False	No
Department_InternalId	String	False	No
Class_InternalId	String	False	No
Location_InternalId	String	False	No
Subsidiary_InternalId	String	False	No
Book_InternalId	String	False	No
OriginalAmount	Decimal	False	No	The original amount as returned by NetSuite in the currency of the subsidiary returned.
OriginalCurrency	String	False	No	The name of the original currency. Will only have a value if ConvertToSubsidiary is specified.
ConvertedAmount	Decimal	False	No	The amount converted to the currency of the subsidiary specified by ConvertToSubsidiary.
ConvertedCurrency	String	False	No	The name of the currency that has been converted to. Will only have a value if ConvertToSubsidiary is specified.
ConvertToSubsidiary	String	False	No	The subsidiary to convert to.
ConvertToRateType	String	False	No	The type of rate conversion to use. Defaults to Current if not specified. See the ConsolidatedExchangeRate table for the actual rates that will be used to make the conversion.

Return to Top

SavedSearches

Name	Type	ReadOnly	FilterOnly	Description
InternalId [KEY]	String	False	No	The InternalId of the saved search.
Name	String	False	No	The name of the saved search.
SearchType	String	False	No	The type of search. This value must be specified when retrieving data.

Return to Top

SavedSearchRawXML

Name	Type	ReadOnly	FilterOnly	Description
SavedSearchId	String	False	No	The InternalId of the saved search.
SearchType	String	False	No	The type of search being used.
ResponseXML	String	False	No	The XML response of the saved search.

Return to Top

Transactions

Name	Type	ReadOnly	FilterOnly	Description
InternalId [KEY]	String	False	No	The internalid of the transaction.
Type	String	False	No	The transaction type.
Account_InternalId	String	False	No	Internal id of the account.
Account_Name	String	False	No	Name of the account.
Amount	Decimal	False	No	Amount on the transaction.
BillingAddress	String	False	No	The billing address.
BillingAccount_InternalId	String	False	No	The billing account internal id.
BillingAccount_Name	String	False	No	The billing account name.
CloseDate	Datetime	False	No	The date closed.
CreatedDate	Datetime	False	No	The date created.
CreatedFrom_InternalId	String	False	No	Created from id.
Currency_InternalId	String	False	No	The currency id.
Currency_Name	String	False	No	The currency name.
CustomForm_InternalId	String	False	No	The custom form id.
CustomForm_Name	String	False	No	The custom form name.
DueDate	Datetime	False	No	The due date.
Email	String	False	No	The email address.
EndDate	Datetime	False	No	The end date.
Entity_InternalId	String	False	No	The entity id.
Entity_Name	String	False	No	The entity name.
Entity_Type	String	False	No	The entity type.
ExchangeRate	Decimal	False	No	The exchange rate.
ExpectedCloseDate	Datetime	False	No	The expected close date.
ExternalId	String	False	No	The transaction external id.
Fob	String	False	No	The email address.
IntercoTransaction_InternalId	String	False	No	The intercompany transaction id.
Job_InternalId	Job	False	No	The job id.
Job_Name	Job	False	No	The job name.
LastModifiedDate	Datetime	False	No	The last modified date.
LeadSource_InternalId	String	False	No	The lead source id.
LeadSource_Name	String	False	No	The lead source name.
LeadSource_Type	String	False	No	The lead source type.
Location_InternalId	String	False	No	The location id.
Location_Name	String	False	No	The location name.
Memo	String	False	No	The memo.
Message	String	False	No	The message.
Partner_InternalId	String	False	No	The partner id.
Partner_Name	String	False	No	The partner name.
PnRefNum	String	False	No	The P/N Ref.
Probability	Double	False	No	The probability of a deal.
ProjectedAmount	Decimal	False	No	The projected amount.
PromoCode_InternalId	String	False	No	The promo code id.
PromoCode_Name	String	False	No	The promo code name.
SalesEffectiveDate	Datetime	False	No	The sales effective date.
SalesRep_InternalId	String	False	No	The sales rep id.
SalesRep_Name	String	False	No	The sales rep name.
Source	String	False	No	The source.
StartDate	Datetime	False	No	The start date.
Status	String	False	No	The status.
Terms_InternalId	String	False	No	The terms id.
Terms_Name	String	False	No	The terms name.
Title	String	False	No	The title.
Total	Decimal	False	No	Total on the transaction.
TranDate	Datetime	False	No	The transaction date.
TranId	String	False	No	The document number/id.
TransactionNumber	String	False	No	The transaction number.
UserTotal	Decimal	False	No	The UserTotal on the transaction.
SavedSearchId	String	False	Yes	Specifies the InternalId of the saved search. This is an alternative to supplying the criteria directly in the query. The search can instead be saved on NetSuite's end to perform more complicated operations than those available in the Web API.

Return to Top

Login

Products

Experiences

Agentforce

CRM Products

Industries

Small Business

Data

Salesforce Platform

Customer Success

Partner Apps & Experts

Discover the #1 AI CRM

Discover the #1 AI CRM

Automotive

Communications

Engineering, Construction & Real Estate

Consumer Goods

Education

Energy & Utilities

Financial Services

Healthcare & Life Sciences

Manufacturing

Media

Nonprofit

Professional Services

Public Sector

Retail

Technology

Travel, Transportation & Hospitality

Explore Salesforce for industries.

Explore Salesforce for industries.

Customer Stories

Salesforce on Salesforce Stories

Trailblazer Stories

Explore success stories.

Explore success stories.

Learning on Trailhead

Events

Resources

Blogs

Become a Trailblazer.

Become a Trailblazer.

Help & Documentation

Communities

Services & Plans

Account Management

Questions? We can help.

Questions? We can help.

About Salesforce

Our Values

Our Impact

Careers

Newsroom

Legal

More Salesforce Brands

Hear our story.

Hear our story.

Events

Original Series

My List

Explore Salesforce+.

Explore Salesforce+.

Login

Products

Experiences

Contact Us

By phone

Online

Products

Experiences

Developer Centers

Salesforce Platform

Industries

Resources

Developer Tools

Build Skills

Extend Salesforce

Stay Up To Date

Community

Oracle NetSuite Connector Objects (SuiteTalk Schema)