Differences

This shows you the differences between two versions of the page.

Link to this comparison view

quickbooks_integration_php_consolibyte_sqlmirror_table_itemservice [2013/01/21 12:44] (current)
Line 1: Line 1:
 +====== QuickBooks SQL Mirror: The 'itemservice' Table ====== 
  
 +<file>
 +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
 +</file>
quickbooks_integration_php_consolibyte_sqlmirror_table_itemservice.txt · Last modified: 2013/01/21 12:44 (external edit)