Transform to Invoice is a powerful action that simplifies your billing process by converting customer data directly into invoices within NetSuite. This functionality enhances your financial operations by ensuring accurate and timely invoicing, reducing manual entry errors, and improving cash flow management. With Transform to Invoice, you can seamlessly integrate customer information, streamline your invoicing workflow, and maintain clear financial records. This action is ideal for businesses of all sizes looking to enhance their invoicing efficiency and ensure a smooth transition from customer management to billing.
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 Invoice Request (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the customer in NetSuite |
| Invoice | NetSuite - Invoice v1.5.0 |
No | Reference to the associated invoice for the customer |
NetSuite - Invoice (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| String | Yes | Email address of the customer for communication purposes | |
| DefaultILShipMethKey | Integer | Yes | Key representing the default shipping method for the customer |
| StartDate | DateTime | Yes | Date when the customer relationship starts |
| Oppcreatedfromtitle | String | Yes | Title of the opportunity from which the customer was created |
| Estimate | Integer | Yes | Estimated value associated with the customer |
| HandlingCost | Double | Yes | Cost associated with handling the customer's orders |
| Subtotal | Double | Yes | Total amount before taxes and additional charges |
| BillAddr1 | String | Yes | First line of the billing address for the customer |
| TotalCostEstimate | Double | Yes | Estimated total cost for the customer's orders |
| AmountPaid | Double | Yes | Total amount paid by the customer |
| BillAddr2 | String | Yes | Second line of the billing address for the customer |
| BillAddr3 | String | Yes | Third line of the billing address for the customer |
| ShippingCost | Double | Yes | Cost of shipping for the customer's orders |
| GiftCertApplied | Double | Yes | Amount of gift certificates applied to the customer's orders |
| IsMultiShipTo | Bool | Yes | Indicates if the customer can have multiple shipping addresses |
| CreatedDate | DateTime | Yes | Date when the customer record was created |
| CanHaveStackable | Bool | Yes | Indicates if the customer can have stackable items |
| WebSite | String | Yes | URL of the customer's website |
| PrevDate | DateTime | Yes | Previous date related to the customer's transactions |
| SalesEffectiveDate | DateTime | Yes | Date when sales terms become effective for the customer |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Custom form used for the customer's transactions |
| PrevRep | Integer | Yes | Identifier for the previous representative associated with the customer |
| ShipAddress | String | Yes | Shipping address for the customer |
| ExternalID | String | Yes | Unique identifier for the customer in external systems |
| Source | NetSuite - Source v1.4.0 |
Yes | Source from which the customer was acquired |
| ToBePrinted | Bool | Yes | Indicates if the customer's documents need to be printed |
| BillPhone | String | Yes | Phone number associated with the billing address |
| BillAttention | String | Yes | Attention line for the billing address |
| ToBeEmailed | Bool | Yes | Indicates if the customer's documents need to be emailed |
| DiscountDate | DateTime | Yes | Date when discounts are applicable for the customer |
| TrackingNumbers | String | Yes | Tracking numbers for shipments to the customer |
| Fob | String | Yes | Free on Board terms for the customer |
| ExchangeRate | Double | Yes | Exchange rate applicable to the customer's transactions |
| Originator | String | Yes | Originator of the customer record |
| BillZip | String | Yes | Zip code for the billing address |
| ToBeFaxed | Bool | Yes | Indicates if the customer's documents need to be faxed |
| PromoCodePluginImpl | String | Yes | Implementation details for the promo code plugin |
| StoreOrder | String | Yes | Identifier for the store order associated with the customer |
| ShipDate | DateTime | Yes | Date when the customer's order is shipped |
| ShippingAddress_text | String | Yes | Text representation of the shipping address |
| PreviousOpportunity | String | Yes | Identifier for the previous opportunity related to the customer |
| Message | String | Yes | Message or notes related to the customer |
| AmountRemainingTotalBox | Double | Yes | Total amount remaining for the customer |
| BillAddressee | String | Yes | Name of the person to whom the bill is addressed |
| DueDate | DateTime | Yes | Due date for payments from the customer |
| BillCity | String | Yes | City for the billing address |
| TranDate | DateTime | Yes | Date of the transaction related to the customer |
| Memo | String | Yes | Additional notes or comments about the customer |
| BillCountry | NetSuite - Bill Country v1.4.0 |
Yes | Country for the billing address |
| ID | String | Yes | Unique identifier for the customer record |
| BillAddress | String | Yes | Full billing address for the customer |
| EstGrossProfit | Double | Yes | Estimated gross profit from the customer |
| EndDate | DateTime | Yes | Date when the customer relationship ends |
| Status | NetSuite - Status v1.4.0 |
Yes | Current status of the customer record |
| ShipIsResidential | Bool | Yes | Indicates if the shipping address is residential |
| EstGrossProfitPercent | Double | Yes | Estimated gross profit percentage from the customer |
| ExcludeCommission | Bool | Yes | Indicates if commissions should be excluded for this customer |
| ShipOverride | Bool | Yes | Indicates if shipping details are overridden for the customer |
| DiscountAmount | Double | Yes | Total discount amount applicable to the customer |
| LinkedTrackingNumbers | String | Yes | Tracking numbers linked to the customer's orders |
| AmountRemaining | Double | Yes | Amount remaining to be paid by the customer |
| DiscountRate | Double | Yes | Rate of discount applicable to the customer |
| BillState | String | Yes | State for the billing address |
| AltHandlingCost | Double | Yes | Alternative handling cost for the customer's orders |
| Oppcreatedfrom | String | Yes | Identifier for the opportunity from which the customer was created |
| BillOverride | String | Yes | Override details for the billing address |
| BillingAddress_text | String | Yes | Text representation of the billing address |
| DiscountTotal | Double | Yes | Total discount applicable to the customer's orders |
| ShippingCostOverridden | Bool | Yes | Indicates if the shipping cost has been overridden |
| MuccPromoCodeInstance | String | Yes | Instance details for the promotional code |
| OtherRefNum | String | Yes | Other reference number associated with the customer |
| ThirdPartyAcct | String | Yes | Third-party account information related to the customer |
| Total | Double | Yes | Total amount for the customer's orders |
| TranID | String | Yes | Transaction ID associated with the customer |
| LastModifiedDate | DateTime | Yes | Date when the customer record was last modified |
| AltShippingCost | Double | Yes | Alternative shipping cost for the customer's orders |
| RefName | String | Yes | Reference name associated with the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links related to the customer record |
| CreatedFrom | NetSuite - Ns Resource v1.6.0 |
Yes | Resource from which the customer was created |
| SourceWebSite | NetSuite - ID v1.2.0 |
Yes | Source website associated with the customer |
| Job | NetSuite - Job One Of v1.4.0 |
Yes | Job identifier related to the customer |
| Department | NetSuite - ID v1.2.0 |
Yes | Department associated with the customer |
| CouponCode | NetSuite - ID v1.2.0 |
Yes | Coupon code applicable to the customer |
| MessageSel | NetSuite - ID v1.2.0 |
Yes | Selected message identifier for the customer |
| ShipAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | List of shipping addresses for the customer |
| PostingPeriod | NetSuite - ID v1.2.0 |
Yes | Posting period for the customer's transactions |
| LeadSource | NetSuite - Ns Resource v1.6.0 |
Yes | Source of the lead for the customer |
| SalesRep | NetSuite - Sales Rep One Of v1.5.0 |
Yes | Sales representative assigned to the customer |
| Time | NetSuite - Invoice Time Collection v1.5.0 |
Yes | Time details related to the customer's invoices |
| Class | NetSuite - ID v1.2.0 |
Yes | Class associated with the customer |
| Terms | NetSuite - ID v1.2.0 |
Yes | Payment terms applicable to the customer |
| BillAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | List of billing addresses for the customer |
| Partner | NetSuite - ID v1.2.0 |
Yes | Partner associated with the customer |
| GiftCertRedemption | NetSuite - Invoice Gift Cert Redemption Collection v1.5.0 |
Yes | Details of gift certificate redemptions for the customer |
| ShippingAddress | NetSuite - Invoice Shipping Address v1.4.0 |
Yes | Shipping address details for the customer's invoices |
| Item | NetSuite - Invoice Item Collection v1.5.0 |
Yes | Items associated with the customer's invoices |
| ShipGroup | NetSuite - Invoice Ship Group Collection v1.4.0 |
Yes | Shipping group details for the customer |
| ExpCost | NetSuite - Invoice Exp Cost Collection v1.5.0 |
Yes | Expected cost details for the customer's invoices |
| Currency | NetSuite - ID v1.2.0 |
Yes | Currency used for the customer's transactions |
| Entity | NetSuite - Entity One Of v1.7.0 |
Yes | Entity associated with the customer |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Subsidiary associated with the customer |
| Account | NetSuite - ID v1.2.0 |
Yes | Account identifier for the customer |
| Location | NetSuite - ID v1.2.0 |
Yes | Location associated with the customer |
| DiscountItem | NetSuite - ID v1.2.0 |
Yes | Discount item identifier for the customer |
| ItemCost | NetSuite - Invoice Item Cost Collection v1.5.0 |
Yes | Cost details for items associated with the customer |
| ShipMethod | NetSuite - ID v1.2.0 |
Yes | Shipping method identifier for the customer |
| AccountingBookDetail | NetSuite - Invoice Accounting Book Detail Collection v1.5.0 |
Yes | Accounting book details for the customer's invoices |
| Opportunity | NetSuite - ID v1.2.0 |
Yes | Opportunity identifier related to the customer |
| BillingAddress | NetSuite - Invoice Billing Address v1.4.0 |
Yes | Billing address details for the customer's invoices |
| PromoCode | NetSuite - ID v1.2.0 |
Yes | Promotional code identifier for the customer |
| CustomFields | JSON | Yes | 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 - Invoice Billing 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 | Holds any extra address details not covered in Addr1 or Addr2 |
| ExternalID | String | Yes | Unique identifier for the customer in external systems |
| AddrPhone | String | Yes | Provides the phone number associated with the customer address |
| Addressee | String | Yes | Identifies the name of the person or entity receiving the address |
| Attention | String | Yes | Specifies any attention line for the address, if applicable |
| Override | Bool | Yes | Indicates whether to override existing customer data |
| State | String | Yes | Represents the state or province of the customer |
| AddrText | String | Yes | Contains the full address as a single text string |
| RefName | String | Yes | Provides a reference name for the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links to related records or resources in NetSuite |
| CustomFields | JSON | Yes | Holds any custom fields associated with the customer |
NetSuite - Invoice 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 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 - Invoice Accounting Book Detail Element v1.3.0 |
Yes | Contains the detailed customer records retrieved from NetSuite |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the customer records |
NetSuite - Invoice Item Cost Collection (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the specific NetSuite resource |
| TotalResults | Integer | Yes | Indicates the total number of results returned |
| Count | Integer | Yes | Represents the number of items in the current response |
| HasMore | Bool | Yes | Indicates if there are more results available |
| Offset | Integer | Yes | Specifies the starting point for the results returned |
| Items | NetSuite - Invoice Item Cost Element v1.4.0 |
Yes | Contains the list of invoice items retrieved |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the customer |
NetSuite - Invoice Exp Cost 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 whether there are more customer records available |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Invoice Exp Cost 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 - Invoice 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 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 whether there are more customer records to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Invoice Ship Group Element v1.2.0 |
Yes | Contains the list of customer records returned in the response |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the customer records |
NetSuite - Invoice 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 customer record |
| 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 - Invoice Item Element v1.4.0 |
Yes | Contains the list of customer records returned in the response |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the customer records |
NetSuite - Invoice 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 of the customer |
| LastModifiedDate | DateTime | Yes | Records the last date and time the customer information was updated |
| 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 of the customer |
| Addressee | String | Yes | Specifies the name of the person 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 province of the customer |
| AddrText | String | Yes | Provides a formatted 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 related to the customer in NetSuite |
| CustomFields | JSON | Yes | Holds any custom fields associated with the customer |
NetSuite - Invoice Gift Cert Redemption 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 interactions |
| TotalResults | Integer | Yes | Indicates the total number of results returned by the query |
| Count | Integer | Yes | Represents the number of items in the current response |
| HasMore | Bool | Yes | Indicates if there are more results available beyond the current response |
| Offset | Integer | Yes | Specifies the starting point for the next set of results |
| Items | NetSuite - Invoice Gift Cert Redemption Element v1.3.0 |
Yes | Contains the list of items retrieved from the NetSuite API |
| CustomFields | JSON | Yes | Holds additional custom field data related to the customer |
NetSuite - Invoice Time 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 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 - Invoice Time 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 - 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 - Invoice 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 current exchange rate for currency conversion |
| RefName | String | Yes | Holds the 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 - Invoice Item Cost Element (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the connection to the NetSuite instance |
| RateSchedule | String | Yes | Specifies the pricing schedule for the customer |
| Memo | String | Yes | Contains additional notes related to the customer |
| Options | String | Yes | Lists any special options or preferences for the customer |
| Unit | String | Yes | Indicates the unit of measure for transactions |
| UnitDisp | String | Yes | Displays the unit of measure in a user-friendly format |
| Line | Integer | Yes | Represents the line number in the transaction |
| BilledDate | DateTime | Yes | Indicates the date when the customer was billed |
| Amount | Double | Yes | Represents the total amount charged to the customer |
| Cost | Double | Yes | Indicates the cost associated with the transaction |
| Apply | Bool | Yes | Specifies whether the transaction should be applied |
| Url | String | Yes | Provides a link to the customer's profile or details |
| ItemCostCount | String | Yes | Indicates the count of items associated with the cost |
| RefName | String | Yes | Contains the reference name for the customer |
| InventoryDetail | NetSuite - Invoice Item Cost Inventory Detail v1.2.0 |
Yes | Provides detailed inventory information related to the transaction |
| Doc | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the document associated with the transaction |
| Department | NetSuite - ID v1.2.0 |
Yes | Indicates the department responsible for the customer |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Specifies the item related to the transaction |
| Location | NetSuite - ID v1.2.0 |
Yes | Indicates the location associated with the customer |
| Class | NetSuite - ID v1.2.0 |
Yes | Represents the classification of the customer |
| CustomFields | JSON | Yes | Contains any custom fields related to the customer |
NetSuite - Invoice Exp Cost 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 customer record |
| Memo | String | Yes | Contains additional notes related to the customer |
| Line | Integer | Yes | Indicates the line number in a transaction |
| BilledDate | DateTime | Yes | Specifies the date when the customer was billed |
| Amount | Double | Yes | Represents the total amount billed to the customer |
| Apply | Bool | Yes | Indicates whether the amount has been applied to an invoice |
| Url | String | Yes | Provides a URL link to the customer record in NetSuite |
| OriginalAmount | Double | Yes | Represents the original amount before any adjustments |
| RefName | String | Yes | Contains the reference name associated with the customer |
| Category | NetSuite - ID v1.2.0 |
Yes | Identifies the category of the customer in NetSuite |
| Class | NetSuite - ID v1.2.0 |
Yes | Specifies the class associated with the customer |
| Employee | NetSuite - ID v1.2.0 |
Yes | Represents the employee linked to the customer record |
| Department | NetSuite - ID v1.2.0 |
Yes | Indicates the department associated with the customer |
| Location | NetSuite - ID v1.2.0 |
Yes | Specifies the location related to the customer |
| Doc | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the document associated with the customer |
| CustomFields | JSON | Yes | Contains any custom fields related to the customer record |
NetSuite - Invoice 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 instance |
| ShippingRate | Double | Yes | Indicates the cost of shipping 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 - Invoice 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 resource |
| VsoeIsEstimate | Bool | Yes | Indicates if the line item is an estimate |
| RateSchedule | String | Yes | Specifies the rate schedule associated with the item |
| ShipCarrier | NetSuite - Ship Carrier v1.2.0 |
Yes | Identifies the shipping carrier for the order |
| QuantityCommitted | Double | Yes | Shows the quantity that has been committed for the order |
| GiftCertRecipientName | String | Yes | Contains the name of the recipient for a gift certificate |
| Options | String | Yes | Lists any options or configurations for the item |
| OqpBucket | String | Yes | Represents the order quantity pricing bucket |
| QuantityOnHand | Double | Yes | Displays the quantity of the item currently in stock |
| VsoeAmount | Double | Yes | Indicates the value of the line item for revenue recognition |
| CostEstimateType | NetSuite - Cost Estimate Type v1.2.0 |
Yes | Defines the type of cost estimate for the item |
| ItemSubtype | NetSuite - Item Subtype v1.2.0 |
Yes | Specifies the subtype of the item in NetSuite |
| VsoeAllocation | Double | Yes | Shows the allocation of the line item for revenue recognition |
| EstGrossProfit | Double | Yes | Estimates the gross profit for the line item |
| BillVarianceStatus | NetSuite - Bill Variance Status v1.2.0 |
Yes | Indicates the billing variance status for the item |
| MatrixType | String | Yes | Defines the matrix type for items with multiple options |
| IsOpen | Bool | Yes | Indicates if the order line is still open |
| EstGrossProfitPercent | Double | Yes | Estimates the gross profit percentage for the line item |
| Line | Integer | Yes | Represents the line number of the item in the order |
| Description | String | Yes | Provides a description of the item or service |
| IsClosed | Bool | Yes | Indicates if the order line has been closed |
| Units | String | Yes | Specifies the unit of measure for the item |
| Rate | Double | Yes | Displays the rate for the item or service |
| Marginal | Bool | Yes | Indicates if the item is considered marginal |
| ExcludeFromRateRequest | Bool | Yes | Specifies if the item should be excluded from rate requests |
| GiftCertRecipientEmail | String | Yes | Contains the email address of the gift certificate recipient |
| CostEstimateRate | Double | Yes | Shows the rate used for cost estimation |
| Linked | Bool | Yes | Indicates if the item is linked to another record |
| MinQty | Double | Yes | Specifies the minimum quantity required for the item |
| PrintItems | Bool | Yes | Indicates if the items should be printed on the invoice |
| Amount | Double | Yes | Represents the total amount for the line item |
| Quantity | Double | Yes | Displays the quantity of the item being ordered |
| InitOqpBucket | String | Yes | Represents the initial order quantity pricing bucket |
| GiftCertFrom | String | Yes | Contains the name of the sender for a gift certificate |
| ProcessedByRevCommit | Bool | Yes | Indicates if the item has been processed by revenue commitment |
| OrderLine | Integer | Yes | Represents the order line number for the item |
| ItemType | NetSuite - Item Type v1.4.0 |
Yes | Specifies the type of item in NetSuite |
| QuantityAvailable | Double | Yes | Displays the quantity of the item available for sale |
| GiftCertMessage | String | Yes | Contains a message for the gift certificate |
| CostEstimate | Double | Yes | Represents the estimated cost for the item |
| Revrec_recurrencetype | String | Yes | Specifies the recurrence type for revenue recognition |
| LicenseCode | String | Yes | Contains the license code associated with the item |
| RefName | String | Yes | Provides a reference name for the item |
| Department | NetSuite - ID v1.2.0 |
Yes | Identifies the department associated with the item |
| Class | NetSuite - ID v1.2.0 |
Yes | Specifies the class associated with the item |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Represents the specific item being referenced |
| InventoryDetail | NetSuite - Invoice Item Inventory Detail v1.2.0 |
Yes | Contains detailed inventory information for the item |
| Account | NetSuite - ID v1.2.0 |
Yes | Identifies the account associated with the item |
| Location | NetSuite - ID v1.2.0 |
Yes | Specifies the location of the item in inventory |
| ShipAddress | NetSuite - Ns Resource v1.6.0 |
Yes | Contains the shipping address for the order |
| ShipMethod | NetSuite - ID v1.2.0 |
Yes | Identifies the shipping method for the order |
| Price | NetSuite - ID v1.2.0 |
Yes | Represents the price associated with the item |
| OrderDoc | NetSuite - Ns Resource v1.6.0 |
Yes | Contains the order document associated with the item |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary associated with the order |
| CustomFields | JSON | Yes | Contains any custom fields related to the item |
NetSuite - Invoice Gift Cert Redemption 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 |
| AuthCodeApplied | Double | Yes | Indicates whether an authorization code has been applied |
| RefName | String | Yes | Contains a reference name for the customer record |
| AuthCode | NetSuite - Ns Resource v1.6.0 |
Yes | Holds the authorization code for accessing NetSuite resources |
| CustomFields | JSON | Yes | Stores additional custom fields related to the customer |
NetSuite - Invoice Time 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 customer record |
| RateSchedule | String | Yes | Specifies the rate schedule associated with the customer |
| Memo | String | Yes | Contains additional notes or comments about the customer |
| Unit | String | Yes | Indicates the unit of measure for transactions |
| BilledDate | DateTime | Yes | Records the date when the customer was billed |
| Rate | Double | Yes | Represents the billing rate for the customer |
| Amount | Double | Yes | Specifies the total amount billed to the customer |
| Apply | Bool | Yes | Indicates whether the billing amount should be applied |
| Url | String | Yes | Provides a URL link to the customer's online profile |
| RefName | String | Yes | Contains the reference name for the customer |
| Class | NetSuite - ID v1.2.0 |
Yes | Identifies the class associated with the customer |
| Location | NetSuite - ID v1.2.0 |
Yes | Specifies the location of the customer in NetSuite |
| Department | NetSuite - ID v1.2.0 |
Yes | Indicates the department linked to the customer |
| Employee | NetSuite - ID v1.2.0 |
Yes | Represents the employee responsible for the customer |
| Doc | NetSuite - ID v1.2.0 |
Yes | Contains the document ID related to the customer |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Specifies the item associated with the customer transaction |
| CustomFields | JSON | Yes | Holds any custom fields related to the customer record |
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 - 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 - Invoice Item Cost Inventory Detail (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ItemDescription | String | Yes | Describes the item being referenced in the customer record |
| Unit | String | Yes | Specifies the unit of measurement for the item |
| Quantity | Double | Yes | Indicates the quantity of the item associated with the customer |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Identifies the custom form used for the customer record |
| ExternalID | String | Yes | Provides a unique identifier for the customer from an external system |
| RefName | String | Yes | Represents the reference name for the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links related to the customer record |
| Location | NetSuite - ID v1.2.0 |
Yes | Specifies the location associated with the customer |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Refers to the specific item linked to the customer |
| ToLocation | NetSuite - ID v1.2.0 |
Yes | Indicates the destination location for the item |
| InventoryAssignment | NetSuite - Invoice Item Cost Inventory Detail Inventory Assignment Collection v1.2.0 |
Yes | Details the inventory assignments related to the customer |
| CustomFields | JSON | Yes | Holds additional custom fields for the customer record |
NetSuite - Invoice Item Inventory Detail (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ItemDescription | String | Yes | Describes the item being sold or serviced |
| Unit | String | Yes | Specifies the unit of measurement for the item |
| Quantity | Double | Yes | Indicates the amount of the item being ordered |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Identifies the custom form used for the transaction |
| ExternalID | String | Yes | Represents an external identifier for the customer |
| RefName | String | Yes | Provides a reference name for the customer record |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links related to the customer record |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Specifies the item associated with the transaction |
| InventoryAssignment | NetSuite - Invoice Item Inventory Detail Inventory Assignment Collection v1.2.0 |
Yes | Details the inventory assignments for the item |
| ToLocation | NetSuite - ID v1.2.0 |
Yes | Indicates the destination location for the item |
| Location | NetSuite - ID v1.2.0 |
Yes | Specifies the location of the item in inventory |
| CustomFields | JSON | Yes | Contains additional custom fields related to the customer |
NetSuite - Invoice Item Cost 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 by the query |
| Count | Integer | Yes | Represents the number of items in the current response |
| HasMore | Bool | Yes | Indicates whether there are more results available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of results |
| Items | NetSuite - Invoice Item Cost Inventory Detail Inventory Assignment Element v1.2.0 |
Yes | Contains the list of items retrieved from the NetSuite query |
| CustomFields | JSON | Yes | Holds additional custom field data associated with the customer |
NetSuite - Invoice 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 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 to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Invoice Item Inventory Detail Inventory Assignment Element v1.2.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 - Invoice Item Cost 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 to the NetSuite instance |
| PackCarton | String | Yes | Identifies the carton used for packing items |
| Quantity | Double | Yes | Specifies the number of items in the transaction |
| ExpirationDate | DateTime | Yes | Indicates when the item will expire |
| InventoryDetail | Integer | Yes | Provides details about the inventory item |
| ReceiptInventoryNumber | String | Yes | Unique identifier for the inventory receipt |
| InternalID | Integer | Yes | Represents the internal identifier for the customer |
| QuantityAvailable | Double | Yes | Shows the available quantity of the item in stock |
| PickCarton | String | Yes | Identifies the carton designated for picking items |
| RefName | String | Yes | Provides a reference name for the customer |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the target inventory status for the item |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Specifies the bin location of the inventory item |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Indicates the target bin location for the item |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the current status of the inventory item |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Unique identifier for the issued inventory |
| CustomFields | JSON | Yes | Contains additional custom fields related to the customer |
NetSuite - Invoice 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 to the NetSuite instance |
| PackCarton | String | Yes | Identifies the carton used for packing items |
| Quantity | Double | Yes | Specifies the number of items in the transaction |
| ExpirationDate | DateTime | Yes | Indicates when the inventory item expires |
| InventoryDetail | Integer | Yes | Provides details about the inventory record |
| ReceiptInventoryNumber | String | Yes | Refers to the inventory number on the receipt |
| InternalID | Integer | Yes | Unique identifier for the customer in NetSuite |
| QuantityAvailable | Double | Yes | Shows the amount of inventory currently available |
| PickCarton | String | Yes | Identifies the carton designated for picking items |
| RefName | String | Yes | Contains a reference name for the customer |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Specifies the destination bin for inventory |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Describes the current status of the inventory item |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the inventory status after the transaction |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Identifies the bin where the inventory is stored |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Refers to the inventory number issued to the customer |
| CustomFields | JSON | Yes | Contains additional custom data 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