Salesforce Docs Portal

Oracle NetSuite Connector Objects (SuiteTalk Schema)

note: This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.

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 References FilterOnly Description
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 References 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 References 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 References 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 References 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 References 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 References 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 References 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 References 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 References 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 References 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