BizTalk Adapter for NetSuite

Build 20.0.7606


The customer table.


Name Type References Description
entityid [KEY] String Entity ID
thirdpartyacct String 3rd Party Billing Account Number
thirdpartycarrier String 3rd Party Billing Carrier
thirdpartycountry String 3rd Party Billing Country
thirdpartyzipcode String 3rd Party Billing Zip
accountnumber String Account
alcoholrecipienttype String Alcohol Recipient Type
altemail String Alt. Email
assignedwebsite String Assigned Web Site
balancesearch Decimal Balance
billingratecard String Billing Rate Card
billingschedule String Billing Schedule
billingtransactiontype String Billing Transaction Type
isbudgetapproved Boolean Budget Approved
buyingreason String Buying Reason
buyingtimeframe String Buying Time Frame
campaignevent String Campaign Event
shippingcarrier String Carrier
category String Category
clickstream String Click-Stream (1st Visit)
comments String Comments
companyname String Company Name
consolbalancesearch Decimal Consolidated Balance
consoldaysoverduesearch Integer Consolidated Days Overdue
consoloverduebalancesearch Decimal Consolidated Overdue Balance
consolunbilledorderssearch Decimal Consolidated Unbilled Orders
contactlist String Contacts
creditholdoverride String Credit Hold
creditlimit Decimal Credit Limit
currency String Currency
altname String Customer
entitytitle String Customer ID
datecreated Date Date Created
defaultbankaccount String Default Bank Account
defaultbillingaddress String Default Billing Address
defaultorderpriority Double Default Order Priority
receivablesaccount String Default Receivables Account
defaultshippingaddress String Default Shipping Address
duplicate Boolean Duplicate
email String Email
emailpreference String Email Preference
emailtransactions Boolean Email Transactions
billpay Boolean Enable Online Bill Pay
enddate Date End Date
estimatedbudget Decimal Estimated Budget
externalid String External ID
faxtransactions Boolean Fax Transactions
firstname String First Name
firstsaledate Date First Sale Date
firstorderdate Date First Sales Order Date
firstvisit Date First Visit
phoneticname String Furigana
globalsubscriptionstatus String Global Subscription Status
isinactive Boolean Inactive
id Integer Internal ID
isperson Boolean Is Individual
title String Job Title
lastmodifieddate Date Last Modified Date
lastname String Last Name
lastpagevisited String Last Page Visited
lastsaledate Date Last Sales Date
lastorderdate Date Last Sales Order Date
lastvisit Date Last Visit
leadsource String Lead Source
giveaccess Boolean Login Access
middlename String Middle Name
salutation String Mr./Ms...
negativenumberformat String Negative Number Format
entitynumber Integer Number
numberformat String Number Format
visits Integer Number of Visits
oncredithold Boolean On Credit Hold
overduebalancesearch Decimal Overdue
parent String Parent
partner String Partner
prefccprocessor String Preferred Payment Processing Profile
pricelevel String Price Level
contact String Primary Contact
printoncheckas String Print on Check As
printtransactions Boolean Print Transactions
probability Double Probability
referrer String Referrer (1st Visit)
reminderdays Integer Reminder Days
resalenumber String Resale Number
salesreadiness String Sales Readiness
salesrep String Sales Rep
keywords String Search Engine Keywords (1st Visit)
shipcomplete Boolean Ship Complete
shippingitem String Shipping Item
sourcewebsite String Source Web Site
searchstage String Stage
startdate Date Start Date
entitystatus String Status
terms String Terms
territory String Territory
unbilledorderssearch Decimal Unbilled Orders

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7606