This is an old revision of the document!


QuickBooks SQL Mirror: The 'iteminventory' Table

qbsql_id		(Auto-increment. Do not update.)
ListID			(Required. If adding a new Item, 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 modified in QuickBooks.)
EditSequence		(Do not update.)
Name			(Required)
FullName		(If this is a sub-Item of something else, QuickBooks will return this to you in the format "ParentName:ChildName")
IsActive		(1 for YES, 0 for NO.)
Parent_ListID	
Parent_FullName
Sublevel		(This field will be overwritten by QuickBooks when the object is modified in QuickBooks.)
ManufacturerPartNumber		
UnitOfMeasureSet_ListID
UnitOfMeasureSet_FullName
SalesTaxCode_ListID
SalesTaxCode_FullName
SalesDesc			(The description of the item that a customer would see.)
SalesPrice			(The price of the item that a customer would see.)
IncomeAccount_ListID
IncomeAccount_FullName		(Either this or IncomeAccount_ListID is required.)
PurchaseDesc			(The description of the item the vendor provides or an internal description.)
PurchaseCost			(The amount the item costs to purchase from the vendor or produce.)
COGSAccount_ListID
COGSAccount_FullName		(Either this or COGSAccount_ListID is required.)
PrefVendor_ListID
PrefVendor_FullName
AssetAccount_ListID
AssetAccount_FullName		(Either this or AssetAccount_ListID is required.)
ReorderPoint
QuantityOnHand
AverageCost
QuantityOnOrder
QuantityOnSalesOrder
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_iteminventory.1253729905.txt.gz · Last modified: 2013/01/21 12:44 (external edit)