Search

Page tree
Skip to end of metadata
Go to start of metadata


This page explains which are the Push and Pull methods supported by NetSuite connector. Push are the methods where interworks.cloud platform sends information to NetSuite and pull are the methods where we get information from NetSuite. For each method the data transformation schema is explained.


PushPull

CreateUpdateDeleteCreateUpdate
Account


Invoices




Products




Payments




Properties Mappings


Account Entity

For BSS Account entities we support both push and pull methods.


Below table presents property mapping between BSS Account entity and NetSuite Customer entity

Account (BSS entity)Customer (NetSuite entity)

ServerVariable
Subsidiary ID that will be set for each tenant

Subsidiary
"Customer"RecordType

Account.Name
Depending on the ServerVariable
CustomerType (Individual or Company)

CompanyName or
FirstName+LastName
Account.Parent.IntegrationIdParent
Account.NameEntityId
Account.PhonePhone
Account.FaxFax
Account.CorpEmailEmail
Lookup value
Account.Type.IntegrationId
Category
Lookup value
Account.Currency.IntegationId
Currency
Account.JobTitle
Account.WebsiteUrl
Account.CreatedDateStartDate
Account.AddressesAddressbook

“F” (false) or “T” (true)
depending on the ServerVariable
CustomerType (Individual or Company)

isPerson


Product Entity

For BSS Product entities we support only push method.


Below table presents property mapping between BSS Product entity and NetSuite Item entity

Product (BSS entity)Item (NetSuite entity)

ServerVariable
Subsidiary ID that will be set for each tenant

Subsidiary
"ServiceItem"RecordType
Product.NameDisplayName
Product.NameItemId
ServerVariable TaxableId or NonTaxableId depending on the value of Product.IsTaxableTaxSchedule
Product.FullDescription if exists, otherwise Product.NameSalesDescription
Lookup value
Product.ProductType.IntegrationId
Class


Invoice Entity

For BSS Invoice entities we support only push method.


Below table presents property mapping between BSS Invoice entity and NetSuite Invoice entity

Invoice (BSS entity)Invoice (NetSuite entity)

ServerVariable
Subsidiary ID that will be set for each tenant

Subsidiary
"Invoice"RecordType
Invoice.BillingAccount.IntegrationIdBillingAccount
Invoice.InvoiceDateCreatedDate

ServerVariable invoiceCustomForm
The id of the standar Custom Form for invoices

CustomForm

ServerVariable InvoiceCustomOrderType
The id of the default Order Type for the Invoices.

Custbod_order_type
Invoice.Account.IntegrationIdCustomer
Invoice.Account.IntegrationIdEndUser
Invoice.Account.IntegrationIdEntityId
Invoice.Account.IntegrationIdCustoBody_end_user

ServerVariable, DiscountType
The ID of the discount item for fixed discount(Coupon)

DiscountItem

Sum of all  invoiceItem.finalPrice
(Only for items that define a discount and not an actual product)

DiscountRate


Invoice Item Entity

For BSS Invoice Ites entities are synced during Invoice synchronization and are added as items in the invoice.


Below table presents property mapping between BSS Invoice Items entity and NetSuite Invoice item lines

Invoice Items (BSS entity)Invoice item line (NetSuite entity)
InvoiceItems.Product.IntegrationIdItemList.Item
InvoiceItems.QuantityItemList.Quantity
InvoiceItems.FinalPrice *
InvoiceItems.Quantity
ItemList.Amount
InvoiceItems.ItemNameItemList.Description
InvoiceItems.Product.isTaxableitemList.isTaxable


Payment Entity

For BSS Payments entities we support only push method.


Below table presents property mapping between BSS Payment entity and NetSuite Customer payment entity

Payment (BSS entity)Customer Payment
(NetSuite entity)

ServerVariable
Subsidiary ID that will be set for each tenant

Subsidiary
CustomerPaymentRecordType
Payment.Account.IntegrationIdCustomer
Lookup value
Payment.Type.IntegrationId
Class
Lookup value
Payment.Account.Currency.IntegrationId
Currency
Payment.AmountPayment
Lookup value
Payment.Method.IntegrationId
PaymentMethod
Payment.PaymentDateTranDae
"F" (False)UndepFunds
(Set to TRUE if entering a payment that will be deposited to a bank account later. If set to FALSE, set an account in the account field.)

Payment Invoices
Payment invoice entities are automatically applied to the appropriate invoice for the current payment.
Depending on the payment amount the invoice will be updated to PAID IN FULL or will remain OPEN with the remaining amount updated.

  • No labels