This is an old revision of the document!


QuickBooks SQL Mirror: The 'vendor' Table

qbsql_id
ListID			(You can make this up if adding a new record to QuickBooks, it will be updated when the record is transferred to QuickBooks. Do not update.)
TimeCreated		(Read-only.)
TimeModified		(Read-only.)
EditSequence		(Read-only. Do not update.)
Name			(Required.)
IsActive
CompanyName
Salutation
FirstName
MiddleName
LastName
VendorAddress_Addr1
VendorAddress_Addr2
VendorAddress_Addr3
VendorAddress_Addr4		(You can only use this field if you do *not* use the City, State, PostalCode, or Country fields.)
VendorAddress_Addr5		(You can only use this field if you do *not* use the City, State, PostalCode, or Country fields.)
VendorAddress_City
VendorAddress_State
VendorAddress_PostalCode
VendorAddress_Country
VendorAddress_Note
VendorAddressBlock_Addr1	(Do not use any of the VendorAddressBlock fields.)
VendorAddressBlock_Addr2
VendorAddressBlock_Addr3
VendorAddressBlock_Addr4
VendorAddressBlock_Addr5
Phone
AltPhone
Fax
Email
Contact
AltContact
NameOnCheck
AccountNumber
Notes
VendorType_ListID
VendorType_FullName
Terms_ListID
Terms_FullName
CreditLimit
VendorTaxIdent
IsVendorEligibleFor1099
Balance			(Read-only.)
BillingRate_ListID
BillingRate_FullName
quickbooks_integration_php_consolibyte_sqlmirror_table_vendor.1256736074.txt.gz · Last modified: 2013/01/21 12:44 (external edit)