Transform to Vendor Bill is a powerful action that simplifies your financial processes by converting vendor information directly into vendor bills within NetSuite. This functionality enhances your ability to manage vendor transactions efficiently, ensuring accurate billing and streamlined accounting practices. By automating this transformation, you reduce manual entry errors and save valuable time, allowing you to focus on more strategic tasks. Whether you're a small business or a large enterprise, this action helps you maintain clear financial records and improve your overall operational efficiency.
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 Vendor To Vendor Bill Request (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor record |
| VendorBill | NetSuite - Vendor Bill v1.7.0 |
No | Represents the vendor bill associated with the vendor |
NetSuite - Vendor Bill (ver. 1.7.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StartDate | DateTime | Yes | Indicates the start date of the vendor bill transaction |
| Received | Bool | Yes | Indicates whether the vendor bill has been received |
| BillAddr1 | String | Yes | The primary billing address line for the vendor |
| BillAddr2 | String | Yes | The secondary billing address line for the vendor |
| BillAddr3 | String | Yes | An optional third line for the billing address |
| CreatedDate | DateTime | Yes | The date when the vendor bill was created |
| ApprovalStatus | NetSuite - Approval Status v1.4.0 |
Yes | The current approval status of the vendor bill |
| PrevDate | DateTime | Yes | The previous date associated with the vendor bill |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | The custom form used for the vendor bill |
| ExternalID | String | Yes | A unique identifier for the vendor bill from an external system |
| ToBePrinted | Bool | Yes | Indicates if the vendor bill is pending printing |
| BillPhone | String | Yes | The phone number associated with the billing address |
| BillAttention | String | Yes | The name of the person to whom the bill is addressed |
| DiscountDate | DateTime | Yes | The date by which any discounts must be applied |
| ExchangeRate | Double | Yes | The exchange rate applicable to the vendor bill |
| BillZip | String | Yes | The ZIP code for the billing address |
| LandedCostMethod | NetSuite - Landed Cost Method v1.4.0 |
Yes | The method used to calculate landed costs for the bill |
| BillAddressee | String | Yes | The name of the addressee for the billing address |
| DueDate | DateTime | Yes | The date by which payment for the vendor bill is due |
| CreditLimit | Double | Yes | The credit limit assigned to the vendor |
| BillCity | String | Yes | The city for the billing address |
| TranDate | DateTime | Yes | The transaction date of the vendor bill |
| Memo | String | Yes | Additional notes or comments related to the vendor bill |
| BillCountry | NetSuite - Bill Country v1.4.0 |
Yes | The country associated with the billing address |
| Balance | Double | Yes | The outstanding balance on the vendor bill |
| ID | String | Yes | The unique identifier for the vendor bill |
| DocumentStatus | String | Yes | The current status of the vendor bill document |
| BillAddress | String | Yes | The complete billing address for the vendor |
| EndDate | DateTime | Yes | The end date of the vendor bill transaction |
| UserTotal | Double | Yes | The total amount calculated for the user |
| Status | NetSuite - Status v1.4.0 |
Yes | The current status of the vendor bill |
| DiscountAmount | Double | Yes | The total discount amount applicable to the vendor bill |
| BillState | String | Yes | The state for the billing address |
| BillOverride | String | Yes | Any overrides applied to the billing information |
| BillingAddress_text | String | Yes | A textual representation of the billing address |
| AvailableVendorCredit | Double | Yes | The amount of vendor credit available for use |
| Total | Double | Yes | The total amount of the vendor bill |
| TranID | String | Yes | The transaction ID associated with the vendor bill |
| LastModifiedDate | DateTime | Yes | The date when the vendor bill was last modified |
| PaymentHold | Bool | Yes | Indicates if payment for the vendor bill is on hold |
| RefName | String | Yes | A reference name associated with the vendor bill |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links related to the vendor bill for additional context |
| Item | NetSuite - Vendor Bill Item Collection v1.7.0 |
Yes | The items included in the vendor bill |
| Expense | NetSuite - Vendor Bill Expense Collection v1.7.0 |
Yes | The expenses associated with the vendor bill |
| Location | NetSuite - ID v1.2.0 |
Yes | The location related to the vendor bill |
| Class | NetSuite - ID v1.2.0 |
Yes | The class associated with the vendor bill |
| BillingAddress | NetSuite - Vendor Bill Billing Address v1.5.0 |
Yes | The structured billing address for the vendor |
| Currency | NetSuite - ID v1.2.0 |
Yes | The currency used for the vendor bill |
| Terms | NetSuite - ID v1.2.0 |
Yes | The payment terms associated with the vendor bill |
| BillAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | A list of billing addresses associated with the vendor |
| AccountingBookDetail | NetSuite - Vendor Bill Accounting Book Detail Collection v1.6.0 |
Yes | Details related to the accounting books for the vendor bill |
| PostingPeriod | NetSuite - ID v1.2.0 |
Yes | The accounting period for posting the vendor bill |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | The subsidiary associated with the vendor bill |
| Entity | NetSuite - Entity One Of v1.7.0 |
Yes | The entity related to the vendor bill |
| Department | NetSuite - ID v1.2.0 |
Yes | The department associated with the vendor bill |
| Account | NetSuite - ID v1.2.0 |
Yes | The account to which the vendor bill is posted |
| CustomFields | JSON | Yes | Custom fields related to the vendor bill for additional data |
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 - Vendor Bill Accounting Book Detail Collection (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the NetSuite API for vendor data access |
| TotalResults | Integer | Yes | Indicates the total number of vendor records retrieved |
| Count | Integer | Yes | Represents the number of vendor records in the current response |
| HasMore | Bool | Yes | Indicates if there are more vendor records available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor records |
| Items | NetSuite - Vendor Bill Accounting Book Detail Element v1.4.0 |
Yes | Contains the detailed vendor records retrieved from NetSuite |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the vendor records |
NetSuite - Vendor Bill Billing Address (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Zip | String | Yes | Represents the postal code of the vendor's address |
| Country | NetSuite - Country v1.4.0 |
Yes | Indicates the country where the vendor is located |
| Addr2 | String | Yes | Provides additional address information for the vendor |
| City | String | Yes | Specifies the city of the vendor's address |
| Addr1 | String | Yes | Contains the primary address line for the vendor |
| LastModifiedDate | DateTime | Yes | Records the last date and time the vendor information was modified |
| Addr3 | String | Yes | Offers further address details for the vendor |
| ExternalID | String | Yes | Serves as a unique identifier for the vendor in external systems |
| AddrPhone | String | Yes | Lists the phone number associated with the vendor's address |
| Addressee | String | Yes | Identifies the name of the person or entity to contact at the vendor |
| Attention | String | Yes | Specifies the name of the person to whom correspondence should be directed |
| Override | Bool | Yes | Indicates whether to override existing vendor information |
| State | String | Yes | Denotes the state or province of the vendor's address |
| AddrText | String | Yes | Provides a formatted text representation of the vendor's address |
| RefName | String | Yes | Contains a reference name for the vendor, useful for identification |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links to related resources or information about the vendor |
| CustomFields | JSON | Yes | Holds additional custom data fields specific to the vendor |
NetSuite - Vendor Bill Expense Collection (ver. 1.7.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 | Represents the total number of vendor records retrieved |
| Count | Integer | Yes | Indicates the number of vendor records in the current response |
| HasMore | Bool | Yes | Indicates if there are more vendor records available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor records |
| Items | NetSuite - Vendor Bill Expense Element v1.5.0 |
Yes | Contains the list of vendor records returned in the response |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the vendor records |
NetSuite - Vendor Bill Item Collection (ver. 1.7.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the specific NetSuite vendor record |
| TotalResults | Integer | Yes | Indicates the total number of vendor records retrieved |
| Count | Integer | Yes | Represents the number of vendor records in the current response |
| HasMore | Bool | Yes | Indicates if there are more vendor records available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor records |
| Items | NetSuite - Vendor Bill Item Element v1.5.0 |
Yes | Contains the list of vendor bill items associated with the vendor |
| CustomFields | JSON | Yes | Holds any custom fields related to the vendor record |
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 - Landed Cost Method (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor in NetSuite |
| RefName | String | Yes | The reference name of the vendor used in the connector |
| CustomFields | JSON | Yes | Additional custom fields related to the vendor information |
NetSuite - Approval Status (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor in NetSuite |
| RefName | String | Yes | The reference name of the vendor used in the connector |
| CustomFields | JSON | Yes | Additional custom attributes related to the vendor |
NetSuite - Vendor Bill Accounting Book Detail 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 |
| ExchangeRate | Double | Yes | Indicates the currency exchange rate for transactions |
| RefName | String | Yes | Provides a reference name for the vendor entry |
| AccountingBook | NetSuite - Ns Resource v1.6.0 |
Yes | Links to the accounting book associated with the vendor |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary to which the vendor belongs |
| CustomFields | JSON | Yes | Contains additional custom fields related to the vendor |
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 - Vendor Bill Expense Element (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the unique identifier for the vendor link in NetSuite |
| ScheduleType | String | Yes | Indicates the type of schedule for the vendor payment |
| AmortizStartDate | DateTime | Yes | Specifies the start date for amortization of the vendor payment |
| Memo | String | Yes | Contains additional notes or comments related to the vendor |
| AmortizationType | String | Yes | Defines the method of amortization for the vendor payment |
| OrderDoc | String | Yes | Refers to the document number associated with the vendor order |
| Line | Integer | Yes | Identifies the line number in the vendor order |
| AmortizationResidual | String | Yes | Indicates any remaining balance after amortization |
| Amount | Double | Yes | Represents the total amount associated with the vendor payment |
| IsBillable | Bool | Yes | Indicates whether the vendor payment is billable to a customer |
| OrderLine | String | Yes | Refers to the specific line item in the vendor order |
| AmortizationEndDate | DateTime | Yes | Specifies the end date for amortization of the vendor payment |
| RefName | String | Yes | Contains the reference name for the vendor transaction |
| Department | NetSuite - ID v1.2.0 |
Yes | Identifies the department associated with the vendor payment |
| Class | NetSuite - ID v1.2.0 |
Yes | Specifies the class categorization for the vendor payment |
| Location | NetSuite - ID v1.2.0 |
Yes | Indicates the location related to the vendor transaction |
| Account | NetSuite - ID v1.2.0 |
Yes | Refers to the account associated with the vendor payment |
| AmortizationSched | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the amortization schedule resource for the vendor |
| Category | NetSuite - ID v1.2.0 |
Yes | Identifies the category for the vendor payment |
| Customer | NetSuite - Customer One Of v1.5.0 |
Yes | Refers to the customer associated with the vendor transaction |
| CustomFields | JSON | Yes | Contains any custom fields related to the vendor payment |
NetSuite - Vendor Bill Item Element (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the link to the NetSuite instance for the vendor data |
| ScheduleType | String | Yes | Defines the type of schedule for vendor payments |
| AmortizStartDate | DateTime | Yes | Indicates the start date for amortization of expenses |
| RateSchedule | String | Yes | Specifies the rate schedule applicable to the vendor |
| Options | String | Yes | Contains additional options related to the vendor |
| OqpBucket | String | Yes | Represents the bucket for open quantity processing |
| ItemSubtype | NetSuite - Item Subtype v1.2.0 |
Yes | Identifies the subtype of items associated with the vendor |
| AmortizationType | String | Yes | Specifies the type of amortization for vendor expenses |
| BillVarianceStatus | NetSuite - Bill Variance Status v1.2.0 |
Yes | Indicates the status of any billing variances |
| IsVsoeBundle | String | Yes | Indicates whether the vendor is part of a VSOE bundle |
| MatrixType | String | Yes | Defines the type of matrix used for pricing or inventory |
| VendorName | String | Yes | The name of the vendor in the NetSuite system |
| DeferRevRec | Bool | Yes | Indicates if revenue recognition is deferred for the vendor |
| IsOpen | Bool | Yes | Indicates if the vendor bill is currently open |
| Line | Integer | Yes | Represents the line number in the vendor bill |
| AmortizationResidual | String | Yes | Indicates any residual amount related to amortization |
| Description | String | Yes | Provides a description of the vendor bill line item |
| IsClosed | Bool | Yes | Indicates if the vendor bill is closed |
| Units | String | Yes | Specifies the units of measure for the vendor items |
| Rate | Double | Yes | Represents the rate charged by the vendor |
| Marginal | Bool | Yes | Indicates if the vendor item is marginal |
| Linked | Bool | Yes | Indicates if the vendor bill is linked to another document |
| PrintItems | Bool | Yes | Specifies if items should be printed on the vendor bill |
| IsBillable | Bool | Yes | Indicates if the vendor bill is billable to a customer |
| Amount | Double | Yes | Represents the total amount for the vendor bill line |
| Quantity | Double | Yes | Specifies the quantity of items associated with the vendor |
| InitOqpBucket | String | Yes | Represents the initial bucket for open quantity processing |
| OrderLine | Integer | Yes | Indicates the order line number associated with the vendor |
| ItemType | NetSuite - Item Type v1.4.0 |
Yes | Specifies the type of item related to the vendor |
| LicenseCode | String | Yes | Represents the license code associated with the vendor |
| AmortizationEndDate | DateTime | Yes | Indicates the end date for amortization of expenses |
| RefName | String | Yes | Provides a reference name for the vendor bill |
| CatchUpPeriod | NetSuite - ID v1.2.0 |
Yes | Specifies the catch-up period for vendor billing |
| Location | NetSuite - ID v1.2.0 |
Yes | Indicates the location associated with the vendor |
| LandedCostCategory | NetSuite - ID v1.2.0 |
Yes | Specifies the landed cost category for the vendor items |
| Customer | NetSuite - Customer One Of v1.5.0 |
Yes | Identifies the customer associated with the vendor bill |
| AmortizationSched | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the amortization schedule for the vendor |
| Department | NetSuite - ID v1.2.0 |
Yes | Indicates the department associated with the vendor |
| Class | NetSuite - ID v1.2.0 |
Yes | Specifies the class for categorizing the vendor |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Identifies the item associated with the vendor bill |
| BillReceipts | NetSuite - Item Receipt Collection v1.2.0 |
Yes | Represents the collection of item receipts for the vendor |
| InventoryDetail | NetSuite - Vendor Bill Item Inventory Detail v1.3.0 |
Yes | Provides detailed inventory information for the vendor bill |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Indicates the subsidiary associated with the vendor |
| OrderDoc | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the order document related to the vendor |
| CustomFields | JSON | Yes | Contains custom fields related to the vendor bill |
NetSuite - Item One Of (ver. 1.3.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| InventoryItem | NetSuite - ID v1.2.0 |
Yes | Represents a stock item in NetSuite for inventory management |
| AssemblyItem | NetSuite - ID v1.2.0 |
Yes | Represents a product that is assembled from multiple components |
| KitItem | NetSuite - ID v1.2.0 |
Yes | Represents a packaged set of items sold together as a single unit |
| NsResource | NetSuite - Ns Resource v1.6.0 |
Yes | Represents a resource used in various transactions within NetSuite |
| DiscountItem | NetSuite - ID v1.2.0 |
Yes | Represents an item that provides a discount on transactions |
| MarkupItem | NetSuite - ID v1.2.0 |
Yes | Represents an item that adds a markup to the base price |
| SubtotalItem | NetSuite - ID v1.2.0 |
Yes | Represents the subtotal amount before taxes and discounts |
| DescriptionItem | NetSuite - ID v1.2.0 |
Yes | Represents an item that provides additional descriptions for transactions |
| PaymentItem | NetSuite - ID v1.2.0 |
Yes | Represents an item used to record payments in NetSuite |
| SalesTaxItem | NetSuite - ID v1.2.0 |
Yes | Represents an item that applies sales tax to transactions |
| ShipItem | NetSuite - ID v1.2.0 |
Yes | Represents an item related to shipping costs in transactions |
| DownloadItem | NetSuite - ID v1.2.0 |
Yes | Represents a digital product that can be downloaded |
| GiftCertificateItem | NetSuite - ID v1.2.0 |
Yes | Represents a gift certificate that can be redeemed for products or services |
| SubscriptionPlan | NetSuite - ID v1.2.0 |
Yes | Represents a plan for recurring billing for subscription services |
| NonInventorySaleItem | NetSuite - ID v1.2.0 |
Yes | Represents a sale item that is not tracked as inventory |
| NonInventoryResaleItem | NetSuite - ID v1.2.0 |
Yes | Represents a resale item that is not tracked as inventory |
| NonInventoryPurchaseItem | NetSuite - ID v1.2.0 |
Yes | Represents a purchase item that is not tracked as inventory |
| ServiceSaleItem | NetSuite - ID v1.2.0 |
Yes | Represents a service that is sold to customers |
| ServiceResaleItem | NetSuite - ID v1.2.0 |
Yes | Represents a service that is resold to customers |
| ServicePurchaseItem | NetSuite - ID v1.2.0 |
Yes | Represents a service that is purchased from a vendor |
| OtherChargeSaleItem | NetSuite - ID v1.2.0 |
Yes | Represents other charges that are applied to sales transactions |
| OtherChargeResaleItem | NetSuite - ID v1.2.0 |
Yes | Represents other charges that are applied to resale transactions |
| OtherChargePurchaseItem | NetSuite - ID v1.2.0 |
Yes | Represents other charges that are applied to purchase transactions |
NetSuite - Customer One Of (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Customer | NetSuite - ID v1.2.0 |
Yes | Unique identifier for a customer in NetSuite |
| Partner | NetSuite - ID v1.2.0 |
Yes | Unique identifier for a partner in NetSuite |
| Vendor | NetSuite - ID v1.2.0 |
Yes | Unique identifier for a vendor in NetSuite |
| NsResource | NetSuite - Ns Resource v1.6.0 |
Yes | Identifier for a resource in NetSuite |
| Employee | NetSuite - ID v1.2.0 |
Yes | Unique identifier for an employee in NetSuite |
| Contact | NetSuite - ID v1.2.0 |
Yes | Unique identifier for a contact in NetSuite |
NetSuite - Vendor Bill Item Inventory Detail (ver. 1.3.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ItemDescription | String | Yes | Describes the item being purchased or billed |
| Unit | String | Yes | Specifies the unit of measurement for the item |
| Quantity | Double | Yes | Indicates the number of items being purchased |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Identifies the custom form used for the transaction |
| ExternalID | String | Yes | Provides a unique identifier for external systems |
| RefName | String | Yes | Represents the reference name for the vendor |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links related to the vendor or transaction |
| ToLocation | NetSuite - ID v1.2.0 |
Yes | Specifies the destination location for the items |
| Location | NetSuite - ID v1.2.0 |
Yes | Indicates the location from which the items are sourced |
| Item | NetSuite - Item One Of v1.3.0 |
Yes | Refers to the specific item being billed or purchased |
| InventoryAssignment | NetSuite - Vendor Bill Item Inventory Detail Inventory Assignment Collection v1.2.0 |
Yes | Details the inventory assignments related to the vendor bill |
| CustomFields | JSON | Yes | Holds additional custom data fields for the vendor transaction |
NetSuite - Item Receipt Collection (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| TotalResults | Integer | Yes | Indicates the total number of vendor records available in the response |
| Items | NetSuite - ID v1.2.0 |
Yes | Contains the list of vendor records retrieved from NetSuite |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides links to related resources or actions for the vendor records |
| Count | Integer | Yes | Represents the number of vendor records returned in the current response |
| HasMore | Bool | Yes | Indicates whether there are more vendor records available beyond the current response |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor records to retrieve |
| CustomFields | JSON | Yes | Contains any additional custom fields associated with the vendor records |
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 - Vendor Bill 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 vendor data source |
| TotalResults | Integer | Yes | Indicates the total number of vendor records retrieved |
| Count | Integer | Yes | Represents the number of vendor records in the current response |
| HasMore | Bool | Yes | Indicates whether there are more vendor records available |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor records |
| Items | NetSuite - Vendor Bill Item Inventory Detail Inventory Assignment Element v1.2.0 |
Yes | Contains the detailed list of vendor records retrieved |
| CustomFields | JSON | Yes | Holds any additional custom field data associated with the vendors |
NetSuite - Vendor Bill 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 vendor record |
| PackCarton | String | Yes | Specifies the carton packaging details for the vendor |
| Quantity | Double | Yes | Indicates the quantity of items associated with the vendor |
| ExpirationDate | DateTime | Yes | Defines the expiration date for the vendor's inventory |
| InventoryDetail | Integer | Yes | Provides detailed inventory information for the vendor |
| ReceiptInventoryNumber | String | Yes | Contains the inventory receipt number for tracking |
| InternalID | Integer | Yes | Unique identifier for the vendor within NetSuite |
| QuantityAvailable | Double | Yes | Shows the available quantity of items from the vendor |
| PickCarton | String | Yes | Identifies the carton designated for picking items |
| RefName | String | Yes | Holds a reference name for the vendor for easy identification |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the target inventory status for the vendor's items |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the current inventory status of the vendor's items |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Specifies the target bin number for inventory placement |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Contains the inventory issue number for tracking purposes |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Identifies the bin number where the vendor's items are stored |
| CustomFields | JSON | Yes | Stores additional custom fields related to the vendor |
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