This is an old revision of the document!


QuickBooks SQL Mirror: The 'invoice' Table

qbsql_id				(Auto-increment. Do not update.)
TxnID					(Required. If adding a new Invoice, you can make this up and QuickBooks will replace it when it's added to QuickBooks. Do not update.)
TimeCreated				(This field will be overwritten by QuickBooks when the object is added to QuickBooks.)
TimeModified				(This field will be overwritten by QuickBooks when the object is added to QuickBooks.)
EditSequence				(Do not update.)
TxnNumber
Customer_ListID
Customer_FullName			(Either this or Customer_ListID is required.)
Class_ListID
Class_FullName
ARAccount_ListID
ARAccount_FullName			(If this and the ARAccount_ListID are left empty, the default 'Accounts Receivable' account within QuickBooks will be used.)
Template_ListID
Template_FullName
TxnDate
RefNumber
BillAddress_Addr1
BillAddress_Addr2
BillAddress_Addr3
BillAddress_Addr4
BillAddress_Addr5
BillAddress_City
BillAddress_State
BillAddress_PostalCode
BillAddress_Country
BillAddress_Note
BillAddressBlock_Addr1			(Do not use any of the BillAddressBlock_* fields.)
BillAddressBlock_Addr2
BillAddressBlock_Addr3
BillAddressBlock_Addr4
BillAddressBlock_Addr5
ShipAddress_Addr1
ShipAddress_Addr2
ShipAddress_Addr3
ShipAddress_Addr4
ShipAddress_Addr5
ShipAddress_City
ShipAddress_State
ShipAddress_PostalCode
ShipAddress_Country
ShipAddress_Note
ShipAddressBlock_Addr1			(Do not use any of the ShipAddressBlock_* fields.)
ShipAddressBlock_Addr2
ShipAddressBlock_Addr3
ShipAddressBlock_Addr4
ShipAddressBlock_Addr5
IsPending
IsFinanceCharge
PONumber
Terms_ListID				(Refers to a record within the 'standardterms' table.)
Terms_FullName				(Refers to a record within the 'standardterms' table.)
DueDate
SalesRep_ListID
SalesRep_FullName
FOB
ShipDate
ShipMethod_ListID
ShipMethod_FullName
Subtotal				(Read-only. You may INSERT or UPDATE this, but it will not be transferred to QuickBooks, instead the total will be calculated from the line items.)
ItemSalesTax_ListID			(Refers to a records within the 'itemsalestax' table.)
ItemSalesTax_FullName			(Refers to a records within the 'itemsalestax' table.)
SalesTaxPercentage			(Read-only. If you want to specify a sales tax percentage, you must specify it by refering to a specific 'itemsalestax' record using ItemSalesTax_ListID or ItemSalesTax_FullName.)
SalesTaxTotal				(Read-only. This is calculated by QuickBooks based on the sales tax percentage.)
AppliedAmount				(Read-only. This is calculated by payments applied to the invoice.)
BalanceRemaining			(Read-only. This is calculated by payments applied to the invoice.)
Memo
IsPaid					(Read-only.)
CustomerMsg_ListID
CustomerMsg_FullName
IsToBePrinted
IsToBeEmailed
CustomerSalesTaxCode_ListID
CustomerSalesTaxCode_FullName
SuggestedDiscountAmount			(?)
SuggestedDiscountDate			(?)
Other
quickbooks_integration_php_consolibyte_sqlmirror_table_invoice.1254332132.txt.gz · Last modified: 2013/01/21 12:44 (external edit)