Oracle NetSuite Connector Objects (SuiteTalk Schema)
This Data Cloud connector is a beta service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot or beta service is at the Customer's sole discretion.
| 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. |
| 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 |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. | |
| 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. |