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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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:
Sample Import files:
- Account List Sample
- BILL ITEM SAMPLE
- Bill Payment Sample
- Bill Sample
- Check Sample
- Credit Card Charge Sample
- Credit Card Credit Sample
- Credit Memo Sample
- Customer List Sample
- Deposit Sample
- eCom SALES RECEIPT SAMPLE
- Employee List Sample
- Estimate Sample
- Inventory Adjustment Sample
- Invoice Sample
- Item Assembly Sample
- Item Fixed Asset Sample
- Item Group Sample
- Item List Sample
- Item Receipt Sample
- Item Receipt with Bill Sample
- Journal Entry Sample
- Other Name List Sample
- Price Level Sample
- Purchase Order Sample
- Receive Payment Sample
- Sales Order Sample
- Sales Receipt Sample
- Statement Charge Sample
- Time Tracking Sample
- Vendor Credit Expense Sample
- Vendor Credit Sample
- Vendor List Sample
Sample Import MAP files:
- Account List Map
- Bill item Map Bill Map
- Bill Payment Map
- Check Map
- Credit Card Charge Map
- Credit Card Credit Map
- Credit Memo map
- Customer List Map
- Deposit Map
- Ecom Sales Receipt
- eCommerce Sales
- Receipt Map
- Employee List Map
- Estimate Map
- Inventory Adjustment Map
- Invoice Map Item Assembly map
- Item Fixed Asset map
- Item List Map
- Item Receipt Map
- Item Receipt With Bill Map
- Journal Entry Map
- Other Names List Map
- Price Level map
- Purchase Order Map
- Receive Payment Map
- Sales Order Map Sales Receipt Map
- Statement Charge Map
- Time Tracking Map
- Vendor Credit Map
- Vendor List Map
This article/post is not supposed to be self-explanatory, this is a link of resources for experienced users
Other Options:
- Download Data Dictionary from TPI site
- Download Sample Import & Map from TPI site
- View Data Dictionary in Google Sheets