Home » Transaction Pro Importer QuickBooks Desktop Data Dictionary & Sample Importing Templates

Transaction Pro Importer QuickBooks Desktop Data Dictionary & Sample Importing Templates

Transaction Pro Importer is one of my favorite programs to import excel/csv data into Quickbooks Desktop, I use this data table to know which fields I can import.

Transaction Type	Field	QuickBooks Form Field Description	Notes	Required Field	Type/Length
Bank Statement	Bank Account *	12	15	X	Char 31
Bank Statement	Transaction Date	12			Date
Bank Statement	Payee *	12		X	Char 31
Bank Statement	Chk No.	12			Char 11
Bank Statement	Account *	12	15	X	Char 31
Bank Statement	Amount *	12		X	Numeric
Bank Statement	Memo	12			Char 4095
Bank Statement	Class	12			Char 41
Bank Statement	Billable	12			Char 1
Bank Statement	Billable Entity	12			Char 41
Bill	Vendor *	Bill Vendor		X	Char 41
Bill	Transaction Date	Bill Date			Date
Bill	RefNumber *	Bill Ref. No.	1	X	Char 20
Bill	Bill Due	Bill Bill Due			Date
Bill	Terms	Bill Terms			Char 31
Bill	Memo	Bill Memo			Char 4095
Bill	Address Line1	Bill Address Box			Char 41
Bill	Address Line2	Bill Address Box			Char 41
Bill	Address Line3	Bill Address Box			Char 41
Bill	Address Line4	Bill Address Box			Char 41
Bill	Address City	Bill Address Box			Char 31
Bill	Address State	Bill Address Box			Char 21
Bill	Address PostalCode	Bill Address Box			Char 13
Bill	Address Country	Bill Address Box			Char 21
Bill	Vendor Acct No	Bill Account Number			Char 99
Bill	Expenses Account	Bill Expenses Tab Account	15	5	Char 31
Bill	Expenses Amount	Bill Expenses Tab Amount		5	Numeric
Bill	Expenses Memo	Bill Expenses Tab Memo			Char 4095
Bill	Expenses Class	Bill Expenses Tab Class			Char 31
Bill	Expenses Customer	Bill Expenses Tab Customer:Job	16		Char 41
Bill	Expenses Billable	Bill Expenses Tab Billable?	6		Char 1
Bill	Items Item	Bill Items Tab Items		5	Char 31
Bill	Items Qty	Bill Items Tab Qty			Numeric
Bill	Items Description	Bill Items Tab Description			Char 4095
Bill	Items Cost	Bill Items Tab Cost		5	Numeric
Bill	Items Class	Bill Items Tab Class			Char 31
Bill	Items Customer	Bill Items Tab Customer:Job	16		Char 41
Bill	Items Billable	Bill Items Tab Billable?	6		Char 1
Bill	Unit of Measure	Bill Items Tab U/M			Char 31
Bill	AP Account	Vendor Information Account	15		Char 31
Bill	Currency	Bill Amount Due			Char 64
Bill	Exchange Rate	Bill Exhange Rate			Numeric
Bill	Inventory Site	Bill Items TabSite	13		Char 31
Bill	Inventory Bin	Bill Items TabBin	13, 14		Char 31
Bill	Serial/Lot Number	Bill Items TabSerial/Lot Number	13		Char 41
Bill Payment	Payee *	Pay Bills Vendor		X	Char 41
Bill Payment	Transaction Date	Payment Summary Payment Date			Date
Bill Payment	Apply to Bill RefNumber	Pay Bills Ref. No.			Char 20
Bill Payment	Payment Method *	Pay Bills Method		X	Char 31
Bill Payment	Bank Account	Pay Bills Account	15		Char 31
Bill Payment	Credit Card Account	Pay Bills Account	15		Char 31
Bill Payment	RefNumber *		2	X	Char 11
Bill Payment	Amount *	Pay Bills Amt. to Pay		X	Numeric
Bill Payment	Memo	Check Memo			Char 4095
Bill Payment	Discount Amount	Pay Bill Discounts and Credits Amount of Discount			Numeric
Bill Payment	Discount Account	Pay Bill Discounts and Credits Discount Account	15		Char 31
Bill Payment	To Be Printed	Check To be printed	6		Char 1
Bill Payment	Exchange Rate				Numeric
Check	Bank Account *	Vendor Information Account	15	X	Char 31
Check	Payee *	Check Pay to the Order of		X	Char 41
Check	Transaction Date	Check Date			Date
Check	RefNumber *	Check No.		X	Char 11
Check	Memo	Check Memo			Char 4095
Check	Address Line1	Check Address Box			Char 41
Check	Address Line2	Check Address Box			Char 41
Check	Address Line3	Check Address Box			Char 41
Check	Address Line4	Check Address Box			Char 41
Check	Address City	Check Address Box			Char 31
Check	Address State	Check Address Box			Char 21
Check	Address PostalCode	Check Address Box			Char 13
Check	Address Country	Check Address Box			Char 21
Check	Vendor Acct No	Check Account Number			Char 99
Check	Expenses Account	Check Expenses Tab Account	15	5	Char 31
Check	Expenses Amount	Check Expenses Tab Amount		5	Numeric
Check	Expenses Memo	Check Expenses Tab Memo			Char 4095
Check	Expenses Class	Check Expenses Tab Class			Char 31
Check	Expenses Customer	Check Expenses Tab Customer:Job	16		Char 41
Check	Expenses Billable	Check Expenses Tab Billable	6		Char 1
Check	Items Item	Check Items Tab Item	16	5	Char 31
Check	Items Qty	Check Items Tab Qty			Numeric
Check	Items Description	Check Items Tab Description			Char 4095
Check	Items Cost	Check Items Tab Cost		5	Numeric
Check	Items Class	Check Items Tab Class			Char 31
Check	Items Customer	Check Items Tab Customer:Job	16		Char 41
Check	Unit of Measure	Check Items Tab U/M			Char 31
Check	Items Billable	Check Items Tab Billable?	6		Char 1
Check	Currency	Check Pay to the Order of			Char 64
Check	Exchange Rate	Check Exhange Rate			Numeric
Check	Inventory Site	Check Items TabSite	13		Char 31
Check	Inventory Bin	Check Items TabBin	13, 14		Char 31
Check	Serial/Lot Number	Check Items TabSerial/Lot Number	13		Char 41
Credit Card Charge	Credit Card Account *	Credit Card Charges Credit Card	15	X	Char 31
Credit Card Charge	Payee *	Credit Card Charges Purchased From		X	Char 31
Credit Card Charge	Transaction Date	Credit Card Charges Date			Date
Credit Card Charge	RefNumber *	Credit Card Charges Ref No.	1	X	Char 11
Credit Card Charge	Memo	Credit Card Charges Memo			Char 4095
Credit Card Charge	Address Line1	Vendor Name and Address			Char 41
Credit Card Charge	Address Line2	Vendor Name and Address			Char 41
Credit Card Charge	Address Line3	Vendor Name and Address			Char 41
Credit Card Charge	Address Line4	Vendor Name and Address			Char 41
Credit Card Charge	Address City	Vendor Name and Address			Char 31
Credit Card Charge	Address State	Vendor Name and Address			Char 21
Credit Card Charge	Address PostalCode	Vendor Name and Address			Char 13
Credit Card Charge	Address Country	Vendor Name and Address			Char 21
Credit Card Charge	Expenses Account	Credit Card Charges Expenses Tab Account	15	5	Char 31
Credit Card Charge	Expenses Amount	Credit Card Charges Expenses Tab Amount		5	Numeric
Credit Card Charge	Expenses Memo	Credit Card Charges Expenses Tab Memo			Char 4095
Credit Card Charge	Expenses Class	Credit Card Charges Expenses Tab Class			Char 31
Credit Card Charge	Expenses Customer	Credit Card Charges Expenses Tab Customer:Job	16		Char 41
Credit Card Charge	Expenses Billable	Credit Card Charges Expenses Tab Billable	6		Char 1
Credit Card Charge	Items Item	Credit Card Charges Items Tab Item	16	5	Char 31
Credit Card Charge	Items Qty	Credit Card Charges Items Tab Qty			Numeric
Credit Card Charge	Items Description	Credit Card Charges Items Tab Description			Char 4095
Credit Card Charge	Items Cost	Credit Card Charges Items Tab Cost		5	Numeric
Credit Card Charge	Items Class	Credit Card Charges Items Tab Class			Char 31
Credit Card Charge	Items Customer	Credit Card Charges Items Tab Customer:Job	16		Char 41
Credit Card Charge	Items Billable	Credit Card Charges Items Tab Billable?	6		Char 1
Credit Card Charge	Currency	Credit Card Charges Amount			Char 64
Credit Card Charge	Exchange Rate	Credit Card Charges Exchange Rate			Numeric
Credit Card Charge	Inventory Site	Credit Card Charges Items TabSite	13		Char 31
Credit Card Charge	Inventory Bin	Credit Card Charges Items TabBin	13, 14		Char 31
Credit Card Charge	Serial/Lot Number	Check Items TabSerial/Lot Number	13		Char 41
Credit Card Credit	Credit Card Account *	Credit Card Refund Credit Card	15	X	Char 31
Credit Card Credit	Payee *	Credit Card Refund Purchased From		X	Char 31
Credit Card Credit	Transaction Date	Credit Card Refund Date			Date
Credit Card Credit	RefNumber *	Credit Card Refund Ref No.	1	X	Char 11
Credit Card Credit	Memo	Credit Card Refund Memo			Char 4095
Credit Card Credit	Address Line1	Vendor Name and Address			Char 41
Credit Card Credit	Address Line2	Vendor Name and Address			Char 41
Credit Card Credit	Address Line3	Vendor Name and Address			Char 41
Credit Card Credit	Address Line4	Vendor Name and Address			Char 41
Credit Card Credit	Address City	Vendor Name and Address			Char 31
Credit Card Credit	Address State	Vendor Name and Address			Char 21
Credit Card Credit	Address PostalCode	Vendor Name and Address			Char 13
Credit Card Credit	Address Country	Vendor Name and Address			Char 21
Credit Card Credit	Expenses Account	Credit Card Credits Expenses Tab Account	15	5	Char 31
Credit Card Credit	Expenses Amount	Credit Card Credits Expenses Tab Amount		5	Numeric
Credit Card Credit	Expenses Memo	Credit Card Credits Expenses Tab Memo			Char 4095
Credit Card Credit	Expenses Class	Credit Card Credits Expenses Tab Class			Char 31
Credit Card Credit	Expenses Customer	Credit Card Credits Expenses Tab Customer:Job	16		Char 41
Credit Card Credit	Expenses Billable	Credit Card Credits Expenses Tab Billable	6		Char 1
Credit Card Credit	Items Item	Credit Card Credits Items Tab Item	16	5	Char 31
Credit Card Credit	Items Qty	Credit Card Credits Items Tab Qty			Numeric
Credit Card Credit	Items Description	Credit Card Credits Items Tab Description			Char 4095
Credit Card Credit	Items Cost	Credit Card Credits Items Tab Cost		5	Numeric
Credit Card Credit	Items Class	Credit Card Credits Items Tab Class			Char 31
Credit Card Credit	Items Customer	Credit Card Credits Items Tab Customer:Job	16		Char 41
Credit Card Credit	Items Billable	Credit Card Credits Items Tab Billable?	6		Char 1
Credit Card Credit	Currency	Credit Card Credit Amount			Char 64
Credit Card Credit	Exchange Rate	Credit card Credit Exchange Rate			Numeric
Credit Card Credit	Inventory Site	Credit Card Credits Items TabSite	13		Char 31
Credit Card Credit	Inventory Bin	Credit Card Credits Items TabBin	13, 14		Char 31
Credit Card Credit	Serial/Lot Number	Credit Card Credits Items TabSerial/Lot Number	13		Char 41
Credit Card Statement	Credit Card Account *	Credit Card Charges/Credits Credit Card	15	X	Char 31
Credit Card Statement	Transaction Date	Credit Card Charges/Credits Date			Date
Credit Card Statement	Payee *	Credit Card Charges/Credits Purchased From		X	Char 31
Credit Card Statement	RefNumber	Credit Card Charges/Credits Ref No.			Char 11
Credit Card Statement	Account *	Credit Card Charges/Credits Expenses Tab Account	15	X	Char 31
Credit Card Statement	Amount *	Credit Card Charges/Credits Expenses Tab Amount	17	X	Numeric
Credit Card Statement	Memo	Credit Card Charges/Credits Memo			Char 4095
Credit Card Statement	Class	Credit Card Charges/Credits Expenses Tab Class			Char 31
Credit Card Statement	Billable	Credit Card Charges/Credits Expenses Tab Billable			Char 1
Credit Card Statement	Billable Entity	Credit Card Charges/Credits Expenses Tab Customer:Job			Char 41
Credit Memo	Customer *	Credit Memos/Refunds Customer:Job	16	X	Char 41
Credit Memo	Transaction Date	Credit Memos/Refunds Date			Date
Credit Memo	RefNumber *	Credit Memos/Refunds Credit No.	1	X	Char 11
Credit Memo	PO Number	Credit Memos/Refunds P.O. No.			Char 25
Credit Memo	Terms	Credit Memos/Refunds Terms			Char 31
Credit Memo	Class	Credit Memos/Refunds Class			Char 31
Credit Memo	Template Name	Credit Memos/Refunds Template			Char 31
Credit Memo	To Be Printed	Credit Memos/Refunds To be printed			Char 1
Credit Memo	Ship Date	Credit Memos/Refunds Ship Date			Date
Credit Memo	BillTo Line1	Credit Memos/Refunds Customer Block			Char 41
Credit Memo	BillTo Line2	Credit Memos/Refunds Customer Block			Char 41
Credit Memo	BillTo Line3	Credit Memos/Refunds Customer Block			Char 41
Credit Memo	BillTo Line4	Credit Memos/Refunds Customer Block			Char 41
Credit Memo	BillTo City	Credit Memos/Refunds Customer Block			Char 31
Credit Memo	BillTo State	Credit Memos/Refunds Customer Block			Char 21
Credit Memo	BillTo PostalCode	Credit Memos/Refunds Customer Block			Char 13
Credit Memo	BillTo Country	Credit Memos/Refunds Customer Block			Char 31
Credit Memo	ShipTo Line1	Credit Memos/Refunds Ship To Block			Char 41
Credit Memo	ShipTo Line2	Credit Memos/Refunds Ship To Block			Char 41
Credit Memo	ShipTo Line3	Credit Memos/Refunds Ship To Block			Char 41
Credit Memo	ShipTo Line4	Credit Memos/Refunds Ship To Block			Char 41
Credit Memo	ShipTo City	Credit Memos/Refunds Ship To Block			Char 31
Credit Memo	ShipTo State	Credit Memos/Refunds Ship To Block			Char 21
Credit Memo	ShipTo PostalCode	Credit Memos/Refunds Ship To Block			Char 13
Credit Memo	ShipTo Country	Credit Memos/Refunds Ship To Block			Char 31
Credit Memo	Phone	Customer Phone			Char 21
Credit Memo	Fax	Customer Fax			Char 21
Credit Memo	Email	Customer Email			Char 1023
Credit Memo	Contact Name	Customer Contact			Char 41
Credit Memo	First Name	Customer First Name			Char 25
Credit Memo	Last Name	Customer Last Name			Char 25
Credit Memo	Rep	Credit Memos/Refunds Rep			Char 5
Credit Memo	Due Date	Credit Memos/Refunds Due Date			Date
Credit Memo	Ship Method	Credit Memos/Refunds Ship Via			Char 15
Credit Memo	Customer Message	Credit Memos/Refunds Customer Message			Char 101
Credit Memo	Memo	Credit Memos/Refunds Memo			Char 4095
Credit Memo	Item *	Credit Memos/Refunds Item		X	Char 31
Credit Memo	Quantity	Credit Memos/Refunds Qty			Numeric
Credit Memo	Description	Credit Memos/Refunds Description			Char 4095
Credit Memo	Price	Credit Memos/Refunds Rate			Numeric
Credit Memo	Is Pending	Credit Memos/Refunds Pending (nonposting)	6		Char 1
Credit Memo	Item Line Class	Credit Memos/Refunds Class			Char 31
Credit Memo	Service Date	Credit Memos/Refunds Serviced			Date
Credit Memo	Customer Acct No	Credit Memos/Refunds Account No.			Char 99
Credit Memo	Sales Tax Item	Credit Memos/Refunds Transaction Line Tax			Char 31
Credit Memo	To Be EMailed	Credit Memos/Refunds To be emailed			Char 1
Credit Memo	Other	Credit Memos/Refunds Other			Char 29
Credit Memo	Other1	Credit Memos/Refunds Other 1			Char 29
Credit Memo	Other2	Credit Memos/Refunds Other 2			Char 29
Credit Memo	Unit of Measure	Credit Memos/Refunds U/M			Char 31
Credit Memo	AR Account	Credit Memos/Refunds Account	15		Char 31
Credit Memo	Currency	Credit Memo Customer:Job	16		Char 64
Credit Memo	Exchange Rate	Credit Memo Exhange Rate			Numeric
Credit Memo	Inventory Site	Credit Memo Site	13		Char 31
Credit Memo	Inventory Bin	Credit Memo Bin	13, 14		Char 31
Credit Memo	Serial /Lot Number	Credit Memo Serial/Lot Number	13		Char 41
Credit Memo	Sales Tax Code	Credit Memos/Refunds Total Tax			Char 3
Deposit	RefNumber *		2	X	Char 11
Deposit	Deposit to Account *	Deposits Deposit To	15	X	Char 31
Deposit	Transaction Date	Deposits Date			Date
Deposit	Deposit Memo	Deposits Memo			Char 4095
Deposit	Received From	Deposits Received From			Char 31
Deposit	From Account *	Deposits From Account	15	X	Char 31
Deposit	Memo	Deposits Transaction Line Memo			Char 4095
Deposit	Chk No.	Deposits Chk No.			Char 11
Deposit	Payment Method	Deposits Pmt Meth.			Char 31
Deposit	Class	Deposits Class			Char 31
Deposit	Amount *	Deposits Amount		X	Numeric
Deposit	Currency	Deposit Deposit Total			Char 64
Deposit	Exchange Rate	Deposit Exchange Rate			Numeric
Estimate	Customer *	Estimate Customer:Job	16	X	Char 41
Estimate	Transaction Date	Estimate Date			Date
Estimate	RefNumber *	Estimate Estimate #	1	X	Char 11
Estimate	PO Number	Estimate P.O. No.			Char 25
Estimate	Class	Estimate Class			Char 31
Estimate	Template Name	Estimate Template			Char 31
Estimate	To Be Printed		4 6		Char 1
Estimate	BillTo Line1	Estimate Name/Address Box			Char 41
Estimate	BillTo Line2	Estimate Name/Address Box			Char 41
Estimate	BillTo Line3	Estimate Name/Address Box			Char 41
Estimate	BillTo Line4	Estimate Name/Address Box			Char 41
Estimate	BillTo City	Estimate Name/Address Box			Char 31
Estimate	BillTo State	Estimate Name/Address Box			Char 21
Estimate	BillTo PostalCode	Estimate Name/Address Box			Char 13
Estimate	BillTo Country	Estimate Name/Address Box			Char 31
Estimate	ShipTo Line1	Estimate Ship to Box			Char 41
Estimate	ShipTo Line2	Estimate Ship to Box			Char 41
Estimate	ShipTo Line3	Estimate Ship to Box			Char 41
Estimate	ShipTo Line4	Estimate Ship to Box			Char 41
Estimate	ShipTo City	Estimate Ship to Box			Char 31
Estimate	ShipTo State	Estimate Ship to Box			Char 21
Estimate	ShipTo PostalCode	Estimate Ship to Box			Char 13
Estimate	ShipTo Country	Estimate Ship to Box			Char 31
Estimate	Phone	Customer Phone			Char 21
Estimate	Fax	Customer Fax			Char 21
Estimate	Email	Customer Email			Char 1023
Estimate	Contact Name	Customer Contact			Char 41
Estimate	First Name	Customer First Name			Char 25
Estimate	Last Name	Customer Last Name			Char 25
Estimate	Rep	Estimate Rep			Char 5
Estimate	Due Date	Estimate Due Date			Date
Estimate	Customer Message	Estimate Customer Message			Char 101
Estimate	Memo	Estimate Memo			Char 4095
Estimate	Item *	Estimate Item		X	Char 31
Estimate	Quantity	Estimate Qty			Numeric
Estimate	Description	Estimate Description			Char 4095
Estimate	Price	Estimate Rate			Numeric
Estimate	Item Line Class	Estimate Class			Char 31
Estimate	FOB	Estimate FOB			Char 13
Estimate	Customer Acct No	Estimate Account #			Char 99
Estimate	Markup	Estimate Markup			Numeric
Estimate	Markup Is Percent		2 6		Char 1
Estimate	Sales Tax Item	Estimate Tax Item			Char 31
Estimate	To Be EMailed	Estimate To be emailed	6		Char 1
Estimate	Other	Estimate Other			Char 29
Estimate	Other1	Estimate Other1			Char 29
Estimate	Other2	Estimate Other2			Char 29
Estimate	Unit of Measure	Estimate U/M			Char 31
Estimate	Currency	Estimate Customer:Job			Char 64
Estimate	Exchange Rate	Estimate Exchange Rate			Numeric
Estimate	Sales Tax Code	Estimate Tax			Char 3
Inventory Adjustment	RefNumber *	Adjust Quantity/Value on Hand Ref. No.		X	Char 11
Inventory Adjustment	Account *	Adjust Quantity/Value on Hand Adjustment Account	15	X	Char 31
Inventory Adjustment	Transaction Date	Adjust Quantity/Value on Hand Adjustment Date			Date
Inventory Adjustment	Memo	Adjust Quantity/Value on Hand Memo			Char 4095
Inventory Adjustment	Item *	Adjust Quantity/Value on Hand Item		X	Char 31
Inventory Adjustment	New Qty	Adjust Quantity/Value on Hand New Qty			Numeric
Inventory Adjustment	New Value	Adjust Quantity/Value on Hand New Value			Numeric
Inventory Adjustment	Adj Qty	Adjust Quantity/Value on Hand Qty Difference			Numeric
Inventory Adjustment	Adj Value	Adjust Quantity/Value on Hand Value Difference			Numeric
Inventory Adjustment	Customer	Adjust Quantity/Value on Hand Customer:Job	16		Char 41
Inventory Adjustment	Class	Adjust Quantity/Value on Hand Class			Char 31
Inventory Adjustment	Inventory Site	Adjust Quantity/Value on Hand Site	13		Char 31
Inventory Adjustment	Inventory Bin	Adjust Quanity/Value on Hand Bin	13, 14		Char 31
Invoice	Customer *	Invoice Customer:Job	16	X	Char 41
Invoice	Transaction Date	Invoice Date			Date
Invoice	RefNumber *	Invoice Invoice #	1	X	Char 11
Invoice	SO RefNumber *	S.O. No.	11	X	Char 11
Invoice	PO Number	Invoice P.O. Number			Char 25
Invoice	Terms	Invoice Terms			Char 31
Invoice	Class	Invoice Class			Char 31
Invoice	Template Name	Invoice Template			Char 31
Invoice	To Be Printed	Invoice To be printed	6		Char 1
Invoice	Ship Date	Invoice Ship			Date
Invoice	BillTo Line1	Invoice Bill To Address Box			Char 41
Invoice	BillTo Line2	Invoice Bill To Address Box			Char 41
Invoice	BillTo Line3	Invoice Bill To Address Box			Char 41
Invoice	BillTo Line4	Invoice Bill To Address Box			Char 41
Invoice	BillTo City	Invoice Bill To Address Box			Char 31
Invoice	BillTo State	Invoice Bill To Address Box			Char 21
Invoice	BillTo PostalCode	Invoice Bill To Address Box			Char 13
Invoice	BillTo Country	Invoice Bill To Address Box			Char 31
Invoice	ShipTo Line1	Invoice Ship To Address Box			Char 41
Invoice	ShipTo Line2	Invoice Ship To Address Box			Char 41
Invoice	ShipTo Line3	Invoice Ship To Address Box			Char 41
Invoice	ShipTo Line4	Invoice Ship To Address Box			Char 41
Invoice	ShipTo City	Invoice Ship To Address Box			Char 31
Invoice	ShipTo State	Invoice Ship To Address Box			Char 21
Invoice	ShipTo PostalCode	Invoice Ship To Address Box			Char 13
Invoice	ShipTo Country	Invoice Ship To Address Box			Char 31
Invoice	Phone	Customer Phone			Char 21
Invoice	Fax	Customer Fax			Char 21
Invoice	Email	Customer Email			Char 1023
Invoice	Contact Name	Customer Contact			Char 41
Invoice	First Name	Customer First Name			Char 25
Invoice	Last Name	Customer Last Name			Char 25
Invoice	Rep	Customer Rep			Char 5
Invoice	Due Date	Customer Due Date			Date
Invoice	Ship Method	Invoice Via			Char 15
Invoice	Customer Message	Invoice Customer Message			Char 101
Invoice	Memo	Invoice Memo			Char 4095
Invoice	Item *	Invoice Item Code		X	Char 31
Invoice	Quantity	Invoice Qty			Numeric
Invoice	Description	Invoice Description			Char 4095
Invoice	Price	Invoice Price Each			Numeric
Invoice	Is Pending	Invoice Pending (nonposting)	6		Char 1
Invoice	Item Line Class	Invoice Class			Char 31
Invoice	Service Date	Invoice Serviced			Date
Invoice	FOB	Invoice F.O.B.			Char 13
Invoice	Customer Acct No	Invoice Account #			Char 99
Invoice	Sales Tax Item	Invoice Tax			Char 31
Invoice	To Be EMailed	Invoice To be emailed	6		Char 1
Invoice	Other	Invoice Other			Char 29
Invoice	Other1	Invoice Other1			Char 29
Invoice	Other2	Invoice Other2			Char 29
Invoice	Unit of Measure	Invoice U/M			Char 31
Invoice	AR Account	Customer Information Account	15		Char 31
Invoice	Currency	Invoice Customer:Job			Char 64
Invoice	Exchange Rate	Invoice Exchange Rate			Numeric
Invoice	Inventory Site	Invoice Site			Char 31
Invoice	Inventory Bin	Invoice Bin	13, 14		Char 31
Invoice	Serial /Lot Number	Invoice Serial/Lot Number	13		Char 41
Invoice	Sales Tax Code	Invoice Customer Tax Code			Char 3
Item Receipt	Vendor *	Item Receipts Vendor		X	Char 41
Item Receipt	Transaction Date	Item Receipts Date			Date
Item Receipt	RefNumber *	Item Receipts Ref. No.	1	X	Char 11
Item Receipt	Memo	Item Receipts Memo			Char 4095
Item Receipt	Vendor Acct No	Vendor Acct No			Char 99
Item Receipt	Receive Against PO #	Item Receipts PO No.			Char 20
Item Receipt	Items Item	Item Receipts Item	16		Char 31
Item Receipt	Items Qty	Item Receipts Qty			Numeric
Item Receipt	Items Description	Item Receipts Description			Char 4095
Item Receipt	Items Cost	Item Receipts Cost			Numeric
Item Receipt	Items Class	Item Receipts Class			Char 31
Item Receipt	Items Customer	Item Receipts Customer:Job	16		Char 41
Item Receipt	Items Billable	Item Receipts Billable			Char 11
Item Receipt	Expenses Account	Item Receipt Expenses Tab Account	15	5	Char 31
Item Receipt	Expenses Amount	Item Receipt Expenses Tab Amount		5	Numeric
Item Receipt	Expenses Memo	Item Receipt Expenses Tab Memo			Char 4095
Item Receipt	Expenses Class	Item Receipt Expenses Tab Class			Char 31
Item Receipt	Expenses Customer	Item Receipt Expenses Tab Customer:Job	16		Char 41
Item Receipt	Expenses Billable	Item Receipt Expenses Tab Billable	6		Char 1
Item Receipt	AP Account	Item Receipts A/P Account	15		Char 31
Item Receipt	Inventory Site	Item Receipts Site			Char 31
Item Receipt	Inventory Bin	Invoice Bin	13, 14		Char 31
Item Receipt	Currency	Item Receipts Total			Cur 64
Item Receipt	Exchange Rate	Item Receipts Exchange Rate			Char 31
Item Receipt	Serial /Lot Number	Credit Memo Serial/Lot Number	13		Char 41
Item Receipt w/Bill	Vendor *	Bills Vendor		X	Char 41
Item Receipt w/Bill	Transaction Date	Bills Date			Date
Item Receipt w/Bill	RefNumber *	Bills Ref. No.	1	X	Char 11
Item Receipt w/Bill	Memo	Bills Memo			Char 4095
Item Receipt w/Bill	Vendor Acct No	Vendor Account Number			Char 99
Item Receipt w/Bill	Receive Against PO #	Bills PO No.			Char 20
Item Receipt w/Bill	Items Item	Bills Item	16		Char 31
Item Receipt w/Bill	Items Qty	Bills Qty			Numeric
Item Receipt w/Bill	Items Description	Bills Description			Char 4095
Item Receipt w/Bill	Items Cost	Bills Cost			Numeric
Item Receipt w/Bill	Items Class	Bills Class			Char 31
Item Receipt w/Bill	Items Customer	Bills Customer:Job	16		Char 41
Item Receipt w/Bill	Items Billable	Bills Billable?	6		Char 1
Item Receipt w/Bill	AP Account	Bills AP Account	15		Char 31
Journal Entry	RefNumber *	General Journal Entries Entry No.	1	X	Ref 11
Journal Entry	Transaction Date	General Journal Entries Date			Date
Journal Entry	Account *	General Journal Entries Account	15	X	Char 31
Journal Entry	Debit	General Journal Entries Debit		7	Numeric
Journal Entry	Credit	General Journal Entries Credit		7	Numeric
Journal Entry	Memo	General Journal Entries Memo			Char 4095
Journal Entry	Name	General Journal Entries Name			Char 41
Journal Entry	Class	General Journal Entries Class			Char 31
Journal Entry	Billable	General Journal Entries Billable	6		Char 1
Journal Entry	Is Adjustment	General Journal Entry Adjusting Entry			Char 1
Journal Entry	Currency	General Journal Entry Debit/Credit			Char 64
Journal Entry	Exchange Rate	General Journal Entry Exchange Rate			Numeric
Journal Entry	Home Currency Adjustment	General Jourunal Entry Home Currency Adjustment			Char 1
Journal Entry	Amounts in Home Currency				Char 1
Purchase Order	Vendor *	Purchase Order Vendor		X	Char 41
Purchase Order	Transaction Date	Purchase Order Date			Date
Purchase Order	PO Number *	Purchase Order P.O. No.	1	X	Char 25
Purchase Order	Class	Purchase Order Class			Char 31
Purchase Order	ShipTo Entity	Purchase Order Ship To Pulldown			Char 41
Purchase Order	BillTo Line1	Purchase Order Bill To Address Box			Char 41
Purchase Order	BillTo Line2	Purchase Order Bill To Address Box			Char 41
Purchase Order	BillTo Line3	Purchase Order Bill To Address Box			Char 41
Purchase Order	BillTo Line4	Purchase Order Bill To Address Box			Char 31
Purchase Order	BillTo City	Purchase Order Bill To Address Box			Char 21
Purchase Order	BillTo State	Purchase Order Bill To Address Box			Char 13
Purchase Order	BillTo PostalCode	Purchase Order Bill To Address Box			Char 31
Purchase Order	BillTo Country	Purchase Order Bill To Address Box			Char 41
Purchase Order	ShipTo Line1	Purchase Order Ship To Address Box			Char 41
Purchase Order	ShipTo Line2	Purchase Order Ship To Address Box			Char 41
Purchase Order	ShipTo Line3	Purchase Order Ship To Address Box			Char 41
Purchase Order	ShipTo Line4	Purchase Order Ship To Address Box			Char 31
Purchase Order	ShipTo City	Purchase Order Ship To Address Box			Char 21
Purchase Order	ShipTo State	Purchase Order Ship To Address Box			Char 13
Purchase Order	ShipTo PostalCode	Purchase Order Ship To Address Box			Char 31
Purchase Order	ShipTo Country	Purchase Order Ship To Address Box			Char 41
Purchase Order	Terms	Purchase Order Terms			Char 31
Purchase Order	Due Date	Purchase Order Due Date			Date
Purchase Order	Expected	Purchase Order Expected			Date
Purchase Order	Ship Method	Purchase Order Via			Char 15
Purchase Order	FOB	Purchase Order FOB			Char 13
Purchase Order	Vendor Message	Purchase Order Vendor Message			Char 99
Purchase Order	Memo	Purchase Order Memo			Char 4095
Purchase Order	Vendor Acct No	Purchase Order Account #			Char 99
Purchase Order	Item *	Purchase Order Item		X	Char 31
Purchase Order	Quantity	Purchase Order Description			Numeric
Purchase Order	Description	Purchase Order Qty			Char 4095
Purchase Order	Rate	Purchase Order Rate			Numeric
Purchase Order	Customer	Purchase Order Customer	16		Char 31
Purchase Order	Service Date	Purchase Order Serviced			Date
Purchase Order	Template Name	Purchase Order Template			Char 31
Purchase Order	To Be Printed	Purchase Order To be printed	6		Char 1
Purchase Order	Vendor Email	Vendor Email			Char 1023
Purchase Order	To Be EMailed	Purchase Order To be emailed	6		Char 1
Purchase Order	Items Class	Purchase Order Class			Char 31
Purchase Order	Other1_Header	Purchase Order Header Other1			Char 29
Purchase Order	Other2_Header	Purchase Order Header Other2			Char 29
Purchase Order	Other1	Purchase Order Other1			Char 29
Purchase Order	Other2	Purchase Order Other2			Char 31
Purchase Order	Unit of Measure	Purchase Order U/M			Char 31
Purchase Order	Manuf Part Number	Purchase Order Man. Part Num			Char 31
Purchase Order	Currency	Purchase Order Vendor			Char 64
Purchase Order	Exchange Rate	Purchase Order Exchange Rate			Numeric
Purchase Order	Inventory Site	Purchase Order Site			Char 31
Purchase Order	Inventory Bin	Invoice Bin	13, 14		Char 31
Receive Payment	Customer *	Receive Payment Received From	16	X	Char 41
Receive Payment	Check Number *	Receive Payment Check #		X	Char 11
Receive Payment	Transaction Date	Receive Payment Date			Date
Receive Payment	Payment Method	Receive Payment Check			Char 31
Receive Payment	Memo	Receive Payment Memo			Char 4095
Receive Payment	Apply to Invoice (blank autoapplies)	Receive Payment Number			Char 11
Receive Payment	Amount *	Receive Payment Amt. Due		X	Numeric
Receive Payment	Deposit To	Customer Center Account	15		Char 31
Receive Payment	Discount Amount	Receive Payment Discount			Numeric
Receive Payment	Discount Account		3,15		Char 31
Receive Payment	Discount Class	Receive Payment Class			Char 31
Receive Payment	AR Account	Receive Payment A/R Account	15		Char 31
Receive Payment	Exchange Rate	Receive Payment Exchange Rate			Char 64
Sales Order	Customer *	Sales Order Customer:Job	16	X	Char 41
Sales Order	Transaction Date	Sales Order Date			Char 11
Sales Order	RefNumber *	Sales Order S.O. No.	1	X	Char 11
Sales Order	PO Number	Sales Order P.O. No.			Char 25
Sales Order	Class	Sales Order Class			Char 31
Sales Order	Template Name	Sales Order Template			Char 31
Sales Order	To Be Printed	Sales Order To be printed			Char 1
Sales Order	Ship Date	Sales Order To be emailed			Date
Sales Order	BillTo Line1	Sales Order Name/Address Block			Char 41
Sales Order	BillTo Line2	Sales Order Name/Address Block			Char 41
Sales Order	BillTo Line3	Sales Order Name/Address Block			Char 41
Sales Order	BillTo Line4	Sales Order Name/Address Block			Char 31
Sales Order	BillTo City	Sales Order Name/Address Block			Char 21
Sales Order	BillTo State	Sales Order Name/Address Block			Char 13
Sales Order	BillTo PostalCode	Sales Order Name/Address Block			Char 31
Sales Order	BillTo Country	Sales Order Name/Address Block			Char 31
Sales Order	ShipTo Line1	Sales Order Ship To Address Block			Char 41
Sales Order	ShipTo Line2	Sales Order Ship To Address Block			Char 41
Sales Order	ShipTo Line3	Sales Order Ship To Address Block			Char 41
Sales Order	ShipTo Line4	Sales Order Ship To Address Block			Char 31
Sales Order	ShipTo City	Sales Order Ship To Address Block			Char 21
Sales Order	ShipTo State	Sales Order Ship To Address Block			Char 13
Sales Order	ShipTo PostalCode	Sales Order Ship To Address Block			Char 31
Sales Order	ShipTo Country	Sales Order Ship To Address Block			Char 31
Sales Order	Phone	Sales Order Phone			Char 21
Sales Order	Fax	Sales Order Fax			Char 21
Sales Order	Email	Sales Order EMail			Char 1023
Sales Order	Contact Name	Sales Order Contact			Char 41
Sales Order	First Name	Sales Order First Name			Char 25
Sales Order	Last Name	Sales Order Last Name			Char 26
Sales Order	Rep	Sales Order Rep			Char 5
Sales Order	Due Date	Sales Order Due Date			Date
Sales Order	Ship Method	Sales Order Ship Via			Char 15
Sales Order	Customer Message	Sales Order Customer Message			Char 101
Sales Order	Memo	Sales Order Memo			Char 4095
Sales Order	Item *	Sales Order Item		X	Char 31
Sales Order	Quantity	Sales Order Ordered			Numeric
Sales Order	Description	Sales Order Description			Char 4095
Sales Order	Price	Sales Order Rate			Numeric
Sales Order	Item Line Class	Sales Order Class			Char 31
Sales Order	Service Date		4		Date
Sales Order	FOB	Sales Order FOB			Char 13
Sales Order	Customer Acct No	Sales Order Account #			Char 99
Sales Order	Terms	Sales Order Terms			Char 31
Sales Order	Sales Tax Item	Sales Order Sales Tax Item			Char 31
Sales Order	To Be EMailed	Sales Order To be emailed	6		Char 1
Sales Order	Other	Sales Order Other			Char 29
Sales Order	Other1	Sales Order Other1			Char 29
Sales Order	Other2	Sales Order Other2			Char 29
Sales Order	Unit of Measure	Sales Order U/M			Char 31
Sales Order	Currency	Sales Order Customer:Job	16		Char 64
Sales Order	Exchange Rate	Sales Order Amount Due			Numeric
Sales Order	Inventory Site	Sales Order Site			Char 31
Sales Order	Inventory Bin	Sales Order Bin	13, 14		Char 31
Sales Order	Serial /Lot Number	Sales Order Serial/Lot Number	13		Char 41
Sales Order	Sales Tax Code	Sales Order Tax			Char 3
Sales Receipt	Customer *	Sales Receipt Customer:Job	16	X	Char 41
Sales Receipt	Transaction Date	Sales Receipt Date			Date
Sales Receipt	RefNumber *	Sales Receipt Sale No.	1	X	Char 11
Sales Receipt	Payment Method	Sales Receipt Payment Method			Char 31
Sales Receipt	Check Number	Sales Receipt Check No			Char 11
Sales Receipt	Class	Sales Receipt Class			Char 31
Sales Receipt	Template Name	Sales Receipt Template			Char 31
Sales Receipt	To Be Printed	Sales Receipt To be printed	6		Char 1
Sales Receipt	Ship Date	Sales Receipt Ship Date			Date
Sales Receipt	BillTo Line1	Sales Receipt Sold To Address Block			Char 41
Sales Receipt	BillTo Line2	Sales Receipt Sold To Address Block			Char 41
Sales Receipt	BillTo Line3	Sales Receipt Sold To Address Block			Char 41
Sales Receipt	BillTo Line4	Sales Receipt Sold To Address Block			Char 31
Sales Receipt	BillTo City	Sales Receipt Sold To Address Block			Char 21
Sales Receipt	BillTo State	Sales Receipt Sold To Address Block			Char 13
Sales Receipt	BillTo PostalCode	Sales Receipt Sold To Address Block			Char 31
Sales Receipt	BillTo Country	Sales Receipt Sold To Address Block			Char 31
Sales Receipt	ShipTo Line1	Sales Receipt Ship To Address Block			Char 41
Sales Receipt	ShipTo Line2	Sales Receipt Ship To Address Block			Char 41
Sales Receipt	ShipTo Line3	Sales Receipt Ship To Address Block			Char 41
Sales Receipt	ShipTo Line4	Sales Receipt Ship To Address Block			Char 31
Sales Receipt	ShipTo City	Sales Receipt Ship To Address Block			Char 21
Sales Receipt	ShipTo State	Sales Receipt Ship To Address Block			Char 13
Sales Receipt	ShipTo PostalCode	Sales Receipt Ship To Address Block			Char 31
Sales Receipt	ShipTo Country	Sales Receipt Ship To Address Block			Char 31
Sales Receipt	Phone	Customer Phone			Char 21
Sales Receipt	Fax	Customer Fax			Char 21
Sales Receipt	Email	Customer Email			Char 1023
Sales Receipt	Contact Name	Customer Contact			Char 41
Sales Receipt	First Name	Customer First Name			Char 25
Sales Receipt	Last Name	Customer Last Name			Char 25
Sales Receipt	Rep	Sales Receipt Rep			Char 5
Sales Receipt	Due Date	Sales Receipt Due Date			Date
Sales Receipt	Ship Method	Sales Receipt Ship Via			Char 15
Sales Receipt	Customer Message	Sales Receipt Customer Message			Char 99
Sales Receipt	Memo	Sales Receipt Memo			Char 4095
Sales Receipt	Item *	Sales Receipt Item		X	Char 31
Sales Receipt	Quantity	Sales Receipt Qty			Numeric
Sales Receipt	Description	Sales Receipt Description			Char 4095
Sales Receipt	Price	Sales Receipt Rate			Numeric
Sales Receipt	Deposit To	Customer Information Account	15		Char 31
Sales Receipt	Is Pending	Sales Receipts Pending (nonposting)	6		Char 1
Sales Receipt	Item Line Class	Sales Receipt Class			Char 31
Sales Receipt	Service Date	Sales Receipt Serviced			Date
Sales Receipt	FOB	Sales Receipt FOB			Char 13
Sales Receipt	Customer Acct No	Sales Receipt Account #			Char 99
Sales Receipt	Sales Tax Item	Sales Receipt Tax			Char 31
Sales Receipt	To Be EMailed	Sales Receipt To be emailed	6		Char 1
Sales Receipt	Other	Sales Receipt Other			Char 29
Sales Receipt	Other1	Sales Receipt Other1			Char 29
Sales Receipt	Other2	Sales Receipt Other2			Char 29
Sales Receipt	Unit of Measure	Sales Receipt U/M			Char 31
Sales Receipt	Currency	Sales Receipt Customer:Job			Char 64
Sales Receipt	Exchange Rate	Sales Receipt Exchange Rate			Numeric
Sales Receipt	Inventory Site	Sales Receipt Site			Char 31
Sales Receipt	Inventory Bin	Sales Receipt Bin	13, 14		Char 31
Sales Receipt	Serial /Lot Number	Sales Receipt Serial/Lot Number	13		Char 41
Sales Receipt	Sales Tax Code	Sales Receipt Customer Tax Code			Char 3
Statement Charge	Customer *	Statement Customer	16	X	Char 31
Statement Charge	Transaction Date	Statement Date			Date
Statement Charge	RefNumber *		2	X	Char 11
Statement Charge	Item *	Statement Item		X	Char 31
Statement Charge	Description	Statement Description			Char 4095
Statement Charge	Quantity	Statement Quantity			Numeric
Statement Charge	Price	Statement Rate			Numeric
Statement Charge	Bill Date		9		Date
Statement Charge	Due Date	Statement Due Date			Date
Statement Charge	Class	Statement Class			Char 31
Statement Charge	AR Account	Create Statements A/R Account	15		Char 31
Time Tracking	Name *	Time/Enter Single Activity Name		X	Char 209
Time Tracking	Transaction Date	Time/Enter Single Activity Date			Date
Time Tracking	Customer *	Time/Enter Single Activity Customer: Job	16	X	Char 41
Time Tracking	Service Item *	Time/Enter Single Activity Service Item		X	Char 31
Time Tracking	Payroll Item	Time/Enter Single Activity Payroll Item			Char 31
Time Tracking	Duration	Time/Enter Single Activity Duration			Char 10
Time Tracking	Class		4
Time Tracking	Billable		2,6		Char 1
Time Tracking	Notes	Time/Enter Single Activity Notes			Char 4095
Transfer	RefNumber *		2	X
Transfer	Transaction Date	Transfer Funds Date			Date
Transfer	Transfer from Acct *	Transfer Funds Transfer Funds From	15	X	Char 31
Transfer	Transfer to Acct *	Transfer Funds Transfer Funds to	15	X	Char 31
Transfer	Amount *	Transfer Funds Transfer Amount		X	Numeric
Transfer	Class	Transfer Funds Class			Char 31
Transfer	Memo	Transfer Funds Memo			Char 4095
Transfer Inventory	RefNumber *	Transfer Inventory Reference No.		X	Char 11
Transfer Inventory	Transaction Date	Transfer Inventory Date			Date
Transfer Inventory	From Site *	Transfer Inventory Transfer From		X	Char 31
Transfer Inventory	From Bin	Transfer Inventory Transfer To			Char 31
Transfer Inventory	To Site *	Transfer Inventory Transfer From		X	Char 31
Transfer Inventory	To Bin	Transfer Inventory Transfer To			Char 31
Transfer Inventory	Item *	Transfer Inventory Item	16	X	Char 31
Transfer Inventory	Qty to Transfer	Transfer Inventory Qty to Transfer			Numeric
Transfer Inventory	Memo	Transfer Inventory Memo			Char 4095
Transfer Inventory	Serial /Lot Number	Transfer Inventory Serial/Lot Number			Char 41
Vendor Credit	Vendor *	Vendor Credit Vendor		X	Char 41
Vendor Credit	Transaction Date	Vendor Credit Date			Date
Vendor Credit	RefNumber *	Vendor Credit Ref. No.	1	X	Char 11
Vendor Credit	Memo	Vendor Credit Memo			Char 4095
Vendor Credit	Address Line1	Vendor Name and Address Block			Char 41
Vendor Credit	Address Line2	Vendor Name and Address Block			Char 41
Vendor Credit	Address Line3	Vendor Name and Address Block			Char 41
Vendor Credit	Address Line4	Vendor Name and Address Block			Char 31
Vendor Credit	Address City	Vendor Name and Address Block			Char 21
Vendor Credit	Address State	Vendor Name and Address Block			Char 13
Vendor Credit	Address PostalCode	Vendor Name and Address Block			Char 21
Vendor Credit	Address Country	Vendor Name and Address Block			Char 21
Vendor Credit	Vendor Acct No	Vendor Credit Account Number			Char 99
Vendor Credit	Expenses Account	Vendor Credit Expenses Tab Account	15	5	Char 31
Vendor Credit	Expenses Amount	Vendor Credit Expenses Tab Amount		5	Numeric
Vendor Credit	Expenses Memo	Vendor Credit Expenses Tab Memo			Char 4095
Vendor Credit	Expenses Class	Vendor Credit Expenses Tab Class			Char 31
Vendor Credit	Expenses Customer	Vendor Credit Expenses Tab Customer:Job	16		Char 41
Vendor Credit	Expenses Billable	Vendor Credit Expenses Tab Billable?	6		Char 1
Vendor Credit	Items Item	Vendor Credit Items Tab Item	16	5	Char 31
Vendor Credit	Items Qty	Vendor Credit Items Tab Qty		5	Numeric
Vendor Credit	Items Description	Vendor Credit Items Tab Description			Char 4096
Vendor Credit	Items Cost	Vendor Credit Items Tab Cost			Numeric
Vendor Credit	Items Class	Vendor Credit Items Tab Class			Char 31
Vendor Credit	Items Customer	Vendor Credit Items Tab Customer:Job	16		Char 41
Vendor Credit	Items Billable	Vendor Credit Items Tab Billable?	6		Char 1
Vendor Credit	AP Account	Vendor Information Account	15		Char 31
Vendor Credit	Currency	Vendor Credit Vendor			Numeric
Vendor Credit	Exchange Rate	Vendor Credit Exchange Rate			Char 31
Account List	Account Name *	Account Account Name		X	Char 31
Account List	Account Type *	Account Account Type		X	Char 31
Account List	Description	Account Description			Char 29
Account List	Number	Account Number			Char 7
Account List	Bank Account Number	Account Bank Acct. No.			Char 25
Account List	Is Active	Account Account is inactive	6		Char 1
Class List	Account Name *	Class Name		X	Char 31
Customer List	Customer Name *	Customer Customer	16	X	Char 41
Customer List	Is Active	Make Customer:Job inactive	6		Char 1
Customer List	Company Name	Customer Company Name			Char 41
Customer List	Salutation	Customer Mr./Ms.?...			Char 15
Customer List	First Name	Customer First Name			Char 25
Customer List	M.I.	Customer M.I.			Char 5
Customer List	Last Name	Customer Last Name			Char 25
Customer List	Contact	Customer Contact			Char 41
Customer List	Phone	Customer Phone			Char 21
Customer List	Fax	Customer FAX			Char 21
Customer List	Alt. Phone	Customer Alt. Phone			Char 21
Customer List	Alt. Contact	Customer Alt. Contact			Char 41
Customer List	Email	Customer Email			Char 1023
Customer List	BillTo Line1	Customer Bill To Address Block			Char 41
Customer List	BillTo Line2	Customer Bill To Address Block			Char 41
Customer List	BillTo Line3	Customer Bill To Address Block			Char 41
Customer List	BillTo Line4	Customer Bill To Address Block			Char 31
Customer List	BillTo City	Customer Bill To Address Block			Char 31
Customer List	BillTo State	Customer Bill To Address Block			Char 13
Customer List	BillTo PostalCode	Customer Bill To Address Block			Char 31
Customer List	BillTo Country	Customer Bill To Address Block			Char 31
Customer List	ShipTo Line1	Customer Ship to Address Block			Char 41
Customer List	ShipTo Line2	Customer Ship to Address Block			Char 41
Customer List	ShipTo Line3	Customer Ship to Address Block			Char 41
Customer List	ShipTo Line4	Customer Ship to Address Block			Char 31
Customer List	ShipTo City	Customer Ship to Address Block			Char 21
Customer List	ShipTo State	Customer Ship to Address Block			Char 13
Customer List	ShipTo PostalCode	Customer Ship to Address Block			Char 31
Customer List	ShipTo Country	Customer Ship to Address Block			Char 31
Customer List	Customer Type	Customer Additional Info Tab Type			Char 159
Customer List	Terms	Customer Additional Info Tab Terms			Char 31
Customer List	Sales Rep	Customer Additional Info Tab Rep			Char 5
Customer List	Resale No.	Customer Additional Info Tab Resale Number			Char 15
Customer List	Price Level	Customer Additional Info Tab Price Level			Char 31
Customer List	Account Number	Customer Payment Info Tab Account No.			Char 99
Customer List	Credit Limit	Customer Payment Info Tab Credit Limit			Numeric
Customer List	Payment Method	Customer Payment Info Tab Preferred Payment Method			Char 31
Customer List	Notes	Customer Notes			Char 4095
Customer List	Sales Tax Code	Customer Additional Info Tab Tax Code			Char 3
Customer List	Sales Tax Item	Customer Additional Info Tab Tax Item			Char 31
Customer List	Job Status	Customer Job Info Tab Job Status			Char 15
Customer List	Job Start Date	Customer Job Info Tab Start Date			Date
Customer List	Job Projected End	Customer Job Info Tab Projected End			Date
Customer List	Job End Date	Customer Job Info Tab End Date			Date
Customer List	Job Description	Customer Job Info Tab Job Description			Char 99
Customer List	Job Type	Customer Job Info Tab Job Type			Char 159
Customer List	Currency	Customer Currency			Char 64
Employee List	First Name *	Employee First Name		X	Char 25
Employee List	Last Name *	Employee Last Name		X	Char 25
Employee List	Middle Name	Employee M.I.			Char 5
Employee List	Is Active	Make Employee Inactive	6		Char 1
Employee List	Salutation	Employee Mr./Ms.?...			Char 15
Employee List	Print on Check	Employee Print on Checks As			Char 41
Employee List	SS No	Employee SS No.			Char 15
Employee List	Gender	Employee Gender			Char 1
Employee List	Date of Birth	Employee Date of Birth			Date
Employee List	Date Hired	Employee Date Hired			Date
Employee List	Date Released	Employee Date Released			Date
Employee List	Address Line1	Employee Address and Contact Tab Address			Char 41
Employee List	Address Line2	Employee Address and Contact Tab Address			Char 41
Employee List	Address City	Employee Address and Contact Tab City			Char 31
Employee List	Address State	Employee Address and Contact Tab State			Char 21
Employee List	Address PostalCode	Employee Address and Contact Tab Zip			Char 13
Employee List	Phone	Employee Address and Contact Tab			Char 21
Employee List	Cellular	Employee Address and Contact Tab Cellular			Char 21
Employee List	Alt. Phone	Employee Address and Contact Tab Alt. Phone			Char 21
Employee List	Fax	Employee Address and Contact Tab Fax			Char 21
Employee List	Email	Employee Address and Contact Tab Email			Char 1023
Employee List	Pager	Employee Address and Contact Tab Pager			Char 21
Employee List	PIN (Pager)	Employee Address and Contact Tab PIN (Pager)			Char 10
Employee List	Account Number	Employee Additional Info Tab Account No.			Char 99
Employee List	Notes	Employee Notes			Char 4095
Item Assembly	Assembly Item Name *	Inventory Assembly Item Name/Number		X	Char 31
Item Assembly	Parent Item Name	Inventory Assembly Item Name/Number			Char 31
Item Assembly	Income Account *	Inventory Assembly Income Account	15	X	Char 31
Item Assembly	COGS Account *	Inventory Assembly COGS Account	15	X	Char 31
Item Assembly	Asset Account *	Inventory Assembly Asset Account	15	X	Char 31
Item Assembly	Purchase Cost	Inventory Assembly Cost			Numeric
Item Assembly	Purchase Description	Inventory Assembly Description			Char 4095
Item Assembly	Sales Price	Inventory Assembly Sales Price			Numeric
Item Assembly	Sales Description	Inventory Assembly Description			Char 4095
Item Assembly	Build Point	Inventory Assembly Build Point			Numeric
Item Assembly	Component Item Name	Inventory Assembly Bill of Materials Item			Char 31
Item Assembly	Component Item Qty	Inventory Assembly Bill of Materials Qty			Numeric
Item Assembly	Unit of Measure	Inventory Assembly U/M Set			Char 31
Item Assembly	Sales Tax Code	Inventory Assembly Sales Tax Code			Char 3
Item Fixed Asset	Asset Name *	Fixed Asset Asset Name/Number		X	Char 31
Item Fixed Asset	Asset Account	Fixed Asset Asset Account	15		Char 31
Item Fixed Asset	Acquired as New	Fixed Asset Item is			Char 1
Item Fixed Asset	Purchase Description	Fixed Asset Purchase Description			Char 4095
Item Fixed Asset	Purchase Date	Fixed Asset Purchase Date			Date
Item Fixed Asset	Purchase Cost	Fixed Asset Purchase Cost			Numeric
Item Fixed Asset	Vendor or Payee	Fixed Asset Purchase Vendor/Payee			Char 41
Item Fixed Asset	Sales Description	Fixed Asset Sales Description			Char 4095
Item Fixed Asset	Sales Date	Fixed Asset Sales Date			Date
Item Fixed Asset	Sales Price	Fixed Asset Sales Price			Numeric
Item Fixed Asset	Sales Expense	Fixed Asset Sales Expense			Numeric
Item Fixed Asset	Asset Description	Fixed Asset Asset Description			Char 4095
Item Fixed Asset	Location	Fixed Asset Location			Char 50
Item Fixed Asset	PO Number	Fixed Asset PO Number			Char 30
Item Fixed Asset	Serial Number	Fixed Asset Serial Number			Char 40
Item Fixed Asset	Warranty Expires	Fixed Asset Warranty Expires			Date
Item Fixed Asset	Notes	Fixed Asset Notes			Char 4095
Item Group	Group Name *	Group Item Group Name/Number		X	Char 31
Item Group	Description	Group Item Description			Char 4095
Item Group	Print Items in Group				Char 1
Item Group	Group Line Item Name *	Group Item Item		X	Char 31
Item Group	Group Line Item Qty *	Group Item Qty		X	Numeric
Item List	Item Name *	Item Item Name/Number	8, 16	X	Char 31
Item List	Item Type *	Item Type	8	X	Char 31
Item List	Is Active	Item Item is inactive	6		Char 1
Item List	Sales Description	Item Description on Sales Transactions			Char 4095
Item List	Purchase Description	Item Description on Purchase Transactions			Char 4096
Item List	Tax Code	Item Tax code			Char 3
Item List	Account/Income Account	Item Income Account	15		Char 31
Item List	Expense/COGS Account	Item COGS Account	15		Char 31
Item List	Asset Account	Item Asset Account	15		Char 31
Item List	Cost	Item Cost			Numeric
Item List	Preferred Vendor	Item Preferred Vendor			Char 41
Item List	Price or %		10		Char 20
Item List	Reorder Point	Item Reorder Point			Numeric
Item List	Manuf Part Number	Item Manufacturer's Part Number			Char 31
Item List	Unit of Measure	Item U/M			Char 31
Item Sales Tax	Sales Tax Item Name *	Sales Tax Item Sales Tax Name		X	Char 31
Item Sales Tax	Tax Rate *	Sales Tax Item Tax Rate (%)		X	Char 20
Item Sales Tax	Tax Agency *	Sales Tax Item Tax Agency (vendor that you collect for)		X	Char 41
Item Sales Tax	Description	Sales Tax Item Description			Char 4095
Other Name List	Other Name *	Other Name Name		X	Char 31
Other Name List	Is Active	Other Name Name is inactive	6		Char 1
Other Name List	Company Name	Other Name Company Name			Char 41
Other Name List	Salutation	Other Name Mr./Ms./É			Char 15
Other Name List	First Name	Other Name First Name			Char 25
Other Name List	M.I.	Other Name M.I.			Char 5
Other Name List	Last Name	Other Name Last Name			Char 25
Other Name List	Address Line1	Other Name Name and Address Block			Char 41
Other Name List	Address Line2	Other Name Name and Address Block			Char 41
Other Name List	Address Line3	Other Name Name and Address Block			Char 41
Other Name List	Address Line4	Other Name Name and Address Block			Char 41
Other Name List	Address City	Other Name Name and Address Block			Char 31
Other Name List	Address State	Other Name Name and Address Block			Char 21
Other Name List	Address PostalCode	Other Name Name and Address Block			Char 13
Other Name List	Address Country	Other Name Name and Address Block			Char 31
Other Name List	Contact	Other Name Contact			Char 41
Other Name List	Phone	Other Name Phone			Char 21
Other Name List	Fax	Other Name FAX			Char 21
Other Name List	Alt. Phone	Other Name Alt. Ph.			Char 21
Other Name List	Alt. Contact	Other Name Alt. Contact			Char 21
Other Name List	Email	Other Name Email			Char 1023
Other Name List	Account Number	Other Name Account No.			Char 99
Other Name List	Notes	Other Name Notes			Char 4095
Price Level List	Name *	Price Level Price Level Name		X	Char 31
Price Level List	Is Active	Price Level Price Level is Active			Char 1
Price Level List	Type *	Price Level Price Level Type		X	Char 20
Price Level List	Fixed Percentage	Price Level Fixed %			Numeric
Price Level List	Item	Price Level Item			Char 31
Price Level List	Custom Price	Price Level Custom Price			Numeric
Price Level List	Adjust Relative To	Price Level than its box			Char 20
Vendor List	Vendor Name *	Vendor Vendor Name		X	Char 41
Vendor List	Is Active	Make Vendor Inactive	6		Char 1
Vendor List	Company Name	Vendor Company Name			Char 25
Vendor List	Salutation	Vendor Mr./Ms./É			Char 15
Vendor List	First Name	Vendor First Name			Char 25
Vendor List	M.I.	Vendor Last Name			Char 5
Vendor List	Last Name	Vendor Last Name			Char 25
Vendor List	Contact	Vendor Contact			Char 41
Vendor List	Phone	Vendor Phone			Char 21
Vendor List	Fax	Vendor FAX			Char 21
Vendor List	Alt. Phone	Vendor Alt. Phone			Char 21
Vendor List	Alt. Contact	Vendor Alt. Contact			Char 21
Vendor List	Email	Vendor Email			Char 1023
Vendor List	Print on Check	Vendor Print on Check As			Char 41
Vendor List	Address Line1	Vendor Name and Address Block			Char 41
Vendor List	Address Line2	Vendor Name and Address Block			Char 41
Vendor List	Address Line3	Vendor Name and Address Block			Char 41
Vendor List	Address Line4	Vendor Name and Address Block			Char 31
Vendor List	Address City	Vendor Name and Address Block			Char 31
Vendor List	Address State	Vendor Name and Address Block			Char 21
Vendor List	Address PostalCode	Vendor Name and Address Block			Char 13
Vendor List	Address Country	Vendor Name and Address Block			Char 31
Vendor List	Vendor Type	Vendor Additional Info Tab Type			Char 159
Vendor List	Terms	Vendor Additional Info Tab Terms			Char 31
Vendor List	Tax ID	Vendor Additional Info Tab Tax ID			Char 14
Vendor List	Eligible for 1099	Vendor Additional Info Tab Vendor eligible for 1099			Char 1
Vendor List	Account Number	Vendor Additional Info Tab Account No.			Char 99
Vendor List	Credit Limit	Vendor Additional Info Tab Credit Limit			Numeric
Vendor List	Notes	Vendor Notes			Char 4095
Vendor List	Prefill Account	Vendor Account Settings			Char 31
Vendor List	Billing Rate	Vendor Billing Rate Level			Numeric
Vendor List	Currency	Vendor Currency			Char 64

Data Dictionary Notes:

If option, let QuickBooks auto assign transaction number is not selected
For internal TPI processing only
Used to determine which account that the discount should be applied to
Ignored not supported by QBSDK
If you are using expenses accounts the following fields are required: expenses account and expenses amount. If you are using items the following fields are required: items item and items cost.
The following values can be used: Y or N, T or F, 1 or 0.
Depends on options selected.
Required fields on the item list import and dependent on the item type.
Used in statement date query.
For dollars put in the actual dollar amount or put in the actual percentage with the % sign (5.25 or 5.25%).
Need to enable the command line parameter /INVOICESO1 for this field to be available.
Look to the fields on the Check or Deposit Transaction further on down in this dictionary.
Available in Enterprise 2011 and later versions with an Advanced Inventory Subscription.
Option 1: If these two fields are in two different columns map the column that has the value Warehouse A to the QuickBooks field, Inventory Site, and the column that has the value, Location 100 to the QuickBooks field, Inventory Bin. Option 2: If these two fields are in one column with a colon in between them (Warehouse A:Location 100) map the column that contains this data to the QuickBooks field, Inventory Site.
Use the lowest sub account number or the entire account name (eg account:subaccount).
For customers or items include the parent and child separated by a colon (eg parent:child).
Negative Amounts are imported as charges and positive amounts are imported as credits.
This field is used if you have a parent and a child assembly.Sample Import files: