QuickBooks SQL Mirror: The 'customer' Table

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
quickbooks_integration_php_consolibyte_sqlmirror_table_customer.txt · Last modified: 2013/01/21 12:44 (external edit)