JDBC Driver for NetSuite

Build 22.0.8462

vendor

The vendor table.

Columns

Name Type References Description
id [KEY] Integer Internal ID
accountnumber String Account Number
altemail String Alt. Email
altname String Vendor
balance Decimal Balance (Base)
balanceprimary Decimal Balance
billpay Boolean Enable Online Bill Pay
category String Category
comments String Comments
companyname String Company Name
contact String Primary Contact
contactlist String Contacts
creditlimit Decimal Credit Limit
currency String Currency
datecreated Date Date Created
defaultbankaccount String Default Bank Account
defaultbillingaddress String Default Billing Address
defaultshippingaddress String Default Shipping Address
duplicate Boolean Duplicate
email String Vendor Email
emailpreference String Email Preference
emailtransactions Boolean Email Transactions
entityid String Entity ID
entitynumber Integer Number
entitytitle String Vendor ID
expenseaccount String Default Expense Account
externalid String External ID
faxtransactions Boolean Fax Transactions
firstname String First Name
giveaccess Boolean Login Access
globalsubscriptionstatus String Global Subscription Status
incoterm String Incoterm
isinactive Boolean Vendor is Inactive
isjobresourcevend Boolean Job Resource
isperson Boolean Is Individual
laborcost Decimal Labor Cost
lastmodifieddate Date Last Modified Date
lastname String Last Name
legalname String Legal Name
middlename String Middle Name
payablesaccount String -No label-
phoneticname String Furigana
predconfidence Double Predicted Risk Confidence
predicteddays Integer Predicted Days Late/Early
printoncheckas String Print on Check As
printtransactions Boolean Print Transactions
purchaseorderamount Double Vendor Bill - Purchase Order Amount Tolerance
purchaseorderquantity Double Vendor Bill - Purchase Order Quantity Tolerance
purchaseorderquantitydiff Double Vendor Bill - Purchase Order Quantity Difference
receiptamount Double Vendor Bill - Item Receipt Amount Tolerance
receiptquantity Double Vendor Bill - Item Receipt Quantity Tolerance
receiptquantitydiff Double Vendor Bill - Item Receipt Quantity Difference
rolesforsearch String Roles
salutation String Mr./Ms...
subsidiaryedition String Edition
terms String Terms
timeapprover String Time Approver
title String Job Title
unbilledorders Decimal Unbilled Orders (Base)
unbilledordersprimary Decimal Unbilled Orders

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462