Vendors

The Entity Fields custom field is available for the Vendors table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
accountnumber	VARCHAR2	99					Account number
altemail	VARCHAR2	254					Alt email
altphone	VARCHAR2	100					Alt phone
billaddress	VARCHAR2	999					Billing address
billing_class_id	NUMBER		22	0			Billing Class ID
city	VARCHAR2	50					City
comments	VARCHAR2	4000					Comments
companyname	VARCHAR2	83					Company name
country	VARCHAR2	50					Country
create_date	TIMESTAMP						Create date (GMT)
creditlimit	NUMBER		20	2			Credit limit
currency_id	NUMBER		22	0			Currency ID
date_last_modified	TIMESTAMP						Date last modified
email	VARCHAR2	254					Email
expense_account_id	NUMBER		22	0			Expense account ID
fax	VARCHAR2	100					Fax
full_name	VARCHAR2	1800					Full name
home_phone	VARCHAR2	100					Home phone
incoterm	VARCHAR2	100					International commercial term (Incoterm)
is_person	VARCHAR2	3					Type (company or individual)
is1099eligible	VARCHAR2	3					1099 eligible
isemailhtml	VARCHAR2	3					Email as HTML
isemailpdf	VARCHAR2	3					Email as PDF
isinactive	VARCHAR2	3					Vendor is inactive
labor_cost	NUMBER		22	0			Cost of labor
last_modified_date	TIMESTAMP						Last modified date (GMT)
line1	VARCHAR2	150					Address line 1
line2	VARCHAR2	150					Address line 2
line3	VARCHAR2	150					Address line 3
loginaccess	VARCHAR2	3					Login access
mobile_phone	VARCHAR2	100					Mobile phone
name	VARCHAR2	83					Name
openbalance	NUMBER		22	0			Vendor's current accounts payable balance in base currency due
openbalance_foreign	NUMBER		22	0			Vendor's current accounts payable balance in foreign currency due
payables_account_id	NUMBER		22	0			Default account payables account for this vendor
payment_terms_id	NUMBER		22	0			Payment terms ID
phone	VARCHAR2	100					Phone
printoncheckas	VARCHAR2	83					Print on checks as
purchaseorderamount	NUMBER		20	2			Purchase order amount
purchaseorderquantity	NUMBER		18	8			Purchase order quantity
purchaseorderquantitydiff	NUMBER		18	8			Purchase order quantity difference
receiptamount	NUMBER		20	2			Receipt amount
receiptquantity	NUMBER		18	8			Receipt quantity
receiptquantitydiff	NUMBER		18	8			Receipt quantity difference
represents_subsidiary_id	NUMBER		22	0	subsidiary_id	Subsidiaries
shipaddress	VARCHAR2	999					Shipping address
state	VARCHAR2	50					Province/state
subsidiary	NUMBER		22	0	subsidiary_id	Subsidiaries	Subsidiary
taxidnum	VARCHAR2	25					Tax ID
unbilled_orders	NUMBER		22	0			Total amount of orders unbilled in base currency
unbilled_orders_foreign	NUMBER		22	0			Total amount of orders unbilled in foreign currency
url	VARCHAR2	100					URL
vendor_extid	VARCHAR2	255					Vendor external ID
vendor_id	NUMBER		22	0			Vendor ID
vendor_type_id	NUMBER		22	0	vendor_type_id	Vendor_types	Vendor type ID. Note: On the vendor record this column displays as a Category. "Type" is used for the entity type on the Vendor Form. The column "vendor_category_id" does not exist for the Connect Service.
zipcode	VARCHAR2	36					Zip code

Primary key

PK Column Name
vendor_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
vendors_subsidiaries_fk	subsidiary	Subsidiaries	subsidiary_id	1
vendors_subsidiaries_fk_2	represents_subsidiary_id	Subsidiaries	subsidiary_id	1
vendors_vendor_types_fk	vendor_type_id	Vendor_types	vendor_type_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Vendor_subsidiary_map_vendors_fk	vendor_id	Vendor_subsidiary_map	vendor_id	1