Vendor

Internal ID: vendor

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
accountnumber	text	true	Account	false
altemail	email	true	Alt. Email	false
altphone	phone	true	Alt. Phone	false
autoname	checkbox	false	Auto	false
balance	currency	false	Balance	false	This is a read-only calculated field that returns the vendor's current accounts payable balance. The balance field on the customer is only returned in search if you set the BodyFieldsOnly flag to false.
balanceprimary	currency	false	Balance	false
bcn	text	false	Business Number	false	Enter the 15-digit registration number that identifies this vendor as a client of the Canada Customs and Revenue Agency (CCRA).
billaddr1	text	false		false
billaddr2	text	false		false
billaddr3	text	false		false
billcity	text	false		false
billcountry	text	false		false
billpay	checkbox	false	Enable Online Bill Pay	false
billstate	text	false		false
billzip	text	false		false
category	select	true	Category	false	References a value in a user defined list at Setup > Accounting > Setup Tasks > Accounting Lists > Vendor Categories.
comments	textarea	true	Comments	false	Enter any other information you wish to track for this vendor.
companyname	text	true	Company Name	false
contact	select	false	Primary Contact	false
creditlimit	poscurrency	true	Credit Limit	false
currency	select	false	Primary Currency	true	References a value in a user-defined list at Lists > Accounting > Currencies. This value sets the currency that all transactions involving this vendor are conducted in. If defaults are OFF, this field is required. Can only be set if the multicurrency feature is enabled?
customform	select	false	Custom Form	true
datecreated	datetime	false	Date Created	false
defaultaddress	address	false	Address	false
defaultbankaccount	select	false	Bank Account	false
email	email	false	Email	false	Sets the email address for the vendor. If giveAccess is also set to true this is the email used by the customer for login.
emailpreference	select	true	Email Preference	false
emailtransactions	checkbox	true	Email	false
entityid	text	true	Vendor ID	true
expenseaccount	select	false	Default Expense Account	false
externalid	text	false	ExternalId	false
fax	phone	true	Fax	false	Sets the fax number for the vendor.
faxtransactions	checkbox	true	Fax	false
firstname	text	false	Name	false
giveaccess	checkbox	false	Give Access	false
globalsubscriptionstatus	select	false	Global Subscription Status	false
homephone	phone	true	Home Phone	false
image	select	false	Image	false	References an image file that has already been uploaded to the account.
is1099eligible	checkbox	true	1099 Eligible	false
isinactive	checkbox	true	Inactive	false
isjobresourcevend	checkbox	true	Project Resource	false
isperson	radio	true	Company	false
laborcost	currency	true	Labor Cost	false
lastmodifieddate	datetime	false	Last Modified Date	false
lastname	text	false		false
legalname	text	false	Legal Name	false
middlename	text	false		false
mobilephone	phone	true	Mobile Phone	false
openingbalance	currency	false	Opening Balance	false
openingbalanceaccount	select	false	Opening Balance Account	false
openingbalancedate	date	false	Opening Balance Date	false
otherrelationships	select	false	Other Relationships	false
parent	integer	false	Parent	false
payablesaccount	select	false	Default Payables Account	false
phone	phone	true	Phone	false
phoneticname	text	false	Furigana	false
printoncheckas	text	false	Print on Check As	false
printtransactions	checkbox	true	Print	false
representingsubsidiary	select	false	Represents Subsidiary	false
requirepwdchange	checkbox	false	Require Password Change On Next Login	false
salutation	text	true	Mr./Ms...	false
sendemail	checkbox	false	Send Notification Email	false
strength	text	false	Password Strength	false
subsidiary	select	false	Subsidiary	true	Select the subsidiary to associate with this vendor. You cannot enter transactions for this vendor unless a subsidiary is assigned.   If you select this vendor on a transaction, the transaction is associated with this subsidiary. The vendor is able to access only information associated with this subsidiary.   Note: Once a transaction has posted for the vendor, you are not able to change the subsidiary selected on the vendor record.
subsidiaryedition	text	false	Edition	false
taxfractionunit	select	false	Tax Rounding Precision	false
taxidnum	text	true	Tax ID	false
taxitem	select	false	Tax Code	false
taxrounding	select	false	Tax Rounding Method	false
tegatamaturity	integer	false	Tegata Maturity Date	false
terms	select	true	Terms	false	References a value in a user-defined list at Setup > Accounting > Setup Tasks > Accounting Lists > Term and sets the standard discount terms for this Vendor�s invoices.
title	text	false	Job Title	false	Only available when isPerson is set to TRUE.
unbilledorders	currency	false	Unbilled Orders	false
unbilledordersprimary	currency	false	Unbilled Orders	false
unsubscribe	select	false	Unsubscribe from Campaigns	false
url	url	true	Web Address	false	Only available when isPerson is set to FALSE.
vatregnumber	text	false	Tax Reg. Number	false
workcalendar	select	true	Work Calendar	true

Sublists

addressbook - Address Book

Internal ID	Type	Label	Required
addr1	text	Address 1	false
addr2	text	Address 2	false
addr3	text		false
addressee	text	Addressee	false
addressid	text		false
addrtext	address	Address	false
attention	text	Attention	false
city	text	City	false
country	select	Country	false
defaultbilling	checkbox	Default Billing	false
defaultshipping	checkbox	Default Shipping	false
displaystate	text	State/Province	false
id	integer	ID	false
internalid	integer		false
label	text	Label	false
override	checkbox	Override	false
phone	phone	Phone	false
state	text	State/Province	false
zip	text	Zip	false

currency - Currencies

Internal ID	Type	Label	Required
balance	currency	Balance	false
currency	select	Currency	true
unbilledorders	currency	Unbilled Orders	false

Tabs

Name	Label
access	Access
address	Address
commission	Commission
custom	Custom
financial	Financial
general	General
info	Info
marketing	Marketing
workflow	Workflow

Search Joins

Join ID	Join Description	Actual Join Name
campaignresponse	Campaign Response	Campaign
contact	Contact	Contact
contactprimary	Contact (Primary)	Contact
messages	Messages	Message
messagesfrom	Messages From	Message
messagesto	Messages To	Message

Search Filters

Internal ID	Type	Label
accountnumber	text	Account
address	textarea	Address
addressee	text	Addressee
addresslabel	text	Address Label
addressphone	phone	Address Phone
attention	text	Attention
balance	currency	Balance
billaddress	textarea	Billing Address
category	select	Category
city	text	City
comments	textarea	Comments
contact	text	Contact
country	select	Country
county	text	County/State
creditlimit	currency	Credit Limit
currency	select	Currency
currentexchangerate	currency	Current Currency Exchange Rate
datecreated	datetime	Date Created
eligibleforcommission	checkbox	Eligible For Commission
email	text	Email
emailpreference	select	Email Preference
emailtransactions	checkbox	Email Transactions
entityid	text	Name/ID
expenseaccount	select	Default Expense Account
externalid	select	External ID
externalidstring	text	External ID (Text)
fax	phone	Fax
faxtransactions	checkbox	Fax Transactions
firstname	text	First Name
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
fxbalance	currency	Balance (Foreign Currency)
fxunbilledorders	currency	Unbilled Orders (Foreign Currency)
giveaccess	checkbox	Login Access
globalsubscriptionstatus	select	Global Subscription Status
group	multiselect	Group
hasduplicates	checkbox	Duplicate
image	image	Image
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
is1099eligible	checkbox	1099 Eligible
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isinactive	checkbox	Inactive
isjobresourcevend	checkbox	Is Job Resource
isperson	checkbox	Is Individual
laborcost	currency	Labor Cost
language	select	Language
lastmodifieddate	datetime	Last Modified
lastname	text	Last Name
level	select	Level
middlename	text	Middle Name
otherrelationships	multiselect	Other Relationships
payablesaccount	select	Default Payables Account
pec	text	PEC
permission	select	Permission
phone	phone	Phone
phoneticname	text	Phonetic Name
printtransactions	checkbox	Print Transactions
representingsubsidiary	select	Represents Subsidiary
salutation	text	Mr./Mrs...
shipaddress	textarea	Shipping Address
state	select	State/Province
subsidiary	select	Subsidiary
taxidnum	text	Tax ID
title	text	Job Title
type	select	Entity Type
unbilledorders	currency	Unbilled Orders
url	url	Web Address
vatregnumber	text	Tax Number
workcalendar	select	Work Calendar
zipcode	text	Zip

Search Columns

Internal ID	Type	Label
accountnumber	text	Account
address	text	Address
address1	text	Address 1
address2	text	Address 2
address3	text	Address 3
addressee	text	Addressee
addressinternalid	text	Address Internal ID
addresslabel	text	Address Label
addressphone	text	Address Phone
altcontact	text	Alt. Contact
altemail	email	Alt. Email
altname	text	Name
altphone	phone	Office Phone
attention	text	Attention
balance	currency	Balance
billaddress	text	Billing Address
billaddress1	text	Billing Address 1
billaddress2	text	Billing Address 2
billaddress3	text	Billing Address 3
billaddressee	text	Billing Addressee
billattention	text	Billing Attention
billcity	text	Billing City
billcountry	select	Billing Country
billcountrycode	text	Billing Country Code
billphone	text	Billing Phone
billstate	select	Billing State/Province
billzipcode	text	Billing Zip
category	select	Category
city	text	City
comments	text	Comments
companyname	text	Company Name
contact	select	Primary Contact
country	select	Country
countrycode	text	Country Code
creditlimit	currency	Credit Limit
currency	select	Currency
currentexchangerate	float	Current Currency Exchange Rate
datecreated	datetime	Date Created
eligibleforcommission	checkbox	Eligible for Commission
email	email	Email
emailpreference	select	Email Preference
emailtransactions	checkbox	Email Transactions
entityid	text	Name
entitynumber	integer	Number
expenseaccount	select	Default Expense Account
externalid	select	External ID
fax	text	Fax
faxtransactions	checkbox	Fax Transactions
firstname	text	First Name
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
fxbalance	currency	Balance (Foreign Currency)
fxunbilledorders	currency	Unbilled Orders (Foreign Currency)
giveaccess	checkbox	Login Access
globalsubscriptionstatus	select	Global Subscription Status
hasduplicates	checkbox	Duplicate
homephone	phone	Home Phone
image	select	Image
internalid	select	Internal ID
is1099eligible	checkbox	1099 Eligible
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isinactive	checkbox	Inactive
isjobresourcevend	checkbox	Job Resource
isperson	checkbox	Is Individual
laborcost	currency	Labor Cost
language	select	Language
lastmodifieddate	datetime	Last Modified
lastname	text	Last Name
lastviewed	datetime	Last Viewed
level	select	Level
middlename	text	Middle Name
mobilephone	phone	Mobile Phone
payablesaccount	select	Default Payables Account
pec	text	PEC
permission	select	Permission
phone	phone	Phone
phoneticname	text	Phonetic Name
printoncheckas	text	Print As
printtransactions	checkbox	Print Transactions
representingsubsidiary	select	Represents Subsidiary
salutation	text	Mr./Mrs...
shipaddress	text	Shipping Address
shipaddress1	text	Shipping Address 1
shipaddress2	text	Shipping Address 2
shipaddress3	text	Shipping Address 3
shipaddressee	text	Shipping Addressee
shipattention	text	Shipping Attention
shipcity	text	Shipping City
shipcountry	select	Shipping Country
shipcountrycode	text	Shipping Country Code
shipphone	text	Shipping Phone
shipstate	text	Shipping State/Province
shipzip	text	Shipping Zip
state	select	State/Province
statedisplayname	select	State/Province Display Name
subscription	select	Subscription
subscriptiondate	datetime	Subscription Date
subscriptionstatus	checkbox	Subscription Status
subsidiary	select	Subsidiary
subsidiarynohierarchy	select	Subsidiary (no hierarchy)
taxidnum	text	Tax ID
terms	select	Terms
title	text	Job Title
type	select	Type
unbilledorders	currency	Unbilled Orders
url	text	Web Address
vatregnumber	text	Tax Number
workcalendar	select	Work Calendar
zipcode	text	Zip Code

Transform Types

Target Record Type	Field Defaults
purchaseorder	customform
vendorbill	customform,entity,poids
vendorpayment	customform