Details:Vendor

TABLE DETAIL REFERENCE: Vendor

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
ListID	12	VARCHAR	36	True	False	False	False	%s
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EditSequence	12	VARCHAR	10	True	False	False	False	%s
Name	12	VARCHAR	100	True	True	True	True	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false
CompanyName	12	VARCHAR	50	True	True	True	False	%s
Salutation	12	VARCHAR	15	True	True	True	False	%s
FirstName	12	VARCHAR	25	True	True	True	False	%s
MiddleName	12	VARCHAR	25	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
JobTitle	12	VARCHAR	1000	True	False	False	False	%s
Suffix	12	VARCHAR	10	True	True	True	False	%s
VendorAddressID	12	VARCHAR	500	True	True	True	False	%s
VendorAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
VendorAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
VendorAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
VendorAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
VendorAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
VendorAddressCity	12	VARCHAR	255	True	True	True	False	%s
VendorAddressState	12	VARCHAR	255	True	True	True	False	%s
VendorAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
VendorAddressCountry	12	VARCHAR	255	True	True	True	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
Mobile	12	VARCHAR	21	True	True	True	False	%s
AltPhone	12	VARCHAR	21	True	True	True	False	%s
Fax	12	VARCHAR	21	True	True	True	False	%s
Email	12	VARCHAR	100	True	True	True	False	%s
WebAddressURI	12	VARCHAR	1000	True	True	True	False	%s
OtherContactInfoType	12	VARCHAR	1000	True	True	True	False	%s
OtherContactInfoTelephone	12	VARCHAR	1000	True	True	True	False	%s
NameOnCheck	12	VARCHAR	110	True	True	True	False	%s
AccountNumber	12	VARCHAR	99	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
VendorTaxIdent	12	VARCHAR	20	True	True	True	False	%s
IsVendorEligibleFor1099	-7	BIT	1	True	False	True	False	1 0 true false
Balance	3	DECIMAL	13	True	False	False	False	%11.2f
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
Cc	12	VARCHAR	100	True	True	True	False	%s
AdditionalContactRefContactName	12	VARCHAR	1000	True	False	False	False	%s
AdditionalContactRefContactValue	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetListID	12	VARCHAR	36	True	True	False	False	%s
ContactsRetTimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
ContactsRetTimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
ContactsRetEditSequence	12	VARCHAR	10	True	True	False	False	%s
ContactsRetName	12	VARCHAR	100	True	True	True	False	%s
ContactsRetIsActive	-7	BIT	1	True	True	False	False	1 0 true false
ContactsRetFirstName	12	VARCHAR	25	True	True	True	False	%s
ContactsRetMiddleName	12	VARCHAR	25	True	True	True	False	%s
ContactsRetLastName	12	VARCHAR	25	True	True	True	False	%s
ContactsRetJobTitle	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetAdditionalContactRefContactName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetAdditionalContactRefContactValue	12	VARCHAR	1000	True	False	False	False	%s
AdditionalNotesNoteID	12	VARCHAR	1000	True	False	False	False	%s
AdditionalNotesDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
AdditionalNotesNote	12	VARCHAR	1000	True	False	False	False	%s
BusinessNumber	12	VARCHAR	99	True	False	True	False	%s
GSTIN	12	VARCHAR	99	True	False	True	False	%s
GSTRegistrationType	12	VARCHAR	99	True	False	True	False	%s
Organization	-7	BIT	1	True	True	True	False	1 0 true false
UserId	12	VARCHAR	1000	True	True	True	False	%s
Status	12	VARCHAR	1000	True	True	True	False	%s
ContactName	12	VARCHAR	1000	True	False	False	False	%s
AltContactName	12	VARCHAR	1000	True	False	False	False	%s
CreditLimit	3	DECIMAL	13	True	True	True	False	%8.2f
T5018Eligible	-7	BIT	1	True	True	False	False	1 0 true false
TDSEnabled	-7	BIT	1	True	True	False	False	1 0 true false
TDSEntityTypeId	3	DECIMAL	15	True	False	False	False	%11.2f
TDSSectionTypeId	3	DECIMAL	15	True	False	False	False	%11.2f
TDSOverrideThreshold	-7	BIT	1	True	True	False	False	1 0 true false
IsSubContractor	-7	BIT	1	True	True	False	False	1 0 true false
SubcontractorType	12	VARCHAR	1000	True	True	True	False	%s
CISRate	12	VARCHAR	1000	True	True	True	False	%s
HasTPAR	-7	BIT	1	True	True	False	False	1 0 true false
VendorPaymentBankDetailAccountNumber	12	VARCHAR	7	True	True	True	False	%s
VendorPaymentBankDetailBankAccountName	12	VARCHAR	1000	True	True	True	False	%s
VendorPaymentBankDetailBankBranchIdentifier	12	VARCHAR	1000	True	True	True	False	%s
VendorPaymentBankDetailStatementText	12	VARCHAR	1000	True	True	True	False	%s
CostRate	3	DECIMAL	13	True	True	True	False	%8.2f
T4AEligible	-7	BIT	1	True	True	False	False	1 0 true false
Vendor1099	-7	BIT	1	True	True	False	False	1 0 true false
Notes	12	VARCHAR	2000	True	True	True	False	%s
TaxCountry	12	VARCHAR	2000	True	True	True	False	%s
TaxIdEffectiveDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
OpenBalance	3	DECIMAL	13	True	False	True	False	%11.2f
OpenBalanceDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
VendorTypeRefListID	12	VARCHAR	36	True	False	False	False	%s
VendorTypeRefFullName	12	VARCHAR	1000	True	False	False	False	%s
Source	12	VARCHAR	2000	True	True	True	False	%s
OtherAddrId	12	VARCHAR	36	True	True	True	False	%s
OtherAddr1	12	VARCHAR	100	True	True	True	False	%s
OtherAddr2	12	VARCHAR	100	True	True	True	False	%s
OtherAddr3	12	VARCHAR	100	True	True	True	False	%s
OtherAddr4	12	VARCHAR	100	True	True	True	False	%s
OtherAddr5	12	VARCHAR	100	True	True	True	False	%s
OtherAddrCity	12	VARCHAR	100	True	True	True	False	%s
OtherAddrState	12	VARCHAR	100	True	True	True	False	%s
OtherAddrProvince	12	VARCHAR	100	True	True	True	False	%s
OtherAddrCounty	12	VARCHAR	100	True	True	True	False	%s
OtherAddrPostalCode	12	VARCHAR	100	True	True	True	False	%s
OtherAddrLat	12	VARCHAR	100	True	True	True	False	%s
OtherAddrLong	12	VARCHAR	100	True	True	True	False	%s
TaxReportingBasis	12	VARCHAR	1000	True	True	True	False	%s
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
UpdateAccountOnTxns	-7	BIT	1	False	True	False	False	1 0 true false

QODBC.com Tools for QuickBooks