Transform to Estimate is a powerful feature that simplifies the process of converting customer information into estimates within the NetSuite platform. By seamlessly integrating customer data with estimating functions, this action enhances your ability to generate accurate and timely estimates for your clients. It not only saves you time but also improves the accuracy of your financial projections, making it an essential tool for businesses of all sizes. With Transform to Estimate, you can streamline your workflow, enhance customer interactions, and make informed decisions that drive your business forward.
Configuration
NetSuite - Connection (ver. 1.0.0)
URL
URL of your NetSuite instance.
Account ID
Account ID for NetSuite API.
Consumer Key
Consumer key for NetSuite API.
Consumer Secret
Consumer secret for NetSuite API.
Token ID
Token ID for NetSuite API.
Token Secret
Token secret for NetSuite API.
NetSuite - Configuration (ver. 1.0.0)
Error behavior
The available values are:
-
Fail and return response: The connector fails at the specified line but generates output with error details.
-
Fail without response: The connector fails - the error will be displayed only in the log.
-
Do not fail and return response: The connector does not fail but generates output records that may be marked with an error and detailed information.
Input & Output Schema
Input
NetSuite - Transform Customer To Estimate Request (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the customer in NetSuite |
| Estimate | NetSuite - Estimate v1.5.0 |
No | Represents the version of the estimate integration for the customer |
NetSuite - Estimate (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| DefaultILShipMethKey | Integer | Yes | Represents the default shipping method key for the customer |
| StartDate | DateTime | Yes | Indicates the start date for the customer's record |
| Oppcreatedfromtitle | String | Yes | Contains the title of the opportunity from which the customer was created |
| HandlingCost | Double | Yes | Represents the cost associated with handling the order |
| Subtotal | Double | Yes | Indicates the subtotal amount before taxes and discounts |
| BillAddr1 | String | Yes | Contains the first line of the billing address |
| TotalCostEstimate | Double | Yes | Represents the estimated total cost for the order |
| BillAddr2 | String | Yes | Contains the second line of the billing address |
| BillAddr3 | String | Yes | Contains the third line of the billing address |
| ShippingCost | Double | Yes | Represents the cost associated with shipping the order |
| FxNetAltSalesTotal | Double | Yes | Indicates the alternative sales total in foreign currency |
| IsMultiShipTo | Bool | Yes | Indicates if the order can be shipped to multiple addresses |
| CreatedDate | DateTime | Yes | Represents the date when the customer record was created |
| VisibleToCustomer | Bool | Yes | Indicates if the record is visible to the customer |
| String | Yes | Contains the email address of the customer | |
| CanHaveStackable | Bool | Yes | Indicates if the customer can have stackable items |
| WebSite | String | Yes | Contains the website URL associated with the customer |
| PrevDate | DateTime | Yes | Represents the previous date related to the customer record |
| SalesEffectiveDate | DateTime | Yes | Indicates the date when sales become effective for the customer |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Represents the custom form used for the customer record |
| ForecastType | NetSuite - Forecast Type v1.2.0 |
Yes | Indicates the type of forecast associated with the customer |
| PrevRep | Integer | Yes | Represents the previous representative assigned to the customer |
| ShipAddress | String | Yes | Contains the shipping address for the customer |
| ExternalID | String | Yes | Represents an external identifier for the customer |
| Source | NetSuite - Source v1.4.0 |
Yes | Indicates the source from which the customer was acquired |
| ToBePrinted | Bool | Yes | Indicates if the document is to be printed |
| BillPhone | String | Yes | Contains the billing phone number for the customer |
| BillAttention | String | Yes | Indicates the attention line for the billing address |
| ToBeEmailed | Bool | Yes | Indicates if the document is to be emailed |
| DiscountDate | DateTime | Yes | Represents the date when discounts are applicable |
| TrackingNumbers | String | Yes | Contains tracking numbers for the shipment |
| Fob | String | Yes | Indicates the freight on board terms for shipping |
| ExchangeRate | Double | Yes | Represents the exchange rate used for currency conversion |
| Originator | String | Yes | Indicates the originator of the customer record |
| Title | String | Yes | Contains the title of the customer contact |
| BillZip | String | Yes | Contains the zip code for the billing address |
| ToBeFaxed | Bool | Yes | Indicates if the document is to be faxed |
| ExpectedCloseDate | DateTime | Yes | Represents the expected close date for the opportunity |
| PromoCodePluginImpl | String | Yes | Contains the implementation details for the promo code |
| ShipDate | DateTime | Yes | Indicates the date when the order is shipped |
| ShippingAddress_text | String | Yes | Contains the text representation of the shipping address |
| PreviousOpportunity | String | Yes | Indicates the previous opportunity associated with the customer |
| Message | String | Yes | Contains any messages related to the customer |
| BillAddressee | String | Yes | Indicates the addressee for the billing address |
| DueDate | DateTime | Yes | Represents the due date for payment |
| BillCity | String | Yes | Contains the city for the billing address |
| TranDate | DateTime | Yes | Represents the transaction date for the customer |
| Memo | String | Yes | Contains any additional notes or memos related to the customer |
| BillCountry | NetSuite - Bill Country v1.4.0 |
Yes | Indicates the country for the billing address |
| ID | String | Yes | Represents the unique identifier for the customer |
| Probability | Double | Yes | Indicates the probability of closing the opportunity |
| BillAddress | String | Yes | Contains the complete billing address |
| NetAltSalesTotal | Double | Yes | Represents the alternative sales total in the native currency |
| EstGrossProfit | Double | Yes | Indicates the estimated gross profit for the order |
| EndDate | DateTime | Yes | Represents the end date for the customer's record |
| Status | NetSuite - Status v1.4.0 |
Yes | Indicates the current status of the customer record |
| ShipIsResidential | Bool | Yes | Indicates if the shipping address is residential |
| EstGrossProfitPercent | Double | Yes | Represents the estimated gross profit percentage |
| ExcludeCommission | Bool | Yes | Indicates if the commission should be excluded for the customer |
| ShipOverride | Bool | Yes | Indicates if the shipping method is overridden |
| DiscountAmount | Double | Yes | Represents the total discount amount applied |
| DiscountRate | Double | Yes | Indicates the discount rate applied to the order |
| BillState | String | Yes | Contains the state for the billing address |
| AltHandlingCost | Double | Yes | Represents the alternative handling cost for the order |
| Oppcreatedfrom | String | Yes | Indicates the opportunity from which the customer was created |
| BillOverride | String | Yes | Contains any overrides for the billing address |
| BillingAddress_text | String | Yes | Contains the text representation of the billing address |
| DiscountTotal | Double | Yes | Represents the total discount applied to the order |
| FxAltSalesTotal | Double | Yes | Indicates the alternative sales total in foreign currency |
| ShippingCostOverridden | Bool | Yes | Indicates if the shipping cost has been overridden |
| MuccPromoCodeInstance | String | Yes | Contains the instance details for the promotional code |
| OtherRefNum | String | Yes | Represents any other reference number associated with the customer |
| ThirdPartyAcct | String | Yes | Indicates the third-party account associated with the customer |
| Total | Double | Yes | Represents the total amount for the order |
| TranID | String | Yes | Contains the transaction ID for the customer |
| LastModifiedDate | DateTime | Yes | Represents the date when the customer record was last modified |
| AltSalesTotal | Double | Yes | Indicates the alternative sales total |
| AltShippingCost | Double | Yes | Represents the alternative shipping cost |
| RefName | String | Yes | Contains the reference name for the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents links associated with the customer record |
| Job | NetSuite - Job One Of v1.4.0 |
Yes | Indicates the job associated with the customer |
| CreatedFrom | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the resource from which the customer was created |
| MessageSel | NetSuite - ID v1.2.0 |
Yes | Indicates the selected message for the customer |
| ShipAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | Contains the list of shipping addresses for the customer |
| Department | NetSuite - ID v1.2.0 |
Yes | Indicates the department associated with the customer |
| Currency | NetSuite - ID v1.2.0 |
Yes | Represents the currency used for the customer transactions |
| Entity | NetSuite - Entity One Of v1.7.0 |
Yes | Indicates the entity associated with the customer |
| CouponCode | NetSuite - ID v1.2.0 |
Yes | Represents the coupon code applicable to the customer |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Indicates the subsidiary associated with the customer |
| EntityStatus | NetSuite - ID v1.2.0 |
Yes | Represents the status of the entity associated with the customer |
| Opportunity | NetSuite - ID v1.2.0 |
Yes | Indicates the opportunity associated with the customer |
| ShippingAddress | NetSuite - Estimate Shipping Address v1.4.0 |
Yes | Represents the shipping address for the estimate |
| ShipGroup | NetSuite - Estimate Ship Group Collection v1.4.0 |
Yes | Contains the shipping group details for the estimate |
| Item | NetSuite - Estimate Item Collection v1.5.0 |
Yes | Represents the items included in the estimate |
| BillingAddress | NetSuite - Estimate Billing Address v1.4.0 |
Yes | Contains the billing address for the estimate |
| LeadSource | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the source of the lead for the customer |
| BillAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | Contains the list of billing addresses for the customer |
| PromoCode | NetSuite - ID v1.2.0 |
Yes | Represents the promotional code applicable to the customer |
| Terms | NetSuite - ID v1.2.0 |
Yes | Indicates the payment terms for the customer |
| ShipMethod | NetSuite - ID v1.2.0 |
Yes | Represents the shipping method used for the order |
| AccountingBookDetail | NetSuite - Estimate Accounting Book Detail Collection v1.5.0 |
Yes | Contains accounting book details for the estimate |
| SalesRep | NetSuite - Sales Rep One Of v1.5.0 |
Yes | Indicates the sales representative assigned to the customer |
| BillingSchedule | NetSuite - ID v1.2.0 |
Yes | Represents the billing schedule for the customer |
| Location | NetSuite - ID v1.2.0 |
Yes | Indicates the location associated with the customer |
| Class | NetSuite - ID v1.2.0 |
Yes | Represents the class associated with the customer |
| Partner | NetSuite - ID v1.2.0 |
Yes | Indicates the partner associated with the customer |
| DiscountItem | NetSuite - ID v1.2.0 |
Yes | Represents the discount item applicable to the customer |
| CustomFields | JSON | Yes | Contains custom fields associated with the customer record |
NetSuite - Job One Of (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Customer | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the customer associated with the credit memo |
| Partner | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the partner related to the credit memo |
| Vendor | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the vendor linked to the credit memo |
| NsResource | NetSuite - Ns Resource v1.6.0 |
Yes | Identifier for the resource used in the credit memo process |
| Employee | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the employee who created the credit memo |
| Contact | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the contact person related to the credit memo |
NetSuite - Sales Rep One Of (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Customer | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the customer associated with the credit memo |
| Partner | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the partner related to the credit memo |
| Vendor | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the vendor linked to the credit memo |
| NsResource | NetSuite - Ns Resource v1.6.0 |
Yes | Identifier for the resource used in the credit memo process |
| Employee | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the employee who created the credit memo |
| Contact | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the contact person related to the credit memo |
NetSuite - Entity One Of (ver. 1.7.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Customer | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the customer associated with the credit memo |
| Partner | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the partner related to the credit memo |
| Vendor | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the vendor linked to the credit memo |
| NsResource | NetSuite - Ns Resource v1.6.0 |
Yes | Identifier for the resource used in the credit memo process |
| Employee | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the employee who created the credit memo |
| Contact | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the contact person related to the credit memo |
NetSuite - Status (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom data related to the credit memo |
NetSuite - Bill Country (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Source (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Estimate Accounting Book Detail Collection (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the NetSuite instance for API calls |
| TotalResults | Integer | Yes | Indicates the total number of customer records retrieved |
| Count | Integer | Yes | Represents the number of customer records in the current response |
| HasMore | Bool | Yes | Indicates if there are more customer records available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Estimate Accounting Book Detail Element v1.3.0 |
Yes | Contains the list of customer records retrieved from NetSuite |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the customer records |
NetSuite - Estimate Billing Address (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Zip | String | Yes | Represents the postal code of the customer address |
| Country | NetSuite - Country v1.4.0 |
Yes | Indicates the country of the customer |
| Addr2 | String | Yes | Contains additional address information |
| City | String | Yes | Specifies the city of the customer address |
| Addr1 | String | Yes | Represents the primary address line of the customer |
| LastModifiedDate | DateTime | Yes | Records the last date and time the customer information was modified |
| Addr3 | String | Yes | Provides further address details if needed |
| ExternalID | String | Yes | Unique identifier for the customer in external systems |
| AddrPhone | String | Yes | Contains the phone number associated with the customer address |
| Addressee | String | Yes | Specifies the name of the person or entity receiving the address |
| Attention | String | Yes | Indicates any specific attention required for the address |
| Override | Bool | Yes | Determines if the existing address should be overridden |
| State | String | Yes | Specifies the state or region of the customer address |
| AddrText | String | Yes | Provides a formatted text representation of the address |
| RefName | String | Yes | Represents a reference name for the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links to related resources or records |
| CustomFields | JSON | Yes | Holds additional custom field data for the customer |
NetSuite - Estimate Item Collection (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the NetSuite resource for the customer data |
| TotalResults | Integer | Yes | Indicates the total number of customer records retrieved |
| Count | Integer | Yes | Represents the number of customer records in the current response |
| HasMore | Bool | Yes | Indicates whether there are more customer records available |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Estimate Item Element v1.4.0 |
Yes | Contains the list of customer records retrieved from NetSuite |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the customer records |
NetSuite - Estimate Ship Group Collection (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the NetSuite instance for API interactions |
| TotalResults | Integer | Yes | Represents the total number of customer records retrieved |
| Count | Integer | Yes | Indicates the number of customer records in the current response |
| HasMore | Bool | Yes | Indicates if there are more customer records available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Estimate Ship Group Element v1.2.0 |
Yes | Contains the list of customer records returned in the response |
| CustomFields | JSON | Yes | Holds any additional custom field data associated with the customer records |
NetSuite - Estimate Shipping Address (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Zip | String | Yes | Represents the postal code of the customer location |
| Country | NetSuite - Country v1.4.0 |
Yes | Indicates the country of the customer |
| Addr2 | String | Yes | Contains additional address information |
| City | String | Yes | Specifies the city of the customer |
| Addr1 | String | Yes | Contains the primary address line for the customer |
| LastModifiedDate | DateTime | Yes | Records the last date and time the customer information was modified |
| Addr3 | String | Yes | Provides further address details if necessary |
| ExternalID | String | Yes | Unique identifier for the customer in external systems |
| AddrPhone | String | Yes | Contains the phone number associated with the customer address |
| Addressee | String | Yes | Specifies the name of the person or entity to whom the address belongs |
| Attention | String | Yes | Indicates any specific attention required for the address |
| Override | Bool | Yes | Determines if the existing customer data should be overridden |
| State | String | Yes | Specifies the state or region of the customer |
| AddrText | String | Yes | Provides a full text representation of the address |
| RefName | String | Yes | Contains a reference name for the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links to related records or resources |
| CustomFields | JSON | Yes | Holds any custom fields associated with the customer |
NetSuite - Forecast Type (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the customer in NetSuite |
| RefName | String | Yes | The reference name for the customer used in the connector |
| CustomFields | JSON | Yes | Additional custom attributes related to the customer |
NetSuite - Country (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Estimate Accounting Book Detail Element (ver. 1.3.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the connection link to the NetSuite instance |
| ExchangeRate | Double | Yes | Indicates the currency exchange rate for transactions |
| RefName | String | Yes | Provides a reference name for the customer record |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary associated with the customer |
| AccountingBook | NetSuite - Ns Resource v1.6.0 |
Yes | Specifies the accounting book linked to the customer |
| CustomFields | JSON | Yes | Contains any custom fields related to the customer record |
NetSuite - Estimate Item Element (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the link to the NetSuite instance for data synchronization |
| RateSchedule | String | Yes | Specifies the rate schedule applicable to the customer |
| ShipCarrier | NetSuite - Ship Carrier v1.2.0 |
Yes | Identifies the shipping carrier used for deliveries |
| QuantityCommitted | Double | Yes | Indicates the quantity of items committed to the customer |
| Options | String | Yes | Contains additional options related to the customer order |
| OqpBucket | String | Yes | Represents the bucket for open quantity processing |
| QuantityOnHand | Double | Yes | Shows the quantity of items currently available in stock |
| CostEstimateType | NetSuite - Cost Estimate Type v1.2.0 |
Yes | Defines the type of cost estimate for the transaction |
| ItemSubtype | NetSuite - Item Subtype v1.2.0 |
Yes | Specifies the subtype of the item being processed |
| EstGrossProfit | Double | Yes | Estimates the gross profit for the transaction |
| BillVarianceStatus | NetSuite - Bill Variance Status v1.2.0 |
Yes | Indicates the status of any billing variances |
| MatrixType | String | Yes | Describes the type of matrix used for pricing or inventory |
| FromJob | Bool | Yes | Indicates if the item is sourced from a job |
| IsOpen | Bool | Yes | Shows whether the transaction is currently open |
| EstGrossProfitPercent | Double | Yes | Estimates the gross profit percentage for the transaction |
| Line | Integer | Yes | Represents the line number in the transaction |
| Description | String | Yes | Provides a description of the item or transaction |
| IsClosed | Bool | Yes | Indicates if the transaction has been closed |
| Units | String | Yes | Specifies the units of measurement for the items |
| Rate | Double | Yes | Represents the rate applied to the transaction |
| Marginal | Bool | Yes | Indicates if the item is considered marginal |
| ExcludeFromRateRequest | Bool | Yes | Specifies if the item should be excluded from rate requests |
| CostEstimateRate | Double | Yes | Represents the estimated cost rate for the transaction |
| Linked | Bool | Yes | Indicates if the transaction is linked to another record |
| IsEstimate | Bool | Yes | Shows whether the record is an estimate |
| MinQty | Double | Yes | Specifies the minimum quantity required for the transaction |
| PrintItems | Bool | Yes | Indicates if items should be printed on the invoice |
| Amount | Double | Yes | Represents the total amount for the transaction |
| Quantity | Double | Yes | Indicates the quantity of items being ordered |
| InitOqpBucket | String | Yes | Represents the initial bucket for open quantity processing |
| ItemType | NetSuite - Item Type v1.4.0 |
Yes | Defines the type of item being processed |
| QuantityAvailable | Double | Yes | Shows the quantity of items available for sale |
| CostEstimate | Double | Yes | Represents the estimated cost for the transaction |
| ExpectedShipDate | DateTime | Yes | Indicates the expected shipping date for the order |
| LicenseCode | String | Yes | Contains the license code associated with the customer |
| RefName | String | Yes | Provides a reference name for the transaction |
| Class | NetSuite - ID v1.2.0 |
Yes | Specifies the class associated with the transaction |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Identifies the specific item being processed |
| Price | NetSuite - ID v1.2.0 |
Yes | Represents the price associated with the item |
| Location | NetSuite - ID v1.2.0 |
Yes | Specifies the location of the item in inventory |
| BillingSchedule | NetSuite - ID v1.2.0 |
Yes | Defines the billing schedule for the customer |
| InventoryDetail | NetSuite - Estimate Item Inventory Detail v1.2.0 |
Yes | Provides detailed inventory information for the item |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary associated with the transaction |
| ShipAddress | NetSuite - Ns Resource v1.6.0 |
Yes | Contains the shipping address for the customer |
| ShipMethod | NetSuite - ID v1.2.0 |
Yes | Specifies the shipping method chosen for delivery |
| Department | NetSuite - ID v1.2.0 |
Yes | Indicates the department associated with the transaction |
| CustomFields | JSON | Yes | Contains custom fields relevant to the customer or transaction |
NetSuite - Estimate Ship Group Element (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the connection to the NetSuite API |
| ShippingRate | Double | Yes | Indicates the calculated shipping cost for the order |
| UniqueKey | Integer | Yes | Serves as a unique identifier for the customer record |
| SourceAddress | String | Yes | Contains the address from which the shipment originates |
| Weight | Double | Yes | Specifies the total weight of the shipment |
| HandlingRate | Double | Yes | Represents the cost associated with handling the shipment |
| ID | Integer | Yes | Unique identifier for the customer in NetSuite |
| DestinationAddress | String | Yes | Contains the address where the shipment is to be delivered |
| ShippingMethod | String | Yes | Describes the method of shipping selected for the order |
| RefName | String | Yes | Provides a reference name for the customer record |
| CustomFields | JSON | Yes | Holds additional custom data related to the customer |
NetSuite - Item Type (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Item Subtype (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Cost Estimate Type (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Ship Carrier (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Estimate Item Inventory Detail (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ItemDescription | String | Yes | Describes the item in the context of the customer record |
| Unit | String | Yes | Specifies the unit of measurement for the item |
| Quantity | Double | Yes | Indicates the quantity of the item being referenced |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Identifies the custom form used for the transaction |
| ExternalID | String | Yes | Provides a unique identifier for the customer in external systems |
| RefName | String | Yes | Represents the reference name associated with the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links to related records or resources |
| InventoryAssignment | NetSuite - Estimate Item Inventory Detail Inventory Assignment Collection v1.2.0 |
Yes | Details the inventory assignments for the item |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Specifies the item associated with the customer |
| Location | NetSuite - ID v1.2.0 |
Yes | Indicates the location of the item in inventory |
| ToLocation | NetSuite - ID v1.2.0 |
Yes | Specifies the destination location for the item |
| CustomFields | JSON | Yes | Holds additional custom data related to the customer |
NetSuite - Bill Variance Status (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the customer in NetSuite |
| RefName | String | Yes | Display name of the customer used in the connector |
| CustomFields | JSON | Yes | Additional custom attributes related to the customer |
NetSuite - Estimate Item Inventory Detail Inventory Assignment Collection (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the NetSuite instance for API interactions |
| TotalResults | Integer | Yes | Indicates the total number of results returned from the query |
| Count | Integer | Yes | Represents the number of items in the current response |
| HasMore | Bool | Yes | Indicates whether there are more results available beyond the current response |
| Offset | Integer | Yes | Specifies the starting point for the next set of results |
| Items | NetSuite - Estimate Item Inventory Detail Inventory Assignment Element v1.2.0 |
Yes | Contains the list of items retrieved from the NetSuite query |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the customer data |
NetSuite - Estimate Item Inventory Detail Inventory Assignment Element (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the connection link to the NetSuite instance |
| PackCarton | String | Yes | Specifies the carton identifier for packing items |
| Quantity | Double | Yes | Indicates the total quantity of items involved |
| ExpirationDate | DateTime | Yes | Denotes the expiration date of the inventory item |
| InventoryDetail | Integer | Yes | Provides detailed inventory information for tracking |
| ReceiptInventoryNumber | String | Yes | Identifies the inventory receipt number for reference |
| InternalID | Integer | Yes | Unique identifier for the customer in NetSuite |
| QuantityAvailable | Double | Yes | Shows the quantity of items currently available in stock |
| PickCarton | String | Yes | Indicates the carton identifier for picking items |
| RefName | String | Yes | Represents a reference name for the customer record |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Identifies the inventory issue number for tracking |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Specifies the destination bin number for inventory |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Identifies the bin number where the inventory is stored |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the current status of the inventory item |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Specifies the target inventory status for the item |
| CustomFields | JSON | Yes | Contains additional custom fields related to the customer |
Output
NetSuite - Response (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StatusCode | Integer | No | HTTP status code returned by the NetSuite API indicating the result of the operation |
| IsError | Bool | No | Indicates whether there was an error during the operation |
| Message | String | Yes | Error or status message providing additional information |
Status Code
- 200 Success
- 400 Bad request
- 404 Not found
- 500 Server error