Transform to Cash Sale is a powerful action that simplifies the process of converting a customer transaction into a cash sale within the NetSuite environment. By seamlessly integrating customer data and sales functionalities, this action enhances your ability to manage financial transactions efficiently. It allows you to quickly process sales, ensuring accurate record-keeping and streamlined cash flow management. Whether you're a small business or a large enterprise, this action helps you optimize your sales operations and improve overall financial performance.
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 Cash Sale Request (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the customer record |
| CashSale | NetSuite - Cash Sale v1.5.0 |
No | Represents the cash sale transaction associated with the customer |
NetSuite - Cash Sale (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 transactions |
| Oppcreatedfromtitle | String | Yes | Title of the opportunity from which the customer was created |
| ClearedDate | DateTime | Yes | Date when the transaction was cleared |
| Estimate | Integer | Yes | Estimate number associated with the customer transaction |
| HandlingCost | Double | Yes | Cost associated with handling the customer's order |
| DebitPinBlock | String | Yes | Block of the debit pin for the customer's payment |
| Subtotal | Double | Yes | Subtotal amount before taxes and discounts |
| BillAddr1 | String | Yes | First line of the billing address for the customer |
| TotalCostEstimate | Double | Yes | Estimated total cost for the customer's order |
| 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 | Total cost of shipping for the customer's order |
| GiftCertApplied | Double | Yes | Amount of gift certificates applied to the order |
| IsMultiShipTo | Bool | Yes | Indicates if the order can be shipped to multiple addresses |
| CreatedDate | DateTime | Yes | Date when the customer record was created |
| PaymentInstrumentLimit | Double | Yes | Limit on the payment instrument for the customer |
| String | Yes | Email address of the customer | |
| CanHaveStackable | Bool | Yes | Indicates if the customer can have stackable items |
| WebSite | String | Yes | Website associated with the customer |
| PrevDate | DateTime | Yes | Previous transaction date for the customer |
| 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 | Previous representative associated with the customer |
| ShipAddress | String | Yes | Shipping address for the customer |
| ExternalID | String | Yes | External identifier for the customer |
| Source | NetSuite - Source v1.4.0 |
Yes | Source of the customer record |
| ToBePrinted | Bool | Yes | Indicates if the invoice should be printed |
| BillPhone | String | Yes | Phone number for billing inquiries |
| BillAttention | String | Yes | Attention line for billing purposes |
| ToBeEmailed | Bool | Yes | Indicates if the invoice should be emailed |
| DiscountDate | DateTime | Yes | Date when discounts are applicable |
| CardSwipe | String | Yes | Card swipe information for payment processing |
| TrackingNumbers | String | Yes | Tracking numbers for the shipment |
| Fob | String | Yes | Free on Board terms for shipping |
| Cleared | Bool | Yes | Indicates if the transaction has been cleared |
| ExchangeRate | Double | Yes | Exchange rate applied to the transaction |
| Originator | String | Yes | Originator of the customer record |
| BillZip | String | Yes | Zip code for the billing address |
| ToBeFaxed | Bool | Yes | Indicates if the invoice should be faxed |
| PromoCodePluginImpl | String | Yes | Implementation details for promo codes |
| StoreOrder | String | Yes | Store order reference for the customer |
| ShipDate | DateTime | Yes | Date when the order is scheduled to ship |
| ShippingAddress_text | String | Yes | Text representation of the shipping address |
| PreviousOpportunity | String | Yes | Reference to the previous opportunity |
| Message | String | Yes | Message associated with the customer transaction |
| BillAddressee | String | Yes | Addressee for billing purposes |
| DueDate | DateTime | Yes | Due date for payment |
| BillCity | String | Yes | City for the billing address |
| TranDate | DateTime | Yes | Date of the transaction |
| Memo | String | Yes | Memo or notes related to the transaction |
| 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 transaction |
| EndDate | DateTime | Yes | End date for the customer's transactions |
| InputPnRefNum | String | Yes | Reference number for input transactions |
| 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 |
| ExcludeCommission | Bool | Yes | Indicates if commission should be excluded |
| ShipOverride | Bool | Yes | Indicates if shipping details are overridden |
| DiscountAmount | Double | Yes | Total discount amount applied |
| PaymentOperation | NetSuite - Payment Operation v1.2.0 |
Yes | Payment operation details for the transaction |
| DiscountRate | Double | Yes | Rate of discount applied to the transaction |
| BillState | String | Yes | State for the billing address |
| PaymentDeviceID | String | Yes | Identifier for the payment device used |
| AltHandlingCost | Double | Yes | Alternative handling cost for the order |
| Oppcreatedfrom | String | Yes | Reference to the opportunity from which the customer was created |
| UndepFunds | NetSuite - Undep Funds v1.2.0 |
Yes | Details of undeposited funds |
| BillOverride | String | Yes | Override details for billing |
| BillingAddress_text | String | Yes | Text representation of the billing address |
| DebitKsn | String | Yes | Key Serial Number for debit transactions |
| DiscountTotal | Double | Yes | Total amount of discounts applied |
| ShippingCostOverridden | Bool | Yes | Indicates if shipping cost has been overridden |
| MuccPromoCodeInstance | String | Yes | Instance details for the promo code |
| OtherRefNum | String | Yes | Other reference number associated with the transaction |
| ThirdPartyAcct | String | Yes | Third-party account information |
| Total | Double | Yes | Total amount for the transaction |
| TranID | String | Yes | Unique transaction identifier |
| LastModifiedDate | DateTime | Yes | Date when the customer record was last modified |
| DynamicDescriptor | String | Yes | Dynamic descriptor for the transaction |
| AltShippingCost | Double | Yes | Alternative shipping cost for the order |
| RefName | String | Yes | Reference name associated with the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links related to the customer record |
| ItemCost | NetSuite - Cash Sale Item Cost Collection v1.5.0 |
Yes | Cost details for items sold to the customer |
| PromoCode | NetSuite - ID v1.2.0 |
Yes | Identifier for the promo code used |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifier for the subsidiary associated with the customer |
| PaymentOption | NetSuite - Ns Resource v1.6.0 |
Yes | Payment options available for the customer |
| ShipGroup | NetSuite - Cash Sale Ship Group Collection v1.4.0 |
Yes | Shipping group details for the order |
| DiscountItem | NetSuite - ID v1.2.0 |
Yes | Identifier for the discount item applied |
| Partner | NetSuite - ID v1.2.0 |
Yes | Identifier for the partner associated with the transaction |
| Entity | NetSuite - Entity One Of v1.7.0 |
Yes | Entity details related to the customer |
| Account | NetSuite - ID v1.2.0 |
Yes | Identifier for the account associated with the customer |
| Terms | NetSuite - ID v1.2.0 |
Yes | Payment terms for the customer |
| ExpCost | NetSuite - Cash Sale Exp Cost Collection v1.5.0 |
Yes | Expected cost details for the transaction |
| BillAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | List of billing addresses associated with the customer |
| Currency | NetSuite - ID v1.2.0 |
Yes | Currency used for the customer's transactions |
| CardholderAuthentication | NetSuite - Ns Resource v1.6.0 |
Yes | Authentication details for cardholder transactions |
| PostingPeriod | NetSuite - ID v1.2.0 |
Yes | Posting period for the transaction |
| Item | NetSuite - Cash Sale Item Collection v1.5.0 |
Yes | Collection of items associated with the transaction |
| LeadSource | NetSuite - Ns Resource v1.6.0 |
Yes | Source of the lead for the customer |
| MessageSel | NetSuite - ID v1.2.0 |
Yes | Selected message identifier for the transaction |
| CouponCode | NetSuite - ID v1.2.0 |
Yes | Identifier for the coupon code used |
| ShippingAddress | NetSuite - Cash Sale Shipping Address v1.4.0 |
Yes | Shipping address details for the customer |
| CreatedFrom | NetSuite - Ns Resource v1.6.0 |
Yes | Resource from which the customer was created |
| ShipAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | List of shipping addresses associated with the customer |
| Class | NetSuite - ID v1.2.0 |
Yes | Class identifier for categorizing the customer |
| GiftCertRedemption | NetSuite - Cash Sale Gift Cert Redemption Collection v1.5.0 |
Yes | Details of gift certificate redemptions |
| Time | NetSuite - Cash Sale Time Collection v1.5.0 |
Yes | Time-related details for the transaction |
| SalesRep | NetSuite - Sales Rep One Of v1.5.0 |
Yes | Sales representative associated with the customer |
| Location | NetSuite - ID v1.2.0 |
Yes | Identifier for the location associated with the customer |
| AccountingBookDetail | NetSuite - Cash Sale Accounting Book Detail Collection v1.5.0 |
Yes | Accounting book details for the transaction |
| BillingAddress | NetSuite - Cash Sale Billing Address v1.4.0 |
Yes | Billing address details for the customer |
| Department | NetSuite - ID v1.2.0 |
Yes | Department identifier associated with the customer |
| Opportunity | NetSuite - ID v1.2.0 |
Yes | Identifier for the opportunity related to the customer |
| ShipMethod | NetSuite - ID v1.2.0 |
Yes | Shipping method identifier for the order |
| Job | NetSuite - Job One Of v1.4.0 |
Yes | Job identifier associated with the customer |
| CustomFields | JSON | Yes | Custom fields for additional customer data |
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 - Cash Sale 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 | Additional address line for the customer |
| City | String | Yes | Specifies the city of the customer address |
| Addr1 | String | Yes | Primary address line for the customer |
| LastModifiedDate | DateTime | Yes | Records the last date and time the customer was modified |
| Addr3 | String | Yes | Optional third address line for the customer |
| ExternalID | String | Yes | Unique identifier for the customer in external systems |
| AddrPhone | String | Yes | Phone number associated with the customer address |
| Addressee | String | Yes | Name of the person or entity to whom the address belongs |
| Attention | String | Yes | Additional attention line for the customer address |
| Override | Bool | Yes | Indicates whether to override existing customer data |
| State | String | Yes | Specifies the state or province of the customer address |
| AddrText | String | Yes | Full text representation of the customer address |
| RefName | String | Yes | Reference name for the customer, often used for display |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links related to the customer for integration |
| CustomFields | JSON | Yes | Stores custom fields associated with the customer |
NetSuite - Cash Sale 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 API for accessing 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 to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Cash Sale 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 - 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 - Cash Sale 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 - Cash Sale Time 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 - Cash Sale Gift Cert Redemption Collection (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides the link to the NetSuite instance for API calls |
| 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 to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of results |
| Items | NetSuite - Cash Sale Gift Cert Redemption Element v1.3.0 |
Yes | Contains the list of cash sale gift certificate redemption items |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the customer |
NetSuite - Cash Sale 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 | Holds any further address details |
| ExternalID | String | Yes | Unique identifier for the customer in external systems |
| AddrPhone | String | Yes | Stores the phone number associated with the customer address |
| Addressee | String | Yes | Names the individual or entity to whom the address belongs |
| Attention | String | Yes | Indicates the person or department to whom correspondence should be directed |
| 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 formatted text representation of the address |
| RefName | String | Yes | Contains a reference name for the customer |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Holds related links for the customer record |
| CustomFields | JSON | Yes | Stores additional custom data fields for the customer |
NetSuite - Cash Sale 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 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 whether there are more customer records to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Cash Sale 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 - Cash Sale 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 if there are more customer records available to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Cash Sale 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 - 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 - Cash Sale 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 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 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 - Cash Sale Ship Group Element v1.2.0 |
Yes | Contains the list of customer records retrieved from NetSuite |
| CustomFields | JSON | Yes | Holds additional custom field data associated with the customer records |
NetSuite - Cash Sale 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 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 to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of customer records |
| Items | NetSuite - Cash Sale Item Cost 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 - Undep Funds (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 user-defined fields related to the customer |
NetSuite - Payment Operation (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 associated with the customer |
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 - 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 - Cash Sale Accounting Book Detail Element (ver. 1.3.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the NetSuite instance for data retrieval |
| ExchangeRate | Double | Yes | Represents the currency exchange rate used in transactions |
| RefName | String | Yes | Contains the reference name for the customer record |
| AccountingBook | NetSuite - Ns Resource v1.6.0 |
Yes | Links to the accounting book associated with the customer |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary under which the customer is categorized |
| CustomFields | JSON | Yes | Stores additional custom fields related to the customer record |
NetSuite - Cash Sale Time Element (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the connection link to the NetSuite instance |
| 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 applied to the customer |
| Amount | Double | Yes | Specifies the total amount billed to the customer |
| Apply | Bool | Yes | Indicates whether the billing should be applied to the customer |
| Url | String | Yes | Provides a link to the customer's profile or related resources |
| RefName | String | Yes | Contains the reference name for the customer |
| Doc | NetSuite - ID v1.2.0 |
Yes | Represents the document ID associated with the customer |
| Location | NetSuite - ID v1.2.0 |
Yes | Identifies the location related to the customer |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Specifies the item associated with the customer transaction |
| Class | NetSuite - ID v1.2.0 |
Yes | Indicates the class category for the customer |
| Employee | NetSuite - ID v1.2.0 |
Yes | Represents the employee responsible for the customer account |
| Department | NetSuite - ID v1.2.0 |
Yes | Identifies the department associated with the customer |
| CustomFields | JSON | Yes | Contains additional custom fields related to the customer |
NetSuite - Cash Sale 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 - Cash Sale Item 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 |
| VsoeIsEstimate | Bool | Yes | Indicates if the line item is an estimate for VSOE purposes |
| 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 | Represents the quantity of items committed to the order |
| GiftCertRecipientName | String | Yes | Contains the name of the recipient for gift certificates |
| Options | String | Yes | Lists any additional options or configurations for the item |
| OqpBucket | String | Yes | Represents the order quantity pricing bucket |
| QuantityOnHand | Double | Yes | Indicates the available quantity of the item in stock |
| VsoeAmount | Double | Yes | Represents the VSOE amount for the line item |
| CostEstimateType | NetSuite - Cost Estimate Type v1.2.0 |
Yes | Specifies the type of cost estimate for the item |
| ItemSubtype | NetSuite - Item Subtype v1.2.0 |
Yes | Identifies the subtype of the item |
| VsoeAllocation | Double | Yes | Represents the allocation of VSOE revenue for the item |
| EstGrossProfit | Double | Yes | Indicates the estimated gross profit for the line item |
| MatrixType | String | Yes | Specifies the matrix type for the item |
| IsOpen | Bool | Yes | Indicates if the order line is currently open |
| EstGrossProfitPercent | Double | Yes | Represents the estimated gross profit percentage |
| Line | Integer | Yes | Specifies 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 is closed |
| Units | String | Yes | Specifies the unit of measure for the item |
| Rate | Double | Yes | Represents the rate charged for the item |
| 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 | Represents 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 order |
| Amount | Double | Yes | Represents the total amount for the line item |
| Quantity | Double | Yes | Indicates the quantity of the item ordered |
| InitOqpBucket | String | Yes | Represents the initial order quantity pricing bucket |
| GiftCertFrom | String | Yes | Contains the name of the sender for gift certificates |
| ProcessedByRevCommit | Bool | Yes | Indicates if the line item has been processed by revenue commitment |
| OrderLine | Integer | Yes | Specifies the order line number |
| ItemType | NetSuite - Item Type v1.4.0 |
Yes | Identifies the type of item being ordered |
| QuantityAvailable | Double | Yes | Indicates 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 revenue recognition recurrence type |
| LicenseCode | String | Yes | Contains the license code associated with the item |
| RefName | String | Yes | Provides a reference name for the item |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary associated with the order |
| InventoryDetail | NetSuite - Cash Sale Item Inventory Detail v1.2.0 |
Yes | Contains detailed inventory information for the item |
| ShipMethod | NetSuite - ID v1.2.0 |
Yes | Specifies the shipping method for the order |
| Price | NetSuite - ID v1.2.0 |
Yes | Represents the price associated with 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 | Identifies the specific item being ordered |
| OrderDoc | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the order document associated with the item |
| ShipAddress | NetSuite - Ns Resource v1.6.0 |
Yes | Contains the shipping address for the order |
| Location | NetSuite - ID v1.2.0 |
Yes | Identifies the location associated with the item |
| CustomFields | JSON | Yes | Contains any custom fields related to the item |
NetSuite - Cash Sale 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 for the 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 transaction is 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 |
| Location | NetSuite - ID v1.2.0 |
Yes | Identifies the location associated with the customer |
| Employee | NetSuite - ID v1.2.0 |
Yes | References the employee responsible for the customer |
| Doc | NetSuite - Ns Resource v1.6.0 |
Yes | Links to the document related to the customer transaction |
| Class | NetSuite - ID v1.2.0 |
Yes | Specifies the class categorization for the customer |
| Category | NetSuite - ID v1.2.0 |
Yes | Identifies the category associated with the customer |
| Department | NetSuite - ID v1.2.0 |
Yes | References the department linked to the customer |
| CustomFields | JSON | Yes | Contains any custom fields related to the customer record |
NetSuite - Cash Sale 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 | Specifies 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 - Cash Sale 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 rate schedule associated with the customer |
| Memo | String | Yes | Contains additional notes or comments about the customer |
| Options | String | Yes | Lists any special options related to the customer |
| Unit | String | Yes | Indicates the unit of measure for transactions |
| UnitDisp | String | Yes | Displays the unit in a user-friendly format |
| Line | Integer | Yes | Represents the line number in a 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 | Specifies the cost associated with the transaction |
| Apply | Bool | Yes | Indicates whether the transaction should be applied |
| Url | String | Yes | Provides a link to additional resources or documentation |
| ItemCostCount | String | Yes | Represents the count of items related to the cost |
| RefName | String | Yes | Contains the reference name for the customer |
| Department | NetSuite - ID v1.2.0 |
Yes | Identifies the department associated with the customer |
| Class | NetSuite - ID v1.2.0 |
Yes | Specifies the class categorizing the customer |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Represents the item associated with the transaction |
| Location | NetSuite - ID v1.2.0 |
Yes | Indicates the location related to the customer |
| Doc | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the document associated with the transaction |
| InventoryDetail | NetSuite - Cash Sale Item Cost Inventory Detail v1.2.0 |
Yes | Provides details about inventory related to the transaction |
| CustomFields | JSON | Yes | Contains any custom fields relevant to the customer |
NetSuite - Cash Sale Item Inventory Detail (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ItemDescription | String | Yes | Describes the item being sold or referenced in the transaction |
| Unit | String | Yes | Specifies the unit of measure for the item |
| Quantity | Double | Yes | Indicates the amount of the item being sold or referenced |
| 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 |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links related to the customer or transaction |
| 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 customer or transaction |
| ToLocation | NetSuite - ID v1.2.0 |
Yes | Specifies the destination location for the transaction |
| InventoryAssignment | NetSuite - Cash Sale Item Inventory Detail Inventory Assignment Collection v1.2.0 |
Yes | Details the inventory assignment for the item sold |
| 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 - Cash Sale Item Cost Inventory Detail (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ItemDescription | String | Yes | Describes the details of the item being sold or purchased |
| Unit | String | Yes | Specifies the unit of measurement for the item |
| Quantity | Double | Yes | Indicates the amount of the item being ordered or sold |
| 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 |
| ToLocation | NetSuite - ID v1.2.0 |
Yes | Indicates the destination location for the item |
| InventoryAssignment | NetSuite - Cash Sale Item Cost Inventory Detail Inventory Assignment Collection v1.2.0 |
Yes | Details the inventory assignment for the item sold |
| Location | NetSuite - ID v1.2.0 |
Yes | Identifies the location related to the customer |
| CustomFields | JSON | Yes | Holds additional custom data fields for the customer |
NetSuite - Cash Sale 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 the link to the NetSuite API for accessing 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 - Cash Sale 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 - Cash Sale 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 the link to the NetSuite instance for API calls |
| 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 - Cash Sale Item Cost Inventory Detail Inventory Assignment Element v1.2.0 |
Yes | Contains the list of customer records retrieved in the response |
| CustomFields | JSON | Yes | Holds any additional custom field data associated with the customer records |
NetSuite - Cash Sale 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 API |
| PackCarton | String | Yes | Identifies the carton used for packing items |
| Quantity | Double | Yes | Specifies the amount of items being processed |
| ExpirationDate | DateTime | Yes | Indicates when the item will expire |
| InventoryDetail | Integer | Yes | Provides details about the inventory item |
| 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 available quantity of the item |
| PickCarton | String | Yes | Identifies the carton designated for picking |
| RefName | String | Yes | Represents a reference name for the customer |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Describes the current status of the inventory |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Indicates the storage location of the item |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Refers to the inventory number issued to the customer |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Specifies the target inventory status for the item |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Indicates the destination bin for the item |
| CustomFields | JSON | Yes | Contains additional custom data related to the customer |
NetSuite - Cash Sale 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 | Specifies the carton identifier for packing |
| Quantity | Double | Yes | Indicates the amount of items being processed |
| ExpirationDate | DateTime | Yes | Denotes the date when the item expires |
| InventoryDetail | Integer | Yes | Provides detailed inventory information |
| ReceiptInventoryNumber | String | Yes | Identifies the inventory receipt number |
| InternalID | Integer | Yes | Unique identifier for the customer in NetSuite |
| QuantityAvailable | Double | Yes | Shows the available quantity of the item |
| PickCarton | String | Yes | Indicates the carton designated for picking |
| RefName | String | Yes | Represents a reference name for the customer |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Specifies the destination bin for inventory |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Identifies the inventory issue number |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the status of the inventory being transferred |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Represents the bin location for the inventory |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Describes the current status of the inventory item |
| CustomFields | JSON | Yes | Contains additional custom attributes for 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