relationship

Type: table

Columns

Column	Type	Attributes	Description
accountnbr	varchar
acknowledgementprintscriptrowid	int
allowbackorder	tinyint
apaccountrowid	int
applycreditlimit	tinyint
araccountrowid	int
box1099rowid	int
companyname	varchar
companyrowid	int
competitortypelistitemrowid	int
creditbalance	decimal
creditlimitamount	decimal
currencyratetyperowid	int
currencyrowid	int
customertypelistitemrowid	int
deliverymethod	varchar
departmentrowid	int
description	varchar
electronicaccountnbr	varchar
electronicbankname	varchar
electronicbillpayment	tinyint
electronicroutingnbr	varchar
employeetypelistitemrowid	int
expenseaccountrowid	int
expenseclassrowid	int
financecharge	tinyint
firstactivitydate	datetime
fobrowid	int
holdpayment	tinyint
invoicedeliverymethodlistitemrowid	int
invoiceformatrowid	int
invoiceprintscriptrowid	int
isactive	tinyint
iscompetitor	tinyint
iscustomer	tinyint
isemployee	tinyint
isindividual	tinyint
ismanufacturer	tinyint
isonetime	tinyint
isothername	tinyint
ispartner	tinyint
isprospect	tinyint
issalesperson	tinyint
istaxable	tinyint
isvendor	tinyint
languagelistitemrowid	int
leadrowid	int
manufacturertypelistitemrowid	int
opportunityrowid	int
othernametypelistitemrowid	int
parentrelationshiprowid	int
partnertypelistitemrowid	int
paymentmethodlistitemrowid	int
pricelevelrowid	int
prospecttypelistitemrowid	int
purchaseorderrequired	tinyint
relationshipid	varchar
relationshiprowid	int
resalenbr	varchar
role1099	tinyint
rowid	int	auto_increment
salesaccountrowid	int
salesclassrowid	int
salespersontypelistitemrowid	int
salestaxgrouprowid	int
separatecheck	tinyint
shippingmethodlistitemrowid	int
taxnbr	varchar
taxregistrationnbr	varchar
termrowid	int
updatetimestamp	timestamp	on update CURRENT_TIMESTAMP
vendortypelistitemrowid	int
webaddress	varchar

v.ismain -- Wed, Feb 28, 2018 2:58 PM