Insert Invoice is a powerful action that simplifies the process of managing invoices within your NetSuite environment. By seamlessly integrating with the NetSuite API, this action allows you to effortlessly insert invoices, ensuring that your financial data is accurate and up-to-date. With Insert Invoice, you can enhance your invoicing workflow, reduce manual entry errors, and improve overall operational efficiency. This action is ideal for businesses of all sizes looking to streamline their invoicing processes and maintain better control over their financial transactions.
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 - Invoice (ver. 1.6.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 order or contract |
| Oppcreatedfromtitle | String | Yes | Contains the title of the opportunity from which the order was created |
| Estimate | Integer | Yes | Represents the estimate number associated with the customer order |
| HandlingCost | Double | Yes | Specifies the handling cost for the order |
| Subtotal | Double | Yes | Represents the subtotal amount before taxes and discounts |
| BillAddr1 | String | Yes | Contains the first line of the billing address |
| TotalCostEstimate | Double | Yes | Provides the estimated total cost for the order |
| AmountPaid | Double | Yes | Indicates the amount that has been paid by the customer |
| 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 | Specifies the cost of shipping for the order |
| GiftCertApplied | Double | Yes | Indicates the amount of gift certificates applied to the order |
| IsMultiShipTo | Bool | Yes | Indicates whether the order can be shipped to multiple addresses |
| CreatedDate | DateTime | Yes | Represents the date when the customer order was created |
| String | Yes | Contains the email address of the customer | |
| CanHaveStackable | Bool | Yes | Indicates if the customer can have stackable items in their order |
| WebSite | String | Yes | Contains the website associated with the customer |
| PrevDate | DateTime | Yes | Represents the previous date related to the customer's order |
| SalesEffectiveDate | DateTime | Yes | Indicates the date when sales terms become effective |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Specifies the custom form used for the customer order |
| PrevRep | Integer | Yes | Represents the previous representative associated with the customer |
| ShipAddress | String | Yes | Contains the shipping address for the order |
| ExternalID | String | Yes | Represents the external identifier for the customer |
| Source | NetSuite - Source v1.4.0 |
Yes | Indicates the source from which the customer order originated |
| ToBePrinted | Bool | Yes | Indicates if the order is to be printed |
| BillPhone | String | Yes | Contains the billing phone number for the customer |
| BillAttention | String | Yes | Specifies the attention line for the billing address |
| ToBeEmailed | Bool | Yes | Indicates if the order is to be emailed |
| DiscountDate | DateTime | Yes | Represents the date when discounts are applicable |
| TrackingNumbers | String | Yes | Contains the tracking numbers for the shipment |
| Fob | String | Yes | Specifies the Free on Board terms for shipping |
| ExchangeRate | Double | Yes | Indicates the exchange rate applied to the order |
| Originator | String | Yes | Represents the originator of the order |
| BillZip | String | Yes | Contains the zip code for the billing address |
| ToBeFaxed | Bool | Yes | Indicates if the order is to be faxed |
| PromoCodePluginImpl | String | Yes | Contains the implementation details for the promo code |
| StoreOrder | String | Yes | Represents the store order number associated with the customer |
| ShipDate | DateTime | Yes | Indicates the date when the order is scheduled to ship |
| ShippingAddress_text | String | Yes | Contains the text representation of the shipping address |
| PreviousOpportunity | String | Yes | Represents the previous opportunity related to the customer |
| Message | String | Yes | Contains any messages related to the order |
| AmountRemainingTotalBox | Double | Yes | Indicates the total amount remaining in the box |
| BillAddressee | String | Yes | Specifies 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 | Indicates the transaction date for the order |
| Memo | String | Yes | Contains any additional notes or memos related to the order |
| BillCountry | NetSuite - Bill Country v1.4.0 |
Yes | Specifies the country for the billing address |
| ID | String | Yes | Represents the unique identifier for the customer |
| BillAddress | String | Yes | Contains the full billing address |
| EstGrossProfit | Double | Yes | Indicates the estimated gross profit for the order |
| EndDate | DateTime | Yes | Represents the end date for the customer's order or contract |
| Status | NetSuite - Status v1.4.0 |
Yes | Indicates the current status of the order |
| ShipIsResidential | Bool | Yes | Indicates if the shipping address is residential |
| EstGrossProfitPercent | Double | Yes | Represents the estimated gross profit percentage |
| ExcludeCommission | Bool | Yes | Indicates if commission should be excluded from the order |
| ShipOverride | Bool | Yes | Indicates if shipping details are overridden |
| DiscountAmount | Double | Yes | Specifies the total discount amount applied to the order |
| LinkedTrackingNumbers | String | Yes | Contains linked tracking numbers for the shipment |
| AmountRemaining | Double | Yes | Indicates the remaining amount due for the order |
| DiscountRate | Double | Yes | Represents the discount rate applied to the order |
| BillState | String | Yes | Contains the state for the billing address |
| AltHandlingCost | Double | Yes | Specifies an alternative handling cost for the order |
| Oppcreatedfrom | String | Yes | Contains the identifier of the opportunity from which the order was created |
| BillOverride | String | Yes | Specifies any overrides for the billing address |
| BillingAddress_text | String | Yes | Contains the text representation of the billing address |
| DiscountTotal | Double | Yes | Indicates the total discount amount applied to the order |
| ShippingCostOverridden | Bool | Yes | Indicates if the shipping cost has been overridden |
| MuccPromoCodeInstance | String | Yes | Contains the instance details for the promo code |
| OtherRefNum | String | Yes | Represents any other reference number associated with the order |
| ThirdPartyAcct | String | Yes | Contains the third-party account information |
| Total | Double | Yes | Represents the total amount for the order |
| TranID | String | Yes | Contains the transaction ID for the order |
| LastModifiedDate | DateTime | Yes | Indicates the last modified date for the order |
| AltShippingCost | Double | Yes | Specifies an alternative shipping cost for the order |
| RefName | String | Yes | Contains the reference name associated with the order |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links related to the customer order |
| CreatedFrom | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the resource from which the order was created |
| SourceWebSite | NetSuite - ID v1.2.0 |
Yes | Represents the source website associated with the order |
| Job | NetSuite - ID v1.2.0 |
Yes | Contains the job identifier related to the order |
| Department | NetSuite - ID v1.2.0 |
Yes | Represents the department associated with the order |
| CouponCode | NetSuite - ID v1.2.0 |
Yes | Contains the coupon code applied to the order |
| MessageSel | NetSuite - ID v1.2.0 |
Yes | Represents the selected message for the order |
| ShipAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | Contains the list of shipping addresses for the order |
| PostingPeriod | NetSuite - ID v1.2.0 |
Yes | Indicates the posting period for the order |
| LeadSource | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the lead source for the customer |
| SalesRep | NetSuite - ID v1.2.0 |
Yes | Contains the sales representative associated with the order |
| Time | NetSuite - Invoice Time Collection v1.5.0 |
Yes | Represents the time details related to the invoice |
| Class | NetSuite - ID v1.2.0 |
Yes | Indicates the class associated with the order |
| Terms | NetSuite - ID v1.2.0 |
Yes | Represents the payment terms for the order |
| BillAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | Contains the list of billing addresses for the customer |
| Partner | NetSuite - ID v1.2.0 |
Yes | Represents the partner associated with the order |
| GiftCertRedemption | NetSuite - Invoice Gift Cert Redemption Collection v1.5.0 |
Yes | Indicates the details of gift certificate redemption |
| ShippingAddress | NetSuite - Invoice Shipping Address v1.4.0 |
Yes | Contains the shipping address details for the invoice |
| Item | NetSuite - Invoice Item Collection v1.5.0 |
Yes | Represents the items included in the invoice |
| ShipGroup | NetSuite - Invoice Ship Group Collection v1.4.0 |
Yes | Contains the shipping group details for the invoice |
| ExpCost | NetSuite - Invoice Exp Cost Collection v1.5.0 |
Yes | Indicates the expected cost details for the invoice |
| Currency | NetSuite - ID v1.2.0 |
Yes | Represents the currency used for the order |
| Entity | NetSuite - ID v1.2.0 |
Yes | Contains the entity identifier associated with the order |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Represents the subsidiary associated with the order |
| Account | NetSuite - ID v1.2.0 |
Yes | Contains the account identifier related to the order |
| Location | NetSuite - ID v1.2.0 |
Yes | Represents the location associated with the order |
| DiscountItem | NetSuite - ID v1.2.0 |
Yes | Contains the discount item identifier for the order |
| ItemCost | NetSuite - Invoice Item Cost Collection v1.5.0 |
Yes | Indicates the cost details for the items in the invoice |
| ShipMethod | NetSuite - ID v1.2.0 |
Yes | Represents the shipping method used for the order |
| AccountingBookDetail | NetSuite - Invoice Accounting Book Detail Collection v1.5.0 |
Yes | Contains accounting book details related to the invoice |
| Opportunity | NetSuite - ID v1.2.0 |
Yes | Represents the opportunity identifier associated with the order |
| BillingAddress | NetSuite - Invoice Billing Address v1.4.0 |
Yes | Contains the billing address details for the invoice |
| PromoCode | NetSuite - ID v1.2.0 |
Yes | Represents the promo code applied to the order |
| CustomFields | JSON | Yes | Contains custom fields related to the customer order |
NetSuite - ID (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | Yes | The unique identifier |
NetSuite - Custom Form (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the contact in NetSuite |
| RefName | String | Yes | Display name of the contact used for reference |
| CustomFields | JSON | Yes | Additional user-defined fields for the contact |
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 - 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 - 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 - Ns Link (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Rel | String | Yes | Represents the relationship identifier for the Netsuite account |
| Href | String | Yes | Contains the URL link to access the Netsuite account |
| CustomFields | JSON | Yes | Holds additional custom field data specific to the Netsuite account |
NetSuite - Ns Resource (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the Netsuite account |
| RefName | String | Yes | User-friendly name for the Netsuite account |
| ExternalID | String | Yes | Identifier used for external references to the account |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links to related resources or entities in Netsuite |
| CustomFields | JSON | Yes | Additional custom attributes specific to the Netsuite account |
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 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 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 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 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 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 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 - 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 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 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 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 - 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 - 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 - 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 - 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 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 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 |
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 |
Output
NetSuite - ID Response (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StatusCode | Integer | No | Indicates the status of the API request |
| IsError | Bool | No | Specifies whether the request resulted in an error |
| Message | String | Yes | Provides additional information about the request status |
| ID | String | Yes | Represents the unique identifier for the Netsuite account |