WebCOBRA.com Community Message Boards

tbbmanager
Posts: 4
Since: 10/13/2009

I have been downloading this information for a few months, but recently i see payments that were once a different payment id then they are now. Is the PaymentID truly a unique identifier or can it change? If this isnt a unique identifier then what is? I need to be able to use this for accounting and invoicing, but I need a unique identifier for each check that comes in.

bptillman
Posts: 22
Since: 12/21/2007

In the AccountingPayment table, each Payment is assigned a PaymentHistoryID and this ID number will never change for the payment. This identifier will identify this payment in other tables in the system (such as AccountingRegister).

Also, what table were you finding this PaymentID field in? Since in AccountingPayment and AccountingRegister it’s called PaymentHistoryID.

What query are you using to pull the info?

~Ben
Travis Dev

tbbmanager
Posts: 4
Since: 10/13/2009

Thanks for the reply. I have been using the access database loader that you provide. In this there is no column called PaymentHistoryID. Can you tell me where i can find this?

Paul

bptillman
Posts: 22
Since: 12/21/2007

I apologize, I thought you were talking about the RelationalAPI and not the WebAPI (Data Loader).

In the RelationalAPI you would find payments in the AccountingPayment table, whereas in the WebAPI Data Loader, the payments will be under the QB_Payment table.

The QB_Payment table has an ID field which will be unique to each payment that has been entered into the system for a QB and will not change.

Just to ensure you are looking at the right field, what field are you referring to, as there is no PaymentID field in the QB_Payment table?


~Ben
Travis Dev

tbbmanager
Posts: 4
Since: 10/13/2009

Ben,

In the access setup i downloaded there is a table called QB_Payment. In that table there is an ID field i called paymentid. I don't have a table in this download called AccountingPayment table. I am using the template from your website.

Paul

bptillman
Posts: 22
Since: 12/21/2007

Paul,

The ID numbers in that QB_Payment table should not change for any actual payments that are made on the QB's account. If it is an ARRA Subsidy, then that ID number could change because if a QB's premium rate were to change, the ARRA Subsidy would have to get recalculated, and in doing that, the entry in that table gets removed, and a new one added in. You can tell if its an ARRA Subsidy by the MemoNote field, which will say something like "ARRA Government Premium Reduction"

Ben
~Travis Dev