qbsql_id
ListID (You can make this up if adding a new record. Do not update it. It will be updated when the record is transferred to QuickBooks.)
TimeCreated (Read-only.)
TimeModified (Read-only.)
EditSequence (Read-only. Do not update, this is needed to sync changes back to QuickBooks.)
Name (Required.)
FullName
IsActive
Parent_ListID
Parent_FullName
Sublevel
CompanyName
Salutation
FirstName
MiddleName
LastName
BillAddress_Addr1
BillAddress_Addr2
BillAddress_Addr3
BillAddress_Addr4 (You can only use this field if you *do not* use the City, State, PostalCode, or Country fields.)
BillAddress_Addr5 (You can only use this field if you *do not* use the City, State, PostalCode, or Country fields.)
BillAddress_City
BillAddress_State
BillAddress_PostalCode
BillAddress_Country
BillAddress_Note
BillAddressBlock_Addr1 (Do not use any of the BillAddressBlock fields, they are all read-only.)
BillAddressBlock_Addr2
BillAddressBlock_Addr3
BillAddressBlock_Addr4
BillAddressBlock_Addr5
ShipAddress_Addr1
ShipAddress_Addr2
ShipAddress_Addr3
ShipAddress_Addr4 (You can only use this field if you *do not* use the City, State, PostalCode, or Country fields.)
ShipAddress_Addr5 (You can only use this field if you *do not* use the City, State, PostalCode, or Country fields.)
ShipAddress_City
ShipAddress_State
ShipAddress_PostalCode
ShipAddress_Country
ShipAddress_Note
ShipAddressBlock_Addr1 (Do not use any of the ShipAddressBlock fields, they are all read-only.)
ShipAddressBlock_Addr2
ShipAddressBlock_Addr3
ShipAddressBlock_Addr4
ShipAddressBlock_Addr5
Phone
AltPhone
Fax
Email
Contact
AltContact
CustomerType_ListID
CustomerType_FullName
Terms_ListID
Terms_FullName
SalesRep_ListID
SalesRep_FullName
Balance (Read-only.)
TotalBalance (Read-only.)
SalesTaxCode_ListID
SalesTaxCode_FullName
ItemSalesTax_ListID
ItemSalesTax_FullName
ResaleNumber
AccountNumber
CreditLimit
PreferredPaymentMethod_ListID
PreferredPaymentMethod_FullName
CreditCardInfo_CreditCardNumber (Some QuickBooks versions do not allow retrieving full, unmasked credit card numbers due to PCI Compliance regulations.)
CreditCardInfo_ExpirationMonth
CreditCardInfo_ExpirationYear
CreditCardInfo_NameOnCard
CreditCardInfo_CreditCardAddress
CreditCardInfo_CreditCardPostalCode
JobStatus
JobStartDate
JobProjectedEndDate
JobEndDate
JobDesc
JobType_ListID
JobType_FullName
Notes
PriceLevel_ListID
PriceLevel_FullName
qbsql_discov_datetime
qbsql_resync_datetime
qbsql_modify_timestamp
qbsql_delete_timestamp
qbsql_errnum
qbsql_errmessage
qbsql_enqueue_datetime
qbsql_dequeue_datetime
qbsql_deleted_flag
