QuickBooks SQL Mirror: The 'itemservice' Table

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.)
FullName				(If this service item has a parent item, the FullName is formatted as "Parent Name:Child Name"
IsActive				
Parent_ListID
Parent_FullName
Sublevel
UnitOfMeasureSet_ListID
UnitOfMeasureSet_FullName
SalesTaxCode_ListID
SalesTaxCode_FullName
SalesOrPurchase_Desc				(You should use *either* the SalesOrPurchase fields *OR* the SalesAndPurchase fields. Do not use both!)
SalesOrPurchase_Price
SalesOrPurchase_PricePercent
SalesOrPurchase_Account_ListID			(Either this field or the SalesOrPurchase_Account_FullName field are required if this item is for Sales *or* Purchase.)
SalesOrPurchase_Account_FullName		(Either this field or the SalesOrPurchase_Account_ListID field are required if this item is for Sales *or* Purchase.)	
SalesAndPurchase_SalesDesc			(You should use *either* the SalesOrPurchase fields *OR* the SalesAndPurchase fields. Do not use both!)
SalesAndPurchase_SalesPrice
SalesAndPurchase_IncomeAccount_ListID		(Either this field or the SalesAndPurchase_IncomeAccount_FullName field are required if this item is for Sales *and* Purchase.)
SalesAndPurchase_IncomeAccount_FullName		(Either this field or the SalesAndPurchase_IncomeAccount_ListID field are required if this item is for Sales *and* Purchase.)
SalesAndPurchase_PurchaseDesc
SalesAndPurchase_PurchaseCost
SalesAndPurchase_ExpenseAccount_ListID		(Either this field or the SalesAndPurchase_ExpenseAccount_FullName field are required if this item is for Sales *and* Purchase.)
SalesAndPurchase_ExpenseAccount_FullName	(Either this field or the SalesAndPurchase_ExpenseAccount_ListID field are required if this item is for Sales *and* Purchase.)
SalesAndPurchase_PrefVendor_ListID
SalesAndPurchase_PrefVendor_FullName
quickbooks_integration_php_consolibyte_sqlmirror_table_itemservice.txt · Last modified: 2013/01/21 12:44 (external edit)