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 StatementBank Account *1215XChar 31
Bank StatementTransaction Date12Date
Bank StatementPayee *12XChar 31
Bank StatementChk No.12Char 11
Bank StatementAccount *1215XChar 31
Bank StatementAmount *12XNumeric
Bank StatementMemo12Char 4095
Bank StatementClass12Char 41
Bank StatementBillable12Char 1
Bank StatementBillable Entity12Char 41
BillVendor *Bill VendorXChar 41
BillTransaction DateBill DateDate
BillRefNumber *Bill Ref. No.1XChar 20
BillBill DueBill Bill DueDate
BillTermsBill TermsChar 31
BillMemoBill MemoChar 4095
BillAddress Line1Bill Address BoxChar 41
BillAddress Line2Bill Address BoxChar 41
BillAddress Line3Bill Address BoxChar 41
BillAddress Line4Bill Address BoxChar 41
BillAddress CityBill Address BoxChar 31
BillAddress StateBill Address BoxChar 21
BillAddress PostalCodeBill Address BoxChar 13
BillAddress CountryBill Address BoxChar 21
BillVendor Acct NoBill Account NumberChar 99
BillExpenses AccountBill Expenses Tab Account155Char 31
BillExpenses AmountBill Expenses Tab Amount5Numeric
BillExpenses MemoBill Expenses Tab MemoChar 4095
BillExpenses ClassBill Expenses Tab ClassChar 31
BillExpenses CustomerBill Expenses Tab Customer:Job16Char 41
BillExpenses BillableBill Expenses Tab Billable?6Char 1
BillItems ItemBill Items Tab Items5Char 31
BillItems QtyBill Items Tab QtyNumeric
BillItems DescriptionBill Items Tab DescriptionChar 4095
BillItems CostBill Items Tab Cost5Numeric
BillItems ClassBill Items Tab ClassChar 31
BillItems CustomerBill Items Tab Customer:Job16Char 41
BillItems BillableBill Items Tab Billable?6Char 1
BillUnit of MeasureBill Items Tab U/MChar 31
BillAP AccountVendor Information Account15Char 31
BillCurrencyBill Amount DueChar 64
BillExchange RateBill Exhange RateNumeric
BillInventory SiteBill Items TabSite13Char 31
BillInventory BinBill Items TabBin13, 14Char 31
BillSerial/Lot NumberBill Items TabSerial/Lot Number13Char 41
Bill PaymentPayee *Pay Bills VendorXChar 41
Bill PaymentTransaction DatePayment Summary Payment DateDate
Bill PaymentApply to Bill RefNumberPay Bills Ref. No.Char 20
Bill PaymentPayment Method *Pay Bills MethodXChar 31
Bill PaymentBank AccountPay Bills Account15Char 31
Bill PaymentCredit Card AccountPay Bills Account15Char 31
Bill PaymentRefNumber *2XChar 11
Bill PaymentAmount *Pay Bills Amt. to PayXNumeric
Bill PaymentMemoCheck MemoChar 4095
Bill PaymentDiscount AmountPay Bill Discounts and Credits Amount of DiscountNumeric
Bill PaymentDiscount AccountPay Bill Discounts and Credits Discount Account15Char 31
Bill PaymentTo Be PrintedCheck To be printed6Char 1
Bill PaymentExchange RateNumeric
CheckBank Account *Vendor Information Account15XChar 31
CheckPayee *Check Pay to the Order ofXChar 41
CheckTransaction DateCheck DateDate
CheckRefNumber *Check No.XChar 11
CheckMemoCheck MemoChar 4095
CheckAddress Line1Check Address BoxChar 41
CheckAddress Line2Check Address BoxChar 41
CheckAddress Line3Check Address BoxChar 41
CheckAddress Line4Check Address BoxChar 41
CheckAddress CityCheck Address BoxChar 31
CheckAddress StateCheck Address BoxChar 21
CheckAddress PostalCodeCheck Address BoxChar 13
CheckAddress CountryCheck Address BoxChar 21
CheckVendor Acct NoCheck Account NumberChar 99
CheckExpenses AccountCheck Expenses Tab Account155Char 31
CheckExpenses AmountCheck Expenses Tab Amount5Numeric
CheckExpenses MemoCheck Expenses Tab MemoChar 4095
CheckExpenses ClassCheck Expenses Tab ClassChar 31
CheckExpenses CustomerCheck Expenses Tab Customer:Job16Char 41
CheckExpenses BillableCheck Expenses Tab Billable6Char 1
CheckItems ItemCheck Items Tab Item165Char 31
CheckItems QtyCheck Items Tab QtyNumeric
CheckItems DescriptionCheck Items Tab DescriptionChar 4095
CheckItems CostCheck Items Tab Cost5Numeric
CheckItems ClassCheck Items Tab ClassChar 31
CheckItems CustomerCheck Items Tab Customer:Job16Char 41
CheckUnit of MeasureCheck Items Tab U/MChar 31
CheckItems BillableCheck Items Tab Billable?6Char 1
CheckCurrencyCheck Pay to the Order ofChar 64
CheckExchange RateCheck Exhange RateNumeric
CheckInventory SiteCheck Items TabSite13Char 31
CheckInventory BinCheck Items TabBin13, 14Char 31
CheckSerial/Lot NumberCheck Items TabSerial/Lot Number13Char 41
Credit Card ChargeCredit Card Account *Credit Card Charges Credit Card15XChar 31
Credit Card ChargePayee *Credit Card Charges Purchased FromXChar 31
Credit Card ChargeTransaction DateCredit Card Charges DateDate
Credit Card ChargeRefNumber *Credit Card Charges Ref No.1XChar 11
Credit Card ChargeMemoCredit Card Charges MemoChar 4095
Credit Card ChargeAddress Line1Vendor Name and AddressChar 41
Credit Card ChargeAddress Line2Vendor Name and AddressChar 41
Credit Card ChargeAddress Line3Vendor Name and AddressChar 41
Credit Card ChargeAddress Line4Vendor Name and AddressChar 41
Credit Card ChargeAddress CityVendor Name and AddressChar 31
Credit Card ChargeAddress StateVendor Name and AddressChar 21
Credit Card ChargeAddress PostalCodeVendor Name and AddressChar 13
Credit Card ChargeAddress CountryVendor Name and AddressChar 21
Credit Card ChargeExpenses AccountCredit Card Charges Expenses Tab Account155Char 31
Credit Card ChargeExpenses AmountCredit Card Charges Expenses Tab Amount5Numeric
Credit Card ChargeExpenses MemoCredit Card Charges Expenses Tab MemoChar 4095
Credit Card ChargeExpenses ClassCredit Card Charges Expenses Tab ClassChar 31
Credit Card ChargeExpenses CustomerCredit Card Charges Expenses Tab Customer:Job16Char 41
Credit Card ChargeExpenses BillableCredit Card Charges Expenses Tab Billable6Char 1
Credit Card ChargeItems ItemCredit Card Charges Items Tab Item165Char 31
Credit Card ChargeItems QtyCredit Card Charges Items Tab QtyNumeric
Credit Card ChargeItems DescriptionCredit Card Charges Items Tab DescriptionChar 4095
Credit Card ChargeItems CostCredit Card Charges Items Tab Cost5Numeric
Credit Card ChargeItems ClassCredit Card Charges Items Tab ClassChar 31
Credit Card ChargeItems CustomerCredit Card Charges Items Tab Customer:Job16Char 41
Credit Card ChargeItems BillableCredit Card Charges Items Tab Billable?6Char 1
Credit Card ChargeCurrencyCredit Card Charges AmountChar 64
Credit Card ChargeExchange RateCredit Card Charges Exchange RateNumeric
Credit Card ChargeInventory SiteCredit Card Charges Items TabSite13Char 31
Credit Card ChargeInventory BinCredit Card Charges Items TabBin13, 14Char 31
Credit Card ChargeSerial/Lot NumberCheck Items TabSerial/Lot Number13Char 41
Credit Card CreditCredit Card Account *Credit Card Refund Credit Card15XChar 31
Credit Card CreditPayee *Credit Card Refund Purchased FromXChar 31
Credit Card CreditTransaction DateCredit Card Refund DateDate
Credit Card CreditRefNumber *Credit Card Refund Ref No.1XChar 11
Credit Card CreditMemoCredit Card Refund MemoChar 4095
Credit Card CreditAddress Line1Vendor Name and AddressChar 41
Credit Card CreditAddress Line2Vendor Name and AddressChar 41
Credit Card CreditAddress Line3Vendor Name and AddressChar 41
Credit Card CreditAddress Line4Vendor Name and AddressChar 41
Credit Card CreditAddress CityVendor Name and AddressChar 31
Credit Card CreditAddress StateVendor Name and AddressChar 21
Credit Card CreditAddress PostalCodeVendor Name and AddressChar 13
Credit Card CreditAddress CountryVendor Name and AddressChar 21
Credit Card CreditExpenses AccountCredit Card Credits Expenses Tab Account155Char 31
Credit Card CreditExpenses AmountCredit Card Credits Expenses Tab Amount5Numeric
Credit Card CreditExpenses MemoCredit Card Credits Expenses Tab MemoChar 4095
Credit Card CreditExpenses ClassCredit Card Credits Expenses Tab ClassChar 31
Credit Card CreditExpenses CustomerCredit Card Credits Expenses Tab Customer:Job16Char 41
Credit Card CreditExpenses BillableCredit Card Credits Expenses Tab Billable6Char 1
Credit Card CreditItems ItemCredit Card Credits Items Tab Item165Char 31
Credit Card CreditItems QtyCredit Card Credits Items Tab QtyNumeric
Credit Card CreditItems DescriptionCredit Card Credits Items Tab DescriptionChar 4095
Credit Card CreditItems CostCredit Card Credits Items Tab Cost5Numeric
Credit Card CreditItems ClassCredit Card Credits Items Tab ClassChar 31
Credit Card CreditItems CustomerCredit Card Credits Items Tab Customer:Job16Char 41
Credit Card CreditItems BillableCredit Card Credits Items Tab Billable?6Char 1
Credit Card CreditCurrencyCredit Card Credit AmountChar 64
Credit Card CreditExchange RateCredit card Credit Exchange RateNumeric
Credit Card CreditInventory SiteCredit Card Credits Items TabSite13Char 31
Credit Card CreditInventory BinCredit Card Credits Items TabBin13, 14Char 31
Credit Card CreditSerial/Lot NumberCredit Card Credits Items TabSerial/Lot Number13Char 41
Credit Card StatementCredit Card Account *Credit Card Charges/Credits Credit Card15XChar 31
Credit Card StatementTransaction DateCredit Card Charges/Credits DateDate
Credit Card StatementPayee *Credit Card Charges/Credits Purchased FromXChar 31
Credit Card StatementRefNumberCredit Card Charges/Credits Ref No.Char 11
Credit Card StatementAccount *Credit Card Charges/Credits Expenses Tab Account15XChar 31
Credit Card StatementAmount *Credit Card Charges/Credits Expenses Tab Amount17XNumeric
Credit Card StatementMemoCredit Card Charges/Credits MemoChar 4095
Credit Card StatementClassCredit Card Charges/Credits Expenses Tab ClassChar 31
Credit Card StatementBillableCredit Card Charges/Credits Expenses Tab BillableChar 1
Credit Card StatementBillable EntityCredit Card Charges/Credits Expenses Tab Customer:JobChar 41
Credit MemoCustomer *Credit Memos/Refunds Customer:Job16XChar 41
Credit MemoTransaction DateCredit Memos/Refunds DateDate
Credit MemoRefNumber *Credit Memos/Refunds Credit No.1XChar 11
Credit MemoPO NumberCredit Memos/Refunds P.O. No.Char 25
Credit MemoTermsCredit Memos/Refunds TermsChar 31
Credit MemoClassCredit Memos/Refunds ClassChar 31
Credit MemoTemplate NameCredit Memos/Refunds TemplateChar 31
Credit MemoTo Be PrintedCredit Memos/Refunds To be printedChar 1
Credit MemoShip DateCredit Memos/Refunds Ship DateDate
Credit MemoBillTo Line1Credit Memos/Refunds Customer BlockChar 41
Credit MemoBillTo Line2Credit Memos/Refunds Customer BlockChar 41
Credit MemoBillTo Line3Credit Memos/Refunds Customer BlockChar 41
Credit MemoBillTo Line4Credit Memos/Refunds Customer BlockChar 41
Credit MemoBillTo CityCredit Memos/Refunds Customer BlockChar 31
Credit MemoBillTo StateCredit Memos/Refunds Customer BlockChar 21
Credit MemoBillTo PostalCodeCredit Memos/Refunds Customer BlockChar 13
Credit MemoBillTo CountryCredit Memos/Refunds Customer BlockChar 31
Credit MemoShipTo Line1Credit Memos/Refunds Ship To BlockChar 41
Credit MemoShipTo Line2Credit Memos/Refunds Ship To BlockChar 41
Credit MemoShipTo Line3Credit Memos/Refunds Ship To BlockChar 41
Credit MemoShipTo Line4Credit Memos/Refunds Ship To BlockChar 41
Credit MemoShipTo CityCredit Memos/Refunds Ship To BlockChar 31
Credit MemoShipTo StateCredit Memos/Refunds Ship To BlockChar 21
Credit MemoShipTo PostalCodeCredit Memos/Refunds Ship To BlockChar 13
Credit MemoShipTo CountryCredit Memos/Refunds Ship To BlockChar 31
Credit MemoPhoneCustomer PhoneChar 21
Credit MemoFaxCustomer FaxChar 21
Credit MemoEmailCustomer EmailChar 1023
Credit MemoContact NameCustomer ContactChar 41
Credit MemoFirst NameCustomer First NameChar 25
Credit MemoLast NameCustomer Last NameChar 25
Credit MemoRepCredit Memos/Refunds RepChar 5
Credit MemoDue DateCredit Memos/Refunds Due DateDate
Credit MemoShip MethodCredit Memos/Refunds Ship ViaChar 15
Credit MemoCustomer MessageCredit Memos/Refunds Customer MessageChar 101
Credit MemoMemoCredit Memos/Refunds MemoChar 4095
Credit MemoItem *Credit Memos/Refunds ItemXChar 31
Credit MemoQuantityCredit Memos/Refunds QtyNumeric
Credit MemoDescriptionCredit Memos/Refunds DescriptionChar 4095
Credit MemoPriceCredit Memos/Refunds RateNumeric
Credit MemoIs PendingCredit Memos/Refunds Pending (nonposting)6Char 1
Credit MemoItem Line ClassCredit Memos/Refunds ClassChar 31
Credit MemoService DateCredit Memos/Refunds ServicedDate
Credit MemoCustomer Acct NoCredit Memos/Refunds Account No.Char 99
Credit MemoSales Tax ItemCredit Memos/Refunds Transaction Line TaxChar 31
Credit MemoTo Be EMailedCredit Memos/Refunds To be emailedChar 1
Credit MemoOtherCredit Memos/Refunds OtherChar 29
Credit MemoOther1Credit Memos/Refunds Other 1Char 29
Credit MemoOther2Credit Memos/Refunds Other 2Char 29
Credit MemoUnit of MeasureCredit Memos/Refunds U/MChar 31
Credit MemoAR AccountCredit Memos/Refunds Account15Char 31
Credit MemoCurrencyCredit Memo Customer:Job16Char 64
Credit MemoExchange RateCredit Memo Exhange RateNumeric
Credit MemoInventory SiteCredit Memo Site13Char 31
Credit MemoInventory BinCredit Memo Bin13, 14Char 31
Credit MemoSerial /Lot NumberCredit Memo Serial/Lot Number13Char 41
Credit MemoSales Tax CodeCredit Memos/Refunds Total TaxChar 3
DepositRefNumber *2XChar 11
DepositDeposit to Account *Deposits Deposit To15XChar 31
DepositTransaction DateDeposits DateDate
DepositDeposit MemoDeposits MemoChar 4095
DepositReceived FromDeposits Received FromChar 31
DepositFrom Account *Deposits From Account15XChar 31
DepositMemoDeposits Transaction Line MemoChar 4095
DepositChk No.Deposits Chk No.Char 11
DepositPayment MethodDeposits Pmt Meth.Char 31
DepositClassDeposits ClassChar 31
DepositAmount *Deposits AmountXNumeric
DepositCurrencyDeposit Deposit TotalChar 64
DepositExchange RateDeposit Exchange RateNumeric
EstimateCustomer *Estimate Customer:Job16XChar 41
EstimateTransaction DateEstimate DateDate
EstimateRefNumber *Estimate Estimate #1XChar 11
EstimatePO NumberEstimate P.O. No.Char 25
EstimateClassEstimate ClassChar 31
EstimateTemplate NameEstimate TemplateChar 31
EstimateTo Be Printed4 6Char 1
EstimateBillTo Line1Estimate Name/Address BoxChar 41
EstimateBillTo Line2Estimate Name/Address BoxChar 41
EstimateBillTo Line3Estimate Name/Address BoxChar 41
EstimateBillTo Line4Estimate Name/Address BoxChar 41
EstimateBillTo CityEstimate Name/Address BoxChar 31
EstimateBillTo StateEstimate Name/Address BoxChar 21
EstimateBillTo PostalCodeEstimate Name/Address BoxChar 13
EstimateBillTo CountryEstimate Name/Address BoxChar 31
EstimateShipTo Line1Estimate Ship to BoxChar 41
EstimateShipTo Line2Estimate Ship to BoxChar 41
EstimateShipTo Line3Estimate Ship to BoxChar 41
EstimateShipTo Line4Estimate Ship to BoxChar 41
EstimateShipTo CityEstimate Ship to BoxChar 31
EstimateShipTo StateEstimate Ship to BoxChar 21
EstimateShipTo PostalCodeEstimate Ship to BoxChar 13
EstimateShipTo CountryEstimate Ship to BoxChar 31
EstimatePhoneCustomer PhoneChar 21
EstimateFaxCustomer FaxChar 21
EstimateEmailCustomer EmailChar 1023
EstimateContact NameCustomer ContactChar 41
EstimateFirst NameCustomer First NameChar 25
EstimateLast NameCustomer Last NameChar 25
EstimateRepEstimate RepChar 5
EstimateDue DateEstimate Due DateDate
EstimateCustomer MessageEstimate Customer MessageChar 101
EstimateMemoEstimate MemoChar 4095
EstimateItem *Estimate ItemXChar 31
EstimateQuantityEstimate QtyNumeric
EstimateDescriptionEstimate DescriptionChar 4095
EstimatePriceEstimate RateNumeric
EstimateItem Line ClassEstimate ClassChar 31
EstimateFOBEstimate FOBChar 13
EstimateCustomer Acct NoEstimate Account #Char 99
EstimateMarkupEstimate MarkupNumeric
EstimateMarkup Is Percent2 6Char 1
EstimateSales Tax ItemEstimate Tax ItemChar 31
EstimateTo Be EMailedEstimate To be emailed6Char 1
EstimateOtherEstimate OtherChar 29
EstimateOther1Estimate Other1Char 29
EstimateOther2Estimate Other2Char 29
EstimateUnit of MeasureEstimate U/MChar 31
EstimateCurrencyEstimate Customer:JobChar 64
EstimateExchange RateEstimate Exchange RateNumeric
EstimateSales Tax CodeEstimate TaxChar 3
Inventory AdjustmentRefNumber *Adjust Quantity/Value on Hand Ref. No.XChar 11
Inventory AdjustmentAccount *Adjust Quantity/Value on Hand Adjustment Account15XChar 31
Inventory AdjustmentTransaction DateAdjust Quantity/Value on Hand Adjustment DateDate
Inventory AdjustmentMemoAdjust Quantity/Value on Hand MemoChar 4095
Inventory AdjustmentItem *Adjust Quantity/Value on Hand ItemXChar 31
Inventory AdjustmentNew QtyAdjust Quantity/Value on Hand New QtyNumeric
Inventory AdjustmentNew ValueAdjust Quantity/Value on Hand New ValueNumeric
Inventory AdjustmentAdj QtyAdjust Quantity/Value on Hand Qty DifferenceNumeric
Inventory AdjustmentAdj ValueAdjust Quantity/Value on Hand Value DifferenceNumeric
Inventory AdjustmentCustomerAdjust Quantity/Value on Hand Customer:Job16Char 41
Inventory AdjustmentClassAdjust Quantity/Value on Hand ClassChar 31
Inventory AdjustmentInventory SiteAdjust Quantity/Value on Hand Site13Char 31
Inventory AdjustmentInventory BinAdjust Quanity/Value on Hand Bin13, 14Char 31
InvoiceCustomer *Invoice Customer:Job16XChar 41
InvoiceTransaction DateInvoice DateDate
InvoiceRefNumber *Invoice Invoice #1XChar 11
InvoiceSO RefNumber *S.O. No.11XChar 11
InvoicePO NumberInvoice P.O. NumberChar 25
InvoiceTermsInvoice TermsChar 31
InvoiceClassInvoice ClassChar 31
InvoiceTemplate NameInvoice TemplateChar 31
InvoiceTo Be PrintedInvoice To be printed6Char 1
InvoiceShip DateInvoice ShipDate
InvoiceBillTo Line1Invoice Bill To Address BoxChar 41
InvoiceBillTo Line2Invoice Bill To Address BoxChar 41
InvoiceBillTo Line3Invoice Bill To Address BoxChar 41
InvoiceBillTo Line4Invoice Bill To Address BoxChar 41
InvoiceBillTo CityInvoice Bill To Address BoxChar 31
InvoiceBillTo StateInvoice Bill To Address BoxChar 21
InvoiceBillTo PostalCodeInvoice Bill To Address BoxChar 13
InvoiceBillTo CountryInvoice Bill To Address BoxChar 31
InvoiceShipTo Line1Invoice Ship To Address BoxChar 41
InvoiceShipTo Line2Invoice Ship To Address BoxChar 41
InvoiceShipTo Line3Invoice Ship To Address BoxChar 41
InvoiceShipTo Line4Invoice Ship To Address BoxChar 41
InvoiceShipTo CityInvoice Ship To Address BoxChar 31
InvoiceShipTo StateInvoice Ship To Address BoxChar 21
InvoiceShipTo PostalCodeInvoice Ship To Address BoxChar 13
InvoiceShipTo CountryInvoice Ship To Address BoxChar 31
InvoicePhoneCustomer PhoneChar 21
InvoiceFaxCustomer FaxChar 21
InvoiceEmailCustomer EmailChar 1023
InvoiceContact NameCustomer ContactChar 41
InvoiceFirst NameCustomer First NameChar 25
InvoiceLast NameCustomer Last NameChar 25
InvoiceRepCustomer RepChar 5
InvoiceDue DateCustomer Due DateDate
InvoiceShip MethodInvoice ViaChar 15
InvoiceCustomer MessageInvoice Customer MessageChar 101
InvoiceMemoInvoice MemoChar 4095
InvoiceItem *Invoice Item CodeXChar 31
InvoiceQuantityInvoice QtyNumeric
InvoiceDescriptionInvoice DescriptionChar 4095
InvoicePriceInvoice Price EachNumeric
InvoiceIs PendingInvoice Pending (nonposting)6Char 1
InvoiceItem Line ClassInvoice ClassChar 31
InvoiceService DateInvoice ServicedDate
InvoiceFOBInvoice F.O.B.Char 13
InvoiceCustomer Acct NoInvoice Account #Char 99
InvoiceSales Tax ItemInvoice TaxChar 31
InvoiceTo Be EMailedInvoice To be emailed6Char 1
InvoiceOtherInvoice OtherChar 29
InvoiceOther1Invoice Other1Char 29
InvoiceOther2Invoice Other2Char 29
InvoiceUnit of MeasureInvoice U/MChar 31
InvoiceAR AccountCustomer Information Account15Char 31
InvoiceCurrencyInvoice Customer:JobChar 64
InvoiceExchange RateInvoice Exchange RateNumeric
InvoiceInventory SiteInvoice SiteChar 31
InvoiceInventory BinInvoice Bin13, 14Char 31
InvoiceSerial /Lot NumberInvoice Serial/Lot Number13Char 41
InvoiceSales Tax CodeInvoice Customer Tax CodeChar 3
Item ReceiptVendor *Item Receipts VendorXChar 41
Item ReceiptTransaction DateItem Receipts DateDate
Item ReceiptRefNumber *Item Receipts Ref. No.1XChar 11
Item ReceiptMemoItem Receipts MemoChar 4095
Item ReceiptVendor Acct NoVendor Acct NoChar 99
Item ReceiptReceive Against PO #Item Receipts PO No.Char 20
Item ReceiptItems ItemItem Receipts Item16Char 31
Item ReceiptItems QtyItem Receipts QtyNumeric
Item ReceiptItems DescriptionItem Receipts DescriptionChar 4095
Item ReceiptItems CostItem Receipts CostNumeric
Item ReceiptItems ClassItem Receipts ClassChar 31
Item ReceiptItems CustomerItem Receipts Customer:Job16Char 41
Item ReceiptItems BillableItem Receipts BillableChar 11
Item ReceiptExpenses AccountItem Receipt Expenses Tab Account155Char 31
Item ReceiptExpenses AmountItem Receipt Expenses Tab Amount5Numeric
Item ReceiptExpenses MemoItem Receipt Expenses Tab MemoChar 4095
Item ReceiptExpenses ClassItem Receipt Expenses Tab ClassChar 31
Item ReceiptExpenses CustomerItem Receipt Expenses Tab Customer:Job16Char 41
Item ReceiptExpenses BillableItem Receipt Expenses Tab Billable6Char 1
Item ReceiptAP AccountItem Receipts A/P Account15Char 31
Item ReceiptInventory SiteItem Receipts SiteChar 31
Item ReceiptInventory BinInvoice Bin13, 14Char 31
Item ReceiptCurrencyItem Receipts TotalCur 64
Item ReceiptExchange RateItem Receipts Exchange RateChar 31
Item ReceiptSerial /Lot NumberCredit Memo Serial/Lot Number13Char 41
Item Receipt w/BillVendor *Bills VendorXChar 41
Item Receipt w/BillTransaction DateBills DateDate
Item Receipt w/BillRefNumber *Bills Ref. No.1XChar 11
Item Receipt w/BillMemoBills MemoChar 4095
Item Receipt w/BillVendor Acct NoVendor Account NumberChar 99
Item Receipt w/BillReceive Against PO #Bills PO No.Char 20
Item Receipt w/BillItems ItemBills Item16Char 31
Item Receipt w/BillItems QtyBills QtyNumeric
Item Receipt w/BillItems DescriptionBills DescriptionChar 4095
Item Receipt w/BillItems CostBills CostNumeric
Item Receipt w/BillItems ClassBills ClassChar 31
Item Receipt w/BillItems CustomerBills Customer:Job16Char 41
Item Receipt w/BillItems BillableBills Billable?6Char 1
Item Receipt w/BillAP AccountBills AP Account15Char 31
Journal EntryRefNumber *General Journal Entries Entry No.1XRef 11
Journal EntryTransaction DateGeneral Journal Entries DateDate
Journal EntryAccount *General Journal Entries Account15XChar 31
Journal EntryDebitGeneral Journal Entries Debit7Numeric
Journal EntryCreditGeneral Journal Entries Credit7Numeric
Journal EntryMemoGeneral Journal Entries MemoChar 4095
Journal EntryNameGeneral Journal Entries NameChar 41
Journal EntryClassGeneral Journal Entries ClassChar 31
Journal EntryBillableGeneral Journal Entries Billable6Char 1
Journal EntryIs AdjustmentGeneral Journal Entry Adjusting EntryChar 1
Journal EntryCurrencyGeneral Journal Entry Debit/CreditChar 64
Journal EntryExchange RateGeneral Journal Entry Exchange RateNumeric
Journal EntryHome Currency AdjustmentGeneral Jourunal Entry Home Currency AdjustmentChar 1
Journal EntryAmounts in Home CurrencyChar 1
Purchase OrderVendor *Purchase Order VendorXChar 41
Purchase OrderTransaction DatePurchase Order DateDate
Purchase OrderPO Number *Purchase Order P.O. No.1XChar 25
Purchase OrderClassPurchase Order ClassChar 31
Purchase OrderShipTo EntityPurchase Order Ship To PulldownChar 41
Purchase OrderBillTo Line1Purchase Order Bill To Address BoxChar 41
Purchase OrderBillTo Line2Purchase Order Bill To Address BoxChar 41
Purchase OrderBillTo Line3Purchase Order Bill To Address BoxChar 41
Purchase OrderBillTo Line4Purchase Order Bill To Address BoxChar 31
Purchase OrderBillTo CityPurchase Order Bill To Address BoxChar 21
Purchase OrderBillTo StatePurchase Order Bill To Address BoxChar 13
Purchase OrderBillTo PostalCodePurchase Order Bill To Address BoxChar 31
Purchase OrderBillTo CountryPurchase Order Bill To Address BoxChar 41
Purchase OrderShipTo Line1Purchase Order Ship To Address BoxChar 41
Purchase OrderShipTo Line2Purchase Order Ship To Address BoxChar 41
Purchase OrderShipTo Line3Purchase Order Ship To Address BoxChar 41
Purchase OrderShipTo Line4Purchase Order Ship To Address BoxChar 31
Purchase OrderShipTo CityPurchase Order Ship To Address BoxChar 21
Purchase OrderShipTo StatePurchase Order Ship To Address BoxChar 13
Purchase OrderShipTo PostalCodePurchase Order Ship To Address BoxChar 31
Purchase OrderShipTo CountryPurchase Order Ship To Address BoxChar 41
Purchase OrderTermsPurchase Order TermsChar 31
Purchase OrderDue DatePurchase Order Due DateDate
Purchase OrderExpectedPurchase Order ExpectedDate
Purchase OrderShip MethodPurchase Order ViaChar 15
Purchase OrderFOBPurchase Order FOBChar 13
Purchase OrderVendor MessagePurchase Order Vendor MessageChar 99
Purchase OrderMemoPurchase Order MemoChar 4095
Purchase OrderVendor Acct NoPurchase Order Account #Char 99
Purchase OrderItem *Purchase Order ItemXChar 31
Purchase OrderQuantityPurchase Order DescriptionNumeric
Purchase OrderDescriptionPurchase Order QtyChar 4095
Purchase OrderRatePurchase Order RateNumeric
Purchase OrderCustomerPurchase Order Customer16Char 31
Purchase OrderService DatePurchase Order ServicedDate
Purchase OrderTemplate NamePurchase Order TemplateChar 31
Purchase OrderTo Be PrintedPurchase Order To be printed6Char 1
Purchase OrderVendor EmailVendor EmailChar 1023
Purchase OrderTo Be EMailedPurchase Order To be emailed6Char 1
Purchase OrderItems ClassPurchase Order ClassChar 31
Purchase OrderOther1_HeaderPurchase Order Header Other1Char 29
Purchase OrderOther2_HeaderPurchase Order Header Other2Char 29
Purchase OrderOther1Purchase Order Other1Char 29
Purchase OrderOther2Purchase Order Other2Char 31
Purchase OrderUnit of MeasurePurchase Order U/MChar 31
Purchase OrderManuf Part NumberPurchase Order Man. Part NumChar 31
Purchase OrderCurrencyPurchase Order VendorChar 64
Purchase OrderExchange RatePurchase Order Exchange RateNumeric
Purchase OrderInventory SitePurchase Order SiteChar 31
Purchase OrderInventory BinInvoice Bin13, 14Char 31
Receive PaymentCustomer *Receive Payment Received From16XChar 41
Receive PaymentCheck Number *Receive Payment Check #XChar 11
Receive PaymentTransaction DateReceive Payment DateDate
Receive PaymentPayment MethodReceive Payment CheckChar 31
Receive PaymentMemoReceive Payment MemoChar 4095
Receive PaymentApply to Invoice (blank autoapplies)Receive Payment NumberChar 11
Receive PaymentAmount *Receive Payment Amt. DueXNumeric
Receive PaymentDeposit ToCustomer Center Account15Char 31
Receive PaymentDiscount AmountReceive Payment DiscountNumeric
Receive PaymentDiscount Account3,15Char 31
Receive PaymentDiscount ClassReceive Payment ClassChar 31
Receive PaymentAR AccountReceive Payment A/R Account15Char 31
Receive PaymentExchange RateReceive Payment Exchange RateChar 64
Sales OrderCustomer *Sales Order Customer:Job16XChar 41
Sales OrderTransaction DateSales Order DateChar 11
Sales OrderRefNumber *Sales Order S.O. No.1XChar 11
Sales OrderPO NumberSales Order P.O. No.Char 25
Sales OrderClassSales Order ClassChar 31
Sales OrderTemplate NameSales Order TemplateChar 31
Sales OrderTo Be PrintedSales Order To be printedChar 1
Sales OrderShip DateSales Order To be emailedDate
Sales OrderBillTo Line1Sales Order Name/Address BlockChar 41
Sales OrderBillTo Line2Sales Order Name/Address BlockChar 41
Sales OrderBillTo Line3Sales Order Name/Address BlockChar 41
Sales OrderBillTo Line4Sales Order Name/Address BlockChar 31
Sales OrderBillTo CitySales Order Name/Address BlockChar 21
Sales OrderBillTo StateSales Order Name/Address BlockChar 13
Sales OrderBillTo PostalCodeSales Order Name/Address BlockChar 31
Sales OrderBillTo CountrySales Order Name/Address BlockChar 31
Sales OrderShipTo Line1Sales Order Ship To Address BlockChar 41
Sales OrderShipTo Line2Sales Order Ship To Address BlockChar 41
Sales OrderShipTo Line3Sales Order Ship To Address BlockChar 41
Sales OrderShipTo Line4Sales Order Ship To Address BlockChar 31
Sales OrderShipTo CitySales Order Ship To Address BlockChar 21
Sales OrderShipTo StateSales Order Ship To Address BlockChar 13
Sales OrderShipTo PostalCodeSales Order Ship To Address BlockChar 31
Sales OrderShipTo CountrySales Order Ship To Address BlockChar 31
Sales OrderPhoneSales Order PhoneChar 21
Sales OrderFaxSales Order FaxChar 21
Sales OrderEmailSales Order EMailChar 1023
Sales OrderContact NameSales Order ContactChar 41
Sales OrderFirst NameSales Order First NameChar 25
Sales OrderLast NameSales Order Last NameChar 26
Sales OrderRepSales Order RepChar 5
Sales OrderDue DateSales Order Due DateDate
Sales OrderShip MethodSales Order Ship ViaChar 15
Sales OrderCustomer MessageSales Order Customer MessageChar 101
Sales OrderMemoSales Order MemoChar 4095
Sales OrderItem *Sales Order ItemXChar 31
Sales OrderQuantitySales Order OrderedNumeric
Sales OrderDescriptionSales Order DescriptionChar 4095
Sales OrderPriceSales Order RateNumeric
Sales OrderItem Line ClassSales Order ClassChar 31
Sales OrderService Date4Date
Sales OrderFOBSales Order FOBChar 13
Sales OrderCustomer Acct NoSales Order Account #Char 99
Sales OrderTermsSales Order TermsChar 31
Sales OrderSales Tax ItemSales Order Sales Tax ItemChar 31
Sales OrderTo Be EMailedSales Order To be emailed6Char 1
Sales OrderOtherSales Order OtherChar 29
Sales OrderOther1Sales Order Other1Char 29
Sales OrderOther2Sales Order Other2Char 29
Sales OrderUnit of MeasureSales Order U/MChar 31
Sales OrderCurrencySales Order Customer:Job16Char 64
Sales OrderExchange RateSales Order Amount DueNumeric
Sales OrderInventory SiteSales Order SiteChar 31
Sales OrderInventory BinSales Order Bin13, 14Char 31
Sales OrderSerial /Lot NumberSales Order Serial/Lot Number13Char 41
Sales OrderSales Tax CodeSales Order TaxChar 3
Sales ReceiptCustomer *Sales Receipt Customer:Job16XChar 41
Sales ReceiptTransaction DateSales Receipt DateDate
Sales ReceiptRefNumber *Sales Receipt Sale No.1XChar 11
Sales ReceiptPayment MethodSales Receipt Payment MethodChar 31
Sales ReceiptCheck NumberSales Receipt Check NoChar 11
Sales ReceiptClassSales Receipt ClassChar 31
Sales ReceiptTemplate NameSales Receipt TemplateChar 31
Sales ReceiptTo Be PrintedSales Receipt To be printed6Char 1
Sales ReceiptShip DateSales Receipt Ship DateDate
Sales ReceiptBillTo Line1Sales Receipt Sold To Address BlockChar 41
Sales ReceiptBillTo Line2Sales Receipt Sold To Address BlockChar 41
Sales ReceiptBillTo Line3Sales Receipt Sold To Address BlockChar 41
Sales ReceiptBillTo Line4Sales Receipt Sold To Address BlockChar 31
Sales ReceiptBillTo CitySales Receipt Sold To Address BlockChar 21
Sales ReceiptBillTo StateSales Receipt Sold To Address BlockChar 13
Sales ReceiptBillTo PostalCodeSales Receipt Sold To Address BlockChar 31
Sales ReceiptBillTo CountrySales Receipt Sold To Address BlockChar 31
Sales ReceiptShipTo Line1Sales Receipt Ship To Address BlockChar 41
Sales ReceiptShipTo Line2Sales Receipt Ship To Address BlockChar 41
Sales ReceiptShipTo Line3Sales Receipt Ship To Address BlockChar 41
Sales ReceiptShipTo Line4Sales Receipt Ship To Address BlockChar 31
Sales ReceiptShipTo CitySales Receipt Ship To Address BlockChar 21
Sales ReceiptShipTo StateSales Receipt Ship To Address BlockChar 13
Sales ReceiptShipTo PostalCodeSales Receipt Ship To Address BlockChar 31
Sales ReceiptShipTo CountrySales Receipt Ship To Address BlockChar 31
Sales ReceiptPhoneCustomer PhoneChar 21
Sales ReceiptFaxCustomer FaxChar 21
Sales ReceiptEmailCustomer EmailChar 1023
Sales ReceiptContact NameCustomer ContactChar 41
Sales ReceiptFirst NameCustomer First NameChar 25
Sales ReceiptLast NameCustomer Last NameChar 25
Sales ReceiptRepSales Receipt RepChar 5
Sales ReceiptDue DateSales Receipt Due DateDate
Sales ReceiptShip MethodSales Receipt Ship ViaChar 15
Sales ReceiptCustomer MessageSales Receipt Customer MessageChar 99
Sales ReceiptMemoSales Receipt MemoChar 4095
Sales ReceiptItem *Sales Receipt ItemXChar 31
Sales ReceiptQuantitySales Receipt QtyNumeric
Sales ReceiptDescriptionSales Receipt DescriptionChar 4095
Sales ReceiptPriceSales Receipt RateNumeric
Sales ReceiptDeposit ToCustomer Information Account15Char 31
Sales ReceiptIs PendingSales Receipts Pending (nonposting)6Char 1
Sales ReceiptItem Line ClassSales Receipt ClassChar 31
Sales ReceiptService DateSales Receipt ServicedDate
Sales ReceiptFOBSales Receipt FOBChar 13
Sales ReceiptCustomer Acct NoSales Receipt Account #Char 99
Sales ReceiptSales Tax ItemSales Receipt TaxChar 31
Sales ReceiptTo Be EMailedSales Receipt To be emailed6Char 1
Sales ReceiptOtherSales Receipt OtherChar 29
Sales ReceiptOther1Sales Receipt Other1Char 29
Sales ReceiptOther2Sales Receipt Other2Char 29
Sales ReceiptUnit of MeasureSales Receipt U/MChar 31
Sales ReceiptCurrencySales Receipt Customer:JobChar 64
Sales ReceiptExchange RateSales Receipt Exchange RateNumeric
Sales ReceiptInventory SiteSales Receipt SiteChar 31
Sales ReceiptInventory BinSales Receipt Bin13, 14Char 31
Sales ReceiptSerial /Lot NumberSales Receipt Serial/Lot Number13Char 41
Sales ReceiptSales Tax CodeSales Receipt Customer Tax CodeChar 3
Statement ChargeCustomer *Statement Customer16XChar 31
Statement ChargeTransaction DateStatement DateDate
Statement ChargeRefNumber *2XChar 11
Statement ChargeItem *Statement ItemXChar 31
Statement ChargeDescriptionStatement DescriptionChar 4095
Statement ChargeQuantityStatement QuantityNumeric
Statement ChargePriceStatement RateNumeric
Statement ChargeBill Date9Date
Statement ChargeDue DateStatement Due DateDate
Statement ChargeClassStatement ClassChar 31
Statement ChargeAR AccountCreate Statements A/R Account15Char 31
Time TrackingName *Time/Enter Single Activity NameXChar 209
Time TrackingTransaction DateTime/Enter Single Activity DateDate
Time TrackingCustomer *Time/Enter Single Activity Customer: Job16XChar 41
Time TrackingService Item *Time/Enter Single Activity Service ItemXChar 31
Time TrackingPayroll ItemTime/Enter Single Activity Payroll ItemChar 31
Time TrackingDurationTime/Enter Single Activity DurationChar 10
Time TrackingClass4
Time TrackingBillable2,6Char 1
Time TrackingNotesTime/Enter Single Activity NotesChar 4095
TransferRefNumber *2X
TransferTransaction DateTransfer Funds DateDate
TransferTransfer from Acct *Transfer Funds Transfer Funds From15XChar 31
TransferTransfer to Acct *Transfer Funds Transfer Funds to15XChar 31
TransferAmount *Transfer Funds Transfer AmountXNumeric
TransferClassTransfer Funds ClassChar 31
TransferMemoTransfer Funds MemoChar 4095
Transfer InventoryRefNumber *Transfer Inventory Reference No.XChar 11
Transfer InventoryTransaction DateTransfer Inventory DateDate
Transfer InventoryFrom Site *Transfer Inventory Transfer FromXChar 31
Transfer InventoryFrom BinTransfer Inventory Transfer ToChar 31
Transfer InventoryTo Site *Transfer Inventory Transfer FromXChar 31
Transfer InventoryTo BinTransfer Inventory Transfer ToChar 31
Transfer InventoryItem *Transfer Inventory Item16XChar 31
Transfer InventoryQty to TransferTransfer Inventory Qty to TransferNumeric
Transfer InventoryMemoTransfer Inventory MemoChar 4095
Transfer InventorySerial /Lot NumberTransfer Inventory Serial/Lot NumberChar 41
Vendor CreditVendor *Vendor Credit VendorXChar 41
Vendor CreditTransaction DateVendor Credit DateDate
Vendor CreditRefNumber *Vendor Credit Ref. No.1XChar 11
Vendor CreditMemoVendor Credit MemoChar 4095
Vendor CreditAddress Line1Vendor Name and Address BlockChar 41
Vendor CreditAddress Line2Vendor Name and Address BlockChar 41
Vendor CreditAddress Line3Vendor Name and Address BlockChar 41
Vendor CreditAddress Line4Vendor Name and Address BlockChar 31
Vendor CreditAddress CityVendor Name and Address BlockChar 21
Vendor CreditAddress StateVendor Name and Address BlockChar 13
Vendor CreditAddress PostalCodeVendor Name and Address BlockChar 21
Vendor CreditAddress CountryVendor Name and Address BlockChar 21
Vendor CreditVendor Acct NoVendor Credit Account NumberChar 99
Vendor CreditExpenses AccountVendor Credit Expenses Tab Account155Char 31
Vendor CreditExpenses AmountVendor Credit Expenses Tab Amount5Numeric
Vendor CreditExpenses MemoVendor Credit Expenses Tab MemoChar 4095
Vendor CreditExpenses ClassVendor Credit Expenses Tab ClassChar 31
Vendor CreditExpenses CustomerVendor Credit Expenses Tab Customer:Job16Char 41
Vendor CreditExpenses BillableVendor Credit Expenses Tab Billable?6Char 1
Vendor CreditItems ItemVendor Credit Items Tab Item165Char 31
Vendor CreditItems QtyVendor Credit Items Tab Qty5Numeric
Vendor CreditItems DescriptionVendor Credit Items Tab DescriptionChar 4096
Vendor CreditItems CostVendor Credit Items Tab CostNumeric
Vendor CreditItems ClassVendor Credit Items Tab ClassChar 31
Vendor CreditItems CustomerVendor Credit Items Tab Customer:Job16Char 41
Vendor CreditItems BillableVendor Credit Items Tab Billable?6Char 1
Vendor CreditAP AccountVendor Information Account15Char 31
Vendor CreditCurrencyVendor Credit VendorNumeric
Vendor CreditExchange RateVendor Credit Exchange RateChar 31
Account ListAccount Name *Account Account NameXChar 31
Account ListAccount Type *Account Account TypeXChar 31
Account ListDescriptionAccount DescriptionChar 29
Account ListNumberAccount NumberChar 7
Account ListBank Account NumberAccount Bank Acct. No.Char 25
Account ListIs ActiveAccount Account is inactive6Char 1
Class ListAccount Name *Class NameXChar 31
Customer ListCustomer Name *Customer Customer16XChar 41
Customer ListIs ActiveMake Customer:Job inactive6Char 1
Customer ListCompany NameCustomer Company NameChar 41
Customer ListSalutationCustomer Mr./Ms.?...Char 15
Customer ListFirst NameCustomer First NameChar 25
Customer ListM.I.Customer M.I.Char 5
Customer ListLast NameCustomer Last NameChar 25
Customer ListContactCustomer ContactChar 41
Customer ListPhoneCustomer PhoneChar 21
Customer ListFaxCustomer FAXChar 21
Customer ListAlt. PhoneCustomer Alt. PhoneChar 21
Customer ListAlt. ContactCustomer Alt. ContactChar 41
Customer ListEmailCustomer EmailChar 1023
Customer ListBillTo Line1Customer Bill To Address BlockChar 41
Customer ListBillTo Line2Customer Bill To Address BlockChar 41
Customer ListBillTo Line3Customer Bill To Address BlockChar 41
Customer ListBillTo Line4Customer Bill To Address BlockChar 31
Customer ListBillTo CityCustomer Bill To Address BlockChar 31
Customer ListBillTo StateCustomer Bill To Address BlockChar 13
Customer ListBillTo PostalCodeCustomer Bill To Address BlockChar 31
Customer ListBillTo CountryCustomer Bill To Address BlockChar 31
Customer ListShipTo Line1Customer Ship to Address BlockChar 41
Customer ListShipTo Line2Customer Ship to Address BlockChar 41
Customer ListShipTo Line3Customer Ship to Address BlockChar 41
Customer ListShipTo Line4Customer Ship to Address BlockChar 31
Customer ListShipTo CityCustomer Ship to Address BlockChar 21
Customer ListShipTo StateCustomer Ship to Address BlockChar 13
Customer ListShipTo PostalCodeCustomer Ship to Address BlockChar 31
Customer ListShipTo CountryCustomer Ship to Address BlockChar 31
Customer ListCustomer TypeCustomer Additional Info Tab TypeChar 159
Customer ListTermsCustomer Additional Info Tab TermsChar 31
Customer ListSales RepCustomer Additional Info Tab RepChar 5
Customer ListResale No.Customer Additional Info Tab Resale NumberChar 15
Customer ListPrice LevelCustomer Additional Info Tab Price LevelChar 31
Customer ListAccount NumberCustomer Payment Info Tab Account No.Char 99
Customer ListCredit LimitCustomer Payment Info Tab Credit LimitNumeric
Customer ListPayment MethodCustomer Payment Info Tab Preferred Payment MethodChar 31
Customer ListNotesCustomer NotesChar 4095
Customer ListSales Tax CodeCustomer Additional Info Tab Tax CodeChar 3
Customer ListSales Tax ItemCustomer Additional Info Tab Tax ItemChar 31
Customer ListJob StatusCustomer Job Info Tab Job StatusChar 15
Customer ListJob Start DateCustomer Job Info Tab Start DateDate
Customer ListJob Projected EndCustomer Job Info Tab Projected EndDate
Customer ListJob End DateCustomer Job Info Tab End DateDate
Customer ListJob DescriptionCustomer Job Info Tab Job DescriptionChar 99
Customer ListJob TypeCustomer Job Info Tab Job TypeChar 159
Customer ListCurrencyCustomer CurrencyChar 64
Employee ListFirst Name *Employee First NameXChar 25
Employee ListLast Name *Employee Last NameXChar 25
Employee ListMiddle NameEmployee M.I.Char 5
Employee ListIs ActiveMake Employee Inactive6Char 1
Employee ListSalutationEmployee Mr./Ms.?...Char 15
Employee ListPrint on CheckEmployee Print on Checks AsChar 41
Employee ListSS NoEmployee SS No.Char 15
Employee ListGenderEmployee GenderChar 1
Employee ListDate of BirthEmployee Date of BirthDate
Employee ListDate HiredEmployee Date HiredDate
Employee ListDate ReleasedEmployee Date ReleasedDate
Employee ListAddress Line1Employee Address and Contact Tab AddressChar 41
Employee ListAddress Line2Employee Address and Contact Tab AddressChar 41
Employee ListAddress CityEmployee Address and Contact Tab CityChar 31
Employee ListAddress StateEmployee Address and Contact Tab StateChar 21
Employee ListAddress PostalCodeEmployee Address and Contact Tab ZipChar 13
Employee ListPhoneEmployee Address and Contact Tab Char 21
Employee ListCellularEmployee Address and Contact Tab CellularChar 21
Employee ListAlt. PhoneEmployee Address and Contact Tab Alt. PhoneChar 21
Employee ListFaxEmployee Address and Contact Tab FaxChar 21
Employee ListEmailEmployee Address and Contact Tab EmailChar 1023
Employee ListPagerEmployee Address and Contact Tab PagerChar 21
Employee ListPIN (Pager)Employee Address and Contact Tab PIN (Pager)Char 10
Employee ListAccount NumberEmployee Additional Info Tab Account No.Char 99
Employee ListNotesEmployee NotesChar 4095
Item AssemblyAssembly Item Name *Inventory Assembly Item Name/NumberXChar 31
Item AssemblyParent Item NameInventory Assembly Item Name/NumberChar 31
Item AssemblyIncome Account *Inventory Assembly Income Account15XChar 31
Item AssemblyCOGS Account *Inventory Assembly COGS Account15XChar 31
Item AssemblyAsset Account *Inventory Assembly Asset Account15XChar 31
Item AssemblyPurchase CostInventory Assembly CostNumeric
Item AssemblyPurchase DescriptionInventory Assembly DescriptionChar 4095
Item AssemblySales PriceInventory Assembly Sales PriceNumeric
Item AssemblySales DescriptionInventory Assembly DescriptionChar 4095
Item AssemblyBuild PointInventory Assembly Build PointNumeric
Item AssemblyComponent Item NameInventory Assembly Bill of Materials ItemChar 31
Item AssemblyComponent Item QtyInventory Assembly Bill of Materials QtyNumeric
Item AssemblyUnit of MeasureInventory Assembly U/M SetChar 31
Item AssemblySales Tax CodeInventory Assembly Sales Tax CodeChar 3
Item Fixed AssetAsset Name *Fixed Asset Asset Name/NumberXChar 31
Item Fixed AssetAsset AccountFixed Asset Asset Account15Char 31
Item Fixed AssetAcquired as NewFixed Asset Item isChar 1
Item Fixed AssetPurchase DescriptionFixed Asset Purchase DescriptionChar 4095
Item Fixed AssetPurchase DateFixed Asset Purchase DateDate
Item Fixed AssetPurchase CostFixed Asset Purchase CostNumeric
Item Fixed AssetVendor or PayeeFixed Asset Purchase Vendor/PayeeChar 41
Item Fixed AssetSales DescriptionFixed Asset Sales DescriptionChar 4095
Item Fixed AssetSales DateFixed Asset Sales DateDate
Item Fixed AssetSales PriceFixed Asset Sales PriceNumeric
Item Fixed AssetSales ExpenseFixed Asset Sales ExpenseNumeric
Item Fixed AssetAsset DescriptionFixed Asset Asset DescriptionChar 4095
Item Fixed AssetLocationFixed Asset LocationChar 50
Item Fixed AssetPO NumberFixed Asset PO NumberChar 30
Item Fixed AssetSerial NumberFixed Asset Serial NumberChar 40
Item Fixed AssetWarranty ExpiresFixed Asset Warranty ExpiresDate
Item Fixed AssetNotesFixed Asset NotesChar 4095
Item GroupGroup Name *Group Item Group Name/NumberXChar 31
Item GroupDescriptionGroup Item DescriptionChar 4095
Item GroupPrint Items in GroupChar 1
Item GroupGroup Line Item Name *Group Item ItemXChar 31
Item GroupGroup Line Item Qty *Group Item QtyXNumeric
Item ListItem Name *Item Item Name/Number8, 16XChar 31
Item ListItem Type *Item Type8XChar 31
Item ListIs ActiveItem Item is inactive6Char 1
Item ListSales DescriptionItem Description on Sales TransactionsChar 4095
Item ListPurchase DescriptionItem Description on Purchase TransactionsChar 4096
Item ListTax CodeItem Tax codeChar 3
Item ListAccount/Income AccountItem Income Account15Char 31
Item ListExpense/COGS AccountItem COGS Account15Char 31
Item ListAsset AccountItem Asset Account15Char 31
Item ListCostItem CostNumeric
Item ListPreferred VendorItem Preferred VendorChar 41
Item ListPrice or %10Char 20
Item ListReorder PointItem Reorder PointNumeric
Item ListManuf Part NumberItem Manufacturer's Part NumberChar 31
Item ListUnit of MeasureItem U/MChar 31
Item Sales TaxSales Tax Item Name *Sales Tax Item Sales Tax NameXChar 31
Item Sales TaxTax Rate *Sales Tax Item Tax Rate (%)XChar 20
Item Sales TaxTax Agency *Sales Tax Item Tax Agency (vendor that you collect for)XChar 41
Item Sales TaxDescriptionSales Tax Item DescriptionChar 4095
Other Name ListOther Name *Other Name NameXChar 31
Other Name ListIs ActiveOther Name Name is inactive6Char 1
Other Name ListCompany NameOther Name Company NameChar 41
Other Name ListSalutationOther Name Mr./Ms./ÉChar 15
Other Name ListFirst NameOther Name First NameChar 25
Other Name ListM.I.Other Name M.I.Char 5
Other Name ListLast NameOther Name Last NameChar 25
Other Name ListAddress Line1Other Name Name and Address BlockChar 41
Other Name ListAddress Line2Other Name Name and Address BlockChar 41
Other Name ListAddress Line3Other Name Name and Address BlockChar 41
Other Name ListAddress Line4Other Name Name and Address BlockChar 41
Other Name ListAddress CityOther Name Name and Address BlockChar 31
Other Name ListAddress StateOther Name Name and Address BlockChar 21
Other Name ListAddress PostalCodeOther Name Name and Address BlockChar 13
Other Name ListAddress CountryOther Name Name and Address BlockChar 31
Other Name ListContactOther Name ContactChar 41
Other Name ListPhoneOther Name PhoneChar 21
Other Name ListFaxOther Name FAXChar 21
Other Name ListAlt. PhoneOther Name Alt. Ph.Char 21
Other Name ListAlt. ContactOther Name Alt. ContactChar 21
Other Name ListEmailOther Name EmailChar 1023
Other Name ListAccount NumberOther Name Account No.Char 99
Other Name ListNotesOther Name NotesChar 4095
Price Level ListName *Price Level Price Level NameXChar 31
Price Level ListIs ActivePrice Level Price Level is ActiveChar 1
Price Level ListType *Price Level Price Level TypeXChar 20
Price Level ListFixed PercentagePrice Level Fixed %Numeric
Price Level ListItemPrice Level ItemChar 31
Price Level ListCustom PricePrice Level Custom PriceNumeric
Price Level ListAdjust Relative ToPrice Level than its boxChar 20
Vendor ListVendor Name *Vendor Vendor NameXChar 41
Vendor ListIs ActiveMake Vendor Inactive6Char 1
Vendor ListCompany NameVendor Company NameChar 25
Vendor ListSalutationVendor Mr./Ms./ÉChar 15
Vendor ListFirst NameVendor First NameChar 25
Vendor ListM.I.Vendor Last NameChar 5
Vendor ListLast NameVendor Last NameChar 25
Vendor ListContactVendor ContactChar 41
Vendor ListPhoneVendor PhoneChar 21
Vendor ListFaxVendor FAXChar 21
Vendor ListAlt. PhoneVendor Alt. PhoneChar 21
Vendor ListAlt. ContactVendor Alt. ContactChar 21
Vendor ListEmailVendor EmailChar 1023
Vendor ListPrint on CheckVendor Print on Check AsChar 41
Vendor ListAddress Line1Vendor Name and Address BlockChar 41
Vendor ListAddress Line2Vendor Name and Address BlockChar 41
Vendor ListAddress Line3Vendor Name and Address BlockChar 41
Vendor ListAddress Line4Vendor Name and Address BlockChar 31
Vendor ListAddress CityVendor Name and Address BlockChar 31
Vendor ListAddress StateVendor Name and Address BlockChar 21
Vendor ListAddress PostalCodeVendor Name and Address BlockChar 13
Vendor ListAddress CountryVendor Name and Address BlockChar 31
Vendor ListVendor TypeVendor Additional Info Tab TypeChar 159
Vendor ListTermsVendor Additional Info Tab TermsChar 31
Vendor ListTax IDVendor Additional Info Tab Tax IDChar 14
Vendor ListEligible for 1099Vendor Additional Info Tab Vendor eligible for 1099Char 1
Vendor ListAccount NumberVendor Additional Info Tab Account No.Char 99
Vendor ListCredit LimitVendor Additional Info Tab Credit LimitNumeric
Vendor ListNotesVendor NotesChar 4095
Vendor ListPrefill AccountVendor Account SettingsChar 31
Vendor ListBilling RateVendor Billing Rate LevelNumeric
Vendor ListCurrencyVendor CurrencyChar 64

Data Dictionary Notes:

  1.  If option, let QuickBooks auto assign transaction number is not selected
  2.  For internal TPI processing only
  3.  Used to determine which account that the discount should be applied to
  4.  Ignored not supported by QBSDK
  5.  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.
  6.  The following values can be used: Y or N, T or F, 1 or 0.
  7. Depends on options selected.
  8. Required fields on the item list import and dependent on the item type.
  9. Used in statement date query.
  10. For dollars put in the actual dollar amount or put in the actual percentage with the % sign (5.25 or 5.25%).
  11. Need to enable the command line parameter /INVOICESO1 for this field to be available.
  12. Look to the fields on the Check or Deposit Transaction further on down in this dictionary.
  13. Available in Enterprise 2011 and later versions with an Advanced Inventory Subscription.
  14. 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.
  15. Use the lowest sub account number or the entire account name (eg account:subaccount).
  16. For customers or items include the parent and child separated by a colon (eg parent:child).
  17. Negative Amounts are imported as charges and positive amounts are imported as credits.
  18. This field is used if you have a parent and a child assembly.Sample Import files:

 

Sample Import files:

Sample Import MAP files:

 

This article/post is not supposed to be self-explanatory, this is a link of resources for experienced users

Other Options:

Hector Garcia

Hector Garcia

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published. Required fields are marked *



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022