TABLE DETAIL REFERENCE:		Vendor
(US VERSION)

FIELD NAME	TYPE	LENGTH	QRY	MOD	INS	REQ INS	VALIDATE	REL
ListID	Varchar	36	True	False	False	N/A	String
TimeCreated	Timestamp	27	True	False	False	N/A	CCCC-MM-DDThh:mm:ssZ
TimeModified	Timestamp	27	True	False	False	N/A	CCCC-MM-DDThh:mm:ssZ
EditSequence	Varchar	16	True	False	False	N/A	String
Name	Varchar	41	True	True	True	Yes	String
IsActive	Bit	5	True	True	True	No	1 0 true false
CompanyName	Varchar	41	True	True	True	No	String
Salutation	Varchar	15	True	True	True	No	String
FirstName	Varchar	25	True	True	True	No	String
MiddleName	Varchar	5	True	True	True	No	String
LastName	Varchar	25	True	True	True	No	String
VendorAddressAddr1	Varchar	41	True	True	True	No	String
VendorAddressAddr2	Varchar	41	True	True	True	No	String
VendorAddressAddr3	Varchar	41	True	True	True	No	String
VendorAddressAddr4	Varchar	41	True	True	True	No	String
VendorAddressAddr5	Varchar	41	True	True	True	No	String
VendorAddressCity	Varchar	31	True	True	True	No	String
VendorAddressState	Varchar	21	True	True	True	No	String
VendorAddressPostalCode	Varchar	13	True	True	True	No	String
VendorAddressCountry	Varchar	31	True	True	True	No	String
VendorAddressNote	Varchar	41	True	True	True	No	String
VendorAddressBlockAddr1	Varchar	41	True	False	False	N/A	String
VendorAddressBlockAddr2	Varchar	41	True	False	False	N/A	String
VendorAddressBlockAddr3	Varchar	41	True	False	False	N/A	String
VendorAddressBlockAddr4	Varchar	41	True	False	False	N/A	String
VendorAddressBlockAddr5	Varchar	41	True	False	False	N/A	String
Phone	Varchar	21	True	True	True	No	String
AltPhone	Varchar	21	True	True	True	No	String
Fax	Varchar	21	True	True	True	No	String
Email	Varchar	1023	True	True	True	No	String
Contact	Varchar	41	True	True	True	No	String
AltContact	Varchar	21	True	True	True	No	String
NameOnCheck	Varchar	41	True	True	True	No	String
AccountNumber	Varchar	99	True	True	True	No	String
Notes	Varchar	4095	True	True	True	No	String
VendorTypeRefListID	Varchar	36	True	False	True	No	String	Yes
VendorTypeRefFullName	Varchar	159	True	True	True	No	String
TermsRefListID	Varchar	36	True	False	True	No	String	Yes
TermsRefFullName	Varchar	31	True	True	True	No	String
CreditLimit	Decimal	11	True	True	True	No	8.2
VendorTaxIdent	Varchar	15	True	True	True	No	String
IsVendorEligibleFor1099	Bit	5	True	True	True	No	1 0 true false
OpenBalance	Decimal	11	True	False	True	No	8.2
OpenBalanceDate	Date	10	True	False	True	No	CCCC-MM-DD
BillingRateRefListID	Varchar	36	True	False	True	No	String	Yes
BillingRateRefFullName	Varchar	31	True	True	True	No	String
Balance	Decimal	11	True	False	False	N/A	8.2