QBooks Office Vendors / Purchase Cycle

Vendors
Vendor Types
Inventory Items

Back to QBooks Office Overview

Ver	Field Name	Type	Prop	IIF Name	Description
-45	nKey	Long	PKey	REFNUM	Unique vendor record identifier
-45	sName	S41	Req	NAME	Name of vendor. (Vendor box at top of form)
-45	sCompanyName	S41	Opt	COMPANY- NAME	Full company name of vendor
-45	sSalutation	S15	Opt	SALUTA- TION	Salutation for contact (Mr., Mrs, etc.)
-45	sFirstName	S25	Opt	FIRSTNAME	First name of person
-45	sMidName	S5	Opt	MIDINIT	Person's middle name or initial
-45	sLastName	S25	Opt	LASTNAME	Person's last name
-45	sAddr1	S41	Opt	ADDR1	Address line
-45	sAddr2	S41	Opt	ADDR2	Address line
-45	sAddr3	S41	Opt	ADDR3	Address line
-45	sAddr4	S41	Opt	ADDR4	Address line If this vendor requires a 1099, one of the address fields needs to contain a 2 char U.S. state abbreviation. Also, a 5 digit zip code must exist in one of the address fields.
-45	sAddr5	S41	Opt	ADDR5	Address line
-45	sContact	S41	Opt	CONT1	Primary contact name
-45	sPhone	S21	Opt	PHONE1	Main telephone number
-45	sPhoneFax	s21	Opt	FAXNUM	Fax telephone number
-45	sPhone2	S21	Opt	PHONE2	Alternate telephone number
-45	sContact2	S41	Opt	CONT2	Secondary contact name
-45	sPrintAs	S41	Opt	PRINTAS	How vendor name printed on checks
-45	sAccount	S99	Opt	NOTE	Vendor's account number (not account number from chart of accounts)
-45	kVendType	Long	FKeyOpt	VTYPE	Key of vendor type
-45	kTerms	Long	FKeyOpt	TERMS	Key of payment terms for payments to this vendor
-45	mCreditLimit	Curr	OptDft0	LIMIT	Maximum credit limit with this vendor Dollar value is negated.
-45	sTaxNum	S11	Opt	TAXID	Federal tax number or SSAN for 1099s. (box Tax ID)
-45	b1099	Bool	Opt	1099	T if 1099 required (checkbox Vendor eligible for 1099)
-45	sCustomField1...	S30	Opt	CUSTFLD1	Custom field value used in vendor
-45	sCustomField15	S30	Opt	CUSTFLD15	Custom field value used in vendor
-45	sNotes	S999	-	NOTEPAD	Memo notes about this vendor. (appears when Notes button is clicked)
-45	sShipAddr1	S41	Opt	-	Shipping address line
-45	sShipAddr2	S41	Opt	-	Shipping address line
-45	sShipAddr3	S41	Opt	-	Shipping address line
-45	sShipAddr4	S41	Opt	-	Shipping address line
-45	sShipAddr5	S41	Opt	-	Shipping address line
-45	mBalance	Curr	OptDft0	-	Current balance owed to this vendor to this vendor. Does not appear in form.
--5	bInactive	Bool	OptDftF	HIDDEN	T if currently inactive (checkbox Vendor is inactive is checked)

Contents of this page
QBooks Office Overview

Ver	Field Name	Type	Prop	IIF Name	Description
-45	nKey	Long	PKey	REFNUM	Unique vendor type record identifier
-45	sName	S31	Req	-	Short name. Does not include colon separators or names of parent vendor type(s).
-45	sFullName	S159	Req	NAME	Full name with colon separators - w/ name(s) of parents if any
-45	nNestLevel	Long	OptDft0	-	Depth of nesting. Parent (root) if missing
-45	kParent	Long	FKeyOpt	-	Key of parent in this set of records
--5	bInactive	Bool	OptDftF	HIDDEN	T if currently inactive (Inactive checkbox is checked)

Contents of this page
QBooks Office Overview

Ver	Field Name	Type	Prop	IIF Name	Description
-45	nKey	Long	PKey	REFNUM	Unique inventory item record identifier
-45	sItemType	S11	Req	INVITEM- TYPE	Type of inventory item. One of "Service", "InvtPart", "NonInvtPart", "OthCharge", "Subtotal", "Group", "Discount", "Payment", "TaxItem", or "TaxGroup".
-45	sName	S13	Req	-	Short name of inventory item. Does not include colon separators or names of parent inventory items.
-45	sFullName	S69	Req	NAME	Full name with colon separators - w/ name(s) of parents if any
-45	nNestLevel	Long	OptDft0	-	Depth of nesting. Parent (root) if missing
-45	kParent	Long	FKeyOpt	-	Key of parent in this set of records
-45	sPurchDescr	Memo	Opt	PURCHASE- DESC	Description of item used on purchase orders Automatically added to all purchase transactions.
-45	bResale	Bool	OptDftF	ISPASSED- THRU	T if item is passed thru as an expense to customers. The prompt for this is different for different inventory item types. Examples: For Service, checkbox = This service is performed by a subcontractor. For Non-inventory Part, checkbox = This item is purchased for and sold to a specific customer:job.
-45	rEnteredCost	Doub	Opt	COST	Wholesale unit cost entered by user. Not automatically updated. Because QuickBooks only uses the averaged cost costing method, this value is never used in cost calculations. (box Cost)
-45	kAcctCOGS	Long	FKeyOpt	COGSACCNT	Key of cost of goods account for this item
-45	kVendor	Long	FKeyOpt	PREFVEND	Key of primary vendor
-45	kVendTax	Long	FKeyOpt	TAXVEND	Key of tax authority (vendor) for this item
-45	sDescr	Memo	Opt	DESC	Description of item
-45	kPayMeth	Long	FKeyOpt	PAYMETH	Key of customer payment method
-45	bDeposit	Bool	OptDftF	DEP_TYPE	T if payment goes directly to bank account. Applies to items of type "Payment" only.
-45	rUnitPrice	Curr	Opt	PRICE	Retail per unit price of this item. Can be either dollars or percentage. (box Sales Price). This can also appear as (box Rate).
-45	bTaxable	Bool	OptDftF	TAXABLE	T if sales tax should be charged for this item
-45	kAcctIncome	Long	FKeyOpt	ACCNT	Key of income account for this item. Depending on type of item, may be used for some purpose other than specifying the income account - but is always an account.
-45	kAcctAsset	Long	FKeyOpt	ASSET- ACCNT	Key of asset account for this item If a current asset account such as 'Inventory' is used, the balance of the account will equal total inventory value.
-45	rReorderPoint	Doub	Opt	REORDER- POINT	Count of items below which reorder should be done
-45	rOnHandCount	Doub	Opt	QNTY	Count of items currently in stock Quantity currently on hand
-45	rAverageCost	Doub	Opt	-	Current averaged wholesale unit cost of this item
-45	rOnOrder	Doub	Opt	QNTY	Count of items currently on order
-45	bPrintItems	Bool	OptDftF	-	T if all items in group should be printed. Applies to item of type "Group" only.
-45	nGroupCnt	Long	OptDft0	-	Count of composite items in group. Applies to group items "Group" and "TaxGroup" only. The kItem... fields also apply only to group items.
-45	kItem1...	-	FKeyOpt	-	Key of another component inventory item in this set of records
-45	kItem20	Long	FKeyOpt	-	Key of another component inventory item in this set of records
-45	nCount1...	Long	Opt	-	Count of composite inventory item
--5	nCount20	-	-	-	Count of composite inventory item
-45	sCustomField1...	S30	Opt	CUSTFLD1	Custom field value for inventory item
-45	sCustomField5	S30	Opt	CUSTFLD5	Custom field value for inventory item
--5	bInactive	Bool	OptDftF	HIDDEN	T if currently inactive (Inactive checkbox is checked)
-45	rOnHandValue	Doub	Opt	-	Total value of items currently in stock

Contents of this page
QBooks Office Overview