You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

Showing articles from Data Dictionary tag

Term Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 31 To import Term be a Sub-Term of another Term, use format Term:Sub-Term DueDays Due in fixed number of days N Numeric 3 Due Date calculated by adding the specified number of d…

Location Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Location be a Sub-Location of another Location, use format Location:Sub-Location. [1]: https://hf-files-oregon.s3.amazonaws.com/hdptransactionpro_kb_attachments/2020…

Bank Transfer Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes TxnDate Date N Date N/A If no date is imported, transaction date will default to the date of the import. PrivateNote Memo N Alpha-numeric 4000 ToAccount Transfer Funds To Y Alpha-numeric 100 Account…

Credit Card Credit Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref No Y Alpha-numeric 21 The Reference Number is the Credit Card Credit Reference Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import …

Purchase - Cash Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref no Y Alpha-numeric 21 The Reference Number is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted by this column prior to importing. BankA…

Refund Receipt Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Refund Receipt no Y Alpha-numeric 21 The Reference Number is the Refund Receipt Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import mus…

Vendor Credit Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref no. Y Alpha-numeric 21 The Reference Number is the assigned Vendor Credit Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must …

Class Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Class as a Sub-Class of another Class, use format Class:Sub-Class [1]: https://hf-files-oregon.s3.amazonaws.com/hdptransactionpro_kb_attachments/2020/10-12/3f38d995-…

Employee Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Title Title N Alpha-numeric 4 Example: Mr, Mrs, Ms, Miss, Dr FirstName First name Y Alpha-numeric 50 MiddleName M.I. N Alpha-numeric 1 QuickBooks Online only stores the Middle Initial. LastName La…

Purchase Order Import Fields for Transaction Pro Online

![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Y Alpha-numeric 21 The Reference Number is the assigned Check Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted by this…

scroll to top icon